This is an automated email from the ASF dual-hosted git repository. mblow pushed a commit to branch master in repository https://gitbox.apache.org/repos/asf/asterixdb.git
commit 7b90dd638660ba1d09c8c3f3e908b8c394c710b7 Merge: 11acb53 02a1424 Author: Murtadha Hubail <[email protected]> AuthorDate: Sun Jun 27 20:58:25 2021 +0300 Merge branch 'gerrit/mad-hatter' Change-Id: I2a3075ab4c6a84fa12fce114cceae2bec46fe04a .../window/misc_01/misc_01.10.query.sqlpp | 34 +++++++++++ .../results/window/misc_01/misc_01.10.adm | 4 ++ .../window/misc_01/misc_01.10.ast | 71 ++++++++++++++++++++++ .../SqlppWindowAggregationSugarVisitor.java | 7 ++- 4 files changed, 114 insertions(+), 2 deletions(-) diff --cc asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/window/misc_01/misc_01.10.ast index 0000000,368f261..a6cbed7 mode 000000,100644..100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/window/misc_01/misc_01.10.ast +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/window/misc_01/misc_01.10.ast @@@ -1,0 -1,50 +1,71 @@@ + DataverseUse test + Query: + SELECT [ + FieldAccessor [ + Variable [ Name=$y ] + Field=c2 + ] + c2 + ( + SELECT [ - WINDOW test.nth_value@2[ - Variable [ Name=$c2 ] ++ WINDOW asterix.nth-value-impl@3[ ++ ( ++ SELECT ELEMENT [ ++ FieldAccessor [ ++ FieldAccessor [ ++ Variable [ Name=#2 ] ++ Field=x ++ ] ++ Field=c2 ++ ] ++ ] ++ FROM [ Variable [ Name=#1 ] ++ AS Variable [ Name=#2 ] ++ ] ++ ) + LiteralExpr [LONG] [3] ++ FieldAccessor [ ++ Variable [ Name=$x ] ++ Field=c2 ++ ] + ] ++ AS Variable [ Name=#1 ] ++ ( ++ x:=Variable [ Name=$x ] ++ ) + OVER ( + PARTITION BY + FieldAccessor [ + Variable [ Name=$x ] + Field=one + ] + ORDER BY + FieldAccessor [ + Variable [ Name=$x ] + Field=c2 + ] + ASC + range between unbounded preceding and unbounded following exclude no others + ) + nth + ] + FROM [ FunctionCall asterix.dataset@1[ + LiteralExpr [STRING] [test.t1] + ] + AS Variable [ Name=$x ] + ] + ) + q1 + ] + FROM [ FunctionCall asterix.dataset@1[ + LiteralExpr [STRING] [test.t1] + ] + AS Variable [ Name=$y ] + ] + Orderby + FieldAccessor [ + Variable [ Name=$y ] + Field=c2 + ] + ASC +
