CapnSpek commented on issue #1278:
URL: https://github.com/apache/age/issues/1278#issuecomment-1763406919
More information:
The query executes successfully if the labels of the supposed query do not
actually exist in the graph:
(The graph still contains only the above mentioned 2 labels and 1 edge)
```
SELECT * FROM cypher('xyz', $$ EXPLAIN ANALYZE VERBOSE MATCH (n:Pers) SET
n.age=25 $$) AS (x agtype);
QUERY PLAN
------------------------------------------------------------------------------------------------------
Custom Scan (Cypher Set) (cost=0.00..0.00 rows=0 width=0) (actual
time=0.003..0.004 rows=0 loops=1)
Output: cypher.x
-> Result (cost=0.00..0.00 rows=0 width=0) (actual time=0.002..0.002
rows=0 loops=1)
Output: cypher.x
One-Time Filter: false
Planning Time: 0.210 ms
Execution Time: 0.043 ms
(7 rows)
```
```
SELECT * FROM cypher('xyz', $$ EXPLAIN ANALYZE VERBOSE MATCH (n:Pers) DETACH
DELETE n $$) AS (x agtype);
QUERY PLAN
---------------------------------------------------------------------------------------------------------
Custom Scan (Cypher Delete) (cost=0.00..0.00 rows=0 width=0) (actual
time=0.008..0.010 rows=0 loops=1)
Output: cypher.x
-> Result (cost=0.00..0.00 rows=0 width=0) (actual time=0.005..0.005
rows=0 loops=1)
Output: cypher.x
One-Time Filter: false
Planning Time: 0.303 ms
Execution Time: 8.880 ms
(7 rows)
```
It is unrelated to the fact whether vertices were actually found or not as
these queries still fail.
```
SELECT * FROM cypher('xyz', $$ EXPLAIN ANALYZE VERBOSE MATCH (n:Person
{name:'x') SET n.name='U' $$) AS (x agtype);
2023-10-15 17:27:51.906 EEST [161353] ERROR: syntax error at or near ")" at
character 81
2023-10-15 17:27:51.906 EEST [161353] STATEMENT: SELECT * FROM
cypher('xyz', $$ EXPLAIN ANALYZE VERBOSE MATCH (n:Person {name:'x') SET
n.name='U' $$) AS (x agtype);
ERROR: syntax error at or near ")"
LINE 1: ... EXPLAIN ANALYZE VERBOSE MATCH (n:Person {name:'x') SET n.na...
```
```
SELECT * FROM cypher('xyz', $$ EXPLAIN ANALYZE VERBOSE MATCH (n:Person
{name:'x') DETACH DELETE n $$) AS (x agtype);
2023-10-15 17:28:15.647 EEST [161353] ERROR: syntax error at or near ")" at
character 81
2023-10-15 17:28:15.647 EEST [161353] STATEMENT: SELECT * FROM
cypher('xyz', $$ EXPLAIN ANALYZE VERBOSE MATCH (n:Person {name:'x') DETACH
DELETE n $$) AS (x agtype);
ERROR: syntax error at or near ")"
LINE 1: ... EXPLAIN ANALYZE VERBOSE MATCH (n:Person {name:'x') DETACH D...
```
--
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]
