You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@age.apache.org by "MuhammadTahaNaveed (via GitHub)" <gi...@apache.org> on 2023/04/12 11:34:38 UTC

[GitHub] [age] MuhammadTahaNaveed opened a new issue, #801: ORDER BY alias does not work with RETURN AS alias

MuhammadTahaNaveed opened a new issue, #801:
URL: https://github.com/apache/age/issues/801

   **Describe the bug**
   ORDER BY alias does not work with RETURN AS alias
   
   **How are you accessing AGE (Command line, driver, etc.)?**
   - Command Line
   
   **What data setup do we need to do?**
   ```pgsql
   SELECT * FROM cypher('graph', $$
       CREATE (:opt_match_v {name: 'someone'})-[:opt_match_e]->(:opt_match_v {name: 'somebody'}),
              (:opt_match_v {name: 'anybody'})-[:opt_match_e]->(:opt_match_v {name: 'nobody'})
   $$) AS (u agtype);
   ```
   
   **What is the command that caused the error?**
   ```pgsql
   SELECT * FROM cypher('graph', $$
       MATCH p=(n)-[]->(m)
       RETURN n.name as u
       ORDER BY u
   $$) AS (u agtype);
   ```
   ```
   ERROR:  could not find rte for u
   LINE 2:     MATCH p=(n)-[]->(m) RETURN n.name as u ORDER BY u
                                                               ^
   ```
   
   **Expected behavior**
   Expected order by to work
   
   **Environment (please complete the following information):**
   - latest
   


-- 
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-unsubscribe@age.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [age] jrgemignani commented on issue #801: ORDER BY alias does not work with RETURN AS alias

Posted by "jrgemignani (via GitHub)" <gi...@apache.org>.
jrgemignani commented on issue #801:
URL: https://github.com/apache/age/issues/801#issuecomment-1509413464

   @MuhammadTahaNaveed Will you be working on a PR to fix this? Just wondering.


-- 
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-unsubscribe@age.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [age] MuhammadTahaNaveed commented on issue #801: ORDER BY alias does not work with RETURN AS alias

Posted by "MuhammadTahaNaveed (via GitHub)" <gi...@apache.org>.
MuhammadTahaNaveed commented on issue #801:
URL: https://github.com/apache/age/issues/801#issuecomment-1509698677

   @jrgemignani Yes, I am working on this issue.


-- 
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-unsubscribe@age.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

Re: [I] ORDER BY alias does not work with RETURN AS alias [age]

Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on issue #801:
URL: https://github.com/apache/age/issues/801#issuecomment-2105397746

   This issue is stale because it has been open 45 days with no activity. Remove "Abondoned" label or comment or this will be closed in 7 days.


-- 
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-unsubscribe@age.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org