#578 Round function doesn't work with SQLite3

[Pablo]

When I execute SQL command select round(vcc,2) as vcc2 from tab; from Adminer, vcc2's column values (type real) are not rounded. When I execute the same SQL command from my Nodejs app, sqlite3 command line or even my own PHP app, it is ok.
I use login-sqlite plugin, tested on PHP 7.1.8 and PHP 5.6.31

[Jakub Vrána]

This is not specific to Adminer, PHP does this. My guess is that the field is transferred as float which is unprecise.

[Pablo]

How this could be PHP related when my own PHP script below is working fine?

<?php
$db = new SQLite3('iot.db');

$results = $db->query('select round(vcc,2) as vcc2 from tab;');
while ($row = $results->fetchArray()) {
    var_dump($row);
}
?>

While "select round(vcc,2) as vcc2 from tab;" in Adminer is not working (values are not rounded).

[Jakub Vrána]

Adminer sets precision to 20.

[Jakub Vrána]

I've decreased the display precision to 17 which is the PHP's internal float precision.