modules/sql-engine/src/integrationTest/sql/group1/update/test_null_update.test

# name: test/sql/update/test_null_update.test
# description: Test standard update behavior with NULLs
# group: [update]

# create a table
statement ok
CREATE TABLE test (a INTEGER);

statement ok
INSERT INTO test VALUES (1), (2), (3), (NULL)

query I
SELECT * FROM test ORDER BY a
----
1
2
3
NULL

statement ok
UPDATE test SET a=NULL WHERE a=2

query I
SELECT * FROM test ORDER BY a
----
1
3
NULL
NULL

statement ok
UPDATE test SET a=4 WHERE a IS NULL

query I
SELECT * FROM test ORDER BY a
----
1
3
4
4