Knowledge Base |

# BUG: Use of Certain Scalar Functions May Cause SQLFetch Errors

Article ID: 112689

Article Last Modified on 10/15/2002

APPLIES TO

- Microsoft Open Database Connectivity 1.0

This article was previously published under Q112689
BUG# ODBCDBASE: 1857 (1.01.1928)

## 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:
[Microsoft][ODBC Single-Tier Driver]Error in predicate:
[Microsoft][ODBC Single-Tier Driver]Expression evaluation error
[Microsoft][ODBC Single-Tier Driver]Memory allocation error.

## STATUS

Microsoft has confirmed this to be a problem in the ODBC Desktop Database Drivers 1.0 (drivers version 1.01.1928) This problem has been fixed in drivers version 1.02.1403, which is available from Microsoft Product Services. For more information, please contact your primary support provider.

Additional query words: 1.01.1928 DDD Visual C++

Keywords: kbbug KB112689