BUG #18458: SQL Error [XX000]: ERROR: cache lookup failed for type 0

The following bug has been logged on the website:

Bug reference:      18458
Logged by:          Stepan Yankevych
Email address:      stepya@ukr.net
PostgreSQL version: 15.6
Operating system:   CentOS Linux release 7.9.2009 (Core)
Description:

pg 15.6 / 15.3
Citus 12.1.1 / 12.1.3
autoexplain ON

test case 

CREATE TABLE billing.test_table
(  report_id int8 NULL,
    date_id int4 NOT NULL);
 
SELECT create_distributed_table('test_table', 'report_id');

CREATE OR REPLACE PROCEDURE billing.test_delete_from(p_date_id int)
  LANGUAGE plpgsql AS
$body$
BEGIN
    DELETE FROM billing.test_table
    WHERE  date_id = p_date_id;
END;
$body$;

CALL billing.test_delete_from(20240401);
SQL Error [XX000]: ERROR: cache lookup failed for type 0
  Where: SQL statement "DELETE FROM billing.test_table
    WHERE  date_id = p_date_id"

PL/pgSQL function test_delete_from(integer) line 3 at SQL statement

BUT if we use constant instead of parameter then everything works fine 

CREATE OR REPLACE PROCEDURE billing.test_delete_from(p_date_id int)
  LANGUAGE plpgsql AS
$body$
BEGIN
    DELETE FROM billing.test_table
    WHERE  date_id = 20240401;
END;
$body$;

Also using Function instead of procedure works fine. 

Disabling auto_explain resolves the issue. 
So looks like a bug some incompatibility between Citus/autoexplain while
using delete inside procedure