Navicat for MySQL 12.1.30

What's new in this version:

Navicat for MySQL 12.1.30
Bug fixes:
- Scrolling was slow in data viewer
- "Error moving files" error occurred when accessing Navicat Cloud
- The color picker disappeared in diagram
- Minor bug fixes and improvements


Navicat for MySQL 12.1.29
- Minor bug fixes and improvements


Navicat for MySQL 12.1.27
- Minor bug fixes and improvements


Navicat for MySQL 12.1.26
Bug fixes:
- Unable to change the Settings Location path of Navicat Cloud connections
- A red exclamation mark was incorrectly displayed on the Navicat Cloud query icon
- "Add Object Privileges" UI issue when using Dark Mode
- Minor bug fixes and improvements


Navicat for MySQL 12.1.25
Bug fixes:
- Unable to search in menu bar / Help
- Unable to show the database list when there was more then 255 databases
- Data Transfer process was stopped in some cases
- Minor bug fixes and improvements


Navicat for MySQL 12.1.24
Bug fixes:
- Unable to list users for MariaDB 10.4
- List View was not retained in the main window after restarting Navicat
- Minor bug fixes and improvements


Navicat for MySQL 12.1.23
- Unable to transfer views from MySQL to MariaDB
- Crashed when running query in some cases
- Unable to use the Add Privilege button
- Connections moved out of the group after editing
- Crashed when editing model in some cases
- Minor bug fixes and improvements


Navicat for MySQL 12.1.22
Bug fixes:
- Empty tables were created when importing .accdb file
- Run Selected option did not run all highlighted text when using shortcut to select the SQL
- SSH connection dropped issue
- Unable to retain selected columns in Foreign Key Selection window
- Data Synchronization data grid UI issue in Dark Mode
- Data Synchronization inserted values into Generated Columns
- Minor bug fixes and improvements


Navicat for MySQL 12.1.20
- Minor bug fixes and improvements


Navicat for MySQL 12.1.19

Bug fixes:
- Error occurred when connecting to MySQL 4.0
- Missing "Tools" menu when running an infinite loop in Console
- Crashed when comparing databases in Structure Synchronization
- Crashed when saving models
- Minor bug fixes and improvements


Navicat for MySQL 12.1.18

Bug fixes:
- Grid View and Form View menu options were flipped
- "On Update Current Timestamp" option did not reflect the settings when using ANSI_QUOTES SQL mode
- The row height of the object list did not match the font size
- Column order was incorrect when importing database to model
- Minor bug fixes and improvements


Navicat for MySQL 12.1.16

Improvements:
- Enter the datetime value directly in the Filter

Bug-fixes:
- Crashed when opening a database in some case
- If the filter value box was opened, Navicat window disappeared when switching to another App
- Crashed when using Find feature after updating the data
- Crashed when code completion was triggered in large query
- Freeze when entering/exiting Full Screen
- Selected connection, database and schema names were missing in Data Transfer window
- 1146 error occurred when duplicating MySQL 8.0 functions
- Minor bug fixes and improvements


Navicat for MySQL 12.1.12

Bug-fixes:
- Mojave's Dark Mode did not display properly
- Minor bug fixes and improvements


Navicat for MySQL 12.1.7

Bug fixes:
- Crash occurred when adding export profile to a batch job in some cases
- Navicat got hanged when viewing SQL Preview in new function
- Crash occurred when saving new function
- Sync User Name with Navicat Cloud option in SSH tab did not work properly
- Unable to scroll horizontally in the comparison step of Data Synchronization
- Minor bug fixes and improvements


Navicat for MySQL 12.1.6
Bug fixes:
- COMMAND-N new object shortcut did not work
- Not Null checkbox state was wrong in Table Designer
- Crashed when creating new connection in some cases
- Import Target and Field Mapping changed after changing the source file in profile
- Syntax error occurred when transferring MySQL ARCHIVE engine tables
- Crashed when closing window in some cases
- Minor bug fixes and improvements


Navicat for MySQL 12.1.4

Bug fixes:
- Unable to map fields in Import Wizard
- New Query shortcut and menu item did not work
- Crashed when clicking New Query button in some cases
- Crashed when typing in Query Editor in some cases
- Minor bug fixes and improvements


Navicat for MySQL 12.1.3
- Support Roles for MySQL 8
- Support Roles for MariaDB 10
- Brand new Filter Wizard
- UI and UX Improvement
- MongoDB is added in Navicat Premium
- Navicat for MongoDB is released


Navicat for MySQL 12.0.28
- Bug fixes:
- Unable to rename table with double-click in some cases
- Sorting Rows column on the Objects tab did not work properly
- Command-W shortcut did not close the active window in some cases
- Some menu items were missing in Table Designer
- Export Wizard did not add a leading zero to pad days and months to two digits


Navicat for MySQL 12.0.27

Improvements:
- Ability to copy comparison results of Model
- Added thousand separators to the row count on the table objects list

Bug Fixes:
- Crashed when opening Navicat if invalid characters were used for the paths in Preferences
- The generated CREATE PROCEDURE statement was incorrect when dumping database to SQL file
- Unable to execute Navicat commands using Automator


Navicat for MySQL 12.0.26

Improvements:
- Supported to connect MySQL 8 using SHA2 connection
- Supported coloring the Objects tab when a colored connection is selected
- Improved table mapping in Import Wizard
- Improved keyboard navigation with tab key in Import Wizard

Bug Fixes:
- Left single quotation mark was wrong style when inputting in Form View
- Extra "(" was added to INSERT statements when deploying scripts in Data Synchronization
- Objects list loading was slow in some cases
- Zero decimal place digits were not displayed in Table Viewer


Navicat for MySQL 12.0.25
Bug Fixes:
- Incorrect SQL "ON UPDATE CURRENT_TIMESTAMP(0)" was dumped for MariaDB 5.5 tables
- Crashed when starting Navicat
- Unable to edit query results when tables had alias
- Exported files were not attached to the notification email
- Procedure Parameters was missing when synchronizing structure
- Unable to filter connections in the Navigation Pane
- Profile icons did not have indicator after adding attachments in Batch Job


Navicat for MySQL 12.0.24
Bug Fixes:
- Unable to copy error messages in Query
- Database name was added to the query when using Query Builder
- XML file data was not imported to JSON fields completely
- Unable to edit data in Query result set in some cases
- Adjusting the height of split screen in Table Designer was not allowed
- Crashed when selecting or editing Procedure SQL in Query Editor
- Incorrect SQL was generated when changing Primary Key name in Table Designer
- Query column width reset after restarting Navicat
- Memory leak issue
- "Fields" and "Referenced Fields" values were vanished after saving and moving cursor to another Foreign Key
- Field properties were not shown when adding a field in Table Designer
- Incorrect field name were shown when moving a field in Table Designer
- UI issue in Full Screen mode
- Exported Excel files were corrupted in some cases


Navicat for MySQL 12.0.23

Improvements:
- Supported Microsoft Azure Database for MySQL

Bug Fixes:
- Unable to open Console if a non-tabbed window was opened in font
- Navicat hanged when refreshing table grid after changing field names
- Navicat process was unable to terminate


Navicat for MySQL 12.0.22

Bug Fixes:
- Error occurred when synchronizing structure in some cases
- Exported Excel files were corrupted in some cases


Navicat for MySQL 12.0.21
- Minor bug fixes and improvements


Navicat for MySQL 12.0.20

Bug Fixes:
- Unable to open a table twice
- Running multi-statement SQLs with delimiters issue
- Crashed when adding default value in Table Designer
- Crashed when clicking the Server Privileges tab in User Designer
- Find feature in Table Viewer was not function correctly
- Target object name was garbled when copying object named with non-ascii characters
- Crashed when executing SQL to insert emoji to table
- Crashed when performing Data Transfer in some cases
- Navicat hanged when executing scripts in Data Synchronization
- Unable to hide the Information pane permanently in Query
- Preferences settings reset when Navicat started
- Unable to stop query when using SSL connection


Navicat for MySQL 12.0.19

Bug Fixes:
- Result tab was focused when explaining query
- Query Plan result column was too narrow in Query
- "t" character was appended to the end of the row when copying data to text / Excel file
- Unable to map fields in Import Wizard
- Dump SQL File process was slow
- Create new table wrongly when importing to existing table in some cases
- Use old user to connect after changing new user name in Connection window
- Unable to import decimal values when data has thousand separator
- Crashed when searching on different pages in Table Viewer


Navicat for MySQL 12.0.18

Bug Fixes:
- The database/schema combo-box did not work in Query
- Manual refresh did not work in Server Monitor when auto-refresh was enabled


Navicat for MySQL 12.0.17
- Change log not available for this version


Navicat for MySQL 12.0.16

Bug Fixes:
- Syntax error occurred when creating MariaDB triggers in Table Designer
- Unable to commit the same query twice
- Unable to create the second filter by using context menu
- Unable to reload or reopen tables after connection was timeout
- Navicat hanged when opening large BLOB data in Hex Editor


Navicat for MySQL 12.0.15
- Save dialog prompted even no changes made in Table Designer
- Query Builder loading was slow
- Unable to execute query in some cases
- Data synchronization crashed when HTTP connection was used
- Unable to export views on High Sierra


Navicat for MySQL 12.0.14

Bug Fixes:
- Error occurred when creating virtual columns in MariaDB Table Designer
- Table Designer UI improvements
- Font settings in Preferences reset to default after restarting Navicat
- SQL Formatting was missing in the Triggers tab of Table Designer
- Unable to delete fields in Table Designer
- View Builder button was missing in View Designer
- SSH connection hangs issue
- Objects list loading was slow
- Automation did not work when the profile name contained spaces
- Syntax error occurred when filtering with ' character in Table Viewer
- Unable to run DELIMITER $$ statements in Query
- Navicat hanged when using normal OS user account
- Duplicate Entry error occurred when importing with Append/Update mode
- Sync Username to Navicat Cloud option was missing in Connection form
- Navicat hanged when connection was cut off


Navicat for MySQL 12.0.13

Bug fixes:
- Auto increment field was ignored when importing
- Unable to set the default value of TEXT/BLOB field for MariaDB 10.2.1 or above
- Error occurred when connecting to MariaDB in some cases
- Navicat hanged when running a query export profile in some cases
- Crashed when viewing or editing Functions
- Code completion displayed unrelated items


Navicat for MySQL 12.0.12
- Replace All did not work in Table Viewer
- Wrong row was inserted to when selecting foreign key value in Table Viewer
- Memory error occurred when transferring tables
- Suggested wrong table columns in code completion list
- Context menu UI issue in some cases
- Tables displayed as NEW in Import Wizard even it is already existed
- Slow issue occurred when using code completion
- Server name was missing in the window title bar of Console
- Unable to add tables/views to Query Builder


Navicat for MySQL 12.0.11

Bug Fixes:
- Crashed when executing query in some cases
- Failed to sort by Modified Time, Created Time or Data Length in Detail view
- Launching Import Wizard was slow
- The month and day values were transposed when importing Date fields
- Copy/Paste context menu was missing in Table Viewer
- Crashed when creating new query without selecting a connection in Navigation pane
- Unable to stop multiple processes in Server Monitor
- Number of running processes was missing in Server Monitor
- Table mapping was not in alphabetic order in Data Synchronization
- Crashed when adding records in Table Viewer
- Exported file name did not add timestamp when using Automation
- Wrong SQL was generated for function in Structure Synchronization
- In-App Purchases did not stay activated after restart the app


Navicat for MySQL 12.0.10
- Crashed when exporting query result in some cases
- Unable to show time values in Timestamp fields in Table Viewer
- Lost focus when inputting auto increment value in Table Designer
- Incorrect values displayed in MySQL "Data Length" column in Detail View
- Table list was not sorted in Export Wizard
- Backup object list in the Objects tab was not refreshed after finishing backup
- Progress bar did not update when importing


Navicat for MySQL 12.0.9
- Unable to copy SQL in the bottom navigation bar of Table Viewer
- Crashed when pasting SQL in Query Editor
- Error occurred when opening MySQL databases in HTTP connection if enabled "Encode outgoing query with base64" setting
- End Process item in the context menu was disabled in Server Monitor
- Syntax error occurred when transferring MySQL data
- Incorrect field names were shown in code completion suggestion list


Navicat for MySQL 12.0.8
- Change log not available for this version


Navicat for MySQL 12.0.7
- Unable to restore in some cases
- Query Table shortcut was missing in Table Viewer
- Foreign Key's reference database was not changed after transferring to other database
- Crashed when launching the application
- Unable to set range in Schedule Setup
- SSH password was not imported when upgrading to Navicat 12
- Memory leak issue in SQL Editor
- Current active server/database was not selected when using CMD-Y shortcut to open New Query window
- Syntax error occurred in Data Transfer
- Sorting by modified/create date did not work for details view in main window
- Unable to copy and paste data in Table Viewer


Navicat for MySQL 12.0.6
Bug Fixes:
- Shift-Option-Arrow did not work for selecting a word in SQL Editor
- Command-R did not refresh the list when database was selected
- Unable to resize window in some cases
- Unable to type some characters in editor when using international keyboard
- Unable to sort the object list in the main window
- Unable to log in Oracle server using lower case username
- Exporting data with commas to CSV file issue


Navicat for MySQL 12.0.5
- Crashed when exporting large query results
- Connection name was missing on the tab of Table Viewer
- Crashed when exporting query results to CSV file
- Query prompted for inputting the same parameter for every occurrence
- Unable to accept Terms and Conditions when first login Navicat Cloud


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


Navicat for MySQL 11.2.18
- Minor bug fixes and improvements


Navicat for MySQL 11.2.17
- Fixed Failed to move procedures to a virtual group
- Minor bug fixes and improvements


Navicat for MySQL 11.2.16
- Unable to show errors when running query in some cases
- Failed to import JSON files in some cases
- Query Editor window has disappeared when it lost focus
- Some options were wrongly displayed in Essentials Edition
- Settings Location was wrongly copied when duplicating connection


Navicat for MySQL 11.2.15
Bug Fixes:
- The default date time format and delimiter of Export Wizard did not follow Import Wizard


Navicat for MySQL 11.2.14

Improvements:
- Added some common keyboard shortcuts

Bug Fixes:
- Failed to transfer tables when enabled "Convert object name" in Data Transfer
- Crashed when opening Query view in some cases
- Crashed when running backup tasks in Batch Job