SAP Knowledge Base Article - Preview

2484339 - SAP IQ - Different results set between releases 15.4 and 16.0

Symptom

You have a query similar the example below.

CREATE TABLE TEST (aa varchar(20));
INSERT INTO TEST (aa) values('Hello');
COMMIT;
SELECT COUNT(1)
FROM (select max(aa) dd from TEST where aa = 'gkgkgkg') aa;

 

And noted that it returned a different result set between SAP IQ 15.4 and IQ 16.0 SP11.03 and higher


Read more...

Environment

  • SAP IQ 15.4
  • SAP IQ 16.0

Product

SAP IQ 16.0 ; SAP Sybase IQ 15.4

Keywords

count(), count, max(), max, incorrect result set, wrong result set , 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.