zihaozeng0021 opened a new issue, #2289:
URL: https://github.com/apache/age/issues/2289
### 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
```
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
