Snowflake: Added connection properties for key pair authenticationSnowflake: Auto Download Driver updated to version 3.26.0Export / Backup Insert Statement Generation: If the value of the column is the actual text null, no longer convert to empty nullGeneral: Upgraded JNA (Java Native Interface) to version 5.17Snowflake: Added the following to the command line call generator to prevent certain errors: --add-opens=java.base/java.nio=ALL-UNNAMEDCommandLineCallGenerator: -commandLine syntax missing a space
Added system property to override default open/save dialog behavior: FILE_DIALOG_TYPE Mac: Execute SQL - Output to File: Second time attempting to select an output file the choose file dialog is hidden behind the main RazorSQL windowSQLite: Import Tool Create Table option: REAL/NUMERIC data columns are sometimes getting classified as TEXT.Import Tool: Create Table option: Table names with special characters are not getting wrapped in quotes
PostgreSQL Database Browser: Filter pg_temp and pg_toast schemas by default. Added preferences in the Database Browser tab for changing these settingsTeradata driver updated to version 20Changes to reduce / eliminate system errors for ODBC 64-bit queriesAdded additional connection properties for certain databasesPostgreSQL: Database Browser not always showing materialized views depending on the database versionSQL Anywhere: Generate DDL for indexes generates duplicate data if there are multiple indexes with the same name
Command Line Interface: Added the ability to convert multiple tables in one call. See DB Tools -> Command Line Call GeneratorDatabase Conversion: Added support for converting Interbase to other database typesAWS Athena: Added option to connect with version 3x of the Athena JDBC driverCSS Validator: call to W3C validator not working
Dremio: Database Browser: Added support for filtering schemas as top level namesResults Editing: Editing in new window size increasedResults Editing: Added a new ON(NW) drop-down option to always edit result cells in a new windowResults Editing: Added Edit Cell (New Window) options to context menus
Query Results: Added a filter option to the right-click menu of the column nameFirebird: Connection Wizard: Added support for roleName propertyImport: The last location a file was imported from now takes precedence when determining the initial directory for the file chooserExport: The last location a file was exported to now takes precedence when determining the initial directory for the file chooserSalesforce: Some numeric results are returning in scientific notation
Redshift: Added support for Redshift ServerlessRedshift: Added support for connection properties such as login_url, idp_response_timeout, and plugin_name for single sign onRedshift: Default connection option is now the Redshift 2.x JDBC driverUpgraded SQLite JDBC Driver to version 3.46Added support for Oracle Wallet when using Oracle 23c driversSalesforce Data Cloud: Generated queries may include schema name when they should not
Redshift: Database Browser: External schemas not displayingin database browserMySQL / MariaDB: Bit data not displaying correctlywhen using the MariaDB JDBC driver
Export: Improved XLSX export performanceMac: Native file dialogs now use dark mode if the machine is in dark modeSQL -> Recent Queries (All Connections) and Recent Queries (This Connection) now display queries in order of the most recent query executedConnections -> View SQL History: Changed ordering on query to get history text to prevent truncation of history dataStatus Log: Queries that error during execution are now logged to the status logSSH Tunnel: A warning is displayed if multiple connection profiles use the same local port for an SSH tunnelExecute SQL - Output to File: Statements that do not return a result may cause an error to be thrown
Database Conversion: When converting to MySQL or MariaDB, generated inserts can now be generated as insert, insert ignore, or replaceOracle: Updated JDBC driver to 23.3Connection Profiles Screen: Driver Location field not showing up correctly for some database types
Added support for Access 2019 to Mac/Linux and Windows UCanAccess connectionsUpgraded UCanAccess driver to version 5.0.1Upgraded included HSQLDB database to version 2.5.1Save password button missing from Databricks Add Connection windowAdd Connection Process: Configure connection property window is sometimes too big for the screen
Added support for DatabricksAWS Athena: Added support for the SAML browser plugin connection propertyJDBC Driver Location selection: Automatically search the target folder for other .jar files and present them for selection in multiple jar files locatedRazorSQL may not start correctly if the file system browser panel is adjusted in certain ways
Alter Table Tool: Add Column screen Length / Precision field not appearing correctly for some databasesAuto Column Lookup: Tables with spaces in the name not handled correctly with auto column lookup
SQLite JDBC: Added the ability to pass properties via the JDBC URL using the following syntax: jdbc:sqlite:db?prop1=value1&prop2=value2 . . .SQLite JDBC: Gave the ability to load extensions via the following JDBC URL property: enable_load_extension=truemsyqli PHP bridge PHP file is now compatible with PHP 8If Strip comments preference is selected, queries with comments embedded inside a line are not always parsed correctlyLicense code validation slow on some machinesOracle: ending semi-colon not getting stripped from alter session statements when using semi-colon as the delimiter
Command Line Export: Added the ability to export in text formatDB2 JTOpen Driver: Added the ability to set the naming property to support system or sql namingFirebird: BLOB SUBTYPE TEXT columns are no longer treated as binary dataFirebird Database Conversion: BLOB SUBTYPE TEXT columns now get converted to character data
Query Results Delete Row: Window size is sometimes too largeDatabase Conversion: Added MariaDB as a supported typeDatabase Conversion: Databases of the same type appearing in the Execute on Connection listIf upgrading an old version of RazorSQL that uses the Windows Legacy UI, an error occurs on launchKeep Alive reconnect closed connections: Database browser not always working correctly after reconnectionDB Tools -> Generate DDL: Generating table and view DDL for databases that support catalogs and schemas was not including the schema name in generated DDL if no schema was selected.
Snowflake: Added the ability to change the current database via the toolbarSnowflake: Query errors when using certain Snowflake JDBC drivers and Java 17
Upgraded SFTP / SSH library: More algorithms now supported and more private key file formats now supportedAdded an entry for English (No Commas) to the locale specific number formatting drop-downs in the query results preferences and in the export toolUpdated PostgreSQL JDBC driver to version 42.6SQL Generation: Columns with pound sign in the name get wrapped in quotes automaticallyQuery Results: Changed key mappings for Home, End, Control / Command Home, and Control / Command End to be the following: Home: Go to first cell of current row End: Go to last cell of current row Control / Command Home: Go to first cell of results Control / Command End: Go to last cell of resultsGeneral: Changed the modality of certain dialogs to prevent blockingCommand Line: Convert Table: convert table option throwing an errorQuery Result next tab / previous tab shortcut does not work if going past first tab or past last tab
Firebird: Windows: Added the ability to connect directly to Firebird 4 database files without a running serverFirebird: Windows: Added the ability to download and install the Firebird 4 embedded client when adding a new connectionAdded a copy results to editor option for Show Found on Find windowAdded a copy results to editor option for Find / Replace in Open EditorsFirebird: Updated the new dataabase creation process when creating a new Firebird 4 databaseSQL Editor: When connecting to a connection profile with an Associate File attached to it, no longer opens a new tab if associate file is already open and unsavedExport: If wrap all values in escape characters is set to true, if column names are included they also get wrappedMac: Custom Keyboard Shortcuts: If the Shift key is part of the custom keyboard shortcut, executing the shortcut from the query results section does not fire the shortcut.
Command Line Tool: Added a Wrap All Values in Double Quotes option to the Export commandAdded option to copy result column names (only names) to clipboard to Results menu and query results tab right-click menuAdded a reconnect all option to the Connections menuWindows: If screen is maximized when RazorSQL is closed, RazorSQL will open in a maximized state on the next launch and remember the previous un-maximized sizeMac: If in full screen mode on close, RazorSQL will open using the dimensions of the window prior to entering full screen modeSQL Editor: Oracle: Ending semi-colon not always getting stripped when appropriateMySQL: SQL generation tools are wrapping BIGINT and TINYINT column type values in single quotesSQL Server Copy Table: Database names not getting wrapped in quotes when necessary when copying tables with identity columns
Added support for the following SQL Server / Azure authentication types when using the 11.x SQL Server JDBC Driver: Active Directory Interactive - Multi Factor Authentication, Active Directory Service Principal, Windows Authentication from another domainAdded support for DB2 type 4 driver when connecting to InformixSQL Server / Azure: Added the MS SQL Server 11.2 JDBC DriverInformix: When executing select into statements against Informix when using the DB2 driver, empty error messages are no longer displayedReconnect process: Reconnect process may throw an error in certain situations
RazorSQL Built-in Database Engine: Improved performance for large tables and reduced memory consumptionTeradata: Added support for additional authentication optionsQuery Results: Added a selected rows value on the status barQuery execution time for the original query stays in the status window even after fetching more rows from the result setDatabase Browser: Streamlined drop and truncate table and drop view GUI flowUpdated Teradata driver to version 17Create table from results: Changing column name in the create table section may result in errorSimpleDB: itemName() column not getting generated correctly via the Generate SQL tools
Added support for H2 version 2New H2 Connections: Will auto detect H2 database version and set driver accordinglySQL Query Builder: Added the following join types: Left Outer, Right Outer, and Full OuterSave choose encoding should default to the file encoding preferenceQuery Results: Delete Row: If result set has remaining rows that have not been fetched, delete row throws an error
Added support for CockroachDBAdded support for HSQLDB 2.7Added support for the allowLocalInFile MariaDB connection property and the allowLoadLocalInFile MySQL connection propertyWhen selecting the JDBC option for databases that have installed drivers, pre-populate the driver class and driver location optionsConnection Wizard: Connection properties not getting set correctly when using MariaDB driver with a MySQL database typeSQL Server Drop Index: Table name not always getting populated when dropping an index from a custom schema
Database Browser: Added a View Data Dictionary option to the right-click menu for the following database types: Oracle, MySQL, MariaDB, SQL Server, and PostgreSQLSalesforce: Support all lowercase for SOQL join syntax for column namesSQL Server Edit Table Tool: Identity columns not recognized correctly when database name has certain characters
Query Results -> Find All Rows Containing Value: A new result set is now created and the original result set is preservedSQL Server: When using the Microsoft SQL Server driver, error line numbers are attempted to be displayed in error messagesOracle: Added additional syntax highlighting keywordsWorkaround for error messages not displaying properly on certain external monitorsUpdate for cursor placement issue when using multiple monitors with different scaling factorsUpdated MS SQL Server JDBC driverMac / Linux: MS SQL Server JDBC driver is now the default driver instead of jTDS
Create Table from Query Results: Improved performanceSalesforce: Added support for the format functionVertica: Updated included Vertica driver to version 12Edit Table Tool: SQL Server Identity columns not getting recognized correctly for tables not in the default schemaShift Selection Right menu mnemonic also used by Preferences menu itemCreate Table from Query Results: Queries with aggregate functions throw errors in certain situations
Command Line Call Generator: Windows: Give the ability to generate a .bat file with the command embedded in it Mac / Linux: Give the ability to generate a .sh file with the command embedded in itCommand Line Call Generator: On Windows systems added a Schedule Command button that has options for creating a task in the Windows Task SchedulerCommand Line Call Generator: Multi-line syntax section not appearing in certain situationsWindows: When scaling above 100%, clicking the mouse may put the cursor position left or right of the mouse pointer location on the screen when using certain font sizes
Filter Query Results now opens a new query results tab with the filtered results and original results are no longer overwrittenAdded the ability to search on keyboard shortcuts when assigning shortcuts via the Preferences -> Keyboard Shortcuts tabQuery Results: Added the ability to drag column names to the SQL editorDatabase Browser: When the system navigator is used to populate the database browser, the database type is included in the top level name of the browserCode -> Inserts -> Insert Selector throws error when editor syntax type is set to T/SQLInsert Selector and Describe Table share the same default keyboard shortcutMac: When find dialog is visible, auto complete returns focus to the find dialog instead of the editor
Added support for using the PostgreSQL pgpass file format when authenticating JDBC connectionsAdded support for using a password file (a file containing nothing but the password) when authenticating JDBC connectionsDatabase Conversion: When converting to MySQL / MariaDB, added the ability to choose the generated SQL insert type Added Test Connection call to DB Tools -> Command Line Call GeneratorAdded Connect call to DB Tools -> Command Line Call GeneratorInformix: Added the ability to set the DBDATE connection property for setting the date formatSQL Server: DDL Generation: create index statements no longer generated for default primary key indexes when generating table DDLFirebird to PostgreSQL Table Conversion: Double and Float columns now get converted to PostgreSQL double precision columnsSalesforce: Comments are stripped from queries automaticallySQL Server: Alter table add column not supporting entering max for column lengthEdit Table Tool: If sort query results preference is set to true, causes problems with the edit table toolPostgreSQL: IN_OUT parameters not supported in the call procedure toolCall Procedure Tool: Error messages are not always displaying to the screen
Added the ability to set a client timezone via the Preferences -> Query Results Tab. Note: This setting will not have an effect for drivers that do not use the client machine timezone for date / time displayWindows: Default fixed-width font is Consolas if found Windows: Default non-fixed width font is Segoe UI if found Most unicode characters are now displayable even if the user selects a custom fontMySQL: Create function tool puts IN keyword in front of parametersFile System Browser: Windows / Linux: File names may get cut offFile System Browser: Highlight color foreground of date and size labels not matching with the file name labelMac: If dark mode is selected from the view menu, switching the selection to Auto Detect Dark / Light Mode no longer turns auto detection back onMac: File System Browser: If Auto Detect Dark / Light Mode is on, and Mac is in Light or Gray mode, highlight colors are not correct on the file system browserLookup / auto complete display list / tooltip text: Font size not always based on the current editor font
Mac: Improved performance of using the arrow keys to select next or previous lines or charactersCertain windows were not displaying the correct text color in Dark ModeRazorSQL no longer launching on some Windows 7 machines
When moving from a high resolution monitor to a non-high resolution monitor, RazorSQL is no longer automatically maximized unless the previous width and height are greater than the maximum screen resolution on the new monitorWhen connecting to MS Access via the UCanAccess driver, the Import Tool create new table option now uses INT instead of INTEGER for non-decimal numeric columns that are smaller than BIGINTBetter detection of dropped connections when using the UCanAccess driver for MS AccessWhen connecting with the UCanAccess driver, the objects that need wrapped now use [ and ] instead of double-quotesDark Mode: Matching bracket / paren highlight color difficult to seeMac: View menu is not displaying the currently set look and feel selection correctly in some casesWhen connecting to MS Access via the UCanAccess driver, date fields were being wrapped with single quotes instead of # in the import tool and Generate SQL options
Enhanced the dark mode. Dark mode can be selected via the View -> Dark Mode menu option. Previous dark mode can now be selected via the View -> Legacy Dark Mode menu option.Added a Light Mode look and feel that can be selected via the View -> Light Mode menu optionWindows / Linux: Changed the default user interface look and feel. The previous look and feel can be selected via the View -> Legacy UI Mode menu.Mac: Dark mode / Light mode is now detected automatically by default. This setting can be changed in the View menuSyntax Highlighting Colors: Added the ability to set different syntax highlighting colors for dark vs non-dark user interfacesColors: Added the ability to set different foreground and background colors for dark vs non-dark user interfacesReduced startup time by approximately 10%Auto Completion / Auto Lookup: Added column data types and sizes to the popup windowWindows: Improved user interface scaling on Windows systems that use scaling over 100%Linux: RazorSQL will automatically scale display on some Linux systemsBinary Data Editor: Edit area now expands as window gets biggerMySQL copy table to another database. Added option to select INSERT, REPLACE, or INSERT IGNORE insert syntaxRemoved some icons from the default toolbar layout. The toolbar layout can be customized via the Edit -> Preferences menuPreferences: Added ability to reset colors to their defaultsRemoved DejuVu Sans Mono fonts from inside Windows installationUpdated mariadb driver to version 3.0.4Updated MySQL driver auto download process to use driver version 8.0.28Auto lookup / auto completion window font now set relative to the size of the editor fontAuto lookup / auto completion window location better adjusts to the position of RazorSQL on the screenAuto lookup / auto completion window may display offscreen if RazorSQL is partially off the screenMac: If text size is increased via the view menu, popup menu fonts do not increase
Added the ability to search for connection profiles by nameQuery Builder: Added IN and NOT IN options to the Search toolToolbar: Quick Connect Box: Show more visible items on clickUpgraded Snowflake driver installed via the auto download process to version 3.13.9Firebird backup: $RDBPRIMARY and $RDBFOREIGN indexes no longer get generated in backup files when backing up a database or table. Foreign and primary keys are generated in the create table statements
Added support for SAP HanaIf Display Executing . . . Window During Query Execution setting is un-checked, View Contents and Show Info queries initiated from the database browser no longer show the Executing windowFTP / SFTP Transfer: Deadlock can occur when uploading files in certain situations
Windows 32-bit and 64-bit java runtime upgraded to 11.0.13Linux 64-bit java runtime upgraded to 11.0.13Mac Apple Silicon java runtime upgraded to 11.0.13Firebird: Query Results: If a binary column has character data, RazorSQL will try to show the character data instead of displaying the value in Hex formatRemoved legacy log4j version 1.2 files from Apache poi.jar file used for reading and writing Excel files. RazorSQL no longer has a reference to any version of log4j. NOTE: RazorSQL has never included log4j 2 - the version affected by the Log4Shell security vulnerabilityPrompt to Save changes when reloading a query results tab with unsaved changes not working correctlyLinux: Display issue first time double clicking results cell in query results
Athena: Added the following connection properties for authenticating with Azure AD: AwsCredentialsProviderClass, tenant_id, client_secret, client_idAthena: Added the following connection properties for authenticating with ADFS: AwsCredentialsProviderClass, idp_host, idp_port, preferred_role, ssl_insecureCommand Line Import: Delimited file import is now supported for JDBC drivers that do not support batch operationsAdded support for drivers that have multi release jar files such as SAP HanaUpgraded Athena driver to version 2.0.25
Added a Tools -> Base64 Encoder toolAdded a Tools -> Base64 Decoder toolMS SQL Server: When connecting with the jTDS driver, new connections now set the ssl property to "request" by defaultUpgraded included SQL Server jTDS driver to version 1.3Cassandra: Apache Thrift Driver: Hex values are now displayed for blob types
Command Line Processor: Added a -testConnection command that has two arguments: -testConnection "Connection Profile Name"Removed id as a postgresql reserved wordCommand Line Process: More error information is now displayed on the console in the event of an errorDB2: JTOpen Driver: Added the ability to set connection propertiesVertica: Added the ability to set connection propertiesDatabase Conversion and Query Generation: SQL not always getting generated correctly when the preference wrap generated database objects is set to always
Added a Results -> Re-execute Query Every X Seconds menu item and added the menu item to the right-click menu of the query results tabOracle: Added Enabled DBMS Output and Disable DBMS Output options to the Connections menuUpgraded Salesforce API to version 52Upgraded Firebird Jaybird JDBC driver to version 4.0.3
Added the ability to set connection properties such as query timeout on BigQuery connectionsMySQL: Export and Backup tools now escape backslashes in dataAthena: New Connections: If the endpoint override property is specified, the AWSRegion should not be set
Added the ability to create new Firebird ODS 11.2 (2.5) database files via the Create Database Tool and when adding new Firebird connectionsOracle Database Browser: Enabled calling DBMS_METADATA.GET_DDL on indexes under tablesOracle Database Browser: Enabled calling DBMS_METADATA.GET_DDL on constraints under tablesCassandra timeuuid column should not have single quotes in generated SQL
Filter Navigator: Top Level Objects. Added a drop-down for Include Selected and Exclude Selected to determine whether to include top level objects in the navigator or exclude them from the navigatorAdded a Connections - View Status Log menu option. View Status Log can now be assigned a keyboard shortcutDB2 to MySQL conversion. DB2 graphic columns getting converted with a G prefix in generated insert statements in certain situations
Added support for the Intersystems IRIS databaseAdded ability to set connection properties for InformixAdded sslConnection as an Informix connection propertyQuery Results: Added a preference in the query results tab for beeping when a query that takes longer than a certain number of seconds completesSQL Formatter: Ignore commas in parens does not handle nested parens correctly
PostgreSQL: Added additional ssl related connection propertiesselect into queries now display the number of rows returned in the file in the updated rows section of the status windowIf query results columns are re-arranged, edit table tool is disabledDynamoDB Edit Table Tool from Query Results: Non select * queries get re-written as select * queries when lauching the edit table toolExecuteAll - execution can hang in certain situations
Salesforce: Added support for date functions in the select clauseSalesforce: Added support for case sensitive aliasesUsers can now enter 0 for the connection level maximum rows value. This will not limit the number of rows returned. Note that this may cause performance problems for some databasesInput focus leaves text area sometimes when query returns no results
Database Browser: Case is now ignored when sorting tablesMongoDB SSL Connections: Now defaults to TLS version 1.2Cassandra SSL Connections: Now defaults to TLS version 1.2Database Conversion: If the new table field contains a period, the new table name is no longer wrapped in quotes in the generated SQLMongoDB: Updated SQL reserved word listSybase / SAP IQ: Alter Table Tool does not generate DDL for rename table or rename columnH2 Database Conversion: Auto increment columns cause invalid DEFAULT clause in generated DDL
Added a New Tab (Share This Connection) menu option to the right-click menu of the SQL Editor tabAdded a Results -> Export Query Results menu optionCommand line call generator: Added example output for using the commandFile syntax to execute multiple commands per callAthena: Added the ability to set connection properties on the Simba Athena JDBC driverUpgraded DB2 JDBC driver to version 4.28.11Upgraded PostgreSQL JDBC driver to version 42.2.18Cassandra: If using the fetch all rows toolbar button or keyboard shortcut, a not supported error is displayed after all rows are returnedCassandra: Exporting or Backing up a table with a timestamp column throws an errorCassandra Export Multiple Tables: If no keyspace is selected, an error is thrown on the start of the export
Query Builder: Added the ability to select the same column multiple times in the queryRazorSQL Command Line Process: Added the ability to execute multiple commands per call using the -commandFile "command file path" option. The command file should contain one RazorSQL command line process command per lineSQL Editor Tab right-click menu: Added a New Tab -> Share Connection menu itemH2 Database Object Search: Added the ability to search for triggersHSQLDB Database Object Search: Added the ability to search for triggersH2 Database Browser: Added support for triggersHSQDLB Database Browser: Added support for triggersBigQuery Database Browser: If project id entered in the connection does not come back from the driver meta data call, include it in the browser list anywayUpdated H2 driver to version 1.4.199H2, HSQLDB, Derby, and SQLite Embedded: When closing a connection, some resources from the connection may not have been eligible for garbage collectionSQL Editor: Single quotes inside of multi-line comments were not getting ignored when determining statement delimiter positioning
Snowflake Generate DDL: Columns of type variant should not have a sizeEditor: When pasting data, editor tries to convert data to plain textmacOS: Changed bundled JRE to version 11.0.9.1Bug FixesmacOS: RazorSQL may crash if switching keyboard input
Cassandra: Added a timestampFormat connection property. For new connections this defaults to utc. For connections created previously, this defaults to the old behavior of local_date. utc displays timestamps in utc format. Other options are local and local_date. local displays timestamps using the timezone of the local machine as the format. local_date displays timestamps in date format using the timezone of the local machine.Upgraded MongoDB driver to 3.12.7Added the following system property options. If opening new dialog windows on macOS Big Sur is causing issues, do the following:Help - Set System Property. Put D_OWNER in the Name. Put NULLWINDOWAT in the Value. If still issues, put NULLWINDOW in the Value
HSQLDB to SQL Server Table Conversion: Converting tables in the HSQLDB PUBLIC schema throws an errormacOS version: Upgraded included JRE to 11.0.9macOS version: Possible RazorSQL crash when connecting or disconnecting external displays
Added a File - Open File (Current Tab) menu option (control / command + shift + o) for replacing the current editor contents with contents from a fileFile System Browser: Add a Open File (Current Tab) optionToolbar open file icon: Added the ability to open the file in the current tab
DynamoDB: Added support for inserting / updating data to columns with a list data type. NOTE: Data must be in a valid JSON formatDynamoDB: Added support for the SQL drop table statementSalesforce: Values not displaying for queries with aggregrate functions that use aliases for the column name / aggregrate function name
Export Tool: Export Delimited Filess: Option to set escape character to something other than double quoteExport Tool: Export Delimited Files: Added option to wrap everything in escape characterCassandra 3x DDL Generation: Added support for generating with clustering order by clauses to generated table DDLDatabase Conversion: SQL Server to H2 conversion: newidCassandra 3x DDL Generation: primary key columns may not be in the correct order in primary key clause of create table statementDynamoDB and SimpleDB Import Tool: An error occurs when including column names in the generated import SQLFile Selection: When selecting a file from the file system for certain operations, the user is not prompted for whether to overwrite the file when the user selects an existing file
Added support for Amazon AWS KeyspacesCassandra: Added the ability to set the consistency level on the connection when creating a new Cassandra connection. The consistency can be set by clicking the Configure button next to the Conn. Properties field.Added an Edit -> Move to First Visible Line (control / command + page up) menu option for moving the cursor to the first visible line in the editorAdded an Edit -> Move to Last Visible Line (control / command + page down) menu option for moving the cursor to the last visible line in the editorQuery Results Tab Right-click Menu: Added a Copy Selected Column Names and Results to Clipboard optionResults: Added an Arrange Columns in Alphabetical Order option to the Results menu and Results tab right-click menuResults: Added a Goto Column option to the Results menu and Results tab right-click menuCassandra: Database Browser now reloads automatically when creating a new tableMac: macOS Big Sur: Display changes to better support Big SurSelected text is no longer moved when using tab or shift+tab if control/command key is pressedExecute All: Execute All no longer stops executing if query type can't be determined. Unknown query type is now used in this case
Cassandra blob columns now display values in hexadecimal formatThe tab key is now allowed as part of a custom keyboard shortcutAdded a system property for turning off the update check.Set UPDATE_CHECK to FALSE in Help -> Set System PropertyMac: Changed type of dialog used for certain save operationsto prevent freezing issues on certain machinesProcedure Excecution: Method can't be called twice error displaysin certain circumstancesGenerate SQL Select and Generate SQL In Clause:If columns in results table are rearranged by dragging,SQL generation uses incorrect column names
Import Tool: Added ability to change the delimiter / line break escape character to something other than double quoteImport Tool: Added option to forego delimiter / line break escapingAdded an execute SQL button on generate SQL popup windowDynamoDB Database Browser: Changed Row Count option to the following:Row Count (Estimate): This method gets the row count from the DynamoDB table meta data. This count is updated by DynamoDB every 6 hoursRow Count (Full Scan): This method scans the whole table to get the row count. This method uses more resources to get the countExecute Procedures: Errors that occur in a procedure are displayed even if the procedure was able to return results prior to the error. Previously the error was not reportedLocal Database / HSQLDB: create table tool defaults creating tables as cached (on-disk) tables instead of in-memory. Memory tables can be created by selecting the Memory option in the Table Type drop-downImport Tool: Create New Table from Data: size and scale drop-downs may be uneditable when they should not be
Import Tool: Delimited Files: Added support for the following date formats for Date columns in addition to yyyy-MM-dd: MM/dd/yyyy Import Tool: Added support for generating insert statements that have multiple rows of values per one statement to reduce overhead for MySQL, PostgreSQL, SQL Server, Derby, DB2, and AthenaImport Tool: Blank rows in spreadsheets and delimited files are now skippedImport Tool: XLSX Files: Importing cells with formulas is now supportedImport Tool: Enhanced the process for guessing column types and sizes when creating a table during the import processImport Tool: If first row of file being imported looks to be column names, the start row of the file will be set to row 2 instead of row 1Athena Export Tool: Added support for generating SQL statements in multiple rows per one insert statement syntaxOracle: For new installs, default to showing all schemas instead of non-empty schemas. Empty schemas can be hidden by the Edit -> Preferences -> Database Browser -> Oracle: Hide Empty Schemas in Database Browser checkboxOracle Editor: Added more line number detail to Oracle query errors
Import Tool: Importing from a saved profile no longer pre-populates the delimited file end row. The last row of the file is assumed by defaultSQLite: Added a Change File button for quickly changing the SQLite database file on an existing SQLite connection profileOracle Database Browser: Changed default query to get all schemasDatabase Browser: Folders are duplicated sometimes, especially when using the enter / return key to make the connection from the Connection Wizard windowWindows 4k Monitors: Icons on the database browser are too small
Database Object Search and Database Data Search can now be assigned keyboard shortcutsFirebird: Binary Data Editor: Queries against tables in the SQL editor where the table name does not match the case of the table name as stored in the database do not allow the binary data editor to launchDB2 Call Procedure Tool throws error in certain situationsAthena Database Browser: Table name is not pre-populated when selecting the drop table optionOracle SQL Editor: describe table statements are not bringing up the describe toolEdit Table Tool: Database name / schema name not always getting wrapped in ticks or quotes when special characters are contained in the namemacOs Catalina: Command line interface throwing an error on some machines
Added a Tools -> URL Encoder toolAdded a Tools -> URL Decoder toolDatabase Object Search: View Contents on a column name now scrolls to and selects the first row in that column in the query resultsAmazon Athena: Added the ability to generate DDL for viewsAmazon Athena Database Browser: Object types are now set to Tables and Views. Tables are listed in Tables section and Views are listed in Views sectionAmazon Athena: Generate Table DDL now uses output from the show create table commandAthena Database Browser: View Contents -> Limit Results options not workingMac: Two browser tabs display when clicking connection help off of WizardAdd
Query Results: Added the ability to sum, average, find mininum, and find maximum for selected cells only in addition to all cellsFirebird: Create Database Tool and Add Connection Tool: Added the ability to create Firebird version 4 / ODS version 13 database filesFile System Browser and Project Browser: Added right-click menu option for Open File Share ConnectionFile System Browsser and Project Browser: If there are active database connections, double-clicking a file prompts for whether to open the file and share a current connectionAdded support for YellowbrickBigQuery Database Browser: Only datasets under a particular project are shown in the project's treeBigQuery Database Browser: SQL generation now includes the project id in the generated SQLToolbar: Show File System Browser button is now shown on the toolbar by defaultLinux: Web browser display: If x-www-browser is available, this command is used to open web browsers on Linux systemsSQL Editor: Tab names can be incorrect if switching tabs in the middle of adding a new connection tabSimpleDB: Inserting or Updating records that have SQL keywords with tick marks does not remove tick marks from keywords prior to sending to SimpleDB
PostgreSQL: Added information to error messages about statement line number and approximate editor line number of errorsJavaScript Validator: Leading line feeds in text can cause an issue with the validatorSnowflake to Local Database Conversion: Number data type conversion is now supportedSalesforce: The All Rows syntax in queries is no longer case sensitiveDatabase Object Search: Added a View Contents right-click option for column name search resultsUpgraded Cassandara datastax driver to version 3.8.0Upgraded BigQuery driver to version 1.2.2.1004. This fixes an issue with numeric columns not being able to be queriedMac: Popup windows may not close property in certain situationsFont selector can't display the names of certain fonts
Query Results: Added the following options to the right-click menu of each results column and to the results menu: Average Values in Column, Count Values in Column, Count Distinct Values in Column, Max Value in Column, Min Value in Column, Sum Values in ColumnDynamoDB: Added the abilty to query against nested maps up to 5 layers deep using SQL syntaxDynamoDB: Added the ability to use syntax similar to the AWS command line for table scansCompare Tool: Improved performanceAdded new DynamoDB scan expression and SQL syntax templatesSalesforce: Queries with column lists and NOT like clauses throwing parser errors
Keep Alive: For databases / drivers that only support one open result set at a time, Keep Alive will no longer run if there is an open result setPostgreSQL SQL Editor: Updated PostgreSQL keywordsConnection Wizard: RazorSQL hosted driver downloads now come from a secure AWS S3 serverSQL Server Database Browser: use queries to switch the database are no longer run when executing a View Contents query from the table node *BUG: SimpleDB: Edit Table Tool, Query Builder, and Results SQL Generation:SimpleDB: Edit Table Tool, Query Builder, and Results SQL Generation: Generated SQL should not allow updates to itemName() columns. This is not supported by SimpleDBLinux Version: Edit Table Tool: Right-click menu not displayingGenerate DDL: SQL Server ODBC Driver: Identity information not displaying
Connection Wizard: Connection Profile Tree: Added the following options to the right-click / context menu: Connect, Add Profile, Copy Profile, Delete ProfileEdit Table Tool: Added the following options to the cell right-click / context menu: Add Row, Copy Row, Delete Row, Preview SQL, Execute SQLDerby Embedded databases are shut down on disconnect instead of on RazorSQL exitAuto Commit on / off values not showing up on connection profile screen
Query Results: Editing Cells: If column has a value and then value is removed, set the column value to null instead of emptyGenerate DDL: If default value for a column is set to null, do not wrap null in quotes in DDLAdding SQL Server Connections: MS SQL Server JDBC driver: instance name in host or database name is now supported. RazorSQL will extract the instance name and put it into the instanceName connection propertyExport: ODBC connections: Handle no data found errors without stopping exportQuery Results: Editing Cells: If column is null, and column is clicked on but no value is entered in the column, update statement is still generatedCreate Table Tool: Data type combo box size not correct when adding columns
Copy Table to Another Database: Added an Inserts Only (No DDL) optionAdded preference to turn off displaying column type and length next to column name for the Database BrowserOracle: 12c JDBC driver updated from version 12.1 to version 12.2Database Browser: Generate DDL for a trigger under a table not working
Performance improvements for MySQL database conversionPerformance improvements for loading large XLSX filesMySQL: When using the MySQL Connector/J driver, the useCursorFetch property is set to true by defaultWindows Installer: Added the option to install for all users or current user onlyDynamoDB: Error when launching edit table tool from query results in certain situations
Import Tool: Copies of Excel files are created and opened for reading to prevent out of memory situations from corrupting original Excel fileImport Tool: Improved performance when importing from XLSX filesUpgraded Apache POI Excel library to version 4.1.1Import Tool: Import from XLSX. Error thrown in certain situations when trying to read xlsx filesImport: Errors occurred during import message displaying behind the import dialog on Mac
PostgreSQL: Added support for proceduresAmazon Redshift: Added support for proceduresAmazon Redshift: Added support for connecting via AWS credentials filesPostgreSQL Create User: Added support for the create role optionDatabase Conversion: SQL Server to Oracle and vice-versa. Converter converts default values of GETDATE() to SYSDATE and vice-versaRazorSQL log file size capped at 1 GBAdded a preference for max SQL History database size in megabytesRedshift: Database Object Search returning all non-views in certain situations when tables option is selectedPostgreSQL DB Tools -> View Function Contents. Drop-down showing function name concatenated with the function specific namePostgreSQL DB Tools -> Edit Function / Procedure. Drop-down showing function / procedure names concatenated with the specific name
Added support for CouchbaseNavigator / Database Browser Filter: Allow comma separated values in the contains and not contains fieldsAdded a Connections -> New Tab (New Connection) menu option to the Connections main menu and context menuAdded a Connections -> New Tab (Copy Editor) menu option to the Connections main menu and context menuAdded a Connections -> Same Tab (Switch Connection) menu option to the Connections main menu and context menuAdded New Session (New Connection) and New Session (Copy Editor) options to the new button popupAdded support for Derby 10.15 for supported operating systems. NOTE: Linux 32-bit and legacy Mac OS X versions do not support Derby 10.15Copy Table to Another Database: Added a Generate Alter Table checkbox. If checked foreign keys are attempted to be assigned via alter table statementsLinux 64-bit: Updated Java Runtime Environment to version 11macOS (Catalina and Mojave version): Updated Java Runtime Environment to 11.0.5Windows 32-bit and 64-bit: Updated Java Runtime Environment to 11.0.5Editor Auto Save. If user closes an unsaved file and auto save is on, still prompt if the user wants to save the fileExport Numeric Formatting Changes:If exporting query results If exporting query results (XLS, XLSX): No formatting is used. Locale specific preferences within Excel determine how the cells are formattedIf exporting from table(s): Numeric formatting is based on Number Format locale selected on the export window with the default being no specific formattingSQL -> Recent Queries menu options: Order is now based on order the statement was executed not just the timestamp when the statement was executedDynamoDB: Scan Requests with where clauses: For tables that have more rows than the "Max Results Per Query" value set on the RazorSQL connection profile, RazorSQL will continue to scan the table until either more rows than the Max Results Per Query value are returned, or there are no more rows to scanMySQL and MariaDB connections, autoReconnect property is now set to true by defaultKeep Alive: Default keep alive interval changed from 4 minutes to 2 minutesKeep Alive Preference: Added an option for 0.5 (30 seconds) to the keep alive intervalMongoDB: macOS notarized version: Not allowing connections over TLS / SSL connections that use SNI such as MongoDB Atlas free tier serversMac repeat hold key preference is not on the correct line in preferencesQuery Results: Create Table from Results on Current Connection throws an error in certain situationsSQL History: When running large numbers of statements through the editor such as thousands of inserts, SQL History process can get backed up and cause delays when trying to exit RazorSQLFedora Linux: Very slow startup time / hangs on startup can occurDatabase Conversion Multiple Tables: When converting to MySQL, if the table name is a reserved word, the table name is getting wrapped in double quotes instead of tick marks in the generated SQLDynamoDB: Generate SQL operations from query results: Where clause not always populated
Added the following Preference: Editor: Auto Convert Files to UTF-8 if Unencodable Chars. If the editor contents contain characters that are not encodable by the default encoding, the contents are saved in UTF-8 format if this preference is selectedMac: Adjusted font sizes for higher resolution displaysUI: Better support for displaying unicode data in labels and drop-downsImport Tool: Encoding set automatically on files encoded with UTF-8Athena: Version 1 Athena driver no longer returning table names in database browser
Added support for HSQLDB 2.5Athena: New Connections now default to using the Athena Simba JDBC driver instead of the old version 1 driver. Older connections using the old version 1 driver may no longer show table names in the database browser. The connections should be created again using the new driverGeneral: Fonts: Default fonts changed to better match system defaults and better support display of unicode charactersSQL Editor: Editor font graphics settings changed to better match system defaults
DynamoDB: Added support for querying for is null and is not null on map attributesQuery Results: Added font auto detection that tries to select an appropriate font if the current font can't display characters in the resultsDynamoDB Database Browser: Expanding a table to show columns now lists key columns first and then remaining columns in alphabetical orderDynamoDB: Running a select * query now puts the key columns first and the rest of the columns are ordered alphabeticallyDynamoDB: If specifying a column list in a select query against a table, the columns displayed in the results are in the same order as the column list in the select statementMac Catalina / Mojave version: Changed default max memory settings based on total memory available.MySQL Connection Properties: Added the characterEncoding property as an option when using the MySQL JDBC driverDynamoDB: is null and is not null syntax in select statements only checking for existence of attribute on the table and not whether it has been set to a NULL attribute valueSimpleDB: Drop Domains generating tick marks around domains with special characters
Edit -> Copy History and Edit -> Paste History: Duplicate entries no longer shownMySQL to HSQLDB Database Conversion: Unique indexes are included in conversionPostgreSQL Backup Table: Index DDL does not always include the statement separatorJavascript Validator: macOS Catalina: Javascript Validator not working on macOS CatalinaHSQLDB: Import from XLSX: Date Values include timestamp on generated insertsQuery Results: Add Row: For tables with 0 rows, 2 rows blank rows are appearing in the edit table tool instead of one
Backup Table: Added certain index DDL to the backup single table outputDynamoDB Export Query Results - invalid cursor state in certain situationsMac Catalina: Import Tool: Unable to import XLSX filesMac Catalina: Crash when bringing up Finder window with preview enabled for certain file types
Query Results: Added an Add Row button to the toolbar, and Add Rows options to the Results menu, and right-click menusQuery Results: Added a Delete Row button to the toolbar and Delete Row options to the Results menu and right-click menusAdded an Edit -> Copy History menu that displays recent text that has been copied to the clipboard from the editorAdded an Edit -> Paste History menu that displays recent text that has been pasted to the clipboard from the editorSQL Editor: Auto Completion: After selecting a table name after typing insert into, an option for generating an insert statement with the table column names and value place holders for the selected table displaysSQL Editor: Auto Completion: After selecting a table name after typing update, an option for generating the set column name clause of the update statement is presentedSQL Editor: Auto Completion: After selecting a table name after typing delete or delete from an option for generating the column name clause of the delete statement is presentedSQL Editor: Auto Completion: If table name is selected after the keyword delete, "from" is automatically inserted between the delete and the table nameUpgraded DB2 JTOpen JDBC driver to the latest versionIncreased the max number of files in the recent files menu optionCall Procedure Tool: If the procedure called returns a result set, the call procedure tool was executing the procedure twice in certain situations
Query Results: Selecting the Compare Query Results option from a query results tab populates both queries in the compare tool if there is more than one query results tabPreferences that should not require restarting RazorSQL to take effect are requiring restartAuto Updater not working for Windows machinesHBase connection help information is missing
Added support for the following HBase drivers: Apache Phoenix JDBC Driver, CData HBase JDBC DriverPreferences: Added a preference for changing the query results selection colorPreferences: Added more categories to make preferences easier to find
AWS Athena: Added the ability to specify an AWS properties file for authenticationOracle Execute Function Tool: Added the ability to call functions with OUT parameters that also return a resultOracle Database Browser: Added the ability to call DBMS_METADATA.GET_DDL for Oracle synonyms
MongoDB: Added support for connecting to MongoDB via a connection stringAWS Athena: Added support for passing in a session token in addition to an access key and secret key for authenticationCassandra: Added the ability to select SSL encryption when setting up the connection profile on the add connection profile screenIf auto save preference is set to true, tabs with file associated to them no longer prompt for save on exit. Files are saved automaticallyQuery Scheduler: Column Aliases ignored for MySQL when printing the column names to the outputMongoDB: Connection Profile screen. Changing the value of the Use SSL Encryption checkbox does not get savedOracle Import Tool: apostrophes / single quotes in text not getting escaped in certain situations
Editor: Added Auto Save functionality for automatically saving editor tabs that have associated files every n seconds. Auto save settings can be configured in the Edit -> Preferences -> Backups / Auto Save preferences tabAdded functionality to periodically backup RazorSQL user data such as connection profiles, preferences, favorites, etc. Backup user data settings can be configured in the Edit -> Preferences -> Backup / Auto Save preferences tabExport Utility: Added the ability to set date and timestamp formats when exporting multiple tablesAdded an Edit -> Restore User Data from Backup option to the Edit menu for restoring user data FTPS Client: Connections to servers with expired certificates is now possibleSalesforce: Certain queries against the Order table are not parsing correctly
Oracle Database Browser: Added ability to generate grants for procedures, functions, and packagesMS SQL Server Database Browser: Added ability to generate grantes for procedures and functionsDB2 LUW Database Browser: Added ability to generate grants for tables, views, and proceduresUpdated to jsch SSH library to version 0.1.55DB2: Edit Procedure and Edit Function: Includes information about using create or replace syntax to preserve permissions
Added auto update capabilities to the Windows and Mac versionsAdded version 19.3 of the Oracle JDBC driverUpdated Firebird JDBC driver to the latest versionEditor: First time save of a file, file name is populated based on file typeXML Validator: Schemas with maxOccurs values of more than 5000 throwing validation errors
Import Tool: When importing from XLSX files, if cell format is not set to scientific notation, values get converted from scientific notation to regular numbersQuery Results to the Same Tab: Queries that don't return results no longer take up space in the query results sectionQuery Results to the Same Tab: Better setting of columns widths after the first result setODBC Connections: If query results number formatting preference is changed, numeric columns do not display data
Added Remove Line Breaks, Duplicate Line, and Text to HTML converter options to the Edit - Text menuUpgraded SQLite JDBC driver to version 3.27.2.1Upgraded hive uber jar to the latest versionDynamoDB: Tables with lists that contain number, string, or binary sets, or tables with lists of lists that contain those sets throwing errors in the database browser and when trying to queryMac Notarized Version: SQLite connections using SQLiteJDBC throw an unsatisfiedlinkerrorMac Notarized Version: Connections to SQL Server / SQL Azure not working when using the Microsoft SQL Server driverOracle Create Table Tool: First column size and scale are not editable until switching the data typeDB2 Generate Alter Table DDL / Describe Tool: Generated foreign key references may not be correct if the same constraint name is used across multiple tablesMySQL Alter Table DDL: Generated foreign key table may be empty
Salesforce Database Browser: Added option to view limited results from tablesSimpleDB Database Browser: Added option to view limited results from domainsQuery Results: Execute SQL (Multiple Results Output to Same Tab): Resizing the query results now also resizes each result set inside the query results tabExecute SQL (Multiple Results Output to Same Tab): For scripts or procedures that return multiple result sets, all results are shown in the same tabExecute SQL (Multiple Results Output to Same Tab): No longer requires multiple queries to be executedSybase / SAP IQ: When using the SQL Anywhere driver, if query returns multiple result sets, only the first one is displayedAdd Connection Wizard: MySQL driver connection properties are displaying when the MariaDB driver is selectedToolbar Customizer: Execute Multiple Results to the Same Tab button is not displaying in toolbar customizer in the preferences
PostgreSQL: Added support for json and jsonb typesPostgreSQL Database Conversion: Added support for json and jsonb typesH2 to MS Access Conversion: H2 bigint data types were not converting to the correct type
Table(s) Conversion Process: Added an option for only generating SQL insert statements and not generating create and alter table DDLCommand Line Table Conversion: Added an option for only generating SQL insert statements and not generating create and alter table DDLChangesFile System Browser: Compress Files: symbolic links no longer followed to add files from sym linksOracle: certain unprintable chars filtered from query results displayH2: If selected database file ends in .h2.db, .h2.db is stripped from file name in generated JDBC URLBug FixesSQL Server Alter View: Extra line breaks getting inserted into view definitions in certain cases
Import Tool: Added an option for whether or not to fully qualify table names in generated insert statements for delimited, Excel, and fixed width importsDatabase Browser: Added support for View Contents - Limit Results for SQLite, HSQLDB, and H2Added an Edit -> Backup User Data menu option for backing up all user specific RazorSQL data such as preferences, connections, etc. to a zip fileQuery Results: Added a locale specific number formatting option on the Edit -> Preferences -> Query Results screenAssociate File: If file is already open on an unconnected and unmodified tab, connect that tab instead of creating a new tabLaunch Edit Table Tool from query results: If the query is a select * query and all the results are retrieved, use the already retrieved results for editing instead of re-executing a new queryEdit Table Tool: Max rows to retrieve per table now use the connection profile specific max rows setting instead of the global max rows setting from the preferencesEdit Table Tool: Query to populate uses a limit clause for certain databases to prevent retrieval of extra rows and improve performanceConnection Wizard: If profile is deleted, copied, or renamed, profile tree does not update immediately
Connection Wizard: Added a tree view for existing connection profiles for faster selectionConnection Wizard: Added the ability to categorize connections inside sub-foldersAdded a columnEncryptionSetting configurable property for the MS SQL Server JDBC driverDynamoDB: Added the ability to scan for values inside of Map columns. See https://razorsql.com/docs/dynamodb_sql_support.html for syntax detailsConnection Process: Added the ability to associate a file to a connection profile. Whenever the connection profile is connected, the file will load in the SQL editor.Salesforce: Updated API version to 45Execute procedure tool - if procedure returns a result set, results are now displayed in the query results tab of the main windowOracle: If DBMS Output is turned on, and query / statement does not return results but does return output, output is displayed in the query results sectionAdded ability to call SQL Server / Sybase functions that return a table via the Call Procedure ToolImport Tool: Create Table from Import: If data values are decimal, will pre-populate decimal type with estimated precision and scale set on the create table windowMySQL and MariaDB: Column aliases not always appearing as column names in query results for queries that use aliases for the column namesInitial screen size may be larger than current screen for multiple monitor machines having monitors with different resolutions
Added a Recent Queries (All Connection) option to the SQL menuAdded a Recent Queries (This Connection) option to the SQL menuFirebird: Added a DB Tools -> Create -> Create Database toolFirebird: Added the ability to create a new database when setting up a new Firebird connectionAdded a preference to enable turning off storage of SQL history
Microsoft Access: Added the ability to create a new MS Access database using theCreate New Database option when adding a new MS Access connectionMongoDB: Decimal values bigger than a certain value are no longer returned in scientific notationBug FixesLast record missing from edit table tool if user filters query results and then launchesEdit Table Tool on query resultsRight-click menu not working on editor tabs
Added a Connections -> Favorites menu. Connections can be set as a favorite eitherwhen creating intially or when connecting by checking the Add to Favorites boxMac Editor: For keyboards with HOME and END keys, Shift + Home and Shift + Endnow select to begin or end of lineEdit Table Tool: If multiple monitors, edit table tool is centered on screen of currentmonitorDB2 to Oracle Database Conversion: Precision of decimal columns not always gettingset to correct numberWhen saving an export data profile for a query, line breaks in the query getting lost
Query Results: Edit Query: Control or Command + U now executes the query in the text areaMySQL DDL Generator: Added support for generating on delete cascade and on update cascade clauses to alter table statementsMySQL to HSQLDB Database Conversion: Added support for on delete cascade and on update cascade clauses in alter table statementsEdit -> Preferences -> Fonts -> User Input / Messaging Font option now changes all messaging fonts and user input fontsAdded a prefernence to the Preferences -> Query Results tab called Horizontal Scroll Sensitivity to allow adjusting the horizontal scroll sensitivity of the query resultsMySQL to HSQLDB Database Conversion: Primary key clause is generated in create table DDL for auto increment / identity columnsMain SQL Editor and pop-up editors: Focus can be transferred away from editors using control + tabQuery Results: Edit Query: Control tab can be used to switch from sql area to buttons without using mouseMySQL Database Conversion: bit(1) columns now convert to bit(1) on HSQLDBDatabase Conversion: When converting single tables, alter table statements are now generated in comments at the end of the conversion scriptMySQL: When sql mode is in strict ANSI compliance, table keys not displayingMySQL to HSQLDB Database Conversion: Identity columns not getting generated correctly in DDLEdit Table Tool: If multiple monitors with varying resolutions, Edit Table Tool window may be too wide or too tall for the current screenInterbase: Boolean type missing from create table type drop-down
Describe Tool: Added a view definition tab for viewsPostgreSQL Database Browser: Added user-defined types under the Types nodePostgreSQL Database Browser: Added a Generate Table Grants option for tables and viewsPostgreSQL: Describe Table/View Tool: Added a Grants tabPostgreSQL, MySQL, Oracle, SQL Server: Alter View: Now generates grant statementsOracle Database Browser: Added a Generate Table Grants option for tables and viewsOracle: Describe Table/View Tool: Added a Grants tabMySQL Database Browser: Added a Generate Table Grants option for tables and viewsMySQL: Describe Table/View Tool: Added a Grants tabMS SQL Server Database Browser: Added a Generate Table Grants option for tables and viewsMS SQL Server: Describe Table/View Tool: Added a Grants tabFirebird: DDL Generator: Added support for generating identitiesHSQLDB: DDL Generator: Added support for generating identitiesSQL Server and Sybase: If a procedure is executed that does not return results, but returnsoutput, display the output in the query resultsSalesforce: Added support for updating and inserting boolean values for CheckBoxes, etc.Linux: Added a new shell script launcher to Linux for nonreparenting window managersPostgreSQL: Updated JDBC driverLinux: increased resolution of desktop / application menu iconsExport Tool: Redesigned export tool file selection flowMonetDB Database Browser: Changed to use system queries to get tables, views, and functions insteadof using driver callsChanging the SQL editor font causes other text areas such as the preview pane on the import tool to use the changededitor font instead of the default fontPostgreSQL 10: If a schema is empty, tables may still be displayed in database browserEditor right-click menu not displayingExport Tool: Loading from Saved Profile: Wrap quotes box selection always set to true
Added support for Java 10 and Java 11 to the Java compilerRegistration Screen now provides more information about license eligibility, upgrades, and archived downloadsIngres: If comments in a query cause an error, RazorSQL will strip them
Added the ability to display results from multiple queries in the same tab via the Control / Command + 8 shortcut or the upward facing green arrow on the toolbar.Mac: Added a dark mode look and feel option via the View -> Dark Mode menu optionCassandra: Datastax Driver: Added ability to set connect timeout and read timeout connection propertiesImport Tool: More detailed error information when an error occurs and the one statement at a time option is checkedCassandra: Datastax Driver: Set the connection timeout based on the value in the preferencesQuery Results: If no column name or alias returned for query, column name given generic titleSQL Formatter: Ignore commas in parens not working correctlyDynamoDB count query not working
Import Tool: Added option to convert empty values to a null value instead of empty stringAdded the ability to import SSL certificates via the Help -> Import SSL Certificate menu itemImport Tool: SQL Server: If values for bit columns are true or false, converted to 1 or 0Ingres: Columns in database browser and describe tool now display in order of ordinal positionQuery Results: Reduced horizontal scroll sensitivityQuery Results: When in edit mode, typing the escape key turns off edit modeExport Tool: JSON Format: ampersand, single quote, greater than, and less than signs no longer use XML escape syntaxPostgreSQL Database Browser: For newer versions of PostgreSQL, expanding the Triggers nodeunder Tables in the database browser does not show the triggers for the tablePostgreSQL: insert and delete statements with returning clause throwing an errorCommand Line Export: JSON Format: Null values not supportedFavorites: Opening a file from favorites menu not working
Opening a file that may be certain types of database files prompts for whether to open or connectImport Tool: Fixed width importer: Performance changesSyntax Highlighting: Not able to change colors for the SQL syntax highlighting set
File System Browser and FTP / SFTP Browser: Added ability to sort by file typeAdded print editor contents using web browser and print editor contents with line numbers using web browseroptions to the File -> Print menuAdded print query results using web browser and print query results with line numbers using web browseroptions to the File -> Print menuAdded the ability to open the same file in multiple tabs via theEdit -> Preferences -> Editor / GUI -> Allow Same File in Multiple Tabs preferenceFile -> Open: If a SQLite database is detected, prompts for whether to connect to the databaseor edit the database file in the editorUpgraded DB2 driver to version 3.72. Now supports TLS version 1.2Upgraded SQLite driver to version 3.23Cassandra: Non-select statements with comments prior to the statement throwing errorsSQLite: Certain images / binary data / blobs are not getting displayed in hex value in query results causing potential hanging issuesMongoDB: When authentication is enabled, can't connect with role that doesn't have listDatabases / listCollections.Salesforce: If a parent field referenced in the query has a null value and a child field referenced in the query has the same name as anotherfield in the query, the value is getting set incorrectly
MySQL: Automatic handling of timezone errors for new MySQL driverMac: Editor: Decreased mouse drag sensitivity to allow double and triple clicks to highlight words and lines appropriatelyLocal documentation updates
Export Tool: Added ability for user to input a custom query for exportMySQL Create User Tool: Added support for MySQL 8 create user syntaxImport Tool: XLSX Importer: Changed time zone behavior to not do timezone conversion on date fieldsMac: Connection help links on the add connection profile screen require a double-clickinstead of a single-click
Redshift Database Browser: Added support for showing external tables via Redshift SpectrumSalesforce: Added support for USING clauses in select queriesIncreased the default query timeout from 300 seconds to 900 secondsRazorSQL Plugins: Plugins now only load from the plugin directory under the user's home directory
Added support for the Snowflake databaseImport Tool / Execute SQL Script: Added better support for importing / executing MySQL dump file formatsImport Tool / Execute SQL Script: Allow for embedded semi-colons in text when statement separator is semi-colonSalesforce: Updated Salesforce API calls to version 43.0SQL Editor: Added None as a syntax highlighting type
DynamoDB Export: Added ability to export tables / queries with very largeresult setsAdded preference for switching the caret to a block instead of a lineAdded preference to turn on / off the blinking caretDynamoDB: Increased max error retry value and network timeout settingsSQL Formatter: Not supporting keywords inside double quotes correctlyImport: Column information for table can get duplicated in certain situationsTables with the same name but different case get duplicate columns on describe tablefor certain databases
SQL Server / SQL Azure: Indexes that are not in the default schema are not displaying in the database browserImport Tool: Unable to retrieve column names for tables or schemas not in the default case of the databasekdb+: Edit Table Tool: Not generating insert, update, or delete statements correctly for numeric columnsIf connecting to Athena before DynamoDB, the DynamoDB connection fails. To fix, re-create Athena connectionIf connecting to Redshift using the Redshift driver before connecting to Dynamodb, an error occurs. To fix,re-create Redshift connection.Call Procedure Tool: When wrap objects in generated sql preference is set to always, call procedure tooldoes not work in certain situationsSQL Server Database Conversion: parens are getting generated in default value clause in create table statementfor databases that do not support parens in default value clauses
BigQuery: Added support for Google BigQuery databasesKDB+: Added support for the kdb+ databaseMongoDB: Added support for connecting using SSL encryptionRedshift: Added support for entering AWS IAM credentials when connecting using the Redshift driverRedshift: Added support for new Amazon Redshift driversCassandra: Added a Create Keyspace / Create Schema toolCassandra: Included additional drivers in installFirebird: Added ability to convert Firebird tables to the following database types: Access, DB2, H2, HSQLDB, MySQL, Oracle, PostgreSQL, SQLite, and SQL ServerAdded ability to adjust max rows per query setting to toolbarAdded an auto-backup process for connection profilesUpdated graphics runtime environments for Windows, Mac, and LinuxUpgraded MongoDB drivers to version 3.6Upgraded MariaDB JDBC driver to version 2.2.3Upgraded UCanAccess driver to version 4.0.4Upgraded Redshift jdbc driver that gets installed via the auto-install processDatabase Conversion: Empty but not null binary values are converted to null in database conversion insertsObjects with a colon in the name now get automatically wrapped in generated SQLSalesforce: Max number of rows returned not matching up with max results setting in certain situationsIngres Generate DDL: column names not being returned in index DDLIngres Execute Procedure Tool: If procedure has not nullable OUT params, OUT params not getting populated in call responsePostgreSQL / Redshift: If view definition is not in information_schema, need to query pg_catalog to get view definitionMySQL via Amazon RDS: MariaDB driver. After running a query that produces a syntax error, subsequent queries failMS SQL Server: Importing unicode characters into nvarchar or nchar fields not prepending generated inserts with N' syntaxSalesforce: Max Results Per Query value getting ignoredMS Access Database Conversion: Date conversion from some databases getting length specific in create table statement for date fieldsFirebird: Compound foreign keys not getting generated property in Generate DDL toolDatabase Conversion: Conversion to Oracle timestamps including a size in the create table statementsWindows: Trying to delete a file via the File -> Open dialog causes RazorSQL to hang
Cassandra: Added support for the DataStax driver. Thrift protocol no longer needsto be enabled to connectCassandra Database Navigator: Added support for views for Cassandra version 3 and newerCassandra Database Navigator: Added option for running limit queriesImproved speed of FTP download and upload processesSQL Server and Sybase: When using GO as a statement separator, it is no longer case sensitiveDatabase Navigator: Cassandra: Show all keyspaces not just the ones that have tablesFileMaker: Export, Edit Table Tool, and Generate Insert, Update, and Delete options on query results not generatingdate, time, and timestamp syntax correctly
H2 Connections: H2 driver can now be auto-installedDerby Network Connections: Added option to create the database on connect if it does not yet existQuery results binary data: Convert to hex now happens by default in query results unless convert to hex preference is manually uncheckedDrop Table and Truncate Table tools - Drop/Truncate statements are automatically regenerated when new table is selectedIngres: Ingres procedure columns not recognized as inout or out in certain situations
Firebird: Added support for connecting to Firebird 3 databases without making wirecript configuration changesFirebird: Added support for the binary data editor and image viewer for blob subtype 0 / blob subtype binary columnsAdded support for Derby 10.14Upgraded Firebird JDBC driverIngres: Procedure names not correct in certain situationsRow limit not supported with old versions of MySQL connector/j driver. RazorSQL now does not attempt to set row limits for old MySQL driver versions
Salesforce: Added row count option to Salesforce database navigator right-click / context menuSalesforce: Added support for streaming Salesforce results to allow support for larger exportsDynamoDB and SimpleDB: Added support for AWS STS temporary credential session tokens for authenticationDynamoDB and SimpleDB: Added support for using AWS credentials files for authenticationSAP / Sybase ASE: Added ability to set NEWPASSWORD property on connections to change expired passwordsAWS Secret Key needs to be masked when adding a new connection profileAthena JDBC driver download updated to latest versionMySQL: Updated reserved word list to support reserved words added in MySQL version 8Oracle Packages with overloaded functions and / or procedures not supported correctlyCommand Line Process: Connection via SSH tunnel not supported
Query Scheduler: Added ability to add date time onto generated file nameSybase IQ / SAP IQ: Added support for autoincrement / identity columns to the generate ddl toolDatabase Conversion: Added support for including default values in generated create table statements for MySQL, HSQLDB, Oracle, H2, and SQL ServerSybase IQ / SAP IQ: Generate DDL generates create index statements that have many spaces after the index nameSQL Favorites Menu: Added sub-menus for instances when there are too many favorites defined to fit on the screenAdded several missing keywords to sql syntax filesIf going from a multiple monitor setup to a single monitor setup, certain windows like the Find dialog may display offscreenMac: Dragging and dropping table and column names to the editor does not work after 7.4.5 releaseSQL History: If multiple versions of RazorSQL are open, sql history may get overwrittenGenerateDDL and Database Conversion: If a table has multiple foreign keys referencing the same column on another table, generate ddl was combining the alter table statements for the foreign keys into one statement
Added ability to drag and drop files to editor for openingAdded ability to create and open file sets (File -> Open File Set) menu option for opening a set of fileswith one operationAdded ability to use the show create commands for procedures, functions, and triggers to the database navigatorDatabase Navigator: Enabled Generate DDL option in addition to the Edit option for functions, procedures, triggers,packages, and package bodies for supported databasesMS SQL Server: Generate View DDL / definition from a database other than the currently selected database ora schema other than dbo is limiting the view definition to the first 8000 charactersQuery results column width not wide enough in certain situations when the last row displayed is the widest valueMS Access: Generate DDL should not display a length for GUID columnsSwitching editor tabs while queries are executing can cause the query results to be displayed in the wrong tab
Added Close Tab context menu option to query results tabsSQLite: RazorSQL SQLite Driver changed to legacy status. Recommended to use SQLite JDBC DriverSQL Server procedure editor - if file contains carriage return / line feed line break format,or if editor preference for line breaks is set to carriage return / line feed, the carriage returnsare kept in the procedure text when sent to the databaseFrontBase: Drop table syntax now includes restrict keyword at the endFrontBase: With certain drivers, dropping an object will cause database navigator to not reload correctlySQLite: Generate DDL does not generate View DDL for views with spaces or special characters in the nameSQLite: Alter option for Views in context menu of database browser not generating drop and create view statementsAuto-commit setting not retained when opening a new tab that shares the existing connectionHigh Resolution Monitors: Close icon on tabs right-edge not completely straightMac: High Resolution Monitors: Close icons not working on tabs
Added Redshift to database conversion toolsDirect3d graphics now enabled by default on WindowsMultiple monitors with vertical orientation or 3 plus monitors with mix of vertical and horizontal orientation, windows not always displaying on the correct monitor
Salesforce and DynamoDB Connection Setup: If there is a proxy server configured on the machine,RazorSQL will prompt for automatically connecting through the proxy serverUpgraded to version 1.11.248 of Amazon AWS JDK for DynamoDB connectionsAdded a work-around to enable connecting to Salesforce, SimpleDB, or DynamoDB over httpsthru a non-https proxy serverUI changes to make sure default buttons were set on windows that did not have a defaultbuttonCleaned up local help documentation. Fixed missing / broken links for certaindatabase specific help pages.Downloading a driver file through a proxy server may cause subsequent connection attempts to time outSQL Server: Explain plan does not work when using server side cursors (selectMethod=cursor) with MS SQL JDBC driverSimpleDB and DynamoDB: Configure Proxy button does not show Proxy configuration windowon the add connection window
RazorSQL now uses system proxy server settings for the driver auto-install / auto-download process to preventdownload timeouts for users behind proxy serversMonetDB: changed the way the set current schema call works to support old and new MonetDB drivers MonetDB: changed the way the call to get columns for a table works to support old and new MonetDB driversUncomment Tool: If multiple lines in the editor are selected, will remove comments from individual lines if theystart and end with multi-line comment indicators
Added support for VoltDBAdded support for DruidAdded additional supported features for Apache HiveAdded support for Oracle XMLType to backup, conversion, data editing,and SQL and DDL generationSalesforce: Added support for min, max, sum, and avg aggregate functionsAdded a database selection drop-down to the toolbar for Apache HiveUpgraded MonetDB JDBC driver that gets downloaded via the auto install processHive: Table names no longer returned as part of the column name in query resultsMac: Multiple files can now be selected when manually adding JDBC driver jar files
Added some preliminary support for Apache HiveFile System Browser path field font gets aligned with the File System Browsertree font if the tree font is changedQuote and Double-Quote keys not usuable on US International Keyboard layout
Query Results filter rows and find all rows options no longer include emptyrows in the results tableMonetDB: Unnecessary SQL warnings no longer displayedHigh Resolution Display Changes: Added higher resolution desktop and taskbar icons,additional window sizing adjustments for better displaySalesforce queries with escaped single quotes throw an error when the query endswith a semi-colon
Added a drop schema tool for the following databases: Oracle, PostgreSQL, Redshift, DB2, MS SQL Server, SQL Azure, Derby, HSQLDB, and H2Add/Remove column buttons not working correctly on the Create Table ToolLinux: Systems running Wayland may crash when displaying context menusDynamoDB: When running a local and remote DynamoDB connection, table information cacheis getting shared across the local and remote connectionCommit and Rollback toolbar icons not getting enabled or disabled correctly whenauto-commit status is changed on the toolbar and multiple connections tabs are navigated to and from
Linux: Added a Dark Mode look and feel option to the View -> Change Look and Feel menuAdded a default max rows value for Netezza and GreenplumUpgraded Firebird JDBC driver to Jaybird version 3.0.2Icons are no longer scaled to a larger size for high-resolution screens that do not have a operating system scaling value setWhen connecting to a *.database.windows.net host for SQL Server or Azure, a database name is requiredDatabase Conversion, Copy to Local Database: Alter statements are not generated / executed after insert statements
Windows: Added Dark Mode look and feel theme to the View -> Change Look and Feel menuAdded Pipe as an option for import delimiter in the command line import process and as a selectable character in import and export tool drop-downsFind in Files: For finds occuring over a network drive, added logic to retry file access if network drive access is temporarily unavailable during find operationCopy Table Tool: Added qualify table names optionAlter Table Tool: Added options to add NOT NULL constraints to change column type options for Oracle, MySQL, and MS SQL ServerChanged commit, rollback, and view table iconsDatabase Navigator: Generate DDL: fully qualify table name in references call when generating alter table statementDatabase Navigator: Copy Table: fully qualify table name in references call when generating alter table statementDatabase Navigator: Oracle, MySQL, MS SQL Server, and Sybase ASE: Duplicate indexes displaying for indexes with more than one column in the index definitionDatabase Navigator: Generate DDL: Oracle, MySQL, MS SQL Server, and Sybase ASE: Generate DDL option generates duplicate create index statements for indexes with multiple columns in the index definition
Windows: Added Windows Default Look and Feel option to the View -> Look and Feel menu. This option sets the look and feel to match the Windows default look and feel for the version of Windows being usedLinux: The OpenGL graphics pipeline can be enabled using the View -> Enabled Advanced Graphics menu option*ENH: Linux: The OpenGL graphics pipeline can be enabled using the View -> Enabled Advanced Graphics menu option. This is not recommended for most systems.Windows: Upgraded to latest version of editor font to support additional unicode charactersRange comment option adds a space at the after the beginning comment characters and before the ending comment characters. Using the Uncomment option does not remove the extra spacesWindows: Direct3d graphics pipeline is now disabled by default. To enable, select the View -> Enable Advanced Graphics menu optionFont changes not staying in effect on high-resolution monitorsWhen manual text size scaling was set via the View menu, Menu font was not correct system font on Windows and LinuxMultiple Monitors: FTP Browser window always showing on main monitor
Oracle Package Body function navigator sorts functions and procedures in alphabetical order by the nameWindows: Upgraded to latest version of editor font to support additional unicode charactersPostgreSQL: Generate DDL with Functions option selected is not returning the function definitionsPostgreSQL: Backup Schema option not generating function contentsFont changes not staying in effect on high-resolution monitors
Amazon Athena: Improved performance of query builder loadAdd Connection Screen: Added option to set max rows to display to all database and connection typesAdd Connection Screen: Set a default, overridable max rows to display of 25000 for certain database typesConnection Screen: If max rows to display is not set, default to 25000 for MySQL, MariaDB, Aurora MySQL, and RedshiftThe connection level max rows to display limit is not applied to export, backup, or other file based processesIn the Preferences, If the Query Results -> Max Rows to Retrieve Per Query value is set, this applies to all select queries including exports and backups. If the connection level max rows to display is set, that value takes precedence over the preference level value, but does not apply to exports or backupsUpdated MariaDB driver to latest version to prevent Aurora MySQL connection timeouts in certain situations
DynamoDB: Added support for inserting / updating map data in json formatEnhancements for 4k resolutionMac FTP / SFTP: Delete dialog can be hidden behind another dialog
Added support for SQL Azure Active Directory user / password authenticationAdded support for SQL Azure Active Directory single sign-on for Windows usersAdded support for HSQLDB / HyperSQL version 2.4Reduce amount of logging for Salesforce and DynamoDB to prevent large log filesRazorSQL SQLite driver not recognizing primary keys correctly when columns are defined with tick marks surrounding the name
Added support for filtering schemas in the database navigator for PostgreSQLUpgraded to latest ucanaccess driverDynamoDB: ListTables permission is no longer required for a successful connectionVertica: Escape tables that have underscores for table meta data calls to improve performanceMultiple tabs sharing same connection - database is changed in the dropdown in one needs to also be changed in all the other tabsPostgreSQL: update returning statement does not workFTP Browser: Overwrite prompt hidden behind other dialog on certain systems
Added JSON as an option to the Export toolAdded JSON option to the command line export toolAdded table conversion to the command line toolAdded a delete all rows option to the Edit Table toolAdded tooltip text to the file names in the FTP browserDatabase name is now required for SQL Azure connectionsEdits in new window font on Edit Table Tool now matches the edit table tool / query results fontTrying to enter column selection mode in a file with potentially misaligned tabs gives warning with an option to create a new editor tab with tabs converted to spacesUpgraded MariaDB driver to version 2.0.1Dragging from 4k display to non-4k display causes window to turn black.FTP Browser: File name width not getting calculated correctly leading to long file names getting cut offDescribe tool not working for tables with certain column typesMySQL keep alive query not getting set correctly when creating new connectionsDynamoDB tables with more than one dot in the name throwing sql parsing error from database navigator operationsConnections -> View Print Output menu option not enabled for PostgreSQLPostgreSQL raise / print information displaying duplicate messages in certain situations
Improved memory efficiency of the compare processXLSX files with empty lines at the end causing errors with the import toolXLSX import - varchar column values getting .0 appended when values are numericView menu user-defined keyboard shortcuts getting lost when opening new tabs
Added a View -> Font -> Reset Fonts to Default menu option and adding a reset fonts to defaultoption in the preferencesMac 64-bit: Included executable program within RazorSQL.app so command line programscan be run without any additional installs requiredChanged default editor font size from 11 to 12Xactly ODBC Driver: If query returns no rows, don't show errorXactly: Drop-downs: Configure for schema support only - remove catalog/database optionsXactly: Don't perform operations on stale results or connections to prevent crashingFTP client. Right-clicking on Mac with control plus click deselects the currently highlighted itemMac 64-bit: Next tab and Previous tab shortcuts moving over two tabs instead of oneIf screen resolution is made larger while RazorSQL is running, unable to resize window pastoriginal screen sizeFTP Client: The progress bar on windows is not wide enoughMS SQL Server: Generate DDL is putting sizes on hierarchy_id columnsQuery Results: Copy Results to Clipboard (No Column Names) option is including the columnnames in the copied text
Better support for windows display scalingAdded support for literal and binary strings over the maximum supported length by the database to be inserted via the Import tool - Import from a File of SQL Statements option if RazorSQL was used to generated the SQL file.For newer versions of Cassandra, all defined keyspaces are displayed in the database navigator even if they do not have tablesChanged default icon and text size to auto detectMac 64-bit: Allow to run on less battery intensive graphics card for machines with two cardsCommand Line Call Generator: Execute Option: Not generating command correctly when password override is left blankSome code builders not working (HTML, C, etc.)
Added support for Amazon AthenaAdded support for Amazon Aurora MySQL compatible versionAdded support for Amazon Aurora PostgreSQL compatible versionAdded support for Derby 10.13 to the auto-install driver processAdded several default, configurable connection properties for the MariaDB driverFor databases that RazorSQL has auto-download configured for drivers, added option for re-installing drivers after they were already downloaded / installedAdded a Tools -> International Editor option for more easily typing languages such as Chinese, Japanese, and KoreanChanged default driver for MySQL to the MariaDB driverUpgraded to version 1.5.5 of the MariaDB driverSQL Server jtds driver: default to useNTMLV2 when not otherwise set and using domain securityCassandra: Selecting against smallint and tinyint columns is not workingCreate function syntax for Amazon Redshift is not correctMac: Find/Replace command window not allowing editing when keyboard input is set to certain languages other than English.Mac: Certain keyboard shortcuts executing twice when keyboard input is set to certain languages other than English
Changed threading behavior for SQL Server ODBC connectionsChanged threading behavior for CacheDB ODBC connectionsConfigure connection properties option does not support values with ~ or | characters in themSybase: Executing queries that load temp tables using the Execute SQL Fetch All Rows option throws an error
Changed default MongoDB timeout and keep alive settingsSSH Tunnel and SFTP Client not working when using SSH servers that have Kerberos as the preferred authentication type
Edit Table Tool: Apache Derby: Added support for identity / auto increment columnsAdded preference for whether to warn on disconnectAdded an Extra Large option to the View -> Text Size menuAdded an Extra Large option to the View -> Icon Size menuChanged default memory settings on 64-bit versionsSFTP Client - set max authentication tries to 1 to prevent account lockingSQL Server to PostgreSQL conversions for smallint and tinyint not working correctlyFile System Browser and FTP client icons not displaying correctly when View - Icon Sizemenu option set to larger than normal
Added support for configuring connection properties for the MS SQL Server driver when connecting to SQL AzureConnection Wizard: Changed display of database type listInformix Edit Table Tool: Generated insert/update/delete statements for columns with data type smallint generating incorrect SQLMac: Zip Utility: Extract All option selecting the parent directory instead of the current directory of the zip fileMac: Zip Utility: Zip file not getting closed correctly after zip utility is closedEditor font not changing if user changes text size option in the View menu to Medium or Large
Export Tool: Added the Excel XLSX format as a supported optionImport Tool: Added the Excel XLSX format as a supported optionLinux x86 and x64: Upgraded graphics libraries and runtimeWindow x86 and x64: Upgraded graphics libraries and runtimeMac x64: Upgraded graphics libraries and runtimeH2 database connection wizard auto download process - updated to get latest stable version of H2Database Conversion: Salesforce address column types getting a length of 0 when converting to other database types
Command Line File Execution: Added a halt on error parameterCommand Line File Execution: Added a show output parameterCommand Line File Execution: When executing as batch, if batch fails, try toexecute statements in batch after the failure statementImport Tool: For delimited, SQL, and Excel files, if batch fails, tryto execute statements in batch after the failure statementFor SQL Server Express / local connections, if JDBC connection fails, tryODBC connection via shared memorySQL Server TSQL blocks that start with a use statement not returning resultsfrom selects inside the block
Added a file encoding parameter option to command line delimited file importAdded a halt on error option to the command line delimited file importCommand line import - if there is an error, batch size is greater than 1,and halt on error is false, try to re-execute any statements in the failed batchthat were not executed due to an error in a previous statement Teradata Version 15 driver throws an ExceptionInitializationErrorImport tool: create new table and import from sql file erroring
Added a Find All Rows icon to the query results pane thatdisplays all rows that have any column that contains the textentered by the userAdded clear entries option to recent files menuAdded clear entries option to recent directories menuMinor performance improvements to ExportUpgraded MariaDB driverUpgraded Informix driverIgnore case when sorting the recent files menu itemsIgnore case when sorting the recent files menu itemsIncreased the time allowed between keystrokes before the buffer resetsfor database navigator key ahead searchingOracle prepared statement import does not work when importing a subset of the columnsin the tableSalesforce:if you order on an aggregate, the grouped field in the linked table disappears
Added support for macOS SierraEnhanced single-threaded mode for legacy ODBC driversAdded a preference to force RazorSQL to run in single-threaded mode (for legacy driversthat don't support multi-threading)Added support for more Salesforce count query typesXactly and CacheDB ODBC connections are now set in single-threaded by defaultChanged the way RazorSQL communicates with the Xactly driver for non-select statementsQueries against tables with uniqueidentifier columns throw errors when usingthe SQL Server ODBC driver
Oracle connection wizard: Added the ability to set up LDAP connectionsOracle connection wizard: Added the ability to set up connections based on TNS filesExcel import: Numbers in scientific notation are converted to whole numbersHSQLDB database conversion: Primary key clause no longer included in create table statement for identity columnsIncreased max frame size in Cassandra driver from 16 MB to 64 MBAdded support for Access GUIDUpgraded Salesforce API to version 37Unable to query Salesforce Order tableProxy settings not getting saved when configuring proxy via Add connection profileCassandra: Timeuuid column type not supportedCertain data types not showing up in create table tool for SQL ServerKeep alive executing during exports causes problems in certain databases / drivers
Added support for DB2 table conversion to and from the following databases: MySQL, PostgreSQL, SQL Server, Oracle, MS Access, SQLite, and HSQLDB.Added support for HPE Vertica databasesSalesforce: Added column sizes to Salesforce describe table toolAdded create index statements to the generate DDL option for tablesDynamoDB: Added the option to connect to a DynamoDB local server when creating a connection to DynamoDBAdded ability to edit connection profile names on the connection windowAdded support for Redshift Interleaved sort keys in create table DDLAdded support for Redshift compound sort keys in create table DDLAdded support for Salesforce date functions like LAST_N_DAYSAdded ability to turn on ssl encryption when connecting to Redshift using the Redshift driverChange in how RazorSQL determines what query to execute when the cursor is after the statement separator but on the same line. Now, the previous query is executed. In the past, the next query was executedSalesforce: Copy to local database uses actual Salesforce column sizes for character-based columns instead of default sizesDynamoDB update statement: If a value is set to null in the update statement, the value is removed from the attribute in the DynamoDB item in the DynamoDB tableCassandra: comments are automatically stripped from queriesMac OS X 64-bit: Upgraded graphics libraries to the latest versionDerby: columns not displaying in database browser for mixed case table namesExport command line interface. If specifying "insert" as the output type, the ending chars field is ignoredDynamoDB Database Browser: Trying to view a table that's name is an SQL keyword throws an errorRedshift sort and dist keys not always returned in generated DDL when when $user is present on the search_pathRedshift sort keys not always determined correctly when generating Table DDLRefresh navigator preference value getting erased in certain Execute All situations
PostgreSQL: Added a dropdown on the toolbar so users can switchbetween databases in the same RazorSQL tabMongoDB: ListDatabases role no longer needed to connect
MySQL Table Conversion: Auto increment columns now convert toPostgreSQL serial columnOracle - added ability to get line number for SQL errorson select statementsAdded a preference for whether to try to display Oracle error linenumbers for select statementsAdded ability to sort query results columns via turning on thesort query results columns preference
SQL Azure: Added support for generating / backing up procedures, functions, and triggersSQL Azure: Added support for displaying indexes, constraints, and rolesCopy to Local Database option for Salesforce and DynamoDB tables throwing errors for varchar columnsMac OS X freezing issues
Added support for select count() queries for SalesforceImport Tool: Import create new table option not recognizing column headers in certain situationsImport Tool: Create new table creating table as default case object but insert statementgeneration using exact caseFTP client throwing error when no files / directories contained ininitial directory
Added option for specifying encoding on Firebird connectionsAdded support for additional ciphers for SSH tunnels and SFTP connectionsCassandra date formatting issuesQuerying for boolean field in where clause does not work in DynamoDB.When entering a value for a query parameter and saving the value in the session,the wrap in single quotes option not getting remembered when applying the value to futurequeries
Sybase Generate DDL for views not generating entire view statementSybase Generate DDL tool displays nchar and nvarchar columns as char and varcharIf "Executing . . ." window preference is turned off, focus does notstay in editor after executing query
Added support for displaying DynamoDB map typeAdded support for displaying DynamoDB list typeAdded support for DynamoDB boolean typeMySQL - if get the no database selected error, display a more meaningful messageto the userUpgraded DynamoDB AWS library to the latest versionText and Icon size auto-detection only scales text and images for resolutionslarger than 1080p and now sets icon and text sizes to medium instead of largeStatements starting with a SET command are always updated as an updatedeven if there are select statements in the statement blockPostgreSQL to MS SQL Server database conversion setting decimal / numeric lengthincorrectly in certain cases
Upgraded Mongodb driver to version 3Upgraded Oracle JDBC drivers to the latest 12c versionMongodb version 3 authentication not supportedIf user sets an icon or text size preference, and then sets it back to auto detectauto detect logic is not correctDynamoDB: generated delete and update statements for tables with dots in the namethrow errors
Added Icon Size menu to the view menu to allow usersto change the size of iconsAdded Text Size menu to the view menu to allow usersto change the default text sizeFor high-resolution displays, RazorSQL will automatically scaletext and icons to a larger size depending on the resolution of thedisplayFirebird database browser not showing columns for case sensitivetablesSet identity insert on not working on import tool if tablebeing imported into is different than the current database
Added 2015 Amazon RDS SSL certificates to RazorSQL installationAdded support for more encyrption algorithms for SSH tooland SSL encrypted connectionsChanged default connection timeout to 35 seconds from 120 secondsMySQL connection properties: verifyServerCertificate property spelled incorrectlyConfigure connection properties function on the add connection profile windownot setting connection properties for the MS SQL Server driver
MS SQL Server: On Windows, added the ability to connect using Windows authentication forthe MS SQL Server JDBC driverAdded a Help -> Set System Property menu option to allow users toset system propertiesStart using newer version of MySQL driver for auto downloadversion 5.1.34SQL history now includes the current statement delimiter when storing the queries to historyIf batch call size is 1, command line execute sql file process no longer usesthe execute batch option on the driverQuery Results Sort: PostgreSQL timestamptz values not sortingRight-click menu on FTP Client sites list does not work on LinuxRight-click menu on file system browser path field does not work on LinuxDynamoDB - columns with the name of key should not be required to be quotedwhen written in queries
Add option to the Window menu for closing the current query results tabUpgraded DB2 driver to the latest version (3.69)When exporting multiple delimited files and delimiter is a comma,name all files with a .csv extensionOracle timestamps: Changed default format for Oracle timestamp columns toYYYY-MM-DD HH24:MI:SS.FFFAdded User Input Font option to the font dialog of the preferences window forchanging the combo box fonts for tools in the Search menuQuery referenced table option in query results not working for queries withquoted table namesClosing the font selection window sometimes changes the font without the OK buttonbeing pressedEdit table tool. Edit query with a lot of results, the last row does not displayin the edit table tool
Upgraded SSH library - supports more ciphers and fixed bugswith connecting to SSH over non-standard portsChanged settings for how RazorSQL sets statement fetch size for DB2 ODBC driversSalesforce: includes query syntax throwing a parsing error
Add Reload option to right-click menu on sql editor tab for reloading the current fileFTP Window needs to remember its sizeDynamoDB query bug introduced with previous versionCommand Line Interface does not work with DynamoDB
Added Amazon Redshift supportEnable viewing of raise output in NetezzaAdded support for Apache Derby 10.11Export Tool: If halt on export is unchecked, all export files / data not getting writtenSave to FTP menu option not workingCassandra: Can't always handle concurrent requests.Changing the decimal separator in query results preference ignoredfor SQL Server and Sybase
Export Tool: Added an option to not halt on errors when exporting multiple tablesAdded UCanAccess JDBC driver supportAllow user to change the location of the built in databaseCommand Line Interface all to pass all information to connect to the databaseon the command lineExample:java -Xms64M -Xmx1200M -jar razorsql.jar -export "jdbc:mysql://192.168.1.11:3307/sample?noDatetimeStringSync=true|com.mysql.jdbc.Driver|/Users/user/Library/RazorSQL/mysql/mysql-connector-java-5.0.8-bin.jar|testuser|testpass" "select * from department" csv "/Users/user/Desktop/export.txt" NO NO NO "DEFAULT" "DEFAULT"Upgraded internal database from HSQLDB 1.8 to HSQLDB 2.3Database conversion: When converting from a database with default upper caseto a database with default lower case or vice versa, no longer wrap generatedcolumn names in quotes if they are not in the default casePostgreSQL function names not displaying in the database browserfor certain PostgreSQL databasesDynamoDB: Errors occur if attributes are not present near the beginningof the table, but do have values later in the tableQuery scheduler does not work with SalesforceGenerate SQL from query results with table name witha space not generating correct SQLSalesforce - unable to query Case table due to SQL syntax errorDatabase Conversion: Boolean types getting converted to Oracle failing on insert
Added PostgreSQL materialized view supportAdded support for creating projects and interacting with projectsvia a tab on the file system browserEnhanced materialized view options on the database browser for OracleAdded an option to print line numbers when printing via the web browser optionExpansion of materialized view node in database browser now shows view columnsDynamoDB: All columns not always displaying in select * queriesPostgreSQL Database browser not differentiating among overloaded functions
Salesforce: Added copy to local database option for Salesforce tablesAdded Copy File Path option to File System BrowserImport Tool: Create table from import - table names converted to defaultcase for the databaseLimit size of table references window in query builder to prevent windowfrom going off screenIf there is an at sign in table - wrap in quotesDatabase Conversion: Oracle to H2 and H2 to Oracle conversion files missingImport Tool: Create table from SQL inserts - generated column names sometimes have spaces
DynamoDB: Added ability to force a query or scan operation using the select_query or select_scansyntax instead of just selectselect_query * from employee where id = 1DynamoDB: Added ability to specify an index to use for a query operation using a query hintselect_query /*index_name*/ * from table_name where . . .DynamoDB: Enhanced logic to determine when to execute a query request and when to execute a scanrequest when query or scan is not indicated in select queryDynamoDB: added support for in clauses in SQL statementsDynamoDB: Import Tool: Added a checkbox for skipping columns / attributes in generatedinserts when the value is null / emptyAdded ability to set connection properties when using the MS SQL Server JDBC driver from MicrosoftDynamoDB: support beginning comments in queriesDynamoDB: A non-descriptive error is thrown when referencing an attribute in an SQLstatement that does not exist in the tableIf SQL Server jtds connection fails for SSL reasons, and MS SQL Server driver is installed,try connecting with the SQL Server driverChanged the formatting of the query error text to handle line wrapping betterFaster scroll speed on Explain Plan windowIf result columns are moved and put back in the same place - results editor throws errorpreventing changes due to columns being re-arrangedPostgreSQL: editing views taking a long time in certain situationsQuery Builder: add table button window appearing behind the query builder on MacQuery results edit table button not always appearing for supported queries when the querieshave comments in them
Added H2 database conversion support to and from HSQLDB, MySQL, Oracle,SQLite, MS SQL Server, PostgreSQL, and MS AccessAdded MonetDB supportWhen closing RazorSQL with unsaved files, added a canceloption to the Yes/No save dialogNew session window no longer required mouse to navigateChanged memory settings on Mac OS X 64-bit versionDynamoDB select count(*) queries with where clauses - where clauses getting ignoredPercent of original size field not showing correct valuesin zip file viewer
DynamoDB: Add global secondary indexes and local secondary indexes to the describe toolDynamoDB: Add global secondary indexes and local secondary indexes color indicator to the database browserDynamoDB: Upgraded to latest AWS librariesIncreased launching performance of edit table toolIncreased launching performance of alter table toolExecute Procedure Tool: For Oracle, now supports REF CURSOR as an IN OUTparameter if no value is set for the REF CURSOR as an IN paramDynamoDB - does not support tables with dashes in the nameDynamoDB: tables with global secondary indexes not showing key informationDynamoDB: describe tool not showing information for tables with global secondary indexesDynamoDB: Tables with no rows not showing columns in the database browserDyanmoDB: Unpopulated index columns not showing as columns in database browserRead only version does not allow to change databases
Added close all query results option to right-click menu of query results tabSQLite: Enabled foreign key support by default for new connectionsSSH Client: Added ability to enter separate passphrase for private key fileSSH Tunnel Tool: Added ability to specify a pass phrase for a private key fileAdded a MariaDB driver option to the MySQL connection type optionsShip with MariaDB driversDatabase Conversion: converting boolean true or false values to SQLitenot getting generated with proper syntaxDynamoDB: Tables with dots in the name not supported for certain operationsNext Tab and Previous Tab options not working correctly on MacIf query results column names are rearranged, and column names and resultsare copied to the clipboard, the column names are not in the correct order
Added support for the Cassandra databaseAdded an Edit -> Delete Lines Containing optionSalesforce: Added the ability to connect to a Salesforce sandbox environmentFunction Navigator / Function Selector: Now shows both procedures and functionsin Oracle PL/SQL packagesQuery Scheduler: Added option to set start timein seconds from current timeQuery Scheduler: Added option to set the title of the query schedulerwindowQuery Scheduler: Added option to determine whether to overwriteor append to the output file if it already existsQuery Scheduler: Added option to load query text from a fileQuery Scheduler: Added option to load query text from the SQL favorites listQuery Scheduler: Added file name, interval, executions, and query tostatus field of query scheduler windowContinue should be the default button on the Add Connection Wizard screenAdded additional error notifications for the Export toolIf a maximum rows value is set in the preferences, that valuewill get set on the JDBC driver's statement object for each querySalesforce: Using TableName.ColumnName syntax in queries returns nullvaluesSalesforce: Relationship queries using join tables via dot notation columns(example: Contact.Account.Name) returning nullvalues for columns from the joined tablesSalesforce queries not always returning rows above initial salesforcerequest limitsMac 64-bit: Various focus issues where windows / dialogs are not gettingfocus when appearing
Upgraded SQLite JDBC driver version - added support for wal databasesFor certain multi-monitor display configurations, the max window sizeof RazorSQL is getting set to the primary display maximum resolutionSQL -> Execute SQL Output to File option throwing errorDerby Network databases - Auto download - both the derby.jar and derbyclient.jarfiles need included in the driver location field
Added XML and HTML as format options in the command line export toolAdded Add Query to SQL Favorites option to right-click menu on query results tabErrors connecting to Salesforce not giving detailed error information
Added SQL Create Table statement support for DynamoDBAdded support to generate Create Table statement DDL to DynamoDB database browserand DynamoDB backup and export toolsAdded support for Derby 10.10For SQL Server and Sybase schemas node automatically expands when databaseis expanded in database browserAllow using time formatting options on Oracle dates in the query resultsWith dual monitors, Executing window and Find dialog window sometimes not showingon the correct monitorView Menu custom keyboard shortcuts not always working in certain situationsWhen executing a long running query, and switch to another tab, and the first query finishes, the currently selected tab getsupdated with the query resultsWindows 7 and newer taskbar pinning of RazorSQL not using Windows standard behaviorIn certain situations, the entire view definition is not being returnedwhen generating SQL Server View DDLKeyboard focus actions do not work on the add connection / connect window whenthe window is launched from an already connected tabDynamoDB - SQL statements not handling columns with spaces correctlyDB2 for Mainframes database data search throwing error on SQL generated by the datasearch toolFixed certain crashing scenarios on Mac 64-bit only version for Lion and Mt. Lion
Added support for Amazon DynamoDBAdded ability to change look and feel to different color themesPostgreSQL: Added the ability to view output from functions such asRAISE NOTICE statementsDatabase Navigator: Increased speed of initial load for MS AccessAdded a preference for whether to strip comments from queriesAdded a View -> Reset Display Sizes to Default optionAdded an option to reset all preferences to defaults (Edit - Reset Preferences)Changed behavior of when a new tab is created and when the current tabis loaded when opening filesQuery Builder: if percent symbols not entered by the user for LIKE and NOT LIKEoperators, value is automatically wrapped in percent symbols by RazorSQLIncreased frequency of how often SQL history is written to diskSQL Server: Stop filtering db_owner schema from database browserUpdated PostgreSQL JDBC driver that ships with RazorSQLUpdated Jsch SFTP library to the latest versionMax Rows per Query for SimpleDB and DynamoDB is now a required field whenadding a connection profile
PostgreSQL Backup and Export Table tools - Now generate create sequence statementsprior to the create table statements if a column references a sequencePostgreSQL Backup and Export tools - added option for whether to includeserial columns in generated insert statementsAdded ability to view print output for Sybase SQL Anywhere and Sybase IQAuto-detect certain statement separators for the Import from SQL file andExecute SQL script processesMade database name a required field when creating new PostgreSQL connectionsPostgreSQL Export / Backup Tools - Not generating DDL for serial columns correctlyEdit Table Tool - When text has line breaks, text is getting formatted incorrectlyin popup windowUsing keyboard shortcut with Shift on Mac causes action to occur twice in some instances
MS SQL Server - Added a backup database toolAdded a Execute All Statements - Fetch All Rows optionAdded Informix PAM authentication supportAdded a preference for whether to display the Executing window during query executionAdded an executable to launch RazorSQL in read-only mode on WindowsAdded options for launching RazorSQL with graphics acceleration turned off for Windows and Mac.Remember the Match Case setting on Find / Replace in FilesMySQL Database Browser: Users without show databases permission not getting a categorized list of databasesInstallation missing the SQL Server ASP bridge fileEdit Table tool - when columns with null values are part of the table key for updates or deletes, SQL syntax getting generated as = null instead of is null
Edit table tool cells now adjust margins with font size increasesSybase IQ - default result set holdability changed to forward onlyConvert query results to local database, if a local schema name isentered, results conversion throwing error
