modules/sql-engine/src/integrationTest/sql/group1/insert/test_insert_invalid.test

# name: test/sql/insert/test_insert_invalid.test
# description: Test invalid INSERT INTO statements
# group: [insert]

# Test insert with too few or too many cols
statement ok
CREATE TABLE a(i integer, j integer)

statement ok
INSERT INTO a VALUES (1, 2)

# scalar inserts
statement error
INSERT INTO a VALUES (1)

statement error
INSERT INTO a VALUES (1,2,3)

statement error
INSERT INTO a VALUES (1,2),(3)

statement error
INSERT INTO a VALUES (1,2),(3,4,5)

# also with queries
statement error
INSERT INTO a SELECT 42