Alessandro Solimando created CALCITE-2145: ---------------------------------------------
Summary: Avatica tests fail depending on local timezone Key: CALCITE-2145 URL: https://issues.apache.org/jira/browse/CALCITE-2145 Project: Calcite Issue Type: Bug Components: avatica Affects Versions: avatica-1.10.0, avatica-1.11.0 Reporter: Alessandro Solimando Running the tests runs correctly with timezone forced to UTC, but fail with other timezones (verified with GMT+8 and GMT+2). All methods using default locale (e.g., Locale.getDefault()) or timezone (e.g., TimeZone.getDefault()) should have been forbidden (-CALCITE-1167-). For instance, this command works: {panel} MAVEN_OPTS="$MAVEN_OPTS -Duser.timezone=UTC" mvn clean test {panel} This other command fails: {panel} MAVEN_OPTS="$MAVEN_OPTS -Duser.timezone=GMT+8" mvn clean test {panel} In what follows the relevant extract from console when running mvn test. {panel:title=mvn clean test console output extract} [...] 2018-01-22 01:56:02,633 [main] INFO - Creating table BATCH_EXECUTE_33 2018-01-22 01:56:02,635 [main] INFO - Creating table BATCH_EXECUTE_34 2018-01-22 01:56:02,675 [main] INFO - Creating table BATCH_CLEARS_36 2018-01-22 01:56:02,676 [main] INFO - Creating table BATCH_CLEARS_37 Tests run: 78, Failures: 2, Errors: 0, Skipped: 4, Time elapsed: 0.569 sec <<< FAILURE! - in org.apache.calcite.avatica.RemoteDriverTest testBatchInsertWithDates[JSON](org.apache.calcite.avatica.RemoteDriverTest) Time elapsed: 0.013 sec <<< FAILURE! java.lang.AssertionError: Wrong day for row 0 expected:<21> but was:<20> at org.apache.calcite.avatica.RemoteDriverTest.executeBatchInsertWithDates(RemoteDriverTest.java:1444) at org.apache.calcite.avatica.RemoteDriverTest.access$1100(RemoteDriverTest.java:91) at org.apache.calcite.avatica.RemoteDriverTest.eachConnection(RemoteDriverTest.java:228) at org.apache.calcite.avatica.RemoteDriverTest.testBatchInsertWithDates(RemoteDriverTest.java:1379) testBatchInsertWithDates[PROTOBUF](org.apache.calcite.avatica.RemoteDriverTest) Time elapsed: 0.003 sec <<< FAILURE! java.lang.AssertionError: Wrong day for row 0 expected:<21> but was:<20> at org.apache.calcite.avatica.RemoteDriverTest.executeBatchInsertWithDates(RemoteDriverTest.java:1444) at org.apache.calcite.avatica.RemoteDriverTest.access$1100(RemoteDriverTest.java:91) at org.apache.calcite.avatica.RemoteDriverTest.eachConnection(RemoteDriverTest.java:228) at org.apache.calcite.avatica.RemoteDriverTest.testBatchInsertWithDates(RemoteDriverTest.java:1379) [...] Results : Failed tests: RemoteDriverTest.testBatchInsertWithDates:1379->eachConnection:228->access$1100:91->executeBatchInsertWithDates:1444 Wrong day for row 0 expected:<21> but was:<20> RemoteDriverTest.testBatchInsertWithDates:1379->eachConnection:228->access$1100:91->executeBatchInsertWithDates:1444 Wrong day for row 0 expected:<21> but was:<20> Tests run: 219, Failures: 2, Errors: 0, Skipped: 15 [INFO] ------------------------------------------------------------------------ [INFO] Reactor Summary: [INFO] [INFO] Apache Calcite Avatica Project ..................... SUCCESS [ 2.233 s] [INFO] Apache Calcite Avatica Metrics ..................... SUCCESS [ 2.984 s] [INFO] Apache Calcite Avatica ............................. SUCCESS [ 26.595 s] [INFO] Apache Calcite Avatica Server ...................... FAILURE [ 13.671 s] [INFO] Apache Calcite Avatica Standalone Server ........... SKIPPED [INFO] Apache Calcite Avatica Docker images ............... SKIPPED [INFO] Apache Calcite Avatica Dropwizard Metrics 3 ........ SKIPPED [INFO] Apache Calcite Avatica Noop Driver ................. SKIPPED [INFO] Apache Calcite Avatica Compatibility Kit ........... SKIPPED [INFO] Apache Calcite Avatica (Shaded) .................... SKIPPED [INFO] ------------------------------------------------------------------------ [INFO] BUILD FAILURE [INFO] ------------------------------------------------------------------------ [...] {panel} -- This message was sent by Atlassian JIRA (v7.6.3#76005)