What did you do?
Running DB.Browser.for.SQLite-v3.13.0-x86.64.AppImage.
I tried modifying a table via Database Structure > Modify table but got a syntax error message, so I clicked on Create Table to create a simple strict table but got the same error:
Error creating table. Message from database engine:
near "STRICT": syntax error (CREATE TABLE "test" (
"Field1" INTEGER
) STRICT;)
I switched to Execute SQL and ran the SQL from above:
CREATE TABLE "test" (
"Field1" INT
) STRICT;
and got the same error:
Execution finished with errors.
Result: near "STRICT": syntax error
At line 1:
CREATE TABLE "test" (
"Field1" INT
) STRICT
Tried again with a new database and got the same error.
What did you expect to see?
Modification to strict table and creation of a strict table.
What did you see instead?
A SQL syntax error.
DB4S Version
3.13.0
What OS are you seeing the problem on?
Linux
OS version
No response
Relevant log output
No response
Prevention against duplicate issues
What did you do?
Running DB.Browser.for.SQLite-v3.13.0-x86.64.AppImage.
I tried modifying a table via Database Structure > Modify table but got a syntax error message, so I clicked on Create Table to create a simple strict table but got the same error:
Error creating table. Message from database engine:
near "STRICT": syntax error (CREATE TABLE "test" (
"Field1" INTEGER
) STRICT;)
I switched to Execute SQL and ran the SQL from above:
CREATE TABLE "test" (
"Field1" INT
) STRICT;
and got the same error:
Execution finished with errors.
Result: near "STRICT": syntax error
At line 1:
CREATE TABLE "test" (
"Field1" INT
) STRICT
Tried again with a new database and got the same error.
What did you expect to see?
Modification to strict table and creation of a strict table.
What did you see instead?
A SQL syntax error.
DB4S Version
3.13.0
What OS are you seeing the problem on?
Linux
OS version
No response
Relevant log output
No response
Prevention against duplicate issues