core Migration fails with: Undefined function: 7 ERROR: operator does not exist: json = unknown (master only?)

[blizzz]

Setting log level to debug
Turned on maintenance mode
Updating database schema

Exception: Database error when running migration 33000Date20251106131209 for app core
An exception occurred while executing a query: SQLSTATE[42883]: Undefined function: 7 ERROR:  operator does not exist: json = unknown
LINE 1: ...utes" = $1 WHERE ("share_type" = $2) AND ("attributes" = $3)
                                                                  ^
HINT:  No operator matches the given name and argument types. You might need to add explicit type casts.

Update failed
Maintenance mode is kept active
Resetting log level

It is a new migration job @julien-nc, happened also to @elzody

[blizzz]

We are both using postgres.

[blizzz]

… and attributes is a JSON column:

                                                 Table "public.oc_share"
          Column          |              Type              | Collation | Nullable |               Default                
--------------------------+--------------------------------+-----------+----------+--------------------------------------
 id                       | bigint                         |           | not null | nextval('oc_share_id_seq'::regclass)
 share_type               | smallint                       |           | not null | 0
 share_with               | character varying(255)         |           |          | NULL::character varying
 password                 | character varying(255)         |           |          | NULL::character varying
 uid_owner                | character varying(64)          |           | not null | ''::character varying
 uid_initiator            | character varying(64)          |           |          | NULL::character varying
 parent                   | bigint                         |           |          | 
 item_type                | character varying(64)          |           | not null | ''::character varying
 item_source              | character varying(255)         |           |          | NULL::character varying
 item_target              | character varying(255)         |           |          | NULL::character varying
 file_source              | bigint                         |           |          | 
 file_target              | character varying(512)         |           |          | NULL::character varying
 permissions              | smallint                       |           | not null | 0
 stime                    | bigint                         |           | not null | 0
 accepted                 | smallint                       |           | not null | 0
 expiration               | timestamp(0) without time zone |           |          | NULL::timestamp without time zone
 token                    | character varying(32)          |           |          | NULL::character varying
 mail_send                | smallint                       |           | not null | 0
 share_name               | character varying(64)          |           |          | NULL::character varying
 password_by_talk         | boolean                        |           |          | false
 note                     | text                           |           |          | 
 hide_download            | smallint                       |           |          | 0
 label                    | character varying(255)         |           |          | NULL::character varying
 password_expiration_time | timestamp(0) without time zone |           |          | NULL::timestamp without time zone
 attributes               | json                           |           |          | 
 reminder_sent            | boolean                        |           |          | false
Indexes:
    "oc_share_pkey" PRIMARY KEY, btree (id)
    "file_source_index" btree (file_source)
    "initiator_index" btree (uid_initiator)
    "item_share_type_index" btree (item_type, share_type)
    "owner_index" btree (uid_owner)
    "parent_index" btree (parent)
    "share_with_index" btree (share_with)
    "token_index" btree (token)

[nickvergessen]

• Attempt in fix(db): Fix JSON handling in WHERE statements for postgres #56504 but needs more work by original authors