link3280 commented on code in PR #4751:
URL: https://github.com/apache/kyuubi/pull/4751#discussion_r1174377431
##########
externals/kyuubi-flink-sql-engine/src/test/scala/org/apache/kyuubi/engine/flink/operation/FlinkOperationSuite.scala:
##########
@@ -739,6 +739,23 @@ abstract class FlinkOperationSuite extends
HiveJDBCTestHelper with WithFlinkTest
}
}
+ test("execute statement - select timestamp with local time zone") {
+ withJdbcStatement() { statement =>
+ statement.executeQuery("CREATE VIEW T1 AS SELECT TO_TIMESTAMP_LTZ(4001,
3)")
+ statement.executeQuery("SET 'table.local-time-zone' = 'UTC'")
+ val resultSetUTC = statement.executeQuery("SELECT * FROM T1")
+ val metaData = resultSetUTC.getMetaData
+ assert(metaData.getColumnType(1) === java.sql.Types.OTHER)
+ assert(resultSetUTC.next())
+ assert(resultSetUTC.getString(1) === "1970-01-01 00:00:04.001 UTC")
Review Comment:
`TIMESTAMP WITH LOCAL ZONE` should not show the zone part. Something is
wrong.
--
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]
