Skip to content

[Bug]: CREATE TABLE with STRICT raises syntax error #3744

@fehmud

Description

@fehmud

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

  • I have searched for similar issues

Metadata

Metadata

Assignees

Labels

Type

No type

Projects

No projects

Milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions