ERREUR: cache lookup failed for function 0 with PostgreSQL 15 beta 2, no error with PostgreSQL 14.4

From: Phil Florent <philflorent(at)hotmail(dot)com>
To: "pgsql-hackers(at)lists(dot)postgresql(dot)org" <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: ERREUR: cache lookup failed for function 0 with PostgreSQL 15 beta 2, no error with PostgreSQL 14.4
Date: 2022-08-04 13:19:59
Message-ID: PA4P191MB160009A09B9D0624359278CFBA9F9@PA4P191MB1600.EURP191.PROD.OUTLOOK.COM
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi,

A DSS developer from my company, Julien Roze, reported me an error I cannot explained. Is it a new behavior or a bug ?

Original query is much more complicated but here is a simplified test case with postgresql 14 and 15 beta 2 on Debian 11, packages from pgdg :

Ver Cluster Port Status Owner Data directory Log file
14 main 5432 online postgres /var/lib/postgresql/14/main /var/log/postgresql/postgresql-14-main.log
15 main 5433 online postgres /var/lib/postgresql/15/main /var/log/postgresql/postgresql-15-main.log

psql -p 5432

select version();
version
-----------------------------------------------------------------------------------------------------------------------------
PostgreSQL 14.4 (Debian 14.4-1.pgdg110+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 10.2.1-6) 10.2.1 20210110, 64-bit
(1 ligne)

with fakedata as (
select 'hello' word
union all
select 'world' word
)
select *
from (
select word, count(*) over (partition by word) nb from fakedata
) t where nb = 1;

word | nb
-------+----
hello | 1
world | 1
(2 lignes)

with fakedata as (
select 'hello' word
union all
select 'world' word
)
select *
from (
select word, count(*) nb from fakedata group by word
) t where nb = 1;

word | nb
-------+----
hello | 1
world | 1
(2 lignes)

psql -p 5433

select version();
version
------------------------------------------------------------------------------------------------------------------------------------
PostgreSQL 15beta2 (Debian 15~beta2-1.pgdg110+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 10.2.1-6) 10.2.1 20210110, 64-bit
(1 ligne)

with fakedata as (
select 'hello' word
union all
select 'world' word
)
select *
from (
select word, count(*) over (partition by word) nb from fakedata
) t where nb = 1;
ERREUR: cache lookup failed for function 0

with fakedata as (
select 'hello' word
union all
select 'world' word
)
select *
from (
select word, count(*) nb from fakedata group by word
) t where nb = 1;

word | nb
-------+----
hello | 1
world | 1
(2 lignes)

Best regards,
Phil

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Amit Langote 2022-08-04 13:21:31 Re: enable/disable broken for statement triggers on partitioned tables
Previous Message Robert Haas 2022-08-04 13:17:23 Re: Smoothing the subtrans performance catastrophe