HeidiSQL 11.3.0.6370

Bugfix: Crash in foreign key dropdown editor
Bugfix: Crash when killing processes on very long running servers
Bugfix: SQL error when accessing UUID and JSON columns in PostgreSQL via SUBSTR
Bugfix: MSSQL: Prefer "schema.table" quoting over "schema"."table" when renaming a table
Bugfix: Fix column type converted to locale string format by String.ToUpper in TDBConnection.GetCreateCode - prefer String.ToUpperInvariant instead, to avoid funny characters in data types
Bugfix: MSSQL: Do not pass "Database=xyz" to connection string if database(s) setting contains more than one database
Bugfix: MSSQL: Try to use some universal date/time format, by injecting a "T" between the date and the time portion
Bugfix: Fix wrong detection of BIT default values
Bugfix: Use "SET search_path TO db" instead of "SET SCHEMA db" for changing a database in PostgreSQL, for downward compatibility reasons
Bugfix: Prepend 'E' to escaped PostgreSQL strings
Bugfix: Use updated URL for MariaDB Explain analyzer, and encode semicolon in URL parameter
Bugfix: User manager: Select "authentication_string" instead of "password" column on MySQL 5.7.6+
Bugfix: Fix various selection bugs in column selection panel
Bugfix: Fix SQL error in "Copy table" dialog, in PostgreSQL mode. Use lowercase table and column names in IS.TABLES, so PG can find them
Bugfix: CSV import: Disable features supported in MySQL only, if active connection is not MySQL
Bugfix: PostgreSQL: Always keep public schema in search path, so one can use procedures from it without prefixing
Bugfix: Text import: Use very last value from last row, even if it's not followed by a field or line terminator
Bugfix: PostgreSQL: Fix wrong ALTER TABLE query for modifying table comment
Bugfix: Update VirtualTree component code to v6.1.0, to fix graphical issues in Windows 8 + 10
Enhancement: Show error when SSH port is already in use
Enhancement: Add support for PostgreSQL's data types uuid, cidr, inet and macaddr
Enhancement: Strip folder path from various file settings, including plink.exe location, if it's the application directory
Enhancement: Try higher ports, up to the 20 next ones, as SSH local port, when the configured one is in use
Enhancement: Display session name in caption of all message dialogs
Enhancement: Add a custom icon for confirmation dialogs, with a question mark on it, so we don't have to use the "i" icon.
Enhancement: Use server time for data grid > "Insert value" menu items
Enhancement: Show line breaks other than Windows style as normal line breaks in text editor
New feature: Introduce option for setting the line break style in text cells without breaks
New feature: Session manager: Add support for SSL cipher, and add various texthints

New feature: Add support for JSON grid export
New feature: Add support for Markdown Here grid export
New feature: Support new command line parameter "n", or "nettype", which takes an integer, representing the protocol number (0=mysql tcpip, ...).
New feature: Add support for connecting to Microsoft Azure Servers
New feature: Add edit box + updown buttons for limiting the size of exported INSERT queries in bytes.
New feature: Display creation time, last alter time, comment and start time of scheduled events.
New feature: Online help document available. Various "Help" buttons in relevant dialogs link to this document.
Bugfix: Dropping functions and procedures on PostgreSQL now with required parameters list
Bugfix: Size bars in "Database" tab on PostgreSQL now with correct values
Bugfix: Loading full grid data on PostgreSQL did not work on text columns
Bugfix: Fix microseconds in MSSQL date/time data types, hidden in data and query grids.
Bugfix: Use ISO 8601 date/time format on MSSQL
Bugfix: PostgreSQL: Fix wrong order of columns shown in indexes, and show normal indexes also
Bugfix: Do not uppercase ENUM values in procedure parameter datatypes
Bugfix: Fix crash when right-clicking a database, following by a click on "Drop"
Bugfix: Version conditional disabling for "Create new" menu items in MySQL mode only
Bugfix: TEXT data type has a maximum length of 65k for MySQL only. Introduce other values for MSSQL and PostgreSQL.
Bugfix: Fix memory leak in TfrmTableTools.SaveSettings
Bugfix: Let longer data type matches win over shorter ones, especially important on PostgreSQL
Bugfix: Make TPGConnection.FetchDbObjects compatible to pre-9.0 servers on PostgreSQL
Bugfix: Fix non working addition of new columns in MySQL
Bugfix: Detect xid type (oid 28) as integer.
Bugfix: Detect character type (oid 1042) as char, not varchar.
Bugfix: Detect aclitem[] type (oid 1034) as unknown, not text.
Bugfix: Fix detection of PostgreSQL data type INTERVAL as VARCHAR.
Enhancement: Automatic storing of settings in portable mode
Enhancement: Optimize query for getting total row count on PostgreSQL
Enhancement: Add support for microsecond precision of MSSQL date/time types in table editor, show these in "Length/Set" column
Enhancement: Add a help button to the quite non-intuitive controls on the export dialog
Enhancement: Add support for JSON data type on PostgreSQL
Enhancement: Add support for HIERARCHYID data type on MSSQL
Enhancement: Increase various default values for window dimensions, for reasonable look and feel for new users
Enhancement: Add "Rename" context menu item in session tree.
Enhancement: Use local number formatting in grids by default
Enhancement: Use transparent background for NULL cells by default
Enhancement: Support columns with a string literal as default value plus an ON UPDATE CURRENT_TIMESTAMP clause.
Enhancement: Increase compatibility when getting procedure body on MSSQL.
Enhancement: Remove duplicates from recent file list pulldown.
Enhancement: Translate connected/disconnected words in status bar
Enhancement: Set focus on filter box when SQL help dialog opens.
Enhancement: Update gettext unit
Enhancement: Make search/replace dialog resizable
Enhancement: Activate "Clear filter" button after applying text to filter memo.
Enhancement: Gracefully remove superfluous WHERE keyword from data grid filter, so other places like the previously modified "More filters" menu do not add a second WHERE.
Enhancement: Use existing data grid WHERE filter to filter values from quick filter > "More values".
Enhancement: Remove outdated details in readme file, and redirect to official help page instead.
Enhancement: Detect all array style types on PostgreSQL as unknown type, e.g. TEXT[].
Enhancement: Pass column or argument name to NativeToNamedColumnType(), as a hint for the user.
Enhancement: Support quoted datatypes in TDBConnection.GetDatatypeByName, coming from TDBConnection.ParseTableStructure

This is a maintenance release, which basically reintroduces support for legacy password encryption (pre-4.1 hash format).

Most important thing this time is the experimental support for connecting to PostgreSQL servers.
Also noticable:
Completely rewritten interface to plink.exe for SSH tunnel connections. Now supports dialogs which ask for trusting unknown host keys.
Bind parameters in SQL queries. When your SQL query contains one or more ":myparam:" occurences, the right hand box offers to set a value for these parameters. Adrien, a former contributor from France, has developed this new feature.
The "Find text on server" dialog now also works on MSSQL and PostgreSQL tables.
The table editor now supports partitions, in a new read-only tab. That way, partitions a) can be seen by the user and b) get included in the CREATE TABLE code tab.
Filter in data grid column selection
Disable SQL hints on result tabs: Some users complained about the potentially huge tooltips on the tabs of a SQL query result. These quickly hide important parts of the result rows. If you're one of those annoyed users, you can now disable these tooltips with a new checkbox option in Tools > Preferences > Data appearance > "Popup SQL text over result tabs".
Database selector: In a session configuration, you can restrict the databases to display. That was just a normal drop down menu previously. Now, you can check databases and uncheck them in a pulldown menu. Also, the connection used to get the names of all databases is recycled for each click, so only the first pull down click establishes a new (potentially slow) connection.
The installer for HeidiSQL now uses localized messages in 23 different languages. Language is auto-selected by checking your Windows locale.
The user manager now supports granting privileges for VIEWs. This was not allowed until now, because I misunderstood the MySQL documentation here. See the forum thread with alfiqmiq for details.
Ask user to confirm unsafe UPDATEs/DELETEs in query tab before executing.
Switch character set from utf8 to the fixed one called utf8mb4 in MySQL.
Turn readme.txt into a more comprehensive online help document
and even more:
Support semicolons in MS SQL passwords
Clone hostname for a cloned user
Ask to close HeidiSQL processes while installing
Check if all indexes have at least one column when creating or altering table to prevent creation of empty index
Support primary keys with KEY_BLOCK_SIZE=xyz
Allow disabling the creation of start menu icons in the installer
Auto-uppercase data types of routine parameters
Display filename with path in query tab hint
Support changing active result tab per shortcut, Alt+Left and Alt+Right.
Disable UNSIGNED and ZEROFILL checkboxes for BIT type columns
Fix missing table alias on MSSQL2K
Support query timeout on MSSQL and PostgreSQL. Make customizable per up/down scroller in "Advanced" tab of session manager.
Add "Save as textfile" action, and include that in routine editor > "CREATE code" tab > context menu.
Activate "Select all" action when it appears in a valid popup menu.
Increase maximum port number from 2^16-1 (65535) to 2^31-1 (2147483647).
Add a 32bit-only installer, for users who want the 32bit version on a 64bit Windows.
Support searching for unformatted integers and floats in filter panel.
Fix truncation of MSSQL routine body to 4000 characters, as a limitation of nvarchar(4000).
Fix SynEdit's double minus comment bug
Use prettier "Consolas" as default font for TSynMemo editors, when available, as an alternative to the old-stylish "Courier New".
Fix SQL error when using "Quick filter" > "More values" in MSSQL and PostgreSQL.
MSSQL: Return date/time string value as expected by server.
Enable foreign keys editor on NDB cluster >= 7.3.x.
Add support for geometry data types in PostgreSQL.
Support renaming tables and views on PostgreSQL.
Fix EStackOverflow in TSynHashEntry.AddEntry when adding too many table names.
Include SQL_TABLE_VALUED_FUNCTION's in MSSQL object browsing
Support DEFAULT clause in PostgreSQL table structure
Keep compatibility with older MySQL servers when getting a trigger's CREATE CODE
MSSQL: Return float values as expected by server.
Introduce handling of stored functions in PostgreSQL: Displays functions in database browser, enables function editor and "run routine" button with argument handling.
Add support for MSSQL datetime2 column type.
Allow applying CURRENT_TIMESTAMP to DATETIME columns.
Add "check/uncheck all" button to column selector in textfile import dialog.
Add 64px, 128px and 256px versions to main icon.

Continue to apply filter of table list after refresh but clear it when changing database.

* 64 bit version allows HeidiSQL to use much more of your memory than the 2GB in 32 bit mode
* New feature: Fast table status for databases with InnoDB tables. (Disable Session > Advanced > [X] Get full table status)
* New feature: Favorites in database tree
* New feature: Append parameter names for procedures and functions in completion proposal
* New feature: Compressed .sql file export
* Migration to the brand new Delphi XE 5 compiler
* Replace out-dated code which partly not runs in 64 bit mode
* Update gettext unit
* Update Cromis.DirectoryWatch unit
* Update VirtualTree component code to 5.2.1 (r567)
* Update SynEdit component (r114)

* Revert r4538 (ctrl backspace bug), as this broke tabbing through grid cells
* Add fallback "DELETE FROM..." to CSV import dialog's option "truncate table"
* Fix non-working "Replace all" button on search/replace dialog
* Turn "Drop" confirmation dialogs into custom critical types, and set focus to the Cancel button.
* Quote plink.exe path and file in SSH tunnel preparation, so spaces in the path do not break the CreateProcess call.
* Fix quick filters, broken with formatted numbers
* Prefer Delphi's various TGraphic descendants over the out-dated GraphicEx library. PNG images even show their transparency now. Removes support for the myriad of exotic image formats.
* Restrict "Quick filters" > "More values" submenu to tables with less than 1GB of data, so we're not running into an endless query

· Shorten long SELECT query in data grid, using '*' when all columns are involved.
· Apply database and table filter on a new connection. Fixes issue #3353.
· Sort snippet filenames manually before displaying in helper box. Seems file ordering is inconsistent between Windows version. Fixes issue #3351.
· Using TDBQuery.ColAttributes() and TTableColumn.LengthSet in a query result does not work, as this relies on a previous SHOW CREATE TABLE parsing. Check PMYSQL_FIELD.length instead to return the correct zero-padded string bitmask for a BIT column. Fixes issue #2544.
· Use a standard TSaveDialog when storing a snippet file. Fixes issue #3346. Also fixes "selection only" version of "Save snippet". Reuse code from actSaveSQLAs action.
· Get Ctrl+Backspace hotkey to work in grid inplace editor, by enabling autocompletion + autosuggestion. Fixes issue #3168.
· Trim clipboard contents for quick filter menu items.
· Add missing event listeners to previously introduced edit box for snippets directory.
· Make snippets directory customizable. Fixes issue #3276
· Fix exception in ReadTextfileChunk when file has 0 bytes.
· Downgrade libmysql.dll to a MariaDB-5.3.12 version. Fixes issue #3343 ("malformed packet" on LOAD DATA). All 5.5 versions seem to be affected, not so 5.3.x. Required tests for the next time I'm updating libmysql.dll: * Ensure LOAD DATA LOCAL INFILE works, and does not throw SQL error 2027/malformed packet * Ensure it's a .dll from the 32bit server version * Ensure it's a MariaDB version, so pluggable authentication still works
· Update libmysql again with a version from MariaDB 5.5.33a. Fix SQL error 2027 "malformed packet", when firing LOAD DATA command. See http://www.heidisql.com/forum.php?t=13454 and issue #3262.
· Attempt to fix issue #2640 again (AV on alt-tab when in popup editor), by disabling the completion form in ApplicationDeActivate event. Activate MainFormOnTaskBar again, which fixes issue #2351 (Windows Flip3D feature) and probably also issue #3342 (Alt-tab in Wine)
· Revert r4003, as issue #2651 could easily be caused by an assigned-check of FPreferencesDialog, which is freed in Toptionsform.FormClose in any case, but leaves the FPreferencesDialog assigned.
· Ensure editDatabaseTableFilterChange is triggered when a db was expanded, which seems the missing event to get the table filter working again. Probably fixes issue #3313.
· Always show the "Copy" tooltip when dragging sessions elsewhere, as we always copy by drag'n drop, never move.
· Load full row content before replacing text using the search+replace dialog on the data grid. Fixes issue #3252.
· Disable grid in AnyGridBeforeCellPaint after TAdoDBQuery.SetRecNo detected a broken MSSQL connection. Hopefully fixes issue #3336.
· List recently active translators in about dialog. Also, read out credits from readme.txt, so I don't have to maintain that list in the TMemo, getting unwanted linefeeds whenever I'm saving it.
· Unescape default text value for a column when inserting a new grid row, so \r and \n and whatever does not get into a cell as a literal. Fixes issue #3283.
· Update libmysql to a 5.5.32 version from the current stable MariaDB release. Fixes issue #3262.
· Provide a way to enter the donators email address in the about dialog, and hide all donate buttons if a check on heidisql.com succeeded. Fixes issue #3334.
· Remove unused uses clause.
· Add donate button to 3 places: * main toolbar * about dialog * updatecheck dialog
· Revert r4357 (add database name in GetCreateViewCode), to fix issue #3329 (view export includes superfluous database name). Issue #3098 is still fixed, by the later r4479 (get view columns from IS.COLUMNS).
· New attempt to fix the file reader for cases where the chunk size end is within a multibyte character. Increase chunk size per loop and retry reading the chunk. See http://www.heidisql.com/forum.php?t=13044
· Be more verbose in RunQueryFile(), on the progress dialog.
· Revert r4503, except for the removed helpers.ScanNulChars() and helpers.RemoveNulChars(). Seem Delphi's encoding detection is totally broken. Also, TStreamReader has bugs and hangs on the second call to ReadTextfileChunk(). Most files should be read fine again, including those mentioned in issue #3331. Also fixes issue #3328. TODO: fix reading specific UTF8 files
· Prefer Windows.GetCommandLine over ParamStr() when parsing command line parameters. ParamStr() removes double quotes.
· TJumpList.Apply seems to trigger "Access denied" exceptions in some cases. Log these in the log panel, but do nothing when that happens.
· Introduce Win7+ jump items on task button.
· Code cosmetic: Move public AppVer* variables to private scope and introduce public properties for the both which are read publicly.
· Edit raw numbers, not their formatted version which is used for displaying. See issue #653.
· Try a new approach in helpers.OpenTextFile(), helpers.ReadTextfile() and helpers.ReadTextfileChunk(): Based on TStreamReader instead of TFileStream now, so we can finally rely on Delphi internals for detecting a file's encoding. Also, this should fix read errors in some UTF-8 files, e.g. mentioned on http://www.heidisql.com/forum.php?t=13044
· Remove helpers.DetectEncoding(). Use a separate TStreamReader in the only caller to detect the encoding of a selected file
· Remove helpers.ScanNulChar()
· Add missing translation strings for preferences dialog
· Issue #3324: Merge "Highlighter" tab into "SQL" tab again, to keep a low number of tabs
· Divide "Data" options tab into "Data appearance" and "Data editing" tabs, to make room for the new checkbox option "Local number format"
· Introduce the new data option "Local number format"
· Issue #3324: When copying from a numeric grid cell, use raw numbers, not the formatted version.
· Use internal flag to remember whether new grid text was pasted from clipboard. This way we can again use "Grid.Text[] := xyz", which triggers AnyGridNewText(), which again is able to pass the right "Null" parameter to TDBQuery.SetCol(). This fixes issue #3325 (invalidated controls, especially "cancel changes" action after pasting). Also, this fixes pasted formatted numbers not being unformatted internally. Finally, we have 5 lines of code less than before :)
· Show thousand separator in data grids. Fixes issue #3324.
· Introduce TMainForm.FGridCopying flag, and use that to temporarily disable integer to datetime conversion in AnyGridGetText(). Fixes issue #3322.
· Remove properties ServerVersionInt and ServerVersionStr from TDBConnection. Instead, move private GetServerVersionInt() and GetServerVersionStr() to public scope, named like the previously used properties now
· Remove overridden methods in descendants of TDBConnection, do it with a version conditional in the upper class
· Finally, remove ConvertServerVersion() and merge code into ServerVersionStr()
· TOP(x) clause for UPDATES + DELETES introduced in MSSQL 2005. Do not use that on older servers. See http://www.heidisql.com/forum.php?t=13289
· Fix reading chunks from SQL file with a multiplier of the encoding's maximum character length. Broken in r4470.
· Fix usage of wrong TDBObject caused by using wrong offset from TDBObjectList.
· Move code from FillPopupQueryLoad into automatically triggered FillPopupQuery.OnPopup event.
· Make getting system imagelist and imageindex shared code in Helpers.GetSystemImageList and Helpers.GetSystemImageIndex
· Remove call to TranslateComponent, accidentally committed in r4490
· Draw system icons with transparency
· Fix crash caused by freeing main image list, see previous commit. Fixes issue #3316.
· Display system known icons in recent SQL files list.
· Don't know when exactly but in some cases VirtualTree.FocusedColumn seems to have the InvalidColumn (-2) index. Do not pass such negative indexes to a TStringList in TDBQuery.ColAttributes.
· Add caption of column selector, forgotten in previous commit.
· Turn column selection form into a tool window, so I can apply a size-grip at the lower right edge of the form. Remember form dimensions. Fixes issue #3299.
· Add CHECK option "FOR UPGRADE" to maintenance dialog. Fixes issue #3279.
· Remove "Run file" dialog, and use a standard Windows IProgressDialog instead when executing a SQL file.
· Enhance error handling when "Stop on errors" is activated, by showing an error summary at the end of script execution.
· Fix regex in TDBConnection.ParseViewStructure which matches on IS.COLUMNS.COLUMN_TYPE but just finds empty matches, because all expression groups are optionally. Also, ZEROFILL attribute for numeric columns never gets detected. Fixes issue #3311.
· Make regex in ParseViewStructure even more loose, this time due to dots in the view's name. See http://www.heidisql.com/forum.php?t=13191
· Issue #3304: Escape column names for PHP
· Fetch column names from IS.COLUMNS only, without joining IS.VIEWS from which we anyway don't read something. Fixes issue #3305.
· Escape exported PHP strings using some extra logic, instead of using incompatible TDBConnection.EscapeString. Fixes issue #3304.
· Get column names from VIEW per IS.COLUMNS, not per SHOW COLUMNS, to support MSSQL here. Fixes empty grid results for MSSQL VIEWs. See comment #46 of issue #3212.
· Translate new menu item "Generate SELECT", missing in r4477.
· Add "Generate SELECT..." menu item to query helpers context menu. See http://www.heidisql.com/forum.php?t=13108
· Move file related actions to "File" menu
· Handle ERegistryException's in TMainForm.FinishedQueryExecution by writing them to the SQL log. These seem to happen sporadically in a broken registry, or due to going from a query thread to the main thread again. Guess there is no real fix to that issue.
· Provide edit box for custom NULL value, in grid export dialog.
· Increase size of chunk to read from SQL dump from 5M to 20M, so we catch at least the file problems
· Process messages in loop of query batch on run sql file dialog. Helps making this dialog responsive.
· Ensure ReadTextfileChunk reads a multiplier of the encoding's maximum byte count per char.
· Log error message when TEncoding.Convert returns an empty TByte array.
· Turn unhandled exception in case of SQL errors into a popup dialog when running SQL files.
· editDatabaseTableFilter.onchange is triggered in DBtree.AfterPaint, which is implicitly called a million times, when mouse hovers over the tree. * Move that call from DBtree.AfterPaint to RefreshTree, and call it only when it required. Removes a big bunch of useless magic code execution. * This way, I can wrap the code in editDatabaseTableFilter.onchange in a BeginUpdate/EndUpdate block to postpone painting while looping over the nodes.
· Include application name in login prompt. Fixes issue #3180.
· Include schema name in ALTER TABLE query on table editor.
· Use table name from helper TDBObject in TDBQuery.PrepareEditing, as TMySQLQuery.TableName does not return the VIEW's name when the VIEW contains aggregated columns. Fixes issue #3284.
· Try to disable platform warnings on command line also
· Silence various compiler warnings about non initialized variables. Globally turn off platform warnings
· Avoid using Format() on event body, as this causes AVs when it contains some % sign. See http://www.heidisql.com/forum.php?t=13010
· Send column default value through UnescapeString and then to EscapeString, and let UnescapeString remove double backslashes. Fixes issue #3283.
· Use the right binary instead of decimal prefixes for bytes: KiB, MiB etc. And introduce unit for 2^60 bytes: Exbibyte. See http://de.wikipedia.org/wiki/Byte .
· Limit test query to return one single row, not all rows. Fixes issue #3271.
· Issue #3240: Set focus on first "Options" tab by default.
· Add page control to trigger editor, and show CREATE code of triggers in separate tab. Fixes issue #3240.
· Make charset query compatible to MSSQL 2000. Fixes issue #3269.
· No need to adjust vertical position of OK button on sorting popup. See http://www.heidisql.com/forum.php?t=12980
· Adjust control dimensions in login form, so translations fit. See http://www.heidisql.com/forum.php?t=12979
· Use TDBQuery.DBObject.Database in TDBQuery.DatabaseName(), so for VIEWs we do not get the db from the table which is selected. Fixes issue #3266.
· Issue #3212: Fall back to db..table if schema is unknown or server has no schema support.
· Support length of "max" in data types. Used in MSSQL.
· Issue #3212: Introduce TDBQuery.DBObject, to which we assign the selected object when getting the result for the data grid. Use that DBObject in TDBQuery.QuotedDbAndTableName and TDBQuery.PrepareEditing, where we need to know the schema of the object.
· Consider schema name when focusing tree node in TMainForm.SetActiveDBObject > TMainForm.FindDBObjectNode > TDBObject.IsSameAs
· Issue #3212: TDBQuery.SaveModifications makes use of TDBQuery.QuotedDbAndTableName, not TDBConnection.QuotedDbAndTableName. Make first one internally call the second one, so both do the same thing.
· Do not always display NULL in a MSSQL grid field when value was edited.
· WITH .. CHECK OPTION" is already contained in the "source" value of a .frm file. Don't include it a second time in TMySQLConnection.GetCreateViewCode. Fixes issue #3258.
· Support brackets in routine parameters. Fixes issue #3255.
· Issue #3212: Reestablish MSSQL 2000 compatibility by removing SCHEMA_NAME(schema_id) from TAdoDBConnection.FetchDbObjects.
· Issue #3212: Inject XY_SCHEMA=xy clause into all other IS queries in TAdoDBConnection.GetCreateCode.
· Issue #3212: Consider schema name in default objects sorting, so the tree displays the same order as we have in the database tab when sorted by "Name" column.
· Issue #3212: Display schema name also in database tab, to make it consistent with the tree.
· Issue #3212: Filter objects by schemata when gathering columns from IS.COLUMNS in TDBConnection.GetCreateCode, so we don't get columns from objects with the same name in another schema.
· Move helpers:GetIndexIcon to TTableKey.GetImageIndex
· Avoid calling TDBConnection.ClearDbObjects() on active database after copying table. Instead, call actRefresh which takes care of a probably opened table object in the table editor. * Check for table existence via SELECT on IS.TABLES, avoid usage and refresh of db objects here also. * Fixes issue #3250.
· Inject default schema between db and table in TDBConnection.QuotedDbAndTableName if target object does not exist. See issue #3212.
· Copy table dialog: * Clear db cache only once in btnOKclick * Clear db cache of target db when done, instead of refreshing active db * Remove unused variables * Remove empty comment clause from CREATE TABLE code
· Introduce TDBConnection.FindObject(db, obj). Use that in TDBConnection.QuotedDbAndTableName() and for checks for table existence.
· Leave out "_binary" keyword on MSSQL when inserting binary files. Fixes issue #3244.
· Issue #3212: Introduce TDBConnection.QuotedDbAndTableName(), callable with a db and table string. Internally calls TDBObject.QuotedDbAndTableName(), so we get the schema between db and table if required.
· Issue #3212: Add basic support for schemas in MSSQL.
· No background gray for sorted columns any longer. Leads to confusion when mixed with the new alternating row colors. See http://www.heidisql.com/forum.php?t=12882.
· Include ROW_FORMAT in CREATE code. Fixes issue #3243.
· Add overlay icons for table engines Blackhole and MergeMyISAM.
· Add preference option and logic for alternating grid row background colors. Fixes issue #2820.
· Clear tab filename also if query editor is empty. Fixes issue #3241.
· Support cancel button in "Run routine" action. Fixes issue #3151.