ODBC driver does not return any results when the WHERE clause contains CURDATE()

CURDATE() yields a "null" in SOAP encoded query when used in a WHERE clause.

1.0.7.3 Driver: Returns 0 records because the encoded query is wrong.
1.0.5 Driver: Yields a NullPointerException.

Within iSQL:

1. Use CURDATE() on its own to see expected behavior.
ISQL> SELECT DATEADD('dd',-10,CURDATE());
DATEADD(dd, -10, CURDATE())

2. Use CURDATE() within a WHERE clause to see unexpected behavior.
ISQL> SELECT sys_id, number FROM incident WHERE (sys_created_on >= DATEADD('dd',-10,CURDATE())) AND sys_id = '8829085b0f4eb1004f2ff45be1050e5f';
sys_id number

Rows selected = 0

Instead of using CURDATE() inside WHERE clauses, use the DATEADD function.

For example, for a query such as following:

SELECT number, sys_created_on FROM incident WHERE sys_created_on <= CURDATE()+10;

Use:

SELECT number, sys_created_on FROM incident WHERE sys_created_on <= DATEAD 
D('dd',+10,CURDATE());