1
-- Test basic TRUNCATE functionality.
2
CREATE TABLE truncate_a (col1 integer primary key);
3
INSERT INTO truncate_a VALUES (1);
4
INSERT INTO truncate_a VALUES (2);
5
SELECT * FROM truncate_a;
10
SELECT * FROM truncate_a;
11
-- Commit the truncate this time
15
SELECT * FROM truncate_a;
17
-- Test foreign constraint check
18
CREATE TABLE truncate_b(col1 integer references truncate_a);
19
INSERT INTO truncate_a VALUES (1);
20
SELECT * FROM truncate_a;
22
SELECT * FROM truncate_a;
24
DROP TABLE truncate_b;
25
DROP TABLE truncate_a;