Changeset: 95189d82517f for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/95189d82517f Modified Files: sql/test/BugTracker/Tests/with_row_number.SF-1898089.test Branch: default Log Message:
keep output ordered diffs (21 lines): diff --git a/sql/test/BugTracker/Tests/with_row_number.SF-1898089.test b/sql/test/BugTracker/Tests/with_row_number.SF-1898089.test --- a/sql/test/BugTracker/Tests/with_row_number.SF-1898089.test +++ b/sql/test/BugTracker/Tests/with_row_number.SF-1898089.test @@ -32633,7 +32633,7 @@ WITH e as (SELECT date, row_number() ove 5 query IIII nosort -WITH e as (SELECT date, row_number() over (order by date) as rn from tradeDate) SELECT e1.date, e1.rn, e2.date, e2.rn from e as e1 inner join e as e2 ON e2.rn = e1.rn limit 5 +WITH e as (SELECT date, row_number() over (order by date) as rn from tradeDate) SELECT e1.date, e1.rn, e2.date, e2.rn from e as e1 inner join e as e2 ON e2.rn = e1.rn order by e1.rn, e2.rn limit 5 ---- 19251231 1 @@ -32657,7 +32657,7 @@ WITH e as (SELECT date, row_number() ove 5 query IIII nosort -WITH e as (SELECT date, row_number() over (order by date) as rn from tradeDate) SELECT e1.date, e1.rn, e2.date, e2.rn from e as e1 inner join e as e2 ON e2.rn + 1 = e1.rn limit 5 +WITH e as (SELECT date, row_number() over (order by date) as rn from tradeDate) SELECT e1.date, e1.rn, e2.date, e2.rn from e as e1 inner join e as e2 ON e2.rn + 1 = e1.rn order by e1.rn, e2.rn limit 5 ---- 19260102 2 _______________________________________________ checkin-list mailing list -- [email protected] To unsubscribe send an email to [email protected]
