Repository navigation
SQLite createFunction corrupts large integers #25021
Description
Description
The following code:
<?php
$db = new PDO('sqlite::memory:');
$db->sqliteCreateFunction('cust', function ($v) {
var_dump($v);
return $v;
}, 1);
$sth = $db->prepare('SELECT 1234000000000 direct, cust(1234000000000) fx');
$sth->execute();
$result = $sth->fetch(PDO::FETCH_ASSOC);
var_dump($result);Resulted in this output:
int(1344386048)
array(2) {
["direct"]=>
int(1234000000000)
["fx"]=>
int(1344386048)
}
But I expected this output instead:
int(1234000000000)
array(2) {
["direct"]=>
int(1234000000000)
["fx"]=>
int(1234000000000)
}
Please fix at the lowest branch possible as there is no client workaround.
PHP Version
any
Operating System
any
Activity
mvorisek commentedon Oct 28, 2026
The issue is in https://github.com/php/php-src/blob/php-8.5.12/ext/pdo_sqlite/sqlite_driver.c#L406 -
sqlite3_value_int64must be used here.The correct code is in https://github.com/php/php-src/blob/php-8.5.12/ext/sqlite3/sqlite3.c#L808-L828.
related with 99d087e