[GitHub] [shardingsphere] lmhmhl commented on pull request #9557: Test Calcite doing query between two sharding tables.

[GitBox <gi...@apache.org>]

lmhmhl commented on pull request #9557:
URL: https://github.com/apache/shardingsphere/pull/9557#issuecomment-788707422


   Hi @tristaZero, When I ran the test, some error happened like follows:
   I test every single test method, It was all good, but if I run the all the method of the class, this error happen.
   ```
   java.lang.RuntimeException: org.h2.jdbc.JdbcSQLException: Unique index or primary key violation: "PRIMARY KEY ON PUBLIC.""t_order_calcite_sharding_0""(""order_id_sharding"")"; SQL statement:
   
   
   INSERT INTO t_order_calcite_sharding_0 VALUES(1000, 10, 'init') [23505-196]
   
   	at org.apache.shardingsphere.driver.jdbc.base.AbstractShardingSphereDataSourceForCalciteTest.initTable(AbstractShardingSphereDataSourceForCalciteTest.java:74)
   	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.RunBefores.evaluate(RunBefores.java:24)
   	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.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.junit.runner.JUnitCore.run(JUnitCore.java:137)
   	at com.intellij.junit4.JUnit4IdeaTestRunner.startRunnerWithArgs(JUnit4IdeaTestRunner.java:68)
   	at com.intellij.rt.execution.junit.IdeaTestRunner$Repeater.startRunnerWithArgs(IdeaTestRunner.java:47)
   	at com.intellij.rt.execution.junit.JUnitStarter.prepareStreamsAndStart(JUnitStarter.java:242)
   	at com.intellij.rt.execution.junit.JUnitStarter.main(JUnitStarter.java:70)
   Caused by: org.h2.jdbc.JdbcSQLException: Unique index or primary key violation: "PRIMARY KEY ON PUBLIC.""t_order_calcite_sharding_0""(""order_id_sharding"")"; SQL statement:
   
   
   INSERT INTO t_order_calcite_sharding_0 VALUES(1000, 10, 'init') [23505-196]
   	at org.h2.message.DbException.getJdbcSQLException(DbException.java:345)
   	at org.h2.message.DbException.get(DbException.java:179)
   	at org.h2.message.DbException.get(DbException.java:155)
   	at org.h2.mvstore.db.MVPrimaryIndex.add(MVPrimaryIndex.java:139)
   	at org.h2.mvstore.db.MVTable.addRow(MVTable.java:705)
   	at org.h2.command.dml.Insert.insertRows(Insert.java:156)
   	at org.h2.command.dml.Insert.update(Insert.java:114)
   	at org.h2.command.CommandContainer.update(CommandContainer.java:101)
   	at org.h2.command.Command.executeUpdate(Command.java:260)
   	at org.h2.jdbc.JdbcStatement.executeInternal(JdbcStatement.java:192)
   	at org.h2.jdbc.JdbcStatement.execute(JdbcStatement.java:164)
   	at org.apache.commons.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:290)
   	at org.apache.commons.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:290)
   	at org.h2.tools.RunScript.execute(RunScript.java:171)
   	at org.apache.shardingsphere.driver.jdbc.base.AbstractShardingSphereDataSourceForCalciteTest.initTable(AbstractShardingSphereDataSourceForCalciteTest.java:69)
   	... 24 more
   ```


----------------------------------------------------------------
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.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org