rerz commented on issue #1278:
URL: https://github.com/apache/age/issues/1278#issuecomment-2085006449

   I ran into a variant of this issue trying to use the rust library 
[sqlx](https://github.com/launchbadge/sqlx) with Apache AGE. sqlx provides 
compile time query checking by running queries against an actual database 
instance. This mostly works just fine since AGE is just Postgres under the hood.
   
   As part of this they use queries like `EXPLAIN (VERBOSE, FORMAT JSON) <your 
query>`
   
   A query like: `sqlx::query!(r#"SELECT * FROM 
ag_catalog.create_graph('graph');"#);` works without issues.
   
   However queries that return something from the cypher query fail with the 
error below:
   
   ```
   sqlx::query!(r#"SELECT * FROM ag_catalog.cypher('graph', $$
       CREATE (v:label) RETURN v
   $$) as (v ag_catalog.agtype)"#);
   ```
   
   ```
   error: error returned from database: cannot display a value of type internal
     --> src/main.rs:49:5
      |
   49 | /     sqlx::query!(r#"SELECT * FROM ag_catalog.cypher('graph', $$
   50 | |         CREATE (v:label) RETURN v
   51 | |     $$) as (v ag_catalog.agtype)"#);
      | |___________________________________^
      |
      = note: this error originates in the macro 
`$crate::sqlx_macros::expand_query` which comes from the expansion of the macro 
`sqlx::query` (in Nightly builds, run with -Z macro-backtrace for more info)
   ```
   
   


-- 
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

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

Reply via email to