[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)); CREATE

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.