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)
