Jefffrey commented on issue #1193: URL: https://github.com/apache/arrow-datafusion/issues/1193#issuecomment-1313168283
Seems to be resolved as of master 96512ac05df40deb42632992cece656842d6debb
Running on datafusion-cli:
```sql
DataFusion CLI v14.0.0
❯ select null between 5 and null as foo;
+-----+
| foo |
+-----+
| |
+-----+
1 row in set. Query took 0.003 seconds.
❯ explain verbose select null between 5 and null as foo;
+------------------------------------------------------------+---------------------------------------------------------------------------------+
| plan_type | plan
|
+------------------------------------------------------------+---------------------------------------------------------------------------------+
| initial_logical_plan | Projection:
NULL BETWEEN Int64(5) AND NULL AS foo |
| |
EmptyRelation |
| logical_plan after inline_table_scan | SAME TEXT AS
ABOVE |
| logical_plan after type_coercion | Projection:
CAST(NULL AS Int64) BETWEEN Int64(5) AND CAST(NULL AS Int64) AS foo |
| |
EmptyRelation |
| logical_plan after simplify_expressions | Projection:
Boolean(NULL) AS foo |
| |
EmptyRelation |
| logical_plan after unwrap_cast_in_comparison | SAME TEXT AS
ABOVE |
| logical_plan after decorrelate_where_exists | SAME TEXT AS
ABOVE |
...
| logical_plan after common_sub_expression_eliminate | SAME TEXT AS
ABOVE |
| logical_plan after projection_push_down | SAME TEXT AS
ABOVE |
| logical_plan | Projection:
Boolean(NULL) AS foo |
| |
EmptyRelation |
| initial_physical_plan |
ProjectionExec: expr=[NULL as foo]
|
| | EmptyExec:
produce_one_row=true |
| |
|
| physical_plan after aggregate_statistics | SAME TEXT AS
ABOVE |
| physical_plan after hash_build_probe_order | SAME TEXT AS
ABOVE |
| physical_plan after BasicEnforcement | SAME TEXT AS
ABOVE |
| physical_plan after coalesce_batches | SAME TEXT AS
ABOVE |
| physical_plan after repartition | SAME TEXT AS
ABOVE |
| physical_plan after BasicEnforcement | SAME TEXT AS
ABOVE |
| physical_plan |
ProjectionExec: expr=[NULL as foo]
|
| | EmptyExec:
produce_one_row=true |
| |
|
+------------------------------------------------------------+---------------------------------------------------------------------------------+
54 rows in set. Query took 0.003 seconds.
❯
```
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
