Softpedia >Windows >Internet >Servers >Database Utils >dbForge Query Builder for MySQL >  Changelog

dbForge Query Builder for MySQL Changelog

What's new in dbForge Query Builder for MySQL 10.0.225

Mar 28, 2024
  • Fixed errors that occurred during query editing (D149483)
  • Fixed a MySQL server connection error that occurred when using the SSL Cipher List parameter
  • Fixed the issue that prevented table editing for queries involving JOIN operations in the Data Editor
  • Resolved an issue that occurred when attempting to open a connection to the server while editing script parameters in the SQL Document
  • Fixed the Lost connection to MySQL server during query error in the stored procedure editor
  • Fixed an issue with unnecessary quotation marks being added to values when copying data from the Data Editor
  • Fixed an issue related to computing the insertion position for elements from the Member List

New in dbForge Query Builder for MySQL 10.0.150 (Jan 18, 2024)

  • Code Completion & Syntax Check:
  • Added support for START, STOP, SHOW and RESET REPLICA statements
  • Added full support for FLUSH command
  • DDL generator:
  • Added option Include triggers to DDL generator
  • Added Include DEFINER clause and Include SQL SECURITY clause options instead of Exclude DEFINER and SQL SECURITY clauses option
  • Others:
  • Added connectivity support for MariaDB 11.4
  • Upgraded from legacy chart designer to advanced new version
  • New Alt + Up/Down Arrow shortcuts for navigating script differences in the lower comparison pane in Schema Compare
  • User-reported and internal bug fixes:
  • Fixed an issue with ANSI_QUOTES that occurred during the compilation of procedures for debugging
  • Fixed issues that occurred during the synchronization of schemas into project files
  • Fixed syntax check issues that caused various malfunctions and improved the diagnostics of such issues
  • Fixed an issue that occurred when comparing object scripts to display differences
  • Fixed an issue with the execution of Commit and Get Latest from the shortcut menu of Database Explorer
  • Implemented the restoration of tables being edited in Data Editor in case of the execution of multiple SELECT queries
  • Fixed an issue in Object Search that occurred when searching for objects whose names contain the underscore character
  • Improved the object renaming functionality for users with limited permissions
  • Fixed an issue with editing string values in columns in Data Editor
  • Fixed an issue with displaying empty values in Data Editor
  • Fixed an issue that occurred when retrieving table metadata in Data Editor
  • Fixed an issue that occurred during the repeated execution of a SELECT query in Data Editor
  • Improved the selection of server connection in Object Editor when navigating between objects by name from SQL Document
  • Fixed an issue that occurred during the repeated execution of a query in SQL Document
  • Fixed an issue that occurred when pasting multiline text into a grid cell in Data Editor
  • Fixed an issue that occurred when opening the Tables node in Database Explorer with the 'Allow uncommitted objects discovery' option enabled
  • Fixed a syntax error in queries that join subqueries
  • Fixed an issue that occurred when running a comparison after saving a .scomp document
  • Fixed an issue that occurred when opening and editing documents in a project
  • Fixed an issue that occurred when changing a column name in Table Editor
  • Implemented the recovery of triggers when rebuilding a table in the editor
  • Fixed an issue with the generation of package DDL
  • Improved error diagnostics in Document Outline
  • Fixed the incorrect restoration of open documents
  • Fixed an issue that occurred when opening a project
  • Fixed an issue with applying the 'Use cached update mode by default' option
  • Fixed an issue with reading LOB
  • Fixed an issue with launching the application via CrossOver

New in dbForge Query Builder for MySQL 10.0.60 (Nov 20, 2023)

  • User-reported and internal bug fixes:
  • Fixed an issue with editing string values in the Data Editor
  • Resolved an application crash issue when attempting to save a script larger than 2 gigabytes
  • Resolved the problem with SQL Document freezing during query execution

New in dbForge Query Builder for MySQL 5.2.105 (Sep 14, 2023)

  • Improvements:
  • Added support for authentication via AWS Identity and Access Management (IAM)
  • User-reported and internal bug fixes:
  • Fixed an issue with the SSL connection to the server

New in dbForge Query Builder for MySQL 5.2.84 (Aug 17, 2023)

  • Connectivity:
  • Added support for MySQL v9.1
  • User-reported bug fixes:
  • Fixed an internal application error in SQL Editor

New in dbForge Query Builder for MySQL 5.2.27 (May 18, 2023)

  • Several user reported minor bugs are fixed

New in dbForge Query Builder for MySQL 5.2.4 (Apr 19, 2023)

  • Query Builder:
  • Added support for sequence tables
  • Connectivity:
  • Added support for MariaDB v11.3
  • Added support for Support for Aiven Cloud
  • Added support for SHA-256/512
  • Text Editor:
  • Enhanced code completion for application-period temporal tables
  • Added support for a broader range of optimizer hints
  • Added support for the TABLE statement
  • Added support for the EXCEPT and INTERSECT statements
  • Added support for spatial functions ST_LineInterpolatePoint, ST_LineInterpolatePoints, ST_PointAtDistance and ST_Collect
  • User-reported bug fixes:
  • Fixed the column list error in Pivot Grid (D99763)
  • Fixed the Query Builder error that could occur when using the IN operator (D104386, D113252, D117902, D117903, D92392)
  • Resolved an issue with excessive memory consumption by dbForge products (D96496)

New in dbForge Query Builder for MySQL 5.1.15 (Aug 30, 2022)

  • Improvements:
  • Connectivity support for MariaDB 10.10
  • User-reported bug fixes:
  • Fixed an issue with data modification in tables with an INVISIBLE column in the Data Editor
  • Fixed a bug that occurred when saving document cache for recovery

New in dbForge Query Builder for MySQL 5.1.6 (Aug 12, 2022)

  • General:
  • Added support for Linux and macOS via CrossOver
  • Added connectivity support for MariaDB 10.9
  • User-reported bug fixes:
  • Fixed an issue that occurred when exporting Execution History to the CSV format
  • Fixed issues that occurred when working with Query Builder (D89333, D89332, D90070, D91692, D91733, D91736, D91751, D92339, D92536, D93315, D94205, D88217, D88554, D88315)
  • Fixed an issue that occurred when opening an invalid .rdb file (D78863)
  • Fixed an issue with switching to the standby mode when moving columns in the query editor

New in dbForge Query Builder for MySQL 5.0.160 (May 20, 2022)

  • Improved CrossOver compatibility

New in dbForge Query Builder for MySQL 5.0.157 (May 19, 2022)

  • Improved CrossOver compatibility

New in dbForge Query Builder for MySQL 5.0.154 (May 12, 2022)

  • Improved the tab activation behavior when executing queries in a SQL Document
  • Improved the SSH Protocol configuration form to display the Local port option
  • Fixed an issue in the text editor on Windows builds 22567 and higher

New in dbForge Query Builder for MySQL 5.0.78 (Dec 9, 2021)

  • Fixed an issue with reading table metadata
  • Fixed an issue with reading session variables when opening a connection
  • Improved performance when opening a connection

New in dbForge Query Builder for MySQL 5.0.72 (Dec 1, 2021)

  • Fixed the behavior of the view editor during detection of syntax errors
  • Fixed an issue with the repeated execution of a query in Data Editor
  • Fixed the behavior of change markers in SQL Editor

New in dbForge Query Builder for MySQL 5.0.31 (Oct 20, 2021)

  • The application fails with a critical error when trying to create diagram objects after installing the KB5006670, KB5006672 or KB5006674 Windows update

New in dbForge Query Builder for MySQL 5.0.19 (Aug 27, 2021)

  • Data Reports
  • Master-Detail Browser
  • Pivot Tables

New in dbForge Query Builder for MySQL 4.5.506 (Jul 8, 2021)

  • Query Builder forces lower case table names

New in dbForge Query Builder for MySQL 4.5.449 (Apr 22, 2021)

  • Issue related to Drag & Drop of nodes in Database Explorer (Z53086, Z53076)

New in dbForge Query Builder for MySQL 4.5.396 (Feb 3, 2021)

  • Minor user reported bugs are fixed

New in dbForge Query Builder for MySQL 4.5.380 (Nov 26, 2020)

  • Improvements:
  • Work of the application when connecting via SSL is improved

New in dbForge Query Builder for MySQL 4.5.355 (Oct 9, 2020)

  • Improvements:
  • Behavior of metadata retrieving when dragging and dropping a table in Query Builder (T314046)
  • User-reported bug fixes:
  • Possibly incorrect scrip generation within Query Builder for queries containing date and time functions
  • Error with updating objects in Query Builder
  • Error with the undoing operations for linked tables in Query Builder

New in dbForge Query Builder for MySQL 4.5.283 (Jul 7, 2020)

  • Minor user reported bugs are fixed

New in dbForge Query Builder for MySQL 4.5.254 (May 22, 2020)

  • Connectivity
  • Connectivity support for MariaDB 10.5 is added
  • Display of server type in the Property window for MySQL, MariaDB, Percona, Amazon, Alibaba Cloud, and Tencent Cloud is added
  • Display of server type in the Connections section of the System window for MySQL, MariaDB, Percona, Amazon, Alibaba Cloud, and Tencent Cloud is added
  • Database Connection Properties and Test Connection windows are redesigned
  • Connectivity support for SkySQL is added
  • Support for new objects:
  • Working with the Packages and Sequences established in MariaDB 10.3 is supported
  • SQL Document:
  • -- nowarn and -- endnowarn tags have been added to the Execution warnings functionality
  • Exporting execution history in the CSV file format is added
  • Code Completion:
  • Code completion is available in the body of triggers and events

New in dbForge Query Builder for MySQL 4.4.38 (May 7, 2019)

  • User reported bugs fixed:
  • Problem with incorrect display of page count is fixed (T272555)
  • Minor user reported bugs are fixed

New in dbForge Query Builder for MySQL 4.4.22 (Jan 15, 2019)

  • Connectivity:
  • Support for MariaDB 10.4
  • User reported bugs fixed:
  • "PDF view" mode of Data Viewer issue is fixed (MYS-2038)
  • "Spatial view" mode of Data Viewer issue is fixed (MYS-2000)

New in dbForge Query Builder for MySQL 4.3.36 (Nov 21, 2018)

  • Problems with connection to MySQL Server are fixed

New in dbForge Query Builder for MySQL 4.3.35 (Oct 18, 2018)

  • Several bugs are fixed

New in dbForge Query Builder for MySQL 4.3.16 (Jul 6, 2018)

  • User reported bug fixes:
  • Loading file or assembly issue is fixed (T260447)

New in dbForge Query Builder for MySQL 4.3.12 (Jun 27, 2018)

  • Support for new servers:
  • Support for MySQL Server 8.0
  • Support for MariaDB 10.3
  • Support for Tencent Cloud

New in dbForge Query Builder for MySQL 4.2.34 (Apr 12, 2018)

  • Features and improvements:
  • Support for MariaDB 10.1
  • Support for MariaDB 10.2
  • Support for Google Cloud Platform
  • Support for Alibaba Cloud
  • Support for Azure MySQL
  • User reported bug fixes:
  • Problems with parsing in Query Builder are fixed (T216731, T218093, T219285)
  • Other user reported bugs are fixed (T165625, T166837, T167884, T171061, T171232, T178390, T179850, T242960, T224304, T199288)

New in dbForge Query Builder for MySQL 4.1.13 (Sep 18, 2017)

  • User reported NRE is fixed

New in dbForge Query Builder for MySQL 4.1.11 (Dec 24, 2016)

  • User reported bugs fixed:
  • Issues with TIME value in Data Editor and Viewer are fixed
  • Some Syntax Check and SQL Document issues are fixed

New in dbForge Query Builder for MySQL 4.1.10 (Nov 23, 2016)

  • Improved SQL document parser performance
  • Connection through Named Pipe implemented
  • Improved XML View and new JSON View for Data Editor and Viewer Window
  • Additional SQL statements are supported
  • Syntax Check supports new MariaDB 10.0 - 10.1 statements

New in dbForge Query Builder for MySQL 3.3.30 (Feb 5, 2015)

  • Database Explorer:
  • Displaying the objects number in the tree
  • Data Export and Import:
  • Export to the Excel 2007 (XLSX) format
  • Retaining records filtering when the Export Selected Rows Only option is selected
  • Export of BLOB fields as TEXT to Excel, TXT, HTML, PDF, RTF, and CSV formats
  • Export to Excel, RTF, PDF with/without a header
  • Force quotes option when exporting data to a CSV file
  • Option to select encoding when exporting to DBF
  • SQL Editing and Execution:
  • Query execution pane
  • Data Editor:
  • Easy way to hide data results
  • Data Viewer and LOB Editor are combined in a single control
  • Redirect Data to Output is transformed into additional data editor
  • Other Features and Improvements:
  • Enhanced Find and Replace window
  • On-line documentation

New in dbForge Query Builder for MySQL 3.2.18 (Aug 7, 2014)

  • The ability to view columns and indexes in Database Explorer is added
  • Object filter in Database Explorer is implemented
  • Connection via Windows authentication is added
  • Windows connection coloring is added
  • Switching between wizard window and primary window is available now

New in dbForge Query Builder for MySQL 3.1.12 (Feb 11, 2014)

  • Database connectivity support:
  • All known MySQL and MariaDB servers' features are available to use. In this version the following servers are supported:
  • MySQL 5.6
  • MySQL 5.7
  • MariaDB 5.5
  • MariaDB 10.0
  • MariaDB Virtual Columns are supported in:
  • Data Export wizards:
  • Microseconds support for TIME, DATETIME and TIMESTAMP data types
  • Data Editor
  • Data Export wizards
  • Pluggable authentication is supported:
  • The product provides the extended support of pluggable authentication modules for MySQL servers
  • Minor features and improvements
  • The application launch time is decreased
  • Microsoft Windows 8.1 is supported
  • User reported bug fixes:
  • MySQL Embedded 5.6 is supported (R29696)
  • Incorrect filter data on choosing Today value in Data Editor is fixed (R31110)

New in dbForge Query Builder for MySQL 3.0.105 (Jan 28, 2014)

  • ArgumentException while sorting data in the Data Editor is fixed (T88214, T88234, T89919)
  • Wrong behaviour with showing the dialog window on displaying data is fixed (T88367)
  • An error occurred while opening a file without an extension is fixed (T88880)
  • Short names are used now for editing data to avoid problems with replication (R29645)
  • NullReferenceException while displaying the Start Page is fixed (T90258, T91547)

New in dbForge Query Builder for MySQL 3.0.94 (Nov 26, 2013)

  • An exception while changing a parameter type in the Edit parameters window is fixed
  • An exception on clicking a splitter button in the Find Results window is fixed
  • A problem, related to the table columns prompting in the IN statement, in a subquery that contains WHERE condition is fixed

New in dbForge Query Builder for MySQL 3.0.79 (Nov 26, 2013)

  • NullReferenceException on sorting data in the Data Editor is fixed
  • NullReferenceException on using invalid file path in the Export wizard
  • NullReferenceException on editing a condition in the HAVING clause is fixed
  • An error while inserting data in a table from the Data Editor is fixed
  • NullReferenceException on editing code in the SQL editor is fixed
  • Receiving of meta data of default database is off (while the "Enable code completion" is disabled)
  • An error related to SSH connection is fixed

New in dbForge Query Builder for MySQL 3.0.69 (Nov 26, 2013)

  • The problem with the replication is fixed
  • InvalidOperationException on closing the application with opened documents is fixed
  • The problem with setting the current date in a cell of Data Editor is fixed
  • NullReferenceException on choosing an item in the Code Completion window is fixed
  • NullReferenceException on editing an expression in Query Builder is fixed
  • InvalidOperationException on describing Code Completion members is fixed
  • The problem with indentation on formatting a script with the CASE WHEN clauses is fixed
  • NullReferenceException on invoking the Save All command is fixed
  • ArgumentException on executing a script in SQL document is fixed
  • The problem with changing a case of variables in the DECLARE clause on formatting a statement is fixed

New in dbForge Query Builder for MySQL 3.0.61 (Aug 23, 2013)

  • NullReferenceException on losing connection is fixed (T72844, T73975, T71393, T71700, T72844, T69852, T70596, T73043)
  • NullReferenceException on executing query is fixed (T72865)
  • Error in Code Completion when working with quoted objects is fixed (T73749)
  • Error on displaying full file name or path in the "Windows" window is fixed (T74242)
  • Error on navigating in the FKLookup window of Data Editor is fixed (R23530)
  • NullReferenceException on adding invalid expression to GROUP BY or ORDER BY in Query Builder is fixed (R24196)
  • Error with suggesting the UNSIGNED keyword in the Code Completion functionality is fixed (R22572)
  • NullReferenceException in Data Editor on switching view modes with unsaved data is fixed (T74100)
  • NullReferenceException on working with SQL document is fixed (T72693)
  • Incorrect behaviour of LOB Editor with unsaved data is fixed (R22597)
  • Error on line numbering while grouping data in Data Editor is fixed (R23179)

New in dbForge Query Builder for MySQL 3.0.45 (Aug 23, 2013)

  • Problem with editing multiline text in a VARCHAR column is fixed (R22636)
  • Base64 encoding support is added for HTTP tunnel in the connection editor (T71684)
  • ArgumentException on showing data after execution of a query is fixed (T71375)
  • Incorrect number of records on showing data in paginal mode in Data Editor is fixed (T72465)
  • Problem with resetting of toolbar's customization is fixed (T70463)
  • Problem with the INTERNAL keyword in Code Completion is fixed (R22954)
  • Problem with execution of the DELIMITER statement is fixed (T72486)

New in dbForge Query Builder for MySQL 3.0.37 (Jun 13, 2013)

  • Invalid 'Reset Toolbar Layout' functionality is fixed (R21587)
  • Function GREATEST is added to autocompletion list (R21960)
  • ArgumentOutOfRangeException on cancelling the formating of a query is fixed (21925)
  • ArgumentOutOfRangeException on writing a SQL query is fixed (T71402)
  • CriteriaCompilerException on filtering data in Data Editor is fixed (T70637)
  • Incorrect determination of the current statement in SQL Document is fixed (T71402, T70359)
  • InvalidCastException on sorting data of the Date type in Data Editor is fixed (R22260)
  • Incorrect behaviour on a valid query in Query Builder is fixed (T70645)

New in dbForge Query Builder for MySQL 3.0.23 (May 8, 2013)

  • Query builder with support of DML statements and usability improvements:
  • Visual building of INSERT, UPDATE, and DELETE statements is supported
  • Conversion of SELECT queries into INSERT statements is supported
  • One-click conversion of SELECT query into UPDATE or DELETE with saving of WHERE condition is supported
  • Execution of separate subqueries to check their correctness without leaving diagram interface
  • Usability of visual expression editor is improved
  • Query type is indicated on the diagram surface
  • Data export to SQL statements:
  • Data export to INSERT, UPDATE, DELETE, and MERGE statements is supported
  • Ability to export query results as well as data directly from a table is supported
  • Quick generation of INSERT statements from data grid without opening wizard is supported
  • Improved code completion:
  • SQL Code Formatter is added
  • Quick object information is improved
  • Performance of describing objects' metadata is improved
  • New window docking system:
  • Switching between tool windows on Ctrl+Tab is supported
  • Minor features:
  • Amazon RDS is supported
  • If there is more than one SELECT statement in a document, query results are now displayed on separate tabs in the Data window after execution
  • Support of MySQL pluggable authentication on creating a connection to MySQL server is added
  • Support of Windows authentication on creating a connection to MySQL server
  • F5 shortcut now works for execution of a selected SQL fragment as well as for the entire script
  • New skins added (Metropolis and VS2010)

New in dbForge Query Builder for MySQL 2.5.44 (Jul 25, 2012)

  • Problem with missing functions in query designer is fixed
  • Error during designing query is fixed
  • Error "Invalid argument" when designing query is fixed

New in dbForge Query Builder for MySQL 2.5.27 (Jun 18, 2012)

  • Error report when specifying Not Null in Filter is fixed (T40269)
  • Error report when editing grid is fixed (T39998)
  • "Execute" label is added to the "execute" button (R9992)
  • Disabling intellisense buttons on change focus from sql document is added (R9996)
  • The "Can't get main profiling query." error report is fixed (T40713)
  • "Enter column name" and "Enter table name" phrases on the "Joins" tab are swapped (T41005)

New in dbForge Query Builder for MySQL 2.5.20 (May 23, 2012)

  • Problem with 'Execute Current Statement' command when the caret is placed after ';' is fixed
  • Error report with a table in the Query Builder is fixed
  • Problem with HTTP-tunneling is fixed
  • Problem with unexpected focused row in the Data Editor is fixed

New in dbForge Query Builder for MySQL 2.5.13 (Jan 13, 2012)

  • InvalidCastException on paste data into the Data editor is fixed
  • ArgumentOutOfRangeException on searching in Data Editor is fixed
  • Bad performance on server side sorting in Data Editor is fixed
  • NullReferenceException on switching to the Data document view in the SQL document is fixed
  • ArgumentException on editing of several records in Data Editor is fixed
  • The problem with windows layout on x64 operating systems is fixed
  • ObjectDisposedException on executing a script in a SQL document is fixed
  • UriFormatException on saving an SQL file on a mapped network drive is fixed
  • NullReferenceException on showing data in Data Editor is fixed
  • InvalidCastException on pasting LONGBLOB data in Data Editor is fixed
  • InvalidOperationException on deleting a record in Data Editor is fixed
  • The problem with changing database for a document is fixed
  • The problem with showing the Product Update dialog behind of the main form is fixed
  • The problem with connecting to MySQL server using SSL tunnel is fixed
  • OutOfMemoryException on changing a page in Data Editor is fixed
  • The wrong behaviour of the Continue button in the error message appeared during script execution is fixed
  • NullReferenceException on pressing the Enter key in Data Editor after inserting a new record is fixed
  • The problem with server-side sorting and filtering in Data Editor is fixed
  • The problem with a table locked by a server in Data Editor is resolved
  • NullReferenceException on editing data in Data Editor is fixed
  • NullReferenceException on opening a SQL file by drag'n'drop operation is fixed
  • ArgumentException on editing data in Data Editor is fixed
  • Incorrect editing of dates in Data Editor is fixed
  • NullReferenceException on parsing text in SQL document is fixed
  • DBConcurrencyException on updating records in Data Editor is fixed
  • Problem with restoring closed tool windows is fixed
  • FormatException on showing data after executing a query is fixed
  • A problem with showing the Product update dialog box is fixed
  • Few problems with showing the foreign key lookup editor in Data Editor are fixed
  • Inability of editing data on MySQL 4.1.22 is fixed
  • Incorrect behaviour with changing color of punctuation in code editor is fixed
  • Incorrect determination of boundaries for the current statement on executing a query in a SQL document is fixed
  • NullReferenceException on filtering data in Data Editor is fixed
  • ArgumentOutOfRangeException on switching from the Text view to the Design view in a SQL document is fixed
  • Refresh command is added for the Query Builder document to refresh objects on the diagram
  • Buttons on the Diagram and Layout toolbars are enabled now
  • NullReferenceException on designing a query in Query Builder is fixed
  • NullReferenceException on generating text with the last_insert_id function in Query Builder is fixed
  • Incorrect renaming of alias on wrapping query to subquery in Query Builder is fixed
  • NullReferenceException on wrapping a query to a subquery in Query Builder is fixed
  • NullReferenceException on refreshing connection with an opened SQL document is fixed
  • ArgumentOutOfRangeException on wrapping a query to a subquery in Query Builder is fixed

New in dbForge Query Builder for MySQL 2.5.11 (Jun 30, 2011)

  • NullReferenceException on refreshing data in Data Editor is fixed
  • ArgumentOutOfRangeException on loading a SQL file is fixed
  • NullReferenceException on fetching data after designing a query is fixed
  • Encoding utf8mb4 is now supported
  • The Cancel button is now the default one in dialog about uncommited changes in Data Editor
  • Annoying notifications in Data Editor are fixed
  • Problem with exporting decimal data is fixed
  • NullReferenceException on adding/removing select list items in table wrapped to subquery is fixed

New in dbForge Query Builder for MySQL 2.5.9 (May 24, 2011)

  • ObjectDisposedException on working with autohidden tool windows is fixed
  • IndexOutOfRangeException on minimizing and restoring the appilication is fixed
  • Lost connection on executing SLEEP function in SELECT statements is fixed
  • Application hanging on working with unresponsable server is fixed
  • ExternalException on operating clilbpoard operation in LOB Editor is fixed
  • Incorrect object describing with ANSI server mode is fixed
  • NullReferenceException on showing data in Data Editor is fixed
  • The problem with bad handshake on connecting to a server is fixed
  • Application hanging on openning a big SQL file with enormous count of JOIN clauses is fixed
  • Incorrect detection of default table engine on some MySQL server versions is fixed
  • Extra spaces on formatting SQL statements are fixed
  • Problems with formatting CASE clauses are fixed
  • Automatic diagram layout on its openning is fixed
  • FormatException on exporting data to CSV with custom DATE delimiters is fixed
  • The problem with exporting data from DECIMAL columns is fixed
  • The problem with showing Code Completion window for SUM() function is fixed
  • NotImplementedException on refreshing triggers collection in Database Explorer is fixed
  • The problem with connecting to MySQL server through SSL tunnel is fixed
  • The problem with connecting to embedded MySQL server is fixed

New in dbForge Query Builder for MySQL 2.5.8 (May 17, 2011)

  • Enhanced Data Editor:
  • Newly added features and a few totally redesigned ones provide even more freedom when working with data.
  • Foreign Key lookup editor added
  • Server-side sorting and filtering implemented to avoid retrieving all data from the table and enhance work in Paginal Mode
  • Few indications added to inform user about Data Editor's state
  • Editing of tables in join statements is enabled now
  • Option for numbering records added
  • Copy data with header functionality added
  • Data Export improvements:
  • Ability to export data from several tables at once added
  • Support for MySQL server 5.5
  • Our product is fully compatible with MySQL server version 5.5
  • New features were added and obsolete clauses removed in the Syntax check functionality
  • New encodings were added to the encoding list in the Connection Properties dialog
  • New state-of-the-art skins
  • Four new UI skins added to improve the application appearance.
  • Other improvements:
  • Ability to view internal SQL queries that are sent to the server with parameter's values added
  • A few UI improvements in Database Explorer

New in dbForge Query Builder for MySQL 2.00.5 (May 17, 2011)

  • New Features:
  • Meet a stronger Query Builder tailored for creating complex conditions with several clicks. The new power is based on the following:
  • Optimized usablility of the Selection tab in the expression editor
  • New Wrap to Subquery option to wrap tables into a subquery
  • Visual addition of subqueries to any part of the main query
  • Optimized navigation in the editor, particularly between subqueries
  • Capability to edit view location in the query document
  • Joins show connection direction; better described connection properties
  • New skin for objects on the diagram
  • New SQL document view layout - now you can see query text and retrieved data at the same time
  • New tool for database developers - Query Profiler
  • dbForge Query Builder offers results of internal MySQL tools like SHOW PROFILE and EXPLAIN in a convenient and clear GUI. Besides you get STATUS variables for the required query automatically calculated.
  • User reported bug fixes:
  • T13265 Transport channel is closed
  • T13766,T15231 ArgumentNullException at System.Windows.Forms.DataObject.SetText on working with Data Editor
  • T13003 The record pointer moves out of the actual edited record when Ctrl+0 was pressed (fill field with NULL)
  • CR51956 Incorrect diplaying datetime values in Data Editor
  • T14852 Incorrect display of application toolbars on some operating systems
  • T16250 Slow "Views" node opening in the Database Explorer
  • T15989 NullReferenceException on retrieving data from the Database Explorer
  • CR53449 Query Profiler must show date of profiling result in local format
  • CR53501 InvalidOperationException on executing script in SQL document
  • CR53593 NullReferenceException after clearing all in the Where editor in Query Builder
  • CR53644 NullReferenceException on getting new results in Query Profiler if the document was opened with the loaded database project
  • CR53646 Why the Refresh button is disabled after reopen SQL document?
  • T20888 NullReferenceException on refreshing data in Data Editor
  • CR53720 Do not save opened document views in SQL document
  • T21284 Display System.Byte[] instead of default values of table columns on MySQL 4.1.x
  • T10942 Add option to ignore query cache on query profiling
  • CR53767 Problems with query profiling on MySQL 4.1.x

New in dbForge Query Builder for MySQL 1.50.6 (Sep 8, 2010)

  • Automatic Connection Recovery:
  • If a database connection is broken, dbForge Query Builder for MySQL implicitly recovers it without any error generation.
  • Improved Data Editor:
  • Up to 40 improvements were implemented to create quicker, easier, and more delighted ways for data management. The Data Editor spares tens of mouse clicks a day for you.
  • Automatic Product Update:
  • dbForge Query Builder for MySQL automatically notifies you about any available updates and offers a flexible update process with Product Update Manager. This is a simple and effective way to deliver the new functionality and let you get the maximum of product usage.

New in dbForge Query Builder for MySQL 1.10.355 (Sep 9, 2009)

  • HTTP tunneling support added
  • SSL and SSH connections support added
  • More flexible setting of connection character set is implemented
  • NullReferenceException on switching between Text and Design views fixed (T5001)
  • NullReferenceException on closing SQL document after work with query builder was fixed (T4712)
  • Problems with editing statements in the Query Builder were fixed (T4013)
  • Correlated subqueries supported
  • Execute Script Wizard added to execute large SQL scripts
  • Database connectivity was optimized. Better performance while opening connections, doing data export.
  • Performance on large databases has been improved
  • Retrieving data from tables has become more faster and convenient
  • Problem with regional value of decimal separator during data copy from Data Editor was fixed (T4656)

New in dbForge Query Builder for MySQL 1.0.227 (Jun 12, 2009)

  • Problem with retrieving data from Database Explorer was fixed

New in dbForge Query Builder for MySQL 1.0.225 (Jun 12, 2009)

  • 'Cannot access a disposed object' error is fixed while working with windows
  • NullReferenceException error is fixed while closing the document
  • NullReferenceException error is fixed while getting data in Data Editor and scrolling simultaneously
  • Unicode data output in LOB editor is fixed
  • Problem with changing connection string was fixed