zihaozeng0021 opened a new issue, #2291:
URL: https://github.com/apache/age/issues/2291
### 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
```
CREATE EXTENSION IF NOT EXISTS age;
LOAD 'age';
SET search_path = ag_catalog, "$user", public;
SELECT create_graph('test');
SELECT * FROM cypher('test', $$
RETURN any(x IN [] WHERE true)
$$) AS (r agtype);
```
---
### Expected behaviour
AGE aims to be 100% compatible with Neo4j wherever possible, so this query
is expected to work as it does in Neo4j:
```
neo4j@neo4j> RETURN any(x IN [] WHERE true);
+-------------------------+
| any(x IN [] WHERE true) |
+-------------------------+
| FALSE |
+-------------------------+
```
### Actual behaviour
The query fails with:
```
ERROR: syntax error at or near "WHERE"
LINE 2: RETURN any(x IN [] WHERE true)
^
```
--
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]
