|
Problem IT09483
|
Status: Closed |
ODBC DRIVER MAY CRASH WHEN PREPARING A 'INSERT INTO ... SELECT F ROM' 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!__SQLPrepare
iclit09b!SQLPrepareW
ODBC32!TraceSQLPrepareW
ODBC32!SQLPrepare |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* ODBC Application trying to insert TEXT column with 'INSERT *
* INTO ... SELECT FROM ...' syntax. *
****************************************************************
* PROBLEM DESCRIPTION: *
* ODBC driver may crash trying to insert into a TEXT column if *
* it uses the 'INSERT INTO ... SELECT FROM ...' syntax. *
****************************************************************
* RECOMMENDATION: *
* The problem has been fixed with CSDK 4.10.xC6. Please *
* upgrade CSDK to this version or higher. *
**************************************************************** |
| Local Fix: |
|
| Solution |
|
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 16.06.2015
30.12.2015
30.12.2015 |
| Problem solved at the following versions (IBM BugInfos) |
4.10.xC6
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 4.10.xC5
|
 |
| 4.10.xC6
|
|
