Symptom
The output value of ROUND() function is different on IQ15.2 compared with IQ15.4 or IQ16.x.
- On IQ15.2:
(DBA)> select c1, round(c1, 1) from MyTable order by c1
c1 round(MyTable.c1,1)
---------------------------------------------
-0.25 -0.2
0.25 0.2
(2 rows) - On IQ15.4 and IQ 16.x:
(DBA)> select c1, round(c1, 1) from MyTable order by c1;
c1 round(MyTable.c1,1)
---------------------------------------------
-0.25 -0.3
0.25 0.3(2 rows)
"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental."
Read more...
Environment
- SAP Sybase IQ 15.2
Product
Keywords
incorrect, query, result , KBA , BC-SYB-IQ , Sybase IQ , How To
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.