Skip to content

Add SQLITE_ENABLE_COLUMN_METADATA and update SQLite - #2948

Merged
JanJakes merged 4 commits into
trunkfrom
sqlite-update
Nov 27, 2025
Merged

JanJakes merged 4 commits into
trunkfrom
sqlite-update

Conversation

@JanJakes

@JanJakes JanJakes commented Nov 26, 2025 •

Copy link
Copy Markdown
Member

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.

@adamziel adamziel left a comment •

Copy link
Copy Markdown
Collaborator

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
Copy Markdown
Member Author

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

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.

2 participants