Hi,

I found a bug in the .genfkey functionality:

If a foreign key constraint references a table with a quoted table name,  
the .genfkey command will fail on that constraint. Example:

   create table "t.3"(c1 primary key);
   create table t13(c1, foreign key(c1) references "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, 01187 Dresden
      tel.: +49 [0]351 4712357
      mobil: +49 [0]175 1723884
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to