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"));
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.
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
3 matches
Mail list logo