Softpedia >Mac >Internet Utilities >SQuirrel SQL Client >  Changelog

SQuirrel SQL Client Changelog

What's new in SQuirrel SQL Client 3.7.1

May 9, 2016
  • ENHANCEMENTS:
  • Option to en/disable "Run all SQLs in editor function", see menu File --> Global Preferences --> tab SQL
  • Updated Polish translation. Thanks to Begina Felicysym.
  • #531 Bookmarks Plugin: In the general options of the bookmarks Plugin (see menu File --> Global Preferences --> tab Bookmarks) there is a new option "In ctrl+j popup use "contains" instead of "starts with" to filter entries".
  • Alias properties --> Tab Schemas --> Table is now sortable
  • Data import plugin: New option to choose if import is done in a single transaction or if data is committed after every N numbers of inserts, where N can be configured.
  • Foreign key references window now also produces a result for the root table of the references tree.
  • Current SQL mark: In the SQL editor if the caret placed inside an SQL such that this SQL could be executed using ctrl enter, this SQL is now marked by a blue box. The feature can be switched off or the color of the box can be changed at menu File --> Global Preferences --> Tab "SQL" --> Section "General"
  • New global preference "In quotes functions should copy quoted SQLs to clipboard", see menu File --> Global Preferences --> Tab "SQL" --> Section "General". Note: With this change the "Edit Extras"-Plugin was removed. All its functions are now part of SQuirreL's core. The change doesn't effect the usage of the functions involved in the change. SQuirreL will not load the "Edit Extras"-Plugin anymore.
  • Updated Polish translation. Thanks to Begina Felicysym.
  • Syntax plugin: Last five find strings are now saved and can be selected from the drop down of the find and replace dialog.
  • Format SQL has three new options, see menu File -> Global Preferences -> Tab SQL formatting:
  • Indent sections check box
  • Comma placing radio buttons
  • When AND/OR keywords occur in FROM clauses you can choose to ignore the start new line setting. This may be considered to lead to more readable JOIN clauses.
  • BUG FIXES:
  • #963 Stored Procedures are not shown in object tree (reported of Informix DB)
  • #1245 SQL Script Plugin: Table script creation failed when a column type could not be derived from a Hibernate dialect. This problem was probable to occur for user defined types e.g. when domains were used by Postgresql.
  • Quoting columns didn't work as in other script generation functions when SELECT statements were created (see Object tree's right mouse menu).
  • #1235 Netezza Plugin: Squirrel not showing Netezza (IBM Puredata) synonyms
  • Fixed bug in "Copy as SQL INSERT-VALUES statement" option: Closing brackets could be lost when timestamp was generated.
  • #1241 Switching tab using Alt Left/Right doesn't work right after tabs were moved using drag and drop
  • For the DB2 data types "FOR BIT DATA", GRAPHIC and VARGRAPHIC the "Store result of SQL in table" function did not create the correct "CREATE TABLE" script.
  • Concerning result output as text: Replace null string character (0x00) with SPACE char, as this character cannot be copied to clipboard and data after this null char are not copied. This fix also replace FF form feed character (0x0C) with SPACE char, as FF character is causing problem when text data are pasted into advanced text editor like Ultraedit, it creates unexpected new lines.
  • Some options in New Session Properties (abort on error, write sql errors to log file) are not saved after Squirrel restart.
  • Milliseconds are lost when you copy timestamp value via "Copy as SQL INSERT-VALUES statement" option.
  • #1240 Data import plugin: When exception occured auto commit mode was usually changed.
  • #1237 Missing color on SQL window and Object tree window
  • #1236 Shortcut for comment/uncomment current line (ctrl + "/") does not work. Fixed according to the suggestion in the bug #1236. Please note: The orginal comment/uncomment hot key of SQuirreL is ctrl+Numpad minus / ctrl+shift+Numpad minus.
  • Current SQL Mark was shown in Object tree find field.
  • #1226 Reconnect didn't work when Session toolbar was configured to be not shown. See menu "File" --> "New Session Properties" --> Tab "General" and check the "Show toolbar" check box.
  • Object tree: Contents tab loading raised ClassCastException when table contents where viewed as text output.
  • NullPointerException occurred when the "Show foreign key references" right mouse menu item of an SQL result table was clicked.
  • Improved logging and handling of "Content" tab display in "Objects" tab with the aim of tracking/preventing:
  • If an SQL to load the content tab fails, the complete SQL string ist written to the logs
  • "SELECT * ..." statement is issued as last fallback.
  • Improvements:
  • UI is resizeable
  • Better error messages

New in SQuirrel SQL Client 3.7.0 (Jan 12, 2016)

  • ENHANCEMENTS:
  • Feature request #521 Alias name in SQL History search dialog.
  • Upgraded to latest RSyntax version (2.5.6):
  • The new version has a clipboard history which is accessible through ctrl shift v.
  • A little drawback of the new version is that background colors are not supported in syntax styles.
  • Feature request #485 Execute multiple SQL statements on one click without selection:
  • The new feature executes all SQLs in the editor.
  • If there are multiple SQLs in the editor the statement separator has to be used.
  • The feature is accessible through a new tool bar button, tools popup and the alt shift ENTER key combination
  • Feature request #484 Query output preferences --> Allow table and text output simultaneously:
  • Note: SQL result output as table or editable table now includes text output in an extra tab.
  • That's why there should be only few cases where choosing text output in Session Properties makes sense anymore.
  • Feature request #479 Add option for tab names to contain only Alias name:
  • The option can be found at menu File --> Global Preferences --> Tab General --> Bottom of section Appearance
  • Feature request #487 Show AS label as column header (if present):
  • If a SQL result contains at least one column whose column name is not equal to its column label a button is shown at the header of the tab named "Result".
  • By this button one can toggle display between column names and labels.
  • Note: To configure the default display see menu File -> Global Preferences -> Tab Data Type Controls -> Top of panel.
  • WIKI table Plugin: Added support for JIRA/Confluence Markup Style. Thanks to Thomas Hackel for the merge request.
  • Feature request #501 Overview/Charts Tab: Distinct Counts:
  • Distinct counts for an Overview as a whole are now displayed right next to the column name
  • Distinct counts of Intervals are available as tool tips
  • as well as a new details window which is accessible through the right mouse menu
  • Sybase dialect support when using jtds. Thanks to Sumit Agarwal for the merge request.
  • On Mac OS X the SQuirreL now uses the acorn icon instead of the default java coffee cup icon. Thanks to Martin W. Kirst for the merge request.
  • New command line parameter:
  • Short form: -detectEDT
  • Long form: --detect-long-running-swing-edt-events
  • The parameter has no arguments.
  • The parameter enables SQuirreL to detect long running Swing Event Dispatch Thread events.
  • When the dispatch thread is blocked for longer than two seconds a warning containing a thread dump is written to the logs.
  • Upgraded to the latest RSyntax version (2.5.3).
  • Syntax Plugin: Made background color for white spaces affect the whole SQL editors background, see menu File --> New Session Properties --> tab Syntax:
  • Note: If you combine this feature with the Metal-Charcoal Look and Feel you can make SQuirreL appear in "fashionable" black. Thanks to Duane Redfern for the patch.
  • When adjusting table column widths a maximum width may now be defined. See menu File --> Global Preferences --> Tab General --> right column
  • Speeded up reading and writing Alias properties. As result opening and closing a connections will be much faster for big, complicated databases. Thanks to Jaroslaw Jarmolowicz for the patch
  • Starting and stopping SQuirreL is much faster for big, complicated databases. Thanks to Jaroslaw Jarmolowicz for the patch
  • Postgres Plugin:
  • - For postgres query plans explain was used which is less accurate than explain analyze so it was changed to use it instead.
  • - Previous implementation had limitation of producing query plans only for SELECT queries. It was changed so query plan can work for every type of query.
  • - Query plan executions are wrapped in transaction so they don't change database state. Thanks to Jaroslaw Jarmolowicz for the patch
  • BUG FIXES:
  • #1185 The example URL for MariaDB is wrong
  • Unfortunately the change will only take effect for new installations.
  • #1191 Remove Newlines Hotkey not working for several versions
  • #1206 SQuirrel detects single line comment inside string literals
  • #1210 Empty Contents Tab in SQuirreL when Column-Names contain dashes (except HSQL-DB)
  • #1212 Selected catalog is not the catalog that is shown in combo box after reconnect.
  • #1216 PostgreSQL: Content tab doesn't display data when quoting column names is necessary
  • The overview- and rotated table- tabs broke when more results where read.
  • DBDiff Plugin: Loading of the DBDiff Object tree menus failed when an Object tree window was opened.
  • #1161 Sorting Aliases creates duplicate entries in the tree view
  • After sorting Aliases in the view without tree, there were duplicate Alias entries in the tree view.
  • Note: If your Aliases got duplicated this way you may delete the SQLAliases23_treeStructure.xml file in your SQuirreL user dir. This way Aliases will be unique again but tree folder structure gets lost.
  • #1193 Wrong command for MySQL when renaming a column. The problem was a wrong preselection of the dialect for MySql5 DBs.
  • Hibernate Plugin: In menu File --> Global Preferences --> Tab Hibernate --> The "Details..." button in the lower part of the panel used to break with a NullPointerException when a directory of the Hibernate class path did not exist.
  • #1188 Help tree links don't work.
  • #1183 Empty Contents Tab in SQuirreL when Column-Names contain dashes.
  • This was because double quotes were missing around column names
  • #1177 Export results to xls fails for large exports that contain DATE columns. Thanks to Neville Rowe for the fix.
  • Tool bar of SQL Worksheet was doubled any time it was moved from between different frames.
  • #1174 PostgreSQL: create table script: wrong data type numeric
  • #618 SQLParam plugin asks for commented variable. Thanks to Michal Stekrt for the patch.
  • Postgres Plugin:
  • Postgres locks table was not displayed. Thanks to Jaroslaw Jarmolowicz for the patch
  • Look-and-Feel Plugin: JTattoo-AluminiumLookAndFeel was not available and logged an exception stack trace during start up.
  • SQuirreL used log an exception stack trace when 'Keep-Alive' was enabled in Alias properties but no SQL statement was entered. Now SQuirreL issues an understandable message. This concerns one discussion entry of bug #1162

New in SQuirrel SQL Client 3.6.0 (Oct 16, 2014)

  • ENHANCEMENTS :
  • Feature request #443 SQL results have new tab "Rotated table" where rows and columns are swapped.
  • Charts of SQL results: Plain x-y-charts of pairs of numeric columns can now be created.
  • Note: Charts make use of JFreeChart: http://www.jfree.org/jfreechart/)
  • New right mouse menu entry in SQL results: "Show foreign key references".
  • Select one or more cells of a SQL result then choose the right mouse menu to display the foreign references for the selected cells.
  • This function is also available in the right mouse menu of tables in the object tree.
  • SQL result --> Info tab: SQL is now displayed in text field instead of label. Formatting is preserved.
  • Check boxes to enable / disable navigation from the SQL editor to the object tree by Ctrl+B and Ctrl + mouse click.
  • See Menu File --> New Session Properties --> Tab SQL --> Section Jump to object tree
  • This will fix bug #982
  • Patch #66 New toolbar button to clone the current Session with a new connection.
  • The button is right next to the new SQL tab button.
  • Thanks to Jaroslaw Jarmolowicz for the patch
  • Patch #67 Session tab tooltip now shows the connections JDBC-URL.
  • Thanks to Jaroslaw Jarmolowicz for the patch
  • Patch #68 The "Copy as INSERT / UPDATE statement" functions now provide the right table name when copying from a content tab.
  • Thanks to Jaroslaw Jarmolowicz for the patch
  • BUG FIXES:
  • Fixed NullPointerException in data export that could occur when BLOB fields with NULL values were present.
  • #1157 Move line feature didn't work in sql editor
  • Rerun was not loaded into Session menu
  • Rerun did not work for result tabs outside of SQL panels.
  • Fixed NullPointerException during Session start when no Hibernate dialect is available for the Session's database connection.
  • Bug #1150 Exports to excel xls format not working in version 3.5.3
  • DB2 Plugin / bug #1097 DB2: don't display UDF source : SQL0206N "SCHEMA" is not valid in the context where it is used.
  • Thanks to Andy Helmer for the fix.
  • Data import Plugin / bug #1133: Now imports new Excel format *.xlsx
  • Patch #69 Postgres: Fixing problem with long running "getTypesInfo" on Postgres.
  • Thanks to Jaroslaw Jarmolowicz for the patch
  • Patch #70 Refactoring --> Dropping foreign key was generating wrong object names in SQL.
  • Thanks to Jaroslaw Jarmolowicz for the patch
  • Patch #71 Postgres: When a WHERE clause with UUID type is generated data is now enclosed in ''
  • Thanks to Jaroslaw Jarmolowicz for the patch

New in SQuirrel SQL Client 3.5.3 (May 12, 2014)

  • Enhancements:
  • #469 Show selected row count (like result row count)
  • #490 Continue offering MS Exel XLS (older file format) export.
  • Users can now choose between XLSX and XLS.
  • Bug fixes:
  • #1144 Error exporting null valued boolean/bit cols to XLS/XLSX
  • #1143 Error exporting null valued date cols to XLS/XLSX
  • Reintroduced compatibility with Java 1.6
  • #1137 ArrayIndexOutOfBoundsException when querying PostGIS geometry columns
  • #1129 Export table to XLSX does not work / #1129 Export table to XLSX does not work --> Export broke on null values
  • #1135 Export of date/time values to XLSX exports number instead of date
  • #1132 keyboard shortcut alt-down/alt-up not working

New in SQuirrel SQL Client 3.0.1 (Mar 24, 2009)

  • Enhancements:
  • New Korean translation available (Thanks to Youngwoo Kim)
  • Bug-Fixes:
  • OS X Look and Feel is Incorrect
  • Quotes missing in squirrel-sql.sh (Thanks to mdykierek for the patch)
  • Oracle create table script the "ON UPDATE" is wrong
  • "Contents Tab SQL filter" and "Limit cell edit WHERE clause size" dialogs didn't work
  • Other reported bug-fixes:
  • Fixed UI freeze issue which sometimes occurred when using software update feature.
  • Better support for PointBase 5.7
  • Fixed bug which caused NullPointerException in Refactoring when modifying column types
  • Fixed bug which occurred when generating FK SQL for DB2 where the update and delete action clause result in syntax error for certain standard constraint actions.
  • Fixed the case of the install directory (java -> Java) to match the case of the directory created by the installer.
  • NullPointerException occured when last tab was closed
  • Fixed several problems when Schemas where cached. For example, "Contents Tab SQL filter" and "Limit cell edit WHERE clause size" dialogs did not open.
  • Fixed a problem where when certain windows were closed (for example, the Session Properties window) the first tab was always selected

New in SQuirrel SQL Client 3.0.0 (Feb 24, 2009)

  • Enhancements:
  • Dataimport Plugin:
  • SuggestColumns: if columns in database and in the first line of the file are equal, they are matched for the import.
  • Sybase Plugin:
  • New ExceptionFormatter for SQLWarnings: better viewing warnings while the parameter showplan is on (set showplan on)
  • Look an Feel Plugin:
  • Made Nimbus look and feel available (needs at least JDK/JRE 1.6.0_10)
  • Made Metal look and feel with Ocean theme the default (used at first start up).
  • Added warning message that look and feels other than Metal may cause perfomance and/or functional problems
  • Updated Italian translation (Ivo Neri), Chinese translation (xpdz), French translation (Erwan Duroselle)
  • New user interface layout: Tabbed layout
  • Hibernate Plugin:Cleaned up details display in mapped objects tab: Now every tree node displays an appropriate details table.Added hint to solve StackOverflowError caused by logging that may occur when connecting to a Hibernate configuration.
  • Object tree search (Feature request 2004240): Above the Object tree is a text field and a find button. The search string has to be the exact simple (unqualified) name of an DB object or may contain placeholders ("%" or "_"). The text field supports code completion. A filter button allows to apply the search string as Object tree filter.
  • Object tree filtering: Multiple (comma separated) Object tree filters can be defined. Filter conditions can be excluding oder including. Better support for placeholders "%" and "_". See "Session Properties"/"New Session Properties" dialogs --> Tab "Object Tree".
  • Graph Plugin:
  • Qualified table names can now be displayed. Use the right mouse menu on graph background.
  • Edit Extras Plugin:
  • Improved handling and look of Escape date dialog.
  • Graph Plugin:
  • New entries in table's popup menu: "Copy table name" and "Copy qualified table name".
  • Columns of all tables in a graph can now be ordered at once. Use the right mouse menu on graph background.
  • New Plugin:
  • Smarttools by Michael Romankiewicz
  • Searching for tables that do not have a primary key or unique index or index.
  • Searching for non nullable columns that contain null values. Some DBs e.g. Firebird can be tricked to have this inconsistency.
  • Changing values database wide according to specified criteria.
  • For more information see the Plugin's help.
  • New Plugin: Firebird Manager by Michael Romankiewicz
  • Storing and restoring Firebird DBs
  • Managing users and roles for the Firebird RDBMS
  • For more information see the Plugin's help.
  • Aliases can be displayed as list or as tree.
  • A new preference for choosing Locales is available in Global Preferences -> General tab. This allows you to set your preferred locale, and if an optional translation is installed that corresponds with the preferred locale, then restart and the changes take effect.(No longer necessary to hand edit the start script)
  • Copy as "SQL WHERE" / "UPDATE-SET" / "INSERT-VALUES" statement function in tables Tables offer right mouse menu to copy WHERE, UPDATE-SET or INSERT-VALUES clauses of selected data to clip board. Works like the existing "Copy as SQL IN statement" function.
  • New Plugin: SQLReplace by Dieter Engelhardt This plugin replaces a set of variables before a statement is executed. The variables to replace can be defined at the Plugin's Global Preferences tab.
  • Added a preference option to allow the selection of items in lists to change while activating the popup menu on a single right-mouse button click. For example, without this, you need to select an object in the tree with a left mouse button click, then press the right mouse button to activate the popup menu.(See Global Preferences -> General -> Select On Right Mouse Click)

New in SQuirrel SQL Client 2.6.9 (Feb 3, 2009)

  • Bug fixes: Unable to switch database
  • Updated French translation labels/messages (Erwan Duroselle)

New in SQuirrel SQL Client 2.6.8 (Nov 24, 2008)

  • Delete records progress dialog was being left visible after it was no longer needed in some cases.
  • Hidden directories are now visible to the file chooser for jdbc driver files.
  • Import from file to table feature now warns and asks the user to confirm that it is ok to truncate the existing table data (The import feature doesn't yet support merging new data with existing data).
  • Windows EOL chars (CRLF) are converted to Linux EOL (LF).
  • Missing Scale Placeholder in Sql server dialect. This causes script generation and dbcopy targeting MS-SQL server to produce decimal columns without the scale attribute (that is, decimal(7) instead of decimal(7,5)).