|
Problem IT26387
|
Status: Geschlossen |
CASTING JSON TO LVARCHAR CAN SEGV IN CASTEXPR2EXPR
|
| Produkt: |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 |
| Problembeschreibung: |
This problem was reported running a special build of 12.10.FC7W1
on linux x86_64 under stress.  The problem seems to reproduce
even faster on 12.10.FC12 running the query by itself with no
stress.  The query performs a cast operation of
column_name::json::lvarchar(3000). ÂÂ
Removing the cast "::lvarchar(3000)" seems to keep the failure
from happening. When the failure occurs, you will see a stack
like:ÂÂ
0x000000000141f989 (oninit) afstackÂÂ
0x0000000001423471 (oninit) mt_ex_throw_sigÂÂ
0x000000000142e343 (oninit) afsig_handlerÂÂ
0x0000003ddfa0e4c0 (Linux) ÂÂ
0x000000000069ba0e (oninit) castexpr2exprÂÂ
0x00000000006994b5 (oninit) expr2exprÂÂ
0x000000000069b9b7 (oninit) castexpr2exprÂÂ
0x00000000006994b5 (oninit) expr2exprÂÂ
0x000000000064feb6 (oninit) prjlst2exprÂÂ
0x0000000000665642 (oninit) sel2cbÂÂ
0x0000000000669284 (oninit) qblk2cbÂÂ
0x000000000066c09c (oninit) stmt2cbÂÂ
0x000000000066fa6e (oninit) p_sp2cbÂÂ
0x0000000000a307bc (oninit) parsecmdÂÂ
0x0000000000a30cd2 (oninit) sqcmdÂÂ
0x0000000000a3ba5a (oninit) sq_cmndÂÂ
0x0000000000a3bbb4 (oninit) sq_prepareÂÂ
0x0000000000b0b011 (oninit) sqmainÂÂ
0x000000000154ca1b (oninit) spawn_threadÂÂ
0x0000000001411450 (oninit) th_init_initglsÂÂ
0x0000000001456d88 (oninit) startup |
| Problem-Zusammenfassung: |
****************************************************************
* USERS AFFECTED: *
* Users of IDS prior to 12.10.xC13. *
****************************************************************
* PROBLEM DESCRIPTION: *
* Casting json to lvarchar can segv in castexpr2expr(). *
****************************************************************
* RECOMMENDATION: *
**************************************************************** |
| Local-Fix: |
Remove the secondary cast from JSON to lvarchar |
| Lösung |
|
| Workaround |
keiner bekannt / siehe Local-Fix |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 21.09.2018
26.09.2019
26.09.2019 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
12.10.xC13
|
| Problem behoben lt. FixList in der Version |
