18 lines
408 B
Text
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
|