1
Fork 0
kantodb/testdata/sql/select_count_one.slt

12 lines
310 B
Text

# `SELECT COUNT(*)` leads to an interesting edge case with `projection=Some([])`
statement ok
CREATE TABLE myschema.mytable (mycolumn BIGINT NOT NULL, PRIMARY KEY(mycolumn));
statement ok
INSERT INTO kanto.myschema.mytable (mycolumn) VALUES (42);
query I
SELECT COUNT(*) FROM kanto.myschema.mytable;
----
1