Symptom
IQ server got crashed due to SQL which is used by incorrect syntax.
And there is "assertion failed" message in stderr.
> select c1 (case when c1*=c2 then 1 else 0 end) as KKK
from test_tb; //incorrect syntax
[stderr]
...
Assertion failed: 0, file /ibm10bld1/gusers/sabld/src.12/db/engine/omni/./qdexpr.c, line 1112
...
Read more...
Environment
SAP IQ 12.7 all, 15.4 all, less than 16 SP03
Product
SAP IQ 16.0 ; SAP Sybase IQ 15.2 ; SAP Sybase IQ 15.4
Keywords
incorrect, syntax, assertion, omni, Query Decomposition, Unknown Node Type, SAP IQ, IQ, SYBASE, -660 , KBA , BC-SYB-IQ , Sybase IQ , BW-SYS-DB-IQ , BW on HANA with Sybase IQ Near-line Storage , Bug Filed
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.