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

2009-10-08 Thread Thomas Henlich
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"));

[sqlite] SQLite export plugin for MySQL Workbench

2009-05-13 Thread Thomas Henlich
ely there. I'm always open for suggestions, bug reports or feature wishes. Links: SQLite export plugin for MySQL Workbench: http://www.henlich.de/software/sqlite-export-plugin-for-mysql-workbench/ MySQL Workbench: http://dev.mysql.com/workbench/ -- Dipl.-Ing. Thomas Henlich Liebigstr.

[sqlite] .genfkey & quoted table names

2009-04-24 Thread Thomas Henlich
s "t.3"(c1)); .genfkey yields: Error in table t13: foreign key columns do not exist I looked at the code in shell.c but I could not find the right place to fix this yet. Does anyone have a suggestion on fixing this bug? Thomas -- Dipl.-Ing. Thomas Henlich Liebigstr. 38, 011