MuhammadTahaNaveed opened a new issue, #693:
URL: https://github.com/apache/age/issues/693
**Describe the bug**
Returning exists(path) terminates the server.
**How are you accessing AGE (Command line, driver, etc.)?**
- Command Line
**What data setup do we need to do?**
```pgsql
SELECT * FROM cypher('new_issue',$$
CREATE (n:City {name:'Islamabad'}),
(m:Country {name:'Pakistan'}),
(n)-[:isin]->(m)
$$) as (a agtype);
```
**What is the command that caused the error?**
```pgsql
SELECT * FROM cypher('new_issue', $$
MATCH (n:City)
RETURN exists((n)-[]->())
$$) as (a agtype);
```
```
server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
The connection to the server was lost. Attempting reset: 2023-02-20
23:27:32.099 PKT [18622] LOG: server process (PID 18654) was terminated by
signal 6: Aborted
2023-02-20 23:27:32.099 PKT [18622] DETAIL: Failed process was running:
SELECT *
FROM cypher('check', $$
MATCH (n:City)
RETURN exists((n)-[]->())
$$) as (full_name agtype);
2023-02-20 23:27:32.099 PKT [18622] LOG: terminating any other active
server processes
2023-02-20 23:27:32.099 PKT [18629] WARNING: terminating connection because
of crash of another server process
2023-02-20 23:27:32.099 PKT [18629] DETAIL: The postmaster has commanded
this server process to roll back the current transaction and exit, because
another server process exited abnormally and possibly corrupted shared memory.
2023-02-20 23:27:32.099 PKT [18629] HINT: In a moment you should be able to
reconnect to the database and repeat your command.
2023-02-20 23:27:32.100 PKT [18957] FATAL: the database system is in
recovery mode
Failed.
!> 2023-02-20 23:27:32.100 PKT [18622] LOG: all server processes
terminated; reinitializing
2023-02-20 23:27:32.113 PKT [18959] LOG: database system was interrupted;
last known up at 2023-02-20 23:24:09 PKT
2023-02-20 23:27:32.499 PKT [18959] LOG: database system was not properly
shut down; automatic recovery in progress
2023-02-20 23:27:32.505 PKT [18959] LOG: redo starts at 0/EBFA818
2023-02-20 23:27:32.505 PKT [18959] LOG: invalid record length at
0/EBFA8F8: wanted 24, got 0
2023-02-20 23:27:32.505 PKT [18959] LOG: redo done at 0/EBFA8C0
2023-02-20 23:27:32.546 PKT [18622] LOG: database system is ready to accept
connections
^Z
[10]+ Stopped pgsql/bin/psql cypher
```
**Expected behavior**
expected boolean value `true`
**Environment (please complete the following information):**
- Version : 1.2.0
--
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]
