BUG #17363: 14 regression: "could not identify a hash function for type record" in a nested record in sublink

Поиск
Список
Период
Сортировка
От PG Bug reporting form
Тема BUG #17363: 14 regression: "could not identify a hash function for type record" in a nested record in sublink
Дата
Msg-id 17363-f6d42fd0d726be02@postgresql.org
обсуждение исходный текст
Ответы Re: BUG #17363: 14 regression: "could not identify a hash function for type record" in a nested record in sublink  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
The following bug has been logged on the website:

Bug reference:      17363
Logged by:          Elvis Pranskevichus
Email address:      elprans@gmail.com
PostgreSQL version: 14.0
Operating system:   Linux
Description:

The following fails in PostgreSQL 14:

    postgres14=# SELECT ROW(ROW(ROW(1))) = ANY (SELECT
(ROW(ROW(ROW(1)))).*);
    ERROR:  could not identify a hash function for type record

whereas PostgreSQL 13 works fine:

    postgres13=# SELECT ROW(ROW(ROW(1))) = ANY (SELECT
(ROW(ROW(ROW(1)))).*);  
     ?column?
    ──────────
     t
    (1 row)

Interestingly, reducing the nesting level to two works in 14:

    postgres14=# SELECT ROW(ROW(1)) = ANY (SELECT (ROW(ROW(1))).*);
     ?column?
    ──────────
     t
    (1 row)


В списке pgsql-bugs по дате отправления:

Предыдущее
От: Peter Geoghegan
Дата:
Сообщение: Re: BUG #17362: Error "could not find block containing chunk" when using index with icu collation on CentOS 7
Следующее
От: Peter Geoghegan
Дата:
Сообщение: Re: BUG #17361: Unique index constraint inconsistence