On 02/10/2012 11:06 PM, Ralf Junker wrote:
On 07.02.2012 12:28, 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?
Dan.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
