[ARROW-11412] [Python] Expressions not working with logical boolean operators (and, or, not)

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 2.0.0, 3.0.0
• Fix Version/s: 4.0.0
• Component/s: Python
• Labels: pull-request-available
• External issue URL: https://github.com/apache/arrow/issues/18483
• Assignee: Joris Van den Bossche
• Reporter: Roman Karlstetter
• Created: 28/Jan/21 06:25
• Updated: 11/Jan/23 08:19
• Resolved: 05/Feb/21 16:26

Description

There's a problem with boolean "and", "or" and "not" expressions when creating them in python (or I'm doing something completely stupid).

 

>>> import pyarrow
>>> pyarrow.__version__
'3.0.0'
>>> import pyarrow.dataset as ds
>>> ds. scalar(False) and ds.scalar(True) # <--- I expect false
<pyarrow.dataset.Expression true>
>>> ds.scalar(True) and ds.scalar(False) # this works
<pyarrow.dataset.Expression false>

>>> ds.scalar(True) or ds.scalar(False) # this works
<pyarrow.dataset.Expression true>
>>> ds.scalar(False) or ds.scalar(True) # <--- I expect true
<pyarrow.dataset.Expression false>

>>> not ds.scalar(True)   # this works                                                                                                                                                                                                  
False                                                                                                                                                                                                                       
>>> not ds.scalar(False)      <--- I expect true                                                                                                                                                                                              
False  

I tried to figure out what goes wrong here, but there are no obvious problems in the python code, same for C++ (but I didn't quite understand everything of it yet).

 

This happens with pyarrow3 and pyarrow2

 

 

Issue Links

• links to: GitHub Pull Request #9351
• links to: GitHub Pull Request #9352