date_sub() function for delete sql through spider will wrong
Bug #1072831 reported by
Yihuey Chyi
This bug affects 1 person
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Spider for MySQL |
Fix Committed
|
Medium
|
Kentoku SHIBA |
Bug Description
The example like this
If I want to delete the data before two years
I wil run the sql in my spider node
delete from JOB_APPLYVIEW_COUNT where custno = 31296859000 and update_date < date_sub(
spider will transfer the sql to the data node
delete from JOB_APPLYVIEW_COUNT where custno = 31296859000 and
update_date < adddate(now(), 730);
It will delete the data after two years ,and the result is wrong.
PLs help us , It's very important. Because we will use it on my production.
Thank you very much.
To post a comment you must log in.
This bug is fixed at Spider 3.0.