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 2022/10/10 06:38:01 UTC

[GitHub] [shardingsphere] williamXinCC opened a new issue, #18973: 5.1.1 not support mysql subquery ?

williamXinCC opened a new issue, #18973:
URL: https://github.com/apache/shardingsphere/issues/18973

    SELECT person_id,
           open_id
           FROM sf_person
           WHERE tenant_id = #{tenantId} and person_id IN
           (SELECT person_id
           FROM sf_person_unit
           WHERE tenant_id = #{tenantId} and
           unit_id IN
           (SELECT unit_id
           FROM sf_unit
           <where>
               <if test="buildingList != null and buildingList.size() > 0">
                   and building_id IN
                   <foreach collection="buildingList" item="item" index="index" open="(" close=")" separator=",">
                       #{item}
                   </foreach>
               </if>
               and tenant_id = #{tenantId}
           </where>
           )and type !=4 and status = 1 and exclusive_state =1
           )


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

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

[GitHub] [shardingsphere] williamXinCC commented on issue #18973: 5.1.1 not support mysql subquery ?

Posted by GitBox <gi...@apache.org>.

williamXinCC commented on issue #18973:
URL: https://github.com/apache/shardingsphere/issues/18973#issuecomment-1179488318

   The other question, after 4.1.1 upgrade to 5.1.2,the project startup very very slow, so i change to 5.1.1 return to normal


-- 
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] TeslaCN commented on issue #18973: 5.1.1 not support mysql subquery ?

Posted by GitBox <gi...@apache.org>.

TeslaCN commented on issue #18973:
URL: https://github.com/apache/shardingsphere/issues/18973#issuecomment-1179647961

   Could you paste the SQL and codes in text format? Screenshots doesn't help us to reproduce 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] williamXinCC commented on issue #18973: 5.1.1 not support mysql subquery ?

Posted by GitBox <gi...@apache.org>.

williamXinCC commented on issue #18973:
URL: https://github.com/apache/shardingsphere/issues/18973#issuecomment-1179487541

   ![image](https://user-images.githubusercontent.com/34149036/178094011-68b02c51-f463-4784-a815-28a2cfede7c2.png)
   ![image](https://user-images.githubusercontent.com/34149036/178094031-a78893e3-3aa8-408b-82f1-fcff37e961bf.png)
   ![image](https://user-images.githubusercontent.com/34149036/178094077-ad794ba1-df29-4070-be8b-1dda6a46b5e7.png)
   ![image](https://user-images.githubusercontent.com/34149036/178094088-bf6b4a8d-bbcb-4839-a7e0-1e2307c30e5b.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] github-actions[bot] closed issue #18973: 5.1.1 not support mysql subquery ?

Posted by GitBox <gi...@apache.org>.

github-actions[bot] closed issue #18973: 5.1.1 not support mysql subquery ?
URL: https://github.com/apache/shardingsphere/issues/18973


-- 
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] linghengqian commented on issue #18973: 5.1.1 not support mysql subquery ?

Posted by GitBox <gi...@apache.org>.

linghengqian commented on issue #18973:
URL: https://github.com/apache/shardingsphere/issues/18973#issuecomment-1208563028

   Hi, a critical calcite issue has been resolved, refer to https://issues.apache.org/jira/plugins/servlet/mobile#issue/CALCITE-35.  I think we have good reason to upgrade to calcite 1.31.0 now.  👨‍🔧


-- 
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] github-actions[bot] commented on issue #18973: 5.1.1 not support mysql subquery ?

Posted by GitBox <gi...@apache.org>.

github-actions[bot] commented on issue #18973:
URL: https://github.com/apache/shardingsphere/issues/18973#issuecomment-1272349422

   Hello , this issue has not received a reply for several days.
   This issue is supposed to be closed.


-- 
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] williamXinCC commented on issue #18973: 5.1.1 not support mysql subquery ?

Posted by GitBox <gi...@apache.org>.

williamXinCC commented on issue #18973:
URL: https://github.com/apache/shardingsphere/issues/18973#issuecomment-1179487755

   Is also never use  my custom StandardShardingAlgorithm


-- 
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] RaigorJiang closed issue #18973: 5.1.1 not support mysql subquery ?

Posted by GitBox <gi...@apache.org>.

RaigorJiang closed issue #18973: 5.1.1 not support mysql subquery ?
URL: https://github.com/apache/shardingsphere/issues/18973


-- 
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] TeslaCN commented on issue #18973: 5.1.1 not support mysql subquery ?

Posted by GitBox <gi...@apache.org>.

TeslaCN commented on issue #18973:
URL: https://github.com/apache/shardingsphere/issues/18973#issuecomment-1179482227

   Hi @williamXinCC 
   Please provide us your configurations, DDL, actual SQL and errors.


-- 
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] linghengqian commented on issue #18973: 5.1.1 not support mysql subquery ?

Posted by GitBox <gi...@apache.org>.

linghengqian commented on issue #18973:
URL: https://github.com/apache/shardingsphere/issues/18973#issuecomment-1179491314

   > The other question, after 4.1.1 upgrade to 5.1.2,the project startup very very slow, so i change to 5.1.1 return to normal
   
   Resolved in https://github.com/apache/shardingsphere/issues/18691 .


-- 
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] RaigorJiang commented on issue #18973: 5.1.1 not support mysql subquery ?

Posted by GitBox <gi...@apache.org>.

RaigorJiang commented on issue #18973:
URL: https://github.com/apache/shardingsphere/issues/18973#issuecomment-1278504525

   > * My local test looks normal, and the issue does not give a reproducible example to test.  For more issues with Calcite, I think we can move to [When I execute integration test using `ADVANCED` type, I am getting exception as below. #20982](https://github.com/apache/shardingsphere/issues/20982) .
   
   OK, thank you @linghengqian , so I just close this issue now.


-- 
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] RaigorJiang commented on issue #18973: 5.1.1 not support mysql subquery ?

Posted by GitBox <gi...@apache.org>.

RaigorJiang commented on issue #18973:
URL: https://github.com/apache/shardingsphere/issues/18973#issuecomment-1246942863

   Hi @williamXinCC @linghengqian 
   Has this issue been resolved after the calcite 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] linghengqian commented on issue #18973: 5.1.1 not support mysql subquery ?

Posted by GitBox <gi...@apache.org>.

linghengqian commented on issue #18973:
URL: https://github.com/apache/shardingsphere/issues/18973#issuecomment-1248217698

   - My local test looks normal, and the issue does not give a reproducible example to test.  For more issues with Calcite, I think we can move to https://github.com/apache/shardingsphere/issues/20982 .


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