Decrease memory requirement for compressing files in installer, by using ZIP instead of LZMA2.

Do not export data from MRG_MYISAM tables. See http://www.heidisql.com/forum.php?t=9842

Try to fix dbtree focus/refresh access violation. Fixes issue #2665.

Find erroneous SQL also when getting a "Duplicate entry 'xyz'" error. Fixes issue #2698.

Fix non-nil values for mysql_ssl_set(), broken in r4031.

Introduce a checkbox for explicit activation of SSL. Any combination is passed to the server now, while SHOW STATUS LIKE 'ssl_cipher' is used to find out if the connection is indeed SSL secured. Pops up a warning when SSL settings were ignored by the server. Fixes issue #2672.

Show up new session after "Save as" action. Fixes issue #2686.

Autofix TYPE|ENGINE clause when exporting to server. Fixes issue #2688.

Do not use TOP 1 in DELETE queries on MS SQL servers. Fixes issue #2690.

Use different TOP syntax for UPDATE + SELECT queries in MS SQL. Fixes issue #2682.

Avoid accessing non existing items in ADO error pool. Fixes issue #2684.

Add version of libmysql.dll to error message when it's outdated.

Fix repeated glitch in previous build. Sigh...

Issue #2550: Do not report unknown uptime if server was started before client machine. Broken in r4020.

Use master.dbo.sysprocesses finally to get it running on all MS SQL versions

Show functions and triggers in MS SQL. See http://www.heidisql.com/forum.php?t=9671

Issue #2550: Use sys.sysprocesses instead of dbo.sysprocesses so this does not fail on old servers. Querying sys.sysprocesses may return an empty result for spid 1, so there is a default of -1 for FServerStarted now, which then reports "(unknown)" in the status bar.

Fix enabled controls which should be disabled when no SSL option selected.

Fix mixed up GRANT privilege in user manager, caused by errors and high complexity in regular expression. See issue #2671. Revert modification in SynRegExpr.pas again, now that we have only about 10 parentheses left.

Support GRANT .. REQUIRE syntax in user manager with a new "SSL options" tab. Fixes issue #2671.

Code cosmetic: Remove unused FColumns list, and set FConnection once instead of accessing outside instance.

Enable OK button when user types custom object name. Fixes issue #2669.

Fix empty tabSettings when creating very first session. Do less what flickers in ValidateControls, move pagecontrol related stuff in ListSessions.FocusChanged. Also, call FocusChanged event explicitly in SelectNode() when focus did not effectively change.

Fix unfocused active control after modifications. Introduces a new bug unfortunately, when creating the very first session.

Make session list and details pagecontrol custom resizable via splitter. Also, do not auto-adjust column width in session list, which has funny effects in some cases.

Remove LoginPrompt() function, create and use TfrmLogin instance like a normal form. That way, mysql_authentication_dialog_ask() can hide the labels and the irrelevant edit box.

Fix 3 compiler warnings

Quote password in plink command line, so it can contain spaces. Fixes issue #2667.

Follow up to r4002 and issue #2656: Set focus to textbox only if it's already shown, to avoid "Cannot focus a hidden or disabled control".

Extend hints on how to install MDAC on Wine. See issue #2660, comment #5.

Fall back from number to string comparison in CompareAnyNode, so equal numbers with word characters in them are sorted alphabetically. Fixes issue #2659.

MS SQL 2000 compatibility for SELECT TOP... Fixes issue #2662

Add context menu item in data grid for inserting a column's default value. Fixes issue #2654.

In TMainform.SetupSynEditors, check if loop editor variable really exists - which is not the case for at least one user. Fixes issue #2651.

Focus textbox when user clicks "Custom" in default-value selector. Fixes issue #2656.

Allow "DELIMITER xyz" not followed by some whitespace. Fixes issue #2655.

Use downward compatible queries for fetching table names on MS SQL 2000. Fixes issue #2661.

Follow up to previous commit: Catch more exceptions when creating the ADO handle. Most probably there are more I know of.

Creating an ADO handle throws exception if MDAC is missing, especially on Wine. Create that handle in TAdoDBConnection.SetActive, not in TAdoDBConnection.Create, and turn the exception into an EDatabaseError, so the caller gets a handled error. Additionally, display a possible solution in that error popup, which I found on http://forum.winehq.org/viewtopic.php?p=30653 . Fixes issue #2660.

Add some taskdialog style to login form.

Remove unused unit includes

Try to prevent event cycles to some DBtree code. Fixes issue #2645.

Remove unused variables

Revert r3979, move imported mysql_* functions from TDBConnection to a global var scope. Fixes issue #2647. Also, move MySQL related structures out of dbconnection.pas into mysql_structures.pas and const.inc.

Add basic support for pluggable authentication:
* Implement and export callback function "mysql_authentication_dialog_ask"
* Update libmysql.dll to the one from MariaDB 5.2.10
* Copy dialog.dll from MariaDB into plugins subfolder
* Modify installer so it creates the plugins folder and its dll files
* Fixes issue #2658

Fix rare errors when passing a broken list of databases via session manager. See http://www.heidisql.com/forum.php?t=9550

Do not access char at non existent position in a string. Introduces CharAtPos function. Fixes issue #2649.

Fix broken sorting logic for positive small numbers, broken in r3987.

Do not store and restore old value of FOREIGN_KEY_CHECKS variable, just set it to 0 when beginning to export, and to 1 again at the end. Should prevent from running into "'foreign_key_checks' can't be set to the value of 'NULL'" error when disconnects happen within export process. Fixes issue #2500.

Use numeric sorting approach instead of string comparison for negative numbers. Fixes issue #2519.

Add support for SQL Server 2008 when fetching database names. Fixes issue #2550.

Refreshing datagrid result while connection is cut triggers SelectedTableColumns to reset implicitly in ConnectionReady > DBTreeFocusChanged > ParseSelectedTableStructure. Add an explicit Connection.Ping(true) before firing any query in DatagridBeforePaint, and merge code from ParseSelectedTableStructure into DBTreeFocusChanges. Fixes issue #2644.

Fix non logged errors, caused by late non executed code in a try block. Fixes issue #2646.

Use -- for line comments, not #, to support MS SQL also in export files.

Fix wrong offset when stripping trailing comma for MS SQL table structure export. See http://www.heidisql.com/forum.php?t=9449

Ensure there are no open result sets when destroying open connections. Fixes an access violation when closing Heidi, caused by accessing Connection.mysql_somefunction() in TMySQLQuery.Destroy. See http://www.heidisql.com/forum.php?t=9508

Late commit for 6.0 installer image

Encapsulate mysql_* functions as class methods of TDBConnection, and give each instance of TDBConnection its own libmysql handle. This way, we can release the lib handle after each disconnect. Also, this opens up some new possibilities:
* use different libmysql.dll versions per connection
* overload mysql_* functions

Auto build installer by InnoSetup command line

Use APPNAME constant from const.inc for SetVersion, and prefer "HeidiSQL 6.0.0.1234 32 Bit" over "A lightweight MySQL client" for the EXE description.

Do not modify SQL_MODE when exporting, just do that temporarily before creating triggers. Avoids running into errors when e.g. ANSI_QUOTES is turned on. Fixes issue #2619.

Place "Preferences" item in system menu of session manager, so users are able to configure stuff without the need to connect first.

Fix unresponsive updownPort + editPort when modifying its value. Broken in r3972.

Ignore different column in ListSessions.FocusChanged event, so modifications do not get discarded silently when user clicks the "wrong" area.

Add support for integrated Windows authentication on SQL Server. See http://www.heidisql.com/forum.php?t=8856

Adjust regular expression in ParseViewStructure so it gracefully matches broken code from SHOW CREATE VIEW. Fixes issue #2563 .

Remember column widths in data grid before clearing header. Fixes issue #2511.

Store selected database object and its properties in a copied TDBObject, instead of referencing an item from TDBConnection.FDatabases[x]. Not sure if that's a good idea as there may be logic somewhere which now updates the temporary copy, not the reference. But at least this fixes issue #2579.

Try again a fix for SynEdit exceptions, similar to what I've already tried in r3922. The approach was right, only there was Mainform.SetupSyneditors accessing all TSynMemos in a thread when reconnecting.
* fixes issue #2605
* should also fix issue #2545
* reverts r3924 and r3925 (SynEdit modifications which should not be required any longer now that logging is postponed for the mainthread)

Add new quick filter menu item "Column IN (...)". Fixes issue #2606

Provide option "tabs to spaces" in preferences dialog. For space reasons, move highlighter options to new tab "Highlighter". Also, unify padding on tab sheets, and move "Ask for saving files" option to "SQL" tab.

Fix memory leak

Add "truncate table" feature to text import dialog. See http://www.heidisql.com/forum.php?t=9367

Add support for Windows 7 task button progress. Unify all callers of ProgressBarStatus in a set of 5 functions in main unit instead of helpers, as this is where the progress bar is placed and also we need the handle of the main window.

Unformat local formatted floats in WHERE clause for grid updates. Probably fixes issue #2558.

Export VIEWs with alternative version of SELECT code. Follow up to r3941, see issue #2546.

Populate database pulldown with dbs from current connection in export window. Fixes issue #2572.

Make regex for detection of VIEW name more stable against international characters. Fixes issue #2578.

Confirm overwriting grid export output file. Fixes issue #2596.

Update VirtualTree component to r320

Fix non-used database in reconnect, caused by too early DoAfterConnect which triggers OnConnected event, which again triggers DBTreeFocusChanged which triggers grid updates. Fixes issue #2573

Merge main menu items "Import" and "Export" into "Tools" menu.

Take hidden primary key columns into account when tbtnDataColumns gets its ImageIndex.

Place some reasonable messages on status bar while deleting (many) grid rows. Fixes issue #2576.

Add support for routine parameters in completion proposal of stored routine editor. Fixes issue #2555.

Sort font names alphabetically in SQL font selector. Fixes issue #2569.

Include sample editor on preferences dialog in SetupSynEditors, so settings get applied when preferences dialog opens. Fixes issue #2568

Revert r3938, and add backticks around identifiers again, so ParseTableStructure can detect column for "copy columns" feature. Fixes issue #2540.

Delete node so treeIndexes.Repaint does not expect old children in moved up node. Todo: Bind FKeys to tree nodes if that's possible with deleted keys. Fixes issue #2557.

Deactivate toAutoScrollOnExpand in object selector, so 1st level nodes do not get out of sight when un/checking one of them.

TMySQLConnection.GetThreadId requires the connection to be active. Fixes issue #2561.

Do not replace two single quotes which are not used to present one escaped single quote. Fixes issue #2560.

Primary key columns can be hidden in data grid. Pressing home key has to use first visible column instead of column 0. Fixes issue #2559.

Fix broken link to plink.exe, prefer a link to the download page over the .exe, as that link is obviously randomly mirrored, while there are disappearing mirrors over time.

Process escaped single quote in TDBConnection.UnescapeString. Mentioned in issue #2546.

Attempt to preserver original VIEW code, by selecting text from the server's .frm file. Fixes issue #2546.

Issue #1289: Add some basic code to the "analyze" button, which detects missing tables in target database.

Catch more types of potential exceptions in image preview box. See http://www.heidisql.com/forum.php?t=8980

Remove redundant backticks in table editors CREATE and ALTER code. See http://www.heidisql.com/forum.php?t=9056

* disable controls as long as no session is selected.
* check all option check boxes by default