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

# name: test/sql/insert/test_insert_query.test
# description: Test insert from constant query
# group: [insert]

statement ok
CREATE TABLE integers(i INTEGER)

statement ok
INSERT INTO integers SELECT 42

statement ok
INSERT INTO integers SELECT CAST(NULL AS INTEGER)

query I rowsort
SELECT * FROM integers
----
42
NULL