[
https://issues.apache.org/jira/browse/CALCITE-2013?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16208555#comment-16208555
]
Francis Chuang commented on CALCITE-2013:
-----------------------------------------
I bumped hsqldb in pom.mxl to 2.4.0, but the tests are failing:
Relevant parts of the output:
{code:java}
Running
org.apache.calcite.avatica.server.HttpQueryStringParameterRemoteUserExtractorTest
2017-10-18 09:54:02,116 [main] INFO - No metrics implementation available on
classpath. Using No-op implementation
2017-10-18 09:54:02,117 [main] INFO - jetty-9.2.19.v20160908
2017-10-18 09:54:02,124 [main] INFO - Started
ServerConnector@61d84e08{HTTP/1.1}{0.0.0.0:45983}
2017-10-18 09:54:02,124 [main] INFO - Started @5516ms
2017-10-18 09:54:02,124 [main] INFO - Service listening on port 45983.
2017-10-18 09:54:02,124 [main] INFO - No metrics implementation available on
classpath. Using No-op implementation
2017-10-18 09:54:02,127 [main] INFO - jetty-9.2.19.v20160908
2017-10-18 09:54:02,140 [main] INFO - Started
ServerConnector@6014a9ba{HTTP/1.1}{0.0.0.0:40999}
2017-10-18 09:54:02,140 [main] INFO - Started @5532ms
2017-10-18 09:54:02,140 [main] INFO - Service listening on port 40999.
2017-10-18 09:54:02,239 [main] INFO - Caught expected exception
java.lang.RuntimeException: Failed to execute HTTP Request, got HTTP/403
at
org.apache.calcite.avatica.remote.AvaticaCommonsHttpClientImpl.send(AvaticaCommonsHttpClientImpl.java:190)
at
org.apache.calcite.avatica.remote.RemoteService.apply(RemoteService.java:34)
at
org.apache.calcite.avatica.remote.JsonService.apply(JsonService.java:172)
at org.apache.calcite.avatica.remote.Driver.connect(Driver.java:176)
at java.sql.DriverManager.getConnection(DriverManager.java:664)
at java.sql.DriverManager.getConnection(DriverManager.java:208)
at
org.apache.calcite.avatica.server.HttpAuthBase.readWriteData(HttpAuthBase.java:63)
at
org.apache.calcite.avatica.server.HttpQueryStringParameterRemoteUserExtractorTest.testUserWithDisallowedDoAsRole(HttpQueryStringParameterRemoteUserExtractorTest.java:163)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at
org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:50)
at
org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12)
at
org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:47)
at
org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:17)
at org.junit.runners.ParentRunner.runLeaf(ParentRunner.java:325)
at
org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:78)
at
org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:57)
at org.junit.runners.ParentRunner$3.run(ParentRunner.java:290)
at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:71)
at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:288)
at org.junit.runners.ParentRunner.access$000(ParentRunner.java:58)
at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:268)
at org.junit.runners.ParentRunner.run(ParentRunner.java:363)
at org.junit.runners.Suite.runChild(Suite.java:128)
at org.junit.runners.Suite.runChild(Suite.java:27)
at org.junit.runners.ParentRunner$3.run(ParentRunner.java:290)
at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:71)
at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:288)
at org.junit.runners.ParentRunner.access$000(ParentRunner.java:58)
at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:268)
at
org.junit.internal.runners.statements.RunBefores.evaluate(RunBefores.java:26)
at
org.junit.internal.runners.statements.RunAfters.evaluate(RunAfters.java:27)
at org.junit.runners.ParentRunner.run(ParentRunner.java:363)
at
org.apache.maven.surefire.junit4.JUnit4Provider.execute(JUnit4Provider.java:367)
at
org.apache.maven.surefire.junit4.JUnit4Provider.executeWithRerun(JUnit4Provider.java:274)
at
org.apache.maven.surefire.junit4.JUnit4Provider.executeTestSet(JUnit4Provider.java:238)
at
org.apache.maven.surefire.junit4.JUnit4Provider.invoke(JUnit4Provider.java:161)
at
org.apache.maven.surefire.booter.ForkedBooter.invokeProviderInSameClassLoader(ForkedBooter.java:290)
at
org.apache.maven.surefire.booter.ForkedBooter.runSuitesInProcess(ForkedBooter.java:242)
at
org.apache.maven.surefire.booter.ForkedBooter.main(ForkedBooter.java:121)
2017-10-18 09:54:02,246 [main] INFO - Caught expected exception
java.lang.RuntimeException: Failed to execute HTTP Request, got HTTP/401
at
org.apache.calcite.avatica.remote.AvaticaCommonsHttpClientImpl.send(AvaticaCommonsHttpClientImpl.java:190)
at
org.apache.calcite.avatica.remote.RemoteService.apply(RemoteService.java:34)
at
org.apache.calcite.avatica.remote.JsonService.apply(JsonService.java:172)
at org.apache.calcite.avatica.remote.Driver.connect(Driver.java:176)
at java.sql.DriverManager.getConnection(DriverManager.java:664)
at java.sql.DriverManager.getConnection(DriverManager.java:208)
at
org.apache.calcite.avatica.server.HttpAuthBase.readWriteData(HttpAuthBase.java:63)
at
org.apache.calcite.avatica.server.HttpQueryStringParameterRemoteUserExtractorTest.testUserWithDisallowedRole(HttpQueryStringParameterRemoteUserExtractorTest.java:153)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at
org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:50)
at
org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12)
at
org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:47)
at
org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:17)
at org.junit.runners.ParentRunner.runLeaf(ParentRunner.java:325)
at
org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:78)
at
org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:57)
at org.junit.runners.ParentRunner$3.run(ParentRunner.java:290)
at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:71)
at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:288)
at org.junit.runners.ParentRunner.access$000(ParentRunner.java:58)
at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:268)
at org.junit.runners.ParentRunner.run(ParentRunner.java:363)
at org.junit.runners.Suite.runChild(Suite.java:128)
at org.junit.runners.Suite.runChild(Suite.java:27)
at org.junit.runners.ParentRunner$3.run(ParentRunner.java:290)
at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:71)
at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:288)
at org.junit.runners.ParentRunner.access$000(ParentRunner.java:58)
at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:268)
at
org.junit.internal.runners.statements.RunBefores.evaluate(RunBefores.java:26)
at
org.junit.internal.runners.statements.RunAfters.evaluate(RunAfters.java:27)
at org.junit.runners.ParentRunner.run(ParentRunner.java:363)
at
org.apache.maven.surefire.junit4.JUnit4Provider.execute(JUnit4Provider.java:367)
at
org.apache.maven.surefire.junit4.JUnit4Provider.executeWithRerun(JUnit4Provider.java:274)
at
org.apache.maven.surefire.junit4.JUnit4Provider.executeTestSet(JUnit4Provider.java:238)
at
org.apache.maven.surefire.junit4.JUnit4Provider.invoke(JUnit4Provider.java:161)
at
org.apache.maven.surefire.booter.ForkedBooter.invokeProviderInSameClassLoader(ForkedBooter.java:290)
at
org.apache.maven.surefire.booter.ForkedBooter.runSuitesInProcess(ForkedBooter.java:242)
at
org.apache.maven.surefire.booter.ForkedBooter.main(ForkedBooter.java:121)
2017-10-18 09:54:02,342 [main] INFO - Caught expected exception
java.lang.RuntimeException: Failed to execute HTTP Request, got HTTP/403
at
org.apache.calcite.avatica.remote.AvaticaCommonsHttpClientImpl.send(AvaticaCommonsHttpClientImpl.java:190)
at
org.apache.calcite.avatica.remote.RemoteProtobufService._apply(RemoteProtobufService.java:45)
at
org.apache.calcite.avatica.remote.ProtobufService.apply(ProtobufService.java:81)
at org.apache.calcite.avatica.remote.Driver.connect(Driver.java:176)
at java.sql.DriverManager.getConnection(DriverManager.java:664)
at java.sql.DriverManager.getConnection(DriverManager.java:208)
at
org.apache.calcite.avatica.server.HttpAuthBase.readWriteData(HttpAuthBase.java:63)
at
org.apache.calcite.avatica.server.HttpQueryStringParameterRemoteUserExtractorTest.testUserWithDisallowedDoAsRole(HttpQueryStringParameterRemoteUserExtractorTest.java:163)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at
org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:50)
at
org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12)
at
org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:47)
at
org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:17)
at org.junit.runners.ParentRunner.runLeaf(ParentRunner.java:325)
at
org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:78)
at
org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:57)
at org.junit.runners.ParentRunner$3.run(ParentRunner.java:290)
at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:71)
at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:288)
at org.junit.runners.ParentRunner.access$000(ParentRunner.java:58)
at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:268)
at org.junit.runners.ParentRunner.run(ParentRunner.java:363)
at org.junit.runners.Suite.runChild(Suite.java:128)
at org.junit.runners.Suite.runChild(Suite.java:27)
at org.junit.runners.ParentRunner$3.run(ParentRunner.java:290)
at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:71)
at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:288)
at org.junit.runners.ParentRunner.access$000(ParentRunner.java:58)
at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:268)
at
org.junit.internal.runners.statements.RunBefores.evaluate(RunBefores.java:26)
at
org.junit.internal.runners.statements.RunAfters.evaluate(RunAfters.java:27)
at org.junit.runners.ParentRunner.run(ParentRunner.java:363)
at
org.apache.maven.surefire.junit4.JUnit4Provider.execute(JUnit4Provider.java:367)
at
org.apache.maven.surefire.junit4.JUnit4Provider.executeWithRerun(JUnit4Provider.java:274)
at
org.apache.maven.surefire.junit4.JUnit4Provider.executeTestSet(JUnit4Provider.java:238)
at
org.apache.maven.surefire.junit4.JUnit4Provider.invoke(JUnit4Provider.java:161)
at
org.apache.maven.surefire.booter.ForkedBooter.invokeProviderInSameClassLoader(ForkedBooter.java:290)
at
org.apache.maven.surefire.booter.ForkedBooter.runSuitesInProcess(ForkedBooter.java:242)
at
org.apache.maven.surefire.booter.ForkedBooter.main(ForkedBooter.java:121)
2017-10-18 09:54:02,347 [main] INFO - Caught expected exception
java.lang.RuntimeException: Failed to execute HTTP Request, got HTTP/401
at
org.apache.calcite.avatica.remote.AvaticaCommonsHttpClientImpl.send(AvaticaCommonsHttpClientImpl.java:190)
at
org.apache.calcite.avatica.remote.RemoteProtobufService._apply(RemoteProtobufService.java:45)
at
org.apache.calcite.avatica.remote.ProtobufService.apply(ProtobufService.java:81)
at org.apache.calcite.avatica.remote.Driver.connect(Driver.java:176)
at java.sql.DriverManager.getConnection(DriverManager.java:664)
at java.sql.DriverManager.getConnection(DriverManager.java:208)
at
org.apache.calcite.avatica.server.HttpAuthBase.readWriteData(HttpAuthBase.java:63)
at
org.apache.calcite.avatica.server.HttpQueryStringParameterRemoteUserExtractorTest.testUserWithDisallowedRole(HttpQueryStringParameterRemoteUserExtractorTest.java:153)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at
org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:50)
at
org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12)
at
org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:47)
at
org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:17)
at org.junit.runners.ParentRunner.runLeaf(ParentRunner.java:325)
at
org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:78)
at
org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:57)
at org.junit.runners.ParentRunner$3.run(ParentRunner.java:290)
at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:71)
at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:288)
at org.junit.runners.ParentRunner.access$000(ParentRunner.java:58)
at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:268)
at org.junit.runners.ParentRunner.run(ParentRunner.java:363)
at org.junit.runners.Suite.runChild(Suite.java:128)
at org.junit.runners.Suite.runChild(Suite.java:27)
at org.junit.runners.ParentRunner$3.run(ParentRunner.java:290)
at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:71)
at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:288)
at org.junit.runners.ParentRunner.access$000(ParentRunner.java:58)
at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:268)
at
org.junit.internal.runners.statements.RunBefores.evaluate(RunBefores.java:26)
at
org.junit.internal.runners.statements.RunAfters.evaluate(RunAfters.java:27)
at org.junit.runners.ParentRunner.run(ParentRunner.java:363)
at
org.apache.maven.surefire.junit4.JUnit4Provider.execute(JUnit4Provider.java:367)
at
org.apache.maven.surefire.junit4.JUnit4Provider.executeWithRerun(JUnit4Provider.java:274)
at
org.apache.maven.surefire.junit4.JUnit4Provider.executeTestSet(JUnit4Provider.java:238)
at
org.apache.maven.surefire.junit4.JUnit4Provider.invoke(JUnit4Provider.java:161)
at
org.apache.maven.surefire.booter.ForkedBooter.invokeProviderInSameClassLoader(ForkedBooter.java:290)
at
org.apache.maven.surefire.booter.ForkedBooter.runSuitesInProcess(ForkedBooter.java:242)
at
org.apache.maven.surefire.booter.ForkedBooter.main(ForkedBooter.java:121)
2017-10-18 09:54:02,348 [main] INFO - Service terminating.
2017-10-18 09:54:02,349 [main] INFO - Stopped
ServerConnector@61d84e08{HTTP/1.1}{0.0.0.0:0}
2017-10-18 09:54:02,350 [main] INFO - Service terminating.
2017-10-18 09:54:02,351 [main] INFO - Stopped
ServerConnector@6014a9ba{HTTP/1.1}{0.0.0.0:0}
Tests run: 6, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.259 sec - in
org.apache.calcite.avatica.server.HttpQueryStringParameterRemoteUserExtractorTest
Running org.apache.calcite.avatica.server.HttpServerBuilderTest
2017-10-18 09:54:02,374 [main] INFO - No metrics implementation available on
classpath. Using No-op implementation
2017-10-18 09:54:02,375 [main] INFO - No metrics implementation available on
classpath. Using No-op implementation
2017-10-18 09:54:02,375 [main] INFO - No metrics implementation available on
classpath. Using No-op implementation
2017-10-18 09:54:02,375 [main] INFO - No metrics implementation available on
classpath. Using No-op implementation
2017-10-18 09:54:02,375 [main] INFO - No metrics implementation available on
classpath. Using No-op implementation
2017-10-18 09:54:02,376 [main] INFO - No metrics implementation available on
classpath. Using No-op implementation
2017-10-18 09:54:02,376 [main] INFO - No metrics implementation available on
classpath. Using No-op implementation
2017-10-18 09:54:02,376 [main] INFO - No metrics implementation available on
classpath. Using No-op implementation
Tests run: 8, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.002 sec - in
org.apache.calcite.avatica.server.HttpServerBuilderTest
Running org.apache.calcite.avatica.server.HttpServerSpnegoWithJaasTest
2017-10-18 09:54:02,377 [main] INFO - Starting KDC server at localhost:37839
2017-10-18 09:54:02,380 [main] INFO - Creating client with keytab
/home/francis/Desktop/avatica/server/target/HttpServerSpnegoWithJaasTest_keytabs/client.keytab
2017-10-18 09:54:02,380 [main] INFO - Creating HTTP/[email protected] with
keytab
/home/francis/Desktop/avatica/server/target/HttpServerSpnegoWithJaasTest_keytabs/HTTP_localhost.keytab
2017-10-18 09:54:02,381 [main] INFO - jetty-9.2.19.v20160908
2017-10-18 09:54:02,442 [main] INFO - Started
ServerConnector@3efedc6f{HTTP/1.1}{0.0.0.0:37909}
2017-10-18 09:54:02,442 [main] INFO - Started @5835ms
2017-10-18 09:54:02,442 [main] INFO - Service listening on port 37909.
2017-10-18 09:54:02,443 [main] INFO - HTTP server running at
http://localhost:37909
2017-10-18 09:54:02,443 [main] INFO - Connecting to http://localhost:37909
2017-10-18 09:54:02,460 [pool-2-thread-1] INFO - Client entry is empty.
2017-10-18 09:54:02,460 [pool-2-thread-1] INFO - The preauth data is empty.
2017-10-18 09:54:02,460 [pool-2-thread-1] INFO - KRB error occurred while
processing request:Additional pre-authentication required
2017-10-18 09:54:02,473 [pool-2-thread-2] INFO - Client entry is empty.
2017-10-18 09:54:02,483 [main] INFO - Using TGT with etype: AES128
2017-10-18 09:54:02,490 [pool-2-thread-2] INFO - Client entry is empty.
2017-10-18 09:54:02,498 [main] INFO - Stopping HTTP server at
http://localhost:37909
2017-10-18 09:54:02,499 [main] INFO - Service terminating.
2017-10-18 09:54:02,500 [main] INFO - Stopped
ServerConnector@3efedc6f{HTTP/1.1}{0.0.0.0:0}
2017-10-18 09:54:02,504 [main] INFO - Stopping KDC on 37839
Tests run: 2, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.128 sec - in
org.apache.calcite.avatica.server.HttpServerSpnegoWithJaasTest
Running org.apache.calcite.avatica.server.BasicAuthHttpServerTest
2017-10-18 09:54:02,506 [main] INFO - No metrics implementation available on
classpath. Using No-op implementation
2017-10-18 09:54:02,506 [main] INFO - jetty-9.2.19.v20160908
2017-10-18 09:54:02,512 [main] INFO - Started
ServerConnector@4c2fb9dd{HTTP/1.1}{0.0.0.0:41595}
2017-10-18 09:54:02,512 [main] INFO - Started @5905ms
2017-10-18 09:54:02,512 [main] INFO - Service listening on port 41595.
2017-10-18 09:54:02,614 [main] INFO - Service terminating.
2017-10-18 09:54:02,624 [main] INFO - Stopped
ServerConnector@4c2fb9dd{HTTP/1.1}{0.0.0.0:0}
Tests run: 6, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.123 sec - in
org.apache.calcite.avatica.server.BasicAuthHttpServerTest
Running org.apache.calcite.avatica.AvaticaSpnegoTest
Tests run: 1, Failures: 0, Errors: 0, Skipped: 1, Time elapsed: 0 sec - in
org.apache.calcite.avatica.AvaticaSpnegoTest
Running org.apache.calcite.avatica.jdbc.StatementInfoTest
Tests run: 5, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.164 sec - in
org.apache.calcite.avatica.jdbc.StatementInfoTest
Running org.apache.calcite.avatica.jdbc.JdbcMetaTest
Tests run: 5, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.214 sec - in
org.apache.calcite.avatica.jdbc.JdbcMetaTest
Running org.apache.calcite.avatica.RemoteDriverMockTest
Tests run: 16, Failures: 0, Errors: 0, Skipped: 8, Time elapsed: 0.014 sec - in
org.apache.calcite.avatica.RemoteDriverMockTest
Running org.apache.calcite.avatica.RemoteDriverTest
2017-10-18 09:54:03,069 [main] INFO - Creating table
PREPARED_INSERT_EXECUTE_NULLS
2017-10-18 09:54:03,071 [main] INFO - Creating table
PREPARED_INSERT_EXECUTE_NULLS_2
2017-10-18 09:54:03,086 [main] INFO - Creating table PREPARED_INSERT_EXECUTE
2017-10-18 09:54:03,088 [main] INFO - Creating table PREPARED_INSERT_EXECUTE_5
2017-10-18 09:54:03,113 [main] INFO - Creating table BATCH_INSERT_EXECUTE_DATES
2017-10-18 09:54:03,118 [main] INFO - Creating table BATCH_INSERT_EXECUTE_NULLS
2017-10-18 09:54:03,120 [main] INFO - Creating table
BATCH_INSERT_EXECUTE_NULLS_8
2017-10-18 09:54:03,138 [main] INFO - Creating table BATCH_EXECUTE
2017-10-18 09:54:03,139 [main] INFO - Creating table BATCH_EXECUTE_10
2017-10-18 09:54:03,179 [main] INFO - Creating table PREPARED_BATCH_EXECUTE
2017-10-18 09:54:03,181 [main] INFO - Creating table PREPARED_BATCH_EXECUTE_12
java.lang.RuntimeException: java.sql.SQLException: exception while executing
query: unbound parameter
at org.apache.calcite.avatica.jdbc.JdbcMeta.propagate(JdbcMeta.java:700)
at org.apache.calcite.avatica.jdbc.JdbcMeta.execute(JdbcMeta.java:897)
at
org.apache.calcite.avatica.remote.LocalService.apply(LocalService.java:254)
at
org.apache.calcite.avatica.remote.Service$ExecuteRequest.accept(Service.java:1032)
at
org.apache.calcite.avatica.remote.Service$ExecuteRequest.accept(Service.java:1002)
at
org.apache.calcite.avatica.remote.LocalJsonService.apply(LocalJsonService.java:36)
at
org.apache.calcite.avatica.RemoteDriverTest$LoggingLocalJsonService.apply(RemoteDriverTest.java:2037)
at
org.apache.calcite.avatica.remote.JsonService.apply(JsonService.java:148)
at
org.apache.calcite.avatica.remote.RemoteMeta$15.call(RemoteMeta.java:344)
at
org.apache.calcite.avatica.remote.RemoteMeta$15.call(RemoteMeta.java:342)
at
org.apache.calcite.avatica.AvaticaConnection.invokeWithRetries(AvaticaConnection.java:756)
at
org.apache.calcite.avatica.remote.RemoteMeta.execute(RemoteMeta.java:341)
at
org.apache.calcite.avatica.AvaticaConnection.executeQueryInternal(AvaticaConnection.java:511)
at
org.apache.calcite.avatica.AvaticaPreparedStatement.executeQuery(AvaticaPreparedStatement.java:133)
at
org.apache.calcite.avatica.RemoteDriverTest.checkPrepareBindExecuteFetch(RemoteDriverTest.java:886)
at
org.apache.calcite.avatica.RemoteDriverTest.testPrepareBindExecuteFetch(RemoteDriverTest.java:865)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at
org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:50)
at
org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12)
at
org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:47)
at
org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:17)
at
org.junit.internal.runners.statements.RunBefores.evaluate(RunBefores.java:26)
at org.junit.runners.ParentRunner.runLeaf(ParentRunner.java:325)
at
org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:78)
at
org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:57)
at org.junit.runners.ParentRunner$3.run(ParentRunner.java:290)
at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:71)
at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:288)
at org.junit.runners.ParentRunner.access$000(ParentRunner.java:58)
at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:268)
at org.junit.runners.ParentRunner.run(ParentRunner.java:363)
at org.junit.runners.Suite.runChild(Suite.java:128)
at org.junit.runners.Suite.runChild(Suite.java:27)
at org.junit.runners.ParentRunner$3.run(ParentRunner.java:290)
at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:71)
at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:288)
at org.junit.runners.ParentRunner.access$000(ParentRunner.java:58)
at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:268)
at org.junit.runners.ParentRunner.run(ParentRunner.java:363)
at
org.apache.maven.surefire.junit4.JUnit4Provider.execute(JUnit4Provider.java:367)
at
org.apache.maven.surefire.junit4.JUnit4Provider.executeWithRerun(JUnit4Provider.java:274)
at
org.apache.maven.surefire.junit4.JUnit4Provider.executeTestSet(JUnit4Provider.java:238)
at
org.apache.maven.surefire.junit4.JUnit4Provider.invoke(JUnit4Provider.java:161)
at
org.apache.maven.surefire.booter.ForkedBooter.invokeProviderInSameClassLoader(ForkedBooter.java:290)
at
org.apache.maven.surefire.booter.ForkedBooter.runSuitesInProcess(ForkedBooter.java:242)
at
org.apache.maven.surefire.booter.ForkedBooter.main(ForkedBooter.java:121)
Caused by: java.sql.SQLException: exception while executing query: unbound
parameter
at org.apache.calcite.avatica.jdbc.JdbcMeta.execute(JdbcMeta.java:850)
... 47 more
2017-10-18 09:54:03,208 [main] INFO - Caught expected error
java.sql.SQLException: java.sql.SQLException: exception while executing query:
unbound parameter
at org.apache.calcite.avatica.Helper.createException(Helper.java:56)
at org.apache.calcite.avatica.Helper.createException(Helper.java:41)
at
org.apache.calcite.avatica.AvaticaConnection.executeQueryInternal(AvaticaConnection.java:520)
at
org.apache.calcite.avatica.AvaticaPreparedStatement.executeQuery(AvaticaPreparedStatement.java:133)
at
org.apache.calcite.avatica.RemoteDriverTest.checkPrepareBindExecuteFetch(RemoteDriverTest.java:886)
at
org.apache.calcite.avatica.RemoteDriverTest.testPrepareBindExecuteFetch(RemoteDriverTest.java:865)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at
org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:50)
at
org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12)
at
org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:47)
at
org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:17)
at
org.junit.internal.runners.statements.RunBefores.evaluate(RunBefores.java:26)
at org.junit.runners.ParentRunner.runLeaf(ParentRunner.java:325)
at
org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:78)
at
org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:57)
at org.junit.runners.ParentRunner$3.run(ParentRunner.java:290)
at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:71)
at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:288)
at org.junit.runners.ParentRunner.access$000(ParentRunner.java:58)
at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:268)
at org.junit.runners.ParentRunner.run(ParentRunner.java:363)
at org.junit.runners.Suite.runChild(Suite.java:128)
at org.junit.runners.Suite.runChild(Suite.java:27)
at org.junit.runners.ParentRunner$3.run(ParentRunner.java:290)
at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:71)
at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:288)
at org.junit.runners.ParentRunner.access$000(ParentRunner.java:58)
at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:268)
at org.junit.runners.ParentRunner.run(ParentRunner.java:363)
at
org.apache.maven.surefire.junit4.JUnit4Provider.execute(JUnit4Provider.java:367)
at
org.apache.maven.surefire.junit4.JUnit4Provider.executeWithRerun(JUnit4Provider.java:274)
at
org.apache.maven.surefire.junit4.JUnit4Provider.executeTestSet(JUnit4Provider.java:238)
at
org.apache.maven.surefire.junit4.JUnit4Provider.invoke(JUnit4Provider.java:161)
at
org.apache.maven.surefire.booter.ForkedBooter.invokeProviderInSameClassLoader(ForkedBooter.java:290)
at
org.apache.maven.surefire.booter.ForkedBooter.runSuitesInProcess(ForkedBooter.java:242)
at
org.apache.maven.surefire.booter.ForkedBooter.main(ForkedBooter.java:121)
Caused by: java.lang.RuntimeException: java.sql.SQLException: exception while
executing query: unbound parameter
at org.apache.calcite.avatica.jdbc.JdbcMeta.propagate(JdbcMeta.java:700)
at org.apache.calcite.avatica.jdbc.JdbcMeta.execute(JdbcMeta.java:897)
at
org.apache.calcite.avatica.remote.LocalService.apply(LocalService.java:254)
at
org.apache.calcite.avatica.remote.Service$ExecuteRequest.accept(Service.java:1032)
at
org.apache.calcite.avatica.remote.Service$ExecuteRequest.accept(Service.java:1002)
at
org.apache.calcite.avatica.remote.LocalJsonService.apply(LocalJsonService.java:36)
at
org.apache.calcite.avatica.RemoteDriverTest$LoggingLocalJsonService.apply(RemoteDriverTest.java:2037)
at
org.apache.calcite.avatica.remote.JsonService.apply(JsonService.java:148)
at
org.apache.calcite.avatica.remote.RemoteMeta$15.call(RemoteMeta.java:344)
at
org.apache.calcite.avatica.remote.RemoteMeta$15.call(RemoteMeta.java:342)
at
org.apache.calcite.avatica.AvaticaConnection.invokeWithRetries(AvaticaConnection.java:756)
at
org.apache.calcite.avatica.remote.RemoteMeta.execute(RemoteMeta.java:341)
at
org.apache.calcite.avatica.AvaticaConnection.executeQueryInternal(AvaticaConnection.java:511)
... 36 more
Caused by: java.sql.SQLException: exception while executing query: unbound
parameter
at org.apache.calcite.avatica.jdbc.JdbcMeta.execute(JdbcMeta.java:850)
... 47 more
{"request":"openConnection","connectionId":"28368568-dc4c-41e1-a235-d3ff14b675f4","info":{}}={"response":"openConnection","rpcMetadata":null}
{"request":"connectionSync","connectionId":"28368568-dc4c-41e1-a235-d3ff14b675f4","connProps":{"connProps":"connPropsImpl","autoCommit":null,"readOnly":null,"transactionIsolation":null,"catalog":null,"schema":null,"dirty":true}}={"response":"connectionSync","connProps":{"connProps":"connPropsImpl","autoCommit":true,"readOnly":false,"transactionIsolation":2,"catalog":"PUBLIC","schema":"SCOTT","dirty":false},"rpcMetadata":null}
{"request":"prepare","connectionId":"28368568-dc4c-41e1-a235-d3ff14b675f4","sql":"select
cast(? as integer) * 3 as c, 'x' as x\nfrom (values (1,
'a'))","maxRowCount":-1}={"response":"prepare","statement":{"connectionId":"28368568-dc4c-41e1-a235-d3ff14b675f4","id":0,"signature":{"columns":[{"ordinal":0,"autoIncrement":false,"caseSensitive":false,"searchable":false,"currency":false,"nullable":2,"signed":true,"displaySize":20,"label":"C","columnName":"C","schemaName":"","precision":64,"scale":0,"tableName":"","catalogName":"","type":{"type":"scalar","id":-5,"name":"BIGINT","rep":"PRIMITIVE_LONG"},"readOnly":true,"writable":false,"definitelyWritable":false,"columnClassName":"java.lang.Long"},{"ordinal":1,"autoIncrement":false,"caseSensitive":true,"searchable":false,"currency":false,"nullable":0,"signed":false,"displaySize":1,"label":"X","columnName":"X","schemaName":"","precision":1,"scale":0,"tableName":"","catalogName":"","type":{"type":"scalar","id":1,"name":"CHARACTER","rep":"STRING"},"readOnly":true,"writable":false,"definitelyWritable":false,"columnClassName":"java.lang.String"}],"sql":"select
cast(? as integer) * 3 as c, 'x' as x\nfrom (values (1,
'a'))","parameters":[{"signed":true,"precision":10,"scale":0,"parameterType":4,"typeName":"INTEGER","className":"java.lang.Integer","name":"?1"}],"cursorFactory":{"style":"LIST","clazz":null,"fieldNames":null},"statementType":null}},"rpcMetadata":null}
{"request":"execute","statementHandle":{"connectionId":"28368568-dc4c-41e1-a235-d3ff14b675f4","id":0,"signature":{"columns":[{"ordinal":0,"autoIncrement":false,"caseSensitive":false,"searchable":false,"currency":false,"nullable":2,"signed":true,"displaySize":20,"label":"C","columnName":"C","schemaName":"","precision":64,"scale":0,"tableName":"","catalogName":"","type":{"type":"scalar","id":-5,"name":"BIGINT","rep":"NUMBER"},"readOnly":true,"writable":false,"definitelyWritable":false,"columnClassName":"java.lang.Long"},{"ordinal":1,"autoIncrement":false,"caseSensitive":true,"searchable":false,"currency":false,"nullable":0,"signed":false,"displaySize":1,"label":"X","columnName":"X","schemaName":"","precision":1,"scale":0,"tableName":"","catalogName":"","type":{"type":"scalar","id":1,"name":"CHARACTER","rep":"STRING"},"readOnly":true,"writable":false,"definitelyWritable":false,"columnClassName":"java.lang.String"}],"sql":"select
cast(? as integer) * 3 as c, 'x' as x\nfrom (values (1,
'a'))","parameters":[{"signed":true,"precision":10,"scale":0,"parameterType":4,"typeName":"INTEGER","className":"java.lang.Integer","name":"?1"}],"cursorFactory":{"style":"LIST","clazz":null,"fieldNames":null},"statementType":null}},"parameterValues":[null],"maxRowCount":100}=null
{"request":"execute","statementHandle":{"connectionId":"28368568-dc4c-41e1-a235-d3ff14b675f4","id":0,"signature":{"columns":[{"ordinal":0,"autoIncrement":false,"caseSensitive":false,"searchable":false,"currency":false,"nullable":2,"signed":true,"displaySize":20,"label":"C","columnName":"C","schemaName":"","precision":64,"scale":0,"tableName":"","catalogName":"","type":{"type":"scalar","id":-5,"name":"BIGINT","rep":"NUMBER"},"readOnly":true,"writable":false,"definitelyWritable":false,"columnClassName":"java.lang.Long"},{"ordinal":1,"autoIncrement":false,"caseSensitive":true,"searchable":false,"currency":false,"nullable":0,"signed":false,"displaySize":1,"label":"X","columnName":"X","schemaName":"","precision":1,"scale":0,"tableName":"","catalogName":"","type":{"type":"scalar","id":1,"name":"CHARACTER","rep":"STRING"},"readOnly":true,"writable":false,"definitelyWritable":false,"columnClassName":"java.lang.String"}],"sql":"select
cast(? as integer) * 3 as c, 'x' as x\nfrom (values (1,
'a'))","parameters":[{"signed":true,"precision":10,"scale":0,"parameterType":4,"typeName":"INTEGER","className":"java.lang.Integer","name":"?1"}],"cursorFactory":{"style":"LIST","clazz":null,"fieldNames":null},"statementType":null}},"parameterValues":[{"type":"INTEGER","value":10,"componentType":null}],"maxRowCount":100}={"response":"executeResults","missingStatement":false,"rpcMetadata":null,"results":[{"response":"resultSet","connectionId":"28368568-dc4c-41e1-a235-d3ff14b675f4","statementId":0,"ownStatement":true,"signature":{"columns":[{"ordinal":0,"autoIncrement":false,"caseSensitive":false,"searchable":false,"currency":false,"nullable":2,"signed":true,"displaySize":20,"label":"C","columnName":"C","schemaName":"","precision":64,"scale":0,"tableName":"","catalogName":"","type":{"type":"scalar","id":-5,"name":"BIGINT","rep":"PRIMITIVE_LONG"},"readOnly":true,"writable":false,"definitelyWritable":false,"columnClassName":"java.lang.Long"},{"ordinal":1,"autoIncrement":false,"caseSensitive":true,"searchable":false,"currency":false,"nullable":0,"signed":false,"displaySize":1,"label":"X","columnName":"X","schemaName":"","precision":1,"scale":0,"tableName":"","catalogName":"","type":{"type":"scalar","id":1,"name":"CHARACTER","rep":"STRING"},"readOnly":true,"writable":false,"definitelyWritable":false,"columnClassName":"java.lang.String"}],"sql":"select
cast(? as integer) * 3 as c, 'x' as x\nfrom (values (1,
'a'))","parameters":[{"signed":true,"precision":10,"scale":0,"parameterType":4,"typeName":"INTEGER","className":"java.lang.Integer","name":"?1"}],"cursorFactory":{"style":"LIST","clazz":null,"fieldNames":null},"statementType":"SELECT"},"firstFrame":{"offset":0,"done":true,"rows":[[30,"x"]]},"updateCount":-1,"rpcMetadata":null}]}
{"request":"execute","statementHandle":{"connectionId":"28368568-dc4c-41e1-a235-d3ff14b675f4","id":0,"signature":{"columns":[{"ordinal":0,"autoIncrement":false,"caseSensitive":false,"searchable":false,"currency":false,"nullable":2,"signed":true,"displaySize":20,"label":"C","columnName":"C","schemaName":"","precision":64,"scale":0,"tableName":"","catalogName":"","type":{"type":"scalar","id":-5,"name":"BIGINT","rep":"NUMBER"},"readOnly":true,"writable":false,"definitelyWritable":false,"columnClassName":"java.lang.Long"},{"ordinal":1,"autoIncrement":false,"caseSensitive":true,"searchable":false,"currency":false,"nullable":0,"signed":false,"displaySize":1,"label":"X","columnName":"X","schemaName":"","precision":1,"scale":0,"tableName":"","catalogName":"","type":{"type":"scalar","id":1,"name":"CHARACTER","rep":"STRING"},"readOnly":true,"writable":false,"definitelyWritable":false,"columnClassName":"java.lang.String"}],"sql":"select
cast(? as integer) * 3 as c, 'x' as x\nfrom (values (1,
'a'))","parameters":[{"signed":true,"precision":10,"scale":0,"parameterType":4,"typeName":"INTEGER","className":"java.lang.Integer","name":"?1"}],"cursorFactory":{"style":"LIST","clazz":null,"fieldNames":null},"statementType":null}},"parameterValues":[{"type":"INTEGER","value":20,"componentType":null}],"maxRowCount":100}={"response":"executeResults","missingStatement":false,"rpcMetadata":null,"results":[{"response":"resultSet","connectionId":"28368568-dc4c-41e1-a235-d3ff14b675f4","statementId":0,"ownStatement":true,"signature":{"columns":[{"ordinal":0,"autoIncrement":false,"caseSensitive":false,"searchable":false,"currency":false,"nullable":2,"signed":true,"displaySize":20,"label":"C","columnName":"C","schemaName":"","precision":64,"scale":0,"tableName":"","catalogName":"","type":{"type":"scalar","id":-5,"name":"BIGINT","rep":"PRIMITIVE_LONG"},"readOnly":true,"writable":false,"definitelyWritable":false,"columnClassName":"java.lang.Long"},{"ordinal":1,"autoIncrement":false,"caseSensitive":true,"searchable":false,"currency":false,"nullable":0,"signed":false,"displaySize":1,"label":"X","columnName":"X","schemaName":"","precision":1,"scale":0,"tableName":"","catalogName":"","type":{"type":"scalar","id":1,"name":"CHARACTER","rep":"STRING"},"readOnly":true,"writable":false,"definitelyWritable":false,"columnClassName":"java.lang.String"}],"sql":"select
cast(? as integer) * 3 as c, 'x' as x\nfrom (values (1,
'a'))","parameters":[{"signed":true,"precision":10,"scale":0,"parameterType":4,"typeName":"INTEGER","className":"java.lang.Integer","name":"?1"}],"cursorFactory":{"style":"LIST","clazz":null,"fieldNames":null},"statementType":"SELECT"},"firstFrame":{"offset":0,"done":true,"rows":[[60,"x"]]},"updateCount":-1,"rpcMetadata":null}]}
{"request":"execute","statementHandle":{"connectionId":"28368568-dc4c-41e1-a235-d3ff14b675f4","id":0,"signature":{"columns":[{"ordinal":0,"autoIncrement":false,"caseSensitive":false,"searchable":false,"currency":false,"nullable":2,"signed":true,"displaySize":20,"label":"C","columnName":"C","schemaName":"","precision":64,"scale":0,"tableName":"","catalogName":"","type":{"type":"scalar","id":-5,"name":"BIGINT","rep":"NUMBER"},"readOnly":true,"writable":false,"definitelyWritable":false,"columnClassName":"java.lang.Long"},{"ordinal":1,"autoIncrement":false,"caseSensitive":true,"searchable":false,"currency":false,"nullable":0,"signed":false,"displaySize":1,"label":"X","columnName":"X","schemaName":"","precision":1,"scale":0,"tableName":"","catalogName":"","type":{"type":"scalar","id":1,"name":"CHARACTER","rep":"STRING"},"readOnly":true,"writable":false,"definitelyWritable":false,"columnClassName":"java.lang.String"}],"sql":"select
cast(? as integer) * 3 as c, 'x' as x\nfrom (values (1,
'a'))","parameters":[{"signed":true,"precision":10,"scale":0,"parameterType":4,"typeName":"INTEGER","className":"java.lang.Integer","name":"?1"}],"cursorFactory":{"style":"LIST","clazz":null,"fieldNames":null},"statementType":null}},"parameterValues":[{"type":"OBJECT","value":null,"componentType":null}],"maxRowCount":100}={"response":"executeResults","missingStatement":false,"rpcMetadata":null,"results":[{"response":"resultSet","connectionId":"28368568-dc4c-41e1-a235-d3ff14b675f4","statementId":0,"ownStatement":true,"signature":{"columns":[{"ordinal":0,"autoIncrement":false,"caseSensitive":false,"searchable":false,"currency":false,"nullable":2,"signed":true,"displaySize":20,"label":"C","columnName":"C","schemaName":"","precision":64,"scale":0,"tableName":"","catalogName":"","type":{"type":"scalar","id":-5,"name":"BIGINT","rep":"PRIMITIVE_LONG"},"readOnly":true,"writable":false,"definitelyWritable":false,"columnClassName":"java.lang.Long"},{"ordinal":1,"autoIncrement":false,"caseSensitive":true,"searchable":false,"currency":false,"nullable":0,"signed":false,"displaySize":1,"label":"X","columnName":"X","schemaName":"","precision":1,"scale":0,"tableName":"","catalogName":"","type":{"type":"scalar","id":1,"name":"CHARACTER","rep":"STRING"},"readOnly":true,"writable":false,"definitelyWritable":false,"columnClassName":"java.lang.String"}],"sql":"select
cast(? as integer) * 3 as c, 'x' as x\nfrom (values (1,
'a'))","parameters":[{"signed":true,"precision":10,"scale":0,"parameterType":4,"typeName":"INTEGER","className":"java.lang.Integer","name":"?1"}],"cursorFactory":{"style":"LIST","clazz":null,"fieldNames":null},"statementType":"SELECT"},"firstFrame":{"offset":0,"done":true,"rows":[[null,"x"]]},"updateCount":-1,"rpcMetadata":null}]}
{"request":"closeStatement","connectionId":"28368568-dc4c-41e1-a235-d3ff14b675f4","statementId":0}={"response":"closeStatement","rpcMetadata":null}
{"request":"closeConnection","connectionId":"28368568-dc4c-41e1-a235-d3ff14b675f4"}={"response":"closeConnection","rpcMetadata":null}
2017-10-18 09:54:03,213 [main] INFO - Creating table BATCH_EXECUTE_13
2017-10-18 09:54:03,214 [main] INFO - Creating table BATCH_EXECUTE_14
2017-10-18 09:54:03,277 [main] INFO - Creating table BATCH_CLEARS
2017-10-18 09:54:03,278 [main] INFO - Creating table BATCH_CLEARS_17
2017-10-18 09:54:03,324 [main] INFO - Creating table
PREPARED_INSERT_EXECUTE_NULLS_19
2017-10-18 09:54:03,325 [main] INFO - Creating table
PREPARED_INSERT_EXECUTE_NULLS_20
2017-10-18 09:54:03,337 [main] INFO - Creating table PREPARED_INSERT_EXECUTE_22
2017-10-18 09:54:03,338 [main] INFO - Creating table PREPARED_INSERT_EXECUTE_23
2017-10-18 09:54:03,345 [main] INFO - Creating table
BATCH_INSERT_EXECUTE_DATES_24
2017-10-18 09:54:03,348 [main] INFO - Creating table
BATCH_INSERT_EXECUTE_NULLS_25
2017-10-18 09:54:03,349 [main] INFO - Creating table
BATCH_INSERT_EXECUTE_NULLS_26
2017-10-18 09:54:03,364 [main] INFO - Creating table BATCH_EXECUTE_27
2017-10-18 09:54:03,367 [main] INFO - Creating table BATCH_EXECUTE_28
2017-10-18 09:54:03,543 [main] INFO - Creating table PREPARED_BATCH_EXECUTE_29
2017-10-18 09:54:03,544 [main] INFO - Creating table PREPARED_BATCH_EXECUTE_30
java.lang.RuntimeException: java.lang.RuntimeException: java.sql.SQLException:
exception while executing query: unbound parameter
at
org.apache.calcite.avatica.RemoteDriverTest$LoggingLocalProtobufService._apply(RemoteDriverTest.java:1861)
at
org.apache.calcite.avatica.remote.ProtobufService.apply(ProtobufService.java:97)
at
org.apache.calcite.avatica.remote.RemoteMeta$15.call(RemoteMeta.java:344)
at
org.apache.calcite.avatica.remote.RemoteMeta$15.call(RemoteMeta.java:342)
at
org.apache.calcite.avatica.AvaticaConnection.invokeWithRetries(AvaticaConnection.java:756)
at
org.apache.calcite.avatica.remote.RemoteMeta.execute(RemoteMeta.java:341)
at
org.apache.calcite.avatica.AvaticaConnection.executeQueryInternal(AvaticaConnection.java:511)
at
org.apache.calcite.avatica.AvaticaPreparedStatement.executeQuery(AvaticaPreparedStatement.java:133)
at
org.apache.calcite.avatica.RemoteDriverTest.checkPrepareBindExecuteFetch(RemoteDriverTest.java:886)
at
org.apache.calcite.avatica.RemoteDriverTest.testPrepareBindExecuteFetch(RemoteDriverTest.java:865)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at
org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:50)
at
org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12)
at
org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:47)
at
org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:17)
at
org.junit.internal.runners.statements.RunBefores.evaluate(RunBefores.java:26)
at org.junit.runners.ParentRunner.runLeaf(ParentRunner.java:325)
at
org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:78)
at
org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:57)
at org.junit.runners.ParentRunner$3.run(ParentRunner.java:290)
at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:71)
at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:288)
at org.junit.runners.ParentRunner.access$000(ParentRunner.java:58)
at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:268)
at org.junit.runners.ParentRunner.run(ParentRunner.java:363)
at org.junit.runners.Suite.runChild(Suite.java:128)
at org.junit.runners.Suite.runChild(Suite.java:27)
at org.junit.runners.ParentRunner$3.run(ParentRunner.java:290)
at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:71)
at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:288)
at org.junit.runners.ParentRunner.access$000(ParentRunner.java:58)
at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:268)
at org.junit.runners.ParentRunner.run(ParentRunner.java:363)
at
org.apache.maven.surefire.junit4.JUnit4Provider.execute(JUnit4Provider.java:367)
at
org.apache.maven.surefire.junit4.JUnit4Provider.executeWithRerun(JUnit4Provider.java:274)
at
org.apache.maven.surefire.junit4.JUnit4Provider.executeTestSet(JUnit4Provider.java:238)
at
org.apache.maven.surefire.junit4.JUnit4Provider.invoke(JUnit4Provider.java:161)
at
org.apache.maven.surefire.booter.ForkedBooter.invokeProviderInSameClassLoader(ForkedBooter.java:290)
at
org.apache.maven.surefire.booter.ForkedBooter.runSuitesInProcess(ForkedBooter.java:242)
at
org.apache.maven.surefire.booter.ForkedBooter.main(ForkedBooter.java:121)
Caused by: java.lang.RuntimeException: java.sql.SQLException: exception while
executing query: unbound parameter
at org.apache.calcite.avatica.jdbc.JdbcMeta.propagate(JdbcMeta.java:700)
at org.apache.calcite.avatica.jdbc.JdbcMeta.execute(JdbcMeta.java:897)
at
org.apache.calcite.avatica.remote.LocalService.apply(LocalService.java:254)
at
org.apache.calcite.avatica.remote.Service$ExecuteRequest.accept(Service.java:1032)
at
org.apache.calcite.avatica.remote.Service$ExecuteRequest.accept(Service.java:1002)
at
org.apache.calcite.avatica.remote.LocalProtobufService._apply(LocalProtobufService.java:46)
at
org.apache.calcite.avatica.RemoteDriverTest$LoggingLocalProtobufService._apply(RemoteDriverTest.java:1854)
... 42 more
Caused by: java.sql.SQLException: exception while executing query: unbound
parameter
at org.apache.calcite.avatica.jdbc.JdbcMeta.execute(JdbcMeta.java:850)
... 47 more
2017-10-18 09:54:03,588 [main] INFO - Caught expected error
java.sql.SQLException: java.lang.RuntimeException: java.sql.SQLException:
exception while executing query: unbound parameter
at org.apache.calcite.avatica.Helper.createException(Helper.java:56)
at org.apache.calcite.avatica.Helper.createException(Helper.java:41)
at
org.apache.calcite.avatica.AvaticaConnection.executeQueryInternal(AvaticaConnection.java:520)
at
org.apache.calcite.avatica.AvaticaPreparedStatement.executeQuery(AvaticaPreparedStatement.java:133)
at
org.apache.calcite.avatica.RemoteDriverTest.checkPrepareBindExecuteFetch(RemoteDriverTest.java:886)
at
org.apache.calcite.avatica.RemoteDriverTest.testPrepareBindExecuteFetch(RemoteDriverTest.java:865)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at
org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:50)
at
org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12)
at
org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:47)
at
org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:17)
at
org.junit.internal.runners.statements.RunBefores.evaluate(RunBefores.java:26)
at org.junit.runners.ParentRunner.runLeaf(ParentRunner.java:325)
at
org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:78)
at
org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:57)
at org.junit.runners.ParentRunner$3.run(ParentRunner.java:290)
at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:71)
at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:288)
at org.junit.runners.ParentRunner.access$000(ParentRunner.java:58)
at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:268)
at org.junit.runners.ParentRunner.run(ParentRunner.java:363)
at org.junit.runners.Suite.runChild(Suite.java:128)
at org.junit.runners.Suite.runChild(Suite.java:27)
at org.junit.runners.ParentRunner$3.run(ParentRunner.java:290)
at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:71)
at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:288)
at org.junit.runners.ParentRunner.access$000(ParentRunner.java:58)
at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:268)
at org.junit.runners.ParentRunner.run(ParentRunner.java:363)
at
org.apache.maven.surefire.junit4.JUnit4Provider.execute(JUnit4Provider.java:367)
at
org.apache.maven.surefire.junit4.JUnit4Provider.executeWithRerun(JUnit4Provider.java:274)
at
org.apache.maven.surefire.junit4.JUnit4Provider.executeTestSet(JUnit4Provider.java:238)
at
org.apache.maven.surefire.junit4.JUnit4Provider.invoke(JUnit4Provider.java:161)
at
org.apache.maven.surefire.booter.ForkedBooter.invokeProviderInSameClassLoader(ForkedBooter.java:290)
at
org.apache.maven.surefire.booter.ForkedBooter.runSuitesInProcess(ForkedBooter.java:242)
at
org.apache.maven.surefire.booter.ForkedBooter.main(ForkedBooter.java:121)
Caused by: java.lang.RuntimeException: java.lang.RuntimeException:
java.sql.SQLException: exception while executing query: unbound parameter
at
org.apache.calcite.avatica.RemoteDriverTest$LoggingLocalProtobufService._apply(RemoteDriverTest.java:1861)
at
org.apache.calcite.avatica.remote.ProtobufService.apply(ProtobufService.java:97)
at
org.apache.calcite.avatica.remote.RemoteMeta$15.call(RemoteMeta.java:344)
at
org.apache.calcite.avatica.remote.RemoteMeta$15.call(RemoteMeta.java:342)
at
org.apache.calcite.avatica.AvaticaConnection.invokeWithRetries(AvaticaConnection.java:756)
at
org.apache.calcite.avatica.remote.RemoteMeta.execute(RemoteMeta.java:341)
at
org.apache.calcite.avatica.AvaticaConnection.executeQueryInternal(AvaticaConnection.java:511)
... 36 more
Caused by: java.lang.RuntimeException: java.sql.SQLException: exception while
executing query: unbound parameter
at org.apache.calcite.avatica.jdbc.JdbcMeta.propagate(JdbcMeta.java:700)
at org.apache.calcite.avatica.jdbc.JdbcMeta.execute(JdbcMeta.java:897)
at
org.apache.calcite.avatica.remote.LocalService.apply(LocalService.java:254)
at
org.apache.calcite.avatica.remote.Service$ExecuteRequest.accept(Service.java:1032)
at
org.apache.calcite.avatica.remote.Service$ExecuteRequest.accept(Service.java:1002)
at
org.apache.calcite.avatica.remote.LocalProtobufService._apply(LocalProtobufService.java:46)
at
org.apache.calcite.avatica.RemoteDriverTest$LoggingLocalProtobufService._apply(RemoteDriverTest.java:1854)
... 42 more
Caused by: java.sql.SQLException: exception while executing query: unbound
parameter
at org.apache.calcite.avatica.jdbc.JdbcMeta.execute(JdbcMeta.java:850)
... 47 more
{"request":"openConnection","connectionId":"06ca3ee7-f5f6-4f8a-a929-d706ae894e7b","info":{}}={"response":"openConnection","rpcMetadata":null}
{"request":"connectionSync","connectionId":"06ca3ee7-f5f6-4f8a-a929-d706ae894e7b","connProps":{"connProps":"connPropsImpl","autoCommit":null,"readOnly":null,"transactionIsolation":null,"catalog":null,"schema":null,"dirty":true}}={"response":"connectionSync","connProps":{"connProps":"connPropsImpl","autoCommit":true,"readOnly":false,"transactionIsolation":2,"catalog":"PUBLIC","schema":"SCOTT","dirty":false},"rpcMetadata":null}
{"request":"prepare","connectionId":"06ca3ee7-f5f6-4f8a-a929-d706ae894e7b","sql":"select
cast(? as integer) * 3 as c, 'x' as x\nfrom (values (1,
'a'))","maxRowCount":-1}={"response":"prepare","statement":{"connectionId":"06ca3ee7-f5f6-4f8a-a929-d706ae894e7b","id":0,"signature":{"columns":[{"ordinal":0,"autoIncrement":false,"caseSensitive":false,"searchable":false,"currency":false,"nullable":2,"signed":true,"displaySize":20,"label":"C","columnName":"C","schemaName":null,"precision":64,"scale":0,"tableName":null,"catalogName":null,"type":{"type":"scalar","id":-5,"name":"BIGINT","rep":"PRIMITIVE_LONG"},"readOnly":true,"writable":false,"definitelyWritable":false,"columnClassName":"java.lang.Long"},{"ordinal":1,"autoIncrement":false,"caseSensitive":true,"searchable":false,"currency":false,"nullable":0,"signed":false,"displaySize":1,"label":"X","columnName":"X","schemaName":null,"precision":1,"scale":0,"tableName":null,"catalogName":null,"type":{"type":"scalar","id":1,"name":"CHARACTER","rep":"STRING"},"readOnly":true,"writable":false,"definitelyWritable":false,"columnClassName":"java.lang.String"}],"sql":"select
cast(? as integer) * 3 as c, 'x' as x\nfrom (values (1,
'a'))","parameters":[{"signed":true,"precision":10,"scale":0,"parameterType":4,"typeName":"INTEGER","className":"java.lang.Integer","name":"?1"}],"cursorFactory":{"style":"LIST","clazz":null,"fieldNames":null},"statementType":"SELECT"}},"rpcMetadata":null}
{"request":"execute","statementHandle":{"connectionId":"06ca3ee7-f5f6-4f8a-a929-d706ae894e7b","id":0,"signature":{"columns":[{"ordinal":0,"autoIncrement":false,"caseSensitive":false,"searchable":false,"currency":false,"nullable":2,"signed":true,"displaySize":20,"label":"C","columnName":"C","schemaName":null,"precision":64,"scale":0,"tableName":null,"catalogName":null,"type":{"type":"scalar","id":-5,"name":"BIGINT","rep":"NUMBER"},"readOnly":true,"writable":false,"definitelyWritable":false,"columnClassName":"java.lang.Long"},{"ordinal":1,"autoIncrement":false,"caseSensitive":true,"searchable":false,"currency":false,"nullable":0,"signed":false,"displaySize":1,"label":"X","columnName":"X","schemaName":null,"precision":1,"scale":0,"tableName":null,"catalogName":null,"type":{"type":"scalar","id":1,"name":"CHARACTER","rep":"STRING"},"readOnly":true,"writable":false,"definitelyWritable":false,"columnClassName":"java.lang.String"}],"sql":"select
cast(? as integer) * 3 as c, 'x' as x\nfrom (values (1,
'a'))","parameters":[{"signed":true,"precision":10,"scale":0,"parameterType":4,"typeName":"INTEGER","className":"java.lang.Integer","name":"?1"}],"cursorFactory":{"style":"LIST","clazz":null,"fieldNames":null},"statementType":"SELECT"}},"parameterValues":[null],"maxRowCount":100}=null
{"request":"execute","statementHandle":{"connectionId":"06ca3ee7-f5f6-4f8a-a929-d706ae894e7b","id":0,"signature":{"columns":[{"ordinal":0,"autoIncrement":false,"caseSensitive":false,"searchable":false,"currency":false,"nullable":2,"signed":true,"displaySize":20,"label":"C","columnName":"C","schemaName":null,"precision":64,"scale":0,"tableName":null,"catalogName":null,"type":{"type":"scalar","id":-5,"name":"BIGINT","rep":"NUMBER"},"readOnly":true,"writable":false,"definitelyWritable":false,"columnClassName":"java.lang.Long"},{"ordinal":1,"autoIncrement":false,"caseSensitive":true,"searchable":false,"currency":false,"nullable":0,"signed":false,"displaySize":1,"label":"X","columnName":"X","schemaName":null,"precision":1,"scale":0,"tableName":null,"catalogName":null,"type":{"type":"scalar","id":1,"name":"CHARACTER","rep":"STRING"},"readOnly":true,"writable":false,"definitelyWritable":false,"columnClassName":"java.lang.String"}],"sql":"select
cast(? as integer) * 3 as c, 'x' as x\nfrom (values (1,
'a'))","parameters":[{"signed":true,"precision":10,"scale":0,"parameterType":4,"typeName":"INTEGER","className":"java.lang.Integer","name":"?1"}],"cursorFactory":{"style":"LIST","clazz":null,"fieldNames":null},"statementType":"SELECT"}},"parameterValues":[{"type":"INTEGER","value":10,"componentType":null}],"maxRowCount":100}={"response":"executeResults","missingStatement":false,"rpcMetadata":null,"results":[{"response":"resultSet","connectionId":"06ca3ee7-f5f6-4f8a-a929-d706ae894e7b","statementId":0,"ownStatement":true,"signature":{"columns":[{"ordinal":0,"autoIncrement":false,"caseSensitive":false,"searchable":false,"currency":false,"nullable":2,"signed":true,"displaySize":20,"label":"C","columnName":"C","schemaName":null,"precision":64,"scale":0,"tableName":null,"catalogName":null,"type":{"type":"scalar","id":-5,"name":"BIGINT","rep":"PRIMITIVE_LONG"},"readOnly":true,"writable":false,"definitelyWritable":false,"columnClassName":"java.lang.Long"},{"ordinal":1,"autoIncrement":false,"caseSensitive":true,"searchable":false,"currency":false,"nullable":0,"signed":false,"displaySize":1,"label":"X","columnName":"X","schemaName":null,"precision":1,"scale":0,"tableName":null,"catalogName":null,"type":{"type":"scalar","id":1,"name":"CHARACTER","rep":"STRING"},"readOnly":true,"writable":false,"definitelyWritable":false,"columnClassName":"java.lang.String"}],"sql":"select
cast(? as integer) * 3 as c, 'x' as x\nfrom (values (1,
'a'))","parameters":[{"signed":true,"precision":10,"scale":0,"parameterType":4,"typeName":"INTEGER","className":"java.lang.Integer","name":"?1"}],"cursorFactory":{"style":"LIST","clazz":null,"fieldNames":null},"statementType":"SELECT"},"firstFrame":{"offset":0,"done":true,"rows":[[30,"x"]]},"updateCount":-1,"rpcMetadata":null}]}
{"request":"execute","statementHandle":{"connectionId":"06ca3ee7-f5f6-4f8a-a929-d706ae894e7b","id":0,"signature":{"columns":[{"ordinal":0,"autoIncrement":false,"caseSensitive":false,"searchable":false,"currency":false,"nullable":2,"signed":true,"displaySize":20,"label":"C","columnName":"C","schemaName":null,"precision":64,"scale":0,"tableName":null,"catalogName":null,"type":{"type":"scalar","id":-5,"name":"BIGINT","rep":"NUMBER"},"readOnly":true,"writable":false,"definitelyWritable":false,"columnClassName":"java.lang.Long"},{"ordinal":1,"autoIncrement":false,"caseSensitive":true,"searchable":false,"currency":false,"nullable":0,"signed":false,"displaySize":1,"label":"X","columnName":"X","schemaName":null,"precision":1,"scale":0,"tableName":null,"catalogName":null,"type":{"type":"scalar","id":1,"name":"CHARACTER","rep":"STRING"},"readOnly":true,"writable":false,"definitelyWritable":false,"columnClassName":"java.lang.String"}],"sql":"select
cast(? as integer) * 3 as c, 'x' as x\nfrom (values (1,
'a'))","parameters":[{"signed":true,"precision":10,"scale":0,"parameterType":4,"typeName":"INTEGER","className":"java.lang.Integer","name":"?1"}],"cursorFactory":{"style":"LIST","clazz":null,"fieldNames":null},"statementType":"SELECT"}},"parameterValues":[{"type":"INTEGER","value":20,"componentType":null}],"maxRowCount":100}={"response":"executeResults","missingStatement":false,"rpcMetadata":null,"results":[{"response":"resultSet","connectionId":"06ca3ee7-f5f6-4f8a-a929-d706ae894e7b","statementId":0,"ownStatement":true,"signature":{"columns":[{"ordinal":0,"autoIncrement":false,"caseSensitive":false,"searchable":false,"currency":false,"nullable":2,"signed":true,"displaySize":20,"label":"C","columnName":"C","schemaName":null,"precision":64,"scale":0,"tableName":null,"catalogName":null,"type":{"type":"scalar","id":-5,"name":"BIGINT","rep":"PRIMITIVE_LONG"},"readOnly":true,"writable":false,"definitelyWritable":false,"columnClassName":"java.lang.Long"},{"ordinal":1,"autoIncrement":false,"caseSensitive":true,"searchable":false,"currency":false,"nullable":0,"signed":false,"displaySize":1,"label":"X","columnName":"X","schemaName":null,"precision":1,"scale":0,"tableName":null,"catalogName":null,"type":{"type":"scalar","id":1,"name":"CHARACTER","rep":"STRING"},"readOnly":true,"writable":false,"definitelyWritable":false,"columnClassName":"java.lang.String"}],"sql":"select
cast(? as integer) * 3 as c, 'x' as x\nfrom (values (1,
'a'))","parameters":[{"signed":true,"precision":10,"scale":0,"parameterType":4,"typeName":"INTEGER","className":"java.lang.Integer","name":"?1"}],"cursorFactory":{"style":"LIST","clazz":null,"fieldNames":null},"statementType":"SELECT"},"firstFrame":{"offset":0,"done":true,"rows":[[60,"x"]]},"updateCount":-1,"rpcMetadata":null}]}
{"request":"execute","statementHandle":{"connectionId":"06ca3ee7-f5f6-4f8a-a929-d706ae894e7b","id":0,"signature":{"columns":[{"ordinal":0,"autoIncrement":false,"caseSensitive":false,"searchable":false,"currency":false,"nullable":2,"signed":true,"displaySize":20,"label":"C","columnName":"C","schemaName":null,"precision":64,"scale":0,"tableName":null,"catalogName":null,"type":{"type":"scalar","id":-5,"name":"BIGINT","rep":"NUMBER"},"readOnly":true,"writable":false,"definitelyWritable":false,"columnClassName":"java.lang.Long"},{"ordinal":1,"autoIncrement":false,"caseSensitive":true,"searchable":false,"currency":false,"nullable":0,"signed":false,"displaySize":1,"label":"X","columnName":"X","schemaName":null,"precision":1,"scale":0,"tableName":null,"catalogName":null,"type":{"type":"scalar","id":1,"name":"CHARACTER","rep":"STRING"},"readOnly":true,"writable":false,"definitelyWritable":false,"columnClassName":"java.lang.String"}],"sql":"select
cast(? as integer) * 3 as c, 'x' as x\nfrom (values (1,
'a'))","parameters":[{"signed":true,"precision":10,"scale":0,"parameterType":4,"typeName":"INTEGER","className":"java.lang.Integer","name":"?1"}],"cursorFactory":{"style":"LIST","clazz":null,"fieldNames":null},"statementType":"SELECT"}},"parameterValues":[{"type":"OBJECT","value":null,"componentType":null}],"maxRowCount":100}={"response":"executeResults","missingStatement":false,"rpcMetadata":null,"results":[{"response":"resultSet","connectionId":"06ca3ee7-f5f6-4f8a-a929-d706ae894e7b","statementId":0,"ownStatement":true,"signature":{"columns":[{"ordinal":0,"autoIncrement":false,"caseSensitive":false,"searchable":false,"currency":false,"nullable":2,"signed":true,"displaySize":20,"label":"C","columnName":"C","schemaName":null,"precision":64,"scale":0,"tableName":null,"catalogName":null,"type":{"type":"scalar","id":-5,"name":"BIGINT","rep":"PRIMITIVE_LONG"},"readOnly":true,"writable":false,"definitelyWritable":false,"columnClassName":"java.lang.Long"},{"ordinal":1,"autoIncrement":false,"caseSensitive":true,"searchable":false,"currency":false,"nullable":0,"signed":false,"displaySize":1,"label":"X","columnName":"X","schemaName":null,"precision":1,"scale":0,"tableName":null,"catalogName":null,"type":{"type":"scalar","id":1,"name":"CHARACTER","rep":"STRING"},"readOnly":true,"writable":false,"definitelyWritable":false,"columnClassName":"java.lang.String"}],"sql":"select
cast(? as integer) * 3 as c, 'x' as x\nfrom (values (1,
'a'))","parameters":[{"signed":true,"precision":10,"scale":0,"parameterType":4,"typeName":"INTEGER","className":"java.lang.Integer","name":"?1"}],"cursorFactory":{"style":"LIST","clazz":null,"fieldNames":null},"statementType":"SELECT"},"firstFrame":{"offset":0,"done":true,"rows":[[null,"x"]]},"updateCount":-1,"rpcMetadata":null}]}
{"request":"closeStatement","connectionId":"06ca3ee7-f5f6-4f8a-a929-d706ae894e7b","statementId":0}={"response":"closeStatement","rpcMetadata":null}
{"request":"closeConnection","connectionId":"06ca3ee7-f5f6-4f8a-a929-d706ae894e7b"}={"response":"closeConnection","rpcMetadata":null}
2017-10-18 09:54:03,621 [main] INFO - Creating table BATCH_EXECUTE_31
2017-10-18 09:54:03,623 [main] INFO - Creating table BATCH_EXECUTE_32
2017-10-18 09:54:03,714 [main] INFO - Creating table BATCH_CLEARS_34
2017-10-18 09:54:03,715 [main] INFO - Creating table BATCH_CLEARS_35
Tests run: 78, Failures: 2, Errors: 0, Skipped: 4, Time elapsed: 0.776 sec <<<
FAILURE! - in org.apache.calcite.avatica.RemoteDriverTest
testBatchInsertWithDates[JSON](org.apache.calcite.avatica.RemoteDriverTest)
Time elapsed: 0.006 sec <<< FAILURE!
java.lang.AssertionError: Wrong day for row 0 expected:<17> but was:<16>
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.002 sec <<< FAILURE!
java.lang.AssertionError: Wrong day for row 0 expected:<17> but was:<16>
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)
Running org.apache.calcite.avatica.remote.AlternatingRemoteMetaTest
2017-10-18 09:54:03,799 [main] INFO - jetty-9.2.19.v20160908
2017-10-18 09:54:03,864 [main] INFO - Started
ServerConnector@38732364{HTTP/1.1}{0.0.0.0:33027}
2017-10-18 09:54:03,864 [main] INFO - Started @7256ms
2017-10-18 09:54:03,864 [main] INFO - Service listening on port 33027.
2017-10-18 09:54:03,868 [main] INFO - jetty-9.2.19.v20160908
2017-10-18 09:54:03,869 [main] INFO - Started
ServerConnector@526f6427{HTTP/1.1}{0.0.0.0:37133}
2017-10-18 09:54:03,869 [main] INFO - Started @7261ms
2017-10-18 09:54:03,869 [main] INFO - Service listening on port 37133.
2017-10-18 09:54:04,693 [main] INFO - Service terminating.
2017-10-18 09:54:04,721 [main] INFO - Stopped
ServerConnector@38732364{HTTP/1.1}{0.0.0.0:0}
2017-10-18 09:54:04,728 [main] INFO - Service terminating.
2017-10-18 09:54:04,735 [main] INFO - Stopped
ServerConnector@526f6427{HTTP/1.1}{0.0.0.0:0}
Tests run: 6, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.909 sec - in
org.apache.calcite.avatica.remote.AlternatingRemoteMetaTest
Running org.apache.calcite.avatica.remote.RemoteMetaTest
2017-10-18 09:54:04,739 [main] INFO - jetty-9.2.19.v20160908
2017-10-18 09:54:04,740 [main] INFO - Started
ServerConnector@7c8874ef{HTTP/1.1}{0.0.0.0:42601}
2017-10-18 09:54:04,740 [main] INFO - Started @8132ms
2017-10-18 09:54:04,740 [main] INFO - Service listening on port 42601.
2017-10-18 09:54:04,741 [main] INFO - jetty-9.2.19.v20160908
2017-10-18 09:54:04,744 [main] INFO - Started
ServerConnector@4dc52559{HTTP/1.1}{0.0.0.0:46077}
2017-10-18 09:54:04,744 [main] INFO - Started @8137ms
2017-10-18 09:54:04,744 [main] INFO - Service listening on port 46077.
2017-10-18 09:54:05,294 [main] INFO - Service terminating.
2017-10-18 09:54:05,304 [main] INFO - Stopped
ServerConnector@7c8874ef{HTTP/1.1}{0.0.0.0:0}
2017-10-18 09:54:05,304 [main] INFO - Service terminating.
2017-10-18 09:54:05,308 [main] INFO - Stopped
ServerConnector@4dc52559{HTTP/1.1}{0.0.0.0:0}
Tests run: 38, Failures: 0, Errors: 0, Skipped: 2, Time elapsed: 0.572 sec - in
org.apache.calcite.avatica.remote.RemoteMetaTest
Running org.apache.calcite.avatica.remote.ArrayTypeTest
2017-10-18 09:54:05,310 [main] INFO - jetty-9.2.19.v20160908
2017-10-18 09:54:05,316 [main] INFO - Started
ServerConnector@73e4387{HTTP/1.1}{0.0.0.0:37777}
2017-10-18 09:54:05,316 [main] INFO - Started @8708ms
2017-10-18 09:54:05,316 [main] INFO - Service listening on port 37777.
2017-10-18 09:54:05,316 [main] INFO - jetty-9.2.19.v20160908
2017-10-18 09:54:05,317 [main] INFO - Started
ServerConnector@5bfc79cb{HTTP/1.1}{0.0.0.0:46797}
2017-10-18 09:54:05,318 [main] INFO - Started @8710ms
2017-10-18 09:54:05,318 [main] INFO - Service listening on port 46797.
2017-10-18 09:54:05,789 [main] INFO - Service terminating.
2017-10-18 09:54:05,792 [main] INFO - Stopped
ServerConnector@73e4387{HTTP/1.1}{0.0.0.0:0}
2017-10-18 09:54:05,793 [main] INFO - Service terminating.
2017-10-18 09:54:05,802 [main] INFO - Stopped
ServerConnector@5bfc79cb{HTTP/1.1}{0.0.0.0:0}
Tests run: 28, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.493 sec - in
org.apache.calcite.avatica.remote.ArrayTypeTest
Results :
Failed tests:
RemoteDriverTest.testBatchInsertWithDates:1379->eachConnection:228->access$1100:91->executeBatchInsertWithDates:1444
Wrong day for row 0 expected:<17> but was:<16>
RemoteDriverTest.testBatchInsertWithDates:1379->eachConnection:228->access$1100:91->executeBatchInsertWithDates:1444
Wrong day for row 0 expected:<17> but was:<16>
Tests run: 217, Failures: 2, Errors: 0, Skipped: 15
[INFO] ------------------------------------------------------------------------
[INFO] Reactor Summary:
[INFO]
[INFO] Apache Calcite Avatica Project ..................... SUCCESS [04:16 min]
[INFO] Apache Calcite Avatica Metrics ..................... SUCCESS [ 41.809 s]
[INFO] Apache Calcite Avatica ............................. SUCCESS [01:16 min]
[INFO] Apache Calcite Avatica Server ...................... FAILURE [ 40.121 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] ------------------------------------------------------------------------
[INFO] Total time: 07:21 min
[INFO] Finished at: 2017-10-18T09:54:06+11:00
[INFO] Final Memory: 82M/2722M
[INFO] ------------------------------------------------------------------------
[ERROR] Failed to execute goal
org.apache.maven.plugins:maven-surefire-plugin:2.19.1:test (default-test) on
project avatica-server: There are test failures.
[ERROR]
[ERROR] Please refer to
/home/francis/Desktop/avatica/server/target/surefire-reports for the individual
test results.
[ERROR] -> [Help 1]
[ERROR]
[ERROR] To see the full stack trace of the errors, re-run Maven with the -e
switch.
[ERROR] Re-run Maven using the -X switch to enable full debug logging.
[ERROR]
[ERROR] For more information about the errors and possible solutions, please
read the following articles:
[ERROR] [Help 1]
http://cwiki.apache.org/confluence/display/MAVEN/MojoFailureException
[ERROR]
[ERROR] After correcting the problems, you can resume the build with the command
[ERROR] mvn <goals> -rf :avatica-server
{code}
> Bump HSQLDB version in avatica
> ------------------------------
>
> Key: CALCITE-2013
> URL: https://issues.apache.org/jira/browse/CALCITE-2013
> Project: Calcite
> Issue Type: Improvement
> Components: avatica
> Affects Versions: avatica-1.10.0
> Reporter: Francis Chuang
> Priority: Minor
>
> It would be nice if the HSQLDB used in avatica can be bumped to the latest
> version. The 2.4.x series was released around 6 months ago and should be
> quite stable. 2.3.1 which is currently being used is around 4 years old and
> there has been a lot of bug fixes since.
> I ran into a bunch of issues while testing the avatica-go driver against
> HSQLDB and I am hoping an upgrade to 2.4.x will resolve some or most of the
> issues.
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
