|
Problem IT16100
|
Status: Closed |
ODBC DRIVER MAY CRASH WHEN EXECUTING A 'INSERT INTO ... SELECT FROM' SQL STATEMENT IF THERE ARE ANY 'TEXT' COLUMNS IN THE INSERT
|
| product: |
IBM CSDK / 5724C2381 / 410 - CSDK 4.10 |
| Problem description: |
The ODBC driver may crash trying to insert into a TEXT column if
it uses the 'INSERT INTO ... SELECT FROM ...' syntax.
The IDS server may fail to cast the TEXT data type and will
return a -617 error.
If that happens, rather than returning the error to the
application, the driver tries to re-prepare the SQL using
parameters which end in a memory violation within the driver.
The stack looks like:
MSVCR90!strcat
iclit09b!parseParam
iclit09b!TextBlobLiteralOperation
iclit09b!TextBlobLiteralProcessing
iclit09b!__SQLExecDirect
iclit09b!SQLExecDirectW
ODBC32!SQLExecute
ODBC32!SQLExecDirect |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* ALL *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to 4.10.xC8 *
**************************************************************** |
| Local Fix: |
|
| Solution |
|
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 12.07.2016
09.12.2016
09.12.2016 |
| Problem solved at the following versions (IBM BugInfos) |
4.10.xC8
|
| Problem solved according to the fixlist(s) of the following version(s) |
