You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@age.apache.org by "zihaozeng0021 (via GitHub)" <gi...@apache.org> on 2025/12/26 14:46:38 UTC

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

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: dev-unsubscribe@age.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

Re: [I] `1 IN []` causes `cache lookup failed for type 0` [age]

Posted by "jrgemignani (via GitHub)" <gi...@apache.org>.
jrgemignani commented on issue #2289:
URL: https://github.com/apache/age/issues/2289#issuecomment-3697177621

   PR #2294 resolves this and adjacent issues.


-- 
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: dev-unsubscribe@age.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

Re: [I] `1 IN []` causes `cache lookup failed for type 0` [age]

Posted by "jrgemignani (via GitHub)" <gi...@apache.org>.
jrgemignani closed issue #2289: `1 IN []` causes `cache lookup failed for type 0`
URL: https://github.com/apache/age/issues/2289


-- 
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: dev-unsubscribe@age.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org