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

18 lines
408 B
Text

# All SQL syntaxes that result in storing a boolean.
statement ok
CREATE TABLE kanto.myschema.mytable (a BOOLEAN, b BOOL);
query T rowsort
SELECT column_name, data_type FROM myschema.information_schema.columns WHERE table_catalog='kanto';
----
a Boolean
b Boolean
statement ok
INSERT INTO kanto.myschema.mytable VALUES (true, false);
query T rowsort
SELECT * FROM kanto.myschema.mytable;
----
true false