Softpedia >Windows >Internet >Servers >Database Utils >A5:SQL Mk-2 >  Changelog

A5:SQL Mk-2 Changelog

What's new in A5:SQL Mk-2 2.20.0 Beta 6

Apr 15, 2024
  • If "Enumerate 〇〇bit ODBC system data sources" and "Enumerate 〇〇bit ODBC user data sources" in the "Add/Remove Database" dialog are not checked, the ODBC data source registration screen will be Fixed an issue where it was not displayed even in the dropdown.

New in A5:SQL Mk-2 2.20.0 Beta 5 (Apr 14, 2024)

  • Improved the ability to register ODBC data sources individually on the database registration screen.
  • Added option to use ssh.exe included with Windows when using SSH tunnel

New in A5:SQL Mk-2 2.20.0 Beta 4 (Mar 24, 2024)

  • Changed language resource creation from Delphi standard feature (deprecated in Delphi 12) to Better Translation Manager
  • Fixed a bug where filter expressions would not work when switching result set tabs when handling multiple result sets in the SQL editor.

New in A5:SQL Mk-2 2.20.0 Beta 3 (Mar 17, 2024)

  • Fixed a bug where an error may occur when using the SQL input support function with SQL containing WITH.

New in A5:SQL Mk-2 2.20.0 Beta 1 (Mar 10, 2024)

  • Functionally equivalent to Version 2.19.1 / Compiler updated (Delphi 12)

New in A5:SQL Mk-2 2.19.1 Beta 4 (Feb 18, 2024)

  • UPDATE_RULE,DELETE_RULE columns were not added to a5m2_FOREIGN_KEYS.csv in the ER diagram entity definition CSV, so they were added (planned to be added in Version 2.19.0).

New in A5:SQL Mk-2 2.19.1 Beta 3 (Feb 12, 2024)

  • Fixed to display a confirmation message box just before data transfer
  • When exporting a result set in the SQL editor, the specification of the DataTitle pseudo-instruction is now adopted as the default file name.
  • Fixed a bug where the application would stop (stack overflow) when checking the gray display of logically deleted lines from the menu.
  • You can now set options such as whether to use recently used tabs and the number of tabs.

New in A5:SQL Mk-2 2.19.1 Beta 1 (Feb 5, 2024)

  • Corrected the evaluation formula that grays out the filter calculation formula and logical deletion so that it will not cause an error even if a keyword is used privately as an identifier.
  • Fixed a bug that caused garbled characters in MySQL

New in A5:SQL Mk-2 2.19.0 (Feb 1, 2024)

  • Function addition/change:
  • Ability to handle ON DELETE and ON UPDATE with foreign keys (in each function of table definition change, table editor, and table definition document)
  • Corrected the layout of table definition document and entity definition document
  • Corrected the Html format design in the table definition document
  • Added a function to display up to 7 "recently used tabs" as a pop-up when hovering over a tab:
  • Enhancement of evaluation formula of filter function
  • Files (SQL, ER diagram, DMS, etc.) can now be registered as favorites in the database
  • Changed so that when connecting via SSH, the IP version used for SSH connection (v4, v6) and the IP version (v4, v6) used from the SSH server to the DB server can be set separately
  • Changed Oracle to use DBA_XXX data dictionaries if available (previously ALL_XXX data dictionaries)
  • Implemented a function to display logically deleted lines in gray (by specifying a conditional expression)
  • ER editor supports option description inside parentheses of CREATE TABLE statement
  • Added the ability to estimate relationships from table names, column names, and data types in the ER editor
  • When pasting an image to a shape object in the ER editor, you can now use a relative path in addition to an absolute path (as before, the image itself is not included in the file)

New in A5:SQL Mk-2 2.19.0 RC 1 (Jan 15, 2024)

  • Fixed so that non-ASCII parameter names can be used with @ format parameters in SQL Editor.
  • Fixed a bug where a backup session in another workspace was restored when restoring a session that ended abnormally.

New in A5:SQL Mk-2 2.19.0 Beta 27 (Jan 8, 2024)

  • Fixed a bug where tables containing Japanese characters etc. could not be opened in the table editor in SQLite.
  • When connecting with ADO, the quote character can now be selected from (none), "", [], and ``.

New in A5:SQL Mk-2 2.19.0 Beta 27 (Jan 8, 2024)

  • Fixed a bug where tables containing Japanese characters etc. could not be opened in the table editor in SQLite.
  • When connecting with ADO, the quote character can now be selected from (none), "", [], and ``.

New in A5:SQL Mk-2 2.19.0 Beta 26 (Jan 3, 2024)

  • In the ER editor, when pasting an image to a shape object, you can now use a relative path instead of an absolute path (as before, the image itself is not included in the file).

New in A5:SQL Mk-2 2.19.0 Beta 24 (Dec 24, 2023)

  • Corrected PostgreSQL to treat OID as a signed integer to an unsigned integer.
  • Fixed an issue where $$ was added to the name of the sequence object generated with Serial type when generating and executing DDL with table design in PostgreSQL (fixed to rename)
  • A function that displays filter expressions and logically deleted lines in gray, and supports NOT LIKE, NOT ILIKE, NOT IN, NOT ~, NOT ~*, !~, !~ operators

New in A5:SQL Mk-2 2.19.0 Beta 23 (Dec 18, 2023)

  • Fixed an issue where the notation of column data type of materialized view was different from normal notation in PostgreSQL.
  • Fixed an issue where DB comments for table columns were not retrieved from the ER diagram when using SQL input support for a database with an ER diagram assigned.

New in A5:SQL Mk-2 2.19.0 Beta 22 (Dec 10, 2023)

  • Fixed a bug where column order of materialized view was incorrect in PostgreSQL
  • Fixed unnecessary enumeration of schema names in SQL Server foreign key enumeration.
  • Corrected to generate "SET IDENTITY_INSERT table name ON" / "SET IDENTITY_INSERT table name OFF" SQL statements in DDL generation when using the SQL Server identity type in the table definition change function.

New in A5:SQL Mk-2 2.19.0 Beta 21 (Dec 3, 2023)

  • Fixed an issue where session variables could not be set in MySQL in Version 2.19.0 beta 14 or later (even if set, the session would be recreated and reset every time a query was executed).

New in A5:SQL Mk-2 2.19.0 Beta 20 (Nov 19, 2023)

  • Version 2.19.0 beta 17 and later did not cause an error even if a non-existent column was specified in the filter expression, but this has been fixed so that an error will occur.
  • Fixed an issue where the upper object could not be selected if there were overlapping objects in the ER diagram and the lower object was selected in Version 2.18.3 or later.

New in A5:SQL Mk-2 2.19.0 Beta 19 (Nov 14, 2023)

  • Fixed a bug where logically deleted rows are grayed out and some syntax does not work correctly in filter expressions.
  • The window when executing SQL comparisons is always displayed on top.

New in A5:SQL Mk-2 2.19.0 Beta 18 (Nov 12, 2023)

  • Fixed an issue where required checkboxes on the table design screen were difficult to see when using a dark theme.

New in A5:SQL Mk-2 2.19.0 Beta 17 (Nov 12, 2023)

  • Function to gray out logically deleted rows, supports IN (subquery not possible), BETWEEN operators
  • Changed the evaluation expression of the filter function to be equivalent to the function that grays out logically deleted rows.
  • Changed to be able to enumerate pg_temp_XXX, pg_toast_XXX schemas in PostgreSQL (this function is OFF by default, settings in the options dialog are required)

New in A5:SQL Mk-2 2.19.0 Beta 16 (Nov 6, 2023)

  • Fixed a bug where the LIKE syntax did not work correctly with the function that grayed out logically deleted lines (by specifying a conditional expression).

New in A5:SQL Mk-2 2.19.0 Beta 13 (Oct 29, 2023)

  • Oracle now uses DBA_XXX data dictionaries when available (previously ALL_XXX data dictionaries)
  • Minor corrections to the display position of hints (tab name/file name) on window tabs.

New in A5:SQL Mk-2 2.19.0 Beta 12 (Oct 22, 2023)

  • Fixed a bug that caused an error when starting for the first time in the version 2.19 beta version.
  • Fixed a bug in PostgreSQL where the logged-in user could not obtain the primary key of a table without a valid role.

New in A5:SQL Mk-2 2.19.0 Beta 10 (Oct 15, 2023)

  • Changed so that when connecting via SSH, the IP version used for SSH connection (v4, v6) and the IP version (v4, v6) used from the SSH server to the DB server can be set separately.

New in A5:SQL Mk-2 2.19.0 Beta 9 (Oct 9, 2023)

  • Fixed a bug where when adding a subtype in the ER editor, the primary key of the subtype's child entity became an invalid column.

New in A5:SQL Mk-2 2.19.0 Beta 7 (Oct 1, 2023)

  • Added a function to display up to 7 "recently used tabs" as a pop-up when hovering over a tab.
  • Adjusted the function to infer relationships from table names, column names, and data types in the ER editor <> (In the case of multiple keys, the child columns must appear consecutively to infer relationships.)
  • Dealing with an issue where an error may occur when running DMonkey scripts

New in A5:SQL Mk-2 2.19.0 Beta 5 (Sep 18, 2023)

  • Internally changed the mechanism for limiting the number of SQL result sets.
  • When the DB connection is disconnected from the server side, the display of A5:SQL Mk-2 will now reflect that the connection has been disconnected.
  • When executing SQL and outputting the result set to CSV/TSV instead of the grid, the file name can now be determined from the SQL title (--* DataTitle pseudo-instruction).

New in A5:SQL Mk-2 2.19.0 Beta 4 (Sep 10, 2023)

  • Changed the design of the HTML table definition document
  • ER editor now supports option description inside parentheses of CREATE TABLE statement

New in A5:SQL Mk-2 2.19.0 Beta 3 (Sep 3, 2023)

  • Added "Include Schema" option in table definition document
  • Slightly speed up Excel output with table definition book
  • Modified the Html format design slightly in the table definition document
  • Fixed to save the output option in the setting in the table definition document

New in A5:SQL Mk-2 2.19.0 Beta 2 (Aug 27, 2023)

  • Corrected the path separator output with in the table definition document / entity definition document

New in A5:SQL Mk-2 2.19.0 Beta 1 (Aug 27, 2023)

  • Be able to handle ON DELETE, ON UPDATE with foreign key (in each function of table definition change, table editor, table definition document)
  • Modify the layout of the table definition document/entity definition document
  • Fixed a bug that SQL Formatting does not format correctly when INNER of INNER JOIN is omitted.

New in A5:SQL Mk-2 2.18.4 (Aug 27, 2023)

  • Fixed so that the line feed code in the data can be displayed when the grid is displayed.

New in A5:SQL Mk-2 2.18.4 Beta 5 (Jul 30, 2023)

  • Revised the UI of the transaction management form to make it easier to operate.
  • Fixed a bug that the representation of numbers with one decimal place less than 0 and -1.0 or more may be incorrect.
  • Check file existence and overwrite confirmation when batch exporting

New in A5:SQL Mk-2 2.18.4 Beta 4 (Jul 17, 2023)

  • Fixed a bug that when trying to execute SQL with a disconnected DB connection in PostgreSQL, an error occurred and the SQL editor could not be operated (bug from Version 2.18.4 beta 2)
  • Corrected so that current date, current date and time, NULL, 0000-00-00 can be entered from the right-click menu in the SQL editor grid.
  • Added a blinking red border around the "Manage Transactions" button when there is an ongoing transaction. (like ~2.17 series)

New in A5:SQL Mk-2 2.18.4 Beta 3 (Jul 9, 2023)

  • Fixed a bug in Version 2.18.0 to 2.18.3 where the DB password was saved in an unintended encrypted format (Blowfish/initialization vector handling is old format) (not a weak cipher)
  • Fixed an issue where text could not be scrolled in the Blob editor when read-only
  • Widen the width of the DB selection pulldown in the data in SQL
  • Changed the maximum size of JIS code CSV import from 10MB to 200MB
  • Fixed a problem that data can not be obtained properly after executing set names command in MySQL

New in A5:SQL Mk-2 2.18.4 Beta 2 (Jul 2, 2023)

  • Fixed the problem that all line feed codes in strings are converted to CRLF and registered in DB when importing CSV
  • Fixed so that the line feed code in the data can be displayed when displaying the grid
  • Fixed a bug that caused an error like "SQL command is not terminated properly" when importing CSV (Version 2.18 series bug)

New in A5:SQL Mk-2 2.18.4 Beta 1 (Jun 25, 2023)

  • Fixed a bug that caused an error depending on the position of the mouse cursor when executing a DB tree filter.
  • Fixed the exclusive mode when connecting to SQLite from Version 2.18.0.

New in A5:SQL Mk-2 2.18.3 Beta 6 (Jun 11, 2023)

  • Improved behavior with Amazon Redshift (support for views, primary keys, constraints, execution plans)
  • Fixed CSV import error in Oracle

New in A5:SQL Mk-2 2.18.3 Beta 5 (Jun 8, 2023)

  • Fixed a bug that garbled characters occurred when connecting to Amazon Redshift.
  • Allow enumerating views on connections to Amazon Redshift.

New in A5:SQL Mk-2 2.18.3 Beta 3 (Jun 4, 2023)

  • Fixed an issue where connection to PostgreSQL may cause an error in forced encoding when the server encoding is SQL_ASCII.
  • Fixed a bug that caused an error when importing with virtual columns

New in A5:SQL Mk-2 2.18.3 Beta 2 (May 28, 2023)

  • Changed the behavior of "Export all result sets to Excel" to be similar to "Export the displayed result set to Excel" in the SQL editor.
  • Fixed a bug that could not connect to EUC_JP database in PostgreSQL version 2.18.0 or later.
  • Fixed a bug that the x64 version of sqlite3.dll was included in the x86 version.
  • Fixed an issue where unintended objects would be selected even if there were adjacent objects by prioritizing selected objects when resizing objects in the ER editor
  • Fixed a bug that the reload button was not displayed in the schema of the DB tree when using SQLServer.

New in A5:SQL Mk-2 2.18.3 Beta 1 (May 21, 2023)

  • Experimental fix for Amazon Redshift (whether it will be included in Version 2.18.3 is undecided).

New in A5:SQL Mk-2 2.18.0 RC 4 (May 1, 2023)

  • Fixed a bug that an error occurred after executing "Execute SQL and output result set to CST/TSV file instead of grid"
  • In PostgreSQL array access, :4 is recognized as a parameter when there is an expression like (ARRAY['A','B','C','D','E'])[2:4]. Fix to prevent crashing
  • Fixed so that comments before statements are also treated as part of SQL (Optionally, it is possible to remove comments before statements and execute them as before)
  • Implement plain text copy of SQL editor (Shift+Ctrl+C)

New in A5:SQL Mk-2 2.18.0 RC 3 (Apr 23, 2023)

  • Fixed a bug that caused an error when closing the execution plan screen after closing the DB
  • Corrected the problem that the column name of the scalar subquery cannot be listed in the column name of the outer subquery when there is a scalar subquery in the SELECT clause in the subquery (or common table expression) in the SQL input support function.
  • Fixed a bug that the ER editor does not generate indexes with the same column definition but different options
  • Added support for index options (currently PostgreSQL only. Partial indexes in PostgreSQL, etc.)
  • Fixed a bug that took a long time to open UNC format (network path format starting with \) file in SQL editor (problem with .editorconfig file)
  • In the SQL editor, when pasting text with line feed code LF and executing SQL and an error occurs, the error position display is corrected.

New in A5:SQL Mk-2 2.18.0 RC 2 (Apr 17, 2023)

  • Change the color of the workspace selection screen at startup
  • Changed the size of the input field of the filter greatly
  • Changed to display time zone information like "+09:00" when displaying timestamp with timezone type in PostgreSQL.
  • Fixed an issue where "Abort" is displayed when closing the DB connection dialog without connecting.
  • Adjust the column width of timestamp type (fixed that it was cut off)
  • Fixed workspace selection screen tint

New in A5:SQL Mk-2 2.18.0 RC 1 (Apr 9, 2023)

  • Fixed a bug that can not connect to OpenSSH 8.8 (some 8.7?) when using RSA format key file for SSH connection (for disabling ssh-rsa format (sha1) hash algorithm by default correspondence)
  • When an error occurs during DB connection, display a dialog that makes it easy to copy the error message instead of the message box.

New in A5:SQL Mk-2 2.18.0 Beta 58 (Apr 2, 2023)

  • On the DB registration screen, display a dialog that makes it easy to copy the error message instead of a message box when a test connection error occurs.
  • Fixed a bug that read violation occurs when filtering in DB tree
  • Fixed a bug that the rollback speed button does not work

New in A5:SQL Mk-2 2.18.0 Beta 56 (Mar 27, 2023)

  • Fixed a bug that caused an error in SQL execution plan acquisition from Version 2.18.0 beta 53

New in A5:SQL Mk-2 2.18.0 Beta 55 (Mar 26, 2023)

  • Fixed a bug that caused an error when generating DDL if desc was added to the index column in the ER diagram.
  • In the DB login dialog, change the checkbox shortcut of "Connect to production environment (or database that needs attention)" to Alt+X (operability)
  • Fixed a bug that the SQL error position was shifted when using the Replace pseudo-instruction during SQL execution.

New in A5:SQL Mk-2 2.18.0 Beta 54 (Mar 21, 2023)

  • Fixed a bug in version 2.18.0 beta 54 that the word position could be selected with "Fixed to select the word at the error position when an error occurred during SQL execution in PostgreSQL and MySQL".

New in A5:SQL Mk-2 2.18.0 Beta 53 (Mar 19, 2023)

  • Modified to select the word at the error position when an error occurs during SQL execution in PostgreSQL and MySQL (previously implemented only in Oracle)
  • In ER diagram, if you operate ER diagram immediately after print or PDF output operation, print/PDF output will be broken.

New in A5:SQL Mk-2 2.18.0 Beta 52 (Mar 12, 2023)

  • Fixed a bug that could not connect to Redshift (untested)
  • Fixed DB tree filter function sometimes causing an error
  • Implemented a function to automatically add a "restore point" of the editor contents after executing SQL (executed by [Edit (E)] - [Restore to restore point (0)...] from the menu)
  • Fixed a bug that common columns are generated even if the entity setting "Add common columns to the end of column definitions when generating DDL" is unchecked in the ER editor

New in A5:SQL Mk-2 2.18.0 Beta 51 (Mar 5, 2023)

  • Added transaction management screen
  • Updated development environment from Delphi 11.2 to Delphi 11.3

New in A5:SQL Mk-2 2.18.0 Beta 50 (Feb 26, 2023)

  • Fixed a bug that the column disappeared and could not be registered when setting the descending order column in the index in the ER editor.

New in A5:SQL Mk-2 2.18.0 Beta 49 (Feb 21, 2023)

  • Fixed the workspace selection dialog at startup to be displayed on the taskbar.
  • Fixed a bug that sometimes the rollback speed button of the DB tree is not heard
  • Implementation of a function to output the contents displayed on the console screen to a log file (Console.log) (check "Output messages from SQL, result sets, and DB to Console.log" in the [SQL] tab of the option dialog)

New in A5:SQL Mk-2 2.18.0 Beta 48 (Feb 12, 2023)

  • Modified to display a warning when logging in when the password is about to expire in Oracle.

New in A5:SQL Mk-2 2.18.0 Beta 47 (Feb 5, 2023)

  • Fixed an error in the contents of the relationship information (FK side) (column list, referring entity name, referencing column list) when the entity definition document was output in markdown with the ER editor.

New in A5:SQL Mk-2 2.18.0 Beta 46 (Feb 5, 2023)

  • Deleted the behavior that Ctrl+Y was to delete one row (delete selected row) in the SQL editor (because of the shortcut of REDO)
  • Added a workspace specification parameter ("/Workspace xxx") as a startup parameter of A5M2.exe.

New in A5:SQL Mk-2 2.18.0 Beta 44 (Jan 22, 2023)

  • Fixed a bug that output code processing of domain of entity definition document was strange in ER editor

New in A5:SQL Mk-2 2.18.0 Beta 42 (Jan 15, 2023)

  • Implemented workspace switching function (at startup and from the menu [Settings (P)] - [Workspace startup and management (Z) ...])
  • Fixed a bug that the SQL timeout time was 1/1000 of the set time in PostgreSQL from version 2.18.0 beta 39

New in A5:SQL Mk-2 2.18.0 Beta 41 (Jan 9, 2023)

  • 2023 correspondence of the copyright notice in the version notation
  • Improved error message when trying to paste Infinity as datetime data in PostgreSQL.

New in A5:SQL Mk-2 2.18.0 Beta 40 (Jan 3, 2023)

  • Devart UniDAC version update 9.1.1 → 9.3.0
  • Fixed a bug that the output order of foreign keys in the same table is not constant when DDL is output in the order of dependencies in ER diagram.

New in A5:SQL Mk-2 2.18.0 Beta 39 (Dec 25, 2022)

  • Fixed a bug that command timeout of SQL does not work in PostgreSQL
  • Set application_name parameter when connecting with PostgreSQL
  • Increased the default size of the execution plan screen

New in A5:SQL Mk-2 2.18.0 Beta 38 (Dec 19, 2022)

  • Fixed a bug that immediately after the first startup, even though "SQL file default transfer coding" was set to UTF-8 (Non BOM), the save dialog was set to Shift_JIS (MS932).

New in A5:SQL Mk-2 2.18.0 Beta 37 (Dec 11, 2022)

  • Enhanced the function of "Select page to display" such as entity in ER editor (Shift + check selects only the target page)
  • Fixed that some translations to English resources were left in Japanese

New in A5:SQL Mk-2 2.18.0 Beta 36 (Dec 4, 2022)

  • Changed to display the number of SQLs being executed when executing multiple SQLs that take a long time.
  • Added [Select Running SQL] to right-click menu of SQL Editor.
  • Replace dialog can be used even with Ctrl+H (Changed SQL execution history to Shift+Ctrl+H)

New in A5:SQL Mk-2 2.18.0 Beta 35 (Nov 29, 2022)

  • Fixed a problem that shortcut keys such as Ctrl + A are processed on the main screen in modeless dialogs such as the property screen of the ER editor.
  • Fixed a bug that the valid flag on the first line of the new entity was set to False on the property screen of the ER editor.

New in A5:SQL Mk-2 2.18.0 Beta 34 (Nov 27, 2022)

  • In the ER editor, fixed a bug that the property screen did not work well with the relationship that enabled/disabled by the attribute of the entity (from version 2.18.0 beta 32)
  • Fixed a bug that could not connect via SSH (from version 2.18.0 beta 19)
  • Fixed a bug that blank line may not appear at the top of attribute value pull-down list in relationship property dialog.
  • SSH/SSL library (Version upgrade of Devart SecureBridge)

New in A5:SQL Mk-2 2.18.0 Beta 32 (Nov 13, 2022)

  • In ER editor, enabled/disabled by entity attribute (handled as non-existing column temporarily)
  • Fixed a bug that did not confirm saving when trying to switch to another object even if some editing was done in the property dialog of the ER editor.
  • Fixed a bug that the encoding of the file save dialog was strange in the "Execute SQL and output the result set to CSV/TSV" function.

New in A5:SQL Mk-2 2.18.0 Beta 31 (Oct 30, 2022)

  • Changed so that when "How to draw lines" is changed in the context menu of the relationship, "How to draw lines" in the properties screen is also modified at the same time if the properties screen is displayed.
  • Changed to execute the previous SQL if there is a caret immediately after the semicolon in the mode where the SQL separator is a semicolon.
  • Fixed a bug that input support does not work properly when "partial match mode with prefix match priority" is selected in SQL input support.

New in A5:SQL Mk-2 2.18.0 Beta 30 (Oct 23, 2022)

  • Addition of "partial match mode with prefix match priority" in SQL input support * Modified improvement so that prefix match candidates are displayed in front when partial match mode is used in SQL input support implemented in beta 29
  • Default is the conventional "partial match mode"
  • Modified to output SQL to log file when result set is updated by table editor or SQL editor.

New in A5:SQL Mk-2 2.18.0 Beta 29 (Oct 17, 2022)

  • Improved so that forward matching candidates are displayed in front when partial match mode is used in SQL input support.

New in A5:SQL Mk-2 2.18.0 Beta 27 (Oct 16, 2022)

  • Added option to add IF EXISTS to DROP TABLE in Microsoft SQL Server 2016
  • Fixed a bug that CSV import of surrogate pair strings in MySQL could not be done
  • Implementation of the marker function on the execution plan screen
  • Fixed a bug that the comment of the node was displayed at an incorrect position when opening the node of the tree (version 2.18.0 beta 21 or later)
  • It seems that "." cannot be added after "?", so the wording has been corrected.

New in A5:SQL Mk-2 2.18.0 Beta 25 (Sep 25, 2022)

  • Fixed error in metadata retrieval SQL for SQL Server 2000
  • Fixed not to enumerate pg_temp_XX, pg_toast_temp_XX schemas in PostgreSQL
  • Fixed the width of the result set tab of the SQL editor to be wider.

New in A5:SQL Mk-2 2.18.0 Beta 24 (Sep 20, 2022)

  • Fixed a bug that can not be pasted in the SQL editor (bug from version 2.18.0 beta 20)

New in A5:SQL Mk-2 2.18.0 Beta 23 (Sep 19, 2022)

  • Additional correction for updating the compiler from Delphi 11.1 to 11.2 (fixing that the ER editor does not start)

New in A5:SQL Mk-2 2.18.0 Beta 22 (Sep 19, 2022)

  • Fixed a bug that some ODBC user data sources such as Amazon Athena ODBC could not be enumerated.

New in A5:SQL Mk-2 2.17.4 (Sep 19, 2022)

  • Function addition/change:
  • Changed the exclusive lock of the log file to a shared lock when executing the SQL script.
  • Fixed that the maximum zoom level of OpenTopo map was changed to 15
  • Bug fixes:
  • Fixed a bug that domain definition CSV in ER diagram entity definition CSV is always output in Shift_JIS (MS932) even if encoding is specified.
  • Fixed a bug that there was an error in the argument check in the DMonkey script.
  • Fixed a bug that an error occurred when moving to SQL tag in ER diagram
  • Fixed a bug that the type treated as BCD in JSON output was treated as a string.
  • Fixed a bug that an error occurred when selecting exit on the registry/portable mode selection screen at the first startup
  • Fixed a bug that stored procedure launcher could not be executed in PostgreSQL.
  • Fixed a bug that the parent schema table cannot be enumerated if the partitioning child table in PostgreSQL is in a different schema than the parent table.
  • Fixed a bug that caused an error when the Print Spooler service was stopped.
  • PostgreSQL Compatible with Oracle
  • Fixed a bug that the log of SQL script execution became CRLFLF.
  • Fixed a bug that the precision of NUMBER becomes low when importing CSV in Oracle.

New in A5:SQL Mk-2 2.18.0 Beta 20 (Sep 4, 2022)

  • Changed so that you can choose what to do when detecting file changes.
  • Fix for OpenTopo map maximum zoom level being changed to 15 in the map feature
  • Fixed a bug that A5:SQL Mk-2 misjudged as connecting to Oracle when connecting to PostgreSQL with Oracle compatibility function
  • A5: Dealing with cases where SQL Mk-2 fails to start before and after Windows Update on 2022/08
  • Gradation support for view objects in the ER editor

New in A5:SQL Mk-2 2.18.0 Beta 19 (Aug 7, 2022)

  • Support message output by raise in PL/pgSQL of PostgreSQL.
  • Fixed a bug in PostgreSQL partitioning table where table enumeration of parent partition schema failed when subpartition was in different schema than parent partition.
  • DB connection related large-scale refactoring.

New in A5:SQL Mk-2 2.18.0 Beta 18 (Jul 31, 2022)

  • Changed the button to display in the DB tree (version 2.18.0 beta 17) from "Display when selecting a node" to "Display on mouseover".

New in A5:SQL Mk-2 2.18.0 Beta 17 (Jul 18, 2022)

  • Added "Change Current Schema" button in "Schema" node in DB tree.
  • Added transaction control and reload buttons on the "database" node in the DB tree.

New in A5:SQL Mk-2 2.18.0 Beta 16 (Jul 10, 2022)

  • Added an option to adjust the brightness of the primary key and NOT NULL item color in the grid when using a dark theme ([Result set grid]-[Dark theme character primary key / required item brightness] in the option dialog. )
  • Corrected to put spaces on both sides of | in the table when outputting the table definition document with markdown
  • Fixed an error when trying to move to a SQL tag when editing an ER diagram view on the Query Designer screen
  • Fixed a bug that the table or view source is displayed in the lower left pane and the row copy mode is entered when trying to copy.

New in A5:SQL Mk-2 2.18.0 Beta 15 (Jun 26, 2022)

  • Implemented code snippet function
  • When using a dark theme, the color of the primary key and NOT NULL item is too bright on the grid, so adjust the color to darker.

New in A5:SQL Mk-2 2.18.0 Beta 13 (Jun 13, 2022)

  • Fixed a bug that copying cannot be done correctly when selecting a rectangle in the text editor and copying.
  • Improved SQL input support function

New in A5:SQL Mk-2 2.18.0 Beta 12 (Jun 5, 2022)

  • Improved SQL input support function
  • (A5: Improved completion function with SQL Mk-2)

New in A5:SQL Mk-2 2.18.0 Beta 11 (May 29, 2022)

  • Fixed to display the total number before applying the filter when using the filter in SQL editor / table editor.
  • Fixed to display Money type up to 2 decimal places in Microsoft SQL Server
  • Fixed an error in the method argument check in the DMonkey script, which often resulted in a memory read violation
  • Fixed a bug that domain definition CSV is always output in Shift_JIS (MS932) even if encoding is specified in entity definition CSV of ER diagram.

New in A5:SQL Mk-2 2.17.2 (May 15, 2022)

  • Function addition / change:
  • Changed the geometry data type of PostgreSQL and MySQL so that the transition from the "..." button to the map can be performed.
  • Implemented a function to move to a row with a different cell value by pressing Ctrl + ↓ (↑). Implemented moving to the beginning / end of the dataset with Shift + PageUp (PageDown), Ctrl + Home (End).
  • Changed not to list partitioned child tables on the table list screen.

New in A5:SQL Mk-2 2.18.0 Beta 9 (May 15, 2022)

  • Changed the dialog at the time of SQL execution error to the original dialog with copy function

New in A5:SQL Mk-2 2.18.0 Beta 8 (May 8, 2022)

  • Fixed the default value of the option as a workaround that the length is limited to 65535 bytes when the option to treat MySQL text type as a string type instead of Clob is ON.
  • Fixed not to list partitioned child tables on the table list screen
  • Keyword automatic capitalization function implementation (default OFF)
  • Implemented a mutual conversion function for compound word naming conventions (snake case (uppercase), snake case (lowercase), pascal case, camel case)
  • Implementation of keyword capitalization / lowercase function, implementation of identifier capitalization / lowercase function

New in A5:SQL Mk-2 2.18.0 Beta 7 (Apr 24, 2022)

  • Fixed a bug related to Ctrl key in the grid in version 2.18.0 beta 5 and 6 (again)
  • Fixed a bug that milliseconds are missing when importing CSV with PostgreSQL

New in A5:SQL Mk-2 2.18.0 Beta 6 (Apr 17, 2022)

  • Change the option setting name for internal saving of SQL formatting (the setting value of the number of digits to be broken and the number of digits to wrap is returned to the default if the number in parentheses is long)
  • With SQL formatting, JOIN… ON provides an option to place ON at the end of the JOIN line
  • Fixed a bug related to the Ctrl key in the grid in version 2.18.0 beta 5.
  • Added SQL formatting options (/ LineFeedPos, / ParenthesesLineFeedPos, / BlockCommentIndependentLine, / IndependentSemicolon, / JoinOnLineEnd)

New in A5:SQL Mk-2 2.18.0 Beta 5 (Apr 10, 2022)

  • Implemented a function to move cell values to different rows by pressing Ctrl + ↓ (↑) on the grid
  • Implemented moving to the beginning / end of the dataset with Shift + PageUp (PageDown), Ctrl + Home (End) on the grid
  • Implemented a function that can be copied in "justification markdown" format on the grid
  • Changed the geometry data type on the grid so that you can transition to the map from the "..." button.

New in A5:SQL Mk-2 2.18.0 Beta 4 (Apr 3, 2022)

  • In SQL formatting, add "number of line breaks" and "number of digits to break when the parentheses are long", "do not add spaces after block comments (option for S2JDBC)", and add spaces and line breaks after block comments. Not added (option for some O / R mappers) ”

New in A5:SQL Mk-2 2.18.0 Beta 3 (Mar 21, 2022)

  • Fixed a mistake that unnecessary')' is output in the markdown format output in the table definition / ER diagram entity definition.

New in A5:SQL Mk-2 2.18.0 Beta 2 (Mar 21, 2022)

  • Modified to output the same number of digits in the table notation in the markdown format output in the table definition / ER diagram entity definition.
  • Fixed a bug that prefix search does not work when narrowing down the table editor

New in A5:SQL Mk-2 2.18.0 Beta 1 (Mar 13, 2022)

  • DB connection library UniDAC version upgrade (8.3.2 → 9.1.1)
  • Enabled to output definition document in markdown format in table definition document / entity definition document of ER diagram.
  • Fixed the problem that the fetch time of all records is 0 in the mode where all fetches are not fetched immediately after the query.
  • Fixed a bug that inherited table is recognized as partitioning table.

New in A5:SQL Mk-2 2.17.1 (Mar 9, 2022)

  • Function addition:
  • Implementation of the function to copy / cut the current line by copying / cutting when not selected in the text editor component.

New in A5:SQL Mk-2 2.17.1 Beta 4 (Feb 23, 2022)

  • Added the ability to copy the result set as an Insert statement in the SQL editor
  • Fixed that the table data is searched again when the condition is canceled.

New in A5:SQL Mk-2 2.17.1 Beta 3 (Feb 20, 2022)

  • Corrected spelling mistakes and improved design / character input on the SQL keyword edit screen in the option dialog.

New in A5:SQL Mk-2 2.17.1 Beta 2 (Feb 13, 2022)

  • Implementation of the function to copy / cut the current line by copying / cutting when not selected in the editor
  • Restored MDI deleted in Version 2.17.0 as an option (check [Window (W)]-[Use MDI (Resizeable Child Window) (M)] from the menu)
  • Login screen layout modification (related to check boxes for production environment connection)
  • Fixed a bug that switching to English resources did not work well
  • Fixed a bug that switching to high DPI is strange when switching to English resources
  • Fixed the function to preview tabs by Shift + mouseover of tabs to the implementation that is less likely to malfunction at the time of key input.

New in A5:SQL Mk-2 2.17.1 Beta 1 (Feb 6, 2022)

  • Fixed to generate a comment even if the comment is empty in the column of ER diagram when generating DDL
  • Fixed the in-process DB mask function (not working) not being hidden
  • Fixed so that you can not log in unless you check the checkbox when connecting to "Production Environment" in the login dialog
  • Fixed a bug that an error occurs because the main screen is not initialized when trying to display toast with the / Connect option.
  • Fixed a bug that the header / footer input of ER diagram does not work.
  • Corrected an error in the output of domain CSV in the definition CSV of ER diagram.

New in A5:SQL Mk-2 2.17.0 (Jan 22, 2022)

  • Renewal of screen design (icons, etc.)
  • Fixed MDI control to always maximize MDI child forms
  • (For controls closer to the more general tab interface)
  • Added PostgreSQL administrator tool
  • (Parameter performance graph session user management)
  • Excel output-Added an option to change the color of even-numbered rows when copying the grid (default OFF)
  • Added the function to manage the physical name of the column in the domain function of ER diagram.
  • From the displayed result set, add [Show SQL Execution Plan (Q) ...] from the right-click menu.
  • Added the function to set the displayed page as the Windows wallpaper in the ER editor.
  • Improved the function to copy a table with insert / update statement
  • (Timestamp, date, and time are changed so that format specification is not required / Binary data type support / Geometry type support / "N''" format internationalized character string support)
  • The result set copy function supports JSON format and DbUnit format.
  • Improved to display a confirmation message box when trying to execute an UPDATE / DELETE statement without a WHERE clause.
  • Fixed so that a confirmation dialog can be displayed when executing SQL other than queries in a production environment, etc.
  • Fixed the problem that the decimal point is not displayed in the case of decimal type where the number of digits and precision are not specified in SQLite.
  • Fixed the problem that an error occurs when adding a table when the table name contains Japanese name etc. when using some DB products on the designer screen.
  • Fixed the table name and column name in Japanese etc. when pressing OK on the SQL designer screen.
  • Fixed the problem that if you delete (or move) the ER diagram file after assigning the ER diagram to the DB, you cannot unassign the ER diagram.
  • Fixed the problem that it is slow to list foreign keys in PostgreSQL
  • Fixed a bug that an error occurs when importing if the column name is different from the default case of DB.
  • · Prepare a screen to control compatibility related to bugs related to ER diagram.
  • Fixed a bug that the source of the function could not be obtained well in Oracle due to the reverse generation function of the object source.
  • Fixed the problem that the position collapses when copying the entity of the ER diagram and pasting it on another ER diagram.

New in A5:SQL Mk-2 2.17.0 RC 2 (Jan 10, 2022)

  • Fixed a bug that in the ER editor, if the relationship line is "free connection" and you enter a "verb phrase", it will not be drawn in the correct position.
  • Fixed some screen components not being able to follow window resizing in reverse generation of ER diagram
  • Blob editor slider, show / hide control error correction
  • Fixed DbUnit format export not being in the menu in SQL Editor / Table Editor
  • Fixed a bug where some forms had broken components or were out of size
  • Minor button icon design modifications

New in A5:SQL Mk-2 2.17.0 RC 1 (Jan 3, 2022)

  • Fixed so that confirmation dialog can be displayed when executing SQL other than query in production environment etc.
  • Fixed to be able to manage users from PostgreSQL control panel
  • Fixed to be able to export result set in DbUnit format from SQL editor / table editor
  • Button icon design minor modifications

New in A5:SQL Mk-2 2.17.0 Beta 33 (Dec 26, 2021)

  • Improved to display a confirmation message box when trying to execute an UPDATE / DELETE statement without a WHERE clause
  • Button icon design minor modifications

New in A5:SQL Mk-2 2.17.0 Beta 32 (Dec 19, 2021)

  • Export-related menu item organization
  • Fixed to export to a file instead of exporting to SQL editor by exporting Inserrt / Update When overwriting the module of Version 2.17.0 beta 25, the picture folder included in Version 2.17.0 beta 25 is Be sure to delete it.

New in A5:SQL Mk-2 2.17.0 Beta 31 (Dec 13, 2021)

  • Fixed a bug that an error occurs at startup when the startup password is set when using portable mode. When overwriting the module of Version 2.17.0 beta 25, the picture folder included in Version 2.17.0 beta 25 is Be sure to delete it.

New in A5:SQL Mk-2 2.17.0 Beta 29 (Dec 12, 2021)

  • Button icon design modification
  • Supports JSON format and DbUnit format with the result set copy function
  • Fixed the operation procedure around the export function of the result set.

New in A5:SQL Mk-2 2.17.0 Beta 27 (Dec 5, 2021)

  • Changed the icon display of various buttons and menus to new ones (images for various resolutions are available)
  • When overwriting the module of Version 2.17.0 beta 25, be sure to delete the picture folder included in Version 2.17.0 beta 25.

New in A5:SQL Mk-2 2.17.0 Beta 25 (Nov 23, 2021)

  • Some button icons etc. are available in high resolution (continued)

New in A5:SQL Mk-2 2.17.0 Beta 23 (Nov 14, 2021)

  • Renewed version notation dialog (and splash screen)
  • Fixed terrible flickering when scrolling with the mouse when using the theme function in the ER editor
  • Modified to generate internationalized strings (NVARCHAR series) in a format like his N'aiueo'when copying UPDATE statements from the table editor.

New in A5:SQL Mk-2 2.17.0 Beta 22 (Nov 7, 2021)

  • Fixed a bug that an error is displayed when there is no temporarily saved data at the time of the previous termination at startup

New in A5:SQL Mk-2 2.16.2 (Oct 13, 2021)

  • Fixed a bug that it is difficult to switch to another tab when executing many SQLs with short execution time continuously in SQL editor.
  • Fixed to wait for the currently executing SQL to stop for the first 2 seconds with the SQL stop button of the SQL editor.
  • Fixed a bug that even if TSV is selected when "Execute SQL and output result set to CSV / TSV file instead of grid" in SQL editor, it is output in CSV.
  • Fixed a bug that the dialog title bar was wrong when copying insert / update statements in the table editor, and the checkboxes were enabled / disabled.
  • Fixed a bug that "Specify sort condition" in the right-click menu of the table editor did not work.
  • Fixed a bug that an error occurs when adding a table when a Japanese name etc. is included in the table name when using some RDBMS products on the designer screen.
  • Fixed a bug that a long character string was displayed as `(memo)` etc. when executing a query on the designer screen.
  • Fixed a bug that a # 42000 error occurred when executing the generated SQL when using the auto_increment type of MySQL in the table redesign function.
  • Fixed a bug that ER diagram cannot be unassigned when reading ER diagram fails.
  • Initial size adjustment of designer form in high DPI environment
  • Fixed the problem that the logical name and comment of the column could not be acquired correctly due to the difference in case when ER diagram was assigned.
  • Fixed a bug that comments cannot be edited in MySQL
  • Fixed a bug that the constraint was not HTML correctly in the output of the table definition (layout collapse)
  • Fixed a bug that decimal (m, d) unsigned format data could not be displayed correctly in MySQL.

New in A5:SQL Mk-2 2.17.0 Beta 17 (Oct 11, 2021)

  • Fixed color syntax display in SQL editor (should be a little faster)
  • Fixed a slow list of foreign keys in PostgreSQL
  • Fixed a bug that an error occurs when importing when the column name is different from the default case of DB.

New in A5:SQL Mk-2 2.17.0 Beta 16 (Oct 10, 2021)

  • Fixed color syntax display in SQL editor (should be a little faster)
  • Fixed a slow list of foreign keys in PostgreSQL
  • Fixed a bug that an error occurs when importing if the column name is different from the default case of DB.

New in A5:SQL Mk-2 2.17.0 Beta 15 (Oct 3, 2021)

  • Temporary action that "grid index is out of range" may occur when executing SQL continuously in Version 2.17.0 beta 10 or later
  • Added an option to change the color of even-numbered rows when copying Excel output / grid (default OFF)
  • Fixed a bug that the sort condition was not set when opening the table editor in Version 2.17.0 beta 14.
  • Removed option to convert line comments to range comments when Oracle with ADO

New in A5:SQL Mk-2 2.17.0 Beta 14 (Sep 26, 2021)

  • In the PostgreSQL performance graph, you can switch the display / non-display of the series by clicking the legend.
  • Corrected the appearance of PostgreSQL performance graphs
  • Re-fixed a bug that the focus moves to the DB tree when executing DML such as UPDATE statement (because version 2.17.0 beta 13 could not be fixed correctly)
  • Fixed a bug that constraints could not be output correctly in HTML output of table definition document.
  • Fixed a bug that an error occurs when correcting a table comment in MySQL
  • Changed "Open with condition" of table editor to default where input instead of value input to grid

New in A5:SQL Mk-2 2.17.0 Beta 12 (Sep 20, 2021)

  • Implemented "Copy Graph" and "Copy Graph Data" functions by right-clicking in the performance (graph) function of the PostgreSQL administrator tool.

New in A5:SQL Mk-2 2.17.0 Beta 11 (Sep 19, 2021)

  • Changes to the performance (graph) function of the PostgreSQL administrator tools
  • Supports PostgreSQL partitioning table (The partitioning child table is not listed in the DB tree, and the partitioning parent / child table can be switched and displayed in the table editor).
  • Fixed a bug that the logical name and comment of the column cannot be obtained in the DB to which the ER diagram is assigned.
  • A workaround for the table redesign feature where he gets an error when trying to run create table without a primary key when the MySQL auto_increment type is specified.

New in A5:SQL Mk-2 2.17.0 Beta 10 (Sep 12, 2021)

  • Changed development environment from Delphi 10.4 to Delphi 11
  • Added performance (graph) and session list functions as a PostgreSQL administrator tool.

New in A5:SQL Mk-2 2.17.0 Beta 7 (Aug 29, 2021)

  • From the displayed result set, add [Show SQL Execution Plan (Q) ...] from the right-click menu.
  • Fixed a bug that unnecessary objects were generated when opening a new menu (only internal correction, no change in application behavior)

New in A5:SQL Mk-2 2.17.0 Beta 6 (Aug 22, 2021)

  • Added the function to set the displayed page as the Windows wallpaper in the ER editor.
  • Fixed a bug that "database" is displayed in the status bar when only the ER editor is started at startup when using English resources.
  • Fixed a bug that a long character string is displayed as `(MEMO)` etc. when executing SQL on the SQL designer screen.

New in A5:SQL Mk-2 2.17.0 Beta 5 (Aug 15, 2021)

  • Fixed a bug that an error occurs when adding a table when the table name contains Japanese name etc. when using some DB products on the designer screen.
  • Fixed a bug that ER diagram cannot be unassigned if ER diagram file is deleted (or moved) after assigning ER diagram to DB

New in A5:SQL Mk-2 2.17.0 Beta 3 (Aug 9, 2021)

  • On the SQL designer screen, when OK is pressed, Japanese etc. are modified to quote table names and column names.

New in A5:SQL Mk-2 2.17.0 Beta 1 (Aug 1, 2021)

  • Fixed to generate a comment even if the comment is empty in the column of ER diagram when generating DDL
  • Implemented update statement export function in table editor
  • Fixed a bug that the dialog title bar is incorrect and the checkbox is enabled / disabled when copying insert / update statements in the table editor.

New in A5:SQL Mk-2 2.16.0 (Jul 4, 2021)

  • SQL editor:
  • Changed to be able to select the line feed code when saving the file in SQL file etc.
  • In the SQL editor, input completion can be done with the Esc key (input completion by F4 is abolished)
  • Implemented the function to copy SQL in a format in the SQL editor
  • Added "Calculate tab width from display width instead of number of characters (monospaced font only)" as an option of SQL editor (default OFF)
  • Table editor:
  • Added an option to add or specify column comments on the SQL generation screen.
  • Improved so that the initial schema can be specified when connecting to a DB in some DBs.
  • ER diagram:
  • In the ER editor, when only one entity is selected, the relationship line associated with it is displayed thicker (easier to see).
  • Add "@BOOLEAN" domain in the ER editor (It may be a 1-byte or 1-bit integer type depending on the DB product.)
  • Other:
  • Improved appearance when using the theme function in a high DPI environment
  • Improved the function to copy from the result set with INSERT statement so that it can be copied in bulk insert format of PostgreSQL and MySQL.
  • Implemented the function to export with insert statement (Oracle, SQLServer, Db2, PostgreSQL, MySQL, SQLite only)
  • Implemented startup parameters (/ DelDB, / DelAllDB, / Exit)
  • Fixed a bug that the time zone may be UTC in PostgreSQL (explicitly set the time zone when connecting)
  • Modified to set the time zone when connecting with MySQL
  • Added PDF output function in ER editor ([File (F)]-[PDF output ...] from the menu)
  • Implemented a function that allows you to preview the contents of a tab when you mouse over the tab while holding down the Shift key.
  • Improved operation on Linux and Mac OS using Wine
  • Implemented a function (button) to adjust the column width of the grid according to the actual data width in the table editor and SQL editor.
  • · EditorConfig support
  • Implemented a function to display the actual color when the data is his WebColor (color such as "#FFFFFF" format or "Red") on the grid (default ON)
  • Supports Geography type in MySQL and MariaDB (displayed in WKT format)
  • Implemented a function that allows "Paste SQL statement" and "Paste CREATE TABLE statement" when dragging and dropping a table name from the DB tree to the SQL editor.
  • Implementation of Replace pseudo instruction

New in A5:SQL Mk-2 2.16.0 RC 4 (Jun 15, 2021)

  • Fixed a bug that the number of tab digits may not be correct in the option that can determine the initial width of the grid from the actual data width of the data when retrieving the result set.
  • Added the function to adjust the width of the column on the left side of the column boundary of the title row of the result set grid from the display width of the actual data.

New in A5:SQL Mk-2 2.16.0 RC 3 (Jun 6, 2021)

  • Fixed to be able to select the display / non-display of WebColor of the grid as an option.
  • Fixed a bug that the "Determine the initial width of the result set column from the actual data" function of the grid does not work properly with the Geometry type.

New in A5:SQL Mk-2 2.16.0 RC 2 (Jun 2, 2021)

  • Fixed a bug that the caret position of the logic of "Calculate tab width from display width instead of number of characters (monospaced font only)" in SQL editor option is incorrect.

New in A5:SQL Mk-2 2.16.0 Beta 35 (May 4, 2021)

  • Improved operability on Mac Wine (problem that editor font is broken, problem that hangs by specific operation, etc.)
  • Replace pseudo instruction can be used even during SQL input support
  • Added an option to determine the initial width of the grid from the actual data width of the data when retrieving the result set ("Determine the initial width of the result set grid from actual data" checkbox on the "Result Set Grid" tab of the Options dialog)

New in A5:SQL Mk-2 2.16.0 Beta 33 (Apr 18, 2021)

  • Fixed a bug that the scroll bar does not work when scrolling by dragging the mouse in the ER editor (from Version 2.15 series)
  • On the SQL generation screen (SELECT, INSERT, UPDATE, DELETE), "Off" for adding a column name comment and "CaptionFromComment pseudo-instruction + column comment" for specifying a column caption cannot be used at the same time when generating SQL. (Improvement of difficult-to-understand option specification)
  • "Paste SQL statement" and "Paste CREATE TABLE statement" can now be performed when dragging and dropping a table name from the DB tree to the SQL editor.

New in A5:SQL Mk-2 2.16.0 Beta 32 (Apr 11, 2021)

  • Fixed Geography type to be displayed in WKT format in MySQL and MariaDB

New in A5:SQL Mk-2 2.16.0 Beta 31 (Apr 5, 2021)

  • Fixed an issue where Geography types were not displayed in WKT format in PostgreSQL
  • Fixed a bug that some geometry types (MultiXxx series) could not be displayed properly in map display (change library from leaflet-omnivore to KTX) (change map display library (leaflet, KTX) from external site call to built-in type )

New in A5:SQL Mk-2 2.15.5 (Mar 31, 2021)

  • Fixed a bug that CSV / TSV import did not work properly when executed in English mode.
  • Fixed the problem that the number with one decimal place from 0.1 to 0.9 is displayed as 0 in PostgreSQL (which may occur in other DBs) (version 2.15.3 or later)
  • Fixed a bug that "CREATE VIEW" was not added to the view source in PostgreSQL.
  • Fixed a bug that the order of composite primary keys is incorrect in PostgreSQL (version 2.15.3 or later)
  • Fixed a bug that the column name is treated as two (or more) columns when there is a space in the column name on the relationship property screen of the ER editor.
  • Fixed a bug that Oracle's XMLTYPE was treated as a virtual column and could not be updated.

New in A5:SQL Mk-2 2.16.0 Beta 30 (Mar 29, 2021)

  • When the data is WebColor (color such as "#FFFFFF" format or "Red") in the grid, the actual color is displayed. (blog)
  • Added CONCURRENTLY (PostgreSQL 9.4 ~) to the keyword list
  • Fixed the problem that BCD type (NUMERIC, NUMBER, etc.) cannot be displayed correctly after the decimal point or the number of digits after the decimal point is omitted depending on the DB.

New in A5:SQL Mk-2 2.16.0 Beta 29 (Mar 21, 2021)

  • Fixed not to be minimized in modal dialog
  • Fixed column width to be preserved when reloading table in table editor
  • Fixed a bug that PostgreSQL (which may occur in other DBs) displayed a real number with one decimal place as an integer from 0.1 to 0.9 (Version 2.15.3, Version 2.16.0 beta 12 or later). )

New in A5:SQL Mk-2 2.16.0 Beta 28 (Mar 14, 2021)

  • EditorConfig
  • Fixed a bug that the function (button) that adjusts the column width of the grid according to the actual data width in the table editor / SQL editor does not work properly in Oracle.

New in A5:SQL Mk-2 2.16.0 Beta 27 (Mar 7, 2021)

  • Implemented a function (button) to adjust the column width of the grid according to the actual data width in the table editor / SQL editor.
  • Fixed a bug that "CREATE VIEW" is not displayed when getting the source in PostgreSQL view.

New in A5:SQL Mk-2 2.16.0 Beta 26 (Feb 28, 2021)

  • Fixed a bug that the column order is incorrect when getting a composite primary key in PostgreSQL.
  • Enhanced input check of "Open by specifying conditions" in the table editor
  • Arrangement of clear buttons in sort order on the "Open by specifying conditions" screen of the table editor
  • Fixed a bug that an error occurs when importing CSV when using in English mode

New in A5:SQL Mk-2 2.16.0 Beta 24 (Feb 22, 2021)

  • Implemented the ability to copy SQL in a format in the SQL editor
  • Fixed a bug that garbled data is added after the correct data when there are multi-byte characters in CHAR type data in Oracle.

New in A5:SQL Mk-2 2.16.0 Beta 22 (Feb 7, 2021)

  • Fixed a bug that the property screen does not work properly when there is a column containing spaces in the physical name in the relationship in the ER diagram.

New in A5:SQL Mk-2 2.15.4 (Jan 28, 2021)

  • Fixed a bug that milliseconds were lost in date / time type when using multi-line inserts (CSV import, dummy data creation, data pump, etc.) in Oracle.
  • Fixed a bug that a space was added after the table name when using MySQL 4.0.
  • In the DDL output on the table design screen, "old" was used for the alias of the table name, but it was changed to "org" because there is a problem in some environments.
  • Fixed the problem that the version check (latest check) did not finish properly and A5: SQL Mk-2 could not finish correctly when used in an environment where the Internet could not be connected.
  • Fixed a bug that the database tree became strange when the DPI value of the main display changed due to remote desktop connection etc.
  • Fixed a bug that the decimal point may not be displayed correctly in the real type.

New in A5:SQL Mk-2 2.16.0 Beta 21 (Jan 18, 2021)

  • A minor modification of the function that allows you to preview the contents of a tab when you mouse over the tab while holding down the Shift key.

New in A5:SQL Mk-2 2.16.0 Beta 20 (Jan 17, 2021)

  • Implemented a function that allows you to preview the contents of a tab when you mouse over the tab while holding down the Shift key.
  • Improved SQL script file execution functionality
  • Improved operability with CrossOver for Mac 20 (Wine 5.0) (freeze during editor input, initial font selection, etc ... However, the operation is still incomplete)
  • Fixed a bug that real numbers may be truncated and displayed as integers in query results.

New in A5:SQL Mk-2 2.16.0 Beta 18 (Jan 3, 2021)

  • Fixed a bug that the database tree became strange when the DPI value of the main display was changed" was incomplete, so it was additionally fixed.
  • Updated DB connection library (Devart UniDAC 8.3.2)
  • Updated SSL / SSH library (Devart SecureBridge 9.4.1)
  • In SQL editor, input completion by Esc key is now possible (input completion by F4 is abolished)
  • Fixed a bug that SQL Mk-2 cannot be terminated when the version check at startup is not completed. "Change to select the node of DB tree at the time of" / Connect "option at startup" works well. Fixed not

New in A5:SQL Mk-2 2.16.0 Beta 17 (Dec 13, 2020)

  • Enhanced Geometry type of PostgreSQL (Geometry type can be displayed in Enhanced WKT format)
  • Enhanced Geometry type map display of PostgreSQL
  • Added an option not to generate comments on the "Create SQL" screen.
  • Fixed a bug that table comments may not be displayed properly when ER diagram is assigned.
  • Restoring SSL-related options in PostgreSQL and MySQL
  • Fixed the handling of default value in MySQL timestamp type
  • Fixed a bug that a protocol error occurs when executing SQL of "select from table name" in PostgreSQL (provisional)
  • Fixed a bug that the option "Send Keep alive to database" was enabled even if the check was OFF in Version 2.15 series.

New in A5:SQL Mk-2 2.16.0 Beta 16 (Dec 13, 2020)

  • In the table design function, in the output DDL, "old" was used as an identifier, but it was changed to "org".
  • (Because old is a reserved word, it may not work properly in some environments)
  • Fixed SQL designer screen getting stuck

New in A5:SQL Mk-2 2.16.0 Beta 15 (Dec 6, 2020)

  • Added PDF output function in ER editor ([File (F)]-[PDF output ...] from the menu)
  • Added "Remove and paste tags from XML" feature in SQL Editor Code Stripper

New in A5:SQL Mk-2 2.15.3 (Dec 2, 2020)

  • Fixed the problem that the time zone is UTC when connecting with PostgreSQL
  • Fixed an issue where MySQL makes the timezone dependent on system settings (often UTC) when connecting
  • Fixed a bug that the comparison of table names did not work with the schema comparison function.
  • Changed the method of acquiring the primary key in PostgreSQL (fixed the problem that the primary key may not be acquired correctly immediately after adding / deleting columns)
  • Fixed a bug that the show command could not be executed in PostgreSQL.
  • Fixed a bug that a space is added after the table name in the table editor or SQL input support in MySQL 4.0 or earlier.

New in A5:SQL Mk-2 2.16.0 Beta 13 (Nov 15, 2020)

  • Fixed a bug that an error occurs when the startup options (/ Connect, / AddDB, / SetDB…) are specified.

New in A5:SQL Mk-2 2.16.0 Beta 11 (Oct 25, 2020)

  • Fixed a bug that schema comparison may not work (sorting rules were slightly different when sorting and matching table lists)

New in A5:SQL Mk-2 2.15.2 (Oct 5, 2020)

  • Enhanced Geometry type of PostgreSQL (Geometry type can be displayed in Enhanced WKT format)
  • -Enhanced Geometry type map display of PostgreSQL
  • -Added an option not to generate comments on the "Create SQL" screen.
  • -Fixed a bug that table comments may not be displayed properly when ER diagram is assigned.
  • -Restoring SSL-related options in PostgreSQL and MySQL
  • -Fixed the handling of default value in MySQL timestamp type
  • -Corrected a bug that a protocol error occurs when executing SQL of "select from table name" in PostgreSQL (provisional)
  • -Fixed a bug in Version 2.15 that was enabled even if the option "Send Keep alive to database" was unchecked.

New in A5:SQL Mk-2 2.15. 1 (Oct 5, 2020)

  • Supports Geometry type of PostgreSQL (Geometry type can be displayed in WKT format)
  • Enabled display on the map with PostgreSQL Geometry type
  • Changed PostgreSQL public schema not to be quoted
  • Changed to execute set transaction_read_only = on in read-only mode in PostgreSQL.
  • Modified so that user-defined types (geometry, etc.) can be acquired correctly in PostgreSQL.
  • Fixed so that the data type defined as Serial type in PostgreSQL can be displayed as Serial instead of Integer.
  • Shift + Del no longer sets NOT NULL items to NULL.

New in A5:SQL Mk-2 2.16.0 Beta 9 (Sep 27, 2020)

  • Modified so that the line feed code can be selected when saving the file in SQL file etc.
  • Fixed an error in the connection mode notation when SQL Native Client could not be found on the DB registration screen of SQL Server.
  • Organize options for batch export

New in A5:SQL Mk-2 2.16.0 Beta 8 (Sep 22, 2020)

  • Implemented the function to export with insert statement (Oracle, SQLServer, Db2, PostgreSQL, MySQL, SQLite only)
  • Fixed a bug that entity name is not displayed in SQL editor input support (mainly in SQL Server) when ER diagram is assigned
  • Integrate the "sort order" function into "table data refinement" in the table editor
  • Fixed a bug that a protocol error occurs when executing SQL of "select from table name" in PostgreSQL (provisional)

New in A5:SQL Mk-2 2.16.0 Beta 7 (Sep 13, 2020)

  • Implemented startup options / AddDB, / SetDB
  • (/ AddDB <DB name> = <ConnectionString> format)
  • (/ SetDB <DB name> = <ConnectionString> format)
  • Fixed handling of default value of timestamp type in MySQL
  • PostgreSQL geometry is now displayed in Enhance WKT format instead of WKT format.
  • Enabled to display types other than Point, LineString, Polygon (Geometry Collection, etc.) in the geometry map display.

New in A5:SQL Mk-2 2.16.0 Beta 5 (Sep 7, 2020)

  • Restored some SSL connection options for PostgreSQL and MySQL in Version 2.15 series (ignore server certificate validity period, ignore server certificate constraint, trust server certificate)
  • Fixed the problem that table comment could not be displayed properly when ER diagram was assigned.

New in A5:SQL Mk-2 2.16.0 Beta 4 (Aug 24, 2020)

  • Improved the function to copy from result set by INSERT statement so that it can be copied in bulk insert format of PostgreSQL and MySQL.
  • Added a function that can be connected with "/connect "DB name"" as a startup option
  • Prevented the continuous import screen from closing even if the process ends normally.
  • ("Cancel" button is also changed to "Close" button)

New in A5:SQL Mk-2 2.16.0 Beta 3 (Aug 16, 2020)

  • Modified to be able to specify initial schema in PostgreSQL
  • Implemented multiple geometry and Tip display/EPSG code change function with map display function of geometry data
  • In the ER editor, when only one entity is selected, the relationship line associated with it is displayed thick (easy to see)

New in A5:SQL Mk-2 2.15.1 Beta 1 (Jun 19, 2020)

  • Changed to add cascade option when dropping table when redesigning table (it deletes related View)
  • In PostgreSQL, Geometry type can be handled in text (WKT) format instead of binary (WKB) format.
  • In PostgreSQL, when Geometry type holds Point type, "Open in Map" can be executed from the context menu (or Ctrl+M). (Even if the Geometry value includes SRID, it is always interpreted as SRID=4326. The map to open can be changed from the [Geometry] tab of the option menu.)
  • Modified to be able to display Serial type as Integer instead of displaying it as Integer in PostgreSQL.
  • Fixed a problem that Undo could not be done with the command to automatically determine the size of the entity in the ER editor
  • Fixed a bug that lowercase tables such as PostgreSQL and MySQL did not match with regular expressions in the DB tree filter function.

New in A5:SQL Mk-2 2.15.0 (Jun 19, 2020)

  • Added table design screen (new table creation/layout change screen)
  • See blog post → https://a5m2.mmatsubara.com/wp/?p=4404
  • Added batch update function for result set (function to send changes in multiple rows at once-default is OFF)
  • Improved ER editor
  • Added "Free connection" mode that allows you to draw lines freely as a relationship line type in the ER diagram
  • Move the object while holding down the Alt key in the ER editor so that the object is arranged according to the grid
  • Added option to capitalize reserved words in DDL generation of ER diagram
  • Modified so that tables can be specified for data transfer between schemas
  • Added the function to detect the SQL delimiter at the time of execution with the SQL editor and switch to "line only "/"" or "line only "GO"" (with confirmation message).
  • Acceleration of SQL input support function in an environment with thousands of tables
  • Implemented json format export
  • Modified to send to the server without removing the semicolon that separates when executing Microsoft SQL Server and MERGE statement.
  • Improved display under high DPI environment
  • Changed the default theme color to "Hakuhazakura"

New in A5:SQL Mk-2 2.15.0 RC10 (May 31, 2020)

  • Review grid drawing logic. (Fixed a bug that it may not be drawn well in dark theme)
  • Review of some color schemes (correction of parts that are difficult to see in dark theme)

New in A5:SQL Mk-2 2.15.0 RC9 (May 24, 2020)

  • Changed the default font color scheme in SQL editor (to make it easier to see in dark theme)
  • Fixed a bug that the grid display may be difficult to see when using a dark theme.
  • Added SIMILAR to keyword list

New in A5:SQL Mk-2 2.15.0 RC8 (May 23, 2020)

  • In PostgreSQL, the sequence of sequences in the DB tree etc. was not arranged in the name order.
  • Corrected the sequence number when the table was created (recreated) with the RestoreFromTempTable directive in PostgreSQL and had a serial type to be the current maximum value + 1.

New in A5:SQL Mk-2 2.15.0 RC7 (May 7, 2020)

  • Reverted the behavior change of the search dialog made in release candidate 4.
  • Change initial value of option
  • Changed the default encoding when saving a new file from MS932 to UTF-8
  • Unified SQL editor and SQL formatting tabs with 4 spaces
  • Fixed a bug that acquisition of table information fails when connecting to an older version of Oracle with release candidate 5 or later

New in A5:SQL Mk-2 2.15.0 RC6 (Apr 19, 2020)

  • Modified to be able to handle TIMESTAMP WITH TIME ZONE of Oracle Database as a character string (in order to handle time zone).
  • (It can be handled as a date type as usual with optional settings)
  • Modified Microsoft SQL Server DateTimeOffset to be handled as a character string (to be able to handle time zone).
  • (It can be handled as a date type as usual with optional settings)

New in A5:SQL Mk-2 2.15.0 RC5 (Apr 12, 2020)

  • Fixed bug of Date type constructor in ECMAScript function.
  • Fixed a bug that the grid goes out of display in the SQL editor
  • Support materialized views in ER editor (Oracle, Db2, PostgreSQL)
  • Fixed Excel output tips
  • Added an option (default ON) that allows unindent operation with backspace in SQL editor
  • Fixed a bug where comments on materialized views could not be obtained.

New in A5:SQL Mk-2 2.15.0 RC4 (Mar 29, 2020)

  • Fixed a bug that comments might be mixed in the column names of the result set.
  • Fixed a bug that background fetch does not work correctly when the maximum number of result sets is 0
  • Fixed a bug that Keep-alive processing sometimes batted with SQL.
  • Fixed the processing of search marks when searching in the editor.
  • Fixed the color of the synchronous editing function

New in A5:SQL Mk-2 2.15.0 RC3 (Mar 22, 2020)

  • Temporary fix for the bug that KeepAlive is battling with batch execution and other SQL execution
  • Added a function to discard (purge) all database connections
  • Query execution result display on the designer screen has been adjusted to SQL editor etc.
  • Fixed a bug where the "0-decimal" option in the SQL editor grid was not working

New in A5:SQL Mk-2 2.15.0 RC2 (Mar 16, 2020)

  • Fixed a problem with pasting records in tables using virtual columns (generated columns / calculated columns).
  • (Oracle, SQL Server, PostgreSQL, MySQL, SQLite)
  • Fixed an issue where the SQL designer screen was dark blue when using a dark theme.
  • Update the DLL of SQLite (SQLite 3.31.1)
  • Fixed a bug that the table design screen could not be opened (bug after version 2.15.0 beta 30)
  • Improved processing of menu shortcut keys (the problem of not being able to use the menu to select all (Alt + E, A) from key operations in the SQL editor)

New in A5:SQL Mk-2 2.15.0 RC1 (Mar 9, 2020)

  • SQLite's TEXT type is now recognized as a string type (not CLOB) by default

New in A5:SQL Mk-2 2.15.0 Beta 36 (Feb 24, 2020)

  • Fixed a bug that tab captions may not be set correctly
  • Changed to capitalize keywords at the word level when generating DDL (prevents capitalization of table options etc.)
  • Added option to capitalize reserved words in DDL generation of ER diagram
  • Fixed a bug that MySQL user management does not work well
  • Fixed to clear cache before syncing ER diagram
  • Fixed a bug that when a binary item was copied as it was displayed as a character string (such as Shift_JIS) and pasted with A5: SQL Mk-2, it was pasted with a base64 character string

New in A5:SQL Mk-2 2.15.0 Beta 35 (Feb 16, 2020)

  • Fixed a bug that the long SQL execution when connecting directly to Oracle is "ORA-03113 End-of-file detected on communication channel" in 30 seconds
  • Improper setting of tab caption right after opening table editor
  • Fixed a bug where MariaDB ODBC hit the limit on the number of table editors when connecting to MySQL from the MariaDB ODBC driver.
  • Fixed a bug that the title line was not displayed when obtaining a result set from a stored procedure and outputting it to Excel in the beta version of Version 2.15.0
  • Fixed a bug that caused an error when pressing Shift + Tab on a line with only blank spaces less than the number of tabs in the editor component

New in A5:SQL Mk-2 2.15.0 Beta 34 (Feb 9, 2020)

  • Fixed a case where enumeration of DB list did not go well on the DB registration screen of SQL Server
  • Changed @FLOAT and @DOUBLE from NUMERIC in IBM Db2 to FLOAT and DOUBLE.
  • Changed to convert @FLOAT to FLOAT only when parenthesized in PostgreSQL. (Usually converted to REAL)
  • When the connection destination DB is MySQL with ADO, it stops sending the GPL message and disconnects.

New in A5:SQL Mk-2 2.15.0 Beta 32 (Jan 26, 2020)

  • Fixed an error in MySQL NOT NULL column judgment fixed in beta 31
  • Modified to be able to input the time with decimals when entering the date and time.
  • In version 2.15.0 beta 29 or later, when setting white space to fixed length character string and NOT NULL item in Oracle, "ORA-01400: (" xxx "." xxx "." xxx ") Cannot be NULL. "

New in A5:SQL Mk-2 2.15.0 Beta 31 (Jan 19, 2020)

  • Fixed a bug where stored procedure arguments could not be enumerated when connecting to SQL Server with the built-in UniDAC library (without using NativeClient).
  • Fixed an issue where nodes could not be expanded or reduced by clicking ">" in the database tree at high DPI
  • Fixed a bug that all columns are identified as NOT NULL when using the past version of MySQL (about 4.1?) In the table editor.
  • Fixed a bug that garbled characters when using the administrator tool with an old version of MySQL (MySQL 4.1 or earlier?)

New in A5:SQL Mk-2 2.15.0 Beta 29 (Jan 5, 2020)

  • Upgrade DB connection library UniDAC (739 ? 812)
  • Upgrade of SSH connection library SecureBridge (902 ? 924)
  • Modified to restore table authority and column authority when re-creating a table on the table design screen
  • (Oracle, Db2, PostgreSQL, MySQL only, SQL Server later)
  • Fixed a bug that MySQL opened in the disabled state the next time it was opened even if it was saved with the SSL enable option enabled in the DB connection settings dialog
  • Modified to add right trim for strings in filter logic of table editor

New in A5:SQL Mk-2 2.15.0 Beta 28 (Dec 22, 2019)

  • Fixed a bug that views etc. could not be enumerated in IBM PureData (Netezza)
  • Slightly corrected text editor performance (when opening large files)
  • Fixed a bug that the number of lines displayed in the text editor became narrow under high DPI environment

New in A5:SQL Mk-2 2.15.0 Beta 27 (Dec 8, 2019)

  • Fixed bug that Z-order of objects is reversed when copying and pasting with ER editor
  • Fixed a bug where relationships were not selected when selecting all with Ctrl + A in ER editor
  • Fixed an issue where PostgreSQL table sources could not get mixed case table sources
  • Implemented an option that can be handled as a string type in the date / time / datetime type in MySQL (Time type is True by default) (Handles a time like 25:00:00 and a date like 0000-00-00 For)
  • Modified to restore authority when re-creating a table on the table design screen (currently Oracle only)
  • Fixed a bug that comparison is not possible when the key set is binary type in the result set comparison
  • PostgreSQL measures "SELECT 1.23456789 :: money :: text" error in some environments
  • Fixed a bug that mixed case error when importing

New in A5:SQL Mk-2 2.15.0 Beta 24 (Nov 4, 2019)

  • Fixed SQL input support bug that occurred in Version 2.14.3
  • Fixed a bug that VERBINARY is recognized as a string type in MySQL
  • Fixed a bug that the definition document of View cannot be output well with SQLServer (column is not output)
  • Fixed the problem that the position of one-line comment is shifted when there are double-byte characters in SQL formatting.
  • Fixed a bug that an error may occur in the sheet name when exporting from the table editor to Excel

New in A5:SQL Mk-2 2.15.0 Beta 23 (Oct 27, 2019)

  • Added "Free connection" mode that allows you to draw lines freely as relationship line types in ER diagrams
  • Modified to output column comments to INSERT, UPDATE statements, and WHERE clauses in "Create SQL" from the table editor.

New in A5:SQL Mk-2 2.15.0 Beta 16 (Sep 8, 2019)

  • Fixed the layout breaks when scaling is changed under high DPI environment
  • Fixed a case where no comment was given in the DB tree (NG when the schema name / table name was quoted)
  • Fixed the problem that the sort order of DB tree is different from DB pull down etc.
  • Modified to support MySQL Verbinary type as binary instead of string.
  • Changed the tab of the page so that it matches the length of the page name from the fixed width in the ER editor.
  • Improvement of error cases before PostgreSQL 7.2
  • Upgrade SecureBridge from 9.0.2 to 9.1.3
  • Improvement of build process (2) (internal story, unrelated to execution program)

New in A5:SQL Mk-2 2.15.0 Beta 15 (Sep 2, 2019)

  • Faster SQL input support
  • Fixed A5: SQL Mk-2 window to be in the foreground when file is opened by drag & drop
  • Improved build process (internal story, unrelated to executable program)

New in A5:SQL Mk-2 2.15.0 Beta 14 (Aug 26, 2019)

  • Accelerated SQL input support (added)
  • Implemented json format export
  • Fixed a bug that the View definition document cannot be output correctly in SQLServer (columns are not output)

New in A5:SQL Mk-2 2.15.0 Beta 13 (Aug 14, 2019)

  • Fixed a bug that date data cannot be acquired correctly in Version 2.15.0 beta 11-12

New in A5:SQL Mk-2 2.15.0 Beta 9 (Jul 8, 2019)

  • Change the theme preview function from the dialog to the method to display the site preview page in the options dialog
  • Modified that only the logical names of tables and columns were displayed in SQL input support etc. so that the entire comment registered in DB is displayed.
  • When displaying a numeric type in the result set grid, it is normally displayed right-justified, but changed to display left-justified only when the number of displayable digits is smaller than the actual number of digits

New in A5:SQL Mk-2 2.15.0 Beta 6 (Jun 9, 2019)

  • Improved the table design screen (foreign key constraint · trigger setting added function ... (still incomplete))

New in A5:SQL Mk-2 2.15.0 Beta 5 (May 19, 2019)

  • Improved table design screen (option setting for each DB product)
  • Oracle Database, IBM Db2, PostgreSQL, MySQL (SQL Server will be implemented later)

New in A5:SQL Mk-2 2.15.0 Beta 4 (May 6, 2019)

  • Add table design screen (Create a new table / Change layout screen)
  • Add a function to detect SQL delimiter at the time of execution with SQL editor and switch to "" / "only line or" "only" line (with confirmation message)
  • Change the condition to output the confirmation message of switching to "stored procedure mode" at the time of execution in SQL editor (change only when ";" is separated by SQL)
  • Fixed the problem that NULL is not correctly transferred in data transfer between schemas in version 2.14 system
  • Fixed bug that NULL registration does not work correctly when creating dummy data in Version 2.14 system.
  • When opening the word at caret position as a table in the SQL editor, change the connection dialog to be displayed when not connected to the database
  • When sending a MERGE statement on Microsoft SQL Server, fixed to send to the server without removing the separating semicolon

New in A5:SQL Mk-2 2.15.0 Beta 3 (Apr 22, 2019)

  • Fixed the problem that the focus moves to the completion window when resizing the completion window of SQL Editor on Windows 8.1 or earlier (If the focus moves to the completion window, the key input will not work in the text editor)

New in A5:SQL Mk-2 2.15.0 Beta 1 (Apr 14, 2019)

  • It became possible to specify a table in data transfer between schemas.
  • In the result set of the table editor or SQL editor, instead of reflecting edits one by one on the server, add a mode to edit multiple rows locally and reflect them collectively

New in A5:SQL Mk-2 2.14.2 Beta 1 (Apr 8, 2019)

  • Changed so that filter string can include comments in table or SQL result
  • Fixed a bug that SQL including surrogate pair is garbled in Oralce
  • Fixed a bug that SQL including surrogate pair is garbled when connecting to utf8mb4 DB with MySQL (including MariaDB)

New in A5:SQL Mk-2 2.14.1 (Mar 29, 2019)

  • Update the SSH connection library from Version 9.0.1 to 9.0.2
  • Fixed the problem that an error occurs when performing CSV import when using in English mode
  • Fixed the problem that load_extension () does not work in SQLite (It is necessary to check "Enable" load_extension () "" on the DB registration screen.)
  • When the "Save sort order and filter conditions" option of "Table" option is ON, if the specified column (mostly the primary key) in sort order is deleted from the table layout, the table Fixed a bug that can not be opened in the editor
  • Fixed the problem that column captions are separated if there is a half-width space in the Captions directive (pseudo instruction)
  • Support for Microsoft Store
  • Fixed the error that error was displayed because it was converted to double precision once when displaying single precision floating point data.
  • Fixed the problem that foreign key constraints were not displayed in PostgreSQL.

New in A5:SQL Mk-2 2.14.1 Beta 1 (Feb 25, 2019)

  • Prepare for Microsoft Store (so that readme etc can be referred directly from application · Link to privacy policy etc)
  • Corrected a problem that displayed an error because it is once converted to double precision when displaying single precision floating point data
  • Fixed a bug that foreign key constraint was no longer displayed in PostgreSQL

New in A5:SQL Mk-2 2.14 (Feb 25, 2019)

  • When outputting or copying Excel, change NULL to "« NULL »".
  •   (We used a character string including "Zero Width Space" so far and it was often troublesome because it is difficult to understand)
  • MySQL 8.0 compatible
  • Supported Netezza (IBM PureData for Analytics)
  •   (Connect using ODBC driver)
  • Change Shift + DEL to "NULL input" on the grid to toggle action of "NULL or null character input"
  • Accelerate CSV import · test data creation · inter-schema data transfer · (multi-row insert)
  • Changing the order of ASCII code ranges in the order of the table in the database tree to all symbols, numbers and alphabets (Full-width has no effect)
  • Batch export · Fix to cancel in progress by continuous import.
  • Fix to change ZOrder when ER diagram is saved when ZOrder is saved (Introduction of ZOrder property) · Changing order of CREATE TABLE creation at DDL creation in ER diagram did
  • It is possible to specify the local side standby port number when connecting to SSH
  • Minor fixes

New in A5:SQL Mk-2 2.14.0 RC 9 (Jan 21, 2019)

  • Fix the logic to get primary key information in PostgreSQL as in version 2.14.0 release candidate 7 and before
  • Fixed a bug that the selected state was in an incorrect state when narrowing down by the filter in the record selection status in the result set
  • Corrected to recognize the handling of data that can not be recognized as Julian day as "yyyyMMddhhmmsszzz" number or its partial number when numeric value is included in date-time type data in SQLite 3
  • - Fixed a bug that caused errors such as CSV import of numbers with a large number of digits in Oracle etc

New in A5:SQL Mk-2 2.14.0 RC 8 (Jan 14, 2019)

  • Version 2.14.0 release Corrected bug that Import of CSV imported integer values ​ exceeding the range of 32 bits may not work well with candidate 7
  • Fixed a bug that primary key information could not be acquired correctly in PostgreSQL
  • Change to display status bar with continuous import
  • Fixed a bug where the focus position was wrong when moving the focus from the DB tree to the child window with F8

New in A5:SQL Mk-2 2.14.0 RC 7 (Jan 7, 2019)

  • Fixed a bug that small-digit integer imports may not work well when importing CSV
  • The local side standby port number for SSH connection can be specified
  • Improved display performance of BLOB items
  • Oracle and PostgreSQL support lazy loading of BLOBs
  • (It can be specified by option, it is ON by default.)
  • Fixed a bug in MySQL that failed to acquire the stored procedure source

New in A5:SQL Mk-2 2.14.0 RC 6 (Dec 27, 2018)

  • Fixed bug that import error of integer importing (bigger than 32 bit) in table import process
  • Fixed a problem that caused an error due to focus change to the database combo box, such as when there is no authority on MySQL database registration screen

New in A5:SQL Mk-2 2.14.0 RC 5 (Dec 17, 2018)

  • When character set of connection information is not specified in MySQL and the character set of DB is utf8mb4, the client character set is set to utf8mb4
  • Change the SSH connection component SecureBridge version from 8.2 to 9.0.1

New in A5:SQL Mk-2 2.14.0 RC 4 (Dec 5, 2018)

  • Fixed a bug that older version encrypted passwords could not be decrypted
  • When DateTime type of SQLite is used and the value is Julian day number and the time is 12:00:00, date and time are not displayed properly. (Bug concerning handling of Julius day)
  • Fixed a bug that DateTime type of SQLite causes an error when dealing with 9999/12/31 12: 00: 00 to 23: 59: 59 (Bug concerning handling of Julius day)

New in A5:SQL Mk-2 2.14.0 RC 1 (Nov 5, 2018)

  • Fix to be able to control creation order of CREATE TABLE at DDL creation in ER diagram
  • Fix as changing the ZOrder when saving the ER diagram so that the sort order at the time of file saving does not change (introduction of ZOrder property)
  • Corrected so that the position of the comma and the line comment are interchanged as needed at the time of SQL formatting, or it can be specified by option

New in A5:SQL Mk-2 2.13.3 (Sep 24, 2018)

  • Fixed a bug that A5: SQL Mk - 2 transaction does not work well when "autocommit = 0" is set in MySQL
  • In Microsoft SQL Server and MySQL database registration dialog, when the password is empty, the combo box in the database list is not loaded
  • Fixed bug that "Index of list exceeded range (0)" error when executing CREATE PROCEDURE with Oracle in SQL editor
  • Fixed a bug that would cause an error to be canceled in the condition dialog when using "Open with condition" by double-clicking the DB tree
  • Fixed a bug that data grid became hard to see when using black series theme
  • Fixed a problem that part of the buttons of Microsoft Access and SQLite database registration screen are not displayed on display with scale not 100%
  • Shortcut changed to Shift + Ctrl + Alt + 0 because shortcut of "Generate source string by specifying rule" in SQL editor became invalid
  • Fixed bug that "SSH tunnel local unoccupied port could not be found" error on SSH connection when only 32 bit version (?)
  • Fixed a bug that causes add-in function reading error at startup on OS not compatible with multi-byte character string
  • Fixed bug that some comment is not displayed by SQL input support

New in A5:SQL Mk-2 2.13.2 (Jun 25, 2018)

  • Fixed a bug that self-referencing relationship could not be selected in ER editor

New in A5:SQL Mk-2 2.13.1 (Jun 25, 2018)

  • "Query Generation" function from table added option to describe comment in SQL
  • Fixed a bug that layout of ER diagram property collapsed in high DPI environment (display display is larger than 100%)
  • Fixed a bug that can not change page (tab) order by drag & drop with ER editor
  • Fixed a bug that the regular expression of the method of separating DB comment into logical name and comment was not properly saved by option value
  • Fixed a bug that trying to connect to the first connected database when multiple SSH connections were made
  • Fixed bug that "Reacquisition without number restriction" does not work properly in table editor
  • Fixed an issue where access to Setting.cini might fail when operating in portable mode with Dropbox folder etc.
  • Add checkbox "Determine column caption from line comment by SELECT statement" in the Create SQL dialog
  • (Measures against the fact that there is an environment where SQL execution fails if there is a line comment)
  • Fixed bug that operation of relations crossing pages in ER diagram could not be operated

New in A5:SQL Mk-2 2.13.0 (Jun 25, 2018)

  • Delphi updated to Delphi 10.2 Tokyo
  • UniDAC updated to Version 7.1.4
  • Upgrade version of SecureBridge (SSH library) from 8.0.1 to 8.1.2
  • Materialized view support for Oracle, DB2, PostgreSQL
  • Add export & import function of registration database (password will not be exported)
  • Only x64 board can be connected to MongoDB ... (provisional correspondence may not correspond in the future)
  • Add paper size of B2, A1 in ER editor
  • Add complement completion (closing parenthesis automatic input) (It is OFF by default, you need to turn it on from the SQL editor tab of option dialog)
  • When logging SQL in portable mode, you can set to not encrypt logs from options.
  • It is possible to register colors for each DB. (Colors are displayed by DB tree, tab, pull down of DB selection etc)
  • Data is saved to a temporary table by writing BackupToTempTable quasi directive with DROP TABLE.
  • Data can be loaded from a temporary table by writing the RestoreFromTempTable quasi directive with CREATE TABLE.
  • Added pseudo-instruction CaptionList and CaptionFromComment
  • Add speed button for tab switching
  • Fix to disconnect all DB when suspending system (can be invalidated by option)

New in A5:SQL Mk-2 2.12.0 (Apr 18, 2017)

  • Changed colors of odd-numbered rows and even-numbered rows in the grid display to make them easier to see
  • When putting "table name (or column name)" and "comment" in "comment" in the database, separating ":", ",", ";" separating only tab character or newline as delimiter It was made to be used as a character. Also, you can select delimiter from option dialog
  • When displaying multiple result sets with SQL editor, Ctrl + Page Up, Ctrl + Page Down can move the tab of result set
  • The result set of the table editor and the SQL editor can be selected by Shift + mouse click
  • Added function to copy selected range with Insert statement in table editor
  • Added a function to restore the previous session backup with startup after abnormal termination
  • Enabled to connect even if SQLClient is not installed on SQL Server connection
  • Encrypted (SSL) to enable communication when connecting to SQL Server
  • Fix to specify port number when connecting to SQL Server / Interbase / Firebird
  • When entering "table name (or column name)" and "comment" in the DB comment at the time of DDL generation in the ER editor, ":", ",", ";" that only tab characters or newlines were used as delimiters So that it can be used as a delimiter
  • In the ER editor, add line (automatic), straight (vertical terminal), straight (horizontal terminal) with how to draw a relationship line
  • Unified since the handling of DB comment was different in ER diagram reverse generation and synchronization (DB → ER diagram)
  • Added a function to open a table editor by considering the word (or the word at the caret position) selected by the SQL editor as the table name
  • Added ability to create Insert statement from result set with SQL editor
  • If the result set number in the table editor is too large to acquire full authority, add a button that can "reacquire without limits"
  • Fixed so that passphrase (or user password) of SSH key file does not have to be stored internally by SSH connection
  • MySQL's 0000-00-00 correspondence
  • Updated SQL formatting function (Correspondence of common 2Way-SQL tool comments · When shifting the position of comma, AND, OR before or after expression, modify the positional relation with line comment and reshape)
  • Changed so that you can select the initial display method of binary items as option
  • Corrected MySQL to treat TEXT type as normal string type instead of CLOB
  • PostgreSQL added an option to forcibly specify encoding when connecting SQL_ASCII DB
  • Reading of CSV in ISO 8601 format with date / time type
  • Modified (integrated) the handling of BLOB and other binary items. (Display · Copy & Paste · CSV Import / Export · XML Export)
  • It is a 64-bit version and it is unnecessary for client libraries when connecting to SQLite
  • SQL connection library · SSH library version upgrade
  • Prepare English version resources