From 81a21e6ce040e7740de86340c8ea4dba30e69bc3 Mon Sep 17 00:00:00 2001 From: Unit 193 Date: Thu, 16 Jan 2025 01:57:37 -0500 Subject: New upstream version 3.4.13+dfsg. --- ChangeLog.md | 87 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ 1 file changed, 87 insertions(+) (limited to 'ChangeLog.md') diff --git a/ChangeLog.md b/ChangeLog.md index a989352..380cf2c 100644 --- a/ChangeLog.md +++ b/ChangeLog.md @@ -1,5 +1,91 @@ # ChangeLog +### 3.4.13 +- BUGFIX: #5183 Fixed completer proposals in the column names of the INSERT INTO statement. +- BUGFIX: #5184 Fixed completer to show tables from implicitly attached database in case of 'SELECT other_database.' +- BUGFIX: System tables (sqlite_*) are now pushed further in the competer proposals. +- BUGFIX: Restored missing completer entries: string, number, BLOB literal. +- BUGFIX: Fixed Linux installer issue related to the logname command on some Linux distributions. + +### 3.4.12 +- BIGFIX: #5179 Fixed results returned from query joining the same table twice. +- BIGFIX: #5179 Fixed smart execution when joining tables with USING clause, so the result metadata is extracted properly and results can be edited. + +### 3.4.11 +- CHANGE: SQLite updated to 3.47.2 +- BUGFIX: #5161 An ultimate fix for dialog windows positioning, so they no longer can appear outside of visible screen. +- BUGFIX: #4882 Fixed Rows Affected counter for huge numbers (over 2 trillion). + +### 3.4.10 +- CHANGE: #5160 The taskbar has been improved to make the currently active task more distinct from the others. +- BUGFIX: #5148 Fixed counting of tables in queries transparently attaching other databases. +- BIGFIX: #5162 Fixed crash when enabling STRICT option in Table Window. +- BIGFIX: Fixed dialog windows positioning, so it's remembered correctly if the dialog is only moved, but not resized. +- BIGFIX: System tables are again being presented on the database list if the app is configured to do so. + +### 3.4.9 +- BUGFIX: #5148 Fixed executing queries that refer to tables with database prefix (i.e. dbName.tableName). +- BUGFIX: #5149 Relaxed recent limitation on requiring Custom SQL Functions to have unique names, so that names can duplicate if input parameters differ. + +### 3.4.8 +- CHANGE: #5146 If user enters a relative file path to the database dialog, a warning will issued to the user pointing out actual resolved path for the relative path entered. +- BUGFIX: #5145 Fixed Extensions Manager crashing the app if the percentile extension was loaded before. The percentile SQLite extension became corrupted in SQLite 3.46.x, then it got fixed, but the fix is not included in SQLite 3.47.1 source package. +- BUGFIX: #5144 Fixed Extensions Manager commit button when all extensions got removed from the list. + +### 3.4.7 +- CHANGE: #5131 SQLite updated to 3.47.1 (except for SQLCipher, which is still on 3.46.1 at the moment). +- BUGFIX: #5119 Fixed very bad performance of import() function executed from SQL Editor. +- BUGFIX: #5124 Fixed ScriptingPython plugin compilation against Python >= 3.12. +- BUGFIX: #5134 Improved performance significantly when working with big values (~1MB per cell) in multiple columns/rows of a table data grid view. +- BUGFIX: #5122 Fixed Linux packages to run properly under Wayland. +- BUGFIX: #5136 Fixed application hanging at quitting when the database is in WAL journaling mode and there is another client still accessing the database. +- BUGFIX: #5135 Counting rows in enormous tables (which can take very long time) no longer blocks the application. + +### 3.4.6 +- BUGFIX: #5114 Fixed black highlighting for current query on systems, where SQLiteStudio was never configured to use theme different than default. +- BUGFIX: #5111 Applied fix for compiling with Python 3.11 (thanks to @mehw). +- BUGFIX: #5115 Fixed smart query executor to work properly if there is an inline subquery in a SELECT result columns. + +### 3.4.5 +- ADDED: #4974 Extension-based collations (like the ICU) can be now registered in databases using Collations Editor window. +- ADDED: #5041 Added support for column list syntax in CREATE VIEW. +- ADDED: #4774 Added checking if data types are matched in both columns while creating foreign column. This applies for Column Dialog Foreign Key, Table Foreign Key and also in the Query Executor (user will receive warning if executed query breaks the Foreign Key data type alignment). +- ADDED: #4928 During exporting data in Export Dialog, the progress bar now shows number of rows already exported in real time (still filesystem may buffer writing operation, so data may appear in the output file with delay). +- ADDED: #5079 Data cell focus and current data page is maintained during data reload. +- CHANGE: #4740 Dialog geometry is saved & restored for several dialog windows (i.e. Import, Export, Populate and more...). +- CHANGE: #4861 When loading SQL script into SQL Editor, contents of current editor are retained. Instead another editor is open to load SQL script, with exception when current editor is empty - in that case it is used for loading. +- CHANGE: #4861 When trying to load SQLite database as SQL script into SQL Editor window, application detects it and opens Database dialog for that file instead. +- CHANGE: #4861 When trying to load huge SQL script (over 10MB) into SQL Editor, user is asked to confirm it. +- BUGFIX: #4828 Fixed Linux installer error 'logname: no login name'. +- BUGFIX: #4761 Fixed current query highligting color to respect configured color, instead of always using default color. Also removed query content selection after execution. +- BUGFIX: #4796 Fixed Database Dialog file selection, so user has clear understanding whether new file is to be created, or existing file to open. Also fixes file selection dialog on MacOS when creating new database file. +- BUGFIX: #4819 Fixed sorting order cached in data view when executing query with less columns than previously. +- BUGFIX: #4846 Fixed crash when using NOT NULL DEFERRABLE INITIALLY DEFERRED. +- BUGFIX: #3454 German translation fixes. +- BUGFIX: #4835 Fixed detecting cell value change (to enable commit button) when erasing cell with BLOB value starting with null byte. +- BUGFIX: #4842 Fixed querying ROWID column from tables. It no longer causes issues with editing query result data. +- BUGFIX: #4844 Fixed moving/copying Views from one base to another using drag&drop or copy&paste. +- BUGFIX: #4861 Fixed application freezing when loading big files into SQL editor (over 1MB or bigger). Now it can work with huge files, although all smart helpers (e.g. syntax highlighting, etc) are disabled in such window. +- BUGFIX: #4872 Fixed executing SQL directly from file, so it does not skip CREATE TRIEGGER statements. +- BUGFIX: #4871 Fixed executing SQL directly from file, so it no longer disables foreign key checks during execution. +- BUGFIX: #4874 Fixed Foreign Key dropdown in data grid when foreign key references 2 different tables with same foreign column name in both referenced tables. +- BUGFIX: Fixed tiny memory leak in the import() function. +- BUGFIX: Fixed import() function options parser, so it no longer overwrites import plugin configuration with incorrect types of configuration values (i.e. string 'true' instead of expected boolean). +- BUGFIX: #5096 Fixed executing large DDL scripts (more than 100 DDL statements) with CREATE TRIGGER in them. +- BUGFIX: #4831 Fixed warning message of forbidded cell edition when trying to do it on a multi-level View results, where the View was given an alias name. Now the warning is clear about forbidden edition due to multi-level View. +- BUGFIX: #5077 Fixed question dialog for going back to structure tab if there are uncommited structure changes (thanks to @marcpley). +- BUGFIX: #5076 Fixed broken order of data insertion when adding new row to a table with GENERATED column (thanks to @marcpley). +- BUGFIX: #4949 Added extra calls for cleaning up WAL files upon application exit. +- BUGFIX: #4934 Fixed copying (drag&drop or copy&paste) tables between databases when a column in the table requires quoting due to being a keyword. +- BUGFIX: #5076 Fixed unchecking Named Constraint option in constraint configuration (thanks to @marcpley). +- BUGFIX: #5083 Improved cell editing behavior, so entering edition with Enter key or mouse Double-Click no longer preselects whole value. +- BUGFIX: #5091 Fixed custom SQL functions editor to prevent duplicated argument names. Also fixed correct argumentName-to-value assignment if arguments share same initial part of their name. Also fixed handling of differnt type of arguments passed to custom SQL function. +- BUGFIX: #5074 #5082 #5083 Fixed cell editing to preselect proper FK value from dropdown, to correctly load cell value if it containts single quote character and to have proper content selection depending on how editing is triggered. +- BUGFIX: #5082 When editing FK value inline (not from dropdown), the autocompleted value also updates selection of item in the dropdown (yet to be shown if user chooses so). This also fixes up/down keyboard navigation basing on autocompleted value. +- BUGFIX: #4959 GitHub Actions Linux build: include qt5-qtwayland to fix segfault in AlmaLinux 9.3 (thanks to @tuffnatty). +- BUGFIX: #4980 Bunch of SchemaResolver optimizations, resulting in huge performance boost when opening/modifying databases with thousands of tables (from minutes down to milliseconds for opening database with ~6000 tables). +- BUGFIX: #5065 Improved handling of columns named 'true' or 'false', which are allowed in SQLite, but are treated in a very unusual way by SQLite. + ### 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. @@ -251,6 +337,7 @@ - BUGFIX: #3787 Field state indicator now shows popup (the message) immediately after pointing it with a mouse, instead of having a delay. - BUGFIX: #3550 After successful data import, a number of rows imported is included in the notification message. - BUGFIX: #3415 Fixed release build scripts on all platforms. +- BUGFIX: Fixed data grid filtering in views that use table-valued functions as data source. ### 3.2.1 - BUGFIX: #3399 Fixed start under Linux using the pre-compiled binary distributions (it used to fail due to missing xcb dependency). -- cgit v1.2.3