date_sub() function for delete sql through spider will wrong

[Yihuey Chyi]

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(now(),interval 730 day);

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.

[Kentoku SHIBA (kentokushiba)]

This bug is fixed at Spider 3.0.