DB2 - Problem description
Problem IT34871 | Status: Closed |
USING WRONG DELIMITER MIGHT CAUSE THE INSTANCE CRASH | |
product: | |
DB2 FOR LUW / DB2FORLUW / B50 - DB2 | |
Problem description: | |
With SQL_COMPAT='NPS', following query causes the eventual crash. WHERE DATE = "22OCT2020" It is intended to be a string literal, but it's a wrong delimiter. Without setting SQL_COMPAT, the statement correctly fails with: SQL0206N "22OCT2020" is not valid in the context where it is used. SQLSTATE=42703 The trap would be: _ZN28sqlnqCandidatePartKeyBuilder27initCandidatePartKeyBuilderEP 9sqlnq_ftbP9sqlnq_qtbS3_P3loc + 0x0fdc (/head/home/db2inst1/sqllib/lib64/libdb2e.so.1) 0x00002AD07B57704C : 81B9040200008300 -----FUNC-ADDR---- ------FUNCTION + OFFSET------ 0x00002AD084CDD126 _Z25ossDumpStackTraceInternalmR11OSSTrapFileiP7siginfoPvmm + 0x0356 (/head/home/db2inst1/sqllib/lib64/libdb2osse.so.1) 0x00002AD084CDCD6B ossDumpStackTraceV98 + 0x002b (/head/home/db2inst1/sqllib/lib64/libdb2osse.so.1) 0x00002AD084CD8F57 _ZN11OSSTrapFile6dumpExEmiP7siginfoPvm + 0x00d7 (/head/home/db2inst1/sqllib/lib64/libdb2osse.so.1) 0x00002AD07BF59177 sqlo_trce + 0x03c7 (/head/home/db2inst1/sqllib/lib64/libdb2e.so.1) 0x00002AD07C0F25A0 sqloEDUCodeTrapHandler + 0x02b0 (/head/home/db2inst1/sqllib/lib64/libdb2e.so.1) 0x00002AD07221A5F0 address: 0x00002AD07221A5F0 ; dladdress: 0x00002AD07220B000 ; offset in lib: 0x000000000000F5F0 ; (/lib64/libpthread.so.0) 0x00002AD07B57704C _ZN28sqlnqCandidatePartKeyBuilder27initCandidatePartKeyBuilderEP 9sqlnq_ftbP9sqlnq_qtbS3_P3loc + 0x0fdc (/head/home/db2inst1/sqllib/lib64/libdb2e.so.1) 0x00002AD07B546DE5 _Z22sqlnq_create_table_endP9sqlnq_qtbmiS0_RmP10sqlrl_fldsP25sqln q_base_table_seq_infobb + 0x5fc5 (/head/home/db2inst1/sqllib/lib64/libdb2e.so.1) 0x00002AD07B9797E6 address: 0x00002AD07B9797E6 ; dladdress: 0x00002AD0727CB000 ; offset in lib: 0x00000000091AE7E6 ; (/head/home/db2inst1/sqllib/lib64/libdb2e.so.1) 0x00002AD07B978360 _Z17sqlnq_table_defn2PP8stknode_i10actiontypePhP3loc + 0x07e0 (/head/home/db2inst1/sqllib/lib64/libdb2e.so.1) 0x00002AD07B3CE58E _Z12sqlnp_smactnP8sqlnp_cbi + 0x06ce (/head/home/db2inst1/sqllib/lib64/libdb2e.so.1) 0x00002AD07B3BEA78 _Z12sqlnp_parserP8sqlnp_cb + 0x1808 (/head/home/db2inst1/sqllib/lib64/libdb2e.so.1) 0x00002AD07B3C6817 _Z10sqlnp_mainP12sqlnq_stringbP3locPP9sqlnq_qur + 0x0827 (/head/home/db2inst1/sqllib/lib64/libdb2e.so.1) 0x00002AD07AF11103 _Z10sqlnn_cmplP8sqeAgentP11sqlrrstrings17sqlnn_compileModesP14sq lrr_cmpl_enviiPP9sqlnq_qur + 0x3063 (/head/home/db2inst1/sqllib/lib64/libdb2e.so.1) 0x00002AD07AF0E091 _Z10sqlnn_cmplP8sqeAgentP11sqlrrstrings17sqlnn_compileModesP14sq lrr_cmpl_env + 0x0021 (/head/home/db2inst1/sqllib/lib64/libdb2e.so.1) 0x00002AD07CA447C6 _Z17sqlra_compile_varP8sqlrr_cbP14sqlra_cmpl_envPhitiiiiiP14SQLP _LOCK_INFOP16sqlra_cached_varPiS5_Pb + 0x1166 (/head/home/db2inst1/sqllib/lib64/libdb2e.so.1) | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * All * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to 11.5.6 or later * **************************************************************** | |
Local Fix: | |
correct the query | |
Solution | |
Workaround | |
**************************************************************** * USERS AFFECTED: * * All * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to 11.5.6 or later * **************************************************************** | |
Comment | |
correct the query | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 10.11.2020 15.03.2021 21.06.2021 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |