[CALCITE-5039] View:Timestamp cannot query Data:Long in GMT+8 TimeZone Env

• Type: Improvement
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 1.29.0, 1.30.0
• Component/s: core, jdbc-driver
• Labels: TimeZone Timestamp
• Assignee: Unassigned
• Reporter: itxiangkui
• Created: 14/Mar/22 03:16
• Updated: 08/Apr/22 07:04

Description

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'  and channel='ios';

```

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'

 

 

Issue Links

• relates to: CALCITE-5027 Incorrect format for timestamp literals in SqlDialect#quoteTimestampLiteral