This was found on Windows 7 64 bit. The following statements return error: malformed database schema:
e:\Code\sqlite>sqlite3 :memory: SQLite version 3.8.1 2013-10-17 12:57:35 Enter ".help" for instructions Enter SQL statements terminated with a ";" sqlite> create table t(c); sqlite> create temp trigger t1 before insert on t begin select * from t; end; sqlite> create temp table t(c); Error: malformed database schema (t1) - trigger t1 already exists sqlite> If lines 2 and 3 are reversed, no errors are returned: sqlite> create table t(c); sqlite> create temp table t(c); sqlite> create temp trigger t1 before insert on t begin select * from t; end; sqlite> Is this a bug? Thanks. Bogdan Ureche _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
