Review 12.4 Merged

89359[BUGFIX] Mitigate Postgres `like` type error for `JSON` fields

Stefan Bürk CR +2 V +2 Easy +2 −2 updated 05/12/25, 08:43

Commit message

`EXT:lowlevel` provides the ability to search full records,
technically limited to all existing database table fields
limited to only TCA managed tables, already for a very long
time. Corresponding code contained special handling for the
PostgreSQL database platform adding field casting for `like`
queries to avoid PostgreSQL type conversion database errors.

Change #106657 introduced TCA configuration for `tx_scheduler_task`
containing native database json and `TCA type=json` fields added as
new storage format recently with #106532.

That lead to database errors with PostgresSQL within the
dbcheck module record search trying to simply use `like`
on json fields which is not supported.

The `Types::JSON` check to avoid adding type conversion for
Postgres for likes is now removed in two places and adding
conversion to `text` before doing a like search to mitigate
the aforementioned issue.

Note that `EXT:reactions` and `EXT:webhooks` are not active
in acceptance test setups. The json fields for TCA managed
tables of these extension has not been tested yet. That
explains why nightlies revealed that now for the scheduler
table and why the issue exists already since v12.

Review

  • Code review CR +2 Done
    • Stefan Bürk +2
  • Verified V +2 Done
    • Stefan Bürk +2
    • core-ci +1 CI

Issues 4

Files 1

Review log 34

  1. Stefan Bürk uploaded patch set 1 05/12/25, 08:36

  2. core-ci voted on patch set 1 V +1 05/12/25, 08:41 Core CI is happy: https://git.typo3.org/typo3/CI/cms/-/pipelines/78798

  3. Stefan Bürk voted on patch set 1 CR +2 V +2 05/12/25, 08:43

  4. Stefan Bürk merged patch set 2 05/12/25, 08:43