You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
{{ message }}
This repository was archived by the owner on Jul 1, 2026. It is now read-only.
Repository navigation
This repository was archived by the owner on Jul 1, 2026. It is now read-only.
Recently I've updated my application env.
In that process, I've updated node-sqlite3 from v5.1.6 to v5.1.7
After that update, ROUND function behavior was changed.
This is minimum example.
const sqlite3 = require('sqlite3').verbose();
const db = new sqlite3.Database(':memory:');
db.serialize(() => {
db.each("SELECT ROUND(1.15, 1) as rounded", (err, row) => {
console.log(row);
});
});
v5.1.6 -> { rounded: 1.2 }
v5.1.7 -> { rounded: 1.1 }
For my usecase, expected value is 1.2.
However v5.1.7 returns 1.1. (Floating point handling was changed?)
The other hand, I've verified sqlite3 binary behavior.
$ echo "SELECT ROUND(1.15, 1)" | sqlite3
1.1
It returns 1.1. (v3.44.2 and v3.49.2)
Is it expected value? v5.1.7 was fixed to return same value of sqlite3 binary?
Activity