Re: v13 planner ERROR: could not determine which collation to use for string comparison

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: v13 planner ERROR: could not determine which collation to use for string comparison
Дата
Msg-id 1199426.1595370300@sss.pgh.pa.us
обсуждение исходный текст
Ответ на v13 planner ERROR: could not determine which collation to use for string comparison  (Justin Pryzby <pryzby@telsasoft.com>)
Ответы Re: v13 planner ERROR: could not determine which collation to use for string comparison  (Michael Paquier <michael@paquier.xyz>)
Список pgsql-hackers
Justin Pryzby <pryzby@telsasoft.com> writes:
> We hit this on v13b2 and verified it fails on today's HEAD (ac25e7b039).
> explain SELECT 1 FROM sites NATURAL JOIN sectors WHERE sites.config_site_name != sectors.sect_name ;
> ERROR:  could not determine which collation to use for string comparison

> I can workaround the issue by DELETEing stats for either column.

Ugh.  It's clear from your stack trace that neqjoinsel() has forgotten to
pass through collation to eqjoinsel().  Will fix.

            regards, tom lane



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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Infinities in type numeric
Следующее
От: Peter Geoghegan
Дата:
Сообщение: Re: Using Valgrind to detect faulty buffer accesses (no pin or buffer content lock held)