We cannot add query conditions on a BLOB/bytea field reliably; in PostgreSQL, a condition value containing non-UTF data generates a
ERROR: invalid byte sequence for encoding "UTF8": ...
Add (the the ability to add) bindValue() calls to query arguments.
#2222635-14: Waiting for table metadata lock on cache_field table → had output issues like #710940-10: Support for BINARY and VARBINARY in Database Schema →
Postponed
10.1 ✨
Particularly affects sites running on the PostgreSQL database.
Enhances an existing API or introduces a new subsystem. Depending on the size and impact, possibly backportable to earlier major versions.
The patch will have to be re-rolled with new suggestions/changes described in the comments in the issue.
Not all content is available!
It's likely this issue predates Contrib.social: some issue and comment data are missing.
Postponed on 🐛 PostgreSQL orderBy method adds fields it doesn't need to, leading to fatal errors when the result is used as an insert subquery Needs work per #42.
Also needs an opinion from maintainer like @daffie on #38.2