|
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) |
