I have a problem with rounding values.
For example:
Value 1.2625 must result in 1.263 (it now results in 1.262)
And value 1.2624 must result in 1.262
with other words, from 5 up to 9 at the fourth decimal must round the third decimal up
and from 0 to 5 at the fourth decimal it must round the third decimal down.
I use the following query:
select round (price,3) from articles
This is a "feature". An annoying one for sure. FLOAT is an approximate representation and so what is represented internally may be close to 1.2625, but not exactly 1.2625. It is a tiny delta less than 1.2625. So when you round it, it rounds down.
You can run the following queries to see this behavior. This does not mean that you can always add 1.0E-10 and get the correct rounded results. Doing so might cause the data to get rounded the wrong way in some other cases.