You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by "jiusi-yyq (via GitHub)" <gi...@apache.org> on 2024/12/03 08:41:42 UTC
[I] sometimes，the query conditions of the sql missing，cause the Result is incorrect [shardingsphere]
jiusi-yyq opened a new issue, #33895:
URL: https://github.com/apache/shardingsphere/issues/33895
shardingSphere-jdbc：5.3.2
mysql-connector：8.0.33
Actual SQL: unique_ds ::: SELECT id,expired,channel_id,channel_apply_id,qts_apply_id,part_job_id,mobile AS mobile,name,apply_remark,school_name,sex,diploma,birthday,wechat,qq,mail,introduction,status,callback_status,reason,account_id,user_id,major,part_job_experience,tags,town,job_intention,apply_content,pro_skill,create_time,update_time FROM open_channel_job_apply WHERE (channel_id = ? AND expired = ? AND channel_apply_id = ?) ::: [241105144043504, false, AP7285393762536287916]
Logic SQL: SELECT id,expired,channel_id,channel_apply_id,qts_apply_id,part_job_id,mobile,name,apply_remark,school_name,sex,diploma,birthday,wechat,qq,mail,introduction,status,callback_status,reason,account_id,user_id,major,part_job_experience,tags,town,job_intention,apply_content,pro_skill,create_time,update_time FROM open_channel_job_apply WHERE (channel_id = ? AND expired = ? AND channel_apply_id = ?)
the error：
the reason is the channel_apply_id condition missing during sql run。
the problem don't certainly occur，which is occasional. especially，the problem easily occur during large Request quantity.
--
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] shardingSphere-jdbc，the query conditions of the sql missing，cause the Result is incorrect [shardingsphere]
Posted by "aillamsun (via GitHub)" <gi...@apache.org>.
aillamsun commented on issue #33895:
URL: https://github.com/apache/shardingsphere/issues/33895#issuecomment-2513916278
there are significant differences between versions, and there are many compatibility issues
--
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] shardingSphere-jdbc，the query conditions of the sql missing，cause the Result is incorrect [shardingsphere]
Posted by "terrymanu (via GitHub)" <gi...@apache.org>.
terrymanu commented on issue #33895:
URL: https://github.com/apache/shardingsphere/issues/33895#issuecomment-2514064663
The issue involves other third-party dependencies, but our focus is solely on ShardingSphere itself. Since ShardingSphere implements the JDBC interface, standard applications should be functional. We wish to allocate more effort towards enhancing the current version, and therefore will no longer handle such issues. Please read the documentation or provide more effective information when submitting an 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
Re: [I] shardingSphere-jdbc，the query conditions of the sql missing，cause the Result is incorrect [shardingsphere]
Posted by "terrymanu (via GitHub)" <gi...@apache.org>.
terrymanu closed issue #33895: shardingSphere-jdbc，the query conditions of the sql missing，cause the Result is incorrect
URL: https://github.com/apache/shardingsphere/issues/33895
--
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