Foreign key lint has issues with without rowid

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
4 messages Options
Reply | Threaded
Open this post in threaded view
|

Foreign key lint has issues with without rowid

David Raymond
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
[hidden email]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Reply | Threaded
Open this post in threaded view
|

Re: Foreign key lint has issues with without rowid

Simon Slavin-3


On 30 Nov 2017, at 7:02pm, David Raymond <[hidden email]> 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.

Please tell us which version of SQLite you’re using.  You should see it when the command line tool starts up.

Simon.
_______________________________________________
sqlite-users mailing list
[hidden email]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Reply | Threaded
Open this post in threaded view
|

Re: Foreign key lint has issues with without rowid

David Raymond
3.21.0



-----Original Message-----
From: sqlite-users [mailto:[hidden email]] On Behalf Of Simon Slavin
Sent: Thursday, November 30, 2017 2:06 PM
To: SQLite mailing list
Subject: Re: [sqlite] Foreign key lint has issues with without rowid



On 30 Nov 2017, at 7:02pm, David Raymond <[hidden email]> 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.

Please tell us which version of SQLite you’re using.  You should see it when the command line tool starts up.

Simon.
_______________________________________________
sqlite-users mailing list
[hidden email]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
[hidden email]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Reply | Threaded
Open this post in threaded view
|

Re: Foreign key lint has issues with without rowid

Dan Kennedy-4
In reply to this post by David Raymond


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
> [hidden email]
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users


_______________________________________________
sqlite-users mailing list
[hidden email]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users