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. Example: CREATE TABLE t10(a,b,c); INSERT INTO t10 VALUES(1,2,3), (4,5,6), (7,8,9); SELECT * FROM t10; For me returns 7, 8, 9 It seems that with SQLITE_OMIT_COMPOUND_SELECT, only the last multiple rows value is inserted. Error messages also differ: INSERT INTO t10 VALUES(11,12,13), (14,15); returns the error message: table t10 has 3 columns but 2 values were supplied instead of: all VALUES must have the same number of terms Ralf _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
