You are viewing a plain text version of this content. The canonical link for it is here.

Posted to notifications@shardingsphere.apache.org by "terrymanu (via GitHub)" <gi...@apache.org> on 2026/10/30 15:13:54 UTC

Re: [I] select exists return multi results [shardingsphere]

terrymanu commented on issue #21583:
URL: https://github.com/apache/shardingsphere/issues/21583#issuecomment-6526172500

   Hi @CatInRl, the original query now works on master with SQL federation enabled. Please configure `sqlFederation.providerType: CALCITE`; federation is disabled by default.
   
   We verified the original SQL using ShardingSphere-JDBC, MySQL 8.0.40, and four physical shards. With `allQueryUseSQLFederation: false`, the query automatically used the federation engine and returned exactly one row with the correct boolean value when no shards, one shard, or multiple shards matched. The column alias `c` was also preserved.
   
   Please use a build from master with SQL federation enabled. Closing this issue as resolved on master.


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