diff options
Diffstat (limited to 'test/insert.test')
-rw-r--r-- | test/insert.test | 17 |
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 |