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
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.