[BUG] [GPU Logic Bug] SELECT (CASE <DATE> WHEN <DATE> THEN <DATE> END) FROM <table> brings Error

[qwebug]

What happened:

SELECT (CASE <DATE> WHEN <DATE> THEN <DATE> END) FROM <table> brings different results, when using CPU and GPU execution.

What you expected to happen:

It is the same result, when using CPU and GPU execution.

Minimal Complete Verifiable Example:

import pandas as pd
import dask.dataframe as dd
from dask_sql import Context

c = Context()

df0 = pd.DataFrame({
    'c0': [True],
})
t0 = dd.from_pandas(df0, npartitions=1)

c.create_table('t0', t0, gpu=False)
c.create_table('t0_gpu', t0, gpu=True)

print('CPU Result:')
result1= c.sql("SELECT (CASE DATE '2005-05-21' WHEN DATE '1981-07-19' THEN DATE '2015-04-07' END ) FROM t0").compute()
print(result1)

print('GPU Result:')
result2= c.sql("SELECT (CASE DATE '2005-05-21' WHEN DATE '1981-07-19' THEN DATE '2015-04-07' END ) FROM t0_gpu").compute()
print(result2)

Result:

INFO:numba.cuda.cudadrv.driver:init
CPU Result:
  CASE Utf8("2005-05-21") WHEN Utf8("1981-07-19") THEN Utf8("2015-04-07") END
0                                                NaT                         
GPU Result:
  CASE Utf8("2005-05-21") WHEN Utf8("1981-07-19") THEN Utf8("2015-04-07") END
0                                               <NA>        

Anything else we need to know?:

Environment:

• dask-sql version: 2023.6.0
• Python version: Python 3.10.11
• Operating System: Ubuntu22.04
• Install method (conda, pip, source): Docker deploy by https://hub.docker.com/layers/rapidsai/rapidsai-dev/23.06-cuda11.8-devel-ubuntu22.04-py3.10/images/sha256-cfbb61fdf7227b090a435a2e758114f3f1c31872ed8dbd96e5e564bb5fd184a7?context=explore

[qwebug]

This problem came up at dask-sql version: 2023.6.0 .
And it has been fixed at dask-sql version: 2024.5.0, after my verification.
Thanks to the developers for their contributions.

[griffith-maker]

Dask-sql version 2024.3.0 has fixed this issue, thanks for your report.