dianaoa22 opened a new issue, #1988:
URL: https://github.com/apache/age/issues/1988
**Describe the bug**
Reserved Keyword Handling- Here below I have a graph test_graph with
property match--keyword but I don't seem to have a way to update it.
nspdb=# SELECT *
nspdb-# FROM cypher('test_graph', $$
nspdb$# MATCH (n:Person)
nspdb$# RETURN n LIMIT 5
nspdb$# $$) AS (v agtype);
v
----------------------------------------------------------------------------------------------------------------------------------------------------
{"id": 3940649673949185, "label": "Person", "properties": {"id": 123,
"city": "Lagos", "name": "Daniel", "match": "test", "title": "xyz"}}::vertex
(1 row)
nspdb=# SELECT * FROM cypher('test_graph', $$ MATCH (n:Person { id: 123 })
SET n.`match` = 'xyz' $$) as (v agtype);
ERROR: syntax error at or near "="
LINE 1: ...h', $$ MATCH (n:Person { id: 123 }) SET n.`match` = 'xyz' ...
^
**How are you accessing AGE (Command line, driver, etc.)?**
- [e.g. JDBC]
**What data setup do we need to do?**
```pgsql
...
SELECT * from cypher('my_graph_name', $$
CREATE (a:Part {part_num: '123'}),
(b:Part {part_num: '345'}),
(c:Part {part_num: '456'}),
(d:Part {part_num: '789'})
$$) as (a agtype);
...
```
**What is the necessary configuration info needed?**
- [e.g. Installed PostGIS]
**What is the command that caused the error?**
```pgsql
SELECT * from cypher('my_graph_name', $$
MATCH (a:Part {part_num: '123'}), (b:Part {part_num: '345'})
CREATE (a)-[u:used_by { quantity: 1 }]->(b)
$$) as (a agtype);
```
```
ERROR: something failed to execute
```
**Expected behavior**
A clear and concise description of what you expected to happen.
**Environment (please complete the following information):**
- Version: [e.g. 0.4.0]
**Additional context**
Add any other context about the problem here.
--
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]
