You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@asterixdb.apache.org by mh...@apache.org on 2017/08/22 10:15:21 UTC
[26/32] asterixdb git commit: [ASTERIXDB-2050][SQL] Enforce a
Semicolon After Each SQL++ Statement
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-primary-22.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-primary-22.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-primary-22.sqlpp
index 0baed6c..cbbf38c 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-primary-22.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-primary-22.sqlpp
@@ -30,17 +30,17 @@ create dataverse test;
use test;
-write output to asterix_nc1:"rttest/btree-index_btree-primary-22.adm"
+write output to asterix_nc1:"rttest/btree-index_btree-primary-22.adm";
create type test.TestTypetmp as
{
fname : string,
lname : string
-}
+};
create type test.TestType as
{
nested : TestTypetmp
-}
+};
create dataset testdst(TestType) primary key nested.fname;
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-primary-23.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-primary-23.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-primary-23.sqlpp
index b221078..3312363 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-primary-23.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-primary-23.sqlpp
@@ -30,17 +30,17 @@ create dataverse test;
use test;
-write output to asterix_nc1:"rttest/btree-index_btree-primary-23.adm"
+write output to asterix_nc1:"rttest/btree-index_btree-primary-23.adm";
create type test.TestTypetmp as
{
fname : string,
lname : string
-}
+};
create type test.TestType as
{
nested : TestTypetmp
-}
+};
create dataset testdst(TestType) primary key nested.fname;
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-primary-24.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-primary-24.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-primary-24.sqlpp
index d867b3d..4617096 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-primary-24.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-primary-24.sqlpp
@@ -30,17 +30,17 @@ create dataverse test;
use test;
-write output to asterix_nc1:"rttest/btree-index_btree-primary-24.adm"
+write output to asterix_nc1:"rttest/btree-index_btree-primary-24.adm";
create type test.TestTypetmp as
{
fname : string,
lname : string
-}
+};
create type test.TestType as
{
nested : TestTypetmp
-}
+};
create dataset testdst(TestType) primary key nested.fname;
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-primary-25.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-primary-25.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-primary-25.sqlpp
index 35acebf..e1ce9bc 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-primary-25.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-primary-25.sqlpp
@@ -30,17 +30,17 @@ create dataverse test;
use test;
-write output to asterix_nc1:"rttest/btree-index_btree-primary-25.adm"
+write output to asterix_nc1:"rttest/btree-index_btree-primary-25.adm";
create type test.TestTypetmp as
{
fname : string,
lname : string
-}
+};
create type test.TestType as
{
nested : TestTypetmp
-}
+};
create dataset testdst(TestType) primary key nested.fname;
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-primary-26.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-primary-26.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-primary-26.sqlpp
index ac37e84..34f7225 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-primary-26.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-primary-26.sqlpp
@@ -30,17 +30,17 @@ create dataverse test;
use test;
-write output to asterix_nc1:"rttest/btree-index_btree-primary-26.adm"
+write output to asterix_nc1:"rttest/btree-index_btree-primary-26.adm";
create type test.TestTypetmp as
{
fname : string,
lname : string
-}
+};
create type test.TestType as
{
nested : TestTypetmp
-}
+};
create dataset testdst(TestType) primary key nested.fname;
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-primary-27.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-primary-27.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-primary-27.sqlpp
index 3c971e8..a5daa7f 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-primary-27.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-primary-27.sqlpp
@@ -30,17 +30,17 @@ create dataverse test;
use test;
-write output to asterix_nc1:"rttest/btree-index_btree-primary-27.adm"
+write output to asterix_nc1:"rttest/btree-index_btree-primary-27.adm";
create type test.TestTypetmp as
{
fname : string,
lname : string
-}
+};
create type test.TestType as
{
nested : TestTypetmp
-}
+};
create dataset testdst(TestType) primary key nested.fname,nested.lname;
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-primary-28.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-primary-28.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-primary-28.sqlpp
index ef574c8..426fb73 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-primary-28.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-primary-28.sqlpp
@@ -30,17 +30,17 @@ create dataverse test;
use test;
-write output to asterix_nc1:"rttest/btree-index_btree-primary-28.adm"
+write output to asterix_nc1:"rttest/btree-index_btree-primary-28.adm";
create type test.TestTypetmp as
{
fname : string,
lname : string
-}
+};
create type test.TestType as
{
nested : TestTypetmp
-}
+};
create dataset testdst(TestType) primary key nested.fname,nested.lname;
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-primary-29.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-primary-29.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-primary-29.sqlpp
index c43685a..7792ede 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-primary-29.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-primary-29.sqlpp
@@ -30,17 +30,17 @@ create dataverse test;
use test;
-write output to asterix_nc1:"rttest/btree-index_btree-primary-29.adm"
+write output to asterix_nc1:"rttest/btree-index_btree-primary-29.adm";
create type test.TestTypetmp as
{
fname : string,
lname : string
-}
+};
create type test.TestType as
{
nested : TestTypetmp
-}
+};
create dataset testdst(TestType) primary key nested.fname,nested.lname;
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-primary-30.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-primary-30.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-primary-30.sqlpp
index 6da097d..0328442 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-primary-30.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-primary-30.sqlpp
@@ -30,17 +30,17 @@ create dataverse test;
use test;
-write output to asterix_nc1:"rttest/btree-index_btree-primary-30.adm"
+write output to asterix_nc1:"rttest/btree-index_btree-primary-30.adm";
create type test.TestTypetmp as
{
fname : string,
lname : string
-}
+};
create type test.TestType as
{
nested : TestTypetmp
-}
+};
create dataset testdst(TestType) primary key nested.fname,nested.lname;
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-primary-31.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-primary-31.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-primary-31.sqlpp
index 1d7ae08..116e519 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-primary-31.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-primary-31.sqlpp
@@ -30,17 +30,17 @@ create dataverse test;
use test;
-write output to asterix_nc1:"rttest/btree-index_btree-primary-31.adm"
+write output to asterix_nc1:"rttest/btree-index_btree-primary-31.adm";
create type test.TestTypetmp as
{
fname : string,
lname : string
-}
+};
create type test.TestType as
{
nested : TestTypetmp
-}
+};
create dataset testdst(TestType) primary key nested.fname,nested.lname;
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-primary-32.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-primary-32.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-primary-32.sqlpp
index 12842d1..9bb3e6e 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-primary-32.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-primary-32.sqlpp
@@ -30,17 +30,17 @@ create dataverse test;
use test;
-write output to asterix_nc1:"rttest/btree-index_btree-primary-32.adm"
+write output to asterix_nc1:"rttest/btree-index_btree-primary-32.adm";
create type test.TestTypetmp as
{
fname : string,
lname : string
-}
+};
create type test.TestType as
{
nested : TestTypetmp
-}
+};
create dataset testdst(TestType) primary key nested.fname,nested.lname;
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-secondary-33.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-secondary-33.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-secondary-33.sqlpp
index 00ade29..062adc8 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-secondary-33.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-secondary-33.sqlpp
@@ -30,18 +30,18 @@ create dataverse test;
use test;
-write output to asterix_nc1:"rttest/btree-index_btree-primary-31.adm"
+write output to asterix_nc1:"rttest/btree-index_btree-primary-31.adm";
create type test.TestTypetmp as
{
id : integer,
fname : string,
lname : string
-}
+};
create type test.TestType as
{
nested : TestTypetmp
-}
+};
create dataset testdst(TestType) primary key nested.id;
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-secondary-34.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-secondary-34.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-secondary-34.sqlpp
index 7dc4131..28f3f58 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-secondary-34.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-secondary-34.sqlpp
@@ -30,18 +30,18 @@ create dataverse test;
use test;
-write output to asterix_nc1:"rttest/btree-index_btree-secondary-32.adm"
+write output to asterix_nc1:"rttest/btree-index_btree-secondary-32.adm";
create type test.TestTypetmp as
{
id : integer,
fname : string,
lname : string
-}
+};
create type test.TestType as
{
nested : TestTypetmp
-}
+};
create dataset testdst(TestType) primary key nested.id;
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-secondary-35.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-secondary-35.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-secondary-35.sqlpp
index 013e792..b66df57 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-secondary-35.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-secondary-35.sqlpp
@@ -30,18 +30,18 @@ create dataverse test;
use test;
-write output to asterix_nc1:"rttest/btree-index_btree-secondary-33.adm"
+write output to asterix_nc1:"rttest/btree-index_btree-secondary-33.adm";
create type test.TestTypetmp as
{
id : integer,
fname : string,
lname : string
-}
+};
create type test.TestType as
{
nested : TestTypetmp
-}
+};
create dataset testdst(TestType) primary key nested.id;
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-secondary-36.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-secondary-36.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-secondary-36.sqlpp
index 1d1254b..7c1a0be 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-secondary-36.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-secondary-36.sqlpp
@@ -30,18 +30,18 @@ create dataverse test;
use test;
-write output to asterix_nc1:"rttest/btree-index_btree-secondary-34.adm"
+write output to asterix_nc1:"rttest/btree-index_btree-secondary-34.adm";
create type test.TestTypetmp as
{
id : integer,
fname : string,
lname : string
-}
+};
create type test.TestType as
{
nested : TestTypetmp
-}
+};
create dataset testdst(TestType) primary key nested.id;
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-secondary-37.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-secondary-37.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-secondary-37.sqlpp
index 6cd94ad..7d8eb2c 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-secondary-37.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-secondary-37.sqlpp
@@ -30,18 +30,18 @@ create dataverse test;
use test;
-write output to asterix_nc1:"rttest/btree-index_btree-secondary-35.adm"
+write output to asterix_nc1:"rttest/btree-index_btree-secondary-35.adm";
create type test.TestTypetmp as
{
id : integer,
fname : string,
lname : string
-}
+};
create type test.TestType as
{
nested : TestTypetmp
-}
+};
create dataset testdst(TestType) primary key nested.id;
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-secondary-38.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-secondary-38.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-secondary-38.sqlpp
index e847978..fe8b51c 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-secondary-38.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-secondary-38.sqlpp
@@ -30,18 +30,18 @@ create dataverse test;
use test;
-write output to asterix_nc1:"rttest/btree-index_btree-secondary-36.adm"
+write output to asterix_nc1:"rttest/btree-index_btree-secondary-36.adm";
create type test.TestTypetmp as
{
id : integer,
fname : string,
lname : string
-}
+};
create type test.TestType as
{
nested : TestTypetmp
-}
+};
create dataset testdst(TestType) primary key nested.id;
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-secondary-39.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-secondary-39.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-secondary-39.sqlpp
index d61f456..6967efb 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-secondary-39.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-secondary-39.sqlpp
@@ -29,18 +29,18 @@ create dataverse test;
use test;
-write output to asterix_nc1:"rttest/btree-index_btree-secondary-37.adm"
+write output to asterix_nc1:"rttest/btree-index_btree-secondary-37.adm";
create type test.TestTypetmp as
{
id : integer,
fname : string,
lname : string
-}
+};
create type test.TestType as
{
nested : TestTypetmp
-}
+};
create dataset testdst(TestType) primary key nested.id;
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-secondary-40.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-secondary-40.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-secondary-40.sqlpp
index bde5ca4..d27d758 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-secondary-40.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-secondary-40.sqlpp
@@ -29,18 +29,18 @@ create dataverse test;
use test;
-write output to asterix_nc1:"rttest/btree-index_btree-secondary-38.adm"
+write output to asterix_nc1:"rttest/btree-index_btree-secondary-38.adm";
create type test.TestTypetmp as
{
id : integer,
fname : string,
lname : string
-}
+};
create type test.TestType as
{
nested : TestTypetmp
-}
+};
create dataset testdst(TestType) primary key nested.id;
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-secondary-41.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-secondary-41.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-secondary-41.sqlpp
index e917d5f..60b47c4 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-secondary-41.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-secondary-41.sqlpp
@@ -30,18 +30,18 @@ create dataverse test;
use test;
-write output to asterix_nc1:"rttest/btree-index_btree-secondary-39.adm"
+write output to asterix_nc1:"rttest/btree-index_btree-secondary-39.adm";
create type test.TestTypetmp as
{
id : integer,
fname : string,
lname : string
-}
+};
create type test.TestType as
{
nested : TestTypetmp
-}
+};
create dataset testdst(TestType) primary key nested.id;
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-secondary-42.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-secondary-42.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-secondary-42.sqlpp
index ff30890..6746e1e 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-secondary-42.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-secondary-42.sqlpp
@@ -30,18 +30,18 @@ create dataverse test;
use test;
-write output to asterix_nc1:"rttest/btree-index_btree-secondary-40.adm"
+write output to asterix_nc1:"rttest/btree-index_btree-secondary-40.adm";
create type test.TestTypetmp as
{
id : integer,
fname : string,
lname : string
-}
+};
create type test.TestType as
{
nested : TestTypetmp
-}
+};
create dataset testdst(TestType) primary key nested.id;
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-secondary-43.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-secondary-43.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-secondary-43.sqlpp
index 9ade4cd..cd5fbd0 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-secondary-43.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-secondary-43.sqlpp
@@ -30,18 +30,18 @@ create dataverse test;
use test;
-write output to asterix_nc1:"rttest/btree-index_btree-secondary-41.adm"
+write output to asterix_nc1:"rttest/btree-index_btree-secondary-41.adm";
create type test.TestTypetmp as
{
id : integer,
fname : string,
lname : string
-}
+};
create type test.TestType as
{
nested : TestTypetmp
-}
+};
create dataset testdst(TestType) primary key nested.id;
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-secondary-44.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-secondary-44.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-secondary-44.sqlpp
index 9bc8e3d..795a72a 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-secondary-44.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-secondary-44.sqlpp
@@ -30,18 +30,18 @@ create dataverse test;
use test;
-write output to asterix_nc1:"rttest/btree-index_btree-secondary-42.adm"
+write output to asterix_nc1:"rttest/btree-index_btree-secondary-42.adm";
create type test.TestTypetmp as
{
id : integer,
fname : string,
lname : string
-}
+};
create type test.TestType as
{
nested : TestTypetmp
-}
+};
create dataset testdst(TestType) primary key nested.id;
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-secondary-45.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-secondary-45.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-secondary-45.sqlpp
index 2363f88..3df1d41 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-secondary-45.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-secondary-45.sqlpp
@@ -30,18 +30,18 @@ create dataverse test;
use test;
-write output to asterix_nc1:"rttest/btree-index_btree-secondary-43.adm"
+write output to asterix_nc1:"rttest/btree-index_btree-secondary-43.adm";
create type test.TestTypetmp as
{
id : integer,
fname : string,
lname : string
-}
+};
create type test.TestType as
{
nested : TestTypetmp
-}
+};
create dataset testdst(TestType) primary key nested.id;
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-secondary-46.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-secondary-46.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-secondary-46.sqlpp
index 9dec507..1c1e684 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-secondary-46.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-secondary-46.sqlpp
@@ -30,18 +30,18 @@ create dataverse test;
use test;
-write output to asterix_nc1:"rttest/btree-index_btree-secondary-44.adm"
+write output to asterix_nc1:"rttest/btree-index_btree-secondary-44.adm";
create type test.TestTypetmp as
{
id : integer,
fname : string,
lname : string
-}
+};
create type test.TestType as
{
nested : TestTypetmp
-}
+};
create dataset testdst(TestType) primary key nested.id;
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-secondary-47.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-secondary-47.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-secondary-47.sqlpp
index d8b32a3..31d2013 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-secondary-47.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-secondary-47.sqlpp
@@ -30,18 +30,18 @@ create dataverse test;
use test;
-write output to asterix_nc1:"rttest/btree-index_btree-secondary-45.adm"
+write output to asterix_nc1:"rttest/btree-index_btree-secondary-45.adm";
create type test.TestTypetmp as
{
id : integer,
fname : string,
lname : string
-}
+};
create type test.TestType as
{
nested : TestTypetmp
-}
+};
create dataset testdst(TestType) primary key nested.id;
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-secondary-48.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-secondary-48.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-secondary-48.sqlpp
index 0f06408..474a719 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-secondary-48.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-secondary-48.sqlpp
@@ -30,18 +30,18 @@ create dataverse test;
use test;
-write output to asterix_nc1:"rttest/btree-index_btree-secondary-46.adm"
+write output to asterix_nc1:"rttest/btree-index_btree-secondary-46.adm";
create type test.TestTypetmp as
{
id : integer,
fname : string,
lname : string
-}
+};
create type test.TestType as
{
nested : TestTypetmp
-}
+};
create dataset testdst(TestType) primary key nested.id;
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-secondary-49.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-secondary-49.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-secondary-49.sqlpp
index 713daa0..bfc1ea5 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-secondary-49.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-secondary-49.sqlpp
@@ -30,18 +30,18 @@ create dataverse test;
use test;
-write output to asterix_nc1:"rttest/btree-index_btree-secondary-47.adm"
+write output to asterix_nc1:"rttest/btree-index_btree-secondary-47.adm";
create type test.TestTypetmp as
{
id : integer,
fname : string,
lname : string
-}
+};
create type test.TestType as
{
nested : TestTypetmp
-}
+};
create dataset testdst(TestType) primary key nested.id;
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-secondary-50.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-secondary-50.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-secondary-50.sqlpp
index 1c47540..6c4b63e 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-secondary-50.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-secondary-50.sqlpp
@@ -30,18 +30,18 @@ create dataverse test;
use test;
-write output to asterix_nc1:"rttest/btree-index_btree-secondary-48.adm"
+write output to asterix_nc1:"rttest/btree-index_btree-secondary-48.adm";
create type test.TestTypetmp as
{
id : integer,
fname : string,
lname : string
-}
+};
create type test.TestType as
{
nested : TestTypetmp
-}
+};
create dataset testdst(TestType) primary key nested.id;
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-secondary-51.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-secondary-51.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-secondary-51.sqlpp
index 5da33da..bc9fdaf 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-secondary-51.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-secondary-51.sqlpp
@@ -30,18 +30,18 @@ create dataverse test;
use test;
-write output to asterix_nc1:"rttest/btree-index_btree-secondary-49.adm"
+write output to asterix_nc1:"rttest/btree-index_btree-secondary-49.adm";
create type test.TestTypetmp as
{
id : integer,
fname : string,
lname : string
-}
+};
create type test.TestType as
{
nested : TestTypetmp
-}
+};
create dataset testdst(TestType) primary key nested.id;
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-secondary-52.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-secondary-52.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-secondary-52.sqlpp
index 26c9b94..9f3682c 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-secondary-52.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-secondary-52.sqlpp
@@ -30,18 +30,18 @@ create dataverse test;
use test;
-write output to asterix_nc1:"rttest/btree-index_btree-secondary-50.adm"
+write output to asterix_nc1:"rttest/btree-index_btree-secondary-50.adm";
create type test.TestTypetmp as
{
id : integer,
fname : string,
lname : string
-}
+};
create type test.TestType as
{
nested : TestTypetmp
-}
+};
create dataset testdst(TestType) primary key nested.id;
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-secondary-53.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-secondary-53.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-secondary-53.sqlpp
index 39934e5..3b35ddf 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-secondary-53.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-secondary-53.sqlpp
@@ -30,18 +30,18 @@ create dataverse test;
use test;
-write output to asterix_nc1:"rttest/btree-index_btree-secondary-51.adm"
+write output to asterix_nc1:"rttest/btree-index_btree-secondary-51.adm";
create type test.TestTypetmp as
{
id : integer,
fname : string,
lname : string
-}
+};
create type test.TestType as
{
nested : TestTypetmp
-}
+};
create dataset testdst(TestType) primary key nested.id;
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-secondary-54.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-secondary-54.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-secondary-54.sqlpp
index 99ad5da..9ada29c 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-secondary-54.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-secondary-54.sqlpp
@@ -29,18 +29,18 @@ create dataverse test;
use test;
-write output to asterix_nc1:"rttest/btree-index_btree-secondary-52.adm"
+write output to asterix_nc1:"rttest/btree-index_btree-secondary-52.adm";
create type test.TestTypetmp as
{
id : integer,
fname : string,
lname : string
-}
+};
create type test.TestType as
{
nested : TestTypetmp
-}
+};
create dataset testdst(TestType) primary key nested.id;
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-secondary-55.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-secondary-55.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-secondary-55.sqlpp
index 3f96b16..a29b0a7 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-secondary-55.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-secondary-55.sqlpp
@@ -29,18 +29,18 @@ create dataverse test;
use test;
-write output to asterix_nc1:"rttest/btree-index_btree-secondary-53.adm"
+write output to asterix_nc1:"rttest/btree-index_btree-secondary-53.adm";
create type test.TestTypetmp as
{
id : integer,
fname : string,
lname : string
-}
+};
create type test.TestType as
{
nested : TestTypetmp
-}
+};
create dataset testdst(TestType) primary key nested.id;
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-secondary-56.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-secondary-56.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-secondary-56.sqlpp
index 5ea3933..7592325 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-secondary-56.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-secondary-56.sqlpp
@@ -29,18 +29,18 @@ create dataverse test;
use test;
-write output to asterix_nc1:"rttest/btree-index_btree-secondary-54.adm"
+write output to asterix_nc1:"rttest/btree-index_btree-secondary-54.adm";
create type test.TestTypetmp as
{
id : integer,
fname : string,
lname : string
-}
+};
create type test.TestType as
{
nested : TestTypetmp
-}
+};
create dataset testdst(TestType) primary key nested.id;
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-secondary-57.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-secondary-57.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-secondary-57.sqlpp
index b65f432..61ad846 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-secondary-57.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-secondary-57.sqlpp
@@ -29,18 +29,18 @@ create dataverse test;
use test;
-write output to asterix_nc1:"rttest/btree-index_btree-secondary-55.adm"
+write output to asterix_nc1:"rttest/btree-index_btree-secondary-55.adm";
create type test.TestTypetmp as
{
id : integer,
fname : string,
lname : string
-}
+};
create type test.TestType as
{
nested : TestTypetmp
-}
+};
create dataset testdst(TestType) primary key nested.id;
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-secondary-58.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-secondary-58.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-secondary-58.sqlpp
index 4e483bb..f527712 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-secondary-58.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-secondary-58.sqlpp
@@ -29,18 +29,18 @@ create dataverse test;
use test;
-write output to asterix_nc1:"rttest/btree-index_btree-primary-56.adm"
+write output to asterix_nc1:"rttest/btree-index_btree-primary-56.adm";
create type test.TestTypetmp as
{
id : integer,
fname : string,
lname : string
-}
+};
create type test.TestType as
{
nested : TestTypetmp
-}
+};
create dataset testdst(TestType) primary key nested.id;
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-secondary-59.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-secondary-59.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-secondary-59.sqlpp
index cc92137..01bd660 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-secondary-59.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-secondary-59.sqlpp
@@ -29,18 +29,18 @@ create dataverse test;
use test;
-write output to asterix_nc1:"rttest/btree-index_btree-secondary-57.adm"
+write output to asterix_nc1:"rttest/btree-index_btree-secondary-57.adm";
create type test.TestTypetmp as
{
id : integer,
fname : string,
lname : string
-}
+};
create type test.TestType as
{
nested : TestTypetmp
-}
+};
create dataset testdst(TestType) primary key nested.id;
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-secondary-60.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-secondary-60.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-secondary-60.sqlpp
index cd22ece..85e778e 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-secondary-60.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-secondary-60.sqlpp
@@ -29,18 +29,18 @@ create dataverse test;
use test;
-write output to asterix_nc1:"rttest/btree-index_btree-secondary-58.adm"
+write output to asterix_nc1:"rttest/btree-index_btree-secondary-58.adm";
create type test.TestTypetmp as
{
id : integer,
fname : string,
lname : string
-}
+};
create type test.TestType as
{
nested : TestTypetmp
-}
+};
create dataset testdst(TestType) primary key nested.id;
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-secondary-61.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-secondary-61.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-secondary-61.sqlpp
index 3c4a3f7..dfe6a06 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-secondary-61.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-secondary-61.sqlpp
@@ -30,18 +30,18 @@ create dataverse test;
use test;
-write output to asterix_nc1:"rttest/btree-index_btree-secondary-61.adm"
+write output to asterix_nc1:"rttest/btree-index_btree-secondary-61.adm";
create type test.TestTypetmp as
{
id : integer,
fname : string,
lname : string
-}
+};
create type test.TestType as
{
nested : TestTypetmp
-}
+};
create dataset testdst(TestType) primary key nested.id;
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-secondary-62.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-secondary-62.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-secondary-62.sqlpp
index 55748c8..baf2887 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-secondary-62.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-secondary-62.sqlpp
@@ -30,18 +30,18 @@ create dataverse test;
use test;
-write output to asterix_nc1:"rttest/btree-index_btree-secondary-62.adm"
+write output to asterix_nc1:"rttest/btree-index_btree-secondary-62.adm";
create type test.TestTypetmp as
{
id : integer,
fname : string,
lname : string
-}
+};
create type test.TestType as
{
nested : TestTypetmp
-}
+};
create dataset testdst(TestType) primary key nested.id;
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-secondary-63.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-secondary-63.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-secondary-63.sqlpp
index dbe35e4..405a8ae 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-secondary-63.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/btree-index/btree-secondary-63.sqlpp
@@ -30,18 +30,18 @@ create dataverse test;
use test;
-write output to asterix_nc1:"rttest/btree-index_btree-secondary-63.adm"
+write output to asterix_nc1:"rttest/btree-index_btree-secondary-63.adm";
create type test.TestTypetmp as
{
id : integer,
fname : string,
lname : string
-}
+};
create type test.TestType as
{
nested : TestTypetmp
-}
+};
create dataset testdst(TestType) primary key nested.id;
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-basic/ngram-contains-panic.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-basic/ngram-contains-panic.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-basic/ngram-contains-panic.sqlpp
index c498c36..0062d60 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-basic/ngram-contains-panic.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-basic/ngram-contains-panic.sqlpp
@@ -35,18 +35,18 @@ create type test.DBLPTypetmp as
title : string,
authors : string,
misc : string
-}
+};
create type test.DBLPType as
closed {
nested : DBLPTypetmp
-}
+};
create dataset DBLP(DBLPType) primary key nested.id;
create index ngram_index on DBLP (nested.title) type ngram (3);
-write output to asterix_nc1:"rttest/inverted-index-basic_ngram-contains-panic.adm"
+write output to asterix_nc1:"rttest/inverted-index-basic_ngram-contains-panic.adm";
select element o
from DBLP as o
where test.contains(o.nested.title,'Mu')
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-basic/ngram-contains.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-basic/ngram-contains.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-basic/ngram-contains.sqlpp
index 308fb0d..ba8cc73 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-basic/ngram-contains.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-basic/ngram-contains.sqlpp
@@ -35,18 +35,18 @@ create type test.DBLPTypetmp as
title : string,
authors : string,
misc : string
-}
+};
create type test.DBLPType as
closed {
nested : DBLPTypetmp
-}
+};
create dataset DBLP(DBLPType) primary key nested.id;
create index ngram_index on DBLP (nested.title) type ngram (3);
-write output to asterix_nc1:"rttest/inverted-index-basic_ngram-contains.adm"
+write output to asterix_nc1:"rttest/inverted-index-basic_ngram-contains.adm";
select element o
from DBLP as o
where test.contains(o.nested.title,'Multimedia')
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-basic/ngram-edit-distance-check-panic.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-basic/ngram-edit-distance-check-panic.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-basic/ngram-edit-distance-check-panic.sqlpp
index c570e5a..4b2abe6 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-basic/ngram-edit-distance-check-panic.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-basic/ngram-edit-distance-check-panic.sqlpp
@@ -35,18 +35,18 @@ create type test.DBLPTypetmp as
title : string,
authors : string,
misc : string
-}
+};
create type test.DBLPType as
closed {
nested : DBLPTypetmp
-}
+};
create dataset DBLP(DBLPType) primary key nested.id;
create index ngram_index on DBLP (nested.authors) type ngram (3);
-write output to asterix_nc1:"rttest/inverted-index-basic_ngram-edit-distance-check-panic.adm"
+write output to asterix_nc1:"rttest/inverted-index-basic_ngram-edit-distance-check-panic.adm";
select element o
from DBLP as o
with ed as test.`edit-distance-check`(o.nested.authors,'Amihay Motro',5)
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-basic/ngram-edit-distance-check.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-basic/ngram-edit-distance-check.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-basic/ngram-edit-distance-check.sqlpp
index f088f1d..1bf50d0 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-basic/ngram-edit-distance-check.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-basic/ngram-edit-distance-check.sqlpp
@@ -35,18 +35,18 @@ create type test.DBLPTypetmp as
title : string,
authors : string,
misc : string
-}
+};
create type test.DBLPType as
closed {
nested : DBLPTypetmp
-}
+};
create dataset DBLP(DBLPType) primary key nested.id;
create index ngram_index on DBLP (nested.authors) type ngram (3);
-write output to asterix_nc1:"rttest/inverted-index-basic_ngram-edit-distance-check.adm"
+write output to asterix_nc1:"rttest/inverted-index-basic_ngram-edit-distance-check.adm";
select element o
from DBLP as o
where test.`edit-distance-check`(o.nested.authors,'Amihay Motro',1)[0]
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-basic/ngram-edit-distance-panic.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-basic/ngram-edit-distance-panic.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-basic/ngram-edit-distance-panic.sqlpp
index cd4ca4b..df59b6f 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-basic/ngram-edit-distance-panic.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-basic/ngram-edit-distance-panic.sqlpp
@@ -35,18 +35,18 @@ create type test.DBLPTypetmp as
title : string,
authors : string,
misc : string
-}
+};
create type test.DBLPType as
closed {
nested : DBLPTypetmp
-}
+};
create dataset DBLP(DBLPType) primary key nested.id;
create index ngram_index on DBLP (nested.authors) type ngram (3);
-write output to asterix_nc1:"rttest/inverted-index-basic_ngram-edit-distance-panic.adm"
+write output to asterix_nc1:"rttest/inverted-index-basic_ngram-edit-distance-panic.adm";
select element o
from DBLP as o
where (test.`edit-distance`(o.nested.authors,'Amihay Motro') <= 5)
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-basic/ngram-edit-distance.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-basic/ngram-edit-distance.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-basic/ngram-edit-distance.sqlpp
index 62866fa..8649d19 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-basic/ngram-edit-distance.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-basic/ngram-edit-distance.sqlpp
@@ -35,18 +35,18 @@ create type test.DBLPTypetmp as
title : string,
authors : string,
misc : string
-}
+};
create type test.DBLPType as
closed {
nested : DBLPTypetmp
-}
+};
create dataset DBLP(DBLPType) primary key nested.id;
create index ngram_index on DBLP (nested.authors) type ngram (3);
-write output to asterix_nc1:"rttest/inverted-index-basic_ngram-edit-distance.adm"
+write output to asterix_nc1:"rttest/inverted-index-basic_ngram-edit-distance.adm";
select element o
from DBLP as o
where (test.`edit-distance`(o.nested.authors,'Amihay Motro') <= 1)
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-basic/ngram-fuzzyeq-edit-distance.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-basic/ngram-fuzzyeq-edit-distance.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-basic/ngram-fuzzyeq-edit-distance.sqlpp
index 88c037d..5898c33 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-basic/ngram-fuzzyeq-edit-distance.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-basic/ngram-fuzzyeq-edit-distance.sqlpp
@@ -35,18 +35,18 @@ create type test.DBLPTypetmp as
title : string,
authors : string,
misc : string
-}
+};
create type test.DBLPType as
closed {
nested : DBLPTypetmp
-}
+};
create dataset DBLP(DBLPType) primary key nested.id;
create index ngram_index on DBLP (nested.authors) type ngram (3);
-write output to asterix_nc1:"rttest/inverted-index-basic_ngram-fuzzyeq-edit-distance.adm"
+write output to asterix_nc1:"rttest/inverted-index-basic_ngram-fuzzyeq-edit-distance.adm";
set `simfunction` `edit-distance`;
set `simthreshold` `1`;
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-basic/ngram-fuzzyeq-jaccard.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-basic/ngram-fuzzyeq-jaccard.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-basic/ngram-fuzzyeq-jaccard.sqlpp
index de7bfef..b72c853 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-basic/ngram-fuzzyeq-jaccard.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-basic/ngram-fuzzyeq-jaccard.sqlpp
@@ -37,18 +37,18 @@ create type test.DBLPTypetmp as
title : string,
authors : string,
misc : string
-}
+};
create type test.DBLPType as
closed {
nested : DBLPTypetmp
-}
+};
create dataset DBLP(DBLPType) primary key nested.id;
create index ngram_index on DBLP (nested.title) type ngram (3);
-write output to asterix_nc1:"rttest/inverted-index-basic_ngram-fuzzyeq-jaccard.adm"
+write output to asterix_nc1:"rttest/inverted-index-basic_ngram-fuzzyeq-jaccard.adm";
set `simfunction` `jaccard`;
set `simthreshold` `0.8f`;
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-basic/ngram-jaccard-check.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-basic/ngram-jaccard-check.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-basic/ngram-jaccard-check.sqlpp
index 1958146..08b09e6 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-basic/ngram-jaccard-check.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-basic/ngram-jaccard-check.sqlpp
@@ -37,18 +37,18 @@ create type test.DBLPTypetmp as
title : string,
authors : string,
misc : string
-}
+};
create type test.DBLPType as
closed {
nested : DBLPTypetmp
-}
+};
create dataset DBLP(DBLPType) primary key nested.id;
create index ngram_index on DBLP (nested.title) type ngram (3);
-write output to asterix_nc1:"rttest/inverted-index-basic_ngram-jaccard-check.adm"
+write output to asterix_nc1:"rttest/inverted-index-basic_ngram-jaccard-check.adm";
select element o
from DBLP as o
where test.`similarity-jaccard-check`(test.`gram-tokens`(o.nested.title,3,false),test.`gram-tokens`('Transactions for Cooperative Environments',3,false),0.500000f)[0]
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-basic/ngram-jaccard.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-basic/ngram-jaccard.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-basic/ngram-jaccard.sqlpp
index cf5da2c..fa1a246 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-basic/ngram-jaccard.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-basic/ngram-jaccard.sqlpp
@@ -37,18 +37,18 @@ create type test.DBLPTypetmp as
title : string,
authors : string,
misc : string
-}
+};
create type test.DBLPType as
closed {
nested : DBLPTypetmp
-}
+};
create dataset DBLP(DBLPType) primary key nested.id;
create index ngram_index on DBLP (nested.title) type ngram (3);
-write output to asterix_nc1:"rttest/inverted-index-basic_ngram-jaccard.adm"
+write output to asterix_nc1:"rttest/inverted-index-basic_ngram-jaccard.adm";
select element o
from DBLP as o
where (test.`similarity-jaccard`(test.`gram-tokens`(o.nested.title,3,false),test.`gram-tokens`('Transactions for Cooperative Environments',3,false)) >= 0.500000f)
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-basic/olist-edit-distance-check-panic.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-basic/olist-edit-distance-check-panic.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-basic/olist-edit-distance-check-panic.sqlpp
index b66d87b..81e7ae9 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-basic/olist-edit-distance-check-panic.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-basic/olist-edit-distance-check-panic.sqlpp
@@ -33,7 +33,7 @@ create type test.AddressType as
number : integer,
street : string,
city : string
-}
+};
create type test.CustomerTypetmp as
closed {
@@ -47,12 +47,12 @@ create type test.CustomerTypetmp as
age : integer?
}
]
-}
+};
create type test.CustomerType as
closed {
nested : CustomerTypetmp
-}
+};
create dataset Customers(CustomerType) primary key nested.cid;
@@ -60,7 +60,7 @@ create dataset Customers2(CustomerType) primary key nested.cid;
create index interests_index on Customers (nested.interests) type keyword;
-write output to asterix_nc1:"rttest/inverted-index-basic_olist-edit-distance-check-panic.adm"
+write output to asterix_nc1:"rttest/inverted-index-basic_olist-edit-distance-check-panic.adm";
select element c
from Customers as c
where test.`edit-distance-check`(c.nested.interests,['computers','wine','walking'],3)[0]
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-basic/olist-edit-distance-check.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-basic/olist-edit-distance-check.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-basic/olist-edit-distance-check.sqlpp
index a8a6326..8c113d1 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-basic/olist-edit-distance-check.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-basic/olist-edit-distance-check.sqlpp
@@ -33,7 +33,7 @@ create type test.AddressType as
number : integer,
street : string,
city : string
-}
+};
create type test.CustomerTypetmp as
closed {
@@ -47,12 +47,12 @@ create type test.CustomerTypetmp as
age : integer?
}
]
-}
+};
create type test.CustomerType as
closed {
nested : CustomerTypetmp
-}
+};
create dataset Customers(CustomerType) primary key nested.cid;
@@ -60,7 +60,7 @@ create dataset Customers2(CustomerType) primary key nested.cid;
create index interests_index on Customers (nested.interests) type keyword;
-write output to asterix_nc1:"rttest/inverted-index-basic_olist-edit-distance-check.adm"
+write output to asterix_nc1:"rttest/inverted-index-basic_olist-edit-distance-check.adm";
select element c
from Customers as c
where test.`edit-distance-check`(c.nested.interests,['computers','wine','walking'],1)[0]
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-basic/olist-edit-distance-panic.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-basic/olist-edit-distance-panic.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-basic/olist-edit-distance-panic.sqlpp
index ea86c45..74d2796 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-basic/olist-edit-distance-panic.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-basic/olist-edit-distance-panic.sqlpp
@@ -33,7 +33,7 @@ create type test.AddressType as
number : integer,
street : string,
city : string
-}
+};
create type test.CustomerTypetmp as
closed {
@@ -47,12 +47,12 @@ create type test.CustomerTypetmp as
age : integer?
}
]
-}
+};
create type test.CustomerType as
closed {
nested : CustomerTypetmp
-}
+};
create dataset Customers(CustomerType) primary key nested.cid;
@@ -60,7 +60,7 @@ create dataset Customers2(CustomerType) primary key nested.cid;
create index interests_index on Customers (nested.interests) type keyword;
-write output to asterix_nc1:"rttest/inverted-index-basic_olist-edit-distance-panic.adm"
+write output to asterix_nc1:"rttest/inverted-index-basic_olist-edit-distance-panic.adm";
select element c
from Customers as c
where (test.`edit-distance`(c.nested.interests,['computers','wine','walking']) <= 3)
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-basic/olist-edit-distance.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-basic/olist-edit-distance.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-basic/olist-edit-distance.sqlpp
index 61a7539..2103dc6 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-basic/olist-edit-distance.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-basic/olist-edit-distance.sqlpp
@@ -33,7 +33,7 @@ create type test.AddressType as
number : integer,
street : string,
city : string
-}
+};
create type test.CustomerTypetmp as
closed {
@@ -47,12 +47,12 @@ create type test.CustomerTypetmp as
age : integer?
}
]
-}
+};
create type test.CustomerType as
closed {
nested : CustomerTypetmp
-}
+};
create dataset Customers(CustomerType) primary key nested.cid;
@@ -60,7 +60,7 @@ create dataset Customers2(CustomerType) primary key nested.cid;
create index interests_index on Customers (nested.interests) type keyword;
-write output to asterix_nc1:"rttest/inverted-index-basic_olist-edit-distance.adm"
+write output to asterix_nc1:"rttest/inverted-index-basic_olist-edit-distance.adm";
select element c
from Customers as c
where (test.`edit-distance`(c.nested.interests,['computers','wine','walking']) <= 1)
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-basic/olist-fuzzyeq-edit-distance.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-basic/olist-fuzzyeq-edit-distance.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-basic/olist-fuzzyeq-edit-distance.sqlpp
index eb98cda..53fe1ab 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-basic/olist-fuzzyeq-edit-distance.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-basic/olist-fuzzyeq-edit-distance.sqlpp
@@ -33,7 +33,7 @@ create type test.AddressType as
number : integer,
street : string,
city : string
-}
+};
create type test.CustomerTypetmp as
closed {
@@ -47,18 +47,18 @@ create type test.CustomerTypetmp as
age : integer?
}
]
-}
+};
create type test.CustomerType as
closed {
nested : CustomerTypetmp
-}
+};
create dataset Customers(CustomerType) primary key nested.cid;
create index interests_index on Customers (nested.interests) type keyword;
-write output to asterix_nc1:"rttest/inverted-index-basic_olist-fuzzyeq-edit-distance.adm"
+write output to asterix_nc1:"rttest/inverted-index-basic_olist-fuzzyeq-edit-distance.adm";
set `simfunction` `edit-distance`;
set `simthreshold` `1`;
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-basic/olist-fuzzyeq-jaccard.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-basic/olist-fuzzyeq-jaccard.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-basic/olist-fuzzyeq-jaccard.sqlpp
index c3e6f33..fb4b646 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-basic/olist-fuzzyeq-jaccard.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-basic/olist-fuzzyeq-jaccard.sqlpp
@@ -33,7 +33,7 @@ create type test.AddressType as
number : integer,
street : string,
city : string
-}
+};
create type test.CustomerTypetmp as
closed {
@@ -47,18 +47,18 @@ create type test.CustomerTypetmp as
age : integer?
}
]
-}
+};
create type test.CustomerType as
closed {
nested : CustomerTypetmp
-}
+};
create dataset Customers(CustomerType) primary key nested.cid;
create index interests_index on Customers (nested.interests) type keyword;
-write output to asterix_nc1:"rttest/inverted-index-basic_olist-fuzzyeq-jaccard.adm"
+write output to asterix_nc1:"rttest/inverted-index-basic_olist-fuzzyeq-jaccard.adm";
set `simfunction` `jaccard`;
set `simthreshold` `0.8f`;
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-basic/olist-jaccard-check.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-basic/olist-jaccard-check.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-basic/olist-jaccard-check.sqlpp
index af74f96..6d7e181 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-basic/olist-jaccard-check.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-basic/olist-jaccard-check.sqlpp
@@ -33,7 +33,7 @@ create type test.AddressType as
number : integer,
street : string,
city : string
-}
+};
create type test.CustomerTypetmp as
closed {
@@ -47,18 +47,18 @@ create type test.CustomerTypetmp as
age : integer?
}
]
-}
+};
create type test.CustomerType as
closed {
nested : CustomerTypetmp
-}
+};
create dataset Customers(CustomerType) primary key nested.cid;
create index interests_index on Customers (nested.interests) type keyword;
-write output to asterix_nc1:"rttest/inverted-index-basic_olist-jaccard-check.adm"
+write output to asterix_nc1:"rttest/inverted-index-basic_olist-jaccard-check.adm";
select element c
from Customers as c
where test.`similarity-jaccard-check`(c.nested.interests,['databases','computers','wine'],0.700000f)[0]
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-basic/olist-jaccard.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-basic/olist-jaccard.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-basic/olist-jaccard.sqlpp
index 7d2b86a..e148b25 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-basic/olist-jaccard.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-basic/olist-jaccard.sqlpp
@@ -33,7 +33,7 @@ create type test.AddressType as
number : integer,
street : string,
city : string
-}
+};
create type test.CustomerTypetmp as
closed {
@@ -47,12 +47,12 @@ create type test.CustomerTypetmp as
age : integer?
}
]
-}
+};
create type test.CustomerType as
closed {
nested : CustomerTypetmp
-}
+};
create dataset Customers(CustomerType) primary key nested.cid;
@@ -60,7 +60,7 @@ create dataset Customers2(CustomerType) primary key nested.cid;
create index interests_index on Customers (nested.interests) type keyword;
-write output to asterix_nc1:"rttest/inverted-index-basic_olist-jaccard.adm"
+write output to asterix_nc1:"rttest/inverted-index-basic_olist-jaccard.adm";
select element c
from Customers as c
where (test.`similarity-jaccard`(c.nested.interests,['databases','computers','wine']) >= 0.700000f)
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-basic/ulist-fuzzyeq-jaccard.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-basic/ulist-fuzzyeq-jaccard.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-basic/ulist-fuzzyeq-jaccard.sqlpp
index bc1f903..507ae3d 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-basic/ulist-fuzzyeq-jaccard.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-basic/ulist-fuzzyeq-jaccard.sqlpp
@@ -33,7 +33,7 @@ create type test.AddressType as
number : integer,
street : string,
city : string
-}
+};
create type test.CustomerTypetmp as
closed {
@@ -47,12 +47,12 @@ create type test.CustomerTypetmp as
age : integer?
}
]
-}
+};
create type test.CustomerType as
closed {
nested : CustomerTypetmp
-}
+};
create dataset Customers(CustomerType) primary key nested.cid;
@@ -60,7 +60,7 @@ create dataset Customers2(CustomerType) primary key nested.cid;
create index interests_index on Customers (nested.interests) type keyword;
-write output to asterix_nc1:"rttest/inverted-index-basic_ulist-fuzzyeq-jaccard.adm"
+write output to asterix_nc1:"rttest/inverted-index-basic_ulist-fuzzyeq-jaccard.adm";
set `simfunction` `jaccard`;
set `simthreshold` `0.8f`;
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-basic/ulist-jaccard-check.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-basic/ulist-jaccard-check.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-basic/ulist-jaccard-check.sqlpp
index d1a2464..f4eb512 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-basic/ulist-jaccard-check.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-basic/ulist-jaccard-check.sqlpp
@@ -33,7 +33,7 @@ create type test.AddressType as
number : integer,
street : string,
city : string
-}
+};
create type test.CustomerTypetmp as
closed {
@@ -47,12 +47,12 @@ create type test.CustomerTypetmp as
age : integer?
}
]
-}
+};
create type test.CustomerType as
closed {
nested : CustomerTypetmp
-}
+};
create dataset Customers(CustomerType) primary key nested.cid;
@@ -60,7 +60,7 @@ create dataset Customers2(CustomerType) primary key nested.cid;
create index interests_index on Customers (nested.interests) type keyword;
-write output to asterix_nc1:"rttest/inverted-index-basic_ulist-jaccard.adm"
+write output to asterix_nc1:"rttest/inverted-index-basic_ulist-jaccard.adm";
select element c
from Customers as c
where test.`similarity-jaccard-check`(c.nested.interests,{{'computers','wine','databases'}},0.700000f)[0]
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-basic/ulist-jaccard.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-basic/ulist-jaccard.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-basic/ulist-jaccard.sqlpp
index 8b6e2f2..fa54a39 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-basic/ulist-jaccard.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-basic/ulist-jaccard.sqlpp
@@ -33,7 +33,7 @@ create type test.AddressType as
number : integer,
street : string,
city : string
-}
+};
create type test.CustomerTypetmp as
closed {
@@ -47,12 +47,12 @@ create type test.CustomerTypetmp as
age : integer?
}
]
-}
+};
create type test.CustomerType as
closed {
nested : CustomerTypetmp
-}
+};
create dataset Customers(CustomerType) primary key nested.cid;
@@ -60,7 +60,7 @@ create dataset Customers2(CustomerType) primary key nested.cid;
create index interests_index on Customers (nested.interests) type keyword;
-write output to asterix_nc1:"rttest/inverted-index-basic_ulist-jaccard.adm"
+write output to asterix_nc1:"rttest/inverted-index-basic_ulist-jaccard.adm";
select element c
from Customers as c
where (test.`similarity-jaccard`(c.nested.interests,{{'computers','databases','wine'}}) >= 0.700000f)
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-basic/word-contains.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-basic/word-contains.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-basic/word-contains.sqlpp
index 23f7df6..09b06b2 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-basic/word-contains.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-basic/word-contains.sqlpp
@@ -35,18 +35,18 @@ create type test.DBLPTypetmp as
title : string,
authors : string,
misc : string
-}
+};
create type test.DBLPType as
closed {
nested : DBLPTypetmp
-}
+};
create dataset DBLP(DBLPType) primary key nested.id;
create index keyword_index on DBLP (nested.title) type keyword;
-write output to asterix_nc1:"rttest/inverted-index-basic_word-contains.adm"
+write output to asterix_nc1:"rttest/inverted-index-basic_word-contains.adm";
select element o
from DBLP as o
where test.contains(o.nested.title,'Multimedia')
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-basic/word-fuzzyeq-jaccard.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-basic/word-fuzzyeq-jaccard.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-basic/word-fuzzyeq-jaccard.sqlpp
index 8ee8648..9d5fa37 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-basic/word-fuzzyeq-jaccard.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-basic/word-fuzzyeq-jaccard.sqlpp
@@ -35,18 +35,18 @@ create type test.DBLPTypetmp as
title : string,
authors : string,
misc : string
-}
+};
create type test.DBLPType as
closed {
nested : DBLPTypetmp
-}
+};
create dataset DBLP(DBLPType) primary key nested.id;
create index keyword_index on DBLP (nested.title) type keyword;
-write output to asterix_nc1:"rttest/inverted-index-basic_word-fuzzyeq-jaccard.adm"
+write output to asterix_nc1:"rttest/inverted-index-basic_word-fuzzyeq-jaccard.adm";
set `simfunction` `jaccard`;
set `simthreshold` `0.5f`;
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-basic/word-jaccard-check.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-basic/word-jaccard-check.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-basic/word-jaccard-check.sqlpp
index 161f08a..8296b81 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-basic/word-jaccard-check.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-basic/word-jaccard-check.sqlpp
@@ -35,18 +35,18 @@ create type test.DBLPTypetmp as
title : string,
authors : string,
misc : string
-}
+};
create type test.DBLPType as
closed {
nested : DBLPTypetmp
-}
+};
create dataset DBLP(DBLPType) primary key nested.id;
create index keyword_index on DBLP (nested.title) type keyword;
-write output to asterix_nc1:"rttest/inverted-index-basic_word-jaccard-check.adm"
+write output to asterix_nc1:"rttest/inverted-index-basic_word-jaccard-check.adm";
select element o
from DBLP as o
where test.`similarity-jaccard-check`(test.`word-tokens`(o.nested.title),test.`word-tokens`('Transactions for Cooperative Environments'),0.500000f)[0]
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-basic/word-jaccard.sqlpp
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-basic/word-jaccard.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-basic/word-jaccard.sqlpp
index e1d8685..24db418 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-basic/word-jaccard.sqlpp
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-index/inverted-index-basic/word-jaccard.sqlpp
@@ -35,18 +35,18 @@ create type test.DBLPTypetmp as
title : string,
authors : string,
misc : string
-}
+};
create type test.DBLPType as
closed {
nested : DBLPTypetmp
-}
+};
create dataset DBLP(DBLPType) primary key nested.id;
create index keyword_index on DBLP (nested.title) type keyword;
-write output to asterix_nc1:"rttest/inverted-index-basic_word-jaccard.adm"
+write output to asterix_nc1:"rttest/inverted-index-basic_word-jaccard.adm";
select element o
from DBLP as o
where (test.`similarity-jaccard`(test.`word-tokens`(o.nested.title),test.`word-tokens`('Transactions for Cooperative Environments')) >= 0.500000f)