dask-sql
dask-sql copied to clipboard
[BUG] [GPU Logic Bug] SELECT -0.0 FROM <table> brings Error
What happened:
SELECT -0.0 FROM <table> brings different results, when using CPU and GPU.
What you expected to happen:
It is the same result, when using CPU and GPU.
Minimal Complete Verifiable Example:
import pandas as pd
import dask.dataframe as dd
from dask_sql import Context
c = Context()
df0 = pd.DataFrame({
'c0': [0],
})
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 -0.0 FROM t0").compute()
print(result1)
print('GPU Result:')
result2 = c.sql("SELECT -0.0 FROM t0_gpu").compute()
print(result2)
Result:
CPU Result:
Float64(-0)
0 -0.0
GPU Result:
Float64(-0)
0 0.0
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