Skip to content

SQLite: support STRICT, WITHOUT ROWID tables #2481

Closed
@ciarand

Description

@ciarand

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.

Metadata

Metadata

Assignees

No one assigned

    Labels

    enhancementNew feature or requesttriageNew issues that hasn't been reviewed

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions