sqlite integer parameters should not be bound as doubles

Version

v26.2.0

Platform

Darwin rocksteady 25.5.0 Darwin Kernel Version 25.5.0: Mon Apr 27 20:40:51 PDT 2026; root:xnu-12377.121.6~2/RELEASE_ARM64_T8112 arm64

Subsystem

sqlite

What steps will reproduce the bug?

I am assuming parameters that are number are always bound as type double, but integers should be bound as type integer so that SQLite performs integer arithmetic and returns a type of integer instead of a type of double.

const db = new DatabaseSync(':memory:', { readBigInts: true });
const big = db.prepare('select 2 * 2');
const bigResult = big.all();
const notBig = db.prepare('select 2 * ?');
const notResult = notBig.all(2);

This is the offending code in nodejs:
https://github.com/nodejs/node/blob/19c46abbefdb8711b913d7237b3c1299367f87d7/src/node_sqlite.cc#L2703

How often does it reproduce? Is there a required condition?

Every time

What is the expected behavior? Why is that the expected behavior?

Integers should be bound as integers not double as they are integers.

What do you see instead?

Integers being bound as double.

Additional information

No response

Beginnen Sie in src/node_sqlite.cc beim verknüpften Parameter-Binding-Code und reproduzieren Sie das Problem mit den bereitgestellten DatabaseSync-Beispielen. Überprüfen Sie, wie numerische Parameter klassifiziert werden, bevor SQLite sie empfängt. Erledigt ist die Aufgabe, wenn Integer-Parameter zu ganzzahliger Arithmetik in SQLite führen und das gemeldete readBigInts-Verhalten durch Regressionstests abgedeckt ist.