30 lines
1.2 KiB
Text
30 lines
1.2 KiB
Text
# All SQL syntaxes that result in storing a f64.
|
|
|
|
statement ok
|
|
CREATE TABLE kanto.myschema.mytable (a DOUBLE);
|
|
|
|
query I rowsort
|
|
SELECT column_name, data_type FROM myschema.information_schema.columns WHERE table_catalog='kanto';
|
|
----
|
|
a Float64
|
|
|
|
statement ok
|
|
INSERT INTO kanto.myschema.mytable VALUES (-1.7);
|
|
|
|
query R rowsort
|
|
SELECT * FROM kanto.myschema.mytable;
|
|
----
|
|
-1.700
|
|
|
|
statement ok
|
|
INSERT INTO kanto.myschema.mytable VALUES (-1.7976931348623157E+308);
|
|
|
|
statement ok
|
|
INSERT INTO kanto.myschema.mytable VALUES (1.7976931348623157E+308);
|
|
|
|
query R nosort
|
|
SELECT * FROM kanto.myschema.mytable ORDER BY a ASC;
|
|
----
|
|
-179769313486231570814527423731704356798070567525844996598917476803157260780028538760589558632766878171540458953514382464234321326889464182768467546703537516986049910576551282076245490090389328944075868508455133942304583236903222948165808559332123348274797826204144723168738177180919299881250404026184124858368.000
|
|
-1.700
|
|
179769313486231570814527423731704356798070567525844996598917476803157260780028538760589558632766878171540458953514382464234321326889464182768467546703537516986049910576551282076245490090389328944075868508455133942304583236903222948165808559332123348274797826204144723168738177180919299881250404026184124858368.000
|