What's new in Navicat for MariaDB 16.3.7
Apr 16, 2024
- Bug-fixes:
- Modified data types were not retained when switching to other tables in Import Wizard.
- Unable to connect using ssh agent in some cases.
- Minor bug fixes and improvements.
New in Navicat for MariaDB 16.3.6 (Feb 21, 2024)
- Bug-fixes:
- Crashed when presenting dashboard in some cases.
- Unable to change data types when creating tables.
- Focus moved to the upper level after deleting an object in Navigation Pane.
- Some labels disappeared after adding the chart to the dashboard.
- Unable to display proportion percentages in the chart axis.
New in Navicat for MariaDB 16.3.5 (Feb 21, 2024)
- Bug-fixes:
- Unable to load indexes in MariaDB Table Designer.
- Crashed when closing Server Monitor.
- The percentage values shown in the chart were incorrect.
- Minor bug fixes and improvements.
New in Navicat for MariaDB 16.3.4 (Dec 12, 2023)
- Bug-fixes:
- Crashed when opening Navicat on older macOS versions.
- Minor bug fixes and improvements.
New in Navicat for MariaDB 16.3.3 (Dec 12, 2023)
- Bug-fixes:
- Column widths were not retained when opening tables/views.
- Crashed when scheduling batch jobs in some cases.
- Minor bug fixes and improvements.
New in Navicat for MariaDB 16.3.2 (Nov 7, 2023)
- Bug-fixes:
- COMMAND-F shortcut did not work in the main window.
- Refresh button did not work in Server Monitor.
- Text in the Search box was hidden in some cases.
- Advanced options in Structure Synchronization cannot be displayed.
- Minor bug fixes and improvements.
New in Navicat for MariaDB 16.3.1 (Oct 30, 2023)
- Bug-fixes:
- Minor bug fixes and improvements.
New in Navicat for MariaDB 16.3.0 (Oct 17, 2023)
- Bug-fixes:
- Crashed when transferring large tables using SSH connection.
- Minor bug fixes and improvements.
New in Navicat for MariaDB 16.2.9 (Sep 21, 2023)
- Bug-fixes:
- Crashed on macOS 14.
- MariaDB Triggers were transferred multiple times during Data Transfer.
- Minor bug fixes and improvements.
New in Navicat for MariaDB 16.2.7 (Aug 29, 2023)
- Bug-fixes:
- Beautify SQL incorrectly added spaces between the function name and parentheses.
- Minor bug fixes and improvements.
New in Navicat for MariaDB 16.2.6 (Aug 29, 2023)
- Bug-fixes:
- Minor bug fixes and improvements.
New in Navicat for MariaDB 16.2.5 (Jul 14, 2023)
- Bug-fixes:
- Minor bug fixes and improvements.
New in Navicat for MariaDB 16.2.3 (Jun 21, 2023)
- Bug-fixes:
- Copy and paste shortcuts did not work in Navigation pane.
- The focus jumped to the top level after renaming an object in Navigation pane.
- Table tree loading issue in Navigation Pane.
- Minor bug fixes and improvements.
New in Navicat for MariaDB 16.2.2 (Jun 9, 2023)
- Bug-fixes:
- Minor bug fixes and improvements.
New in Navicat for MariaDB 16.2.1 (Jun 9, 2023)
- Main New Features:
- Support sequence design for MariaDB.
- Show fields, indexes and more under tables in Navigation Pane.
- Minor bug fixes and improvements.
- Navicat for Redis is released.
New in Navicat for MariaDB 16.1.10 (May 31, 2023)
- Bug-fixes:
- High CPU usage when using SSH connection.
- Unable to save the schedule changes.
- TAB key did not work when adding field.
- Minor bug fixes and improvements.
New in Navicat for MariaDB 16.1.9 (Apr 18, 2023)
- Bug-fixes:
- Crashed when opening Preferences in some cases.
- Crashed when importing database to model in some cases.
- Crashed when saving table after changing field comment.
- Minor bug fixes and improvements.
New in Navicat for MariaDB 16.1.7 (Mar 2, 2023)
- Bug-fixes:
- Memory utilization issue.
- Minor bug fixes and improvements.
New in Navicat for MariaDB 16.1.6 (Mar 2, 2023)
- Bug-fixes:
- Unable to backup if database folder did not exist.
- Unable to load cloud connection info when opening data transfer profile.
- Minor bug fixes and improvements.
New in Navicat for MariaDB 16.1.5 (Dec 12, 2022)
- Bug-fixes:
- Default value did not show when adding new records.
- Minor bug fixes and improvements.
New in Navicat for MariaDB 16.1.4 (Nov 26, 2022)
- Bug-fixes:
- 1267 error occurred when clicking the "Users" button.
- Bar chart label display issue.
- BLOB data was truncated in Console.
- Table columns were not aligned in Console.
- Chart value labels disappeared after reopening Navicat in dark mode.
- Minor bug fixes and improvements.
New in Navicat for MariaDB 16.1.3 (Sep 29, 2022)
- Bug-fixes:
- Unable to enter Enum values in MariaDB table designer.
- Query Builder did not recognize the selected fields.
- Minor bug fixes and improvements.
New in Navicat for MariaDB 16.1.2 (Aug 31, 2022)
- Bug-fixes:
- Minor bug fixes and improvements.
New in Navicat for MariaDB 16.1.1 (Aug 21, 2022)
- Bug-fixes:
- Unable to open the objects in the "Find in Database" window.
- Cannot show query errors when using HTTP tunnel.
- Crashed when renaming a connection in a group.
- Cannot show the new group unless Navicat was restarted.
- Checks were not imported when using "Reverse Database to Model".
- Unable to sort columns in table viewer.
- Minor bug fixes and improvements.
New in Navicat for MariaDB 16.1.0 (Jul 21, 2022)
- Main New Features:
- 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.
New in Navicat for MariaDB 16.0.14 (Jun 15, 2022)
- Bug-fixes:
- Query parameters did not work in some cases.
- Function group creation issue.
- Hanged when updating records in some cases.
- Minor bug fixes and improvements.
New in Navicat for MariaDB 16.0.13 (May 10, 2022)
- Bug-fixes:
- Chart title display issue.
- Query listing issue when loading cloud queries.
- Minor bug fixes and improvements.
New in Navicat for MariaDB 16.0.12 (Mar 28, 2022)
- Bug-fixes:
- Crashed when opening a table in some cases.
- Minor bug fixes and improvements.
New in Navicat for MariaDB 16.0.11 (Mar 16, 2022)
- Bug-fixes:
- Add/Delete Foreign Key issue in ER diagram.
- "Show bar labels" setting cannot be saved in Charts.
- Crashed when moving a connection from Navicat Cloud to My Connections.
- Crashed when running Automation in some cases.
- Minor bug fixes and improvements.
New in Navicat for MariaDB 16.0.9 (Mar 1, 2022)
- Bug-fixes:
- Crashed when using table viewer.
- Minor bug fixes and improvements.
New in Navicat for MariaDB 16.0.8 (Mar 1, 2022)
- Bug-fixes:
- Unable to show the query result tab in Navicat for MariaDB.
- Auto completion did not work when inputting ENUM value in the table viewer.
- Crashed when closing Navicat in some cases.
- Hanged when designing table.
- Unable to scroll through the fields with the mouse wheel in Query Builder.
- Duplicate options in the user Plugin dropdown menu.
- Connection coloring did not work on subtabs.
- Crashed when importing invalid json files.
- Minor bug fixes and improvements.
New in Navicat for MariaDB 16.0.7 (Jan 13, 2022)
- Bug-fixes:
- Minor bug fixes and improvements.
New in Navicat for MariaDB 16.0.6 (Jan 3, 2022)
- Bug-fixes:
- Data Transfer failed when using HTTP tunnel.
- Line numbers disappeared when scrolling in Query Editor.
- Minor bug fixes and improvements.
New in Navicat for MariaDB 16.0.5 (Dec 15, 2021)
- Bug-fixes:
- Connection encoding issue in Navicat Cloud.
- Crashed in some cases.
- Minor bug fixes and improvements.
New in Navicat for MariaDB 16.0.3 (Nov 23, 2021)
- Main New Features:
- New Data Generation Tool
- Enhanced Charts Feature
- Support of Navicat On-Prem Server
- Additional Features:
- Connection Profiles
- Field Information Pane
- Query Execution Summary
- Navicat On-Prem Server is released
- Many other new features and improvements
New in Navicat for MariaDB 15.0.32 (Nov 14, 2021)
- Bug-fixes:
- Crashed when running scripts in some cases.
- Crashed when copying records in some cases.
- The TEXT pane did not retain when running queries.
- Minor bug fixes and improvements.
New in Navicat for MariaDB 15.0.30 (Aug 20, 2021)
- Bug-fixes:
- Unable to show the cursor when editing TEXT data using Form View in Dark Mode.
- Minor bug fixes and improvements.
New in Navicat for MariaDB 15.0.29 (Jun 29, 2021)
- Bug-fixes:
- Differences were incorrectly detected when synchronizing MySQL table structures.
- Crashed when running query in some cases.
- Minor bug fixes and improvements.
New in Navicat for MariaDB 15.0.28 (May 3, 2021)
- Bug-fixes:
- Unable to update data in some cases.
- Crashed when using Data Transfer in some cases.
- Exporting JSON field didn't handle NULL and integer values properly.
- Cursor did not focus to the Search box after pressing CMD-F.
- Crashed when selecting the "Group by Object Type" in Structure Synchronization.
- Minor bug fixes and improvements.
New in Navicat for MariaDB 15.0.26 (Mar 8, 2021)
- Bug-fixes:
- Unable to read grid data in Dark mode.
- Unable to sort the last column by clicking the column header in Table Viewer.
- Duplicate entry error occurred when editing the pasted records.
- Hanged when starting Navicat in some cases.
- Minor bug fixes and improvements.
New in Navicat for MariaDB 15.0.25 (Jan 15, 2021)
- Bug-fixes:
- 'Primary key needs to be integer' error occurred when synchronizing data.
- Unable to show the ENUM items list in Table Viewer.
- Unable to sort by clicking the column header in Table Viewer.
- Minor bug fixes and improvements.
New in Navicat for MariaDB 15.0.24 (Dec 16, 2020)
- Improvements:
- Set the values of a column to NULL.
- Bug-fixes:
- Crashed when saving MariaDB Views.
- The modified dates of backup files were incorrect.
- Minor bug fixes and improvements.
New in Navicat for MariaDB 15.0.22 (Oct 12, 2020)
- Improvements:
- Prompt to change the MariaDB password when it expired.
- Bug-fixes:
- Unable to show the granted privileges if the database name contained wildcard characters.
- Only the last selected table was printed when printing multiple tables.
- The SQL Editor was flickered and repainted when saving the query.
- "Auto Increment" and "Unsigned" options were removed after adding another field.
- Crashed when using Query Builder on Big Sur.
- Minor bug fixes and improvements.
New in Navicat for MariaDB 15.0.21 (Sep 15, 2020)
- Bug-fixes:
- The "Set to Null" option was applied to a wrong column when some columns were hidden in Table Viewer.
- The field size was incorrect in Form View.
- Crashed when opening/testing a connection after changing "Settings Location" to a folder in Documents.
- The "Encoding" setting was not stored when the connection was synchronized to Navicat Cloud.
- "Dump SQL File" stopped running in some cases.
- Minor bug fixes and improvements.
New in Navicat for MariaDB 15.0.20 (Aug 4, 2020)
- Bug-fixes:
- Unable to set the encoding of MariaDB connection.
- Schedule did not trigger when using Navicat App Store version.
- The "Close Database" option in the context menu was dimmed when a query tab was focused.
- The entire connection tree was collapsed when searching.
- Crashed when deleting a data source in Charts.
- Minor bug fixes and improvements.
New in Navicat for MariaDB 15.0.18 (Jun 23, 2020)
- Improvements:
- Improvement on resizing Information pane.
- Bug-fixes:
- Negative default value displayed as "-" in MariaDB.
- No records were imported in some cases when Import Wizard displayed "Finished Successfully".
- Wrong SQL generated for CAST function when switching between Query Editor and Query Builder.
- Minor bug fixes and improvements.
New in Navicat for MariaDB 15.0.17 (Jun 5, 2020)
- Bug-fixes:
- Unable to show full table names in the Data Synchronization window.
- Field names in the Join dialog were truncated.
- Minor bug fixes and improvements.
New in Navicat for MariaDB 15.0.16 (May 18, 2020)
- Bug-fixes:
- Minor bug fixes and improvements.
New in Navicat for MariaDB 15.0.15 (May 6, 2020)
- Bug-fixes:
- Jumped to the first record when refreshing in Form View.
- The list of the reference tables for foreign key was empty in Model.
- Minor bug fixes and improvements.
New in Navicat for MariaDB 15.0.12 (Mar 23, 2020)
- Bug-fixes:
- "9015: Error Moving Error" error occurred when using Navicat Cloud.
- Crashed when clicking the Next button without choosing a target database in Data Transfer.
- Unable to show the whole Trial Reminder dialog.
- Crashed when editing/composing new queries in some cases.
- Invalid XML error occurred when importing connections.
- Crashed when starting Data Transfer in some cases.
- Minor bug fixes and improvements.
New in Navicat for MariaDB 15.0.11 (Feb 28, 2020)
- Bug-fixes:
- Console was missing in Standard eidtion.
- Minor bug fixes and improvements.
New in Navicat for MariaDB 15.0.10 (Feb 28, 2020)
- Bug-fixes:
- Crashed when using Data Transfer in some cases.
- Inserted records to the target server when transferring views.
- CPU usage was high when using Query Builder.
- Unable to open the main window when starting Navicat.
- Minor bug fixes and improvements.
New in Navicat for MariaDB 15.0.8 (Jan 16, 2020)
- Bug-fixes:
- Crashed when starting Navicat.
- Dates before 1900 were exported as numeric values when exporting to Excel.
- The Search feature did not work properly in the Data Transfer window.
- Icon and text were not aligned well in the Navigation pane
- The unchecked "Includes anonymous system profile" option was reverted to check after restarting Navicat.
- Minor bug fixes and improvements.
New in Navicat for MariaDB 15.0.7 (Jan 6, 2020)
- Bug-fixes:
- Crashed when starting Navicat.
- Crashed when running Data Transfer in some cases.
- Minor bug fixes and improvements.
New in Navicat for MariaDB 15.0.6 (Dec 24, 2019)
- Bug-fixes:
- Unable to run selected query in some cases.
- Crashed when using Data Transfer.
- Unable to show which database is active.
- Minor bug fixes and improvements.
New in Navicat for MariaDB 15.0.4 (Dec 9, 2019)
- Bug-fixes:
- Data Synchronization options were unable to save in profile.
- Auto Layout feature separated notes and labels from layers.
- Unable to copy SQL query from Process List in Server Monitor.
New in Navicat for MariaDB 15.0.3 (Nov 25, 2019)
- New Features:
- New Charts
- Advanced Data Transfer
- Brand new Query Builder
- Enhanced Data Modeling Tool
- Dark theme UI and Diagram
- Many other new features and improvements
New in Navicat for MariaDB 12.1.27 (Oct 16, 2019)
- Bug-fixes:
- Minor bug fixes and improvements.
New in Navicat for MariaDB 12.1.26 (Oct 9, 2019)
- 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.
New in Navicat for MariaDB 12.1.25 (Sep 17, 2019)
- 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.
New in Navicat for MariaDB 12.1.24 (Jul 24, 2019)
- 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.
New in Navicat for MariaDB 12.1.23 (Jun 12, 2019)
- 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.
New in Navicat for MariaDB 12.1.22 (May 24, 2019)
- 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.
New in Navicat for MariaDB 12.1.20 (Apr 18, 2019)
- Bug-fixes:
- Minor bug fixes and improvements.
New in Navicat for MariaDB 12.1.19 (Apr 17, 2019)
- Bug-fixes:
- 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.
New in Navicat for MariaDB 12.1.18 (Mar 21, 2019)
- 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.
New in Navicat for MariaDB 12.1.16 (Feb 27, 2019)
- 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.
- Minor bug fixes and improvements.
New in Navicat for MariaDB 12.1.15 (Feb 27, 2019)
- Bug-fixes:
- Unable to search the grouped queries unless the group was selected.
- Crashed when using Find in Database/Schema if the connection was not opened.
- Field comment font color issue when using Dark Mode.
- SSH key file reselect issue when opening connection in App Store version.
- Crashed when creating a project.
- Beautify SQL feature wrongly split text which started with numbers.
- Row highlight issue when using Dark Mode.
- Crashed when opening Datetime picker window in Table Viewer.
- Unable to show line number in SQL Editor on macOS 10.14.
- Code Folding did not work properly in SQL Editor on macOS 10.14.
- Minor bug fixes and improvements.
New in Navicat for MariaDB 12.1.13 (Feb 27, 2019)
- Bug-fixes:
- Crashed when opening Navicat if logged in Navicat Cloud.
- Unable to connect using SSH private key in some cases.
- Hanged when saving Procedure/Function.
- Crashed when clicking Views in some cases.
- Minor bug fixes and improvements.
New in Navicat for MariaDB 12.1.12 (Feb 27, 2019)
- Bug-fixes:
- Mojave's Dark Mode did not display properly.
- Minor bug fixes and improvements.
New in Navicat for MariaDB 12.1.11 (Feb 27, 2019)
- Bug-fixes:
- Stored procedures was not exported properly when using Data Transfer.
- Import Wizard was slow in some cases.
- "Connection is in use" message prompted when restarting Navicat if connection password was not stored.
- Crashed after Navicat was opened in a few minutes.
- Crashed when showing Navicat Cloud Agreement.
- Crashed when synchronizing data in MariaDB System Versioned Tables.
- Unable to copy data from Table Viewer.
- Code Completion did not work properly in some cases.
- Inputted text was not displayed when renaming objects on Navigation Pane in Mojave's Dark Mode.
- Unable to list the batch jobs in some cases.
- Connection/Database did not open when dragging tables into it.
- Minor bug fixes and improvements.
New in Navicat for MariaDB 12.1.10 (Feb 27, 2019)
- Bug-fixes:
- "" tag was repeated twice when exporting HTML file.
- Definition was missing when dumping Views and Functions.
- Crashed when starting Navicat in some cases.
- Foreign key data selection did not work.
- Minor bug fixes and improvements.
New in Navicat for MariaDB 12.1.9 (Oct 2, 2018)
- Bug-fixes:
- HTML export did not specify charset.
- Minor bug fixes and improvements.
New in Navicat for MariaDB 12.1.8 (Oct 2, 2018)
- Available Jobs list did not sort alphabetically in Automation.
- Minor bug fixes and improvements.
New in Navicat for MariaDB 12.1.7 (Aug 29, 2018)
- 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.
New in Navicat for MariaDB 12.1.6 (Aug 23, 2018)
- 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.
New in Navicat for MariaDB 12.1.4 (Aug 3, 2018)
- 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.
New in Navicat for MariaDB 12.1.3 (Jul 27, 2018)
- Support Roles for MariaDB 10
- Brand new Filter Wizard
- UI and UX Improvement
- MongoDB is added in Navicat Premium
- Navicat for MongoDB is released
New in Navicat for MariaDB 12.0.28 (Jul 13, 2018)
- 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.
New in Navicat for MariaDB 12.0.27 (Jun 10, 2018)
- 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.
New in Navicat for MariaDB 12.0.25 (Apr 24, 2018)
- 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.
New in Navicat for MariaDB 12.0.24 (Mar 29, 2018)
- 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.
New in Navicat for MariaDB 12.0.23 (Feb 25, 2018)
- 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.
New in Navicat for MariaDB 12.0.22 (Jan 22, 2018)
- Bug Fixes:
- Error occurred when synchronizing structure in some cases.
- Enum type value returned as string in query results.
- Exported Excel files were corrupted in some cases.
New in Navicat for MariaDB 12.0.21 (Jan 15, 2018)
- Bug Fixes:
- Minor bug fixes and improvements.
New in Navicat for MariaDB 12.0.20 (Jan 11, 2018)
- 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.
New in Navicat for MariaDB 12.0.19 (Dec 2, 2017)
- Bug Fixes:
- Unable to zoom in/out Query Editor using mouse wheel.
- 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.
New in Navicat for MariaDB 12.0.18 (Nov 13, 2017)
- 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.
New in Navicat for MariaDB 12.0.16 (Oct 17, 2017)
- 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.
New in Navicat for MariaDB 12.0.15 (Oct 12, 2017)
- Bug Fixes:
- 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.
New in Navicat for MariaDB 12.0.14 (Sep 26, 2017)
- 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.
New in Navicat for MariaDB 12.0.13 (Sep 11, 2017)
- 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.
New in Navicat for MariaDB 12.0.12 (Aug 25, 2017)
- Bug Fixes:
- 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 column 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.
New in Navicat for MariaDB 12.0.11 (Aug 25, 2017)
- 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.
New in Navicat for MariaDB 12.0.10 (Jul 26, 2017)
- 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.
New in Navicat for MariaDB 12.0.9 (Jul 15, 2017)
- Bug Fixes:
- 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.
New in Navicat for MariaDB 12.0.7 (Jul 4, 2017)
- Bug Fixes:
- 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.
New in Navicat for MariaDB 12.0.6 (Jun 27, 2017)
- 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.
New in Navicat for MariaDB 12.0.5 (Jun 16, 2017)
- Bug Fixes:
- 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.
New in Navicat for MariaDB 11.2.18 (May 5, 2017)
- Minor bug fixes and improvements.
New in Navicat for MariaDB 11.2.17 (Mar 1, 2017)
- Bug fixes:
- Failed to move procedures to a virtual group.
- Minor bug fixes and improvements.
New in Navicat for MariaDB 11.2.16 (Dec 19, 2016)
- Bug Fixes:
- 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.
New in Navicat for MariaDB 11.2.15 (Oct 24, 2016)
- Bug Fixes:
- The default date time format and delimiter of Export Wizard did not follow Import Wizard.
New in Navicat for MariaDB 11.2.14 (Sep 1, 2016)
- 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.
New in Navicat for MariaDB 11.2.13 (Aug 8, 2016)
- Bug Fixes:
- Crashed after exporting in some cases.
- Crashed when importing files with long field name.
- Failed to run "LOAD DATA LOCAL INFILE" statement in Query Editor.
- Column titles was unable to display properly in Form view when using large font size.
- Crashed when deleting tables with relations in Diagram view.
New in Navicat for MariaDB 11.2.12 (Jul 5, 2016)
- Improvements:
- Support utf8mb4 Character Set in MariaDB connections.
- Support smart quotes in Query Builder.
- Bug Fixes:
- Progress bar did not update in Data Transfer.
- Unable to expand connection tree in some case if the corresponding tab was not selected.
- Crashed while working with a profile in a virtual group.
- Unable to perform data synchronization using command line.
- Crashed when inserting record with RAW mode in Table Viewer.
- Failed to move multiple objects into a virtual group by right-click menu in Navicat Cloud connections.
New in Navicat for MariaDB 11.2.11 (Apr 29, 2016)
- Bug fixes:
- Crashed when opening or closing Navicat Cloud database in some cases.
- Unable to beautify SQL keywords to upper case in Query Editor.
New in Navicat for MariaDB 11.2.10 (Apr 26, 2016)
- Bug fixes:
- Fixed the column order issue when using Copy As Insert/Update in Table Viewer.
- Failed to close the parameter window after opening in Function Designer.
- App Store Essentials version: Failed to keep the "Show Object List" state in Query.
New in Navicat for MariaDB 11.2.9 (Mar 9, 2016)
- Bug fixes:
- Functions were removed after editing the query in Query Builder.
- Unable to remember the file path if the path contains space in Export Wizard.
- Model History pane showed many changing color histories in some cases.
New in Navicat for MariaDB 11.2.8 (Jan 28, 2016)
- Bug fixes:
- Background color of keyword "SUM" did not change with non-white background in Query Editor.
- Auto-completion did not work for 1 char alias in Query Editor.
- Extra database name was added when drag and drop a table to Query Builder.
- Crashed when creating backup in Cloud connections.
- Unable to create MySQL Enum column in Table Designer.
- Crashed when double-clicking the "Find in Database" result in some cases.
- Queries with "JOIN" was not parsed correctly in some case in Query Editor.
New in Navicat for MariaDB 11.2.7 (Jan 14, 2016)
- Bug Fixes:
- Wrongly added extra " char in the exported data when the data contained " char.
- Unable to open the Find result in "Find in Database".
- Unable to change the field order by dragging in the SELECT tab of View Builder.
- "Show Result" setting of Query was not saved immediately.
- Unable to disable the folding setting of Query Editor in Preferences.
- Crashed when double-click to select the query and run selected.
- Crashed when loading server preferences from preference.plist file on launching Navicat.
- Unable to open the saved import profile.
- Unable to show [] with black background in Query Editor.
- Shortcuts CTRL-A, CTRL-E were missing in Query Editor.
New in Navicat for MariaDB 11.2.6 (Dec 28, 2015)
- Bug Fixes:
- Adding multiple relations issue in Model's Table Designer.
- Unable to uncheck the "Limit records per page" box in Table Viewer.
- Crashed when pasting SQL to Query Editor.
- Error occurred when saving views after applying Beautify SQL.
New in Navicat for MariaDB 11.2.5 (Dec 23, 2015)
- Bug Fixes:
- Unable to save the "Show Object List" option in Query.
- There was no syntax highlight in the SQL Preview tab.
- Unable to show the cursor in Query Editor with black background.
- Failed to drag and drop connection in some cases.
- Smart quote issue in Query Editor.
- Font issue in Query Editor.
- Find feature issue in Query Editor.
- Unable to copy more than 30 rows in Table/Query Viewer.
New in Navicat for MariaDB 11.2.2 (Dec 10, 2015)
- MAJOR NEW FEATURES:
- Navicat Cloud Collaboration:
- Create/Modify/Delete projects.
- Add members to project for sharing connection settings, queries and models.
- View Project Activity Log.
- Data Modeling Tool:
- Support Model Conversion.
- Support Views.
- Enhanced Table Designer.
- Others:
- Enhanced Filter Wizard.
- Enhanced Query Designer.
New in Navicat for MariaDB 11.1.17 (Nov 18, 2015)
- Bug Fixes:
- Failed to log in Navicat Cloud in some cases.
- Crashed when running Structure Synchronization.
New in Navicat for MariaDB 11.1.16 (Nov 3, 2015)
- Bug Fixes:
- Unable to copy backup files to another database by drag and drop method.
- Crashed when running Data Transfer more than once on OS X 10.11.
- Froze when operating Table Viewer with longtext data.
- Crashed when running stored procedures on OS X 10.11.
- Crashed when adding password using MD5 function in Table Viewer Raw mode.
- Crash when running SQL multi times in Console.
- Unable to set the default value of the bit type in Table Designer.
New in Navicat for MariaDB 11.1.15 (Sep 16, 2015)
- Showed wrong database in Connection Tree.
- Execute SQL file did not output errors in some cases.
- Lost local connections after Navicat crashed during synchronizing to Navicat Cloud.
- App Store version: In-App Purchase did not work in Mac OS X 10.11.
New in Navicat for MariaDB 11.1.14 (Aug 4, 2015)
- Improvements:
- Supported format strings in Schedule email body.
- Bug Fixes:
- Unable to send notification email in Schedule.
- Created a new connection when previewing a view.
- Unable to change the case of the backup file name.
- Lost connections in some cases.
New in Navicat for MariaDB 11.1.13 (May 21, 2015)
- Bug Fixes:
- Crashed when importing connections.
- Crashed when reversing database to model.
New in Navicat for MariaDB 11.1.12 (Apr 27, 2015)
- Bug Fixes:
- Object List tab did not change when selecting nodes from connection tree.
- Unable to send email when running batch jobs using Command Line.
- Failed to save the order of connections in Navicat Cloud.
New in Navicat for MariaDB 11.1.11 (Mar 27, 2015)
- Bug Fixes:
- Unable to edit BLOB field's text data on TEXT editor.
- Unable to use CMD-Y New Query shortcut after selecting Tables, Views, etc nodes on Connection Tree.
- Failed to run schedule for connections in Navicat Cloud.
- Cursor did not focus on Query Editor when opening a query.
New in Navicat for MariaDB 11.1.10 (Mar 13, 2015)
- Bug Fixes:
- Wrongly showed MySQL/MariaDB TEXT fields with collation xxx_bin as BLOB fields in Table Viewer.
- Fixed import DBF file with empty datetime value issue.
New in Navicat for MariaDB 11.1.9 (Feb 6, 2015)
- Improvements:
- Added the ability to copy column name with data and copy records as Insert/Update statements in Query/View Result.
- Bug Fixes:
- Fixed the time interval setting issue in Schedule.
- Fixed the multi headers issue when exporting multi SELECT query to XML file.
- Fixed the warning issue when renaming query.
- Fixed unable to handle delimiter statements issue in Execute SQL File.
New in Navicat for MariaDB 11.1.8 (Feb 6, 2015)
- Improvements:
- Added the ability to copy column name with data in Table Viewer.
- Bug Fixes:
- Crashed in SSH re-connection.
- Fixed the smart quotes/dashes issue in Query Builder.
- Fixed the data type issue when importing xlsx in Import Wizard.
- Fixed the creation of database/schema issue when no target database/schema name provided in Data Transfer.
New in Navicat for MariaDB 11.1.7 (Dec 17, 2014)
- Improvements:
- Show popup message if errors occur during dumping tables/databases/schemas to SQL file.
- Bug Fixes:
- Crashed when using "Reverse Database to Model" feature.
- Crashed when the connection between server and client is disconnected.
- Unable to scroll on long query.
- Unable to re-send Navicat Cloud verification email.
- Result set scrolled to line 2 after executing the query in OS X 10.10 .
New in Navicat for MariaDB 11.1.6 (Dec 2, 2014)
- Improvements:
- Supported copy data as INSERT/UPDATE statements in Table Viewer.
- Bug Fixes:
- Wrongly changed field type varchar(400) to BLOB for MySQL version 5.0.4 or above in Data Transfer.
- Editing data was not allowed sometimes in Table Viewer TEXT editor for MySQL/MariaDB.
- Failed to transfer MySQL tables with trigger in Data Transfer.
- Error occurred when changing the case of the connection name.
- Crashed when importing database/schema to Model.
- Crashed when creating Navicat Cloud account.
- Wrongly applied "Use smart quotes and dashes" setting in Console.
New in Navicat for MariaDB 11.1.5 (Oct 23, 2014)
- Bug Fixes:
- Navicat Cloud login checking restriction.
- The Select/Where/Group By/Having/Order By clasue bar disappeared in Query/View Builder.
- Connections are moved out from virtual groups after upgrading from version 11.0.
- Crashed when saving profiles.
- Failed to import date time field and float number from DBF files..
- Select fields panel in Table Designer did not update after the table was saved.
- INT type values were rounded up when importing XLS files.
- Table Designer view was not displayed corrently in HTTP connections.
New in Navicat for MariaDB 11.1.4 (Sep 26, 2014)
- Improvements:
- Customized column width and column order in Table Design are saved.
- Bug Fixes:
- Failed to run Backup Server jobs for cloud connections in Schedule.
- Generated wrong query for field name with "." in Filter Wizard.
- Crashed when removing connection from a virtual group.
- Unable to save the Word Wrap setting in Table Text Editor.
- Crashed when creating a new virtual group in fresh installed Navicat.
- Connection list did not refresh automatically after dragging connections between Navicat Cloud and My Connections.
New in Navicat for MariaDB 11.1.00 (Aug 26, 2014)
- Support to sync selected conntection settings, queries, model files and virtual group information to Navicat Cloud.
New in Navicat for MariaDB 11.0.20 (Aug 2, 2014)
- Bug Fixes:
- Crashed when adding foreign key under Table Designer in Data Modeling Tool.
New in Navicat for MariaDB 11.0.19 (Jul 9, 2014)
- Improvements:
- Support length of SSH password/private key passphrase increased from 99 to 255.
- Support to save name with "/" for Connection Save Path, Query, Import/Export/Backup profile, Backup, Schedule, Model, Data Transfer/Synchronization profile.
- Bug Fixes:
- Crashed after opening Navicat for long time.
- Crashed when prompted to input password for SSH connection in Data Transfer, Data/Structure Synchronization and Server Monitor.
- Reduced the time needed to wait for connection timeout when disconnected to server.
- Non-ASCII characters not able to show in Hex Editor under Table Viewer.
- Some operations in main window did not popup error when error occurred.
- When generated update query, identity column did not skip in Import Wizard.
- Crashed when modifying an error view.
- Website version: "SSH:Unknown Error!" error occured if doing any further action for SSH connection.
New in Navicat for MariaDB 11.0.18 (May 26, 2014)
- Bug Fixes:
- Crashed when copied and pasted a new row and committed the changes by clicking the "tick" button in Table Viewer.
- Export Wizard window did not show up for exporting query results.
- The title in Console window did not update into newly changed connection name.
- When typing single/double quote in Console, the quote would be changed into other char that did not recognized by server.
New in Navicat for MariaDB 11.0.17 (May 12, 2014)
- Improvements:
- Allow drag to reorder field as default in Table Designer.
- Bug Fixes:
- Connection password was unable to be saved.
- The state of running in full screen was unable to be saved, so that Navicat only started up in window mode.
- Error message occured while viewing table structure to show the file path.
- Disabled the vertical elastic effect to avoid wrong colour drawing for row index < 0 in Table Viewer.
- When previewed and enabled save queries to file, queries were not correctly written to the file in Data Synchronization.
- The file and file size position in Model info view were wrong.
- Crashed when right-clicked on an open area and seleted "Restore Backup".
- The bookmark setting of saved path was incorrect in Backup schedule.
New in Navicat for MariaDB 11.0.16 (Mar 7, 2014)
- Improvements:
- Now only column titles of the first result included when exporting multi dataset to the same file using Export Wizard.
- Bug Fixes:
- Tab was unable to be dragged and reordered in full screen mode.
- Crashed when using Find function in Table Viewer.
- Copy and Paste did not work on tables with auto-incremented columns while saving a record by clicking "tick" icon in the Table Viewer.
- Crashed after changed the "Use advanced connections" and press "ok" button in Table Viewer.
- Parameter list not able to show while including CHARACTER type in function parameters in Function Designer.
- Crashed when selecting a suggested word that required quoting in Scintilla auto completion.
- Crashed while scrolling table in Query Builder and exited Navicat.
- int with "." as Thousand Separator did not import correctly in Import Wizard.
- The datetime format showed in the export profile did not match the format used in the original table.
- Date and time were exported incorrectly while using a EDT time zone.
- Message Log was unable to save correctly for the Preview function in Data Synchronization.
- Table dataset and collation info on CREATE TABLE queries not able to synchronize in Structure Synchronization.
- When changing a relation's referencing schema, the relation remained in the table but the relation line in diagram was removed under Table Designer in Data Modeling Tool.
- Crashed when double-clicking the connection tree under Synchronize to Database in Data Modeling Tool.
- Schedele helper did not work although jobs still run in old version.
- Website version: Typed in the export queries filepath directly would cause file creation error in Data Synchronization.
- App Store Essentials version: Crashed when purchasing Code Completion feature without SQL Builder in View Designer.
New in Navicat for MariaDB 11.0.15 (Jan 7, 2014)
- Improvements:
- Improved connection tree behavior in main window.
- Bug Fixes:
- Database name was changed if failed to open it.
- Popup menu was shown far away when clicking on Diagram View or Model Design in retina display.
- Crashed when deleting active connection.
- Crashed when typing single digit in hour/minute/second field and press OK in table viewer.
- Unable to show error when getting database on open connection.
- Wrongly transformed MySQL date value in exported file.
- Crashed when closing the Export Wizard for exporting selected row in Table Viewer.
New in Navicat for MariaDB 11.0.14 (Dec 23, 2013)
- Improvements:
- Disabled zooming by magic mouse in Query Editor.
- Bug Fixes:
- Failed to open table on Mac OS X 10.6.
- Unable to add view's profile to the virtual group.
- Unable to duplicate profiles.