Imported from /home/lorry/working-area/delta_berkeleydb/db-6.1.23.tar.gz.HEADdb-6.1.23master

1 files changed, 17 insertions, 0 deletions

diff --git a/lang/sql/sqlite/test/insert.test b/lang/sql/sqlite/test/insert.test
index 9ea9cd72..e00b9a80 100644
--- a/lang/sql/sqlite/test/insert.test
+++ b/lang/sql/sqlite/test/insert.test
@@ -386,6 +386,23 @@ do_test insert-9.2 {
   }
 } {1 1 2 2 3 3 12 101 13 102 16 103}
 
+# Multiple VALUES clauses
+#
+ifcapable compound {
+  do_test insert-10.1 {
+    execsql {
+      CREATE TABLE t10(a,b,c);
+      INSERT INTO t10 VALUES(1,2,3), (4,5,6), (7,8,9);
+      SELECT * FROM t10;
+    }
+  } {1 2 3 4 5 6 7 8 9}
+  do_test insert-10.2 {
+    catchsql {
+      INSERT INTO t10 VALUES(11,12,13), (14,15);
+    }
+  } {1 {all VALUES must have the same number of terms}}
+}
+
 integrity_check insert-99.0
 
 finish_test