Hello,
I have hit a bug that allows creation of a database that couldn't be
loaded. Step to reproduce are listed below.
Best regards,
Filip Navara
>sqlite3.exe
SQLite version 3.7.6.3
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> ATTACH DATABASE 'attached.dat' AS 'attached';
sqlite> CREATE TABLE "attached"."a" ("b");
sqlite> CREATE TRIGGER "attached"."ta" AFTER INSERT ON "attached"."a"
BEGIN SELECT 0; END;
>sqlite3.exe attached.dat
SQLite version 3.7.6.3
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> .schema
Error: malformed database schema (ta) - trigger "ta" cannot reference objects in
database attached
sqlite>
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
