Match with order by can not return the node #189
Description
Describe the bug
A clear and concise description of what the bug is.
How are you accessing AGE (Command line, driver, etc.)?
- [e.g. JDBC]
What data setup do we need to do?
SELECT * from cypher('agegraph', $$ MATCH (n) RETURN n $$) as (n agtype);
+-----------------------------------------------------------------------+
| n |
|-----------------------------------------------------------------------|
| {"id": 281474976710662, "label": "", "properties": {"id": 1}}::vertex |
| {"id": 281474976710663, "label": "", "properties": {"id": 2}}::vertex |
| {"id": 281474976710664, "label": "", "properties": {"id": 3}}::vertex |
+-----------------------------------------------------------------------+
...What is the necessary configuration info needed?
- [e.g. Installed PostGIS]
What is the command that caused the error?
memflask_dev> SELECT * from cypher('agegraph', $$ MATCH (n) ORDER BY n.id RETURN n $$) as (n agtype);
syntax error at or near "ORDER"
LINE 1: SELECT * from cypher('agegraph', $$ MATCH (n) ORDER BY n.id ...```
**Expected behavior**
A clear and concise description of what you expected to happen.
**Environment (please complete the following information):**
- Version: [e.g. 0.7.0]
**Additional context**
Add any other context about the problem here.