itxiangkui created CALCITE-5039:
-----------------------------------
Summary: View:Timestamp cannot query Data:Long in GMT+8 TimeZone
Env
Key: CALCITE-5039
URL: https://issues.apache.org/jira/browse/CALCITE-5039
Project: Calcite
Issue Type: Bug
Components: jdbc-driver
Affects Versions: 1.29.0
Reporter: itxiangkui
When I have a row like :
|ts:TimeStamp|channel:String|pv:Long|
|1647187200000|ios|10|
while 1647187200000 is a timestamp in TimeZone of "GMT+8",the datetime is
"2022-03-14 00:00:00"
but you can not query the data using a sql like :
```sql
select * from table where ts='2022-03-14 00:00:00';
select * from table where ts<'2022-03-14 00:00:01' and ts>'2022-03-13
23:59:59' ;
```
it is like the jdbc-fether will filter the data when match the
timestampString,while the timestamp String looks like '2022-03-13 16:00:00' or
'2022-03-14 08:00:00'
--
This message was sent by Atlassian Jira
(v8.20.1#820001)
