modules/calcite/src/test/sql/delete/test_delete.test

# name: test/sql/delete/test_delete.test
# description: Test deletions
# group: [delete]

statement ok
CREATE TABLE a(i INTEGER);

statement ok
INSERT INTO a VALUES (42);

query I
SELECT COUNT(*) FROM a;
----
1

# delete everything
statement ok
DELETE FROM a;

query I
SELECT COUNT(*) FROM a;
----
0

statement ok
INSERT INTO a VALUES (42);

query I
SELECT COUNT(*) FROM a;
----
1