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 for Me (Login required).

Search for additional results

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