Navicat For Postgresql 12 1 19 0

Bug-fixes:

1. Double foreign key lines were printed when exporting a model to a PDF file.
2. Access violation error occurred when searching in the Backup's Object Selection tab.
3. No data value on the label when exporting a chart to a PDF file.
4. Unable to synchronize decimal precision from a model to SQL Server database.
5. Unable to rename a view inside a group in Navicat Cloud.
6. Cannot connect to Microsoft Azure Database in some cases.
7. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Improvements:

1. Support Retryable Writes and Retryable Reads for MongoDB.
2. Support tunneling on PHP 8.

Bug-fixes:

1. Unable to show accurate value of Oracle BINARY_DOUBLE type.
2. Unknown Internal Error occurred when importing Excel file in some cases.
3. Wrong SQL generated when comparing SQL Server tables with different constraint names.
4. An empty string was not quoted when exporting to a text file.
5. Query was garbled when the system locale set to Japanese.
6. Export/Import profile did not work if it was copied to Desktop.
7. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Empty rows were added when exporting more than 1.05 M records to Excel file.
2. Unable to rename Oracle views when the 'Use custom database list' option is enabled.
3. Error occurred when using Recordset Generator to generate a record set for the Date field.
4. Hanged when designing a table with many fields.
5. Error occurred when copying tables from one SQLite database to another.
6. Unable to display the definition of SQLite View in some cases.
7. Relation lines were disappeared after saving and reopening Logical Model.
8. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Unable to exclude collations when synchronizing a model to a database.
2. Functions were not properly saved as the default value in MariaDB.
3. ER diagram was reloaded when clicking the Design Table button.
4. Unable to toggle 'Virtual Type' in an existing table.
5. Error 1227 occurred when creating or designing a table.
6. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Incorrect CREATE INDEX statements were generated when comparing PostgreSQL model.
2. MySQL/MariaDB connection encoding issue.
3. Error occurred when debugging PostgreSQL functions.
4. Wrong MySQL version was detected for Microsoft Azure connection.
5. Numeric data was shown as String in the chart data source.
6. Unable to change the owners of PostgreSQL functions.
7. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Unable to show user's database privileges in MySQL 5.0.
2. Unable to change the label text color in Report's header.
3. Incorrect default value was displayed for BIT field in a new record.
4. Incorrect Foreign Key ALTER statements were generated when synchronizing PostgreSQL table structures.
5. Notification email subject was incorrect when the job finished unsuccessfully.
6. Cursor focusing issue when using Find feature in Table Viewer.
7. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Queries cannot be displayed when 'Settings Location' was set to a network path.
2. Error 80041318 occurred when setting schedule .
3. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Slow response when querying the full collection count.
2. Flashed in dark mode.
3. 'Unallowed argument in list..' error when running export / import schedule.
4. Error occurred when modifying the value in a DateTimeOffset field.
5. Unable to load version 10 data synchronization profiles.
6. Differences were incorrectly detected in Synchronize to Database.
7. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Unable to import MEMO data from DBF files.
2. Unable to reconnect SSH connection after the PC woke up.
3. Unable to display SQLite view definition in some cases.
4. Unknown Internal Error occurred when executing Oracle's package body.
5. Crashed when setting multiple cells to NULL in Table Viewer.
6. ORA-01002 error occurred when migrating data from Oracle to PostgreSQL.
7. Unable to display full Oracle view definition in some cases.
8. Incorrect PostgreSQL function definition was displayed in some cases.
9. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. 'IDENTITY_INSERT is already ON' error occurred when synchronizing SQL Server tables.
2. Unable to show records that had -1 data in Table Viewer.
3. 'Drop target objects before create' option did not work in Data Transfer.
4. Memory leak issue when enabled code completion.
5. 'Relation does not exist' error occurred when debugging a function in a schema other than the 'public' schema.
6. 'Unknown Internal Error (A70529211102SE)' error occurred when exporting / importing data.
7. Slow issue when transferring large tables.
8. Unable to show the inputted text in Filter Wizard.
9. Error occurred when filtering data by right-clicking a cell in Table Viewer.
10. 'Cannot insert into column' error occurred when transferring PostgreSQL tables.
11. Inserted records to the wrong table when transferring data to the target table with a different name.
12. 'Debugger Plugin is not installed or enabled' error occurred when the extension was installed in another schema.
13. Unable to connect MySQL server when using TLSv1.2.
14. 'COMMENT ON FUNCTION' clause was mistakenly generated when synchronizing PostgreSQL procedures.
15. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Differences were detected when re-comparing the model and the database.
2. Unable to synchronize large ndm2 model files to Navicat Cloud.
3. Unable to show users' database privileges in MySQL 5.0.
4. Negative default value displayed as '-' in MariaDB.
5. Drop-down list was blank in Table Designer.
6. Unable to scroll after switching the query results to Form view.
7. Wrong SQL generated when adding aggregates using Query Builder in SQL Server.
8. Double quotes were added to the fields of a compound index in Oracle.
9. Syntax error occurred when transferring data between two MySQL 8 servers.
10. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Improvements:

1. Support Active Directory authentication method for SQL Server.
2. Integer column exported in Number format when exporting Excel file.
3. Display export profiles in the same group of queries.

Bug-fixes:

1. The fields of PostgreSQL compound index were displayed incorrectly.
2. Unable to show index fields in PostgreSQL 9.0 .
3. Unable to set data to NULL in query results.
4. Crashed when clicking the ellipsis button in Custom Recordset.
5. Pasting data into a column cleared another column data.
6. Default Settings Location path was set to a wrong location for some cases.
7. 'Floating point division by zero' error occurred when setting the dashboard background.
8. The file extension was missing when exporting the dashboard.
9. Query Parameter did not work when using a parameter twice.
10. 'Invalid floating point operation' error occurred when adding NULL data to the chart.
11. Incorrect columns were displayed after clicking the Default button in the 'Choose columns' window
12. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Unable to set the identity seed and increment in PostgreSQL models.
2. Unable to synchronize data to MySQL 8.0.19.
3. Unable to connect AnalyticDB.
4. Unable to set SET IDENTITY_INSERT ON in Data Synchronization.
5. Unable to export data to .mdb files.
6. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

New Features:

1. New Charts
2. Advanced Data Transfer
3. Brand new Query Builder
4. Enhanced Data Modeling Tool
5. Dark theme UI and Diagram
6. Many other new features and improvements

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Query wrongly returned null results in some cases.
2. Unable to update bit type data.
3. Datetime format issue when exporting to Excel files.
4. Query Results Text pane appended values of the selected cells.
5. Syntax error occurred when renaming an index in MariaDB table.
6. 'No such column' error when adding column to SQLite table.
7. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Unable to connect Azure Database for MariaDB.
2. Crashed when running COPY XXX FROM STDIN query.
3. Table name was changed in View definition when altering SQLite table structure.
4. Wrong options were selected when loading another Data Transfer profile.
5. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Improvements:

1. SQLite library is updated.
2. Support SQLite Windows Functions.

Bug-fixes:

1. 'Unknown Internal Error' occurred when debugging PostgreSQL functions.
2. Unable to list tables when connecting to MyCat.
3. Unable to list external tables when connecting to Redshift.
4. Down arrow key did not highlight table grid cell in some cases.
5. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Failed to update records in table viewer.
2. 'Input profile is invalid' error occurred when opening export query profiles.
3. Tab was exported instead of ',' when scheduling to export CSV files.
4. Automation was failed when scheduling export profile and import profile.
5. Unable to copy and paste ',' comma decimal separator.
6. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Export process was slow.
2. Error occurred when editing Stored Aggregate Functions.
3. Unable to restore tables that included 'pg_catalog'.'name' type.
4. Unable to dump the default value of TIMESTAMP field.
5. Synchronize to Database feature wrongly detected differences of unique constraints.
6. Unable to show multiple values for list partitioning in PostgreSQL partition table.
7. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Copy and paste data issue in Table Viewer.
2. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Unable to list users for MariaDB 10.4.
2. Code Completion did not work in some cases.
3. Unable to import signed numbers when there was spaces between the sign and the number.
4. A double quote was added to the JSONB column index (PostgreSQL).
5. Unable to map a source field to multiple target fields in Import Wizard.
6. DELIMITER statements did not work in Console.
7. 'Synchronize to Database' incorrectly detected differences for unique constraints (PostgreSQL).
8. 'Cannot open file' error occurred when scheduling export profiles in some cases.
9. 'IDENTITY_INSERT is already ON for table' error occurred when transferring tables (SQL Server).
10. Unable to show empty fields in query result sets.
11. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. 'syntax error at end of input' error occurred when running CREATE RULE statement in Query Editor.
2. 'Unknown Internal Error' occurred when opening Table Designer.
3. 'syntax error at or near 'VERBOSE' occurred when using Vacuum Analyze on PostgreSQL 11 tables.
4. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Text editor did not display the full text in some cases.
2. Data Synchronization inserted values into Generated Columns.
3. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Error occurred when connecting to MySQL 4.0.
2. Unable to execute SQL files that contain 'NaN' values.
3. Primary Key checkbox was deselected when tabbing to the next field in Table Designer.
4. 'Unknown Internal' error occurred when importing data.
5. The DDL of PostgreSQL tables with 'tstzrange' data type was incorrect.
6. Table Designer cannot show the definition of MySQL 5.0 triggers.
7. Unable to set the precision of 'datetime2' data type to 0 in Table Designer.
8. The deployment scripts generated incorrect default value in Structure Synchronization.
9. 'Access Violation' error occurred after editing the data pipeline in Report.
10. 'Unknown Internal' error occurred when using Automation.
11. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. SQLite table structure cannot be modified when using an HTTP tunnel.
2. Query result pane size did not retain after minimizing the window.
3. Paradox tables cannot be imported.
4. Unknown Internal error occurred when importing data.
5. Unknown Internal error occurred when opening GridFS Buckets.
6. 'On Update Current Timestamp' option did not reflect the settings when using ANSI_QUOTES SQL mode.
7. Column order was incorrect when importing database to model.
8. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. 'Replace All' button was unable to replace the last occurrence in Query Editor.
2. Code completion suggestion list did not show on the same screen as the editor.
3. Crashed when opening Oracle table with Spatial data.
4. A table was mistakenly transferred even it was not selected.
5. Incorrect syntax highlighting issue in Query Editor.
6. MySQL trigger definition displayed as .
7. Unable to transfer unique index from MySQL to SQLite.
8. Filter criteria input box was not retained when switching applications.
9. Drag and drop selected text on Query Editor did not move the text.
10. JSON expression did not display correctly in Table Designer.
11. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Improvements:

1. Add a 'Drop with CASCADE' option for deleting PostgreSQL objects.

Bug-fixes:

1. Crashed when opening Oracle table with Spatial data.
2. 'Cannot add foreign key constraint' error occurred when importing Access file.
3. Code completion box displayed off the bottom of the screen and partially obscured.
4. Unable to customize query result tab name by using /*NAME:XYZ*/ .
5. Hanged when executing script files in MongoDB server.
6. Boolean or BIT(1) values importing, exporting and transferring issue.
7. Copying table field names in Table Designer was slow.
8. Table Form view was unable to show jpg images.
9. Unable to import data when using Append/Update mode.
10. Importing files to Oracle server was slow.
11. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Error occurred when modifying a MongoDB view and auth was enabled.
2. Unable to change variable's value when debugging Oracle function.
3. SQL order issue in Structure Synchronization.
4. Console window was not colored when connection coloring were set.
5. Unable to specify the minimum property when designing a collection in MongoDB.
6. Unable to save PostgreSQL function in some cases.
7. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Main New Features:

1. Support of MongoDB
2. Support of Roles for MySQL 8
3. Support of Roles for MariaDB 10
4. Support of Partitioned Table for PostgreSQL 10
5. Brand new Filter Wizard
6. UI and UX Improvement
7. MongoDB is added in Navicat Premium
8. Navicat for MongoDB is released

To upgrade, please visit our Customer Center.

Bug Fixes:

1. File encoding was incorrect when transferring database to SQL file.
2. The generated CREATE PROCEDURE statement was incorrect when dumping database to SQL file.
3. Structure Synchronization detected differences after synchronizing.
4. Incorrect unique values were imported from .dbf file.
5. Crashed when saving the modified field names in some cases.
6. Extra '(' was added to INSERT statements when deploying scripts in Data Synchronization.
7. Foreign keys were not transferred when transferring tables from MySQL to SQLite.
8. Unable to restore LONGTEXT data completely from .psc file.
9. .ndm file association was not worked.

To upgrade, please visit our Customer Center.

Improvements:

1. Supported to connect MySQL 8 using SHA2 connection.

Bug Fixes:

1. 80041318 error occurred when saving a task schedule.
2. The cursor position row moved to the bottom line after saved the procedure/function.
3. 'XXX is not a valid value' error occurred when editing a PostgreSQL model table in some cases.
4. Syntax error occurred when updating MySQL user password.
5. Transaction did not end after closing the table in some cases.
6. Error occurred when there was a 'CRLF' character in Oracle procedure.

To upgrade, please visit our Customer Center.

Bug Fixes:

1. Unable to transfer objects between different server types by drag-and-drop.
2. Zero decimal place digits were not displayed in Table Viewer.
3. 'Double' format issue for SQL Server in Table Viewer.
4. Exported SQL file did not have table name when exporting an unsaved query.
5. Incorrect SQL 'ON UPDATE CURRENT_TIMESTAMP(0)' was dumped for MariaDB 5.5 tables.
6. The privileges of PostgreSQL functions with parameters were not visible in Privilege Manager.
7. Error occurred when transferring BLOB data from MySQL to SQL Server.
8. Unknown Internal Error occurred when importing from ODBC.
9. Incorrect dates were exported when exporting PostgreSQL tables to Excel files.
10. Syntax error occurred when importing CSV files in some cases.
11. Database names were missing in the Drop SQL generated by Structure Synchronization.
12. ORA-01830 error occurred when transferring tables to Oracle server in some cases.
13. Unable to change the Tab Width in Query Editor.
14. Unable to edit query results when tables had alias.
15. Procedure parameters were missing in the scripts generated by Structure Synchronization.
16. Unknown Internal Error occurred when Automation ran.
17. Unable to transfer tables with HEX format.
18. Default parameter syntax was stripped after saving PostgreSQL function.
19. Syntax error occurred when creating PostgreSQL function with array parameters.
20. Encoding issue of the exported text file.
21. Unable to show the SQLite CTE based view definition in View Designer.
22. Crashed when the Oracle host name was longer than 1000.

To upgrade, please visit our Customer Center.

Bug Fixes:

1. 'Access Violation' error occurred when creating new connections in fresh installed Navicat.

To upgrade, please visit our Customer Center.

Bug Fixes:

1. Unable to create a query inside a group.
2. The color of function keywords did not change according to the Font Color settings in Options.
3. Column width did not retain after hide and show the column in Table Viewer.
4. Unable to drag and drop a query into a group in some cases.
5. 'SQL Logic' error occurred when loading SQLite extension.
6. Unable to edit query results in some cases.
7. Unable to disable Foreign Key constraint in Data Synchronization.
8. Crashed when dumping table to sql file in some cases.
9. Foreign Key constraint didn't work when the constraint name was empty in SQLite.
10. DROP PROCEDURE statements in Structure Synchronization did not include the schema name.
11. Some setting values was missing in SQLite Trigger Designer.
12. Foreign Key constraint issue in Import Wizard.
13. Unable to show the SQLite CTE based view definition in View Designer.
14. SQLite connections was missing in Model's Import from Database feature.
15. Code completion replaced the text after caret.
16. Exported files or reports were not attached to the notification email.
17. Plugin error occurred when using RSA/PAM authentication for MariaDB connections.
18. Keepalive Interval setting attempted to connect continuously even the database was down.
19. If a query was opened, abnormal behavior happened when closing Navicat.
20. Automation did not start when the computer was logged out.
21. Unable to create new table with primary key settings in Import Wizard.

To upgrade, please visit our Customer Center.

Improvements:

1. Supported creating PostgreSQL 10 Models.
2. Supported Microsoft Azure Database for MySQL.

Bug Fixes:

1. RAISE NOTICE events did not show in Message Log.
2. Spaces were missing in the SQL exported from Model.
3. Extra newlines were added to the SQL exported from Model.
4. Unable to change the comment of PostgreSQL functions with named parameters.
5. 'Hourly' option was missing on Task Schedule's Trigger tab.
6. Wrong datestamp was appended to the exported files.
7. Added records showed wrong values until refreshing SQLite table grid.
8. Slow issue when searching in Table Viewer.
9. Unable to move functions into a group.
10. Syntax error occurred when running query in some cases.
11. Unable to select Enum data in query results.
12. 'Unknown Internal Error' occurred when opening SQLite tables.
13. 'Invalid byte sequence for encoding' error occurred when opening PostgreSQL tables.
14. Target functions/procedures were not dropped before create when synchronizing structure.
15. Unable to synchronize models/queries in Navicat Cloud.
16. Exported Excel files were corrupted in some cases.
17. 'Access is denied' error occurred when setting schedule.

To upgrade, please visit our Customer Center.

New Features:

1. New UI/UX.
2. On Startup: open favorite tabs automatically when Navicat launches.
3. Code Snippet.
4. Advanced Code Completion with better suggestions.
5. Brand new Structure Synchronization: visually show side-by-side DDL comparison between two databases.
6. Brand new Data Synchronization: show particular status to distinguish the differences between records easily.
7. New Automation: easy to find desired profiles and create automated batch jobs.
8. Responsiveness and performance improved.
9. Many other new features and improvements.

To upgrade, please visit our Customer Center.

Bug Fixes:

1. Fixed the CREATE PACKAGE and CREATE PACKAGE BODY issue in SQL Editor.
2. Error occurred when exporting with Time field type.
3. Error occurred when importing identity column in SQL Server.
4. Unable to insert trigger in Table Viewer.
5. Removed 'WHEN()' if 'When Clause' is NULL for Oracle trigger.
6. 'Argument out of range' occurred when running 'Reverse Database to Model'.
7. Wrong Oracle SQL statements were generated wrong when running 'Synchronize to Database' in Model.
8. Fixed the Oracle varchar2 issue when running 'Synchronize to Database' in Model.
9. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug Fixes:

1. Cannot to show PostgreSQL large decimal data properly in Table Viewer.
2. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug Fixes:

1. Unable to show some errors in MySQL Console.
2. Crashed when using Query in some cases.
3. 'IGNORE_DUP_KEY' was always set to 'ON' for SQL Server in Structure Synchronization.
4. Query auto-save feature did not work in some cases.
5. Debugger did not work for PostgreSQL 8.3 to 9.0.

To upgrade, please visit our Customer Center.

Bug Fixes:

1. Unable to move PostgreSQL function with special parameter to virtual group.
2. Error occurred when getting MySQL query status.
3. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Major New Features:

Navicat Cloud Collaboration

1. Create/Modify/Delete projects.
2. Add members to project for sharing connection settings, queries and models.
3. View Project Activity Log.

PostgreSQL Objects

1. Support Foreign Server with User Mapping.
2. Support Foreign Table.
3. Support PostgreSQL Debugger.
4. Enhanced Object Designers.

Data Modeling Tool

1. Support Model Conversion.
2. Support Views.
3. Enhanced Table Designer.

Others

1. SQLite Users Management.
2. Enhanced Connection Coloring.
3. Search database object structure.

To upgrade, please visit our Customer Center.

Improvements:

1. Supported PostgreSQL 9.5.
2. Enhanced Stored Procedure editor.

Bug Fixes:

1. Exported result incorrect for TIME field type in Export Wizard.
2. File name with appended timestamp issue in Export Wizard.
3. Wrong caption/icon showed for Stored Procedure.
4. Unable to synchronize BIT fields for PostgreSQL tables in Data Synchronization.
5. Slow performance when showing/hiding column with Memo editor opened.
6. SSH protocol error issue.

To upgrade, please visit our Customer Center.

Bug Fixes:

1. Foreign keys were re-created when editing Oracle tables in Table Designer.
2. Generated object SQL identifier without escaping quote characters in Model.
3. Unable to load the virtual group settings file created by old versions of Navicat.
4. After sorted a selected column in Table Viewer, access violation occurred when resizing column width.

To upgrade, please visit our Customer Center.

Improvements:

1. Reset the field length to default value after changing the auto guessed field type in Table Designer.

Bug Fixes:

1. Access violation error occurred when entering SQL in Query.
2. Cannot access field 'Super_priv' as type Boolean error occurred when managing MySQL/MariaDB Users.
3. Unable to download source files with HTTPS connection in Import Wizard.
4. Failed to create/edit users for MySQL 5.7.6.
5. 'Cannot create oci environment' error occurred in Oracle connections.

To upgrade, please visit our Customer Center.

Improvements:

1. Improved the Message Log information.

Bug Fixes:

1. Table Designer did not allow to edit MySQL table partition's Values setting.
2. Failed to generate PostgreSQL index field clause in Structure Synchronization.
3. Unable to drop columns for PostgreSQL View in View Designer.
4. Unable to identify equality of trigger definitions with different system line breaks in Structure Synchronization.
5. Code Completion did not parse SQL Server PIVOT SQL clause properly in Query Editor.
6. Unable to generate the SET clause properly for Oracle when using update mode in Import Wizard.
7. Unable to generate MySQL table SQL with charset binary properly in Structure Synchronization.
8. Code Completion added smart quote wrongly for utc_date() in Query Editor.
9. Unable to convert object names in Data Transfer when using Schedule.
10. Unable to transfer MariaDB triggers in Data Transfer.

To upgrade, please visit our Customer Center.

New Features:

1. Support to sync selected connection settings, queries, model files and virtual group information to Navicat Cloud. For more information, please visit here.

Improvements:

1. Support PostgreSQL 9.3 Materialized View.
2. Support SQLite 3.8 WITHOUT ROWID.
3. Support parameter in Report command line.
4. Support adding shapes in Model.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Crashed when running scripts in some cases.
2. Crashed when copying records in some cases.
3. The TEXT pane did not retain when running queries.
4. Cannot connect to Microsoft Azure Database in some cases.
5. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Unable to dump databases from MongoDB Atlas using MongoDump.
2. Unable to show the cursor when editing TEXT data using Form View in Dark Mode.
3. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Mac blu ray player 2 16 16 2416. Bug-fixes:

1. Crashed when adding relations to a logical model.
2. Differences were incorrectly detected when synchronizing MySQL table structures.
3. Crashed when running query in some cases.
4. Error occurred when transferring SQL Server tables with user-defined types to other server types.
5. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Unable to update data in some cases.
2. Crashed when adding a trigger to PostgreSQL model.
3. Crashed when using Data Transfer in some cases.
4. Exporting JSON field didn't handle NULL and integer values properly.
5. Cursor did not focus to the Search box after pressing CMD-F.
6. Crashed when selecting the 'Group by Object Type' in Structure Synchronization.
7. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Unable to read grid data in Dark mode.
2. Unable to sort the last column by clicking the column header in Table Viewer.
3. Duplicate entry error occurred when editing the pasted records.
4. Unable to connect to server via SSH Tunnel in some cases.
5. Hanged when starting Navicat in some cases.
6. 'Different primary key type' error occurred when synchronizing MySQL data.
7. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. 'Primary key needs to be integer' error occurred when synchronizing data.
2. Unable to show the ENUM items list in Table Viewer.
3. Unable to sort by clicking the column header in Table Viewer.
4. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Crashed when modifying PostgreSQL permissions.
2. Only 10,000 records were exported when exporting MongoDB collection.
3. Data Synchronization UX issue.
4. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Improvements:

1. Set the values of a column to NULL.

Bug-fixes:

1. Crashed when saving MariaDB Views.
2. The modified dates of backup files were incorrect.
3. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Improvements:

1. Prompt to change the MariaDB password when it expired.

Bug-fixes:

1. Unable to show the granted privileges if the database name contained wildcard characters.
2. Only the last selected table was printed when printing multiple tables.
3. The SQL Editor was flickered and repainted when saving the query.
4. 'Auto Increment' and 'Unsigned' options were removed after adding another field.
5. Crashed when using Query Builder on Big Sur.
6. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. The 'Set to Null' option was applied to a wrong column when some columns were hidden in Table Viewer.
2. The field size was incorrect in Form View.
3. Crashed when opening/testing a connection after changing 'Settings Location' to a folder in Documents.
4. The 'SQLite3 Dynamic Library' option did not work.
5. The 'Encoding' setting was not stored when the connection was synchronized to Navicat Cloud.
6. 'Dump SQL File' stopped running in some cases.
7. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Unable to set the encoding of MariaDB connection.
2. Unable to connect MySQL server when using TLSv1.2.
3. Schedule did not trigger when using Navicat App Store version.
4. The 'Close Database' option in the context menu was dimmed when a query tab was focused.
5. The entire connection tree was collapsed when searching.
6. Crashed when deleting a data source in Charts.
7. Crashed when connecting to MongoDB in some cases.
8. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Improvements:

1. Improvement on resizing Information pane.

Bug-fixes:

1. Negative default value displayed as '-' in MariaDB.
2. No records were imported in some cases when Import Wizard displayed 'Finished Successfully'.
3. Wrong SQL generated for CAST function when switching between Query Editor and Query Builder.
4. 'Authentication failed' error occurred when using MongoDump.
5. Crashed when running MongoDB query for the second time.
6. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Error occurred when running a valid updateMany query.
2. Unable to show full table names in the Data Synchronization window.
3. Field names in the Join dialog were truncated.
4. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. MongoDB data export failed.
2. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Jumped to the first record when refreshing in Form View.
2. Unable to synchronize data to MySQL 8.0.19.
3. Unable to connect AnalyticDB.
4. Unable to set SET IDENTITY_INSERT ON in Data Synchronization.
5. The list of the reference tables for foreign key was empty in Model.
6. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Scrolling was slow in data viewer.
2. 'Error moving files' error occurred when accessing Navicat Cloud.
3. The color picker disappeared in diagram.
4. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

New Features:

1. New Charts
2. Advanced Data Transfer
3. Brand new Query Builder
4. Enhanced Data Modeling Tool
5. Dark theme UI and Diagram
6. Many other new features and improvements

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Data Synchronization options were unable to save in profile.
2. Unable to copy SQL query from Process List in Server Monitor.
3. 'Option' button was missing in the file selection window of Import Wizard.
4. Minor bug fixes and improvements.

Highland 2 0 5 – powerful straightforward screenwriting appropriate. To upgrade, please visit our Customer Center.

Bug-fixes:

1. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Unable to show tables in PostgreSQL 12.
2. Unable to change the Settings Location path of Navicat Cloud connections.
3. A red exclamation mark was incorrectly displayed on the Navicat Cloud query icon.
4. 'Add Object Privileges' UI issue when using Dark Mode.
5. Crashed when connecting to MongoDB database.
6. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Byte type integer was default converted to bytea when importing from Access files.
2. Unable to search in menu bar / Help.
3. Unable to show the database list when there was more then 255 databases.
4. Data Transfer process was stopped in some cases.
5. Error occurred when running 'select * from table1 where field1 like '%SA_%' escape ';'.
6. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Unable to list users for MariaDB 10.4.
2. Error occurred when running multiple SQL Server queries (ended with ;) in Query Editor.
3. List View was not retained in the main window after restarting Navicat.
4. The backup context menu was incorrect when the SQL Server connection was not opened.
5. 'Field 'type' is currently not supported.' error occurred when listing MongoDB collections.
6. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Unable to transfer views from MySQL to MariaDB.
2. Crashed when running query in some cases.
3. Unable to use the Add Privilege button.
4. Unable to add, edit or remove users in AWS Redshift instance.
5. Connections moved out of the group after editing.
6. 'Incorrect syntax near ',' occurred when importing accdb file to SQL Server.
7. Crashed when editing model in some cases.
8. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Empty tables were created when importing .accdb file.
2. Run Selected option did not run all highlighted text when using shortcut to select the SQL.
3. SSH connection dropped issue.
4. Unable to retain selected columns in Foreign Key Selection window.
5. PostgreSQL SCRAM authentication did not work properly.
6. Data Synchronization data grid UI issue in Dark Mode.
7. Data Synchronization inserted values into Generated Columns.
8. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Error occurred when connecting to MySQL 4.0.
2. Missing 'Tools' menu when running an infinite loop in Console.
3. Crashed when comparing databases in Structure Synchronization.
4. Login failed when connecting to Azure SQL Database.
5. Crashed when saving models.
6. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Grid View and Form View menu options were flipped.
2. SQLite table structure cannot be modified when using an HTTP tunnel.
3. 'On Update Current Timestamp' option did not reflect the settings when using ANSI_QUOTES SQL mode.
4. The row height of the object list did not match the font size.
5. Column order was incorrect when importing database to model.
6. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Improvements:

1. Enter the datetime value directly in the Filter.
2. Add a 'Drop with CASCADE' option for deleting PostgreSQL objects.

Bug-fixes:

1. Crashed when opening a database in some case.
2. If the filter value box was opened, Navicat window disappeared when switching to another App.
3. Crashed when using Find feature after updating the data.
4. Crashed when code completion was triggered in large query.
5. Freeze when entering/exiting Full Screen.
6. Selected connection, database and schema names were missing in Data Transfer window.
7. 'Directory' textbox became empty when creating SQL Server database.
8. Structure Synchronization was unable to create SQL Server primary or secondary XML indexes.
9. 1146 error occurred when duplicating MySQL 8.0 functions.
10. SQL Server Data Transfer was slow.
11. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Unable to search the grouped queries unless the group was selected.
2. Crashed when using Find in Database/Schema if the connection was not opened.
3. Field comment font color issue when using Dark Mode.
4. SSH key file reselect issue when opening connection in App Store version.
5. Crashed when creating a project.
6. Beautify SQL feature wrongly split text which started with numbers.
7. Row highlight issue when using Dark Mode.
8. Crashed when opening Datetime picker window in Table Viewer.
9. Unable to show line number in SQL Editor on macOS 10.14.
10. Code Folding did not work properly in SQL Editor on macOS 10.14.
11. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Main New Features:

1. Support of MongoDB
2. Support of Roles for MySQL 8
3. Support of Roles for MariaDB 10
4. Support of Partitioned Table for PostgreSQL 10
5. Brand new Filter Wizard
6. UI and UX Improvement
7. MongoDB is added in Navicat Premium
8. Navicat for MongoDB is released

To upgrade, please visit our Customer Center.

Bug-fixes:

1. The Not Null checkbox states were inverted in Oracle Table Designer.
2. Unable to rename table with double-click in some cases.
3. Sorting Rows column on the Objects tab did not work properly.
4. Command-W shortcut did not close the active window in some cases.
5. Some menu items were missing in Table Designer.
6. Export Wizard did not add a leading zero to pad days and months to two digits.

To upgrade, please visit our Customer Center.

Improvements:

1. Ability to copy comparison results of Model.
2. Added thousand separators to the row count on the table objects list.

Bug Fixes:

1. Crashed when opening Navicat if invalid characters were used for the paths in Preferences.
2. The generated CREATE PROCEDURE statement was incorrect when dumping database to SQL file.
3. Unable to execute Navicat commands using Automator.

To upgrade, please visit our Customer Center.

Improvements:

1. Supported to connect MySQL 8 using SHA2 connection.
2. Supported coloring the Objects tab when a colored connection is selected.
3. Improved table mapping in Import Wizard.
4. Improved keyboard navigation with tab key in Import Wizard.

Bug Fixes:

1. Left single quotation mark was wrong style when inputting in Form View.
2. Error occurred when deleting multiple users in SQL Server.
3. Extra '(' was added to INSERT statements when deploying scripts in Data Synchronization.
4. Objects list loading was slow in some cases.
5. Zero decimal place digits were not displayed in Table Viewer.

To upgrade, please visit our Customer Center.

Bug Fixes:

1. Incorrect SQL 'ON UPDATE CURRENT_TIMESTAMP(0)' was dumped for MariaDB 5.5 tables.
2. Crashed when starting Navicat.
3. Unable to edit query results when tables had alias.
4. Exported files were not attached to the notification email.
5. Procedure Parameters was missing when synchronizing structure.
6. Unable to filter connections in the Navigation Pane.
7. Error occurred when importing data to TIMESTAMP(6) fields.
8. Profile icons did not have indicator after adding attachments in Batch Job.

To upgrade, please visit our Customer Center.

Bug Fixes:

1. Unable to copy error messages in Query.
2. Database name was added to the query when using Query Builder.
3. Unable to show the Oracle Package Body definition.
4. XML file data was not imported to JSON fields completely.
5. Unable to edit data in Query result set in some cases.
6. Adjusting the height of split screen in Table Designer was not allowed.
7. Crashed when selecting or editing Procedure SQL in Query Editor.
8. Incorrect SQL was generated when changing Primary Key name in Table Designer.
9. Query column width reset after restarting Navicat.
10. Memory leak issue.
11. 'Fields' and 'Referenced Fields' values were vanished after saving and moving cursor to another Foreign Key.
12. Field properties were not shown when adding a field in Table Designer.
13. Incorrect field name were shown when moving a field in Table Designer.
14. UI issue in Full Screen mode.
15. Exported Excel files were corrupted in some cases.

To upgrade, please visit our Customer Center.

Improvements:

1. Supported Microsoft Azure Database for MySQL.

Bug Fixes:

1. Unable to open Console if a non-tabbed window was opened in font.
2. Incorrect syntax error occurred when transferring SQL Server tables.
3. Added records showed wrong values until refreshing SQLite table grid.
4. Navicat hanged when refreshing table grid after changing field names.
5. Navicat process was unable to terminate.

To upgrade, please visit our Customer Center.

New Features:

1. New UI/UX.
2. On Startup: open favorite tabs automatically when Navicat launches.
3. Code Snippet.
4. Advanced Code Completion with better suggestions.
5. Brand new Structure Synchronization: visually show side-by-side DDL comparison between two databases.
6. Brand new Data Synchronization: show particular status to distinguish the differences between records easily.
7. New Automation: easy to find desired profiles and create automated batch jobs.
8. Responsiveness and performance improved.
9. Many other new features and improvements.

To upgrade, please visit our Customer Center.

Bug Fixes:

1. Failed to export SQLite views with alias field names.
2. Crashed when dumping certain PostgreSQL SQL statements.
3. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug Fixes:

1. Failed to save Oracle trigger changes when trigger definition is updated in Trigger Designer.
2. Crashed when transferring certain Oracle Timestamp values in Data Transfer.
3. Failed to move procedures to a virtual group.
4. Unable to create roles in PostgreSQL 9.6.
5. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug Fixes:

1. Unable to show errors when running query in some cases.
2. Failed to import JSON files in some cases.
3. Query Editor window has disappeared when it lost focus.
4. Failed to parse PostgreSQL rules with 'DO INSTEAD NOTHING' when dumping SQL.
5. Some options were wrongly displayed in Essentials Edition.
6. Unable to save the changes in Oracle Package Body Designer.
7. Settings Location was wrongly copied when duplicating connection.

To upgrade, please visit our Customer Center.

Major New Features:

Navicat Cloud Collaboration

1. Create/Modify/Delete projects.
2. Add members to project for sharing connection settings, queries and models.
3. View Project Activity Log.

PostgreSQL Objects

1. Support Foreign Server with User Mapping.
2. Support Foreign Table.
3. Support PostgreSQL Debugger.
4. Enhanced Object Designers.

Data Modeling Tool

1. Support Model Conversion.
2. Support Views.
3. Enhanced Table Designer.

Others

1. SQLite Users Management.
2. Enhanced Filter Wizard.
3. Enhanced Query Designer.

To upgrade, please visit our Customer Center.

Bug Fixes:

1. Failed to log in Navicat Cloud in some cases.
2. Crashed when running Structure Synchronization.
3. Failed to open SQL Server connections on Mac OS X 10.9 or below.

To upgrade, please visit our Customer Center.

Bug Fixes:

1. Unable to copy backup files to another database by drag and drop method.
2. Crashed when running Data Transfer more than once on OS X 10.11.
3. Froze when operating Table Viewer with longtext data.
4. Crashed when running stored procedures on OS X 10.11.
5. Template database name has not escaped when creating PostgreSQL database.
6. Crashed when adding password using MD5 function in Table Viewer Raw mode.
7. Crashed when running SQL multi times in Console.
8. Unable to login SQL Server with password contains ';'.
9. Unable to set the default value of the bit type in Table Designer.

To upgrade, please visit our Customer Center.

Bug Fixes:

1. Incorrect schema name for CREATE INDEX or TRIGGER SQL for PostgreSQL in Structure Synchronization.
2. Crashed when getting table constraints due to extra constraints created by PostgreSQL extension earthdistance.
3. Showed wrong database in Connection Tree.
4. Execute SQL file did not output errors in some cases.
5. Lost local connections after Navicat crashed during synchronizing to Navicat Cloud.
6. App Store version: In-App Purchase did not work in Mac OS X 10.11.

To upgrade, please visit our Customer Center.

Improvements:

1. Supported format strings in Schedule email body.

Bug Fixes:

1. Unable to send notification email in Schedule.
2. Wrongly updated the SQL Server table identity columns in Import Wizard.
3. Created a new connection when previewing a view or a materialized view.
4. Syntax error occurred when updating SQL Server tables in Table Viewer.
5. 'Database file path is not correct' error occurred when opening SQLite database files from finder.
6. Crashed when dumping SQL Server tables to a SQL file.
7. Unable to change the case of the backup file name.
8. Failed to synchronize Row Format when creating MySQL tables in Structure Synchronization.
9. Lost connections in some cases.

To upgrade, please visit our Customer Center.

Bug Fixes:

1. Unable to show error messages when saving SQL Server procedures.
2. Crashed when importing connections.
3. Error occurred when using profile to perform Data Synchronization for PostgreSQL.
4. SQL Server connection would hang when the connection was disconnected.
5. Crashed when reversing database to model.
6. Generated incorrect SQL for foreign keys when transferring Oracle tables to a SQL file.

To upgrade, please visit our Customer Center.

Bug Fixes:

1. Unable to connect PostgreSQL with password contained single quote/backslash characters.
2. Object List tab did not change when selecting nodes from connection tree.
3. Unable to synchronize or export model to SQL Azure.
4. Unable to send email when running batch jobs using Command Line.
5. Failed to save the order of connections in Navicat Cloud.
6. Unable to transfer PostgreSQL index when index field contained function.

To upgrade, please visit our Customer Center.

Bug Fixes:

1. Unable to edit BLOB field's text data on TEXT editor.
2. Error occurred when opening SQL Server 2005 and SQL Azure connections.
3. Unable to use CMD-Y New Query shortcut after selecting Tables, Views, etc nodes on Connection Tree.
4. .wal and .shm files were not deleted after closed SQLite connections.
5. Failed to create/edit users for MySQL 5.7.6.
6. Failed to run schedule for connections in Navicat Cloud.
7. Cursor did not focus on Query Editor when opening a query.

To upgrade, please visit our Customer Center.

Bug Fixes:

1. Fixed the escape character data issue for PostgreSQL tables in Data Transfer.
2. Unable to insert/update/delete money type in Table Viewer and Data Transfer for SQL Server 2000.
3. Wrongly showed MySQL/MariaDB TEXT fields with collation xxx_bin as BLOB fields in Table Viewer.
4. Fixed import DBF file with empty datetime value issue.
5. Crashed when typing 'create function test (in_' in Query Editor.
6. Error occurred when opening SQL Server 2008 R2 schemas.
7. Error occurred when opening SQLite files with the same name by double-clicking the database files.

To upgrade, please visit our Customer Center.

Improvements:

1. Added the ability to copy column name with data and copy records as Insert/Update statements in Query/View Result.

Bug Fixes:

1. App Store Essentials version: Fixed unable to copy query by drag-and-drop method.
2. Fixed the SQL Azure connection hang issue.
3. Fixed the time interval setting issue in Schedule.
4. Fixed the multi headers issue when exporting multi SELECT query to XML file.
5. Fixed the warning issue when renaming query.
6. Fixed unable to handle delimiter statements issue in Execute SQL File.

To upgrade, please visit our Customer Center.

New Features:

1. Support to sync selected connection settings, queries, model files and virtual group information to Navicat Cloud. For more information, please visit here.

Improvements:

1. Support PostgreSQL 9.3 Materialized View.
2. Support adding shapes in Model.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Unable to launch Navicat after upgrading the system to use GLib-2.70.0 .
2. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Crashed when viewing or adding emoji data.
2. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. The Stop button did not work when processing deletion in the table viewer.
2. Error occurred when editing data in query results.
3. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. '2013 - Lost connection to MySQL' error often occurred when the 'Keepalive interval' option was enabled.
2. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Crashed when the query returned a large result set.
2. Not all matching data was highlighted when searching the query results.
3. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Crashed when working with PostgreSQL.
2. Crashed after refreshing the table.
3. Unable to set privileges for PostgreSQL functions.
4. Crashed when importing PostgreSQL database to the model.
5. Hanged when dragging a table from the main window to the model window.
6. Incorrect default field size issue in Table Designer.
7. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. CTRL+R shortcut did not apply the filter.
2. Unable to view TEXT data in Data Synchronization.
3. Unable to show the input text in Table/Collection Viewer when using Dark Mode.
4. Missing the primary key warning in Table Viewer.
5. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Unable to export the fractional part when the decimal separator was comma.
2. Unable to select privileges in the 'Add Privilege' window by using the Space key.
3. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Crashed when restoring the backup file to another database.
2. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. 'IDENTITY_INSERT is already ON' error occurred when synchronizing SQL Server tables.
2. Crashed when using Charts in some cases.
3. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. The number of processes was missing in the Server Monitor window.
2. Unable to delete multiple fields in Table Designer.
3. The tab of Table Designer did not mark with * after deleting a field.
4. Some buttons were disabled at all times in New Query.
5. Unable to copy and paste multiple rows data to another table.
6. Right-clicking a row header in data grid highlighted the corresponding column.
7. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Crashed when editing functions.
2. No server, database and schema were selected when opening query.
3. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Negative default value displayed as '-' in MariaDB.
2. An empty diagram was created when reversing a database to a model.
3. Unable to change font for Editor and Records.
4. Unable to display special characters of SQL Server query results.
5. The selected privileges were inverted when adding database privileges.
6. Error occurred when changing user password in MySQL 5.6.
7. CREATE USER statement on the SQL Preview tab was wrong.
8. Query returned different results for an empty row.
9. DROP DEFAULT clause was incorrectly added to the statement when opening PostgreSQL table designer.
10. Unable to copy the selected text with shortcut in Console.
11. Crashed when importing tables to a model.
12. Unable to add a table to the model using the mouse.
13. Delay when pasting with CTRL+V.
14. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Crashed when synchronizing Navicat Cloud on Ubuntu OS.
2. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. CTRL+Z, CTRL+Y, ESC shortcuts did no work when editing table columns.
2. Unable to change MySQL/MariaDB user password.
3. Unable to copy variables in Server Monitor.
4. Virtual field expression was displayed as ******.
5. Unable to copy and paste views to other databases.
6. Unable to copy and paste indexes in Table Designer.
7. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

New Features:

1. Native Linux Support
2. Support of SQL Server
3. New Charts
4. Advanced Data Transfer
5. Brand new Query Builder
6. Enhanced Data Modeling Tool
7. Dark theme UI and Diagram
8. Many other new features and improvements

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Unable to connect Azure Database for MariaDB.
2. Crashed when running COPY XXX FROM STDIN query.
3. Table name was changed in View definition when altering SQLite table structure.
4. Wrong options were selected when loading another Data Transfer profile.
5. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Improvements:

1. SQLite library is updated.
2. Support SQLite Linux Functions.

Bug-fixes:

1. 'Unknown Internal Error' occurred when debugging PostgreSQL functions.
2. Unable to list tables when connecting to MyCat.
3. Unable to list external tables when connecting to Redshift.
4. Down arrow key did not highlight table grid cell in some cases.
5. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Failed to update records in table viewer.
2. 'Input profile is invalid' error occurred when opening export query profiles.
3. Tab was exported instead of ',' when scheduling to export CSV files.
4. Automation was failed when scheduling export profile and import profile.
5. Unable to copy and paste ',' comma decimal separator.
6. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Export process was slow.
2. Error occurred when editing Stored Aggregate Functions.
3. Unable to restore tables that included 'pg_catalog'.'name' type.
4. Unable to dump the default value of TIMESTAMP field.
5. Synchronize to Database feature wrongly detected differences of unique constraints.
6. Unable to show multiple values for list partitioning in PostgreSQL partition table.
7. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Copy and paste data issue in Table Viewer.
2. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Unable to list users for MariaDB 10.4.
2. Code Completion did not work in some cases.
3. Unable to import signed numbers when there was spaces between the sign and the number.
4. A double quote was added to the JSONB column index (PostgreSQL).
5. Unable to map a source field to multiple target fields in Import Wizard.
6. 'Synchronize to Database' incorrectly detected differences for unique constraints (PostgreSQL).
7. 'Cannot open file' error occurred when scheduling export profiles in some cases.
8. 'IDENTITY_INSERT is already ON for table' error occurred when transferring tables (SQL Server).
9. Unable to show empty fields in query result sets.
10. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. 'syntax error at end of input' error occurred when running CREATE RULE statement in Query Editor.
2. 'Unknown Internal Error' occurred when opening Table Designer.
3. 'syntax error at or near 'VERBOSE' occurred when using Vacuum Analyze on PostgreSQL 11 tables.
4. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Text editor did not display the full text in some cases.
2. Data Synchronization inserted values into Generated Columns.
3. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Error occurred when connecting to MySQL 4.0.
2. Unable to execute SQL files that contain 'NaN' values.
3. Primary Key checkbox was deselected when tabbing to the next field in Table Designer.
4. 'Unknown Internal' error occurred when importing data.
5. The DDL of PostgreSQL tables with 'tstzrange' data type was incorrect.
6. Table Designer cannot show the definition of MySQL 5.0 triggers.
7. Unable to set the precision of 'datetime2' data type to 0 in Table Designer.
8. The deployment scripts generated incorrect default value in Structure Synchronization.
9. 'Access Violation' error occurred after editing the data pipeline in Report.
10. 'Unknown Internal' error occurred when using Automation.
11. Unable to duplicate model files.
12. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. SQLite table structure cannot be modified when using an HTTP tunnel.
2. Query result pane size did not retain after minimizing the window.
3. Paradox tables cannot be imported.
4. Unknown Internal error occurred when importing data.
5. Unknown Internal error occurred when opening GridFS Buckets.
6. 'On Update Current Timestamp' option did not reflect the settings when using ANSI_QUOTES SQL mode.
7. Column order was incorrect when importing database to model.
8. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. 'Replace All' button was unable to replace the last occurrence in Query Editor.
2. Code completion suggestion list did not show on the same screen as the editor.
3. Crashed when opening Oracle table with Spatial data.
4. A table was mistakenly transferred even it was not selected.
5. Incorrect syntax highlighting issue in Query Editor.
6. MySQL trigger definition displayed as .
7. Unable to transfer unique index from MySQL to SQLite.
8. Filter criteria input box was not retained when switching applications.
9. Drag and drop selected text on Query Editor did not move the text.
10. JSON expression did not display correctly in Table Designer.
11. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Improvements:

1. Add a 'Drop with CASCADE' option for deleting PostgreSQL objects.

Bug-fixes:

1. Crashed when opening Oracle table with Spatial data.
2. Code completion box displayed off the bottom of the screen and partially obscured.
3. Unable to customize query result tab name by using /*NAME:XYZ*/ .
4. Hanged when executing script files in MongoDB server.
5. Boolean or BIT(1) values importing, exporting and transferring issue.
6. Copying table field names in Table Designer was slow.
7. Table Form view was unable to show jpg images.
8. Unable to import data when using Append/Update mode.
9. Importing files to Oracle server was slow.
10. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug-fixes:

1. Error occurred when modifying a MongoDB view and auth was enabled.
2. Unable to change variable's value when debugging Oracle function.
3. SQL order issue in Structure Synchronization.
4. Unable to specify the minimum property when designing a collection in MongoDB.
5. Unable to save PostgreSQL function in some cases.
6. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Main New Features:

1. Support of MongoDB
2. Support of Roles for MySQL 8
3. Support of Roles for MariaDB 10
4. Support of Partitioned Table for PostgreSQL 10
5. Brand new Filter Wizard
6. UI and UX Improvement
7. MongoDB is added in Navicat Premium
8. Navicat for MongoDB is released

To upgrade, please visit our Customer Center.

Bug Fixes:

1. File encoding was incorrect when transferring database to SQL file.
2. The generated CREATE PROCEDURE statement was incorrect when dumping database to SQL file.
3. Structure Synchronization detected differences after synchronizing.
4. Incorrect unique values were imported from .dbf file.
5. Crashed when saving the modified field names in some cases.
6. Extra '(' was added to INSERT statements when deploying scripts in Data Synchronization.
7. Foreign keys were not transferred when transferring tables from MySQL to SQLite.
8. Unable to restore LONGTEXT data completely from .psc file.
9. .ndm file association was not worked.

To upgrade, please visit our Customer Center.

Bug Fixes:

1. 80041318 error occurred when saving a task schedule.
2. The cursor position row moved to the bottom line after saved the procedure/function.
3. 'XXX is not a valid value' error occurred when editing a PostgreSQL model table in some cases.
4. Syntax error occurred when updating MySQL user password.
5. Transaction did not end after closing the table in some cases.
6. Error occurred when there was a 'CRLF' character in Oracle procedure.

To upgrade, please visit our Customer Center.

Bug Fixes:

1. Unable to transfer objects between different server types by drag-and-drop.
2. Zero decimal place digits were not displayed in Table Viewer.
3. Exported SQL file did not have table name when exporting an unsaved query.
4. Incorrect SQL 'ON UPDATE CURRENT_TIMESTAMP(0)' was dumped for MariaDB 5.5 tables.
5. The privileges of PostgreSQL functions with parameters were not visible in Privilege Manager.
6. Incorrect dates were exported when exporting PostgreSQL tables to Excel files.
7. Syntax error occurred when importing CSV files in some cases.
8. Database names were missing in the Drop SQL generated by Structure Synchronization.
9. ORA-01830 error occurred when transferring tables to Oracle server in some cases.
10. Unable to change the Tab Width in Query Editor.
11. Unable to edit query results when tables had alias.
12. Procedure parameters were missing in the scripts generated by Structure Synchronization.
13. Unknown Internal Error occurred when Automation ran.
14. Unable to transfer tables with HEX format.
15. Default parameter syntax was stripped after saving PostgreSQL function.
16. Syntax error occurred when creating PostgreSQL function with array parameters.
17. Encoding issue of the exported text file.
18. Unable to show the SQLite CTE based view definition in View Designer.
19. Crashed when the Oracle host name was longer than 1000.

To upgrade, please visit our Customer Center.

Bug Fixes:

1. 'Access Violation' error occurred when creating new connections in fresh installed Navicat.

To upgrade, please visit our Customer Center.

Bug Fixes:

1. Unable to create a query inside a group.
2. The color of function keywords did not change according to the Font Color settings in Options.
3. Column width did not retain after hide and show the column in Table Viewer.
4. Unable to drag and drop a query into a group in some cases.
5. 'SQL Logic' error occurred when loading SQLite extension.
6. Unable to edit query results in some cases.
7. Unable to disable Foreign Key constraint in Data Synchronization.
8. Crashed when dumping table to sql file in some cases.
9. Foreign Key constraint didn't work when the constraint name was empty in SQLite.
10. DROP PROCEDURE statements in Structure Synchronization did not include the schema name.
11. Some setting values was missing in SQLite Trigger Designer.
12. Foreign Key constraint issue in Import Wizard.
13. Unable to show the SQLite CTE based view definition in View Designer.
14. SQLite connections was missing in Model's Import from Database feature.
15. Code completion replaced the text after caret.
16. Exported files were not attached to the notification email.
17. Plugin error occurred when using RSA/PAM authentication for MariaDB connections.
18. Keepalive Interval setting attempted to connect continuously even the database was down.
19. If a query was opened, abnormal behavior happened when closing Navicat.
20. Automation did not start when the computer was logged out.
21. Unable to create new table with primary key settings in Import Wizard.
22. Navicat was not responded when performing Structure Synchronization.

To upgrade, please visit our Customer Center.

Improvements:

1. Supported creating PostgreSQL 10 Models.
2. Supported Microsoft Azure Database for MySQL.

Bug Fixes:

1. RAISE NOTICE events did not show in Message Log.
2. Spaces were missing in the SQL exported from Model.
3. Extra newlines were added to the SQL exported from Model.
4. Unable to change the comment of PostgreSQL functions with named parameters.
5. 'Hourly' option was missing on Task Schedule's Trigger tab.
6. Wrong datestamp was appended to the exported files.
7. Added records showed wrong values until refreshing SQLite table grid.
8. Slow issue when searching in Table Viewer.
9. Unable to move functions into a group.
10. Syntax error occurred when running query in some cases.
11. Unable to select Enum data in query results.
12. 'Unknown Internal Error' occurred when opening SQLite tables.
13. 'Invalid byte sequence for encoding' error occurred when opening PostgreSQL tables.
14. Target functions/procedures were not dropped before create when synchronizing structure.
15. Unable to synchronize models/queries in Navicat Cloud.
16. Exported Excel files were corrupted in some cases.

To upgrade, please visit our Customer Center.

New Features:

1. New UI/UX.
2. On Startup: open favorite tabs automatically when Navicat launches.
3. Code Snippet.
4. Advanced Code Completion with better suggestions.
5. Brand new Structure Synchronization: visually show side-by-side DDL comparison between two databases.
6. Brand new Data Synchronization: show particular status to distinguish the differences between records easily.
7. New Automation: easy to find desired profiles and create automated batch jobs.
8. Responsiveness and performance improved.
9. Many other new features and improvements.

To upgrade, please visit our Customer Center.

Bug Fixes:

1. Fixed the CREATE PACKAGE and CREATE PACKAGE BODY issue in SQL Editor.
2. Error occurred when exporting with Time field type.
3. Unable to insert trigger in Table Viewer.
4. Removed 'WHEN()' if 'When Clause' is NULL for Oracle trigger.
5. 'Argument out of range' occurred when running 'Reverse Database to Model'.
6. Wrong Oracle SQL statements were generated wrong when running 'Synchronize to Database' in Model.
7. Fixed the Oracle varchar2 issue when running 'Synchronize to Database' in Model.
8. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug Fixes:

1. Cannot to show PostgreSQL large decimal data properly in Table Viewer.
2. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Bug Fixes:

1. Crashed when using Query in some cases.
2. Query auto-save feature did not work in some cases.
3. Debugger did not work for PostgreSQL 8.3 to 9.0.
4. Set task schedule in Batch Job did not work.
5. Fixed UI font issue in Ubuntu 16.10.

To upgrade, please visit our Customer Center.

Bug Fixes:

1. Unable to move PostgreSQL function with special parameter to virtual group.
2. Error occurred when getting MySQL query status.
3. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Major New Features:

Navicat Cloud Collaboration

1. Create/Modify/Delete projects.
2. Add members to project for sharing connection settings, queries and models.
3. View Project Activity Log.

PostgreSQL Objects

1. Support Foreign Server with User Mapping.
2. Support Foreign Table.
3. Support PostgreSQL Debugger.
4. Enhanced Object Designers.

Data Modeling Tool

1. Support Model Conversion.
2. Support Views.
3. Enhanced Table Designer.

Others

1. SQLite Users Management.
2. Enhanced Connection Coloring.
3. Search database object structure.

To upgrade, please visit our Customer Center.

Improvements:

1. Supported PostgreSQL 9.5.
2. Enhanced Stored Procedure editor.

Bug Fixes:

1. Exported result incorrect for TIME field type in Export Wizard.
2. File name with appended timestamp issue in Export Wizard.
3. Wrong caption/icon showed for Stored Procedure.
4. Unable to synchronize BIT fields for PostgreSQL tables in Data Synchronization.
5. Slow performance when showing/hiding column with Memo editor opened.
6. SSH protocol error issue.

To upgrade, please visit our Customer Center.

Bug Fixes:

1. Foreign keys were re-created when editing Oracle tables in Table Designer.
2. Generated object SQL identifier without escaping quote characters in Model.
3. Unable to load the virtual group settings file created by old versions of Navicat.
4. After sorted a selected column in Table Viewer, access violation occurred when resizing column width.

To upgrade, please visit our Customer Center.

Improvements:

1. Reset the field length to default value after changing the auto guessed field type in Table Designer.

Bug Fixes:

1. Access violation error occurred when entering SQL in Query.
2. Cannot access field 'Super_priv' as type Boolean error occurred when managing MySQL/MariaDB Users.
3. Unable to download source files with HTTPS connection in Import Wizard.
4. Failed to create/edit users for MySQL 5.7.6.
5. 'Cannot create oci environment' error occurred in Oracle connections.

To upgrade, please visit our Customer Center.

Improvements:

1. Improved the Message Log information.

Bug Fixes:

1. Table Designer did not allow to edit MySQL table partition's Values setting.
2. Failed to generate PostgreSQL index field clause in Structure Synchronization.
3. Unable to drop columns for PostgreSQL View in View Designer.
4. Unable to identify equality of trigger definitions with different system line breaks in Structure Synchronization.
5. Unable to generate the SET clause properly for Oracle when using update mode in Import Wizard.
6. Unable to generate MySQL table SQL with charset binary properly in Structure Synchronization.
7. Code Completion added smart quote wrongly for utc_date() in Query Editor.
8. Unable to convert object names in Data Transfer when using Schedule.
9. Unable to transfer MariaDB triggers in Data Transfer.

To upgrade, please visit our Customer Center.

New Features:

1. Support to sync selected connection settings, queries, model files and virtual group information to Navicat Cloud. For more information, please visit here.

Improvements:

1. Support PostgreSQL 9.3 Materialized View.
2. Support SQLite 3.8 WITHOUT ROWID.
3. Support adding shapes in Model.

To upgrade, please visit our Customer Center.