Closed
Description
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.