# All SQL syntaxes that result in storing a i64.

statement ok
CREATE TABLE kanto.myschema.mytable (a BIGINT);

query I rowsort
SELECT column_name, data_type FROM myschema.information_schema.columns WHERE table_catalog='kanto';
----
a Int64

statement ok
INSERT INTO kanto.myschema.mytable VALUES (-1);

query I rowsort
SELECT * FROM kanto.myschema.mytable;
----
-1

statement ok
INSERT INTO kanto.myschema.mytable VALUES (-9223372036854775808);

statement ok
INSERT INTO kanto.myschema.mytable VALUES (9223372036854775807);