1
Fork 0
kantodb/testdata/sql/unimplemented/unimplemented_truncate.slt

20 lines
442 B
Text

statement ok
CREATE TABLE kanto.myschema.mytable (a BIGINT);
statement ok
INSERT INTO kanto.myschema.mytable (a) VALUES (42), (13);
statement error ^External error: unimplemented_sql/uf3rr4diw3o1o: TRUNCATE$
TRUNCATE TABLE kanto.myschema.mytable;
#statement ok
#TRUNCATE TABLE kanto.myschema.mytable;
#
#query I rowsort
#SELECT * FROM kanto.myschema.mytable;
#----
#
#query I rowsort
#SELECT count(*) FROM kanto.myschema.mytable;
#----
#0