CINXE.COM
HeidiSQL 12.7 with support for descending indexes, filter boxes in table tools, JSONL export, and more
<!DOCTYPE html> <html lang="en"> <head> <title>HeidiSQL 12.7 with support for descending indexes, filter boxes in table tools, JSONL export, and more</title> <meta name="description" content="Get it from the download page 3rd party updates: Issue #1946: update libmariadb.dll and plugin libraries to latest v3.3.8 Update regular expression library to v1.181 2023.11.22, supporting \K pattern to set the begin of a reported match. Update InnoSetup compiler to v6.2.2 Update VirtualTrees comp" /> <link rel="canonical" href="/forum.php?t=42121" /> <link rel="alternate" type="application/atom+xml" href="/rss.php" /> <meta name="Content-Language" content="en" /> <meta name="author" content="Ansgar Becker" /> <meta name="viewport" content="width=device-width" /> <link rel="search" type="application/opensearchdescription+xml" title="HeidiSQL Board Search" href="/searchboard.xml" /> <link rel="stylesheet" type="text/css" href="/basic.css?v54" /> <script type="text/javascript"> // Log JS errors per AJAX call window.onerror = function (msg, url, line, column) { let headers = "Method: GET\n"; let img = new Image(); let maxValLen = 250; // column may be 0, or even unsupported in old browsers if(typeof column === 'undefined') { column = (window.event && event.errorCharacter) || -1; } for (let p in navigator) { let tp = typeof navigator[p]; let val = navigator[p]; switch (tp) { case "string": case "number": // Normal case - do nothing specific break; case "boolean": val = val ? "true" : "false"; break; case "object": try { val = JSON.stringify(val); } catch(err) { val = "[" + tp + "]"; } break; default: val = "[unknown]"; } if ((typeof val === "string") && val.indexOf("function") !== 0) { if(val.length > maxValLen) { val = val.substr(0, maxValLen) + '...'; } headers += p + ": " + val + "\n"; } } img.src = "/logjserror.php" + "?domain=" + encodeURIComponent(window.location.host) + "&url=" + encodeURIComponent(window.location.pathname) + "&referrer=" + encodeURIComponent(document.referrer) + "&headers=" + encodeURIComponent(headers) + "&message=" + encodeURIComponent(msg) + "&jsurl=" + encodeURIComponent(url) + "&jsline=" + encodeURIComponent(line) + "&jscolumn=" + encodeURIComponent(column); return false; }; </script> <script src="/jquery-3.5.1.min.js" onload="window.jQueryLoaded=true"></script> <script src="/xads.js" defer></script> <script src="/jquery.selection.js"></script> <script src="/helpers.js?v1"></script> <script async src="https://pagead2.googlesyndication.com/pagead/js/adsbygoogle.js?client=ca-pub-4114345487694759" crossorigin="anonymous"></script> <script> window.onload = function() { window.download_started = false; let links = document.querySelectorAll('.download-link'), i; for (i=0; i<links.length; i++) { links[i].onclick = function() { window.download_started = true; }; } // auto download? // Forum preview and handle paste if(window.jQueryLoaded) { let postMessage = $('#post_message'); postMessage.keyup(debounce(postPreview, 250, {maxWait: 3000})); postMessage.on('paste', handlePaste); } }; </script> </head> <body> <div id="header"> <div id="inner-header"> <a href="/"> <img src="/images/heidisql_logo_mwd.png" id="logo" alt="HeidiSQL Logo" width="260" height="66" /> </a> <div id="inner-right-header"> <!-- horizontal --> <ins class="adsbygoogle" style="display:inline-block;width:640px;height:100px" data-ad-client="ca-pub-4114345487694759" data-ad-slot="2718443743"></ins><script> (adsbygoogle = window.adsbygoogle || []).push({}); </script> </div> <ul id="menu"> <li><a href="/">Home</a></li> <li><a href="/download.php">Downloads</a><ul><li><a href="/download.php?download=installer">Installer</a></li> <li><a href="/download.php?download=portable">Portable</a></li> <li><a href="/download.php?download=portable-64">Portable-64</a></li> <li><a href="/download.php?download=app">App</a></li> <li><a href="/download.php?download=source">Source</a></li> <li><a href="/download.php#nightlybuilds">Nightly builds</a></li> </ul></li> <li><a href="/screenshots.php">Images</a><ul><li><a href="/screenshots.php">Screenshots</a></li> <li><a href="/themes.php">Themes</a></li> </ul></li> <li class="highlight"><a href="/forum.php">Forum</a><ul><li><a href="/forum.php?t=43753#p43754"> 29 Nov - bootleeg: Connect to MySQL Router r/w split acce <span title="... ss mode auto">...</span> </a></li> <li><a href="/forum.php?t=43621#p43752"> 28 Nov - cleverpg: Log error, invalid characters </a></li> <li><a href="/forum.php?t=43728#p43751"> 28 Nov - nadeemcoorg: I want to run a query with CMD file </a></li> <li><a href="/forum.php?t=43749"> 27 Nov - d: Insert images in MariaDB </a></li> <li><a href="/forum.php?t=43739#p43742"> 25 Nov - Jakko: Bulk import of CSV with some columns only </a></li> <li><a href="/forum.php?t=43736#p43737"> 24 Nov - ansgar: heidi sql grid editing error: column #4 <span title="... not available">...</span> </a></li> <li><a href="/forum.php?t=43734#p43735"> 23 Nov - ansgar: Unlock the Power of PostgreSQL Date Data <span title="... Types">...</span> </a></li> <li><a href="/forum.php?t=43725#p43727"> 18 Nov - TimothyMadden: How to connect to default SQL Ser <span title="... ver installation ?">...</span> </a></li> <li><a href="/forum.php?t=43720#p43724"> 16 Nov - sakim: heidisql for Postgresql </a></li> <li><a href="/forum.php?t=6073#p43723"> 16 Nov - Reinier: Unable to see query results ... </a></li> <li><a href="/forum.php?t=5331#p43722"> 16 Nov - Reinier: how to enable Resut panel in Query tab </a></li> <li><a href="/forum.php?t=43713#p43719"> 12 Nov - ansgar: Can you use multiple databases from dife <span title="... rent connections for doing a statement">...</span> </a></li> <li><a href="/forum.php?t=43709#p43712"> 07 Nov - artvandelay: Un/comment in toolbar or shortcut </a></li> <li><a href="/forum.php?t=43710"> 07 Nov - ATRICA: Error at connection to a FIREBIRD DB </a></li> <li><a href="/forum.php?t=43698#p43708"> 03 Nov - luvheidi: Newbie. Cannot log on. Consistent 1006 <span title="... 0 error. Please help.">...</span> </a></li> <li><a href="/forum.php?t=43706#p43707"> 03 Nov - ansgar: Lost connection to server at 'hands <span title="... hake: reading initial communication packet&#039;, system error: 0uery">...</span> </a></li> <li><a href="/forum.php?t=43696#p43697"> 30 Oct - ansgar: parameters fonts size </a></li> <li><a href="/forum.php?t=43685#p43694"> 29 Oct - ansgar: Why did my grid go? </a></li> <li><a href="/forum.php?t=43691"> 24 Oct - SQL_Hack: Problem with User-Defined Variables an <span title="... d Run Routine function">...</span> </a></li> <li><a href="/forum.php?t=39507#p43690"> 23 Oct - LAIS: Incomplete display of store procedure </a></li> </ul></li> <li><a href="/donate.php">Donate</a><ul><li><a href="/donate.php#howto">How to donate</a></li> <li><a href="/donate.php#donors">List of donors</a></li> </ul></li> <li><a href="https://github.com/HeidiSQL/HeidiSQL/issues">Bugtracker</a><ul><li><a href="https://github.com/HeidiSQL/HeidiSQL/milestones">Milestone Roadmap</a></li> <li><a href="https://github.com/HeidiSQL/HeidiSQL/issues?q=is%3Aissue+is%3Aopen+label%3Abug">Bug reports</a></li> <li><a href="https://github.com/HeidiSQL/HeidiSQL/issues?q=is%3Aissue+is%3Aopen+label%3Afeature">Feature requests</a></li> <li><a href="https://github.com/HeidiSQL/HeidiSQL/issues?q=is%3Aissue+is%3Aopen+label%3Aenhancement">Enhancement requests</a></li> </ul></li> <li><a href="/help.php">Help</a><ul><li><a href="/help.php#requirements">Requirements</a></li> <li><a href="/help.php#connecting">Connecting to a server</a></li> <li><a href="/help.php#commandline">Command line switches</a></li> <li><a href="/help.php#dbtree">The database tree</a></li> <li><a href="/help.php#createtable">Creating a table</a></li> <li><a href="/help.php#createview">Creating a view</a></li> <li><a href="/help.php#createroutine">Creating a stored procedure</a></li> <li><a href="/help.php#createtrigger">Creating a trigger</a></li> <li><a href="/help.php#createevent">Creating a scheduled event</a></li> <li><a href="/help.php#data">The Data tab</a></li> <li><a href="/help.php#queries">Running SQL queries</a></li> <li><a href="/help.php#sqlexport">SQL export</a></li> <li><a href="/help.php#import">Importing files</a></li> <li><a href="/help.php#portable">HeidiSQL portable</a></li> <li><a href="/help.php#license">License</a></li> <li><a href="/help.php#credits">Credits</a></li> </ul></li> </ul> </div> </div> <div id="content"> <h1>HeidiSQL 12.7 with support for descending indexes, filter boxes in table tools, JSONL export, and more</h1> <div class="forum_toolbar"> <form action="/forum.php" class="inlineform"> <input type="text" name="s" value="" size="20" /> <button type="submit" title="Find"> <img src="/images/icons/magnifier.png" alt="Find" /> </button> </form> <form action="/forum.php" class="inlineform"> <input type="hidden" name="post_action" value="add" /> <button type="submit" title="New topic"> <img src="/images/icons/add.png" alt="Add" /> New topic </button> </form><form action="user.php" class="inlineform"> <button type="submit"> <img src="/images/icons/user_add.png" alt="Register" /> Register </button> </form> <form action="login.php" class="inlineform"> <button type="submit"> <img src="/images/icons/application_go.png" alt="Logout" /> Log in </button> </form></div><div id="forum-thread"> <div class="forum-post" id="p42121"> <div class="forum-user"> <div class="forum-user-img forum-user-donor" title="ansgar" style="background:url('//www.gravatar.com/avatar/f6630ffe8b3c60e183e902a63a476f98?d=identicon&s=100') no-repeat; background-size:cover;"> <img src="/images/icons/money_euro.png" title="Donor" /> </div> <div class="forum-user-posts"> <a href="/forum.php?u=2" title="Click to find all posts from ansgar">10364 posts</a> </div> </div> <div class="forum-post-wrapper"> <div class="forum-post-header"> <img class="forum-user-img-mobile" src="//www.gravatar.com/avatar/f6630ffe8b3c60e183e902a63a476f98?d=identicon&s=100" alt="ansgar's profile image"/> <strong>ansgar</strong> posted <span title="05 May 2024 12:20">7 months ago</span> in <a href="/forum.php?c=1" title="Click to find all posts in category Anouncements">Anouncements</a> <span class="floatright"> <a href="?t=42121#p42121" title="Permalink to this post"> <img src="/images/icon-permalink.svg" alt="Permalink" /> </a> </span> </div> <div class="forum-post-content" id="msg42121"><p>Get it from the <a href="/download.php?download=installer">download page</a></p> <p><a rel="ugc"href="https://www.heidisql.com/donatebutton.php?place=announcement"><img src="https://www.heidisql.com/images/donatebutton.png" alt="" /></a></p> <p><strong>3rd party updates:</strong></p> <ul> <li><a href="https://github.com/HeidiSQL/HeidiSQL/issues/1946">Issue #1946</a>: update libmariadb.dll and plugin libraries to latest <a rel="ugc"href="https://dlm.mariadb.com/browse/c_connector/201/1924/">v3.3.8</a></li> <li>Update <a rel="ugc"href="https://github.com/andgineer/TRegExpr/">regular expression library</a> to v1.181 2023.11.22, supporting \K pattern to set the begin of a reported match.</li> <li>Update <a rel="ugc"href="https://jrsoftware.org/isdl.php">InnoSetup</a> compiler to v6.2.2</li> <li>Update <a rel="ugc"href="https://github.com/JAM-Software/Virtual-TreeView">VirtualTrees</a> component code to release v8.0.3 (major version update)</li> <li><a href="https://github.com/HeidiSQL/HeidiSQL/issues/1888">Issue #1888</a>: Update <a rel="ugc"href="https://www.chiark.greenend.org.uk/~sgtatham/putty/">plink</a> executables to v0.81</li> <li>Update <a rel="ugc"href="https://madshi.net/">madExcept</a> exception handler to v5.1.4</li> <li><a href="https://github.com/HeidiSQL/HeidiSQL/issues/1905">Issue #1905</a>: Update <a rel="ugc"href="https://www.openssl.org/">OpenSSL</a> libraries used by libpq-15.dll to v3.1.5</li> <li>Update SQLite libraries to v3.45.3 from 2024-04-15</li> </ul> <p><strong>New stuff:</strong></p> <ul> <li><a href="https://github.com/HeidiSQL/HeidiSQL/issues/1879">Issue #1879</a>: add drop down menu to "Apply filter" button, with an option to overwrite the current filter based on the different input text</li> <li><a href="https://github.com/HeidiSQL/HeidiSQL/issues/1512">Issue #1512</a>: add basic support for indexes with descending column direction</li> <li><a href="https://github.com/HeidiSQL/HeidiSQL/issues/1429">Issue #1429</a>: add "SQL INSERT IGNORE" output format to grid export dialog</li> <li><a href="https://github.com/HeidiSQL/HeidiSQL/issues/178">Issue #178</a>: add database and table filter boxes above tree view on table tools dialog</li> <li><a href="https://github.com/HeidiSQL/HeidiSQL/issues/1917">Issue #1917</a>: Support additional UCA collations introduced in MariaDB 10.10.1.</li> <li><a href="https://github.com/HeidiSQL/HeidiSQL/issues/1927">Issue #1927</a>: display column comments in completion proposal, give that third column more space to the left and italic style</li> <li>Table editor: when user runs into the cryptic "constraint is incorrectly formed" message, append a more meaningful line from SHOW ENGINE INNODB STATUS.</li> <li>Support naming result tabs per "-- name: xyz" comment. See <a rel="ugc"href="https://www.heidisql.com/forum.php?t=10493">https://www.heidisql.com/forum.php?t=10493</a></li> <li>Reorder components in grid export dialog, and convert format radio buttons to combobox. Makes the dialog more wide than high, creating space for wider labels and more format options.</li> <li><a href="https://github.com/HeidiSQL/HeidiSQL/issues/1930">Issue #1930</a>: Grid export: implement JSON Lines format.</li> <li><a href="https://github.com/HeidiSQL/HeidiSQL/issues/139">Issue #139</a>: Alternating row background colors in table columns list and most other main tabs, if activated by user.</li> </ul> <p><strong>Bugfixes and enhancements:</strong></p> <ul> <li>Enhance readability of focused text in result grid using dark styles. TreeOptions.PaintOptions.toGhostedIfUnfocused grays out text otherwise.</li> <li>Fix crash in SynCompletionProposalChange, happening when scrolling very fast to the top of the list</li> <li>Fix crash in f_() function with invalid format specifiers from some translation. Happened in Japanese recently.</li> <li><a href="https://github.com/HeidiSQL/HeidiSQL/issues/1870">Issue #1870</a>: support VARCHAR columns with a length of 0, in temporary fake tables for exporting views</li> <li>Detect Windows 11 in about dialog, and remove functions only required for the no longer supported Windows Store version</li> <li>Fix activated SSH tunnel for a network type which does not support that, after changing the network type from an explicit SSH-tunnel-type to a TCP/IP version.</li> <li>Search replace: ignore numbers in static row id column</li> <li>Installer: add newly available translations for Hungarian and Bulgarian</li> <li>Add item in Tools main menu for resetting panels to their default dimensions. Useful for quite a few people who move their app window between screens with different resolutions.</li> <li>Static row id: always use the color of the session the result belongs to</li> <li>Performance: call TimerHostUptimeTimer event every 20 seconds only, instead of each second</li> <li>SQL export dialog: cut long file list down to 20 latest items</li> <li><a href="https://github.com/HeidiSQL/HeidiSQL/issues/520">Issue #520</a>: Fix crash in sort columns dialog when removing the last column, with a non-default theme</li> <li>After reformatting SQL code, unify new lines to Windows line feeds, so the selection's end in SynMemo is correct</li> <li>Fix retrieving MySQL events from the current database on older servers, work around MySQL bug 41907. See <a rel="ugc"href="https://bugs.mysql.com/bug.php?id=41907#c360194">https://bugs.mysql.com/bug.php?id=41907#c360194</a></li> <li>Make pressed state of favorites button more noticeable, by using the gray-scale icon in unpressed state</li> <li>Fix emptied "SHOW WARNINGS" pool due to queried @max_error_count in warning dialog. See <a rel="ugc"href="https://www.heidisql.com/forum.php?t=41753">https://www.heidisql.com/forum.php?t=41753</a></li> <li><a href="https://github.com/HeidiSQL/HeidiSQL/issues/1899">Issue #1899</a>: fix wrong column number on column selector above data grid</li> <li><a href="https://github.com/HeidiSQL/HeidiSQL/issues/1906">Issue #1906</a>: provide a new preference option to turn on color icons on inactive tabs again</li> <li><a href="https://github.com/HeidiSQL/HeidiSQL/issues/1910">Issue #1910</a>: Fix CURRENT_TIMESTAMP default text detection as an expression, not as an ordinary string literal, on MySQL 8.0.14+.</li> <li><a href="https://github.com/HeidiSQL/HeidiSQL/issues/1887">Issue #1887</a>: restore old scroll offset in data grid, when refreshing result or paging to the next rows</li> <li><a href="https://github.com/HeidiSQL/HeidiSQL/issues/1918">Issue #1918</a>: Remove leading timestamp from log message when copying to new query tab.</li> <li>Host tab: use session name as tab caption, and show host name as mouse-over hint. See <a rel="ugc"href="https://www.heidisql.com/forum.php?t=41399">https://www.heidisql.com/forum.php?t=41399</a></li> <li>Hopefully fix slow loading tabs.</li> <li><a href="https://github.com/HeidiSQL/HeidiSQL/issues/1923">Issue #1923</a>: Fix completion proposal not showing columns of a table alias when table name contains the word "join".</li> <li><a href="https://github.com/HeidiSQL/HeidiSQL/issues/355">Issue #355</a>: Fix non-working scrolling with a horizontal mouse wheel in grids, by preferring TWMScroll.Pos over TScrollInfo.nTrackPos (always 0).</li> <li>Add functions-mysql8.ini with some newer functions in it, and search for version specific ini file when connecting. See <a rel="ugc"href="https://www.heidisql.com/forum.php?t=41892">https://www.heidisql.com/forum.php?t=41892</a></li> <li>Fix too small foreign columns dropdown, scale controls on TSetEditorLink DPI aware</li> <li><a href="https://github.com/HeidiSQL/HeidiSQL/issues/1247">Issue #1247</a>: Fix invalid SQL code for dropping foreign key constraint in PostgreSQL mode.</li> <li><a href="https://github.com/HeidiSQL/HeidiSQL/issues/1586">Issue #1586</a>: include "COLLATE xyz" clause when applying collation and user checked the "Convert data" option, so the columns do not get the default collation of the new charset</li> <li><a href="https://github.com/HeidiSQL/HeidiSQL/issues/1934">Issue #1934</a>: fix empty column list in completion proposal when user input starts with a quote character</li> <li><a href="https://github.com/HeidiSQL/HeidiSQL/issues/1933">Issue #1933</a>: Update list with known MySQL 8 keywords, taken from <a rel="ugc"href="https://dev.mysql.com/doc/refman/8.0/en/keywords.html#keywords-in-current-series">https://dev.mysql.com/doc/refman/8.0/en/keywords.html#keywords-in-current-series</a></li> <li><a href="https://github.com/HeidiSQL/HeidiSQL/issues/1939">Issue #1939</a>: Fix empty CREATE TABLE code and "List index out of bounds" message in log, due to accessing TTableKey.Collations[x] without being initialized</li> <li><a href="https://github.com/HeidiSQL/HeidiSQL/issues/321">Issue #321</a>: Fix SQL code in TTableKey.SQLCode for PostgreSQL</li> <li><a href="https://github.com/HeidiSQL/HeidiSQL/issues/1940">Issue #1940</a>: In TSecureShellCmd.Connect, include parallel happened errors in any success dialog. Also, log errors to the log panel when both pipes have content.</li> <li><a href="https://github.com/HeidiSQL/HeidiSQL/issues/1942">Issue #1942</a>: Reset FClipboardHasNull marker before pasting text which was copied outside the application.</li> <li><a href="https://github.com/HeidiSQL/HeidiSQL/issues/1943">Issue #1943</a>: Set DbTree.DefaultNodeHeight in FormShow rather than in FormCreate, to respect DPI settings.</li> <li><a href="https://github.com/HeidiSQL/HeidiSQL/issues/1931">Issue #1931</a>: Support CITEXT columns in Postgres and categorize as text type, so these show up in foreign values pulldown editor of data grid.</li> <li><a href="https://github.com/HeidiSQL/HeidiSQL/issues/1868">Issue #1868</a>: Reset sort order of data tab grid as well, when user clicks "Clear data tab filter".</li> <li><a href="https://github.com/HeidiSQL/HeidiSQL/issues/1936">Issue #1936</a>: Fix EAbstractError when closing text editor</li> <li><a href="https://github.com/HeidiSQL/HeidiSQL/issues/1947">Issue #1947</a>: don't change case of detected column names, in CSV parser</li> </ul> </div> </div> </div><p>Please login to leave a reply, or <a href="/user.php">register</a> at first.</p><form method="post" action="/forum.php" id="loginform"> <label for="login_username">Username:</label> <input type="text" name="login_username" id="login_username" value="" /><br /> <label for="login_password">Password:</label> <input type="password" name="login_password" id="login_password" value="" /><br /> <input type="checkbox" name="login_remember" value="1" checked="checked" id="login_remember" /> <label for="login_remember">Remember me</label><br /> <input type="submit" value="Login" /><input type="hidden" name="t" value="42121" /></form></div> <script> var forumReadOnly = false; if(forumReadOnly) { $('#postform').html('<p style="color:maroon;">Forum registration and posting is currently disabled, due to a spamming flood.</p>'); } </script> </div> <p id="footer"> <a href="//mariadb.org"> <img src="/images/icons/server-mariadb.png" alt="MariaDB" /> Database powered by MariaDB</a> <a href="https://www.embarcadero.com/de/case-study/heidisql-case-study?utm_source=Eloqua&utm_medium=web&utm_content=HeidiSQL-website-footer"> <img src="/images/icons/embarcadero-rad-studio.png" alt="Embarcadero Delphi" /> HeidiSQL is proudly built with Embarcadero Delphi</a> <a href="https://www.facebook.com/HeidiSQL" title="HeidiSQL on Facebook"><img src="/images/facebook-icon.png" alt="Facebook" /></a> <a href="https://www.instagram.com/heidisql.official/" title="HeidiSQL on Instagram"><img src="/images/instagram-icon.png" alt="Instagram" /></a> <a href="/imprint.php">Imprint</a> </p> <div class="sticky-right"> </div> </body> </html>