Return-Path: X-Original-To: archive-asf-public@cust-asf.ponee.io Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by cust-asf.ponee.io (Postfix) with SMTP id 3300E166A98 for ; Tue, 22 Aug 2017 12:15:00 +0200 (CEST) Received: (qmail 62113 invoked by uid 500); 22 Aug 2017 10:14:59 -0000 Mailing-List: contact commits-help@asterixdb.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@asterixdb.apache.org Delivered-To: mailing list commits@asterixdb.apache.org Received: (qmail 61195 invoked by uid 99); 22 Aug 2017 10:14:58 -0000 Received: from git1-us-west.apache.org (HELO git1-us-west.apache.org) (140.211.11.23) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 22 Aug 2017 10:14:58 +0000 Received: by git1-us-west.apache.org (ASF Mail Server at git1-us-west.apache.org, from userid 33) id 50767F5F09; Tue, 22 Aug 2017 10:14:57 +0000 (UTC) Content-Type: text/plain; charset="us-ascii" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit From: mhubail@apache.org To: commits@asterixdb.apache.org Date: Tue, 22 Aug 2017 10:15:26 -0000 Message-Id: <608cf34e592742efa9da036bf0ffd12d@git.apache.org> In-Reply-To: <7abd4fd7f49741acaaec1712da95441a@git.apache.org> References: <7abd4fd7f49741acaaec1712da95441a@git.apache.org> X-Mailer: ASF-Git Admin Mailer Subject: [31/32] asterixdb git commit: [ASTERIXDB-2050][SQL] Enforce a Semicolon After Each SQL++ Statement http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/aggregate/constant-agg.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/aggregate/constant-agg.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/aggregate/constant-agg.sqlpp index 2081d2e..efde2b4 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/aggregate/constant-agg.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/aggregate/constant-agg.sqlpp @@ -26,21 +26,21 @@ use TinySocial; create type TinySocial.TwitterUserType as { `screen-name` : string -} +}; create type TinySocial.TweetMessageType as { tweetid : string -} +}; create type TinySocial.FacebookUserType as open { id : bigint -} +}; create type TinySocial.FacebookMessageType as open { `message-id` : bigint -} +}; create dataset FacebookUsers(FacebookUserType) primary key id; create dataset FacebookMessages(FacebookMessageType) primary key `message-id`; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/aggregate/constant-gby-agg.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/aggregate/constant-gby-agg.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/aggregate/constant-gby-agg.sqlpp index b901447..cfedb7d 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/aggregate/constant-gby-agg.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/aggregate/constant-gby-agg.sqlpp @@ -26,21 +26,21 @@ use TinySocial; create type TinySocial.TwitterUserType as { `screen-name` : string -} +}; create type TinySocial.TweetMessageType as { tweetid : string -} +}; create type TinySocial.FacebookUserType as open { id : bigint -} +}; create type TinySocial.FacebookMessageType as open { `message-id` : bigint -} +}; create dataset FacebookUsers(FacebookUserType) primary key id; create dataset FacebookMessages(FacebookMessageType) primary key `message-id`; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/aggregate/count-dataset.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/aggregate/count-dataset.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/aggregate/count-dataset.sqlpp index c54962f..88f8cd8 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/aggregate/count-dataset.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/aggregate/count-dataset.sqlpp @@ -26,7 +26,7 @@ use TinySocial; create type TinySocial.FacebookUserType as open { id : bigint -} +}; create dataset FacebookUsers(FacebookUserType) primary key id; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/aggregate/list-dataset.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/aggregate/list-dataset.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/aggregate/list-dataset.sqlpp index a77a741..4e72848 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/aggregate/list-dataset.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/aggregate/list-dataset.sqlpp @@ -26,7 +26,7 @@ use TinySocial; create type TinySocial.FacebookUserType as open { id : bigint -} +}; create dataset FacebookUsers(FacebookUserType) primary key id; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/aggregate/query-ASTERIXDB-1626-2.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/aggregate/query-ASTERIXDB-1626-2.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/aggregate/query-ASTERIXDB-1626-2.sqlpp index 4247ef9..01a85d8 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/aggregate/query-ASTERIXDB-1626-2.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/aggregate/query-ASTERIXDB-1626-2.sqlpp @@ -27,7 +27,7 @@ use TinySocial; create type TinySocial.FacebookUserType as open { id : bigint -} +}; create dataset FacebookUsers(FacebookUserType) primary key id; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/aggregate/query-ASTERIXDB-1626-3.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/aggregate/query-ASTERIXDB-1626-3.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/aggregate/query-ASTERIXDB-1626-3.sqlpp index 6a81d64..50b799e 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/aggregate/query-ASTERIXDB-1626-3.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/aggregate/query-ASTERIXDB-1626-3.sqlpp @@ -27,7 +27,7 @@ use TinySocial; create type TinySocial.FacebookUserType as open { id : bigint -} +}; create dataset FacebookUsers(FacebookUserType) primary key id; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/aggregate/query-ASTERIXDB-1626.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/aggregate/query-ASTERIXDB-1626.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/aggregate/query-ASTERIXDB-1626.sqlpp index 7a19526..8f7a024 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/aggregate/query-ASTERIXDB-1626.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/aggregate/query-ASTERIXDB-1626.sqlpp @@ -27,7 +27,7 @@ use TinySocial; create type TinySocial.FacebookUserType as open { id : bigint -} +}; create dataset FacebookUsers(FacebookUserType) primary key id; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/btree-index-join/primary-between-join_01.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/btree-index-join/primary-between-join_01.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/btree-index-join/primary-between-join_01.sqlpp index 55afe6a..4622cd9 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/btree-index-join/primary-between-join_01.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/btree-index-join/primary-between-join_01.sqlpp @@ -26,7 +26,7 @@ create type TestType as open { key2: integer, fname : string, lname : string -} +}; create dataset DsOne(TestType) primary key key1; create dataset DsTwo(TestType) primary key key1; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/join-singletonbranch-2.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/join-singletonbranch-2.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/join-singletonbranch-2.sqlpp index 753b2d1..d6dbb98 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/join-singletonbranch-2.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/join-singletonbranch-2.sqlpp @@ -25,11 +25,11 @@ use test; create type FooType as { fid: integer -} +}; create type BarType as { bid: integer -} +}; create dataset Foo(FooType) primary key fid; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/join-singletonbranch-3.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/join-singletonbranch-3.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/join-singletonbranch-3.sqlpp index 687f9d0..f6d3acf 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/join-singletonbranch-3.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/join-singletonbranch-3.sqlpp @@ -25,11 +25,11 @@ use test; create type FooType as { fid: integer -} +}; create type BarType as { bid: integer -} +}; create dataset Foo(FooType) primary key fid; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/join-singletonbranch.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/join-singletonbranch.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/join-singletonbranch.sqlpp index cce9f91..1eb508c 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/join-singletonbranch.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/join-singletonbranch.sqlpp @@ -25,11 +25,11 @@ use test; create type FooType as { fid: integer -} +}; create type BarType as { bid: integer -} +}; create dataset Foo(FooType) primary key fid; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/loj-core.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/loj-core.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/loj-core.sqlpp index 2a5ed3a..d9834c3 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/loj-core.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/loj-core.sqlpp @@ -30,7 +30,7 @@ create type test.DBLPType as title : string, authors : string, misc : string -} +}; create type test.CSXType as closed { @@ -39,7 +39,7 @@ create type test.CSXType as title : string, authors : string, misc : string -} +}; create dataset DBLP(DBLPType) primary key id; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/loj-sugar.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/loj-sugar.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/loj-sugar.sqlpp index 1a952d6..98fa9a5 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/loj-sugar.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/loj-sugar.sqlpp @@ -30,7 +30,7 @@ create type test.DBLPType as title : string, authors : string, misc : string -} +}; create type test.CSXType as closed { @@ -39,7 +39,7 @@ create type test.CSXType as title : string, authors : string, misc : string -} +}; create dataset DBLP(DBLPType) primary key id; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-non-enforced/btree-equi-join-non-enforced/btree-equi-join-non-enforced-05.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-non-enforced/btree-equi-join-non-enforced/btree-equi-join-non-enforced-05.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-non-enforced/btree-equi-join-non-enforced/btree-equi-join-non-enforced-05.sqlpp index 175fa08..c8ad09c 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-non-enforced/btree-equi-join-non-enforced/btree-equi-join-non-enforced-05.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-non-enforced/btree-equi-join-non-enforced/btree-equi-join-non-enforced-05.sqlpp @@ -26,11 +26,11 @@ drop dataverse test if exists; create dataverse test; use test; -write output to asterix_nc1:"rttest/btree-equi-join-non-enforced_btree-equi-join-non-enforced-05.adm" +write output to asterix_nc1:"rttest/btree-equi-join-non-enforced_btree-equi-join-non-enforced-05.adm"; create type TestOpenType as open { c_id: int64 -} +}; create dataset TestOpen1(TestOpenType) primary key c_id; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-non-enforced/btree-equi-join-non-enforced/btree-equi-join-non-enforced-06.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-non-enforced/btree-equi-join-non-enforced/btree-equi-join-non-enforced-06.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-non-enforced/btree-equi-join-non-enforced/btree-equi-join-non-enforced-06.sqlpp index edff5ce..0fdf599 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-non-enforced/btree-equi-join-non-enforced/btree-equi-join-non-enforced-06.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-non-enforced/btree-equi-join-non-enforced/btree-equi-join-non-enforced-06.sqlpp @@ -25,11 +25,11 @@ drop dataverse test if exists; create dataverse test; use test; -write output to asterix_nc1:"rttest/btree-equi-join-non-enforced_btree-equi-join-non-enforced-06.adm" +write output to asterix_nc1:"rttest/btree-equi-join-non-enforced_btree-equi-join-non-enforced-06.adm"; create type TestOpenType as open { c_id: int64 -} +}; create dataset TestOpen1(TestOpenType) primary key c_id; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-non-enforced/btree-equi-join-non-enforced/btree-equi-join-non-enforced-07.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-non-enforced/btree-equi-join-non-enforced/btree-equi-join-non-enforced-07.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-non-enforced/btree-equi-join-non-enforced/btree-equi-join-non-enforced-07.sqlpp index 32f4c5a..2ceb8d8 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-non-enforced/btree-equi-join-non-enforced/btree-equi-join-non-enforced-07.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-non-enforced/btree-equi-join-non-enforced/btree-equi-join-non-enforced-07.sqlpp @@ -25,11 +25,11 @@ drop dataverse test if exists; create dataverse test; use test; -write output to asterix_nc1:"rttest/btree-equi-join-non-enforced_btree-equi-join-non-enforced-07.adm" +write output to asterix_nc1:"rttest/btree-equi-join-non-enforced_btree-equi-join-non-enforced-07.adm"; create type TestOpenType as open { c_id: int64 -} +}; create dataset TestOpen1(TestOpenType) primary key c_id; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-non-enforced/btree-equi-join-non-enforced/btree-equi-join-non-enforced-08.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-non-enforced/btree-equi-join-non-enforced/btree-equi-join-non-enforced-08.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-non-enforced/btree-equi-join-non-enforced/btree-equi-join-non-enforced-08.sqlpp index aef434a..40c1bc3 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-non-enforced/btree-equi-join-non-enforced/btree-equi-join-non-enforced-08.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-non-enforced/btree-equi-join-non-enforced/btree-equi-join-non-enforced-08.sqlpp @@ -26,11 +26,11 @@ drop dataverse test if exists; create dataverse test; use test; -write output to asterix_nc1:"rttest/btree-equi-join-non-enforced_btree-equi-join-non-enforced-08.adm" +write output to asterix_nc1:"rttest/btree-equi-join-non-enforced_btree-equi-join-non-enforced-08.adm"; create type TestOpenType as open { c_id: int64 -} +}; create dataset TestOpen1(TestOpenType) primary key c_id; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-non-enforced/btree-equi-join-non-enforced/btree-equi-join-non-enforced-09.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-non-enforced/btree-equi-join-non-enforced/btree-equi-join-non-enforced-09.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-non-enforced/btree-equi-join-non-enforced/btree-equi-join-non-enforced-09.sqlpp index a8b24b1..510f2df 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-non-enforced/btree-equi-join-non-enforced/btree-equi-join-non-enforced-09.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-non-enforced/btree-equi-join-non-enforced/btree-equi-join-non-enforced-09.sqlpp @@ -26,11 +26,11 @@ drop dataverse test if exists; create dataverse test; use test; -write output to asterix_nc1:"rttest/btree-equi-join-non-enforced_btree-equi-join-non-enforced-08.adm" +write output to asterix_nc1:"rttest/btree-equi-join-non-enforced_btree-equi-join-non-enforced-08.adm"; create type TestOpenType as open { c_id: int64 -} +}; create dataset TestOpen1(TestOpenType) primary key c_id; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-non-enforced/btree-index-non-enforced/btree-index-non-enforced-04.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-non-enforced/btree-index-non-enforced/btree-index-non-enforced-04.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-non-enforced/btree-index-non-enforced/btree-index-non-enforced-04.sqlpp index 5d804b9..86a04a2 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-non-enforced/btree-index-non-enforced/btree-index-non-enforced-04.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-non-enforced/btree-index-non-enforced/btree-index-non-enforced-04.sqlpp @@ -27,11 +27,11 @@ drop dataverse test if exists; create dataverse test; use test; -write output to asterix_nc1:"rttest/btree-index-non-enforced_btree-index-non-enforced-04.adm" +write output to asterix_nc1:"rttest/btree-index-non-enforced_btree-index-non-enforced-04.adm"; create type TestOpenType as open { c_id: int64 -} +}; create dataset TestOpen(TestOpenType) primary key c_id; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-non-enforced/btree-index-non-enforced/btree-index-non-enforced-05.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-non-enforced/btree-index-non-enforced/btree-index-non-enforced-05.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-non-enforced/btree-index-non-enforced/btree-index-non-enforced-05.sqlpp index 2818002..83ae02a 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-non-enforced/btree-index-non-enforced/btree-index-non-enforced-05.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-non-enforced/btree-index-non-enforced/btree-index-non-enforced-05.sqlpp @@ -27,11 +27,11 @@ drop dataverse test if exists; create dataverse test; use test; -write output to asterix_nc1:"rttest/btree-index-non-enforced_btree-index-non-enforced-05.adm" +write output to asterix_nc1:"rttest/btree-index-non-enforced_btree-index-non-enforced-05.adm"; create type TestOpenType as open { c_id: int64 -} +}; create dataset TestOpen(TestOpenType) primary key c_id; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-non-enforced/btree-index-non-enforced/btree-index-non-enforced-06.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-non-enforced/btree-index-non-enforced/btree-index-non-enforced-06.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-non-enforced/btree-index-non-enforced/btree-index-non-enforced-06.sqlpp index 7bff919..b8cdcd0 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-non-enforced/btree-index-non-enforced/btree-index-non-enforced-06.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-non-enforced/btree-index-non-enforced/btree-index-non-enforced-06.sqlpp @@ -27,11 +27,11 @@ drop dataverse test if exists; create dataverse test; use test; -write output to asterix_nc1:"rttest/btree-index-non-enforced_btree-index-non-enforced-06.adm" +write output to asterix_nc1:"rttest/btree-index-non-enforced_btree-index-non-enforced-06.adm"; create type TestOpenType as open { c_id: int64 -} +}; create dataset TestOpen(TestOpenType) primary key c_id; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-non-enforced/btree-index-non-enforced/btree-index-non-enforced-07.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-non-enforced/btree-index-non-enforced/btree-index-non-enforced-07.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-non-enforced/btree-index-non-enforced/btree-index-non-enforced-07.sqlpp index fe78300..b84796b 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-non-enforced/btree-index-non-enforced/btree-index-non-enforced-07.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-non-enforced/btree-index-non-enforced/btree-index-non-enforced-07.sqlpp @@ -27,11 +27,11 @@ drop dataverse test if exists; create dataverse test; use test; -write output to asterix_nc1:"rttest/btree-index-non-enforced_btree-index-non-enforced-07.adm" +write output to asterix_nc1:"rttest/btree-index-non-enforced_btree-index-non-enforced-07.adm"; create type TestOpenType as open { c_id: int64 -} +}; create dataset TestOpen(TestOpenType) primary key c_id; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-non-enforced/btree-index-non-enforced/btree-index-non-enforced-08.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-non-enforced/btree-index-non-enforced/btree-index-non-enforced-08.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-non-enforced/btree-index-non-enforced/btree-index-non-enforced-08.sqlpp index 0116c95..9659d6c 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-non-enforced/btree-index-non-enforced/btree-index-non-enforced-08.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-non-enforced/btree-index-non-enforced/btree-index-non-enforced-08.sqlpp @@ -27,11 +27,11 @@ drop dataverse test if exists; create dataverse test; use test; -write output to asterix_nc1:"rttest/btree-index-non-enforced_btree-index-non-enforced-08.adm" +write output to asterix_nc1:"rttest/btree-index-non-enforced_btree-index-non-enforced-08.adm"; create type TestOpenType as open { c_id: int64 -} +}; create dataset TestOpen(TestOpenType) primary key c_id; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-non-enforced/btree-index-non-enforced/btree-index-non-enforced-09.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-non-enforced/btree-index-non-enforced/btree-index-non-enforced-09.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-non-enforced/btree-index-non-enforced/btree-index-non-enforced-09.sqlpp index 2c39be5..39414d0 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-non-enforced/btree-index-non-enforced/btree-index-non-enforced-09.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-non-enforced/btree-index-non-enforced/btree-index-non-enforced-09.sqlpp @@ -27,11 +27,11 @@ drop dataverse test if exists; create dataverse test; use test; -write output to asterix_nc1:"rttest/btree-index-non-enforced_btree-index-non-enforced-09.adm" +write output to asterix_nc1:"rttest/btree-index-non-enforced_btree-index-non-enforced-09.adm"; create type TestOpenType as open { c_id: int64 -} +}; create dataset TestOpen(TestOpenType) primary key c_id; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-non-enforced/btree-index-non-enforced/btree-index-non-enforced-10.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-non-enforced/btree-index-non-enforced/btree-index-non-enforced-10.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-non-enforced/btree-index-non-enforced/btree-index-non-enforced-10.sqlpp index f3519ab..18b75ef 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-non-enforced/btree-index-non-enforced/btree-index-non-enforced-10.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-non-enforced/btree-index-non-enforced/btree-index-non-enforced-10.sqlpp @@ -27,11 +27,11 @@ drop dataverse test if exists; create dataverse test; use test; -write output to asterix_nc1:"rttest/btree-index-non-enforced_btree-index-non-enforced-10.adm" +write output to asterix_nc1:"rttest/btree-index-non-enforced_btree-index-non-enforced-10.adm"; create type TestOpenType as open { c_id: int64 -} +}; create dataset TestOpen(TestOpenType) primary key c_id; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-non-enforced/btree-index-non-enforced/btree-index-non-enforced-105.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-non-enforced/btree-index-non-enforced/btree-index-non-enforced-105.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-non-enforced/btree-index-non-enforced/btree-index-non-enforced-105.sqlpp index 0ef985e..e34f931 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-non-enforced/btree-index-non-enforced/btree-index-non-enforced-105.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-non-enforced/btree-index-non-enforced/btree-index-non-enforced-105.sqlpp @@ -28,11 +28,11 @@ drop dataverse test if exists; create dataverse test; use test; -write output to asterix_nc1:"rttest/btree-index-non-enforced_btree-index-non-enforced-104.adm" +write output to asterix_nc1:"rttest/btree-index-non-enforced_btree-index-non-enforced-104.adm"; create type TestOpenType as open { c_id: int64 -} +}; create dataset TestOpen(TestOpenType) primary key c_id; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-non-enforced/btree-index-non-enforced/btree-index-non-enforced-11.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-non-enforced/btree-index-non-enforced/btree-index-non-enforced-11.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-non-enforced/btree-index-non-enforced/btree-index-non-enforced-11.sqlpp index 0032524..f4d2a2d 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-non-enforced/btree-index-non-enforced/btree-index-non-enforced-11.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-non-enforced/btree-index-non-enforced/btree-index-non-enforced-11.sqlpp @@ -27,11 +27,11 @@ drop dataverse test if exists; create dataverse test; use test; -write output to asterix_nc1:"rttest/btree-index-non-enforced_btree-index-non-enforced-11.adm" +write output to asterix_nc1:"rttest/btree-index-non-enforced_btree-index-non-enforced-11.adm"; create type TestOpenType as open { c_id: int64 -} +}; create dataset TestOpen(TestOpenType) primary key c_id; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/query-ASTERIXDB-159-3.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/query-ASTERIXDB-159-3.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/query-ASTERIXDB-159-3.sqlpp index a41fb6d..8da16a0 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/query-ASTERIXDB-159-3.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/query-ASTERIXDB-159-3.sqlpp @@ -25,7 +25,7 @@ use TinySocial; create type TinySocial.FacebookUserType as open { id : bigint -} +}; create dataset FacebookUsers(FacebookUserType) primary key id; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/query-ASTERIXDB-1671.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/query-ASTERIXDB-1671.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/query-ASTERIXDB-1671.sqlpp index 33b40b2..088e819 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/query-ASTERIXDB-1671.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/query-ASTERIXDB-1671.sqlpp @@ -26,7 +26,7 @@ USE tpch; CREATE TYPE LineItemType AS { l_orderkey : bigint, l_linenumber : bigint -} +}; CREATE DATASET LineItem(LineItemType) PRIMARY KEY l_orderkey,l_linenumber; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/query-ASTERIXDB-1806.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/query-ASTERIXDB-1806.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/query-ASTERIXDB-1806.sqlpp index b7ab318..063ebff 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/query-ASTERIXDB-1806.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/query-ASTERIXDB-1806.sqlpp @@ -46,7 +46,7 @@ create type LineItemType as l_shipinstruct : string, l_shipmode : string, l_comment : string -} +}; create dataset LineItem(LineItemType) primary key l_orderkey,l_linenumber; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/query-ASTERIXDB-810-2.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/query-ASTERIXDB-810-2.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/query-ASTERIXDB-810-2.sqlpp index b6f6159..a05087b 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/query-ASTERIXDB-810-2.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/query-ASTERIXDB-810-2.sqlpp @@ -46,7 +46,7 @@ CREATE TYPE LineItemType AS CLOSED { l_shipinstruct : string, l_shipmode : string, l_comment : string -} +}; CREATE DATASET LineItem(LineItemType) PRIMARY KEY l_orderkey,l_linenumber; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/query-ASTERIXDB-810.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/query-ASTERIXDB-810.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/query-ASTERIXDB-810.sqlpp index 451f163..0a46e9a 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/query-ASTERIXDB-810.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/query-ASTERIXDB-810.sqlpp @@ -46,7 +46,7 @@ CREATE TYPE LineItemType AS CLOSED { l_shipinstruct : string, l_shipmode : string, l_comment : string -} +}; CREATE DATASET LineItem(LineItemType) PRIMARY KEY l_orderkey,l_linenumber; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/subquery/exists.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/subquery/exists.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/subquery/exists.sqlpp index a38359d..74573b9 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/subquery/exists.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/subquery/exists.sqlpp @@ -32,7 +32,7 @@ CREATE TYPE OrderType AS CLOSED { o_clerk: string, o_shippriority: integer, o_comment: string -} +}; CREATE TYPE CustomerType AS CLOSED { c_custkey: integer, @@ -43,7 +43,7 @@ CREATE TYPE CustomerType AS CLOSED { c_acctbal: double, c_mktsegment: string, c_comment: string -} +}; CREATE EXTERNAL DATASET Customer(CustomerType) USING `localfs` ((`path`=`asterix_nc1://data/tpch0.001/customer.tbl`), http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/subquery/in.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/subquery/in.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/subquery/in.sqlpp index 270c81a..0a11b07 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/subquery/in.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/subquery/in.sqlpp @@ -24,11 +24,11 @@ USE test; CREATE TYPE OrderType AS { o_orderkey: integer -} +}; CREATE TYPE CustomerType AS { c_custkey: integer -} +}; CREATE COLLECTION Customers(CustomerType) PRIMARY KEY c_custkey; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/subquery/in_correlated.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/subquery/in_correlated.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/subquery/in_correlated.sqlpp index dfbef68..55a63f8 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/subquery/in_correlated.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/subquery/in_correlated.sqlpp @@ -25,11 +25,11 @@ USE test; CREATE TYPE OrderType AS { o_orderkey: integer -} +}; CREATE TYPE CustomerType AS { c_custkey: integer -} +}; CREATE COLLECTION Customers(CustomerType) PRIMARY KEY c_custkey; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/subquery/not_exists.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/subquery/not_exists.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/subquery/not_exists.sqlpp index f31b7c1..0dfdea0 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/subquery/not_exists.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/subquery/not_exists.sqlpp @@ -32,7 +32,7 @@ CREATE TYPE OrderType AS CLOSED { o_clerk: string, o_shippriority: integer, o_comment: string -} +}; CREATE TYPE CustomerType AS CLOSED { c_custkey: integer, @@ -43,7 +43,7 @@ CREATE TYPE CustomerType AS CLOSED { c_acctbal: double, c_mktsegment: string, c_comment: string -} +}; CREATE EXTERNAL DATASET Customer(CustomerType) USING `localfs` ((`path`=`asterix_nc1://data/tpch0.001/customer.tbl`), http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/tpcds/query-ASTERIXDB-1580.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/tpcds/query-ASTERIXDB-1580.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/tpcds/query-ASTERIXDB-1580.sqlpp index fc72375..ce6ce07 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/tpcds/query-ASTERIXDB-1580.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/tpcds/query-ASTERIXDB-1580.sqlpp @@ -36,7 +36,7 @@ create type tpcds.customer_address_type as closed { ca_country: string?, ca_gmt_offset: double?, ca_location_type: string? -} +}; create type tpcds.customer_type as closed { c_customer_sk: bigint, @@ -57,7 +57,7 @@ create type tpcds.customer_type as closed { c_login: string?, c_email_address: string?, c_last_review_date: string? -} +}; create type tpcds.store_sales_type as closed { ss_sold_date_sk: bigint?, @@ -83,7 +83,7 @@ create type tpcds.store_sales_type as closed { ss_net_paid: double?, ss_net_paid_inc_tax: double?, ss_net_profit: double? -} +}; create type tpcds.date_dim_type as closed { d_date_sk: bigint, @@ -114,7 +114,7 @@ create type tpcds.date_dim_type as closed { d_current_month: string?, d_current_quarter: string?, d_current_year: string? -} +}; create type tpcds.item_type as closed { i_item_sk: bigint, @@ -139,7 +139,7 @@ create type tpcds.item_type as closed { i_container: string?, i_manager_id: bigint?, i_product_name: string? -} +}; create dataset customer (customer_type) primary key c_customer_sk; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/tpcds/query-ASTERIXDB-1581-correlated.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/tpcds/query-ASTERIXDB-1581-correlated.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/tpcds/query-ASTERIXDB-1581-correlated.sqlpp index 39b3eac..a41f864 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/tpcds/query-ASTERIXDB-1581-correlated.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/tpcds/query-ASTERIXDB-1581-correlated.sqlpp @@ -46,7 +46,7 @@ create type tpcds.store_sales_type as closed { ss_net_paid: double?, ss_net_paid_inc_tax: double?, ss_net_profit: double? -} +}; create type tpcds.item_type as closed { @@ -72,7 +72,7 @@ create type tpcds.item_type as closed { i_container: string?, i_manager_id: bigint?, i_product_name: string? -} +}; create dataset store_sales (store_sales_type) primary key ss_item_sk, ss_ticket_number; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/tpcds/query-ASTERIXDB-1581.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/tpcds/query-ASTERIXDB-1581.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/tpcds/query-ASTERIXDB-1581.sqlpp index d736540..5c94fcf 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/tpcds/query-ASTERIXDB-1581.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/tpcds/query-ASTERIXDB-1581.sqlpp @@ -46,7 +46,7 @@ create type tpcds.store_sales_type as closed { ss_net_paid: double?, ss_net_paid_inc_tax: double?, ss_net_profit: double? -} +}; create type tpcds.item_type as closed { @@ -72,7 +72,7 @@ create type tpcds.item_type as closed { i_container: string?, i_manager_id: bigint?, i_product_name: string? -} +}; create dataset store_sales (store_sales_type) primary key ss_item_sk, ss_ticket_number; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/tpcds/query-ASTERIXDB-1591.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/tpcds/query-ASTERIXDB-1591.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/tpcds/query-ASTERIXDB-1591.sqlpp index 3886520..7608cdf 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/tpcds/query-ASTERIXDB-1591.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/tpcds/query-ASTERIXDB-1591.sqlpp @@ -38,7 +38,7 @@ create type customer_address_type as closed { ca_country: string?, ca_gmt_offset: double?, ca_location_type: string? -} +}; create type customer_type as closed { c_customer_sk: bigint, @@ -59,7 +59,7 @@ create type customer_type as closed { c_login: string?, c_email_address: string?, c_last_review_date: string? -} +}; create type store_sales_type as closed { ss_sold_date_sk: bigint?, @@ -85,7 +85,7 @@ create type store_sales_type as closed { ss_net_paid: double?, ss_net_paid_inc_tax: double?, ss_net_profit: double? -} +}; create type catalog_sales_type as closed { cs_sold_date_sk: bigint?, @@ -122,7 +122,7 @@ create type catalog_sales_type as closed { cs_net_paid_inc_ship: double?, cs_net_paid_inc_ship_tax: double?, cs_net_profit: double? -} +}; create type catalog_returns_type as closed { cr_returned_date_sk: bigint?, @@ -152,7 +152,7 @@ create type catalog_returns_type as closed { cr_reversed_charge: double?, cr_store_credit: double?, cr_net_loss: double? -} +}; create type tpcds.date_dim_type as closed { d_date_sk: bigint, @@ -183,7 +183,7 @@ create type tpcds.date_dim_type as closed { d_current_month: string?, d_current_quarter: string?, d_current_year: string? -} +}; create type item_type as closed { i_item_sk: bigint, @@ -208,7 +208,7 @@ create type item_type as closed { i_container: string?, i_manager_id: bigint?, i_product_name: string? -} +}; create type web_sales_type as closed { ws_sold_date_sk: bigint?, @@ -245,7 +245,7 @@ create type web_sales_type as closed { ws_net_paid_inc_ship: double?, ws_net_paid_inc_ship_tax: double?, ws_net_profit: double? -} +}; create dataset customer (customer_type) primary key c_customer_sk; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/tpcds/query-ASTERIXDB-1596.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/tpcds/query-ASTERIXDB-1596.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/tpcds/query-ASTERIXDB-1596.sqlpp index a953e59..2308340 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/tpcds/query-ASTERIXDB-1596.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/tpcds/query-ASTERIXDB-1596.sqlpp @@ -57,7 +57,7 @@ create type tpcds.catalog_sales_type as closed { cs_net_paid_inc_ship: double?, cs_net_paid_inc_ship_tax: double?, cs_net_profit: double? -} +}; create type tpcds.catalog_returns_type as closed { cr_returned_date_sk: bigint?, @@ -87,7 +87,7 @@ create type tpcds.catalog_returns_type as closed { cr_reversed_charge: double?, cr_store_credit: double?, cr_net_loss: double? -} +}; create type tpcds.item_type as closed { i_item_sk: bigint, @@ -112,7 +112,7 @@ create type tpcds.item_type as closed { i_container: string?, i_manager_id: bigint?, i_product_name: string? -} +}; create dataset catalog_sales (catalog_sales_type) primary key cs_item_sk, cs_order_number; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/tpch/q12_shipping.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/tpch/q12_shipping.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/tpch/q12_shipping.sqlpp index e1d10e1..70581d8 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/tpch/q12_shipping.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/tpch/q12_shipping.sqlpp @@ -26,11 +26,11 @@ USE tpch; CREATE TYPE LineItemType AS { l_linenumber : integer -} +}; CREATE TYPE OrderType AS { o_orderkey : integer -} +}; CREATE DATASET LineItem(LineItemType) PRIMARY KEY l_linenumber; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/tpch/q12_shipping_broadcast.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/tpch/q12_shipping_broadcast.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/tpch/q12_shipping_broadcast.sqlpp index 94b5d2b..9add5d3 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/tpch/q12_shipping_broadcast.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/tpch/q12_shipping_broadcast.sqlpp @@ -26,11 +26,11 @@ USE tpch; CREATE TYPE LineItemType AS { l_linenumber : integer -} +}; CREATE TYPE OrderType AS { o_orderkey : integer -} +}; CREATE DATASET LineItem(LineItemType) PRIMARY KEY l_linenumber; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/leftouterjoin-probe-pidx-with-join-btree-sidx_01.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/leftouterjoin-probe-pidx-with-join-btree-sidx_01.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/leftouterjoin-probe-pidx-with-join-btree-sidx_01.sqlpp index bf58b28..fc99d0b 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/leftouterjoin-probe-pidx-with-join-btree-sidx_01.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/leftouterjoin-probe-pidx-with-join-btree-sidx_01.sqlpp @@ -37,7 +37,7 @@ create type test.TwitterUserType as `statuses-count` : integer, name : string, `followers-count` : integer -} +}; create type test.TweetMessageType as closed { @@ -49,7 +49,7 @@ create type test.TweetMessageType as `message-text` : string, countA : integer, countB : integer -} +}; create dataset TweetMessages(TweetMessageType) primary key tweetid; @@ -61,7 +61,7 @@ create index msgCountBIx on TweetMessages (countB) type btree; create index msgTextIx on TweetMessages (`message-text`) type keyword; -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/btree-index-join/leftouterjoin-probe-pidx-with-join-btree-sidx_02.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/leftouterjoin-probe-pidx-with-join-btree-sidx_02.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/leftouterjoin-probe-pidx-with-join-btree-sidx_02.sqlpp index 0d0933d..96e43a9 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/leftouterjoin-probe-pidx-with-join-btree-sidx_02.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/leftouterjoin-probe-pidx-with-join-btree-sidx_02.sqlpp @@ -37,7 +37,7 @@ create type test.TwitterUserType as `statuses-count` : integer, name : string, `followers-count` : integer -} +}; create type test.TweetMessageType as closed { @@ -49,7 +49,7 @@ create type test.TweetMessageType as `message-text` : string, countA : integer, countB : integer -} +}; create dataset TweetMessages(TweetMessageType) primary key tweetid; @@ -61,7 +61,7 @@ create index msgCountBIx on TweetMessages (countB) type btree; create index msgTextIx on TweetMessages (`message-text`) type keyword; -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/btree-index-join/primary-composite-key-join_01.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-composite-key-join_01.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-composite-key-join_01.sqlpp index 7d521a1..f00eeeb 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-composite-key-join_01.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-composite-key-join_01.sqlpp @@ -33,11 +33,11 @@ create type test.Name as { fname : string, lname : string -} +}; create dataset Names(Name) primary key fname,lname; -write output to asterix_nc1:"rttest/btree-index-join_primary-composite-key-prefix-join_01.adm" +write output to asterix_nc1:"rttest/btree-index-join_primary-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/btree-index-join/primary-composite-key-join_02.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-composite-key-join_02.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-composite-key-join_02.sqlpp index 00fa3f1..c12df2e 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-composite-key-join_02.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-composite-key-join_02.sqlpp @@ -33,11 +33,11 @@ create type test.Name as { fname : string, lname : string -} +}; create dataset Names(Name) primary key fname,lname; -write output to asterix_nc1:"rttest/btree-index-join_primary-composite-key-prefix-join_02.adm" +write output to asterix_nc1:"rttest/btree-index-join_primary-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/btree-index-join/primary-composite-key-join_03.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-composite-key-join_03.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-composite-key-join_03.sqlpp index 0ed7290..fa95763 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-composite-key-join_03.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-composite-key-join_03.sqlpp @@ -33,11 +33,11 @@ create type test.Name as { fname : string, lname : string -} +}; create dataset Names(Name) primary key fname,lname; -write output to asterix_nc1:"rttest/btree-index-join_primary-composite-key-prefix-join_03.adm" +write output to asterix_nc1:"rttest/btree-index-join_primary-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/btree-index-join/primary-composite-key-prefix-join_01.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-composite-key-prefix-join_01.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-composite-key-prefix-join_01.sqlpp index b068383..fdc5d9b 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-composite-key-prefix-join_01.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-composite-key-prefix-join_01.sqlpp @@ -33,11 +33,11 @@ create type test.Name as { fname : string, lname : string -} +}; create dataset Names(Name) primary key fname,lname; -write output to asterix_nc1:"rttest/btree-index-join_primary-composite-key-prefix-prefix-join_01.adm" +write output to asterix_nc1:"rttest/btree-index-join_primary-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/btree-index-join/primary-composite-key-prefix-join_02.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-composite-key-prefix-join_02.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-composite-key-prefix-join_02.sqlpp index 0ff28d4..285affd 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-composite-key-prefix-join_02.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-composite-key-prefix-join_02.sqlpp @@ -33,11 +33,11 @@ create type test.Name as { fname : string, lname : string -} +}; create dataset Names(Name) primary key fname,lname; -write output to asterix_nc1:"rttest/btree-index-join_primary-composite-key-prefix-prefix-join_02.adm" +write output to asterix_nc1:"rttest/btree-index-join_primary-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/btree-index-join/primary-composite-key-prefix-join_03.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-composite-key-prefix-join_03.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-composite-key-prefix-join_03.sqlpp index ee75dbe..61268a4 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-composite-key-prefix-join_03.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-composite-key-prefix-join_03.sqlpp @@ -33,11 +33,11 @@ create type test.Name as { fname : string, lname : string -} +}; create dataset Names(Name) primary key fname,lname; -write output to asterix_nc1:"rttest/btree-index-join_primary-composite-key-prefix-prefix-join_03.adm" +write output to asterix_nc1:"rttest/btree-index-join_primary-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/btree-index-join/primary-composite-key-prefix-join_04.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-composite-key-prefix-join_04.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-composite-key-prefix-join_04.sqlpp index e611b42..83feb01 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-composite-key-prefix-join_04.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-composite-key-prefix-join_04.sqlpp @@ -33,11 +33,11 @@ create type test.Name as { fname : string, lname : string -} +}; create dataset Names(Name) primary key fname,lname; -write output to asterix_nc1:"rttest/btree-index-join_primary-composite-key-prefix-prefix-join_04.adm" +write output to asterix_nc1:"rttest/btree-index-join_primary-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/btree-index-join/primary-composite-key-prefix-join_05.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-composite-key-prefix-join_05.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-composite-key-prefix-join_05.sqlpp index 5762a92..dab1456 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-composite-key-prefix-join_05.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-composite-key-prefix-join_05.sqlpp @@ -33,11 +33,11 @@ create type test.Name as { fname : string, lname : string -} +}; create dataset Names(Name) primary key fname,lname; -write output to asterix_nc1:"rttest/btree-index-join_primary-composite-key-prefix-prefix-join_05.adm" +write output to asterix_nc1:"rttest/btree-index-join_primary-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/btree-index-join/primary-composite-key-prefix-join_06.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-composite-key-prefix-join_06.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-composite-key-prefix-join_06.sqlpp index cdac8fc..54a57dd 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-composite-key-prefix-join_06.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-composite-key-prefix-join_06.sqlpp @@ -33,11 +33,11 @@ create type test.Name as { fname : string, lname : string -} +}; create dataset Names(Name) primary key fname,lname; -write output to asterix_nc1:"rttest/btree-index-join_primary-composite-key-prefix-prefix-join_06.adm" +write output to asterix_nc1:"rttest/btree-index-join_primary-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/btree-index-join/primary-equi-join-multipred.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-equi-join-multipred.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-equi-join-multipred.sqlpp index 81d06b1..7cf8561 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-equi-join-multipred.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-equi-join-multipred.sqlpp @@ -36,7 +36,7 @@ create type test.AddressType as number : integer, street : string, city : string -} +}; create type test.CustomerType as closed { @@ -49,7 +49,7 @@ create type test.CustomerType as total : float } -} +}; create type test.OrderType as closed { @@ -59,13 +59,13 @@ create type test.OrderType as orderpriority : string, clerk : string, total : float -} +}; create dataset Customers(CustomerType) primary key cid; create dataset Orders(OrderType) primary key oid; -write output to asterix_nc1:"rttest/btree-index-join_primary-equi-join-multipred.adm" +write output to asterix_nc1:"rttest/btree-index-join_primary-equi-join-multipred.adm"; select element {'customer':c,'order':o} from Customers as c, Orders as o http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-equi-join-neg_01.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-equi-join-neg_01.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-equi-join-neg_01.sqlpp index 07044bb..ab8d14a 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-equi-join-neg_01.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-equi-join-neg_01.sqlpp @@ -32,13 +32,13 @@ create type test1.TestType as key2 : integer, fname : string, lname : string -} +}; create dataset test1.DsOne(TestType) primary key key1; create dataset test1.DsTwo(TestType) primary key key1; -write output to asterix_nc1:"rttest/btree-index-join_primary-equi-join-neg_01.adm" +write output to asterix_nc1:"rttest/btree-index-join_primary-equi-join-neg_01.adm"; select element x from `test1.DsOne` as x, `test1.DsTwo` as y http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-equi-join-neg_02.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-equi-join-neg_02.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-equi-join-neg_02.sqlpp index 33fa8a8..bd7d7b2 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-equi-join-neg_02.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-equi-join-neg_02.sqlpp @@ -32,13 +32,13 @@ create type test1.TestType as key2 : integer, fname : string, lname : string -} +}; create dataset test1.DsOne(TestType) primary key key1; create dataset test1.DsTwo(TestType) primary key key1; -write output to asterix_nc1:"rttest/btree-index-join_primary-equi-join-neg_02.adm" +write output to asterix_nc1:"rttest/btree-index-join_primary-equi-join-neg_02.adm"; select element x from `test1.DsOne` as x, `test1.DsTwo` as y http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-equi-join_01.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-equi-join_01.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-equi-join_01.sqlpp index 8be3a29..5313576 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-equi-join_01.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-equi-join_01.sqlpp @@ -32,13 +32,13 @@ create type test1.TestType as key2 : integer, fname : string, lname : string -} +}; create dataset test1.DsOne(TestType) primary key key1; create dataset test1.DsTwo(TestType) primary key key1; -write output to asterix_nc1:"rttest/btree-index-join_primary-equi-join_01.adm" +write output to asterix_nc1:"rttest/btree-index-join_primary-equi-join_01.adm"; select element x from `test1.DsOne` as x, `test1.DsTwo` as y http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-equi-join_02.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-equi-join_02.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-equi-join_02.sqlpp index 8771300..a3740b6 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-equi-join_02.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-equi-join_02.sqlpp @@ -32,13 +32,13 @@ create type test1.TestType as key2 : integer, fname : string, lname : string -} +}; create dataset test1.DsOne(TestType) primary key key1; create dataset test1.DsTwo(TestType) primary key key1; -write output to asterix_nc1:"rttest/btree-index-join_primary-equi-join_02.adm" +write output to asterix_nc1:"rttest/btree-index-join_primary-equi-join_02.adm"; select element x from `test1.DsOne` as x, `test1.DsTwo` as y http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-equi-join_03.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-equi-join_03.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-equi-join_03.sqlpp index 9d70e51..9d1aaf3 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-equi-join_03.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-equi-join_03.sqlpp @@ -34,7 +34,7 @@ create type test.AddressType as number : integer, street : string, city : string -} +}; create type test.CustomerType as closed { @@ -47,7 +47,7 @@ create type test.CustomerType as total : float } -} +}; create type test.OrderType as closed { @@ -57,13 +57,13 @@ create type test.OrderType as orderpriority : string, clerk : string, total : float -} +}; create dataset Customers(CustomerType) primary key cid; create dataset Orders(OrderType) primary key oid; -write output to asterix_nc1:"rttest/btree-index-join_primary-equi-join_04.adm" +write output to asterix_nc1:"rttest/btree-index-join_primary-equi-join_04.adm"; select element {'customer':c,'order':o} from Customers as c, Orders as o http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-equi-join_04.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-equi-join_04.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-equi-join_04.sqlpp index cd0f18f..e465dc4 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-equi-join_04.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-equi-join_04.sqlpp @@ -34,7 +34,7 @@ create type test.AddressType as number : integer, street : string, city : string -} +}; create type test.CustomerType as closed { @@ -47,7 +47,7 @@ create type test.CustomerType as total : float } -} +}; create type test.OrderType as closed { @@ -57,13 +57,13 @@ create type test.OrderType as orderpriority : string, clerk : string, total : float -} +}; create dataset Customers(CustomerType) primary key cid; create dataset Orders(OrderType) primary key oid; -write output to asterix_nc1:"rttest/btree-index-join_primary-equi-join_05.adm" +write output to asterix_nc1:"rttest/btree-index-join_primary-equi-join_05.adm"; select element {'customer':c,'order':o} from Orders as o, Customers as c http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-equi-join_05.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-equi-join_05.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-equi-join_05.sqlpp index 50d3c22..75f6bdd 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-equi-join_05.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-equi-join_05.sqlpp @@ -34,7 +34,7 @@ create type test.AddressType as number : integer, street : string, city : string -} +}; create type test.CustomerType as closed { @@ -47,11 +47,11 @@ create type test.CustomerType as total : float } -} +}; create dataset Customers(CustomerType) primary key cid; -write output to asterix_nc1:"rttest/btree-index-join_primary-equi-join_06.adm" +write output to asterix_nc1:"rttest/btree-index-join_primary-equi-join_06.adm"; select element {'customer1':c1,'customer2':c2} from Customers as c1, Customers as c2 http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-ge-join_01.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-ge-join_01.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-ge-join_01.sqlpp index 531ae70..6c1a30a 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-ge-join_01.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-ge-join_01.sqlpp @@ -32,13 +32,13 @@ create type test1.TestType as key2 : integer, fname : string, lname : string -} +}; create dataset test1.DsOne(TestType) primary key key1; create dataset test1.DsTwo(TestType) primary key key1; -write output to asterix_nc1:"rttest/btree-index-join_primary-ge-join_01.adm" +write output to asterix_nc1:"rttest/btree-index-join_primary-ge-join_01.adm"; select element x from `test1.DsOne` as x, `test1.DsTwo` as y http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-ge-join_02.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-ge-join_02.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-ge-join_02.sqlpp index 9da023e..954b3a6 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-ge-join_02.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-ge-join_02.sqlpp @@ -32,13 +32,13 @@ create type test1.TestType as key2 : integer, fname : string, lname : string -} +}; create dataset test1.DsOne(TestType) primary key key1; create dataset test1.DsTwo(TestType) primary key key1; -write output to asterix_nc1:"rttest/btree-index-join_primary-ge-join_02.adm" +write output to asterix_nc1:"rttest/btree-index-join_primary-ge-join_02.adm"; select element x from `test1.DsOne` as x, `test1.DsTwo` as y http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-gt-join_01.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-gt-join_01.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-gt-join_01.sqlpp index c4a1aa4..8763a0d 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-gt-join_01.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-gt-join_01.sqlpp @@ -32,13 +32,13 @@ create type test1.TestType as key2 : integer, fname : string, lname : string -} +}; create dataset test1.DsOne(TestType) primary key key1; create dataset test1.DsTwo(TestType) primary key key1; -write output to asterix_nc1:"rttest/btree-index-join_primary-gt-join_01.adm" +write output to asterix_nc1:"rttest/btree-index-join_primary-gt-join_01.adm"; select element x from `test1.DsOne` as x, `test1.DsTwo` as y http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-gt-join_02.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-gt-join_02.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-gt-join_02.sqlpp index 6c10a54..748bfb0 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-gt-join_02.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-gt-join_02.sqlpp @@ -32,13 +32,13 @@ create type test1.TestType as key2 : integer, fname : string, lname : string -} +}; create dataset test1.DsOne(TestType) primary key key1; create dataset test1.DsTwo(TestType) primary key key1; -write output to asterix_nc1:"rttest/btree-index-join_primary-gt-join_02.adm" +write output to asterix_nc1:"rttest/btree-index-join_primary-gt-join_02.adm"; select element x from `test1.DsOne` as x, `test1.DsTwo` as y http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-le-join_01.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-le-join_01.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-le-join_01.sqlpp index 77227a6..0e99c88 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-le-join_01.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-le-join_01.sqlpp @@ -32,13 +32,13 @@ create type test1.TestType as key2 : integer, fname : string, lname : string -} +}; create dataset test1.DsOne(TestType) primary key key1; create dataset test1.DsTwo(TestType) primary key key1; -write output to asterix_nc1:"rttest/btree-index-join_primary-le-join_01.adm" +write output to asterix_nc1:"rttest/btree-index-join_primary-le-join_01.adm"; select element x from `test1.DsOne` as x, `test1.DsTwo` as y http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-le-join_02.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-le-join_02.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-le-join_02.sqlpp index 541c0eb..2eb1dde 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-le-join_02.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-le-join_02.sqlpp @@ -32,13 +32,13 @@ create type test1.TestType as key2 : integer, fname : string, lname : string -} +}; create dataset test1.DsOne(TestType) primary key key1; create dataset test1.DsTwo(TestType) primary key key1; -write output to asterix_nc1:"rttest/btree-index-join_primary-le-join_02.adm" +write output to asterix_nc1:"rttest/btree-index-join_primary-le-join_02.adm"; select element x from `test1.DsOne` as x, `test1.DsTwo` as y http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-lt-join_01.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-lt-join_01.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-lt-join_01.sqlpp index 3711d3c..f717a64 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-lt-join_01.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-lt-join_01.sqlpp @@ -32,13 +32,13 @@ create type test1.TestType as key2 : integer, fname : string, lname : string -} +}; create dataset test1.DsOne(TestType) primary key key1; create dataset test1.DsTwo(TestType) primary key key1; -write output to asterix_nc1:"rttest/btree-index-join_primary-lt-join_01.adm" +write output to asterix_nc1:"rttest/btree-index-join_primary-lt-join_01.adm"; select element x from `test1.DsOne` as x, `test1.DsTwo` as y http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-lt-join_02.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-lt-join_02.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-lt-join_02.sqlpp index 55bbbef..e574877 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-lt-join_02.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/primary-lt-join_02.sqlpp @@ -32,13 +32,13 @@ create type test1.TestType as key2 : integer, fname : string, lname : string -} +}; create dataset test1.DsOne(TestType) primary key key1; create dataset test1.DsTwo(TestType) primary key key1; -write output to asterix_nc1:"rttest/btree-index-join_primary-lt-join_02.adm" +write output to asterix_nc1:"rttest/btree-index-join_primary-lt-join_02.adm"; select element x from `test1.DsOne` as x, `test1.DsTwo` as y http://git-wip-us.apache.org/repos/asf/asterixdb/blob/dc77522b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/secondary-equi-join-multiindex.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/secondary-equi-join-multiindex.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/secondary-equi-join-multiindex.sqlpp index 3704121..4580dab 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/secondary-equi-join-multiindex.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/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 closed { @@ -59,7 +59,7 @@ create type test.FacebookMessageType as `in-response-to` : integer?, `sender-location` : point?, message : string -} +}; create dataset FacebookUsers(FacebookUserType) primary key id; @@ -67,7 +67,7 @@ create dataset FacebookMessages(FacebookMessageType) primary key `message-id`; create index fbmIdxAutId if not exists on FacebookMessages (`author-id-copy`) type btree; -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/btree-index-join/secondary-equi-join-multipred.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/secondary-equi-join-multipred.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/secondary-equi-join-multipred.sqlpp index be83104..0fb1462 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/secondary-equi-join-multipred.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/secondary-equi-join-multipred.sqlpp @@ -38,7 +38,7 @@ create type test.DBLPType as title : string, authors : string, misc : string -} +}; create type test.CSXType as closed { @@ -47,7 +47,7 @@ create type test.CSXType as title : string, authors : string, misc : string -} +}; create dataset DBLP(DBLPType) primary key id; @@ -55,7 +55,7 @@ create dataset CSX(CSXType) primary key id; create index title_index on DBLP (title) type btree; -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/btree-index-join/secondary-equi-join_01.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/secondary-equi-join_01.sqlpp b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/secondary-equi-join_01.sqlpp index 9500353..30352db 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/secondary-equi-join_01.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries_sqlpp/btree-index-join/secondary-equi-join_01.sqlpp @@ -36,7 +36,7 @@ create type test.DBLPType as title : string, authors : string, misc : string -} +}; create type test.CSXType as closed { @@ -45,7 +45,7 @@ create type test.CSXType as title : string, authors : string, misc : string -} +}; create dataset DBLP(DBLPType) primary key id; @@ -53,7 +53,7 @@ create dataset CSX(CSXType) primary key id; create index title_index on DBLP (title) type btree; -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