Ok, now I understand. Thank you (and Richard) very much.
- Original Message -
From: Keith Medcalf
To: SQLite mailing list
Sent: Tuesday, November 13, 2018, 14:06:11
Subject: [sqlite] Broken Foreign key
On Tuesday, 13 November, 2018 05:47, Thomas Kurz asked:
>May I ask why par
On Tuesday, 13 November, 2018 05:47, Thomas Kurz asked:
>May I ask why parent keys *must* have indexes? I don't see any
>correlation between enforcing a client/parent-relationship and the
>necessity for an index. I'm just asking to better understand. To me
>it is clear that the parent column is
anually index PRIMARY KEY columns as well or are those
> auto-indexed?
>
> Kind reagrds,
> Thomas
>
>
> - Original Message -
> From: Keith Medcalf
> To: SQLite mailing list
> Sent: Monday, November 12, 2018, 05:15:35
> Subject: [sqlite] Broken Foreign key
hy does it need to have an
index?
And do I have to manually index PRIMARY KEY columns as well or are those
auto-indexed?
Kind reagrds,
Thomas
- Original Message -
From: Keith Medcalf
To: SQLite mailing list
Sent: Monday, November 12, 2018, 05:15:35
Subject: [sqlite] Broken Foreign ke
lot about anticipated traffic volume.
>-Original Message-
>From: sqlite-users [mailto:sqlite-users-
>boun...@mailinglists.sqlite.org] On Behalf Of J Decker
>Sent: Tuesday, 13 November, 2018 04:33
>To: General Discussion of SQLite Database
>Subject: Re: [sqlite] Broken
.sqlite.org] On Behalf Of J Decker
> >Sent: Sunday, 11 November, 2018 20:25
> >To: General Discussion of SQLite Database
> >Subject: [sqlite] Broken Foreign key
> >
> >https://d3x0r.org:444/temporary/broken_fk.tgz (30k)
> >
> >this has a .option.db in i
nly a Stairway to Heaven says a
lot about anticipated traffic volume.
>-Original Message-
>From: sqlite-users [mailto:sqlite-users-
>boun...@mailinglists.sqlite.org] On Behalf Of J Decker
>Sent: Sunday, 11 November, 2018 20:25
>To: General Discussion of SQLite Database
>S
https://d3x0r.org:444/temporary/broken_fk.tgz (30k)
this has a .option.db in it and a test.sh.
It turns on foreign_keys, selects from the name_id that it says is a
forieng key violation, and inserts into option4_map.
option4_map has option_id(PK),parent_id(FK option_id),name_id(FK)
option4_name
8 matches
Mail list logo