Symptom
- COALESCE/ISNULL function and GROUP BY clause return an internal error under certain conditions.
- Value of the non-NULL is in expression list of the COALESCE/ISNULL function.
- COALESCE/ISNULL function and GROUP BY clause are used in subquery.
- Result of COALESCE/ISNULL function is aggregated. (ex. MIN/MAX)
- Aggregate column is used in the WHERE clause and COUNT clause in the outside SELECT statement.
- Error Message:
There was an error reading the results of the SQL statement.
The displayed results may be incorrect or incomplete.
Report to Sybase IQ Support. Query 'Internal error at node: #07 Can not evaluate expression: t_A1.col2',
-- (dflib/dfo.cxx 13183) SQLCODE=-1001043, ODBC 3 State="HY000"
Read more...
Environment
- SAP IQ 15.4 ESD 2 or later
- SAP IQ 16.x
Product
SAP IQ 16.0 ; SAP Sybase IQ 15.4
Keywords
CR762390, 762390 , KBA , BC-SYB-IQ , Sybase IQ , Problem
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.