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 SELECT * FROM <table> WHERE ((<column> + <column>) < <column>) OR (<column> = <column>) brings different results , when set EXECUTOR_DEVICE 'CPU' and 'GPU'.
SQL:
CREATETABLEt0(c0 INT);
INSERT INTO t0(c0) VALUES(749466197), (-1013771122), (-1575001538);
ALTER SESSION SET EXECUTOR_DEVICE='CPU';
SELECT*FROM t0 WHERE ((t0.c0+t0.c0)<(t0.c0)) OR (t0.c0=t0.c0);
Result:
c0
749466197
-1013771122
SQL:
ALTER SESSION SET EXECUTOR_DEVICE='GPU';
SELECT*FROM t0 WHERE ((t0.c0+t0.c0)<(t0.c0)) OR (t0.c0=t0.c0);
The text was updated successfully, but these errors were encountered:
qwebug
changed the title
[Error Bug] SELECT * FROM <table> WHERE ((<column> + <column>) < <column>) OR (<column> = <column>) Brings Errors
[GPU Error Bug] SELECT * FROM <table> WHERE ((<column> + <column>) < <column>) OR (<column> = <column>) Brings Errors
Oct 18, 2023
Describe:
Using SELECT * FROM <table> WHERE ((<column> + <column>) < <column>) OR (<column> = <column>) 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: