Skip to content
New issue

Have a question about this project? # for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “#”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? # to your account

[GPU Logic Bug] SELECT <column> FROM <table> Brings Errors #834

Open
qwebug opened this issue Jun 5, 2024 · 0 comments
Open

[GPU Logic Bug] SELECT <column> FROM <table> Brings Errors #834

qwebug opened this issue Jun 5, 2024 · 0 comments

Comments

@qwebug
Copy link

qwebug commented Jun 5, 2024

Describe:

SELECT <column> FROM <table> brings different results, when using CPU-only configurations and GPU-used configurations.

SQL with CPU-only Config:

CREATE TABLE t1(c0 FLOAT NULL);
INSERT INTO t1(c0) VALUES('Infinity');
INSERT INTO t1(c0) VALUES(0.1);
ALTER SESSION SET EXECUTOR_DEVICE='CPU';
SELECT CAST(CAST(t1.c0 AS INT) AS BOOLEAN) FROM t1;

Result:

EXPR$0
NULL
false

SQL with GPU-used Config:

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

Result:

EXPR$0
true
false

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

# for free to join this conversation on GitHub. Already have an account? # to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant