MironAtHome opened a new issue, #1629:
URL: https://github.com/apache/age/issues/1629
**Describe the bug**
Statement below does not return rows, should return
LOAD 'age';
SET search_path TO ag_catalog;
SELECT create_graph('test_graph');
-- SELECT drop_label('test_graph', 'vertice1');
-- SELECT drop_label('test_graph', 'vertice2');
-- SELECT drop_label('test_graph', 'edge1');
SELECT create_vlabel('test_graph', 'vertice1');
SELECT create_vlabel('test_graph', 'vertice2');
SELECT create_elabel('test_graph', 'edge1');
SELECT * FROM cypher(
'test_graph'
, $$
MATCH (a:vertice1)
RETURN a
$$
) AS (a agtype);
SELECT * FROM cypher(
'test_graph'
, $$
MATCH (a:vertice2)
RETURN a
$$
) AS (a agtype);
SELECT * FROM cypher(
'test_graph'
, $$
CREATE (a:vertice1 {vertice_name:'first'})
RETURN a
$$
) AS (a agtype);
SELECT * FROM cypher(
'test_graph'
, $$
OPTIONAL MATCH (a:vertice1), (b:vertice2)
RETURN a, b
$$
) AS (a agtype, b agtype);
**How are you accessing AGE (Command line, driver, etc.)?**
- PGAdmin4
**What data setup do we need to do?**
```please see top section with bug description, it has the script to create
needed data structure and data
**What is the necessary configuration info needed?**
- Postgres version 14 Age release version 1.5.0
**What is the command that caused the error?**
```pgsql
SELECT * FROM cypher(
'test_graph'
, $$
OPTIONAL MATCH (a:vertice1), (b:vertice2)
RETURN a, b
$$
) AS (a agtype, b agtype);
```
```
ERROR: no rows produced
```
**Expected behavior**
value produced for vertice1, NULL produced for vertice2
**Environment (please complete the following information):**
- Version: 1.5.0
**Additional context**
Clarification using brief search on the web:
Please note, I do not consider this source of information to be
authoritative, but I have a hunch that in this case it's close enough to main
to call it out. Feel free to find clarification in anything that looks more
like a standard that would render me wrong.
--
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.apache.org
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org
