I’m using the CLI’s .lint fkey-indexes command, and it appears to be having
issues with without rowid tables. A low priority thing to look into when
someone's bored.
sqlite> create table parent (id integer primary key);
sqlite> create table child1 (id integer primary key, parentID int references
parent);
sqlite> .lint fkey-indexes
CREATE INDEX 'child1_parentID' ON 'child1'('parentID'); --> parent(id)
sqlite> create index idx_child1 on child1 (parentID);
sqlite> .lint fkey-indexes
sqlite> create table child2 (id int primary key, parentID int references
parent) without rowid;
sqlite> .lint fkey-indexes
no such column: rowid
sqlite> create index idx_child2 on child2 (parentID);
sqlite> .lint fkey-indexes
no such column: rowid
sqlite>
_______________________________________________
sqlite-users mailing list
[email protected]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
