dbForge Query Builder for MySQL Revision History

2026.1.77 25-Jun-2026

User-reported bug fixes

Resolved clipboard data corruption when copying HTML data with duplicate column names
Fixed an issue that caused a parsing error in stored procedures

2026.1.39 15-May-2026

User-reported bug fixes

Several minor bugs are fixed

2026.1.31 11-May-2026

AI Assistant

Improved AI Assistant by adding support for database index metadata

Text Editor

Added the Enclose identifiers in quotes feature to the SQL Editor
Added index name suggestions in code completion
Added indexed column icons in Quick Info
Added the ability to pin document tabs

Improvements

Added the ability to restore document tab order

User-reported bug fixes

Fixed the behavior of the "SQL Look In" option in the Find and Replace control
Fixed an error in the data editor that occurred when executing a modified query before the previous query had finished fetching data
Fixed an issue in the Procedure Editor when editing procedures with invalid syntax
Added parsing support for the sys_refcursor pseudo-type
Improved saving of window layouts and restoration of window positions after restarting the Studio
Updated the installation wizard to not display the "Successful Install" page during dbForge product updates

2025.3.149 25-Mar-26

User-reported bug fixes

Fixed an issue that caused long response times from MySQL and MariaDB servers when executing certain queries that referenced non-existent objects

2025.3.107 12-Feb-26

User-reported bug fixes

Several minor bugs are fixed

2025.3.93 29-Jan-26

User-reported bug fixes

Improved support for SET TRANSACTION syntax on MySQL and MariaDB servers for the Text Editor

2025.3.61 24-Dec-25

Connectivity

Added support for AWS RDS Proxy with caching_sha2_password authentication
Added support for MySQL 9.5
Added support for MariaDB 12.2

Text Editor Improvements

Added scroll bar annotations
Added an option to automatically surround selections
Added support for SHOW BINARY LOG STATUS
Added support for CREATE OR ALTER USER, SET PASSWORD, and CREATE ROLE
Added camelCase formatting for identifiers

User-reported bug fixes

Fixed an issue with connecting to MySQL servers over SSH
Implemented a text preview for CLOB data types instead of an icon
Fixed an issue where floating-point values lost precision when copied to Excel

2025.2.138 20-Nov-25

User-reported bug fixes

Several minor bugs are fixed

2025.2.109 31-Oct-25

User-reported bug fixes

Resolved an issue with displaying the tooltip for a document bookmark, where the tooltip window overlapped the document bookmark

2025.2.91 23-Oct-25

User-reported bug fixes

Fixed an issue with text selection on double-click in SQL Document

2025.2.37 23-Sep-25

AI Assistant

Introduced automatic error submission from the Error List to AI chat for detailed explanations and suggested fixes
Added a Web Search option in the AI Assistant chat, allowing searches across Devart documentation, website, and blog

Connectivity

Added support for MySQL 9.4
Added support for MariaDB 12

Improvements

Improved encryption capabilities
Added tooltips to the SQL document tab, showing connection and database names, document owner, full file path, and server version
Introduced the ability to customize the position where new document tabs open
Added Alt+Up and Alt+Down shortcuts to move selected lines up or down in the SQL document
Added the Ctrl+Shift+A shortcut to select the entire statement in the SQL document, including all related keywords, operators, and values
Added options to qualify column names with table or alias names

User-reported bug fixes

Fixed an issue with query diagram rendering
Fixed an issue with aliases

2025.1.230 21-Aug-25

User-reported bug fixes

Expanded code completion suggestions for the UPDATE SET clause to include columns from the updated table

2025.1.186 21-Jul-25

User-reported bug fixes

Fixed an issue with the Clear Filter functionality in server mode
Fixed an issue with the automatic display of Data Editor: when the Activate Data Editor after query execution option is enabled, Data Editor now opens automatically after a query runs, even if no data is returned

2025.1.134 23-Jun-25

User-reported bug fixes

Several minor user-reported bugs are fixed

2025.1.124 16-Jun-25

AI Assistant is added

Context-aware query generation
Conversion of natural language to SQL
Query optimization
SQL explanations
SQL troubleshooting
Error analysis and recommendations
AI chat
Integration with the dbForge tools

Improvements

Updated color palettes for the Light and Dark skins
Refined font rendering and the coloring of syntax errors
Added Brief View to the Start Page to switch between displaying full paths to recent files and a more compact list

User-reported bug fixes

Several minor user-reported bugs are fixed

10.1.165 09-Apr-25

User-reported and internal bug fixes

Several user reported minor bugs are fixed

10.1.158 28-Mar-25

Improvements

Added connectivity support for MySQL 9.2
Added support for modern encryption, hashing, and key exchange algorithms for SSH connections

User-reported and internal bug fixes

Fixed a 'Commands out of sync' error in Data Editor
Improved the forming of column names in SELECT queries

10.1.24 25-Sep-24

Improvements

Introduced connectivity support for MySQL 9.0
Added support for the rds-ca-rsa2048-g1 SSL/TLS certificate for connecting to MariaDB servers on Amazon Web Services (AWS)
Added support for HeatWave-specific commands in Code Completion and Syntax Check
Added connectivity support for Kamatera MySQL Cloud
Redesigned the Query History interface
Added the ability to copy data to the clipboard in the CSV format from Data Editor
Added the ability to copy data to the clipboard in the Excel-compatible format from Data Editor

User-reported and internal bug fixes

Resolved an issue with data sorting in Data Editor
Several user reported minor bugs are fixed

10.0.225 28-Mar-24

User-reported and internal bug fixes

Fixed errors that occurred during query editing (#149483)
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

10.0.150 17-Jan-24

Improvement

Added connectivity support for MariaDB 11.4

User-reported and internal bug fixes

Fixed an issue with the launch of the object editor in Query Builder (#140767)

10.0.60 20-Nov-23

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

10.0.46 03-Nov-23

New features

Implemented support for the JSON_TABLE() table function in MariaDB
Improved commenting out selections inside a line of code
Added full support for complex VALUE statements
The CAST() function now supports the AT TIME ZONE operator
Non-aggregated columns are now suggested for GROUP BY statements
The Reset Suggestions Cache and Refresh Local Cache buttons on the toolbar have been replaced with a single button Reset Suggestions

Connectivity

Introduced support for Transport Layer Security 1.3
Added support for MySQL v8.2

User-reported and internal bug fixes

Resolved an issue with invoking the popup menu on macOS
Improved the performance of Query Builder
Improved data display for the JSON_OBJECT function
Resolved an issue that occurred when establishing an SSH connection to the server
Resolved an issue with updating data cells for TIMESTAMP-type columns in Data Editor
Fixed an error that occurred when editing data in Data Editor
Fixed an error that occurred when editing INSERT .. VALUES expressions in Query Builder
Improved the visualization of table relationships in Query Builder involving functions in JOIN conditions

5.2.105 14-Sep-23

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

5.2.84 17-Aug-23

Connectivity

Added support for MySQL v8.1

User-reported bug fixes

Fixed an internal application error in SQL Editor

5.2.27 18-May-23

User-reported bug fixes

Several user reported minor bugs are fixed

5.2.4 19-Apr-23

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 VALUES ... ORDER BY ... LIMIT statements
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 (#99763)
Fixed the Query Builder error that could occur when using the IN operator (#104386, #113252, #117902, #117903, #92392)
Resolved an issue with excessive memory consumption by dbForge products (#96496)

5.1.15 30-Aug-22

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

5.1.6 12-Aug-22

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 (#89333, #89332, #90070, #91692, #91733, #91736, #91751, #92339, #92536, #93315, #94205, #88217, #88554, #88315)
Fixed an issue that occurred when opening an invalid .rdb file (#78863)
Fixed an issue with switching to the standby mode when moving columns in the query editor

5.0.160 20-May-22

Improvements

Improved CrossOver compatibility

5.0.154 12-May-22

User-reported bug fixes

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

5.0.78 09-Dec-21

User-reported bug fixes

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

5.0.72 01-Dec-21

User-reported bug fixes

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

5.0.31 20-Oct-21

User-reported bug fixes

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

5.0.19 25-Aug-21

New features and improvements

Data Reports
Master-Detail Browser
Pivot Tables

4.5.506 8-Jul-21

User-reported bug fixes

Query Builder forces lower case table names

4.5.449 22-Apr-21

User-reported bug fixes

Issue related to Drag & Drop of nodes in Database Explorer (#53086, #53076)

4.5.396 02-Feb-21

User-reported bug fixes

Minor user reported bugs are fixed

4.5.380 25-Nov-20

Improvements

Work of the application when connecting via SSL is improved

4.5.355 10-Oct-20

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

4.5.317 17-Aug-20

User-reported bug fixes

Minor user reported bugs are fixed

4.5.283 07-Jul-20

User-reported bug fixes

Minor user reported bugs are fixed

4.5.254 21-May-20

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

4.4.38 07-May-19

User-reported bug fixes

Issue with incorrect display of page count is fixed (T272555)
Minor user reported bugs are fixed

4.4.22 15-Jan-19

Database Connectivity

Support for MariaDB 10.4

User-reported bug fixes

"PDF view" mode of Data Viewer issue is fixed (MYS-2038)
"Spatial view" mode of Data Viewer issue is fixed (MYS-2000)

4.3.36 20-Nov-18

User-reported bug fixes

Issues with connection to MySQL Server are fixed

4.3.36 17-Oct-18

User-reported bug fixes

Other user reported bugs are fixed

4.3.26 14-Aug-18

User-reported bug fixes

Issue with product freeze is fixed
Issue with NRE is fixed
Issues with lost connection are fixed
Issues with TLS 1.2 connection are fixed

4.3.16 06-Jul-18

User-reported bug fixes

Loading file or assembly issue is fixed (T260447)

4.3.12 27-Jun-18

Database Connectivity

Support for MySQL Server 8.0
Support for MariaDB 10.3
Support for Tencent Cloud

4.2.34 12-Apr-18

Database Connectivity

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

Issues 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)

4.1.10 17-Nov-16

New features and improvements

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
Styled icons are used by default
Other minor fixes and improvements

4.0.27 19-Sep-16

New features and improvements

Data type information to the column header in Data Grid added
Data Grid now supports Generate Script As feature
Generate Script As now available for multiple objects in Database Explorer
Latest MySQL builds are supported

4.0.19 29-Feb-16

User-reported bug fixes

Issue with connecting to MySQL 5.7 instance on Unix systems when lower_case_table_names set to 0 is fixed (T162055, T161962)

4.0.17 26-Feb-16

New features and improvements

Support for MySQL 5.7
Support Percona PAM authentication
Support for the Amazon Aurora connection

User-reported bug fixes

Issue with saving 'Look In' option in Find and Replace window is fixed (T122242)
Issue with connection via SSH is fixed (T133379, T133780, T135203, T144325, T156321, T157597)
Issue with text replacement using regular expression is fixed
'Current Document' is selected by default in Find and Replace window
Issue with query profiling is fixed
Exception while executing a query is fixed (T148670)
Issues with connection to MySQL 5.7.x is fixed (T152158, T152648, T152709, T153183, T153489, T154109, T158606, T159165, T159384, T159417, T159468, T159601)
COLUMN_GET expressions are recognized correctly (T152603)
Viewing functions in GROUP BY are correct (T155234)
Default path for log is changed

3.3.30 02-Feb-15

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

3.2.18 04-Aug-14

New features and improvements

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

3.1.12 30-Jan-14

Database Connectivity

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 Wizard

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)

3.0.105 26-Nov-13

User-reported bug fixes

ArgumentException while sorting data in the Data Editor is fixed (T88214, T88234, T89919)
Wrong behavior 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)

3.0.94 22-Oct-13

User-reported bug fixes

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

3.0.79 25-Sep-13

User-reported bug fixes

NullReferenceException on sorting data in the Data Editor is fixed (T84292, T84287)
NullReferenceException on using invalid file path in the Export wizard (T84136)
NullReferenceException on editing a condition in the HAVING clause is fixed (T83306)
An error while inserting data in a table from the Data Editor is fixed (T83957)
NullReferenceException on editing code in the SQL editor is fixed (T83895)
Receiving of metadata of default database is off (while the "Enable code completion" is disabled) (T83160)
An error related to SSH connection is fixed (T75300)

3.0.69 23-Aug-13

User-reported bug fixes

The issue with the replication is fixed (T24637)
InvalidOperationException on closing the application with opened documents is fixed (T74609)
The problem with setting the current date in a cell of Data Editor is fixed (T74754)
NullReferenceException on choosing an item in the Code Completion window is fixed (T75098, T83498)
NullReferenceException on editing an expression in Query Builder is fixed (T75448)
InvalidOperationException on describing Code Completion members is fixed (75692)
The problem with indentation on formatting a script with the CASE WHEN clauses is fixed (R25618)
NullReferenceException on invoking the Save All command is fixed (T76032)
ArgumentException on executing a script in SQL document is fixed (R25155)
The problem with changing a case of variables in the DECLARE clause on formatting a statement is fixed (R25322)

3.0.61 31-Jul-13

User-reported bug fixes

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 behavior of LOB Editor with unsaved data is fixed (R22597)
Error on line numbering while grouping data in Data Editor is fixed (R23179)

3.0.45 27-Jun-13

User-reported bug fixes

Issue 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)
Issue with resetting of toolbar's customization is fixed (T70463)
Issue with the INTERNAL keyword in Code Completion is fixed (R22954)
Issue with execution of the DELIMITER statement is fixed (T72486)

3.0.37 23-May-13

User-reported bug fixes

Invalid 'Reset Toolbar Layout' functionality is fixed (R21587)
Function GREATEST is added to autocompletion list (R21960)
ArgumentOutOfRangeException on canceling the formatting of a query is fixed (R21925)
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 behavior on a valid query in Query Builder is fixed (T70645)

3.0.23 22-Apr-13

Query builder with support for 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)

User-reported bug fixes

NullReferenceException on creating new connection is fixed (T62954)
Incorrect showing of conditions in query builder document is fixed (T39012)
ArgumentNullException on designing a SQL query is fixed (T31255)
The problem with retrieving data from a table with datetime field is fixed (T60213)

2.5.42 23-Jul-12

User-reported bug fixes

Issue with missing functions in query designer is fixed (R10934)
Error during designing query is fixed (R8955)
Error "Invalid argument" when designing query is fixed (R10169)

2.5.27 15-June-12

User-reported bug fixes

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)

2.5.20 18-May-12

User-reported bug fixes

Issue with the 'Execute Current Statement' command when the caret is placed after ';' is fixed (T39448)
Error report with a table in the Query Builder is fixed (T39207)
Issue with HTTP-tunneling is fixed (T38708)
Issue with unexpected focused row in the Data Editor is fixed (T38675)

2.5.13 13-Jan-12

User-reported bug fixes

InvalidCastException on paste data into the Data editor is fixed (R2050)
ArgumentOutOfRangeException on searching in Data Editor is fixed (T31142)
Bad performance on server side sorting in Data Editor is fixed (T31581, T31511)
NullReferenceException on switching to the Data document view in the SQL document is fixed (R2311)
ArgumentException on editing of several records in Data Editor is fixed (T31478)
The problem with windows layout on x64 operating systems is fixed (T31293)
ObjectDisposedException on executing a script in a SQL document is fixed (T31081)
UriFormatException on saving an SQL file on a mapped network drive is fixed (T30092)
NullReferenceException on showing data in Data Editor is fixed (T31832)
InvalidCastException on pasting LONGBLOB data in Data Editor is fixed (R3507)
InvalidOperationException on deleting a record in Data Editor is fixed (T31439)
The problem with changing database for a document is fixed (R3338)
The problem with showing the Product Update dialog behind of the main form is fixed (T33358)
The problem with connecting to MySQL server using SSL tunnel is fixed (T32811)
OutOfMemoryException on changing a page in Data Editor is fixed (R3508)
The wrong behavior of the Continue button in the error message appeared during script execution is fixed (R3691)
NullReferenceException on pressing the Enter key in Data Editor after inserting a new record is fixed (T32393)
The problem with server-side sorting and filtering in Data Editor is fixed (R4336)
Issue with a table locked by a server in Data Editor is resolved (T32566, T31856)
NullReferenceException on editing data in Data Editor is fixed (T32173, T32138, T32104)
NullReferenceException on opening a SQL file by drag'n'drop operation is fixed (T32362)
ArgumentException on editing data in Data Editor is fixed (T33826)
Incorrect editing of dates in Data Editor is fixed (T34205)
NullReferenceException on parsing text in SQL document is fixed (T33582)
DBConcurrencyException on updating records in Data Editor is fixed (T33830)
Issue with restoring closed tool windows is fixed (R5019)
FormatException on showing data after executing a query is fixed (T33985, T33788, T34883)
Issue with showing the Product update dialog box is fixed (T33358)
Few problems with showing the foreign key lookup editor in Data Editor are fixed (R5691, R5690)
Inability of editing data on MySQL 4.1.22 is fixed (R6228)
Incorrect behavior with changing color of punctuation in code editor is fixed (T33640)
Incorrect determination of boundaries for the current statement on executing a query in a SQL document is fixed (R5449)
NullReferenceException on filtering data in Data Editor is fixed (T35232, T34698)
ArgumentOutOfRangeException on switching from the Text view to the Design view in a SQL document is fixed (T32360)
Refresh command is added for the Query Builder document to refresh objects on the diagram (T32015)
Buttons on the Diagram and Layout toolbars are enabled now (T34437)
NullReferenceException on designing a query in Query Builder is fixed (T33930)
NullReferenceException on generating text with the last_insert_id function in Query Builder is fixed (R4203, R5243)
Incorrect renaming of alias on wrapping query to subquery in Query Builder is fixed (T34205)
NullReferenceException on wrapping a query to a subquery in Query Builder is fixed (R5766)
NullReferenceException on refreshing connection with an opened SQL document is fixed (R5536)
ArgumentOutOfRangeException on wrapping a query to a subquery in Query Builder is fixed (R644)

2.5.11 23-Jun-11

User-reported bug fixes

NullReferenceException on refreshing data in Data Editor is fixed (T29562)
ArgumentOutOfRangeException on loading a SQL file is fixed (T29427)
NullReferenceException on fetching data after designing a query is fixed (T29277)
Encoding utf8mb4 is now supported (R890)
The Cancel button is now the default one in dialog about uncommitted changes in Data Editor (R870)
Annoying notifications in Data Editor are fixed (T28861)
Issue with exporting decimal data is fixed (R860)
NullReferenceException on adding/removing select list items in table wrapped to subquery is fixed (T29303)

2.5.9 19-May-11

User-reported bug fixes

ObjectDisposedException on working with autohidden tool windows is fixed (T28329)
IndexOutOfRangeException on minimizing and restoring the application is fixed (T28344)
Lost connection on executing SLEEP function in SELECT statements is fixed (S12783291)
Application hanging on working with unresponsible server is fixed (S12782055)
ExternalException on operating clipboard operation in LOB Editor is fixed (T28373)
Incorrect object describing with ANSI server mode is fixed (T28591)
NullReferenceException on showing data in Data Editor is fixed (T28478, T28837)
The problem with bad handshake on connecting to a server is fixed (T28747)
Application hanging on opening a big SQL file with enormous count of JOIN clauses is fixed (T28716)
Incorrect detection of default table engine on some MySQL server versions is fixed (R124)
Extra spaces on formatting SQL statements are fixed (T28282)
Issues with formatting CASE clauses are fixed (S12776963)
Automatic diagram layout on its opening is fixed (S12828929)
FormatException on exporting data to CSV with custom DATE delimiters is fixed (S13040337)
The problem with exporting data from DECIMAL columns is fixed (T28367)
The problem with showing Code Completion window for SUM() function is fixed (S12744935)
NotImplementedException on refreshing triggers collection in Database Explorer is fixed (T28363)
The problem with connecting to MySQL server through SSL tunnel is fixed (S12831167)
The problem with connecting to embedded MySQL server is fixed (S12831167)

2.5.8 04-May-11

Database Connectivity

Support for MySQL Server 5.5

Enhanced Data Editor

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.
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

2.00.5 29-Jul-10

New features and improvements

Optimized usability 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 displaying datetime values in Data Editor
T14852 Incorrect display of the 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 Issues with query profiling on MySQL 4.1.x

1.50.4 03-Mar-10

New features and improvements

Improved work with Data Editor
Data export updates
A mechanism to renew a server connection after its break was implemented
Product installation was redesigned to allow product updating without unistalling a previous version
Customizable product updates check, downloading and installation

1.10.361 16-Sep-09

New features and improvements

HTTP tunneling script was added to the installation
Issue with editing data in Data Editor with enabled paginal mode was fixed
Errors in documentation are fixed

1.10.355 09-Sep-09

New features and improvements

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)
Issues 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
Issue with regional value of decimal separator during data copy from Data Editor was fixed (T4656)

1.00.227 26-Feb-09

User-reported bug fixes

Issue with retrieving data from Database Explorer was fixed (38089)

1.00.225 12-Feb-09

User-reported bug fixes

The 'Cannot access a disposed object' error is fixed while working with windows (37379)
NullReferenceException error is fixed while closing the document (35195).
NullReferenceException error is fixed while getting data in Data Editor and scrolling simultaneously (36252).
Unicode data output in LOB editor is fixed
Issue with changing connection string was fixed (36547)

1.00.192 06-Nov-08

New features and improvements

First release of dbForge Query Builder for MySQL.