1 files changed, 17 insertions, 0 deletions
diff --git a/test/insert.test b/test/insert.test
index 9ea9cd7..e00b9a8 100644
--- a/test/insert.test
+++ b/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