On 13.02.2012 10:18, Dan Kennedy wrote: > On 02/10/2012 11:06 PM, Ralf Junker wrote: >> >>> The new feature to insert multiple rows of VALUES in a single INSERT >>> >>> http://www.sqlite.org/src/info/eb3b6a0ceb >>> >>> gives wrong results if SQLite is compiled with >>> SQLITE_OMIT_COMPOUND_SELECT. >> >> Has the team seen this or has it been overlooked? Shall I file a ticket? > > I get this: > > SQLite version 3.7.11 2012-02-13 08:50:23 > Enter ".help" for instructions > Enter SQL statements terminated with a ";" > sqlite> CREATE TABLE t1(x, y); > sqlite> INSERT INTO t1 VALUES(1, 2), (3, 4); > Error: near ",": syntax error > > Is this what you are seeing? That the syntax is rejected with > an error message? Or some other problem?
I believe Richard has already take care of this and disabled multiple rows in the VALUES clause if SQLITE_OMIT_COMPOUND_SELECT is defined: http://127.0.0.1:8080/info/92131195d0 Before this, I did not see any error message. After, I expect an error message similar to yours (from reading the code, I did not compile and run). So do I guess correctly that you were testing with trunk later than check-in [92131195d0]? Ralf _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
