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: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
