New upstream version 3.4.4+dfsg.upstream/3.4.4+dfsg

1 files changed, 160 insertions, 2 deletions

diff --git a/ChangeLog.md b/ChangeLog.md
index c4d8433..a989352 100644
--- a/ChangeLog.md
+++ b/ChangeLog.md
@@ -1,5 +1,163 @@
 # ChangeLog
 
+### 3.4.4
+- ADDED: #3488 SQLite ICU extension is boundled into binary packages (thanks to @tuffnatty).
+- ADDED: #4697 Added a 'Restore original hotkey' buttons at keyboard shortcuts page of configuration dialog.
+- ADDED: Added sqlar extension to the default set of extensions provided with binary packages.
+- CHANGE: #4689 Sorting order is not cleared when table data is refreshed. To removed sorting order user can either double-click on header (once or twice) to restore no sorting for a column, or use context menu to clear any sorting.
+- CHANGE: #4735 Order of functions loading has changed. Now it's: built-in, extension-provided, user-defined. The last loaded has the highest precedense.
+- CHANGE: #4732 SQLite updated to 3.41.2 (except for SQLCipher, which is still on 3.39.4 at the moment).
+- CHANGE: #4683 Custom syntax highlighting colors now use theme-based colors by default (to work well with dynamically changing color palette in night/day theme changes) and can be explicitly enabled in configuration.
+- BUGFIX: #4676 #4716 #4693 #4701 #4669 #4721 Few critical fixes for Query Executor, fixing a frequent error: near ")": syntax error.
+- BUGFIX: #4685 Fixed WINDOW/OVER/FILTER keyword handling in the SQL parser.
+- BUGFIX: #4694 Fixed messages for toolbar buttons in Code Snippets window & fixed loading translations for plugins.
+- BUGFIX: #4698 Fixed handling object names with '{' and '}' in their names.
+- BUGFIX: #4681 Fixed risk of null reference call in the SqliteOrderBy.
+- BUGFIX: #4707 Fixed database file selection dialog, so it doesn't complaint about read-only files.
+- BUGFIX: #4679 Fixed issue with case sensivity of CTE alias.
+- BUGFIX: #4697 Changed default hotkey for rolling back pending changes in table data from Ctrl+Backspace to Alt+Shit+Backspace. Default hotkey affects new users and will not change automatically for those who upgrade from older SQLiteStudio.
+- BUGFIX: #4739 Fixed committing changes in Extensions Manager if modifying valid extension settings, while there is another invalid, yet untouched extension on the list.
+- BUGFIX: #4715 Fixed the UPDATE OF column popup on MacOSX.
+- BUGFIX: #4754 Fixed Windows uninstaller to not create separate uninstall entries in Windows registry per each SQLiteStudio version and added SQLiteStudio icon for the uninstall entry in Windows Add/Remove programs.
+- BUGFIX: Tcl plugin compilation improved on Ubuntu 18.04 (thanks to @tuffnatty).
+
+### 3.4.3
+- CHANGE: #4631 Linux binaries are built again back on Ubuntu 20.04 (instead of 22.04) to make it compatible for more Linux machines.
+- BUGFIX: #4660 Removed unnecessary linking to curses library in Linux build file.
+- BUGFIX: #4658 Fixed crash when SQL parser stack gets overflown.
+
+### 3.4.2
+- ADDED: #4653 For dealing with small fractional numbers there is an option now to change Grid View representation of these numbers to a scientific notation - the option is in Configuration/Data Browsing.
+- CHANGE: #4535 Improved current query highlighter, so it considers query on the left of the cursor as current in a more intuitive way.
+- BUGFIX: #4602 Fixed editing data in table with Russian upper-case name.
+- BUGFIX: #4105 Fixed Import Dialog state update when changing import source (CSV vs RegExp), which could cause inability to proceed with the import in some cases.
+- BUGFIX: #3767 Fixed copying objects between unencrypted and encrypted databases, also fixed copying tables with generated columns.
+- BUGFIX: #4422 Portable configuration also prevents SQLiteStudio from touching Windows registry.
+- BUGFIX: #3759 Fixed using independent SQLiteStudio instances by different Unix users simultaneously, regardless of one's settings.
+- BUGFIX: #4198 When copying/moving table with name-colliding index (or trigger) to another database, the name conflict resolution now actually works.
+- BUGFIX: #3541 Standardized commit/rollback hotkeys for: functions editor, extensions editor, collations editor, snippets editor, table window structure tab, view window query tab.
+- BUGFIX: #4607 Fixed bug in Query Executor, that caused selecting ROWID from a View, without expanding the view in the first place, thus causing smart execution to fail.
+- BUGFIX: #4607 Fixed Query Executor to apply column sorting correctly even in Simple Execution method.
+- BUGFIX: #4614 Fixed opening object links in SQL editor to be case-insensitive.
+- BUGFIX: #4618 Fixed query executor when using filer on a View.
+- BUGFIX: #4613 Fixed per-column filter behavior when clearing single filter using the in-line erase button.
+- BUGFIX: #4613 Fixed per-column filter behavior when jumping between subsequent filter inputs, so it does not apply filter for each single input, but rather waits for user Enter or Return key to be hit. Also not applying filter immediately when clicking the in-line erase button.
+- BUGFIX: #4624 Fixed (optimized) "Replace All" function in SQL Editor, reducing the "Replace All" action time from 30 seconds to 30 milliseconds in case of 380 occurrences.
+- BUGFIX: #4622 Fixed Form View to open at the same row that is selected in the Grid View.
+- BUGFIX: #4616 Fixed font refreshing in Grid View when changing font size with ctrl+wheel.
+- BUGFIX: #4562 Fixed Config Dialog to properly show loaded/unloaded plugins in case of dependant plugins.
+- BUGFIX: #4634 Added workaround for handling qt5ct style from Qt configuration utility.
+- BUGFIX: #4548 Automatic indexes are now marked correctly as unique and the Index Dialog is read-only for them.
+- BUGFIX: #4637 Fixed Bind Parameters dialog to apply initially a reasonable size of input editors.
+- BUGFIX: #4384 Fixed DDL modifications of Foreign Key referencing table, so the FK constraint is not retained if referenced column was dropped.
+- BUGFIX: #4636 Fixed importing CSV with multi-word column names in the header line of CSV.
+- BUGFIX: #4365 Fixed support for triggers with same name as tables in the same database (which is allowed by SQLite).
+- BUGFIX: #4641 Fixed a serious bug with filtering data grid view with more complex queries/views, including expression-based column names with multi-word aliases.
+- BUGFIX: #4272 Fixed undesired code assistant after starting application with SQL Editor contents suggesting auto completion.
+- BUGFIX: #4643 Fixed executing query with apostrophe (doubled) inside of a string literal value.
+- BUGFIX: #4546 Fixed exporting results of a query that is a huge SQL statement.
+- BUGFIX: #4642 Fixed crash when removing a last database from the application and then modifying contents of SQL Editor.
+- BUGFIX: #4064 Fixed support for ":memory:" database.
+- BUGFIX: #4254 Fixed few issues with CLI help messages.
+- BUGFIX: #4639 Fixed typo.
+- BUGFIX: Fixed refreshing invalid database state if edited & fixed its connection options.
+
+### 3.4.1
+- CHANGE: #4585 SQLite updated to 3.40.0 (except for SQLCipher, which has latest version 3.39.2).
+- BUGFIX: #4600 #4587 Fixed very slow loading of data in tables with foreign keys.
+- BUGFIX: #4549 Query executor column aliases do not need wrapping anymore, because parser in 3.4.0 does not strip wrapped aliases anymore.
+- BUGFIX: #4219 Removed duplicated UI config entries generated by Printing plugin.
+- BUGFIX: #4563 Installer now runs the application at final step as a regular user even if running as root.
+- BUGFIX: Fixed icon path for Linux installer, so that SQLiteStudio shows with the icon in Linux application list.
+- BUGFIX: #4550 Fixed the Test Connection button in Database Dialog.
+- BUGFIX: #4569 Fixed casual application crash on database disconnection.
+- BUGFIX: #4529 Fixed application freeze when creating table with ICU collation.
+- BUGFIX: #4586 Fixed unloading & loading SQLCipher plugin during single run of application.
+- BUGFIX: #4577 Fixed SSL handshake issue under Linux during updates checking.
+- BUGFIX: #4590 Fixed TLS issue under Windows.
+- BUGFIX: #4364 Fixed table modification script in case all existing columns of a table are deleted, but the table remains and then new columns are added.
+- BUGFIX: #4098 Fixed disappearing table (not really, just in UI) when dragging it and dropping onto SQL Editor.
+- BUGFIX: #4594 Initial (default) colors of current line/query in SQL Editor is fixed to not be just black.
+- BUGFIX: #4140 #4343 Disabling Foreign Keys during execution SQL directly from file.
+- BUGFIX: #4593 Fixed row/column (de)selection on header ctrl+click.
+- BUGFIX: #4596 Fixed thread-safety issue with QtScripting (JavaScript) built-in plugin.
+
+### 3.4.0
+- ADDED: #4058 Added support for RETURNING syntax in INSERT/DELETE/UPDATE and MATERIALIZED syntax in CTE - introduced in SQLite 3.35.
+- ADDED: #4058 Added support for STRICT tables introduced in SQLite 3.37.
+- ADDED: #4058 Added support for -> and ->> operators from SQLite 3.38.
+- ADDED: #4058 Added support for RIGHT, FULL OUTER JOIN, IS (NOT) DISTINCT FROM operators that were introduced in SQLite 3.39.
+- ADDED: #513 Python scripting plugin added, along side with Python syntax highlighting plugin. Requires Python installed in the system to use the plugin.
+- ADDED: #4050 Functions Editor allows marking functions as deterministic (thus using them for GENERATED columns).
+- ADDED: #3615 console.log() function for JS scripts.
+- ADDED: #3503 #3963 SQL Editor has word wrapping option in context menu. It's also available in the configuration dialog.
+- ADDED: #4087 The installer packages are back (powered by VMware InstallBuilder), with proper "Start Menu" entries and SQLite file associations - across all 3 platforms!
+- ADDED: #3291 Filtering in View window (thanks to @electrickite).
+- ADDED: #4103 Windows 32-bit binaries, alongside with 64-bit. With version 3.3.0 Windows binaries were upgraded to 64 bit, but it turns out many people still need 32 bit binaries.
+- ADDED: #3715 Dedicated hotkeys to execute either single query under cursor or all queries in editor, regardless of default execution mode configured. Default hotkeys: Ctrl+F9 (or Cmd+F9) for single query, Shift+F9 for all queries.
+- ADDED: #3714 Added highlighter for current query (under cursor, to be executed), to make the user aware which query is actually going to be executed when Execute Query hotkey is used.
+- ADDED: #4006 Colors configuration for syntax highlighting is reintroduced in a new, improved form.
+- ADDED: #3793 Close windows on the left/right options added to the View menu and Taskbar context menu. Also renamed 'all but selected' to 'other'.
+- ADDED: #4065 Code Snippets - define in dedicated window, use it from the code assistant (hit the assistant hotkey twice).
+- ADDED: #4402 Added context menu option to adjust height of rows according to their contents. Also added single-row adjusting by double-clicking on the row header section on the left.
+- ADDED: #3942 Added option to SQL Export plugin to add IF NOT EXISTS clause to CREATE statements.
+- ADDED: #4249 Added tooltips for WITHOUT ROWID and STRICT checkboxes in the Table Window.
+- ADDED: #4264 Added svg icon to portable packages.
+- ADDED: #3439 Foreign Key dropdown is now available not only in the Grid View, but also in the Form View and the modal Value Editor dialog.
+- ADDED: #3779 Constraint icons on the Structure tab of a Table Window now shows tooltips (on mouse hover) with details of the constraint.
+- ADDED: #3956 Added button for clearing DDL history in the DDL History window.
+- ADDED: #4024 Added feature to the CLI app for executing SQL files directly from the command line, using all SQLiteStudio query executor features.
+- ADDED: #3515 Added option in CSV Import plugin to treat quotation character (") as regular character.
+- ADDED: #4092 Added possibility to increase/decrease font size using Ctrl+MouseWheel or by (configurable) shortcuts Ctrl++ & Ctrl+-. Applicable for SQL Editor, Database List, Status Field, Data View.
+- ADDED: #4217 Added the Invert Selection entry in data grid context menu.
+- ADDED: #4096 Added data grid option for filtering by strict text (not just whether contains, but if actually equals). Old filtering options remain.
+- ADDED: Allow drag and drop a file to the add database dialog.
+- CHANGE: #4058 SQLite updated to 3.39.4 (except for SQLCipher, which has latest version 3.39.2).
+- CHANGE: #3272 Named function parameters of Custom SQL functions are now passed to script code as named variables.
+- CHANGE: #3337 QtScript (deprecated module) usage migrated to QML module, using QJSEngine, the EcmaScript compliant implementation. Also changed plugin language name from QtScript to JavaScript and icon from Qt icon to JS icon.
+- CHANGE: #2963 Application state (session) is saved (apart from normal application exit) whenever the state changes and also during critical application crash.
+- CHANGE: #4083 Added support for regexp literals and template literals in JS syntax highlighter.
+- CHANGE: #4071 #3437 Data column width has now more configuration options, so that it can retain its width upon entered value, or to have header contents (column name) visible.
+- CHANGE: Finalized transition to new model of translation files (using Crowdin). Generation of qm files and updating qrc files is now fully automated.
+- CHANGE: #4300 Db Dialog now has just 1 browse button, but uses Qt file dialog, not native one.
+- CHANGE: Unused the help button in title bar are removed.
+- CHANGE: #4273 Newer opened database is selected by default in the tree.
+- CHANGE: #4240 #4458 #4419 #4129 Removed mechanism that limited initial value loaded to a cell to keep the amount of memory used at safe level. While it served it purpose well, it introduced so many other issues (refer to GitHub issues mentioned for this ChangeLog item), that it was not worth it. If a user keeps lots of gigabytes in a single table and you plan to query it, the user may want to limit amount of rows you query or display at once.
+- CHANGE: #4435 Changed data griv view behavior, so when user clicks once, it will select column/row and if double-clicks, the sorting order is applied.
+- CHANGE: #4088 Changed F2 hotkey, so it enters inline editing of a cell (no longer it opens the config dialog, which now is under F10 key). View Window, Collation Editor, Functions Editor, and Extensions Editor got now Ctrl+S hotkey to commit pending changes.
+- CHANGE: #4341 When testing or accepting database connection in Database Dialog, in case of error, the message is displayed in status field properly, but also shows up in tooltip of the connection error icon.
+- CHANGE: #3439 Compact Layout (that reduces many margins to save working space) is now excluded from the Form View, as it made it only worse.
+- CHANGE: #4538 Linux binaries are now built onUbuntu 22.04 (used to be 20.04).
+- BUGFIX: #4218 Fixed mnemonics ampersand displayed in toolbar button tooltips (they are used for relevant menu items, but in toolbar they caused additional ampersand to be displayed).
+- BUGFIX: #4095 Fixed "per column" filter to apply updated values upon leaving filter input, or resetting it.
+- BUGFIX: #4113 Fixed importing from data sources having less columns than in the target table.
+- BUGFIX: #4207 Fixed crash when populating table with either Random Numbers or Random Text. Big thanks to @jiangzc!
+- BUGFIX: #4093 Fixed foreign key dropdown to execute query asynchronously (and not to block UI for that time) and to not overwrite randomly value that user already typed.
+- BUGFIX: #4177 Fixed Populate Table dialog when there is only one table in the database.
+- BUGFIX: #4148 Fixed selection loss when disconnecting from database.
+- BUGFIX: #4084 Fixed View window refreshing when a dependant table was modified.
+- BUGFIX: Fixed error messages in debug console when executing query with less columns in results than the previously executed query.
+- BUGFIX: Fixed WITHOUT ROWID checkbox updating when table structure changes are rolled back.
+- BUGFIX: Fixed updating data values for a single PK column in WITHOUT ROWID table.
+- BUGFIX: Fixed a bug when a style plugin was missing and style was in use - the config window was being confusedabout it.
+- BUGFIX: #4267 Path now shows familiar backslashes on Windows for Add a database and About dialog.
+- BUGFIX: #4314 Fixed missing OpenSSL license exemptions.
+- BUGFIX: #4433 Fixed loading translations under Linux.
+- BUGFIX: #4447 Fixed AUTOINCREMENT generation of DDL statement for table-level PRIMARY KEY.
+- BUGFIX: #4418 Fixed current editor window deselection after dropping table/view with a query in that editor, which (that table/view) was open in another window, that got closed with the DROP statement.
+- BUGFIX: #4386 Fixed handling database password with an apostrophe.
+- BUGFIX: #4369 WAL mode is now handled properly upon application quit or database disconnection.
+- BUGFIX: #4340 Fixed crash when populating two columns with random text.
+- BUGFIX: #4362 #4363 #4239 Fixed handling object names (i.e. tables) with a usual wrapping characters being part of their name, for example table named [someTable].
+- BUGFIX: #4356 Fixed resolving column names by SelectResolver in rare cases, when the column name is undefined and should be left for SQLite engine to determin.
+- BUGFIX: #4331 Fixed handling object names with # and $ inside.
+- BUGFIX: #4306 Fixed parsing BLOB literals and formatting it back to SQL statements from internal AST.
+- BUGFIX: #4278 Fixed language dropdown being empty sometimes when English language was selected.
+- BUGFUX: #4545 Fixed Dead Keys support under Linux.
+- BUGFIX: #4529 Fixed cooperation with collations defined by ICU extension.
+- BUGFIX: #4534 Configuration Dialog categories list width is now initially adjusted to fit contents.
+- BUGFIX: Schema changes are now properly refreshed in SQL Editors to highlight database object names.
+
 ### 3.3.3
 - CHANGE: #4011 SQLite updated to 3.35.4. SQLite3MultipleCiphers updated to 1.2.4 (SQLite 3.35.4). This enables math functions from 3.35. SQLCipher updated to 4.4.3, which is only SQLite 3.34.1, so no math functions for SQLCipher.
 - CHANGE: #4028 Open databases are now expanded upon startup only if they were expanded during application shutdown.
@@ -35,7 +193,7 @@
 - ADDED: #3975 Database dropdowns added to table & view windows, to it's more clear to which database particular object belongs. The same database dropdown in SQL Editor is moved to the left side, to be more consistent across the application. Main toolbar ha snow way less unnecessary buttons.
 - CHANGE: Windows binaries are now 64-bit.
 - CHANGE: SQLite2 plugin removed due to harder and harder maintenance of SQLite2 library compilation.
-- CHANGE: Minumum Qt version now is 5.12.0.
+- CHANGE: Minimum Qt version now is 5.12.0.
 - CHANGE: #3470 SQLite upgraded to 3.34.1. From now on the core SQLite3 library is bounded together with application (no longer a separate library).
 - CHANGE: #3494 DbSqliteCipher (SQLCipher) upgraded to 4.4.2 (SQLite 3.34.0).
 - CHANGE: #3954 DbSqliteWx plugin migrated to SQLite3MultipleCiphers 1.1.4 (SQLite 3.34.1).
@@ -1362,4 +1520,4 @@
 - BUGFIX: DDL formatting in table window fixed.
 - BUGFIX: Fixed critical error while exporting some data as a XML.
 - BUGFIX: Fixed critical error while some error occured when trying to create trigger.
-- BUGFIX: Fixed critical errors while customizing toolbar.
\ No newline at end of file
+- BUGFIX: Fixed critical errors while customizing toolbar.