Thanks for reporting this. Now fixed here:
http://www.sqlite.org/src/info/5771b1d611b3562e
Dan.
On 12/01/2017 02:02 AM, David Raymond wrote:
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
_______________________________________________
sqlite-users mailing list
[email protected]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
