Create Sample Table using "Import/Database from SQL file" function
CREATE TABLE foo (x DOUBLE);
INSERT INTO foo VALUES (9e999); -- +Inf
INSERT INTO foo VALUES (-9e999); -- -Inf
INSERT INTO foo VALUES (9e999 / 9e999); -- NaN: gets converted to NULL
This foo table has these values
'Inf'
'-Inf'
'NULL'
Export foo table to SQL using "Export/Database to SQL file" function. This SQL Statement generates error on "Inf".
CREATE TABLE foo (x DOUBLE);
INSERT INTO foo VALUES (Inf);
INSERT INTO foo VALUES (-Inf);
INSERT INTO foo VALUES (NULL);
I think that this is right. What do you think about this?
CREATE TABLE foo (x DOUBLE);
INSERT INTO foo VALUES ('Inf');
INSERT INTO foo VALUES ('-Inf');
INSERT INTO foo VALUES (NULL);
Reactions are currently unavailable
Create Sample Table using "Import/Database from SQL file" function
This foo table has these values
Export foo table to SQL using "Export/Database to SQL file" function. This SQL Statement generates error on "Inf".
I think that this is right. What do you think about this?