BUG: Use of Certain Scalar Functions May Cause SQLFetch Errors (112689)

SYMPTOMS

Under certain circumstances, memory allocation errors may be returned from drivers that ship with the ODBC Database Driver Pack. These errors occur when fetching a results set from a certain kind of SQL Statement that uses ODBC scalar functions.

The following SQL query uses scalar functions and causes errors, not on SQLExecDirect or SQLExecute, but on SQLFetch after 1087 rows have been retrieved.

   select *
   from "test"
   where
   {fn CONVERT('19'+
        {fn LEFT("test"."col_DATE_Y" ,2) }        +   '-'      +
        {fn LEFT("test"."col_DATE_MD",2)}       +   '-'  +
        {fn RIGHT({ fn RTRIM("test"."col_DATE_MD") }  , 2  )  }
   ,SQL_DATE)}
   >= '1992-01-01'
				

Errors received on SQLFetch after 1087 rows have been fetched: