asterixdb-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From buyin...@apache.org
Subject [06/34] incubator-asterixdb git commit: SQL++ support in AsterixDB: 1. implemented SQL++ expression to logical plan translator; 2. refactored REST API to be agnostic of query languages; 3. disabled fuzzy join queries for SQL++ runtime tests; 4. fixed sev
Date Tue, 17 Nov 2015 00:56:38 GMT
http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/caea8f0e/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/temporal/interval_functions/interval_functions.3.ast
----------------------------------------------------------------------
diff --git a/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/temporal/interval_functions/interval_functions.3.ast b/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/temporal/interval_functions/interval_functions.3.ast
index 338c5fe..e85501d 100644
--- a/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/temporal/interval_functions/interval_functions.3.ast
+++ b/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/temporal/interval_functions/interval_functions.3.ast
@@ -1,398 +1,409 @@
 DataverseUse test
 Query:
+LetVariable [ Name=itv1 ]
+  :=
+  FunctionCall test.interval-from-date@2[
+    LiteralExpr [STRING] [2010-10-30]
+    LiteralExpr [STRING] [2010-12-21]
+  ]
+LetVariable [ Name=itv2 ]
+  :=
+  FunctionCall test.interval-from-date@2[
+    LiteralExpr [STRING] [2011-10-30]
+    LiteralExpr [STRING] [2012-10-21]
+  ]
+LetVariable [ Name=itv3 ]
+  :=
+  FunctionCall test.interval-from-date@2[
+    LiteralExpr [STRING] [2010-12-21]
+    LiteralExpr [STRING] [2013-01-01]
+  ]
+LetVariable [ Name=blnBefore1 ]
+  :=
+  FunctionCall test.interval-before@2[
+    Variable [ Name=itv1 ]
+    Variable [ Name=itv2 ]
+  ]
+LetVariable [ Name=blnAfter1 ]
+  :=
+  FunctionCall test.interval-after@2[
+    Variable [ Name=itv2 ]
+    Variable [ Name=itv1 ]
+  ]
+LetVariable [ Name=blnBefore2 ]
+  :=
+  FunctionCall test.interval-before@2[
+    Variable [ Name=itv1 ]
+    Variable [ Name=itv3 ]
+  ]
+LetVariable [ Name=blnAfter2 ]
+  :=
+  FunctionCall test.interval-after@2[
+    Variable [ Name=itv3 ]
+    Variable [ Name=itv1 ]
+  ]
+LetVariable [ Name=itv4 ]
+  :=
+  FunctionCall test.interval-from-datetime@2[
+    LiteralExpr [STRING] [2012-06-26T01:01:01.111]
+    LiteralExpr [STRING] [2012-07-27T02:02:02.222]
+  ]
+LetVariable [ Name=itv5 ]
+  :=
+  FunctionCall test.interval-from-datetime@2[
+    LiteralExpr [STRING] [20120727T020202222]
+    LiteralExpr [STRING] [2013-08-08T03:03:03.333]
+  ]
+LetVariable [ Name=itv6 ]
+  :=
+  FunctionCall test.interval-from-datetime@2[
+    LiteralExpr [STRING] [19000707T020202222]
+    LiteralExpr [STRING] [2013-08-07T03:03:03.333]
+  ]
+LetVariable [ Name=blnMeet1 ]
+  :=
+  FunctionCall test.interval-meets@2[
+    Variable [ Name=itv4 ]
+    Variable [ Name=itv5 ]
+  ]
+LetVariable [ Name=blnMetBy1 ]
+  :=
+  FunctionCall test.interval-met-by@2[
+    Variable [ Name=itv5 ]
+    Variable [ Name=itv4 ]
+  ]
+LetVariable [ Name=blnMeet2 ]
+  :=
+  FunctionCall test.interval-meets@2[
+    Variable [ Name=itv6 ]
+    Variable [ Name=itv4 ]
+  ]
+LetVariable [ Name=blnMetBy2 ]
+  :=
+  FunctionCall test.interval-met-by@2[
+    Variable [ Name=itv6 ]
+    Variable [ Name=itv4 ]
+  ]
+LetVariable [ Name=itv7 ]
+  :=
+  FunctionCall test.interval-from-time@2[
+    LiteralExpr [STRING] [12:32:38]
+    LiteralExpr [STRING] [20:29:20]
+  ]
+LetVariable [ Name=itv8 ]
+  :=
+  FunctionCall test.interval-from-time@2[
+    LiteralExpr [STRING] [17:48:19]
+    LiteralExpr [STRING] [22:19:49]
+  ]
+LetVariable [ Name=itv9 ]
+  :=
+  FunctionCall test.interval-from-time@2[
+    LiteralExpr [STRING] [01:32:49]
+    LiteralExpr [STRING] [17:48:19]
+  ]
+LetVariable [ Name=blnOverlaps1 ]
+  :=
+  FunctionCall test.interval-overlaps@2[
+    Variable [ Name=itv7 ]
+    Variable [ Name=itv8 ]
+  ]
+LetVariable [ Name=blnOverlapped1 ]
+  :=
+  FunctionCall test.interval-overlapped-by@2[
+    Variable [ Name=itv8 ]
+    Variable [ Name=itv7 ]
+  ]
+LetVariable [ Name=blnOverlaps2 ]
+  :=
+  FunctionCall test.interval-overlaps@2[
+    Variable [ Name=itv9 ]
+    Variable [ Name=itv8 ]
+  ]
+LetVariable [ Name=blnOverlapped2 ]
+  :=
+  FunctionCall test.interval-overlapped-by@2[
+    Variable [ Name=itv8 ]
+    Variable [ Name=itv9 ]
+  ]
+LetVariable [ Name=blnOverlap1 ]
+  :=
+  FunctionCall test.interval-overlapping@2[
+    Variable [ Name=itv9 ]
+    Variable [ Name=itv7 ]
+  ]
+LetVariable [ Name=blnOverlap2 ]
+  :=
+  FunctionCall test.interval-overlapping@2[
+    Variable [ Name=itv9 ]
+    Variable [ Name=itv8 ]
+  ]
+LetVariable [ Name=itv10 ]
+  :=
+  FunctionCall test.interval-from-date@2[
+    LiteralExpr [STRING] [2010-10-30]
+    LiteralExpr [STRING] [2010-11-30]
+  ]
+LetVariable [ Name=blnStarts1 ]
+  :=
+  FunctionCall test.interval-starts@2[
+    Variable [ Name=itv10 ]
+    Variable [ Name=itv1 ]
+  ]
+LetVariable [ Name=blnStarts2 ]
+  :=
+  FunctionCall test.interval-starts@2[
+    Variable [ Name=itv10 ]
+    Variable [ Name=itv2 ]
+  ]
+LetVariable [ Name=blnStartedBy1 ]
+  :=
+  FunctionCall test.interval-started-by@2[
+    Variable [ Name=itv1 ]
+    Variable [ Name=itv10 ]
+  ]
+LetVariable [ Name=blnStartedBy2 ]
+  :=
+  FunctionCall test.interval-started-by@2[
+    Variable [ Name=itv10 ]
+    Variable [ Name=itv2 ]
+  ]
+LetVariable [ Name=itv10 ]
+  :=
+  FunctionCall test.interval-from-datetime@2[
+    LiteralExpr [STRING] [19000707T020202222]
+    LiteralExpr [STRING] [2013-08-07T03:03:03.333]
+  ]
+LetVariable [ Name=itv11 ]
+  :=
+  FunctionCall test.interval-from-datetime@2[
+    LiteralExpr [STRING] [19990707T020202222]
+    LiteralExpr [STRING] [2013-08-07T03:03:03.333]
+  ]
+LetVariable [ Name=itv12 ]
+  :=
+  FunctionCall test.interval-from-datetime@2[
+    LiteralExpr [STRING] [-19990707T020202222]
+    LiteralExpr [STRING] [2013-08-07T03:03:03.333]
+  ]
+LetVariable [ Name=blnCovers1 ]
+  :=
+  FunctionCall test.interval-covers@2[
+    Variable [ Name=itv10 ]
+    Variable [ Name=itv11 ]
+  ]
+LetVariable [ Name=blnCovers2 ]
+  :=
+  FunctionCall test.interval-covers@2[
+    Variable [ Name=itv10 ]
+    Variable [ Name=itv12 ]
+  ]
+LetVariable [ Name=blnCoveredBy1 ]
+  :=
+  FunctionCall test.interval-covered-by@2[
+    Variable [ Name=itv11 ]
+    Variable [ Name=itv10 ]
+  ]
+LetVariable [ Name=blnCoveredBy2 ]
+  :=
+  FunctionCall test.interval-covered-by@2[
+    Variable [ Name=itv12 ]
+    Variable [ Name=itv10 ]
+  ]
+LetVariable [ Name=itv11 ]
+  :=
+  FunctionCall test.interval-from-time@2[
+    LiteralExpr [STRING] [19:00:00.009]
+    LiteralExpr [STRING] [20:29:20.000]
+  ]
+LetVariable [ Name=blnEnds1 ]
+  :=
+  FunctionCall test.interval-ends@2[
+    Variable [ Name=itv11 ]
+    Variable [ Name=itv7 ]
+  ]
+LetVariable [ Name=blnEnds2 ]
+  :=
+  FunctionCall test.interval-ends@2[
+    Variable [ Name=itv11 ]
+    Variable [ Name=itv8 ]
+  ]
+LetVariable [ Name=blnEndedBy1 ]
+  :=
+  FunctionCall test.interval-ended-by@2[
+    Variable [ Name=itv7 ]
+    Variable [ Name=itv11 ]
+  ]
+LetVariable [ Name=blnEndedBy2 ]
+  :=
+  FunctionCall test.interval-ended-by@2[
+    Variable [ Name=itv8 ]
+    Variable [ Name=itv11 ]
+  ]
+LetVariable [ Name=null1 ]
+  :=
+  FunctionCall test.interval-before@2[
+    LiteralExpr [NULL]
+    Variable [ Name=itv2 ]
+  ]
+LetVariable [ Name=null2 ]
+  :=
+  FunctionCall test.interval-covered-by@2[
+    Variable [ Name=itv11 ]
+    LiteralExpr [NULL]
+  ]
+LetVariable [ Name=null3 ]
+  :=
+  FunctionCall test.interval-overlapping@2[
+    LiteralExpr [NULL]
+    LiteralExpr [NULL]
+  ]
+SELECT ELEMENT [
 RecordConstructor [
   (
     LiteralExpr [STRING] [before1]
     :
-    FunctionCall test.interval-before@2[
-      FunctionCall test.interval-from-date@2[
-        LiteralExpr [STRING] [2010-10-30]
-        LiteralExpr [STRING] [2010-12-21]
-      ]
-      FunctionCall test.interval-from-date@2[
-        LiteralExpr [STRING] [2011-10-30]
-        LiteralExpr [STRING] [2012-10-21]
-      ]
-    ]
+    Variable [ Name=blnBefore1 ]
   )
   (
     LiteralExpr [STRING] [before2]
     :
-    FunctionCall test.interval-before@2[
-      FunctionCall test.interval-from-date@2[
-        LiteralExpr [STRING] [2010-10-30]
-        LiteralExpr [STRING] [2010-12-21]
-      ]
-      FunctionCall test.interval-from-date@2[
-        LiteralExpr [STRING] [2010-12-21]
-        LiteralExpr [STRING] [2013-01-01]
-      ]
-    ]
+    Variable [ Name=blnBefore2 ]
   )
   (
     LiteralExpr [STRING] [after1]
     :
-    FunctionCall test.interval-after@2[
-      FunctionCall test.interval-from-date@2[
-        LiteralExpr [STRING] [2011-10-30]
-        LiteralExpr [STRING] [2012-10-21]
-      ]
-      FunctionCall test.interval-from-date@2[
-        LiteralExpr [STRING] [2010-10-30]
-        LiteralExpr [STRING] [2010-12-21]
-      ]
-    ]
+    Variable [ Name=blnAfter1 ]
   )
   (
     LiteralExpr [STRING] [after2]
     :
-    FunctionCall test.interval-after@2[
-      FunctionCall test.interval-from-date@2[
-        LiteralExpr [STRING] [2010-12-21]
-        LiteralExpr [STRING] [2013-01-01]
-      ]
-      FunctionCall test.interval-from-date@2[
-        LiteralExpr [STRING] [2010-10-30]
-        LiteralExpr [STRING] [2010-12-21]
-      ]
-    ]
+    Variable [ Name=blnAfter2 ]
   )
   (
     LiteralExpr [STRING] [meet1]
     :
-    FunctionCall test.interval-meets@2[
-      FunctionCall test.interval-from-datetime@2[
-        LiteralExpr [STRING] [2012-06-26T01:01:01.111]
-        LiteralExpr [STRING] [2012-07-27T02:02:02.222]
-      ]
-      FunctionCall test.interval-from-datetime@2[
-        LiteralExpr [STRING] [20120727T020202222]
-        LiteralExpr [STRING] [2013-08-08T03:03:03.333]
-      ]
-    ]
+    Variable [ Name=blnMeet1 ]
   )
   (
     LiteralExpr [STRING] [meet2]
     :
-    FunctionCall test.interval-meets@2[
-      FunctionCall test.interval-from-datetime@2[
-        LiteralExpr [STRING] [19000707T020202222]
-        LiteralExpr [STRING] [2013-08-07T03:03:03.333]
-      ]
-      FunctionCall test.interval-from-datetime@2[
-        LiteralExpr [STRING] [2012-06-26T01:01:01.111]
-        LiteralExpr [STRING] [2012-07-27T02:02:02.222]
-      ]
-    ]
+    Variable [ Name=blnMeet2 ]
   )
   (
     LiteralExpr [STRING] [metby1]
     :
-    FunctionCall test.interval-met-by@2[
-      FunctionCall test.interval-from-datetime@2[
-        LiteralExpr [STRING] [20120727T020202222]
-        LiteralExpr [STRING] [2013-08-08T03:03:03.333]
-      ]
-      FunctionCall test.interval-from-datetime@2[
-        LiteralExpr [STRING] [2012-06-26T01:01:01.111]
-        LiteralExpr [STRING] [2012-07-27T02:02:02.222]
-      ]
-    ]
+    Variable [ Name=blnMetBy1 ]
   )
   (
     LiteralExpr [STRING] [metby2]
     :
-    FunctionCall test.interval-met-by@2[
-      FunctionCall test.interval-from-datetime@2[
-        LiteralExpr [STRING] [19000707T020202222]
-        LiteralExpr [STRING] [2013-08-07T03:03:03.333]
-      ]
-      FunctionCall test.interval-from-datetime@2[
-        LiteralExpr [STRING] [2012-06-26T01:01:01.111]
-        LiteralExpr [STRING] [2012-07-27T02:02:02.222]
-      ]
-    ]
+    Variable [ Name=blnMetBy2 ]
   )
   (
     LiteralExpr [STRING] [overlaps1]
     :
-    FunctionCall test.interval-overlaps@2[
-      FunctionCall test.interval-from-time@2[
-        LiteralExpr [STRING] [12:32:38]
-        LiteralExpr [STRING] [20:29:20]
-      ]
-      FunctionCall test.interval-from-time@2[
-        LiteralExpr [STRING] [17:48:19]
-        LiteralExpr [STRING] [22:19:49]
-      ]
-    ]
+    Variable [ Name=blnOverlaps1 ]
   )
   (
     LiteralExpr [STRING] [overlaps2]
     :
-    FunctionCall test.interval-overlaps@2[
-      FunctionCall test.interval-from-time@2[
-        LiteralExpr [STRING] [01:32:49]
-        LiteralExpr [STRING] [17:48:19]
-      ]
-      FunctionCall test.interval-from-time@2[
-        LiteralExpr [STRING] [17:48:19]
-        LiteralExpr [STRING] [22:19:49]
-      ]
-    ]
+    Variable [ Name=blnOverlaps2 ]
   )
   (
     LiteralExpr [STRING] [overlapped1]
     :
-    FunctionCall test.interval-overlapped-by@2[
-      FunctionCall test.interval-from-time@2[
-        LiteralExpr [STRING] [17:48:19]
-        LiteralExpr [STRING] [22:19:49]
-      ]
-      FunctionCall test.interval-from-time@2[
-        LiteralExpr [STRING] [12:32:38]
-        LiteralExpr [STRING] [20:29:20]
-      ]
-    ]
+    Variable [ Name=blnOverlapped1 ]
   )
   (
     LiteralExpr [STRING] [overlapped2]
     :
-    FunctionCall test.interval-overlapped-by@2[
-      FunctionCall test.interval-from-time@2[
-        LiteralExpr [STRING] [17:48:19]
-        LiteralExpr [STRING] [22:19:49]
-      ]
-      FunctionCall test.interval-from-time@2[
-        LiteralExpr [STRING] [01:32:49]
-        LiteralExpr [STRING] [17:48:19]
-      ]
-    ]
+    Variable [ Name=blnOverlapped2 ]
   )
   (
     LiteralExpr [STRING] [overlap1]
     :
-    FunctionCall test.interval-overlapping@2[
-      FunctionCall test.interval-from-time@2[
-        LiteralExpr [STRING] [01:32:49]
-        LiteralExpr [STRING] [17:48:19]
-      ]
-      FunctionCall test.interval-from-time@2[
-        LiteralExpr [STRING] [12:32:38]
-        LiteralExpr [STRING] [20:29:20]
-      ]
-    ]
+    Variable [ Name=blnOverlap1 ]
   )
   (
     LiteralExpr [STRING] [overlap2]
     :
-    FunctionCall test.interval-overlapping@2[
-      FunctionCall test.interval-from-time@2[
-        LiteralExpr [STRING] [01:32:49]
-        LiteralExpr [STRING] [17:48:19]
-      ]
-      FunctionCall test.interval-from-time@2[
-        LiteralExpr [STRING] [17:48:19]
-        LiteralExpr [STRING] [22:19:49]
-      ]
-    ]
+    Variable [ Name=blnOverlap2 ]
   )
   (
     LiteralExpr [STRING] [starts1]
     :
-    FunctionCall test.interval-starts@2[
-      FunctionCall test.interval-from-date@2[
-        LiteralExpr [STRING] [2010-10-30]
-        LiteralExpr [STRING] [2010-11-30]
-      ]
-      FunctionCall test.interval-from-date@2[
-        LiteralExpr [STRING] [2010-10-30]
-        LiteralExpr [STRING] [2010-12-21]
-      ]
-    ]
+    Variable [ Name=blnStarts1 ]
   )
   (
     LiteralExpr [STRING] [starts2]
     :
-    FunctionCall test.interval-starts@2[
-      FunctionCall test.interval-from-date@2[
-        LiteralExpr [STRING] [2010-10-30]
-        LiteralExpr [STRING] [2010-11-30]
-      ]
-      FunctionCall test.interval-from-date@2[
-        LiteralExpr [STRING] [2011-10-30]
-        LiteralExpr [STRING] [2012-10-21]
-      ]
-    ]
+    Variable [ Name=blnStarts2 ]
   )
   (
     LiteralExpr [STRING] [startedby1]
     :
-    FunctionCall test.interval-started-by@2[
-      FunctionCall test.interval-from-date@2[
-        LiteralExpr [STRING] [2010-10-30]
-        LiteralExpr [STRING] [2010-12-21]
-      ]
-      FunctionCall test.interval-from-date@2[
-        LiteralExpr [STRING] [2010-10-30]
-        LiteralExpr [STRING] [2010-11-30]
-      ]
-    ]
+    Variable [ Name=blnStartedBy1 ]
   )
   (
     LiteralExpr [STRING] [startedby2]
     :
-    FunctionCall test.interval-started-by@2[
-      FunctionCall test.interval-from-date@2[
-        LiteralExpr [STRING] [2010-10-30]
-        LiteralExpr [STRING] [2010-11-30]
-      ]
-      FunctionCall test.interval-from-date@2[
-        LiteralExpr [STRING] [2011-10-30]
-        LiteralExpr [STRING] [2012-10-21]
-      ]
-    ]
+    Variable [ Name=blnStartedBy2 ]
   )
   (
     LiteralExpr [STRING] [covers1]
     :
-    FunctionCall test.interval-covers@2[
-      FunctionCall test.interval-from-date@2[
-        LiteralExpr [STRING] [2010-10-30]
-        LiteralExpr [STRING] [2010-11-30]
-      ]
-      FunctionCall test.interval-from-datetime@2[
-        LiteralExpr [STRING] [19990707T020202222]
-        LiteralExpr [STRING] [2013-08-07T03:03:03.333]
-      ]
-    ]
+    Variable [ Name=blnCovers1 ]
   )
   (
     LiteralExpr [STRING] [covers2]
     :
-    FunctionCall test.interval-covers@2[
-      FunctionCall test.interval-from-date@2[
-        LiteralExpr [STRING] [2010-10-30]
-        LiteralExpr [STRING] [2010-11-30]
-      ]
-      FunctionCall test.interval-from-datetime@2[
-        LiteralExpr [STRING] [-19990707T020202222]
-        LiteralExpr [STRING] [2013-08-07T03:03:03.333]
-      ]
-    ]
+    Variable [ Name=blnCovers2 ]
   )
   (
     LiteralExpr [STRING] [coveredby1]
     :
-    FunctionCall test.interval-covered-by@2[
-      FunctionCall test.interval-from-datetime@2[
-        LiteralExpr [STRING] [19990707T020202222]
-        LiteralExpr [STRING] [2013-08-07T03:03:03.333]
-      ]
-      FunctionCall test.interval-from-date@2[
-        LiteralExpr [STRING] [2010-10-30]
-        LiteralExpr [STRING] [2010-11-30]
-      ]
-    ]
+    Variable [ Name=blnCoveredBy1 ]
   )
   (
     LiteralExpr [STRING] [coveredby2]
     :
-    FunctionCall test.interval-covered-by@2[
-      FunctionCall test.interval-from-datetime@2[
-        LiteralExpr [STRING] [-19990707T020202222]
-        LiteralExpr [STRING] [2013-08-07T03:03:03.333]
-      ]
-      FunctionCall test.interval-from-date@2[
-        LiteralExpr [STRING] [2010-10-30]
-        LiteralExpr [STRING] [2010-11-30]
-      ]
-    ]
+    Variable [ Name=blnCoveredBy2 ]
   )
   (
     LiteralExpr [STRING] [ends1]
     :
-    FunctionCall test.interval-ends@2[
-      FunctionCall test.interval-from-datetime@2[
-        LiteralExpr [STRING] [19990707T020202222]
-        LiteralExpr [STRING] [2013-08-07T03:03:03.333]
-      ]
-      FunctionCall test.interval-from-time@2[
-        LiteralExpr [STRING] [12:32:38]
-        LiteralExpr [STRING] [20:29:20]
-      ]
-    ]
+    Variable [ Name=blnEnds1 ]
   )
   (
     LiteralExpr [STRING] [ends2]
     :
-    FunctionCall test.interval-ends@2[
-      FunctionCall test.interval-from-datetime@2[
-        LiteralExpr [STRING] [19990707T020202222]
-        LiteralExpr [STRING] [2013-08-07T03:03:03.333]
-      ]
-      FunctionCall test.interval-from-time@2[
-        LiteralExpr [STRING] [17:48:19]
-        LiteralExpr [STRING] [22:19:49]
-      ]
-    ]
+    Variable [ Name=blnEnds2 ]
   )
   (
     LiteralExpr [STRING] [endedby1]
     :
-    FunctionCall test.interval-ended-by@2[
-      FunctionCall test.interval-from-time@2[
-        LiteralExpr [STRING] [12:32:38]
-        LiteralExpr [STRING] [20:29:20]
-      ]
-      FunctionCall test.interval-from-datetime@2[
-        LiteralExpr [STRING] [19990707T020202222]
-        LiteralExpr [STRING] [2013-08-07T03:03:03.333]
-      ]
-    ]
+    Variable [ Name=blnEndedBy1 ]
   )
   (
     LiteralExpr [STRING] [endedby2]
     :
-    FunctionCall test.interval-ended-by@2[
-      FunctionCall test.interval-from-time@2[
-        LiteralExpr [STRING] [17:48:19]
-        LiteralExpr [STRING] [22:19:49]
-      ]
-      FunctionCall test.interval-from-datetime@2[
-        LiteralExpr [STRING] [19990707T020202222]
-        LiteralExpr [STRING] [2013-08-07T03:03:03.333]
-      ]
-    ]
+    Variable [ Name=blnEndedBy2 ]
   )
   (
     LiteralExpr [STRING] [null1]
     :
-    FunctionCall test.interval-before@2[
-      LiteralExpr [NULL]
-      FunctionCall test.interval-from-date@2[
-        LiteralExpr [STRING] [2011-10-30]
-        LiteralExpr [STRING] [2012-10-21]
-      ]
-    ]
+    Variable [ Name=null1 ]
   )
   (
     LiteralExpr [STRING] [null2]
     :
-    FunctionCall test.interval-covered-by@2[
-      FunctionCall test.interval-from-datetime@2[
-        LiteralExpr [STRING] [19990707T020202222]
-        LiteralExpr [STRING] [2013-08-07T03:03:03.333]
-      ]
-      LiteralExpr [NULL]
-    ]
+    Variable [ Name=null2 ]
   )
   (
     LiteralExpr [STRING] [null3]
     :
-    FunctionCall test.interval-overlapping@2[
-      LiteralExpr [NULL]
-      LiteralExpr [NULL]
-    ]
+    Variable [ Name=null3 ]
   )
 ]
+]

http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/caea8f0e/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/temporal/overlap_bins_gby_0/overlap_bins_gby_0.3.ast
----------------------------------------------------------------------
diff --git a/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/temporal/overlap_bins_gby_0/overlap_bins_gby_0.3.ast b/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/temporal/overlap_bins_gby_0/overlap_bins_gby_0.3.ast
index f3945e1..297d932 100644
--- a/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/temporal/overlap_bins_gby_0/overlap_bins_gby_0.3.ast
+++ b/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/temporal/overlap_bins_gby_0/overlap_bins_gby_0.3.ast
@@ -32,20 +32,35 @@ FROM [  (
     SELECT ELEMENT [
     RecordConstructor [
       (
-        LiteralExpr [STRING] [i]
+        LiteralExpr [STRING] [bin]
         :
-        Variable [ Name=i ]
+        Variable [ Name=bin ]
       )
       (
-        LiteralExpr [STRING] [bin]
+        LiteralExpr [STRING] [i]
         :
-        Variable [ Name=bin ]
+        Variable [ Name=i ]
       )
     ]
     ]
-    FROM [      FunctionCall Metadata.dataset@1[
-        LiteralExpr [STRING] [tsdata]
-      ]
+    FROM [      (
+        SELECT ELEMENT [
+        Variable [ Name=i ]
+        ]
+        FROM [          FunctionCall Metadata.dataset@1[
+            LiteralExpr [STRING] [tsdata]
+          ]
+          AS
+          Variable [ Name=i ]
+        ]
+        Orderby
+          FieldAccessor [
+            Variable [ Name=i ]
+            Field=time
+          ]
+          ASC
+
+      )
       AS
       Variable [ Name=i ]
 ,
@@ -107,3 +122,12 @@ LetVariable [ Name=itv ]
       Field=duration
     ]
   ]
+Orderby
+  FunctionCall test.get-interval-start@1[
+    FieldAccessor [
+      Variable [ Name=gen0 ]
+      Field=bin
+    ]
+  ]
+  ASC
+

http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/caea8f0e/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/tpch-sql-like/query-issue785-2/query-issue785-2.3.ast
----------------------------------------------------------------------
diff --git a/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/tpch-sql-like/query-issue785-2/query-issue785-2.3.ast b/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/tpch-sql-like/query-issue785-2/query-issue785-2.3.ast
index 4a81b19..715999d 100644
--- a/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/tpch-sql-like/query-issue785-2/query-issue785-2.3.ast
+++ b/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/tpch-sql-like/query-issue785-2/query-issue785-2.3.ast
@@ -129,7 +129,6 @@ LetVariable [ Name=X ]
       Variable [ Name=orders ]
       Variable [ Name=n ]
       Variable [ Name=customer ]
-      Variable [ Name=X ]
       Variable [ Name=t ]
 
     LetVariable [ Name=sum ]

http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/caea8f0e/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/tpch-sql-like/query-issue785/query-issue785.3.ast
----------------------------------------------------------------------
diff --git a/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/tpch-sql-like/query-issue785/query-issue785.3.ast b/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/tpch-sql-like/query-issue785/query-issue785.3.ast
index 085714d..f69a6be 100644
--- a/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/tpch-sql-like/query-issue785/query-issue785.3.ast
+++ b/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/tpch-sql-like/query-issue785/query-issue785.3.ast
@@ -39,6 +39,7 @@ RecordConstructor [
         With
         Variable [ Name=i ]
         Variable [ Name=x ]
+        Variable [ Name=nation_key ]
 
       LetVariable [ Name=sum ]
         :=

http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/caea8f0e/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/tpch/nest_aggregate/nest_aggregate.3.ast
----------------------------------------------------------------------
diff --git a/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/tpch/nest_aggregate/nest_aggregate.3.ast b/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/tpch/nest_aggregate/nest_aggregate.3.ast
index ccaa2ee..47eea36 100644
--- a/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/tpch/nest_aggregate/nest_aggregate.3.ast
+++ b/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/tpch/nest_aggregate/nest_aggregate.3.ast
@@ -137,3 +137,10 @@ Where
       Field=n_nationkey
     ]
   ]
+Orderby
+  FieldAccessor [
+    Variable [ Name=nation ]
+    Field=n_nationkey
+  ]
+  ASC
+

http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/caea8f0e/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/tpch/q04_order_priority/q04_order_priority.3.ast
----------------------------------------------------------------------
diff --git a/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/tpch/q04_order_priority/q04_order_priority.3.ast b/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/tpch/q04_order_priority/q04_order_priority.3.ast
index 4dc7445..2f4234e 100644
--- a/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/tpch/q04_order_priority/q04_order_priority.3.ast
+++ b/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/tpch/q04_order_priority/q04_order_priority.3.ast
@@ -54,14 +54,12 @@ FROM [  FunctionCall Metadata.dataset@1[
   ]
   AS
   Variable [ Name=o ]
-,
-  FunctionCall tpch.tmp@0[
-  ]
-  AS
-  Variable [ Name=t ]
-]
-Where
-  OperatorExpr [
+  INNER JOIN
+    FunctionCall tpch.tmp@0[
+    ]
+    AS
+    Variable [ Name=t ]
+    ON
     OperatorExpr [
       FieldAccessor [
         Variable [ Name=o ]
@@ -73,7 +71,9 @@ Where
         Field=o_orderkey
       ]
     ]
-    and
+]
+Where
+  OperatorExpr [
     OperatorExpr [
       FieldAccessor [
         Variable [ Name=o ]

http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/caea8f0e/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/tpch/q09_product_type_profit_nt/q09_product_type_profit_nt.3.ast
----------------------------------------------------------------------
diff --git a/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/tpch/q09_product_type_profit_nt/q09_product_type_profit_nt.3.ast b/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/tpch/q09_product_type_profit_nt/q09_product_type_profit_nt.3.ast
index 8052433..2472739 100644
--- a/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/tpch/q09_product_type_profit_nt/q09_product_type_profit_nt.3.ast
+++ b/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/tpch/q09_product_type_profit_nt/q09_product_type_profit_nt.3.ast
@@ -119,258 +119,258 @@ FROM [  (
           ]
           AS
           Variable [ Name=p ]
-,
-          (
-            SELECT ELEMENT [
-            RecordConstructor [
-              (
-                LiteralExpr [STRING] [l_extendedprice]
-                :
-                FieldAccessor [
-                  Variable [ Name=l1 ]
-                  Field=l_extendedprice
-                ]
-              )
-              (
-                LiteralExpr [STRING] [l_discount]
-                :
-                FieldAccessor [
-                  Variable [ Name=l1 ]
-                  Field=l_discount
-                ]
-              )
-              (
-                LiteralExpr [STRING] [l_quantity]
-                :
-                FieldAccessor [
-                  Variable [ Name=l1 ]
-                  Field=l_quantity
-                ]
-              )
-              (
-                LiteralExpr [STRING] [l_partkey]
-                :
-                FieldAccessor [
-                  Variable [ Name=l1 ]
-                  Field=l_partkey
-                ]
-              )
-              (
-                LiteralExpr [STRING] [l_orderkey]
-                :
-                FieldAccessor [
-                  Variable [ Name=l1 ]
-                  Field=l_orderkey
-                ]
-              )
-              (
-                LiteralExpr [STRING] [n_name]
-                :
-                FieldAccessor [
-                  Variable [ Name=l1 ]
-                  Field=n_name
-                ]
-              )
-              (
-                LiteralExpr [STRING] [ps_supplycost]
-                :
-                FieldAccessor [
-                  Variable [ Name=ps ]
-                  Field=ps_supplycost
-                ]
-              )
-            ]
-            ]
-            FROM [              FunctionCall Metadata.dataset@1[
-                LiteralExpr [STRING] [Partsupp]
+          INNER JOIN
+            (
+              SELECT ELEMENT [
+              RecordConstructor [
+                (
+                  LiteralExpr [STRING] [l_extendedprice]
+                  :
+                  FieldAccessor [
+                    Variable [ Name=l1 ]
+                    Field=l_extendedprice
+                  ]
+                )
+                (
+                  LiteralExpr [STRING] [l_discount]
+                  :
+                  FieldAccessor [
+                    Variable [ Name=l1 ]
+                    Field=l_discount
+                  ]
+                )
+                (
+                  LiteralExpr [STRING] [l_quantity]
+                  :
+                  FieldAccessor [
+                    Variable [ Name=l1 ]
+                    Field=l_quantity
+                  ]
+                )
+                (
+                  LiteralExpr [STRING] [l_partkey]
+                  :
+                  FieldAccessor [
+                    Variable [ Name=l1 ]
+                    Field=l_partkey
+                  ]
+                )
+                (
+                  LiteralExpr [STRING] [l_orderkey]
+                  :
+                  FieldAccessor [
+                    Variable [ Name=l1 ]
+                    Field=l_orderkey
+                  ]
+                )
+                (
+                  LiteralExpr [STRING] [n_name]
+                  :
+                  FieldAccessor [
+                    Variable [ Name=l1 ]
+                    Field=n_name
+                  ]
+                )
+                (
+                  LiteralExpr [STRING] [ps_supplycost]
+                  :
+                  FieldAccessor [
+                    Variable [ Name=ps ]
+                    Field=ps_supplycost
+                  ]
+                )
               ]
-              AS
-              Variable [ Name=ps ]
-,
-              (
-                SELECT ELEMENT [
-                RecordConstructor [
-                  (
-                    LiteralExpr [STRING] [l_suppkey]
-                    :
-                    FieldAccessor [
-                      Variable [ Name=l ]
-                      Field=l_suppkey
-                    ]
-                  )
-                  (
-                    LiteralExpr [STRING] [l_extendedprice]
-                    :
-                    FieldAccessor [
-                      Variable [ Name=l ]
-                      Field=l_extendedprice
-                    ]
-                  )
-                  (
-                    LiteralExpr [STRING] [l_discount]
-                    :
-                    FieldAccessor [
-                      Variable [ Name=l ]
-                      Field=l_discount
-                    ]
-                  )
-                  (
-                    LiteralExpr [STRING] [l_quantity]
-                    :
-                    FieldAccessor [
-                      Variable [ Name=l ]
-                      Field=l_quantity
-                    ]
-                  )
-                  (
-                    LiteralExpr [STRING] [l_partkey]
-                    :
-                    FieldAccessor [
-                      Variable [ Name=l ]
-                      Field=l_partkey
-                    ]
-                  )
-                  (
-                    LiteralExpr [STRING] [l_orderkey]
-                    :
-                    FieldAccessor [
-                      Variable [ Name=l ]
-                      Field=l_orderkey
-                    ]
-                  )
-                  (
-                    LiteralExpr [STRING] [n_name]
-                    :
-                    FieldAccessor [
-                      Variable [ Name=s1 ]
-                      Field=n_name
-                    ]
-                  )
-                ]
+              ]
+              FROM [                FunctionCall Metadata.dataset@1[
+                  LiteralExpr [STRING] [Partsupp]
                 ]
-                FROM [                  (
+                AS
+                Variable [ Name=ps ]
+                INNER JOIN
+                  (
                     SELECT ELEMENT [
                     RecordConstructor [
                       (
-                        LiteralExpr [STRING] [s_suppkey]
+                        LiteralExpr [STRING] [l_suppkey]
                         :
                         FieldAccessor [
-                          Variable [ Name=s ]
-                          Field=s_suppkey
+                          Variable [ Name=l ]
+                          Field=l_suppkey
+                        ]
+                      )
+                      (
+                        LiteralExpr [STRING] [l_extendedprice]
+                        :
+                        FieldAccessor [
+                          Variable [ Name=l ]
+                          Field=l_extendedprice
+                        ]
+                      )
+                      (
+                        LiteralExpr [STRING] [l_discount]
+                        :
+                        FieldAccessor [
+                          Variable [ Name=l ]
+                          Field=l_discount
+                        ]
+                      )
+                      (
+                        LiteralExpr [STRING] [l_quantity]
+                        :
+                        FieldAccessor [
+                          Variable [ Name=l ]
+                          Field=l_quantity
+                        ]
+                      )
+                      (
+                        LiteralExpr [STRING] [l_partkey]
+                        :
+                        FieldAccessor [
+                          Variable [ Name=l ]
+                          Field=l_partkey
+                        ]
+                      )
+                      (
+                        LiteralExpr [STRING] [l_orderkey]
+                        :
+                        FieldAccessor [
+                          Variable [ Name=l ]
+                          Field=l_orderkey
                         ]
                       )
                       (
                         LiteralExpr [STRING] [n_name]
                         :
                         FieldAccessor [
-                          Variable [ Name=n ]
+                          Variable [ Name=s1 ]
                           Field=n_name
                         ]
                       )
                     ]
                     ]
-                    FROM [                      FunctionCall Metadata.dataset@1[
-                        LiteralExpr [STRING] [Supplier]
-                      ]
-                      AS
-                      Variable [ Name=s ]
+                    FROM [                      (
+                        SELECT ELEMENT [
+                        RecordConstructor [
+                          (
+                            LiteralExpr [STRING] [s_suppkey]
+                            :
+                            FieldAccessor [
+                              Variable [ Name=s ]
+                              Field=s_suppkey
+                            ]
+                          )
+                          (
+                            LiteralExpr [STRING] [n_name]
+                            :
+                            FieldAccessor [
+                              Variable [ Name=n ]
+                              Field=n_name
+                            ]
+                          )
+                        ]
+                        ]
+                        FROM [                          FunctionCall Metadata.dataset@1[
+                            LiteralExpr [STRING] [Supplier]
+                          ]
+                          AS
+                          Variable [ Name=s ]
 ,
-                      FunctionCall Metadata.dataset@1[
-                        LiteralExpr [STRING] [Nation]
-                      ]
-                      AS
-                      Variable [ Name=n ]
-                    ]
-                    Where
-                      OperatorExpr [
-                        FieldAccessor [
+                          FunctionCall Metadata.dataset@1[
+                            LiteralExpr [STRING] [Nation]
+                          ]
+                          AS
                           Variable [ Name=n ]
-                          Field=n_nationkey
                         ]
-                        =
-                        FieldAccessor [
-                          Variable [ Name=s ]
-                          Field=s_nationkey
+                        Where
+                          OperatorExpr [
+                            FieldAccessor [
+                              Variable [ Name=n ]
+                              Field=n_nationkey
+                            ]
+                            =
+                            FieldAccessor [
+                              Variable [ Name=s ]
+                              Field=s_nationkey
+                            ]
+                          ]
+                      )
+                      AS
+                      Variable [ Name=s1 ]
+                      INNER JOIN
+                        FunctionCall Metadata.dataset@1[
+                          LiteralExpr [STRING] [LineItem]
                         ]
-                      ]
+                        AS
+                        Variable [ Name=l ]
+                        ON
+                        OperatorExpr [
+                          FieldAccessor [
+                            Variable [ Name=s1 ]
+                            Field=s_suppkey
+                          ]
+                          =
+                          FieldAccessor [
+                            Variable [ Name=l ]
+                            Field=l_suppkey
+                          ]
+                        ]
+                    ]
                   )
                   AS
-                  Variable [ Name=s1 ]
-,
-                  FunctionCall Metadata.dataset@1[
-                    LiteralExpr [STRING] [LineItem]
-                  ]
-                  AS
-                  Variable [ Name=l ]
-                ]
-                Where
+                  Variable [ Name=l1 ]
+                  ON
                   OperatorExpr [
-                    FieldAccessor [
-                      Variable [ Name=s1 ]
-                      Field=s_suppkey
+                    OperatorExpr [
+                      FieldAccessor [
+                        Variable [ Name=ps ]
+                        Field=ps_suppkey
+                      ]
+                      =
+                      FieldAccessor [
+                        Variable [ Name=l1 ]
+                        Field=l_suppkey
+                      ]
                     ]
-                    =
-                    FieldAccessor [
-                      Variable [ Name=l ]
-                      Field=l_suppkey
+                    and
+                    OperatorExpr [
+                      FieldAccessor [
+                        Variable [ Name=ps ]
+                        Field=ps_partkey
+                      ]
+                      =
+                      FieldAccessor [
+                        Variable [ Name=l1 ]
+                        Field=l_partkey
+                      ]
                     ]
                   ]
-              )
-              AS
-              Variable [ Name=l1 ]
-            ]
-            Where
-              OperatorExpr [
-                OperatorExpr [
-                  FieldAccessor [
-                    Variable [ Name=ps ]
-                    Field=ps_suppkey
-                  ]
-                  =
-                  FieldAccessor [
-                    Variable [ Name=l1 ]
-                    Field=l_suppkey
-                  ]
-                ]
-                and
-                OperatorExpr [
-                  FieldAccessor [
-                    Variable [ Name=ps ]
-                    Field=ps_partkey
-                  ]
-                  =
-                  FieldAccessor [
-                    Variable [ Name=l1 ]
-                    Field=l_partkey
-                  ]
-                ]
-              ]
-          )
-          AS
-          Variable [ Name=l2 ]
-        ]
-        Where
-          OperatorExpr [
-            FunctionCall tpch.contains@2[
-              FieldAccessor [
-                Variable [ Name=p ]
-                Field=p_name
               ]
-              LiteralExpr [STRING] [green]
-            ]
-            and
+            )
+            AS
+            Variable [ Name=l2 ]
+            ON
             OperatorExpr [
-              FieldAccessor [
-                Variable [ Name=p ]
-                Field=p_partkey
+              FunctionCall tpch.contains@2[
+                FieldAccessor [
+                  Variable [ Name=p ]
+                  Field=p_name
+                ]
+                LiteralExpr [STRING] [green]
               ]
-              =
-              FieldAccessor [
-                Variable [ Name=l2 ]
-                Field=l_partkey
+              and
+              OperatorExpr [
+                FieldAccessor [
+                  Variable [ Name=p ]
+                  Field=p_partkey
+                ]
+                =
+                FieldAccessor [
+                  Variable [ Name=l2 ]
+                  Field=l_partkey
+                ]
               ]
             ]
-          ]
+        ]
       )
       AS
       Variable [ Name=l3 ]

http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/caea8f0e/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/tpch/q18_large_volume_customer/q18_large_volume_customer.3.ast
----------------------------------------------------------------------
diff --git a/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/tpch/q18_large_volume_customer/q18_large_volume_customer.3.ast b/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/tpch/q18_large_volume_customer/q18_large_volume_customer.3.ast
index edf6190..440f07a 100644
--- a/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/tpch/q18_large_volume_customer/q18_large_volume_customer.3.ast
+++ b/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/tpch/q18_large_volume_customer/q18_large_volume_customer.3.ast
@@ -130,26 +130,24 @@ Where
     ]
     and
     OperatorExpr [
-      OperatorExpr [
-        FieldAccessor [
-          Variable [ Name=o ]
-          Field=o_orderkey
-        ]
-        =
-        FieldAccessor [
-          Variable [ Name=t ]
-          Field=l_orderkey
-        ]
+      FieldAccessor [
+        Variable [ Name=o ]
+        Field=o_orderkey
       ]
-      and
-      OperatorExpr [
-        FieldAccessor [
-          Variable [ Name=t ]
-          Field=t_sum_quantity
-        ]
-        >
-        LiteralExpr [LONG] [30]
+      =
+      FieldAccessor [
+        Variable [ Name=t ]
+        Field=l_orderkey
+      ]
+    ]
+    and
+    OperatorExpr [
+      FieldAccessor [
+        Variable [ Name=t ]
+        Field=t_sum_quantity
       ]
+      >
+      LiteralExpr [LONG] [30]
     ]
     and
     OperatorExpr [
@@ -159,8 +157,8 @@ Where
       ]
       =
       FieldAccessor [
-        Variable [ Name=o ]
-        Field=o_orderkey
+        Variable [ Name=t ]
+        Field=l_orderkey
       ]
     ]
   ]

http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/caea8f0e/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/tpch/q21_suppliers_who_kept_orders_waiting/q21_suppliers_who_kept_orders_waiting.3.ast
----------------------------------------------------------------------
diff --git a/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/tpch/q21_suppliers_who_kept_orders_waiting/q21_suppliers_who_kept_orders_waiting.3.ast b/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/tpch/q21_suppliers_who_kept_orders_waiting/q21_suppliers_who_kept_orders_waiting.3.ast
index c471683..02b134c 100644
--- a/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/tpch/q21_suppliers_who_kept_orders_waiting/q21_suppliers_who_kept_orders_waiting.3.ast
+++ b/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/tpch/q21_suppliers_who_kept_orders_waiting/q21_suppliers_who_kept_orders_waiting.3.ast
@@ -359,28 +359,26 @@ FROM [  (
         Where
           OperatorExpr [
             OperatorExpr [
-              OperatorExpr [
-                FieldAccessor [
-                  Variable [ Name=ns ]
-                  Field=s_suppkey
-                ]
-                =
-                FieldAccessor [
-                  Variable [ Name=l ]
-                  Field=l_suppkey
-                ]
+              FieldAccessor [
+                Variable [ Name=ns ]
+                Field=s_suppkey
               ]
-              and
-              OperatorExpr [
-                FieldAccessor [
-                  Variable [ Name=l ]
-                  Field=l_receiptdate
-                ]
-                >
-                FieldAccessor [
-                  Variable [ Name=l ]
-                  Field=l_commitdate
-                ]
+              =
+              FieldAccessor [
+                Variable [ Name=l ]
+                Field=l_suppkey
+              ]
+            ]
+            and
+            OperatorExpr [
+              FieldAccessor [
+                Variable [ Name=l ]
+                Field=l_receiptdate
+              ]
+              >
+              FieldAccessor [
+                Variable [ Name=l ]
+                Field=l_commitdate
               ]
             ]
             and

http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/caea8f0e/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/tpch/query-issue785-2/query-issue785-2.3.ast
----------------------------------------------------------------------
diff --git a/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/tpch/query-issue785-2/query-issue785-2.3.ast b/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/tpch/query-issue785-2/query-issue785-2.3.ast
index 4a81b19..715999d 100644
--- a/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/tpch/query-issue785-2/query-issue785-2.3.ast
+++ b/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/tpch/query-issue785-2/query-issue785-2.3.ast
@@ -129,7 +129,6 @@ LetVariable [ Name=X ]
       Variable [ Name=orders ]
       Variable [ Name=n ]
       Variable [ Name=customer ]
-      Variable [ Name=X ]
       Variable [ Name=t ]
 
     LetVariable [ Name=sum ]

http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/caea8f0e/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/tpch/query-issue785/query-issue785.3.ast
----------------------------------------------------------------------
diff --git a/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/tpch/query-issue785/query-issue785.3.ast b/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/tpch/query-issue785/query-issue785.3.ast
index 085714d..f69a6be 100644
--- a/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/tpch/query-issue785/query-issue785.3.ast
+++ b/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/tpch/query-issue785/query-issue785.3.ast
@@ -39,6 +39,7 @@ RecordConstructor [
         With
         Variable [ Name=i ]
         Variable [ Name=x ]
+        Variable [ Name=nation_key ]
 
       LetVariable [ Name=sum ]
         :=

http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/caea8f0e/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/user-defined-functions/query-issue172/query-issue172.3.ast
----------------------------------------------------------------------
diff --git a/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/user-defined-functions/query-issue172/query-issue172.3.ast b/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/user-defined-functions/query-issue172/query-issue172.3.ast
index e69de29..0246049 100644
--- a/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/user-defined-functions/query-issue172/query-issue172.3.ast
+++ b/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/user-defined-functions/query-issue172/query-issue172.3.ast
@@ -0,0 +1,9 @@
+Query:
+FunctionCall null.string-length@1[
+  FunctionCall null.string-concat@1[
+    OrderedListConstructor [
+      LiteralExpr [STRING] [this is a ]
+      LiteralExpr [STRING] [test string]
+    ]
+  ]
+]

http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/caea8f0e/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/user-defined-functions/query-issue201/query-issue201.3.ast
----------------------------------------------------------------------
diff --git a/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/user-defined-functions/query-issue201/query-issue201.3.ast b/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/user-defined-functions/query-issue201/query-issue201.3.ast
index e69de29..0aa55c7 100644
--- a/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/user-defined-functions/query-issue201/query-issue201.3.ast
+++ b/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/user-defined-functions/query-issue201/query-issue201.3.ast
@@ -0,0 +1,15 @@
+Set import-private-functions=true
+Query:
+LetVariable [ Name=x ]
+  :=
+  FunctionCall null.range@2[
+    LiteralExpr [LONG] [1]
+    LiteralExpr [LONG] [100]
+  ]
+SELECT ELEMENT [
+Variable [ Name=i ]
+]
+FROM [  Variable [ Name=x ]
+  AS
+  Variable [ Name=i ]
+]

http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/caea8f0e/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/user-defined-functions/query-issue218-2/query-issue218-2.3.ast
----------------------------------------------------------------------
diff --git a/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/user-defined-functions/query-issue218-2/query-issue218-2.3.ast b/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/user-defined-functions/query-issue218-2/query-issue218-2.3.ast
index e69de29..15eb8e3 100644
--- a/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/user-defined-functions/query-issue218-2/query-issue218-2.3.ast
+++ b/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/user-defined-functions/query-issue218-2/query-issue218-2.3.ast
@@ -0,0 +1,7 @@
+Query:
+SELECT ELEMENT [
+FunctionCall test.computeBonus@2[
+  NEGATIVE LiteralExpr [LONG] [1]
+  NEGATIVE LiteralExpr [LONG] [1]
+]
+]

http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/caea8f0e/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/user-defined-functions/query-issue218/query-issue218.3.ast
----------------------------------------------------------------------
diff --git a/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/user-defined-functions/query-issue218/query-issue218.3.ast b/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/user-defined-functions/query-issue218/query-issue218.3.ast
index e69de29..bc1d2ae 100644
--- a/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/user-defined-functions/query-issue218/query-issue218.3.ast
+++ b/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/user-defined-functions/query-issue218/query-issue218.3.ast
@@ -0,0 +1,2 @@
+Query:
+LiteralExpr [LONG] [1]

http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/caea8f0e/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/user-defined-functions/query-issue244/query-issue244.1.ast
----------------------------------------------------------------------
diff --git a/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/user-defined-functions/query-issue244/query-issue244.1.ast b/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/user-defined-functions/query-issue244/query-issue244.1.ast
index e69de29..b5cf1a2 100644
--- a/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/user-defined-functions/query-issue244/query-issue244.1.ast
+++ b/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/user-defined-functions/query-issue244/query-issue244.1.ast
@@ -0,0 +1,9 @@
+DataverseUse test
+TypeDecl TypeA [
+  open RecordType {
+    id : int64,
+    name : string
+  }
+]
+DatasetDecl t1(TypeA) partitioned by [[id]]
+DatasetDecl t2(TypeA) partitioned by [[id]]

http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/caea8f0e/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/user-defined-functions/query-issue244/query-issue244.2.ast
----------------------------------------------------------------------
diff --git a/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/user-defined-functions/query-issue244/query-issue244.2.ast b/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/user-defined-functions/query-issue244/query-issue244.2.ast
index e69de29..916a59e 100644
--- a/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/user-defined-functions/query-issue244/query-issue244.2.ast
+++ b/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/user-defined-functions/query-issue244/query-issue244.2.ast
@@ -0,0 +1 @@
+DataverseUse test

http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/caea8f0e/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/user-defined-functions/query-issue244/query-issue244.3.ast
----------------------------------------------------------------------
diff --git a/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/user-defined-functions/query-issue244/query-issue244.3.ast b/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/user-defined-functions/query-issue244/query-issue244.3.ast
index e69de29..b14b434 100644
--- a/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/user-defined-functions/query-issue244/query-issue244.3.ast
+++ b/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/user-defined-functions/query-issue244/query-issue244.3.ast
@@ -0,0 +1,18 @@
+DataverseUse test
+Query:
+SELECT ELEMENT [
+Variable [ Name=l ]
+]
+FROM [  FunctionCall Metadata.dataset@1[
+    LiteralExpr [STRING] [t2]
+  ]
+  AS
+  Variable [ Name=l ]
+]
+Orderby
+  FieldAccessor [
+    Variable [ Name=l ]
+    Field=id
+  ]
+  ASC
+

http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/caea8f0e/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/user-defined-functions/query-issue455/query-issue455.2.ast
----------------------------------------------------------------------
diff --git a/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/user-defined-functions/query-issue455/query-issue455.2.ast b/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/user-defined-functions/query-issue455/query-issue455.2.ast
index e69de29..c30763f 100644
--- a/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/user-defined-functions/query-issue455/query-issue455.2.ast
+++ b/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/user-defined-functions/query-issue455/query-issue455.2.ast
@@ -0,0 +1,5 @@
+Query:
+SELECT ELEMENT [
+FunctionCall null.printName@0[
+]
+]

http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/caea8f0e/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/user-defined-functions/query-issue455/query-issue455.4.ast
----------------------------------------------------------------------
diff --git a/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/user-defined-functions/query-issue455/query-issue455.4.ast b/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/user-defined-functions/query-issue455/query-issue455.4.ast
index e69de29..2e23f79 100644
--- a/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/user-defined-functions/query-issue455/query-issue455.4.ast
+++ b/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/user-defined-functions/query-issue455/query-issue455.4.ast
@@ -0,0 +1,15 @@
+Query:
+SELECT ELEMENT [
+Variable [ Name=l ]
+]
+FROM [  FunctionCall Metadata.dataset@1[
+    LiteralExpr [STRING] [Metadata.Function]
+  ]
+  AS
+  Variable [ Name=l ]
+]
+Query:
+SELECT ELEMENT [
+FunctionCall null.printName@0[
+]
+]

http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/caea8f0e/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/user-defined-functions/query-issue489/query-issue489.1.ast
----------------------------------------------------------------------
diff --git a/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/user-defined-functions/query-issue489/query-issue489.1.ast b/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/user-defined-functions/query-issue489/query-issue489.1.ast
index e69de29..916a59e 100644
--- a/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/user-defined-functions/query-issue489/query-issue489.1.ast
+++ b/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/user-defined-functions/query-issue489/query-issue489.1.ast
@@ -0,0 +1 @@
+DataverseUse test

http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/caea8f0e/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/user-defined-functions/query-issue489/query-issue489.2.ast
----------------------------------------------------------------------
diff --git a/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/user-defined-functions/query-issue489/query-issue489.2.ast b/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/user-defined-functions/query-issue489/query-issue489.2.ast
index e69de29..7a053bd 100644
--- a/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/user-defined-functions/query-issue489/query-issue489.2.ast
+++ b/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/user-defined-functions/query-issue489/query-issue489.2.ast
@@ -0,0 +1,25 @@
+Query:
+SELECT ELEMENT [
+FunctionCall null.count@1[
+  (
+    SELECT ELEMENT [
+    Variable [ Name=x ]
+    ]
+    FROM [      FunctionCall Metadata.dataset@1[
+        LiteralExpr [STRING] [Metadata.Function]
+      ]
+      AS
+      Variable [ Name=x ]
+    ]
+    Where
+      OperatorExpr [
+        FieldAccessor [
+          Variable [ Name=x ]
+          Field=DataverseName
+        ]
+        =
+        LiteralExpr [STRING] [test]
+      ]
+  )
+]
+]

http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/caea8f0e/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/user-defined-functions/query-issue489/query-issue489.4.ast
----------------------------------------------------------------------
diff --git a/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/user-defined-functions/query-issue489/query-issue489.4.ast b/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/user-defined-functions/query-issue489/query-issue489.4.ast
index e69de29..7a053bd 100644
--- a/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/user-defined-functions/query-issue489/query-issue489.4.ast
+++ b/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/user-defined-functions/query-issue489/query-issue489.4.ast
@@ -0,0 +1,25 @@
+Query:
+SELECT ELEMENT [
+FunctionCall null.count@1[
+  (
+    SELECT ELEMENT [
+    Variable [ Name=x ]
+    ]
+    FROM [      FunctionCall Metadata.dataset@1[
+        LiteralExpr [STRING] [Metadata.Function]
+      ]
+      AS
+      Variable [ Name=x ]
+    ]
+    Where
+      OperatorExpr [
+        FieldAccessor [
+          Variable [ Name=x ]
+          Field=DataverseName
+        ]
+        =
+        LiteralExpr [STRING] [test]
+      ]
+  )
+]
+]

http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/caea8f0e/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/user-defined-functions/udf01/udf01.1.ast
----------------------------------------------------------------------
diff --git a/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/user-defined-functions/udf01/udf01.1.ast b/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/user-defined-functions/udf01/udf01.1.ast
index e69de29..916a59e 100644
--- a/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/user-defined-functions/udf01/udf01.1.ast
+++ b/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/user-defined-functions/udf01/udf01.1.ast
@@ -0,0 +1 @@
+DataverseUse test

http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/caea8f0e/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/user-defined-functions/udf02/udf02.1.ast
----------------------------------------------------------------------
diff --git a/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/user-defined-functions/udf02/udf02.1.ast b/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/user-defined-functions/udf02/udf02.1.ast
index e69de29..916a59e 100644
--- a/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/user-defined-functions/udf02/udf02.1.ast
+++ b/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/user-defined-functions/udf02/udf02.1.ast
@@ -0,0 +1 @@
+DataverseUse test

http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/caea8f0e/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/user-defined-functions/udf04/udf04.1.ast
----------------------------------------------------------------------
diff --git a/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/user-defined-functions/udf04/udf04.1.ast b/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/user-defined-functions/udf04/udf04.1.ast
index e69de29..916a59e 100644
--- a/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/user-defined-functions/udf04/udf04.1.ast
+++ b/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/user-defined-functions/udf04/udf04.1.ast
@@ -0,0 +1 @@
+DataverseUse test

http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/caea8f0e/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/user-defined-functions/udf05/udf05.1.ast
----------------------------------------------------------------------
diff --git a/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/user-defined-functions/udf05/udf05.1.ast b/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/user-defined-functions/udf05/udf05.1.ast
index e69de29..916a59e 100644
--- a/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/user-defined-functions/udf05/udf05.1.ast
+++ b/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/user-defined-functions/udf05/udf05.1.ast
@@ -0,0 +1 @@
+DataverseUse test

http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/caea8f0e/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/user-defined-functions/udf06/udf06.1.ast
----------------------------------------------------------------------
diff --git a/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/user-defined-functions/udf06/udf06.1.ast b/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/user-defined-functions/udf06/udf06.1.ast
index e69de29..916a59e 100644
--- a/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/user-defined-functions/udf06/udf06.1.ast
+++ b/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/user-defined-functions/udf06/udf06.1.ast
@@ -0,0 +1 @@
+DataverseUse test

http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/caea8f0e/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/user-defined-functions/udf07/udf07.1.ast
----------------------------------------------------------------------
diff --git a/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/user-defined-functions/udf07/udf07.1.ast b/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/user-defined-functions/udf07/udf07.1.ast
index e69de29..916a59e 100644
--- a/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/user-defined-functions/udf07/udf07.1.ast
+++ b/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/user-defined-functions/udf07/udf07.1.ast
@@ -0,0 +1 @@
+DataverseUse test

http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/caea8f0e/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/user-defined-functions/udf08/udf08.1.ast
----------------------------------------------------------------------
diff --git a/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/user-defined-functions/udf08/udf08.1.ast b/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/user-defined-functions/udf08/udf08.1.ast
index e69de29..916a59e 100644
--- a/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/user-defined-functions/udf08/udf08.1.ast
+++ b/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/user-defined-functions/udf08/udf08.1.ast
@@ -0,0 +1 @@
+DataverseUse test

http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/caea8f0e/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/user-defined-functions/udf09/udf09.1.ast
----------------------------------------------------------------------
diff --git a/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/user-defined-functions/udf09/udf09.1.ast b/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/user-defined-functions/udf09/udf09.1.ast
index e69de29..40ba667 100644
--- a/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/user-defined-functions/udf09/udf09.1.ast
+++ b/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/user-defined-functions/udf09/udf09.1.ast
@@ -0,0 +1,7 @@
+DataverseUse test
+TypeDecl TestType [
+  open RecordType {
+    id : int64
+  }
+]
+DatasetDecl t1(TestType) partitioned by [[id]]

http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/caea8f0e/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/user-defined-functions/udf10/udf10.1.ast
----------------------------------------------------------------------
diff --git a/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/user-defined-functions/udf10/udf10.1.ast b/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/user-defined-functions/udf10/udf10.1.ast
index e69de29..916a59e 100644
--- a/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/user-defined-functions/udf10/udf10.1.ast
+++ b/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/user-defined-functions/udf10/udf10.1.ast
@@ -0,0 +1 @@
+DataverseUse test

http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/caea8f0e/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/user-defined-functions/udf11/udf11.1.ast
----------------------------------------------------------------------
diff --git a/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/user-defined-functions/udf11/udf11.1.ast b/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/user-defined-functions/udf11/udf11.1.ast
index e69de29..916a59e 100644
--- a/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/user-defined-functions/udf11/udf11.1.ast
+++ b/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/user-defined-functions/udf11/udf11.1.ast
@@ -0,0 +1 @@
+DataverseUse test

http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/caea8f0e/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/user-defined-functions/udf12/udf12.1.ast
----------------------------------------------------------------------
diff --git a/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/user-defined-functions/udf12/udf12.1.ast b/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/user-defined-functions/udf12/udf12.1.ast
index e69de29..916a59e 100644
--- a/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/user-defined-functions/udf12/udf12.1.ast
+++ b/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/user-defined-functions/udf12/udf12.1.ast
@@ -0,0 +1 @@
+DataverseUse test

http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/caea8f0e/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/user-defined-functions/udf13/udf13.1.ast
----------------------------------------------------------------------
diff --git a/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/user-defined-functions/udf13/udf13.1.ast b/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/user-defined-functions/udf13/udf13.1.ast
index e69de29..916a59e 100644
--- a/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/user-defined-functions/udf13/udf13.1.ast
+++ b/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/user-defined-functions/udf13/udf13.1.ast
@@ -0,0 +1 @@
+DataverseUse test

http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/caea8f0e/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/user-defined-functions/udf14/udf14.1.ast
----------------------------------------------------------------------
diff --git a/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/user-defined-functions/udf14/udf14.1.ast b/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/user-defined-functions/udf14/udf14.1.ast
index e69de29..916a59e 100644
--- a/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/user-defined-functions/udf14/udf14.1.ast
+++ b/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/user-defined-functions/udf14/udf14.1.ast
@@ -0,0 +1 @@
+DataverseUse test

http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/caea8f0e/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/user-defined-functions/udf16/udf16.1.ast
----------------------------------------------------------------------
diff --git a/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/user-defined-functions/udf16/udf16.1.ast b/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/user-defined-functions/udf16/udf16.1.ast
index e69de29..916a59e 100644
--- a/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/user-defined-functions/udf16/udf16.1.ast
+++ b/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/user-defined-functions/udf16/udf16.1.ast
@@ -0,0 +1 @@
+DataverseUse test

http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/caea8f0e/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/user-defined-functions/udf17/udf17.1.ast
----------------------------------------------------------------------
diff --git a/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/user-defined-functions/udf17/udf17.1.ast b/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/user-defined-functions/udf17/udf17.1.ast
index e69de29..916a59e 100644
--- a/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/user-defined-functions/udf17/udf17.1.ast
+++ b/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/user-defined-functions/udf17/udf17.1.ast
@@ -0,0 +1 @@
+DataverseUse test

http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/caea8f0e/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/user-defined-functions/udf18/udf18.1.ast
----------------------------------------------------------------------
diff --git a/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/user-defined-functions/udf18/udf18.1.ast b/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/user-defined-functions/udf18/udf18.1.ast
index e69de29..916a59e 100644
--- a/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/user-defined-functions/udf18/udf18.1.ast
+++ b/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/user-defined-functions/udf18/udf18.1.ast
@@ -0,0 +1 @@
+DataverseUse test

http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/caea8f0e/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/user-defined-functions/udf19/udf19.1.ast
----------------------------------------------------------------------
diff --git a/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/user-defined-functions/udf19/udf19.1.ast b/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/user-defined-functions/udf19/udf19.1.ast
index e69de29..916a59e 100644
--- a/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/user-defined-functions/udf19/udf19.1.ast
+++ b/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/user-defined-functions/udf19/udf19.1.ast
@@ -0,0 +1 @@
+DataverseUse test

http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/caea8f0e/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/user-defined-functions/udf20/udf20.1.ast
----------------------------------------------------------------------
diff --git a/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/user-defined-functions/udf20/udf20.1.ast b/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/user-defined-functions/udf20/udf20.1.ast
index e69de29..916a59e 100644
--- a/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/user-defined-functions/udf20/udf20.1.ast
+++ b/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/user-defined-functions/udf20/udf20.1.ast
@@ -0,0 +1 @@
+DataverseUse test

http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/caea8f0e/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/user-defined-functions/udf21/udf21.1.ast
----------------------------------------------------------------------
diff --git a/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/user-defined-functions/udf21/udf21.1.ast b/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/user-defined-functions/udf21/udf21.1.ast
index e69de29..916a59e 100644
--- a/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/user-defined-functions/udf21/udf21.1.ast
+++ b/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/user-defined-functions/udf21/udf21.1.ast
@@ -0,0 +1 @@
+DataverseUse test

http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/caea8f0e/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/user-defined-functions/udf22/udf22.1.ast
----------------------------------------------------------------------
diff --git a/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/user-defined-functions/udf22/udf22.1.ast b/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/user-defined-functions/udf22/udf22.1.ast
index e69de29..916a59e 100644
--- a/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/user-defined-functions/udf22/udf22.1.ast
+++ b/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/user-defined-functions/udf22/udf22.1.ast
@@ -0,0 +1 @@
+DataverseUse test

http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/caea8f0e/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/user-defined-functions/udf23/udf23.1.ast
----------------------------------------------------------------------
diff --git a/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/user-defined-functions/udf23/udf23.1.ast b/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/user-defined-functions/udf23/udf23.1.ast
index e69de29..916a59e 100644
--- a/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/user-defined-functions/udf23/udf23.1.ast
+++ b/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/user-defined-functions/udf23/udf23.1.ast
@@ -0,0 +1 @@
+DataverseUse test

http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/caea8f0e/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/user-defined-functions/udf26/udf26.1.ast
----------------------------------------------------------------------
diff --git a/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/user-defined-functions/udf26/udf26.1.ast b/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/user-defined-functions/udf26/udf26.1.ast
index e69de29..916a59e 100644
--- a/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/user-defined-functions/udf26/udf26.1.ast
+++ b/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/user-defined-functions/udf26/udf26.1.ast
@@ -0,0 +1 @@
+DataverseUse test

http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/caea8f0e/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/user-defined-functions/udf27/udf27.1.ast
----------------------------------------------------------------------
diff --git a/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/user-defined-functions/udf27/udf27.1.ast b/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/user-defined-functions/udf27/udf27.1.ast
index e69de29..916a59e 100644
--- a/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/user-defined-functions/udf27/udf27.1.ast
+++ b/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/user-defined-functions/udf27/udf27.1.ast
@@ -0,0 +1 @@
+DataverseUse test

http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/caea8f0e/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/user-defined-functions/udf28/udf28.1.ast
----------------------------------------------------------------------
diff --git a/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/user-defined-functions/udf28/udf28.1.ast b/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/user-defined-functions/udf28/udf28.1.ast
index e69de29..916a59e 100644
--- a/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/user-defined-functions/udf28/udf28.1.ast
+++ b/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/user-defined-functions/udf28/udf28.1.ast
@@ -0,0 +1 @@
+DataverseUse test


Mime
View raw message