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 sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users