[asterixdb] 17/23: Merge branch 'gerrit/mad-hatter'

[mb...@apache.org]

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 <mu...@couchbase.com>
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
+