You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Using CAST('Infinity' AS INT) brings different results , when set EXECUTOR_DEVICE 'CPU' and 'GPU'.
SQL:
CREATETABLEIF NOT EXISTS t0(c0 DOUBLE NULL);
INSERT INTO t0(c0) VALUES(0), (1), ('Infinity');
ALTER SESSION SET EXECUTOR_DEVICE='CPU';
SELECT CAST(t0.c0ASINT) FROM t0;
Result:
EXPR$0
0
1
null
SQL:
ALTER SESSION SET EXECUTOR_DEVICE='GPU';
SELECT CAST(t0.c0ASINT) FROM t0;
Describe:
Using CAST('Infinity' AS INT) brings different results , when set EXECUTOR_DEVICE 'CPU' and 'GPU'.
SQL:
Result:
EXPR$0 0 1 null
SQL:
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
The text was updated successfully, but these errors were encountered: