You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by "13302516724 (via GitHub)" <gi...@apache.org> on 2024/06/15 09:38:32 UTC
[I] SKIP_SQL_REWRITE=true, invalid [shardingsphere]
13302516724 opened a new issue, #31709:
URL: https://github.com/apache/shardingsphere/issues/31709
The number of shards in the table is 4, using USER-ID as the shard key
Logic SQL:
/* SHARDINGSPHERE_HINT: DISABLE_AUDIT_NAMES=sharding_key_required_auditor, SKIP_SQL_REWRITE=true */
SELECT * FROM T_ACCOUNT WHERE USERNAME=#{username} AND APP_ID = #{appId}
Actual SQL：
SELECT * FROM T_ACCOUNT WHERE USERNAME=#{username} AND APP_ID = #{appId}
UNION ALL
SELECT * FROM T_ACCOUNT WHERE USERNAME=#{username} AND APP_ID = #{appId}
UNION ALL
SELECT * FROM T_ACCOUNT WHERE USERNAME=#{username} AND APP_ID = #{appId}
UNION ALL
SELECT * FROM T_ACCOUNT WHERE USERNAME=#{username} AND APP_ID = #{appId}
**How to effectively skip rewriting**
**expect**
SELECT * FROM T_ACCOUNT WHERE USERNAME=#{username} AND APP_ID = #{appId}
--
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
Re: [I] SKIP_SQL_REWRITE=true, invalid [shardingsphere]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on issue #31709:
URL: https://github.com/apache/shardingsphere/issues/31709#issuecomment-2229294416
There hasn't been any activity on this issue recently, and in order to prioritize active issues, it will be marked as stale.
--
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
Re: [I] SKIP_SQL_REWRITE=true, invalid [shardingsphere]
Posted by "terrymanu (via GitHub)" <gi...@apache.org>.
terrymanu commented on issue #31709:
URL: https://github.com/apache/shardingsphere/issues/31709#issuecomment-2211846758
I apologize, but your description is too brief for me to understand your intent. Could you please clarify your issue and purpose more clearly?
--
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
Re: [I] SKIP_SQL_REWRITE=true, invalid [shardingsphere]
Posted by "terrymanu (via GitHub)" <gi...@apache.org>.
terrymanu closed issue #31709: SKIP_SQL_REWRITE=true, invalid
URL: https://github.com/apache/shardingsphere/issues/31709
--
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