Imported Upstream version 3.1.0upstream/3.1.0

1 files changed, 62 insertions, 0 deletions

diff --git a/SQLiteStudio3/coreSQLiteStudio/ChangeLog.txt b/SQLiteStudio3/coreSQLiteStudio/ChangeLog.txt
index 38c2289..a477b8c 100644
--- a/SQLiteStudio3/coreSQLiteStudio/ChangeLog.txt
+++ b/SQLiteStudio3/coreSQLiteStudio/ChangeLog.txt
@@ -1,3 +1,65 @@
+[3.1.0]
+        * [ADDED]: SQLCipher plugin is now free, open source and distributed together with other standard plugins.
+        * [ADDED]: #2963 Indexed expressions for CREATE INDEX statements (introduced in SQLite 3.9) are now supported and can be edited in Index Dialog.
+        * [ADDED]: View window now supports explicit column names for the view (introduced in SQLite 3.9).
+        * [ADDED]: #3056 #3063 Implemented index column ordering in index dialog.
+        * [ADDED]: Added shortcut (Ctrl+/ by default) to toggle comment of current line or selected block of code (if any) in SQL editor.
+        * [ADDED]: #3040 Added new entry in context menu of data grid to generate SELECT/INSERT/UPDATE/DELETE statement together with WHERE clause containing IN conditions for selected cells.
+        * [ADDED]: Added new entry in context menu of database list to generate queries like in #3040 for selected table.
+        * [ADDED]: #2975 Information message after successful table/view change.
+        * [ADDED]: Introduced "loadByDefault" property for plugin descriptor files.
+        * [ADDED]: Added options to have "Data" tab placed as a first tab for Table windows and for View windows. By default option is disabled, so by default nothing changes.
+        * [ADDED]: Added option in configuration dialog to avoid reopening status panel for each message printed there.
+        * [ADDED]: Added option in configuration dialog to prevent displaying tooltips over data view when user holds mouse over it.
+        * [ADDED]: #3070 Added option in configuration dialog to have new databases marked as not permanent by default.
+        * [ADDED]: #3070 Added option in configuration dialog to bypass database dialog completely when dropping file from file manager onto database list.
+        * [ADDED]: #3013 When double clicking on empty space in list of indexes or tables (in table or view window) the action is not ignored, but a dialog opens for adding new item.
+        * [CHANGE]: DbAndroid plugin has now JAR file embedded and you can get it from Tools menu.
+        * [CHANGE]: SQLite version updated to 3.13.0.
+        * [CHANGE]: Qt version updated to 5.6.0. Should still compile with 5.3, but binary distributions on homepage will be made with 5.6.
+        * [CHANGE]: Foreign key dropdown (when editing FK cell) uses now more readable set of columns and column headers can be resized.
+        * [CHANGE]: Column dialog validates scale and precision fields (against INTEGER PRIMARY KEY and against each other).
+        * [CHANGE]: Structure tab in table window has now fully named headers in column list.
+        * [CHANGE]: Table and View window options moved from Look & Feel configuration page to Data Browsing page.
+        * [CHANGE]: All database list options moved to a separate Database List configuration page.
+        * [CHANGE]: Window list in main menu -> "View" -> "Window list" is not sorted alphabetically.
+        * [BUGFIX]: Not loading Android plugin by default (needs manual load from configuration dialog), which stops the "ADB" error for people not using the plugin.
+        * [BUGFIX]: #2927 Several critical bugs fixed and enhancements to table modification algorithm related to foreign keys.
+        * [BUGFIX]: #2954 #2803 #2937 Fixed incorrect recreation of foreign keys chain.
+        * [BUGFIX]: #3008 Editing foreign key cell with more than 10 000 possible values will now use simple text editor, not dropdown. It also loads values asynchronously.
+        * [BUGFIX]: Fixed importing from CSV with some of lines containing less fields than defined in header (or in first data row).
+        * [BUGFIX]: #2989 Fixed multiline value handling in CSV import plugin.
+        * [BUGFIX]: #2921 Fixed empty values as NULL handling in CSV import plugin.
+        * [BUGFIX]: #3034 Fixed handling empty string as value for DEFAULT constraint.
+        * [BUGFIX]: #3064 Fixed locking database executions when counting rows in huge tables.
+        * [BUGFIX]: DbAndroid plugin has fix for null pointer in the JAR when client has disconnected
+        * [BUGFIX]: Error message details were missing in some cases (when smart execution method failed at parsing stage). This is fixed now.
+        * [BUGFIX]: #3026 #3027 #3043 Fixed RAISE() function formatting in enterprise formatter (used to produce invalid SQL).
+        * [BUGFIX]: #3015 Fixed error with DEFAULT constraint containing datetime('now', 'localtime').
+        * [BUGFIX]: #3000 Fixed compilation errors for Qt >= 5.5.
+        * [BUGFIX]: #2956 Fixed unexpected data refresh when clicking in the right side of value filter field in table window.
+        * [BUGFIX]: #2991 #2928 #2929 #2941 #2960 Fixed executing "garbage" query, causing application crash.
+        * [BUGFIX]: #2920 Fixed removing several databases.
+        * [BUGFIX]: #3068 #3066 Fixed database removal confirmation dialog so the message asks about removing it from the list, not deleting it.
+        * [BUGFIX]: #3073 Fixed crash when unloading plugin with its own configuration subpage and saving config dialog.
+        * [BUGFIX]: #2931 #2962 Fixed incorrect results when executing 2-level queries with an expression and an alias combination as a result column definition.
+        * [BUGFIX]: #2942 Fixed deleting multiple tables/indexes/... when selected them and picked "Delete table/index/..." from context menu.
+        * [BUGFIX]: #2945 Fixed manual reordering of database objects with Drag&Drop.
+        * [BUGFIX]: #3055 Fixed crash when exporting on MacOS using plugin that requires column value length information (such as PDF export plugin).
+        * [BUGFIX]: #3047 Fixed copying/moving tables together with indexes or triggers with Drag&Drop across same SQLite version databases.
+        * [BUGFIX]: #3012 SQL simple formatter plugin does not load by default from now on. It is still available, but won't load until manually loaded.
+        * [BUGFIX]: Table window for new table (just created) will now properly close when that table gets deleted immediately by the user.
+        * [BUGFIX]: #2998 Fixed reading decimal values from database when using simple execution method (a fallback in case of some problems).
+        * [BUGFIX]: #2999 Fixed working on objects from database that on the list is named "main".
+        * [BUGFIX]: Fixed error detection when selecting column from incorrect table alias (http://forum.sqlitestudio.pl/viewtopic.php?f=11&t=1051).
+        * [BUGFIX]: #3046 Fixed scale & precision fields in column dialog so it's possible to delete their values from the column.
+        * [BUGFIX]: Vacuum invoked from context menu on database list is now executed in SQL editor and is asynchronous.
+        * [BUGFIX]: #3001 Order of objects exported by Export Dialog is now alphabetical (in object type groups).
+        * [BUGFIX]: #3022 Fixed parsing of some expressions, resulting in this particular bug report in being unable to browse view results.
+        * [BUGFIX]: Enhanced floating point numbers handling.
+        * [BUGFIX]: Fixed formatting of INSERT and UPDATE statements.
+        * [BUGFIX]: Enterprise formatter no longer puts new lines when formating list of elements in "IN" clause.
+
 [3.0.7]
         * [ADDED]: #2951 Implemented dropdown value picking for foreign key columns in grid view.
         * [ADDED]: Context menu entry to go to row in referenced table by current foreign key cell value.