Re: [sqlite] Bug in 3.6.18 genfkey code: trigger not working for quoted column names

On Oct 8, 2009, at 6:59 AM, Thomas Henlich wrote: > Hi, > > I found a bug in the .genfkey functionality: Thank you for the bug report. Did you know that the next release of SQLite will contain native support for foreign key constraints? The ".genfkey" functionality will become obsolete.

[sqlite] Bug in 3.6.18 genfkey code: trigger not working for quoted column names

Hi, I found a bug in the .genfkey functionality: If a foreign key constraint has or references columns which need to be quoted, the .genfkey command will generate invalid triggers which fail to enforce that particular constraint. Example: CREATE TABLE parent("a.1", PRIMARY KEY("a.1"));