sqlitestudio
sqlitestudio copied to clipboard
Published
20 hours ago •
pawelsalawa
pawelsalawa
Crash instantly with `NOT NULL DEFERRABLE INITIALLY DEFERRED`
Details
GUI crashes instantly. CLI does not instantly crash, can see tree etc. Works fine in other programs. It is valid sqlite I assume since sqlite3 will create it with no problem
Steps to reproduce
CREATE TABLE test(t INTEGER NOT NULL DEFERRABLE INITIALLY DEFERRED);
sqlite3 mydb.sqlite
SQLite version 3.42.0 2023-05-16 12:36:15
Enter ".help" for usage hints.
sqlite> CREATE TABLE test(t INTEGER NOT NULL DEFERRABLE INITIALLY DEFERRED);
sqlite> .tables
test
sqlite> .quit
sqlitestudio.exe .\mydb.sqlite
Instant crash
Log after crash
[23:58:52.568] DEBUG: "SQL CompletionHelper::init()> PRAGMA function_list;" (flags: "" )
[23:58:52.568] DEBUG: "SQL CompletionHelper::init()> PRAGMA pragma_list;" (flags: "" )
[23:58:52.569] DEBUG: "SQL SQLiteStudio settings> SELECT * FROM sqlite_master" (flags: "" )
[23:58:52.570] DEBUG: Using configuration directory: C:\Users\andys-pc\AppData\Local\SalSoft\SQLiteStudio
[23:58:52.570] DEBUG: "SQL SQLiteStudio settings> PRAGMA foreign_keys = 1;" (flags: "" )
[23:58:52.570] DEBUG: "SQL SQLiteStudio settings> SELECT lower(name) AS name FROM sqlite_master WHERE type = 'table'" (flags: "" )
[23:58:52.570] DEBUG: "SQL SQLiteStudio settings> SELECT version FROM version LIMIT 1" (flags: "" )
[23:58:52.570] DEBUG: "SQL SQLiteStudio settings> SELECT sqlite_version()" (flags: "" )
[23:58:52.570] DEBUG: "SQL SQLiteStudio settings> SELECT value FROM settings WHERE [group] = ? AND [key] = ?" (flags: "" )
[23:58:52.570] DEBUG: SQL arg> 0 = QVariant(QString, "General")
[23:58:52.570] DEBUG: SQL arg> 1 = QVariant(QString, "Language")
[23:58:52.572] DEBUG: "SQL SQLiteStudio settings> SELECT name, path, options FROM dblist" (flags: "" )
[23:58:52.572] DEBUG: "SQL SQLiteStudio settings> SELECT value FROM settings WHERE [group] = ? AND [key] = ?" (flags: "" )
[23:58:52.572] DEBUG: SQL arg> 0 = QVariant(QString, "Internal")
[23:58:52.572] DEBUG: SQL arg> 1 = QVariant(QString, "Functions")
[23:58:52.572] DEBUG: "SQL SQLiteStudio settings> SELECT value FROM settings WHERE [group] = ? AND [key] = ?" (flags: "" )
[23:58:52.572] DEBUG: SQL arg> 0 = QVariant(QString, "Internal")
[23:58:52.572] DEBUG: SQL arg> 1 = QVariant(QString, "Collations")
[23:58:52.572] DEBUG: "SQL SQLiteStudio settings> SELECT value FROM settings WHERE [group] = ? AND [key] = ?" (flags: "" )
[23:58:52.572] DEBUG: SQL arg> 0 = QVariant(QString, "Internal")
[23:58:52.572] DEBUG: SQL arg> 1 = QVariant(QString, "Extensions")
[23:58:52.573] DEBUG: SQLite extension: "C:/Users/andys-pc/scoop/apps/sqlitestudio/current/ext/compress.dll"
[23:58:52.573] DEBUG: SQLite extension: "C:/Users/andys-pc/scoop/apps/sqlitestudio/current/ext/csv.dll"
[23:58:52.573] DEBUG: SQLite extension: "C:/Users/andys-pc/scoop/apps/sqlitestudio/current/ext/decimal.dll"
[23:58:52.573] DEBUG: SQLite extension: "C:/Users/andys-pc/scoop/apps/sqlitestudio/current/ext/eval.dll"
[23:58:52.573] DEBUG: SQLite extension: "C:/Users/andys-pc/scoop/apps/sqlitestudio/current/ext/icu.dll"
[23:58:52.573] DEBUG: SQLite extension: "C:/Users/andys-pc/scoop/apps/sqlitestudio/current/ext/ieee754.dll"
[23:58:52.573] DEBUG: SQLite extension: "C:/Users/andys-pc/scoop/apps/sqlitestudio/current/ext/percentile.dll"
[23:58:52.573] DEBUG: SQLite extension: "C:/Users/andys-pc/scoop/apps/sqlitestudio/current/ext/rot13.dll"
[23:58:52.573] DEBUG: SQLite extension: "C:/Users/andys-pc/scoop/apps/sqlitestudio/current/ext/series.dll"
[23:58:52.573] DEBUG: SQLite extension: "C:/Users/andys-pc/scoop/apps/sqlitestudio/current/ext/sqlar.dll"
[23:58:52.573] DEBUG: SQLite extension: "C:/Users/andys-pc/scoop/apps/sqlitestudio/current/ext/uint.dll"
[23:58:52.573] DEBUG: SQLite extension: "C:/Users/andys-pc/scoop/apps/sqlitestudio/current/ext/uuid.dll"
[23:58:52.573] DEBUG: SQLite extension: "C:/Users/andys-pc/scoop/apps/sqlitestudio/current/ext/zorder.dll"
[23:58:52.573] DEBUG: "SQL > PRAGMA foreign_keys = 1;" (flags: "" )
[23:58:52.573] DEBUG: "SQL > PRAGMA recursive_triggers = 1;" (flags: "" )
[23:58:52.573] DEBUG: "SQL > SELECT * FROM sqlite_master" (flags: "" )
[23:58:52.574] DEBUG: "SQL SQLiteStudio settings> SELECT value FROM settings WHERE [group] = ? AND [key] = ?" (flags: "" )
[23:58:52.574] DEBUG: SQL arg> 0 = QVariant(QString, "Internal")
[23:58:52.574] DEBUG: SQL arg> 1 = QVariant(QString, "CodeSnippets")
[23:58:52.574] DEBUG: "SQL SQLiteStudio settings> SELECT value FROM settings WHERE [group] = ? AND [key] = ?" (flags: "" )
[23:58:52.574] DEBUG: SQL arg> 0 = QVariant(QString, "Internal")
[23:58:52.574] DEBUG: SQL arg> 1 = QVariant(QString, "DefaultSnippetsCreated")
[23:58:52.602] DEBUG: "SQL SQLiteStudio settings> SELECT value FROM settings WHERE [group] = ? AND [key] = ?" (flags: "" )
[23:58:52.602] DEBUG: SQL arg> 0 = QVariant(QString, "General")
[23:58:52.602] DEBUG: SQL arg> 1 = QVariant(QString, "DataViewTabs")
[23:58:52.623] DEBUG: "SQL SQLiteStudio settings> SELECT value FROM settings WHERE [group] = ? AND [key] = ?" (flags: "" )
[23:58:52.623] DEBUG: SQL arg> 0 = QVariant(QString, "General")
[23:58:52.623] DEBUG: SQL arg> 1 = QVariant(QString, "DockLayout")
[23:58:52.629] DEBUG: "SQL SQLiteStudio settings> SELECT value FROM settings WHERE [group] = ? AND [key] = ?" (flags: "" )
[23:58:52.629] DEBUG: SQL arg> 0 = QVariant(QString, "General")
[23:58:52.629] DEBUG: SQL arg> 1 = QVariant(QString, "CompactLayout")
[23:58:52.630] DEBUG: "SQL SQLiteStudio settings> SELECT value FROM settings WHERE [group] = ? AND [key] = ?" (flags: "" )
[23:58:52.630] DEBUG: SQL arg> 0 = QVariant(QString, "ShortcutsCategoryDbTree")
[23:58:52.630] DEBUG: SQL arg> 1 = QVariant(QString, "DEL_SELECTED")
[23:58:52.630] DEBUG: "SQL SQLiteStudio settings> SELECT value FROM settings WHERE [group] = ? AND [key] = ?" (flags: "" )
[23:58:52.630] DEBUG: SQL arg> 0 = QVariant(QString, "ShortcutsCategoryDbTree")
[23:58:52.630] DEBUG: SQL arg> 1 = QVariant(QString, "SELECT_ALL")
[23:58:52.630] DEBUG: "SQL SQLiteStudio settings> SELECT value FROM settings WHERE [group] = ? AND [key] = ?" (flags: "" )
[23:58:52.630] DEBUG: SQL arg> 0 = QVariant(QString, "ShortcutsCategoryDbTree")
[23:58:52.630] DEBUG: SQL arg> 1 = QVariant(QString, "PASTE")
[23:58:52.630] DEBUG: "SQL SQLiteStudio settings> SELECT value FROM settings WHERE [group] = ? AND [key] = ?" (flags: "" )
[23:58:52.630] DEBUG: SQL arg> 0 = QVariant(QString, "ShortcutsCategoryDbTree")
[23:58:52.630] DEBUG: SQL arg> 1 = QVariant(QString, "COPY")
[23:58:52.631] DEBUG: "SQL SQLiteStudio settings> SELECT value FROM settings WHERE [group] = ? AND [key] = ?" (flags: "" )
[23:58:52.631] DEBUG: SQL arg> 0 = QVariant(QString, "ShortcutsCategoryDbTree")
[23:58:52.631] DEBUG: SQL arg> 1 = QVariant(QString, "ADD_DB")
[23:58:52.631] DEBUG: "SQL SQLiteStudio settings> SELECT value FROM settings WHERE [group] = ? AND [key] = ?" (flags: "" )
[23:58:52.631] DEBUG: SQL arg> 0 = QVariant(QString, "ShortcutsCategoryDbTree")
[23:58:52.631] DEBUG: SQL arg> 1 = QVariant(QString, "DECR_FONT_SIZE")
[23:58:52.631] DEBUG: "SQL SQLiteStudio settings> SELECT value FROM settings WHERE [group] = ? AND [key] = ?" (flags: "" )
[23:58:52.631] DEBUG: SQL arg> 0 = QVariant(QString, "ShortcutsCategoryDbTree")
[23:58:52.631] DEBUG: SQL arg> 1 = QVariant(QString, "INCR_FONT_SIZE")
[23:58:52.631] DEBUG: "SQL SQLiteStudio settings> SELECT value FROM settings WHERE [group] = ? AND [key] = ?" (flags: "" )
[23:58:52.631] DEBUG: SQL arg> 0 = QVariant(QString, "ShortcutsCategoryDbTree")
[23:58:52.631] DEBUG: SQL arg> 1 = QVariant(QString, "REFRESH_SCHEMAS")
[23:58:52.631] DEBUG: "SQL SQLiteStudio settings> SELECT value FROM settings WHERE [group] = ? AND [key] = ?" (flags: "" )
[23:58:52.631] DEBUG: SQL arg> 0 = QVariant(QString, "ShortcutsCategoryDbTree")
[23:58:52.631] DEBUG: SQL arg> 1 = QVariant(QString, "CLEAR_FILTER")
[23:58:52.631] DEBUG: "SQL SQLiteStudio settings> SELECT value FROM settings WHERE [group] = ? AND [key] = ?" (flags: "" )
[23:58:52.631] DEBUG: SQL arg> 0 = QVariant(QString, "ShortcutsCategoryDbTree")
[23:58:52.631] DEBUG: SQL arg> 1 = QVariant(QString, "REFRESH_SCHEMA")
[23:58:52.631] DEBUG: "SQL SQLiteStudio settings> SELECT id, name, [order], open, dbname, db_expanded FROM groups WHERE parent IS NULL ORDER BY [order]" (flags: "" )
[23:58:52.632] DEBUG: "SQL SQLiteStudio settings> SELECT id, name, [order], open, dbname, db_expanded FROM groups WHERE parent = ? ORDER BY [order]" (flags: "" )
[23:58:52.632] DEBUG: SQL arg> 0 = QVariant(qlonglong, 38)
[23:58:52.897] DEBUG: "SQL SQLiteStudio settings> SELECT value FROM settings WHERE [group] = ? AND [key] = ?" (flags: "" )
[23:58:52.897] DEBUG: SQL arg> 0 = QVariant(QString, "ShortcutsCategoryMainWindow")
[23:58:52.897] DEBUG: SQL arg> 1 = QVariant(QString, "OPEN_DEBUG_CONSOLE")
[23:58:52.898] DEBUG: "SQL SQLiteStudio settings> SELECT value FROM settings WHERE [group] = ? AND [key] = ?" (flags: "" )
[23:58:52.898] DEBUG: SQL arg> 0 = QVariant(QString, "ShortcutsCategoryMainWindow")
[23:58:52.898] DEBUG: SQL arg> 1 = QVariant(QString, "OPEN_FUNCTION_EDITOR")
[23:58:52.898] DEBUG: "SQL SQLiteStudio settings> SELECT value FROM settings WHERE [group] = ? AND [key] = ?" (flags: "" )
[23:58:52.898] DEBUG: SQL arg> 0 = QVariant(QString, "ShortcutsCategoryMainWindow")
[23:58:52.898] DEBUG: SQL arg> 1 = QVariant(QString, "OPEN_SNIPPETS_EDITOR")
[23:58:52.898] DEBUG: "SQL SQLiteStudio settings> SELECT value FROM settings WHERE [group] = ? AND [key] = ?" (flags: "" )
[23:58:52.898] DEBUG: SQL arg> 0 = QVariant(QString, "ShortcutsCategoryMainWindow")
[23:58:52.898] DEBUG: SQL arg> 1 = QVariant(QString, "OPEN_DDL_HISTORY")
[23:58:52.898] DEBUG: "SQL SQLiteStudio settings> SELECT value FROM settings WHERE [group] = ? AND [key] = ?" (flags: "" )
[23:58:52.898] DEBUG: SQL arg> 0 = QVariant(QString, "ShortcutsCategoryMainWindow")
[23:58:52.898] DEBUG: SQL arg> 1 = QVariant(QString, "OPEN_CONFIG")
[23:58:52.898] DEBUG: "SQL SQLiteStudio settings> SELECT value FROM settings WHERE [group] = ? AND [key] = ?" (flags: "" )
[23:58:52.898] DEBUG: SQL arg> 0 = QVariant(QString, "ShortcutsCategoryMainWindow")
[23:58:52.898] DEBUG: SQL arg> 1 = QVariant(QString, "OPEN_EXTENSION_MANAGER")
[23:58:52.898] DEBUG: "SQL SQLiteStudio settings> SELECT value FROM settings WHERE [group] = ? AND [key] = ?" (flags: "" )
[23:58:52.898] DEBUG: SQL arg> 0 = QVariant(QString, "ShortcutsCategoryMainWindow")
[23:58:52.898] DEBUG: SQL arg> 1 = QVariant(QString, "OPEN_COLLATION_EDITOR")
[23:58:52.898] DEBUG: "SQL SQLiteStudio settings> SELECT value FROM settings WHERE [group] = ? AND [key] = ?" (flags: "" )
[23:58:52.898] DEBUG: SQL arg> 0 = QVariant(QString, "ShortcutsCategoryMainWindow")
[23:58:52.898] DEBUG: SQL arg> 1 = QVariant(QString, "HIDE_STATUS_FIELD")
[23:58:52.899] DEBUG: "SQL SQLiteStudio settings> SELECT value FROM settings WHERE [group] = ? AND [key] = ?" (flags: "" )
[23:58:52.899] DEBUG: SQL arg> 0 = QVariant(QString, "ShortcutsCategoryMainWindow")
[23:58:52.899] DEBUG: SQL arg> 1 = QVariant(QString, "PREV_TASK")
[23:58:52.899] DEBUG: "SQL SQLiteStudio settings> SELECT value FROM settings WHERE [group] = ? AND [key] = ?" (flags: "" )
[23:58:52.899] DEBUG: SQL arg> 0 = QVariant(QString, "ShortcutsCategoryMainWindow")
[23:58:52.899] DEBUG: SQL arg> 1 = QVariant(QString, "QUIT")
[23:58:52.899] DEBUG: "SQL SQLiteStudio settings> SELECT value FROM settings WHERE [group] = ? AND [key] = ?" (flags: "" )
[23:58:52.899] DEBUG: SQL arg> 0 = QVariant(QString, "ShortcutsCategoryMainWindow")
[23:58:52.899] DEBUG: SQL arg> 1 = QVariant(QString, "NEXT_TASK")
[23:58:52.899] DEBUG: "SQL SQLiteStudio settings> SELECT value FROM settings WHERE [group] = ? AND [key] = ?" (flags: "" )
[23:58:52.899] DEBUG: SQL arg> 0 = QVariant(QString, "ShortcutsCategoryMainWindow")
[23:58:52.899] DEBUG: SQL arg> 1 = QVariant(QString, "OPEN_SQL_EDITOR")
[23:58:52.899] DEBUG: "SQL SQLiteStudio settings> SELECT value FROM settings WHERE [group] = ? AND [key] = ?" (flags: "" )
[23:58:52.899] DEBUG: SQL arg> 0 = QVariant(QString, "ShortcutsCategoryMainWindow")
[23:58:52.899] DEBUG: SQL arg> 1 = QVariant(QString, "USER_MANUAL")
[23:58:52.899] DEBUG: "SQL SQLiteStudio settings> SELECT value FROM settings WHERE [group] = ? AND [key] = ?" (flags: "" )
[23:58:52.899] DEBUG: SQL arg> 0 = QVariant(QString, "ShortcutsCategoryMainWindow")
[23:58:52.899] DEBUG: SQL arg> 1 = QVariant(QString, "OPEN_CSS_CONSOLE")
[23:58:52.899] DEBUG: "SQL SQLiteStudio settings> SELECT value FROM settings WHERE [group] = ? AND [key] = ?" (flags: "" )
[23:58:52.899] DEBUG: SQL arg> 0 = QVariant(QString, "ShortcutsCategoryMainWindow")
[23:58:52.899] DEBUG: SQL arg> 1 = QVariant(QString, "ABOUT")
[23:58:52.900] DEBUG: "SQL SQLiteStudio settings> SELECT value FROM settings WHERE [group] = ? AND [key] = ?" (flags: "" )
[23:58:52.900] DEBUG: SQL arg> 0 = QVariant(QString, "Colors")
[23:58:52.900] DEBUG: SQL arg> 1 = QVariant(QString, "SyntaxForegroundCustom")
[23:58:52.900] DEBUG: "SQL SQLiteStudio settings> SELECT value FROM settings WHERE [group] = ? AND [key] = ?" (flags: "" )
[23:58:52.900] DEBUG: SQL arg> 0 = QVariant(QString, "Colors")
[23:58:52.900] DEBUG: SQL arg> 1 = QVariant(QString, "SyntaxStringFgCustom")
[23:58:52.901] DEBUG: "SQL SQLiteStudio settings> SELECT value FROM settings WHERE [group] = ? AND [key] = ?" (flags: "" )
[23:58:52.901] DEBUG: SQL arg> 0 = QVariant(QString, "Colors")
[23:58:52.901] DEBUG: SQL arg> 1 = QVariant(QString, "SyntaxKeywordFgCustom")
[23:58:52.901] DEBUG: "SQL SQLiteStudio settings> SELECT value FROM settings WHERE [group] = ? AND [key] = ?" (flags: "" )
[23:58:52.901] DEBUG: SQL arg> 0 = QVariant(QString, "Colors")
[23:58:52.901] DEBUG: SQL arg> 1 = QVariant(QString, "SyntaxBindParamFgCustom")
[23:58:52.901] DEBUG: "SQL SQLiteStudio settings> SELECT value FROM settings WHERE [group] = ? AND [key] = ?" (flags: "" )
[23:58:52.901] DEBUG: SQL arg> 0 = QVariant(QString, "Colors")
[23:58:52.901] DEBUG: SQL arg> 1 = QVariant(QString, "SyntaxBlobFgCustom")
[23:58:52.901] DEBUG: "SQL SQLiteStudio settings> SELECT value FROM settings WHERE [group] = ? AND [key] = ?" (flags: "" )
[23:58:52.901] DEBUG: SQL arg> 0 = QVariant(QString, "Colors")
[23:58:52.901] DEBUG: SQL arg> 1 = QVariant(QString, "SyntaxCommentFgCustom")
[23:58:52.901] DEBUG: "SQL SQLiteStudio settings> SELECT value FROM settings WHERE [group] = ? AND [key] = ?" (flags: "" )
[23:58:52.901] DEBUG: SQL arg> 0 = QVariant(QString, "Colors")
[23:58:52.901] DEBUG: SQL arg> 1 = QVariant(QString, "SyntaxNumberFgCustom")
[23:58:52.901] DEBUG: "SQL SQLiteStudio settings> SELECT value FROM settings WHERE [group] = ? AND [key] = ?" (flags: "" )
[23:58:52.901] DEBUG: SQL arg> 0 = QVariant(QString, "Fonts")
[23:58:52.901] DEBUG: SQL arg> 1 = QVariant(QString, "StatusField")
[23:58:52.901] DEBUG: "SQL SQLiteStudio settings> SELECT value FROM settings WHERE [group] = ? AND [key] = ?" (flags: "" )
[23:58:52.901] DEBUG: SQL arg> 0 = QVariant(QString, "General")
[23:58:52.901] DEBUG: SQL arg> 1 = QVariant(QString, "AutoOpenStatusField")
[23:58:52.906] DEBUG: "SQL SQLiteStudio settings> SELECT value FROM settings WHERE [group] = ? AND [key] = ?" (flags: "" )
[23:58:52.906] DEBUG: SQL arg> 0 = QVariant(QString, "General")
[23:58:52.906] DEBUG: SQL arg> 1 = QVariant(QString, "AllowMultipleSessions")
[23:58:52.906] DEBUG: "SQL SQLiteStudio settings> SELECT value FROM settings WHERE [group] = ? AND [key] = ?" (flags: "" )
[23:58:52.906] DEBUG: SQL arg> 0 = QVariant(QString, "Fonts")
[23:58:52.906] DEBUG: SQL arg> 1 = QVariant(QString, "SqlEditor")
[23:58:52.907] DEBUG: "SQL SQLiteStudio settings> SELECT value FROM settings WHERE [group] = ? AND [key] = ?" (flags: "" )
[23:58:52.907] DEBUG: SQL arg> 0 = QVariant(QString, "Fonts")
[23:58:52.907] DEBUG: SQL arg> 1 = QVariant(QString, "DataView")
[23:58:52.907] DEBUG: "SQL SQLiteStudio settings> SELECT value FROM settings WHERE [group] = ? AND [key] = ?" (flags: "" )
[23:58:52.907] DEBUG: SQL arg> 0 = QVariant(QString, "Fonts")
[23:58:52.907] DEBUG: SQL arg> 1 = QVariant(QString, "DbTree")
[23:58:52.907] DEBUG: "SQL SQLiteStudio settings> SELECT value FROM settings WHERE [group] = ? AND [key] = ?" (flags: "" )
[23:58:52.907] DEBUG: SQL arg> 0 = QVariant(QString, "Fonts")
[23:58:52.907] DEBUG: SQL arg> 1 = QVariant(QString, "DbTreeLabel")
[23:58:52.907] DEBUG: "SQL SQLiteStudio settings> SELECT value FROM settings WHERE [group] = ? AND [key] = ?" (flags: "" )
[23:58:52.907] DEBUG: SQL arg> 0 = QVariant(QString, "General")
[23:58:52.907] DEBUG: SQL arg> 1 = QVariant(QString, "InsertRowPlacement")
[23:58:52.908] DEBUG: "SQL SQLiteStudio settings> SELECT value FROM settings WHERE [group] = ? AND [key] = ?" (flags: "" )
[23:58:52.908] DEBUG: SQL arg> 0 = QVariant(QString, "General")
[23:58:52.908] DEBUG: SQL arg> 1 = QVariant(QString, "SqlEditorTabs")
[23:58:52.908] DEBUG: "SQL SQLiteStudio settings> SELECT value FROM settings WHERE [group] = ? AND [key] = ?" (flags: "" )
[23:58:52.908] DEBUG: SQL arg> 0 = QVariant(QString, "General")
[23:58:52.908] DEBUG: SQL arg> 1 = QVariant(QString, "SqlEditorWrapWords")
[23:58:52.919] DEBUG: Following plugins found: ("ConfigMigration", "PythonSyntaxHighlighterPlugin", "ScriptingPython", "Printing", "MultiEditorImagePlugin", "CsvImport", "RegExpImport", "CsvExport", "SqlExport", "DbSqliteCipher", "JsonExport", "ScriptingTcl", "SqlFormatterSimplePlugin", "PdfExport", "SqlEnterpriseFormatter", "XmlExport", "DbSqliteWx", "DbAndroid", "HtmlExport")
[23:58:52.919] DEBUG: "SQL SQLiteStudio settings> SELECT value FROM settings WHERE [group] = ? AND [key] = ?" (flags: "" )
[23:58:52.919] DEBUG: SQL arg> 0 = QVariant(QString, "General")
[23:58:52.919] DEBUG: SQL arg> 1 = QVariant(QString, "LoadedPlugins")
[23:58:52.920] DEBUG: "SQL SQLiteStudio settings> SELECT value FROM settings WHERE [group] = ? AND [key] = ?" (flags: "" )
[23:58:52.920] DEBUG: SQL arg> 0 = QVariant(QString, "CfgMigration")
[23:58:52.920] DEBUG: SQL arg> 1 = QVariant(QString, "Migrated")
[23:58:52.921] DEBUG: ConfigMigration loaded: C:\Users\andys-pc\scoop\apps\sqlitestudio\current\plugins\ConfigMigration.dll
[23:58:52.922] DEBUG: PythonSyntaxHighlighterPlugin loaded: C:\Users\andys-pc\scoop\apps\sqlitestudio\current\plugins\PythonSyntaxHighlighter.dll
[23:58:52.923] DEBUG: PdfExport loaded: C:\Users\andys-pc\scoop\apps\sqlitestudio\current\plugins\PdfExport.dll
[23:58:52.926] DEBUG: Printing loaded: C:\Users\andys-pc\scoop\apps\sqlitestudio\current\plugins\Printing.dll
[23:58:52.927] DEBUG: MultiEditorImagePlugin loaded: C:\Users\andys-pc\scoop\apps\sqlitestudio\current\plugins\MultiEditorImage.dll
[23:58:52.927] DEBUG: CsvImport loaded: C:\Users\andys-pc\scoop\apps\sqlitestudio\current\plugins\CsvImport.dll
[23:58:52.929] DEBUG: RegExpImport loaded: C:\Users\andys-pc\scoop\apps\sqlitestudio\current\plugins\RegExpImport.dll
[23:58:52.930] DEBUG: CsvExport loaded: C:\Users\andys-pc\scoop\apps\sqlitestudio\current\plugins\CsvExport.dll
[23:58:52.931] DEBUG: SqlExport loaded: C:\Users\andys-pc\scoop\apps\sqlitestudio\current\plugins\SqlExport.dll
[23:58:52.932] DEBUG: DbSqliteCipher loaded: C:\Users\andys-pc\scoop\apps\sqlitestudio\current\plugins\DbSqliteCipher.dll
[23:58:52.934] DEBUG: JsonExport loaded: C:\Users\andys-pc\scoop\apps\sqlitestudio\current\plugins\JsonExport.dll
[23:58:52.938] DEBUG: ScriptingTcl loaded: C:\Users\andys-pc\scoop\apps\sqlitestudio\current\plugins\ScriptingTcl.dll
[23:58:52.939] DEBUG: "SQL SQLiteStudio settings> SELECT value FROM settings WHERE [group] = ? AND [key] = ?" (flags: "" )
[23:58:52.939] DEBUG: SQL arg> 0 = QVariant(QString, "SqlEnterpriseFormatter")
[23:58:52.939] DEBUG: SQL arg> 1 = QVariant(QString, "PrefferedWrapper")
[23:58:52.940] DEBUG: "SQL SQLiteStudio settings> SELECT value FROM settings WHERE [group] = ? AND [key] = ?" (flags: "" )
[23:58:52.940] DEBUG: SQL arg> 0 = QVariant(QString, "SqlEnterpriseFormatter")
[23:58:52.940] DEBUG: SQL arg> 1 = QVariant(QString, "UppercaseKeywords")
[23:58:52.940] DEBUG: "SQL SQLiteStudio settings> SELECT value FROM settings WHERE [group] = ? AND [key] = ?" (flags: "" )
[23:58:52.940] DEBUG: SQL arg> 0 = QVariant(QString, "SqlEnterpriseFormatter")
[23:58:52.940] DEBUG: SQL arg> 1 = QVariant(QString, "NlAfterJoinStmt")
[23:58:52.940] DEBUG: "SQL SQLiteStudio settings> SELECT value FROM settings WHERE [group] = ? AND [key] = ?" (flags: "" )
[23:58:52.940] DEBUG: SQL arg> 0 = QVariant(QString, "SqlEnterpriseFormatter")
[23:58:52.940] DEBUG: SQL arg> 1 = QVariant(QString, "SpaceBeforeOpenPar")
[23:58:52.940] DEBUG: "SQL SQLiteStudio settings> SELECT value FROM settings WHERE [group] = ? AND [key] = ?" (flags: "" )
[23:58:52.940] DEBUG: SQL arg> 0 = QVariant(QString, "SqlEnterpriseFormatter")
[23:58:52.940] DEBUG: SQL arg> 1 = QVariant(QString, "SpaceAfterOpenPar")
[23:58:52.940] DEBUG: "SQL SQLiteStudio settings> SELECT value FROM settings WHERE [group] = ? AND [key] = ?" (flags: "" )
[23:58:52.940] DEBUG: SQL arg> 0 = QVariant(QString, "SqlEnterpriseFormatter")
[23:58:52.940] DEBUG: SQL arg> 1 = QVariant(QString, "NlBeforeOpenParExpr")
[23:58:52.940] DEBUG: "SQL SQLiteStudio settings> SELECT value FROM settings WHERE [group] = ? AND [key] = ?" (flags: "" )
[23:58:52.940] DEBUG: SQL arg> 0 = QVariant(QString, "SqlEnterpriseFormatter")
[23:58:52.940] DEBUG: SQL arg> 1 = QVariant(QString, "NlAfterOpenParExpr")
[23:58:52.941] DEBUG: "SQL SQLiteStudio settings> SELECT value FROM settings WHERE [group] = ? AND [key] = ?" (flags: "" )
[23:58:52.941] DEBUG: SQL arg> 0 = QVariant(QString, "SqlEnterpriseFormatter")
[23:58:52.941] DEBUG: SQL arg> 1 = QVariant(QString, "SpaceBeforeMathOp")
[23:58:52.941] DEBUG: "SQL SQLiteStudio settings> SELECT value FROM settings WHERE [group] = ? AND [key] = ?" (flags: "" )
[23:58:52.941] DEBUG: SQL arg> 0 = QVariant(QString, "SqlEnterpriseFormatter")
[23:58:52.941] DEBUG: SQL arg> 1 = QVariant(QString, "SpaceAfterMathOp")
[23:58:52.941] DEBUG: "SQL SQLiteStudio settings> SELECT value FROM settings WHERE [group] = ? AND [key] = ?" (flags: "" )
[23:58:52.941] DEBUG: SQL arg> 0 = QVariant(QString, "SqlEnterpriseFormatter")
[23:58:52.941] DEBUG: SQL arg> 1 = QVariant(QString, "SpaceBeforeClosePar")
[23:58:52.941] DEBUG: "SQL SQLiteStudio settings> SELECT value FROM settings WHERE [group] = ? AND [key] = ?" (flags: "" )
[23:58:52.941] DEBUG: SQL arg> 0 = QVariant(QString, "SqlEnterpriseFormatter")
[23:58:52.941] DEBUG: SQL arg> 1 = QVariant(QString, "SpaceAfterClosePar")
[23:58:52.941] DEBUG: "SQL SQLiteStudio settings> SELECT value FROM settings WHERE [group] = ? AND [key] = ?" (flags: "" )
[23:58:52.941] DEBUG: SQL arg> 0 = QVariant(QString, "SqlEnterpriseFormatter")
[23:58:52.941] DEBUG: SQL arg> 1 = QVariant(QString, "NlBeforeCloseParExpr")
[23:58:52.941] DEBUG: "SQL SQLiteStudio settings> SELECT value FROM settings WHERE [group] = ? AND [key] = ?" (flags: "" )
[23:58:52.941] DEBUG: SQL arg> 0 = QVariant(QString, "SqlEnterpriseFormatter")
[23:58:52.941] DEBUG: SQL arg> 1 = QVariant(QString, "NlAfterCloseParExpr")
[23:58:52.941] DEBUG: "SQL SQLiteStudio settings> SELECT value FROM settings WHERE [group] = ? AND [key] = ?" (flags: "" )
[23:58:52.941] DEBUG: SQL arg> 0 = QVariant(QString, "SqlEnterpriseFormatter")
[23:58:52.941] DEBUG: SQL arg> 1 = QVariant(QString, "SpaceNeverBeforeComma")
[23:58:52.941] DEBUG: "SQL SQLiteStudio settings> SELECT value FROM settings WHERE [group] = ? AND [key] = ?" (flags: "" )
[23:58:52.942] DEBUG: SQL arg> 0 = QVariant(QString, "SqlEnterpriseFormatter")
[23:58:52.942] DEBUG: SQL arg> 1 = QVariant(QString, "NlAfterComma")
[23:58:52.942] DEBUG: "SQL SQLiteStudio settings> SELECT value FROM settings WHERE [group] = ? AND [key] = ?" (flags: "" )
[23:58:52.942] DEBUG: SQL arg> 0 = QVariant(QString, "SqlEnterpriseFormatter")
[23:58:52.942] DEBUG: SQL arg> 1 = QVariant(QString, "NlBeforeOpenParDef")
[23:58:52.942] DEBUG: "SQL SQLiteStudio settings> SELECT value FROM settings WHERE [group] = ? AND [key] = ?" (flags: "" )
[23:58:52.942] DEBUG: SQL arg> 0 = QVariant(QString, "SqlEnterpriseFormatter")
[23:58:52.942] DEBUG: SQL arg> 1 = QVariant(QString, "NlAfterOpenParDef")
[23:58:52.942] DEBUG: "SQL SQLiteStudio settings> SELECT value FROM settings WHERE [group] = ? AND [key] = ?" (flags: "" )
[23:58:52.942] DEBUG: SQL arg> 0 = QVariant(QString, "SqlEnterpriseFormatter")
[23:58:52.942] DEBUG: SQL arg> 1 = QVariant(QString, "IndentParenthesisBlock")
[23:58:52.942] DEBUG: "SQL SQLiteStudio settings> SELECT value FROM settings WHERE [group] = ? AND [key] = ?" (flags: "" )
[23:58:52.942] DEBUG: SQL arg> 0 = QVariant(QString, "SqlEnterpriseFormatter")
[23:58:52.942] DEBUG: SQL arg> 1 = QVariant(QString, "TabSize")
[23:58:52.942] DEBUG: "SQL SQLiteStudio settings> SELECT value FROM settings WHERE [group] = ? AND [key] = ?" (flags: "" )
[23:58:52.942] DEBUG: SQL arg> 0 = QVariant(QString, "SqlEnterpriseFormatter")
[23:58:52.942] DEBUG: SQL arg> 1 = QVariant(QString, "AlwaysUseNameWrapping")
[23:58:52.942] DEBUG: "SQL SQLiteStudio settings> SELECT value FROM settings WHERE [group] = ? AND [key] = ?" (flags: "" )
[23:58:52.942] DEBUG: SQL arg> 0 = QVariant(QString, "SqlEnterpriseFormatter")
[23:58:52.942] DEBUG: SQL arg> 1 = QVariant(QString, "SpaceBeforeDot")
[23:58:52.942] DEBUG: "SQL SQLiteStudio settings> SELECT value FROM settings WHERE [group] = ? AND [key] = ?" (flags: "" )
[23:58:52.942] DEBUG: SQL arg> 0 = QVariant(QString, "SqlEnterpriseFormatter")
[23:58:52.942] DEBUG: SQL arg> 1 = QVariant(QString, "SpaceAfterDot")
[23:58:52.943] DEBUG: "SQL SQLiteStudio settings> SELECT value FROM settings WHERE [group] = ? AND [key] = ?" (flags: "" )
[23:58:52.943] DEBUG: SQL arg> 0 = QVariant(QString, "SqlEnterpriseFormatter")
[23:58:52.943] DEBUG: SQL arg> 1 = QVariant(QString, "LineUpKeywords")
[23:58:52.943] DEBUG: "SQL SQLiteStudio settings> SELECT value FROM settings WHERE [group] = ? AND [key] = ?" (flags: "" )
[23:58:52.943] DEBUG: SQL arg> 0 = QVariant(QString, "SqlEnterpriseFormatter")
[23:58:52.943] DEBUG: SQL arg> 1 = QVariant(QString, "NlBeforeCloseParDef")
[23:58:52.943] DEBUG: "SQL SQLiteStudio settings> SELECT value FROM settings WHERE [group] = ? AND [key] = ?" (flags: "" )
[23:58:52.943] DEBUG: SQL arg> 0 = QVariant(QString, "SqlEnterpriseFormatter")
[23:58:52.943] DEBUG: SQL arg> 1 = QVariant(QString, "NlAfterCloseParDef")
[23:58:52.943] DEBUG: "SQL SQLiteStudio settings> SELECT value FROM settings WHERE [group] = ? AND [key] = ?" (flags: "" )
[23:58:52.943] DEBUG: SQL arg> 0 = QVariant(QString, "SqlEnterpriseFormatter")
[23:58:52.943] DEBUG: SQL arg> 1 = QVariant(QString, "SpaceNeverBeforeSemicolon")
[23:58:52.943] DEBUG: "SQL SQLiteStudio settings> SELECT value FROM settings WHERE [group] = ? AND [key] = ?" (flags: "" )
[23:58:52.943] DEBUG: SQL arg> 0 = QVariant(QString, "SqlEnterpriseFormatter")
[23:58:52.943] DEBUG: SQL arg> 1 = QVariant(QString, "NlAfterSemicolon")
[23:58:52.943] DEBUG: "SQL SQLiteStudio settings> SELECT value FROM settings WHERE [group] = ? AND [key] = ?" (flags: "" )
[23:58:52.943] DEBUG: SQL arg> 0 = QVariant(QString, "SqlEnterpriseFormatter")
[23:58:52.943] DEBUG: SQL arg> 1 = QVariant(QString, "UppercaseDataTypes")
[23:58:52.943] DEBUG: "SQL SQLiteStudio settings> SELECT value FROM settings WHERE [group] = ? AND [key] = ?" (flags: "" )
[23:58:52.944] DEBUG: SQL arg> 0 = QVariant(QString, "SqlEnterpriseFormatter")
[23:58:52.944] DEBUG: SQL arg> 1 = QVariant(QString, "NlAfterCommaInExpr")
[23:58:52.944] DEBUG: "SQL SQLiteStudio settings> SELECT value FROM settings WHERE [group] = ? AND [key] = ?" (flags: "" )
[23:58:52.944] DEBUG: SQL arg> 0 = QVariant(QString, "SqlEnterpriseFormatter")
[23:58:52.944] DEBUG: SQL arg> 1 = QVariant(QString, "SpaceAfterCommaInList")
[23:58:52.944] DEBUG: "SQL SQLiteStudio settings> SELECT value FROM settings WHERE [group] = ? AND [key] = ?" (flags: "" )
[23:58:52.944] DEBUG: SQL arg> 0 = QVariant(QString, "SqlEnterpriseFormatter")
[23:58:52.944] DEBUG: SQL arg> 1 = QVariant(QString, "NlBetweenConstraints")
[23:58:52.944] DEBUG: "SQL SQLiteStudio settings> SELECT value FROM settings WHERE [group] = ? AND [key] = ?" (flags: "" )
[23:58:52.944] DEBUG: SQL arg> 0 = QVariant(QString, "SqlEnterpriseFormatter")
[23:58:52.944] DEBUG: SQL arg> 1 = QVariant(QString, "MoveAllCommentsToLineEnd")
[23:58:52.944] DEBUG: "SQL SQLiteStudio settings> SELECT value FROM settings WHERE [group] = ? AND [key] = ?" (flags: "" )
[23:58:52.944] DEBUG: SQL arg> 0 = QVariant(QString, "SqlEnterpriseFormatter")
[23:58:52.944] DEBUG: SQL arg> 1 = QVariant(QString, "PreferredCommentMarker")
[23:58:52.945] DEBUG: SqlEnterpriseFormatter loaded: C:\Users\andys-pc\scoop\apps\sqlitestudio\current\plugins\SqlEnterpriseFormatter.dll
[23:58:52.947] DEBUG: XmlExport loaded: C:\Users\andys-pc\scoop\apps\sqlitestudio\current\plugins\XmlExport.dll
[23:58:52.948] DEBUG: DbSqliteWx loaded: C:\Users\andys-pc\scoop\apps\sqlitestudio\current\plugins\DbSqliteWx.dll
[23:58:52.950] DEBUG: HtmlExport loaded: C:\Users\andys-pc\scoop\apps\sqlitestudio\current\plugins\HtmlExport.dll
[23:58:52.950] DEBUG: "SQL SQLiteStudio settings> SELECT value FROM settings WHERE [group] = ? AND [key] = ?" (flags: "" )
[23:58:52.950] DEBUG: SQL arg> 0 = QVariant(QString, "General")
[23:58:52.950] DEBUG: SQL arg> 1 = QVariant(QString, "ActiveCodeFormatter")
[23:58:52.950] DEBUG: "SQL SQLiteStudio settings> SELECT id, name, [order], open, dbname, db_expanded FROM groups WHERE parent IS NULL ORDER BY [order]" (flags: "" )
[23:58:52.950] DEBUG: "SQL SQLiteStudio settings> SELECT id, name, [order], open, dbname, db_expanded FROM groups WHERE parent = ? ORDER BY [order]" (flags: "" )
[23:58:52.950] DEBUG: SQL arg> 0 = QVariant(qlonglong, 38)
[23:58:52.951] DEBUG: Loading form file: :\forms\CsvExport.ui
[23:58:52.951] DEBUG: Loading form file: :\forms\CsvImportOptions.ui
[23:58:52.951] DEBUG: Loading form file: :\forms\htmlexport.ui
[23:58:52.951] DEBUG: Loading form file: :\forms\jsonexport.ui
[23:58:52.951] DEBUG: Loading form file: :\forms\pdfexport.ui
[23:58:52.951] DEBUG: Loading form file: :\forms\plugins\populateconstant.ui
[23:58:52.951] DEBUG: Loading form file: :\forms\plugins\populatedictionary.ui
[23:58:52.951] DEBUG: Loading form file: :\forms\plugins\populaterandom.ui
[23:58:52.951] DEBUG: Loading form file: :\forms\plugins\populaterandomtext.ui
[23:58:52.951] DEBUG: Loading form file: :\forms\plugins\populatescript.ui
[23:58:52.951] DEBUG: Loading form file: :\forms\plugins\populatesequence.ui
[23:58:52.951] DEBUG: Loading form file: :\forms\regexpimport.ui
[23:58:52.951] DEBUG: Loading form file: :\forms\sqlenterpriseformatter.ui
[23:58:52.951] DEBUG: Loading form file: :\forms\SqlExportCommon.ui
[23:58:52.951] DEBUG: Loading form file: :\forms\SqlExportQuery.ui
[23:58:52.951] DEBUG: Loading form file: :\forms\XmlExport.ui
[23:58:52.970] DEBUG: "SQL SQLiteStudio settings> SELECT value FROM settings WHERE [group] = ? AND [key] = ?" (flags: "" )
[23:58:52.970] DEBUG: SQL arg> 0 = QVariant(QString, "General")
[23:58:52.970] DEBUG: SQL arg> 1 = QVariant(QString, "LanguageAsked")
[23:58:52.971] DEBUG: "SQL SQLiteStudio settings> SELECT value FROM settings WHERE [group] = ? AND [key] = ?" (flags: "" )
[23:58:52.971] DEBUG: SQL arg> 0 = QVariant(QString, "General")
[23:58:52.971] DEBUG: SQL arg> 1 = QVariant(QString, "Session")
[23:58:52.977] DEBUG: "SQL SQLiteStudio settings> SELECT value FROM settings WHERE [group] = ? AND [key] = ?" (flags: "" )
[23:58:52.977] DEBUG: SQL arg> 0 = QVariant(QString, "General")
[23:58:52.977] DEBUG: SQL arg> 1 = QVariant(QString, "CustomCss")
[23:58:52.981] DEBUG: "SQL SQLiteStudio settings> INSERT OR REPLACE INTO settings VALUES (?, ?, ?)" (flags: "" )
[23:58:52.981] DEBUG: SQL arg> 0 = QVariant(QString, "General")
[23:58:52.981] DEBUG: SQL arg> 1 = QVariant(QString, "Style")
[23:58:52.981] DEBUG: SQL arg> 2 = QVariant(QByteArray, "\x00\x00\x00\n\x00\x00\x00\x00\x18\x00w\x00i\x00n\x00""d\x00o\x00w\x00s\x00v\x00i\x00s\x00t\x00""a")
[23:58:52.988] DEBUG: "SQL SQLiteStudio settings> SELECT value FROM settings WHERE [group] = ? AND [key] = ?" (flags: "" )
[23:58:52.988] DEBUG: SQL arg> 0 = QVariant(QString, "General")
[23:58:52.988] DEBUG: SQL arg> 1 = QVariant(QString, "RestoreSession")
[23:58:53.088] DEBUG: "SQL mydb> PRAGMA foreign_keys = 1;" (flags: "" )
[23:58:53.088] DEBUG: "SQL mydb> PRAGMA recursive_triggers = 1;" (flags: "" )
[23:58:53.088] DEBUG: "SQL mydb> SELECT * FROM sqlite_master" (flags: "" )
[23:58:53.091] DEBUG: "SQL mydb> PRAGMA foreign_keys = 1;" (flags: "" )
[23:58:53.091] DEBUG: "SQL mydb> PRAGMA recursive_triggers = 1;" (flags: "" )
[23:58:53.092] DEBUG: "SQL SQLiteStudio settings> SELECT value FROM settings WHERE [group] = ? AND [key] = ?" (flags: "" )
[23:58:53.092] DEBUG: SQL arg> 0 = QVariant(QString, "General")
[23:58:53.092] DEBUG: SQL arg> 1 = QVariant(QString, "ShowSystemObjects")
[23:58:53.092] DEBUG: "SQL SQLiteStudio settings> SELECT value FROM settings WHERE [group] = ? AND [key] = ?" (flags: "" )
[23:58:53.092] DEBUG: SQL arg> 0 = QVariant(QString, "General")
[23:58:53.092] DEBUG: SQL arg> 1 = QVariant(QString, "SortObjects")
[23:58:53.092] DEBUG: "SQL mydb> SELECT name FROM main.sqlite_master WHERE type = ?;" (flags: "" )
[23:58:53.092] DEBUG: SQL arg> 0 = QVariant(QString, "table")
[23:58:53.092] DEBUG: "SQL mydb> SELECT sql FROM main.sqlite_master WHERE lower(name) = 'test' AND type = 'table';" (flags: "" )
[23:58:53.093] DEBUG: "SQL SQLiteStudio settings> BEGIN;" (flags: "" )
[23:58:53.093] DEBUG: "SQL SQLiteStudio settings> DELETE FROM groups" (flags: "" )
[23:58:53.094] DEBUG: "SQL SQLiteStudio settings> INSERT INTO groups (name, [order], parent, open, dbname, db_expanded) VALUES (?, ?, ?, ?, ?, ?)" (flags: "" )
[23:58:53.094] DEBUG: SQL arg> 0 = QVariant(QString, "")
[23:58:53.094] DEBUG: SQL arg> 1 = QVariant(int, 0)
[23:58:53.094] DEBUG: SQL arg> 2 = QVariant(qlonglong, 0)
[23:58:53.094] DEBUG: SQL arg> 3 = QVariant(bool, false)
[23:58:53.094] DEBUG: SQL arg> 4 = QVariant(QString, "db")
[23:58:53.094] DEBUG: SQL arg> 5 = QVariant(bool, false)
[23:58:53.094] DEBUG: "SQL SQLiteStudio settings> INSERT INTO groups (name, [order], parent, open, dbname, db_expanded) VALUES (?, ?, ?, ?, ?, ?)" (flags: "" )
[23:58:53.094] DEBUG: SQL arg> 0 = QVariant(QString, "")
[23:58:53.094] DEBUG: SQL arg> 1 = QVariant(int, 1)
[23:58:53.094] DEBUG: SQL arg> 2 = QVariant(qlonglong, 0)
[23:58:53.094] DEBUG: SQL arg> 3 = QVariant(bool, true)
[23:58:53.094] DEBUG: SQL arg> 4 = QVariant(QString, "mydb")
[23:58:53.094] DEBUG: SQL arg> 5 = QVariant(bool, false)
[23:58:53.094] DEBUG: "SQL SQLiteStudio settings> COMMIT;" (flags: "" )
Operating system
Windows 10
SQLiteStudio version
3.4.4
Even just pasting this CREATE statement into SQL Editor window causes the crash. Most likely it's a problem with internal SQL parser. Thanks for reporting!
