[CALCITE-2243] Timestamp values change with remote connection when the result set size exceeds 100 rows - ASF JIRA

Log work

Agile Board

Rank to Top

Rank to Bottom

Attach files

Attach Screenshot

Bulk Copy Attachments

Bulk Move Attachments

Add vote

Voters

Watch issue

Watchers

Create sub-task

Convert to sub-task

Link

Clone

Labels

Update Comment Author

Replace String in Comment

Update Comment Visibility

Delete Comments

XML

Word

Printable

JSON

Details

Type: Bug
Status: Open
Priority: Major
Resolution: Unresolved
Affects Version/s: 1.16.0
Fix Version/s: None
Component/s: core
Labels:
None

Description

Table queries with TIMESTAMP values return incorrect values when the result set size is larger than 100 rows. Perhaps the timezone shift is calculated twice, as the first 100 lines are correct and the bug always occurs after that. The default fetch size in the code seems to be 100. The bug should be reproducable by running the attached code, which the same model with local and remote connection and gets a different data as a result.

Some output shortly:

Local:

#1 TIME=2018-04-09 11:20:38.31; FORMATTED=9.4.2018 14:20:38
#2 TIME=2018-04-09 11:20:38.31; FORMATTED=9.4.2018 14:20:38
#100 TIME=2018-04-09 11:20:38.31; FORMATTED=9.4.2018 14:20:38
#101 TIME=2018-04-09 11:20:38.31; FORMATTED=9.4.2018 14:20:38
#102 TIME=2018-04-09 11:20:38.31; FORMATTED=9.4.2018 14:20:38
#200 TIME=2018-04-09 11:20:38.31; FORMATTED=9.4.2018 14:20:38

Remote:

#1 TIME=2018-04-09 11:20:38.31; FORMATTED=9.4.2018 14:20:38
#2 TIME=2018-04-09 11:20:38.31; FORMATTED=9.4.2018 14:20:38
#100 TIME=2018-04-09 11:20:38.31; FORMATTED=9.4.2018 14:20:38
#101 TIME=2018-04-09 08:20:38.31; FORMATTED=9.4.2018 14:20:38
#102 TIME=2018-04-09 08:20:38.31; FORMATTED=9.4.2018 14:20:38
#200 TIME=2018-04-09 08:20:38.31; FORMATTED=9.4.2018 14:20:38

TimestampsIssue.java