Hello Keith,
On Thu, Oct 4, 2018 at 1:16 AM Keith Medcalf wrote:
>
> Unrelated, but are you sure that you want the albums "id int primary key"
> and did not happen to misspell "integer" so that the declaration should be
> "id integer primary key". In the former case, id is an integer that just
Unrelated, but are you sure that you want the albums "id int primary key" and
did not happen to misspell "integer" so that the declaration should be "id
integer primary key". In the former case, id is an integer that just happens
to be unique (ie, "id int primary key" is the same as "id
Hello,
I want to report a bug, I checked https://www.sqlite.org/src/rptview?rn=8
and did not find the same?
Let schema be:
sqlite> .schema
CREATE TABLE albums (id int primary key, title text, score int);
CREATE TABLE rates (album_id references albums(id) on delete cascade,
comment text, score
3 matches
Mail list logo
