You are viewing a plain text version of this content. The canonical link for it is here.

Posted to codereview@trafodion.apache.org by traflm <gi...@git.apache.org> on 2018/06/02 07:45:18 UTC

[GitHub] trafodion pull request #1592: Trafodion 3025 support order by with limit N i...

GitHub user traflm opened a pull request:

    https://github.com/apache/trafodion/pull/1592

    Trafodion 3025 support order by with limit N in subquery

    ORDER BY in subquery is ignored by Trafodion, when in the subquery, there is a limit N, it is good to keep the order by:
    
    select * from t ( select * from t order by c limit 20);
    
    for example

You can merge this pull request into a Git repository by running:

    $ git pull https://github.com/traflm/trafodion TRAFODION-3025

Alternatively you can review and apply these changes as the patch at:

    https://github.com/apache/trafodion/pull/1592.patch

To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:

    This closes #1592
    
----
commit e45745fece09450f59a1adebc7b3413b35e54c50
Author: Liu Ming <ov...@...>
Date:   2018-06-02T06:37:54Z

    [TRAFODION-3025] support order by in subquery if there is limit N

commit fda906dcd94ff28957b32c825e04206e57160841
Author: Liu Ming <ov...@...>
Date:   2018-06-02T07:33:32Z

    add test

----


---

[GitHub] trafodion pull request #1592: TRAFODION-3025 support order by with limit N i...

Posted by asfgit <gi...@git.apache.org>.

Github user asfgit closed the pull request at:

    https://github.com/apache/trafodion/pull/1592


---