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/06/28 09:45:12 UTC

[GitHub] [shardingsphere] wenjunlichao1231 opened a new issue #11043: select * from t_user where(id in (select id from t_machine)) not support

wenjunlichao1231 opened a new issue #11043:
URL: https://github.com/apache/shardingsphere/issues/11043


   select * from t_user where(id in (select id from t_machine)) 
   
   When select * encounters a subquery, the query field will include the field of the table in the subquery, resulting in the field of the query does not exist, because the word is read in the table of the subquery.
   


-- 
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] wenjunlichao1231 commented on issue #11043: select * from t_user where(id in (select id from t_machine)) not support

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


   > Which version do you use?
   > And provider t_user & t_machine configurations
   
   5.0.0-alpha


-- 
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] avalon5666 commented on issue #11043: select * from t_user where(id in (select id from t_machine)) not support

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


   Has this problem been solved?


-- 
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] wenjunlichao1231 commented on issue #11043: select * from t_user where(id in (select id from t_machine)) not support

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


   > Pls provider shardingsphere table rule configuration. java api or yaml file or spring namespace and so on.
   
   [rule.txt](https://github.com/apache/shardingsphere/files/6731123/rule.txt)
   


-- 
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] wenjunlichao1231 commented on issue #11043: select * from t_user where(id in (select id from t_machine)) not support

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


   > Has this problem been solved?
   
   Because it is not convenient for us to upgrade to the latest version, The way I solve it now is as shown in the screenshot, I am not sure if there will be other problems
   ![6](https://user-images.githubusercontent.com/8392641/123783896-740eeb80-d909-11eb-8f35-016cde849b9c.png)
   


-- 
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] wenjunlichao1231 commented on issue #11043: select * from t_user where(id in (select id from t_machine)) not support

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


   > Pls provider shardingsphere table rule configuration. java api or yaml file or spring namespace and so on.
   
   Hello, have you reproduced it now? This statement has nothing to do with the rule. Even if there is no rule, an error will occur, because it will be wrong to get the query field. The obtained query field contains the field of the table in the subquery


-- 
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] wenjunlichao1231 commented on issue #11043: select * from t_user where(id in (select id from t_machine)) not support

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


   > shardingsphere table rule configuration
   
   You can try a strategy that is not worthy of sensitive, and it won’t work without a strategy.


-- 
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] avalon5666 commented on issue #11043: select * from t_user where(id in (select id from t_machine)) not support

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


   Pls try 5.0.0-beta


-- 
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] avalon5666 closed issue #11043: select * from t_user where(id in (select id from t_machine)) not support

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


   


-- 
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] wenjunlichao1231 commented on issue #11043: select * from t_user where(id in (select id from t_machine)) not support

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


   > Can you set sql.show=true, and provider the configuration and full exception log?
   
   Thank you very much for your reply, the actual sql query statement is not rewritten, but when the result set is obtained, because the select * field to be queried includes the field in the subquery table, the array is out of bounds.The getColumnCount function includes the sum of the fields of the query table and the subquery table, resulting in a query error
   ![16151624852541_ pic_hd](https://user-images.githubusercontent.com/8392641/123722559-2b304600-d8bb-11eb-8992-fb9a80da8d09.jpg)
   
   


-- 
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] wenjunlichao1231 commented on issue #11043: select * from t_user where(id in (select id from t_machine)) not support

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


   > Recommand to upgrade.
   
   Your answer is not what I want, I need some guidance, thank you


-- 
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] avalon5666 commented on issue #11043: select * from t_user where(id in (select id from t_machine)) not support

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






-- 
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] avalon5666 commented on issue #11043: select * from t_user where(id in (select id from t_machine)) not support

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


   This file does not contain the above exception stack.


-- 
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] avalon5666 commented on issue #11043: select * from t_user where(id in (select id from t_machine)) not support

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


   Pls  the configuration and full exception log, I can't find out which sql execute by ShardingSphere-Command-1 thread.


-- 
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] wenjunlichao1231 commented on issue #11043: select * from t_user where(id in (select id from t_machine)) not support

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


   > Pls try 5.0.0-beta, I test work fine in 5.0.0-beta
   
   I found another problem, I submitted a new issuer, can you please help me to check it out, [https://github.com/apache/shardingsphere/issues/11057](url)


-- 
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] avalon5666 commented on issue #11043: select * from t_user where(id in (select id from t_machine)) not support

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


   Recommand to upgrade.


-- 
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] avalon5666 commented on issue #11043: select * from t_user where(id in (select id from t_machine)) not support

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


   shardingsphere table rule configuration


-- 
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] avalon5666 edited a comment on issue #11043: select * from t_user where(id in (select id from t_machine)) not support

Posted by GitBox <gi...@apache.org>.
avalon5666 edited a comment on issue #11043:
URL: https://github.com/apache/shardingsphere/issues/11043#issuecomment-870392619


   Pls try 5.0.0-beta, I test work fine in 5.0.0-beta


-- 
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] wenjunlichao1231 commented on issue #11043: select * from t_user where(id in (select id from t_machine)) not support

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


   > Which version do you use?
   > And provider t_user & t_machine configurations
   
   Please help me see 
   [sql.zip](https://github.com/apache/shardingsphere/files/6730923/sql.zip)
   


-- 
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] avalon5666 edited a comment on issue #11043: select * from t_user where(id in (select id from t_machine)) not support

Posted by GitBox <gi...@apache.org>.
avalon5666 edited a comment on issue #11043:
URL: https://github.com/apache/shardingsphere/issues/11043#issuecomment-870214275






-- 
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] avalon5666 commented on issue #11043: select * from t_user where(id in (select id from t_machine)) not support

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


   Pls provider shardingsphere table rule configuration. java api or yaml file or spring namespace and so on.


-- 
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] wenjunlichao1231 commented on issue #11043: select * from t_user where(id in (select id from t_machine)) not support

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






-- 
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] wenjunlichao1231 commented on issue #11043: select * from t_user where(id in (select id from t_machine)) not support

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


   > Pls the configuration and full exception log, I can't find out which sql execute by ShardingSphere-Command-1 thread.
   
   This is the error log thanks for your help [error.txt](https://github.com/apache/shardingsphere/files/6730053/error.txt)
   


-- 
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] avalon5666 edited a comment on issue #11043: select * from t_user where(id in (select id from t_machine)) not support

Posted by GitBox <gi...@apache.org>.
avalon5666 edited a comment on issue #11043:
URL: https://github.com/apache/shardingsphere/issues/11043#issuecomment-870214275


   Which version do you use?
   And provider t_user & t_machine configurations


-- 
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] wenjunlichao1231 commented on issue #11043: select * from t_user where(id in (select id from t_machine)) not support

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


   > This file does not contain the above exception stack.
   
   Please help me take a look again, thank you very much ,
   ![1624938462244](https://user-images.githubusercontent.com/8392641/123734426-e95dca80-d8cf-11eb-8d55-2fbb3572e151.jpg)
   ![1624938484953](https://user-images.githubusercontent.com/8392641/123734429-ebc02480-d8cf-11eb-80f3-d5a3118d3a17.jpg)
   
   [error1.txt](https://github.com/apache/shardingsphere/files/6730506/error1.txt)
   


-- 
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] avalon5666 closed issue #11043: select * from t_user where(id in (select id from t_machine)) not support

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


   


-- 
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] avalon5666 commented on issue #11043: select * from t_user where(id in (select id from t_machine)) not support

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


   Can you set sql.show=true, and provider the configuration and full exception log?


-- 
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] avalon5666 commented on issue #11043: select * from t_user where(id in (select id from t_machine)) not support

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


   Which version do you use?


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