SAP Knowledge Base Article - Preview

2007727 - COALESCE/ISNULL function and GROUP BY clause return an internal error - SAP IQ

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.