[ARROW-10753] [Rust] [DataFusion] Negative numbers in SQL WHERE clause not parsed correctly

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 2.0.0
• Fix Version/s: 3.0.0
• Component/s: Rust - DataFusion
• Labels: pull-request-available
• Environment: Any (MacOS 10.15.6)
• External issue URL: https://github.com/apache/arrow/issues/26697
• Assignee: Evan Chan
• Reporter: Evan Chan
• Created: 27/Nov/20 22:16
• Updated: 11/Jan/23 08:15
• Resolved: 03/Dec/20 11:17

Description

Negative numbers in SQL WHERE clauses are not parsed correctly:

 

```

> create external table blogs stored as PARQUET location '../../testing/data/parquet/generated_simple_numerics/blogs.par0 rows in set. Query took 0 seconds.
> select reply, blog_id from blogs where blog_id >= -1000;
InternalError("SQL binary operator cannot be interpreted as a unary operator")

```

The above can be seen with different data files, and with both integer and floating point negative numbers.    The exception comes from planner.rs sql_to_rex() function, in the UnaryOp case, so it is data independent.   jorgecarleitao  seems you have made commits here, WDYT?

I'm not sure if the problem is SQLParser itself but the fix seems quite easy, basically to parse this:

UnaryOp { op: Minus, expr: Value(Number("1")) }

It can be seen in latest master also.

I'm up for contributing a fix if this is confirmed as a bug.

Issue Links

• links to: GitHub Pull Request #8815