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(<column>+<column>(overflow) AS BOOLEAN) brings different results , when set EXECUTOR_DEVICE 'CPU' and 'GPU'.
SQL:
CREATE TABLE t0(c0 INTEGERNULL);
INSERT INTO t0(c0) VALUES(1707341980);
ALTER SESSION SET EXECUTOR_DEVICE='CPU';
SELECT ALL t0.c0FROM t0 WHERE CAST(t0.c0+t0.c0ASBOOLEAN) IS FALSE IS NULL;
Result:
No rows returned.
SQL:
ALTER SESSION SET EXECUTOR_DEVICE='GPU';
SELECT ALL t0.c0FROM t0 WHERE CAST(t0.c0+t0.c0ASBOOLEAN) IS FALSE IS NULL;
Describe:
Using CAST(<column>+<column>(overflow) AS BOOLEAN) brings different results , when set EXECUTOR_DEVICE 'CPU' and 'GPU'.
SQL:
Result:
SQL:
Result:
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: