Skip to content

Conversation

@JanJakes
Copy link
Member

@JanJakes JanJakes commented Nov 26, 2025

Motivation for the change, related issues

Our SQLite builds don't set the SQLITE_ENABLE_COLUMN_METADATA flag, which results in some metadata missing when PDOStatement::getColumnMeta is used. This results in issues like missing row editing controls in phpMyAdmin and possibly other problems.

This flag seems to be set in most libsqlite3 builds: https://www.rogerbinns.com/blog/sqlite-configuration.html

Therefore, I think it's safe to add it and, from the SQLite side, assume that it's always used.

Implementation details

I added the flag, updated SQLite, rebuilt it, and rebuilt all PHP builds.

Testing Instructions (or ideally a Blueprint)

I added tests for the SQLITE_ENABLE_COLUMN_METADATA and they need to pass.

Copy link
Collaborator

@adamziel adamziel left a comment

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

All the tests pass. The description could use a little brushing up, but the code is good to merge as is :-)

@JanJakes JanJakes changed the title WIP Add SQLITE_ENABLE_COLUMN_METADATA and update SQLite Add SQLITE_ENABLE_COLUMN_METADATA and update SQLite Nov 27, 2025
@JanJakes JanJakes marked this pull request as ready for review November 27, 2025 09:33
@JanJakes
Copy link
Member Author

I added tests, they're passing, so merging this now.

@JanJakes JanJakes merged commit 1817e45 into trunk Nov 27, 2025
28 checks passed
@JanJakes JanJakes deleted the sqlite-update branch November 27, 2025 09:55
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Labels

None yet

Projects

None yet

Development

Successfully merging this pull request may close these issues.

3 participants