Return-Path: X-Original-To: archive-asf-public-internal@cust-asf2.ponee.io Delivered-To: archive-asf-public-internal@cust-asf2.ponee.io Received: from cust-asf.ponee.io (cust-asf.ponee.io [163.172.22.183]) by cust-asf2.ponee.io (Postfix) with ESMTP id 0C190200B72 for ; Fri, 26 Aug 2016 21:22:49 +0200 (CEST) Received: by cust-asf.ponee.io (Postfix) id 0AAF6160AB6; Fri, 26 Aug 2016 19:22:49 +0000 (UTC) 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 12591160ACD for ; Fri, 26 Aug 2016 21:22:45 +0200 (CEST) Received: (qmail 35245 invoked by uid 500); 26 Aug 2016 19:22:45 -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 34906 invoked by uid 99); 26 Aug 2016 19:22:45 -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; Fri, 26 Aug 2016 19:22:45 +0000 Received: by git1-us-west.apache.org (ASF Mail Server at git1-us-west.apache.org, from userid 33) id D6E8ADFA1E; Fri, 26 Aug 2016 19:22:44 +0000 (UTC) Content-Type: text/plain; charset="us-ascii" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit From: dtabass@apache.org To: commits@asterixdb.apache.org Date: Fri, 26 Aug 2016 19:22:54 -0000 Message-Id: In-Reply-To: <7bf4e24119424f54bf67c3a1d9b48f6b@git.apache.org> References: <7bf4e24119424f54bf67c3a1d9b48f6b@git.apache.org> X-Mailer: ASF-Git Admin Mailer Subject: [11/13] asterixdb git commit: Fix open field CREATE INDEX syntax (AQL and SQLPP). archived-at: Fri, 26 Aug 2016 19:22:49 -0000 http://git-wip-us.apache.org/repos/asf/asterixdb/blob/af8e19df/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/inverted-index-join/ngram-fuzzyeq-jaccard_03.aql ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/inverted-index-join/ngram-fuzzyeq-jaccard_03.aql b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/inverted-index-join/ngram-fuzzyeq-jaccard_03.aql index 2a3eb8f..5e12569 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/inverted-index-join/ngram-fuzzyeq-jaccard_03.aql +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/inverted-index-join/ngram-fuzzyeq-jaccard_03.aql @@ -40,7 +40,7 @@ create type DBLPType as closed { create dataset DBLP(DBLPType) primary key nested.id; -create index ngram_index on DBLP(nested.title: string) type ngram(3) enforced; +create index ngram_index on DBLP(nested.title: string?) type ngram(3) enforced; write output to asterix_nc1:"rttest/inverted-index-join_ngram-fuzzyeq-jaccard_01.adm"; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/af8e19df/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/inverted-index-join/ngram-fuzzyeq-jaccard_04.aql ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/inverted-index-join/ngram-fuzzyeq-jaccard_04.aql b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/inverted-index-join/ngram-fuzzyeq-jaccard_04.aql index 757dcd3..cc2f6cc 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/inverted-index-join/ngram-fuzzyeq-jaccard_04.aql +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/inverted-index-join/ngram-fuzzyeq-jaccard_04.aql @@ -53,9 +53,9 @@ create dataset DBLP(DBLPType) primary key nested.id; create dataset CSX(CSXType) primary key nested.id; -create index ngram_index_DBLP on DBLP(nested.title: string) type ngram(3) enforced; +create index ngram_index_DBLP on DBLP(nested.title: string?) type ngram(3) enforced; -create index ngram_index_CSX on CSX(nested.title: string) type ngram(3) enforced; +create index ngram_index_CSX on CSX(nested.title: string?) type ngram(3) enforced; write output to asterix_nc1:"rttest/inverted-index-join_ngram-fuzzyeq-jaccard_01.adm"; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/af8e19df/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/inverted-index-join/ngram-jaccard-check_01.aql ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/inverted-index-join/ngram-jaccard-check_01.aql b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/inverted-index-join/ngram-jaccard-check_01.aql index f26b0e9..da4d914 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/inverted-index-join/ngram-jaccard-check_01.aql +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/inverted-index-join/ngram-jaccard-check_01.aql @@ -54,7 +54,7 @@ create dataset DBLP(DBLPType) primary key nested.id; create dataset CSX(CSXType) primary key nested.id; -create index ngram_index on DBLP(nested.title: string) type ngram(3) enforced; +create index ngram_index on DBLP(nested.title: string?) type ngram(3) enforced; write output to asterix_nc1:"rttest/inverted-index-join_ngram-jaccard-check_01.adm"; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/af8e19df/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/inverted-index-join/ngram-jaccard-check_02.aql ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/inverted-index-join/ngram-jaccard-check_02.aql b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/inverted-index-join/ngram-jaccard-check_02.aql index 2a834ce..5576768 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/inverted-index-join/ngram-jaccard-check_02.aql +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/inverted-index-join/ngram-jaccard-check_02.aql @@ -54,7 +54,7 @@ create dataset DBLP(DBLPType) primary key nested.id; create dataset CSX(CSXType) primary key nested.id; -create index ngram_index on CSX(nested.title: string) type ngram(3) enforced; +create index ngram_index on CSX(nested.title: string?) type ngram(3) enforced; write output to asterix_nc1:"rttest/inverted-index-join_ngram-jaccard-check_01.adm"; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/af8e19df/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/inverted-index-join/ngram-jaccard-check_03.aql ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/inverted-index-join/ngram-jaccard-check_03.aql b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/inverted-index-join/ngram-jaccard-check_03.aql index 498d925..32829fb 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/inverted-index-join/ngram-jaccard-check_03.aql +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/inverted-index-join/ngram-jaccard-check_03.aql @@ -40,7 +40,7 @@ create type DBLPType as closed { create dataset DBLP(DBLPType) primary key nested.id; -create index ngram_index on DBLP(nested.title: string) type ngram(3) enforced; +create index ngram_index on DBLP(nested.title: string?) type ngram(3) enforced; write output to asterix_nc1:"rttest/inverted-index-join_ngram-jaccard-check_01.adm"; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/af8e19df/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/inverted-index-join/ngram-jaccard-check_04.aql ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/inverted-index-join/ngram-jaccard-check_04.aql b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/inverted-index-join/ngram-jaccard-check_04.aql index 224a7d5..dc4c210 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/inverted-index-join/ngram-jaccard-check_04.aql +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/inverted-index-join/ngram-jaccard-check_04.aql @@ -53,9 +53,9 @@ create dataset DBLP(DBLPType) primary key nested.id; create dataset CSX(CSXType) primary key nested.id; -create index ngram_index_DBLP on DBLP(nested.title: string) type ngram(3) enforced; +create index ngram_index_DBLP on DBLP(nested.title: string?) type ngram(3) enforced; -create index ngram_index_CSX on CSX(nested.title: string) type ngram(3) enforced; +create index ngram_index_CSX on CSX(nested.title: string?) type ngram(3) enforced; write output to asterix_nc1:"rttest/inverted-index-join_ngram-jaccard-check_01.adm"; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/af8e19df/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/inverted-index-join/ngram-jaccard-inline.aql ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/inverted-index-join/ngram-jaccard-inline.aql b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/inverted-index-join/ngram-jaccard-inline.aql index 92346dc..bd599b4 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/inverted-index-join/ngram-jaccard-inline.aql +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/inverted-index-join/ngram-jaccard-inline.aql @@ -42,7 +42,7 @@ create type DBLPType as closed { create dataset DBLP(DBLPType) primary key nested.id; -create index ngram_index on DBLP(nested.title: string) type ngram(3) enforced; +create index ngram_index on DBLP(nested.title: string?) type ngram(3) enforced; write output to asterix_nc1:"rttest/inverted-index-join-noeqjoin_ngram-jaccard-inline.adm"; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/af8e19df/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/inverted-index-join/ngram-jaccard_01.aql ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/inverted-index-join/ngram-jaccard_01.aql b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/inverted-index-join/ngram-jaccard_01.aql index 14cb1ff..0106176 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/inverted-index-join/ngram-jaccard_01.aql +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/inverted-index-join/ngram-jaccard_01.aql @@ -54,7 +54,7 @@ create dataset DBLP(DBLPType) primary key nested.id; create dataset CSX(CSXType) primary key nested.id; -create index ngram_index on DBLP(nested.title: string) type ngram(3) enforced; +create index ngram_index on DBLP(nested.title: string?) type ngram(3) enforced; write output to asterix_nc1:"rttest/inverted-index-join_ngram-jaccard_01.adm"; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/af8e19df/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/inverted-index-join/ngram-jaccard_02.aql ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/inverted-index-join/ngram-jaccard_02.aql b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/inverted-index-join/ngram-jaccard_02.aql index e85c997..e9f491b 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/inverted-index-join/ngram-jaccard_02.aql +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/inverted-index-join/ngram-jaccard_02.aql @@ -54,7 +54,7 @@ create dataset DBLP(DBLPType) primary key nested.id; create dataset CSX(CSXType) primary key nested.id; -create index ngram_index on CSX(nested.title: string) type ngram(3) enforced; +create index ngram_index on CSX(nested.title: string?) type ngram(3) enforced; write output to asterix_nc1:"rttest/inverted-index-join_ngram-jaccard_01.adm"; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/af8e19df/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/inverted-index-join/ngram-jaccard_03.aql ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/inverted-index-join/ngram-jaccard_03.aql b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/inverted-index-join/ngram-jaccard_03.aql index bfc9b3b..e064c03 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/inverted-index-join/ngram-jaccard_03.aql +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/inverted-index-join/ngram-jaccard_03.aql @@ -40,7 +40,7 @@ create type DBLPType as closed { create dataset DBLP(DBLPType) primary key nested.id; -create index ngram_index on DBLP(nested.title: string) type ngram(3) enforced; +create index ngram_index on DBLP(nested.title: string?) type ngram(3) enforced; write output to asterix_nc1:"rttest/inverted-index-join_ngram-jaccard_01.adm"; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/af8e19df/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/inverted-index-join/ngram-jaccard_04.aql ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/inverted-index-join/ngram-jaccard_04.aql b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/inverted-index-join/ngram-jaccard_04.aql index 2b67ebf..b08eabf 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/inverted-index-join/ngram-jaccard_04.aql +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/inverted-index-join/ngram-jaccard_04.aql @@ -53,9 +53,9 @@ create dataset DBLP(DBLPType) primary key nested.id; create dataset CSX(CSXType) primary key nested.id; -create index ngram_index_DBLP on DBLP(nested.title: string) type ngram(3) enforced; +create index ngram_index_DBLP on DBLP(nested.title: string?) type ngram(3) enforced; -create index ngram_index_CSX on CSX(nested.title: string) type ngram(3) enforced; +create index ngram_index_CSX on CSX(nested.title: string?) type ngram(3) enforced; write output to asterix_nc1:"rttest/inverted-index-join_ngram-jaccard_01.adm"; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/af8e19df/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/inverted-index-join/word-fuzzyeq-jaccard_01.aql ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/inverted-index-join/word-fuzzyeq-jaccard_01.aql b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/inverted-index-join/word-fuzzyeq-jaccard_01.aql index 37ee1b4..287b338 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/inverted-index-join/word-fuzzyeq-jaccard_01.aql +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/inverted-index-join/word-fuzzyeq-jaccard_01.aql @@ -53,7 +53,7 @@ create dataset DBLP(DBLPType) primary key nested.id; create dataset CSX(CSXType) primary key nested.id; -create index keyword_index on DBLP(nested.title: string) type keyword enforced; +create index keyword_index on DBLP(nested.title: string?) type keyword enforced; write output to asterix_nc1:"rttest/inverted-index-join_word-fuzzyeq-jaccard_01.adm"; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/af8e19df/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/inverted-index-join/word-fuzzyeq-jaccard_02.aql ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/inverted-index-join/word-fuzzyeq-jaccard_02.aql b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/inverted-index-join/word-fuzzyeq-jaccard_02.aql index 7939ca2..e19b4af 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/inverted-index-join/word-fuzzyeq-jaccard_02.aql +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/inverted-index-join/word-fuzzyeq-jaccard_02.aql @@ -53,7 +53,7 @@ create dataset DBLP(DBLPType) primary key nested.id; create dataset CSX(CSXType) primary key nested.id; -create index keyword_index on CSX(nested.title: string) type keyword enforced; +create index keyword_index on CSX(nested.title: string?) type keyword enforced; write output to asterix_nc1:"rttest/inverted-index-join_word-fuzzyeq-jaccard_01.adm"; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/af8e19df/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/inverted-index-join/word-fuzzyeq-jaccard_03.aql ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/inverted-index-join/word-fuzzyeq-jaccard_03.aql b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/inverted-index-join/word-fuzzyeq-jaccard_03.aql index eb4c84c..5fd64c9 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/inverted-index-join/word-fuzzyeq-jaccard_03.aql +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/inverted-index-join/word-fuzzyeq-jaccard_03.aql @@ -38,7 +38,7 @@ create type DBLPType as closed { create dataset DBLP(DBLPType) primary key nested.id; -create index keyword_index on DBLP(nested.title: string) type keyword enforced; +create index keyword_index on DBLP(nested.title: string?) type keyword enforced; write output to asterix_nc1:"rttest/inverted-index-join_word-fuzzyeq-jaccard_01.adm"; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/af8e19df/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/inverted-index-join/word-fuzzyeq-jaccard_04.aql ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/inverted-index-join/word-fuzzyeq-jaccard_04.aql b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/inverted-index-join/word-fuzzyeq-jaccard_04.aql index adbca83..cad00d1 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/inverted-index-join/word-fuzzyeq-jaccard_04.aql +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/inverted-index-join/word-fuzzyeq-jaccard_04.aql @@ -52,9 +52,9 @@ create dataset DBLP(DBLPType) primary key nested.id; create dataset CSX(CSXType) primary key nested.id; -create index keyword_index_DBLP on DBLP(nested.title: string) type keyword enforced; +create index keyword_index_DBLP on DBLP(nested.title: string?) type keyword enforced; -create index keyword_index_CSX on CSX(nested.title: string) type keyword enforced; +create index keyword_index_CSX on CSX(nested.title: string?) type keyword enforced; write output to asterix_nc1:"rttest/inverted-index-join_word-fuzzyeq-jaccard_01.adm"; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/af8e19df/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/inverted-index-join/word-jaccard-check-after-btree-access.aql ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/inverted-index-join/word-jaccard-check-after-btree-access.aql b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/inverted-index-join/word-jaccard-check-after-btree-access.aql index c09ca89..9ef8bb2 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/inverted-index-join/word-jaccard-check-after-btree-access.aql +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/inverted-index-join/word-jaccard-check-after-btree-access.aql @@ -57,7 +57,7 @@ primary key nested.tweetid; create index twmSndLocIx on TweetMessages(nested.sender-location) type rtree; create index msgCountAIx on TweetMessages(nested.countA) type btree; create index msgCountBIx on TweetMessages(nested.countB) type btree; -create index msgTextIx on TweetMessages(nested.message-text: string) type keyword enforced; +create index msgTextIx on TweetMessages(nested.message-text: string?) type keyword enforced; write output to asterix_nc1:"rttest/inverted-index-join_word-jaccard-check-after-btree-access.adm"; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/af8e19df/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/inverted-index-join/word-jaccard-check_01.aql ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/inverted-index-join/word-jaccard-check_01.aql b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/inverted-index-join/word-jaccard-check_01.aql index 8bca7b3..682a754 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/inverted-index-join/word-jaccard-check_01.aql +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/inverted-index-join/word-jaccard-check_01.aql @@ -53,7 +53,7 @@ create dataset DBLP(DBLPType) primary key nested.id; create dataset CSX(CSXType) primary key nested.id; -create index keyword_index on DBLP(nested.title: string) type keyword enforced; +create index keyword_index on DBLP(nested.title: string?) type keyword enforced; write output to asterix_nc1:"rttest/inverted-index-join_word-jaccard-check_01.adm"; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/af8e19df/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/inverted-index-join/word-jaccard-check_02.aql ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/inverted-index-join/word-jaccard-check_02.aql b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/inverted-index-join/word-jaccard-check_02.aql index 803d4db..583dda6 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/inverted-index-join/word-jaccard-check_02.aql +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/inverted-index-join/word-jaccard-check_02.aql @@ -53,7 +53,7 @@ create dataset DBLP(DBLPType) primary key nested.id; create dataset CSX(CSXType) primary key nested.id; -create index keyword_index on CSX(nested.title: string) type keyword enforced; +create index keyword_index on CSX(nested.title: string?) type keyword enforced; write output to asterix_nc1:"rttest/inverted-index-join_word-jaccard-check_01.adm"; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/af8e19df/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/inverted-index-join/word-jaccard-check_03.aql ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/inverted-index-join/word-jaccard-check_03.aql b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/inverted-index-join/word-jaccard-check_03.aql index 54f6065..2cff649 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/inverted-index-join/word-jaccard-check_03.aql +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/inverted-index-join/word-jaccard-check_03.aql @@ -39,7 +39,7 @@ create type DBLPType as closed { create dataset DBLP(DBLPType) primary key nested.id; -create index keyword_index_DBLP on DBLP(nested.title: string) type keyword enforced; +create index keyword_index_DBLP on DBLP(nested.title: string?) type keyword enforced; write output to asterix_nc1:"rttest/inverted-index-join_word-jaccard-check_01.adm"; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/af8e19df/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/inverted-index-join/word-jaccard-check_04.aql ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/inverted-index-join/word-jaccard-check_04.aql b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/inverted-index-join/word-jaccard-check_04.aql index 24ed006..fe7b2f9 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/inverted-index-join/word-jaccard-check_04.aql +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/inverted-index-join/word-jaccard-check_04.aql @@ -52,9 +52,9 @@ create dataset DBLP(DBLPType) primary key nested.id; create dataset CSX(CSXType) primary key nested.id; -create index keyword_index on DBLP(nested.title: string) type keyword enforced; +create index keyword_index on DBLP(nested.title: string?) type keyword enforced; -create index keyword_index on CSX(nested.title: string) type keyword enforced; +create index keyword_index on CSX(nested.title: string?) type keyword enforced; write output to asterix_nc1:"rttest/inverted-index-join_word-jaccard-check_01.adm"; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/af8e19df/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/inverted-index-join/word-jaccard-inline.aql ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/inverted-index-join/word-jaccard-inline.aql b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/inverted-index-join/word-jaccard-inline.aql index 7219d51..2ec1846 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/inverted-index-join/word-jaccard-inline.aql +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/inverted-index-join/word-jaccard-inline.aql @@ -41,7 +41,7 @@ create type DBLPType as closed { create dataset DBLP(DBLPType) primary key nested.id; -create index keyword_index on DBLP(nested.title: string) type keyword enforced; +create index keyword_index on DBLP(nested.title: string?) type keyword enforced; write output to asterix_nc1:"rttest/inverted-index-join-noeqjoin_word-jaccard-inline.adm"; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/af8e19df/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/inverted-index-join/word-jaccard_01.aql ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/inverted-index-join/word-jaccard_01.aql b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/inverted-index-join/word-jaccard_01.aql index aeef474..c255829 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/inverted-index-join/word-jaccard_01.aql +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/inverted-index-join/word-jaccard_01.aql @@ -53,7 +53,7 @@ create dataset DBLP(DBLPType) primary key nested.id; create dataset CSX(CSXType) primary key nested.id; -create index keyword_index on DBLP(nested.title: string) type keyword enforced; +create index keyword_index on DBLP(nested.title: string?) type keyword enforced; write output to asterix_nc1:"rttest/inverted-index-join_word-jaccard_01.adm"; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/af8e19df/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/inverted-index-join/word-jaccard_02.aql ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/inverted-index-join/word-jaccard_02.aql b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/inverted-index-join/word-jaccard_02.aql index 15a88ca..2d52ae9 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/inverted-index-join/word-jaccard_02.aql +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/inverted-index-join/word-jaccard_02.aql @@ -53,7 +53,7 @@ create dataset DBLP(DBLPType) primary key nested.id; create dataset CSX(CSXType) primary key nested.id; -create index keyword_index on CSX(nested.title: string) type keyword enforced; +create index keyword_index on CSX(nested.title: string?) type keyword enforced; write output to asterix_nc1:"rttest/inverted-index-join_word-jaccard_01.adm"; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/af8e19df/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/inverted-index-join/word-jaccard_03.aql ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/inverted-index-join/word-jaccard_03.aql b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/inverted-index-join/word-jaccard_03.aql index 045e3b4..456ad8c 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/inverted-index-join/word-jaccard_03.aql +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/inverted-index-join/word-jaccard_03.aql @@ -39,7 +39,7 @@ create type DBLPType as closed { create dataset DBLP(DBLPType) primary key nested.id; -create index keyword_index on DBLP(nested.title: string) type keyword enforced; +create index keyword_index on DBLP(nested.title: string?) type keyword enforced; write output to asterix_nc1:"rttest/inverted-index-join_word-jaccard_01.adm"; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/af8e19df/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/inverted-index-join/word-jaccard_04.aql ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/inverted-index-join/word-jaccard_04.aql b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/inverted-index-join/word-jaccard_04.aql index 63ad895..8812d81 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/inverted-index-join/word-jaccard_04.aql +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/inverted-index-join/word-jaccard_04.aql @@ -52,9 +52,9 @@ create dataset DBLP(DBLPType) primary key nested.id; create dataset CSX(CSXType) primary key nested.id; -create index keyword_index on DBLP(nested.title: string) type keyword enforced; +create index keyword_index on DBLP(nested.title: string?) type keyword enforced; -create index keyword_index on CSX(nested.title: string) type keyword enforced; +create index keyword_index on CSX(nested.title: string?) type keyword enforced; write output to asterix_nc1:"rttest/inverted-index-join_word-jaccard_01.adm"; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/af8e19df/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/rtree-index-join/leftouterjoin-probe-pidx-with-join-rtree-sidx_01.aql ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/rtree-index-join/leftouterjoin-probe-pidx-with-join-rtree-sidx_01.aql b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/rtree-index-join/leftouterjoin-probe-pidx-with-join-rtree-sidx_01.aql index c07ad40..8fa81da 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/rtree-index-join/leftouterjoin-probe-pidx-with-join-rtree-sidx_01.aql +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/rtree-index-join/leftouterjoin-probe-pidx-with-join-rtree-sidx_01.aql @@ -53,7 +53,7 @@ create type TweetMessageType as open { create dataset TweetMessages(TweetMessageType) primary key nested.tweetid; -create index twmSndLocIx on TweetMessages(nested.sender-location: point) type rtree enforced; +create index twmSndLocIx on TweetMessages(nested.sender-location: point?) type rtree enforced; create index msgCountAIx on TweetMessages(nested.countA) type btree; create index msgCountBIx on TweetMessages(nested.countB) type btree; create index msgTextIx on TweetMessages(nested.message-text) type keyword; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/af8e19df/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/rtree-index-join/leftouterjoin-probe-pidx-with-join-rtree-sidx_02.aql ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/rtree-index-join/leftouterjoin-probe-pidx-with-join-rtree-sidx_02.aql b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/rtree-index-join/leftouterjoin-probe-pidx-with-join-rtree-sidx_02.aql index 2456a17..8499c9a 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/rtree-index-join/leftouterjoin-probe-pidx-with-join-rtree-sidx_02.aql +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/rtree-index-join/leftouterjoin-probe-pidx-with-join-rtree-sidx_02.aql @@ -53,7 +53,7 @@ create type TweetMessageType as open { create dataset TweetMessages(TweetMessageType) primary key nested.tweetid; -create index twmSndLocIx on TweetMessages(nested.sender-location: point) type rtree enforced; +create index twmSndLocIx on TweetMessages(nested.sender-location: point?) type rtree enforced; create index msgCountAIx on TweetMessages(nested.countA) type btree; create index msgCountBIx on TweetMessages(nested.countB) type btree; create index msgTextIx on TweetMessages(nested.message-text) type keyword; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/af8e19df/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/rtree-index-join/spatial-intersect-point_01.aql ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/rtree-index-join/spatial-intersect-point_01.aql b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/rtree-index-join/spatial-intersect-point_01.aql index b5f36e7..1812b3b 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/rtree-index-join/spatial-intersect-point_01.aql +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/rtree-index-join/spatial-intersect-point_01.aql @@ -18,7 +18,7 @@ */ /* * Description : Joins two datasets on the intersection of their point attributes. - * The dataset 'MyData1' has an enforced open RTree index, and we expect the + * The dataset 'MyData1' has an enforced open RTree index?, and we expect the * join to be transformed into an indexed nested-loop join. * Success : Yes */ http://git-wip-us.apache.org/repos/asf/asterixdb/blob/af8e19df/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/rtree-index-join/spatial-intersect-point_02.aql ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/rtree-index-join/spatial-intersect-point_02.aql b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/rtree-index-join/spatial-intersect-point_02.aql index 76eb7c9..bed6626 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/rtree-index-join/spatial-intersect-point_02.aql +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/rtree-index-join/spatial-intersect-point_02.aql @@ -18,7 +18,7 @@ */ /* * Description : Joins two datasets on the intersection of their point attributes. - * The dataset 'MyData2' has an enforced open RTree index, and we expect the + * The dataset 'MyData2' has an enforced open RTree index?, and we expect the * join to be transformed into an indexed nested-loop join. * Success : Yes */ http://git-wip-us.apache.org/repos/asf/asterixdb/blob/af8e19df/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/rtree-index-join/spatial-intersect-point_03.aql ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/rtree-index-join/spatial-intersect-point_03.aql b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/rtree-index-join/spatial-intersect-point_03.aql index 5d0b806..e991ee8 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/rtree-index-join/spatial-intersect-point_03.aql +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/rtree-index-join/spatial-intersect-point_03.aql @@ -18,7 +18,7 @@ */ /* * Description : Self-joins a dataset on the intersection of its point attribute. - * The dataset has an enforced open RTree index, and we expect the + * The dataset has an enforced open RTree index?, and we expect the * join to be transformed into an indexed nested-loop join. * Success : Yes */ http://git-wip-us.apache.org/repos/asf/asterixdb/blob/af8e19df/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/rtree-index-join/spatial-intersect-point_04.aql ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/rtree-index-join/spatial-intersect-point_04.aql b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/rtree-index-join/spatial-intersect-point_04.aql index 8010f89..06a30b4 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/rtree-index-join/spatial-intersect-point_04.aql +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/rtree-index-join/spatial-intersect-point_04.aql @@ -18,7 +18,7 @@ */ /* * Description : Joins two datasets on the intersection of their point attributes. - * Both datasets 'MyData' and 'MyData2' have an enforced open RTree index, and we expect the + * Both datasets 'MyData' and 'MyData2' have an enforced open RTree index?, and we expect the * join to be transformed into an indexed nested-loop join. * Success : Yes */ @@ -44,9 +44,9 @@ create type MyRecordOpen as closed { create dataset MyData1(MyRecordOpen) primary key nested.id; create dataset MyData2(MyRecordOpen) primary key nested.id; -create index rtree_index on MyData1(nested.point:point) type rtree enforced; +create index rtree_index on MyData1(nested.point:point?) type rtree enforced; -create index rtree_index2 on MyData2(nested.point:point) type rtree enforced; +create index rtree_index2 on MyData2(nested.point:point?) type rtree enforced; write output to asterix_nc1:"rttest/rtree-index-join_spatial-intersect-point_02.adm"; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/af8e19df/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/rtree-index-join/spatial-intersect-point_05.aql ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/rtree-index-join/spatial-intersect-point_05.aql b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/rtree-index-join/spatial-intersect-point_05.aql index 0a99784..22a3905 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/rtree-index-join/spatial-intersect-point_05.aql +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/rtree-index-join/spatial-intersect-point_05.aql @@ -18,7 +18,7 @@ */ /* * Description : Joins two datasets on the intersection of their point attributes. - * Only dataset 'MyData1' has an enforced open RTree index, hence we + * Only dataset 'MyData1' has an enforced open RTree index?, hence we * *do not* expect the join to be transformed into an indexed nested-loop join. * Success : Yes */ @@ -44,7 +44,7 @@ create type MyRecordOpen as closed { create dataset MyData1(MyRecordOpen) primary key nested.id; create dataset MyData2(MyRecordOpen) primary key nested.id; -create index rtree_index on MyData1(nested.point:point) type rtree enforced; +create index rtree_index on MyData1(nested.point:point?) type rtree enforced; write output to asterix_nc1:"rttest/rtree-index-join_spatial-intersect-point_02.adm"; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/af8e19df/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index-join/disjunction-to-join.aql ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index-join/disjunction-to-join.aql b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index-join/disjunction-to-join.aql index fe75193..1c95319 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index-join/disjunction-to-join.aql +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index-join/disjunction-to-join.aql @@ -32,7 +32,7 @@ create type TestType as open { }; create dataset TestSet(TestType) primary key "id"; -create index TestSetIndex on TestSet(idx: string) enforced; +create index TestSetIndex on TestSet(idx: string?) enforced; for $x in dataset TestSet where $x.idx = "one" or $x.idx = "two" http://git-wip-us.apache.org/repos/asf/asterixdb/blob/af8e19df/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index-join/leftouterjoin-probe-pidx-with-join-btree-sidx_01_1.aql ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index-join/leftouterjoin-probe-pidx-with-join-btree-sidx_01_1.aql b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index-join/leftouterjoin-probe-pidx-with-join-btree-sidx_01_1.aql index a096c8b..325063b 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index-join/leftouterjoin-probe-pidx-with-join-btree-sidx_01_1.aql +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index-join/leftouterjoin-probe-pidx-with-join-btree-sidx_01_1.aql @@ -49,7 +49,7 @@ create type TweetMessageType as open { create dataset TweetMessages(TweetMessageType) primary key tweetid; -create index msgCountBIx on TweetMessages(countB: int32) type btree enforced; +create index msgCountBIx on TweetMessages(countB: int32?) type btree enforced; write output to asterix_nc1:"rttest/btree-index-join_leftouterjoin-probe-pidx-with-join-btree-sidx_01.adm"; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/af8e19df/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index-join/leftouterjoin-probe-pidx-with-join-btree-sidx_01_2.aql ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index-join/leftouterjoin-probe-pidx-with-join-btree-sidx_01_2.aql b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index-join/leftouterjoin-probe-pidx-with-join-btree-sidx_01_2.aql index 96849fe..bb1552a 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index-join/leftouterjoin-probe-pidx-with-join-btree-sidx_01_2.aql +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index-join/leftouterjoin-probe-pidx-with-join-btree-sidx_01_2.aql @@ -48,8 +48,8 @@ create type TweetMessageType as open { create dataset TweetMessages(TweetMessageType) primary key tweetid; -create index msgCountAIx on TweetMessages(countA: int32) type btree enforced; -create index msgCountBIx on TweetMessages(countB: int32) type btree enforced; +create index msgCountAIx on TweetMessages(countA: int32?) type btree enforced; +create index msgCountBIx on TweetMessages(countB: int32?) type btree enforced; write output to asterix_nc1:"rttest/btree-index-join_leftouterjoin-probe-pidx-with-join-btree-sidx_01.adm"; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/af8e19df/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index-join/leftouterjoin-probe-pidx-with-join-btree-sidx_02_1.aql ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index-join/leftouterjoin-probe-pidx-with-join-btree-sidx_02_1.aql b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index-join/leftouterjoin-probe-pidx-with-join-btree-sidx_02_1.aql index 1ff785e..78673c3 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index-join/leftouterjoin-probe-pidx-with-join-btree-sidx_02_1.aql +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index-join/leftouterjoin-probe-pidx-with-join-btree-sidx_02_1.aql @@ -49,7 +49,7 @@ create type TweetMessageType as open { create dataset TweetMessages(TweetMessageType) primary key tweetid; -create index msgCountBIx on TweetMessages(countB: int32) type btree enforced; +create index msgCountBIx on TweetMessages(countB: int32?) type btree enforced; write output to asterix_nc1:"rttest/btree-index-join_leftouterjoin-probe-pidx-with-join-btree-sidx_02.adm"; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/af8e19df/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index-join/leftouterjoin-probe-pidx-with-join-btree-sidx_02_2.aql ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index-join/leftouterjoin-probe-pidx-with-join-btree-sidx_02_2.aql b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index-join/leftouterjoin-probe-pidx-with-join-btree-sidx_02_2.aql index f386e00..07f4a07 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index-join/leftouterjoin-probe-pidx-with-join-btree-sidx_02_2.aql +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index-join/leftouterjoin-probe-pidx-with-join-btree-sidx_02_2.aql @@ -48,8 +48,8 @@ create type TweetMessageType as open { create dataset TweetMessages(TweetMessageType) primary key tweetid; -create index msgCountAIx on TweetMessages(countA: int32) type btree enforced; -create index msgCountBIx on TweetMessages(countB: int32) type btree enforced; +create index msgCountAIx on TweetMessages(countA: int32?) type btree enforced; +create index msgCountBIx on TweetMessages(countB: int32?) type btree enforced; write output to asterix_nc1:"rttest/btree-index-join_leftouterjoin-probe-pidx-with-join-btree-sidx_02.adm"; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/af8e19df/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index-join/secondary-composite-key-join_01.aql ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index-join/secondary-composite-key-join_01.aql b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index-join/secondary-composite-key-join_01.aql index ea51434..9e07c8d 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index-join/secondary-composite-key-join_01.aql +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index-join/secondary-composite-key-join_01.aql @@ -32,7 +32,7 @@ create type Name as open { } create dataset Names(Name) primary key id; -create index Name_idx on Names(fname: string,lname: string) enforced; +create index Name_idx on Names(fname: string?,lname: string?) enforced; write output to asterix_nc1:"rttest/btree-index-join_secondary-composite-key-prefix-join_01.adm"; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/af8e19df/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index-join/secondary-composite-key-join_02.aql ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index-join/secondary-composite-key-join_02.aql b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index-join/secondary-composite-key-join_02.aql index 938f9f0..50963e2 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index-join/secondary-composite-key-join_02.aql +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index-join/secondary-composite-key-join_02.aql @@ -32,7 +32,7 @@ create type Name as open { } create dataset Names(Name) primary key id; -create index Name_idx on Names(fname: string,lname: string) enforced; +create index Name_idx on Names(fname: string?,lname: string?) enforced; write output to asterix_nc1:"rttest/btree-index-join_secondary-composite-key-prefix-join_02.adm"; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/af8e19df/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index-join/secondary-composite-key-join_03.aql ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index-join/secondary-composite-key-join_03.aql b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index-join/secondary-composite-key-join_03.aql index 82d71ab..52d113e 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index-join/secondary-composite-key-join_03.aql +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index-join/secondary-composite-key-join_03.aql @@ -32,7 +32,7 @@ create type Name as open { } create dataset Names(Name) primary key id; -create index Name_idx on Names(fname: string,lname: string) enforced; +create index Name_idx on Names(fname: string?,lname: string?) enforced; write output to asterix_nc1:"rttest/btree-index-join_secondary-composite-key-prefix-join_03.adm"; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/af8e19df/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index-join/secondary-composite-key-prefix-join_01.aql ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index-join/secondary-composite-key-prefix-join_01.aql b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index-join/secondary-composite-key-prefix-join_01.aql index 2ee9098..05f4d74 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index-join/secondary-composite-key-prefix-join_01.aql +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index-join/secondary-composite-key-prefix-join_01.aql @@ -32,7 +32,7 @@ create type Name as open { } create dataset Names(Name) primary key id; -create index Name_idx on Names(fname: string,lname: string) enforced; +create index Name_idx on Names(fname: string?,lname: string?) enforced; write output to asterix_nc1:"rttest/btree-index-join_secondary-composite-key-prefix-prefix-join_01.adm"; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/af8e19df/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index-join/secondary-composite-key-prefix-join_02.aql ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index-join/secondary-composite-key-prefix-join_02.aql b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index-join/secondary-composite-key-prefix-join_02.aql index b62b48f..b41c3b0 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index-join/secondary-composite-key-prefix-join_02.aql +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index-join/secondary-composite-key-prefix-join_02.aql @@ -32,7 +32,7 @@ create type Name as open { } create dataset Names(Name) primary key id; -create index Name_idx on Names(fname: string,lname: string) enforced; +create index Name_idx on Names(fname: string?,lname: string?) enforced; write output to asterix_nc1:"rttest/btree-index-join_secondary-composite-key-prefix-prefix-join_02.adm"; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/af8e19df/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index-join/secondary-composite-key-prefix-join_03.aql ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index-join/secondary-composite-key-prefix-join_03.aql b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index-join/secondary-composite-key-prefix-join_03.aql index b58ef1c..196347a 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index-join/secondary-composite-key-prefix-join_03.aql +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index-join/secondary-composite-key-prefix-join_03.aql @@ -32,7 +32,7 @@ create type Name as open { } create dataset Names(Name) primary key id; -create index Name_idx on Names(fname: string,lname: string) enforced; +create index Name_idx on Names(fname: string?,lname: string?) enforced; write output to asterix_nc1:"rttest/btree-index-join_secondary-composite-key-prefix-prefix-join_03.adm"; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/af8e19df/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index-join/secondary-composite-key-prefix-join_04.aql ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index-join/secondary-composite-key-prefix-join_04.aql b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index-join/secondary-composite-key-prefix-join_04.aql index 5b4b18e..559650e 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index-join/secondary-composite-key-prefix-join_04.aql +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index-join/secondary-composite-key-prefix-join_04.aql @@ -32,7 +32,7 @@ create type Name as open { } create dataset Names(Name) primary key id; -create index Name_idx on Names(fname: string,lname: string) enforced; +create index Name_idx on Names(fname: string?,lname: string?) enforced; write output to asterix_nc1:"rttest/btree-index-join_secondary-composite-key-prefix-prefix-join_04.adm"; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/af8e19df/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index-join/secondary-composite-key-prefix-join_05.aql ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index-join/secondary-composite-key-prefix-join_05.aql b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index-join/secondary-composite-key-prefix-join_05.aql index 5d0eb2f..15fc889 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index-join/secondary-composite-key-prefix-join_05.aql +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index-join/secondary-composite-key-prefix-join_05.aql @@ -32,7 +32,7 @@ create type Name as open { } create dataset Names(Name) primary key id; -create index Name_idx on Names(fname: string,lname: string) enforced; +create index Name_idx on Names(fname: string?,lname: string?) enforced; write output to asterix_nc1:"rttest/btree-index-join_secondary-composite-key-prefix-prefix-join_05.adm"; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/af8e19df/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index-join/secondary-composite-key-prefix-join_06.aql ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index-join/secondary-composite-key-prefix-join_06.aql b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index-join/secondary-composite-key-prefix-join_06.aql index a0df2f5..551fdb7 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index-join/secondary-composite-key-prefix-join_06.aql +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index-join/secondary-composite-key-prefix-join_06.aql @@ -32,7 +32,7 @@ create type Name as open { } create dataset Names(Name) primary key id; -create index Name_idx on Names(fname: string,lname: string) enforced; +create index Name_idx on Names(fname: string?,lname: string?) enforced; write output to asterix_nc1:"rttest/btree-index-join_secondary-composite-key-prefix-prefix-join_06.adm"; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/af8e19df/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index-join/secondary-equi-join-multiindex.aql ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index-join/secondary-equi-join-multiindex.aql b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index-join/secondary-equi-join-multiindex.aql index 3a0e289..af51a69 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index-join/secondary-equi-join-multiindex.aql +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index-join/secondary-equi-join-multiindex.aql @@ -61,7 +61,7 @@ primary key id; create dataset FacebookMessages(FacebookMessageType) primary key message-id; -create index fbmIdxAutId if not exists on FacebookMessages(author-id-copy:int32) enforced; +create index fbmIdxAutId if not exists on FacebookMessages(author-id-copy:int32?) enforced; write output to asterix_nc1:"rttest/btree-index-join_title-secondary-equi-join-multiindex.adm"; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/af8e19df/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index-join/secondary-equi-join-multipred.aql ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index-join/secondary-equi-join-multipred.aql b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index-join/secondary-equi-join-multipred.aql index 4cad8e3..046d664 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index-join/secondary-equi-join-multipred.aql +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index-join/secondary-equi-join-multipred.aql @@ -48,7 +48,7 @@ create dataset DBLP(DBLPType) primary key id; create dataset CSX(CSXType) primary key id; -create index title_index on DBLP(title:string) enforced; +create index title_index on DBLP(title:string?) enforced; write output to asterix_nc1:"rttest/btree-index-join_title-secondary-equi-join-multipred.adm"; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/af8e19df/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index-join/secondary-equi-join_01.aql ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index-join/secondary-equi-join_01.aql b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index-join/secondary-equi-join_01.aql index b9a9f59..5170257 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index-join/secondary-equi-join_01.aql +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index-join/secondary-equi-join_01.aql @@ -46,7 +46,7 @@ create dataset DBLP(DBLPType) primary key id; create dataset CSX(CSXType) primary key id; -create index title_index on DBLP(title:string) enforced; +create index title_index on DBLP(title:string?) enforced; write output to asterix_nc1:"rttest/btree-index-join_title-secondary-equi-join_01.adm"; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/af8e19df/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index-join/secondary-equi-join_02.aql ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index-join/secondary-equi-join_02.aql b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index-join/secondary-equi-join_02.aql index d24522d..247b5e0 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index-join/secondary-equi-join_02.aql +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index-join/secondary-equi-join_02.aql @@ -46,7 +46,7 @@ create dataset DBLP(DBLPType) primary key id; create dataset CSX(CSXType) primary key id; -create index title_index on CSX(title:string) enforced; +create index title_index on CSX(title:string?) enforced; write output to asterix_nc1:"rttest/btree-index-join_title-secondary-equi-join_02.adm"; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/af8e19df/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index-join/secondary-equi-join_03.aql ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index-join/secondary-equi-join_03.aql b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index-join/secondary-equi-join_03.aql index e39a320..a414ba3 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index-join/secondary-equi-join_03.aql +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index-join/secondary-equi-join_03.aql @@ -36,7 +36,7 @@ create type DBLPType as open { create dataset DBLP(DBLPType) primary key id; -create index title_index on DBLP(title:string) enforced; +create index title_index on DBLP(title:string?) enforced; write output to asterix_nc1:"rttest/btree-index-join_title-secondary-equi-join_03.adm"; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/af8e19df/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index-join/secondary-equi-join_04.aql ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index-join/secondary-equi-join_04.aql b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index-join/secondary-equi-join_04.aql index 5a988ff..8b78831 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index-join/secondary-equi-join_04.aql +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index-join/secondary-equi-join_04.aql @@ -45,9 +45,9 @@ create dataset DBLP(DBLPType) primary key id; create dataset CSX(CSXType) primary key id; -create index title_index_DBLP on DBLP(title:string) enforced; +create index title_index_DBLP on DBLP(title:string?) enforced; -create index title_index on CSX(title:string) enforced; +create index title_index on CSX(title:string?) enforced; write output to asterix_nc1:"rttest/btree-index-join_title-secondary-equi-join_02.adm"; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/af8e19df/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index-join/secondary-equi-join_05.aql ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index-join/secondary-equi-join_05.aql b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index-join/secondary-equi-join_05.aql index 714bbf8..85a4495 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index-join/secondary-equi-join_05.aql +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index-join/secondary-equi-join_05.aql @@ -46,7 +46,7 @@ create dataset DBLP(DBLPType) primary key id; create dataset CSX(CSXType) primary key id; -create index title_index on DBLP(title:string) enforced; +create index title_index on DBLP(title:string?) enforced; write output to asterix_nc1:"rttest/btree-index-join_title-secondary-equi-join_02.adm"; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/af8e19df/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index/btree-secondary-33.aql ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index/btree-secondary-33.aql b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index/btree-secondary-33.aql index b4d7e8b..4c5c2b8 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index/btree-secondary-33.aql +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index/btree-secondary-33.aql @@ -38,7 +38,7 @@ create type TestType as open { create dataset testdst(TestType) primary key id; -create index sec_Idx on testdst(fname:string,lname:string) enforced; +create index sec_Idx on testdst(fname:string?,lname:string?) enforced; for $emp in dataset('testdst') where $emp.fname > "Roger" http://git-wip-us.apache.org/repos/asf/asterixdb/blob/af8e19df/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index/btree-secondary-34.aql ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index/btree-secondary-34.aql b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index/btree-secondary-34.aql index 8fc5bf3..4aee42a 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index/btree-secondary-34.aql +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index/btree-secondary-34.aql @@ -38,7 +38,7 @@ create type TestType as open { create dataset testdst(TestType) primary key id; -create index sec_Idx on testdst(fname:string,lname:string) enforced; +create index sec_Idx on testdst(fname:string?,lname:string?) enforced; for $emp in dataset('testdst') where $emp.fname >= "Susan" http://git-wip-us.apache.org/repos/asf/asterixdb/blob/af8e19df/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index/btree-secondary-35.aql ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index/btree-secondary-35.aql b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index/btree-secondary-35.aql index 4db04c4..549db84 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index/btree-secondary-35.aql +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index/btree-secondary-35.aql @@ -38,7 +38,7 @@ create type TestType as open { create dataset testdst(TestType) primary key id; -create index sec_Idx on testdst(fname:string,lname:string) enforced; +create index sec_Idx on testdst(fname:string?,lname:string?) enforced; for $emp in dataset('testdst') where $emp.fname < "Isa" http://git-wip-us.apache.org/repos/asf/asterixdb/blob/af8e19df/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index/btree-secondary-36.aql ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index/btree-secondary-36.aql b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index/btree-secondary-36.aql index 072e8df..5d181fc 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index/btree-secondary-36.aql +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index/btree-secondary-36.aql @@ -38,7 +38,7 @@ create type TestType as open { create dataset testdst(TestType) primary key id; -create index sec_Idx on testdst(fname:string,lname:string) enforced; +create index sec_Idx on testdst(fname:string?,lname:string?) enforced; for $emp in dataset('testdst') where $emp.fname <= "Vanpatten" http://git-wip-us.apache.org/repos/asf/asterixdb/blob/af8e19df/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index/btree-secondary-37.aql ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index/btree-secondary-37.aql b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index/btree-secondary-37.aql index 03f90e3..75804ea 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index/btree-secondary-37.aql +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index/btree-secondary-37.aql @@ -38,7 +38,7 @@ create type TestType as open { create dataset testdst(TestType) primary key id; -create index sec_Idx on testdst(fname:string,lname:string) enforced; +create index sec_Idx on testdst(fname:string?,lname:string?) enforced; for $emp in dataset('testdst') where $emp.fname != "Max" http://git-wip-us.apache.org/repos/asf/asterixdb/blob/af8e19df/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index/btree-secondary-38.aql ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index/btree-secondary-38.aql b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index/btree-secondary-38.aql index f73425d..711e68f 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index/btree-secondary-38.aql +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index/btree-secondary-38.aql @@ -38,7 +38,7 @@ create type TestType as open { create dataset testdst(TestType) primary key id; -create index sec_Idx on testdst(fname:string,lname:string) enforced; +create index sec_Idx on testdst(fname:string?,lname:string?) enforced; for $emp in dataset('testdst') where $emp.fname = "Julio" http://git-wip-us.apache.org/repos/asf/asterixdb/blob/af8e19df/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index/btree-secondary-39.aql ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index/btree-secondary-39.aql b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index/btree-secondary-39.aql index 63a69af..fb3b93d 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index/btree-secondary-39.aql +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index/btree-secondary-39.aql @@ -38,7 +38,7 @@ create type TestType as open { create dataset testdst(TestType) primary key id; -create index sec_Idx on testdst(fname:string,lname:string) enforced; +create index sec_Idx on testdst(fname:string?,lname:string?) enforced; for $emp in dataset('testdst') where $emp.lname = "Kim" http://git-wip-us.apache.org/repos/asf/asterixdb/blob/af8e19df/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index/btree-secondary-40.aql ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index/btree-secondary-40.aql b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index/btree-secondary-40.aql index 4de4012..0f42145 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index/btree-secondary-40.aql +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index/btree-secondary-40.aql @@ -35,7 +35,7 @@ create type TestType as open { create dataset testdst(TestType) primary key id; -create index sec_Idx on testdst(fname:string,lname:string) enforced; +create index sec_Idx on testdst(fname:string?,lname:string?) enforced; for $emp in dataset('testdst') where $emp.fname = "Young Seok" and $emp.lname = "Kim" http://git-wip-us.apache.org/repos/asf/asterixdb/blob/af8e19df/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index/btree-secondary-41.aql ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index/btree-secondary-41.aql b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index/btree-secondary-41.aql index 262b729..d05ac9f 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index/btree-secondary-41.aql +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index/btree-secondary-41.aql @@ -38,7 +38,7 @@ create type TestType as open { create dataset testdst(TestType) primary key id; -create index sec_Idx on testdst(fname:string,lname:string) enforced; +create index sec_Idx on testdst(fname:string?,lname:string?) enforced; for $emp in dataset('testdst') where $emp.fname = "Julio" or $emp.lname = "Malaika" http://git-wip-us.apache.org/repos/asf/asterixdb/blob/af8e19df/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index/btree-secondary-42.aql ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index/btree-secondary-42.aql b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index/btree-secondary-42.aql index 8a10529..63daef0 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index/btree-secondary-42.aql +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index/btree-secondary-42.aql @@ -36,7 +36,7 @@ create type TestType as open { create dataset testdst(TestType) primary key id; -create index sec_Idx on testdst(fname:string,lname:string) enforced; +create index sec_Idx on testdst(fname:string?,lname:string?) enforced; for $emp in dataset('testdst') where $emp.fname > "Alex" and $emp.lname < "Zach" http://git-wip-us.apache.org/repos/asf/asterixdb/blob/af8e19df/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index/btree-secondary-43.aql ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index/btree-secondary-43.aql b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index/btree-secondary-43.aql index e136d17..b584eee 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index/btree-secondary-43.aql +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index/btree-secondary-43.aql @@ -36,7 +36,7 @@ create type TestType as open { create dataset testdst(TestType) primary key id; -create index sec_Idx on testdst(fname:string,lname:string) enforced; +create index sec_Idx on testdst(fname:string?,lname:string?) enforced; for $emp in dataset('testdst') where $emp.fname > "Allan" and $emp.lname < "Zubi" http://git-wip-us.apache.org/repos/asf/asterixdb/blob/af8e19df/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index/btree-secondary-44.aql ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index/btree-secondary-44.aql b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index/btree-secondary-44.aql index 499daf1..05b92c0 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index/btree-secondary-44.aql +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index/btree-secondary-44.aql @@ -38,7 +38,7 @@ create type TestType as open { create dataset testdst(TestType) primary key id; -create index sec_Idx on testdst(fname:string,lname:string) enforced; +create index sec_Idx on testdst(fname:string?,lname:string?) enforced; for $emp in dataset('testdst') where $emp.fname > "Allan" and $emp.lname = "Xu" http://git-wip-us.apache.org/repos/asf/asterixdb/blob/af8e19df/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index/btree-secondary-45.aql ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index/btree-secondary-45.aql b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index/btree-secondary-45.aql index 0cd5b62..a732af4 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index/btree-secondary-45.aql +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index/btree-secondary-45.aql @@ -38,7 +38,7 @@ create type TestType as open { create dataset testdst(TestType) primary key id; -create index sec_Idx on testdst(fname:string,lname:string) enforced; +create index sec_Idx on testdst(fname:string?,lname:string?) enforced; for $emp in dataset('testdst') where $emp.fname = "Julio" and $emp.lname < "Xu" http://git-wip-us.apache.org/repos/asf/asterixdb/blob/af8e19df/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index/btree-secondary-46.aql ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index/btree-secondary-46.aql b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index/btree-secondary-46.aql index 75247b7..efdae0a 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index/btree-secondary-46.aql +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index/btree-secondary-46.aql @@ -36,7 +36,7 @@ create type TestType as open { create dataset testdst(TestType) primary key id; -create index sec_Idx on testdst(fname:string,lname:string) enforced; +create index sec_Idx on testdst(fname:string?,lname:string?) enforced; for $emp in dataset('testdst') where $emp.fname >= "Michael" and $emp.lname <= "Xu" http://git-wip-us.apache.org/repos/asf/asterixdb/blob/af8e19df/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index/btree-secondary-47.aql ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index/btree-secondary-47.aql b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index/btree-secondary-47.aql index 6dbbb33..4cd35eb 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index/btree-secondary-47.aql +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index/btree-secondary-47.aql @@ -36,7 +36,7 @@ create type TestType as open { create dataset testdst(TestType) primary key id; -create index sec_Idx on testdst(fname:string,lname:string) enforced; +create index sec_Idx on testdst(fname:string?,lname:string?) enforced; for $emp in dataset('testdst') where $emp.fname > "Craig" and $emp.lname > "Kevin" and $emp.fname < "Mary" and $emp.lname < "Tomes" http://git-wip-us.apache.org/repos/asf/asterixdb/blob/af8e19df/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index/btree-secondary-48.aql ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index/btree-secondary-48.aql b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index/btree-secondary-48.aql index 785f605..83ab8e6 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index/btree-secondary-48.aql +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index/btree-secondary-48.aql @@ -36,7 +36,7 @@ create type TestType as open { create dataset testdst(TestType) primary key id; -create index sec_Idx on testdst(fname:string,lname:string) enforced; +create index sec_Idx on testdst(fname:string?,lname:string?) enforced; for $emp in dataset('testdst') where $emp.fname >= "Craig" and $emp.lname >= "Kevin" and $emp.fname <= "Mary" and $emp.lname <= "Tomes" http://git-wip-us.apache.org/repos/asf/asterixdb/blob/af8e19df/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index/btree-secondary-49.aql ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index/btree-secondary-49.aql b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index/btree-secondary-49.aql index d695b53..b255913 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index/btree-secondary-49.aql +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index/btree-secondary-49.aql @@ -36,7 +36,7 @@ create type TestType as open { create dataset testdst(TestType) primary key id; -create index sec_Idx on testdst(fname:string,lname:string) enforced; +create index sec_Idx on testdst(fname:string?,lname:string?) enforced; for $emp in dataset('testdst') where $emp.fname <= "Craig" and $emp.lname > "Kevin" http://git-wip-us.apache.org/repos/asf/asterixdb/blob/af8e19df/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index/btree-secondary-50.aql ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index/btree-secondary-50.aql b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index/btree-secondary-50.aql index ce20a9d..427e29a 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index/btree-secondary-50.aql +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index/btree-secondary-50.aql @@ -36,7 +36,7 @@ create type TestType as open { create dataset testdst(TestType) primary key id; -create index sec_Idx on testdst(fname:string,lname:string) enforced; +create index sec_Idx on testdst(fname:string?,lname:string?) enforced; for $emp in dataset('testdst') where $emp.fname != "Michael" and $emp.lname != "Carey" http://git-wip-us.apache.org/repos/asf/asterixdb/blob/af8e19df/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index/btree-secondary-51.aql ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index/btree-secondary-51.aql b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index/btree-secondary-51.aql index a48a641..99baf52 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index/btree-secondary-51.aql +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index/btree-secondary-51.aql @@ -36,7 +36,7 @@ create type TestType as open { create dataset testdst(TestType) primary key id; -create index sec_Idx on testdst(fname:string,lname:string) enforced; +create index sec_Idx on testdst(fname:string?,lname:string?) enforced; for $emp in dataset('testdst') where $emp.fname > "Craig" and $emp.lname > "Kevin" and $emp.fname <= "Mary" and $emp.lname <= "Tomes" http://git-wip-us.apache.org/repos/asf/asterixdb/blob/af8e19df/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index/btree-secondary-52.aql ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index/btree-secondary-52.aql b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index/btree-secondary-52.aql index f07897d..9d9f6f8 100644 --- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index/btree-secondary-52.aql +++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/open-index-enforced/btree-index/btree-secondary-52.aql @@ -36,7 +36,7 @@ create type TestType as open { create dataset testdst(TestType) primary key id; -create index sec_Idx on testdst(fname:string,lname:string) enforced; +create index sec_Idx on testdst(fname:string?,lname:string?) enforced; for $emp in dataset('testdst') where $emp.fname >= "Craig" and $emp.lname >= "Kevin" and $emp.fname < "Mary" and $emp.lname < "Tomes"