asterixdb-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From dtab...@apache.org
Subject [11/13] asterixdb git commit: Fix open field CREATE INDEX syntax (AQL and SQLPP).
Date Fri, 26 Aug 2016 19:22:54 GMT
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"


Mime
View raw message