jrgemignani commented on issue #41:
URL: https://github.com/apache/incubator-age/issues/41#issuecomment-794427205
Interesting. And, ty, I can reproduce it.
I will look into it.
john
On Tue, Mar 9, 2021 at 12:27 PM Pieterjan De Potter <
notificati...@github.com> wrote:
> After creating a new database connection, the first cypher query results
> in a ERROR: unhandled cypher(cstring) function call error. This error
> does not occur on subsequent cypher queries, or if a create_graph query has
> been executed prior to the cypher query.
>
> How to reproduce:
>
> - Set up database
>
> vagrant@local:~$ sudo -u postgres createdb testdb
> vagrant@local:~$ sudo -u postgres psql -d testdb -c "CREATE EXTENSION age;"
> CREATE EXTENSION
> vagrant@local:~$ sudo -u postgres psql -d testdb -c "LOAD 'age';"
> LOAD
>
>
> - First connection to create a graph and add some data. Here, the
> cypher query succeeds.
>
> vagrant@local:~$ sudo -u postgres psql -d testdb
> psql (11.7 (Debian 11.7-0+deb10u1), server 11.10 (Debian 11.10-0+deb10u1))
> Type "help" for help.
>
> testdb=# SET search_path = ag_catalog, "$user", public;
> SET
> testdb=# SELECT create_graph('testgraph');
> NOTICE: graph "testgraph" has been created
> create_graph
> --------------
>
> (1 row)
>
> testdb=# SELECT * from cypher('testgraph', $$ CREATE (a:Person {name:
'Tom'}) $$) as (a agtype);
> a
> ---
> (0 rows)
>
> testdb=# \q
>
>
> - Second connection to query the graph. The first cypher query fails,
> the second query succeeds.
>
> vagrant@local:~$ sudo -u postgres psql -d testdb
> psql (11.7 (Debian 11.7-0+deb10u1), server 11.10 (Debian 11.10-0+deb10u1))
> Type "help" for help.
>
> testdb=# SET search_path = ag_catalog, "$user", public;
> SET
> testdb=# SELECT * FROM cypher('testgraph', $$MATCH (p) return p$$) as (a
agtype);
> ERROR: unhandled cypher(cstring) function call
> DETAIL: testgraph
> testdb=# SELECT * FROM cypher('testgraph', $$MATCH (p) return p$$) as (a
agtype);
>
> a
>
-----------------------------------------------------------------------------------
> {"id": 844424930131969, "label": "Person", "properties": {"name":
"Tom"}}::vertex
> (1 row)
>
> (END)
>
> testdb=# \q
>
>
> - Third connection to add more data. The first cypher query again
> fails, the second query again succeeds.
>
> vagrant@local:~$ sudo -u postgres psql -d testdb
> psql (11.7 (Debian 11.7-0+deb10u1), server 11.10 (Debian 11.10-0+deb10u1))
> Type "help" for help.
>
> testdb=# SET search_path = ag_catalog, "$user", public;
> SET
> testdb=# SELECT * from cypher('testgraph', $$ CREATE (a:Person {name:
'Ann'}) $$) as (a agtype);
> ERROR: unhandled cypher(cstring) function call
> DETAIL: testgraph
> testdb=# SELECT * from cypher('testgraph', $$ CREATE (a:Person {name:
'Ann'}) $$) as (a agtype);
> a
> ---
> (0 rows)
>
> testdb=# \q
>
> —
> You are receiving this because you are subscribed to this thread.
> Reply to this email directly, view it on GitHub
> <https://github.com/apache/incubator-age/issues/41>, or unsubscribe
>
<https://github.com/notifications/unsubscribe-auth/AALPO4CMQG4HXWNQCTBRA5DTC2ABZANCNFSM4Y4NEVJA>
> .
>
----------------------------------------------------------------
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.
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org
