|  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #78497 SQLite3 version regression
Submitted: 2019-09-05 20:03 UTC Modified: 2019-09-06 07:29 UTC
From: fra dot martin at free dot fr Assigned: cmb (profile)
Status: Not a bug Package: SQLite related
PHP Version: 7.3.9 OS: Debian Jessie
Private report: No CVE-ID: None
View Add Comment Developer Edit
Anyone can comment on a bug. Have a simpler test case? Does it work for you on a different platform? Let us know!
Just going to say 'Me too!'? Don't clutter the database with that please !
Your email address:
Solve the problem:
15 - 2 = ?
Subscribe to this entry?

 [2019-09-05 20:03 UTC] fra dot martin at free dot fr
SQLite3 version is in latest PHP 7.3.9 (Debian Jessie repositories)
when PHP 7.3.8 had SQLITE 3.28.0

... big regression!

Test script:
echo SQLite3::version()


Add a Patch

Pull Requests

Add a Pull Request


AllCommentsChangesGit/SVN commitsRelated reports
 [2019-09-05 21:24 UTC]
-Status: Open +Status: Not a bug -Assigned To: +Assigned To: cmb
 [2019-09-05 21:24 UTC]
The bundled libsqlite3 is indeed version 3.28.0 in PHP 7.3.8 and
7.3.9.  It is, however, not up to to decide which version
is used by distros.  Feel free to report this issue to Debian.
 [2019-09-05 22:59 UTC] phpbugreports at gmail dot com
> SQLite3 version is in latest PHP 7.3.9 (Debian Jessie repositories)

how does that bother upstream in any way?
 [2019-09-06 07:29 UTC] fra dot martin at free dot fr
When querying from a SQLite View with alias, the field names change depending on the libsqlite3 version.

// 'my_view' is defined as: CREATE my_view AS SELECT id FROM my_table
$q = $db->query("select from my_view as m");
$r = $q->fetchArray(SQLITE3_ASSOC);

Then, to read the ID field:
With sqlite v3.8.7.1, I have to use $r['']
With sqlite v3.28.0, I have to use $r['id']

When queyring from a Table with exactly the same syntax:
$q = $db->query("select from my_table as m");
$r = $q->fetchArray(SQLITE3_ASSOC);

I can use $r['id'] with both SQLite versions.
PHP Copyright © 2001-2023 The PHP Group
All rights reserved.
Last updated: Mon Mar 27 03:03:41 2023 UTC