CapnSpek opened a new issue, #1278:
URL: https://github.com/apache/age/issues/1278

   **Describe the bug**
   `EXPLAIN ANALYZE VERBOSE` query will not work with `DETACH DELETE` and `SET` 
queries.
   Error message
   ```
   2023-10-15 17:16:43.423 EEST [161353] ERROR:  cannot display a value of type 
internal
   2023-10-15 17:16:43.423 EEST [161353] STATEMENT:  SELECT * FROM 
cypher('xyz', $$ EXPLAIN ANALYZE VERBOSE MATCH (n:Person {age:24}) SET n.age=25 
$$) AS (x agtype);
   ERROR:  cannot display a value of type internal
   ```
   
   **How are you accessing AGE (Command line, driver, etc.)?**
   Accessing AGE through command line.
   
   **What data setup do we need to do?**
   Apache AGE (master branch) with PGSQL15.
   
   **What is the necessary configuration info needed?**
   Create a graph and a pair of vertices.
   ```
   SELECT * FROM cypher('xyz', $$ CREATE (n:Person 
{age:24})-[e:Knows]->(m:Person {age:25}) $$) AS (x agtype);
   ```
   
   **What is the command that caused the error?**
   ```
   SELECT * FROM cypher('xyz', $$ EXPLAIN ANALYZE VERBOSE MATCH (n:Person 
{age:24}) SET n.age=25 $$) AS (x agtype);
   ```
   **ERROR**
   ```
   2023-10-15 17:21:10.744 EEST [161353] ERROR:  cannot display a value of type 
internal
   2023-10-15 17:21:10.744 EEST [161353] STATEMENT:  SELECT * FROM 
cypher('xyz', $$ EXPLAIN ANALYZE VERBOSE MATCH (n:Person {age:24}) SET n.age=25 
$$) AS (x agtype);
   ERROR:  cannot display a value of type internal
   ```
   
   **Expected behavior**
   Expected the query to execute successfully.
   
   
   
   **Environment (please complete the following information):**
   - Version: [e.g. 0.4.0]
   
   **Additional context**
   Add any other context about the problem here.
   


-- 
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-unsubscr...@age.apache.org.apache.org

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

Reply via email to