CapnSpek commented on issue #1062:
URL: https://github.com/apache/age/issues/1062#issuecomment-1650823140
Tests that may require code changes.
File - cypher_match.out
```
Line 141
SELECT * FROM cypher('cypher_match', $$
MATCH (:v1)-[e]-() RETURN e
$$) AS (a agtype);
- a
----------------------------------------------------------------------------------------------------------------------------
- {"id": 1407374883553282, "label": "e1", "end_id": 1125899906842626,
"start_id": 1125899906842625, "properties": {}}::edge
- {"id": 1407374883553281, "label": "e1", "end_id": 1125899906842627,
"start_id": 1125899906842626, "properties": {}}::edge
- {"id": 1407374883553282, "label": "e1", "end_id": 1125899906842626,
"start_id": 1125899906842625, "properties": {}}::edge
- {"id": 1407374883553281, "label": "e1", "end_id": 1125899906842627,
"start_id": 1125899906842626, "properties": {}}::edge
-(4 rows)
-
+ERROR: function ag_catalog._extract_label_id(bigint) does not exist
+LINE 1: SELECT * FROM cypher('cypher_match', $$
+ ^
+HINT: No function matches the given name and argument types. You might
need to add explicit type casts.
Line 152
SELECT * FROM cypher('cypher_match', $$
MATCH (:v1)-[e]-(:v1) RETURN e
$$) AS (a agtype);
- a
----------------------------------------------------------------------------------------------------------------------------
- {"id": 1407374883553282, "label": "e1", "end_id": 1125899906842626,
"start_id": 1125899906842625, "properties": {}}::edge
- {"id": 1407374883553281, "label": "e1", "end_id": 1125899906842627,
"start_id": 1125899906842626, "properties": {}}::edge
- {"id": 1407374883553282, "label": "e1", "end_id": 1125899906842626,
"start_id": 1125899906842625, "properties": {}}::edge
- {"id": 1407374883553281, "label": "e1", "end_id": 1125899906842627,
"start_id": 1125899906842626, "properties": {}}::edge
-(4 rows)
-
+ERROR: function ag_catalog._extract_label_id(bigint) does not exist
+LINE 1: SELECT * FROM cypher('cypher_match', $$
+ ^
+HINT: No function matches the given name and argument types. You might
need to add explicit type casts.
SELECT * FROM cypher('cypher_match', $$
MATCH ()-[]-()-[e]-(:v1) RETURN e
$$) AS (a agtype);
- a
----------------------------------------------------------------------------------------------------------------------------
- {"id": 1407374883553282, "label": "e1", "end_id": 1125899906842626,
"start_id": 1125899906842625, "properties": {}}::edge
- {"id": 1407374883553281, "label": "e1", "end_id": 1125899906842627,
"start_id": 1125899906842626, "properties": {}}::edge
-(2 rows)
-
+ERROR: function ag_catalog._extract_label_id(bigint) does not exist
+LINE 1: SELECT * FROM cypher('cypher_match', $$
+ ^
+HINT: No function matches the given name and argument types. You might
need to add explicit type casts.
SELECT * FROM cypher('cypher_match', $$
MATCH (a)-[]-()-[]-(:v1) RETURN a
$$) AS (a agtype);
- a
-----------------------------------------------------------------------------------
- {"id": 1125899906842625, "label": "v1", "properties": {"id":
"initial"}}::vertex
- {"id": 1125899906842627, "label": "v1", "properties": {"id":
"end"}}::vertex
-(2 rows)
-
+ERROR: function ag_catalog._extract_label_id(bigint) does not exist
+LINE 1: SELECT * FROM cypher('cypher_match', $$
+ ^
+HINT: No function matches the given name and argument types. You might
need to add explicit type casts.
Line 230
SELECT * FROM cypher('cypher_match', $$
MATCH (:v1)-[e]->() RETURN e
$$) AS (a agtype);
- a
----------------------------------------------------------------------------------------------------------------------------
- {"id": 1407374883553281, "label": "e1", "end_id": 1125899906842627,
"start_id": 1125899906842626, "properties": {}}::edge
- {"id": 1407374883553282, "label": "e1", "end_id": 1125899906842626,
"start_id": 1125899906842625, "properties": {}}::edge
-(2 rows)
-
+ERROR: function ag_catalog._extract_label_id(bigint) does not exist
+LINE 1: SELECT * FROM cypher('cypher_match', $$
+ ^
+HINT: No function matches the given name and argument types. You might
need to add explicit type casts.
SELECT * FROM cypher('cypher_match', $$
MATCH ()-[e]->(:v1) RETURN e
$$) AS (a agtype);
- a
----------------------------------------------------------------------------------------------------------------------------
- {"id": 1407374883553281, "label": "e1", "end_id": 1125899906842627,
"start_id": 1125899906842626, "properties": {}}::edge
- {"id": 1407374883553282, "label": "e1", "end_id": 1125899906842626,
"start_id": 1125899906842625, "properties": {}}::edge
-(2 rows)
-
+ERROR: function ag_catalog._extract_label_id(bigint) does not exist
+LINE 1: SELECT * FROM cypher('cypher_match', $$
+ ^
+HINT: No function matches the given name and argument types. You might
need to add explicit type casts.
SELECT * FROM cypher('cypher_match', $$
MATCH (:v1)-[e]->(:v1) RETURN e
$$) AS (a agtype);
- a
----------------------------------------------------------------------------------------------------------------------------
- {"id": 1407374883553281, "label": "e1", "end_id": 1125899906842627,
"start_id": 1125899906842626, "properties": {}}::edge
- {"id": 1407374883553282, "label": "e1", "end_id": 1125899906842626,
"start_id": 1125899906842625, "properties": {}}::edge
-(2 rows)
-
+ERROR: function ag_catalog._extract_label_id(bigint) does not exist
+LINE 1: SELECT * FROM cypher('cypher_match', $$
+ ^
+HINT: No function matches the given name and argument types. You might
need to add explicit type casts.
Line 307
SELECT * FROM cypher('cypher_match', $$
MATCH (:v1)<-[e]-(:v1) RETURN e
$$) AS (a agtype);
- a
----------------------------------------------------------------------------------------------------------------------------
- {"id": 1407374883553281, "label": "e1", "end_id": 1125899906842627,
"start_id": 1125899906842626, "properties": {}}::edge
- {"id": 1407374883553282, "label": "e1", "end_id": 1125899906842626,
"start_id": 1125899906842625, "properties": {}}::edge
-(2 rows)
-
+ERROR: function ag_catalog._extract_label_id(bigint) does not exist
+LINE 1: SELECT * FROM cypher('cypher_match', $$
+ ^
+HINT: No function matches the given name and argument types. You might
need to add explicit type casts.
Line 357
SELECT * FROM cypher('cypher_match', $$
MATCH (:v2)<-[]-(:v2)-[]->(:v2)
MATCH p=()-[]->()
RETURN p
$$) AS (i agtype);
-
i
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
- [{"id": 1125899906842625, "label": "v1", "properties": {"id":
"initial"}}::vertex, {"id": 1407374883553282, "label": "e1", "end_id":
1125899906842626, "start_id": 1125899906842625, "properties": {}}::edge, {"id":
1125899906842626, "label": "v1", "properties": {"id": "middle"}}::vertex]::path
- [{"id": 1125899906842625, "label": "v1", "properties": {"id":
"initial"}}::vertex, {"id": 1407374883553282, "label": "e1", "end_id":
1125899906842626, "start_id": 1125899906842625, "properties": {}}::edge, {"id":
1125899906842626, "label": "v1", "properties": {"id": "middle"}}::vertex]::path
- [{"id": 1125899906842626, "label": "v1", "properties": {"id":
"middle"}}::vertex, {"id": 1407374883553281, "label": "e1", "end_id":
1125899906842627, "start_id": 1125899906842626, "properties": {}}::edge, {"id":
1125899906842627, "label": "v1", "properties": {"id": "end"}}::vertex]::path
- [{"id": 1125899906842626, "label": "v1", "properties": {"id":
"middle"}}::vertex, {"id": 1407374883553281, "label": "e1", "end_id":
1125899906842627, "start_id": 1125899906842626, "properties": {}}::edge, {"id":
1125899906842627, "label": "v1", "properties": {"id": "end"}}::vertex]::path
- [{"id": 1688849860263938, "label": "v2", "properties": {"id":
"middle"}}::vertex, {"id": 1970324836974594, "label": "e2", "end_id":
1688849860263937, "start_id": 1688849860263938, "properties": {}}::edge, {"id":
1688849860263937, "label": "v2", "properties": {"id": "initial"}}::vertex]::path
- [{"id": 1688849860263938, "label": "v2", "properties": {"id":
"middle"}}::vertex, {"id": 1970324836974594, "label": "e2", "end_id":
1688849860263937, "start_id": 1688849860263938, "properties": {}}::edge, {"id":
1688849860263937, "label": "v2", "properties": {"id": "initial"}}::vertex]::path
- [{"id": 1688849860263938, "label": "v2", "properties": {"id":
"middle"}}::vertex, {"id": 1970324836974593, "label": "e2", "end_id":
1688849860263939, "start_id": 1688849860263938, "properties": {}}::edge, {"id":
1688849860263939, "label": "v2", "properties": {"id": "end"}}::vertex]::path
- [{"id": 1688849860263938, "label": "v2", "properties": {"id":
"middle"}}::vertex, {"id": 1970324836974593, "label": "e2", "end_id":
1688849860263939, "start_id": 1688849860263938, "properties": {}}::edge, {"id":
1688849860263939, "label": "v2", "properties": {"id": "end"}}::vertex]::path
-(8 rows)
-
+ERROR: function ag_catalog._extract_label_id(bigint) does not exist
+LINE 1: SELECT * FROM cypher('cypher_match', $$
+ ^
+HINT: No function matches the given name and argument types. You might
need to add explicit type casts.
SELECT * FROM cypher('cypher_match', $$
MATCH ()<-[]-(:v2)-[]->()
MATCH p=()-[]->()
RETURN p
$$) AS (i agtype);
-
i
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
- [{"id": 1125899906842625, "label": "v1", "properties": {"id":
"initial"}}::vertex, {"id": 1407374883553282, "label": "e1", "end_id":
1125899906842626, "start_id": 1125899906842625, "properties": {}}::edge, {"id":
1125899906842626, "label": "v1", "properties": {"id": "middle"}}::vertex]::path
- [{"id": 1125899906842625, "label": "v1", "properties": {"id":
"initial"}}::vertex, {"id": 1407374883553282, "label": "e1", "end_id":
1125899906842626, "start_id": 1125899906842625, "properties": {}}::edge, {"id":
1125899906842626, "label": "v1", "properties": {"id": "middle"}}::vertex]::path
- [{"id": 1125899906842626, "label": "v1", "properties": {"id":
"middle"}}::vertex, {"id": 1407374883553281, "label": "e1", "end_id":
1125899906842627, "start_id": 1125899906842626, "properties": {}}::edge, {"id":
1125899906842627, "label": "v1", "properties": {"id": "end"}}::vertex]::path
- [{"id": 1125899906842626, "label": "v1", "properties": {"id":
"middle"}}::vertex, {"id": 1407374883553281, "label": "e1", "end_id":
1125899906842627, "start_id": 1125899906842626, "properties": {}}::edge, {"id":
1125899906842627, "label": "v1", "properties": {"id": "end"}}::vertex]::path
- [{"id": 1688849860263938, "label": "v2", "properties": {"id":
"middle"}}::vertex, {"id": 1970324836974594, "label": "e2", "end_id":
1688849860263937, "start_id": 1688849860263938, "properties": {}}::edge, {"id":
1688849860263937, "label": "v2", "properties": {"id": "initial"}}::vertex]::path
- [{"id": 1688849860263938, "label": "v2", "properties": {"id":
"middle"}}::vertex, {"id": 1970324836974594, "label": "e2", "end_id":
1688849860263937, "start_id": 1688849860263938, "properties": {}}::edge, {"id":
1688849860263937, "label": "v2", "properties": {"id": "initial"}}::vertex]::path
- [{"id": 1688849860263938, "label": "v2", "properties": {"id":
"middle"}}::vertex, {"id": 1970324836974593, "label": "e2", "end_id":
1688849860263939, "start_id": 1688849860263938, "properties": {}}::edge, {"id":
1688849860263939, "label": "v2", "properties": {"id": "end"}}::vertex]::path
- [{"id": 1688849860263938, "label": "v2", "properties": {"id":
"middle"}}::vertex, {"id": 1970324836974593, "label": "e2", "end_id":
1688849860263939, "start_id": 1688849860263938, "properties": {}}::edge, {"id":
1688849860263939, "label": "v2", "properties": {"id": "end"}}::vertex]::path
-(8 rows)
-
+ERROR: function ag_catalog._extract_label_id(bigint) does not exist
+LINE 1: SELECT * FROM cypher('cypher_match', $$
+ ^
+HINT: No function matches the given name and argument types. You might
need to add explicit type casts.
Line 409
SELECT * FROM cypher('cypher_match', $$
MATCH (:v3)-[b:e3]->()
RETURN b
$$) AS (i agtype);
- i
----------------------------------------------------------------------------------------------------------------------------
- {"id": 2533274790395905, "label": "e3", "end_id": 2251799813685250,
"start_id": 2251799813685251, "properties": {}}::edge
- {"id": 2533274790395906, "label": "e3", "end_id": 2251799813685250,
"start_id": 2251799813685249, "properties": {}}::edge
-(2 rows)
-
+ERROR: function ag_catalog._extract_label_id(bigint) does not exist
+LINE 1: SELECT * FROM cypher('cypher_match', $$
+ ^
+HINT: No function matches the given name and argument types. You might
need to add explicit type casts.
Line 466
SELECT * FROM cypher('cypher_match', $$
MATCH (a)-[]->(:v3)<-[]-(b)
where a.id = 'initial'
RETURN b
$$) AS (con_path agtype);
- con_path
-------------------------------------------------------------------------------
- {"id": 2251799813685251, "label": "v3", "properties": {"id":
"end"}}::vertex
-(1 row)
-
+ERROR: function ag_catalog._extract_label_id(bigint) does not exist
+LINE 1: SELECT * FROM cypher('cypher_match', $$
+ ^
+HINT: No function matches the given name and argument types. You might
need to add explicit type casts.
Line 554
SELECT * FROM cypher('cypher_match', $$
MATCH (a:v)
MATCH (:v1)-[]-(c)
RETURN a.i, c.id
$$) AS (i agtype, c agtype);
- i | c
----+-----------
- | "initial"
- 0 | "initial"
- 1 | "initial"
- | "middle"
- 0 | "middle"
- 1 | "middle"
- | "middle"
- 0 | "middle"
- 1 | "middle"
- | "end"
- 0 | "end"
- 1 | "end"
-(12 rows)
-
+ERROR: function ag_catalog._extract_label_id(bigint) does not exist
+LINE 1: SELECT * FROM cypher('cypher_match', $$
+ ^
+HINT: No function matches the given name and argument types. You might
need to add explicit type casts.
Line 1554
SELECT * FROM cypher('cypher_match', $$
MATCH (u:duplicate)-[]-(:other_v)
RETURN DISTINCT u
$$) AS (i agtype);
- i
---------------------------------------------------------------------------
- {"id": 3377699720527873, "label": "duplicate", "properties": {}}::vertex
-(1 row)
-
+ERROR: function ag_catalog._extract_label_id(bigint) does not exist
+LINE 1: SELECT * FROM cypher('cypher_match', $$
+ ^
+HINT: No function matches the given name and argument types. You might
need to add explicit type casts.
Line 1783
SELECT * FROM cypher('test_retrieve_var', $$
MATCH (a:A)-[r:incs]->() WITH a, r
OPTIONAL MATCH (a)-[r]->(c)
WHERE EXISTS((:A)<-[]-(c))
RETURN a, r
$$) AS (a agtype, r agtype);
- a |
r
------------------------------------------------------------------+----------------------------------------------------------------------------------------------------------------------------
- {"id": 844424930131969, "label": "A", "properties": {}}::vertex | {"id":
1125899906842625, "label": "incs", "end_id": 1407374883553281, "start_id":
844424930131969, "properties": {}}::edge
-(1 row)
-
+ERROR: function ag_catalog._extract_label_id(bigint) does not exist
+LINE 1: SELECT * FROM cypher('test_retrieve_var', $$
+ ^
+HINT: No function matches the given name and argument types. You might
need to add explicit type casts.
SELECT * FROM cypher('test_retrieve_var', $$
MATCH (a:A)-[r:incs]->() WITH a, r
OPTIONAL MATCH (a)-[r]->(c)
WHERE EXISTS((c)<-[]-(:A))
RETURN a, r
$$) AS (a agtype, r agtype);
- a |
r
------------------------------------------------------------------+----------------------------------------------------------------------------------------------------------------------------
- {"id": 844424930131969, "label": "A", "properties": {}}::vertex | {"id":
1125899906842625, "label": "incs", "end_id": 1407374883553281, "start_id":
844424930131969, "properties": {}}::edge
-(1 row)
-
+ERROR: function ag_catalog._extract_label_id(bigint) does not exist
+LINE 1: SELECT * FROM cypher('test_retrieve_var', $$
+ ^
+HINT: No function matches the given name and argument types. You might
need to add explicit type casts.
SELECT * FROM cypher('test_retrieve_var', $$
MATCH (a:A)-[r:incs]->() WITH a, r
OPTIONAL MATCH (a)-[r]->(c)
WHERE EXISTS((:C)<-[]-(:A))
RETURN a, r
$$) AS (a agtype, r agtype);
- a |
r
------------------------------------------------------------------+----------------------------------------------------------------------------------------------------------------------------
- {"id": 844424930131969, "label": "A", "properties": {}}::vertex | {"id":
1125899906842625, "label": "incs", "end_id": 1407374883553281, "start_id":
844424930131969, "properties": {}}::edge
-(1 row)
-
+ERROR: function ag_catalog._extract_label_id(bigint) does not exist
+LINE 1: SELECT * FROM cypher('test_retrieve_var', $$
+ ^
+HINT: No function matches the given name and argument types. You might
need to add explicit type casts.
```
```
--
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]
