heavyai / heavydb

HeavyDB (formerly OmniSciDB)
https://heavy.ai
Apache License 2.0
2.96k stars 448 forks source link

[GPU Logic Bug] Cast 'Infinity' as INT Brings Errors #804

Open qwebug opened 1 year ago

qwebug commented 1 year ago

Describe:

Using CAST('Infinity' AS INT)  brings different results , when set EXECUTOR_DEVICE 'CPU' and 'GPU'.

SQL:

CREATE TABLE IF NOT EXISTS t0(c0 DOUBLE  NULL);
INSERT INTO t0(c0) VALUES(0), (1), ('Infinity');
ALTER SESSION SET EXECUTOR_DEVICE='CPU';
SELECT CAST(t0.c0 AS INT) FROM t0;

Result:

EXPR$0
0
1
null

SQL:

ALTER SESSION SET EXECUTOR_DEVICE='GPU';
SELECT CAST(t0.c0 AS INT) FROM t0;

Result:

EXPR$0
0
1
2147483647

Environment:

Docker Deployment

https://hub.docker.com/layers/heavyai/heavyai-ee-cuda/latest/images/sha256-5af3ad3a00cbc5ce09c299b8b81cda96521a27373dbb1e59209c02358cfd9b1f?context=explore

Docker DIGEST: sha256:5af3ad3a00cbc5ce09c299b8b81cda96521a27373dbb1e59209c02358cfd9b1f

HeavyDB Version: 7.1.0-20230821-eae9ec17da

HeavyDB license: Free Edition