|
Problem IT05613
|
Status: Closed |
SQL0901 ERROR (UNEXPECTED ERROR AT SQLERRORSANDWARNINGS.CPP) FROM COLUMN-ORGANIZED TABLE WITH CASE STATEMENT |
| product: |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 |
| Problem description: |
The issue only occurs in the following conditions:
The query involves:
- a column oriented table
- a CASE expression where the search condition is evaluated on
results of a GROUP BY expression.
- errors or warnings are produced from the CASE expression.
In such a case, the query may fail with a -901 sqlcode:
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -901 sqlerrml: 48
sqlerrmc: unexpected error at SQLErrorsAndWarnings.cpp:344
sqlerrp : SQLCT001
sqlerrd : (1) 0x00000000 (2) 0x00000000 (3)
0x00000000
(4) 0x00000000 (5) 0xFFFFFEA8 (6)
0x00000000
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate:
A typical stack will look like so (including the
mergeSQLErrorsAndWarnings and evaluateCaseSearchedWhenClause()
in the stack:
[3] 0x090000001338BC94
constructAndThrow__Q3_7ibm_cde8services24AssertionFailedExceptio
nFCQ3_7ibm_cde8services11ComponentIDCPCcCUlN22RCQ3_7ibm_cde8ser
+ 0x7C
[4] 0x0900000011DBBDC4
mergeSQLErrorsAndWarnings__Q3_7ibm_cde8services20SQLErrorsAndWar
ningsFPQ3_7ibm_cde8services20SQLErrorsAndWarningsRCQ3_7ibm_cde5
+ 0x464
[5] 0x09000000151D18B8
evaluateCaseSearchedWhenClause__Q3_7ibm_cde5query13NaryEvaluator
HQ3_7ibm_cde5types7Decimal_v_v + 0x6F0
[6] 0x09000000152638C8
processInputsSynchronously__Q3_7ibm_cde5query13NaryEvaluatorFv +
0x158C
[7] 0x0900000013B32A1C
evaluate__Q3_7ibm_cde5query9EvaluatorFbT1RQ4_7ibm_cde5query9Eval
uator21EvaluatorRestartStatePQ3_7ibm_cde5query19OptPredicateTra
+ 0xCDC
[8] 0x0900000013B32FD8
evaluate__Q3_7ibm_cde5query17EvaluationRoutineFUiP15sql_static_d
ata + 0xA4
[9] 0x0900000013B3544C
runThreadTask__Q3_7ibm_cde5query9SchedulerFPvPi + 0xA8
[10] 0x0900000015492698
cdeEntryPointImpl__Q2_7ibm_cde5queryFP8sqeAgentPvT2 + 0xC0
[11] 0x0900000015C3647C
startCdeSubagent__12cdeInterfaceFP8sqeAgent + 0x1E4
[12] 0x0900000008BF3598 sqlriInvokeCde__FP8sqlrr_cb + 0x9C
[13] 0x09000000092A7F9C
sqlriSectInvoke__FP8sqlrr_cbP12sqlri_opparm + 0x74
[14] 0x090000000A379E40
sqlrr_subagent_router__FP8sqeAgentP12SQLE_DB2RA_T + 0x5670 |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* Column-organized tables - queries with errors or warnings *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* upgrade to DB2 V10.5 fixpack 5 *
**************************************************************** |
| Local Fix: |
if possibe rewrite query to avoid the case expression or to
avoid the errors/warnings |
| Solution |
Fixed in DB2 V10.5 fixpack 5 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 17.11.2014
15.12.2014
15.12.2014 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 10.5.0.5
|
 |
