You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by GitBox <gi...@apache.org> on 2021/12/06 06:18:58 UTC

[GitHub] [shardingsphere] userkdg opened a new issue #13940: select subquery Bug

userkdg opened a new issue #13940:
URL: https://github.com/apache/shardingsphere/issues/13940


   ## Bug Report
   
   ### Which version of ShardingSphere did you use?
   5.0.0-GA
   
   ### Which project did you use? ShardingSphere-JDBC or ShardingSphere-Proxy?
   ShardingSphere-Proxy
   
   ### Expected behavior
   
   select count(0) as cnt from ( select address_cipher as address from ec_oms_order ) as tmp;
   
   ### Actual behavior
   
   select count(0) as cnt from ( select address from ec_oms_order ) as tmp;
   
   ### Reason analyze (If you can)
   
   sql parser failed , not supported subquery select on encrypt tables
   
   ### 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).
   ```
   MySQL [ec_order_db]> preview select count(0) as cnt from ( select address from ec_oms_order ) as tmp;
   +------------------+-------------------------------------------------------------------------+
   | data_source_name | sql                                                                     |
   +------------------+-------------------------------------------------------------------------+
   | ec_order_ds      | select count(0) as cnt from ( select address from ec_oms_order ) as tmp |
   +------------------+-------------------------------------------------------------------------+
   ```


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org

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



[GitHub] [shardingsphere] strongduanmu closed issue #13940: select subquery Bug

Posted by GitBox <gi...@apache.org>.
strongduanmu closed issue #13940:
URL: https://github.com/apache/shardingsphere/issues/13940


   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org

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



[GitHub] [shardingsphere] userkdg commented on issue #13940: select subquery Bug

Posted by GitBox <gi...@apache.org>.
userkdg commented on issue #13940:
URL: https://github.com/apache/shardingsphere/issues/13940#issuecomment-987502746


   > @userkdg This is the result of my test, and no exception was found.
   > 
   > ```
   > [INFO ] 2021-12-07 09:17:23.323 [Connection-1-ThreadExecutor] ShardingSphere-SQL - Logic SQL: select count(0) as cnt from (select order_id from t_encrypt) as tmp
   > [INFO ] 2021-12-07 09:17:23.324 [Connection-1-ThreadExecutor] ShardingSphere-SQL - SQLStatement: MySQLSelectStatement(limit=Optional.empty, lock=Optional.empty, window=Optional.empty)
   > [INFO ] 2021-12-07 09:17:23.324 [Connection-1-ThreadExecutor] ShardingSphere-SQL - Actual SQL: ds_1 ::: select count(0) as cnt from (select order_cipher AS order_id from t_encrypt) as tmp
   > ```
   
   thinks,i check it on local env,success ! but had a new issue now 
   
    on my build docker container,when  ** mysql -hxxx -P53308 -uroot -pxxx ** connect to proxy,then not login command line , the proxy console print  the error:
   ``` 
   02:05:38.752 [epollEventLoopGroup-3-1] DEBUG org.apache.shardingsphere.db.protocol.codec.PacketCodec - Read from client 9b9c9754 :
            +-------------------------------------------------+
            |  0  1  2  3  4  5  6  7  8  9  a  b  c  d  e  f |
   +--------+-------------------------------------------------+----------------+
   |00000000| 21 00 00 00 03 73 65 6c 65 63 74 20 40 40 76 65 |!....select @@ve|
   |00000010| 72 73 69 6f 6e 5f 63 6f 6d 6d 65 6e 74 20 6c 69 |rsion_comment li|
   |00000020| 6d 69 74 20 31                                  |mit 1           |
   +--------+-------------------------------------------------+----------------+
   Exception in thread "ShardingSphere-Command-0" java.lang.NoSuchMethodError: org.apache.shardingsphere.db.protocol.mysql.packet.command.MySQLCommandPacketFactory.newInstance(Lorg/apache/shardingsphere/db/protocol/mysql/packet/command/MySQLCommandPacketType;Lorg/apache/shardingsphere/db/protocol/mysql/payload/MySQLPacketPayload;)Lorg/apache/shardingsphere/db/protocol/mysql/packet/command/MySQLCommandPacket;
   	at org.apache.shardingsphere.proxy.frontend.mysql.command.MySQLCommandExecuteEngine.getCommandPacket(MySQLCommandExecuteEngine.java:55)
   	at org.apache.shardingsphere.proxy.frontend.mysql.command.MySQLCommandExecuteEngine.getCommandPacket(MySQLCommandExecuteEngine.java:46)
   	at org.apache.shardingsphere.proxy.frontend.command.CommandExecutorTask.executeCommand(CommandExecutorTask.java:96)
   	at org.apache.shardingsphere.proxy.frontend.command.CommandExecutorTask.run(CommandExecutorTask.java:72)
   	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
   	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
   	at java.lang.Thread.run(Thread.java:748)
   02:05:42.054 [main-SendThread(192.168.243.34:12181)] DEBUG org.apache.zookeeper.ClientCnxn - Got ping response for session id: 0x104e9235c6801e4 after 1ms.
   02:0
   ``` 
   additional docker files 
   ``` text
   ext-lib
     bcpkix-jdk15on-1.60.jar
     bcprov-jdk15on-1.60.jar
     bd-shardingsphere-custom-encrypt-algo-5.0.0.jar
     hutool-core-5.7.16.jar
     hutool-crypto-5.7.16.jar
     mysql-connector-java-8.0.26.jar
   
   
   lib
     accessors-smart-1.2.jar
     aggdesigner-algorithm-6.0.jar
     animal-sniffer-annotations-1.18.jar
     antlr4-runtime-4.9.2.jar
     apiguardian-api-1.1.0.jar
     asm-5.0.4.jar
     atomikos-util-5.0.8.jar
     audience-annotations-0.5.0.jar
     avatica-core-1.18.0.jar
     avatica-metrics-1.18.0.jar
     calcite-core-1.27.0.jar
     calcite-linq4j-1.27.0.jar
     checker-qual-2.11.1.jar
     commons-codec-1.10.jar
     commons-collections4-4.2.jar
     commons-compiler-3.0.11.jar
     commons-exec-1.3.jar
     commons-io-2.8.0.jar
     commons-lang-2.6.jar
     commons-lang3-3.4.jar
     commons-logging-1.1.3.jar
     curator-client-5.1.0.jar
     curator-framework-5.1.0.jar
     curator-recipes-5.1.0.jar
     elasticjob-api-3.0.1.jar
     elasticjob-dataflow-executor-3.0.1.jar
     elasticjob-error-handler-general-3.0.1.jar
     elasticjob-error-handler-spi-3.0.1.jar
     elasticjob-executor-kernel-3.0.1.jar
     elasticjob-http-executor-3.0.1.jar
     elasticjob-infra-common-3.0.1.jar
     elasticjob-lite-core-3.0.1.jar
     elasticjob-lite-lifecycle-3.0.1.jar
     elasticjob-registry-center-3.0.1.jar
     elasticjob-script-executor-3.0.1.jar
     elasticjob-simple-executor-3.0.1.jar
     elasticjob-tracing-api-3.0.1.jar
     elasticjob-tracing-rdb-3.0.1.jar
     error_prone_annotations-2.3.4.jar
     esri-geometry-api-2.2.0.jar
     failsafe-2.3.3.jar
     failureaccess-1.0.1.jar
     groovy-2.4.19-indy.jar
     grpc-api-1.27.1.jar
     grpc-context-1.27.1.jar
     grpc-core-1.27.1.jar
     grpc-grpclb-1.27.1.jar
     grpc-netty-1.27.1.jar
     grpc-protobuf-1.27.1.jar
     grpc-protobuf-lite-1.27.1.jar
     grpc-stub-1.27.1.jar
     gson-2.8.6.jar
     guava-29.0-jre.jar
     HikariCP-3.4.2.jar
     httpclient-4.5.9.jar
     httpcore-4.4.11.jar
     jackson-annotations-2.10.0.jar
     jackson-core-2.10.0.jar
     jackson-databind-2.10.0.jar
     jackson-dataformat-yaml-2.10.0.jar
     janino-3.0.11.jar
     jcl-over-slf4j-1.7.7.jar
     jetcd-common-0.5.0.jar
     jetcd-core-0.5.0.jar
     jetcd-resolver-0.5.0.jar
     json-path-2.4.0.jar
     json-smart-2.3.jar
     jsr305-3.0.2.jar
     jta-1.1.jar
     listenablefuture-9999.0-empty-to-avoid-conflict-with-guava.jar
     log4j-1.2.17.jar
     logback-classic-1.2.0.jar
     logback-core-1.2.0.jar
     mchange-commons-java-0.2.15.jar
     memory-0.9.0.jar
     netty-buffer-4.1.69.Final.jar
     netty-codec-4.1.69.Final.jar
     netty-codec-http-4.1.69.Final.jar
     netty-codec-http2-4.1.69.Final.jar
     netty-codec-socks-4.1.69.Final.jar
     netty-common-4.1.69.Final.jar
     netty-handler-4.1.69.Final.jar
     netty-handler-proxy-4.1.69.Final.jar
     netty-resolver-4.1.69.Final.jar
     netty-transport-4.1.69.Final.jar
     netty-transport-native-epoll-4.1.69.Final-linux-aarch_64.jar
     netty-transport-native-epoll-4.1.69.Final-linux-x86_64.jar
     netty-transport-native-epoll-4.1.69.Final.jar
     netty-transport-native-unix-common-4.1.69.Final.jar
     perfmark-api-0.19.0.jar
     postgresql-42.2.5.jar
     proto-google-common-protos-1.17.0.jar
     protobuf-java-3.11.0.jar
     protobuf-java-util-3.11.0.jar
     quartz-2.3.2.jar
     shardingsphere-authority-api-5.0.1-SNAPSHOT.jar
     shardingsphere-authority-core-5.0.1-SNAPSHOT.jar
     shardingsphere-cluster-mode-core-5.0.1-SNAPSHOT.jar
     shardingsphere-cluster-mode-repository-api-5.0.1-SNAPSHOT.jar
     shardingsphere-cluster-mode-repository-etcd-5.0.1-SNAPSHOT.jar
     shardingsphere-cluster-mode-repository-zookeeper-curator-5.0.1-SNAPSHOT.jar
     shardingsphere-db-discovery-api-5.0.1-SNAPSHOT.jar
     shardingsphere-db-discovery-core-5.0.1-SNAPSHOT.jar
     shardingsphere-db-discovery-distsql-handler-5.0.1-SNAPSHOT.jar
     shardingsphere-db-discovery-distsql-parser-5.0.1-SNAPSHOT.jar
     shardingsphere-db-discovery-distsql-statement-5.0.1-SNAPSHOT.jar
     shardingsphere-db-discovery-mgr-5.0.1-SNAPSHOT.jar
     shardingsphere-db-protocol-core-5.0.1-SNAPSHOT.jar
     shardingsphere-db-protocol-mysql-5.0.1-SNAPSHOT.jar
     shardingsphere-db-protocol-opengauss-5.0.1-SNAPSHOT.jar
     shardingsphere-db-protocol-postgresql-5.0.1-SNAPSHOT.jar
     shardingsphere-distsql-parser-5.0.1-SNAPSHOT.jar
     shardingsphere-distsql-statement-5.0.1-SNAPSHOT.jar
     shardingsphere-encrypt-api-5.0.1-SNAPSHOT.jar
     shardingsphere-encrypt-core-5.0.1-SNAPSHOT.jar
     shardingsphere-encrypt-distsql-handler-5.0.1-SNAPSHOT.jar
     shardingsphere-encrypt-distsql-parser-5.0.1-SNAPSHOT.jar
     shardingsphere-encrypt-distsql-statement-5.0.1-SNAPSHOT.jar
     shardingsphere-infra-binder-5.0.1-SNAPSHOT.jar
     shardingsphere-infra-common-5.0.1-SNAPSHOT.jar
     shardingsphere-infra-context-5.0.1-SNAPSHOT.jar
     shardingsphere-infra-datetime-spi-5.0.1-SNAPSHOT.jar
     shardingsphere-infra-executor-5.0.1-SNAPSHOT.jar
     shardingsphere-infra-federation-optimizer-5.0.1-SNAPSHOT.jar
     shardingsphere-infra-merge-5.0.1-SNAPSHOT.jar
     shardingsphere-infra-parser-5.0.1-SNAPSHOT.jar
     shardingsphere-infra-rewrite-5.0.1-SNAPSHOT.jar
     shardingsphere-infra-route-5.0.1-SNAPSHOT.jar
     shardingsphere-jdbc-core-5.0.1-SNAPSHOT.jar
     shardingsphere-memory-mode-core-5.0.1-SNAPSHOT.jar
     shardingsphere-mode-core-5.0.1-SNAPSHOT.jar
     shardingsphere-parser-api-5.0.1-SNAPSHOT.jar
     shardingsphere-parser-core-5.0.1-SNAPSHOT.jar
     shardingsphere-proxy-backend-5.0.1-SNAPSHOT.jar
     shardingsphere-proxy-bootstrap-5.0.1-SNAPSHOT.jar
     shardingsphere-proxy-frontend-core-5.0.1-SNAPSHOT.jar
     shardingsphere-proxy-frontend-mysql-5.0.1-SNAPSHOT.jar
     shardingsphere-proxy-frontend-opengauss-5.0.1-SNAPSHOT.jar
     shardingsphere-proxy-frontend-postgresql-5.0.1-SNAPSHOT.jar
     shardingsphere-proxy-frontend-spi-5.0.1-SNAPSHOT.jar
     shardingsphere-readwrite-splitting-api-5.0.1-SNAPSHOT.jar
     shardingsphere-readwrite-splitting-core-5.0.1-SNAPSHOT.jar
     shardingsphere-readwrite-splitting-distsql-handler-5.0.1-SNAPSHOT.jar
     shardingsphere-readwrite-splitting-distsql-parser-5.0.1-SNAPSHOT.jar
     shardingsphere-readwrite-splitting-distsql-statement-5.0.1-SNAPSHOT.jar
     shardingsphere-scaling-core-5.0.1-SNAPSHOT.jar
     shardingsphere-scaling-distsql-handler-5.0.1-SNAPSHOT.jar
     shardingsphere-scaling-distsql-parser-5.0.1-SNAPSHOT.jar
     shardingsphere-scaling-distsql-statement-5.0.1-SNAPSHOT.jar
     shardingsphere-scaling-mysql-5.0.1-SNAPSHOT.jar
     shardingsphere-scaling-opengauss-5.0.1-SNAPSHOT.jar
     shardingsphere-scaling-postgresql-5.0.1-SNAPSHOT.jar
     shardingsphere-shadow-api-5.0.1-SNAPSHOT.jar
     shardingsphere-shadow-core-5.0.1-SNAPSHOT.jar
     shardingsphere-shadow-distsql-handler-5.0.1-SNAPSHOT.jar
     shardingsphere-shadow-distsql-parser-5.0.1-SNAPSHOT.jar
     shardingsphere-shadow-distsql-statement-5.0.1-SNAPSHOT.jar
     shardingsphere-sharding-api-5.0.1-SNAPSHOT.jar
     shardingsphere-sharding-core-5.0.1-SNAPSHOT.jar
     shardingsphere-sharding-distsql-handler-5.0.1-SNAPSHOT.jar
     shardingsphere-sharding-distsql-parser-5.0.1-SNAPSHOT.jar
     shardingsphere-sharding-distsql-statement-5.0.1-SNAPSHOT.jar
     shardingsphere-single-table-api-5.0.1-SNAPSHOT.jar
     shardingsphere-single-table-core-5.0.1-SNAPSHOT.jar
     shardingsphere-spi-5.0.1-SNAPSHOT.jar
     shardingsphere-sql-parser-engine-5.0.1-SNAPSHOT.jar
     shardingsphere-sql-parser-mysql-5.0.1-SNAPSHOT.jar
     shardingsphere-sql-parser-opengauss-5.0.1-SNAPSHOT.jar
     shardingsphere-sql-parser-oracle-5.0.1-SNAPSHOT.jar
     shardingsphere-sql-parser-postgresql-5.0.1-SNAPSHOT.jar
     shardingsphere-sql-parser-spi-5.0.1-SNAPSHOT.jar
     shardingsphere-sql-parser-sql92-5.0.1-SNAPSHOT.jar
     shardingsphere-sql-parser-sqlserver-5.0.1-SNAPSHOT.jar
     shardingsphere-sql-parser-statement-5.0.1-SNAPSHOT.jar
     shardingsphere-standalone-mode-core-5.0.1-SNAPSHOT.jar
     shardingsphere-standalone-mode-repository-api-5.0.1-SNAPSHOT.jar
     shardingsphere-standalone-mode-repository-file-5.0.1-SNAPSHOT.jar
     shardingsphere-system-datetime-5.0.1-SNAPSHOT.jar
     shardingsphere-transaction-api-5.0.1-SNAPSHOT.jar
     shardingsphere-transaction-core-5.0.1-SNAPSHOT.jar
     shardingsphere-transaction-xa-atomikos-5.0.1-SNAPSHOT.jar
     shardingsphere-transaction-xa-core-5.0.1-SNAPSHOT.jar
     shardingsphere-transaction-xa-spi-5.0.1-SNAPSHOT.jar
     sketches-core-0.9.0.jar
     slf4j-api-1.7.7.jar
     snakeyaml-1.16.jar
     transactions-5.0.8.jar
     transactions-api-5.0.8.jar
     transactions-jdbc-5.0.8.jar
     transactions-jta-5.0.8.jar
     uzaygezen-core-0.2.jar
     zookeeper-3.6.0.jar
     zookeeper-jute-3.6.0.jar
   ```
   
   
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org

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



[GitHub] [shardingsphere] strongduanmu commented on issue #13940: select subquery Bug

Posted by GitBox <gi...@apache.org>.
strongduanmu commented on issue #13940:
URL: https://github.com/apache/shardingsphere/issues/13940#issuecomment-987510245


   > thinks,i check it on local env,success ! but had a new issue now
   
   @userkdg Welcome to submit a new issue to report this issue.


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org

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



[GitHub] [shardingsphere] userkdg commented on issue #13940: select subquery Bug

Posted by GitBox <gi...@apache.org>.
userkdg commented on issue #13940:
URL: https://github.com/apache/shardingsphere/issues/13940#issuecomment-987609469


   > @userkdg This is the result of my test, and no exception was found.
   > 
   > ```
   > [INFO ] 2021-12-07 09:17:23.323 [Connection-1-ThreadExecutor] ShardingSphere-SQL - Logic SQL: select count(0) as cnt from (select order_id from t_encrypt) as tmp
   > [INFO ] 2021-12-07 09:17:23.324 [Connection-1-ThreadExecutor] ShardingSphere-SQL - SQLStatement: MySQLSelectStatement(limit=Optional.empty, lock=Optional.empty, window=Optional.empty)
   > [INFO ] 2021-12-07 09:17:23.324 [Connection-1-ThreadExecutor] ShardingSphere-SQL - Actual SQL: ds_1 ::: select count(0) as cnt from (select order_cipher AS order_id from t_encrypt) as tmp
   > ```
   
   bad!! subquery table set alias , proxy rewrite sql error .  such as :
   
   actual
   ``` sql
   MySQL [ec_order_db]> preview select count(1) as cnt from (select a.address from ec_oms_order a) as tmp;
   +------------------+-----------------------------------------------------------------------------------------------+
   | data_source_name | sql                                                                                           |
   +------------------+-----------------------------------------------------------------------------------------------+
   | ec_order_ds      | select count(1) as cnt from (select a.a.address_cipher AS address from ec_oms_order a) as tmp |
   +------------------+-----------------------------------------------------------------------------------------------+
   
   ```
   Expected 
   
   ``` sql 
    select count(1) as cnt from (select a.address_cipher AS address from ec_oms_order a) as tmp
   ```
   
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org

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



[GitHub] [shardingsphere] strongduanmu commented on issue #13940: select subquery Bug

Posted by GitBox <gi...@apache.org>.
strongduanmu commented on issue #13940:
URL: https://github.com/apache/shardingsphere/issues/13940#issuecomment-987612373


   > ```sql
   > MySQL [ec_order_db]> preview select count(1) as cnt from (select a.address from ec_oms_order a) as tmp;
   > ```
   
   Hi @userkdg, thank you for your test, and can you report this bug on another issue? 


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org

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



[GitHub] [shardingsphere] userkdg commented on issue #13940: select subquery Bug

Posted by GitBox <gi...@apache.org>.
userkdg commented on issue #13940:
URL: https://github.com/apache/shardingsphere/issues/13940#issuecomment-986474305


   please ,every boss how to deal 


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org

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



[GitHub] [shardingsphere] userkdg commented on issue #13940: select subquery Bug

Posted by GitBox <gi...@apache.org>.
userkdg commented on issue #13940:
URL: https://github.com/apache/shardingsphere/issues/13940#issuecomment-986717142


   > Hi @userkdg, I have tested this issue on version 5.0.0 and this is indeed a bug. The latest master branch has fixed this problem, welcome to test.
   
   i try found the fixed commit - revision number 【b8db81f51e533773a8992c4909cc4f623279a356 】, message 【optimize encrypt subquery projection rewrite logic (#13643)】, but not fix it .
   
   
   
   
   
   
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org

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



[GitHub] [shardingsphere] strongduanmu commented on issue #13940: select subquery Bug

Posted by GitBox <gi...@apache.org>.
strongduanmu commented on issue #13940:
URL: https://github.com/apache/shardingsphere/issues/13940#issuecomment-986508426


   Hi @userkdg, I have tested this issue on version 5.0.0 and this is indeed a bug. The latest master branch has fixed this problem, welcome to test.


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org

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



[GitHub] [shardingsphere] userkdg commented on issue #13940: select subquery Bug

Posted by GitBox <gi...@apache.org>.
userkdg commented on issue #13940:
URL: https://github.com/apache/shardingsphere/issues/13940#issuecomment-986705942


   > Hi @userkdg, I have tested this issue on version 5.0.0 and this is indeed a bug. The latest master branch has fixed this problem, welcome to test.
   
   ...the case, i git pull the lastest master branch, then shardingsphere-proxy-distribution build docker image, container, but the **bug still exists**..... 
   
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org

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



[GitHub] [shardingsphere] strongduanmu commented on issue #13940: select subquery Bug

Posted by GitBox <gi...@apache.org>.
strongduanmu commented on issue #13940:
URL: https://github.com/apache/shardingsphere/issues/13940#issuecomment-987472839


   @userkdg This is the result of my test, and no exception was found.
   
   ```
   [INFO ] 2021-12-07 09:17:23.323 [Connection-1-ThreadExecutor] ShardingSphere-SQL - Logic SQL: select count(0) as cnt from (select order_id from t_encrypt) as tmp
   [INFO ] 2021-12-07 09:17:23.324 [Connection-1-ThreadExecutor] ShardingSphere-SQL - SQLStatement: MySQLSelectStatement(limit=Optional.empty, lock=Optional.empty, window=Optional.empty)
   [INFO ] 2021-12-07 09:17:23.324 [Connection-1-ThreadExecutor] ShardingSphere-SQL - Actual SQL: ds_1 ::: select count(0) as cnt from (select order_cipher AS order_id from t_encrypt) as tmp
   ```


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org

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



[GitHub] [shardingsphere] strongduanmu commented on issue #13940: select subquery Bug

Posted by GitBox <gi...@apache.org>.
strongduanmu commented on issue #13940:
URL: https://github.com/apache/shardingsphere/issues/13940#issuecomment-986482506


   Hi @userkdg, thank you for your feedback, I will check this issue.


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org

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