Navicat for MySQL 12.1.27 (32-bit)

What's new in this version:

Navicat for MySQL 12.1.27 (32-bit)
Bug fixes:
- Query wrongly returned null results in some cases
- Unable to update bit type data
- Datetime format issue when exporting to Excel files
- Query Results Text pane appended values of the selected cells
- Syntax error occurred when renaming an index in MariaDB table
- Minor bug fixes and improvements


Navicat for MySQL 12.1.25 (32-bit)
- Change log not available for this version


Navicat for MySQL 12.1.24 (32-bit)
Bug fixes:
- Failed to update records in table viewer
- "Input profile is invalid" error occurred when opening export query profiles
- Tab was exported instead of "," when scheduling to export CSV files
- Automation was failed when scheduling export profile and import profile
- Unable to copy and paste "," comma decimal separator
- Minor bug fixes and improvements


Navicat for MySQL 12.1.23 (32-bit)
Bug-fixes:
- Export process was slow
- Unable to dump the default value of TIMESTAMP field
- Synchronize to Database feature wrongly detected differences of unique constraints
- Minor bug fixes and improvements


Navicat for MySQL 12.1.22 (32-bit)
- Copy and paste data issue in Table Viewer
- Minor bug fixes and improvements


Navicat for MySQL 12.1.21 (32-bit)
Bug-fixes:
- Unable to list users for MariaDB 10.4
- Code Completion did not work in some cases
- Unable to import signed numbers when there was spaces between the sign and the number
- Unable to map a source field to multiple target fields in Import Wizard
- DELIMITER statements did not work in Console
- "Cannot open file" error occurred when scheduling export profiles in some cases
- Unable to show empty fields in query result sets
- Minor bug fixes and improvements


Navicat for MySQL 12.1.20 (32-bit)
- "syntax error at end of input" error occurred when running CREATE RULE statement in Query Editor
- "Unknown Internal Error" occurred when opening Table Designer
- "syntax error at or near "VERBOSE"" occurred when using Vacuum Analyze on PostgreSQL 11 tables
- Minor bug fixes and improvements


Navicat for MySQL 12.1.19 (32-bit)
- Text editor did not display the full text in some cases
- Data Synchronization inserted values into Generated Columns
- Minor bug fixes and improvements


Navicat for MySQL 12.1.18 (32-bit)
- Error occurred when connecting to MySQL 40
- Unable to execute SQL files that contain "NaN" values
- Primary Key checkbox was deselected when tabbing to the next field in Table Designer
- "Unknown Internal" error occurred when importing data
- The DDL of PostgreSQL tables with "tstzrange" data type was incorrect
- Table Designer cannot show the definition of MySQL 50 triggers
- Unable to set the precision of "datetime2" data type to 0 in Table Designer
- The deployment scripts generated incorrect default value in Structure Synchronization
- "Access Violation" error occurred after editing the data pipeline in Report
- "Unknown Internal" error occurred when using Automation
- Minor bug fixes and improvements


Navicat for MySQL 12.1.17 (32-bit)

Bug fixes:
- Query result pane size did not retain after minimizing the window
- Paradox tables cannot be imported
- Unknown Internal error occurred when importing data
- "On Update Current Timestamp" option did not reflect the settings when using ANSI_QUOTES SQL mode
- Column order was incorrect when importing database to model
- Minor bug fixes and improvements


Navicat for MySQL 12.1.16 (32-bit)
- "Replace All" button was unable to replace the last occurrence in Query Editor
- Code completion suggestion list did not show on the same screen as the editor
- Crashed when opening Oracle table with Spatial data
- A table was mistakenly transferred even it was not selected
- Incorrect syntax highlighting issue in Query Editor
- MySQL trigger definition displayed as
- Unable to transfer unique index from MySQL to SQLite
- Filter criteria input box was not retained when switching applications
- Drag and drop selected text on Query Editor did not move the text
- JSON expression did not display correctly in Table Designer
- Minor bug fixes and improvements


Navicat for MySQL 12.1.15 (32-bit)

Bug-fixes:
- SQL order issue in Structure Synchronization
- Console window was not colored when connection coloring were set
- Minor bug fixes and improvements


Navicat for MySQL 12.1.12 (32-bit)
- Change log not available for this version


Navicat for MySQL 12.1.9 (32-bit)
- Custom Filter was cleared when editing it
- HTML export did not specify charset
- "Show/Hide Columns" option was missing in Form View
- The hidden Information pane was shown when switching from Form View to Grid View
- Cursor focus issue in Form View
- Code Completion did not work in some cases
- Minor bug fixes and improvements


Navicat for MySQL 12.1.8 (32-bit)
- Change log not available for this version


Navicat for MySQL 12.1.7 (32-bit)
Bug-fixes:
- "SQLite function sqlite_libversion cannot linked" error occurred when starting Navicat
- Unable to scroll inside the text box in Form View
- "is in list" operator in Filter Wizard did not working correctly
- Structure Synchronization compared table options
- Minor bug fixes and improvements


Navicat for MySQL 12.1.6 (32-bit)
Bug fixes:
- Unknown Internal Error occurred when showing data "{}" in TEXT editor
- Precision value in CURRENT_TIMESTAMP(6) was missing when synchronizing structure
- Esc shortcut did not work when error occurred during deleting records
- Error occurred when renaming an existing column and adding a new one
- Filter value did not displayed when the string exceeded 5880 characters
- Unable to display the columns list in Table Designer's Index tab when there was no index
- Unable to apply Filter profile
- Unable to scroll to right in Filter Wizard
- Opening Design Table froze in large database
- "Open Table" and "Design Table" were not properly synchronized
- Import Target and Field Mapping changed after changing the source file in profile


Navicat for MySQL 12.1.5 (32-bit)
Improvements:
- Improved Filter Wizard
- Supported expression for default field value in Table Designer

Bug-fixes:
- Crashed when applying filter in Foreign Key Selection window
- Minor bug fixes and improvements


Navicat for MySQL 12.1.4 (32-bit)
- 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.29 (32-bit)
- Change log not available for this version


Navicat for MySQL 12.0.28 (32-bit)
Bug fixes:
- 80041318 error occurred when saving a task schedule
- The cursor position row moved to the bottom line after saved the procedure/function
- Syntax error occurred when updating MySQL user password
- Transaction did not end after closing the table in some cases


Navicat for MySQL 12.0.27 (32-bit)
- Unable to transfer objects between different server types by drag-and-drop
- Zero decimal place digits were not displayed in Table Viewer
- Exported SQL file did not have table name when exporting an unsaved query
- Incorrect SQL "ON UPDATE CURRENT_TIMESTAMP(0)" was dumped for MariaDB 5.5 tables
- Unknown Internal Error occurred when importing from ODBC
- Syntax error occurred when importing CSV files in some cases
- Database names were missing in the Drop SQL generated by Structure Synchronization
- Unable to change the Tab Width in Query Editor
- Unable to edit query results when tables had alias
- Procedure parameters were missing in the scripts generated by Structure Synchronization
- Unknown Internal Error occurred when Automation ran
- Unable to transfer tables with HEX format
- Encoding issue of the exported text file


Navicat for MySQL 12.0.26 (32-bit)
- Change log not available for this version


Navicat for MySQL 12.0.25 (32-bit)

Improvements:
- Supported Microsoft Azure Database for MySQL

Bug Fixes:
- Spaces were missing in the SQL exported from Model
- Extra newlines were added to the SQL exported from Model
- "Hourly" option was missing on Task Schedule's Trigger tab
- Wrong datestamp was appended to the exported files
- Slow issue when searching in Table Viewer
- Unable to move functions into a group
- Syntax error occurred when running query in some cases
- Unable to select Enum data in query results
- Target functions/procedures were not dropped before create when synchronizing structure
- Unable to synchronize models/queries in Navicat Cloud
- Exported Excel files were corrupted in some cases
- "Access is denied" error occurred when setting schedule


Navicat for MySQL 12.0.24 (32-bit)

Bug Fixes:
- Error occurred when synchronizing structure in some cases
- Replace All did not work in Table Viewer
- Cell selection disappeared after pressing CTRL+C in Table Viewer
- Error occurred when running query in some cases
- "Unknown Internal Error" occurred when exporting query results


Navicat for MySQL 12.0.23 (32-bit)
- Change log not available for this version


Navicat for MySQL 12.0.22 (32-bit)
- Change log not available for this version


Navicat for MySQL 12.0.21 (32-bit)
- Unable to transfer POINT data type from MySQL to MariaDB
- Minor bug fixes and improvements


Navicat for MySQL 12.0.20 (32-bit)
- Change log not available for this version


Navicat for MySQL 12.0.19 (32-bit)

Bug Fixes:
- Unable to zoom in/out Query Editor using mouse wheel
- Unable to connect Sphinx servers
- Swapping connections did not work when re-comparing in Data Synchronization
- Syntax errors occurred when running query in some cases
- Unknown Internal error occurred when performing Structure Synchronization
- No records was transferred when the target connection was using HTTP Tunnel
- Query syntax highlight was wrong after switching tabs
- DateTime field Not Null checkbox unchecked wrongly in Table Designer
- Unable to export table to xlsx with name longer than 31 characters
- Hanged when searching in Table Viewer in some cases


Navicat for MySQL 12.0.18 (32-bit)

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
- Unknown Internal Error occurred when performing Structure Synchronization


Navicat for MySQL 12.0.17 (32-bit)

Bug Fixes:
- Structure Synchronization detected differences wrongly in some cases
- Record delimiter was wrong when exporting to text file using Automation
- Table Viewer moved back to the first page when refreshing a table
- Characters displayed wrongly in Table Viewer
- Unable to select fields when exporting to Excel file


Navicat for MySQL 12.0.16 (32-bit)
- Change log not available for this version


Navicat for MySQL 12.0.15 (32-bit)
- Error occurred when deleting INT field value in Table View


Navicat for MySQL 12.0.14 (32-bit)

Bug Fixes:
- Wrongly shown differences when synchronizing structure
- The DDL tab in Information pane did not updated after saving changes in sub forms
- Unknown Internal Error occurred when synchronizing structure/data in some cases
- Unable to schedule Data Synchronization profiles
- Syntax error occurred when filtering with ' character in Table Viewer
- Compared table comments in Structure Synchronization
- Input decimal separator issue in Table Viewer
- Unable to import date from Excel to VARCHAR field
- Query Builder loading was slow
- Custom backup file name was ignored when scheduling in Automation
- Re-registration issue
- Unable to create new table in Import Wizard in some cases


Navicat for MySQL 12.0.13 (32-bit)

Bug Fixes:
- Table triggers was not included when backing up tables
- Auto increment field was ignored when importing
- Unable to set the default value of TEXT/BLOB field for MariaDB 10.2.1 or above
- Navicat hanged when running a query export profile in some cases
- Error occurred when running LOAD DATA LOCAL queries
- Special characters were garbled when exporting Access files
- Unknown Internal error occurred when exporting Access files
- Unknown Internal error occurred when saving changes in Table Designer
- "Too many client tasks" error occurred when importing Access files
- Double-quote encased text fields were split into new records when importing a record which multiple lines
- Syntax error occurred when performing data transfer in some cases
- Unknown Internal error occurred when adding multiple records in Table Viewer
- Two identical functions declared as different in Structure Synchronization


Navicat for MySQL 12.0.11 (32-bit)

Bug Fixes:
- Unable to open Information pane by context menu
- Unable to import fixed width text file in some cases
- Access Violation error occurred when creating models / tables in some cases
- Access Violation error occurred after Navicat was idle
- Unable to import the CDATA data in XML files
- Number values were exported as text in Excel files
- Code completion did not work for alias in SQL Editor
- Beautify SQL did not format multiple statements properly in SQL Editor
- Unknown Internal error occurred when running query with parameters
- Table menu displayed wrong item in some cases
- Unknown Internal error occurred when running old version export profiles in Automation
- Unknown Internal error occurred when opening tables in some cases
- "_Navicat_Temp_Stored_Proc() does not exist" error occurred when saving functions
- High memory usage issue in Data Synchronization
- "Use empty string as NULL" option did not work in Import Wizard
- Unknown Internal error occurred when writing query in some cases
- Unknown Internal error occurred when backup in Automation in some cases
- Hang issue occurred when launching Import Wizard
- Unable to connect with SSL in some cases


Navicat for MySQL 12.0.10 (32-bit)
- Error occurred when opening MySQL databases in HTTP connection if enabled "Encode outgoing query with base64" setting
- Unable to import Chinese characters from Excel files
- Incorrect date and decimal formats in exported Excel files
- Filter criteria settings were removed when applying sorting on column
- Error occurred when duplicating MySQL tables in HTTP connection
- Unknown Internal Error occurred when executing old version export profiles in Batch Job
- Save dialog did not pop up when closing backup profiles after editing
- Unknown Internal Error occurred when loading Filter profiles in Table Viewer
- File path and file name were not saved in Export profiles
- Unknown Internal Error occurred when there was multiple statements in Query
- Incorrect field names were shown in code completion suggestion list
- Unable to attach the report PDF file in notification email


Navicat for MySQL 12.0.9 (32-bit)

Bug Fixes:
- "Unknown Internal Error" occurred when typing statement in SQL Editor
- Unable to show field names in data pipeline after editing SQL in Report
- Beautify SQL formatted the statement wrongly in some cases
- Sorting by modified/create date did not work for details view in main window
- Connection coloring displayed wrong color in some cases


Navicat for MySQL 12.0.8 (32-bit)
- Wrong table showed when comparing tables in Data Synchronization in some cases
- Unable to import special characters from Excel
- Unable to paste multiple records in Table Viewer
- Created Batch Jobs did not show in Standard Edition
- "Unknown Internal Error" occurred when importing files
- View Builder locked up when re-open for editing in some cases


Navicat for MySQL 12.0.7 (32-bit)

Bug Fixes:
- "Access violation" error occurred when create new query/view
- Enum value drop-down list was missing for MariaDB in Table Viewer
- Wrongly showed primary key warning in some cases
- Unable to type some characters in editor when using international keyboard
- Unable to edit connection settings in some cases
- Information Pane did not appear in some cases
- Internal error occurred when importing CSV files
- Cell values froze when scrolling in grid view


Navicat for MySQL 12.0.6 (32-bit)

Bug Fixes:
- 1142 error occurred when dumping SQL files
- 1142 error occurred when backing up databases
- Failed to load Data Synchronization profiles
- Data display issues in table viewer
- Minor bug fixes and improvements


Navicat for MySQL 12.0.5 (32-bit)
- 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.16 (32-bit)

Bug Fixes:
- Error occurred when exporting with Time field type
- "Argument out of range" occurred when running "Reverse Database to Model"
- Minor bug fixes and improvements


Navicat for MySQL 11.2.15 (32-bit)
- Minor bug fixes and improvements


Navicat for MySQL 11.2.11 (32-bit)
- Bug Fixes: Copy and paste issue in Table Viewer's Memo Editor