You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@asterixdb.apache.org by bu...@apache.org on 2015/10/31 00:16:29 UTC
[21/51] [partial] incubator-asterixdb git commit: SQL++ parser: 1.
refactored asterix-aql to become asterix-lang-common and asterix-lang-aql,
where the former is the common part for different languages;
2. added asterix-lang-sqlpp on top of asterix-lang-
http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/391f09e5/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/btree-index/btree-primary-28.ast
----------------------------------------------------------------------
diff --git a/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/btree-index/btree-primary-28.ast b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/btree-index/btree-primary-28.ast
new file mode 100644
index 0000000..15c06d0
--- /dev/null
+++ b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/btree-index/btree-primary-28.ast
@@ -0,0 +1,57 @@
+DataverseUse test
+WriteOutputTo nc1:rttest/btree-index_btree-primary-28.adm
+TypeDecl TestType [
+ open RecordType {
+ fname : string,
+ lname : string
+ }
+]
+DatasetDecl testdst(TestType) partitioned by [[fname], [lname]]
+Query:
+SELECT ELEMENT [
+Variable [ Name=emp ]
+]
+FROM [ FunctionCall Metadata.dataset@1[
+ LiteralExpr [STRING] [testdst]
+ ]
+ AS
+ Variable [ Name=emp ]
+]
+Where
+ OperatorExpr [
+ OperatorExpr [
+ FieldAccessor [
+ Variable [ Name=emp ]
+ Field=fname
+ ]
+ >
+ LiteralExpr [STRING] [Craig]
+ ]
+ and
+ OperatorExpr [
+ FieldAccessor [
+ Variable [ Name=emp ]
+ Field=lname
+ ]
+ >
+ LiteralExpr [STRING] [Kevin]
+ ]
+ and
+ OperatorExpr [
+ FieldAccessor [
+ Variable [ Name=emp ]
+ Field=fname
+ ]
+ <
+ LiteralExpr [STRING] [Mary]
+ ]
+ and
+ OperatorExpr [
+ FieldAccessor [
+ Variable [ Name=emp ]
+ Field=lname
+ ]
+ <=
+ LiteralExpr [STRING] [Tomes]
+ ]
+ ]
http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/391f09e5/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/btree-index/btree-primary-29.ast
----------------------------------------------------------------------
diff --git a/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/btree-index/btree-primary-29.ast b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/btree-index/btree-primary-29.ast
new file mode 100644
index 0000000..687536e
--- /dev/null
+++ b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/btree-index/btree-primary-29.ast
@@ -0,0 +1,57 @@
+DataverseUse test
+WriteOutputTo nc1:rttest/btree-index_btree-primary-29.adm
+TypeDecl TestType [
+ open RecordType {
+ fname : string,
+ lname : string
+ }
+]
+DatasetDecl testdst(TestType) partitioned by [[fname], [lname]]
+Query:
+SELECT ELEMENT [
+Variable [ Name=emp ]
+]
+FROM [ FunctionCall Metadata.dataset@1[
+ LiteralExpr [STRING] [testdst]
+ ]
+ AS
+ Variable [ Name=emp ]
+]
+Where
+ OperatorExpr [
+ OperatorExpr [
+ FieldAccessor [
+ Variable [ Name=emp ]
+ Field=fname
+ ]
+ >
+ LiteralExpr [STRING] [Craig]
+ ]
+ and
+ OperatorExpr [
+ FieldAccessor [
+ Variable [ Name=emp ]
+ Field=lname
+ ]
+ >=
+ LiteralExpr [STRING] [Kevin]
+ ]
+ and
+ OperatorExpr [
+ FieldAccessor [
+ Variable [ Name=emp ]
+ Field=fname
+ ]
+ <
+ LiteralExpr [STRING] [Mary]
+ ]
+ and
+ OperatorExpr [
+ FieldAccessor [
+ Variable [ Name=emp ]
+ Field=lname
+ ]
+ <
+ LiteralExpr [STRING] [Tomes]
+ ]
+ ]
http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/391f09e5/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/btree-index/btree-primary-30.ast
----------------------------------------------------------------------
diff --git a/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/btree-index/btree-primary-30.ast b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/btree-index/btree-primary-30.ast
new file mode 100644
index 0000000..e572543
--- /dev/null
+++ b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/btree-index/btree-primary-30.ast
@@ -0,0 +1,57 @@
+DataverseUse test
+WriteOutputTo nc1:rttest/btree-index_btree-primary-30.adm
+TypeDecl TestType [
+ open RecordType {
+ fname : string,
+ lname : string
+ }
+]
+DatasetDecl testdst(TestType) partitioned by [[fname], [lname]]
+Query:
+SELECT ELEMENT [
+Variable [ Name=emp ]
+]
+FROM [ FunctionCall Metadata.dataset@1[
+ LiteralExpr [STRING] [testdst]
+ ]
+ AS
+ Variable [ Name=emp ]
+]
+Where
+ OperatorExpr [
+ OperatorExpr [
+ FieldAccessor [
+ Variable [ Name=emp ]
+ Field=fname
+ ]
+ >=
+ LiteralExpr [STRING] [Craig]
+ ]
+ and
+ OperatorExpr [
+ FieldAccessor [
+ Variable [ Name=emp ]
+ Field=lname
+ ]
+ >
+ LiteralExpr [STRING] [Kevin]
+ ]
+ and
+ OperatorExpr [
+ FieldAccessor [
+ Variable [ Name=emp ]
+ Field=fname
+ ]
+ <
+ LiteralExpr [STRING] [Mary]
+ ]
+ and
+ OperatorExpr [
+ FieldAccessor [
+ Variable [ Name=emp ]
+ Field=lname
+ ]
+ <
+ LiteralExpr [STRING] [Tomes]
+ ]
+ ]
http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/391f09e5/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/btree-index/btree-primary-31.ast
----------------------------------------------------------------------
diff --git a/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/btree-index/btree-primary-31.ast b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/btree-index/btree-primary-31.ast
new file mode 100644
index 0000000..c5771bd
--- /dev/null
+++ b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/btree-index/btree-primary-31.ast
@@ -0,0 +1,39 @@
+DataverseUse test
+WriteOutputTo nc1:rttest/btree-index_btree-primary-31.adm
+TypeDecl TestType [
+ open RecordType {
+ fname : string,
+ lname : string
+ }
+]
+DatasetDecl testdst(TestType) partitioned by [[fname], [lname]]
+Query:
+SELECT ELEMENT [
+Variable [ Name=emp ]
+]
+FROM [ FunctionCall Metadata.dataset@1[
+ LiteralExpr [STRING] [testdst]
+ ]
+ AS
+ Variable [ Name=emp ]
+]
+Where
+ OperatorExpr [
+ OperatorExpr [
+ FieldAccessor [
+ Variable [ Name=emp ]
+ Field=fname
+ ]
+ =
+ LiteralExpr [STRING] [Julio]
+ ]
+ and
+ OperatorExpr [
+ FieldAccessor [
+ Variable [ Name=emp ]
+ Field=lname
+ ]
+ >
+ LiteralExpr [STRING] [Xu]
+ ]
+ ]
http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/391f09e5/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/btree-index/btree-primary-32.ast
----------------------------------------------------------------------
diff --git a/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/btree-index/btree-primary-32.ast b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/btree-index/btree-primary-32.ast
new file mode 100644
index 0000000..f2bf632
--- /dev/null
+++ b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/btree-index/btree-primary-32.ast
@@ -0,0 +1,39 @@
+DataverseUse test
+WriteOutputTo nc1:rttest/btree-index_btree-primary-32.adm
+TypeDecl TestType [
+ open RecordType {
+ fname : string,
+ lname : string
+ }
+]
+DatasetDecl testdst(TestType) partitioned by [[fname], [lname]]
+Query:
+SELECT ELEMENT [
+Variable [ Name=emp ]
+]
+FROM [ FunctionCall Metadata.dataset@1[
+ LiteralExpr [STRING] [testdst]
+ ]
+ AS
+ Variable [ Name=emp ]
+]
+Where
+ OperatorExpr [
+ OperatorExpr [
+ FieldAccessor [
+ Variable [ Name=emp ]
+ Field=fname
+ ]
+ <
+ LiteralExpr [STRING] [Julio]
+ ]
+ and
+ OperatorExpr [
+ FieldAccessor [
+ Variable [ Name=emp ]
+ Field=lname
+ ]
+ =
+ LiteralExpr [STRING] [Xu]
+ ]
+ ]
http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/391f09e5/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/btree-index/btree-secondary-33.ast
----------------------------------------------------------------------
diff --git a/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/btree-index/btree-secondary-33.ast b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/btree-index/btree-secondary-33.ast
new file mode 100644
index 0000000..c75bd69
--- /dev/null
+++ b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/btree-index/btree-secondary-33.ast
@@ -0,0 +1,29 @@
+DataverseUse test
+WriteOutputTo nc1:rttest/btree-index_btree-primary-33.adm
+TypeDecl TestType [
+ open RecordType {
+ id : int32,
+ fname : string,
+ lname : string
+ }
+]
+DatasetDecl testdst(TestType) partitioned by [[id]]
+Query:
+SELECT ELEMENT [
+Variable [ Name=emp ]
+]
+FROM [ FunctionCall Metadata.dataset@1[
+ LiteralExpr [STRING] [testdst]
+ ]
+ AS
+ Variable [ Name=emp ]
+]
+Where
+ OperatorExpr [
+ FieldAccessor [
+ Variable [ Name=emp ]
+ Field=fname
+ ]
+ >
+ LiteralExpr [STRING] [Roger]
+ ]
http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/391f09e5/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/btree-index/btree-secondary-34.ast
----------------------------------------------------------------------
diff --git a/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/btree-index/btree-secondary-34.ast b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/btree-index/btree-secondary-34.ast
new file mode 100644
index 0000000..b30daaa
--- /dev/null
+++ b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/btree-index/btree-secondary-34.ast
@@ -0,0 +1,29 @@
+DataverseUse test
+WriteOutputTo nc1:rttest/btree-index_btree-secondary-34.adm
+TypeDecl TestType [
+ open RecordType {
+ id : int32,
+ fname : string,
+ lname : string
+ }
+]
+DatasetDecl testdst(TestType) partitioned by [[id]]
+Query:
+SELECT ELEMENT [
+Variable [ Name=emp ]
+]
+FROM [ FunctionCall Metadata.dataset@1[
+ LiteralExpr [STRING] [testdst]
+ ]
+ AS
+ Variable [ Name=emp ]
+]
+Where
+ OperatorExpr [
+ FieldAccessor [
+ Variable [ Name=emp ]
+ Field=fname
+ ]
+ >=
+ LiteralExpr [STRING] [Susan]
+ ]
http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/391f09e5/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/btree-index/btree-secondary-35.ast
----------------------------------------------------------------------
diff --git a/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/btree-index/btree-secondary-35.ast b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/btree-index/btree-secondary-35.ast
new file mode 100644
index 0000000..07ebdf7
--- /dev/null
+++ b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/btree-index/btree-secondary-35.ast
@@ -0,0 +1,29 @@
+DataverseUse test
+WriteOutputTo nc1:rttest/btree-index_btree-secondary-35.adm
+TypeDecl TestType [
+ open RecordType {
+ id : int32,
+ fname : string,
+ lname : string
+ }
+]
+DatasetDecl testdst(TestType) partitioned by [[id]]
+Query:
+SELECT ELEMENT [
+Variable [ Name=emp ]
+]
+FROM [ FunctionCall Metadata.dataset@1[
+ LiteralExpr [STRING] [testdst]
+ ]
+ AS
+ Variable [ Name=emp ]
+]
+Where
+ OperatorExpr [
+ FieldAccessor [
+ Variable [ Name=emp ]
+ Field=fname
+ ]
+ <
+ LiteralExpr [STRING] [Isa]
+ ]
http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/391f09e5/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/btree-index/btree-secondary-36.ast
----------------------------------------------------------------------
diff --git a/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/btree-index/btree-secondary-36.ast b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/btree-index/btree-secondary-36.ast
new file mode 100644
index 0000000..ec5a443
--- /dev/null
+++ b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/btree-index/btree-secondary-36.ast
@@ -0,0 +1,29 @@
+DataverseUse test
+WriteOutputTo nc1:rttest/btree-index_btree-secondary-36.adm
+TypeDecl TestType [
+ open RecordType {
+ id : int32,
+ fname : string,
+ lname : string
+ }
+]
+DatasetDecl testdst(TestType) partitioned by [[id]]
+Query:
+SELECT ELEMENT [
+Variable [ Name=emp ]
+]
+FROM [ FunctionCall Metadata.dataset@1[
+ LiteralExpr [STRING] [testdst]
+ ]
+ AS
+ Variable [ Name=emp ]
+]
+Where
+ OperatorExpr [
+ FieldAccessor [
+ Variable [ Name=emp ]
+ Field=fname
+ ]
+ <=
+ LiteralExpr [STRING] [Vanpatten]
+ ]
http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/391f09e5/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/btree-index/btree-secondary-37.ast
----------------------------------------------------------------------
diff --git a/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/btree-index/btree-secondary-37.ast b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/btree-index/btree-secondary-37.ast
new file mode 100644
index 0000000..6065247
--- /dev/null
+++ b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/btree-index/btree-secondary-37.ast
@@ -0,0 +1,29 @@
+DataverseUse test
+WriteOutputTo nc1:rttest/btree-index_btree-secondary-37.adm
+TypeDecl TestType [
+ open RecordType {
+ id : int32,
+ fname : string,
+ lname : string
+ }
+]
+DatasetDecl testdst(TestType) partitioned by [[id]]
+Query:
+SELECT ELEMENT [
+Variable [ Name=emp ]
+]
+FROM [ FunctionCall Metadata.dataset@1[
+ LiteralExpr [STRING] [testdst]
+ ]
+ AS
+ Variable [ Name=emp ]
+]
+Where
+ OperatorExpr [
+ FieldAccessor [
+ Variable [ Name=emp ]
+ Field=fname
+ ]
+ !=
+ LiteralExpr [STRING] [Max]
+ ]
http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/391f09e5/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/btree-index/btree-secondary-38.ast
----------------------------------------------------------------------
diff --git a/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/btree-index/btree-secondary-38.ast b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/btree-index/btree-secondary-38.ast
new file mode 100644
index 0000000..1a0fdff
--- /dev/null
+++ b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/btree-index/btree-secondary-38.ast
@@ -0,0 +1,29 @@
+DataverseUse test
+WriteOutputTo nc1:rttest/btree-index_btree-secondary-38.adm
+TypeDecl TestType [
+ open RecordType {
+ id : int32,
+ fname : string,
+ lname : string
+ }
+]
+DatasetDecl testdst(TestType) partitioned by [[id]]
+Query:
+SELECT ELEMENT [
+Variable [ Name=emp ]
+]
+FROM [ FunctionCall Metadata.dataset@1[
+ LiteralExpr [STRING] [testdst]
+ ]
+ AS
+ Variable [ Name=emp ]
+]
+Where
+ OperatorExpr [
+ FieldAccessor [
+ Variable [ Name=emp ]
+ Field=fname
+ ]
+ =
+ LiteralExpr [STRING] [Julio]
+ ]
http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/391f09e5/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/btree-index/btree-secondary-39.ast
----------------------------------------------------------------------
diff --git a/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/btree-index/btree-secondary-39.ast b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/btree-index/btree-secondary-39.ast
new file mode 100644
index 0000000..bfd613a
--- /dev/null
+++ b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/btree-index/btree-secondary-39.ast
@@ -0,0 +1,29 @@
+DataverseUse test
+WriteOutputTo nc1:rttest/btree-index_btree-secondary-39.adm
+TypeDecl TestType [
+ open RecordType {
+ id : int32,
+ fname : string,
+ lname : string
+ }
+]
+DatasetDecl testdst(TestType) partitioned by [[id]]
+Query:
+SELECT ELEMENT [
+Variable [ Name=emp ]
+]
+FROM [ FunctionCall Metadata.dataset@1[
+ LiteralExpr [STRING] [testdst]
+ ]
+ AS
+ Variable [ Name=emp ]
+]
+Where
+ OperatorExpr [
+ FieldAccessor [
+ Variable [ Name=emp ]
+ Field=lname
+ ]
+ =
+ LiteralExpr [STRING] [Kim]
+ ]
http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/391f09e5/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/btree-index/btree-secondary-40.ast
----------------------------------------------------------------------
diff --git a/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/btree-index/btree-secondary-40.ast b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/btree-index/btree-secondary-40.ast
new file mode 100644
index 0000000..aa9bf67
--- /dev/null
+++ b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/btree-index/btree-secondary-40.ast
@@ -0,0 +1,40 @@
+DataverseUse test
+WriteOutputTo nc1:rttest/btree-index_btree-secondary-40.adm
+TypeDecl TestType [
+ open RecordType {
+ id : int32,
+ fname : string,
+ lname : string
+ }
+]
+DatasetDecl testdst(TestType) partitioned by [[id]]
+Query:
+SELECT ELEMENT [
+Variable [ Name=emp ]
+]
+FROM [ FunctionCall Metadata.dataset@1[
+ LiteralExpr [STRING] [testdst]
+ ]
+ AS
+ Variable [ Name=emp ]
+]
+Where
+ OperatorExpr [
+ OperatorExpr [
+ FieldAccessor [
+ Variable [ Name=emp ]
+ Field=fname
+ ]
+ =
+ LiteralExpr [STRING] [Young Seok]
+ ]
+ and
+ OperatorExpr [
+ FieldAccessor [
+ Variable [ Name=emp ]
+ Field=lname
+ ]
+ =
+ LiteralExpr [STRING] [Kim]
+ ]
+ ]
http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/391f09e5/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/btree-index/btree-secondary-41.ast
----------------------------------------------------------------------
diff --git a/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/btree-index/btree-secondary-41.ast b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/btree-index/btree-secondary-41.ast
new file mode 100644
index 0000000..603c195
--- /dev/null
+++ b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/btree-index/btree-secondary-41.ast
@@ -0,0 +1,40 @@
+DataverseUse test
+WriteOutputTo nc1:rttest/btree-index_btree-secondary-41.adm
+TypeDecl TestType [
+ open RecordType {
+ id : int32,
+ fname : string,
+ lname : string
+ }
+]
+DatasetDecl testdst(TestType) partitioned by [[id]]
+Query:
+SELECT ELEMENT [
+Variable [ Name=emp ]
+]
+FROM [ FunctionCall Metadata.dataset@1[
+ LiteralExpr [STRING] [testdst]
+ ]
+ AS
+ Variable [ Name=emp ]
+]
+Where
+ OperatorExpr [
+ OperatorExpr [
+ FieldAccessor [
+ Variable [ Name=emp ]
+ Field=fname
+ ]
+ =
+ LiteralExpr [STRING] [Julio]
+ ]
+ or
+ OperatorExpr [
+ FieldAccessor [
+ Variable [ Name=emp ]
+ Field=lname
+ ]
+ =
+ LiteralExpr [STRING] [Malaika]
+ ]
+ ]
http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/391f09e5/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/btree-index/btree-secondary-42.ast
----------------------------------------------------------------------
diff --git a/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/btree-index/btree-secondary-42.ast b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/btree-index/btree-secondary-42.ast
new file mode 100644
index 0000000..6254e7e
--- /dev/null
+++ b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/btree-index/btree-secondary-42.ast
@@ -0,0 +1,40 @@
+DataverseUse test
+WriteOutputTo nc1:rttest/btree-index_btree-secondary-42.adm
+TypeDecl TestType [
+ open RecordType {
+ id : int32,
+ fname : string,
+ lname : string
+ }
+]
+DatasetDecl testdst(TestType) partitioned by [[id]]
+Query:
+SELECT ELEMENT [
+Variable [ Name=emp ]
+]
+FROM [ FunctionCall Metadata.dataset@1[
+ LiteralExpr [STRING] [testdst]
+ ]
+ AS
+ Variable [ Name=emp ]
+]
+Where
+ OperatorExpr [
+ OperatorExpr [
+ FieldAccessor [
+ Variable [ Name=emp ]
+ Field=fname
+ ]
+ >
+ LiteralExpr [STRING] [Alex]
+ ]
+ and
+ OperatorExpr [
+ FieldAccessor [
+ Variable [ Name=emp ]
+ Field=lname
+ ]
+ <
+ LiteralExpr [STRING] [Zach]
+ ]
+ ]
http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/391f09e5/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/btree-index/btree-secondary-43.ast
----------------------------------------------------------------------
diff --git a/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/btree-index/btree-secondary-43.ast b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/btree-index/btree-secondary-43.ast
new file mode 100644
index 0000000..45b3d8c
--- /dev/null
+++ b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/btree-index/btree-secondary-43.ast
@@ -0,0 +1,40 @@
+DataverseUse test
+WriteOutputTo nc1:rttest/btree-index_btree-secondary-43.adm
+TypeDecl TestType [
+ open RecordType {
+ id : int32,
+ fname : string,
+ lname : string
+ }
+]
+DatasetDecl testdst(TestType) partitioned by [[id]]
+Query:
+SELECT ELEMENT [
+Variable [ Name=emp ]
+]
+FROM [ FunctionCall Metadata.dataset@1[
+ LiteralExpr [STRING] [testdst]
+ ]
+ AS
+ Variable [ Name=emp ]
+]
+Where
+ OperatorExpr [
+ OperatorExpr [
+ FieldAccessor [
+ Variable [ Name=emp ]
+ Field=fname
+ ]
+ >
+ LiteralExpr [STRING] [Allan]
+ ]
+ and
+ OperatorExpr [
+ FieldAccessor [
+ Variable [ Name=emp ]
+ Field=lname
+ ]
+ <
+ LiteralExpr [STRING] [Zubi]
+ ]
+ ]
http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/391f09e5/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/btree-index/btree-secondary-44.ast
----------------------------------------------------------------------
diff --git a/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/btree-index/btree-secondary-44.ast b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/btree-index/btree-secondary-44.ast
new file mode 100644
index 0000000..9b88340
--- /dev/null
+++ b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/btree-index/btree-secondary-44.ast
@@ -0,0 +1,40 @@
+DataverseUse test
+WriteOutputTo nc1:rttest/btree-index_btree-secondary-44.adm
+TypeDecl TestType [
+ open RecordType {
+ id : int32,
+ fname : string,
+ lname : string
+ }
+]
+DatasetDecl testdst(TestType) partitioned by [[id]]
+Query:
+SELECT ELEMENT [
+Variable [ Name=emp ]
+]
+FROM [ FunctionCall Metadata.dataset@1[
+ LiteralExpr [STRING] [testdst]
+ ]
+ AS
+ Variable [ Name=emp ]
+]
+Where
+ OperatorExpr [
+ OperatorExpr [
+ FieldAccessor [
+ Variable [ Name=emp ]
+ Field=fname
+ ]
+ >
+ LiteralExpr [STRING] [Allan]
+ ]
+ and
+ OperatorExpr [
+ FieldAccessor [
+ Variable [ Name=emp ]
+ Field=lname
+ ]
+ =
+ LiteralExpr [STRING] [Xu]
+ ]
+ ]
http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/391f09e5/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/btree-index/btree-secondary-45.ast
----------------------------------------------------------------------
diff --git a/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/btree-index/btree-secondary-45.ast b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/btree-index/btree-secondary-45.ast
new file mode 100644
index 0000000..77d5eb1
--- /dev/null
+++ b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/btree-index/btree-secondary-45.ast
@@ -0,0 +1,40 @@
+DataverseUse test
+WriteOutputTo nc1:rttest/btree-index_btree-secondary-45.adm
+TypeDecl TestType [
+ open RecordType {
+ id : int32,
+ fname : string,
+ lname : string
+ }
+]
+DatasetDecl testdst(TestType) partitioned by [[id]]
+Query:
+SELECT ELEMENT [
+Variable [ Name=emp ]
+]
+FROM [ FunctionCall Metadata.dataset@1[
+ LiteralExpr [STRING] [testdst]
+ ]
+ AS
+ Variable [ Name=emp ]
+]
+Where
+ OperatorExpr [
+ OperatorExpr [
+ FieldAccessor [
+ Variable [ Name=emp ]
+ Field=fname
+ ]
+ =
+ LiteralExpr [STRING] [Julio]
+ ]
+ and
+ OperatorExpr [
+ FieldAccessor [
+ Variable [ Name=emp ]
+ Field=lname
+ ]
+ <
+ LiteralExpr [STRING] [Xu]
+ ]
+ ]
http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/391f09e5/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/btree-index/btree-secondary-46.ast
----------------------------------------------------------------------
diff --git a/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/btree-index/btree-secondary-46.ast b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/btree-index/btree-secondary-46.ast
new file mode 100644
index 0000000..75cdaab
--- /dev/null
+++ b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/btree-index/btree-secondary-46.ast
@@ -0,0 +1,40 @@
+DataverseUse test
+WriteOutputTo nc1:rttest/btree-index_btree-secondary-46.adm
+TypeDecl TestType [
+ open RecordType {
+ id : int32,
+ fname : string,
+ lname : string
+ }
+]
+DatasetDecl testdst(TestType) partitioned by [[id]]
+Query:
+SELECT ELEMENT [
+Variable [ Name=emp ]
+]
+FROM [ FunctionCall Metadata.dataset@1[
+ LiteralExpr [STRING] [testdst]
+ ]
+ AS
+ Variable [ Name=emp ]
+]
+Where
+ OperatorExpr [
+ OperatorExpr [
+ FieldAccessor [
+ Variable [ Name=emp ]
+ Field=fname
+ ]
+ >=
+ LiteralExpr [STRING] [Michael]
+ ]
+ and
+ OperatorExpr [
+ FieldAccessor [
+ Variable [ Name=emp ]
+ Field=lname
+ ]
+ <=
+ LiteralExpr [STRING] [Xu]
+ ]
+ ]
http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/391f09e5/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/btree-index/btree-secondary-47.ast
----------------------------------------------------------------------
diff --git a/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/btree-index/btree-secondary-47.ast b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/btree-index/btree-secondary-47.ast
new file mode 100644
index 0000000..9bace09
--- /dev/null
+++ b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/btree-index/btree-secondary-47.ast
@@ -0,0 +1,58 @@
+DataverseUse test
+WriteOutputTo nc1:rttest/btree-index_btree-secondary-47.adm
+TypeDecl TestType [
+ open RecordType {
+ id : int32,
+ fname : string,
+ lname : string
+ }
+]
+DatasetDecl testdst(TestType) partitioned by [[id]]
+Query:
+SELECT ELEMENT [
+Variable [ Name=emp ]
+]
+FROM [ FunctionCall Metadata.dataset@1[
+ LiteralExpr [STRING] [testdst]
+ ]
+ AS
+ Variable [ Name=emp ]
+]
+Where
+ OperatorExpr [
+ OperatorExpr [
+ FieldAccessor [
+ Variable [ Name=emp ]
+ Field=fname
+ ]
+ >
+ LiteralExpr [STRING] [Craig]
+ ]
+ and
+ OperatorExpr [
+ FieldAccessor [
+ Variable [ Name=emp ]
+ Field=lname
+ ]
+ >
+ LiteralExpr [STRING] [Kevin]
+ ]
+ and
+ OperatorExpr [
+ FieldAccessor [
+ Variable [ Name=emp ]
+ Field=fname
+ ]
+ <
+ LiteralExpr [STRING] [Mary]
+ ]
+ and
+ OperatorExpr [
+ FieldAccessor [
+ Variable [ Name=emp ]
+ Field=lname
+ ]
+ <
+ LiteralExpr [STRING] [Tomes]
+ ]
+ ]
http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/391f09e5/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/btree-index/btree-secondary-48.ast
----------------------------------------------------------------------
diff --git a/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/btree-index/btree-secondary-48.ast b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/btree-index/btree-secondary-48.ast
new file mode 100644
index 0000000..58e8c0d
--- /dev/null
+++ b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/btree-index/btree-secondary-48.ast
@@ -0,0 +1,58 @@
+DataverseUse test
+WriteOutputTo nc1:rttest/btree-index_btree-secondary-48.adm
+TypeDecl TestType [
+ open RecordType {
+ id : int32,
+ fname : string,
+ lname : string
+ }
+]
+DatasetDecl testdst(TestType) partitioned by [[id]]
+Query:
+SELECT ELEMENT [
+Variable [ Name=emp ]
+]
+FROM [ FunctionCall Metadata.dataset@1[
+ LiteralExpr [STRING] [testdst]
+ ]
+ AS
+ Variable [ Name=emp ]
+]
+Where
+ OperatorExpr [
+ OperatorExpr [
+ FieldAccessor [
+ Variable [ Name=emp ]
+ Field=fname
+ ]
+ >=
+ LiteralExpr [STRING] [Craig]
+ ]
+ and
+ OperatorExpr [
+ FieldAccessor [
+ Variable [ Name=emp ]
+ Field=lname
+ ]
+ >=
+ LiteralExpr [STRING] [Kevin]
+ ]
+ and
+ OperatorExpr [
+ FieldAccessor [
+ Variable [ Name=emp ]
+ Field=fname
+ ]
+ <=
+ LiteralExpr [STRING] [Mary]
+ ]
+ and
+ OperatorExpr [
+ FieldAccessor [
+ Variable [ Name=emp ]
+ Field=lname
+ ]
+ <=
+ LiteralExpr [STRING] [Tomes]
+ ]
+ ]
http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/391f09e5/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/btree-index/btree-secondary-49.ast
----------------------------------------------------------------------
diff --git a/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/btree-index/btree-secondary-49.ast b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/btree-index/btree-secondary-49.ast
new file mode 100644
index 0000000..42aa6f3
--- /dev/null
+++ b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/btree-index/btree-secondary-49.ast
@@ -0,0 +1,40 @@
+DataverseUse test
+WriteOutputTo nc1:rttest/btree-index_btree-secondary-49.adm
+TypeDecl TestType [
+ open RecordType {
+ id : int32,
+ fname : string,
+ lname : string
+ }
+]
+DatasetDecl testdst(TestType) partitioned by [[id]]
+Query:
+SELECT ELEMENT [
+Variable [ Name=emp ]
+]
+FROM [ FunctionCall Metadata.dataset@1[
+ LiteralExpr [STRING] [testdst]
+ ]
+ AS
+ Variable [ Name=emp ]
+]
+Where
+ OperatorExpr [
+ OperatorExpr [
+ FieldAccessor [
+ Variable [ Name=emp ]
+ Field=fname
+ ]
+ <=
+ LiteralExpr [STRING] [Craig]
+ ]
+ and
+ OperatorExpr [
+ FieldAccessor [
+ Variable [ Name=emp ]
+ Field=lname
+ ]
+ >
+ LiteralExpr [STRING] [Kevin]
+ ]
+ ]
http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/391f09e5/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/btree-index/btree-secondary-50.ast
----------------------------------------------------------------------
diff --git a/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/btree-index/btree-secondary-50.ast b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/btree-index/btree-secondary-50.ast
new file mode 100644
index 0000000..96b2c09
--- /dev/null
+++ b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/btree-index/btree-secondary-50.ast
@@ -0,0 +1,40 @@
+DataverseUse test
+WriteOutputTo nc1:rttest/btree-index_btree-secondary-50.adm
+TypeDecl TestType [
+ open RecordType {
+ id : int32,
+ fname : string,
+ lname : string
+ }
+]
+DatasetDecl testdst(TestType) partitioned by [[id]]
+Query:
+SELECT ELEMENT [
+Variable [ Name=emp ]
+]
+FROM [ FunctionCall Metadata.dataset@1[
+ LiteralExpr [STRING] [testdst]
+ ]
+ AS
+ Variable [ Name=emp ]
+]
+Where
+ OperatorExpr [
+ OperatorExpr [
+ FieldAccessor [
+ Variable [ Name=emp ]
+ Field=fname
+ ]
+ !=
+ LiteralExpr [STRING] [Michael]
+ ]
+ and
+ OperatorExpr [
+ FieldAccessor [
+ Variable [ Name=emp ]
+ Field=lname
+ ]
+ !=
+ LiteralExpr [STRING] [Carey]
+ ]
+ ]
http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/391f09e5/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/btree-index/btree-secondary-51.ast
----------------------------------------------------------------------
diff --git a/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/btree-index/btree-secondary-51.ast b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/btree-index/btree-secondary-51.ast
new file mode 100644
index 0000000..ee61d0b
--- /dev/null
+++ b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/btree-index/btree-secondary-51.ast
@@ -0,0 +1,58 @@
+DataverseUse test
+WriteOutputTo nc1:rttest/btree-index_btree-secondary-51.adm
+TypeDecl TestType [
+ open RecordType {
+ id : int32,
+ fname : string,
+ lname : string
+ }
+]
+DatasetDecl testdst(TestType) partitioned by [[id]]
+Query:
+SELECT ELEMENT [
+Variable [ Name=emp ]
+]
+FROM [ FunctionCall Metadata.dataset@1[
+ LiteralExpr [STRING] [testdst]
+ ]
+ AS
+ Variable [ Name=emp ]
+]
+Where
+ OperatorExpr [
+ OperatorExpr [
+ FieldAccessor [
+ Variable [ Name=emp ]
+ Field=fname
+ ]
+ >
+ LiteralExpr [STRING] [Craig]
+ ]
+ and
+ OperatorExpr [
+ FieldAccessor [
+ Variable [ Name=emp ]
+ Field=lname
+ ]
+ >
+ LiteralExpr [STRING] [Kevin]
+ ]
+ and
+ OperatorExpr [
+ FieldAccessor [
+ Variable [ Name=emp ]
+ Field=fname
+ ]
+ <=
+ LiteralExpr [STRING] [Mary]
+ ]
+ and
+ OperatorExpr [
+ FieldAccessor [
+ Variable [ Name=emp ]
+ Field=lname
+ ]
+ <=
+ LiteralExpr [STRING] [Tomes]
+ ]
+ ]
http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/391f09e5/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/btree-index/btree-secondary-52.ast
----------------------------------------------------------------------
diff --git a/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/btree-index/btree-secondary-52.ast b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/btree-index/btree-secondary-52.ast
new file mode 100644
index 0000000..61475c9
--- /dev/null
+++ b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/btree-index/btree-secondary-52.ast
@@ -0,0 +1,58 @@
+DataverseUse test
+WriteOutputTo nc1:rttest/btree-index_btree-secondary-52.adm
+TypeDecl TestType [
+ open RecordType {
+ id : int32,
+ fname : string,
+ lname : string
+ }
+]
+DatasetDecl testdst(TestType) partitioned by [[id]]
+Query:
+SELECT ELEMENT [
+Variable [ Name=emp ]
+]
+FROM [ FunctionCall Metadata.dataset@1[
+ LiteralExpr [STRING] [testdst]
+ ]
+ AS
+ Variable [ Name=emp ]
+]
+Where
+ OperatorExpr [
+ OperatorExpr [
+ FieldAccessor [
+ Variable [ Name=emp ]
+ Field=fname
+ ]
+ >=
+ LiteralExpr [STRING] [Craig]
+ ]
+ and
+ OperatorExpr [
+ FieldAccessor [
+ Variable [ Name=emp ]
+ Field=lname
+ ]
+ >=
+ LiteralExpr [STRING] [Kevin]
+ ]
+ and
+ OperatorExpr [
+ FieldAccessor [
+ Variable [ Name=emp ]
+ Field=fname
+ ]
+ <
+ LiteralExpr [STRING] [Mary]
+ ]
+ and
+ OperatorExpr [
+ FieldAccessor [
+ Variable [ Name=emp ]
+ Field=lname
+ ]
+ <
+ LiteralExpr [STRING] [Tomes]
+ ]
+ ]
http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/391f09e5/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/btree-index/btree-secondary-53.ast
----------------------------------------------------------------------
diff --git a/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/btree-index/btree-secondary-53.ast b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/btree-index/btree-secondary-53.ast
new file mode 100644
index 0000000..05278a5
--- /dev/null
+++ b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/btree-index/btree-secondary-53.ast
@@ -0,0 +1,58 @@
+DataverseUse test
+WriteOutputTo nc1:rttest/btree-index_btree-secondary-53.adm
+TypeDecl TestType [
+ open RecordType {
+ id : int32,
+ fname : string,
+ lname : string
+ }
+]
+DatasetDecl testdst(TestType) partitioned by [[id]]
+Query:
+SELECT ELEMENT [
+Variable [ Name=emp ]
+]
+FROM [ FunctionCall Metadata.dataset@1[
+ LiteralExpr [STRING] [testdst]
+ ]
+ AS
+ Variable [ Name=emp ]
+]
+Where
+ OperatorExpr [
+ OperatorExpr [
+ FieldAccessor [
+ Variable [ Name=emp ]
+ Field=fname
+ ]
+ >=
+ LiteralExpr [STRING] [Craig]
+ ]
+ and
+ OperatorExpr [
+ FieldAccessor [
+ Variable [ Name=emp ]
+ Field=lname
+ ]
+ <=
+ LiteralExpr [STRING] [Kevin]
+ ]
+ and
+ OperatorExpr [
+ FieldAccessor [
+ Variable [ Name=emp ]
+ Field=fname
+ ]
+ <=
+ LiteralExpr [STRING] [Mary]
+ ]
+ and
+ OperatorExpr [
+ FieldAccessor [
+ Variable [ Name=emp ]
+ Field=lname
+ ]
+ >=
+ LiteralExpr [STRING] [Tomes]
+ ]
+ ]
http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/391f09e5/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/btree-index/btree-secondary-54.ast
----------------------------------------------------------------------
diff --git a/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/btree-index/btree-secondary-54.ast b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/btree-index/btree-secondary-54.ast
new file mode 100644
index 0000000..5fbf88d
--- /dev/null
+++ b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/btree-index/btree-secondary-54.ast
@@ -0,0 +1,29 @@
+DataverseUse test
+WriteOutputTo nc1:rttest/btree-index_btree-secondary-54.adm
+TypeDecl TestType [
+ open RecordType {
+ id : int32,
+ fname : string,
+ lname : string
+ }
+]
+DatasetDecl testdst(TestType) partitioned by [[id]]
+Query:
+SELECT ELEMENT [
+Variable [ Name=emp ]
+]
+FROM [ FunctionCall Metadata.dataset@1[
+ LiteralExpr [STRING] [testdst]
+ ]
+ AS
+ Variable [ Name=emp ]
+]
+Where
+ OperatorExpr [
+ FieldAccessor [
+ Variable [ Name=emp ]
+ Field=fname
+ ]
+ >
+ LiteralExpr [STRING] [Max]
+ ]
http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/391f09e5/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/btree-index/btree-secondary-55.ast
----------------------------------------------------------------------
diff --git a/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/btree-index/btree-secondary-55.ast b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/btree-index/btree-secondary-55.ast
new file mode 100644
index 0000000..bd2ddb1
--- /dev/null
+++ b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/btree-index/btree-secondary-55.ast
@@ -0,0 +1,29 @@
+DataverseUse test
+WriteOutputTo nc1:rttest/btree-index_btree-secondary-55.adm
+TypeDecl TestType [
+ open RecordType {
+ id : int32,
+ fname : string,
+ lname : string
+ }
+]
+DatasetDecl testdst(TestType) partitioned by [[id]]
+Query:
+SELECT ELEMENT [
+Variable [ Name=emp ]
+]
+FROM [ FunctionCall Metadata.dataset@1[
+ LiteralExpr [STRING] [testdst]
+ ]
+ AS
+ Variable [ Name=emp ]
+]
+Where
+ OperatorExpr [
+ FieldAccessor [
+ Variable [ Name=emp ]
+ Field=fname
+ ]
+ >=
+ LiteralExpr [STRING] [Sofia]
+ ]
http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/391f09e5/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/btree-index/btree-secondary-56.ast
----------------------------------------------------------------------
diff --git a/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/btree-index/btree-secondary-56.ast b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/btree-index/btree-secondary-56.ast
new file mode 100644
index 0000000..a36f447
--- /dev/null
+++ b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/btree-index/btree-secondary-56.ast
@@ -0,0 +1,29 @@
+DataverseUse test
+WriteOutputTo nc1:rttest/btree-index_btree-secondary-56.adm
+TypeDecl TestType [
+ open RecordType {
+ id : int32,
+ fname : string,
+ lname : string
+ }
+]
+DatasetDecl testdst(TestType) partitioned by [[id]]
+Query:
+SELECT ELEMENT [
+Variable [ Name=emp ]
+]
+FROM [ FunctionCall Metadata.dataset@1[
+ LiteralExpr [STRING] [testdst]
+ ]
+ AS
+ Variable [ Name=emp ]
+]
+Where
+ OperatorExpr [
+ FieldAccessor [
+ Variable [ Name=emp ]
+ Field=fname
+ ]
+ <
+ LiteralExpr [STRING] [Chen]
+ ]
http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/391f09e5/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/btree-index/btree-secondary-57.ast
----------------------------------------------------------------------
diff --git a/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/btree-index/btree-secondary-57.ast b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/btree-index/btree-secondary-57.ast
new file mode 100644
index 0000000..3c6bd5c
--- /dev/null
+++ b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/btree-index/btree-secondary-57.ast
@@ -0,0 +1,29 @@
+DataverseUse test
+WriteOutputTo nc1:rttest/btree-index_btree-secondary-57.adm
+TypeDecl TestType [
+ open RecordType {
+ id : int32,
+ fname : string,
+ lname : string
+ }
+]
+DatasetDecl testdst(TestType) partitioned by [[id]]
+Query:
+SELECT ELEMENT [
+Variable [ Name=emp ]
+]
+FROM [ FunctionCall Metadata.dataset@1[
+ LiteralExpr [STRING] [testdst]
+ ]
+ AS
+ Variable [ Name=emp ]
+]
+Where
+ OperatorExpr [
+ FieldAccessor [
+ Variable [ Name=emp ]
+ Field=fname
+ ]
+ <=
+ LiteralExpr [STRING] [Julio]
+ ]
http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/391f09e5/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/btree-index/btree-secondary-58.ast
----------------------------------------------------------------------
diff --git a/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/btree-index/btree-secondary-58.ast b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/btree-index/btree-secondary-58.ast
new file mode 100644
index 0000000..5765a06
--- /dev/null
+++ b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/btree-index/btree-secondary-58.ast
@@ -0,0 +1,40 @@
+DataverseUse test
+WriteOutputTo nc1:rttest/btree-index_btree-primary-58.adm
+TypeDecl TestType [
+ open RecordType {
+ id : int32,
+ fname : string,
+ lname : string
+ }
+]
+DatasetDecl testdst(TestType) partitioned by [[id]]
+Query:
+SELECT ELEMENT [
+Variable [ Name=emp ]
+]
+FROM [ FunctionCall Metadata.dataset@1[
+ LiteralExpr [STRING] [testdst]
+ ]
+ AS
+ Variable [ Name=emp ]
+]
+Where
+ OperatorExpr [
+ OperatorExpr [
+ FieldAccessor [
+ Variable [ Name=emp ]
+ Field=fname
+ ]
+ >
+ LiteralExpr [STRING] [Neil]
+ ]
+ and
+ OperatorExpr [
+ FieldAccessor [
+ Variable [ Name=emp ]
+ Field=fname
+ ]
+ <
+ LiteralExpr [STRING] [Roger]
+ ]
+ ]
http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/391f09e5/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/btree-index/btree-secondary-59.ast
----------------------------------------------------------------------
diff --git a/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/btree-index/btree-secondary-59.ast b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/btree-index/btree-secondary-59.ast
new file mode 100644
index 0000000..7f64667
--- /dev/null
+++ b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/btree-index/btree-secondary-59.ast
@@ -0,0 +1,40 @@
+DataverseUse test
+WriteOutputTo nc1:rttest/btree-index_btree-secondary-59.adm
+TypeDecl TestType [
+ open RecordType {
+ id : int32,
+ fname : string,
+ lname : string
+ }
+]
+DatasetDecl testdst(TestType) partitioned by [[id]]
+Query:
+SELECT ELEMENT [
+Variable [ Name=emp ]
+]
+FROM [ FunctionCall Metadata.dataset@1[
+ LiteralExpr [STRING] [testdst]
+ ]
+ AS
+ Variable [ Name=emp ]
+]
+Where
+ OperatorExpr [
+ OperatorExpr [
+ FieldAccessor [
+ Variable [ Name=emp ]
+ Field=fname
+ ]
+ >=
+ LiteralExpr [STRING] [Max]
+ ]
+ and
+ OperatorExpr [
+ FieldAccessor [
+ Variable [ Name=emp ]
+ Field=fname
+ ]
+ <=
+ LiteralExpr [STRING] [Roger]
+ ]
+ ]
http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/391f09e5/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/btree-index/btree-secondary-60.ast
----------------------------------------------------------------------
diff --git a/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/btree-index/btree-secondary-60.ast b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/btree-index/btree-secondary-60.ast
new file mode 100644
index 0000000..fd76fa1
--- /dev/null
+++ b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/btree-index/btree-secondary-60.ast
@@ -0,0 +1,29 @@
+DataverseUse test
+WriteOutputTo nc1:rttest/btree-index_btree-secondary-60.adm
+TypeDecl TestType [
+ open RecordType {
+ id : int32,
+ fname : string,
+ lname : string
+ }
+]
+DatasetDecl testdst(TestType) partitioned by [[id]]
+Query:
+SELECT ELEMENT [
+Variable [ Name=emp ]
+]
+FROM [ FunctionCall Metadata.dataset@1[
+ LiteralExpr [STRING] [testdst]
+ ]
+ AS
+ Variable [ Name=emp ]
+]
+Where
+ OperatorExpr [
+ FieldAccessor [
+ Variable [ Name=emp ]
+ Field=fname
+ ]
+ =
+ LiteralExpr [STRING] [Max]
+ ]
http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/391f09e5/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/btree-index/btree-secondary-61.ast
----------------------------------------------------------------------
diff --git a/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/btree-index/btree-secondary-61.ast b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/btree-index/btree-secondary-61.ast
new file mode 100644
index 0000000..21bce85
--- /dev/null
+++ b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/btree-index/btree-secondary-61.ast
@@ -0,0 +1,58 @@
+DataverseUse test
+WriteOutputTo nc1:rttest/btree-index_btree-secondary-61.adm
+TypeDecl TestType [
+ open RecordType {
+ id : int32,
+ fname : string,
+ lname : string
+ }
+]
+DatasetDecl testdst(TestType) partitioned by [[id]]
+Query:
+SELECT ELEMENT [
+Variable [ Name=emp ]
+]
+FROM [ FunctionCall Metadata.dataset@1[
+ LiteralExpr [STRING] [testdst]
+ ]
+ AS
+ Variable [ Name=emp ]
+]
+Where
+ OperatorExpr [
+ OperatorExpr [
+ FieldAccessor [
+ Variable [ Name=emp ]
+ Field=fname
+ ]
+ >
+ LiteralExpr [STRING] [Craig]
+ ]
+ and
+ OperatorExpr [
+ FieldAccessor [
+ Variable [ Name=emp ]
+ Field=lname
+ ]
+ >
+ LiteralExpr [STRING] [Kevin]
+ ]
+ and
+ OperatorExpr [
+ FieldAccessor [
+ Variable [ Name=emp ]
+ Field=fname
+ ]
+ <=
+ LiteralExpr [STRING] [Mary]
+ ]
+ and
+ OperatorExpr [
+ FieldAccessor [
+ Variable [ Name=emp ]
+ Field=lname
+ ]
+ <
+ LiteralExpr [STRING] [Tomes]
+ ]
+ ]
http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/391f09e5/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/btree-index/btree-secondary-62.ast
----------------------------------------------------------------------
diff --git a/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/btree-index/btree-secondary-62.ast b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/btree-index/btree-secondary-62.ast
new file mode 100644
index 0000000..1536c49
--- /dev/null
+++ b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/btree-index/btree-secondary-62.ast
@@ -0,0 +1,40 @@
+DataverseUse test
+WriteOutputTo nc1:rttest/btree-index_btree-secondary-62.adm
+TypeDecl TestType [
+ open RecordType {
+ id : int32,
+ fname : string,
+ lname : string
+ }
+]
+DatasetDecl testdst(TestType) partitioned by [[id]]
+Query:
+SELECT ELEMENT [
+Variable [ Name=emp ]
+]
+FROM [ FunctionCall Metadata.dataset@1[
+ LiteralExpr [STRING] [testdst]
+ ]
+ AS
+ Variable [ Name=emp ]
+]
+Where
+ OperatorExpr [
+ OperatorExpr [
+ FieldAccessor [
+ Variable [ Name=emp ]
+ Field=fname
+ ]
+ =
+ LiteralExpr [STRING] [Julio]
+ ]
+ and
+ OperatorExpr [
+ FieldAccessor [
+ Variable [ Name=emp ]
+ Field=lname
+ ]
+ >
+ LiteralExpr [STRING] [Xu]
+ ]
+ ]
http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/391f09e5/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/btree-index/btree-secondary-63.ast
----------------------------------------------------------------------
diff --git a/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/btree-index/btree-secondary-63.ast b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/btree-index/btree-secondary-63.ast
new file mode 100644
index 0000000..ad1b845
--- /dev/null
+++ b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/btree-index/btree-secondary-63.ast
@@ -0,0 +1,40 @@
+DataverseUse test
+WriteOutputTo nc1:rttest/btree-index_btree-secondary-63.adm
+TypeDecl TestType [
+ open RecordType {
+ id : int32,
+ fname : string,
+ lname : string
+ }
+]
+DatasetDecl testdst(TestType) partitioned by [[id]]
+Query:
+SELECT ELEMENT [
+Variable [ Name=emp ]
+]
+FROM [ FunctionCall Metadata.dataset@1[
+ LiteralExpr [STRING] [testdst]
+ ]
+ AS
+ Variable [ Name=emp ]
+]
+Where
+ OperatorExpr [
+ OperatorExpr [
+ FieldAccessor [
+ Variable [ Name=emp ]
+ Field=fname
+ ]
+ <
+ LiteralExpr [STRING] [Julio]
+ ]
+ and
+ OperatorExpr [
+ FieldAccessor [
+ Variable [ Name=emp ]
+ Field=lname
+ ]
+ =
+ LiteralExpr [STRING] [Xu]
+ ]
+ ]
http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/391f09e5/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/collocated.ast
----------------------------------------------------------------------
diff --git a/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/collocated.ast b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/collocated.ast
new file mode 100644
index 0000000..fd9a57d
--- /dev/null
+++ b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/collocated.ast
@@ -0,0 +1,65 @@
+DataverseUse colocated
+TypeDecl UserType [
+ open RecordType {
+ uid : int32,
+ name : string,
+ lottery_numbers : UnorderedList <int32>
+
+ }
+]
+TypeDecl VisitorType [
+ open RecordType {
+ vid : int32,
+ name : string,
+ lottery_numbers : UnorderedList <int32>
+
+ }
+]
+DatasetDecl Users(UserType) partitioned by [[uid]]
+DatasetDecl Visitors(VisitorType) partitioned by [[vid]]
+WriteOutputTo nc1:/tmp/fuzzy1.adm
+Query:
+SELECT ELEMENT [
+RecordConstructor [
+ (
+ LiteralExpr [STRING] [user_name]
+ :
+ FieldAccessor [
+ Variable [ Name=user ]
+ Field=name
+ ]
+ )
+ (
+ LiteralExpr [STRING] [visitor_name]
+ :
+ FieldAccessor [
+ Variable [ Name=visitor ]
+ Field=name
+ ]
+ )
+]
+]
+FROM [ FunctionCall Metadata.dataset@1[
+ LiteralExpr [STRING] [Users]
+ ]
+ AS
+ Variable [ Name=user ]
+,
+ FunctionCall Metadata.dataset@1[
+ LiteralExpr [STRING] [Visitors]
+ ]
+ AS
+ Variable [ Name=visitor ]
+]
+Where
+ OperatorExpr [
+ FieldAccessor [
+ Variable [ Name=user ]
+ Field=uid
+ ]
+ =
+ FieldAccessor [
+ Variable [ Name=visitor ]
+ Field=vid
+ ]
+ ]
http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/391f09e5/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/consolidate-selects-complex.ast
----------------------------------------------------------------------
diff --git a/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/consolidate-selects-complex.ast b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/consolidate-selects-complex.ast
new file mode 100644
index 0000000..787d03f
--- /dev/null
+++ b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/consolidate-selects-complex.ast
@@ -0,0 +1,90 @@
+DataverseUse test
+TypeDecl DBLPType [
+ closed RecordType {
+ id : int32,
+ dblpid : string,
+ title : string,
+ authors : string,
+ misc : string
+ }
+]
+DatasetDecl DBLP(DBLPType) partitioned by [[id]]
+WriteOutputTo nc1:rttest/consolidate-complex-selects.aql
+Query:
+SELECT ELEMENT [
+RecordConstructor [
+ (
+ LiteralExpr [STRING] [Paper]
+ :
+ Variable [ Name=paper_tokens ]
+ )
+ (
+ LiteralExpr [STRING] [Query]
+ :
+ Variable [ Name=query_tokens ]
+ )
+]
+]
+FROM [ FunctionCall Metadata.dataset@1[
+ LiteralExpr [STRING] [DBLP]
+ ]
+ AS
+ Variable [ Name=paper ]
+]
+LetVariable [ Name=paper_tokens ]
+ :=
+ FunctionCall test.word-tokens@1[
+ FieldAccessor [
+ Variable [ Name=paper ]
+ Field=title
+ ]
+ ]
+LetVariable [ Name=query_tokens ]
+ :=
+ FunctionCall test.word-tokens@1[
+ LiteralExpr [STRING] [Transactions for Cooperative Environments]
+ ]
+LetVariable [ Name=jacca ]
+ :=
+ FunctionCall test.similarity-jaccard-check@3[
+ Variable [ Name=paper_tokens ]
+ Variable [ Name=query_tokens ]
+ LiteralExpr [FLOAT] [0.8]
+ ]
+LetVariable [ Name=jaccb ]
+ :=
+ FunctionCall test.similarity-jaccard-check@3[
+ Variable [ Name=paper_tokens ]
+ Variable [ Name=query_tokens ]
+ LiteralExpr [FLOAT] [0.5]
+ ]
+LetVariable [ Name=jaccc ]
+ :=
+ FunctionCall test.similarity-jaccard-check@3[
+ Variable [ Name=paper_tokens ]
+ Variable [ Name=query_tokens ]
+ LiteralExpr [FLOAT] [0.3]
+ ]
+Where
+ OperatorExpr [
+ IndexAccessor [
+ Variable [ Name=jacca ]
+ Index: Variable [ Name=jacca ]
+ ]
+ and
+ IndexAccessor [
+ Variable [ Name=jaccb ]
+ Index: Variable [ Name=jaccb ]
+ ]
+ and
+ OperatorExpr [
+ FieldAccessor [
+ Variable [ Name=paper ]
+ Field=authors
+ ]
+ =
+ LiteralExpr [STRING] [testauth]
+ ]
+ and
+ Variable [ Name=jaccc ]
+ ]
http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/391f09e5/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/consolidate-selects-simple.ast
----------------------------------------------------------------------
diff --git a/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/consolidate-selects-simple.ast b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/consolidate-selects-simple.ast
new file mode 100644
index 0000000..da1791a
--- /dev/null
+++ b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/consolidate-selects-simple.ast
@@ -0,0 +1,63 @@
+DataverseUse test
+TypeDecl CustomerType [
+ closed RecordType {
+ c_custkey : int32,
+ c_name : string,
+ c_address : string,
+ c_nationkey : int32,
+ c_phone : string,
+ c_acctbal : double,
+ c_mktsegment : string,
+ c_comment : string
+ }
+]
+DatasetDecl Customers(CustomerType) partitioned by [[c_custkey]]
+WriteOutputTo nc1:rttest/consolidate-selects-simple.aql
+Query:
+SELECT ELEMENT [
+Variable [ Name=c ]
+]
+FROM [ FunctionCall Metadata.dataset@1[
+ LiteralExpr [STRING] [Customers]
+ ]
+ AS
+ Variable [ Name=c ]
+]
+Where
+ OperatorExpr [
+ OperatorExpr [
+ FieldAccessor [
+ Variable [ Name=c ]
+ Field=c_name
+ ]
+ =
+ LiteralExpr [STRING] [testname]
+ ]
+ and
+ OperatorExpr [
+ FieldAccessor [
+ Variable [ Name=c ]
+ Field=c_address
+ ]
+ =
+ LiteralExpr [STRING] [testaddr]
+ ]
+ and
+ OperatorExpr [
+ FieldAccessor [
+ Variable [ Name=c ]
+ Field=c_nationkey
+ ]
+ =
+ LiteralExpr [LONG] [1]
+ ]
+ and
+ OperatorExpr [
+ FieldAccessor [
+ Variable [ Name=c ]
+ Field=c_phone
+ ]
+ =
+ LiteralExpr [STRING] [123456789]
+ ]
+ ]
http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/391f09e5/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/const-folding.ast
----------------------------------------------------------------------
diff --git a/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/const-folding.ast b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/const-folding.ast
new file mode 100644
index 0000000..7b38d56
--- /dev/null
+++ b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/const-folding.ast
@@ -0,0 +1,31 @@
+DataverseUse test
+WriteOutputTo nc1:rttest/divide.adm
+Query:
+FieldAccessor [
+ RecordConstructor [
+ (
+ LiteralExpr [STRING] [a]
+ :
+ OperatorExpr [
+ LiteralExpr [LONG] [1]
+ +
+ LiteralExpr [LONG] [2]
+ ]
+ )
+ (
+ LiteralExpr [STRING] [b]
+ :
+ IndexAccessor [
+ OrderedListConstructor [
+ LiteralExpr [STRING] [foo]
+ LiteralExpr [STRING] [bar]
+ ]
+ Index: OrderedListConstructor [
+ LiteralExpr [STRING] [foo]
+ LiteralExpr [STRING] [bar]
+ ]
+ ]
+ )
+ ]
+ Field=b
+]
http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/391f09e5/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/count-tweets.ast
----------------------------------------------------------------------
diff --git a/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/count-tweets.ast b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/count-tweets.ast
new file mode 100644
index 0000000..202abef
--- /dev/null
+++ b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/count-tweets.ast
@@ -0,0 +1,58 @@
+DataverseUse twitter
+TypeDecl Tweet [
+ open RecordType {
+ id : int32,
+ tweetid : int64,
+ loc : point,
+ time : datetime,
+ text : string
+ }
+]
+DatasetDecl TwitterData(Tweet)is an external dataset
+WriteOutputTo nc1:/tmp/count-tweets.adm
+Query:
+SELECT ELEMENT [
+RecordConstructor [
+ (
+ LiteralExpr [STRING] [word]
+ :
+ Variable [ Name=tok ]
+ )
+ (
+ LiteralExpr [STRING] [count]
+ :
+ FunctionCall twitter.count@1[
+ Variable [ Name=token ]
+ ]
+ )
+]
+]
+FROM [ FunctionCall Metadata.dataset@1[
+ LiteralExpr [STRING] [TwitterData]
+ ]
+ AS
+ Variable [ Name=t ]
+,
+ FunctionCall Metadata.dataset@1[
+ LiteralExpr [STRING] [tokens]
+ ]
+ AS
+ Variable [ Name=token ]
+]
+LetVariable [ Name=tokens ]
+ :=
+ FunctionCall twitter.word-tokens@1[
+ FieldAccessor [
+ Variable [ Name=t ]
+ Field=text
+ ]
+ ]
+Groupby
+ Variable [ Name=tok ]
+ :=
+ Variable [ Name=token ]
+ With
+ Variable [ Name=tokens ]
+ Variable [ Name=t ]
+ Variable [ Name=token ]
+
http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/391f09e5/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/cust_group_no_agg.ast
----------------------------------------------------------------------
diff --git a/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/cust_group_no_agg.ast b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/cust_group_no_agg.ast
new file mode 100644
index 0000000..c64af19
--- /dev/null
+++ b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/cust_group_no_agg.ast
@@ -0,0 +1,35 @@
+DataverseUse group_no_agg
+TypeDecl CustomerType [
+ closed RecordType {
+ c_custkey : int32,
+ c_name : string,
+ c_address : string,
+ c_nationkey : int32,
+ c_phone : string,
+ c_acctbal : double,
+ c_mktsegment : string,
+ c_comment : string
+ }
+]
+DatasetDecl Customers(CustomerType) partitioned by [[c_custkey]]
+WriteOutputTo nc1:/tmp/.adm
+Query:
+SELECT ELEMENT [
+Variable [ Name=name ]
+]
+FROM [ FunctionCall Metadata.dataset@1[
+ LiteralExpr [STRING] [Customers]
+ ]
+ AS
+ Variable [ Name=c ]
+]
+Groupby
+ Variable [ Name=name ]
+ :=
+ FieldAccessor [
+ Variable [ Name=c ]
+ Field=c_name
+ ]
+ With
+ Variable [ Name=c ]
+
http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/391f09e5/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/denorm-cust-order.ast
----------------------------------------------------------------------
diff --git a/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/denorm-cust-order.ast b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/denorm-cust-order.ast
new file mode 100644
index 0000000..cf92da8
--- /dev/null
+++ b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/denorm-cust-order.ast
@@ -0,0 +1,98 @@
+DataverseUse custorder
+TypeDecl AddressType [
+ closed RecordType {
+ number : int32,
+ street : string,
+ city : string
+ }
+]
+TypeDecl CustomerType [
+ closed RecordType {
+ cid : int32,
+ name : string,
+ age : int32?,
+ address : AddressType?,
+ lastorder : open RecordType {
+ oid : int32,
+ total : float
+ }
+
+ }
+]
+TypeDecl OrderType [
+ closed RecordType {
+ oid : int32,
+ cid : int32,
+ orderstatus : string,
+ orderpriority : string,
+ clerk : string,
+ total : float
+ }
+]
+DatasetDecl Customers(CustomerType) partitioned by [[cid]]
+DatasetDecl Orders(OrderType) partitioned by [[oid]]
+WriteOutputTo nc1:/tmp/custorder.adm
+Query:
+SELECT ELEMENT [
+RecordConstructor [
+ (
+ LiteralExpr [STRING] [cid]
+ :
+ Variable [ Name=cid ]
+ )
+ (
+ LiteralExpr [STRING] [cust]
+ :
+ FunctionCall Metadata.dataset@1[
+ LiteralExpr [STRING] [cust]
+ ]
+ )
+ (
+ LiteralExpr [STRING] [cnt-orders]
+ :
+ FunctionCall custorder.count@1[
+ Variable [ Name=o ]
+ ]
+ )
+ (
+ LiteralExpr [STRING] [orders]
+ :
+ Variable [ Name=o ]
+ )
+]
+]
+FROM [ FunctionCall Metadata.dataset@1[
+ LiteralExpr [STRING] [Customers]
+ ]
+ AS
+ Variable [ Name=c ]
+,
+ FunctionCall Metadata.dataset@1[
+ LiteralExpr [STRING] [Orders]
+ ]
+ AS
+ Variable [ Name=o ]
+]
+Where
+ OperatorExpr [
+ FieldAccessor [
+ Variable [ Name=c ]
+ Field=cid
+ ]
+ =
+ FieldAccessor [
+ Variable [ Name=o ]
+ Field=cid
+ ]
+ ]
+Groupby
+ Variable [ Name=cid ]
+ :=
+ FieldAccessor [
+ Variable [ Name=c ]
+ Field=cid
+ ]
+ With
+ Variable [ Name=c ]
+ Variable [ Name=o ]
+
http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/391f09e5/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/disjunction-to-join-delete-1.ast
----------------------------------------------------------------------
diff --git a/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/disjunction-to-join-delete-1.ast b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/disjunction-to-join-delete-1.ast
new file mode 100644
index 0000000..72cf10d
--- /dev/null
+++ b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/disjunction-to-join-delete-1.ast
@@ -0,0 +1,9 @@
+DataverseUse test
+TypeDecl TestType [
+ open RecordType {
+ id : string,
+ idx : string,
+ no-idx : string
+ }
+]
+DatasetDecl TestSet(TestType) partitioned by [[id]]
http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/391f09e5/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/disjunction-to-join-delete-2.ast
----------------------------------------------------------------------
diff --git a/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/disjunction-to-join-delete-2.ast b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/disjunction-to-join-delete-2.ast
new file mode 100644
index 0000000..72cf10d
--- /dev/null
+++ b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/disjunction-to-join-delete-2.ast
@@ -0,0 +1,9 @@
+DataverseUse test
+TypeDecl TestType [
+ open RecordType {
+ id : string,
+ idx : string,
+ no-idx : string
+ }
+]
+DatasetDecl TestSet(TestType) partitioned by [[id]]
http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/391f09e5/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/disjunction-to-join-delete-3.ast
----------------------------------------------------------------------
diff --git a/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/disjunction-to-join-delete-3.ast b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/disjunction-to-join-delete-3.ast
new file mode 100644
index 0000000..72cf10d
--- /dev/null
+++ b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/disjunction-to-join-delete-3.ast
@@ -0,0 +1,9 @@
+DataverseUse test
+TypeDecl TestType [
+ open RecordType {
+ id : string,
+ idx : string,
+ no-idx : string
+ }
+]
+DatasetDecl TestSet(TestType) partitioned by [[id]]
http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/391f09e5/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/distinct_aggregate.ast
----------------------------------------------------------------------
diff --git a/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/distinct_aggregate.ast b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/distinct_aggregate.ast
new file mode 100644
index 0000000..44d9754
--- /dev/null
+++ b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/distinct_aggregate.ast
@@ -0,0 +1,128 @@
+DataverseUse tpch
+TypeDecl LineItemType [
+ closed RecordType {
+ l_orderkey : int32,
+ l_partkey : int32,
+ l_suppkey : int32,
+ l_linenumber : int32,
+ l_quantity : double,
+ l_extendedprice : double,
+ l_discount : double,
+ l_tax : double,
+ l_returnflag : string,
+ l_linestatus : string,
+ l_shipdate : string,
+ l_commitdate : string,
+ l_receiptdate : string,
+ l_shipinstruct : string,
+ l_shipmode : string,
+ l_comment : string
+ }
+]
+DatasetDecl LineItems_q1(LineItemType) partitioned by [[l_orderkey], [l_linenumber]]
+WriteOutputTo nc1:rttest/tpch_q1_pricing_summary_report_nt.adm
+Query:
+SELECT ELEMENT [
+RecordConstructor [
+ (
+ LiteralExpr [STRING] [l_returnflag]
+ :
+ Variable [ Name=l_returnflag ]
+ )
+ (
+ LiteralExpr [STRING] [l_linestatus]
+ :
+ Variable [ Name=l_linestatus ]
+ )
+ (
+ LiteralExpr [STRING] [count_suppkey]
+ :
+ FunctionCall tpch.count@1[
+ Variable [ Name=g ]
+ ]
+ )
+]
+]
+FROM [ (
+ SELECT ELEMENT [
+ RecordConstructor [
+ (
+ LiteralExpr [STRING] [l_returnflag]
+ :
+ Variable [ Name=l_returnflag ]
+ )
+ (
+ LiteralExpr [STRING] [l_linestatus]
+ :
+ Variable [ Name=l_linestatus ]
+ )
+ (
+ LiteralExpr [STRING] [l_suppkey]
+ :
+ Variable [ Name=l_suppkey ]
+ )
+ ]
+ ]
+ FROM [ FunctionCall Metadata.dataset@1[
+ LiteralExpr [STRING] [LineItems_q1]
+ ]
+ AS
+ Variable [ Name=l ]
+ ]
+ Where
+ OperatorExpr [
+ FieldAccessor [
+ Variable [ Name=l ]
+ Field=l_shipdate
+ ]
+ <=
+ LiteralExpr [STRING] [1998-09-02]
+ ]
+ Groupby
+ Variable [ Name=l_returnflag ]
+ :=
+ FieldAccessor [
+ Variable [ Name=l ]
+ Field=l_returnflag
+ ]
+ Variable [ Name=l_linestatus ]
+ :=
+ FieldAccessor [
+ Variable [ Name=l ]
+ Field=l_linestatus
+ ]
+ Variable [ Name=l_suppkey ]
+ :=
+ FieldAccessor [
+ Variable [ Name=l ]
+ Field=l_suppkey
+ ]
+ With
+ Variable [ Name=l ]
+
+ )
+ AS
+ Variable [ Name=g ]
+]
+Groupby
+ Variable [ Name=l_returnflag ]
+ :=
+ FieldAccessor [
+ Variable [ Name=g ]
+ Field=l_returnflag
+ ]
+ Variable [ Name=l_linestatus ]
+ :=
+ FieldAccessor [
+ Variable [ Name=g ]
+ Field=l_linestatus
+ ]
+ With
+ Variable [ Name=g ]
+
+Orderby
+ Variable [ Name=l_returnflag ]
+ ASC
+ Variable [ Name=l_linestatus ]
+ ASC
+
http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/391f09e5/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/filter-nested.ast
----------------------------------------------------------------------
diff --git a/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/filter-nested.ast b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/filter-nested.ast
new file mode 100644
index 0000000..dddcd69
--- /dev/null
+++ b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/filter-nested.ast
@@ -0,0 +1,39 @@
+DataverseUse test
+WriteOutputTo nc1:rttest/filter-nested.adm
+TypeDecl TestTypetmp [
+ open RecordType {
+ fname : string,
+ lname : string
+ }
+]
+TypeDecl TestType [
+ open RecordType {
+ nested : TestTypetmp
+ }
+]
+DatasetDecl testdst(TestType) partitioned by [[nested, fname]]
+Query:
+SELECT ELEMENT [
+FieldAccessor [
+ Variable [ Name=emp ]
+ Field=nested
+]
+]
+FROM [ FunctionCall Metadata.dataset@1[
+ LiteralExpr [STRING] [testdst]
+ ]
+ AS
+ Variable [ Name=emp ]
+]
+Where
+ OperatorExpr [
+ FieldAccessor [
+ FieldAccessor [
+ Variable [ Name=emp ]
+ Field=nested
+ ]
+ Field=lname
+ ]
+ >
+ LiteralExpr [STRING] [Roger]
+ ]
http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/391f09e5/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/fj-dblp-csx.ast
----------------------------------------------------------------------
diff --git a/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/fj-dblp-csx.ast b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/fj-dblp-csx.ast
new file mode 100644
index 0000000..fe0b69c
--- /dev/null
+++ b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/fj-dblp-csx.ast
@@ -0,0 +1,200 @@
+DataverseUse fj-dblp-csx
+TypeDecl DBLPType [
+ open RecordType {
+ id : int32,
+ dblpid : string,
+ title : string,
+ authors : string,
+ misc : string
+ }
+]
+TypeDecl CSXType [
+ open RecordType {
+ id : int32,
+ csxid : string,
+ title : string,
+ authors : string,
+ misc : string
+ }
+]
+DatasetDecl DBLP(DBLPType) partitioned by [[id]]
+DatasetDecl CSX(CSXType) partitioned by [[id]]
+WriteOutputTo nc1:rttest/fj-dblp-csx.adm
+Query:
+SELECT ELEMENT [
+RecordConstructor [
+ (
+ LiteralExpr [STRING] [idDBLP]
+ :
+ Variable [ Name=idDBLP ]
+ )
+ (
+ LiteralExpr [STRING] [idCSX]
+ :
+ Variable [ Name=idCSX ]
+ )
+]
+]
+FROM [ FunctionCall Metadata.dataset@1[
+ LiteralExpr [STRING] [DBLP]
+ ]
+ AS
+ Variable [ Name=paperDBLP ]
+,
+ FunctionCall Metadata.dataset@1[
+ LiteralExpr [STRING] [tokensDBLP]
+ ]
+ AS
+ Variable [ Name=prefixTokenDBLP ]
+,
+ FunctionCall Metadata.dataset@1[
+ LiteralExpr [STRING] [CSX]
+ ]
+ AS
+ Variable [ Name=paperCSX ]
+,
+ FunctionCall Metadata.dataset@1[
+ LiteralExpr [STRING] [tokensCSX]
+ ]
+ AS
+ Variable [ Name=prefixTokenCSX ]
+]
+LetVariable [ Name=idDBLP ]
+ :=
+ FieldAccessor [
+ Variable [ Name=paperDBLP ]
+ Field=id
+ ]
+LetVariable [ Name=unrankedTokensDBLP ]
+ :=
+ FunctionCall fj-dblp-csx.counthashed-word-tokens@1[
+ FieldAccessor [
+ Variable [ Name=paperDBLP ]
+ Field=title
+ ]
+ ]
+LetVariable [ Name=tokensDBLP ]
+ :=
+ (
+ SELECT ELEMENT [
+ Variable [ Name=i ]
+ ]
+ FROM [ Variable [ Name=unrankedTokensDBLP ]
+ AS
+ Variable [ Name=token ]
+,
+ (
+ SELECT ELEMENT [
+ FieldAccessor [
+ Variable [ Name=paper ]
+ Field=title
+ ]
+ ]
+ FROM [ FunctionCall Metadata.dataset@1[
+ LiteralExpr [STRING] [DBLP]
+ ]
+ AS
+ Variable [ Name=paper ]
+ ]
+ )
+ AS
+ Variable [ Name=tokenRanked ]
+ AT
+ Variable [ Name=i ]
+ ]
+ Where
+ OperatorExpr [
+ Variable [ Name=token ]
+ =
+ Variable [ Name=tokenRanked ]
+ ]
+ Orderby
+ Variable [ Name=i ]
+ ASC
+
+ )
+LetVariable [ Name=idCSX ]
+ :=
+ FieldAccessor [
+ Variable [ Name=paperCSX ]
+ Field=id
+ ]
+LetVariable [ Name=unrankedTokensCSX ]
+ :=
+ FunctionCall fj-dblp-csx.counthashed-word-tokens@1[
+ FieldAccessor [
+ Variable [ Name=paperCSX ]
+ Field=title
+ ]
+ ]
+LetVariable [ Name=tokensCSX ]
+ :=
+ (
+ SELECT ELEMENT [
+ Variable [ Name=i ]
+ ]
+ FROM [ Variable [ Name=unrankedTokensCSX ]
+ AS
+ Variable [ Name=token ]
+,
+ (
+ SELECT ELEMENT [
+ FieldAccessor [
+ Variable [ Name=paper ]
+ Field=title
+ ]
+ ]
+ FROM [ FunctionCall Metadata.dataset@1[
+ LiteralExpr [STRING] [DBLP]
+ ]
+ AS
+ Variable [ Name=paper ]
+ ]
+ )
+ AS
+ Variable [ Name=tokenRanked ]
+ AT
+ Variable [ Name=i ]
+ ]
+ Where
+ OperatorExpr [
+ Variable [ Name=token ]
+ =
+ Variable [ Name=tokenRanked ]
+ ]
+ Orderby
+ Variable [ Name=i ]
+ ASC
+
+ )
+Where
+ OperatorExpr [
+ Variable [ Name=prefixTokenDBLP ]
+ =
+ Variable [ Name=prefixTokenCSX ]
+ ]
+Groupby
+ Variable [ Name=idDBLP ]
+ :=
+ Variable [ Name=idDBLP ]
+ Variable [ Name=idCSX ]
+ :=
+ Variable [ Name=idCSX ]
+ With
+ Variable [ Name=tokensCSX ]
+ Variable [ Name=unrankedTokensCSX ]
+ Variable [ Name=idCSX ]
+ Variable [ Name=tokensDBLP ]
+ Variable [ Name=unrankedTokensDBLP ]
+ Variable [ Name=idDBLP ]
+ Variable [ Name=paperDBLP ]
+ Variable [ Name=prefixTokenDBLP ]
+ Variable [ Name=prefixTokenCSX ]
+ Variable [ Name=paperCSX ]
+
+Orderby
+ Variable [ Name=idDBLP ]
+ ASC
+ Variable [ Name=idCSX ]
+ ASC
+
http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/391f09e5/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/fj-phase1.ast
----------------------------------------------------------------------
diff --git a/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/fj-phase1.ast b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/fj-phase1.ast
new file mode 100644
index 0000000..dc23607
--- /dev/null
+++ b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/fj-phase1.ast
@@ -0,0 +1,111 @@
+DataverseUse rares03
+TypeDecl UserType [
+ open RecordType {
+ uid : int32,
+ name : string,
+ lottery_numbers : UnorderedList <int32>
+
+ }
+]
+TypeDecl VisitorType [
+ open RecordType {
+ vid : int32,
+ name : string,
+ lottery_numbers : UnorderedList <int32>
+
+ }
+]
+DatasetDecl Users(UserType) partitioned by [[uid]]
+DatasetDecl Visitors(VisitorType) partitioned by [[vid]]
+WriteOutputTo nc1:/tmp/rares03.adm
+Query:
+SELECT ELEMENT [
+RecordConstructor [
+ (
+ LiteralExpr [STRING] [uid]
+ :
+ FieldAccessor [
+ Variable [ Name=user ]
+ Field=uid
+ ]
+ )
+ (
+ LiteralExpr [STRING] [tokens]
+ :
+ Variable [ Name=tokens ]
+ )
+]
+]
+FROM [ FunctionCall Metadata.dataset@1[
+ LiteralExpr [STRING] [Users]
+ ]
+ AS
+ Variable [ Name=user ]
+]
+LetVariable [ Name=tokens ]
+ :=
+ (
+ SELECT ELEMENT [
+ Variable [ Name=i ]
+ ]
+ FROM [ FieldAccessor [
+ Variable [ Name=user ]
+ Field=lottery_numbers
+ ]
+ AS
+ Variable [ Name=lottery_number ]
+,
+ (
+ SELECT ELEMENT [
+ Variable [ Name=item ]
+ ]
+ FROM [ FunctionCall Metadata.dataset@1[
+ LiteralExpr [STRING] [Users]
+ ]
+ AS
+ Variable [ Name=user ]
+,
+ FieldAccessor [
+ Variable [ Name=user ]
+ Field=lottery_numbers
+ ]
+ AS
+ Variable [ Name=lottery_number ]
+ ]
+ Groupby
+ Variable [ Name=item ]
+ :=
+ Variable [ Name=lottery_number ]
+ With
+ Variable [ Name=lottery_number ]
+ Variable [ Name=user ]
+ Variable [ Name=lottery_number ]
+ Variable [ Name=tokens ]
+ Variable [ Name=user ]
+
+ LetVariable [ Name=count ]
+ :=
+ FunctionCall rares03.count@1[
+ Variable [ Name=user ]
+ ]
+ Orderby
+ Variable [ Name=count ]
+ DESC
+
+ )
+ AS
+ Variable [ Name=token ]
+ AT
+ Variable [ Name=i ]
+ ]
+ Where
+ OperatorExpr [
+ Variable [ Name=lottery_number ]
+ =
+ Variable [ Name=token ]
+ ]
+ Orderby
+ Variable [ Name=token ]
+ ASC
+
+ )
http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/391f09e5/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/fj-phase2-with-hints.ast
----------------------------------------------------------------------
diff --git a/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/fj-phase2-with-hints.ast b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/fj-phase2-with-hints.ast
new file mode 100644
index 0000000..48fcb34
--- /dev/null
+++ b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/fj-phase2-with-hints.ast
@@ -0,0 +1,117 @@
+DataverseUse fuzzyjoin_078
+TypeDecl DBLPType [
+ open RecordType {
+ id : int32,
+ dblpid : string,
+ title : string,
+ authors : string,
+ misc : string
+ }
+]
+DatasetDecl DBLP_fuzzyjoin_078(DBLPType) partitioned by [[id]]
+WriteOutputTo nc1:rttest/fuzzyjoin_078.adm
+Query:
+SELECT ELEMENT [
+RecordConstructor [
+ (
+ LiteralExpr [STRING] [id]
+ :
+ FieldAccessor [
+ Variable [ Name=paperDBLP ]
+ Field=id
+ ]
+ )
+ (
+ LiteralExpr [STRING] [tokens]
+ :
+ Variable [ Name=tokensDBLP ]
+ )
+]
+]
+FROM [ FunctionCall Metadata.dataset@1[
+ LiteralExpr [STRING] [DBLP_fuzzyjoin_078]
+ ]
+ AS
+ Variable [ Name=paperDBLP ]
+]
+LetVariable [ Name=unrankedTokensDBLP ]
+ :=
+ FunctionCall fuzzyjoin_078.counthashed-word-tokens@1[
+ FieldAccessor [
+ Variable [ Name=paperDBLP ]
+ Field=title
+ ]
+ ]
+LetVariable [ Name=tokensDBLP ]
+ :=
+ (
+ SELECT ELEMENT [
+ Variable [ Name=i ]
+ ]
+ FROM [ Variable [ Name=unrankedTokensDBLP ]
+ AS
+ Variable [ Name=token ]
+,
+ (
+ SELECT ELEMENT [
+ Variable [ Name=tokenGroupped ]
+ ]
+ FROM [ FunctionCall Metadata.dataset@1[
+ LiteralExpr [STRING] [DBLP_fuzzyjoin_078]
+ ]
+ AS
+ Variable [ Name=paper ]
+,
+ FunctionCall fuzzyjoin_078.counthashed-word-tokens@1[
+ FieldAccessor [
+ Variable [ Name=paper ]
+ Field=title
+ ]
+ ]
+ AS
+ Variable [ Name=token ]
+ ]
+ Groupby
+ Variable [ Name=tokenGroupped ]
+ :=
+ Variable [ Name=token ]
+ With
+ Variable [ Name=paper ]
+ Variable [ Name=token ]
+ Variable [ Name=token ]
+ Variable [ Name=tokensDBLP ]
+ Variable [ Name=unrankedTokensDBLP ]
+ Variable [ Name=paperDBLP ]
+
+ Orderby
+ FunctionCall fuzzyjoin_078.count@1[
+ Variable [ Name=paper ]
+ ]
+ ASC
+ Variable [ Name=tokenGroupped ]
+ ASC
+
+ )
+ AS
+ Variable [ Name=tokenRanked ]
+ AT
+ Variable [ Name=i ]
+ ]
+ Where
+ OperatorExpr [
+ Variable [ Name=token ]
+ =
+ Variable [ Name=tokenRanked ]
+ ]
+ Orderby
+ Variable [ Name=i ]
+ ASC
+
+ )
+Orderby
+ FieldAccessor [
+ Variable [ Name=paperDBLP ]
+ Field=id
+ ]
+ ASC
+
http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/391f09e5/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/hashjoin-with-unnest.ast
----------------------------------------------------------------------
diff --git a/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/hashjoin-with-unnest.ast b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/hashjoin-with-unnest.ast
new file mode 100644
index 0000000..3432a40
--- /dev/null
+++ b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/hashjoin-with-unnest.ast
@@ -0,0 +1,57 @@
+DataverseUse test
+TypeDecl TestType [
+ open RecordType {
+ id : int32,
+ name : string
+ }
+]
+DatasetDecl t1(TestType) partitioned by [[id]]
+DatasetDecl t2(TestType) partitioned by [[id]]
+WriteOutputTo nc1:rttest/hahsjoin-with-unnest.adm
+Query:
+SELECT ELEMENT [
+RecordConstructor [
+ (
+ LiteralExpr [STRING] [t1]
+ :
+ Variable [ Name=m ]
+ )
+ (
+ LiteralExpr [STRING] [t2]
+ :
+ Variable [ Name=n ]
+ )
+]
+]
+FROM [ FunctionCall Metadata.dataset@1[
+ LiteralExpr [STRING] [t1]
+ ]
+ AS
+ Variable [ Name=m ]
+,
+ FunctionCall Metadata.dataset@1[
+ LiteralExpr [STRING] [t2]
+ ]
+ AS
+ Variable [ Name=n ]
+,
+ FieldAccessor [
+ Variable [ Name=m ]
+ Field=hobbies
+ ]
+ AS
+ Variable [ Name=a ]
+,
+ FieldAccessor [
+ Variable [ Name=n ]
+ Field=hobbies
+ ]
+ AS
+ Variable [ Name=b ]
+]
+Where
+ OperatorExpr [
+ Variable [ Name=a ]
+ =
+ Variable [ Name=b ]
+ ]
http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/391f09e5/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/inline-funs.ast
----------------------------------------------------------------------
diff --git a/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/inline-funs.ast b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/inline-funs.ast
new file mode 100644
index 0000000..30ebc0b
--- /dev/null
+++ b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/inline-funs.ast
@@ -0,0 +1,46 @@
+DataverseUse test
+WriteOutputTo nc1:/tmp/inline_funs.adm
+FunctionDecl f1([]) {
+ OperatorExpr [
+ LiteralExpr [LONG] [1]
+ +
+ FunctionCall test.f2@0[
+ ]
+ ]
+}
+
+FunctionDecl f2([]) {
+ OperatorExpr [
+ LiteralExpr [LONG] [2]
+ +
+ FunctionCall test.f3@0[
+ ]
+ +
+ FunctionCall test.f3@0[
+ ]
+ +
+ FunctionCall test.f3@0[
+ ]
+ +
+ FunctionCall test.f4@0[
+ ]
+ ]
+}
+
+FunctionDecl f3([]) {
+ OperatorExpr [
+ LiteralExpr [LONG] [0]
+ -
+ LiteralExpr [LONG] [1]
+ ]
+}
+
+FunctionDecl f4([]) {
+ LiteralExpr [LONG] [1001]
+}
+
+Query:
+SELECT ELEMENT [
+FunctionCall test.f1@0[
+]
+]
http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/391f09e5/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/inlined_q18_large_volume_customer.ast
----------------------------------------------------------------------
diff --git a/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/inlined_q18_large_volume_customer.ast b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/inlined_q18_large_volume_customer.ast
new file mode 100644
index 0000000..ee6cc44
--- /dev/null
+++ b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/inlined_q18_large_volume_customer.ast
@@ -0,0 +1,260 @@
+DataverseUse inlined_q18_large_volume_customer
+TypeDecl LineItemType [
+ closed RecordType {
+ l_orderkey : int32,
+ l_partkey : int32,
+ l_suppkey : int32,
+ l_linenumber : int32,
+ l_quantity : double,
+ l_extendedprice : double,
+ l_discount : double,
+ l_tax : double,
+ l_returnflag : string,
+ l_linestatus : string,
+ l_shipdate : string,
+ l_commitdate : string,
+ l_receiptdate : string,
+ l_shipinstruct : string,
+ l_shipmode : string,
+ l_comment : string
+ }
+]
+TypeDecl OrderType [
+ closed RecordType {
+ o_orderkey : int32,
+ o_custkey : int32,
+ o_orderstatus : string,
+ o_totalprice : double,
+ o_orderdate : string,
+ o_orderpriority : string,
+ o_clerk : string,
+ o_shippriority : int32,
+ o_comment : string
+ }
+]
+TypeDecl CustomerType [
+ closed RecordType {
+ c_custkey : int32,
+ c_name : string,
+ c_address : string,
+ c_nationkey : int32,
+ c_phone : string,
+ c_acctbal : double,
+ c_mktsegment : string,
+ c_comment : string
+ }
+]
+DatasetDecl LineItems(LineItemType) partitioned by [[l_orderkey], [l_linenumber]]
+DatasetDecl Orders(OrderType) partitioned by [[o_orderkey]]
+DatasetDecl Customers(CustomerType) partitioned by [[c_custkey]]
+WriteOutputTo nc1:/tmp/inlined_q18_large_volume_customer.adm
+Query:
+SELECT ELEMENT [
+RecordConstructor [
+ (
+ LiteralExpr [STRING] [c_name]
+ :
+ Variable [ Name=c_name ]
+ )
+ (
+ LiteralExpr [STRING] [c_custkey]
+ :
+ Variable [ Name=c_custkey ]
+ )
+ (
+ LiteralExpr [STRING] [o_orderkey]
+ :
+ Variable [ Name=o_orderkey ]
+ )
+ (
+ LiteralExpr [STRING] [o_orderdate]
+ :
+ Variable [ Name=o_orderdate ]
+ )
+ (
+ LiteralExpr [STRING] [o_totalprice]
+ :
+ Variable [ Name=o_totalprice ]
+ )
+ (
+ LiteralExpr [STRING] [sum_quantity]
+ :
+ FunctionCall inlined_q18_large_volume_customer.sum@1[
+ (
+ SELECT ELEMENT [
+ FieldAccessor [
+ Variable [ Name=j ]
+ Field=l_quantity
+ ]
+ ]
+ FROM [ Variable [ Name=l ]
+ AS
+ Variable [ Name=j ]
+ ]
+ )
+ ]
+ )
+]
+]
+FROM [ FunctionCall Metadata.dataset@1[
+ LiteralExpr [STRING] [Customers]
+ ]
+ AS
+ Variable [ Name=c ]
+,
+ FunctionCall Metadata.dataset@1[
+ LiteralExpr [STRING] [Orders]
+ ]
+ AS
+ Variable [ Name=o ]
+,
+ (
+ SELECT ELEMENT [
+ RecordConstructor [
+ (
+ LiteralExpr [STRING] [l_orderkey]
+ :
+ Variable [ Name=l_orderkey ]
+ )
+ (
+ LiteralExpr [STRING] [t_sum_quantity]
+ :
+ FunctionCall inlined_q18_large_volume_customer.sum@1[
+ (
+ SELECT ELEMENT [
+ FieldAccessor [
+ Variable [ Name=i ]
+ Field=l_quantity
+ ]
+ ]
+ FROM [ Variable [ Name=l ]
+ AS
+ Variable [ Name=i ]
+ ]
+ )
+ ]
+ )
+ ]
+ ]
+ FROM [ FunctionCall Metadata.dataset@1[
+ LiteralExpr [STRING] [LineItems]
+ ]
+ AS
+ Variable [ Name=l ]
+ ]
+ Groupby
+ Variable [ Name=l_orderkey ]
+ :=
+ FieldAccessor [
+ Variable [ Name=l ]
+ Field=l_orderkey
+ ]
+ With
+ Variable [ Name=l ]
+ Variable [ Name=c ]
+ Variable [ Name=o ]
+
+ )
+ AS
+ Variable [ Name=t ]
+,
+ FunctionCall Metadata.dataset@1[
+ LiteralExpr [STRING] [LineItems]
+ ]
+ AS
+ Variable [ Name=l ]
+]
+Where
+ OperatorExpr [
+ OperatorExpr [
+ FieldAccessor [
+ Variable [ Name=c ]
+ Field=c_custkey
+ ]
+ =
+ FieldAccessor [
+ Variable [ Name=o ]
+ Field=o_custkey
+ ]
+ ]
+ and
+ OperatorExpr [
+ OperatorExpr [
+ FieldAccessor [
+ Variable [ Name=o ]
+ Field=o_orderkey
+ ]
+ =
+ FieldAccessor [
+ Variable [ Name=t ]
+ Field=l_orderkey
+ ]
+ ]
+ and
+ OperatorExpr [
+ FieldAccessor [
+ Variable [ Name=t ]
+ Field=t_sum_quantity
+ ]
+ >
+ LiteralExpr [LONG] [300]
+ ]
+ ]
+ and
+ OperatorExpr [
+ FieldAccessor [
+ Variable [ Name=l ]
+ Field=l_orderkey
+ ]
+ =
+ FieldAccessor [
+ Variable [ Name=o ]
+ Field=o_orderkey
+ ]
+ ]
+ ]
+Groupby
+ Variable [ Name=c_name ]
+ :=
+ FieldAccessor [
+ Variable [ Name=c ]
+ Field=c_name
+ ]
+ Variable [ Name=c_custkey ]
+ :=
+ FieldAccessor [
+ Variable [ Name=c ]
+ Field=c_custkey
+ ]
+ Variable [ Name=o_orderkey ]
+ :=
+ FieldAccessor [
+ Variable [ Name=o ]
+ Field=o_orderkey
+ ]
+ Variable [ Name=o_orderdate ]
+ :=
+ FieldAccessor [
+ Variable [ Name=o ]
+ Field=o_orderdate
+ ]
+ Variable [ Name=o_totalprice ]
+ :=
+ FieldAccessor [
+ Variable [ Name=o ]
+ Field=o_totalprice
+ ]
+ With
+ Variable [ Name=c ]
+ Variable [ Name=t ]
+ Variable [ Name=l ]
+ Variable [ Name=o ]
+
+Orderby
+ Variable [ Name=o_totalprice ]
+ DESC
+ Variable [ Name=o_orderdate ]
+ ASC
+
+Limit
+ LiteralExpr [LONG] [100]