Store last session name at disconnect time instead when when connecting. Fixes issue #2102.

If a session is configured to prompt for username + password, only prompt on the initial connect, not on each reconnection, which is annoying and superfluous.

Add button right besides recent filter pulldown menu, for clearing data grid related stuff for selected table, session or all sessions. Fixes issue #2096.

Minor code cosmetic

Apply more unique icon to SQL export action, so it has a different one than the grid export action.

Table editor fails to detect the default collation on some tables. Fetch it from SHOW TABLE STATUS instead as fallback. See http://www.heidisql.com/forum.php?t=6202

Fix date time grid editor for YEAR data type. Fixes issue #2078.

Session manager: Add checkbox option for users who want to be prompted for username + password rather than saving that to registry. Prompt window itself is called from within TMySQLConnection.SetActive.

Add context popup menu on column list which allows hiding/displaying single columns. Also fixes hidden collation column after having introduced the new zerofill column in r3441.

Immediately call popup text editor for cells which either contain line breaks or huge text over 100k. Fixes issue #1651.

Fix query splitter: "DELIMITER xyz" must be followed by some space char, this is not optionally. Broken in r3432. Fixes issue #2092.

FocusedColumn may also be "InvalidColumn" (-2) when the relevant grid column is hidden. Fixes issue #2088.

Triggers need to be exported after tables, just like views. Fixes issue #2077.

Table editor: Apply default length/set for new columns as long as user didn't touch it. Fixes issue #2084.

Remove code which is never executed - BLOB preview is done internally, not via temporary file.

Fix exceptions triggered when some grid cell editors are destroyed, e.g. by accessing the registry too late. Hopefully fixes issue #2046.

Attempt to fix some memory leaks in TMySQLQuery, when it gets destroyed. Should already be done by the compiler but who knows, probably this fixes issue #2063.

Remove dead code

Add "Clear file list" to query load menu. Fixes issue #2082.

Remove 3 dead constants

Add LIMIT 1 clause to grid UPDATE queries, to make these safer on tables without sufficient unique key. Fixes issue #2079.

Add fallback when trying to detect length of column. Fixes an AV in rare special cases.

Do not trigger completion proposal in query editors when cursor is inside a comment. Fixes issue #2070.

Force reinitializing nodes in ListDatabases when connecting. Fixes issue #1491, the hot tracking AV.

Add support for ZEROFILL flag in table editor. Introduces a new checkbox column in the columns list. Fixes issue #570.

Bring back database filter pulldown, for users who dislike to create one session per filter. Fixes issue #2054.

Remove Mince() function to shorten a file path - setting a label's EllipsisPosition to epPathEllipsis does the same.

Remember state of WordWrap button on text and hex editor. Fixes issue #2055.

Add menu item for inserting UNIX timestamp into grid cells. Fixes issue #2060.

Text and hex editor forms have "toolwin" style, which prevents the app from appearing when pressing Alt+Tab. Additionally, Alt+Tab leaves the app in foreground when such a window had focus. This is a Windows issue, as one can read here: http://edn.embarcadero.com/article/26050 . Set both forms back to bsSizable, fixes issue #2061.

Minor: Enhance wording on grid export caption. No need to mention all 6 different export formats in one short caption.

After disconnecting, accessing an old TMySQLQuery's connection can result in unhandled exceptions. Catch all of them in TMainForm.tabsetQueryGetImageIndex, not just those of which we're aware of. Fixes issue #2048.

Do not raise, just put a log info when previously focused db or table is gone after refreshing. This is a normal case when db or table was deleted from outside or via query. Fixes issue #2059.

Adjust offset stuff in SQL splitter routine, DELIMITER department. Fixes issue #2053.

When copying HTML from grid rows, StreamToClipboard needs its 3rd parameter set to true to create the required clipboard header for rich text editors. Also, calculate values for StartHTML and EndHTML - seems required by Mozilla based applications like Thunderbird. Fixes unformatted HTML pasted into rich text editors.

Foreign key constraint symbol names must be unique in a database. To avoid violation errors the "Copy table" dialog should just leave the CONSTRAINT clause out from the CREATE TABLE code. In that case MySQL auto creates a valid name on demand. See http://www.heidisql.com/forum.php?t=6086

Add support for exporting grids as Wiki table markup

Merge 5 GridToXYZ export routines into one, so there is less code to maintain and to make it easier to add further export formats.

Create query tab array early enough so we don't access them before by actDataPreviewExecute(). Fixes an AV on startup when preview panel was active.

Assign hotkeys to controls on search and replace dialog. See http://www.heidisql.com/forum.php?t=5801

Increase auto calculated column width slightly, so the flashing "..." button has room when editing cells, without cutting text. Fixes issue #2051.

Remove superfluous uses unit.

Use the right expression group when detecting "AT" date. Fixes issue #2041.

Be sure later calls to SetRecNo are executed after discarding a new grid row. Fixes issue #2031.

If a file does not contain a BOM, do not advance the stream position for later readers. Fixes issue #2035.

Trim db names to ignore such minor typos. Fixes issue #2036.

Do not overtake empty strings in semicolon separated list of databases. Fixes issue #2032.

Do not annoy user with error popup when accessing table data in information_schema.

Make data in VIEWs editable again by fetching table name and column names in a slightly different way. Fixes issue #1999.

Restrict "Select all" action to Ctrl+A, do not trigger it on Ctrl+Alt+A or AltGr+A. Fixes issue #2027.

Use TOpenTextFileDialog instead of TOpenDialog for two places where we load SQL and text cell contents. That dialog has an additional "Encoding" dropdown, where the user can select the file's encoding, which can be required if the auto detection did not succeed. Fixes issue #2025.

Remove remaining wrong \r\n text from LaTeX output.

Tweak LaTeX export: Fix case in all occurrences of "LaTex" - must be "LaTeX" and remove trailing "\r\n" in output.

Split identifiers with dot only in explicit cases, so column names containing a dot can be loaded and created. Fixes issue #2026.

Implement LaTeX output for "Copy as" actions. Code parts from brampton. Fixes issue #2020.

Apply non-redundant shortcut Ctrl+Shift+F to "Filter panel", instead of Ctrl+F which is used for "Find text" in query editors. Fixes issue #1907.

Load all rows in data grid when pressing Ctrl+End. Fixes issue #1949.

Fix recently broken support for views in "Copy table" dialog.

When total command count is very low, percentage values in command stats tab were miscalculated. Fixes issue #2015.

Fix wrong "DROP [index name]" clause when turning a normal key into a primary key. Fixes issue #2011.

Enhance wrapped text in result tab hint text. See issue #2014.

Implement recent filters in "Copy table" dialog, selectable via button + dropdown menu.

Wrap hint text at 100 chars. Fixes issue #2014.

Tweak copy table dialog:
- display number of checked/total child nodes per option node
- display row count on "Data" option
- remove plus button from disabled option nodes, and do not check them
- code cosmetic

Reset FRecNo after executing a new query, otherwise SetRecNo does nothing if FRecNo was already 0. Fixes issue #2009.

Enhancement: Prompt if target table exists, ask if it shall be dropped before creating the new table copy.

Bugfix: Only disable WHERE memo on first level "Data" node, not on second level nodes.

Enhancement: Disable "Indexes" and "Foreign keys" node to indicate they have 0 child nodes

Bugfix: Mixed check state also means that this node was checked

Refactor "Copy table" dialog:
* Replace checkboxes, radio buttons and checklistbox by a VirtualTree using checkbox support
* Support selecting/deselecting single indexes
* Support foreign keys
* Place a SynMemo at the bottom in which the user can type an optional WHERE clause to filter incoming data. Fixes issue #2000.
* Move code for SQL generation into TTableColumn etc.

Focus previous privilege tree node after deletion. Fixes issue #853.

Tweak auto setting column widths in datagrid: do not recalculate them on "Quick filter" clicks. Fixes issue #2005.

Find a way to fix issue #1970 again, this time without breaking remembered data grid node/col as in r3385. Fixes issue #2007.

Make grid scrolling incredibly much faster, by exiting early in SetRecNo if current row is already the right one. See http://www.heidisql.com/forum.php?t=5890

Immediately prepare editing when data grid fetches rows, as that implicitly fixes BLOBs detection and enables "Image preview" action. Fixes issue #1948.

Set and fetch default height of PageControl via constant rather than from the control itself, as that may not be created that early. A minimal chance that this fixes issue #1995.

Avoid endless loop in SQL help topics tree on broken help tables, by displaying a category node as topic item if has the same name as its parent category. Fixes issue #1988.

Repeat automatic calculating optimal column widths in data grid on refresh, as long as user did not resize some column. Fixes issue #2005.

Keep scroll offset when refreshing data grid. Fixes issue #2003.

Reset stored db and table names when dbtree focus changed, so the grid also refreshes when you add or remove column(s) in the table editor, switch to another table and then back. Fixes issue #1970.

Fix sporadic AV reported in forum: http://www.heidisql.com/forum.php?t=5911#p5925

Fix detected end offset of DELIMITER query.

Don't know what I meant to fix by this split-and-combine-again code, as it only has the effect that lines get trimmed. Remove that code. Fixes issue #2002.

Avoid an AV in cases when main tab is "Data" on startup.