http://git-wip-us.apache.org/repos/asf/asterixdb/blob/d6cf641a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-open-index/index-leftouterjoin/probe-pidx-with-join-btree-sidx1/probe-pidx-with-join-btree-sidx1.3.query.aql ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-open-index/index-leftouterjoin/probe-pidx-with-join-btree-sidx1/probe-pidx-with-join-btree-sidx1.3.query.aql b/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-open-index/index-leftouterjoin/probe-pidx-with-join-btree-sidx1/probe-pidx-with-join-btree-sidx1.3.query.aql index b73bd5d..72f4397 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-open-index/index-leftouterjoin/probe-pidx-with-join-btree-sidx1/probe-pidx-with-join-btree-sidx1.3.query.aql +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-open-index/index-leftouterjoin/probe-pidx-with-join-btree-sidx1/probe-pidx-with-join-btree-sidx1.3.query.aql @@ -32,8 +32,8 @@ return { "tweetid1": $t1.nested.tweetid, "count1":$t1.nested.countA, "t2info": for $t2 in dataset('TweetMessages') - where $t1.nested.countA /* +indexnl */= $t2.nested.countB - order by $t2.nested.tweetid - return {"tweetid2": $t2.nested.tweetid, - "count2":$t2.nested.countB} + where $t1.nested.countA /* +indexnl */= $t2.nested.countB + order by $t2.nested.tweetid + return {"tweetid2": $t2.nested.tweetid, + "count2":$t2.nested.countB} };
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/d6cf641a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-open-index/index-leftouterjoin/probe-pidx-with-join-btree-sidx2/probe-pidx-with-join-btree-sidx2.1.ddl.aql ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-open-index/index-leftouterjoin/probe-pidx-with-join-btree-sidx2/probe-pidx-with-join-btree-sidx2.1.ddl.aql b/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-open-index/index-leftouterjoin/probe-pidx-with-join-btree-sidx2/probe-pidx-with-join-btree-sidx2.1.ddl.aql index 0d3e91c..9b0f229 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-open-index/index-leftouterjoin/probe-pidx-with-join-btree-sidx2/probe-pidx-with-join-btree-sidx2.1.ddl.aql +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-open-index/index-leftouterjoin/probe-pidx-with-join-btree-sidx2/probe-pidx-with-join-btree-sidx2.1.ddl.aql @@ -28,26 +28,26 @@ create dataverse test; use dataverse test; create type TwitterUserType as closed { - screen-name: string, - lang: string, - friends-count: int64, - statuses-count: int64, - name: string, - followers-count: int64 + screen-name: string, + lang: string, + friends-count: int64, + statuses-count: int64, + name: string, + followers-count: int64 } create type TweetMessageNestedType as open { - tweetid: int64, + tweetid: int64, user: TwitterUserType, sender-location: point, - send-time: datetime, + send-time: datetime, referred-topics: {{ string }}, - message-text: string, - countA: int64 + message-text: string, + countA: int64 } create type TweetMessageType as closed { - nested: TweetMessageNestedType + nested: TweetMessageNestedType } create dataset TweetMessages(TweetMessageType) http://git-wip-us.apache.org/repos/asf/asterixdb/blob/d6cf641a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-open-index/index-leftouterjoin/probe-pidx-with-join-btree-sidx2/probe-pidx-with-join-btree-sidx2.2.update.aql ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-open-index/index-leftouterjoin/probe-pidx-with-join-btree-sidx2/probe-pidx-with-join-btree-sidx2.2.update.aql b/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-open-index/index-leftouterjoin/probe-pidx-with-join-btree-sidx2/probe-pidx-with-join-btree-sidx2.2.update.aql index 6f9deaf..25e4432 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-open-index/index-leftouterjoin/probe-pidx-with-join-btree-sidx2/probe-pidx-with-join-btree-sidx2.2.update.aql +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-open-index/index-leftouterjoin/probe-pidx-with-join-btree-sidx2/probe-pidx-with-join-btree-sidx2.2.update.aql @@ -31,26 +31,26 @@ using localfs insert into dataset TweetMessages ( - for $c in dataset('TweetMessagesTmp') - where $c.tweetid < int64("125") - return { - "nested" : $c - } + for $c in dataset('TweetMessagesTmp') + where $c.tweetid < int64("125") + return { + "nested" : $c + } ); insert into dataset TweetMessages ( - for $c in dataset('TweetMessagesTmp') - where $c.tweetid >= int64("125") - return { - "nested" : { - "tweetid": $c.tweetid, - "user": $c.user, - "sender-location": $c.sender-location, - "send-time": $c.send-time, - "referred-topics": $c.referred-topics, - "message-text": $c.message-text, - "countA": $c.countA - } - } + for $c in dataset('TweetMessagesTmp') + where $c.tweetid >= int64("125") + return { + "nested" : { + "tweetid": $c.tweetid, + "user": $c.user, + "sender-location": $c.sender-location, + "send-time": $c.send-time, + "referred-topics": $c.referred-topics, + "message-text": $c.message-text, + "countA": $c.countA + } + } ); http://git-wip-us.apache.org/repos/asf/asterixdb/blob/d6cf641a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-open-index/index-leftouterjoin/probe-pidx-with-join-invidx-sidx2/probe-pidx-with-join-invidx-sidx2.1.ddl.aql ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-open-index/index-leftouterjoin/probe-pidx-with-join-invidx-sidx2/probe-pidx-with-join-invidx-sidx2.1.ddl.aql b/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-open-index/index-leftouterjoin/probe-pidx-with-join-invidx-sidx2/probe-pidx-with-join-invidx-sidx2.1.ddl.aql index bff7103..aa89b93 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-open-index/index-leftouterjoin/probe-pidx-with-join-invidx-sidx2/probe-pidx-with-join-invidx-sidx2.1.ddl.aql +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-open-index/index-leftouterjoin/probe-pidx-with-join-invidx-sidx2/probe-pidx-with-join-invidx-sidx2.1.ddl.aql @@ -18,7 +18,7 @@ */ /* * Description : Test that left-outer-join may use two available indexes, one for primary index in prob subtree and another for secondary btree index in index subtree. - * Issue : 730, 741 + * Issue : 730, 741 * Expected Res : Success * Date : 8th May 2014 */ @@ -28,26 +28,26 @@ create dataverse test; use dataverse test; create type TwitterUserType as closed { - screen-name: string, - lang: string, - friends-count: int64, - statuses-count: int64, - name: string, - followers-count: int64 -} + screen-name: string, + lang: string, + friends-count: int64, + statuses-count: int64, + name: string, + followers-count: int64 +} create type TweetMessageNestedType as open { - tweetid: int64, + tweetid: int64, user: TwitterUserType, sender-location: point, - send-time: datetime, + send-time: datetime, referred-topics: {{ string }}, - countA: int64, - countB: int64 + countA: int64, + countB: int64 } create type TweetMessageType as closed { - nested: TweetMessageNestedType + nested: TweetMessageNestedType } create dataset TweetMessages(TweetMessageType) http://git-wip-us.apache.org/repos/asf/asterixdb/blob/d6cf641a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-open-index/index-leftouterjoin/probe-pidx-with-join-invidx-sidx2/probe-pidx-with-join-invidx-sidx2.2.update.aql ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-open-index/index-leftouterjoin/probe-pidx-with-join-invidx-sidx2/probe-pidx-with-join-invidx-sidx2.2.update.aql b/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-open-index/index-leftouterjoin/probe-pidx-with-join-invidx-sidx2/probe-pidx-with-join-invidx-sidx2.2.update.aql index d355283..8ead179 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-open-index/index-leftouterjoin/probe-pidx-with-join-invidx-sidx2/probe-pidx-with-join-invidx-sidx2.2.update.aql +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-open-index/index-leftouterjoin/probe-pidx-with-join-invidx-sidx2/probe-pidx-with-join-invidx-sidx2.2.update.aql @@ -31,26 +31,26 @@ using localfs insert into dataset TweetMessages ( - for $c in dataset('TweetMessagesTmp') - where $c.tweetid < int64("125") - return { - "nested" : $c - } + for $c in dataset('TweetMessagesTmp') + where $c.tweetid < int64("125") + return { + "nested" : $c + } ); insert into dataset TweetMessages ( - for $c in dataset('TweetMessagesTmp') - where $c.tweetid >= int64("125") - return { - "nested" : { - "tweetid": $c.tweetid, - "user": $c.user, - "sender-location": $c.sender-location, - "send-time": $c.send-time, - "referred-topics": $c.referred-topics, - "countA": $c.countA, - "countB": $c.countB - } - } + for $c in dataset('TweetMessagesTmp') + where $c.tweetid >= int64("125") + return { + "nested" : { + "tweetid": $c.tweetid, + "user": $c.user, + "sender-location": $c.sender-location, + "send-time": $c.send-time, + "referred-topics": $c.referred-topics, + "countA": $c.countA, + "countB": $c.countB + } + } ); http://git-wip-us.apache.org/repos/asf/asterixdb/blob/d6cf641a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-open-index/index-leftouterjoin/probe-pidx-with-join-invidx-sidx2/probe-pidx-with-join-invidx-sidx2.3.query.aql ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-open-index/index-leftouterjoin/probe-pidx-with-join-invidx-sidx2/probe-pidx-with-join-invidx-sidx2.3.query.aql b/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-open-index/index-leftouterjoin/probe-pidx-with-join-invidx-sidx2/probe-pidx-with-join-invidx-sidx2.3.query.aql index e56f515..b233806 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-open-index/index-leftouterjoin/probe-pidx-with-join-invidx-sidx2/probe-pidx-with-join-invidx-sidx2.3.query.aql +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-open-index/index-leftouterjoin/probe-pidx-with-join-invidx-sidx2/probe-pidx-with-join-invidx-sidx2.3.query.aql @@ -32,7 +32,7 @@ return { "tweet": {"id": $t1.tweetid, "topics" : $t1.message-text} , "similar-tweets": for $t2 in dataset('TweetMessages') let $sim := edit-distance-check($t1.message-text, $t2.nested.message-text, 7) - where $sim[0] and + where $sim[0] and $t2.nested.tweetid != $t1.tweetid order by $t2.nested.tweetid return {"id": $t2.nested.tweetid, "topics" : $t2.nested.message-text} http://git-wip-us.apache.org/repos/asf/asterixdb/blob/d6cf641a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-open-index/index-leftouterjoin/probe-pidx-with-join-rtree-sidx1/probe-pidx-with-join-rtree-sidx1.1.ddl.aql ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-open-index/index-leftouterjoin/probe-pidx-with-join-rtree-sidx1/probe-pidx-with-join-rtree-sidx1.1.ddl.aql b/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-open-index/index-leftouterjoin/probe-pidx-with-join-rtree-sidx1/probe-pidx-with-join-rtree-sidx1.1.ddl.aql index 4d34fb5..8399068 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-open-index/index-leftouterjoin/probe-pidx-with-join-rtree-sidx1/probe-pidx-with-join-rtree-sidx1.1.ddl.aql +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-open-index/index-leftouterjoin/probe-pidx-with-join-rtree-sidx1/probe-pidx-with-join-rtree-sidx1.1.ddl.aql @@ -28,26 +28,26 @@ create dataverse test; use dataverse test; create type TwitterUserType as closed { - screen-name: string, - lang: string, - friends-count: int64, - statuses-count: int64, - name: string, - followers-count: int64 + screen-name: string, + lang: string, + friends-count: int64, + statuses-count: int64, + name: string, + followers-count: int64 } create type TweetMessageNestedType as open { - tweetid: int64, + tweetid: int64, user: TwitterUserType, - send-time: datetime, + send-time: datetime, referred-topics: {{ string }}, - message-text: string, - countA: int64, - countB: int64 + message-text: string, + countA: int64, + countB: int64 } create type TweetMessageType as closed { - nested: TweetMessageNestedType + nested: TweetMessageNestedType } create dataset TweetMessages(TweetMessageType) http://git-wip-us.apache.org/repos/asf/asterixdb/blob/d6cf641a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-open-index/index-leftouterjoin/probe-pidx-with-join-rtree-sidx1/probe-pidx-with-join-rtree-sidx1.2.update.aql ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-open-index/index-leftouterjoin/probe-pidx-with-join-rtree-sidx1/probe-pidx-with-join-rtree-sidx1.2.update.aql b/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-open-index/index-leftouterjoin/probe-pidx-with-join-rtree-sidx1/probe-pidx-with-join-rtree-sidx1.2.update.aql index 6b7bf44..c73db9f 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-open-index/index-leftouterjoin/probe-pidx-with-join-rtree-sidx1/probe-pidx-with-join-rtree-sidx1.2.update.aql +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-open-index/index-leftouterjoin/probe-pidx-with-join-rtree-sidx1/probe-pidx-with-join-rtree-sidx1.2.update.aql @@ -31,26 +31,26 @@ using localfs insert into dataset TweetMessages ( - for $c in dataset('TweetMessagesTmp') - where $c.tweetid < int64("125") - return { - "nested" : $c - } + for $c in dataset('TweetMessagesTmp') + where $c.tweetid < int64("125") + return { + "nested" : $c + } ); insert into dataset TweetMessages ( - for $c in dataset('TweetMessagesTmp') - where $c.tweetid >= int64("125") - return { - "nested" : { - "tweetid": $c.tweetid, - "user": $c.user, - "send-time": $c.send-time, - "referred-topics": $c.referred-topics, - "message-text": $c.message-text, - "countA": $c.countA, - "countB": $c.countB - } - } + for $c in dataset('TweetMessagesTmp') + where $c.tweetid >= int64("125") + return { + "nested" : { + "tweetid": $c.tweetid, + "user": $c.user, + "send-time": $c.send-time, + "referred-topics": $c.referred-topics, + "message-text": $c.message-text, + "countA": $c.countA, + "countB": $c.countB + } + } ); http://git-wip-us.apache.org/repos/asf/asterixdb/blob/d6cf641a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-open-index/index-leftouterjoin/probe-pidx-with-join-rtree-sidx2/probe-pidx-with-join-rtree-sidx2.1.ddl.aql ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-open-index/index-leftouterjoin/probe-pidx-with-join-rtree-sidx2/probe-pidx-with-join-rtree-sidx2.1.ddl.aql b/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-open-index/index-leftouterjoin/probe-pidx-with-join-rtree-sidx2/probe-pidx-with-join-rtree-sidx2.1.ddl.aql index 4d34fb5..8399068 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-open-index/index-leftouterjoin/probe-pidx-with-join-rtree-sidx2/probe-pidx-with-join-rtree-sidx2.1.ddl.aql +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-open-index/index-leftouterjoin/probe-pidx-with-join-rtree-sidx2/probe-pidx-with-join-rtree-sidx2.1.ddl.aql @@ -28,26 +28,26 @@ create dataverse test; use dataverse test; create type TwitterUserType as closed { - screen-name: string, - lang: string, - friends-count: int64, - statuses-count: int64, - name: string, - followers-count: int64 + screen-name: string, + lang: string, + friends-count: int64, + statuses-count: int64, + name: string, + followers-count: int64 } create type TweetMessageNestedType as open { - tweetid: int64, + tweetid: int64, user: TwitterUserType, - send-time: datetime, + send-time: datetime, referred-topics: {{ string }}, - message-text: string, - countA: int64, - countB: int64 + message-text: string, + countA: int64, + countB: int64 } create type TweetMessageType as closed { - nested: TweetMessageNestedType + nested: TweetMessageNestedType } create dataset TweetMessages(TweetMessageType) http://git-wip-us.apache.org/repos/asf/asterixdb/blob/d6cf641a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-open-index/index-leftouterjoin/probe-pidx-with-join-rtree-sidx2/probe-pidx-with-join-rtree-sidx2.2.update.aql ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-open-index/index-leftouterjoin/probe-pidx-with-join-rtree-sidx2/probe-pidx-with-join-rtree-sidx2.2.update.aql b/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-open-index/index-leftouterjoin/probe-pidx-with-join-rtree-sidx2/probe-pidx-with-join-rtree-sidx2.2.update.aql index 6b7bf44..c73db9f 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-open-index/index-leftouterjoin/probe-pidx-with-join-rtree-sidx2/probe-pidx-with-join-rtree-sidx2.2.update.aql +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-open-index/index-leftouterjoin/probe-pidx-with-join-rtree-sidx2/probe-pidx-with-join-rtree-sidx2.2.update.aql @@ -31,26 +31,26 @@ using localfs insert into dataset TweetMessages ( - for $c in dataset('TweetMessagesTmp') - where $c.tweetid < int64("125") - return { - "nested" : $c - } + for $c in dataset('TweetMessagesTmp') + where $c.tweetid < int64("125") + return { + "nested" : $c + } ); insert into dataset TweetMessages ( - for $c in dataset('TweetMessagesTmp') - where $c.tweetid >= int64("125") - return { - "nested" : { - "tweetid": $c.tweetid, - "user": $c.user, - "send-time": $c.send-time, - "referred-topics": $c.referred-topics, - "message-text": $c.message-text, - "countA": $c.countA, - "countB": $c.countB - } - } + for $c in dataset('TweetMessagesTmp') + where $c.tweetid >= int64("125") + return { + "nested" : { + "tweetid": $c.tweetid, + "user": $c.user, + "send-time": $c.send-time, + "referred-topics": $c.referred-topics, + "message-text": $c.message-text, + "countA": $c.countA, + "countB": $c.countB + } + } ); http://git-wip-us.apache.org/repos/asf/asterixdb/blob/d6cf641a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-open-index/index-selection/btree-index-composite-key-mixed-intervals/btree-index-composite-key-mixed-intervals.1.ddl.aql ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-open-index/index-selection/btree-index-composite-key-mixed-intervals/btree-index-composite-key-mixed-intervals.1.ddl.aql b/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-open-index/index-selection/btree-index-composite-key-mixed-intervals/btree-index-composite-key-mixed-intervals.1.ddl.aql index 30ddb91..d07f5b4 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-open-index/index-selection/btree-index-composite-key-mixed-intervals/btree-index-composite-key-mixed-intervals.1.ddl.aql +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-open-index/index-selection/btree-index-composite-key-mixed-intervals/btree-index-composite-key-mixed-intervals.1.ddl.aql @@ -20,7 +20,7 @@ * Description : Test that BTree index is used in query plan * : define the BTree index on a composite key (fname,lanme) * : predicate => where $l.fname > "Julio" and $l.lname > "Mattocks" and - * $l.fname <= "Micco" and $l.lname < "Vangieson" + * $l.fname <= "Micco" and $l.lname < "Vangieson" * Expected Result : Success * Issue : Issue 174 * Date : 5th Feb, 2013 http://git-wip-us.apache.org/repos/asf/asterixdb/blob/d6cf641a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-open-index/index-selection/btree-index-composite-key-mixed-intervals/btree-index-composite-key-mixed-intervals.2.update.aql ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-open-index/index-selection/btree-index-composite-key-mixed-intervals/btree-index-composite-key-mixed-intervals.2.update.aql b/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-open-index/index-selection/btree-index-composite-key-mixed-intervals/btree-index-composite-key-mixed-intervals.2.update.aql index 6b4077e..00dd5db 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-open-index/index-selection/btree-index-composite-key-mixed-intervals/btree-index-composite-key-mixed-intervals.2.update.aql +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-open-index/index-selection/btree-index-composite-key-mixed-intervals/btree-index-composite-key-mixed-intervals.2.update.aql @@ -20,7 +20,7 @@ * Description : Test that BTree index is used in query plan * : define the BTree index on a composite key (fname,lanme) * : predicate => where $l.fname > "Julio" and $l.lname > "Mattocks" and - * $l.fname <= "Micco" and $l.lname < "Vangieson" + * $l.fname <= "Micco" and $l.lname < "Vangieson" * Expected Result : Success * Issue : Issue 174 * Date : 5th Feb, 2013 @@ -35,26 +35,26 @@ using localfs insert into dataset employee ( - for $c in dataset('employeeTmp') - where $c.id <= 1000 - return { - "nested" : { - "id": $c.id, - "fname": $c.fname, - "lname": $c.lname, - "age": $c.age, - "dept": $c.dept } - } + for $c in dataset('employeeTmp') + where $c.id <= 1000 + return { + "nested" : { + "id": $c.id, + "fname": $c.fname, + "lname": $c.lname, + "age": $c.age, + "dept": $c.dept } + } ); insert into dataset employee ( - for $c in dataset('employeeTmp') - where $c.id > 1000 - return { - "nested" : { - "id": $c.id, - "age": $c.age, - "dept": $c.dept } - } + for $c in dataset('employeeTmp') + where $c.id > 1000 + return { + "nested" : { + "id": $c.id, + "age": $c.age, + "dept": $c.dept } + } ); http://git-wip-us.apache.org/repos/asf/asterixdb/blob/d6cf641a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-open-index/index-selection/btree-index-composite-key-mixed-intervals/btree-index-composite-key-mixed-intervals.3.ddl.aql ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-open-index/index-selection/btree-index-composite-key-mixed-intervals/btree-index-composite-key-mixed-intervals.3.ddl.aql b/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-open-index/index-selection/btree-index-composite-key-mixed-intervals/btree-index-composite-key-mixed-intervals.3.ddl.aql index cdec5ac..b4e1a6b 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-open-index/index-selection/btree-index-composite-key-mixed-intervals/btree-index-composite-key-mixed-intervals.3.ddl.aql +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-open-index/index-selection/btree-index-composite-key-mixed-intervals/btree-index-composite-key-mixed-intervals.3.ddl.aql @@ -20,7 +20,7 @@ * Description : Test that BTree index is used in query plan * : define the BTree index on a composite key (fname,lanme) * : predicate => where $l.fname > "Julio" and $l.lname > "Mattocks" and - * $l.fname <= "Micco" and $l.lname < "Vangieson" + * $l.fname <= "Micco" and $l.lname < "Vangieson" * Expected Result : Success * Issue : Issue 174 * Date : 5th Feb, 2013 http://git-wip-us.apache.org/repos/asf/asterixdb/blob/d6cf641a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-open-index/index-selection/btree-index-composite-key-mixed-intervals/btree-index-composite-key-mixed-intervals.4.query.aql ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-open-index/index-selection/btree-index-composite-key-mixed-intervals/btree-index-composite-key-mixed-intervals.4.query.aql b/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-open-index/index-selection/btree-index-composite-key-mixed-intervals/btree-index-composite-key-mixed-intervals.4.query.aql index f77ddcd..c46678f 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-open-index/index-selection/btree-index-composite-key-mixed-intervals/btree-index-composite-key-mixed-intervals.4.query.aql +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-open-index/index-selection/btree-index-composite-key-mixed-intervals/btree-index-composite-key-mixed-intervals.4.query.aql @@ -20,7 +20,7 @@ * Description : Test that BTree index is used in query plan * : define the BTree index on a composite key (fname,lanme) * : predicate => where $l.fname > "Julio" and $l.lname > "Mattocks" and - * $l.fname <= "Micco" and $l.lname < "Vangieson" + * $l.fname <= "Micco" and $l.lname < "Vangieson" * Expected Result : Success * Issue : Issue 174 * Date : 5th Feb, 2013 http://git-wip-us.apache.org/repos/asf/asterixdb/blob/d6cf641a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-open-index/index-selection/btree-index-composite-key/btree-index-composite-key.2.update.aql ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-open-index/index-selection/btree-index-composite-key/btree-index-composite-key.2.update.aql b/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-open-index/index-selection/btree-index-composite-key/btree-index-composite-key.2.update.aql index 029665f..9e564fd 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-open-index/index-selection/btree-index-composite-key/btree-index-composite-key.2.update.aql +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-open-index/index-selection/btree-index-composite-key/btree-index-composite-key.2.update.aql @@ -34,13 +34,13 @@ using localfs insert into dataset employee ( - for $c in dataset('employeeTmp') - return { - "nested" : { - "id": $c.id, - "fname": $c.fname, - "lname": $c.lname, - "age": $c.age, - "dept": $c.dept } - } + for $c in dataset('employeeTmp') + return { + "nested" : { + "id": $c.id, + "fname": $c.fname, + "lname": $c.lname, + "age": $c.age, + "dept": $c.dept } + } ); http://git-wip-us.apache.org/repos/asf/asterixdb/blob/d6cf641a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-open-index/index-selection/btree-index-rewrite-multiple/btree-index-rewrite-multiple.2.update.aql ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-open-index/index-selection/btree-index-rewrite-multiple/btree-index-rewrite-multiple.2.update.aql b/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-open-index/index-selection/btree-index-rewrite-multiple/btree-index-rewrite-multiple.2.update.aql index 3aa3804..b0c9ece 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-open-index/index-selection/btree-index-rewrite-multiple/btree-index-rewrite-multiple.2.update.aql +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-open-index/index-selection/btree-index-rewrite-multiple/btree-index-rewrite-multiple.2.update.aql @@ -32,10 +32,10 @@ using localfs insert into dataset Orders ( - for $c in dataset('Orderstmp') - where $c.o_orderkey <= 4000 - return { - "nested" : { + for $c in dataset('Orderstmp') + where $c.o_orderkey <= 4000 + return { + "nested" : { "o_orderkey": $c.o_orderkey, "o_custkey": $c.o_custkey, "o_orderstatus": $c.o_orderstatus, @@ -46,15 +46,15 @@ insert into dataset Orders "o_shippriority": $c.o_shippriority, "o_comment": $c.o_comment } - } + } ); insert into dataset Orders ( - for $c in dataset('Orderstmp') - where $c.o_orderkey > 4000 - return { - "nested" : { + for $c in dataset('Orderstmp') + where $c.o_orderkey > 4000 + return { + "nested" : { "o_orderkey": $c.o_orderkey, "o_orderstatus": $c.o_orderstatus, "o_totalprice": $c.o_totalprice, @@ -64,5 +64,5 @@ insert into dataset Orders "o_shippriority": $c.o_shippriority, "o_comment": $c.o_comment } - } + } ); http://git-wip-us.apache.org/repos/asf/asterixdb/blob/d6cf641a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-open-index/index-selection/inverted-index-ngram-contains/inverted-index-ngram-contains.2.update.aql ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-open-index/index-selection/inverted-index-ngram-contains/inverted-index-ngram-contains.2.update.aql b/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-open-index/index-selection/inverted-index-ngram-contains/inverted-index-ngram-contains.2.update.aql index c762398..5ae0852 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-open-index/index-selection/inverted-index-ngram-contains/inverted-index-ngram-contains.2.update.aql +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-open-index/index-selection/inverted-index-ngram-contains/inverted-index-ngram-contains.2.update.aql @@ -24,23 +24,23 @@ using localfs insert into dataset DBLP ( - for $c in dataset('DBLPtmp') - where $c.id <= 50 - return { - "nested" : $c - } + for $c in dataset('DBLPtmp') + where $c.id <= 50 + return { + "nested" : $c + } ); insert into dataset DBLP ( - for $c in dataset('DBLPtmp') - where $c.id > 50 - return { - "nested" : { - "id": $c.id, - "dblpid": $c.dblpid, - "authors": $c.authors, - "misc": $c.misc - } - } + for $c in dataset('DBLPtmp') + where $c.id > 50 + return { + "nested" : { + "id": $c.id, + "dblpid": $c.dblpid, + "authors": $c.authors, + "misc": $c.misc + } + } ); http://git-wip-us.apache.org/repos/asf/asterixdb/blob/d6cf641a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-open-index/index-selection/inverted-index-ngram-edit-distance-contains/inverted-index-ngram-edit-distance-contains.2.update.aql ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-open-index/index-selection/inverted-index-ngram-edit-distance-contains/inverted-index-ngram-edit-distance-contains.2.update.aql b/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-open-index/index-selection/inverted-index-ngram-edit-distance-contains/inverted-index-ngram-edit-distance-contains.2.update.aql index 953a027..5179cae 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-open-index/index-selection/inverted-index-ngram-edit-distance-contains/inverted-index-ngram-edit-distance-contains.2.update.aql +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-open-index/index-selection/inverted-index-ngram-edit-distance-contains/inverted-index-ngram-edit-distance-contains.2.update.aql @@ -23,22 +23,22 @@ using localfs (("path"="asterix_nc1://data/dblp-small/dblp-small-id.txt"),("format"="delimited-text"),("delimiter"=":")) pre-sorted; insert into dataset test.DBLP ( - for $x in dataset test.DBLPtmp - where $x.id <= 50 - return { - "nested": $x - } + for $x in dataset test.DBLPtmp + where $x.id <= 50 + return { + "nested": $x + } ); insert into dataset test.DBLP ( - for $c in dataset test.DBLPtmp - where $c.id > 50 - return { - "nested": { - "id": $c.id, - "dblpid": $c.dblpid, - "authors": $c.authors, - "misc": $c.misc - } - } + for $c in dataset test.DBLPtmp + where $c.id > 50 + return { + "nested": { + "id": $c.id, + "dblpid": $c.dblpid, + "authors": $c.authors, + "misc": $c.misc + } + } ); http://git-wip-us.apache.org/repos/asf/asterixdb/blob/d6cf641a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-open-index/index-selection/inverted-index-ngram-edit-distance-panic/inverted-index-ngram-edit-distance-panic.2.update.aql ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-open-index/index-selection/inverted-index-ngram-edit-distance-panic/inverted-index-ngram-edit-distance-panic.2.update.aql b/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-open-index/index-selection/inverted-index-ngram-edit-distance-panic/inverted-index-ngram-edit-distance-panic.2.update.aql index f02322e..31e220a 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-open-index/index-selection/inverted-index-ngram-edit-distance-panic/inverted-index-ngram-edit-distance-panic.2.update.aql +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-open-index/index-selection/inverted-index-ngram-edit-distance-panic/inverted-index-ngram-edit-distance-panic.2.update.aql @@ -24,23 +24,23 @@ using localfs insert into dataset DBLP ( - for $c in dataset('DBLPtmp') - where $c.id <= 50 - return { - "nested" : $c - } + for $c in dataset('DBLPtmp') + where $c.id <= 50 + return { + "nested" : $c + } ); insert into dataset DBLP ( - for $c in dataset('DBLPtmp') - where $c.id > 50 - return { - "nested" : { - "id": $c.id, - "dblpid": $c.dblpid, - "title": $c.title, - "misc": $c.misc - } - } + for $c in dataset('DBLPtmp') + where $c.id > 50 + return { + "nested" : { + "id": $c.id, + "dblpid": $c.dblpid, + "title": $c.title, + "misc": $c.misc + } + } ); http://git-wip-us.apache.org/repos/asf/asterixdb/blob/d6cf641a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-open-index/index-selection/inverted-index-ngram-edit-distance-word-tokens/inverted-index-ngram-edit-distance-word-tokens.2.update.aql ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-open-index/index-selection/inverted-index-ngram-edit-distance-word-tokens/inverted-index-ngram-edit-distance-word-tokens.2.update.aql b/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-open-index/index-selection/inverted-index-ngram-edit-distance-word-tokens/inverted-index-ngram-edit-distance-word-tokens.2.update.aql index 953a027..5179cae 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-open-index/index-selection/inverted-index-ngram-edit-distance-word-tokens/inverted-index-ngram-edit-distance-word-tokens.2.update.aql +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-open-index/index-selection/inverted-index-ngram-edit-distance-word-tokens/inverted-index-ngram-edit-distance-word-tokens.2.update.aql @@ -23,22 +23,22 @@ using localfs (("path"="asterix_nc1://data/dblp-small/dblp-small-id.txt"),("format"="delimited-text"),("delimiter"=":")) pre-sorted; insert into dataset test.DBLP ( - for $x in dataset test.DBLPtmp - where $x.id <= 50 - return { - "nested": $x - } + for $x in dataset test.DBLPtmp + where $x.id <= 50 + return { + "nested": $x + } ); insert into dataset test.DBLP ( - for $c in dataset test.DBLPtmp - where $c.id > 50 - return { - "nested": { - "id": $c.id, - "dblpid": $c.dblpid, - "authors": $c.authors, - "misc": $c.misc - } - } + for $c in dataset test.DBLPtmp + where $c.id > 50 + return { + "nested": { + "id": $c.id, + "dblpid": $c.dblpid, + "authors": $c.authors, + "misc": $c.misc + } + } ); http://git-wip-us.apache.org/repos/asf/asterixdb/blob/d6cf641a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-open-index/index-selection/inverted-index-ngram-edit-distance/inverted-index-ngram-edit-distance.2.update.aql ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-open-index/index-selection/inverted-index-ngram-edit-distance/inverted-index-ngram-edit-distance.2.update.aql b/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-open-index/index-selection/inverted-index-ngram-edit-distance/inverted-index-ngram-edit-distance.2.update.aql index f02322e..31e220a 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-open-index/index-selection/inverted-index-ngram-edit-distance/inverted-index-ngram-edit-distance.2.update.aql +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-open-index/index-selection/inverted-index-ngram-edit-distance/inverted-index-ngram-edit-distance.2.update.aql @@ -24,23 +24,23 @@ using localfs insert into dataset DBLP ( - for $c in dataset('DBLPtmp') - where $c.id <= 50 - return { - "nested" : $c - } + for $c in dataset('DBLPtmp') + where $c.id <= 50 + return { + "nested" : $c + } ); insert into dataset DBLP ( - for $c in dataset('DBLPtmp') - where $c.id > 50 - return { - "nested" : { - "id": $c.id, - "dblpid": $c.dblpid, - "title": $c.title, - "misc": $c.misc - } - } + for $c in dataset('DBLPtmp') + where $c.id > 50 + return { + "nested" : { + "id": $c.id, + "dblpid": $c.dblpid, + "title": $c.title, + "misc": $c.misc + } + } ); http://git-wip-us.apache.org/repos/asf/asterixdb/blob/d6cf641a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-open-index/index-selection/inverted-index-ngram-jaccard/inverted-index-ngram-jaccard.2.update.aql ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-open-index/index-selection/inverted-index-ngram-jaccard/inverted-index-ngram-jaccard.2.update.aql b/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-open-index/index-selection/inverted-index-ngram-jaccard/inverted-index-ngram-jaccard.2.update.aql index c762398..5ae0852 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-open-index/index-selection/inverted-index-ngram-jaccard/inverted-index-ngram-jaccard.2.update.aql +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-open-index/index-selection/inverted-index-ngram-jaccard/inverted-index-ngram-jaccard.2.update.aql @@ -24,23 +24,23 @@ using localfs insert into dataset DBLP ( - for $c in dataset('DBLPtmp') - where $c.id <= 50 - return { - "nested" : $c - } + for $c in dataset('DBLPtmp') + where $c.id <= 50 + return { + "nested" : $c + } ); insert into dataset DBLP ( - for $c in dataset('DBLPtmp') - where $c.id > 50 - return { - "nested" : { - "id": $c.id, - "dblpid": $c.dblpid, - "authors": $c.authors, - "misc": $c.misc - } - } + for $c in dataset('DBLPtmp') + where $c.id > 50 + return { + "nested" : { + "id": $c.id, + "dblpid": $c.dblpid, + "authors": $c.authors, + "misc": $c.misc + } + } ); http://git-wip-us.apache.org/repos/asf/asterixdb/blob/d6cf641a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-open-index/index-selection/inverted-index-word-contains/inverted-index-word-contains.2.update.aql ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-open-index/index-selection/inverted-index-word-contains/inverted-index-word-contains.2.update.aql b/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-open-index/index-selection/inverted-index-word-contains/inverted-index-word-contains.2.update.aql index 036e957..4038bf5 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-open-index/index-selection/inverted-index-word-contains/inverted-index-word-contains.2.update.aql +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-open-index/index-selection/inverted-index-word-contains/inverted-index-word-contains.2.update.aql @@ -25,23 +25,23 @@ using localfs insert into dataset DBLP ( - for $c in dataset('DBLPtmp') - where $c.id <= 50 - return { - "nested" : $c - } + for $c in dataset('DBLPtmp') + where $c.id <= 50 + return { + "nested" : $c + } ); insert into dataset DBLP ( - for $c in dataset('DBLPtmp') - where $c.id > 50 - return { - "nested" : { - "id": $c.id, - "dblpid": $c.dblpid, - "authors": $c.authors, - "misc": $c.misc - } - } + for $c in dataset('DBLPtmp') + where $c.id > 50 + return { + "nested" : { + "id": $c.id, + "dblpid": $c.dblpid, + "authors": $c.authors, + "misc": $c.misc + } + } ); http://git-wip-us.apache.org/repos/asf/asterixdb/blob/d6cf641a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-open-index/index-selection/inverted-index-word-jaccard/inverted-index-word-jaccard.2.update.aql ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-open-index/index-selection/inverted-index-word-jaccard/inverted-index-word-jaccard.2.update.aql b/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-open-index/index-selection/inverted-index-word-jaccard/inverted-index-word-jaccard.2.update.aql index 036e957..4038bf5 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-open-index/index-selection/inverted-index-word-jaccard/inverted-index-word-jaccard.2.update.aql +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-open-index/index-selection/inverted-index-word-jaccard/inverted-index-word-jaccard.2.update.aql @@ -25,23 +25,23 @@ using localfs insert into dataset DBLP ( - for $c in dataset('DBLPtmp') - where $c.id <= 50 - return { - "nested" : $c - } + for $c in dataset('DBLPtmp') + where $c.id <= 50 + return { + "nested" : $c + } ); insert into dataset DBLP ( - for $c in dataset('DBLPtmp') - where $c.id > 50 - return { - "nested" : { - "id": $c.id, - "dblpid": $c.dblpid, - "authors": $c.authors, - "misc": $c.misc - } - } + for $c in dataset('DBLPtmp') + where $c.id > 50 + return { + "nested" : { + "id": $c.id, + "dblpid": $c.dblpid, + "authors": $c.authors, + "misc": $c.misc + } + } ); http://git-wip-us.apache.org/repos/asf/asterixdb/blob/d6cf641a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-open-index/index-selection/orders-index-custkey-conjunctive/orders-index-custkey-conjunctive.2.update.aql ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-open-index/index-selection/orders-index-custkey-conjunctive/orders-index-custkey-conjunctive.2.update.aql b/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-open-index/index-selection/orders-index-custkey-conjunctive/orders-index-custkey-conjunctive.2.update.aql index 6d5ccc6..bda3125 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-open-index/index-selection/orders-index-custkey-conjunctive/orders-index-custkey-conjunctive.2.update.aql +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-open-index/index-selection/orders-index-custkey-conjunctive/orders-index-custkey-conjunctive.2.update.aql @@ -24,8 +24,8 @@ using localfs insert into dataset Orders ( - for $c in dataset('Orderstmp') - return { - "nested" : $c - } + for $c in dataset('Orderstmp') + return { + "nested" : $c + } ); http://git-wip-us.apache.org/repos/asf/asterixdb/blob/d6cf641a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-open-index/index-selection/orders-index-custkey/orders-index-custkey.2.update.aql ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-open-index/index-selection/orders-index-custkey/orders-index-custkey.2.update.aql b/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-open-index/index-selection/orders-index-custkey/orders-index-custkey.2.update.aql index 3b6f0a3..c095344 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-open-index/index-selection/orders-index-custkey/orders-index-custkey.2.update.aql +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-open-index/index-selection/orders-index-custkey/orders-index-custkey.2.update.aql @@ -24,27 +24,27 @@ using localfs insert into dataset Orders ( - for $c in dataset('Orderstmp') - where $c.o_orderkey <= 3000 - return { - "nested" : $c - } + for $c in dataset('Orderstmp') + where $c.o_orderkey <= 3000 + return { + "nested" : $c + } ); insert into dataset Orders ( - for $c in dataset('Orderstmp') - where $c.o_orderkey > 3000 - return { - "nested" : { - "o_orderkey": $c.o_orderkey, - "o_orderstatus": $c.o_orderstatus, - "o_totalprice": $c.o_totalprice, - "o_orderdate": $c.o_orderdate, - "o_orderpriority": $c.o_orderpriority, - "o_clerk": $c.o_clerk, - "o_shippriority": $c.o_shippriority, - "o_comment": $c.o_comment - } - } + for $c in dataset('Orderstmp') + where $c.o_orderkey > 3000 + return { + "nested" : { + "o_orderkey": $c.o_orderkey, + "o_orderstatus": $c.o_orderstatus, + "o_totalprice": $c.o_totalprice, + "o_orderdate": $c.o_orderdate, + "o_orderpriority": $c.o_orderpriority, + "o_clerk": $c.o_clerk, + "o_shippriority": $c.o_shippriority, + "o_comment": $c.o_comment + } + } ); http://git-wip-us.apache.org/repos/asf/asterixdb/blob/d6cf641a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-open-index/index-selection/range-search/range-search.2.update.aql ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-open-index/index-selection/range-search/range-search.2.update.aql b/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-open-index/index-selection/range-search/range-search.2.update.aql index 85f1f6d..61bd454 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-open-index/index-selection/range-search/range-search.2.update.aql +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-open-index/index-selection/range-search/range-search.2.update.aql @@ -24,34 +24,34 @@ using localfs insert into dataset LineItem ( - for $c in dataset('LineItemtmp') - where $c.l_orderkey < 3000 - return { - "nested" : $c - } + for $c in dataset('LineItemtmp') + where $c.l_orderkey < 3000 + return { + "nested" : $c + } ); insert into dataset LineItem ( - for $x in dataset('LineItemtmp') - where $x.l_orderkey >= 3000 - return { - "nested" : { - "l_orderkey": $x.l_orderkey, - "l_partkey": $x.l_partkey, - "l_linenumber": $x.l_linenumber, - "l_quantity": $x.l_quantity, - "l_extendedprice": $x.l_extendedprice, - "l_discount": $x.l_discount, - "l_tax": $x.l_tax, - "l_returnflag": $x.l_returnflag, - "l_linestatus": $x.l_linestatus, - "l_shipdate": $x.l_shipdate, - "l_commitdate": $x.l_commitdate, - "l_receiptdate": $x.l_receiptdate, - "l_shipinstruct": $x.l_shipinstruct, - "l_shipmode": $x.l_shipmode, - "l_comment": $x.l_comment - } - } + for $x in dataset('LineItemtmp') + where $x.l_orderkey >= 3000 + return { + "nested" : { + "l_orderkey": $x.l_orderkey, + "l_partkey": $x.l_partkey, + "l_linenumber": $x.l_linenumber, + "l_quantity": $x.l_quantity, + "l_extendedprice": $x.l_extendedprice, + "l_discount": $x.l_discount, + "l_tax": $x.l_tax, + "l_returnflag": $x.l_returnflag, + "l_linestatus": $x.l_linestatus, + "l_shipdate": $x.l_shipdate, + "l_commitdate": $x.l_commitdate, + "l_receiptdate": $x.l_receiptdate, + "l_shipinstruct": $x.l_shipinstruct, + "l_shipmode": $x.l_shipmode, + "l_comment": $x.l_comment + } + } ); http://git-wip-us.apache.org/repos/asf/asterixdb/blob/d6cf641a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-open-index/index-selection/rtree-secondary-index/rtree-secondary-index.2.update.aql ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-open-index/index-selection/rtree-secondary-index/rtree-secondary-index.2.update.aql b/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-open-index/index-selection/rtree-secondary-index/rtree-secondary-index.2.update.aql index 43d28e5..6042913 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-open-index/index-selection/rtree-secondary-index/rtree-secondary-index.2.update.aql +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries/nested-open-index/index-selection/rtree-secondary-index/rtree-secondary-index.2.update.aql @@ -24,27 +24,27 @@ using localfs insert into dataset MyData ( - for $c in dataset('MyDatatmp') - where $c.id < 15 - return { - "nested" : $c - } + for $c in dataset('MyDatatmp') + where $c.id < 15 + return { + "nested" : $c + } ); insert into dataset MyData ( - for $c in dataset('MyDatatmp') - where $c.id >= 15 - return { - "nested" : { - "id": $c.id, - "kwds": $c.kwds, - "line1": $c.line1, - "line2": $c.line2, - "poly1": $c.poly1, - "poly2": $c.poly2, - "rec": $c.rec, - "circle": $c.circle - } - } + for $c in dataset('MyDatatmp') + where $c.id >= 15 + return { + "nested" : { + "id": $c.id, + "kwds": $c.kwds, + "line1": $c.line1, + "line2": $c.line2, + "poly1": $c.poly1, + "poly2": $c.poly2, + "rec": $c.rec, + "circle": $c.circle + } + } ); http://git-wip-us.apache.org/repos/asf/asterixdb/blob/d6cf641a/asterixdb/asterix-app/src/test/resources/runtimets/queries/numeric/abs0/abs0.3.query.aql ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries/numeric/abs0/abs0.3.query.aql b/asterixdb/asterix-app/src/test/resources/runtimets/queries/numeric/abs0/abs0.3.query.aql index 56c3d27..0581f29 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries/numeric/abs0/abs0.3.query.aql +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries/numeric/abs0/abs0.3.query.aql @@ -27,4 +27,4 @@ let $c5 := int16("0") let $c6 := int32("0") let $c7 := int64("0") return {"f0": abs($c0), "f1": abs($c1),"f2": abs($c2), "f3": abs($c3), - "f4": abs($c4),"f5": abs($c5) ,"f6": abs($c6), "f7": abs($c7)} + "f4": abs($c4),"f5": abs($c5) ,"f6": abs($c6), "f7": abs($c7)} http://git-wip-us.apache.org/repos/asf/asterixdb/blob/d6cf641a/asterixdb/asterix-app/src/test/resources/runtimets/queries/numeric/abs1/abs1.3.query.aql ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries/numeric/abs1/abs1.3.query.aql b/asterixdb/asterix-app/src/test/resources/runtimets/queries/numeric/abs1/abs1.3.query.aql index 367a4df..2cd19bd 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries/numeric/abs1/abs1.3.query.aql +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries/numeric/abs1/abs1.3.query.aql @@ -27,4 +27,4 @@ let $c5 := int16("22") let $c6 := int32("23") let $c7 := int64("27") return {"f0": abs($c0), "f1": abs($c1),"f2": abs($c2), "f3": abs($c3), - "f4": abs($c4),"f5": abs($c5) ,"f6": abs($c6), "f7": abs($c7)} + "f4": abs($c4),"f5": abs($c5) ,"f6": abs($c6), "f7": abs($c7)} http://git-wip-us.apache.org/repos/asf/asterixdb/blob/d6cf641a/asterixdb/asterix-app/src/test/resources/runtimets/queries/numeric/ceiling0/ceiling0.3.query.aql ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries/numeric/ceiling0/ceiling0.3.query.aql b/asterixdb/asterix-app/src/test/resources/runtimets/queries/numeric/ceiling0/ceiling0.3.query.aql index 1bc12ea..66b502e 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries/numeric/ceiling0/ceiling0.3.query.aql +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries/numeric/ceiling0/ceiling0.3.query.aql @@ -27,4 +27,4 @@ let $c5 := int16("0") let $c6 := int32("0") let $c7 := int64("0") return {"f0": ceiling($c0), "f1": ceiling($c1),"f2": ceiling($c2), "f3": ceiling($c3), - "f4": ceiling($c4),"f5": ceiling($c5) ,"f6": ceiling($c6), "f7": ceiling($c7)} + "f4": ceiling($c4),"f5": ceiling($c5) ,"f6": ceiling($c6), "f7": ceiling($c7)} http://git-wip-us.apache.org/repos/asf/asterixdb/blob/d6cf641a/asterixdb/asterix-app/src/test/resources/runtimets/queries/numeric/ceiling1/ceiling1.3.query.aql ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries/numeric/ceiling1/ceiling1.3.query.aql b/asterixdb/asterix-app/src/test/resources/runtimets/queries/numeric/ceiling1/ceiling1.3.query.aql index 4c13c5c..2b66b30 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries/numeric/ceiling1/ceiling1.3.query.aql +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries/numeric/ceiling1/ceiling1.3.query.aql @@ -27,4 +27,4 @@ let $c5 := int16("22") let $c6 := int32("23") let $c7 := int64("27") return {"f0": ceiling($c0), "f1": ceiling($c1),"f2": ceiling($c2), "f3": ceiling($c3), - "f4": ceiling($c4),"f5": ceiling($c5) ,"f6": ceiling($c6), "f7": ceiling($c7)} + "f4": ceiling($c4),"f5": ceiling($c5) ,"f6": ceiling($c6), "f7": ceiling($c7)} http://git-wip-us.apache.org/repos/asf/asterixdb/blob/d6cf641a/asterixdb/asterix-app/src/test/resources/runtimets/queries/numeric/floor0/floor0.3.query.aql ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries/numeric/floor0/floor0.3.query.aql b/asterixdb/asterix-app/src/test/resources/runtimets/queries/numeric/floor0/floor0.3.query.aql index 1d1e638..0641383 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries/numeric/floor0/floor0.3.query.aql +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries/numeric/floor0/floor0.3.query.aql @@ -27,4 +27,4 @@ let $c5 := int16("0") let $c6 := int32("0") let $c7 := int64("0") return {"f0": floor($c0), "f1": floor($c1),"f2": floor($c2), "f3": floor($c3), - "f4": floor($c4),"f5": floor($c5) ,"f6": floor($c6), "f7": floor($c7)} + "f4": floor($c4),"f5": floor($c5) ,"f6": floor($c6), "f7": floor($c7)} http://git-wip-us.apache.org/repos/asf/asterixdb/blob/d6cf641a/asterixdb/asterix-app/src/test/resources/runtimets/queries/numeric/floor1/floor1.3.query.aql ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries/numeric/floor1/floor1.3.query.aql b/asterixdb/asterix-app/src/test/resources/runtimets/queries/numeric/floor1/floor1.3.query.aql index 15a5462..4eaac90 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries/numeric/floor1/floor1.3.query.aql +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries/numeric/floor1/floor1.3.query.aql @@ -27,4 +27,4 @@ let $c5 := int16("22") let $c6 := int32("23") let $c7 := int64("27") return {"f0": floor($c0), "f1": floor($c1),"f2": floor($c2), "f3": floor($c3), - "f4": floor($c4),"f5": floor($c5) ,"f6": floor($c6), "f7": floor($c7)} + "f4": floor($c4),"f5": floor($c5) ,"f6": floor($c6), "f7": floor($c7)} http://git-wip-us.apache.org/repos/asf/asterixdb/blob/d6cf641a/asterixdb/asterix-app/src/test/resources/runtimets/queries/numeric/round-half-to-even0/round-half-to-even0.3.query.aql ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries/numeric/round-half-to-even0/round-half-to-even0.3.query.aql b/asterixdb/asterix-app/src/test/resources/runtimets/queries/numeric/round-half-to-even0/round-half-to-even0.3.query.aql index 8ebdde3..75084f1 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries/numeric/round-half-to-even0/round-half-to-even0.3.query.aql +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries/numeric/round-half-to-even0/round-half-to-even0.3.query.aql @@ -27,4 +27,4 @@ let $c5 := int16("0") let $c6 := int32("0") let $c7 := int64("0") return {"f0": round-half-to-even($c0), "f1": round-half-to-even($c1),"f2": round-half-to-even($c2), "f3": round-half-to-even($c3), - "f4": round-half-to-even($c4),"f5": round-half-to-even($c5) ,"f6": round-half-to-even($c6), "f7": round-half-to-even($c7)} + "f4": round-half-to-even($c4),"f5": round-half-to-even($c5) ,"f6": round-half-to-even($c6), "f7": round-half-to-even($c7)} http://git-wip-us.apache.org/repos/asf/asterixdb/blob/d6cf641a/asterixdb/asterix-app/src/test/resources/runtimets/queries/numeric/round-half-to-even1/round-half-to-even1.3.query.aql ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries/numeric/round-half-to-even1/round-half-to-even1.3.query.aql b/asterixdb/asterix-app/src/test/resources/runtimets/queries/numeric/round-half-to-even1/round-half-to-even1.3.query.aql index 3191293..fdec38e 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries/numeric/round-half-to-even1/round-half-to-even1.3.query.aql +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries/numeric/round-half-to-even1/round-half-to-even1.3.query.aql @@ -27,4 +27,4 @@ let $c5 := int16("22") let $c6 := int32("23") let $c7 := int64("27") return {"f0": round-half-to-even($c0), "f1": round-half-to-even($c1),"f2": round-half-to-even($c2), "f3": round-half-to-even($c3), - "f4": round-half-to-even($c4),"f5": round-half-to-even($c5) ,"f6": round-half-to-even($c6), "f7": round-half-to-even($c7)} + "f4": round-half-to-even($c4),"f5": round-half-to-even($c5) ,"f6": round-half-to-even($c6), "f7": round-half-to-even($c7)} http://git-wip-us.apache.org/repos/asf/asterixdb/blob/d6cf641a/asterixdb/asterix-app/src/test/resources/runtimets/queries/numeric/round-half-to-even20/round-half-to-even20.3.query.aql ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries/numeric/round-half-to-even20/round-half-to-even20.3.query.aql b/asterixdb/asterix-app/src/test/resources/runtimets/queries/numeric/round-half-to-even20/round-half-to-even20.3.query.aql index b2a56bd..73f056a 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries/numeric/round-half-to-even20/round-half-to-even20.3.query.aql +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries/numeric/round-half-to-even20/round-half-to-even20.3.query.aql @@ -27,4 +27,4 @@ let $c5 := int16("0") let $c6 := int32("0") let $c7 := int64("0") return {"f0": round-half-to-even($c0,2), "f1": round-half-to-even($c1,2),"f2": round-half-to-even($c2,2), "f3": round-half-to-even($c3,2), - "f4": round-half-to-even($c4,2),"f5": round-half-to-even($c5,2) ,"f6": round-half-to-even($c6,2), "f7": round-half-to-even($c7,2)} + "f4": round-half-to-even($c4,2),"f5": round-half-to-even($c5,2) ,"f6": round-half-to-even($c6,2), "f7": round-half-to-even($c7,2)} http://git-wip-us.apache.org/repos/asf/asterixdb/blob/d6cf641a/asterixdb/asterix-app/src/test/resources/runtimets/queries/numeric/round-half-to-even21/round-half-to-even21.3.query.aql ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries/numeric/round-half-to-even21/round-half-to-even21.3.query.aql b/asterixdb/asterix-app/src/test/resources/runtimets/queries/numeric/round-half-to-even21/round-half-to-even21.3.query.aql index 49d7251..04478fe 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries/numeric/round-half-to-even21/round-half-to-even21.3.query.aql +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries/numeric/round-half-to-even21/round-half-to-even21.3.query.aql @@ -27,4 +27,4 @@ let $c5 := int16("22") let $c6 := int32("23") let $c7 := int64("27") return {"f0": round-half-to-even($c0,2), "f1": round-half-to-even($c1,2),"f2": round-half-to-even($c2,2), "f3": round-half-to-even($c3,2), - "f4": round-half-to-even($c4,2),"f5": round-half-to-even($c5,2) ,"f6": round-half-to-even($c6,2), "f7": round-half-to-even($c7,2)} + "f4": round-half-to-even($c4,2),"f5": round-half-to-even($c5,2) ,"f6": round-half-to-even($c6,2), "f7": round-half-to-even($c7,2)} http://git-wip-us.apache.org/repos/asf/asterixdb/blob/d6cf641a/asterixdb/asterix-app/src/test/resources/runtimets/queries/numeric/round0/round0.3.query.aql ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries/numeric/round0/round0.3.query.aql b/asterixdb/asterix-app/src/test/resources/runtimets/queries/numeric/round0/round0.3.query.aql index d9ebf1b..b2cdd89 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries/numeric/round0/round0.3.query.aql +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries/numeric/round0/round0.3.query.aql @@ -27,4 +27,4 @@ let $c5 := int16("0") let $c6 := int32("0") let $c7 := int64("0") return {"f0": round($c0), "f1": round($c1),"f2": round($c2), "f3": round($c3), - "f4": round($c4),"f5": round($c5) ,"f6": round($c6), "f7": round($c7)} + "f4": round($c4),"f5": round($c5) ,"f6": round($c6), "f7": round($c7)} http://git-wip-us.apache.org/repos/asf/asterixdb/blob/d6cf641a/asterixdb/asterix-app/src/test/resources/runtimets/queries/numeric/round1/round1.3.query.aql ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries/numeric/round1/round1.3.query.aql b/asterixdb/asterix-app/src/test/resources/runtimets/queries/numeric/round1/round1.3.query.aql index 8e027ba..c1864b1 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries/numeric/round1/round1.3.query.aql +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries/numeric/round1/round1.3.query.aql @@ -27,4 +27,4 @@ let $c5 := int16("22") let $c6 := int32("23") let $c7 := int64("27") return {"f0": round($c0), "f1": round($c1),"f2": round($c2), "f3": round($c3), - "f4": round($c4),"f5": round($c5) ,"f6": round($c6), "f7": round($c7)} + "f4": round($c4),"f5": round($c5) ,"f6": round($c6), "f7": round($c7)} http://git-wip-us.apache.org/repos/asf/asterixdb/blob/d6cf641a/asterixdb/asterix-app/src/test/resources/runtimets/queries/open-closed/query-issue134/query-issue134.1.ddl.aql ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries/open-closed/query-issue134/query-issue134.1.ddl.aql b/asterixdb/asterix-app/src/test/resources/runtimets/queries/open-closed/query-issue134/query-issue134.1.ddl.aql index 0aa3268..b7a2b85 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries/open-closed/query-issue134/query-issue134.1.ddl.aql +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries/open-closed/query-issue134/query-issue134.1.ddl.aql @@ -18,7 +18,7 @@ */ /* * Description : This test case is to verify the fix for issue134 - : https://code.google.com/p/asterixdb/issues/detail?id=134 + : https://code.google.com/p/asterixdb/issues/detail?id=134 * Expected Res : Success * Date : 26th November 2012 */ http://git-wip-us.apache.org/repos/asf/asterixdb/blob/d6cf641a/asterixdb/asterix-app/src/test/resources/runtimets/queries/open-closed/query-issue134/query-issue134.2.update.aql ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries/open-closed/query-issue134/query-issue134.2.update.aql b/asterixdb/asterix-app/src/test/resources/runtimets/queries/open-closed/query-issue134/query-issue134.2.update.aql index 0aa3268..b7a2b85 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries/open-closed/query-issue134/query-issue134.2.update.aql +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries/open-closed/query-issue134/query-issue134.2.update.aql @@ -18,7 +18,7 @@ */ /* * Description : This test case is to verify the fix for issue134 - : https://code.google.com/p/asterixdb/issues/detail?id=134 + : https://code.google.com/p/asterixdb/issues/detail?id=134 * Expected Res : Success * Date : 26th November 2012 */ http://git-wip-us.apache.org/repos/asf/asterixdb/blob/d6cf641a/asterixdb/asterix-app/src/test/resources/runtimets/queries/open-closed/query-issue134/query-issue134.3.query.aql ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries/open-closed/query-issue134/query-issue134.3.query.aql b/asterixdb/asterix-app/src/test/resources/runtimets/queries/open-closed/query-issue134/query-issue134.3.query.aql index 1ed1b9f..f3926f8 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries/open-closed/query-issue134/query-issue134.3.query.aql +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries/open-closed/query-issue134/query-issue134.3.query.aql @@ -18,7 +18,7 @@ */ /* * Description : This test case is to verify the fix for issue134 - : https://code.google.com/p/asterixdb/issues/detail?id=134 + : https://code.google.com/p/asterixdb/issues/detail?id=134 * Expected Res : Success * Date : 26th November 2012 */ http://git-wip-us.apache.org/repos/asf/asterixdb/blob/d6cf641a/asterixdb/asterix-app/src/test/resources/runtimets/queries/open-closed/query-issue166/query-issue166.1.ddl.aql ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries/open-closed/query-issue166/query-issue166.1.ddl.aql b/asterixdb/asterix-app/src/test/resources/runtimets/queries/open-closed/query-issue166/query-issue166.1.ddl.aql index e8a5293..0b8f376 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries/open-closed/query-issue166/query-issue166.1.ddl.aql +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries/open-closed/query-issue166/query-issue166.1.ddl.aql @@ -18,8 +18,8 @@ */ /* * Description : This test case is to verify the fix for issue166 - : https://code.google.com/p/asterixdb/issues/detail?id=166 + : https://code.google.com/p/asterixdb/issues/detail?id=166 * Expected Res : Success * Date : 26th November 2012 */ - + http://git-wip-us.apache.org/repos/asf/asterixdb/blob/d6cf641a/asterixdb/asterix-app/src/test/resources/runtimets/queries/open-closed/query-issue166/query-issue166.2.update.aql ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries/open-closed/query-issue166/query-issue166.2.update.aql b/asterixdb/asterix-app/src/test/resources/runtimets/queries/open-closed/query-issue166/query-issue166.2.update.aql index e8a5293..0b8f376 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries/open-closed/query-issue166/query-issue166.2.update.aql +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries/open-closed/query-issue166/query-issue166.2.update.aql @@ -18,8 +18,8 @@ */ /* * Description : This test case is to verify the fix for issue166 - : https://code.google.com/p/asterixdb/issues/detail?id=166 + : https://code.google.com/p/asterixdb/issues/detail?id=166 * Expected Res : Success * Date : 26th November 2012 */ - + http://git-wip-us.apache.org/repos/asf/asterixdb/blob/d6cf641a/asterixdb/asterix-app/src/test/resources/runtimets/queries/open-closed/query-issue166/query-issue166.3.query.aql ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries/open-closed/query-issue166/query-issue166.3.query.aql b/asterixdb/asterix-app/src/test/resources/runtimets/queries/open-closed/query-issue166/query-issue166.3.query.aql index 8b0290a..fb11390 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries/open-closed/query-issue166/query-issue166.3.query.aql +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries/open-closed/query-issue166/query-issue166.3.query.aql @@ -18,10 +18,10 @@ */ /* * Description : This test case is to verify the fix for issue166 - : https://code.google.com/p/asterixdb/issues/detail?id=166 + : https://code.google.com/p/asterixdb/issues/detail?id=166 * Expected Res : Success * Date : 26th November 2012 */ - + let $a := [[1,2,3],[4,5,6,7]] return $a[1] http://git-wip-us.apache.org/repos/asf/asterixdb/blob/d6cf641a/asterixdb/asterix-app/src/test/resources/runtimets/queries/open-closed/query-issue196/query-issue196.2.update.aql ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries/open-closed/query-issue196/query-issue196.2.update.aql b/asterixdb/asterix-app/src/test/resources/runtimets/queries/open-closed/query-issue196/query-issue196.2.update.aql index 99079e3..ffb0ec1 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries/open-closed/query-issue196/query-issue196.2.update.aql +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries/open-closed/query-issue196/query-issue196.2.update.aql @@ -18,7 +18,7 @@ */ /* * Description : This test case is to verify the fix for issue196 - : https://code.google.com/p/asterixdb/issues/detail?id=196 + : https://code.google.com/p/asterixdb/issues/detail?id=196 * Expected Res : Success * Date : 5th May 2013 */ http://git-wip-us.apache.org/repos/asf/asterixdb/blob/d6cf641a/asterixdb/asterix-app/src/test/resources/runtimets/queries/open-closed/query-issue196/query-issue196.3.query.aql ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries/open-closed/query-issue196/query-issue196.3.query.aql b/asterixdb/asterix-app/src/test/resources/runtimets/queries/open-closed/query-issue196/query-issue196.3.query.aql index 58980a9..ea4572e 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries/open-closed/query-issue196/query-issue196.3.query.aql +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries/open-closed/query-issue196/query-issue196.3.query.aql @@ -18,7 +18,7 @@ */ /* * Description : This test case is to verify the fix for issue196 - : https://code.google.com/p/asterixdb/issues/detail?id=196 + : https://code.google.com/p/asterixdb/issues/detail?id=196 * Expected Res : Success * Date : 5th May 2013 */ http://git-wip-us.apache.org/repos/asf/asterixdb/blob/d6cf641a/asterixdb/asterix-app/src/test/resources/runtimets/queries/open-closed/query-issue208/query-issue208.2.update.aql ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries/open-closed/query-issue208/query-issue208.2.update.aql b/asterixdb/asterix-app/src/test/resources/runtimets/queries/open-closed/query-issue208/query-issue208.2.update.aql index d5656a5..5a5e797 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries/open-closed/query-issue208/query-issue208.2.update.aql +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries/open-closed/query-issue208/query-issue208.2.update.aql @@ -18,7 +18,7 @@ */ /* * Description : This test case is to verify the fix for issue208 - : https://code.google.com/p/asterixdb/issues/detail?id=208 + : https://code.google.com/p/asterixdb/issues/detail?id=208 * Expected Res : Success * Date : 26th November 2012 */ http://git-wip-us.apache.org/repos/asf/asterixdb/blob/d6cf641a/asterixdb/asterix-app/src/test/resources/runtimets/queries/open-closed/query-issue208/query-issue208.3.query.aql ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries/open-closed/query-issue208/query-issue208.3.query.aql b/asterixdb/asterix-app/src/test/resources/runtimets/queries/open-closed/query-issue208/query-issue208.3.query.aql index 6bcef32..860e012 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries/open-closed/query-issue208/query-issue208.3.query.aql +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries/open-closed/query-issue208/query-issue208.3.query.aql @@ -18,7 +18,7 @@ */ /* * Description : This test case is to verify the fix for issue208 - : https://code.google.com/p/asterixdb/issues/detail?id=208 + : https://code.google.com/p/asterixdb/issues/detail?id=208 * Expected Res : Success * Date : 26th November 2012 */ http://git-wip-us.apache.org/repos/asf/asterixdb/blob/d6cf641a/asterixdb/asterix-app/src/test/resources/runtimets/queries/open-closed/query-issue236/query-issue236.2.update.aql ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries/open-closed/query-issue236/query-issue236.2.update.aql b/asterixdb/asterix-app/src/test/resources/runtimets/queries/open-closed/query-issue236/query-issue236.2.update.aql index d0b756a..ba432ec 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries/open-closed/query-issue236/query-issue236.2.update.aql +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries/open-closed/query-issue236/query-issue236.2.update.aql @@ -18,7 +18,7 @@ */ /* * Description : This test case is to verify the fix for issue236 - : https://code.google.com/p/asterixdb/issues/detail?id=236 + : https://code.google.com/p/asterixdb/issues/detail?id=236 * Expected Res : Success * Date : 20 Dec. 2012 */ @@ -27,15 +27,15 @@ use dataverse SocialNetworkData; insert into dataset TweetMessages( -{ -"tweetid": "1111387810", -"tweetid-copy": "1111387810", -"user": { "screen-name": "TonyNapier#786", "lang": "en", "friends_count": 4241366, -"statuses_count": 97, "name": "Tony Napier", "followers_count": 5984113 }, -"sender-location": point("29.24,78.35"), -"send-time": datetime("2011-11-24T14:24:51.000Z"), -"send-time-copy": datetime("2011-11-24T14:24:51.000Z"), -"referred-topics": {{ "sprint", "wireless" }}, -"message-text": " love sprint its wireless is mind-blowing:)" +{ +"tweetid": "1111387810", +"tweetid-copy": "1111387810", +"user": { "screen-name": "TonyNapier#786", "lang": "en", "friends_count": 4241366, +"statuses_count": 97, "name": "Tony Napier", "followers_count": 5984113 }, +"sender-location": point("29.24,78.35"), +"send-time": datetime("2011-11-24T14:24:51.000Z"), +"send-time-copy": datetime("2011-11-24T14:24:51.000Z"), +"referred-topics": {{ "sprint", "wireless" }}, +"message-text": " love sprint its wireless is mind-blowing:)" }); http://git-wip-us.apache.org/repos/asf/asterixdb/blob/d6cf641a/asterixdb/asterix-app/src/test/resources/runtimets/queries/open-closed/query-issue236/query-issue236.3.query.aql ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries/open-closed/query-issue236/query-issue236.3.query.aql b/asterixdb/asterix-app/src/test/resources/runtimets/queries/open-closed/query-issue236/query-issue236.3.query.aql index 80d4355..8b89b0c 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries/open-closed/query-issue236/query-issue236.3.query.aql +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries/open-closed/query-issue236/query-issue236.3.query.aql @@ -18,7 +18,7 @@ */ /* * Description : This test case is to verify the fix for issue236 - : https://code.google.com/p/asterixdb/issues/detail?id=236 + : https://code.google.com/p/asterixdb/issues/detail?id=236 * Expected Res : Success * Date : 20 Dec. 2012 */ http://git-wip-us.apache.org/repos/asf/asterixdb/blob/d6cf641a/asterixdb/asterix-app/src/test/resources/runtimets/queries/open-closed/query-issue258/query-issue258.2.update.aql ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries/open-closed/query-issue258/query-issue258.2.update.aql b/asterixdb/asterix-app/src/test/resources/runtimets/queries/open-closed/query-issue258/query-issue258.2.update.aql index 1fb7292..60242f1 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries/open-closed/query-issue258/query-issue258.2.update.aql +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries/open-closed/query-issue258/query-issue258.2.update.aql @@ -18,7 +18,7 @@ */ /* * Description : This test case is to verify the fix for issue258 - : https://code.google.com/p/asterixdb/issues/detail?id=258 + : https://code.google.com/p/asterixdb/issues/detail?id=258 * Expected Res : Success * Date : 21 May 2013 */ @@ -26,7 +26,7 @@ use dataverse test; insert into dataset ds1( -let $L:= +let $L:= for $x in dataset('ds2') where $x.id = 10 return $x http://git-wip-us.apache.org/repos/asf/asterixdb/blob/d6cf641a/asterixdb/asterix-app/src/test/resources/runtimets/queries/open-closed/query-issue258/query-issue258.3.query.aql ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries/open-closed/query-issue258/query-issue258.3.query.aql b/asterixdb/asterix-app/src/test/resources/runtimets/queries/open-closed/query-issue258/query-issue258.3.query.aql index a08cebd..aba7f15 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries/open-closed/query-issue258/query-issue258.3.query.aql +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries/open-closed/query-issue258/query-issue258.3.query.aql @@ -18,7 +18,7 @@ */ /* * Description : This test case is to verify the fix for issue258 - : https://code.google.com/p/asterixdb/issues/detail?id=258 + : https://code.google.com/p/asterixdb/issues/detail?id=258 * Expected Res : Success * Date : 21 May 2013 */ http://git-wip-us.apache.org/repos/asf/asterixdb/blob/d6cf641a/asterixdb/asterix-app/src/test/resources/runtimets/queries/open-closed/query-issue29/query-issue29.1.ddl.aql ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries/open-closed/query-issue29/query-issue29.1.ddl.aql b/asterixdb/asterix-app/src/test/resources/runtimets/queries/open-closed/query-issue29/query-issue29.1.ddl.aql index 1bb17b3..b371a74 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries/open-closed/query-issue29/query-issue29.1.ddl.aql +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries/open-closed/query-issue29/query-issue29.1.ddl.aql @@ -18,7 +18,7 @@ */ /* * Description : This test case is to verify the fix for issue29 - : https://code.google.com/p/asterixdb/issues/detail?id=29 + : https://code.google.com/p/asterixdb/issues/detail?id=29 * Expected Res : Success * Date : 26th November 2012 */ http://git-wip-us.apache.org/repos/asf/asterixdb/blob/d6cf641a/asterixdb/asterix-app/src/test/resources/runtimets/queries/open-closed/query-issue29/query-issue29.2.update.aql ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries/open-closed/query-issue29/query-issue29.2.update.aql b/asterixdb/asterix-app/src/test/resources/runtimets/queries/open-closed/query-issue29/query-issue29.2.update.aql index 1bb17b3..b371a74 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries/open-closed/query-issue29/query-issue29.2.update.aql +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries/open-closed/query-issue29/query-issue29.2.update.aql @@ -18,7 +18,7 @@ */ /* * Description : This test case is to verify the fix for issue29 - : https://code.google.com/p/asterixdb/issues/detail?id=29 + : https://code.google.com/p/asterixdb/issues/detail?id=29 * Expected Res : Success * Date : 26th November 2012 */ http://git-wip-us.apache.org/repos/asf/asterixdb/blob/d6cf641a/asterixdb/asterix-app/src/test/resources/runtimets/queries/open-closed/query-issue29/query-issue29.3.query.aql ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries/open-closed/query-issue29/query-issue29.3.query.aql b/asterixdb/asterix-app/src/test/resources/runtimets/queries/open-closed/query-issue29/query-issue29.3.query.aql index a4f88dc..0335dd9 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries/open-closed/query-issue29/query-issue29.3.query.aql +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries/open-closed/query-issue29/query-issue29.3.query.aql @@ -18,12 +18,12 @@ */ /* * Description : This test case is to verify the fix for issue29 - : https://code.google.com/p/asterixdb/issues/detail?id=29 + : https://code.google.com/p/asterixdb/issues/detail?id=29 * Expected Res : Success * Date : 26th November 2012 */ -let $tweets := +let $tweets := {{ { "tweetid": "1023", http://git-wip-us.apache.org/repos/asf/asterixdb/blob/d6cf641a/asterixdb/asterix-app/src/test/resources/runtimets/queries/open-closed/query-issue343-2/query-issue343-2.2.update.aql ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries/open-closed/query-issue343-2/query-issue343-2.2.update.aql b/asterixdb/asterix-app/src/test/resources/runtimets/queries/open-closed/query-issue343-2/query-issue343-2.2.update.aql index 1e294f5..6d64df4 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries/open-closed/query-issue343-2/query-issue343-2.2.update.aql +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries/open-closed/query-issue343-2/query-issue343-2.2.update.aql @@ -18,7 +18,7 @@ */ /* * Description : This test case is to verify the fix for issue343. It is a more general case. - : https://code.google.com/p/asterixdb/issues/detail?id=343 + : https://code.google.com/p/asterixdb/issues/detail?id=343 * Expected Res : Success * Date : 30th April 2013 */ http://git-wip-us.apache.org/repos/asf/asterixdb/blob/d6cf641a/asterixdb/asterix-app/src/test/resources/runtimets/queries/open-closed/query-issue343-2/query-issue343-2.3.query.aql ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries/open-closed/query-issue343-2/query-issue343-2.3.query.aql b/asterixdb/asterix-app/src/test/resources/runtimets/queries/open-closed/query-issue343-2/query-issue343-2.3.query.aql index 6ef2ea1..779f4da 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries/open-closed/query-issue343-2/query-issue343-2.3.query.aql +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries/open-closed/query-issue343-2/query-issue343-2.3.query.aql @@ -18,7 +18,7 @@ */ /* * Description : This test case is to verify the fix for issue343. It is a more general case. - : https://code.google.com/p/asterixdb/issues/detail?id=343 + : https://code.google.com/p/asterixdb/issues/detail?id=343 * Expected Res : Success * Date : 30th April 2013 */ http://git-wip-us.apache.org/repos/asf/asterixdb/blob/d6cf641a/asterixdb/asterix-app/src/test/resources/runtimets/queries/open-closed/query-issue343/query-issue343.2.update.aql ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries/open-closed/query-issue343/query-issue343.2.update.aql b/asterixdb/asterix-app/src/test/resources/runtimets/queries/open-closed/query-issue343/query-issue343.2.update.aql index 3b87458..e39b6e3 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries/open-closed/query-issue343/query-issue343.2.update.aql +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries/open-closed/query-issue343/query-issue343.2.update.aql @@ -18,7 +18,7 @@ */ /* * Description : This test case is to verify the fix for issue343 - : https://code.google.com/p/asterixdb/issues/detail?id=343 + : https://code.google.com/p/asterixdb/issues/detail?id=343 * Expected Res : Success * Date : 30th April 2013 */ http://git-wip-us.apache.org/repos/asf/asterixdb/blob/d6cf641a/asterixdb/asterix-app/src/test/resources/runtimets/queries/open-closed/query-issue343/query-issue343.3.query.aql ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries/open-closed/query-issue343/query-issue343.3.query.aql b/asterixdb/asterix-app/src/test/resources/runtimets/queries/open-closed/query-issue343/query-issue343.3.query.aql index fc20fdf..8ddfb9a 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries/open-closed/query-issue343/query-issue343.3.query.aql +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries/open-closed/query-issue343/query-issue343.3.query.aql @@ -18,7 +18,7 @@ */ /* * Description : This test case is to verify the fix for issue343 - : https://code.google.com/p/asterixdb/issues/detail?id=343 + : https://code.google.com/p/asterixdb/issues/detail?id=343 * Expected Res : Success * Date : 30th April 2013 */