There were some omissions of support for decfloat (decfloat64
and decfloat128) that impact certain expressions (including IN
list) which causes the SQL0901N error for column-organized
tables
with numeric data types.
This issue can be reproduced as follows:
drop table t
DB20000I The SQL command completed successfully.
create table t(c1 int, c2 decimal(10,0)) organize by column
DB20000I The SQL command completed successfully.
select * from t where c1 in(1, 2, 3, '4', '55', '6', 7, 8, 9,
10, 11, 12, 13,14)
C1 C2
----------- ------------
SQL0901N The SQL statement or command failed because of a
database system
error. (Reason "unexpected error at Parser.cpp:12026".)
SQLSTATE=58004
2014-01-16-04.45.12.187087-300 I319375E3574 LEVEL:
Error
PID : 10593 TID : 46913386703168 KTID :
23081
PROC : db2sysc
INSTANCE: ibmdb2 NODE : 000 DB :
TESTDBU
APPHDL : 0-18 APPID: *LOCAL.ibmdb2.140116094459
AUTHID : IBMDB2 HOSTNAME: db2machine
EDUID : 18 EDUNAME: db2agent (TESTDBU)
FUNCTION: DB2 UDB, CDE Trace, cdeDiagnosticsFacility,
probe:12026
DATA #1 : String, 130 bytes
AssertionFailedException: An assertion 'false' failed.
Additional info: unknown or unsupported type 4
Thrown at Parser.cpp : 12026
DATA #2 : Function name in Library, 119 bytes
void ibm_cde::query::Parser::getMinMaxCodeListVal(const
ibm_cde::query::SyntaxTree *, unsigned long &, unsigned long &)
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] 0x00002AAAAD923DF0 pdLog + 0x49C
[1] 0x00002AAAAF18DA49
_ZN7ibm_cde8services6Tracer9traceDataENS0_11ComponentIDENS0_16Co
mmonTraceLevelENS1_10TraceEventEPKcmS6_PKvmRKSbIcSt11char_trait
+ 0x35B
[2] 0x00002AAAAF10CFE9
_ZNK7ibm_cde8services13BaseException14traceExceptionENS0_11Compo
nentIDEPKc + 0x501
[3] 0x00002AAAAF103370
_ZN7ibm_cde8services24AssertionFailedException5traceENS0_11Compo
nentIDE + 0x38
[4] 0x00002AAAB01D6B7E
_ZN7ibm_cde5query6Parser20getMinMaxCodeListValEPKNS0_10SyntaxTre
eERmS5_ + 0x506
[5] 0x00002AAAB012EB3F
_ZN7ibm_cde5query6Parser15makeDerivedPredEPKNS0_10SyntaxTreeEPKN
S_4data13TableAccessorES8_b + 0x28AD
[6] 0x00002AAAB012C80C
_ZN7ibm_cde5query6Parser15makeDerivedPredEPKNS0_10SyntaxTreeEPKN
S_4data13TableAccessorES8_b + 0x57A
[7] 0x00002AAAB0131535
_ZN7ibm_cde5query6Parser16addSynopsisQueryEPNS0_10SyntaxTreeEb +
0xA9F
[8] 0x00002AAAB0118359
_ZN7ibm_cde5query6Parser13parserWrapperERKSbIcSt11char_traitsIcE
NS_8services13CharAllocatorEERKNS_4data8DataBaseERKNS0_14QueryR
+ 0x19D3
[9] 0x00002AAAB002F4D2
_ZN12cdeInterface14initializeDataEP8sqlrr_cbP17sqlriCdeStatement
+ 0x560A
[10] 0x00002AAAB0029953
_ZN12cdeInterface13openTableScanEP8sqlrr_cbP17sqlriCdeStatement
+ 0x177
[11] 0x00002AAABD42D44D
_Z12sqlriCdeOpenP8sqlrr_cbP17sqlriCdeStatement + 0x1029
[12] 0x00002AAABD430321 _Z13sqlriCdeQueryP8sqlrr_cb + 0x9B1
[13] 0x00002AAABD3D448B
_Z15sqlriExecThreadP8sqlrr_cbP12sqlri_opparm + 0xC3B
[14] 0x00002AAABD595F08
_Z15sqlriSectInvokeP8sqlrr_cbP12sqlri_opparm + 0x2224
[15] 0x00002AAABC7DD771
_Z27sqlrr_process_fetch_requestP14db2UCinterface + 0x24A1
[16] 0x00002AAABC7C5D18
_Z10sqlrr_openP14db2UCinterfaceP15db2UCCursorInfo + 0x2D94
[17] 0x00002AAAB7B066E5
_Z16sqljs_ddm_opnqryP14db2UCinterfaceP13sqljDDMObject + 0x4A5
[18] 0x00002AAAB7AE1ECD
_Z21sqljsParseRdbAccessedP13sqljsDrdaAsCbP13sqljDDMObjectP14db2U
Cinterface + 0x475
[19] 0x00002AAAB7AE4918
_Z10sqljsParseP13sqljsDrdaAsCbP14db2UCinterfaceP8sqeAgentb +
0x436
[20] 0x00002AAAB7ACE847 libdb2e.so.1 + 0xCDEE847 |
