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.