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 <ovis_poly@...>
Date: 2018-06-02T06:37:54Z
[TRAFODION-3025] support order by in subquery if there is limit N
commit fda906dcd94ff28957b32c825e04206e57160841
Author: Liu Ming <ovis_poly@...>
Date: 2018-06-02T07:33:32Z
add test
----
---
