BlazingDB / blazingsql

BlazingSQL is a lightweight, GPU accelerated, SQL engine for Python. Built on RAPIDS cuDF.
https://blazingsql.com
Apache License 2.0
1.92k stars 181 forks source link

[BUG] IS NOT FALSE throws an RunExecuteGraph exception #1446

Closed drabastomek closed 3 years ago

drabastomek commented 3 years ago

Describe the bug SQL call SELECT * FROM <foo> WHERE <bool_column> IS NOT FALSE prints out an Exception message from the graph

>>>>>>>>  [RunExecuteGraph Error] std::exception

while SELECT * FROM <foo> WHERE <bool_column> IS TRUE or (conversely) SELECT * FROM <foo> WHERE <bool_column> IS NOT TRUE are fine.

Moreover, the code above prints an exception message in Jupyter but does not throw a proper Exception.

Steps/Code to reproduce bug

import blazingsql as bsql
import cudf

df = cudf.DataFrame({'bools': [True, False, True, True, False]})
bc = bsql.BlazingContext()
bc.create_table('bools_table', df)

bc.sql('SELECT * FROM bools_table WHERE bools IS NOT FALSE')

Expected behavior Should return all the rows where values is TRUE.

Environment overview (please complete the following information)