RazorSQL Updates / Change Log

The latest version of RazorSQL is 7.3.14

7.3.14 Change Log (Released 11/16/2017)

7.3.13 Change Log (Released 11/01/2017)

7.3.12 Change Log (Released 10/22/2017)

7.3.11 Change Log (Released 10/20/2017)

7.3.10 Change Log (Released 10/17/2017)

7.3.9 Change Log (Released 10/11/2017)

7.3.8 Change Log (Released 09/28/2017)

7.3.7 Change Log (Released 09/21/2017)

7.3.6 Change Log (Released 09/12/2017)

7.3.5 Change Log (Released 09/05/2017)

7.3.4 Change Log (Released 08/30/2017)

7.3.3 Change Log (Released 08/15/2017)

7.3.2 Change Log (Released 08/01/2017)

7.3.1 Change Log (Released 07/18/2017)

7.3.0 Change Log (Released 06/13/2017)

7.2.6 Change Log (Released 05/08/2017)

7.2.5 Change Log (Released 04/10/2017)

7.2.4 Change Log (Released 03/22/2017)

7.2.3 Change Log (Released 02/07/2017)

7.2.2 Change Log (Released 01/18/2017)

7.2.1 Change Log (Released 01/04/2017)

7.2.0 Change Log (Released 12/15/2016)

7.1.4 Change Log (Released 12/2/2016)

7.1.3 Change Log (Released 11/23/2016)

7.1.2 Change Log (Released 11/20/2016)

7.1.1 Change Log (Released 11/01/2016)

7.1.0 Change Log (Released 10/25/2016)

7.0.9 Change Log (Released 10/10/2016)

7.0.8 Change Log (Released 10/05/2016)

7.0.7 Change Log (Released 09/29/2016)

7.0.6 Change Log (Released 09/21/2016)

7.0.5 Change Log (Released 09/01/2016)

7.0.4 Change Log (Released 08/24/2016)

7.0.3 Change Log (Released 08/02/2016)

7.0.2 Change Log (Released 07/27/2016)

7.0.1 Change Log (Released 06/16/2016)

7.0 Change Log (Released 06/08/2016)

6.4.8 Change Log (Released 04/06/2016)

6.4.7 Change Log (Released 03/11/2016)

6.4.6 Change Log (Released 03/01/2016)

6.4.5 Change Log (Released 02/19/2016)

6.4.4 Change Log (Released 02/04/2016)

6.4.3 Change Log (Released 01/26/2016)

6.4.2 Change Log (Released 01/14/2016)

6.4.1 Change Log (Released 12/15/2015)

6.4.0 Change Log (Released 11/23/2015)

6.3.29 Change Log (Released 10/22/2015)

6.3.28 Change Log (Released 09/30/2015)

6.3.27 Change Log (Released 09/14/2015)

6.3.26 Change Log (Released 07/30/2015)

6.3.25 Change Log (Released 07/21/2015)

6.3.24 Change Log (Released 05/28/2015)

6.3.23 Change Log (Released 05/11/2015)

6.3.22 Change Log (Released 04/27/2015)

6.3.21 Change Log (Released 04/13/2015)

6.3.20 Change Log (Released 04/01/2015)

6.3.19 Change Log (Released 03/18/2015)

6.3.18 Change Log (Released 03/04/2015)

6.3.17 Change Log (Released 02/10/2015)

6.3.16 Change Log (Released 12/16/2014)

6.3.15 Change Log (Released 12/02/2014)

6.3.14 Change Log (Released 11/03/2014)

6.3.13 Change Log (Released 10/20/2014)

6.3.12 Change Log (Released 09/23/2014)

6.3.11 Change Log (Released 08/27/2014)

6.3.10 Change Log (Released 08/20/2014)

6.3.9 Change Log (Released 07/29/2014)

6.3.8 Change Log (Released 07/02/2014)

6.3.7 Change Log (Released 06/10/2014)

6.3.6 Change Log (Released 05/22/2014)

6.3.5 Change Log (Released 04/29/2014)

6.3.4 Change Log (Released 04/01/2014)

6.3.3 Change Log (Released 02/25/2014)

6.3.2 Change Log (Released 02/10/2014)

6.3.1 Change Log (Released 02/05/2014)

6.3.0 Change Log (Released 01/15/2014)

6.2.6 Change Log (Released 12/09/2013)

6.2.5 Change Log (Released 12/05/2013)

6.2.4 Change Log (Released 11/20/2013)

6.2.3 Change Log (Released 10/23/2013)

6.2.2 Change Log (Released 09/25/2013)

6.2.1 Change Log (Released 09/12/2013)

6.2.0 Change Log (Released 09/11/2013)

6.1.7 Change Log (Released 08/05/2013)

6.1.6 Change Log (Released 07/23/2013)

6.1.5 Change Log (Released 07/17/2013)

6.1.4 Change Log (Released 07/05/2013)

6.1.3 Change Log (Released 07/03/2013)

6.1.2 Change Log (Released 07/02/2013)

6.1.1 Change Log (Released 07/01/2013)

6.1.0 Change Log (Released 06/03/2013)

6.0.7 Change Log (Released 04/04/2013)

6.0.6 Change Log (Released 03/21/2013)

6.0.5 Change Log (Released 03/01/2013)

6.0.4 Change Log (Released 02/23/2013)

6.0.3 Change Log (Released 01/30/2013)

6.0.2 Change Log (Released 01/16/2013)

6.0.1 Change Log (Released 12/04/2012)

6.0.0 Change Log (Released 10/09/2012)

5.6.4 Change Log (Released 07/15/2012)

Older Updates

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