[GPU Error Bug] <column> NOT IN <column(overflow)> Brings Errors

[qwebug]

Describe:

Using \ NOT IN \<column(overflow)> brings different results , when set EXECUTOR_DEVICE 'CPU' and 'GPU'.

SQL:

CREATE TABLE IF NOT EXISTS t0(c0 INT, c1 INT);
INSERT INTO t0(c1, c0) VALUES(-2016839045, 8138);
ALTER SESSION SET EXECUTOR_DEVICE='CPU';
SELECT t0.c0 FROM t0 WHERE (t0.c0) NOT IN (t0.c1+t0.c1, t0.c0);

Result:

No rows returned.

SQL:

ALTER SESSION SET EXECUTOR_DEVICE='GPU';
SELECT t0.c0 FROM t0 WHERE (t0.c0) NOT IN (t0.c1+t0.c1, t0.c0);

Result:

ERR_OVERFLOW_OR_UNDERFLOW: Overflow or underflow.

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

[Carmelo006]

HeavyDB v7.2.4 has fixed it. Thanks to report.