RazorSQL Updates / Change Log

Firebird: Connection Wizard: Added support for roleName property
Import: The last location a file was imported from now takes precedence when determining the initial directory for the file chooser
Export: The last location a file was exported to now takes precedence when determining the initial directory for the file chooser

Bug Fixes

Salesforce: Some numeric results are returning in scientific notation

10.6.0

Enhancements

Redshift: Added support for Redshift Serverless
Redshift: Added support for connection properties such as login_url, idp_response_timeout, and plugin_name for single sign on

Changes

Redshift: Default connection option is now the Redshift 2.x JDBC driver
Upgraded SQLite JDBC Driver to version 3.46
Added support for Oracle Wallet when using Oracle 23c drivers

Bug Fixes

Salesforce Data Cloud: Generated queries may include schema name when they should not

10.5.5

Changes

Redshift: Database Browser: External schemas not displaying in database browser
MySQL / MariaDB: Bit data not displaying correctly when using the MariaDB JDBC driver

10.5.4

Changes

Export: Improved XLSX export performance
Mac: Native file dialogs now use dark mode if the machine is in dark mode
SQL -> Recent Queries (All Connections) and Recent Queries (This Connection) now display queries in order of the most recent query executed
Connections -> View SQL History: Changed ordering on query to get history text to prevent truncation of history data
Status Log: Queries that error during execution are now logged to the status log
SSH Tunnel: A warning is displayed if multiple connection profiles use the same local port for an SSH tunnel

Bug Fixes

Execute SQL - Output to File: Statements that do not return a result may cause an error to be thrown

10.5.3

Changes

Database Conversion: When converting to MySQL or MariaDB, generated inserts can now be generated as insert, insert ignore, or replace
Oracle: Updated JDBC driver to 23.3

Bug Fixes

Connection Profiles Screen: Driver Location field not showing up correctly for some database types

10.5.2

Changes

Added support for Salesforce Data Cloud

10.5.1

Changes

Added support for Access 2019 to Mac/Linux and Windows UCanAccess connections
Upgraded UCanAccess driver to version 5.0.1
Upgraded included HSQLDB database to version 2.5.1

Bug Fixes

Save password button missing from Databricks Add Connection window
Add Connection Process: Configure connection property window is sometimes too big for the screen

10.5.0

Enhancements

Added support for Databricks
AWS Athena: Added support for the SAML browser plugin connection property
JDBC Driver Location selection: Automatically search the target folder for other .jar files and present them for selection in multiple jar files located

Bug Fixes

RazorSQL may not start correctly if the file system browser panel is adjusted in certain ways

10.4.7

Bug Fixes

Alter Table Tool: Add Column screen Length / Precision field not appearing correctly for some databases
Auto Column Lookup: Tables with spaces in the name not handled correctly with auto column lookup

10.4.6

Enhancements

SQLite JDBC: Added the ability to pass properties via the JDBC URL using the following syntax: jdbc:sqlite:db?prop1=value1&prop2=value2 . . .

Changes

SQLite JDBC: Gave the ability to load extensions via the following JDBC URL property: enable_load_extension=true
msyqli PHP bridge PHP file is now compatible with PHP 8

Bug Fixes

If Strip comments preference is selected, queries with comments embedded inside a line are not always parsed correctly
License code validation slow on some machines
Oracle: ending semi-colon not getting stripped from alter session statements when using semi-colon as the delimiter

10.4.5

Enhancements

Command Line Export: Added the ability to export in text format
DB2 JTOpen Driver: Added the ability to set the naming property to support system or sql naming

Changes

Firebird: BLOB SUBTYPE TEXT columns are no longer treated as binary data
Firebird Database Conversion: BLOB SUBTYPE TEXT columns now get converted to character data

10.4.4

Changes

Query Results Delete Row: Window size is sometimes too large
Database Conversion: Added MariaDB as a supported type

Bug Fixes

Database Conversion: Databases of the same type appearing in the Execute on Connection list
If upgrading an old version of RazorSQL that uses the Windows Legacy UI, an error occurs on launch
Keep Alive reconnect closed connections: Database browser not always working correctly after reconnection
DB 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.

10.4.3

Bug Fixes

RazorSQL Legacy User Interface menus stopped working in version 10.4

10.4.2

Enhancements

Snowflake: Added support for switching databases to the toolbar

Bug Fixes

Snowflake: Query errors when using certain Snowflake JDBC drivers with Java version 17

10.4.1

Bug Fixes

AWS Redshift connections with the Redshift JDBC driver failing on certain machines

10.4.0

Changes

Added support for Derby 10.16 for systems supporting JRE 17
Import Tool: Execute as Batch option added back in when executing a file of SQL statements. Was removed erroneously for Postgres, MySQL, Athena, and SQL Server
Updated included JRE to version 17.0.7 for systems that support it

Bug Fixes

Results Generate Update Statements: Columns with null values causing issues with update generation

10.3.3

Enhancements

Upgraded SFTP / SSH library: More algorithms now supported and more private key file formats now supported
Added an entry for English (No Commas) to the locale specific number formatting drop-downs in the query results preferences and in the export tool

Changes

Updated PostgreSQL JDBC driver to version 42.6
SQL Generation: Columns with pound sign in the name get wrapped in quotes automatically
Query 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 results
General: Changed the modality of certain dialogs to prevent blocking

Bug Fixes

Command Line: Convert Table: convert table option throwing an error
Query Result next tab / previous tab shortcut does not work if going past first tab or past last tab

10.3.2

Enhancements

Firebird: Windows: Added the ability to connect directly to Firebird 4 database files without a running server
Firebird: Windows: Added the ability to download and install the Firebird 4 embedded client when adding a new connection
Added a copy results to editor option for Show Found on Find window
Added a copy results to editor option for Find / Replace in Open Editors

Changes

Firebird: Updated the new dataabase creation process when creating a new Firebird 4 database
SQL 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 unsaved
Export: If wrap all values in escape characters is set to true, if column names are included they also get wrapped

10.3.1

Enhancements

Command Line Tool: Added a Wrap All Values in Double Quotes option to the Export command
Added option to copy result column names (only names) to clipboard to Results menu and query results tab right-click menu
Added a reconnect all option to the Connections menu

Changes

Windows: 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 size
Mac: If in full screen mode on close, RazorSQL will open using the dimensions of the window prior to entering full screen mode

Bug Fixes

SQL Editor: Oracle: Ending semi-colon not always getting stripped when appropriate
MySQL: SQL generation tools are wrapping BIGINT and TINYINT column type values in single quotes
SQL Server Copy Table: Database names not getting wrapped in quotes when necessary when copying tables with identity columns

10.3.0

Enhancements

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 domain
Added support for DB2 type 4 driver when connecting to Informix

Changes

SQL Server / Azure: Added the MS SQL Server 11.2 JDBC Driver
Informix: When executing select into statements against Informix when using the DB2 driver, empty error messages are no longer displayed

Bug Fixes

Reconnect process: Reconnect process may throw an error in certain situations

10.2.0

Enhancements

RazorSQL Built-in Database Engine: Improved performance for large tables and reduced memory consumption
Teradata: Added support for additional authentication options
Query Results: Added a selected rows value on the status bar

Changes

Query execution time for the original query stays in the status window even after fetching more rows from the result set
Database Browser: Streamlined drop and truncate table and drop view GUI flow
Updated Teradata driver to version 17

Bug Fixes

Create table from results: Changing column name in the create table section may result in error
SimpleDB: itemName() column not getting generated correctly via the Generate SQL tools

10.1.1

Enhancements

Added support for H2 version 2
New H2 Connections: Will auto detect H2 database version and set driver accordingly
SQL Query Builder: Added the following join types: Left Outer, Right Outer, and Full Outer

Changes

Save choose encoding should default to the file encoding preference

Bug Fixes

Query Results: Delete Row: If result set has remaining rows that have not been fetched, delete row throws an error

10.1.0

Enhancements

Added support for CockroachDB
Added support for HSQLDB 2.7
Added support for the allowLocalInFile MariaDB connection property and the allowLoadLocalInFile MySQL connection property

Changes

When selecting the JDBC option for databases that have installed drivers, pre-populate the driver class and driver location options

Bug Fixes

Connection Wizard: Connection properties not getting set correctly when using MariaDB driver with a MySQL database type
SQL Server Drop Index: Table name not always getting populated when dropping an index from a custom schema

10.0.9

Enhancements

Database Browser: Added a View Data Dictionary option to the right-click menu for the following database types: Oracle, MySQL, MariaDB, SQL Server, and PostgreSQL

Changes

Salesforce: Support all lowercase for SOQL join syntax for column names

Bug Fixes

SQL Server Edit Table Tool: Identity columns not recognized correctly when database name has certain characters

10.0.8

Enhancements

Query Results -> Find All Rows Containing Value: A new result set is now created and the original result set is preserved
SQL Server: When using the Microsoft SQL Server driver, error line numbers are attempted to be displayed in error messages

Changes

Oracle: Added additional syntax highlighting keywords
Workaround for error messages not displaying properly on certain external monitors
Update for cursor placement issue when using multiple monitors with different scaling factors
Updated MS SQL Server JDBC driver
Mac / Linux: MS SQL Server JDBC driver is now the default driver instead of jTDS

10.0.7

Changes

Create Table from Query Results: Improved performance
Salesforce: Added support for the format function
Vertica: Updated included Vertica driver to version 12

Bug Fixes

Edit Table Tool: SQL Server Identity columns not getting recognized correctly for tables not in the default schema
Shift Selection Right menu mnemonic also used by Preferences menu item
Create Table from Query Results: Queries with aggregate functions throw errors in certain situations

10.0.6

Enhancements

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 it
Command Line Call Generator: On Windows systems added a Schedule Command button that has options for creating a task in the Windows Task Scheduler

Bug Fixes

Command Line Call Generator: Multi-line syntax section not appearing in certain situations
Windows: 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

10.0.5

Enhancements

Filter Query Results now opens a new query results tab with the filtered results and original results are no longer overwritten
Added the ability to search on keyboard shortcuts when assigning shortcuts via the Preferences -> Keyboard Shortcuts tab
Query Results: Added the ability to drag column names to the SQL editor

Changes

Database Browser: When the system navigator is used to populate the database browser, the database type is included in the top level name of the browser

Bug Fixes

Code -> Inserts -> Insert Selector throws error when editor syntax type is set to T/SQL
Insert Selector and Describe Table share the same default keyboard shortcut
Mac: When find dialog is visible, auto complete returns focus to the find dialog instead of the editor

10.0.4

Enhancements

Added support for using the PostgreSQL pgpass file format when authenticating JDBC connections
Added support for using a password file (a file containing nothing but the password) when authenticating JDBC connections
Database Conversion: When converting to MySQL / MariaDB, added the ability to choose the generated SQL insert type (INSERT, REPLACE, or INSERT IGNORE)
Added Test Connection call to DB Tools -> Command Line Call Generator
Added Connect call to DB Tools -> Command Line Call Generator
Informix: Added the ability to set the DBDATE connection property for setting the date format

Changes

SQL Server: DDL Generation: create index statements no longer generated for default primary key indexes when generating table DDL
Firebird to PostgreSQL Table Conversion: Double and Float columns now get converted to PostgreSQL double precision columns
Salesforce: Comments are stripped from queries automatically

Bug Fixes

SQL Server: Alter table add column not supporting entering max for column length
Edit Table Tool: If sort query results preference is set to true, causes problems with the edit table tool
PostgreSQL: IN_OUT parameters not supported in the call procedure tool
Call Procedure Tool: Error messages are not always displaying to the screen

10.0.3

Enhancements

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 display

Changes

Windows: Default fixed-width font is Consolas if found (previously Courier New)
Windows: Default non-fixed width font is Segoe UI if found (not all components were using Segoe UI)
Most unicode characters are now displayable even if the user selects a custom font

Bug Fixes

MySQL: Create function tool puts IN keyword in front of parameters
File System Browser: Windows / Linux: File names may get cut off
File System Browser: Highlight color foreground of date and size labels not matching with the file name label
Mac: If dark mode is selected from the view menu, switching the selection to Auto Detect Dark / Light Mode no longer turns auto detection back on
Mac: 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 browser
Lookup / auto complete display list / tooltip text: Font size not always based on the current editor font

10.0.2

Enhancements

Mac: Improved performance of using the arrow keys to select next or previous lines or characters

Bug Fixes

Certain windows were not displaying the correct text color in Dark Mode
RazorSQL no longer launching on some Windows 7 machines

10.0.1

Changes

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 monitor
When 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 BIGINT
Better detection of dropped connections when using the UCanAccess driver for MS Access
When connecting with the UCanAccess driver, the objects that need wrapped now use [ and ] instead of double-quotes

Bug Fixes

Dark Mode: Matching bracket / paren highlight color difficult to see
Mac: View menu is not displaying the currently set look and feel selection correctly in some cases
When 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

10.0

Enhancements

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 option
Windows / 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 menu
Syntax Highlighting Colors: Added the ability to set different syntax highlighting colors for dark vs non-dark user interfaces
Colors: Added the ability to set different foreground and background colors for dark vs non-dark user interfaces
Reduced startup time by approximately 10%
Auto Completion / Auto Lookup: Added column data types and sizes to the popup window
Windows: Improved user interface scaling on Windows systems that use scaling over 100%
Linux: RazorSQL will automatically scale display on some Linux systems
Binary Data Editor: Edit area now expands as window gets bigger
MySQL copy table to another database. Added option to select INSERT, REPLACE, or INSERT IGNORE insert syntax

Changes

Removed some icons from the default toolbar layout. The toolbar layout can be customized via the Edit -> Preferences menu
Preferences: Added ability to reset colors to their defaults
Removed DejuVu Sans Mono fonts from inside Windows installation
Updated mariadb driver to version 3.0.4
Updated MySQL driver auto download process to use driver version 8.0.28
Auto lookup / auto completion window font now set relative to the size of the editor font
Auto lookup / auto completion window location better adjusts to the position of RazorSQL on the screen

Bug Fixes

Auto lookup / auto completion window may display offscreen if RazorSQL is partially off the screen
Mac: If text size is increased via the view menu, popup menu fonts do not increase

9.5.2

Enhancements

Added the ability to search for connection profiles by name
Query Builder: Added IN and NOT IN options to the Search tool

Changes

Toolbar: Quick Connect Box: Show more visible items on click
Upgraded Snowflake driver installed via the auto download process to version 3.13.9
Firebird 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

9.5.1

Enhancements

Added support for SAP Hana

Changes

If 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 window
Mac: Big Sur and Monterey dialog settings set back to old behavior, to go back to original behavior go to Help -> Set System Property, set Name to D_OWNER and value to NULLWINDOWAT

Bug Fixes

FTP / SFTP Transfer: Deadlock can occur when uploading files in certain situations
Mac Apple Silicon version: Auto updater not working

9.5.0

Changes

Windows 32-bit and 64-bit java runtime upgraded to 11.0.13
Linux 64-bit java runtime upgraded to 11.0.13
Mac Apple Silicon java runtime upgraded to 11.0.13
Firebird: Query Results: If a binary column has character data, RazorSQL will try to show the character data instead of displaying the value in Hex format
Removed 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 vulnerability

Bug Fixes

Prompt to Save changes when reloading a query results tab with unsaved changes not working correctly
Linux: Display issue first time double clicking results cell in query results

9.4.10

Changes

Added support for new HSQLDB v 2.6
Upgraded Java runtime for Mac Intel build

Bug Fixes

Resizing the Preferences window causes a display issue

9.4.9

Enhancements

Athena: Added the following connection properties for authenticating with Azure AD: AwsCredentialsProviderClass, tenant_id, client_secret, client_id
Athena: Added the following connection properties for authenticating with ADFS: AwsCredentialsProviderClass, idp_host, idp_port, preferred_role, ssl_insecure

Changes

Command Line Import: Delimited file import is now supported for JDBC drivers that do not support batch operations
Added support for drivers that have multi release jar files such as SAP Hana
Upgraded Athena driver to version 2.0.25

9.4.8

Enhancements

Added a Tools -> Base64 Encoder tool
Added a Tools -> Base64 Decoder tool

Changes

MS SQL Server: When connecting with the jTDS driver, new connections now set the ssl property to "request" by default
Upgraded included SQL Server jTDS driver to version 1.3
Cassandra: Apache Thrift Driver: Hex values are now displayed for blob types

Bug Fixes

Mac: US International keyboards: quote, double quote, and back quote typing behavior is not correct

9.4.7

Changes

Command Line Processor: Added a -testConnection command that has two arguments: -testConnection "Connection Profile Name"
Removed id as a postgresql reserved word
Command Line Process: More error information is now displayed on the console in the event of an error
DB2: JTOpen Driver: Added the ability to set connection properties
Vertica: Added the ability to set connection properties

Bug Fixes

Database Conversion and Query Generation: SQL not always getting generated correctly when the preference wrap generated database objects is set to always

9.4.6

Enhancements

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 tab
Oracle: Added Enabled DBMS Output and Disable DBMS Output options to the Connections menu

Changes

Upgraded Salesforce API to version 52
Upgraded Firebird Jaybird JDBC driver to version 4.0.3

9.4.5

Changes

Added the ability to set connection properties such as query timeout on BigQuery connections
MySQL: Export and Backup tools now escape backslashes in data
Athena: New Connections: If the endpoint override property is specified, the AWSRegion should not be set

9.4.4

Changes

Upgraded SQLite driver to version 3.34

Bug Fixes

SQLite connections do not work on Apple Silicon machines

9.4.3

Enhancements

Added the ability to connect directly to Firebird database files (versions 2.0 - 3.0) without a running Firebird server on Windows machines
Added the ability to create new Firebird ODS 11.2 (2.5) database files via the Create Database Tool and when adding new Firebird connections
Oracle Database Browser: Enabled calling DBMS_METADATA.GET_DDL on indexes under tables
Oracle Database Browser: Enabled calling DBMS_METADATA.GET_DDL on constraints under tables

Bug Fixes

Cassandra timeuuid column should not have single quotes in generated SQL

9.4.2

Enhancements

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 navigator
Added a Connections - View Status Log menu option. View Status Log can now be assigned a keyboard shortcut

Bug Fixes

DB2 to MySQL conversion. DB2 graphic columns getting converted with a G prefix in generated insert statements in certain situations

9.4.1

Enhancements

Added configurable connection property support for Interbase

Bug Fixes

ODBC connections throw errors on certain machines due to a missing library

9.4.0

Enhancements

Added support for the Intersystems IRIS database
Added ability to set connection properties for Informix
Added sslConnection as an Informix connection property
Query Results: Added a preference in the query results tab for beeping when a query that takes longer than a certain number of seconds completes

Bug Fixes

SQL Formatter: Ignore commas in parens does not handle nested parens correctly

9.3.4

Enhancements

PostgreSQL: Added additional ssl related connection properties

Changes

select into queries now display the number of rows returned in the file in the updated rows section of the status window
If query results columns are re-arranged, edit table tool is disabled
DynamoDB Edit Table Tool from Query Results: Non select * queries get re-written as select * queries when lauching the edit table tool

Bug Fixes

ExecuteAll - execution can hang in certain situations

9.3.3

Changes

Salesforce: Added support for date functions in the select clause
Salesforce: Added support for case sensitive aliases
Users 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 databases

Bug Fixes

Input focus leaves text area sometimes when query returns no results

9.3.2

Changes

Database Browser: Case is now ignored when sorting tables
MongoDB SSL Connections: Now defaults to TLS version 1.2
Cassandra SSL Connections: Now defaults to TLS version 1.2
Database Conversion: If the new table field contains a period, the new table name is no longer wrapped in quotes in the generated SQL
MongoDB: Updated SQL reserved word list

Bug Fixes

Sybase / SAP IQ: Alter Table Tool does not generate DDL for rename table or rename column
H2 Database Conversion: Auto increment columns cause invalid DEFAULT clause in generated DDL

9.3.1

Enhancements

Added a New Tab (Share This Connection) menu option to the right-click menu of the SQL Editor tab
Added a Results -> Export Query Results menu option
Command line call generator: Added example output for using the commandFile syntax to execute multiple commands per call

Changes

Athena: Added the ability to set connection properties on the Simba Athena JDBC driver
Upgraded DB2 JDBC driver to version 4.28.11
Upgraded PostgreSQL JDBC driver to version 42.2.18

Bug Fixes

Cassandra: If using the fetch all rows toolbar button or keyboard shortcut, a not supported error is displayed after all rows are returned
Cassandra: Exporting or Backing up a table with a timestamp column throws an error
Cassandra Export Multiple Tables: If no keyspace is selected, an error is thrown on the start of the export

9.3.0

Enhancements

Query Builder: Added the ability to select the same column multiple times in the query
RazorSQL 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 line
SQL Editor Tab right-click menu: Added a New Tab -> Share Connection menu item
H2 Database Object Search: Added the ability to search for triggers
HSQLDB Database Object Search: Added the ability to search for triggers
H2 Database Browser: Added support for triggers
HSQDLB Database Browser: Added support for triggers

Changes

BigQuery 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 anyway
Updated H2 driver to version 1.4.199
H2, HSQLDB, Derby, and SQLite Embedded: When closing a connection, some resources from the connection may not have been eligible for garbage collection

Bug Fixes

SQL Editor: Single quotes inside of multi-line comments were not getting ignored when determining statement delimiter positioning

9.2.7

Bug Fixes

When pasting data into the editor an extra line break may be inserted at the end

9.2.6

Changes

Snowflake Generate DDL: Columns of type variant should not have a size
Editor: When pasting data, editor tries to convert data to plain text
macOS: Changed bundled JRE to version 11.0.9.1

Bug Fixes

macOS: RazorSQL may crash if switching keyboard input

9.2.5

Enhancements

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.

Changes

Added 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
Upgraded MongoDB driver to 3.12.7

9.2.4

Changes

macOS version: Upgraded included JRE to 11.0.9

Bug Fixes

macOS version: Possible RazorSQL crash when connecting or disconnecting external displays
HSQLDB to SQL Server Table Conversion: Converting tables in the HSQLDB PUBLIC schema throws an error

9.2.3

Enhancements

Added a File -> Open File (Current Tab) menu option (control / command + shift + o) for replacing the current editor contents with contents from a file
File System Browser: Add a Open File (Current Tab) option
Toolbar open file icon: Added the ability to open the file in the current tab

9.2.2

Enhancements

DynamoDB: Added support for inserting / updating data to columns with a list data type. NOTE: Data must be in a valid JSON format
DynamoDB: Added support for the SQL drop table statement

Bug Fixes

Salesforce: Values not displaying for queries with aggregrate functions that use aliases for the column name / aggregrate function name

9.2.1

Enhancements

Export Tool: Export Delimited Files: Option to set escape character to something other than double quote
Export Tool: Export Delimited Files: Added option to wrap everything in escape character
Cassandra 3x DDL Generation: Added support for generating with clustering order by clauses to generated table DDL

Changes

Database Conversion: SQL Server to H2 conversion: newid() in default column values is now converted to random_uuid()

Bug Fixes

Cassandra 3x DDL Generation: primary key columns may not be in the correct order in primary key clause of create table statement
DynamoDB and SimpleDB Import Tool: An error occurs when including column names in the generated import SQL
File 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

9.2.0

Enhancements

Added support for Amazon AWS Keyspaces
Cassandra: 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 editor
Added an Edit -> Move to Last Visible Line (control / command + page down) menu option for moving the cursor to the last visible line in the editor
Query Results Tab Right-click Menu: Added a Copy Selected Column Names and Results to Clipboard option
Results: Added an Arrange Columns in Alphabetical Order option to the Results menu and Results tab right-click menu
Results: Added a Goto Column option to the Results menu and Results tab right-click menu

Changes

Cassandra: Database Browser now reloads automatically when creating a new table
Mac: macOS Big Sur: Display changes to better support Big Sur
Selected text is no longer moved when using tab or shift+tab if control/command key is pressed

Bug Fixes

Execute All: Execute All no longer stops executing if query type can't be determined. Unknown query type is now used in this case

9.1.6

Changes

Cassandra blob columns now display values in hexadecimal format
The tab key is now allowed as part of a custom keyboard shortcut
Added a system property for turning off the update check. Set UPDATE_CHECK to FALSE in Help -> Set System Property
Mac: Changed type of dialog used for certain save operations to prevent freezing issues on certain machines

Bug Fixes

Procedure Excecution: Method can't be called twice error displays in certain circumstances
Generate SQL Select and Generate SQL In Clause: If columns in results table are rearranged by dragging, SQL generation uses incorrect column names

9.1.5

Enhancements

Import Tool: Added ability to change the delimiter / line break escape character to something other than double quote
Import Tool: Added option to forego delimiter / line break escaping
Added an execute SQL button on generate SQL popup window
DynamoDB 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 hours
Row Count (Full Scan): This method scans the whole table to get the row count. This method uses more resources to get the count

Changes

Execute 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 reported
Local 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-down

Bug Fixes

Import Tool: Create New Table from Data: size and scale drop-downs may be uneditable when they should not be

9.1.4

Enhancements

Import Tool: Delimited Files: Added support for the following date formats for Date columns in addition to yyyy-MM-dd: MM/dd/yyyy (06/22/2020) M/d/yyyy (6/2/2020) MM/dd/yy (06/02/20) d-MMM-yy (2-Jun-20)
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 Athena

Changes

Import Tool: Blank rows in spreadsheets and delimited files are now skipped
Import Tool: XLSX Files: Importing cells with formulas is now supported
Import Tool: Enhanced the process for guessing column types and sizes when creating a table during the import process
Import 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 1
Athena Export Tool: Added support for generating SQL statements in multiple rows per one insert statement syntax
Oracle: 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 checkbox
Oracle Editor: Added more line number detail to Oracle query errors

9.1.3

Changes

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 default
SQLite: Added a Change File button for quickly changing the SQLite database file on an existing SQLite connection profile
Oracle Database Browser: Changed default query to get all schemas

Bug Fixes

Database Browser: Folders are duplicated sometimes, especially when using the enter / return key to make the connection from the Connection Wizard window
Windows 4k Monitors: Icons on the database browser are too small

9.1.2

Changes

Database Object Search and Database Data Search can now be assigned keyboard shortcuts

Bug Fixes

Firebird: 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 launch
DB2 Call Procedure Tool throws error in certain situations
Athena Database Browser: Table name is not pre-populated when selecting the drop table option
Oracle SQL Editor: describe table statements are not bringing up the describe tool
Edit Table Tool: Database name / schema name not always getting wrapped in ticks or quotes when special characters are contained in the name
macOs Catalina: Command line interface throwing an error on some machines

9.1.1

Enhancements

Added a Tools -> URL Encoder tool
Added a Tools -> URL Decoder tool
Database Object Search: View Contents on a column name now scrolls to and selects the first row in that column in the query results
Amazon Athena: Added the ability to generate DDL for views

Changes

Amazon Athena Database Browser: Object types are now set to Tables and Views. Tables are listed in Tables section and Views are listed in Views section
Amazon Athena: Generate Table DDL now uses output from the show create table command

Bug Fixes

Athena Database Browser: View Contents -> Limit Results options not working
Mac: Two browser tabs display when clicking connection help off of WizardAdd

9.1.0

Enhancements

Query Results: Added the ability to sum, average, find mininum, and find maximum for selected cells only in addition to all cells
Firebird: Create Database Tool and Add Connection Tool: Added the ability to create Firebird version 4 / ODS version 13 database files
File System Browser and Project Browser: Added right-click menu option for Open File Share Connection
File 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 connection
Added support for Yellowbrick

Changes

BigQuery Database Browser: Only datasets under a particular project are shown in the project's tree
BigQuery Database Browser: SQL generation now includes the project id in the generated SQL
Toolbar: Show File System Browser button is now shown on the toolbar by default
Linux: Web browser display: If x-www-browser is available, this command is used to open web browsers on Linux systems

Bug Fixes

SQL Editor: Tab names can be incorrect if switching tabs in the middle of adding a new connection tab
SimpleDB: Inserting or Updating records that have SQL keywords with tick marks does not remove tick marks from keywords prior to sending to SimpleDB

9.0.9

Enhancements

PostgreSQL: Added information to error messages about statement line number and approximate editor line number of errors

Changes

JavaScript Validator: Leading line feeds in text can cause an issue with the validator
Snowflake to Local Database Conversion: Number data type conversion is now supported
Salesforce: The All Rows syntax in queries is no longer case sensitive
Database Object Search: Added a View Contents right-click option for column name search results
Upgraded Cassandara datastax driver to version 3.8.0
Upgraded BigQuery driver to version 1.2.2.1004. This fixes an issue with numeric columns not being able to be queried

Bug Fixes

Mac: Popup windows may not close property in certain situations
Font selector can't display the names of certain fonts

9.0.8

Enhancements

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 Column
DynamoDB: Added the abilty to query against nested maps up to 5 layers deep using SQL syntax Example query: select * from test_nested_map where outermap.innermap.innermap2.height = 60; outermap, innermap, and innermap2 are all maps in this example
DynamoDB: Added the ability to use syntax similar to the AWS command line for table scans. See RazorSQL DynamoDB SQL Support for details
Compare Tool: Improved performance
Added new DynamoDB scan expression and SQL syntax templates

Bug Fixes

Salesforce: Queries with column lists and NOT like clauses throwing parser errors

9.0.7

Changes

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 set
PostgreSQL SQL Editor: Updated PostgreSQL keywords
Connection Wizard: RazorSQL hosted driver downloads now come from a secure AWS S3 server
SQL 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:

Bug Fixes

SimpleDB: Edit Table Tool, Query Builder, and Results SQL Generation: Generated SQL should not allow updates to itemName() columns. This is not supported by SimpleDB
Linux Version: Edit Table Tool: Right-click menu not displaying
Generate DDL: SQL Server ODBC Driver: Identity information not displaying

9.0.6

Enhancements

Connection Wizard: Connection Profile Tree: Added the following options to the right-click / context menu: Connect, Add Profile, Copy Profile, Delete Profile
Edit Table Tool: Added the following options to the cell right-click / context menu: Add Row, Copy Row, Delete Row, Preview SQL, Execute SQL

Changes

Derby Embedded databases are shut down on disconnect instead of on RazorSQL exit

Bug Fixes

Auto Commit on / off values not showing up on connection profile screen

9.0.5

Changes

Query Results: Editing Cells: If column has a value and then value is removed, set the column value to null instead of empty
Generate DDL: If default value for a column is set to null, do not wrap null in quotes in DDL
Adding 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 property
Export: ODBC connections: Handle no data found errors without stopping export

Bug Fixes

Query Results: Editing Cells: If column is null, and column is clicked on but no value is entered in the column, update statement is still generated
Create Table Tool: Data type combo box size not correct when adding columns

9.0.4

Enhancements

Copy Table to Another Database: Added an Inserts Only (No DDL) option
Added preference to turn off displaying column type and length next to column name for the Database Browser

Changes

Oracle: 12c JDBC driver updated from version 12.1 to version 12.2

Bug Fixes

Database Browser: Generate DDL for a trigger under a table not working

9.0.3

Changes

Performance improvements for MySQL database conversion
Performance improvements for loading large XLSX files
MySQL: When using the MySQL Connector/J driver, the useCursorFetch property is set to true by default
Windows Installer: Added the option to install for all users or current user only

Bug Fixes

DynamoDB: Error when launching edit table tool from query results in certain situations

9.0.2

Changes

Import Tool: Copies of Excel files are created and opened for reading to prevent out of memory situations from corrupting original Excel file
Import Tool: Improved performance when importing from XLSX files
Upgraded Apache POI Excel library to version 4.1.1

Bug Fixes

Import Tool: Import from XLSX. Error thrown in certain situations when trying to read xlsx files
Import: Errors occurred during import message displaying behind the import dialog on Mac

9.0.1

Enhancements

PostgreSQL: Added support for procedures
Amazon Redshift: Added support for procedures
Amazon Redshift: Added support for connecting via AWS credentials files

Changes

PostgreSQL Create User: Added support for the create role option
Database Conversion: SQL Server to Oracle and vice-versa. Converter converts default values of GETDATE() to SYSDATE and vice-versa
RazorSQL log file size capped at 1 GB
Added a preference for max SQL History database size in megabytes

Bug Fixes

Redshift: Database Object Search returning all non-views in certain situations when tables option is selected
PostgreSQL DB Tools -> View Function Contents. Drop-down showing function name concatenated with the function specific name
PostgreSQL DB Tools -> Edit Function / Procedure. Drop-down showing function / procedure names concatenated with the specific name

9.0.0

Enhancements

Added support for Couchbase
Navigator / Database Browser Filter: Allow comma separated values in the contains and not contains fields
Added a Connections -> New Tab (New Connection) menu option to the Connections main menu and context menu
Added a Connections -> New Tab (Copy Editor) menu option to the Connections main menu and context menu
Added a Connections -> Same Tab (Switch Connection) menu option to the Connections main menu and context menu
Added New Session (New Connection) and New Session (Copy Editor) options to the new button popup
Added support for Derby 10.15 for supported operating systems. NOTE: Linux 32-bit and legacy Mac OS X versions do not support Derby 10.15
Copy Table to Another Database: Added a Generate Alter Table checkbox. If checked foreign keys are attempted to be assigned via alter table statements

Changes

Linux 64-bit: Updated Java Runtime Environment to version 11
macOS (Catalina and Mojave version): Updated Java Runtime Environment to 11.0.5
Windows 32-bit and 64-bit: Updated Java Runtime Environment to 11.0.5
Editor Auto Save. If user closes an unsaved file and auto save is on, still prompt if the user wants to save the file
Export Numeric Formatting Changes:
If exporting query results (SQL, Delimited File, XML, HTML, Text): Formatting used is based on query results preference values for Locale options (primary) and decimal separator (if locale option not set)
If exporting query results (XLS, XLSX): No formatting is used. Locale specific preferences within Excel determine how the cells are formatted
If exporting from table(s): Numeric formatting is based on Number Format locale selected on the export window with the default being no specific formatting
SQL -> Recent Queries menu options: Order is now based on order the statement was executed not just the timestamp when the statement was executed
DynamoDB: 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 scan
MySQL and MariaDB connections, autoReconnect property is now set to true by default
Keep Alive: Default keep alive interval changed from 4 minutes to 2 minutes
Keep Alive Preference: Added an option for 0.5 (30 seconds) to the keep alive interval

Bug Fixes

MongoDB: macOS notarized version: Not allowing connections over TLS / SSL connections that use SNI such as MongoDB Atlas free tier servers
Mac repeat hold key preference is not on the correct line in preferences
Query Results: Create Table from Results on Current Connection throws an error in certain situations
SQL 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 RazorSQL
Fedora Linux: Very slow startup time / hangs on startup can occur
Database 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 SQL
DynamoDB: Generate SQL operations from query results: Where clause not always populated

8.5.5

Enhancements

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 selected

Changes

Mac: Adjusted font sizes for higher resolution displays
UI: Better support for displaying unicode data in labels and drop-downs
Import Tool: Encoding set automatically on files encoded with UTF-8

Bug Fixes

Athena: Version 1 Athena driver no longer returning table names in database browser

8.5.4

Enhancements

Added support for HSQLDB 2.5

Changes

Athena: 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 driver
General: Fonts: Default fonts changed to better match system defaults and better support display of unicode characters
SQL Editor: Editor font graphics settings changed to better match system defaults

8.5.3

Enhancements

DynamoDB: Added support for querying for is null and is not null on map attributes
Query Results: Added font auto detection that tries to select an appropriate font if the current font can't display characters in the results

Changes

DynamoDB Database Browser: Expanding a table to show columns now lists key columns first and then remaining columns in alphabetical order
DynamoDB: Running a select * query now puts the key columns first and the rest of the columns are ordered alphabetically
DynamoDB: 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 statement
Mac 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 driver

Bug Fixes

DynamoDB: 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 value
SimpleDB: Drop Domains generating tick marks around domains with special characters

8.5.2

Changes

Edit -> Copy History and Edit -> Paste History: Duplicate entries no longer shown
MySQL to HSQLDB Database Conversion: Unique indexes are included in conversion

Bug Fixes

PostgreSQL Backup Table: Index DDL does not always include the statement separator
Javascript Validator: macOS Catalina: Javascript Validator not working on macOS Catalina
HSQLDB: Import from XLSX: Date Values include timestamp on generated inserts
Query Results: Add Row: For tables with 0 rows, 2 rows blank rows are appearing in the edit table tool instead of one

8.5.1

Enhancements

Backup Table: Added certain index DDL to the backup single table output

Bug Fixes

DynamoDB Export Query Results - invalid cursor state in certain situations
Mac Catalina: Import Tool: Unable to import XLSX files
Mac Catalina: Crash when bringing up Finder window with preview enabled for certain file types

8.5.0

Enhancements

Query Results: Added an Add Row button to the toolbar, and Add Rows options to the Results menu, and right-click menus
Query Results: Added a Delete Row button to the toolbar and Delete Row options to the Results menu and right-click menus
Added an Edit -> Copy History menu that displays recent text that has been copied to the clipboard from the editor
Added an Edit -> Paste History menu that displays recent text that has been pasted to the clipboard from the editor
SQL 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 displays
SQL 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 presented
SQL 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 presented

Changes

SQL Editor: Auto Completion: If table name is selected after the keyword delete, "from" is automatically inserted between the delete and the table name
Upgraded DB2 JTOpen JDBC driver to the latest version
Increased the max number of files in the recent files menu option

Bug Fixes

Call Procedure Tool: If the procedure called returns a result set, the call procedure tool was executing the procedure twice in certain situations

8.4.7

Changes

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 tab

Bug Fixes

Preferences that should not require restarting RazorSQL to take effect are requiring restart
Auto Updater not working for Windows machines
HBase connection help information is missing

8.4.6

Enhancements

Added support for the following HBase drivers: Apache Phoenix JDBC Driver, CData HBase JDBC Driver
Preferences: Added a preference for changing the query results selection color

Changes

Preferences: Added more categories to make preferences easier to find

8.4.5

Enhancements

AWS Athena: Added the ability to specify an AWS properties file for authentication
Oracle Execute Function Tool: Added the ability to call functions with OUT parameters that also return a result
Oracle Database Browser: Added the ability to call DBMS_METADATA.GET_DDL for Oracle synonyms

8.4.4

Enhancements

MongoDB: Added support for connecting to MongoDB via a connection string
AWS Athena: Added support for passing in a session token in addition to an access key and secret key for authentication
Cassandra: Added the ability to select SSL encryption when setting up the connection profile on the add connection profile screen

Changes

If auto save preference is set to true, tabs with file associated to them no longer prompt for save on exit. Files are saved automatically

Bug Fixes

Query Scheduler: Column Aliases ignored for MySQL when printing the column names to the output
MongoDB: Connection Profile screen. Changing the value of the Use SSL Encryption checkbox does not get saved
Oracle Import Tool: apostrophes / single quotes in text not getting escaped in certain situations

8.4.3

Enhancements

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 tab
Added 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 tab
Export Utility: Added the ability to set date and timestamp formats when exporting multiple tables
Added an Edit -> Restore User Data from Backup option to the Edit menu for restoring user data (preferences, connection profiles, built-in database, etc.) from a previously created backup file (Edit -> Backup User Data)

Changes

FTPS Client: Connections to servers with expired certificates is now possible

Bug Fixes

Salesforce: Certain queries against the Order table are not parsing correctly

8.4.2

Enhancements

FTP Client: Added support for explicit FTPS connections
Oracle: Call Function Tool: Added support for calling functions that return ref cursors

8.4.1

Enhancements

Oracle Database Browser: Added ability to generate grants for procedures, functions, and packages
MS SQL Server Database Browser: Added ability to generate grants for procedures and functions
DB2 LUW Database Browser: Added ability to generate grants for tables, views, and procedures

Changes

Updated to jsch SSH library to version 0.1.55
DB2: Edit Procedure and Edit Function: Includes information about using create or replace syntax to preserve permissions

8.4.0

Enhancements

Added auto update capabilities to the Windows and Mac versions

Changes

Added version 19.3 of the Oracle JDBC driver
Updated Firebird JDBC driver to the latest version
Editor: First time save of a file, file name is populated based on file type

Bug Fixes

XML Validator: Schemas with maxOccurs values of more than 5000 throwing validation errors

8.3.6

Changes

Import Tool: When importing from XLSX files, if cell format is not set to scientific notation, values get converted from scientific notation to regular numbers
Query Results to the Same Tab: Queries that don't return results no longer take up space in the query results section
Query Results to the Same Tab: Better setting of columns widths after the first result set

Bug Fixes

ODBC Connections: If query results number formatting preference is changed, numeric columns do not display data

8.3.5

Enhancements

Added Remove Line Breaks, Duplicate Line, and Text to HTML converter options to the Edit - Text menu

Changes

Upgraded SQLite JDBC driver to version 3.27.2.1
Upgraded hive uber jar to the latest version

Bug Fixes

DynamoDB: 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 query
Mac Notarized Version: SQLite connections using SQLiteJDBC throw an unsatisfiedlinkerror
Mac Notarized Version: Connections to SQL Server / SQL Azure not working when using the Microsoft SQL Server driver
Oracle Create Table Tool: First column size and scale are not editable until switching the data type
DB2 Generate Alter Table DDL / Describe Tool: Generated foreign key references may not be correct if the same constraint name is used across multiple tables
MySQL Alter Table DDL: Generated foreign key table may be empty

8.3.4

Enhancements

Salesforce Database Browser: Added option to view limited results from tables
SimpleDB Database Browser: Added option to view limited results from domains
Query Results: Execute SQL (Multiple Results Output to Same Tab): Resizing the query results now also resizes each result set inside the query results tab
Execute SQL (Multiple Results Output to Same Tab): For scripts or procedures that return multiple result sets, all results are shown in the same tab

Changes

Execute SQL (Multiple Results Output to Same Tab): No longer requires multiple queries to be executed

Bug Fixes

Sybase / SAP IQ: When using the SQL Anywhere driver, if query returns multiple result sets, only the first one is displayed
Add Connection Wizard: MySQL driver connection properties are displaying when the MariaDB driver is selected
Toolbar Customizer: Execute Multiple Results to the Same Tab button is not displaying in toolbar customizer in the preferences

8.3.3

Enhancements

PostgreSQL: Added support for json and jsonb types
PostgreSQL Database Conversion: Added support for json and jsonb types

Bug Fixes

H2 to MS Access Conversion: H2 bigint data types were not converting to the correct type

8.3.2

Enhancements

Table(s) Conversion Process: Added an option for only generating SQL insert statements and not generating create and alter table DDL
Command Line Table Conversion: Added an option for only generating SQL insert statements and not generating create and alter table DDL

Changes

File System Browser: Compress Files: symbolic links no longer followed to add files from sym links
Oracle: certain unprintable chars filtered from query results display
H2: If selected database file ends in .h2.db, .h2.db is stripped from file name in generated JDBC URL

Bug Fixes

SQL Server Alter View: Extra line breaks getting inserted into view definitions in certain cases

8.3.1

Enhancements

Import Tool: Added an option for whether or not to fully qualify table names in generated insert statements for delimited, Excel, and fixed width imports
Database Browser: Added support for View Contents - Limit Results for SQLite, HSQLDB, and H2
Added an Edit -> Backup User Data menu option for backing up all user specific RazorSQL data such as preferences, connections, etc. to a zip file
Query Results: Added a locale specific number formatting option on the Edit -> Preferences -> Query Results screen

Changes

Associate File: If file is already open on an unconnected and unmodified tab, connect that tab instead of creating a new tab
Launch 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 query
Edit 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 preferences
Edit Table Tool: Query to populate uses a limit clause for certain databases to prevent retrieval of extra rows and improve performance

Bug Fixes

Connection Wizard: If profile is deleted, copied, or renamed, profile tree does not update immediately

8.3.0

Enhancements

Connection Wizard: Added a tree view for existing connection profiles for faster selection
Connection Wizard: Added the ability to categorize connections inside sub-folders
Added a columnEncryptionSetting configurable property for the MS SQL Server JDBC driver
DynamoDB: Added the ability to scan for values inside of Map columns. See https://razorsql.com/docs/dynamodb_sql_support.html for syntax details
Connection 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.

Changes

Salesforce: Updated API version to 45
Execute procedure tool - if procedure returns a result set, results are now displayed in the query results tab of the main window
Oracle: If DBMS Output is turned on, and query / statement does not return results but does return output, output is displayed in the query results section
Added ability to call SQL Server / Sybase functions that return a table via the Call Procedure Tool
Import 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 window

Bug Fixes

MySQL and MariaDB: Column aliases not always appearing as column names in query results for queries that use aliases for the column names
Initial screen size may be larger than current screen for multiple monitor machines having monitors with different resolutions

8.2.5

Enhancements

DynamoDB: Added support for parallel scans with a comment hint syntax. For example, select /*parallel:5:100*/ * from table where id < 10000 5 is the number of parallel threads 100 is the max results returned per thread
Salesforce: Describe Table Tool: Added a Reference Table column to the Columns tab
Salesforce: Query Builder: Added the ability to add more than one table to select queries
Query Results: Create Table from Results: Added option to create table from results on another connection of the same database type

Changes

Edit Table Tool: Changed so that the table containing the table data always expands to the full size of the window and has a smaller minimum size
Auto Reconnect: If database is disconnected, and auto reconnection process works, set the selected database on the connection to the database at the time the connectio was lost instead of the database set on the connection profile
Salesforce: Added support for toLabel function in queries
PostgreSQL: Changed display of int2, int4, and int8 columns to smallint, integer, and bigint
The following files are now handled as zip files when opening: .odb, .odf, and .odt

8.2.4

Enhancements

Added a Recent Queries (All Connection) option to the SQL menu
Added a Recent Queries (This Connection) option to the SQL menu
Firebird: Added a DB Tools -> Create -> Create Database tool
Firebird: Added the ability to create a new database when setting up a new Firebird connection

Changes

Added a preference to enable turning off storage of SQL history

8.2.3

Enhancements

Microsoft Access: Added the ability to create a new MS Access database using the Create New Database option when adding a new MS Access connection

Changes

MongoDB: Decimal values bigger than a certain value are no longer returned in scientific notation

Bug Fixes

Last record missing from edit table tool if user filters query results and then launches Edit Table Tool on query results
Right-click menu not working on editor tabs

8.2.2

Enhancements

Added a Connections -> Favorites menu. Connections can be set as a favorite either when creating intially or when connecting by checking the Add to Favorites box

Changes

Mac Editor: For keyboards with HOME and END keys, Shift + Home and Shift + End now select to begin or end of line
Edit Table Tool: If multiple monitors, edit table tool is centered on screen of current monitor

Bug Fixes

DB2 to Oracle Database Conversion: Precision of decimal columns not always getting set to correct number
When saving an export data profile for a query, line breaks in the query getting lost

8.2.1

Enhancements

Query Results: Edit Query: Control or Command + U now executes the query in the text area
MySQL DDL Generator: Added support for generating on delete cascade and on update cascade clauses to alter table statements
MySQL to HSQLDB Database Conversion: Added support for on delete cascade and on update cascade clauses in alter table statements
Edit -> Preferences -> Fonts -> User Input / Messaging Font option now changes all messaging fonts and user input fonts
Added a prefernence to the Preferences -> Query Results tab called Horizontal Scroll Sensitivity to allow adjusting the horizontal scroll sensitivity of the query results

Changes

MySQL to HSQLDB Database Conversion: Primary key clause is generated in create table DDL for auto increment / identity columns
Main SQL Editor and pop-up editors: Focus can be transferred away from editors using control + tab
Query Results: Edit Query: Control tab can be used to switch from sql area to buttons without using mouse
MySQL Database Conversion: bit(1) columns now convert to bit(1) on HSQLDB
Database Conversion: When converting single tables, alter table statements are now generated in comments at the end of the conversion script

Bug Fixes

MySQL: When sql mode is in strict ANSI compliance, table keys not displaying
MySQL to HSQLDB Database Conversion: Identity columns not getting generated correctly in DDL
Edit Table Tool: If multiple monitors with varying resolutions, Edit Table Tool window may be too wide or too tall for the current screen
Interbase: Boolean type missing from create table type drop-down

8.2.0

Enhancements

Describe Tool: Added a view definition tab for views
PostgreSQL Database Browser: Added user-defined types under the Types node
PostgreSQL Database Browser: Added a Generate Table Grants option for tables and views
PostgreSQL: Describe Table/View Tool: Added a Grants tab
PostgreSQL, MySQL, Oracle, SQL Server: Alter View: Now generates grant statements
Oracle Database Browser: Added a Generate Table Grants option for tables and views
Oracle: Describe Table/View Tool: Added a Grants tab
MySQL Database Browser: Added a Generate Table Grants option for tables and views
MySQL: Describe Table/View Tool: Added a Grants tab
MS SQL Server Database Browser: Added a Generate Table Grants option for tables and views
MS SQL Server: Describe Table/View Tool: Added a Grants tab
Firebird: DDL Generator: Added support for generating identities
HSQLDB: DDL Generator: Added support for generating identities
SQL Server and Sybase: If a procedure is executed that does not return results, but returns output, display the output in the query results
Salesforce: Added support for updating and inserting boolean values for CheckBoxes, etc.
Linux: Added a new shell script launcher to Linux for nonreparenting window managers

Changes

PostgreSQL: Updated JDBC driver
Linux: increased resolution of desktop / application menu icons
Export Tool: Redesigned export tool file selection flow
MonetDB Database Browser: Changed to use system queries to get tables, views, and functions instead of using driver calls
Changing the SQL editor font causes other text areas such as the preview pane on the import tool to use the changed editor font instead of the default font

Bug Fixes

PostgreSQL 10: If a schema is empty, tables may still be displayed in database browser
Editor right-click menu not displaying
Export Tool: Loading from Saved Profile: Wrap quotes box selection always set to true

8.1.1

Changes

Ingres: If comments in a query cause an error, RazorSQL will strip them
Added support for Java 10 and Java 11 to the Java compiler
Registration Screen now provides more information about license eligibility, upgrades, and archived downloads
Minor changes to Windows installers to improve performance

8.1.0

Enhancements

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 option
Cassandra: Datastax Driver: Added ability to set connect timeout and read timeout connection properties

Changes

Import Tool: More detailed error information when an error occurs and the one statement at a time option is checked
Cassandra: Datastax Driver: Set the connection timeout based on the value in the preferences
Query Results: If no column name or alias returned for query, column name given generic title

Bug Fixes

SQL Formatter: Ignore commas in parens not working correctly
DynamoDB count query not working

8.0.9

Enhancements

Import Tool: Added option to convert empty values to a null value instead of empty string
Added the ability to import SSL certificates via the Help -> Import SSL Certificate menu item

Changes

Import Tool: SQL Server: If values for bit columns are true or false, converted to 1 or 0
Ingres: Columns in database browser and describe tool now display in order of ordinal position
Query Results: Reduced horizontal scroll sensitivity
Query Results: When in edit mode, typing the escape key turns off edit mode
Export Tool: JSON Format: ampersand, single quote, greater than, and less than signs no longer use XML escape syntax

Bug Fixes

PostgreSQL Database Browser: For newer versions of PostgreSQL, expanding the Triggers node under Tables in the database browser does not show the triggers for the table
PostgreSQL: insert and delete statements with returning clause throwing an error
Command Line Export: JSON Format: Null values not supported
Favorites: Opening a file from favorites menu not working

8.0.8

Changes

Opening a file that may be certain types of database files prompts for whether to open or connect
Import Tool: Fixed width importer: Performance changes

Bug Fixes

Syntax Highlighting: Not able to change colors for the SQL syntax highlighting set

8.0.7

Enhancements

File System Browser and FTP / SFTP Browser: Added ability to sort by file type
Added print editor contents using web browser and print editor contents with line numbers using web browser options to the File -> Print menu
Added print query results using web browser and print query results with line numbers using web browser options to the File -> Print menu
Added the ability to open the same file in multiple tabs via the Edit -> Preferences -> Editor / GUI -> Allow Same File in Multiple Tabs preference

Changes

File -> Open: If a SQLite database is detected, prompts for whether to connect to the database or edit the database file in the editor
Upgraded DB2 driver to version 3.72. Now supports TLS version 1.2
Upgraded SQLite driver to version 3.23

Bug Fixes

Cassandra: Non-select statements with comments prior to the statement throwing errors
SQLite: Certain images / binary data / blobs are not getting displayed in hex value in query results causing potential hanging issues
MongoDB: 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 another field in the query, the value is getting set incorrectly

8.0.6

Changes

MySQL: Automatic handling of timezone errors for new MySQL driver
Mac: Editor: Decreased mouse drag sensitivity to allow double and triple clicks to highlight words
Updated local help documentation

8.0.5

Enhancements

Export Tool: Added ability for user to input a custom query for export
MySQL Create User Tool: Added support for MySQL 8 create user syntax

Changes

Import Tool: XLSX Importer: Changed time zone behavior to not do timezone conversion on date fields

Bug Fixes

Mac: Connection help links on the add connection profile screen require a double-click instead of a single-click

8.0.4

Enhancements

Redshift Database Browser: Added support for showing external tables via Redshift Spectrum
Salesforce: Added support for USING clauses in select queries

Changes

Increased the default query timeout from 300 seconds to 900 seconds
RazorSQL Plugins: Plugins now only load from the plugin directory under the user's home directory

8.0.3

Enhancements

Added support for the Snowflake database
Import Tool / Execute SQL Script: Added better support for importing / executing MySQL dump file formats
Import Tool / Execute SQL Script: Allow for embedded semi-colons in text when statement separator is semi-colon

Changes

Salesforce: Updated Salesforce API calls to version 43.0
SQL Editor: Added None as a syntax highlighting type

8.0.2

Enhancements

DynamoDB Export: Added ability to export tables / queries with very large result sets
Added preference for switching the caret to a block instead of a line
Added preference to turn on / off the blinking caret

Changes

DynamoDB: Increased max error retry value and network timeout settings

Bug Fixes

SQL Formatter: Not supporting keywords inside double quotes correctly
Import: Column information for table can get duplicated in certain situations
Tables with the same name but different case get duplicate columns on describe table for certain databases

8.0.1

Bug Fixes

SQL Server / SQL Azure: Indexes that are not in the default schema are not displaying in the database browser
Import Tool: Unable to retrieve column names for tables or schemas not in the default case of the database
kdb+: Edit Table Tool: Not generating insert, update, or delete statements correctly for numeric columns
If connecting to Athena before DynamoDB, the DynamoDB connection fails. To fix, re-create Athena connection
If 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 tool does not work in certain situations
SQL Server Database Conversion: parens are getting generated in default value clause in create table statement for databases that do not support parens in default value clauses

8.0.0

Enhancements

BigQuery: Added support for Google BigQuery databases
KDB+: Added support for the kdb+ database
MongoDB: Added support for connecting using SSL encryption
Redshift: Added support for entering AWS IAM credentials when connecting using the Redshift driver
Redshift: Added support for new Amazon Redshift drivers
Cassandra: Added a Create Keyspace / Create Schema tool
Cassandra: Included additional drivers in install
Firebird: Added ability to convert Firebird tables to the following database types: Access, DB2, H2, HSQLDB, MySQL, Oracle, PostgreSQL, SQLite, and SQL Server
Added ability to adjust max rows per query setting to toolbar
Added an auto-backup process for connection profiles

Changes

Updated graphics runtime environments for Windows, Mac, and Linux
Upgraded MongoDB drivers to version 3.6
Upgraded MariaDB JDBC driver to version 2.2.3
Upgraded UCanAccess driver to version 4.0.4
Upgraded Redshift jdbc driver that gets installed via the auto-install process
Database Conversion: Empty but not null binary values are converted to null in database conversion inserts
Objects with a colon in the name now get automatically wrapped in generated SQL

Bug Fixes

Salesforce: Max number of rows returned not matching up with max results setting in certain situations
Ingres Generate DDL: column names not being returned in index DDL
Ingres Execute Procedure Tool: If procedure has not nullable OUT params, OUT params not getting populated in call response
PostgreSQL / Redshift: If view definition is not in information_schema, need to query pg_catalog to get view definition
MySQL via Amazon RDS: MariaDB driver. After running a query that produces a syntax error, subsequent queries fail
MS SQL Server: Importing unicode characters into nvarchar or nchar fields not prepending generated inserts with N' syntax
Salesforce: Max Results Per Query value getting ignored
MS Access Database Conversion: Date conversion from some databases getting length specific in create table statement for date fields
Firebird: Compound foreign keys not getting generated property in Generate DDL tool
Database Conversion: Conversion to Oracle timestamps including a size in the create table statements
Windows: Trying to delete a file via the File -> Open dialog causes RazorSQL to hang

7.4.10

Enhancements

Cassandra: Added support for the DataStax driver. Thrift protocol no longer needs to be enabled to connect
Cassandra Database Navigator: Added support for views for Cassandra version 3 and newer
Cassandra Database Navigator: Added option for running limit queries
FTP Client: Improved speed of FTP download and upload processes

Changes

SQL Server and Sybase: When using GO as a statement separator, it is no longer case sensitive
Database Navigator: Cassandra: Show all keyspaces not just the ones that have tables

Bug Fixes

FileMaker: Export, Edit Table Tool, and Generate Insert, Update, and Delete options on query results not generting date, time, and timestamp syntax correctly

7.4.9

Enhancements

H2 Connections: H2 driver can now be auto-installed
Derby Network Connections: Added option to create the database on connect if it does not yet exist

Changes

Query results binary data: Convert to hex now happens by default in query results unless convert to hex preference is manually unchecked
Drop Table and Truncate Table tools - Drop/Truncate statements are automatically regenerated when new table is selected

Bug Fixes

Ingres: Ingres procedure columns not recognized as inout or out in certain situations

7.4.8

Enhancements

Firebird: Added support for connecting to Firebird 3 databases without making wirecript configuration changes
Firebird: Added support for the binary data editor and image viewer for blob subtype 0 / blob subtype binary columns
Added support for Derby 10.14

Changes

Upgraded Firebird JDBC driver

Bug Fixes

Ingres: Procedure names not correct in certain situations
Row 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

7.4.7

Enhancements

Salesforce: Added row count option to Salesforce database navigator right-click / context menu
Salesforce: Added support for streaming Salesforce results to allow support for larger exports
DynamoDB and SimpleDB: Added support for AWS STS temporary credential session tokens for authentication
DynamoDB and SimpleDB: Added support for using AWS credentials files for authentication
SAP / Sybase ASE: Added ability to set NEWPASSWORD property on connections to change expired passwords

Changes

AWS Secret Key needs to be masked when adding a new connection profile
Athena JDBC driver download updated to latest version
MySQL: Updated reserved word list to support reserved words added in MySQL version 8

Bug Fixes

Oracle Packages with overloaded functions and / or procedures not supported correctly
Command Line Process: Connection via SSH tunnel not supported

7.4.6

Enhancements

Query Scheduler: Added ability to add date time onto generated file name
Sybase IQ / SAP IQ: Added support for autoincrement / identity columns to the generate ddl tool
Database Conversion: Added support for including default values in generated create table statements for MySQL, HSQLDB, Oracle, H2, and SQL Server

Changes

Sybase IQ / SAP IQ: Generate DDL generates create index statements that have many spaces after the index name
SQL Favorites Menu: Added sub-menus for instances when there are too many favorites defined to fit on the screen
Added several missing keywords to sql syntax files

Bug Fixes

If going from a multiple monitor setup to a single monitor setup, certain windows like the Find dialog may display offscreen
Mac: Dragging and dropping table and column names to the editor does not work after 7.4.5 release
SQL History: If multiple versions of RazorSQL are open, sql history may get overwritten
GenerateDDL 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

7.4.5

Enhancements

Added ability to drag and drop files to editor for opening
Added ability to create and open file sets (File -> Open File Set) menu option for opening a set of files with one operation
Added ability to use the show create commands for procedures, functions, and triggers to the database navigator
Database Navigator: Enabled Generate DDL option in addition to the Edit option for functions, procedures, triggers, packages, and package bodies for supported databases

Bug Fixes

MS SQL Server: Generate View DDL / definition from a database other than the currently selected database or a schema other than dbo is limiting the view definition to the first 8000 characters
Query results column width not wide enough in certain situations when the last row displayed is the widest value
MS Access: Generate DDL should not display a length for GUID columns
Switching editor tabs while queries are executing can cause the query results to be displayed in the wrong tab

7.4.4

Enhancements

Added Close Tab context menu option to query results tabs

Changes

SQLite: RazorSQL SQLite Driver changed to legacy status. Recommended to use SQLite JDBC Driver
SQL 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 returns are kept in the procedure text when sent to the database
FrontBase: Drop table syntax now includes restrict keyword at the end

Bug Fixes

FrontBase: With certain drivers, dropping an object will cause database navigator to not reload correctly
SQLite: Generate DDL does not generate View DDL for views with spaces or special characters in the name
SQLite: Alter option for Views in context menu of database browser not generating drop and create view statements
Auto-commit setting not retained when opening a new tab that shares the existing connection
High Resolution Monitors: Close icon on tabs right-edge not completely straight
Mac: High Resolution Monitors: Close icons not working on tabs

7.4.3

Enhancements

Added Redshift to database conversion tools

Changes

Direct3d graphics now enabled by default on Windows

Bug Fixes

Multiple monitors with vertical orientation or 3 plus monitors with mix of vertical and horizontal orientation, windows not always displaying on the correct monitor

7.4.2

Enhancements

Salesforce and DynamoDB Connection Setup: If there is a proxy server configured on the machine, RazorSQL will prompt for automatically connecting through the proxy server

Changes

Upgraded to version 1.11.248 of Amazon AWS JDK for DynamoDB connections
Added a work-around to enable connecting to Salesforce, SimpleDB, or DynamoDB over https thru a non-https proxy server
UI changes to make sure default buttons were set on windows that did not have a default button
Cleaned up local help documentation. Fixed missing / broken links for certain database specific help pages.

Bug Fixes

Downloading a driver file through a proxy server may cause subsequent connection attempts to time out
SQL Server: Explain plan does not work when using server side cursors (selectMethod=cursor) with MS SQL JDBC driver
SimpleDB and DynamoDB: Configure Proxy button does not show Proxy configuration window on the add connection window

7.4.1

Changes

RazorSQL now uses system proxy server settings for the driver auto-install / auto-download process to prevent download timeouts for users behind proxy servers
MonetDB: 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 drivers
Uncomment Tool: If multiple lines in the editor are selected, will remove comments from individual lines if they start and end with multi-line comment indicators

7.4.0

Enhancements

Added support for VoltDB
Added support for Druid
Added additional supported features for Apache Hive
Added support for Oracle XMLType to backup, conversion, data editing, and SQL and DDL generation
Salesforce: Added support for min, max, sum, and avg aggregate functions
Added a database selection drop-down to the toolbar for Apache Hive

Changes

Upgraded MonetDB JDBC driver that gets downloaded via the auto install process
Hive: Table names no longer returned as part of the column name in query results
Mac: Multiple files can now be selected when manually adding JDBC driver jar files

7.3.15

Enhancements

Added some preliminary support for Apache Hive

Changes

File System Browser path field font gets aligned with the File System Browser tree font if the tree font is changed

Bug Fixes

Quote and Double-Quote keys not usuable on US International Keyboard layout

7.3.14

Changes

Query Results filter rows and find all rows options no longer include empty rows in the results table
MonetDB: Unnecessary SQL warnings no longer displayed
High Resolution Display Changes: Added higher resolution desktop and taskbar icons, additional window sizing adjustments for better display

Bug Fixes

Salesforce queries with escaped single quotes throw an error when the query ends with a semi-colon

7.3.13

Enhancements

Added a drop schema tool for the following databases: Oracle, PostgreSQL, Redshift, DB2, MS SQL Server, SQL Azure, Derby, HSQLDB, and H2

Bug Fixes

Add/Remove column buttons not working correctly on the Create Table Tool
Linux: Systems running Wayland may crash when displaying context menus
DynamoDB: When running a local and remote DynamoDB connection, table information cache is getting shared across the local and remote connection
Commit and Rollback toolbar icons not getting enabled or disabled correctly when auto-commit status is changed on the toolbar and multiple connections tabs are navigated to and from

7.3.12

Enhancements

MonetDB: Added schema drop-down on toolbar for changing the current schema
Increased the maximum number of files displayed in the recent files, recent directories, and file system browser goto directory menus
Added a Document End Line Break option to the Edit menu for taking the cursor to the end of the editor and inserting a line break to put the cursor at the front of the newly created last line

Changes

DB2: Large double numbers no longer show in scientific notation

Bug Fixes

MonetDB: Database name getting concatenated in front of schema name in generated queries
MonetDB: Mixed case / all upper-case tables not getting wrapped in quotes in generated queries

7.3.11

Changes

Windows: Added special RazorSQL launches for the following: Completely turning off hardware acceleration, running with direct3d graphics pipeline on, running with opengl graphics pipeline on

Bug Fixes

Mac: Copy Table Tool: Window freezing after executing the generated SQL script from within the copy table window

7.3.10

Enhancements

Linux: Added a Dark Mode look and feel option to the View -> Change Look and Feel menu

Changes

Added a default max rows value for Netezza and Greenplum
Upgraded Firebird JDBC driver to Jaybird version 3.0.2
Icons are no longer scaled to a larger size for high-resolution screens that do not have a operating system scaling value set
When connecting to a *.database.windows.net host for SQL Server or Azure, a database name is required
Database Conversion, Copy to Local Database: Alter statements are now generated / executed after insert statements

7.3.9

Enhancements

Windows: Added Dark Mode look and feel theme to the View -> Change Look and Feel menu
Added Pipe as an option for import delimiter in the command line import process and as a selectable character in import and export tool drop-downs
Find in Files: For finds occuring over a network drive, added logic to retry file access if network drive access is temporarily unavailable during find operation
Copy Table Tool: Added qualify table names option
Alter Table Tool: Added options to add NOT NULL constraints to change column type options for Oracle, MySQL, and MS SQL Server

Changes

Changed commit, rollback, and view table icons
Database Navigator: Generate DDL: fully qualify table name in references call when generating alter table statement
Database Navigator: Copy Table: fully qualify table name in references call when generating alter table statement

Bug Fixes

Database Navigator: Oracle, MySQL, MS SQL Server, and Sybase ASE: Duplicate indexes displaying for indexes with more than one column in the index definition
Database 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

7.3.8

Enhancements

Windows: Added Windows Default Look and Feel option to the View -> Change 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 used
Added preference for whether to halt processing of result sets when an error occurs retrieving results. Default is set to true
Linux: The OpenGL graphics pipeline can be enabled using the View -> Enabled Advanced Graphics menu option. This is not recommended for most systems.

Changes

Windows: Direct3d graphics pipeline is now disabled by default. To enable, select the View -> Enable Advanced Graphics menu option
Range 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 spaces

Bug Fixes

When manual text size scaling was set via the View menu, Menu font was not correct system font on Windows and Linux
Multiple Monitors: FTP Browser window always showing on main monitor

7.3.7

Changes

Oracle Package Body function navigator sorts functions and procedures in alphabetical order by the name
Windows: Upgraded to latest version of editor font to support additional unicode characters

Bug Fixes

PostgreSQL: Generate DDL with Functions option selected is not returning the function definitions
PostgreSQL: Backup Schema option not generating function contents
Font changes not staying in effect on high-resolution monitors

7.3.6

Changes

Mac: Changed default key hold behavior to repeating keys

Bug Fixes

Mac: Command keys and sometimes keyboard input stops working in certain situations

7.3.5

Changes

Amazon Athena: Improved performance of query builder load
Add Connection Screen: Added option to set max rows to display to all database and connection types
Add Connection Screen: Set a default, overridable max rows to display of 25000 for certain database types
Connection Screen: If max rows to display is not set, default to 25000 for MySQL, MariaDB, Aurora MySQL, and Redshift
The connection level max rows to display limit is not applied to export, backup, or other file based processes
In 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 backups
Updated MariaDB driver to latest version to prevent Aurora MySQL connection timeouts in certain situations

7.3.4

Enhancements

DynamoDB: Added support for inserting / updating map data in json format
Enhancements for 4k resolution

Bugs

Mac FTP / SFTP: Delete dialog can be hidden behind another dialog

7.3.3

Enhancements

Added support for SQL Azure Active Directory user / password authentication
Added support for SQL Azure Active Directory single sign-on for Windows users
Added support for HSQLDB / HyperSQL version 2.4

Changes

Reduce amount of logging for Salesforce and DynamoDB to prevent large log files

Bugs

RazorSQL SQLite driver not recognizing primary keys correctly when columns are defined with tick marks surrounding the name

7.3.2

Enhancements

Added ability to enter a custom Salesforce.com URL via the environment drop-down when creating a connection
Added a mysqli_bridge.php page to the bridges folder under the installation directory that supports MySQL Bridge connections for PHP 7
Added a preference to the Query Results preference tab for replacing editor contents with the query used to generate the query results tab when switching query results tabs

7.3.1

Enhancements

Added support for filtering schemas in the database navigator for PostgreSQL
Upgraded to latest ucanaccess driver

Changes

DynamoDB: ListTables permission is no longer required for a successful connection
Vertica: Escape tables that have underscores for table meta data calls to improve performance

Bug Fixes

Multiple tabs sharing same connection - database is changed in the dropdown in one needs to also be changed in all the other tabs
PostgreSQL: update returning statement does not work
FTP Browser: Overwrite prompt hidden behind other dialog on certain systems

7.3.0

Enhancements

Added JSON as an option to the Export tool
Added JSON option to the command line export tool
Added table conversion to the command line tool
Added a delete all rows option to the Edit Table tool
Added tooltip text to the file names in the FTP browser

Changes

Database name is now required for SQL Azure connections
Edits in new window font on Edit Table Tool now matches the edit table tool / query results font
Trying 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 spaces
Upgraded MariaDB driver to version 2.0.1

Bug Fixes

Dragging 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 off
Describe tool not working for tables with certain column types
MySQL keep alive query not getting set correctly when creating new connections
DynamoDB tables with more than one dot in the name throwing sql parsing error from database navigator operations
Connections -> View Print Output menu option not enabled for PostgreSQL
PostgreSQL raise / print information displaying duplicate messages in certain situations

7.2.6

Enhancements

Automatic application of Windows scaling percentage for text and icons when text and icon size are set to the defaults of Auto-Detect
Enhancements to make fonts, icons, etc. look better on 4k displays

Bug Fixes

If default syntax type is set in preferences to something other than SQL, not always getting applied properly when opening new tabs

7.2.5

Changes

Improved memory efficiency of the compare process

Bug Fixes

XLSX files with empty lines at the end causing errors with the import tool
XLSX import - varchar column values getting .0 appended when values are numeric
View menu user-defined keyboard shortcuts getting lost when opening new tabs

7.2.4

Enhancements

Added support for the XLSX format for the command line export process
Added Azure Data Warehouse connection option for SQL Azure
Added support for mouse-based horizontal scrolling on Mac
Better support for SQL keywords in Salesforce queries

Changes

Upgraded HSQLDB driver to 2.3.4
Upgraded SQLite driver to 3.16
Upgraded sqlite3 command line program to 3.16

Bug Fixes

Icons and Text not getting scaled enough for Windows scaling above 150%
SQL Formatter window OK button requires mouse to execute - can't be executed with keyboard
Add Connection Wizard: When no existing database connection profile exist, the database type list is not getting the window focus
Fonts on preferences window not correct for scaling or when text size expanded
Query results search all option is not setting the view of the results table back to the first row

7.2.3

Enhancements

Added a View -> Font -> Reset Fonts to Default menu option and adding a reset fonts to default option in the preferences
Mac 64-bit: Included executable program within RazorSQL.app so command line programs can be run without any additional installs required

Changes

Changed default editor font size from 11 to 12
Xactly ODBC Driver: If query returns no rows, don't show error
Xactly: Drop-downs: Configure for schema support only - remove catalog/database options
Xactly: Don't perform operations on stale results or connections to prevent crashing

Bug Fixes

FTP client. Right-clicking on Mac with control plus click deselects the currently highlighted item
Mac 64-bit: Next tab and Previous tab shortcuts moving over two tabs instead of one
If screen resolution is made larger while RazorSQL is running, unable to resize window past original screen size
FTP Client: The progress bar on windows is not wide enough
MS SQL Server: Generate DDL is putting sizes on hierarchy_id columns
Query Results: Copy Results to Clipboard (No Column Names) option is including the column names in the copied text

7.2.2

Enhancements

Better support for windows display scaling
Added 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.

Changes

For newer versions of Cassandra, all defined keyspaces are displayed in the database navigator even if they do not have tables
Changed default icon and text size to auto detect
Mac 64-bit: Allow to run on less battery intensive graphics card for machines with two cards

Bug Fixes

Command Line Call Generator: Execute Option: Not generating command correctly when password override is left blank
Some code builders not working (HTML, C, etc.)

7.2.1

Enhancements

Added a quick connect box to the toolbar

Changes

Changed Xactly keep alive settings to prevent a crashing issue
Changed the way decimal values are retrieved for Xactly

Bug Fixes

HSQLDB / HyperSQL: Generate DDL and Alter view not working with newer versions of HSQLDB

7.2.0

Enhancements

Added support for Amazon Athena
Added support for Amazon Aurora MySQL compatible version
Added support for Amazon Aurora PostgreSQL compatible version
Added support for Derby 10.13 to the auto-install driver process
Added several default, configurable connection properties for the MariaDB driver
For databases that RazorSQL has auto-download configured for drivers, added option for re-installing drivers after they were already downloaded / installed
Added a Tools -> International Editor option for more easily typing languages such as Chinese, Japanese, and Korean

Changes

Changed default driver for MySQL to the MariaDB driver
Upgraded to version 1.5.5 of the MariaDB driver
SQL Server jtds driver: default to useNTMLV2 when not otherwise set and using domain security

Bug Fixes

Cassandra: Selecting against smallint and tinyint columns is not working
Create function syntax for Amazon Redshift is not correct
Mac: 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

7.1.4

Changes

Changed threading behavior for SQL Server ODBC connections
Changed threading behavior for CacheDB ODBC connections

Bug Fixes

Configure connection properties option does not support values with ~ or | characters in them
Sybase: Executing queries that load temp tables using the Execute SQL Fetch All Rows option throws an error

7.1.3

Changes

MongoDB: Changed default settings for timeouts and socket keep alive

Bug Fixes

SSH Tunnel and SFTP client not working with SSH servers whose preferred authentication is kerberos

7.1.2

Enhancements

Edit Table Tool: Apache Derby: Added support for identity / auto increment columns
Added preference for whether to warn on disconnect
Added an Extra Large option to the View -> Text Size menu
Added an Extra Large option to the View -> Icon Size menu

Changes

Changed default memory settings on 64-bit versions
SFTP Client - set max authentication tries to 1 to prevent account locking
Changed default max memory for razorsql_himem.exe to 6 GB

Bug Fixes

SQL Server to PostgreSQL conversions for smallint and tinyint not working correctly
File System Browser and FTP client icons not displaying correctly when View - Icon Size menu option set to larger than normal

7.1.1

Enhancements

Added support for configuring connection properties for the MS SQL Server driver when connecting to SQL Azure

Changes

Connection Wizard: Changed display of database type list

Bug Fixes

Informix Edit Table Tool: Generated insert/update/delete statements for columns with data type smallint generating incorrect SQL
Mac: Zip Utility: Extract All option selecting the parent directory instead of the current directory of the zip file
Mac: Zip Utility: Zip file not getting closed correctly after zip utility is closed
Editor font not changing if user changes text size option in the View menu to Medium or Large

7.1.0

Enhancements

Export Tool: Added the Excel XLSX format as a supported option
Import Tool: Added the Excel XLSX format as a supported option
Linux x86 and x64: Upgraded graphics libraries and runtime
Window x86 and x64: Upgraded graphics libraries and runtime
Mac x64: Upgraded graphics libraries and runtime

Changes

H2 database connection wizard auto download process - updated to get latest stable version of H2

Bug Fixes

Database Conversion: Salesforce address column types getting a length of 0 when converting to other database types

7.0.9

Enhancements

Command Line File Execution: Added a halt on error parameter
Command Line File Execution: Added a show output parameter
Command Line File Execution: When executing as batch, if batch fails, try to execute statements in batch after the failure statement
Import Tool: For delimited, SQL, and Excel files, if batch fails, try to execute statements in batch after the failure statement

Changes

For SQL Server Express / local connections, if JDBC connection fails, try ODBC connection via shared memory

Bug Fixes

SQL Server TSQL blocks that start with a use statement not returning results from selects inside the block

7.0.8

Enhancements

Added a file encoding parameter option to command line delimited file import
Added a halt on error option to the command line delimited file import
Command 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 batch that were not executed due to an error in a previous statement

Bug Fixes

Teradata Version 15 driver throws an ExceptionInitializationError
Import tool: create new table and import from sql file erroring

7.0.7

Enhancements

Added a Find All Rows icon to the query results pane that displays all rows that have any column that contains the text entered by the user
Added clear entries option to recent files menu
Added clear entries option to recent directories menu
Minor performance improvements to Export

Changes

Upgraded MariaDB driver
Upgraded Informix driver
Ignore case when sorting the recent files menu items
Ignore case when sorting the recent files menu items
Increased the time allowed between keystrokes before the buffer resets for database navigator key ahead searching

Bug Fixes

Oracle prepared statement import does not work when importing a subset of the columns in the table
Salesforce: if you order on an aggregate, the grouped field in the linked table disappears

7.0.6

Enhancements

Added support for Salesforce functions in select and group by, and having clauses
Oracle: Added a use preparedstatement option to delimited file import tool for better performance
General performance improvements to the delimited file import process
Added an option to command line import that determines whether to print the executed statements
Added an option to command line import that determines whether to use prepared statements to increase performance if supported by the database type and data types of the table

Changes

Command line import for Oracle now generates date inserts using the to_date syntax for certain date formats

Bug Fixes

Salesforce query values not displaying for certain join types
Filter navigator option not working for MS Access
Auto commit setting getting turned off mid-session for some ODBC drivers
Unable to fetch more rows when row count is above fetch size using SQL Server ODBC

7.0.5

Changes

Explicit commit now called when auto commit is on for SQL Server ODBC connections running with Read Uncommitted transaction isolation

Bug Fixes

Edit Table Tool: If close window without saving, and click No on warning message, window closes anyway
No data found error for SQL Server Numeric columns using ODBC
Mac file selection dialog returning an actual file as a directory path in certain situations

7.0.4

Enhancements

Added support for macOS Sierra
Enhanced single-threaded mode for legacy ODBC drivers
Added a preference to force RazorSQL to run in single-threaded mode (for legacy drivers that don't support multi-threading)
Added support for more Salesforce count query types

Changes

Xactly and CacheDB ODBC connections are now set in single-threaded by default
Changed the way RazorSQL communicates with the Xactly driver for non-select statements

Bug Fixes

Queries against tables with uniqueidentifier columns throw errors when using the SQL Server ODBC driver

7.0.3

Enhancements

Added a preference for showing empty Oracle schemas in the database navigator

Bug Fixes

Salesforce: connections to sandbox not working since version 7.0.2
SQL Server xml type should not get a size automatically in create table tool

7.0.2

Enhancements

Oracle connection wizard: Added the ability to set up LDAP connections
Oracle connection wizard: Added the ability to set up connections based on TNS files

Changes

Excel import: Numbers in scientific notation are converted to whole numbers
HSQLDB database conversion: Primary key clause no longer included in create table statement for identity columns
Increased max frame size in Cassandra driver from 16 MB to 64 MB
Added support for Access GUID
Upgraded Salesforce API to version 37

Bug Fixes

Unable to query Salesforce Order table
Proxy settings not getting saved when configuring proxy via Add connection profile
Cassandra: Timeuuid column type not supported
Certain data types not showing up in create table tool for SQL Server
Keep alive executing during exports causes problems in certain databases / drivers

7.0.1

Enhancements

Salesforce table conversion: Added the ability to convert Salesforce tables to the following databases: DB2,MS SQL Server,MS Access,MySQL,Oracle,PostgreSQL,SQLite, HSQLDB, and H2
DynamoDB local connections now allow the region to be specified in the local URL

Changes

DB2 Conversion - when converting to DB2 tables, force a NOT NULL constraint on primary key columns
Minor display layout changes

Bug Fixes

Export Tool: Invalid file paths sometimes received from the save file dialog

7.0.0

Enhancements

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 databases
Salesforce: Added column sizes to Salesforce describe table tool
Added create index statements to the generate DDL option for tables
DynamoDB: Added the option to connect to a DynamoDB local server when creating a connection to DynamoDB
Added ability to edit connection profile names on the connection window
Added support for Redshift Interleaved sort keys in create table DDL
Added support for Redshift compound sort keys in create table DDL
Added support for Salesforce date functions like LAST_N_DAYS
Added ability to turn on ssl encryption when connecting to Redshift using the Redshift driver

Changes

Change 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 executed
Salesforce: Copy to local database uses actual Salesforce column sizes for character-based columns instead of default sizes
DynamoDB 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 table
Cassandra: comments are automatically stripped from queries
Mac OS X 64-bit: Upgraded graphics libraries to the latest version

Bug Fixes

Derby: columns not displaying in database browser for mixed case table names
Export command line interface. If specifying "insert" as the output type, the ending chars field is ignored
DynamoDB Database Browser: Trying to view a table that's name is an SQL keyword throws an error
Redshift sort and dist keys not always returned in generated DDL when when $user is present on the search_path
Redshift sort keys not always determined correctly when generating Table DDL
Refresh navigator preference value getting erased in certain Execute All situations

6.4.8

Enhancements

Added preference for specifying the maximum column width in query results cells

Changes

Previous Vertica result sets are closed upon execution of new queries

Bug Fixes

Vertica error messages not displaying properly
Database navigator not loading correctly when disconnecting and reconnecting a Vertica database
MySQL JDBC drivers versions 5.1.35 and newer not able to connect

6.4.7

Enhancements

Added ability to change text and background color of query results
Added ability to change text and background color of database navigator
Added more options to the "View Query" window

Changes

Added support for connecting to Salesforce vai TLSv1.1 and TLSv1.2 protocols
Added support for connecting to Salesforce vai TLSv1.1 and TLSv1.2 protocols

6.4.6

Changes

Increased default memory settings on Mac and Windows 64-bit versions

Bug Fixes

Database navigator does not work with Cassandra version 3
Mac 64-bit: Value in Help menu Adjust Memory Settings box may not match what the actual max memory is set to

6.4.5

Changes

JSP, PHP and ASP Bridges: Added support for connecting to web sites with self-signed certificates
No row count related warning messages suppressed

Bug Fixes

New plugins unable to be imported
Wrong ora18n.jar version getting set when connecting to older versions of Oracle
Import tool: Decimal values in Excel spreadsheets getting rounded in certain situations

6.4.4

Enhancements

Added ability to specify an approximate maximum number of rows to return from Salesforce queries
Added option to export tool for adding the schema name to the generated file name when exporting single or mutliple tables

Changes

Removed the restriction of limiting Salesforce queries to 200000 rows if the Salesforce max rows setting is set above 200000

Bug Fixes

Export Tool: Window is sometimes not centered on the screen when selecting certain options

6.4.3

Changes

Sybase Call Procedure Tool: Added support for timestamps as input
Command Line Connect Option: Added support for specifying the connection tab name as an additional parameter after the connection string
Maximum window size is no longer set when multiple monitors are present

Bug Fixes

Create table on local database from query results not handling Oracle date values correctly

6.4.2

Enhancements

Added ability to launch RazorSQL with connection information specified on the command line in the following format: -connect "jdbcUrl|driverClassName| driverLocation|user|password"

Changes

Redshift: Better recognition of when a column is a dist key
Salesforce: Better support for case-insensitive spelling of column names in join statements

Bug Fixes

Paired foreign keys getting generated as two separate alter statements in the database conversion process

6.4.1

Enhancements

Added support for Redshift sorkey and distkey when generating Redshift table DDL
Added support for Redshift JDBC driver
Added auto-download support for the Redshift driver
Salesforce: Added support for additional timestamp formatting for Salesforce queries

Changes

Better support for select into statements when using Redshift

Bug Fixes

Oracle binary data editor - if table name is not in all upper-case - throws a table/view does not exist error
Objective-C compiler settings not correct for OS X Yosemite and El Capitan
Sorting query results and then trying to fetch all remaining rows after sort causes crash

6.4.0

Enhancements

Edit query window from query results tab is now a bigger window and has syntax highlighting
Added support for Derby version 10.12
Upgraded graphics libraries on Windows and Mac
Salesforce: Added support for querying using ALL ROWS

Changes

Teradata: Updated driver class name on connection wizard to reflect recommended name instead of deprecated name
Better support establishing Cassandra connection
For users who upgrade, better handling of replacing old Oracle drivers with new Oracle drivers from connection profiles created with old versions of RazorSQL

Bug Fixes

DB2 Copy to Local Database: Decimal column length not getting set correctly
Add connection profile - HSQLDB driver version listed incorrectly

6.3.29

Enhancements

PostgreSQL: Added a dropdown on the toolbar so users can switch between databases in the same RazorSQL tab

Changes

MongoDB: ListDatabases role no longer needed to connect

6.3.28

Enhancements

MySQL Table Conversion: Auto increment columns now convert to PostgreSQL serial column
Oracle - added ability to get line number for SQL errors on select statements
Added a preference for whether to try to display Oracle error line numbers for select statements
Added ability to sort query results columns via turning on the sort query results columns preference

6.3.27

Enhancements

SQL Azure: Added support for generating / backing up procedures, functions, and triggers
SQL Azure: Added support for displaying indexes, constraints, and roles

Bug Fixes

Copy to Local Database option for Salesforce and DynamoDB tables throwing errors for varchar columns
Mac OS X freezing issues

6.3.26

Enhancements

Added support for select count() queries for Salesforce

Bug Fixes

Import Tool: Import create new table option not recognizing column headers in certain situations
Import Tool: Create new table creating table as default case object but insert statement generation using exact case
FTP client throwing error when no files / directories contained in initial directory

6.3.25

Enhancements

Added option for specifying encoding on Firebird connections
Added support for additional ciphers for SSH tunnels and SFTP connections

Bug Fixes

Cassandra date formatting issues
Querying 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 future queries

6.3.24

Bug Fixes

Sybase Generate DDL for views not generating entire view statement
Sybase Generate DDL tool displays nchar and nvarchar columns as char and varchar
If "Executing . . ." window preference is turned off, focus does not stay in editor after executing query

6.3.23

Enhancements

Added support for displaying DynamoDB map type
Added support for displaying DynamoDB list type
Added support for DynamoDB boolean type

Changes

MySQL - if get the no database selected error, display a more meaningful message to the user
Upgraded DynamoDB AWS library to the latest version
Text and Icon size auto-detection only scales text and images for resolutions larger than 1080p and now sets icon and text sizes to medium instead of large

Bug Fixes

Statements starting with a SET command are always updated as an updated even if there are select statements in the statement block
PostgreSQL to MS SQL Server database conversion setting decimal / numeric length incorrectly in certain cases

6.3.22

Changes

Upgraded Mongodb driver to version 3
Upgraded Oracle JDBC drivers to the latest 12c version

Bug Fixes

Mongodb version 3 authentication not supported
If user sets an icon or text size preference, and then sets it back to auto detect auto detect logic is not correct
DynamoDB: generated delete and update statements for tables with dots in the name throw errors

6.3.21

Enhancements

Added Icon Size menu to the view menu to allow users to change the size of icons
Added Text Size menu to the view menu to allow users to change the default text size

Changes

For high-resolution displays, RazorSQL will automatically scale text and icons to a larger size depending on the resolution of the display

Bug Fixes

Firebird database browser not showing columns for case sensitive tables
Set identity insert on not working on import tool if table being imported into is different than the current database

6.3.20

Enhancements

Added 2015 Amazon RDS SSL certificates to RazorSQL installation
Added support for more encyrption algorithms for SSH tool and SSL encrypted connections

Changes

Changed default connection timeout to 35 seconds from 120 seconds

Bug Fixes

MySQL connection properties: verifyServerCertificate property spelled incorrectly
Configure connection properties function on the add connection profile window not setting connection properties for the MS SQL Server driver

6.3.19

Enhancements

Added encoding option to command line export process

Changes

Plus sign should be a special char that requires objects to be wrapped in quotes

Bug Fixes

Browse buttons on command line call generator do not allow users to type in names of output files

6.3.18

Enhancements

MS SQL Server: On Windows, added the ability to connect using Windows authentication for the MS SQL Server JDBC driver
Added a Help -> Set System Property menu option to allow users to set system properties

Changes

Start using newer version of MySQL driver for auto download version 5.1.34
SQL history now includes the current statement delimiter when storing the queries to history
If batch call size is 1, command line execute sql file process no longer uses the execute batch option on the driver

Bug Fixes

Query Results Sort: PostgreSQL timestamptz values not sorting
Right-click menu on FTP Client sites list does not work on Linux
Right-click menu on file system browser path field does not work on Linux
DynamoDB - columns with the name of key should not be required to be quoted when written in queries

6.3.17

Enhancements

Add option to the Window menu for closing the current query results tab
Upgraded DB2 driver to the latest version (3.69)

Changes

When exporting multiple delimited files and delimiter is a comma, name all files with a .csv extension
Oracle timestamps: Changed default format for Oracle timestamp columns to YYYY-MM-DD HH24:MI:SS.FFF
Added User Input Font option to the font dialog of the preferences window for changing the combo box fonts for tools in the Search menu

Bug Fixes

Query referenced table option in query results not working for queries with quoted table names
Closing the font selection window sometimes changes the font without the OK button being pressed
Edit table tool. Edit query with a lot of results, the last row does not display in the edit table tool

6.3.16

Bug Fixes

For machines with certain network configurations the process to connect to the database is taking longer than it should
Cassandra: List, Map, and Set data types not showing correctly in the database browser or generate DDL tools
Salesforce: excludes query syntax throwing parsing error
Salesforce: chaining together more than 3 tables in a query throws an SQL parser error
Salesforce: Empty values being returned if more than two tables are chained together in SOQL joins

6.3.15

Changes

Upgraded SSH library - supports more ciphers and fixed bugs with connecting to SSH over non-standard ports
Changed settings for how RazorSQL sets statement fetch size for DB2 ODBC drivers

Bug Fixes

Salesforce: includes query syntax throwing a parsing error

6.3.14

Enhancements

Add Reload option to right-click menu on sql editor tab for reloading the current file

Changes

FTP Window needs to remember its size

Bug Fixes

DynamoDB query bug introduced with previous version
Command Line Interface does not work with DynamoDB

6.3.13

Enhancements

Added Amazon Redshift support
Enable viewing of raise output in Netezza
Added support for Apache Derby 10.11

Bug Fixes

Export Tool: If halt on export is unchecked, all export files / data not getting written
Save to FTP menu option not working
Cassandra: Can't always handle concurrent requests.
Changing the decimal separator in query results preference ignored for SQL Server and Sybase

6.3.12

Enhancements

Export Tool: Added an option to not halt on errors when exporting multiple tables
Added UCanAccess JDBC driver support
Allow user to change the location of the built in database
Command Line Interface all to pass all information to connect to the database on the command line Example: 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"

Changes

Upgraded internal database from HSQLDB 1.8 to HSQLDB 2.3
Database conversion: When converting from a database with default upper case to a database with default lower case or vice versa, no longer wrap generated column names in quotes if they are not in the default case

Bug Fixes

PostgreSQL function names not displaying in the database browser for certain PostgreSQL databases
DynamoDB: Errors occur if attributes are not present near the beginning of the table, but do have values later in the table
Query scheduler does not work with Salesforce
Generate SQL from query results with table name with a space not generating correct SQL
Salesforce - unable to query Case table due to SQL syntax error
Database Conversion: Boolean types getting converted to Oracle failing on insert

6.3.11

Changes

Mac 64-bit: Made changes to try to prevent RazorSQL from crashing and Window display issues caused by Karabiner keyboard customization software

Bug Fixes

Export tool throws an error when exporting HSQLDB blob columns
Query results does not show HSQLDB blob columns in hex format

6.3.10

Bug Fixes

SQLite: Copy to Another Database. Table name not getting set to the new table name if a new table name is entered
Mac 64-bit Version: Crashing issues on some machines

6.3.9

Enhancements

Added ability to load binary data from a file via an insert statement with the razorsql_load_binary syntax insert into test_table values (1, razorsql_load_binary('C:\test.png'));
File System Browser search now prints out files results were found in
File System Browser search should search sub-directories
Added ability to delete inserts
Added ability to delete macros

Changes

Describe Table Window should be resizable

Bug Fixes

Home / End keys do not work in dialog text areas
SQLite: binary data editor sometimes throws errors
Drop database window has incorrect title
FTP Transfer window not showing file sizes correctly for very large files
Sybase: exec statements not always displaying results for all result sets returned by procedure
DynamoDB: querying binary columns throws error
Unable to create a connection using the RazorSQL JDBC Bridge with the "Other" database type
SimpleDB: when itemName is a column in the column list, the itemName column is not being populated
Sizing issues on Command Line Call Generator window

6.3.8

Enhancements

Added PostgreSQL materialized view support
Added support for creating projects and interacting with projects via a tab on the file system browser
Enhanced materialized view options on the database browser for Oracle
Added an option to print line numbers when printing via the web browser option

Changes

Expansion of materialized view node in database browser now shows view columns

Bug Fixes

DynamoDB: All columns not always displaying in select * queries
PostgreSQL Database browser not differentiating among overloaded functions

6.3.7

Enhancements

Salesforce: Added copy to local database option for Salesforce tables
Added Copy File Path option to File System Browser

Changes

Import Tool: Create table from import - table names converted to default case for the database
Limit size of table references window in query builder to prevent window from going off screen
If there is an @ sign in table - wrap in quotes

Bug Fixes

Database Conversion: Oracle to H2 and H2 to Oracle conversion files missing
Import Tool: Create table from SQL inserts - generated column names sometimes have spaces

6.3.6

Enhancements

DynamoDB: Added ability to force a query or scan operation using the select_query or select_scan syntax instead of just select select_query * from employee where id = 1
DynamoDB: Added ability to specify an index to use for a query operation using a query hint select_query /*index_name*/ * from table_name where . . .
DynamoDB: Enhanced logic to determine when to execute a query request and when to execute a scan request when query or scan is not indicated in select query
DynamoDB: added support for in clauses in SQL statements
DynamoDB: Import Tool: Added a checkbox for skipping columns / attributes in generated inserts when the value is null / empty
Added ability to set connection properties when using the MS SQL Server JDBC driver from Microsoft

Changes

DynamoDB: support beginning comments in queries
DynamoDB: A non-descriptive error is thrown when referencing an attribute in an SQL statement that does not exist in the table
If SQL Server jtds connection fails for SSL reasons, and MS SQL Server driver is installed, try connecting with the SQL Server driver
Changed the formatting of the query error text to handle line wrapping better
Faster scroll speed on Explain Plan window

Bug Fixes

If result columns are moved and put back in the same place - results editor throws error preventing changes due to columns being re-arranged
PostgreSQL: editing views taking a long time in certain situations
Query Builder: add table button window appearing behind the query builder on Mac
Query results edit table button not always appearing for supported queries when the queries have comments in them

6.3.5

Enhancements

Filter Query Results Tool: Added options for matching any column in a row with equals, contains, or in operations
Import Tool - If column names included on first line of delimited file or excel spreadsheet, try to populate column number field based on order of column names
Command Line Export Tool: Added multi-value insert syntax option for supported databases
Command Line Backup Table Tool: Added multi-value insert syntax option
Command Line Backup Table Tool: Added included identity column insert option
Command Line Backup Schema Tool: Added multi-value insert syntax option
Command Line Backup Schema Tool: Added included identity column insert option

Changes

Changed process for getting PostgreSQL type information to improve performance
No longer display keep-alive errors for SQLite

Bug Fixes

Database Browser: Informix tables and views not always getting sorted in the correct order
DyanmoDB: Generate DDL tool not generating column types when tables have both hash and range keys
DynamoDB inserts against tables with more than one global secondary index throwing errors
DynamoDB describe table not showing all global secondary indexes

6.3.4

Enhancements

Added H2 database conversion support to and from HSQLDB, MySQL, Oracle, SQLite, MS SQL Server, PostgreSQL, and MS Access
Added MonetDB support

Changes

When closing RazorSQL with unsaved files, added a cancel option to the Yes/No save dialog
New session window no longer required mouse to navigate
Changed memory settings on Mac OS X 64-bit version

Bug Fixes

DynamoDB select count(*) queries with where clauses - where clauses getting ignored
Percent of original size field not showing correct values in zip file viewer

6.3.3

Enhancements

DynamoDB: Add global secondary indexes and local secondary indexes to the describe tool
DynamoDB: Add global secondary indexes and local secondary indexes color indicator to the database browser
DynamoDB: Upgraded to latest AWS libraries
Increased launching performance of edit table tool
Increased launching performance of alter table tool

Changes

Execute Procedure Tool: For Oracle, now supports REF CURSOR as an IN OUT parameter if no value is set for the REF CURSOR as an IN param

Bug Fixes

DynamoDB - does not support tables with dashes in the name
DynamoDB: tables with global secondary indexes not showing key information
DynamoDB: describe tool not showing information for tables with global secondary indexes
DynamoDB: Tables with no rows not showing columns in the database browser
DyanmoDB: Unpopulated index columns not showing as columns in database browser
Read only version does not allow to change databases

6.3.2

Enhancements

Added MariaDB support
Added the Oracle 12c JDBC drivers

Bug Fixes

Dynamodb - Export with generate DDL not working for tables with periods in the name

6.3.1

Enhancements

Added close all query results option to right-click menu of query results tab
SQLite: Enabled foreign key support by default for new connections
SSH Client: Added ability to enter separate passphrase for private key file
SSH Tunnel Tool: Added ability to specify a pass phrase for a private key file
Added a MariaDB driver option to the MySQL connection type options
Ship with MariaDB drivers

Bug Fixes

Database Conversion: converting boolean true or false values to SQLite not getting generated with proper syntax
DynamoDB: Tables with dots in the name not supported for certain operations
Next Tab and Previous Tab options not working correctly on Mac
If query results column names are rearranged, and column names and results are copied to the clipboard, the column names are not in the correct order

6.3.0

Enhancements

Added support for the Cassandra database
Added an Edit -> Delete Lines Containing option
Salesforce: Added the ability to connect to a Salesforce sandbox environment
Function Navigator / Function Selector: Now shows both procedures and functions in Oracle PL/SQL packages
Query Scheduler: Added option to set start time in seconds from current time
Query Scheduler: Added option to set the title of the query scheduler window
Query Scheduler: Added option to determine whether to overwrite or append to the output file if it already exists
Query Scheduler: Added option to load query text from a file
Query Scheduler: Added option to load query text from the SQL favorites list
Query Scheduler: Added file name, interval, executions, and query to status field of query scheduler window

Changes

Continue should be the default button on the Add Connection Wizard screen
Added additional error notifications for the Export tool
If a maximum rows value is set in the preferences, that value will get set on the JDBC driver's statement object for each query

Bug Fixes

Salesforce: Using TableName.ColumnName syntax in queries returns null values
Salesforce: Relationship queries using join tables via dot notation columns (example: Contact.Account.Name) returning null values for columns from the joined tables
Salesforce queries not always returning rows above initial salesforce request limits
Mac 64-bit: Various focus issues where windows / dialogs are not getting focus when appearing

6.2.6

Bug Fixes

Connection to Salesforce not working since previous release
SQL Server / Sybase: Calculated results in select clauses can return 0.0 instead of null

6.2.5

Enhancements

Added Retina Display support for Mac 64-bit version
Query Results - added row count display for query results for queries executed without using the fetch all rows option if all rows have been retrieved from the query

Changes

Database Browser - added logic to always trim spaces from tables for databases where table are retrieved from the driver as opposed to executing system queries
FTP Connection Window - mouse click no longer needed to connect
Changed default font on Mac 64-bit versions to enable bold in default Monaco font

Bug Fixes

Execute SQL Fetch All Rows option displays extra blank row in the query results after the last row

6.2.4

Enhancements

Added auto download and install option for the MS SQL Server driver for SQL Server and SQL Azure
Added razorsql_portable.exe to the Windows version for launching a self-contained version of RazorSQL that does not store data outside of its directory structure

Changes

Upgraded JRE to version 1.7.0_45 on Windows and Linux versions
Upgraded DejuVu Sans Mono fonts to the latest versions
Made MS SQL Driver the default driver for SQL Azure

Bug Fixes

SQL Server and Sybase - Large numbers being rounded when returned in scientfic notation from the driver

6.2.3

Enhancements

Added a fetch all rows button to the query results toolbar and a fetch all rows option to the results menu for fetching any remaining rows not yet retrieved from a database query
Added a Connections -> Change Current Database / Schema menu option

Changes

Typing enter in query results search field now executes search
The escape key was not closing certain dialog windows
Certain numbers being converted to scientific notation in MS SQL Server and Sybase are now displayed in decimal
Focus in query results menu item no longer sets selection to first cell in results if a cell is already selected
Next Word, Previous Word, Select Next Word, Select Previous Word, Delete Word, and Backspace Word menu items / shortcuts no longer considers underscore as word separators

Bug Fixes

Informix Generate DDL - create table DDL for int8 columns are getting generated with sizes

6.2.2

Changes

Upgraded SQLite JDBC driver version - added support for wal databases

Bug Fixes

For certain multi-monitor display configurations, the max window size of RazorSQL is getting set to the primary display maximum resolution
SQL -> Execute SQL Output to File option throwing error
Derby Network databases - Auto download - both the derby.jar and derbyclient.jar files need included in the driver location field

6.2.1

Enhancements

Added XML and HTML as format options in the command line export tool
Added Add Query to SQL Favorites option to right-click menu on query results tab

Bug Fixes

Errors connecting to Salesforce not giving detailed error information

6.2.0

Enhancements

Added support for Salesforce
Added support for HSQLDB 2.3
Added menu item to query results tab for Copy Results to Clipboard (No Column Names)
DB2 LUW: Added ability to specify connection properties when creating a connection
Teradata: Added ability to specify connection properties when creating a connection

Changes

Editor: Select to Begin of Line, Select to Begin of Paragraph, and Select to Begin of Document options not setting cursor position to the beginning of the selection
Upgraded SSH library - new encryption algorithms supported
DynamoDB - Backup, export, and generate insert tools no longer include column names and null values in insert statements for columns that have no value in the table
Changed behavior of SQL editor when executing queries and the last statement in the editor is missing the statement delimiter

Bug Fixes

DynamoDB: Not all tables are being returned in database navigator for databases with large numbers tables

6.1.7

Enhancements

Added Show Distinct Values in Column option to the Column Name header of the query results table
Added Generate In Clause for Selected Cells option to right-click menu of query results cells and query results tab
Database conversion menu now enabled for all database types - non-supported databases can now be converted to either HSQLDB or the Local Database
Improved performance of Connect / Add Connection window load time

Changes

When clicking on a query results tab, the status component text is updated to display the query time for the query executed on that tab
Added column selection mode indicator to editor status panel

Bug Fixes

Derby: Edit table tool not working when trying to edit query results and using lowercase table names in the select
The Insert Text At Column dialog does not allow you to insert only spaces

6.1.6

Changes

Enhanced parameterized query parser to work better with non-select statements such as inserts, updates, and deletes and enhanced parser to work better with operators and special characters
Mac OS X 64-bit: Updated included JRE to latest build that contains fixes for certain freezing issues
Changed how RazorSQL exits so that it gives open connections a longer time to close before exiting

Bug Fixes

Export Tool: SQL Server: date format not working for date column when using the jTDS driver
Export Tool: When a custom date format is requested, date columns in formats other than the default are not getting converted
Export Tool: Export as Text - inserting a blank line in results in certain situations

6.1.5

Changes

SimpleDB - More detailed error messages when incorrect select SQL syntax is used
Mac 64-bit version: Change configuration for graphics hardware acceleration

Bug Fixes

Execute Procedure Tool: Does not support datetime types for SQL Server and Sybase
DDL Generator - Alter Table syntax - foreign keys that reference multi-column primary keys are not getting combined into one alter table statement
Clicking on certain menus causing currently selected tab to change in certain situations

6.1.4

Enhancements

Added installation of Desktop shortcut to Linux distributions that support it

Bug Fixes

DynamoDB: Connections always pointing to default US-East region
Mac OS X 64-bit - Upgraded runtime environment that includes fixes for crashing issues on certain machines

6.1.3

Bug Fixes

Fix for MongoDB SQL parsing but introduced in version 6.1.1
Fix for MongoDB database data search bug introduced in version 6.1.1

6.1.2

Enhancements

SQL Azure: Added support for editing triggers and viewing trigger contents

Changes

PostgreSQL Database Browser: Automatically expand schemas when expanding the database node

Bug Fixes

Mac 64-bit version - Certain keyboard shortcuts using Shift such as next character, previous character, next line, previous line, next paragraph, and previous paragraph are executing twice for each keyboard event instead of once

6.1.1

Enhancements

Added SQL Create Table statement support for DynamoDB
Added support to generate Create Table statement DDL to DynamoDB database browser and DynamoDB backup and export tools
Added support for Derby 10.10

Changes

For SQL Server and Sybase schemas node automatically expands when database is expanded in database browser
Allow using time formatting options on Oracle dates in the query results

Bug Fixes

With dual monitors, Executing window and Find dialog window sometimes not showing on the correct monitor
View Menu custom keyboard shortcuts not always working in certain situations
When executing a long running query, and switch to another tab, and the first query finishes, the currently selected tab gets updated with the query results
Windows 7 and newer taskbar pinning of RazorSQL not using Windows standard behavior
In certain situations, the entire view definition is not being returned when generating SQL Server View DDL
Keyboard focus actions do not work on the add connection / connect window when the window is launched from an already connected tab
DynamoDB - SQL statements not handling columns with spaces correctly
DB2 for Mainframes database data search throwing error on SQL generated by the data search tool
Fixed certain crashing scenarios on Mac 64-bit only version for Lion and Mt. Lion

6.1.0

Enhancements

Added support for Amazon DynamoDB
Added ability to change look and feel to different color themes
PostgreSQL: Added the ability to view output from functions such as RAISE NOTICE statements
Database Navigator: Increased speed of initial load for MS Access
Added a preference for whether to strip comments from queries
Added a View -> Reset Display Sizes to Default option
Added an option to reset all preferences to defaults (Edit - Reset Preferences)

Changes

Changed behavior of when a new tab is created and when the current tab is loaded when opening files
Query Builder: if percent symbols not entered by the user for LIKE and NOT LIKE operators, value is automatically wrapped in percent symbols by RazorSQL
Increased frequency of how often SQL history is written to disk
SQL Server: Stop filtering db_owner schema from database browser
Updated PostgreSQL JDBC driver that ships with RazorSQL
Updated Jsch SFTP library to the latest version
Max Rows per Query for SimpleDB and DynamoDB is now a required field when adding a connection profile

6.0.7

Enhancements

PostgreSQL Backup and Export Table tools - Now generate create sequence statements prior to the create table statements if a column references a sequence
PostgreSQL Backup and Export tools - added option for whether to include serial columns in generated insert statements
Added ability to view print output for Sybase SQL Anywhere and Sybase IQ
Auto-detect certain statement separators for the Import from SQL file and Execute SQL script processes

Changes

Made database name a required field when creating new PostgreSQL connections

Bugs

PostgreSQL Export / Backup Tools - Not generating DDL for serial columns correctly
Edit Table Tool - When text has line breaks, text is getting formatted incorrectly in popup window
Using keyboard shortcut with Shift on Mac causes action to occur twice in some instances

6.0.6

Enhancements

MS SQL Server - Added a backup database tool
Added a Execute All Statements - Fetch All Rows option
Added Informix PAM authentication support
Added a preference for whether to display the Executing window during query execution
Added an executable to launch RazorSQL in read-only mode on Windows
Added options for launching RazorSQL with graphics acceleration turned off for Windows and Mac.

Changes

Remember the Match Case setting on Find / Replace in Files

Bugs

MySQL Database Browser: Users without show databases permission not getting a categorized list of databases
Installation missing the SQL Server ASP bridge file
Edit 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

6.0.5

Enhancements

Added Copy Table to Another Database option in the DB Tools menu and on the database browser context menu
Added a Run on Local Server option in the Tools -> HTML menu

Bugs

PostgreSQL Binary Data Editor not launching for tables in the public schema

6.0.4

Enhancements

Added create schema tools for H2, HSQLDB, Derby, and PostgreSQL
Command Line Tool: Added an option to specify an import file start row on the import command
Command Line Tool: Added a fetch size override parameter to the export command
Added a schema selection dropdown to the main toolbar for H2 database connections

Changes

Updated included PostgreSQL JDBC driver to the latest version
For SQL Server and Sybase, multiple result sets can now be automatically displayed without using the "Fetch All Rows" execution option if the first result set returned contains fewer than the "fetch size" number of rows
Updated graphics runtime environment for Windows, Mac, and Linux versions

Bugs

Try to export more than 65536 rows in XLS format, hangs
Using very large fonts in the navigator causes letters to get cut off
HSQLDB: Explain plan not working for newer versions of HSQLDB
Fix for potential stability issues for certain Mac OS X 64-bit machines

6.0.3

Changes

Edit table tool cells now adjust margins with font size increases
Sybase IQ - default result set holdability changed to forward only

Bugs

Convert query results to local database, if a local schema name is entered, results conversion throwing error

6.0.2

Enhancements

Added ability to connect via private key file for SSH tunnels
Added ability to connect via private key files for the SFTP client
Included MySQL sample database in templates
Added ability to add connection properties to Sybase JConnect driver
Import tool tries to automatically recognize if the first row of the import file contains column names and sets the value for the first row field accordingly

Changes

Database Navigator: Enabled the edit option on the database navigator context menu for views
Database Navigator: Changed the query used to get Sybase databases
Execute SQL Script - If query is empty, do not attempt to execute it
When selecting from template, put cursor position back at the beginning of the insert
More help error message for Sybase optimizer errors when in read uncommitted mode

Bugs

Firebird: Smart commit option not working correctly
Oracle CLOB Editor - requiring table case to be upper-case in order for clob editing to work
FTP / SFTP Client - List of FTP sites does not scroll or get bigger
Oracle Database Conversion via ODBC driver throwing errors when data type is of type decimal
Database Converter: MYSQL bit data type throws error during conversion
Database Converter: MS Access to PostgreSQL conversions using double instead of float8
Database Converter - Tables and columns with spaces in insert statements not getting formatted correctly when converting from databases with different formatting rules
MySQL generate index ddl and index show info not always factoring in the table the index is assoicated with. Causes problems when a database has multiple indexes with the same name

6.0.1

Enhancements

Import Tool: Add ability to save import settings for reusable import operations
Export Tool: Add ability to save export settings for reusable export operations
Export Tool: Add an option to open the exported file after the export is complete
SQL Editor: Add a "Open file after complete" option to the Execute SQL -> Output to file option
Connection Wizard: Give ability to add Oracle connection properties
Command Line Export: Give option to pass in database password override on the command line interface for the import, export, execute, backup table, and backup commands
General: Added keyboard shortcuts and options to the Window menu for moving between query results tabs

Changes

Netezza - Limit open cursors to one per connection
Change colors for edited, inserted, and deleted rows on edit table tool so they are no so bright

Bugs

SQL Editor: Auto-complete not working for certain multi-table joins
SQL Editor: Code -> Line Comment option not generating correct comment syntax when connected to MySQL
SQL Editor: Text - To Upper and To Lower - if null is highlighted everything gets capitalized instead of just null
Sybase: Sybase - when using aliases in a stored procedure that executes a select statement, the query results are displaying the actual column names and not the aliases
SQL Server edit function tool changing create to alter in certain situations when it should not be
Title on create table from results window not correct
Radio buttons on create table from results not mutually exclusive
FTP download/upload progress not shown correctly when transferring large amounts of data
Query Results: Generate SQL Updates - if multiple tables with the same name across schemas / databases, sometimes clauses get duplicated in generated SQL

6.0.0

Enhancements

Database Conversion: Added database conversion tools for converting the following types of databases: HSQLDB, MS Access, MS SQL Server, MySQL, Oracle, PostgreSQL, SQLite
Database Conversion: Added the ability to convert tables from the following database types to the RazorSQL local database: DB2, Derby, Informix, MongoDB, MS Access, MS SQL Server, MySQL, Oracle, PostgreSQL, SimpleDB, SQLite, Sybase
Database Conversion: Added Copy to Local Database option for copying tables from remote dbs to the local RazorSQL database
Added a Create Table from Results Option for creating a table from query results
Added a Create Local Table from Results for creating a local table from query results on a remote database
Added a Create Table from Results option for converting the query results to a table on another database
Added Query Referenced Table option to query results for foreign key columns
Add ability to view images - open an image file and display it
Added Search -> Goto Column option for the SQL editor
Added option to not include column names in output for Execute SQL - output to file
Added Insert - Insert from File option to the Inserts menu
For parameterized queries, add option for automatically wrapping character data in single quotes
Added an option for viewing a status log for each connection that includes queries executed, query times, and rows returned
Added 10 to Fetch Limit Rows option
Added Editor Backups option to the preferences for backing up files on save
Added binary data editing and image viewing with the SQLite JDBC Driver
Added support for binary data editing to the RazorSQL SQLite Driver
Ship with SQLite JDBC driver
SQLite - Auto expand navigator to show Tables, Views, etc.
Allow to change auto commit on the toolbar
Add SSH tunnel support for MongoDB
Added SQL favorites selector shortcut
Added a timeout for how long results / statements will stay open and added a preference for it
Added support for Derby 10.9
Add full screen mode on OS X Lion and Mountain Lion
Better auto-completion support for certain join types
Added a 64-bit only RazorSQL download for Windows
Better memory handling for SimpleDB queries with large result sets
Added Consolas as a fixed-width font
Recognize reserved words in generated SQL, including database specific reserved words
Added additional information to error messages displayed when queries or statements thrown an error

Changes

Database Browser: Change firebird query for retrieving sequences
Sybase: make sure result sets are always read-only
Query log, don't store queries in memory, store them in a file
SQL history, just log to file, on exit, trim the file down to the size requested by the user
Import Tool: Handle importing date columns from Excel to Oracle
Import Tool: Handle importing timestamps from Excel to Oracle
Import Tool: Delimited File Import - Now accepts the following date formats for Oracle: MM/DD/YYYY YYYY-MM-DD
Remove Execute Batch option for SimpleDB since it is not currently supported
Make View JSON for row and Edit JSON for row windows for MongoDB resizable
Can now recognize more often when an Access table has a primary key
Create Table Tool: Changed sytnax when creating an MS Access table that has a primary key
For the SQLite JDBC driver, when there is a syntax error, the error message is not helpful
Access: Generate DDL Not generating Primary key even if it is defined
Upgrade version of SQLite shipping with RazorSQL
Added transaction isolation setting to the create connection profile process
Changed default transaction isolation to read uncommitted for DB2, MS SQL Server, and Sybase
When editing table results or query results, when the cell in table is clicked on for editing, the font used is not the font set on the table
Don't ship with any Derby drivers. Don't pre-select any versions. Add all Derby drivers to the auto-download option
Change RazorSQL local data storage directory location on Mac and Windows to align with standards for each OS
Update JRE to version 1.7 for the Windows versions
View row in column mode is now resizable
Added more tips of the day
Increase max memory on Mac and 32-bit Windows versions

Bugs

PHP Classes syntax highlighting issue
HttpUtil: Need to also set httpsProxyHost and httpsProxyPort
SQL Server - Tools like Copy Table, etc. that take build catalog, schemas, tables selection box only include schemas from the currently selected database
PostgreSQL: Backup tools - Not pulling in PostgreSQL catalog to information schema queries causing RazorSQL to go to the driver to get type information
MongoDB: Clicking the Edit option on the database navigator on the non-default database throws an error
Mysql: Data getting converted to Hex that should not be:
Oracle FLOAT data type size getting generated as 0 in the generate DDL tool
When checking for identity in Export tool, sometimes throwing error
SQL Server rename column - if column name or table name has spaces, should not be wrapping in quotes
When doing an auto-complete / auto-lookup in HSQLDB, MySQL, and Derby, not factoring in the Schema
Trim Spaces option being ignored on the command line export client
MySQL, H2, HSQLDB - If multiple tables with the same name in various databases / schemas clicking to edit the table in the query results may throw an error
If you drag columns around in the query view window and do an edit, the generated SQL references the incorrect columns
Connect to a database, hit the connect button, click on the Add Connection Profile tab, click continue, can't put cursor in any of the fields

5.6.4

Enhancements

Added support for Mac retina displays
Added support for MongoDB slaveOK command

Changes

Added Gatekeeper signing for Mac OS X Lion
Updated H2 driver

Bugs

Auto-complete shortcut not working in certain situations
Amazon SimpleDB: Some unicode characters not accepted via SQL insert and update statements

RazorSQL

Query, Edit, Browse, and Manage Databases

RazorSQL Updates / Change Log

Enhancements

Changes

Enhancements

Changes

Bug Fixes

Enhancements

Changes

Bug Fixes

Changes

Changes

Bug Fixes

Changes

Bug Fixes

Changes

Changes

Bug Fixes

Enhancements

Bug Fixes

Bug Fixes

Enhancements

Changes

Bug Fixes

Enhancements

Changes

Changes

Bug Fixes

Bug Fixes

Enhancements

Bug Fixes

Bug Fixes

Changes

Bug Fixes

Enhancements

Changes

Bug Fixes

Enhancements

Changes

Enhancements

Changes

Bug Fixes

Enhancements

Changes

Bug Fixes

Enhancements

Changes

Bug Fixes

Enhancements

Changes

Bug Fixes

Enhancements

Changes

Bug Fixes

Enhancements

Changes

Bug Fixes

Enhancements

Changes

Changes

Bug Fixes

Enhancements

Bug Fixes

Enhancements

Changes

Bug Fixes

Enhancements

Changes

Bug Fixes

Enhancements

Changes

Bug Fixes

Enhancements

Bug Fixes

Changes

Bug Fixes

Enhancements

Changes

Bug Fixes