30 lines
691 B
Text
30 lines
691 B
Text
# All SQL syntaxes that result in storing a f32.
|
|
|
|
statement ok
|
|
CREATE TABLE kanto.myschema.mytable (a REAL);
|
|
|
|
query I rowsort
|
|
SELECT column_name, data_type FROM myschema.information_schema.columns WHERE table_catalog='kanto';
|
|
----
|
|
a Float32
|
|
|
|
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 (-3.40282347E+38);
|
|
|
|
statement ok
|
|
INSERT INTO kanto.myschema.mytable VALUES (3.40282347E+38);
|
|
|
|
query R nosort
|
|
SELECT * FROM kanto.myschema.mytable ORDER BY a ASC;
|
|
----
|
|
-340282346638528859811704183484516925440.000
|
|
-1.700
|
|
340282346638528859811704183484516925440.000
|