Navicat for MySQL (64-bit)

What's new in this version:

Navicat Premium 16.1.1 (64-bit)
Fixed:
- Unable to open the objects in the "Find in Database" window
- The first number of every value in the list was removed in the table filter
- Unknown Internal Error occurred when updating query results in some cases
- Unable to use "Copy As" in View results
- Crashed when opening functions in some cases
- Unknown Internal Error occurred when foreign key selection window popped up
- Unable to open schema in Azure SQL
- Crashed when clicking on the value box in table filter
- Decimal separator issue in SQLite
- Cannot retain the window size and position for existing objects
- Minor bug fixes and improvements


Navicat Premium 16.1.0 (64-bit)
Main New Features:
- Support OceanBase Community Edition
- Support Trend Line for several chart types
- Support adding On-Prem Server with URI
- Allow skip preview of changes in data sync
- Enhanced responsiveness and performance
- Improved UI/UX
- Minor bug fixes and improvements


Navicat Premium 16.0.14 (64-bit)
Fixed:
- Query parameters did not work in some cases
- Unable to synchronize PostgreSQL data in some cases
- Decimal precision issue when importing from Excel files
- Minor bug fixes and improvements


Navicat Premium 16.0.12 (64-bit)
Fixed:
- Wrong time zone was added to TIMESTAMP field when exporting CSV file
- Extra commas were added to the script in Structure Synchronization
- Unknown Internal Error occurred when exporting large amount of data
- Unable to sign in Subscription plan
- Minor bug fixes and improvements


Navicat Premium 16.0.11 (64-bit)
Fixed:
- Crashed when running Automation in some cases
- Missing the first record when import
- Unable to locate project when running batch job
- Unable to get table information when scheduling data synchronization
- Refresh button ran all SQLs in Query Editor
- .0000 data export issue
- Function execution message log issue
- Access Violation error occurred when removing default value
- Navicat exited when clicking the Type column in Table Designer
- Crashed when batch querying tables with FK dependency
- Minor bug fixes and improvements


Navicat Premium 16.0.10 (64-bit)
- Change log not available for this version


Navicat Premium 16.0.9 (64-bit)
Fixed:
- The "Compare" button did not work in Data Synchronization in some cases
- "Couldn't open known_hosts file" error occurred when the SSH path contained Chinese characters
- Minor bug fixes and improvements


Navicat Premium 16.0.7 (64-bit)
Fixed:
- Unable to show data when using HTTP tunnel
- Unable to show utf8mb4 data
- Minor bug fixes and improvements


Navicat Premium 16.0.5 (64-bit)
Fixed:
- Connection encoding issue in Navicat Cloud
- Connection password issue when updating connection in Navicat Cloud
- Error occurred when synchronizing to Navicat Cloud
- Unknown Internal Error occurred when designing PostgreSQL table
- Minor bug fixes and improvements


Navicat Premium 16.0.4 (64-bit)
Fixed:
- Syntax error occurred when importing data to MySQL table
- Notification Email authentication failed in some cases
- Minor bug fixes and improvements


Navicat Premium 15.0.27 (64-bit)
Fixed:
- Double foreign key lines were printed when exporting a model to a PDF file
- Access violation error occurred when searching in the Backup's Object Selection tab
- No data value on the label when exporting a chart to a PDF file
- Unable to synchronize decimal precision from a model to SQL Server database
- Unable to rename a view inside a group in Navicat Cloud
- Cannot connect to Microsoft Azure Database in some cases
- Minor bug fixes and improvements


Navicat Premium 15.0.26 (64-bit)
Improvements:
- Support Retryable Writes and Retryable Reads for MongoDB
- Support tunneling on PHP 8

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


Navicat Premium 15.0.25 (64-bit)
Bug fixes:
- Empty rows were added when exporting more than 1.05 M records to Excel file
- Unable to rename Oracle views when the "Use custom database list" option is enabled
- Error occurred when using Recordset Generator to generate a record set for the Date field
- Hanged when designing a table with many fields
- Error occurred when copying tables from one SQLite database to another
- Unable to display the definition of SQLite View in some cases
- Relation lines were disappeared after saving and reopening Logical Model
- Minor bug fixes and improvements


Navicat Premium 15.0.23 (64-bit)
Fixed:
- Unable to exclude collations when synchronizing a model to a database
- Functions were not properly saved as the default value in MariaDB
- ER diagram was reloaded when clicking the Design Table button
- Unable to toggle "Virtual Type" in an existing table
- Error 1227 occurred when creating or designing a table
- Minor bug fixes and improvements


Navicat Premium 15.0.22 (64-bit)
- Change log not available for this version


Navicat Premium 15.0.21 (64-bit)
Bug-fixes:
- Queries cannot be displayed when "Settings Location" was set to a network path
- Error 80041318 occurred when setting schedule
- Minor bug fixes and improvements


Navicat Premium 15.0.20 (64-bit)
Bug-fixes:
- Slow response when querying the full collection count
- Flashed in dark mode
- "Unallowed argument in list..." error when running export / import schedule
- Error occurred when modifying the value in a DateTimeOffset field
- Unable to load version 10 data synchronization profiles
- Differences were incorrectly detected in Synchronize to Database
- Minor bug fixes and improvements


Navicat Premium 15.0.19 (64-bit)
- Change log not available for this version


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


Navicat Premium 15.0.17 (64-bit)
- Change log not available for this version


Navicat Premium 15.0.16 (64-bit)
Improvements:
- Support Active Directory authentication method for SQL Server
- Integer column exported in Number format when exporting Excel file
- Display export profiles in the same group of queries

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


Navicat Premium 15.0.14 (64-bit)
Bug fixes:
- Unable to set the identity seed and increment in PostgreSQL models
- Unable to synchronize data to MySQL 8.0.19
- Unable to connect AnalyticDB
- Unable to set SET IDENTITY_INSERT ON in Data Synchronization
- Unable to export data to .mdb files
- Minor bug fixes and improvements


Navicat Premium 15.0.13 (64-bit)
Bug-fixes:
- MySQL table row format reverted to Compact after editing
- Unknown Internal error occurred when opening Oracle tables
- Syntax error occurred when creating events
- Unable to set default value for fields in Table Designer
- Unable to show SUPER privilege for MariaDB 10.4 in the user object list
- Foreign key was dropped and added when re-comparing the model
- Data Pump Import's Table Exists Action drop-down list options were incorrect
- Minor bug fixes and improvements


Navicat Premium 15.0.12 (64-bit)
Bug fixes:
- Incorrect SQL generated when transferring Oracle tables
- Invalid XML error occurred when importing connections
- Differences was detected in re-comparison in Structure Synchronization and Synchronize to Database
- Incorrect data was updated when saving ; in a non-text field
- Unable to import data to PostgreSQL array fields
- Incorrect SQL generated for altering fields in Structure Synchronization
- Incorrect items were displayed in suggestion list when using code completion with alias
- Incorrect SQL generated when enabling "On Update Current_timestamp" in Table Designer
- Minor bug fixes and improvements


Navicat Premium 15.0.11 (64-bit)
Bug fixes:
- Query wrongly returned null results in some cases
- "," was replaced by "." when using Custom Filter in Table Viewer
- Relation attributes were wrong after reopening the logical model
- Minor bug fixes and improvements


Navicat Premium 15.0.9 (64-bit)
Bug fixes:
- Only the first batch was transferred when "Number of row per batch" was enabled
- Minor bug fixes and improvements


Navicat Premium 15.0.8 (64-bit)
Improvements:
- Added "Keep Orthogonal Layout" to Model

Bug fixes:
- Unable to update bit type data
- Minor bug fixes and improvements


Navicat Premium 15.0.7 (64-bit)
Bug fixes:
- The "Others" button was missing for PostgreSQL, Oracle and SQL Server connections


Navicat Premium 15.0.6 (64-bit)
Improvements:
- Added shortcuts for "Run Current Statement" and "Select Current Statement" in Query Editor

Bug fixes:
- "Unknown Internal Error" occurred when modeling databases
- Find bar UI issue in Data Viewer
- Unable to print table when using popup menu on Navigation pane
- Syntax error occurred when renaming index in MariaDB table
- Explain feature did not work with query parameters
- Interval type was not supported in Charts
- Highlight color issue in Filter wizard when using Dark mode
- Minor bug fixes and improvements


Navicat Premium 15.0.5 (64-bit)
Bug fixes:
- OCI Environment setting was unable to save
- "Invalid floating point operation" error occurred when resizing tables in View Builder
- Multiple primary key names were generated when exporting model to SQL files
- int8 type was converted to int8(255) when synchronizing model to PostgreSQL server
- Syntax error occurred when connecting to MySQL 4
- Minor bug fixes and improvements


Navicat Premium 15.0.4 (64-bit)
Bug fixes:
- Access violation error occurred when adding users to Navicat Cloud project
- Access Denied error occurred when designing table
- Unable to highlight field when typing in Filter's field selection list
- Wrong fields are exported to the SQL file when not all fields are selected
- Dark theme kept reverting back to Normal theme
- Wrong CREATE INDEX was generated in Model
- MySQL JSON data was truncated in Table Viewer
- Empty value was exported as **** when exporting DBF file
- Data Transfer high memory consumption issue
- Unable to connect Azure Database for MariaDB
- Run queries slow issue
- Unable to set Numeric field without precision in PostgreSQL server
- "List index out of bounds (-1)" error occurred when editing role privileges
- "Last Tab Window" option was missing


Navicat Premium 15.0.3 (64-bit)
- New Charts
- Advanced Data Transfer
- Brand new Query Builder
- Enhanced Data Modeling Tool
- Dark theme UI and Diagram
- Many other new features and improvements