DB2 might return SQL0901N under the following conditions:
1) Query contains atleast one rollup or cube
2) The query contains atleast one UNION ALL clause
Error Message :
ASSERTION - 'currentNode.getChild(1)->tokType()==OP_AS'
Stack :
2015-01-28-16.31.17.716404-300 I13735930E3701 LEVEL:
Error
PID : 9664 TID : 140070384297728 PROC :
db2sysc
INSTANCE: regress1 NODE : 000 DB :
BLUDB
APPHDL : 0-1425 APPID:
9.26.98.0.39235.150128214050
AUTHID : REGRESS1 HOSTNAME: vmsvtlnx64x09
EDUID : 4417 EDUNAME: db2agent (BLUDB)
FUNCTION: DB2 UDB, CDE Trace, cdeDiagnosticsFacility, probe:9200
DATA #1 : String, 189 bytes
AssertionFailedException: An assertion
'currentNode.getChild(1)->tokType()==OP_AS' failed. Additional
info: bad CAST clause {CAST:T0 AS:T0 DATE:T10 NULLABLE:T0}
Thrown at Parser.cpp : 9200
DATA #2 : Function name in Library, 122 bytes
static void
ibm_cde::query::Parser::simplifyCastNode(ibm_cde::query::SyntaxT
ree &, const ibm_cde::query::QueryResources &)
DATA #3 : File name, 10 bytes
Parser.cpp
CALLSTCK: (Static functions may not be resolved correctly, as
they are resolved to the nearest symbol)
[0] 0x00007F6A5A764D00
_ZN7ibm_cde8services6Tracer9traceDataENS0_11ComponentIDENS0_16Co
mmonTraceLevelENS1_10TraceEventEPKcmS6_PKvmRKSbIcSt11char_trait
+ 0x710
[1] 0x00007F6A5E49CA5B
_ZNK7ibm_cde8services13BaseException14traceExceptionENS0_11Compo
nentIDEPKc + 0x22B
[2] 0x00007F6A5E49ACE7
_ZN7ibm_cde8services24AssertionFailedException17constructAndThro
wENS0_11ComponentIDEPKcmS4_S4_RKNS0_16CdeOStringStreamE + 0x97
[3] 0x00007F6A5ABB7819
_ZN7ibm_cde5query6Parser16simplifyCastNodeERNS0_10SyntaxTreeERKN
S0_14QueryResourcesE + 0x829
[4] 0x00007F6A5ABB6C35
_ZN7ibm_cde5query6Parser16addCastOperatorsEPNS0_10SyntaxTreeERKN
S0_14QueryResourcesERKNS0_18QueryInfoContainerE + 0x2345
[5] 0x00007F6A5ABA986D
_ZN7ibm_cde5query6Parser7prepareEPNS0_10SyntaxTreeEPNS0_17QueryA
rgumentListEbi + 0x3AD
[6] 0x00007F6A5AB9C8E6
_ZN7ibm_cde5query6Parser13parserWrapperERKSbIcSt11char_traitsIcE
NS_8services9AllocatorIcEEERKNS_4data8DataBaseERKNS0_14QueryRes
+ 0x10B6
[7] 0x00007F6A5E612FF5
_ZN7ibm_cde5query6Parser18prepareNestedQueryEPNS0_10SyntaxTreeES
3_RKNS_4data8DataBaseERKNS0_14QueryResourcesEP13SQLO_MEM_POOL +
0x2A5
[8] 0x00007F6A5AB9C5FD
_ZN7ibm_cde5query6Parser13parserWrapperERKSbIcSt11char_traitsIcE
NS_8services9AllocatorIcEEERKNS_4data8DataBaseERKNS0_14QueryRes
+ 0xDCD
[9] 0x00007F6A5E608C87
_ZN12cdeInterface14initializeDataEP8sqlrr_cbP17sqlriCdeStatement
+ 0x1267
[10] 0x00007F6A5E5F2B23
_ZN12cdeInterface13openTableScanEP8sqlrr_cbP17sqlriCdeStatement
+ 0x63
[11] 0x00007F6A5D6E7313
_Z12sqlriCdeOpenP8sqlrr_cbP17sqlriCdeStatement + 0xF33
[12] 0x00007F6A6036256C _Z13sqlriCdeQueryP8sqlrr_cb + 0x3DC
[13] 0x00007F6A60362AF1
_Z15sqlriSectInvokeP8sqlrr_cbP12sqlri_opparm + 0x1B1
[14] 0x00007F6A5D53B87F
_Z27sqlrr_process_fetch_requestP14db2UCinterface + 0x1BF
[15] 0x00007F6A5D537639
_Z10sqlrr_openP14db2UCinterfaceP15db2UCCursorInfo + 0xA89
[16] 0x00007F6A5C6C7281
_Z16sqljs_ddm_opnqryP14db2UCinterfaceP13sqljDDMObject + 0x3F1
[17] 0x00007F6A6028E9F6
_Z21sqljsParseRdbAccessedP13sqljsDrdaAsCbP13sqljDDMObjectP14db2U
Cinterface + 0x3C6
[18] 0x00007F6A5C6B2FAC
_Z10sqljsParseP13sqljsDrdaAsCbP14db2UCinterfaceP8sqeAgentb +
0x36C
[19] 0x00007F6A5C6AD47F
/home/regress1/sqllib/lib64/libdb2e.so.1 + 0x33D447F
[20] 0x00007F6A5C6AB96C
/home/regress1/sqllib/lib64/libdb2e.so.1 + 0x33D296C
[21] 0x00007F6A5C6A89C9
/home/regress1/sqllib/lib64/libdb2e.so.1 + 0x33CF9C9
[22] 0x00007F6A5C6A85BB
_Z17sqljsDrdaAsDriverP18SQLCC_INITSTRUCT_T + 0xEB
[23] 0x00007F6A5C3ACBAF _ZN8sqeAgent6RunEDUEv + 0xACF
[24] 0x00007F6A5DB96B87 _ZN9sqzEDUObj9EDUDriverEv + 0xF7
[25] 0x00007F6A5D36E5C3 sqloEDUEntry + 0x303
[26] 0x00007F6A646437B6 /lib64/libpthread.so.0 + 0x77B6
[27] 0x00007F6A58132D6D clone + 0x6D
. . . . . . . . . . . .
--- Line 237947
--- SQLCODE -901 message
2015-01-28-16.31.18.549885-300 I13745048E900 LEVEL:
Severe
PID : 9664 TID : 140070384297728 PROC :
db2sysc
INSTANCE: regress1 NODE : 000 DB :
BLUDB
APPHDL : 0-1425 APPID:
9.26.98.0.39235.150128214050
AUTHID : REGRESS1 HOSTNAME: vmsvtlnx64x09
EDUID : 4417 EDUNAME: db2agent (BLUDB)
FUNCTION: DB2 UDB, relation data serv, sqlrr_dump_ffdc,
probe:250
DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -901 sqlerrml: 35
sqlerrmc: unexpected error at Parser.cpp:9200
sqlerrp : SQLCT001
sqlerrd : (1) 0x00000000 (2) 0x00000000 (3)
0x00000000
(4) 0x00000000 (5) 0xFFFFDC10 (6)
0x00000000
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate:
2015-01-28-16.31.18.550165-300 I13745949E663 LEVEL:
Severe
PID : 9664 TID : 140070384297728 PROC :
db2sysc
INSTANCE: regress1 NODE : 000 DB :
BLUDB
APPHDL : 0-1425 APPID:
9.26.98.0.39235.150128214050
AUTHID : REGRESS1 HOSTNAME: vmsvtlnx64x09
EDUID : 4417 EDUNAME: db2agent (BLUDB)
FUNCTION: DB2 UDB, relation data serv, sqlrr_dump_ffdc,
probe:275
MESSAGE : MASTER TIME INFO
DATA #1 : Hexdump, 32 bytes
0x00007F64D11A2CC0 : DC51 C954 0000 0000 A601 0000 3171 0600
.Q.T........1q..
0x00007F64D11A2CD0 : 3171 0600 DC51 C954 0000 0000 0000 0000
1q...Q.T........ |
