`1 IN []` causes `cache lookup failed for type 0`

[zihaozeng0021]

Configuration

AGE Version: apache/age:latest (pulled 2025-12-26)

Operating System: WSL2 – Ubuntu 24.04.1 LTS

Installation Method: Docker

---

Steps to reproduce

1. Start AGE via Docker

docker run \
  --name age \
  -p 5455:5432 \
  -e POSTGRES_USER=postgresUser \
  -e POSTGRES_PASSWORD=postgresPW \
  -e POSTGRES_DB=postgresDB \
  -d \
  apache/age:latest

2. Connect with psql

PGPASSWORD='postgresPW' psql -h localhost -p 5455 -U postgresUser -d postgresDB

3. Run the following query

Set up:

CREATE EXTENSION IF NOT EXISTS age;
LOAD 'age';
SET search_path = ag_catalog, "$user", public;

SELECT create_graph('test');

The buggy query:

SELECT *
FROM cypher('test', $$ RETURN (1 IN []) AS v $$) AS (v agtype);

---

Expected behaviour

The expression should evaluate to FALSE, as in Neo4j:

neo4j@neo4j> RETURN (1 IN []) AS v;
+-------+
| v     |
+-------+
| FALSE |
+-------+

1 row
ready to start consuming query after 67 ms, results consumed after another 1 ms

Actual behaviour

postgresDB=# SELECT *
FROM cypher('test', $$ RETURN (1 IN []) AS v $$) AS (v agtype);
ERROR:  cache lookup failed for type 0

[jrgemignani]

PR #2294 resolves this and adjacent issues.