1982741 - [SAP IQ] IQ server got crashed due to incorrect syntax.

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

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.