http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index-join/secondary-composite-key-join_02.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index-join/secondary-composite-key-join_02.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index-join/secondary-composite-key-join_02.sqlpp index f44a10c..c94fc26 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index-join/secondary-composite-key-join_02.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index-join/secondary-composite-key-join_02.sqlpp @@ -32,18 +32,18 @@ use test; create type test.Nametmp as { id : integer -} +}; create type test.NameType as { nested : Nametmp -} +}; create dataset Names(NameType) primary key nested.id; create index Name_idx on Names (nested.fname:string?,lnested.name:string?) type btree enforced; -write output to asterix_nc1:"rttest/btree-index-join_secondary-composite-key-prefix-join_02.adm" +write output to asterix_nc1:"rttest/btree-index-join_secondary-composite-key-prefix-join_02.adm"; select element {'emp1':emp1,'emp2':emp2} from Names as emp1, Names as emp2
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index-join/secondary-composite-key-join_03.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index-join/secondary-composite-key-join_03.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index-join/secondary-composite-key-join_03.sqlpp index 7a919c3..3881d81 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index-join/secondary-composite-key-join_03.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index-join/secondary-composite-key-join_03.sqlpp @@ -32,18 +32,18 @@ use test; create type test.Nametmp as { id : integer -} +}; create type test.NameType as { nested : Nametmp -} +}; create dataset Names(NameType) primary key nested.id; create index Name_idx on Names (nested.fname:string?,lnested.name:string?) type btree enforced; -write output to asterix_nc1:"rttest/btree-index-join_secondary-composite-key-prefix-join_03.adm" +write output to asterix_nc1:"rttest/btree-index-join_secondary-composite-key-prefix-join_03.adm"; select element {'emp1':emp1,'emp2':emp2} from Names as emp1, Names as emp2 http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index-join/secondary-composite-key-prefix-join_01.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index-join/secondary-composite-key-prefix-join_01.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index-join/secondary-composite-key-prefix-join_01.sqlpp index cebfa07..61a7672 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index-join/secondary-composite-key-prefix-join_01.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index-join/secondary-composite-key-prefix-join_01.sqlpp @@ -32,18 +32,18 @@ use test; create type test.Nametmp as { id : integer -} +}; create type test.NameType as { nested : Nametmp -} +}; create dataset Names(NameType) primary key nested.id; create index Name_idx on Names (nested.fname:string?,lnested.name:string?) type btree enforced; -write output to asterix_nc1:"rttest/btree-index-join_secondary-composite-key-prefix-prefix-join_01.adm" +write output to asterix_nc1:"rttest/btree-index-join_secondary-composite-key-prefix-prefix-join_01.adm"; select element {'emp1':emp1,'emp2':emp2} from Names as emp1, Names as emp2 http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index-join/secondary-composite-key-prefix-join_02.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index-join/secondary-composite-key-prefix-join_02.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index-join/secondary-composite-key-prefix-join_02.sqlpp index a3434fe..0d617a2 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index-join/secondary-composite-key-prefix-join_02.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index-join/secondary-composite-key-prefix-join_02.sqlpp @@ -32,18 +32,18 @@ use test; create type test.Nametmp as { id : integer -} +}; create type test.NameType as { nested : Nametmp -} +}; create dataset Names(NameType) primary key nested.id; create index Name_idx on Names (nested.fname:string?,lnested.name:string?) type btree enforced; -write output to asterix_nc1:"rttest/btree-index-join_secondary-composite-key-prefix-prefix-join_02.adm" +write output to asterix_nc1:"rttest/btree-index-join_secondary-composite-key-prefix-prefix-join_02.adm"; select element {'emp1':emp1,'emp2':emp2} from Names as emp1, Names as emp2 http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index-join/secondary-composite-key-prefix-join_03.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index-join/secondary-composite-key-prefix-join_03.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index-join/secondary-composite-key-prefix-join_03.sqlpp index 21fa2e8..6c1a2a4 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index-join/secondary-composite-key-prefix-join_03.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index-join/secondary-composite-key-prefix-join_03.sqlpp @@ -32,18 +32,18 @@ use test; create type test.Nametmp as { id : integer -} +}; create type test.NameType as { nested : Nametmp -} +}; create dataset Names(NameType) primary key nested.id; create index Name_idx on Names (nested.fname:string?,lnested.name:string?) type btree enforced; -write output to asterix_nc1:"rttest/btree-index-join_secondary-composite-key-prefix-prefix-join_03.adm" +write output to asterix_nc1:"rttest/btree-index-join_secondary-composite-key-prefix-prefix-join_03.adm"; select element {'emp1':emp1,'emp2':emp2} from Names as emp1, Names as emp2 http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index-join/secondary-composite-key-prefix-join_04.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index-join/secondary-composite-key-prefix-join_04.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index-join/secondary-composite-key-prefix-join_04.sqlpp index 13af0ac..8c09b0b 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index-join/secondary-composite-key-prefix-join_04.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index-join/secondary-composite-key-prefix-join_04.sqlpp @@ -32,18 +32,18 @@ use test; create type test.Nametmp as { id : integer -} +}; create type test.NameType as { nested : Nametmp -} +}; create dataset Names(NameType) primary key nested.id; create index Name_idx on Names (nested.fname:string?,lnested.name:string?) type btree enforced; -write output to asterix_nc1:"rttest/btree-index-join_secondary-composite-key-prefix-prefix-join_04.adm" +write output to asterix_nc1:"rttest/btree-index-join_secondary-composite-key-prefix-prefix-join_04.adm"; select element {'emp1':emp1,'emp2':emp2} from Names as emp1, Names as emp2 http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index-join/secondary-composite-key-prefix-join_05.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index-join/secondary-composite-key-prefix-join_05.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index-join/secondary-composite-key-prefix-join_05.sqlpp index 61c7424..84069b4 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index-join/secondary-composite-key-prefix-join_05.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index-join/secondary-composite-key-prefix-join_05.sqlpp @@ -32,18 +32,18 @@ use test; create type test.Nametmp as { id : integer -} +}; create type test.NameType as { nested : Nametmp -} +}; create dataset Names(NameType) primary key nested.id; create index Name_idx on Names (nested.fname:string?,lnested.name:string?) type btree enforced; -write output to asterix_nc1:"rttest/btree-index-join_secondary-composite-key-prefix-prefix-join_05.adm" +write output to asterix_nc1:"rttest/btree-index-join_secondary-composite-key-prefix-prefix-join_05.adm"; select element {'emp1':emp1,'emp2':emp2} from Names as emp1, Names as emp2 http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index-join/secondary-composite-key-prefix-join_06.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index-join/secondary-composite-key-prefix-join_06.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index-join/secondary-composite-key-prefix-join_06.sqlpp index ef66911..4822293 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index-join/secondary-composite-key-prefix-join_06.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index-join/secondary-composite-key-prefix-join_06.sqlpp @@ -32,18 +32,18 @@ use test; create type test.Nametmp as { id : integer -} +}; create type test.NameType as { nested : Nametmp -} +}; create dataset Names(NameType) primary key nested.id; create index Name_idx on Names (nested.fname:string?,lnested.name:string?) type btree enforced; -write output to asterix_nc1:"rttest/btree-index-join_secondary-composite-key-prefix-prefix-join_06.adm" +write output to asterix_nc1:"rttest/btree-index-join_secondary-composite-key-prefix-prefix-join_06.adm"; select element {'emp1':emp1,'emp2':emp2} from Names as emp1, Names as emp2 http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index-join/secondary-equi-join-multiindex.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index-join/secondary-equi-join-multiindex.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index-join/secondary-equi-join-multiindex.sqlpp index 802b31c..cfb465a 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index-join/secondary-equi-join-multiindex.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index-join/secondary-equi-join-multiindex.sqlpp @@ -36,7 +36,7 @@ create type test.EmploymentType as `organization-name` : string, `start-date` : date, `end-date` : date? -} +}; create type test.FacebookUserTypetmp as closed { @@ -48,7 +48,7 @@ create type test.FacebookUserTypetmp as `user-since-copy` : datetime, `friend-ids` : {{integer}}, employment : [EmploymentType] -} +}; create type test.FacebookMessageTypetmp as { @@ -58,17 +58,17 @@ create type test.FacebookMessageTypetmp as `in-response-to` : integer?, `sender-location` : point?, message : string -} +}; create type test.FacebookUserType as closed { nested : FacebookUserTypetmp -} +}; create type test.FacebookMessageType as closed { nested : FacebookMessageTypetmp -} +}; create dataset FacebookUsers(FacebookUserType) primary key nested.id; @@ -76,7 +76,7 @@ create dataset FacebookMessages(FacebookMessageType) primary key nested.`messag create index fbmIdxAutId if not exists on FacebookMessages (nested.`author-id-copy`:integer?) type btree enforced; -write output to asterix_nc1:"rttest/btree-index-join_title-secondary-equi-join-multiindex.adm" +write output to asterix_nc1:"rttest/btree-index-join_title-secondary-equi-join-multiindex.adm"; select element {'fbu-ID':user.nested.id,'fbm-auth-ID':message.nested.`author-id`,'uname':user.nested.name,'message':message.nested.message} from FacebookUsers as user, FacebookMessages as message http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index-join/secondary-equi-join-multipred.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index-join/secondary-equi-join-multipred.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index-join/secondary-equi-join-multipred.sqlpp index 6859e93..92599bb 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index-join/secondary-equi-join-multipred.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index-join/secondary-equi-join-multipred.sqlpp @@ -37,7 +37,7 @@ create type test.DBLPTypetmp as dblpid : string, authors : string, misc : string -} +}; create type test.CSXTypetmp as closed { @@ -46,17 +46,17 @@ create type test.CSXTypetmp as title : string, authors : string, misc : string -} +}; create type test.DBLPType as closed { nested : DBLPTypetmp -} +}; create type test.CSXType as closed { nested : CSXTypetmp -} +}; create dataset DBLP(DBLPType) primary key nested.id; @@ -64,7 +64,7 @@ create dataset CSX(CSXType) primary key nested.id; create index title_index on DBLP (nested.title:string?) type btree enforced; -write output to asterix_nc1:"rttest/btree-index-join_title-secondary-equi-join-multipred.adm" +write output to asterix_nc1:"rttest/btree-index-join_title-secondary-equi-join-multipred.adm"; select element {'arec':a,'brec':b} from DBLP as a, CSX as b http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index-join/secondary-equi-join_01.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index-join/secondary-equi-join_01.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index-join/secondary-equi-join_01.sqlpp index 90d2951..6b207c5 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index-join/secondary-equi-join_01.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index-join/secondary-equi-join_01.sqlpp @@ -35,7 +35,7 @@ create type test.DBLPTypetmp as dblpid : string, authors : string, misc : string -} +}; create type test.CSXTypetmp as closed { @@ -44,17 +44,17 @@ create type test.CSXTypetmp as title : string, authors : string, misc : string -} +}; create type test.DBLPType as closed { nested : DBLPTypetmp -} +}; create type test.CSXType as closed { nested : CSXTypetmp -} +}; create dataset DBLP(DBLPType) primary key nested.id; @@ -62,7 +62,7 @@ create dataset CSX(CSXType) primary key nested.id; create index title_index on DBLP (nested.title:string?) type btree enforced; -write output to asterix_nc1:"rttest/btree-index-join_title-secondary-equi-join_01.adm" +write output to asterix_nc1:"rttest/btree-index-join_title-secondary-equi-join_01.adm"; select element {'arec':a,'brec':b} from DBLP as a, CSX as b http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index-join/secondary-equi-join_02.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index-join/secondary-equi-join_02.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index-join/secondary-equi-join_02.sqlpp index d78a86b..fc67495 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index-join/secondary-equi-join_02.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index-join/secondary-equi-join_02.sqlpp @@ -36,7 +36,7 @@ create type test.DBLPTypetmp as title : string, authors : string, misc : string -} +}; create type test.CSXTypetmp as { @@ -44,17 +44,17 @@ create type test.CSXTypetmp as csxid : string, authors : string, misc : string -} +}; create type test.DBLPType as closed { nested : DBLPTypetmp -} +}; create type test.CSXType as closed { nested : CSXTypetmp -} +}; create dataset DBLP(DBLPType) primary key nested.id; @@ -62,7 +62,7 @@ create dataset CSX(CSXType) primary key nested.id; create index title_index on CSX (nested.title:string?) type btree enforced; -write output to asterix_nc1:"rttest/btree-index-join_title-secondary-equi-join_02.adm" +write output to asterix_nc1:"rttest/btree-index-join_title-secondary-equi-join_02.adm"; select element {'arec':a,'brec':b} from DBLP as a, CSX as b http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index-join/secondary-equi-join_03.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index-join/secondary-equi-join_03.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index-join/secondary-equi-join_03.sqlpp index 8d5ed86..c8b0dfd 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index-join/secondary-equi-join_03.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index-join/secondary-equi-join_03.sqlpp @@ -35,7 +35,7 @@ create type test.DBLPTypetmp as dblpid : string, authors : string, misc : string -} +}; create type test.CSXTypetmp as { @@ -43,17 +43,17 @@ create type test.CSXTypetmp as csxid : string, authors : string, misc : string -} +}; create type test.DBLPType as closed { nested : DBLPTypetmp -} +}; create type test.CSXType as closed { nested : CSXTypetmp -} +}; create dataset DBLP(DBLPType) primary key nested.id; @@ -63,7 +63,7 @@ create index title_index_DBLP on DBLP (nested.title:string?) type btree enforc create index title_index_CSX on CSX (nested.title:string?) type btree enforced; -write output to asterix_nc1:"rttest/btree-index-join_title-secondary-equi-join_03.adm" +write output to asterix_nc1:"rttest/btree-index-join_title-secondary-equi-join_03.adm"; select element {'arec':a,'brec':b} from DBLP as a, CSX as b http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index-join/secondary-equi-join_04.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index-join/secondary-equi-join_04.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index-join/secondary-equi-join_04.sqlpp index 364cfc2..c68c001 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index-join/secondary-equi-join_04.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index-join/secondary-equi-join_04.sqlpp @@ -35,18 +35,18 @@ create type test.DBLPTypetmp as dblpid : string, authors : string, misc : string -} +}; create type test.DBLPType as { nested : DBLPTypetmp -} +}; create dataset DBLP(DBLPType) primary key nested.id; create index title_index on DBLP (nested.title:string?) type btree enforced; -write output to asterix_nc1:"rttest/btree-index-join_title-secondary-equi-join_04.adm" +write output to asterix_nc1:"rttest/btree-index-join_title-secondary-equi-join_04.adm"; select element {'arec':a,'arec2':a2} from DBLP as a, DBLP as a2 http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index-join/secondary-equi-join_05.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index-join/secondary-equi-join_05.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index-join/secondary-equi-join_05.sqlpp index 6db5040..38ff226 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index-join/secondary-equi-join_05.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index-join/secondary-equi-join_05.sqlpp @@ -35,7 +35,7 @@ create type test.DBLPTypetmp as dblpid : string, authors : string, misc : string -} +}; create type test.CSXTypetmp as { @@ -43,17 +43,17 @@ create type test.CSXTypetmp as csxid : string, authors : string, misc : string -} +}; create type test.DBLPType as closed { nested : DBLPTypetmp -} +}; create type test.CSXType as closed { nested : CSXTypetmp -} +}; create dataset DBLP(DBLPType) primary key nested.id; @@ -61,7 +61,7 @@ create dataset CSX(CSXType) primary key nested.id; create index title_index on DBLP (nested.title:string?) type btree enforced; -write output to asterix_nc1:"rttest/btree-index-join_title-secondary-equi-join_05.adm" +write output to asterix_nc1:"rttest/btree-index-join_title-secondary-equi-join_05.adm"; select element {'arec':a,'brec':b} from DBLP as a, CSX as b http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index/btree-secondary-33.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index/btree-secondary-33.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index/btree-secondary-33.sqlpp index e825441..5eedf99 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index/btree-secondary-33.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index/btree-secondary-33.sqlpp @@ -30,16 +30,16 @@ create dataverse test; use test; -write output to asterix_nc1:"rttest/btree-index_btree-primary-39.adm" +write output to asterix_nc1:"rttest/btree-index_btree-primary-39.adm"; create type test.TestTypetmp as { id : integer -} +}; 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-open-index/btree-index/btree-secondary-34.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index/btree-secondary-34.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index/btree-secondary-34.sqlpp index d80cd72..dafd317 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index/btree-secondary-34.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index/btree-secondary-34.sqlpp @@ -30,16 +30,16 @@ 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 -} +}; 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-open-index/btree-index/btree-secondary-35.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index/btree-secondary-35.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index/btree-secondary-35.sqlpp index c0148eb..236d8a4 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index/btree-secondary-35.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index/btree-secondary-35.sqlpp @@ -30,16 +30,16 @@ 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 -} +}; 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-open-index/btree-index/btree-secondary-36.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index/btree-secondary-36.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index/btree-secondary-36.sqlpp index 9050120..44a582b 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index/btree-secondary-36.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index/btree-secondary-36.sqlpp @@ -30,16 +30,16 @@ 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 -} +}; 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-open-index/btree-index/btree-secondary-37.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index/btree-secondary-37.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index/btree-secondary-37.sqlpp index f45c4b8..361af5f 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index/btree-secondary-37.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index/btree-secondary-37.sqlpp @@ -30,16 +30,16 @@ 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 -} +}; 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-open-index/btree-index/btree-secondary-38.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index/btree-secondary-38.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index/btree-secondary-38.sqlpp index 160a2ef..a7cf700 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index/btree-secondary-38.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index/btree-secondary-38.sqlpp @@ -30,16 +30,16 @@ 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 -} +}; 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-open-index/btree-index/btree-secondary-39.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index/btree-secondary-39.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index/btree-secondary-39.sqlpp index ca3a198..ed1bbcc 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index/btree-secondary-39.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index/btree-secondary-39.sqlpp @@ -29,16 +29,16 @@ 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 -} +}; 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-open-index/btree-index/btree-secondary-40.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index/btree-secondary-40.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index/btree-secondary-40.sqlpp index 90a3b65..8f4bab2 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index/btree-secondary-40.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index/btree-secondary-40.sqlpp @@ -29,16 +29,16 @@ 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 -} +}; 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-open-index/btree-index/btree-secondary-41.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index/btree-secondary-41.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index/btree-secondary-41.sqlpp index 0888c7e..0d54ffc 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index/btree-secondary-41.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index/btree-secondary-41.sqlpp @@ -30,16 +30,16 @@ 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 -} +}; 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-open-index/btree-index/btree-secondary-42.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index/btree-secondary-42.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index/btree-secondary-42.sqlpp index 3f936bd..f412a96 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index/btree-secondary-42.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index/btree-secondary-42.sqlpp @@ -30,16 +30,16 @@ 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 -} +}; 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-open-index/btree-index/btree-secondary-43.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index/btree-secondary-43.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index/btree-secondary-43.sqlpp index 57e90ea..5872426 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index/btree-secondary-43.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index/btree-secondary-43.sqlpp @@ -30,16 +30,16 @@ 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 -} +}; 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-open-index/btree-index/btree-secondary-44.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index/btree-secondary-44.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index/btree-secondary-44.sqlpp index bc295e8..f7a4e51 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index/btree-secondary-44.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index/btree-secondary-44.sqlpp @@ -30,16 +30,16 @@ 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 -} +}; 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-open-index/btree-index/btree-secondary-45.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index/btree-secondary-45.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index/btree-secondary-45.sqlpp index f18ec0f..e5eeb29 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index/btree-secondary-45.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index/btree-secondary-45.sqlpp @@ -30,16 +30,16 @@ 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 -} +}; 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-open-index/btree-index/btree-secondary-46.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index/btree-secondary-46.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index/btree-secondary-46.sqlpp index a594359..bf04ce0 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index/btree-secondary-46.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index/btree-secondary-46.sqlpp @@ -30,16 +30,16 @@ 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 -} +}; 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-open-index/btree-index/btree-secondary-47.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index/btree-secondary-47.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index/btree-secondary-47.sqlpp index 942f7ec..b2b23a1 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index/btree-secondary-47.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index/btree-secondary-47.sqlpp @@ -30,16 +30,16 @@ 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 -} +}; 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-open-index/btree-index/btree-secondary-48.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index/btree-secondary-48.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index/btree-secondary-48.sqlpp index 0c884a2..a3689e3 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index/btree-secondary-48.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index/btree-secondary-48.sqlpp @@ -30,16 +30,16 @@ 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 -} +}; 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-open-index/btree-index/btree-secondary-49.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index/btree-secondary-49.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index/btree-secondary-49.sqlpp index 3bf8493..f5d7566 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index/btree-secondary-49.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index/btree-secondary-49.sqlpp @@ -30,16 +30,16 @@ 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 -} +}; 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-open-index/btree-index/btree-secondary-50.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index/btree-secondary-50.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index/btree-secondary-50.sqlpp index c55a454..171229e 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index/btree-secondary-50.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index/btree-secondary-50.sqlpp @@ -30,16 +30,16 @@ 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 -} +}; 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-open-index/btree-index/btree-secondary-51.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index/btree-secondary-51.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index/btree-secondary-51.sqlpp index b2fa4c9..6c8d7ba 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index/btree-secondary-51.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index/btree-secondary-51.sqlpp @@ -30,16 +30,16 @@ 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 -} +}; 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-open-index/btree-index/btree-secondary-52.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index/btree-secondary-52.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index/btree-secondary-52.sqlpp index 7df1221..68c46aa 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index/btree-secondary-52.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index/btree-secondary-52.sqlpp @@ -30,16 +30,16 @@ 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 -} +}; 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-open-index/btree-index/btree-secondary-53.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index/btree-secondary-53.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index/btree-secondary-53.sqlpp index 14ae213..91b932e 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index/btree-secondary-53.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index/btree-secondary-53.sqlpp @@ -30,16 +30,16 @@ 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 -} +}; 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-open-index/btree-index/btree-secondary-54.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index/btree-secondary-54.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index/btree-secondary-54.sqlpp index 81530ac..7b4ed5c 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index/btree-secondary-54.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index/btree-secondary-54.sqlpp @@ -29,17 +29,17 @@ 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, 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-open-index/btree-index/btree-secondary-55.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index/btree-secondary-55.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index/btree-secondary-55.sqlpp index b0d2f17..a7a9ffa 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index/btree-secondary-55.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index/btree-secondary-55.sqlpp @@ -29,17 +29,17 @@ 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, 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-open-index/btree-index/btree-secondary-56.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index/btree-secondary-56.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index/btree-secondary-56.sqlpp index ffcb484..bbb3b01 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index/btree-secondary-56.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index/btree-secondary-56.sqlpp @@ -29,17 +29,17 @@ 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, 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-open-index/btree-index/btree-secondary-57.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index/btree-secondary-57.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index/btree-secondary-57.sqlpp index a13a6ae..4188230 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index/btree-secondary-57.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index/btree-secondary-57.sqlpp @@ -29,17 +29,17 @@ 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, 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-open-index/btree-index/btree-secondary-58.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index/btree-secondary-58.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index/btree-secondary-58.sqlpp index f33f06d..d0d619f 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index/btree-secondary-58.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index/btree-secondary-58.sqlpp @@ -29,17 +29,17 @@ 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, 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-open-index/btree-index/btree-secondary-59.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index/btree-secondary-59.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index/btree-secondary-59.sqlpp index eadb114..b454d71 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index/btree-secondary-59.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index/btree-secondary-59.sqlpp @@ -29,17 +29,17 @@ 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, 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-open-index/btree-index/btree-secondary-60.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index/btree-secondary-60.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index/btree-secondary-60.sqlpp index 7898cb9..62ed07e 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index/btree-secondary-60.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index/btree-secondary-60.sqlpp @@ -29,17 +29,17 @@ 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, 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-open-index/btree-index/btree-secondary-61.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index/btree-secondary-61.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index/btree-secondary-61.sqlpp index 45dd983..c4bb152 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index/btree-secondary-61.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index/btree-secondary-61.sqlpp @@ -30,16 +30,16 @@ create dataverse test; use test; -write output to asterix_nc1:"rttest/btree-index_btree-secondary-59.adm" +write output to asterix_nc1:"rttest/btree-index_btree-secondary-59.adm"; create type test.TestTypetmp as { id : integer -} +}; 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-open-index/btree-index/btree-secondary-62.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index/btree-secondary-62.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index/btree-secondary-62.sqlpp index 5045510..198d361 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index/btree-secondary-62.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index/btree-secondary-62.sqlpp @@ -30,16 +30,16 @@ 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 -} +}; 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-open-index/btree-index/btree-secondary-63.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index/btree-secondary-63.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index/btree-secondary-63.sqlpp index b901683..85ff1d4 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index/btree-secondary-63.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/btree-index/btree-secondary-63.sqlpp @@ -30,16 +30,16 @@ 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 -} +}; 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-open-index/inverted-index-basic/ngram-contains-panic.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-basic/ngram-contains-panic.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-basic/ngram-contains-panic.sqlpp index 98a0fc7..1d4e565 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-basic/ngram-contains-panic.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-basic/ngram-contains-panic.sqlpp @@ -34,18 +34,18 @@ create type test.DBLPTypetmp as dblpid : 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:string?) type ngram (3) enforced; -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-open-index/inverted-index-basic/ngram-contains.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-basic/ngram-contains.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-basic/ngram-contains.sqlpp index 88f1908..ed08291 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-basic/ngram-contains.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-basic/ngram-contains.sqlpp @@ -34,18 +34,18 @@ create type test.DBLPTypetmp as dblpid : 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:string?) type ngram (3) enforced; -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-open-index/inverted-index-basic/ngram-edit-distance-check-panic.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-basic/ngram-edit-distance-check-panic.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-basic/ngram-edit-distance-check-panic.sqlpp index 5745d16..9377ea0 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-basic/ngram-edit-distance-check-panic.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-basic/ngram-edit-distance-check-panic.sqlpp @@ -34,18 +34,18 @@ create type test.DBLPTypetmp as dblpid : string, title : 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:string?) type ngram (3) enforced; -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-open-index/inverted-index-basic/ngram-edit-distance-check.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-basic/ngram-edit-distance-check.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-basic/ngram-edit-distance-check.sqlpp index 9ad58cb..e30ff08 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-basic/ngram-edit-distance-check.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-basic/ngram-edit-distance-check.sqlpp @@ -34,18 +34,18 @@ create type test.DBLPTypetmp as dblpid : string, title : 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:string?) type ngram (3) enforced; -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-open-index/inverted-index-basic/ngram-edit-distance-panic.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-basic/ngram-edit-distance-panic.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-basic/ngram-edit-distance-panic.sqlpp index 94b1ecc..55959f2 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-basic/ngram-edit-distance-panic.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-basic/ngram-edit-distance-panic.sqlpp @@ -34,18 +34,18 @@ create type test.DBLPTypetmp as dblpid : string, title : 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:string?) type ngram (3) enforced; -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-open-index/inverted-index-basic/ngram-edit-distance.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-basic/ngram-edit-distance.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-basic/ngram-edit-distance.sqlpp index cf15310..8c23d24 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-basic/ngram-edit-distance.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-basic/ngram-edit-distance.sqlpp @@ -34,18 +34,18 @@ create type test.DBLPTypetmp as dblpid : string, title : 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:string?) type ngram (3) enforced; -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-open-index/inverted-index-basic/ngram-fuzzyeq-edit-distance.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-basic/ngram-fuzzyeq-edit-distance.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-basic/ngram-fuzzyeq-edit-distance.sqlpp index 00261d3..192ef74 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-basic/ngram-fuzzyeq-edit-distance.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-basic/ngram-fuzzyeq-edit-distance.sqlpp @@ -34,18 +34,18 @@ create type test.DBLPTypetmp as dblpid : string, title : 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:string?) type ngram (3) enforced; -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-open-index/inverted-index-basic/ngram-fuzzyeq-jaccard.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-basic/ngram-fuzzyeq-jaccard.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-basic/ngram-fuzzyeq-jaccard.sqlpp index f435f55..d6cfd59 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-basic/ngram-fuzzyeq-jaccard.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-basic/ngram-fuzzyeq-jaccard.sqlpp @@ -36,18 +36,18 @@ create type test.DBLPTypetmp as dblpid : 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:string?) type ngram (3) enforced; -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-open-index/inverted-index-basic/ngram-jaccard-check.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-basic/ngram-jaccard-check.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-basic/ngram-jaccard-check.sqlpp index ba44d09..cbda7b4 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-basic/ngram-jaccard-check.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-basic/ngram-jaccard-check.sqlpp @@ -36,18 +36,18 @@ create type test.DBLPTypetmp as dblpid : 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:string?) type ngram (3) enforced; -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-open-index/inverted-index-basic/ngram-jaccard.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-basic/ngram-jaccard.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-basic/ngram-jaccard.sqlpp index 4125bfc..be07ae2 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-basic/ngram-jaccard.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-basic/ngram-jaccard.sqlpp @@ -36,18 +36,18 @@ create type test.DBLPTypetmp as dblpid : 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:string?) type ngram (3) enforced; -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-open-index/inverted-index-basic/word-contains.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-basic/word-contains.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-basic/word-contains.sqlpp index 3584196..4a71613 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-basic/word-contains.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-basic/word-contains.sqlpp @@ -34,18 +34,18 @@ create type test.DBLPTypetmp as dblpid : 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:string?) type keyword enforced; -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-open-index/inverted-index-basic/word-fuzzyeq-jaccard.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-basic/word-fuzzyeq-jaccard.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-basic/word-fuzzyeq-jaccard.sqlpp index cc3a797..1170592 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-basic/word-fuzzyeq-jaccard.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-basic/word-fuzzyeq-jaccard.sqlpp @@ -34,18 +34,18 @@ create type test.DBLPTypetmp as dblpid : 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:string?) type keyword enforced; -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-open-index/inverted-index-basic/word-jaccard-check.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-basic/word-jaccard-check.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-basic/word-jaccard-check.sqlpp index 8ff00a2..5bfb33d 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-basic/word-jaccard-check.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-basic/word-jaccard-check.sqlpp @@ -34,18 +34,18 @@ create type test.DBLPTypetmp as dblpid : 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:string?) type keyword enforced; -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-open-index/inverted-index-basic/word-jaccard.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-basic/word-jaccard.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-basic/word-jaccard.sqlpp index 92fc1b8..e95a48d 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-basic/word-jaccard.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-basic/word-jaccard.sqlpp @@ -34,18 +34,18 @@ create type test.DBLPTypetmp as dblpid : 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:string?) type keyword enforced; -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) http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-complex/ngram-edit-distance-check-let-panic-nopanic_01.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-complex/ngram-edit-distance-check-let-panic-nopanic_01.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-complex/ngram-edit-distance-check-let-panic-nopanic_01.sqlpp index 6c34cb4..8771118 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-complex/ngram-edit-distance-check-let-panic-nopanic_01.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-complex/ngram-edit-distance-check-let-panic-nopanic_01.sqlpp @@ -36,18 +36,18 @@ create type test.DBLPTypetmp as dblpid : string, title : 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:string?) type ngram (3) enforced; -write output to asterix_nc1:"rttest/inverted-index-complex_ngram-edit-distance-check-let-panic-nopanic_01.adm" +write output to asterix_nc1:"rttest/inverted-index-complex_ngram-edit-distance-check-let-panic-nopanic_01.adm"; select element o from DBLP as o with eda as test.`edit-distance-check`(o.nested.authors,'Amihay Motro',3), http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-complex/ngram-edit-distance-check-let-panic-nopanic_02.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-complex/ngram-edit-distance-check-let-panic-nopanic_02.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-complex/ngram-edit-distance-check-let-panic-nopanic_02.sqlpp index e076bc7..8bc92fe 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-complex/ngram-edit-distance-check-let-panic-nopanic_02.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-complex/ngram-edit-distance-check-let-panic-nopanic_02.sqlpp @@ -36,18 +36,18 @@ create type test.DBLPTypetmp as dblpid : string, title : 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:string?) type ngram (3) enforced; -write output to asterix_nc1:"rttest/inverted-index-complex_ngram-edit-distance-check-let-panic-nopanic_01.adm" +write output to asterix_nc1:"rttest/inverted-index-complex_ngram-edit-distance-check-let-panic-nopanic_01.adm"; select element o from DBLP as o with edb 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-open-index/inverted-index-complex/ngram-edit-distance-check-let-panic.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-complex/ngram-edit-distance-check-let-panic.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-complex/ngram-edit-distance-check-let-panic.sqlpp index c960385..7ce9153 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-complex/ngram-edit-distance-check-let-panic.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-complex/ngram-edit-distance-check-let-panic.sqlpp @@ -35,18 +35,18 @@ create type test.DBLPTypetmp as dblpid : string, title : 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:string?) type ngram (3) enforced; -write output to asterix_nc1:"rttest/inverted-index-complex_ngram-edit-distance-check-let-panic.adm" +write output to asterix_nc1:"rttest/inverted-index-complex_ngram-edit-distance-check-let-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-open-index/inverted-index-complex/ngram-edit-distance-check-let.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-complex/ngram-edit-distance-check-let.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-complex/ngram-edit-distance-check-let.sqlpp index b774d65..05eca1e 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-complex/ngram-edit-distance-check-let.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-complex/ngram-edit-distance-check-let.sqlpp @@ -35,18 +35,18 @@ create type test.DBLPTypetmp as dblpid : string, title : 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:string?) type ngram (3) enforced; -write output to asterix_nc1:"rttest/inverted-index-complex_ngram-edit-distance-check-let.adm" +write output to asterix_nc1:"rttest/inverted-index-complex_ngram-edit-distance-check-let.adm"; select element o from DBLP as o with ed as test.`edit-distance-check`(o.nested.authors,'Amihay Motro',1)