xiedeyantu commented on code in PR #4910: URL: https://github.com/apache/calcite/pull/4910#discussion_r3151828946
########## babel/src/test/resources/sql/big-query.iq: ########## @@ -30,6 +30,32 @@ !use scott-big-query !set outputformat mysql +# Test case for [CALCITE-7491] https://issues.apache.org/jira/browse/CALCITE-7491 +# Literals of type TIMESTAMP WITH TIME ZONE cause crashes +# This will change once we fix [CALCITE-7494] +# Avatica conversion to string of TIMESTAMP WITH TIME ZONE +# does not include time zone +select TIMESTAMP WITH TIME ZONE '2020-01-01 00:00:00 America/New_York'; ++---------------------+ +| EXPR$0 | ++---------------------+ +| 2020-01-01 05:00:00 | ++---------------------+ +(1 row) + +!ok + +# Two timestamps with time zone are equal if they represent the same UTC time +SELECT TIMESTAMP WITH TIME ZONE '2020-01-01 08:10:10 America/New_York' = TIMESTAMP WITH TIME ZONE '2020-01-01 05:10:10 America/Los_Angeles'; Review Comment: If you have this plan, then you don't need to add it; you can supplement it with more comprehensive testing in the new PR. -- 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]
