Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

SQLite: support STRICT, WITHOUT ROWID tables #2481

Closed
ciarand opened this issue Jul 19, 2023 · 0 comments · Fixed by #2482
Closed

SQLite: support STRICT, WITHOUT ROWID tables #2481

ciarand opened this issue Jul 19, 2023 · 0 comments · Fixed by #2482
Labels
enhancement New feature or request triage New issues that hasn't been reviewed

Comments

@ciarand
Copy link

ciarand commented Jul 19, 2023

What do you want to change?

In line with #2175, SQLite tables defined using both STRICT and WITHOUT ROWID aren't currently supported.

This works:

CREATE TABLE authors (
  id   BIGSERIAL PRIMARY KEY,
  name text      NOT NULL,
  bio  text
) WITHOUT ROWID;

This works:

CREATE TABLE authors (
  id   BIGSERIAL PRIMARY KEY,
  name text      NOT NULL,
  bio  text
) STRICT;

This doesn't work:

CREATE TABLE authors (
  id   BIGSERIAL PRIMARY KEY,
  name text      NOT NULL,
  bio  text
) STRICT, WITHOUT ROWID;

What database engines need to be changed?

SQLite

What programming language backends need to be changed?

I'm using Go, not sure if that matters for this feature request.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
enhancement New feature or request triage New issues that hasn't been reviewed
Projects
None yet
Development

Successfully merging a pull request may close this issue.

1 participant