alibaba / alibaba/DataX

query sql's where statement Garbage characters

Open
#2,294 0 comments 0 reactions 0 assignees View on GitHub
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

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.