SAP Knowledge Base Article - Preview

3015788 - Aggregate function return double result incorrectly - SAP IQ

Symptom

Aggregate function return double result incorrectly.
When the same SQL is executed repeatedly, the result does not return the same value.

ex:

4.818968800000145E7
4.8189688000001445E7
4.8189688000001445E7
4.818968800000145E7
4.8189688000001445E7
4.818968800000145E7
4.818968800000145E7
4.8189688000001445E7
4.8189688000001445E7
4.8189688000001445E7
4.8189688000001445E7
4.8189688000001445E7
4.818968800000145E7


Read more...

Environment

  • SAP IQ 16.0 SP11 PL20 and later
  • SAP IQ 16.1 

Product

SAP IQ 16.0 ; SAP IQ 16.1

Keywords

double, fload, sum, avg, aggregate, 16.0, 16.1, IQ, incorrect , KBA , BC-SYB-IQ , Sybase IQ , Bug Filed

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.