Issue 1:
Bug Report

For English only, other languages will not accept.

Before report a bug, make sure you have:

Searched open and closed GitHub issues.

Read documentation: ShardingSphere Doc.

Please pay attention on issues you submitted, because we maybe need more details.

If no response anymore and we cannot reproduce it on current information, we will close it.

Please answer these questions before submitting your issue. Thanks!

Which version of ShardingSphere did you use?

master

Which project did you use? ShardingSphere-JDBC or ShardingSphere-Proxy?

Expected behavior

when execute ShardingSpringNamespaceTest test case, cause error.

Actual behavior

Reason analyze (If you can)

Steps to reproduce the behavior, such as: SQL to execute, sharding rule configuration, when exception occur etc.

Example codes for reproduce this issue (such as a github link).

/Library/Java/JavaVirtualMachines/jdk1.8.0_161.jdk/Contents/Home/bin/java -ea -Didea.test.cyclic.buffer.size=1048576 -javaagent:/Applications/IntelliJ IDEA.app/Contents/lib/idea_rt.jar=57309:/Applications/IntelliJ IDEA.app/Contents/bin -Dfile.encoding=UTF-8 -classpath /Applications/IntelliJ IDEA.app/Contents/lib/idea_rt.jar:/Applications/IntelliJ IDEA.app/Contents/plugins/junit/lib/junit5-rt.jar:/Applications/IntelliJ IDEA.app/Contents/plugins/junit/lib/junit-rt.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_161.jdk/Contents/Home/jre/lib/charsets.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_161.jdk/Contents/Home/jre/lib/deploy.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_161.jdk/Contents/Home/jre/lib/ext/cldrdata.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_161.jdk/Contents/Home/jre/lib/ext/dnsns.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_161.jdk/Contents/Home/jre/lib/ext/jaccess.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_161.jdk/Contents/Home/jre/lib/ext/jfxrt.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_161.jdk/Contents/Home/jre/lib/ext/localedata.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_161.jdk/Contents/Home/jre/lib/ext/nashorn.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_161.jdk/Contents/Home/jre/lib/ext/sunec.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_161.jdk/Contents/Home/jre/lib/ext/sunjce_provider.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_161.jdk/Contents/Home/jre/lib/ext/sunpkcs11.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_161.jdk/Contents/Home/jre/lib/ext/zipfs.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_161.jdk/Contents/Home/jre/lib/javaws.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_161.jdk/Contents/Home/jre/lib/jce.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_161.jdk/Contents/Home/jre/lib/jfr.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_161.jdk/Contents/Home/jre/lib/jfxswt.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_161.jdk/Contents/Home/jre/lib/jsse.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_161.jdk/Contents/Home/jre/lib/management-agent.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_161.jdk/Contents/Home/jre/lib/plugin.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_161.jdk/Contents/Home/jre/lib/resources.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_161.jdk/Contents/Home/jre/lib/rt.jar:/Users/dongzonglei/source_code/Github/shardingsphere/shardingsphere-features/shardingsphere-sharding/shardingsphere-sharding-spring/shardingsphere-sharding-spring-namespace/target/test-classes:/Users/dongzonglei/source_code/Github/shardingsphere/shardingsphere-features/shardingsphere-sharding/shardingsphere-sharding-spring/shardingsphere-sharding-spring-namespace/target/classes:/Users/dongzonglei/source_code/Github/shardingsphere/shardingsphere-features/shardingsphere-sharding/shardingsphere-sharding-core/target/classes:/Users/dongzonglei/source_code/Github/shardingsphere/shardingsphere-features/shardingsphere-sharding/shardingsphere-sharding-api/target/classes:/Users/dongzonglei/source_code/Github/shardingsphere/shardingsphere-kernel/shardingsphere-data-pipeline/shardingsphere-data-pipeline-core/target/classes:/Users/dongzonglei/source_code/Github/shardingsphere/shardingsphere-kernel/shardingsphere-data-pipeline/shardingsphere-data-pipeline-api/target/classes:/Users/dongzonglei/server/repository/org/apache/commons/commons-lang3/3.8/commons-lang3-3.8.jar:/Users/dongzonglei/server/repository/commons-codec/commons-codec/1.15/commons-codec-1.15.jar:/Users/dongzonglei/source_code/Github/shardingsphere/shardingsphere-kernel/shardingsphere-schedule/shardingsphere-schedule-core/target/classes:/Users/dongzonglei/server/repository/org/apache/shardingsphere/elasticjob/elasticjob-lite-core/3.0.1/elasticjob-lite-core-3.0.1.jar:/Users/dongzonglei/server/repository/org/apache/shardingsphere/elasticjob/elasticjob-api/3.0.1/elasticjob-api-3.0.1.jar:/Users/dongzonglei/server/repository/org/apache/shardingsphere/elasticjob/elasticjob-infra-common/3.0.1/elasticjob-infra-common-3.0.1.jar:/Users/dongzonglei/server/repository/org/apache/shardingsphere/elasticjob/elasticjob-registry-center/3.0.1/elasticjob-registry-center-3.0.1.jar:/Users/dongzonglei/server/repository/org/apache/shardingsphere/elasticjob/elasticjob-simple-executor/3.0.1/elasticjob-simple-executor-3.0.1.jar:/Users/dongzonglei/server/repository/org/apache/shardingsphere/elasticjob/elasticjob-executor-kernel/3.0.1/elasticjob-executor-kernel-3.0.1.jar:/Users/dongzonglei/server/repository/org/apache/shardingsphere/elasticjob/elasticjob-error-handler-general/3.0.1/elasticjob-error-handler-general-3.0.1.jar:/Users/dongzonglei/server/repository/org/apache/shardingsphere/elasticjob/elasticjob-error-handler-spi/3.0.1/elasticjob-error-handler-spi-3.0.1.jar:/Users/dongzonglei/server/repository/org/apache/shardingsphere/elasticjob/elasticjob-dataflow-executor/3.0.1/elasticjob-dataflow-executor-3.0.1.jar:/Users/dongzonglei/server/repository/org/apache/shardingsphere/elasticjob/elasticjob-script-executor/3.0.1/elasticjob-script-executor-3.0.1.jar:/Users/dongzonglei/server/repository/org/apache/commons/commons-exec/1.3/commons-exec-1.3.jar:/Users/dongzonglei/server/repository/org/apache/shardingsphere/elasticjob/elasticjob-http-executor/3.0.1/elasticjob-http-executor-3.0.1.jar:/Users/dongzonglei/server/repository/org/apache/shardingsphere/elasticjob/elasticjob-tracing-rdb/3.0.1/elasticjob-tracing-rdb-3.0.1.jar:/Users/dongzonglei/server/repository/org/apache/shardingsphere/elasticjob/elasticjob-tracing-api/3.0.1/elasticjob-tracing-api-3.0.1.jar:/Users/dongzonglei/server/repository/com/google/code/gson/gson/2.9.1/gson-2.9.1.jar:/Users/dongzonglei/server/repository/org/quartz-scheduler/quartz/2.3.2/quartz-2.3.2.jar:/Users/dongzonglei/server/repository/com/mchange/mchange-commons-java/0.2.15/mchange-commons-java-0.2.15.jar:/Users/dongzonglei/server/repository/org/apache/shardingsphere/elasticjob/elasticjob-lite-lifecycle/3.0.1/elasticjob-lite-lifecycle-3.0.1.jar:/Users/dongzonglei/server/repository/com/zaxxer/HikariCP/3.4.2/HikariCP-3.4.2.jar:/Users/dongzonglei/source_code/Github/shardingsphere/shardingsphere-infra/shardingsphere-infra-executor/target/classes:/Users/dongzonglei/server/repository/io/vertx/vertx-mysql-client/4.2.3/vertx-mysql-client-4.2.3.jar:/Users/dongzonglei/server/repository/io/vertx/vertx-core/4.2.3/vertx-core-4.2.3.jar:/Users/dongzonglei/server/repository/io/netty/netty-common/4.1.73.Final/netty-common-4.1.73.Final.jar:/Users/dongzonglei/server/repository/io/netty/netty-buffer/4.1.73.Final/netty-buffer-4.1.73.Final.jar:/Users/dongzonglei/server/repository/io/netty/netty-transport/4.1.73.Final/netty-transport-4.1.73.Final.jar:/Users/dongzonglei/server/repository/io/netty/netty-handler/4.1.73.Final/netty-handler-4.1.73.Final.jar:/Users/dongzonglei/server/repository/io/netty/netty-codec/4.1.73.Final/netty-codec-4.1.73.Final.jar:/Users/dongzonglei/server/repository/io/netty/netty-tcnative-classes/2.0.46.Final/netty-tcnative-classes-2.0.46.Final.jar:/Users/dongzonglei/server/repository/io/netty/netty-handler-proxy/4.1.73.Final/netty-handler-proxy-4.1.73.Final.jar:/Users/dongzonglei/server/repository/io/netty/netty-codec-socks/4.1.73.Final/netty-codec-socks-4.1.73.Final.jar:/Users/dongzonglei/server/repository/io/netty/netty-codec-http/4.1.73.Final/netty-codec-http-4.1.73.Final.jar:/Users/dongzonglei/server/repository/io/netty/netty-codec-http2/4.1.73.Final/netty-codec-http2-4.1.73.Final.jar:/Users/dongzonglei/server/repository/io/netty/netty-resolver/4.1.73.Final/netty-resolver-4.1.73.Final.jar:/Users/dongzonglei/server/repository/io/netty/netty-resolver-dns/4.1.73.Final/netty-resolver-dns-4.1.73.Final.jar:/Users/dongzonglei/server/repository/io/netty/netty-codec-dns/4.1.73.Final/netty-codec-dns-4.1.73.Final.jar:/Users/dongzonglei/server/repository/io/vertx/vertx-sql-client/4.2.3/vertx-sql-client-4.2.3.jar:/Users/dongzonglei/source_code/Github/shardingsphere/shardingsphere-kernel/shardingsphere-parser/shardingsphere-parser-core/target/classes:/Users/dongzonglei/source_code/Github/shardingsphere/shardingsphere-kernel/shardingsphere-parser/shardingsphere-parser-api/target/classes:/Users/dongzonglei/source_code/Github/shardingsphere/shardingsphere-mode/shardingsphere-mode-type/shardingsphere-cluster-mode/shardingsphere-cluster-mode-core/target/classes:/Users/dongzonglei/source_code/Github/shardingsphere/shardingsphere-mode/shardingsphere-mode-type/shardingsphere-cluster-mode/shardingsphere-cluster-mode-repository/shardingsphere-cluster-mode-repository-api/target/classes:/Users/dongzonglei/source_code/Github/shardingsphere/shardingsphere-mode/shardingsphere-mode-type/shardingsphere-cluster-mode/shardingsphere-cluster-mode-repository/shardingsphere-cluster-mode-repository-provider/shardingsphere-cluster-mode-repository-zookeeper-curator/target/classes:/Users/dongzonglei/server/repository/org/apache/curator/curator-framework/5.1.0/curator-framework-5.1.0.jar:/Users/dongzonglei/server/repository/org/apache/curator/curator-client/5.1.0/curator-client-5.1.0.jar:/Users/dongzonglei/server/repository/org/apache/zookeeper/zookeeper/3.6.0/zookeeper-3.6.0.jar:/Users/dongzonglei/server/repository/commons-lang/commons-lang/2.6/commons-lang-2.6.jar:/Users/dongzonglei/server/repository/org/apache/zookeeper/zookeeper-jute/3.6.0/zookeeper-jute-3.6.0.jar:/Users/dongzonglei/server/repository/org/apache/yetus/audience-annotations/0.5.0/audience-annotations-0.5.0.jar:/Users/dongzonglei/server/repository/log4j/log4j/1.2.17/log4j-1.2.17.jar:/Users/dongzonglei/server/repository/org/apache/curator/curator-recipes/5.1.0/curator-recipes-5.1.0.jar:/Users/dongzonglei/source_code/Github/shardingsphere/shardingsphere-infra/shardingsphere-infra-binder/target/classes:/Users/dongzonglei/source_code/Github/shardingsphere/shardingsphere-dialect-exception/shardingsphere-dialect-exception-core/target/classes:/Users/dongzonglei/source_code/Github/shardingsphere/shardingsphere-sql-parser/shardingsphere-sql-parser-engine/target/classes:/Users/dongzonglei/source_code/Github/shardingsphere/shardingsphere-sql-parser/shardingsphere-sql-parser-spi/target/classes:/Users/dongzonglei/source_code/Github/shardingsphere/shardingsphere-sql-parser/shardingsphere-sql-parser-statement/target/classes:/Users/dongzonglei/server/repository/org/antlr/antlr4-runtime/4.9.2/antlr4-runtime-4.9.2.jar:/Users/dongzonglei/server/repository/com/github/ben-manes/caffeine/caffeine/2.9.2/caffeine-2.9.2.jar:/Users/dongzonglei/source_code/Github/shardingsphere/shardingsphere-infra/shardingsphere-infra-parser/target/classes:/Users/dongzonglei/source_code/Github/shardingsphere/shardingsphere-distsql/shardingsphere-distsql-parser/target/classes:/Users/dongzonglei/source_code/Github/shardingsphere/shardingsphere-distsql/shardingsphere-distsql-statement/target/classes:/Users/dongzonglei/source_code/Github/shardingsphere/shardingsphere-infra/shardingsphere-infra-route/target/classes:/Users/dongzonglei/source_code/Github/shardingsphere/shardingsphere-infra/shardingsphere-infra-rewrite/target/classes:/Users/dongzonglei/source_code/Github/shardingsphere/shardingsphere-kernel/shardingsphere-sql-translator/shardingsphere-sql-translator-core/target/classes:/Users/dongzonglei/source_code/Github/shardingsphere/shardingsphere-kernel/shardingsphere-sql-translator/shardingsphere-sql-translator-api/target/classes:/Users/dongzonglei/source_code/Github/shardingsphere/shardingsphere-kernel/shardingsphere-sql-translator/shardingsphere-sql-translator-provider/shardingsphere-sql-translator-native-provider/target/classes:/Users/dongzonglei/source_code/Github/shardingsphere/shardingsphere-infra/shardingsphere-infra-merge/target/classes:/Users/dongzonglei/server/repository/org/apache/calcite/calcite-linq4j/1.31.0/calcite-linq4j-1.31.0.jar:/Users/dongzonglei/server/repository/org/apiguardian/apiguardian-api/1.1.2/apiguardian-api-1.1.2.jar:/Users/dongzonglei/server/repository/org/apache/calcite/avatica/avatica-core/1.22.0/avatica-core-1.22.0.jar:/Users/dongzonglei/server/repository/org/apache/calcite/avatica/avatica-metrics/1.22.0/avatica-metrics-1.22.0.jar:/Users/dongzonglei/server/repository/com/fasterxml/jackson/core/jackson-annotations/2.10.0/jackson-annotations-2.10.0.jar:/Users/dongzonglei/server/repository/com/fasterxml/jackson/core/jackson-databind/2.10.0/jackson-databind-2.10.0.jar:/Users/dongzonglei/server/repository/com/google/protobuf/protobuf-java/3.17.1/protobuf-java-3.17.1.jar:/Users/dongzonglei/server/repository/com/fasterxml/jackson/core/jackson-core/2.10.0/jackson-core-2.10.0.jar:/Users/dongzonglei/server/repository/org/apache/httpcomponents/client5/httpclient5/5.1.3/httpclient5-5.1.3.jar:/Users/dongzonglei/server/repository/org/apache/httpcomponents/core5/httpcore5-h2/5.1.3/httpcore5-h2-5.1.3.jar:/Users/dongzonglei/server/repository/org/apache/httpcomponents/core5/httpcore5/5.1.3/httpcore5-5.1.3.jar:/Users/dongzonglei/source_code/Github/shardingsphere/shardingsphere-mode/shardingsphere-mode-core/target/classes:/Users/dongzonglei/source_code/Github/shardingsphere/shardingsphere-infra/shardingsphere-infra-context/target/classes:/Users/dongzonglei/source_code/Github/shardingsphere/shardingsphere-infra/shardingsphere-infra-datetime/shardingsphere-infra-datetime-type/shardingsphere-system-datetime/target/classes:/Users/dongzonglei/source_code/Github/shardingsphere/shardingsphere-infra/shardingsphere-infra-datetime/shardingsphere-infra-datetime-spi/target/classes:/Users/dongzonglei/source_code/Github/shardingsphere/shardingsphere-features/shardingsphere-sharding/shardingsphere-sharding-plugin/shardingsphere-sharding-cosid/target/classes:/Users/dongzonglei/server/repository/me/ahoo/cosid/cosid-core/1.14.4/cosid-core-1.14.4.jar:/Users/dongzonglei/source_code/Github/shardingsphere/shardingsphere-features/shardingsphere-sharding/shardingsphere-sharding-plugin/shardingsphere-sharding-nanoid/target/classes:/Users/dongzonglei/server/repository/com/aventrix/jnanoid/jnanoid/2.0.0/jnanoid-2.0.0.jar:/Users/dongzonglei/source_code/Github/shardingsphere/shardingsphere-jdbc/shardingsphere-jdbc-spring/shardingsphere-jdbc-spring-infra/shardingsphere-jdbc-spring-namespace-infra/target/classes:/Users/dongzonglei/source_code/Github/shardingsphere/shardingsphere-infra/shardingsphere-infra-common/target/classes:/Users/dongzonglei/source_code/Github/shardingsphere/shardingsphere-infra/shardingsphere-infra-util/target/classes:/Users/dongzonglei/server/repository/org/yaml/snakeyaml/1.30/snakeyaml-1.30.jar:/Users/dongzonglei/server/repository/org/apache/groovy/groovy/4.0.3/groovy-4.0.3.jar:/Users/dongzonglei/server/repository/com/h2database/h2/2.1.214/h2-2.1.214.jar:/Users/dongzonglei/source_code/Github/shardingsphere/shardingsphere-jdbc/shardingsphere-jdbc-core/target/classes:/Users/dongzonglei/source_code/Github/shardingsphere/shardingsphere-kernel/shardingsphere-transaction/shardingsphere-transaction-core/target/classes:/Users/dongzonglei/source_code/Github/shardingsphere/shardingsphere-kernel/shardingsphere-transaction/shardingsphere-transaction-api/target/classes:/Users/dongzonglei/source_code/Github/shardingsphere/shardingsphere-sql-parser/shardingsphere-sql-parser-dialect/shardingsphere-sql-parser-sql92/target/classes:/Users/dongzonglei/source_code/Github/shardingsphere/shardingsphere-sql-parser/shardingsphere-sql-parser-dialect/shardingsphere-sql-parser-mysql/target/classes:/Users/dongzonglei/source_code/Github/shardingsphere/shardingsphere-sql-parser/shardingsphere-sql-parser-dialect/shardingsphere-sql-parser-postgresql/target/classes:/Users/dongzonglei/source_code/Github/shardingsphere/shardingsphere-sql-parser/shardingsphere-sql-parser-dialect/shardingsphere-sql-parser-oracle/target/classes:/Users/dongzonglei/source_code/Github/shardingsphere/shardingsphere-sql-parser/shardingsphere-sql-parser-dialect/shardingsphere-sql-parser-sqlserver/target/classes:/Users/dongzonglei/source_code/Github/shardingsphere/shardingsphere-sql-parser/shardingsphere-sql-parser-dialect/shardingsphere-sql-parser-opengauss/target/classes:/Users/dongzonglei/source_code/Github/shardingsphere/shardingsphere-dialect-exception/shardingsphere-mysql-dialect-exception/target/classes:/Users/dongzonglei/source_code/Github/shardingsphere/shardingsphere-dialect-exception/shardingsphere-postgresql-dialect-exception/target/classes:/Users/dongzonglei/source_code/Github/shardingsphere/shardingsphere-kernel/shardingsphere-authority/shardingsphere-authority-core/target/classes:/Users/dongzonglei/source_code/Github/shardingsphere/shardingsphere-kernel/shardingsphere-authority/shardingsphere-authority-api/target/classes:/Users/dongzonglei/source_code/Github/shardingsphere/shardingsphere-kernel/shardingsphere-single-table/shardingsphere-single-table-core/target/classes:/Users/dongzonglei/source_code/Github/shardingsphere/shardingsphere-kernel/shardingsphere-single-table/shardingsphere-single-table-api/target/classes:/Users/dongzonglei/source_code/Github/shardingsphere/shardingsphere-kernel/shardingsphere-traffic/shardingsphere-traffic-core/target/classes:/Users/dongzonglei/source_code/Github/shardingsphere/shardingsphere-kernel/shardingsphere-traffic/shardingsphere-traffic-api/target/classes:/Users/dongzonglei/source_code/Github/shardingsphere/shardingsphere-mode/shardingsphere-mode-type/shardingsphere-standalone-mode/shardingsphere-standalone-mode-core/target/classes:/Users/dongzonglei/source_code/Github/shardingsphere/shardingsphere-mode/shardingsphere-mode-type/shardingsphere-standalone-mode/shardingsphere-standalone-mode-repository/shardingsphere-standalone-mode-repository-api/target/classes:/Users/dongzonglei/source_code/Github/shardingsphere/shardingsphere-mode/shardingsphere-mode-type/shardingsphere-standalone-mode/shardingsphere-standalone-mode-repository/shardingsphere-standalone-mode-repository-provider/shardingsphere-standalone-mode-repository-jdbc/shardingsphere-standalone-mode-repository-jdbc-h2/target/classes:/Users/dongzonglei/source_code/Github/shardingsphere/shardingsphere-mode/shardingsphere-mode-type/shardingsphere-standalone-mode/shardingsphere-standalone-mode-repository/shardingsphere-standalone-mode-repository-provider/shardingsphere-standalone-mode-repository-jdbc/shardingsphere-standalone-mode-repository-jdbc-core/target/classes:/Users/dongzonglei/source_code/Github/shardingsphere/shardingsphere-features/shardingsphere-readwrite-splitting/shardingsphere-readwrite-splitting-core/target/classes:/Users/dongzonglei/source_code/Github/shardingsphere/shardingsphere-features/shardingsphere-readwrite-splitting/shardingsphere-readwrite-splitting-api/target/classes:/Users/dongzonglei/source_code/Github/shardingsphere/shardingsphere-features/shardingsphere-db-discovery/shardingsphere-db-discovery-core/target/classes:/Users/dongzonglei/source_code/Github/shardingsphere/shardingsphere-features/shardingsphere-db-discovery/shardingsphere-db-discovery-api/target/classes:/Users/dongzonglei/source_code/Github/shardingsphere/shardingsphere-features/shardingsphere-db-discovery/shardingsphere-db-discovery-provider/shardingsphere-db-discovery-mysql/target/classes:/Users/dongzonglei/source_code/Github/shardingsphere/shardingsphere-features/shardingsphere-db-discovery/shardingsphere-db-discovery-provider/shardingsphere-db-discovery-opengauss/target/classes:/Users/dongzonglei/source_code/Github/shardingsphere/shardingsphere-features/shardingsphere-encrypt/shardingsphere-encrypt-core/target/classes:/Users/dongzonglei/source_code/Github/shardingsphere/shardingsphere-features/shardingsphere-encrypt/shardingsphere-encrypt-api/target/classes:/Users/dongzonglei/source_code/Github/shardingsphere/shardingsphere-features/shardingsphere-encrypt/shardingsphere-encrypt-plugin/shardingsphere-encrypt-sm/target/classes:/Users/dongzonglei/server/repository/org/bouncycastle/bcprov-jdk15on/1.70/bcprov-jdk15on-1.70.jar:/Users/dongzonglei/source_code/Github/shardingsphere/shardingsphere-features/shardingsphere-shadow/shardingsphere-shadow-core/target/classes:/Users/dongzonglei/source_code/Github/shardingsphere/shardingsphere-features/shardingsphere-shadow/shardingsphere-shadow-api/target/classes:/Users/dongzonglei/source_code/Github/shardingsphere/shardingsphere-infra/shardingsphere-infra-federation/shardingsphere-infra-federation-executor/target/classes:/Users/dongzonglei/source_code/Github/shardingsphere/shardingsphere-infra/shardingsphere-infra-federation/shardingsphere-infra-federation-optimizer/target/classes:/Users/dongzonglei/server/repository/org/apache/calcite/calcite-core/1.31.0/calcite-core-1.31.0.jar:/Users/dongzonglei/server/repository/com/esri/geometry/esri-geometry-api/2.2.0/esri-geometry-api-2.2.0.jar:/Users/dongzonglei/server/repository/com/fasterxml/jackson/dataformat/jackson-dataformat-yaml/2.13.2/jackson-dataformat-yaml-2.13.2.jar:/Users/dongzonglei/server/repository/com/google/uzaygezen/uzaygezen-core/0.2/uzaygezen-core-0.2.jar:/Users/dongzonglei/server/repository/com/jayway/jsonpath/json-path/2.7.0/json-path-2.7.0.jar:/Users/dongzonglei/server/repository/net/minidev/json-smart/2.4.7/json-smart-2.4.7.jar:/Users/dongzonglei/server/repository/net/minidev/accessors-smart/2.4.7/accessors-smart-2.4.7.jar:/Users/dongzonglei/server/repository/org/ow2/asm/asm/9.1/asm-9.1.jar:/Users/dongzonglei/server/repository/com/yahoo/datasketches/sketches-core/0.9.0/sketches-core-0.9.0.jar:/Users/dongzonglei/server/repository/com/yahoo/datasketches/memory/0.9.0/memory-0.9.0.jar:/Users/dongzonglei/server/repository/net/hydromatic/aggdesigner-algorithm/6.0/aggdesigner-algorithm-6.0.jar:/Users/dongzonglei/server/repository/org/apache/commons/commons-dbcp2/2.2.0/commons-dbcp2-2.2.0.jar:/Users/dongzonglei/server/repository/org/apache/commons/commons-pool2/2.5.0/commons-pool2-2.5.0.jar:/Users/dongzonglei/server/repository/commons-io/commons-io/2.11.0/commons-io-2.11.0.jar:/Users/dongzonglei/server/repository/org/codehaus/janino/commons-compiler/3.1.6/commons-compiler-3.1.6.jar:/Users/dongzonglei/server/repository/org/codehaus/janino/janino/3.1.6/janino-3.1.6.jar:/Users/dongzonglei/server/repository/org/apache/commons/commons-collections4/4.4/commons-collections4-4.4.jar:/Users/dongzonglei/server/repository/org/springframework/spring-context-support/4.3.30.RELEASE/spring-context-support-4.3.30.RELEASE.jar:/Users/dongzonglei/server/repository/org/springframework/spring-beans/4.3.30.RELEASE/spring-beans-4.3.30.RELEASE.jar:/Users/dongzonglei/server/repository/org/springframework/spring-context/4.3.30.RELEASE/spring-context-4.3.30.RELEASE.jar:/Users/dongzonglei/server/repository/org/springframework/spring-aop/4.3.30.RELEASE/spring-aop-4.3.30.RELEASE.jar:/Users/dongzonglei/server/repository/org/springframework/spring-expression/4.3.30.RELEASE/spring-expression-4.3.30.RELEASE.jar:/Users/dongzonglei/server/repository/org/springframework/spring-core/4.3.30.RELEASE/spring-core-4.3.30.RELEASE.jar:/Users/dongzonglei/server/repository/commons-logging/commons-logging/1.2/commons-logging-1.2.jar:/Users/dongzonglei/server/repository/org/springframework/spring-test/4.3.30.RELEASE/spring-test-4.3.30.RELEASE.jar:/Users/dongzonglei/server/repository/javax/annotation/javax.annotation-api/1.3.2/javax.annotation-api-1.3.2.jar:/Users/dongzonglei/server/repository/com/google/guava/guava/30.0-jre/guava-30.0-jre.jar:/Users/dongzonglei/server/repository/com/google/guava/failureaccess/1.0.1/failureaccess-1.0.1.jar:/Users/dongzonglei/server/repository/com/google/code/findbugs/jsr305/3.0.2/jsr305-3.0.2.jar:/Users/dongzonglei/server/repository/org/checkerframework/checker-qual/3.5.0/checker-qual-3.5.0.jar:/Users/dongzonglei/server/repository/com/google/errorprone/error_prone_annotations/2.3.4/error_prone_annotations-2.3.4.jar:/Users/dongzonglei/server/repository/org/projectlombok/lombok/1.18.20/lombok-1.18.20.jar:/Users/dongzonglei/server/repository/junit/junit/4.12/junit-4.12.jar:/Users/dongzonglei/server/repository/org/hamcrest/hamcrest-core/1.3/hamcrest-core-1.3.jar:/Users/dongzonglei/server/repository/org/hamcrest/hamcrest-library/1.3/hamcrest-library-1.3.jar:/Users/dongzonglei/server/repository/org/mockito/mockito-core/4.5.1/mockito-core-4.5.1.jar:/Users/dongzonglei/server/repository/net/bytebuddy/byte-buddy/1.12.10/byte-buddy-1.12.10.jar:/Users/dongzonglei/server/repository/net/bytebuddy/byte-buddy-agent/1.12.10/byte-buddy-agent-1.12.10.jar:/Users/dongzonglei/server/repository/org/objenesis/objenesis/3.2/objenesis-3.2.jar:/Users/dongzonglei/server/repository/org/mockito/mockito-inline/4.5.1/mockito-inline-4.5.1.jar:/Users/dongzonglei/server/repository/org/slf4j/slf4j-api/1.7.7/slf4j-api-1.7.7.jar:/Users/dongzonglei/server/repository/org/slf4j/jcl-over-slf4j/1.7.7/jcl-over-slf4j-1.7.7.jar:/Users/dongzonglei/server/repository/org/slf4j/jul-to-slf4j/1.7.7/jul-to-slf4j-1.7.7.jar:/Users/dongzonglei/server/repository/ch/qos/logback/logback-classic/1.2.10/logback-classic-1.2.10.jar:/Users/dongzonglei/server/repository/ch/qos/logback/logback-core/1.2.10/logback-core-1.2.10.jar com.intellij.rt.junit.JUnitStarter -ideVersion5 -junit4 org.apache.shardingsphere.sharding.spring.namespace.ShardingSpringNamespaceTest,assertKeyGenAlgorithm
[ERROR] 2022-09-06 00:06:32.164 [main] o.s.test.context.TestContextManager - Caught exception while allowing TestExecutionListener [org.springframework.test.context.support.DependencyInjectionTestExecutionListener@1224144a] to prepare test instance [org.apache.shardingsphere.sharding.spring.namespace.ShardingSpringNamespaceTest@29f7cefd]
java.lang.IllegalStateException: Failed to load ApplicationContext
at org.springframework.test.context.cache.DefaultCacheAwareContextLoaderDelegate.loadContext(DefaultCacheAwareContextLoaderDelegate.java:124)
at org.springframework.test.context.support.DefaultTestContext.getApplicationContext(DefaultTestContext.java:83)
at org.springframework.test.context.support.DependencyInjectionTestExecutionListener.injectDependencies(DependencyInjectionTestExecutionListener.java:117)
at org.springframework.test.context.support.DependencyInjectionTestExecutionListener.prepareTestInstance(DependencyInjectionTestExecutionListener.java:83)
at org.springframework.test.context.TestContextManager.prepareTestInstance(TestContextManager.java:230)
at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.createTest(SpringJUnit4ClassRunner.java:228)
at org.springframework.test.context.junit4.SpringJUnit4ClassRunner$1.runReflectiveCall(SpringJUnit4ClassRunner.java:287)
at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12)
at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.methodBlock(SpringJUnit4ClassRunner.java:289)
at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.runChild(SpringJUnit4ClassRunner.java:247)
at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.runChild(SpringJUnit4ClassRunner.java:94)
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.springframework.test.context.junit4.statements.RunBeforeTestClassCallbacks.evaluate(RunBeforeTestClassCallbacks.java:61)
at org.springframework.test.context.junit4.statements.RunAfterTestClassCallbacks.evaluate(RunAfterTestClassCallbacks.java:70)
at org.junit.runners.ParentRunner.run(ParentRunner.java:363)
at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.run(SpringJUnit4ClassRunner.java:191)
at org.junit.runner.JUnitCore.run(JUnitCore.java:137)
at com.intellij.junit4.JUnit4IdeaTestRunner.startRunnerWithArgs(JUnit4IdeaTestRunner.java:69)
at com.intellij.rt.junit.IdeaTestRunner$Repeater$1.execute(IdeaTestRunner.java:38)
at com.intellij.rt.execution.junit.TestsRepeater.repeat(TestsRepeater.java:11)
at com.intellij.rt.junit.IdeaTestRunner$Repeater.startRunnerWithArgs(IdeaTestRunner.java:35)
at com.intellij.rt.junit.JUnitStarter.prepareStreamsAndStart(JUnitStarter.java:235)
at com.intellij.rt.junit.JUnitStarter.main(JUnitStarter.java:54)
Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'simpleRule': Cannot resolve reference to bean 'uuidAlgorithm' while setting bean property 'keyGenerators' with key [uuidAlgorithm]; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'uuidAlgorithm': FactoryBean threw exception on object creation; nested exception is java.util.ServiceConfigurationError: org.apache.shardingsphere.sharding.spi.KeyGenerateAlgorithm: Provider org.apache.shardingsphere.sharding.spring.namespace.fixture.keygen.IncrementKeyGenerateAlgorithm not found
at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:359)
at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:108)
at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveManagedMap(BeanDefinitionValueResolver.java:407)
at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:165)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1522)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1269)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:551)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:481)
at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:312)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:308)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:197)
at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:756)
at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:867)
at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:542)
at org.springframework.test.context.support.AbstractGenericContextLoader.loadContext(AbstractGenericContextLoader.java:127)
at org.springframework.test.context.support.AbstractGenericContextLoader.loadContext(AbstractGenericContextLoader.java:60)
at org.springframework.test.context.support.AbstractDelegatingSmartContextLoader.delegateLoading(AbstractDelegatingSmartContextLoader.java:281)
at org.springframework.test.context.support.AbstractDelegatingSmartContextLoader.loadContext(AbstractDelegatingSmartContextLoader.java:249)
at org.springframework.test.context.cache.DefaultCacheAwareContextLoaderDelegate.loadContextInternal(DefaultCacheAwareContextLoaderDelegate.java:98)
at org.springframework.test.context.cache.DefaultCacheAwareContextLoaderDelegate.loadContext(DefaultCacheAwareContextLoaderDelegate.java:116)
... 26 common frames omitted
Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'uuidAlgorithm': FactoryBean threw exception on object creation; nested exception is java.util.ServiceConfigurationError: org.apache.shardingsphere.sharding.spi.KeyGenerateAlgorithm: Provider org.apache.shardingsphere.sharding.spring.namespace.fixture.keygen.IncrementKeyGenerateAlgorithm not found
at org.springframework.beans.factory.support.FactoryBeanRegistrySupport.doGetObjectFromFactoryBean(FactoryBeanRegistrySupport.java:185)
at org.springframework.beans.factory.support.FactoryBeanRegistrySupport.getObjectFromFactoryBean(FactoryBeanRegistrySupport.java:103)
at org.springframework.beans.factory.support.AbstractBeanFactory.getObjectForBeanInstance(AbstractBeanFactory.java:1646)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:254)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:197)
at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:351)
... 46 common frames omitted
Caused by: java.util.ServiceConfigurationError: org.apache.shardingsphere.sharding.spi.KeyGenerateAlgorithm: Provider org.apache.shardingsphere.sharding.spring.namespace.fixture.keygen.IncrementKeyGenerateAlgorithm not found
at java.util.ServiceLoader.fail(ServiceLoader.java:239)
at java.util.ServiceLoader.access$300(ServiceLoader.java:185)
at java.util.ServiceLoader$LazyIterator.nextService(ServiceLoader.java:372)
at java.util.ServiceLoader$LazyIterator.next(ServiceLoader.java:404)
at java.util.ServiceLoader$1.next(ServiceLoader.java:480)
at org.apache.shardingsphere.infra.util.spi.ShardingSphereServiceLoader.load(ShardingSphereServiceLoader.java:53)
at org.apache.shardingsphere.infra.util.spi.ShardingSphereServiceLoader.register(ShardingSphereServiceLoader.java:47)
at org.apache.shardingsphere.sharding.factory.KeyGenerateAlgorithmFactory.<clinit>(KeyGenerateAlgorithmFactory.java:36)
at org.apache.shardingsphere.sharding.spring.namespace.factorybean.KeyGenerateAlgorithmFactoryBean.getObject(KeyGenerateAlgorithmFactoryBean.java:38)
at org.apache.shardingsphere.sharding.spring.namespace.factorybean.KeyGenerateAlgorithmFactoryBean.getObject(KeyGenerateAlgorithmFactoryBean.java:30)
at org.springframework.beans.factory.support.FactoryBeanRegistrySupport.doGetObjectFromFactoryBean(FactoryBeanRegistrySupport.java:178)
... 51 common frames omitted

java.lang.IllegalStateException: Failed to load ApplicationContext

at org.springframework.test.context.cache.DefaultCacheAwareContextLoaderDelegate.loadContext(DefaultCacheAwareContextLoaderDelegate.java:124)
at org.springframework.test.context.support.DefaultTestContext.getApplicationContext(DefaultTestContext.java:83)
at org.springframework.test.context.support.DependencyInjectionTestExecutionListener.injectDependencies(DependencyInjectionTestExecutionListener.java:117)
at org.springframework.test.context.support.DependencyInjectionTestExecutionListener.prepareTestInstance(DependencyInjectionTestExecutionListener.java:83)
at org.springframework.test.context.TestContextManager.prepareTestInstance(TestContextManager.java:230)
at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.createTest(SpringJUnit4ClassRunner.java:228)
at org.springframework.test.context.junit4.SpringJUnit4ClassRunner$1.runReflectiveCall(SpringJUnit4ClassRunner.java:287)
at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12)
at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.methodBlock(SpringJUnit4ClassRunner.java:289)
at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.runChild(SpringJUnit4ClassRunner.java:247)
at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.runChild(SpringJUnit4ClassRunner.java:94)
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.springframework.test.context.junit4.statements.RunBeforeTestClassCallbacks.evaluate(RunBeforeTestClassCallbacks.java:61)
at org.springframework.test.context.junit4.statements.RunAfterTestClassCallbacks.evaluate(RunAfterTestClassCallbacks.java:70)
at org.junit.runners.ParentRunner.run(ParentRunner.java:363)
at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.run(SpringJUnit4ClassRunner.java:191)
at org.junit.runner.JUnitCore.run(JUnitCore.java:137)
at com.intellij.junit4.JUnit4IdeaTestRunner.startRunnerWithArgs(JUnit4IdeaTestRunner.java:69)
at com.intellij.rt.junit.IdeaTestRunner$Repeater$1.execute(IdeaTestRunner.java:38)
at com.intellij.rt.execution.junit.TestsRepeater.repeat(TestsRepeater.java:11)
at com.intellij.rt.junit.IdeaTestRunner$Repeater.startRunnerWithArgs(IdeaTestRunner.java:35)
at com.intellij.rt.junit.JUnitStarter.prepareStreamsAndStart(JUnitStarter.java:235)
at com.intellij.rt.junit.JUnitStarter.main(JUnitStarter.java:54)
Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'simpleRule': Cannot resolve reference to bean 'uuidAlgorithm' while setting bean property 'keyGenerators' with key [uuidAlgorithm]; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'uuidAlgorithm': FactoryBean threw exception on object creation; nested exception is java.util.ServiceConfigurationError: org.apache.shardingsphere.sharding.spi.KeyGenerateAlgorithm: Provider org.apache.shardingsphere.sharding.spring.namespace.fixture.keygen.IncrementKeyGenerateAlgorithm not found
at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:359)
at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:108)
at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveManagedMap(BeanDefinitionValueResolver.java:407)
at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:165)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1522)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1269)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:551)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:481)
at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:312)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:308)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:197)
at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:756)
at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:867)
at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:542)
at org.springframework.test.context.support.AbstractGenericContextLoader.loadContext(AbstractGenericContextLoader.java:127)
at org.springframework.test.context.support.AbstractGenericContextLoader.loadContext(AbstractGenericContextLoader.java:60)
at org.springframework.test.context.support.AbstractDelegatingSmartContextLoader.delegateLoading(AbstractDelegatingSmartContextLoader.java:281)
at org.springframework.test.context.support.AbstractDelegatingSmartContextLoader.loadContext(AbstractDelegatingSmartContextLoader.java:249)
at org.springframework.test.context.cache.DefaultCacheAwareContextLoaderDelegate.loadContextInternal(DefaultCacheAwareContextLoaderDelegate.java:98)
at org.springframework.test.context.cache.DefaultCacheAwareContextLoaderDelegate.loadContext(DefaultCacheAwareContextLoaderDelegate.java:116)
... 26 more
Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'uuidAlgorithm': FactoryBean threw exception on object creation; nested exception is java.util.ServiceConfigurationError: org.apache.shardingsphere.sharding.spi.KeyGenerateAlgorithm: Provider org.apache.shardingsphere.sharding.spring.namespace.fixture.keygen.IncrementKeyGenerateAlgorithm not found
at org.springframework.beans.factory.support.FactoryBeanRegistrySupport.doGetObjectFromFactoryBean(FactoryBeanRegistrySupport.java:185)
at org.springframework.beans.factory.support.FactoryBeanRegistrySupport.getObjectFromFactoryBean(FactoryBeanRegistrySupport.java:103)
at org.springframework.beans.factory.support.AbstractBeanFactory.getObjectForBeanInstance(AbstractBeanFactory.java:1646)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:254)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:197)
at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:351)
... 46 more
Caused by: java.util.ServiceConfigurationError: org.apache.shardingsphere.sharding.spi.KeyGenerateAlgorithm: Provider org.apache.shardingsphere.sharding.spring.namespace.fixture.keygen.IncrementKeyGenerateAlgorithm not found
at java.util.ServiceLoader.fail(ServiceLoader.java:239)
at java.util.ServiceLoader.access$300(ServiceLoader.java:185)
at java.util.ServiceLoader$LazyIterator.nextService(ServiceLoader.java:372)
at java.util.ServiceLoader$LazyIterator.next(ServiceLoader.java:404)
at java.util.ServiceLoader$1.next(ServiceLoader.java:480)
at org.apache.shardingsphere.infra.util.spi.ShardingSphereServiceLoader.load(ShardingSphereServiceLoader.java:53)
at org.apache.shardingsphere.infra.util.spi.ShardingSphereServiceLoader.register(ShardingSphereServiceLoader.java:47)
at org.apache.shardingsphere.sharding.factory.KeyGenerateAlgorithmFactory.<clinit>(KeyGenerateAlgorithmFactory.java:36)
at org.apache.shardingsphere.sharding.spring.namespace.factorybean.KeyGenerateAlgorithmFactoryBean.getObject(KeyGenerateAlgorithmFactoryBean.java:38)
at org.apache.shardingsphere.sharding.spring.namespace.factorybean.KeyGenerateAlgorithmFactoryBean.getObject(KeyGenerateAlgorithmFactoryBean.java:30)
at org.springframework.beans.factory.support.FactoryBeanRegistrySupport.doGetObjectFromFactoryBean(FactoryBeanRegistrySupport.java:178)
... 51 more

Process finished with exit code 255

Issue 2:
Bug Report

SQL like "select * from t_order where create_time between '2018-01-01 00:00:00' and '2018-01-02 00:00:00'" is not supported, we use create_time for RangeShardingAlgorithm

and we always get the wrong RangeShardingValue ( we expected Range ['2018-01-01 00:00:00', '2018-01-02 00:00:00'] bu we received Range [-1, -1] ), the column type of create_time is datetime.

in the OrConditionFilter.java line 206,

private com.google.common.base.Optional<SQLExpression> buildExpression(final SelectStatement selectStatement, final ExpressionSegment expressionSegment, final String sql,
final ShardingRule shardingRule, final ShardingTableMetaData shardingTableMetaData) {
if (!(expressionSegment instanceof CommonExpressionSegment)) {
new ExpressionFiller().fill(expressionSegment, selectStatement, sql, shardingRule, shardingTableMetaData);
return com.google.common.base.Optional.absent();
}
CommonExpressionSegment commonExpressionSegment = (CommonExpressionSegment) expressionSegment;
if (-1 < commonExpressionSegment.getIndex()) {
return com.google.common.base.Optional.<SQLExpression>of(new SQLPlaceholderExpression(commonExpressionSegment.getIndex()));
}
// it will always return SQLNumberExpression because there is a default value -1 for commonExpressionSegment.getValue()
if (null != commonExpressionSegment.getValue()) {
return com.google.common.base.Optional.<SQLExpression>of(new SQLNumberExpression(commonExpressionSegment.getValue()));
}
String expression = sql.substring(commonExpressionSegment.getStartPosition(), commonExpressionSegment.getEndPosition() + 1);
return Optional.<SQLExpression>of(new SQLTextExpression(expression));
}

but the value field in CommonExpressionSegment has a default value -1. so it will be always consider as SQLNumberExpression.

after i remove the default value -1 for field value in CommonExpressionSegment.java, it's ok.

public final class CommonExpressionSegment extends ExpressionWithAliasSegment
{

private final int startPosition;

private final int endPosition;

private int index = -1;

//remove the default value -1
private Number value;
}

but the range value keep the single quote for the string like this:

['2018-01-01 00:00:00', '2018-01-01 23:59:59']

lowerEndpoint: '2018-01-01 00:00:00' upperEndpoint: '2018-01-01 23:59:59'

and what we expected is like this:

[2018-01-01 00:00:00, 2018-01-01 23:59:59]

lowerEndpoint: 2018-01-01 00:00:00 upperEndpoint: 2018-01-01 23:59:59

the source code for RangeShardingAlgorithm is like this:

public Collection<String> doSharding(Collection<String> availableTargetNames, RangeShardingValue<String> value)

Which version of ShardingSphere did you use?

3.1.0

Which project did you use? Sharding-JDBC or Sharding-Proxy?

Sharding-JDBC

Expected behavior

supported

Actual behavior

not supported

Reason analyze (If you can)

as mentioned above

Steps to reproduce the behavior, such as: SQL to execute, sharding rule configuration, when exception occur etc.

as mentioned above

Example codes for reproduce this issue (such as a github link).

as mentioned above