Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

Appearance settings

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

Copy link
Copy link
@fehmud

Description

@fehmud
Issue body actions

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

    Morty Proxy This is a proxified and sanitized view of the page, visit original site.