dask-sql icon indicating copy to clipboard operation
dask-sql copied to clipboard

[BUG] [GPU Logic Bug] SELECT -0.0 FROM <table> brings Error

Open qwebug opened this issue 1 year ago • 0 comments

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:

qwebug avatar Oct 18 '24 07:10 qwebug