Repository navigation
Bundled SQLite for Windows is missing math functions #24758
Description
Description
The following code:
<?php
$db = new PDO('sqlite::memory:');
$sth = $db->prepare('SELECT sqrt(null) foo');
$sth->execute();
$result = $sth->fetch(PDO::FETCH_ASSOC);
var_dump($result);Resulted in this output:
Fatal error: Uncaught PDOException: SQLSTATE[HY000]: General error: 1 no such function: sqrt
But I expected this output instead:
array(1) {
["foo"]=>
NULL
}
download source: https://www.php.net/downloads.php?os=windows
In older official PHP 7.4 download with SQLite 3.45.1 this was working. The new bundled version is 3.53.4. There needs to be some build regression.
PHP Version
PHP 8.5.12 (cli) (built: Oct 26 2026 09:51:07) (NTS Visual C++ 2022 x64)
Copyright (c) The PHP Group
Built by The PHP Group
Zend Engine v4.5.12, Copyright (c) Zend Technologies
with Zend OPcache v8.5.12, Copyright (c), by Zend Technologies
Operating System
windows
Reacted by Shivam Mathur
Activity
mvorisek commentedon Oct 26, 2026
The bundled version should be the same as officially offered by SQLite - https://www.sqlite.org/download.html
when the official dll from SQLite web (and larger in size) is used, the math functions are available
shivammathur commentedon Oct 27, 2026
Fixed in winlibs/sqlite3@05dd5bd.
@mvorisek Please test with this sqlite3 3.54.1 build for PHP 8.5.
mvorisek commentedon Oct 28, 2026
I have tested the dll from the mentioned .zip and it fixes this issue on Windows. If this can be landed into the lower supported php versions please do so. Thank you!
mvorisek commentedon Oct 29, 2026
closing as fixed