# E011-02: REAL, DOUBLE PRECISION, and FLOAT data types

statement ok
CREATE TABLE TABLE_E011_02_01_01 ( ID INT PRIMARY KEY, A DOUBLE PRECISION )

statement ok
CREATE TABLE TABLE_E011_02_01_02 ( ID INT PRIMARY KEY, A FLOAT ( 2 ) )

statement ok
CREATE TABLE TABLE_E011_02_01_03 ( ID INT PRIMARY KEY, A FLOAT )

statement ok
CREATE TABLE TABLE_E011_02_01_04 ( ID INT PRIMARY KEY, A REAL )

query R
SELECT +7.8
----
7.8

query R
SELECT -7.8
----
-7.8

query R
SELECT +.2
----
0.2

query R
SELECT +.2E+2
----
20.0

query R
SELECT +.2E-2
----
0.002

query R
SELECT +.2E2
----
20.0

query I
SELECT +2
----
2

query R
SELECT +2.
----
2.0

query R
SELECT +2.2
----
2.2

query R
SELECT +2.2E+2
----
220.0

query R
SELECT +2.2E-2
----
0.022

query R
SELECT +2.2E2
----
220.0

query R
SELECT +2.E+2
----
200.0

query R
SELECT +2.E-2
----
0.02

query R
SELECT +2.E2
----
200.0

query R
SELECT +2E+2
----
200.0

query R
SELECT +2E-2
----
0.02

query R
SELECT +2E2
----
200.0

query R
SELECT -.2
----
-0.2

query R
SELECT -.2E+2
----
-20.0

query R
SELECT -.2E-2
----
-0.002

query R
SELECT -.2E2
----
-20.0

query I
SELECT -2
----
-2

query R
SELECT -2.
----
-2.0

query R
SELECT -2.2
----
-2.2

query R
SELECT -2.2E+2
----
-220.0

query R
SELECT -2.2E-2
----
-0.022

query R
SELECT -2.2E2
----
-220.0

query R
SELECT -2.E+2
----
-200.0

query R
SELECT -2.E-2
----
-0.02

query R
SELECT -2.E2
----
-200.0

query R
SELECT -2E+2
----
-200.0

query R
SELECT -2E-2
----
-0.02

query R
SELECT -2E2
----
-200.0

query R
SELECT .2
----
0.2

query R
SELECT .2E+2
----
20.0

query R
SELECT .2E-2
----
0.002

query R
SELECT .2E2
----
20.0

query I
SELECT 2
----
2

query R
SELECT 2.
----
2.0

query R
SELECT 2.2
----
2.2

query R
SELECT 2.2E+2
----
220.0

query R
SELECT 2.2E-2
----
0.022

query R
SELECT 2.2E2
----
220.0

query R
SELECT 2.E+2
----
200.0

query R
SELECT 2.E-2
----
0.02

query R
SELECT 2.E2
----
200.0

query R
SELECT 2E+2
----
200.0

query R
SELECT 2E-2
----
0.02

query R
SELECT 2E2
----
200.0
