Logic AND is case sensitive.

[xzdandy]

Search before asking

• I have searched the EvaDB issues and found no similar bug report.

Bug

SELECT * FROM postgres_data.home_rentals where neighborhood='downtown' and number_of_rooms=2 crashed with the following error message:

11-11-2023 20:25:59 ERROR [plan_executor:plan_executor.py:execute_plan:0179] local variable 'mask' referenced before assignment
Traceback (most recent call last):
  File "/usr/local/lib/python3.10/dist-packages/evadb/executor/plan_executor.py", line 175, in execute_plan
    yield from output
  File "/usr/local/lib/python3.10/dist-packages/evadb/executor/project_executor.py", line 48, in exec
    for batch in child_executor.exec(**kwargs):
  File "/usr/local/lib/python3.10/dist-packages/evadb/executor/predicate_executor.py", line 37, in exec
    batch = apply_predicate(batch, self.predicate)
  File "/usr/local/lib/python3.10/dist-packages/evadb/executor/executor_utils.py", line 77, in apply_predicate
    outcomes = predicate.evaluate(batch)
  File "/usr/local/lib/python3.10/dist-packages/evadb/expression/logical_expression.py", line 52, in evaluate
    pushdown_batch = batch[mask]
UnboundLocalError: local variable 'mask' referenced before assignment

Meanwhile, SELECT * FROM postgres_data.home_rentals where neighborhood='downtown' AND number_of_rooms=2 works as expected.

Environment

From Slack cummunity: https://evadb.slack.com/archives/C047S6Z0V40/p1699376705485419

Are you willing to submit a PR?

• Yes I'd like to help by submitting a PR!