jrgemignani commented on issue #2193:
URL: https://github.com/apache/age/issues/2193#issuecomment-3058235296
@AnnXie2001 Verified in the master. It seems to happen with this command to
any **new** label. While the command does not execute correctly the first time,
it does create the new label which allows the command to execute correctly the
second time -
```
psql-16.2-5432-pgsql=# SELECT * FROM ag_catalog.create_graph('issue_2193');
NOTICE: graph "issue_2193" has been created
create_graph
--------------
(1 row)
psql-16.2-5432-pgsql=# select * from cypher('issue_2193', $$ match (u)
return u $$) as (result agtype);
result
--------
(0 rows)
psql-16.2-5432-pgsql=# select * from ag_label where relation::text like
'%issue%';
name | graph | id | kind | relation |
seq_name
------------------+-------+----+------+-----------------------------+-------------------------
_ag_label_vertex | 17181 | 1 | v | issue_2193._ag_label_vertex |
_ag_label_vertex_id_seq
_ag_label_edge | 17181 | 2 | e | issue_2193._ag_label_edge |
_ag_label_edge_id_seq
(2 rows)
psql-16.2-5432-pgsql=# SELECT * FROM cypher('issue_2193', $$
CREATE (a:abc {name: 'Jane', livesIn: 'London'}), (b:abc {name: 'Tom',
livesIn: 'Copenhagen'})
WITH a, b MATCH (p:abc) RETURN p.name $$) AS (result agtype);
result
--------
(0 rows)
psql-16.2-5432-pgsql=# SELECT * FROM cypher('issue_2193', $$
CREATE (a:def {name: 'Jane', livesIn: 'London'}), (b:def {name: 'Tom',
livesIn: 'Copenhagen'})
WITH a, b MATCH (p:def) RETURN p.name $$) AS (result agtype);
result
--------
(0 rows)
psql-16.2-5432-pgsql=# select * from ag_label where relation::text like
'%issue%';
name | graph | id | kind | relation |
seq_name
------------------+-------+----+------+-----------------------------+-------------------------
_ag_label_vertex | 17181 | 1 | v | issue_2193._ag_label_vertex |
_ag_label_vertex_id_seq
_ag_label_edge | 17181 | 2 | e | issue_2193._ag_label_edge |
_ag_label_edge_id_seq
abc | 17181 | 3 | v | issue_2193.abc |
abc_id_seq
def | 17181 | 4 | v | issue_2193.def |
def_id_seq
(4 rows)
psql-16.2-5432-pgsql=# select create_vlabel('issue_2193','ghi');
NOTICE: VLabel "ghi" has been created
create_vlabel
---------------
(1 row)
psql-16.2-5432-pgsql=# SELECT * FROM cypher('issue_2193', $$
CREATE (a:ghi {name: 'Jane', livesIn: 'London'}), (b:ghi {name: 'Tom',
livesIn: 'Copenhagen'})
WITH a, b MATCH (p:ghi) RETURN p.name $$) AS (result agtype);
result
--------
"Jane"
"Tom"
(2 rows)
psql-16.2-5432-pgsql=#
```
--
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
