FazBrowse GitHub Viewer | Trending |
URL:
| Home
Tools: [Download Repo ZIP]   [Original HTTPS Page]

+Infinite and -Infinite Expression on Export Database to SQL file · Issue #244 · sqlitebrowser/sqlitebrowser · GitHub

+Infinite and -Infinite Expression on Export Database to SQL file #244

Description

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);

Metadata

Metadata

Assignees

No one assigned

    Labels

    bugConfirmed bugs or reports that are very likely to be bugs.

    Type

    No type

    Projects

    No projects

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions


    Back | FazBrowse Home | New Git URL