Validate all types import and download correctly - Githubissues

heavyai / heavyai.jl

Julia client for OmniSci GPU-accelerated SQL engine and analytics platform

https://omnisci.github.io/OmniSci.jl/latest/

Other

21 stars 9 forks source link

Validate all types import and download correctly #41

Open randyzwitch opened 5 years ago

randyzwitch commented 5 years ago

This matrix represents whether test has been written, not just whether the method known to actually work

Export: sql_execute

[x] TINYINT
[x] SMALLINT
[x] INTEGER
[x] BIGINT
[x] FLOAT
[x] DOUBLE
[x] DECIMAL (as Dec64)
[x] TEXT
[x] BOOLEAN
[x] DATE
[x] TIME
[x] TIMESTAMP
[x] POINT
[x] LINESTRING
[x] POLYGON
[x] MULTIPOLYGON
[ ] ARRAY - Blocked by #53

Import: load_table

[x] TINYINT
[x] SMALLINT
[x] INTEGER
[x] BIGINT
[x] FLOAT
[x] DOUBLE
[x] DECIMAL (string)
[x] DECIMAL (float)
[x] DECIMAL (double)
[x] DECIMAL (rational)
[x] DecFP
[x] Decimals.jl
[x] TEXT
[x] BOOLEAN
[x] DATE
[x] TIME
[x] TIMESTAMP
[x] POINT (WKT)
[x] LINESTRING (WKT)
[x] POLYGON (WKT)
[x] MULTIPOLYGON (WKT)
[x] POINT (GeoInterface)
[x] LINESTRING (GeoInterface)
[x] POLYGON (GeoInterface)
[x] MULTIPOLYGON (GeoInterface)
[x] POINT (LibGEOS)
[x] LINESTRING (LibGEOS)
[x] POLYGON (LibGEOS)
[x] MULTIPOLYGON (LibGEOS)
[x] ARRAY (tested with all major types)

Import: load_table_binary_columnar

[x] TINYINT
[x] SMALLINT
[x] INTEGER
[x] BIGINT
[x] FLOAT
[x] DOUBLE
[x] TEXT
[x] BOOLEAN
[x] DATE
[x] TIME
[x] TIMESTAMP
[ ] DECIMAL (add kw argument for decimal precision/scale, require to be set/assert to not upload without proper value
[x] POINT (WKT)
[x] LINESTRING (WKT)
[x] POLYGON (WKT)
[x] MULTIPOLYGON (WKT)
[x] POINT (GeoInterface)
[x] LINESTRING (GeoInterface)
[x] POLYGON (GeoInterface)
[x] MULTIPOLYGON (GeoInterface)
[x] POINT (LibGEOS)
[x] LINESTRING (LibGEOS)
[x] POLYGON (LibGEOS)
[x] MULTIPOLYGON (LibGEOS)
[x] ARRAY

randyzwitch commented 5 years ago

Related #38