5.1.1 not support mysql subquery ?

[williamXinCC]

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 and building_id IN #{item} and tenant_id = #{tenantId} )and type !=4 and status = 1 and exclusive_state =1 )

[TeslaCN]

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

[williamXinCC]

[williamXinCC]

Is also never use my custom StandardShardingAlgorithm

[williamXinCC]

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

[linghengqian]

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 sub-problem is resolved in https://github.com/apache/shardingsphere/issues/18691 .

[TeslaCN]

Could you paste the SQL and codes in text format? Screenshots doesn't help us to reproduce this issue.

[linghengqian]

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. 👨‍🔧

[RaigorJiang]

Hi @williamXinCC @linghengqian Has this issue been resolved after the calcite upgrade?

[linghengqian]

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

[github-actions[bot]]

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

[RaigorJiang]

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

OK, thank you @linghengqian , so I just close this issue now.