query sql's where statement Garbage characters
- Dominant language
- Java
- Stars
- 17.4k
- Forks
- 5.7k
- PR merge metrics
- No merged PRs in 30d
Description
select * from cq_crew_list_info where (sys_update_dt between DATE_SUB(CURDATE(), INTERVAL 365 DAY) and DATE_SUB(CURDATE(), INTERVAL 0 DAY)) and ('10005@PfY' <= employee_id AND employee_id < '10008z]@)')
select * from cq_crew_list_info where (sys_update_dt between DATE_SUB(CURDATE(), INTERVAL 365 DAY) and DATE_SUB(CURDATE(), INTERVAL 0 DAY)) and ('10008z]@)' <= employee_id AND employee_id < '1000:Ohjy')
select * from cq_crew_list_info where (sys_update_dt between DATE_SUB(CURDATE(), INTERVAL 365 DAY) and DATE_SUB(CURDATE(), INTERVAL 0 DAY)) and ('1000:Ohjy' <= employee_id AND employee_id < '1000=VvsI')
select * from cq_crew_list_info where (sys_update_dt between DATE_SUB(CURDATE(), INTERVAL 365 DAY) and DATE_SUB(CURDATE(), INTERVAL 0 DAY)) and ('1000=VvsI' <= employee_id AND employee_id < '1000?_EM')
select * from cq_crew_list_info where (sys_update_dt between DATE_SUB(CURDATE(), INTERVAL 365 DAY) and DATE_SUB(CURDATE(), INTERVAL 0 DAY)) and ('1000?_EM' <= employee_id AND employee_id < '1000B''3&i')
select * from cq_crew_list_info where (sys_update_dt between DATE_SUB(CURDATE(), INTERVAL 365 DAY) and DATE_SUB(CURDATE(), INTERVAL 0 DAY)) and ('1000B''3&i' <= employee_id AND employee_id < '1000Do!9')
select * from cq_crew_list_info where (sys_update_dt between DATE_SUB(CURDATE(), INTERVAL 365 DAY) and DATE_SUB(CURDATE(), INTERVAL 0 DAY)) and ('1000Do!9' <= employee_id AND employee_id < '1000G7)Z ')
select * from cq_crew_list_info where (sys_update_dt between DATE_SUB(CURDATE(), INTERVAL 365 DAY) and DATE_SUB(CURDATE(), INTERVAL 0 DAY)) and ('1000G7)Z ' <= employee_id AND employee_id < '1000I~}63Y')
select * from cq_crew_list_info where (sys_update_dt between DATE_SUB(CURDATE(), INTERVAL 365 DAY) and DATE_SUB(CURDATE(), INTERVAL 0 DAY)) and ('1000I~}63Y' <= employee_id AND employee_id < '1000LFkC
Contributor guide
No contributing guide indexed for this repository
Research direction
The issue contains generated SQL but names no source file, test, or entry point. Reproduce the query generation using the shown employee_id ranges, then trace the producing code; done means the WHERE clauses no longer contain unexpected control or garbage characters.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- sql
- Domain
- databases
- Issue type
- Bug
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Needs clarification
- Newbie friendliness
- 25/100