Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.

HeidiSQL 11.2 with support for check constraints and CSV layout detection

ansgar's profile image ansgar posted 10 months ago in Anouncements Permalink

Get it from the download page

3rd party updates:

New features and enhancements in this version:

  • New CSV layout detection for "Import text file" dialog (select <New table>)
  • Support for table level check constraints on MariaDB
  • New "Rename tab" context menu for query tabs
  • New "CREATE code" tab in view editor
  • Tab restore feature:
    • Gracefully re-create folder if query tab file and its folder was deleted from outside
    • restore scroll position
    • restore active query tab
  • Grid export:
    • Convert "Copy rows" context menu item to a submenu, and provide all export formats, with icons
    • Support custom hotkeys for each of these grid export actions
  • SQL export:
    • Prevent "Variable 'sql_notes' can't be set to the value of 'NULL'", via IFNULL() wrap
    • Speed up data exports of large MS SQL tables, by introducing ORDER BY .. OFFSET .. FETCH clauses in SELECT's
    • Limit rows per exported INSERT to 1000 for MSSQL.
    • Auto-create directory path of output file
  • Support shortcut Ctrl+F for focus on filter edit on session manager
  • Data grid: Prefer SUBSTR() over LEFT() function, unsupported in old PostgreSQL versions
  • Support regproc and jsonb column types on PostgreSQL
  • Support binary values in "More values" quick filter menu
  • Restore minimized main window when user attempts to start a second HeidiSQL process in single-instance mode
  • Apply data type colors to column names in completion proposal
  • Widen status bar panels for big screens
  • Shortcut settings: Prompt user for overwriting an existing shortcut

Bugfixes

  • Fix various crash reports uploaded by users via exception dialog
  • Accept any whitespace after double-minus comment in MySQL/MariaDB mode
  • Add UTF-8 BOM in Excel output only in file-mode, not in copy-mode.
  • Fix grid search/replace with scope=selection
  • Enable MYSQL_OPT_LOCAL_INFILE, seems still required on some systems for importing local CSV files
  • Fix invalid enabled state of "Explain current query" action
  • Re-add CURRENT_TIMESTAMP function, removed accidentally in last update
  • Fix cleared highlighter's TableNames list in irrelevant events
  • Fix empty library drop-down after changing network type for the first selected session.
  • Fix wrongly parsed ON UPDATE clause of columns when information_schema is hidden by session setting
  • Enable cancel button after setting grid cell to NULL

Complete change list: https://github.com/HeidiSQL/HeidiSQL/milestone/6?closed=1

Wiikend's profile image Wiikend posted 8 months ago Permalink

Thank you for the check constraint interface! Just upgraded to MariaDB 10.2, perfect timing :)

Please login to leave a reply, or register at first.




Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.