SAP Knowledge Base Article - Preview

2490899 - Multicolumn index returns conversion error to "= NULL" comparison expression - SAP IQ

Symptom

If you specify "= NULL" for a multicolumn index with a numeric column type, SAP IQ will return a conversion error.

(DBA)> select col1,col2 from repro_tbl where col1 = NULL and col2 = NULL
col1 col2
----------------------
There was an error reading the results of the SQL statement.
The displayed results may be incorrect or incomplete.
Data exception - data type conversion is not possible.
--
(dflib/dfp_MColEquality.cxx 351)
SQLCODE=-1001006, ODBC 3 State="HY000"

(0 rows)


Read more...

Environment

  • SAP IQ 15.x
  • SAP IQ 16.x

Product

SAP IQ 16.0

Keywords

SAP IQ, index, HG, multi column, NULL, conversion, dfp_MColEquality.cxx , 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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.