jayzhan211 commented on issue #10310:
URL: https://github.com/apache/datafusion/issues/10310#issuecomment-2089915430
An example to reproduce.
```
statement ok
create table t1 as values (
date_bin(interval '1 hour', '2022-08-03 14:38:50Z' at time zone
'Europe/Brussels'),
date_bin(interval '1 hour', '2022-08-03 14:38:50Z' at time zone
'Europe/Brussels'));
query error
select * from t1 where column1 >= '2019-03-27T22:00:00.000Z'::timestamp at
time zone 'Europe/Brussels';
----
DataFusion error: Internal error: binary_op should be handled by
sql_expr_to_logical_expr..
This was likely caused by a bug in DataFusion's code and we would welcome
that you file an bug report in our issue tracker
```
sql we got in `sql_expr_to_logical_expr`
```
sql: AtTimeZone { timestamp: BinaryOp { left: Identifier(Ident { value:
"column1", quote_style: None }), op: GtEq, right: Cast { expr:
Value(SingleQuotedString("2019-03-27T22:00:00.000Z")), data_type:
Timestamp(None, None), format: None } }, time_zone: "Europe/Brussels" }
```
We need to support `AtTimeZone`, and maybe timezone casting 🤔 ?
--
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]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
