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-join/word-jaccard_04.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-join/word-jaccard_04.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-join/word-jaccard_04.sqlpp index 22992bc..b95c674 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-join/word-jaccard_04.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/inverted-index-join/word-jaccard_04.sqlpp @@ -34,7 +34,7 @@ create type test.DBLPTypetmp as dblpid : string, authors : string, misc : string -} +}; create type test.CSXTypetmp as { @@ -42,17 +42,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 index keyword_index on DBLP (nested.title:string?) type keyword enforce create index keyword_index on CSX (nested.title:string?) type keyword enforced; -write output to asterix_nc1:"rttest/inverted-index-join_word-jaccard_01.adm" +write output to asterix_nc1:"rttest/inverted-index-join_word-jaccard_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/rtree-index-join/leftouterjoin-probe-pidx-with-join-rtree-sidx_01.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/rtree-index-join/leftouterjoin-probe-pidx-with-join-rtree-sidx_01.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/rtree-index-join/leftouterjoin-probe-pidx-with-join-rtree-sidx_01.sqlpp index 78ae7bf..5a91cdc 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/rtree-index-join/leftouterjoin-probe-pidx-with-join-rtree-sidx_01.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/rtree-index-join/leftouterjoin-probe-pidx-with-join-rtree-sidx_01.sqlpp @@ -37,7 +37,7 @@ create type test.TwitterUserType as `statuses-count` : integer, name : string, `followers-count` : integer -} +}; create type test.TweetMessageNestedType as { @@ -48,12 +48,12 @@ create type test.TweetMessageNestedType as `message-text` : string, countA : integer, countB : integer -} +}; create type test.TweetMessageType as { nested : TweetMessageNestedType -} +}; create dataset TweetMessages(TweetMessageType) primary key nested.tweetid; @@ -65,7 +65,7 @@ create index msgCountBIx on TweetMessages (nested.countB) type btree; create index msgTextIx on TweetMessages (nested.`message-text`) type keyword; -write output to asterix_nc1:"rttest/rtree-index-join_leftouterjoin-probe-pidx-with-join-rtree-sidx_01.adm" +write output to asterix_nc1:"rttest/rtree-index-join_leftouterjoin-probe-pidx-with-join-rtree-sidx_01.adm"; select element {'tweetid1':t1.nested.tweetid,'loc1':t1.nested.`sender-location`,'nearby-message':( select element {'tweetid2':t2.nested.tweetid,'loc2':t2.nested.`sender-location`} from TweetMessages as t2 http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/rtree-index-join/leftouterjoin-probe-pidx-with-join-rtree-sidx_02.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/rtree-index-join/leftouterjoin-probe-pidx-with-join-rtree-sidx_02.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/rtree-index-join/leftouterjoin-probe-pidx-with-join-rtree-sidx_02.sqlpp index 5fd44ec..77d9ad0 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/rtree-index-join/leftouterjoin-probe-pidx-with-join-rtree-sidx_02.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/rtree-index-join/leftouterjoin-probe-pidx-with-join-rtree-sidx_02.sqlpp @@ -37,7 +37,7 @@ create type test.TwitterUserType as `statuses-count` : integer, name : string, `followers-count` : integer -} +}; create type test.TweetMessageNestedType as { @@ -48,12 +48,12 @@ create type test.TweetMessageNestedType as `message-text` : string, countA : integer, countB : integer -} +}; create type test.TweetMessageType as { nested : TweetMessageNestedType -} +}; create dataset TweetMessages(TweetMessageType) primary key nested.tweetid; @@ -65,7 +65,7 @@ create index msgCountBIx on TweetMessages (nested.countB) type btree; create index msgTextIx on TweetMessages (nested.`message-text`) type keyword; -write output to asterix_nc1:"rttest/rtree-index-join_leftouterjoin-probe-pidx-with-join-rtree-sidx_02.adm" +write output to asterix_nc1:"rttest/rtree-index-join_leftouterjoin-probe-pidx-with-join-rtree-sidx_02.adm"; select element {'tweetid1':t1.nested.tweetid,'loc1':t1.nested.`sender-location`,'nearby-message':( select element {'tweetid2':t2.nested.tweetid,'loc2':t2.nested.`sender-location`} from TweetMessages as t2 http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/rtree-index-join/spatial-intersect-point_01.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/rtree-index-join/spatial-intersect-point_01.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/rtree-index-join/spatial-intersect-point_01.sqlpp index b38a6e3..75f9de3 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/rtree-index-join/spatial-intersect-point_01.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/rtree-index-join/spatial-intersect-point_01.sqlpp @@ -39,12 +39,12 @@ create type test.MyRecord as poly1 : polygon, poly2 : polygon, rec : rectangle -} +}; create type test.MyRecordNested as closed { nested : MyRecord -} +}; create dataset MyData1(MyRecordNested) primary key nested.id; @@ -52,7 +52,7 @@ create dataset MyData2(MyRecord) primary key id; create index rtree_index on MyData1 (nested.point) type rtree; -write output to asterix_nc1:"rttest/index-join_rtree-spatial-intersect-point.adm" +write output to asterix_nc1:"rttest/index-join_rtree-spatial-intersect-point.adm"; select element {'a':a,'b':b} from MyData1 as a, MyData2 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/rtree-index-join/spatial-intersect-point_02.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/rtree-index-join/spatial-intersect-point_02.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/rtree-index-join/spatial-intersect-point_02.sqlpp index 67cfc52..9d09f48 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/rtree-index-join/spatial-intersect-point_02.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/rtree-index-join/spatial-intersect-point_02.sqlpp @@ -39,12 +39,12 @@ create type test.MyRecord as poly1 : polygon, poly2 : polygon, rec : rectangle -} +}; create type test.MyRecordNested as closed { nested : MyRecord -} +}; create dataset MyData1(MyRecordNested) primary key nested.id; @@ -52,7 +52,7 @@ create dataset MyData2(MyRecord) primary key id; create index rtree_index on MyData2 (point) type rtree; -write output to asterix_nc1:"rttest/rtree-index-join_spatial-intersect-point_02.adm" +write output to asterix_nc1:"rttest/rtree-index-join_spatial-intersect-point_02.adm"; select element {'a':a,'b':b} from MyData1 as a, MyData2 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/rtree-index-join/spatial-intersect-point_03.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/rtree-index-join/spatial-intersect-point_03.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/rtree-index-join/spatial-intersect-point_03.sqlpp index 2fc5cc5..fa3ff7b 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/rtree-index-join/spatial-intersect-point_03.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/rtree-index-join/spatial-intersect-point_03.sqlpp @@ -39,18 +39,18 @@ create type test.MyRecord as poly1 : polygon, poly2 : polygon, rec : rectangle -} +}; create type test.MyRecordNested as closed { nested : MyRecord -} +}; create dataset MyData(MyRecordNested) primary key nested.id; create index rtree_index on MyData (nested.point) type rtree; -write output to asterix_nc1:"rttest/rtree-index-join_spatial-intersect-point_03.adm" +write output to asterix_nc1:"rttest/rtree-index-join_spatial-intersect-point_03.adm"; select element {'a':a,'b':b} from MyData as a, MyData 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/rtree-index-join/spatial-intersect-point_04.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/rtree-index-join/spatial-intersect-point_04.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/rtree-index-join/spatial-intersect-point_04.sqlpp index bf11ae2..3993450 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/rtree-index-join/spatial-intersect-point_04.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/rtree-index-join/spatial-intersect-point_04.sqlpp @@ -38,12 +38,12 @@ create type test.MyRecordNestedOpen as poly1 : polygon, poly2 : polygon, rec : rectangle -} +}; create type test.MyRecordOpen as closed { nested : MyRecordNestedOpen -} +}; create dataset MyData1(MyRecordOpen) primary key nested.id; @@ -53,7 +53,7 @@ create index rtree_index on MyData1 (nested.point:point?) type rtree enforced; create index rtree_index2 on MyData2 (nested.point:point?) type rtree enforced; -write output to asterix_nc1:"rttest/rtree-index-join_spatial-intersect-point_02.adm" +write output to asterix_nc1:"rttest/rtree-index-join_spatial-intersect-point_02.adm"; select element {'a':a,'b':b} from MyData1 as a, MyData2 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/rtree-index-join/spatial-intersect-point_05.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/rtree-index-join/spatial-intersect-point_05.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/rtree-index-join/spatial-intersect-point_05.sqlpp index 6b7e58c..dc9059f 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/rtree-index-join/spatial-intersect-point_05.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested-open-index/rtree-index-join/spatial-intersect-point_05.sqlpp @@ -38,12 +38,12 @@ create type test.MyRecordNestedOpen as poly1 : polygon, poly2 : polygon, rec : rectangle -} +}; create type test.MyRecordOpen as closed { nested : MyRecordNestedOpen -} +}; create dataset MyData1(MyRecordOpen) primary key nested.id; @@ -51,7 +51,7 @@ create dataset MyData2(MyRecordOpen) primary key nested.id; create index rtree_index on MyData1 (nested.point:point?) type rtree enforced; -write output to asterix_nc1:"rttest/rtree-index-join_spatial-intersect-point_02.adm" +write output to asterix_nc1:"rttest/rtree-index-join_spatial-intersect-point_02.adm"; select element {'a':a,'b':b} from MyData1 as a, MyData2 as b http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested_loj2.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested_loj2.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested_loj2.sqlpp index eb113d7..aae756c 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested_loj2.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested_loj2.sqlpp @@ -41,7 +41,7 @@ create type tpch.LineItemType as l_shipinstruct : string, l_shipmode : string, l_comment : string -} +}; create type tpch.OrderType as closed { @@ -54,7 +54,7 @@ create type tpch.OrderType as o_clerk : string, o_shippriority : integer, o_comment : string -} +}; create type tpch.CustomerType as closed { @@ -66,7 +66,7 @@ create type tpch.CustomerType as c_acctbal : double, c_mktsegment : string, c_comment : string -} +}; create nodegroup group1 if not exists on asterix_nc1, @@ -78,7 +78,7 @@ create dataset Orders(OrderType) primary key o_orderkey on group1; create dataset Customers(CustomerType) primary key c_custkey on group1; -write output to asterix_nc1:"/tmp/nested_loj.adm" +write output to asterix_nc1:"/tmp/nested_loj.adm"; select element {'cust':c,'orders':orders} from Customers as c with orders as ( http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested_loj3.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested_loj3.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested_loj3.sqlpp index b8cd6d1..b54dee6 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested_loj3.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/nested_loj3.sqlpp @@ -41,7 +41,7 @@ create type tpch.LineItemType as l_shipinstruct : string, l_shipmode : string, l_comment : string -} +}; create type tpch.OrderType as closed { @@ -54,7 +54,7 @@ create type tpch.OrderType as o_clerk : string, o_shippriority : integer, o_comment : string -} +}; create type tpch.CustomerType as closed { @@ -66,7 +66,7 @@ create type tpch.CustomerType as c_acctbal : double, c_mktsegment : string, c_comment : string -} +}; create type tpch.PartSuppType as closed { @@ -75,7 +75,7 @@ create type tpch.PartSuppType as ps_availqty : integer, ps_supplycost : double, ps_comment : string -} +}; create nodegroup group1 if not exists on asterix_nc1, @@ -89,7 +89,7 @@ create dataset Customers(CustomerType) primary key c_custkey on group1; create dataset PartSupp(PartSuppType) primary key ps_partkey,ps_suppkey on group1; -write output to asterix_nc1:"/tmp/nested_loj.adm" +write output to asterix_nc1:"/tmp/nested_loj.adm"; select element {'cust':c,'orders':orders} from Customers as c with orders as ( http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index-join/disjunction-to-join.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index-join/disjunction-to-join.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index-join/disjunction-to-join.sqlpp index 895e94a..6ec8923 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index-join/disjunction-to-join.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index-join/disjunction-to-join.sqlpp @@ -32,7 +32,7 @@ create type test.TestType as { id : string, `no-idx` : string -} +}; create dataset TestSet(TestType) primary key id; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index-join/leftouterjoin-probe-pidx-with-join-btree-sidx_01_1.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index-join/leftouterjoin-probe-pidx-with-join-btree-sidx_01_1.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index-join/leftouterjoin-probe-pidx-with-join-btree-sidx_01_1.sqlpp index 2995866..bf9850a 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index-join/leftouterjoin-probe-pidx-with-join-btree-sidx_01_1.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index-join/leftouterjoin-probe-pidx-with-join-btree-sidx_01_1.sqlpp @@ -37,7 +37,7 @@ create type test.TwitterUserType as `statuses-count` : integer, name : string, `followers-count` : integer -} +}; create type test.TweetMessageType as { @@ -48,13 +48,13 @@ create type test.TweetMessageType as `referred-topics` : {{string}}, `message-text` : string, countA : integer -} +}; create dataset TweetMessages(TweetMessageType) primary key tweetid; create index msgCountBIx on TweetMessages (countB:integer?) type btree enforced; -write output to asterix_nc1:"rttest/btree-index-join_leftouterjoin-probe-pidx-with-join-btree-sidx_01.adm" +write output to asterix_nc1:"rttest/btree-index-join_leftouterjoin-probe-pidx-with-join-btree-sidx_01.adm"; select element {'tweetid1':t1.tweetid,'count1':t1.countA,'t2info':( select element {'tweetid2':t2.tweetid,'count2':t2.countB} from TweetMessages as t2 http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index-join/leftouterjoin-probe-pidx-with-join-btree-sidx_01_2.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index-join/leftouterjoin-probe-pidx-with-join-btree-sidx_01_2.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index-join/leftouterjoin-probe-pidx-with-join-btree-sidx_01_2.sqlpp index bbffccc..0a94d56 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index-join/leftouterjoin-probe-pidx-with-join-btree-sidx_01_2.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index-join/leftouterjoin-probe-pidx-with-join-btree-sidx_01_2.sqlpp @@ -37,7 +37,7 @@ create type test.TwitterUserType as `statuses-count` : integer, name : string, `followers-count` : integer -} +}; create type test.TweetMessageType as { @@ -47,7 +47,7 @@ create type test.TweetMessageType as `send-time` : datetime, `referred-topics` : {{string}}, `message-text` : string -} +}; create dataset TweetMessages(TweetMessageType) primary key tweetid; @@ -55,7 +55,7 @@ create index msgCountAIx on TweetMessages (countA:integer?) type btree enforce create index msgCountBIx on TweetMessages (countB:integer?) type btree enforced; -write output to asterix_nc1:"rttest/btree-index-join_leftouterjoin-probe-pidx-with-join-btree-sidx_01.adm" +write output to asterix_nc1:"rttest/btree-index-join_leftouterjoin-probe-pidx-with-join-btree-sidx_01.adm"; select element {'tweetid1':t1.tweetid,'count1':t1.countA,'t2info':( select element {'tweetid2':t2.tweetid,'count2':t2.countB} from TweetMessages as t2 http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index-join/leftouterjoin-probe-pidx-with-join-btree-sidx_02_1.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index-join/leftouterjoin-probe-pidx-with-join-btree-sidx_02_1.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index-join/leftouterjoin-probe-pidx-with-join-btree-sidx_02_1.sqlpp index 28959b4..bc517cf 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index-join/leftouterjoin-probe-pidx-with-join-btree-sidx_02_1.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index-join/leftouterjoin-probe-pidx-with-join-btree-sidx_02_1.sqlpp @@ -37,7 +37,7 @@ create type test.TwitterUserType as `statuses-count` : integer, name : string, `followers-count` : integer -} +}; create type test.TweetMessageType as { @@ -48,13 +48,13 @@ create type test.TweetMessageType as `referred-topics` : {{string}}, `message-text` : string, countA : integer -} +}; create dataset TweetMessages(TweetMessageType) primary key tweetid; create index msgCountBIx on TweetMessages (countB:integer?) type btree enforced; -write output to asterix_nc1:"rttest/btree-index-join_leftouterjoin-probe-pidx-with-join-btree-sidx_02.adm" +write output to asterix_nc1:"rttest/btree-index-join_leftouterjoin-probe-pidx-with-join-btree-sidx_02.adm"; select element {'tweetid1':t1.tweetid,'count1':t1.countA,'t2info':( select element {'tweetid2':t2.tweetid,'count2':t2.countB} from TweetMessages as t2 http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index-join/leftouterjoin-probe-pidx-with-join-btree-sidx_02_2.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index-join/leftouterjoin-probe-pidx-with-join-btree-sidx_02_2.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index-join/leftouterjoin-probe-pidx-with-join-btree-sidx_02_2.sqlpp index ce88e60..0504b30 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index-join/leftouterjoin-probe-pidx-with-join-btree-sidx_02_2.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index-join/leftouterjoin-probe-pidx-with-join-btree-sidx_02_2.sqlpp @@ -37,7 +37,7 @@ create type test.TwitterUserType as `statuses-count` : integer, name : string, `followers-count` : integer -} +}; create type test.TweetMessageType as { @@ -47,7 +47,7 @@ create type test.TweetMessageType as `send-time` : datetime, `referred-topics` : {{string}}, `message-text` : string -} +}; create dataset TweetMessages(TweetMessageType) primary key tweetid; @@ -55,7 +55,7 @@ create index msgCountAIx on TweetMessages (countA:integer?) type btree enforce create index msgCountBIx on TweetMessages (countB:integer?) type btree enforced; -write output to asterix_nc1:"rttest/btree-index-join_leftouterjoin-probe-pidx-with-join-btree-sidx_02.adm" +write output to asterix_nc1:"rttest/btree-index-join_leftouterjoin-probe-pidx-with-join-btree-sidx_02.adm"; select element {'tweetid1':t1.tweetid,'count1':t1.countA,'t2info':( select element {'tweetid2':t2.tweetid,'count2':t2.countB} from TweetMessages as t2 http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index-join/secondary-composite-key-join_01.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index-join/secondary-composite-key-join_01.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index-join/secondary-composite-key-join_01.sqlpp index 683fac0..1c2b803 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index-join/secondary-composite-key-join_01.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index-join/secondary-composite-key-join_01.sqlpp @@ -32,13 +32,13 @@ use test; create type test.Name as { id : integer -} +}; create dataset Names(Name) primary key id; create index Name_idx on Names (fname:string?,lname:string?) type btree enforced; -write output to asterix_nc1:"rttest/btree-index-join_secondary-composite-key-prefix-join_01.adm" +write output to asterix_nc1:"rttest/btree-index-join_secondary-composite-key-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/open-index-enforced/btree-index-join/secondary-composite-key-join_02.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index-join/secondary-composite-key-join_02.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index-join/secondary-composite-key-join_02.sqlpp index c71faf9..7008899 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index-join/secondary-composite-key-join_02.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index-join/secondary-composite-key-join_02.sqlpp @@ -32,13 +32,13 @@ use test; create type test.Name as { id : integer -} +}; create dataset Names(Name) primary key id; create index Name_idx on Names (fname:string?,lname: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/open-index-enforced/btree-index-join/secondary-composite-key-join_03.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index-join/secondary-composite-key-join_03.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index-join/secondary-composite-key-join_03.sqlpp index e60b352..cfb31f7 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index-join/secondary-composite-key-join_03.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index-join/secondary-composite-key-join_03.sqlpp @@ -32,13 +32,13 @@ use test; create type test.Name as { id : integer -} +}; create dataset Names(Name) primary key id; create index Name_idx on Names (fname:string?,lname: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/open-index-enforced/btree-index-join/secondary-composite-key-prefix-join_01.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index-join/secondary-composite-key-prefix-join_01.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index-join/secondary-composite-key-prefix-join_01.sqlpp index ec084f4..f0e8ff2 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index-join/secondary-composite-key-prefix-join_01.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index-join/secondary-composite-key-prefix-join_01.sqlpp @@ -32,13 +32,13 @@ use test; create type test.Name as { id : integer -} +}; create dataset Names(Name) primary key id; create index Name_idx on Names (fname:string?,lname: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/open-index-enforced/btree-index-join/secondary-composite-key-prefix-join_02.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index-join/secondary-composite-key-prefix-join_02.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index-join/secondary-composite-key-prefix-join_02.sqlpp index 88c833f..400b7d1 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index-join/secondary-composite-key-prefix-join_02.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index-join/secondary-composite-key-prefix-join_02.sqlpp @@ -32,13 +32,13 @@ use test; create type test.Name as { id : integer -} +}; create dataset Names(Name) primary key id; create index Name_idx on Names (fname:string?,lname: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/open-index-enforced/btree-index-join/secondary-composite-key-prefix-join_03.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index-join/secondary-composite-key-prefix-join_03.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index-join/secondary-composite-key-prefix-join_03.sqlpp index ac41385..39adc5c 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index-join/secondary-composite-key-prefix-join_03.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index-join/secondary-composite-key-prefix-join_03.sqlpp @@ -32,13 +32,13 @@ use test; create type test.Name as { id : integer -} +}; create dataset Names(Name) primary key id; create index Name_idx on Names (fname:string?,lname: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/open-index-enforced/btree-index-join/secondary-composite-key-prefix-join_04.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index-join/secondary-composite-key-prefix-join_04.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index-join/secondary-composite-key-prefix-join_04.sqlpp index 1aed2f9..b403c1a 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index-join/secondary-composite-key-prefix-join_04.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index-join/secondary-composite-key-prefix-join_04.sqlpp @@ -32,13 +32,13 @@ use test; create type test.Name as { id : integer -} +}; create dataset Names(Name) primary key id; create index Name_idx on Names (fname:string?,lname: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/open-index-enforced/btree-index-join/secondary-composite-key-prefix-join_05.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index-join/secondary-composite-key-prefix-join_05.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index-join/secondary-composite-key-prefix-join_05.sqlpp index 4bc05bd..22e6c4a 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index-join/secondary-composite-key-prefix-join_05.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index-join/secondary-composite-key-prefix-join_05.sqlpp @@ -32,13 +32,13 @@ use test; create type test.Name as { id : integer -} +}; create dataset Names(Name) primary key id; create index Name_idx on Names (fname:string?,lname: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/open-index-enforced/btree-index-join/secondary-composite-key-prefix-join_06.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index-join/secondary-composite-key-prefix-join_06.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index-join/secondary-composite-key-prefix-join_06.sqlpp index 2e101c5..244f583 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index-join/secondary-composite-key-prefix-join_06.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index-join/secondary-composite-key-prefix-join_06.sqlpp @@ -32,13 +32,13 @@ use test; create type test.Name as { id : integer -} +}; create dataset Names(Name) primary key id; create index Name_idx on Names (fname:string?,lname: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/open-index-enforced/btree-index-join/secondary-equi-join-multiindex.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index-join/secondary-equi-join-multiindex.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index-join/secondary-equi-join-multiindex.sqlpp index e2c6242..88b0584 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index-join/secondary-equi-join-multiindex.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/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.FacebookUserType as closed { @@ -48,7 +48,7 @@ create type test.FacebookUserType as `user-since-copy` : datetime, `friend-ids` : {{integer}}, employment : [EmploymentType] -} +}; create type test.FacebookMessageType as { @@ -58,7 +58,7 @@ create type test.FacebookMessageType as `in-response-to` : integer?, `sender-location` : point?, message : string -} +}; create dataset FacebookUsers(FacebookUserType) primary key id; @@ -66,7 +66,7 @@ create dataset FacebookMessages(FacebookMessageType) primary key `message-id`; create index fbmIdxAutId if not exists on FacebookMessages (`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.id,'fbm-auth-ID':message.`author-id`,'uname':user.name,'message':message.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/open-index-enforced/btree-index-join/secondary-equi-join-multipred.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index-join/secondary-equi-join-multipred.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index-join/secondary-equi-join-multipred.sqlpp index bef57e1..816815a 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index-join/secondary-equi-join-multipred.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index-join/secondary-equi-join-multipred.sqlpp @@ -37,7 +37,7 @@ create type test.DBLPType as dblpid : string, authors : string, misc : string -} +}; create type test.CSXType as closed { @@ -46,7 +46,7 @@ create type test.CSXType as title : string, authors : string, misc : string -} +}; create dataset DBLP(DBLPType) primary key id; @@ -54,7 +54,7 @@ create dataset CSX(CSXType) primary key id; create index title_index on DBLP (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/open-index-enforced/btree-index-join/secondary-equi-join_01.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index-join/secondary-equi-join_01.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index-join/secondary-equi-join_01.sqlpp index a5d3d7b..01bf0ab 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index-join/secondary-equi-join_01.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index-join/secondary-equi-join_01.sqlpp @@ -35,7 +35,7 @@ create type test.DBLPType as dblpid : string, authors : string, misc : string -} +}; create type test.CSXType as closed { @@ -44,7 +44,7 @@ create type test.CSXType as title : string, authors : string, misc : string -} +}; create dataset DBLP(DBLPType) primary key id; @@ -52,7 +52,7 @@ create dataset CSX(CSXType) primary key id; create index title_index on DBLP (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/open-index-enforced/btree-index-join/secondary-equi-join_02.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index-join/secondary-equi-join_02.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index-join/secondary-equi-join_02.sqlpp index 04e1a25..750d100 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index-join/secondary-equi-join_02.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index-join/secondary-equi-join_02.sqlpp @@ -36,7 +36,7 @@ create type test.DBLPType as title : string, authors : string, misc : string -} +}; create type test.CSXType as { @@ -44,7 +44,7 @@ create type test.CSXType as csxid : string, authors : string, misc : string -} +}; create dataset DBLP(DBLPType) primary key id; @@ -52,7 +52,7 @@ create dataset CSX(CSXType) primary key id; create index title_index on CSX (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/open-index-enforced/btree-index-join/secondary-equi-join_03.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index-join/secondary-equi-join_03.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index-join/secondary-equi-join_03.sqlpp index a623356..3d33222 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index-join/secondary-equi-join_03.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index-join/secondary-equi-join_03.sqlpp @@ -35,13 +35,13 @@ create type test.DBLPType as dblpid : string, authors : string, misc : string -} +}; create dataset DBLP(DBLPType) primary key id; create index title_index on DBLP (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, DBLP as b http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index-join/secondary-equi-join_04.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index-join/secondary-equi-join_04.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index-join/secondary-equi-join_04.sqlpp index b0eaef0..d987e47 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index-join/secondary-equi-join_04.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index-join/secondary-equi-join_04.sqlpp @@ -35,7 +35,7 @@ create type test.DBLPType as dblpid : string, authors : string, misc : string -} +}; create type test.CSXType as { @@ -43,7 +43,7 @@ create type test.CSXType as csxid : string, authors : string, misc : string -} +}; create dataset DBLP(DBLPType) primary key id; @@ -53,7 +53,7 @@ create index title_index_DBLP on DBLP (title:string?) type btree enforced; create index title_index on CSX (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/open-index-enforced/btree-index-join/secondary-equi-join_05.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index-join/secondary-equi-join_05.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index-join/secondary-equi-join_05.sqlpp index 050d58f..c322c44 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index-join/secondary-equi-join_05.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index-join/secondary-equi-join_05.sqlpp @@ -36,7 +36,7 @@ create type test.DBLPType as dblpid : string, authors : string, misc : string -} +}; create type test.CSXType as { @@ -44,7 +44,7 @@ create type test.CSXType as csxid : string, authors : string, misc : string -} +}; create dataset DBLP(DBLPType) primary key id; @@ -52,7 +52,7 @@ create dataset CSX(CSXType) primary key id; create index title_index on DBLP (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/open-index-enforced/btree-index/btree-secondary-33.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index/btree-secondary-33.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index/btree-secondary-33.sqlpp index 4156eb7..e4f0814 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index/btree-secondary-33.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index/btree-secondary-33.sqlpp @@ -30,11 +30,11 @@ 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.TestType as { id : integer -} +}; create dataset testdst(TestType) primary key id; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index/btree-secondary-34.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index/btree-secondary-34.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index/btree-secondary-34.sqlpp index c622c5e..bcea4a7 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index/btree-secondary-34.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index/btree-secondary-34.sqlpp @@ -30,11 +30,11 @@ 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.TestType as { id : integer -} +}; create dataset testdst(TestType) primary key id; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index/btree-secondary-35.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index/btree-secondary-35.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index/btree-secondary-35.sqlpp index 0cd0de2..3d4f2d6 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index/btree-secondary-35.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index/btree-secondary-35.sqlpp @@ -30,11 +30,11 @@ 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.TestType as { id : integer -} +}; create dataset testdst(TestType) primary key id; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index/btree-secondary-36.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index/btree-secondary-36.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index/btree-secondary-36.sqlpp index 0cd320e..bebae85 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index/btree-secondary-36.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index/btree-secondary-36.sqlpp @@ -30,11 +30,11 @@ 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.TestType as { id : integer -} +}; create dataset testdst(TestType) primary key id; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index/btree-secondary-37.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index/btree-secondary-37.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index/btree-secondary-37.sqlpp index 559620b..c67e089 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index/btree-secondary-37.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index/btree-secondary-37.sqlpp @@ -30,11 +30,11 @@ 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.TestType as { id : integer -} +}; create dataset testdst(TestType) primary key id; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index/btree-secondary-38.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index/btree-secondary-38.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index/btree-secondary-38.sqlpp index a9f60cf..39fb3ae 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index/btree-secondary-38.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index/btree-secondary-38.sqlpp @@ -30,11 +30,11 @@ 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.TestType as { id : integer -} +}; create dataset testdst(TestType) primary key id; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index/btree-secondary-39.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index/btree-secondary-39.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index/btree-secondary-39.sqlpp index 6a1bea8..357c6a3 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index/btree-secondary-39.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index/btree-secondary-39.sqlpp @@ -29,11 +29,11 @@ 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.TestType as { id : integer -} +}; create dataset testdst(TestType) primary key id; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index/btree-secondary-40.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index/btree-secondary-40.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index/btree-secondary-40.sqlpp index d731726..bdead51 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index/btree-secondary-40.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index/btree-secondary-40.sqlpp @@ -29,11 +29,11 @@ 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.TestType as { id : integer -} +}; create dataset testdst(TestType) primary key id; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index/btree-secondary-41.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index/btree-secondary-41.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index/btree-secondary-41.sqlpp index dda5d82..6cb1afe 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index/btree-secondary-41.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index/btree-secondary-41.sqlpp @@ -30,11 +30,11 @@ 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.TestType as { id : integer -} +}; create dataset testdst(TestType) primary key id; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index/btree-secondary-42.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index/btree-secondary-42.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index/btree-secondary-42.sqlpp index adf0bf3..1fd309d 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index/btree-secondary-42.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index/btree-secondary-42.sqlpp @@ -30,11 +30,11 @@ 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.TestType as { id : integer -} +}; create dataset testdst(TestType) primary key id; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index/btree-secondary-43.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index/btree-secondary-43.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index/btree-secondary-43.sqlpp index 332b5cc..6c33486 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index/btree-secondary-43.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index/btree-secondary-43.sqlpp @@ -30,11 +30,11 @@ 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.TestType as { id : integer -} +}; create dataset testdst(TestType) primary key id; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index/btree-secondary-44.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index/btree-secondary-44.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index/btree-secondary-44.sqlpp index cd4b818..f4e67d2 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index/btree-secondary-44.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index/btree-secondary-44.sqlpp @@ -30,11 +30,11 @@ 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.TestType as { id : integer -} +}; create dataset testdst(TestType) primary key id; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index/btree-secondary-45.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index/btree-secondary-45.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index/btree-secondary-45.sqlpp index 8ab91cd..225dceb 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index/btree-secondary-45.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index/btree-secondary-45.sqlpp @@ -30,11 +30,11 @@ 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.TestType as { id : integer -} +}; create dataset testdst(TestType) primary key id; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index/btree-secondary-46.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index/btree-secondary-46.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index/btree-secondary-46.sqlpp index 034d030..61c58de 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index/btree-secondary-46.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index/btree-secondary-46.sqlpp @@ -30,11 +30,11 @@ 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.TestType as { id : integer -} +}; create dataset testdst(TestType) primary key id; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index/btree-secondary-47.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index/btree-secondary-47.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index/btree-secondary-47.sqlpp index c54cefa..623e287 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index/btree-secondary-47.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index/btree-secondary-47.sqlpp @@ -30,11 +30,11 @@ 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.TestType as { id : integer -} +}; create dataset testdst(TestType) primary key id; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index/btree-secondary-48.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index/btree-secondary-48.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index/btree-secondary-48.sqlpp index 82390bf..df9db9c 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index/btree-secondary-48.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index/btree-secondary-48.sqlpp @@ -30,11 +30,11 @@ 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.TestType as { id : integer -} +}; create dataset testdst(TestType) primary key id; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index/btree-secondary-49.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index/btree-secondary-49.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index/btree-secondary-49.sqlpp index c2670e9..3726ebb 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index/btree-secondary-49.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index/btree-secondary-49.sqlpp @@ -30,11 +30,11 @@ 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.TestType as { id : integer -} +}; create dataset testdst(TestType) primary key id; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index/btree-secondary-50.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index/btree-secondary-50.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index/btree-secondary-50.sqlpp index 2596807..21a1e7c 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index/btree-secondary-50.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index/btree-secondary-50.sqlpp @@ -30,11 +30,11 @@ 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.TestType as { id : integer -} +}; create dataset testdst(TestType) primary key id; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index/btree-secondary-51.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index/btree-secondary-51.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index/btree-secondary-51.sqlpp index 638c7f4..ae5ca02 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index/btree-secondary-51.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index/btree-secondary-51.sqlpp @@ -30,11 +30,11 @@ 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.TestType as { id : integer -} +}; create dataset testdst(TestType) primary key id; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index/btree-secondary-52.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index/btree-secondary-52.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index/btree-secondary-52.sqlpp index f0b0787..27c6807 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index/btree-secondary-52.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index/btree-secondary-52.sqlpp @@ -30,11 +30,11 @@ 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.TestType as { id : integer -} +}; create dataset testdst(TestType) primary key id; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index/btree-secondary-53.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index/btree-secondary-53.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index/btree-secondary-53.sqlpp index bbe11ba..8e9aea5 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index/btree-secondary-53.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index/btree-secondary-53.sqlpp @@ -30,11 +30,11 @@ 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.TestType as { id : integer -} +}; create dataset testdst(TestType) primary key id; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index/btree-secondary-54.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index/btree-secondary-54.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index/btree-secondary-54.sqlpp index 9422940..64be60b 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index/btree-secondary-54.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index/btree-secondary-54.sqlpp @@ -29,11 +29,11 @@ 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.TestType as { id : integer -} +}; create dataset testdst(TestType) primary key id; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index/btree-secondary-55.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index/btree-secondary-55.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index/btree-secondary-55.sqlpp index 3cde8cb..6d0f320 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index/btree-secondary-55.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index/btree-secondary-55.sqlpp @@ -29,11 +29,11 @@ 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.TestType as { id : integer -} +}; create dataset testdst(TestType) primary key id; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index/btree-secondary-56.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index/btree-secondary-56.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index/btree-secondary-56.sqlpp index c145b7b..5ac912b 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index/btree-secondary-56.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index/btree-secondary-56.sqlpp @@ -29,11 +29,11 @@ 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.TestType as { id : integer -} +}; create dataset testdst(TestType) primary key id; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index/btree-secondary-57.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index/btree-secondary-57.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index/btree-secondary-57.sqlpp index 486c75b..2de2f34 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index/btree-secondary-57.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index/btree-secondary-57.sqlpp @@ -29,11 +29,11 @@ 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.TestType as { id : integer -} +}; create dataset testdst(TestType) primary key id; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index/btree-secondary-58.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index/btree-secondary-58.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index/btree-secondary-58.sqlpp index 8c33044..de54406 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index/btree-secondary-58.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index/btree-secondary-58.sqlpp @@ -29,11 +29,11 @@ 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.TestType as { id : integer -} +}; create dataset testdst(TestType) primary key id; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index/btree-secondary-59.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index/btree-secondary-59.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index/btree-secondary-59.sqlpp index 68382ef..4db7f17 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index/btree-secondary-59.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index/btree-secondary-59.sqlpp @@ -29,11 +29,11 @@ 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.TestType as { id : integer -} +}; create dataset testdst(TestType) primary key id; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index/btree-secondary-60.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index/btree-secondary-60.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index/btree-secondary-60.sqlpp index eff417e..a0d20aa 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index/btree-secondary-60.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index/btree-secondary-60.sqlpp @@ -29,11 +29,11 @@ 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.TestType as { id : integer -} +}; create dataset testdst(TestType) primary key id; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index/btree-secondary-61.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index/btree-secondary-61.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index/btree-secondary-61.sqlpp index 3561ecb..ea7e791 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index/btree-secondary-61.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index/btree-secondary-61.sqlpp @@ -30,11 +30,11 @@ 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.TestType as { id : integer -} +}; create dataset testdst(TestType) primary key id; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index/btree-secondary-62.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index/btree-secondary-62.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index/btree-secondary-62.sqlpp index 933954b..7897e16 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index/btree-secondary-62.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index/btree-secondary-62.sqlpp @@ -30,11 +30,11 @@ 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.TestType as { id : integer -} +}; create dataset testdst(TestType) primary key id; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index/btree-secondary-63.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index/btree-secondary-63.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index/btree-secondary-63.sqlpp index 75fb66e..ae70c61 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index/btree-secondary-63.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/btree-index/btree-secondary-63.sqlpp @@ -30,11 +30,11 @@ 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.TestType as { id : integer -} +}; create dataset testdst(TestType) primary key id; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-basic/ngram-contains-panic.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-basic/ngram-contains-panic.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-basic/ngram-contains-panic.sqlpp index 87bef97..235d076 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-basic/ngram-contains-panic.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-basic/ngram-contains-panic.sqlpp @@ -34,13 +34,13 @@ create type test.DBLPType as dblpid : string, authors : string, misc : string -} +}; create dataset DBLP(DBLPType) primary key id; create index ngram_index on DBLP (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.title,'Mu') http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-basic/ngram-contains.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-basic/ngram-contains.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-basic/ngram-contains.sqlpp index 985336f..d91f0a2 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-basic/ngram-contains.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-basic/ngram-contains.sqlpp @@ -34,13 +34,13 @@ create type test.DBLPType as dblpid : string, authors : string, misc : string -} +}; create dataset DBLP(DBLPType) primary key id; create index ngram_index on DBLP (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.title,'Multimedia') http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-basic/ngram-edit-distance-check-panic.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-basic/ngram-edit-distance-check-panic.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-basic/ngram-edit-distance-check-panic.sqlpp index 7501006..d4516ed 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-basic/ngram-edit-distance-check-panic.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/open-index-enforced/inverted-index-basic/ngram-edit-distance-check-panic.sqlpp @@ -34,13 +34,13 @@ create type test.DBLPType as dblpid : string, title : string, misc : string -} +}; create dataset DBLP(DBLPType) primary key id; create index ngram_index on DBLP (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.authors,'Amihay Motro',5)
