asterixdb-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From dtab...@apache.org
Subject [13/13] asterixdb git commit: Fix open field CREATE INDEX syntax (AQL and SQLPP).
Date Fri, 26 Aug 2016 19:22:56 GMT
Fix open field CREATE INDEX syntax (AQL and SQLPP).

Our CREATE INDEX syntax for open fields didn't match our semantics.
Our semantics allow to-be-indexed open field(s) to be MISSING.
We don't support (or offer :-)) tighter semantics than that.
Our syntax didn't require creators to say this, but now it does:
  Old: CREATE INDEX myIdx on MyDSet(myTime: datetime) ENFORCED;
  New: CREATE INDEX myIdx on MyDSet(myTime: datetime?) ENFORCED;
Have now addressed all of  Till's comments (I think).

Change-Id: I32bf8bc5ac1c0e6aa6744ca8f91a197311219814
Reviewed-on: https://asterix-gerrit.ics.uci.edu/1106
Reviewed-by: Yingyi Bu <buyingyi@gmail.com>
Sonar-Qube: Jenkins <jenkins@fulliautomatix.ics.uci.edu>
Tested-by: Jenkins <jenkins@fulliautomatix.ics.uci.edu>
Integration-Tests: Jenkins <jenkins@fulliautomatix.ics.uci.edu>


Project: http://git-wip-us.apache.org/repos/asf/asterixdb/repo
Commit: http://git-wip-us.apache.org/repos/asf/asterixdb/commit/af8e19df
Tree: http://git-wip-us.apache.org/repos/asf/asterixdb/tree/af8e19df
Diff: http://git-wip-us.apache.org/repos/asf/asterixdb/diff/af8e19df

Branch: refs/heads/master
Commit: af8e19df1b391d17b44147ed6ea6b5b44718400e
Parents: 82ac2f0
Author: Mike Carey <dtabass@gmail.com>
Authored: Thu Aug 25 17:55:17 2016 -0700
Committer: Michael Carey <dtabass@gmail.com>
Committed: Fri Aug 26 12:20:35 2016 -0700

----------------------------------------------------------------------
 .../queries/basic/meta16/meta16.1.ddl.aql       |   2 +-
 .../queries/basic/meta17/meta17.1.ddl.aql       |   2 +-
 .../queries/basic/meta24/meta24.1.ddl.aql       |   2 +-
 .../meta/secondary_index-lojoin_with_meta-1.aql |   8 +++---
 .../meta/secondary_index-nljoin_with_meta-1.aql |   4 +--
 .../meta/secondary_index-nljoin_with_meta-2.aql |   4 +--
 .../meta/secondary_index_with_meta-2.aql        |   2 +-
 .../spatial-intersect-point_01.aql              |   2 +-
 .../spatial-intersect-point_02.aql              |   2 +-
 .../spatial-intersect-point_03.aql              |   2 +-
 .../btree-index-join/disjunction-to-join.aql    |   2 +-
 ...oin-probe-pidx-with-join-btree-sidx_01_1.aql |   2 +-
 ...oin-probe-pidx-with-join-btree-sidx_01_2.aql |   4 +--
 ...oin-probe-pidx-with-join-btree-sidx_02_1.aql |   2 +-
 ...oin-probe-pidx-with-join-btree-sidx_02_2.aql |   4 +--
 .../secondary-composite-key-join_01.aql         |   2 +-
 .../secondary-composite-key-join_02.aql         |   2 +-
 .../secondary-composite-key-join_03.aql         |   2 +-
 .../secondary-composite-key-prefix-join_01.aql  |   2 +-
 .../secondary-composite-key-prefix-join_02.aql  |   2 +-
 .../secondary-composite-key-prefix-join_03.aql  |   2 +-
 .../secondary-composite-key-prefix-join_04.aql  |   2 +-
 .../secondary-composite-key-prefix-join_05.aql  |   2 +-
 .../secondary-composite-key-prefix-join_06.aql  |   2 +-
 .../secondary-equi-join-multiindex.aql          |   2 +-
 .../secondary-equi-join-multipred.aql           |   2 +-
 .../btree-index-join/secondary-equi-join_01.aql |   2 +-
 .../btree-index-join/secondary-equi-join_02.aql |   2 +-
 .../btree-index-join/secondary-equi-join_03.aql |   4 +--
 .../btree-index-join/secondary-equi-join_04.aql |   2 +-
 .../btree-index-join/secondary-equi-join_05.aql |   2 +-
 .../btree-index/btree-secondary-33.aql          |   2 +-
 .../btree-index/btree-secondary-34.aql          |   2 +-
 .../btree-index/btree-secondary-35.aql          |   2 +-
 .../btree-index/btree-secondary-36.aql          |   2 +-
 .../btree-index/btree-secondary-37.aql          |   2 +-
 .../btree-index/btree-secondary-38.aql          |   2 +-
 .../btree-index/btree-secondary-39.aql          |   2 +-
 .../btree-index/btree-secondary-40.aql          |   2 +-
 .../btree-index/btree-secondary-41.aql          |   2 +-
 .../btree-index/btree-secondary-42.aql          |   2 +-
 .../btree-index/btree-secondary-43.aql          |   2 +-
 .../btree-index/btree-secondary-44.aql          |   2 +-
 .../btree-index/btree-secondary-45.aql          |   2 +-
 .../btree-index/btree-secondary-46.aql          |   2 +-
 .../btree-index/btree-secondary-47.aql          |   2 +-
 .../btree-index/btree-secondary-48.aql          |   2 +-
 .../btree-index/btree-secondary-49.aql          |   2 +-
 .../btree-index/btree-secondary-50.aql          |   2 +-
 .../btree-index/btree-secondary-51.aql          |   2 +-
 .../btree-index/btree-secondary-52.aql          |   2 +-
 .../btree-index/btree-secondary-53.aql          |   2 +-
 .../btree-index/btree-secondary-54.aql          |   2 +-
 .../btree-index/btree-secondary-55.aql          |   2 +-
 .../btree-index/btree-secondary-56.aql          |   2 +-
 .../btree-index/btree-secondary-57.aql          |   2 +-
 .../btree-index/btree-secondary-58.aql          |   2 +-
 .../btree-index/btree-secondary-59.aql          |   2 +-
 .../btree-index/btree-secondary-60.aql          |   2 +-
 .../btree-index/btree-secondary-61.aql          |   2 +-
 .../btree-index/btree-secondary-62.aql          |   2 +-
 .../btree-index/btree-secondary-63.aql          |   2 +-
 .../ngram-contains-panic.aql                    |   2 +-
 .../inverted-index-basic/ngram-contains.aql     |   2 +-
 .../ngram-edit-distance-check-panic.aql         |   2 +-
 .../ngram-edit-distance-check.aql               |   2 +-
 .../ngram-edit-distance-panic.aql               |   2 +-
 .../ngram-edit-distance.aql                     |   2 +-
 .../ngram-fuzzyeq-edit-distance.aql             |   2 +-
 .../ngram-fuzzyeq-jaccard.aql                   |   2 +-
 .../ngram-jaccard-check.aql                     |   2 +-
 .../inverted-index-basic/ngram-jaccard.aql      |   2 +-
 .../inverted-index-basic/word-contains.aql      |   2 +-
 .../word-fuzzyeq-jaccard.aql                    |   2 +-
 .../inverted-index-basic/word-jaccard-check.aql |   2 +-
 .../inverted-index-basic/word-jaccard.aql       |   2 +-
 ...edit-distance-check-let-panic-nopanic_01.aql |   2 +-
 ...edit-distance-check-let-panic-nopanic_02.aql |   2 +-
 .../ngram-edit-distance-check-let-panic.aql     |   2 +-
 .../ngram-edit-distance-check-let.aql           |   2 +-
 .../ngram-edit-distance-check-substring.aql     |   2 +-
 .../ngram-edit-distance-check-word-tokens.aql   |   2 +-
 .../ngram-jaccard-check-let.aql                 |   2 +-
 .../ngram-jaccard-check-multi-let.aql           |   2 +-
 .../word-jaccard-check-let.aql                  |   2 +-
 .../word-jaccard-check-multi-let.aql            |   2 +-
 ...idx-with-join-edit-distance-check-idx_01.aql |   2 +-
 .../inverted-index-join/ngram-contains_01.aql   |   2 +-
 .../inverted-index-join/ngram-contains_02.aql   |   2 +-
 .../inverted-index-join/ngram-contains_03.aql   |   2 +-
 .../inverted-index-join/ngram-contains_04.aql   |   4 +--
 .../ngram-edit-distance-check_01.aql            |   2 +-
 .../ngram-edit-distance-check_02.aql            |   2 +-
 .../ngram-edit-distance-check_03.aql            |   2 +-
 .../ngram-edit-distance-check_04.aql            |   4 +--
 .../ngram-edit-distance-check_05.aql            |   2 +-
 .../ngram-edit-distance-contains.aql            |   2 +-
 .../ngram-edit-distance-inline.aql              |   2 +-
 .../ngram-edit-distance_01.aql                  |   2 +-
 .../ngram-edit-distance_02.aql                  |   2 +-
 .../ngram-edit-distance_03.aql                  |   2 +-
 .../ngram-edit-distance_04.aql                  |   4 +--
 .../ngram-edit-distance_05.aql                  |   2 +-
 .../ngram-fuzzyeq-edit-distance_01.aql          |   2 +-
 .../ngram-fuzzyeq-edit-distance_02.aql          |   2 +-
 .../ngram-fuzzyeq-edit-distance_03.aql          |   2 +-
 .../ngram-fuzzyeq-edit-distance_04.aql          |   4 +--
 .../ngram-fuzzyeq-edit-distance_05.aql          |   2 +-
 .../ngram-fuzzyeq-jaccard_01.aql                |   2 +-
 .../ngram-fuzzyeq-jaccard_02.aql                |   2 +-
 .../ngram-fuzzyeq-jaccard_03.aql                |   2 +-
 .../ngram-fuzzyeq-jaccard_04.aql                |   4 +--
 .../ngram-jaccard-check_01.aql                  |   2 +-
 .../ngram-jaccard-check_02.aql                  |   2 +-
 .../ngram-jaccard-check_03.aql                  |   2 +-
 .../ngram-jaccard-check_04.aql                  |   4 +--
 .../ngram-jaccard-inline.aql                    |   2 +-
 .../inverted-index-join/ngram-jaccard_01.aql    |   2 +-
 .../inverted-index-join/ngram-jaccard_02.aql    |   2 +-
 .../inverted-index-join/ngram-jaccard_03.aql    |   2 +-
 .../inverted-index-join/ngram-jaccard_04.aql    |   4 +--
 .../word-fuzzyeq-jaccard_01.aql                 |   2 +-
 .../word-fuzzyeq-jaccard_02.aql                 |   2 +-
 .../word-fuzzyeq-jaccard_03.aql                 |   2 +-
 .../word-fuzzyeq-jaccard_04.aql                 |   4 +--
 .../word-jaccard-check-after-btree-access.aql   |   2 +-
 .../word-jaccard-check_01.aql                   |   2 +-
 .../word-jaccard-check_02.aql                   |   2 +-
 .../word-jaccard-check_03.aql                   |   2 +-
 .../word-jaccard-check_04.aql                   |   4 +--
 .../inverted-index-join/word-jaccard-inline.aql |   2 +-
 .../inverted-index-join/word-jaccard_01.aql     |   2 +-
 .../inverted-index-join/word-jaccard_02.aql     |   2 +-
 .../inverted-index-join/word-jaccard_03.aql     |   2 +-
 .../inverted-index-join/word-jaccard_04.aql     |   4 +--
 ...rjoin-probe-pidx-with-join-rtree-sidx_01.aql |   2 +-
 ...rjoin-probe-pidx-with-join-rtree-sidx_02.aql |   2 +-
 .../spatial-intersect-point_01.aql              |   2 +-
 .../spatial-intersect-point_02.aql              |   2 +-
 .../spatial-intersect-point_03.aql              |   2 +-
 .../spatial-intersect-point_04.aql              |   6 ++--
 .../spatial-intersect-point_05.aql              |   4 +--
 .../btree-index-join/disjunction-to-join.aql    |   2 +-
 ...oin-probe-pidx-with-join-btree-sidx_01_1.aql |   2 +-
 ...oin-probe-pidx-with-join-btree-sidx_01_2.aql |   4 +--
 ...oin-probe-pidx-with-join-btree-sidx_02_1.aql |   2 +-
 ...oin-probe-pidx-with-join-btree-sidx_02_2.aql |   4 +--
 .../secondary-composite-key-join_01.aql         |   2 +-
 .../secondary-composite-key-join_02.aql         |   2 +-
 .../secondary-composite-key-join_03.aql         |   2 +-
 .../secondary-composite-key-prefix-join_01.aql  |   2 +-
 .../secondary-composite-key-prefix-join_02.aql  |   2 +-
 .../secondary-composite-key-prefix-join_03.aql  |   2 +-
 .../secondary-composite-key-prefix-join_04.aql  |   2 +-
 .../secondary-composite-key-prefix-join_05.aql  |   2 +-
 .../secondary-composite-key-prefix-join_06.aql  |   2 +-
 .../secondary-equi-join-multiindex.aql          |   2 +-
 .../secondary-equi-join-multipred.aql           |   2 +-
 .../btree-index-join/secondary-equi-join_01.aql |   2 +-
 .../btree-index-join/secondary-equi-join_02.aql |   2 +-
 .../btree-index-join/secondary-equi-join_03.aql |   2 +-
 .../btree-index-join/secondary-equi-join_04.aql |   4 +--
 .../btree-index-join/secondary-equi-join_05.aql |   2 +-
 .../btree-index/btree-secondary-33.aql          |   2 +-
 .../btree-index/btree-secondary-34.aql          |   2 +-
 .../btree-index/btree-secondary-35.aql          |   2 +-
 .../btree-index/btree-secondary-36.aql          |   2 +-
 .../btree-index/btree-secondary-37.aql          |   2 +-
 .../btree-index/btree-secondary-38.aql          |   2 +-
 .../btree-index/btree-secondary-39.aql          |   2 +-
 .../btree-index/btree-secondary-40.aql          |   2 +-
 .../btree-index/btree-secondary-41.aql          |   2 +-
 .../btree-index/btree-secondary-42.aql          |   2 +-
 .../btree-index/btree-secondary-43.aql          |   2 +-
 .../btree-index/btree-secondary-44.aql          |   2 +-
 .../btree-index/btree-secondary-45.aql          |   2 +-
 .../btree-index/btree-secondary-46.aql          |   2 +-
 .../btree-index/btree-secondary-47.aql          |   2 +-
 .../btree-index/btree-secondary-48.aql          |   2 +-
 .../btree-index/btree-secondary-49.aql          |   2 +-
 .../btree-index/btree-secondary-50.aql          |   2 +-
 .../btree-index/btree-secondary-51.aql          |   2 +-
 .../btree-index/btree-secondary-52.aql          |   2 +-
 .../btree-index/btree-secondary-53.aql          |   2 +-
 .../btree-index/btree-secondary-54.aql          |   2 +-
 .../btree-index/btree-secondary-55.aql          |   2 +-
 .../btree-index/btree-secondary-56.aql          |   2 +-
 .../btree-index/btree-secondary-57.aql          |   2 +-
 .../btree-index/btree-secondary-58.aql          |   2 +-
 .../btree-index/btree-secondary-59.aql          |   2 +-
 .../btree-index/btree-secondary-60.aql          |   2 +-
 .../btree-index/btree-secondary-61.aql          |   2 +-
 .../btree-index/btree-secondary-62.aql          |   2 +-
 .../btree-index/btree-secondary-63.aql          |   2 +-
 .../ngram-contains-panic.aql                    |   2 +-
 .../inverted-index-basic/ngram-contains.aql     |   2 +-
 .../ngram-edit-distance-check-panic.aql         |   2 +-
 .../ngram-edit-distance-check.aql               |   2 +-
 .../ngram-edit-distance-panic.aql               |   2 +-
 .../ngram-edit-distance.aql                     |   2 +-
 .../ngram-fuzzyeq-edit-distance.aql             |   2 +-
 .../ngram-fuzzyeq-jaccard.aql                   |   2 +-
 .../ngram-jaccard-check.aql                     |   2 +-
 .../inverted-index-basic/ngram-jaccard.aql      |   2 +-
 .../inverted-index-basic/word-contains.aql      |   2 +-
 .../word-fuzzyeq-jaccard.aql                    |   2 +-
 .../inverted-index-basic/word-jaccard-check.aql |   2 +-
 .../inverted-index-basic/word-jaccard.aql       |   2 +-
 ...edit-distance-check-let-panic-nopanic_01.aql |   2 +-
 ...edit-distance-check-let-panic-nopanic_02.aql |   2 +-
 .../ngram-edit-distance-check-let-panic.aql     |   2 +-
 .../ngram-edit-distance-check-let.aql           |   2 +-
 .../ngram-edit-distance-check-substring.aql     |   2 +-
 .../ngram-edit-distance-check-word-tokens.aql   |   2 +-
 .../ngram-jaccard-check-let.aql                 |   2 +-
 .../ngram-jaccard-check-multi-let.aql           |   2 +-
 .../word-jaccard-check-let.aql                  |   2 +-
 .../word-jaccard-check-multi-let.aql            |   2 +-
 ...idx-with-join-edit-distance-check-idx_01.aql |   2 +-
 .../inverted-index-join/ngram-contains_01.aql   |   2 +-
 .../inverted-index-join/ngram-contains_02.aql   |   2 +-
 .../inverted-index-join/ngram-contains_03.aql   |   2 +-
 .../inverted-index-join/ngram-contains_04.aql   |   4 +--
 .../ngram-edit-distance-check_01.aql            |   4 +--
 .../ngram-edit-distance-check_02.aql            |   4 +--
 .../ngram-edit-distance-check_03.aql            |   4 +--
 .../ngram-edit-distance-check_04.aql            |   6 ++--
 .../ngram-edit-distance-check_05.aql            |   6 ++--
 .../ngram-edit-distance-check_inline_03.aql     |   4 +--
 .../ngram-edit-distance-contains.aql            |   2 +-
 .../ngram-edit-distance_01.aql                  |   4 +--
 .../ngram-edit-distance_02.aql                  |   4 +--
 .../ngram-edit-distance_03.aql                  |   4 +--
 .../ngram-edit-distance_04.aql                  |   6 ++--
 .../ngram-edit-distance_05.aql                  |   6 ++--
 .../ngram-edit-distance_inline_03.aql           |   4 +--
 .../ngram-fuzzyeq-edit-distance_01.aql          |   4 +--
 .../ngram-fuzzyeq-edit-distance_02.aql          |   4 +--
 .../ngram-fuzzyeq-edit-distance_03.aql          |   4 +--
 .../ngram-fuzzyeq-edit-distance_04.aql          |   6 ++--
 .../ngram-fuzzyeq-edit-distance_05.aql          |   6 ++--
 .../ngram-fuzzyeq-jaccard_01.aql                |   4 +--
 .../ngram-fuzzyeq-jaccard_02.aql                |   4 +--
 .../ngram-fuzzyeq-jaccard_03.aql                |   4 +--
 .../ngram-fuzzyeq-jaccard_04.aql                |   6 ++--
 .../ngram-jaccard-check_01.aql                  |   4 +--
 .../ngram-jaccard-check_02.aql                  |   4 +--
 .../ngram-jaccard-check_03.aql                  |   4 +--
 .../ngram-jaccard-check_04.aql                  |   6 ++--
 .../ngram-jaccard-check_inline_03.aql           |   4 +--
 .../inverted-index-join/ngram-jaccard_01.aql    |   4 +--
 .../inverted-index-join/ngram-jaccard_02.aql    |   4 +--
 .../inverted-index-join/ngram-jaccard_03.aql    |   4 +--
 .../inverted-index-join/ngram-jaccard_04.aql    |   6 ++--
 .../ngram-jaccard_inline_03.aql                 |   4 +--
 .../word-fuzzyeq-jaccard_01.aql                 |   4 +--
 .../word-fuzzyeq-jaccard_02.aql                 |   4 +--
 .../word-fuzzyeq-jaccard_03.aql                 |   4 +--
 .../word-fuzzyeq-jaccard_04.aql                 |   6 ++--
 .../word-jaccard-check-after-btree-access.aql   |   2 +-
 .../word-jaccard-check_01.aql                   |   4 +--
 .../word-jaccard-check_02.aql                   |   4 +--
 .../word-jaccard-check_03.aql                   |   4 +--
 .../word-jaccard-check_04.aql                   |   6 ++--
 .../word-jaccard-check_inline_03.aql            |   4 +--
 .../inverted-index-join/word-jaccard_01.aql     |   4 +--
 .../inverted-index-join/word-jaccard_02.aql     |   4 +--
 .../inverted-index-join/word-jaccard_03.aql     |   4 +--
 .../inverted-index-join/word-jaccard_04.aql     |   6 ++--
 .../word-jaccard_inline_03.aql                  |   4 +--
 ...rjoin-probe-pidx-with-join-rtree-sidx_01.aql |   2 +-
 ...rjoin-probe-pidx-with-join-rtree-sidx_02.aql |   2 +-
 .../spatial-intersect-point_01.aql              |   4 +--
 .../spatial-intersect-point_02.aql              |   4 +--
 .../spatial-intersect-point_03.aql              |   4 +--
 .../spatial-intersect-point_04.aql              |   6 ++--
 .../spatial-intersect-point_05.aql              |   4 +--
 .../spatial-intersect-point_01.sqlpp            |   2 +-
 .../spatial-intersect-point_02.sqlpp            |   2 +-
 .../spatial-intersect-point_03.sqlpp            |   2 +-
 .../btree-index-join/disjunction-to-join.sqlpp  |   2 +-
 ...n-probe-pidx-with-join-btree-sidx_01_1.sqlpp |   2 +-
 ...n-probe-pidx-with-join-btree-sidx_01_2.sqlpp |   4 +--
 ...n-probe-pidx-with-join-btree-sidx_02_1.sqlpp |   2 +-
 ...n-probe-pidx-with-join-btree-sidx_02_2.sqlpp |   4 +--
 .../secondary-composite-key-join_01.sqlpp       |   2 +-
 .../secondary-composite-key-join_02.sqlpp       |   2 +-
 .../secondary-composite-key-join_03.sqlpp       |   2 +-
 ...secondary-composite-key-prefix-join_01.sqlpp |   2 +-
 ...secondary-composite-key-prefix-join_02.sqlpp |   2 +-
 ...secondary-composite-key-prefix-join_03.sqlpp |   2 +-
 ...secondary-composite-key-prefix-join_04.sqlpp |   2 +-
 ...secondary-composite-key-prefix-join_05.sqlpp |   2 +-
 ...secondary-composite-key-prefix-join_06.sqlpp |   2 +-
 .../secondary-equi-join-multiindex.sqlpp        |   2 +-
 .../secondary-equi-join-multipred.sqlpp         |   2 +-
 .../secondary-equi-join_01.sqlpp                |   2 +-
 .../secondary-equi-join_02.sqlpp                |   2 +-
 .../secondary-equi-join_03.sqlpp                |   4 +--
 .../secondary-equi-join_04.sqlpp                |   2 +-
 .../secondary-equi-join_05.sqlpp                |   2 +-
 .../btree-index/btree-secondary-33.sqlpp        |   2 +-
 .../btree-index/btree-secondary-34.sqlpp        |   2 +-
 .../btree-index/btree-secondary-35.sqlpp        |   2 +-
 .../btree-index/btree-secondary-36.sqlpp        |   2 +-
 .../btree-index/btree-secondary-37.sqlpp        |   2 +-
 .../btree-index/btree-secondary-38.sqlpp        |   2 +-
 .../btree-index/btree-secondary-39.sqlpp        |   2 +-
 .../btree-index/btree-secondary-40.sqlpp        |   2 +-
 .../btree-index/btree-secondary-41.sqlpp        |   2 +-
 .../btree-index/btree-secondary-42.sqlpp        |   2 +-
 .../btree-index/btree-secondary-43.sqlpp        |   2 +-
 .../btree-index/btree-secondary-44.sqlpp        |   2 +-
 .../btree-index/btree-secondary-45.sqlpp        |   2 +-
 .../btree-index/btree-secondary-46.sqlpp        |   2 +-
 .../btree-index/btree-secondary-47.sqlpp        |   2 +-
 .../btree-index/btree-secondary-48.sqlpp        |   2 +-
 .../btree-index/btree-secondary-49.sqlpp        |   2 +-
 .../btree-index/btree-secondary-50.sqlpp        |   2 +-
 .../btree-index/btree-secondary-51.sqlpp        |   2 +-
 .../btree-index/btree-secondary-52.sqlpp        |   2 +-
 .../btree-index/btree-secondary-53.sqlpp        |   2 +-
 .../btree-index/btree-secondary-54.sqlpp        |   2 +-
 .../btree-index/btree-secondary-55.sqlpp        |   2 +-
 .../btree-index/btree-secondary-56.sqlpp        |   2 +-
 .../btree-index/btree-secondary-57.sqlpp        |   2 +-
 .../btree-index/btree-secondary-58.sqlpp        |   2 +-
 .../btree-index/btree-secondary-59.sqlpp        |   2 +-
 .../btree-index/btree-secondary-60.sqlpp        |   2 +-
 .../btree-index/btree-secondary-61.sqlpp        |   2 +-
 .../btree-index/btree-secondary-62.sqlpp        |   2 +-
 .../btree-index/btree-secondary-63.sqlpp        |   2 +-
 .../ngram-contains-panic.sqlpp                  |   2 +-
 .../inverted-index-basic/ngram-contains.sqlpp   |   2 +-
 .../ngram-edit-distance-check-panic.sqlpp       |   2 +-
 .../ngram-edit-distance-check.sqlpp             |   2 +-
 .../ngram-edit-distance-panic.sqlpp             |   2 +-
 .../ngram-edit-distance.sqlpp                   |   2 +-
 .../ngram-fuzzyeq-edit-distance.sqlpp           |   2 +-
 .../ngram-fuzzyeq-jaccard.sqlpp                 |   2 +-
 .../ngram-jaccard-check.sqlpp                   |   2 +-
 .../inverted-index-basic/ngram-jaccard.sqlpp    |   2 +-
 .../inverted-index-basic/word-contains.sqlpp    |   2 +-
 .../word-fuzzyeq-jaccard.sqlpp                  |   2 +-
 .../word-jaccard-check.sqlpp                    |   2 +-
 .../inverted-index-basic/word-jaccard.sqlpp     |   2 +-
 ...it-distance-check-let-panic-nopanic_01.sqlpp |   2 +-
 ...it-distance-check-let-panic-nopanic_02.sqlpp |   2 +-
 .../ngram-edit-distance-check-let-panic.sqlpp   |   2 +-
 .../ngram-edit-distance-check-let.sqlpp         |   2 +-
 .../ngram-edit-distance-check-substring.sqlpp   |   2 +-
 .../ngram-edit-distance-check-word-tokens.sqlpp |   2 +-
 .../ngram-jaccard-check-let.sqlpp               |   2 +-
 .../ngram-jaccard-check-multi-let.sqlpp         |   2 +-
 .../word-jaccard-check-let.sqlpp                |   2 +-
 .../word-jaccard-check-multi-let.sqlpp          |   2 +-
 ...x-with-join-edit-distance-check-idx_01.sqlpp |   2 +-
 .../inverted-index-join/ngram-contains_01.sqlpp |   2 +-
 .../inverted-index-join/ngram-contains_02.sqlpp |   2 +-
 .../inverted-index-join/ngram-contains_03.sqlpp |   2 +-
 .../inverted-index-join/ngram-contains_04.sqlpp |   4 +--
 .../ngram-edit-distance-check_01.sqlpp          |   2 +-
 .../ngram-edit-distance-check_02.sqlpp          |   2 +-
 .../ngram-edit-distance-check_03.sqlpp          |   2 +-
 .../ngram-edit-distance-check_04.sqlpp          |   4 +--
 .../ngram-edit-distance-check_05.sqlpp          |   2 +-
 .../ngram-edit-distance-contains.sqlpp          |   2 +-
 .../ngram-edit-distance-inline.sqlpp            |   2 +-
 .../ngram-edit-distance_01.sqlpp                |   2 +-
 .../ngram-edit-distance_02.sqlpp                |   2 +-
 .../ngram-edit-distance_03.sqlpp                |   2 +-
 .../ngram-edit-distance_04.sqlpp                |   4 +--
 .../ngram-edit-distance_05.sqlpp                |   2 +-
 .../ngram-fuzzyeq-edit-distance_01.sqlpp        |   2 +-
 .../ngram-fuzzyeq-edit-distance_02.sqlpp        |   2 +-
 .../ngram-fuzzyeq-edit-distance_03.sqlpp        |   2 +-
 .../ngram-fuzzyeq-edit-distance_04.sqlpp        |   4 +--
 .../ngram-fuzzyeq-edit-distance_05.sqlpp        |   2 +-
 .../ngram-fuzzyeq-jaccard_01.sqlpp              |   2 +-
 .../ngram-fuzzyeq-jaccard_02.sqlpp              |   2 +-
 .../ngram-fuzzyeq-jaccard_03.sqlpp              |   2 +-
 .../ngram-fuzzyeq-jaccard_04.sqlpp              |   4 +--
 .../ngram-jaccard-check_01.sqlpp                |   2 +-
 .../ngram-jaccard-check_02.sqlpp                |   2 +-
 .../ngram-jaccard-check_03.sqlpp                |   2 +-
 .../ngram-jaccard-check_04.sqlpp                |   4 +--
 .../ngram-jaccard-inline.sqlpp                  |   2 +-
 .../inverted-index-join/ngram-jaccard_01.sqlpp  |   2 +-
 .../inverted-index-join/ngram-jaccard_02.sqlpp  |   2 +-
 .../inverted-index-join/ngram-jaccard_03.sqlpp  |   2 +-
 .../inverted-index-join/ngram-jaccard_04.sqlpp  |   4 +--
 .../word-fuzzyeq-jaccard_01.sqlpp               |   2 +-
 .../word-fuzzyeq-jaccard_02.sqlpp               |   2 +-
 .../word-fuzzyeq-jaccard_03.sqlpp               |   2 +-
 .../word-fuzzyeq-jaccard_04.sqlpp               |   4 +--
 .../word-jaccard-check-after-btree-access.sqlpp |   2 +-
 .../word-jaccard-check_01.sqlpp                 |   2 +-
 .../word-jaccard-check_02.sqlpp                 |   2 +-
 .../word-jaccard-check_03.sqlpp                 |   2 +-
 .../word-jaccard-check_04.sqlpp                 |   4 +--
 .../word-jaccard-inline.sqlpp                   |   2 +-
 .../inverted-index-join/word-jaccard_01.sqlpp   |   2 +-
 .../inverted-index-join/word-jaccard_02.sqlpp   |   2 +-
 .../inverted-index-join/word-jaccard_03.sqlpp   |   2 +-
 .../inverted-index-join/word-jaccard_04.sqlpp   |   4 +--
 ...oin-probe-pidx-with-join-rtree-sidx_01.sqlpp |   2 +-
 ...oin-probe-pidx-with-join-rtree-sidx_02.sqlpp |   2 +-
 .../spatial-intersect-point_01.sqlpp            |   2 +-
 .../spatial-intersect-point_02.sqlpp            |   2 +-
 .../spatial-intersect-point_03.sqlpp            |   2 +-
 .../spatial-intersect-point_04.sqlpp            |   6 ++--
 .../spatial-intersect-point_05.sqlpp            |   4 +--
 .../btree-index-join/disjunction-to-join.sqlpp  |   2 +-
 ...n-probe-pidx-with-join-btree-sidx_01_1.sqlpp |   2 +-
 ...n-probe-pidx-with-join-btree-sidx_01_2.sqlpp |   4 +--
 ...n-probe-pidx-with-join-btree-sidx_02_1.sqlpp |   2 +-
 ...n-probe-pidx-with-join-btree-sidx_02_2.sqlpp |   4 +--
 .../secondary-composite-key-join_01.sqlpp       |   2 +-
 .../secondary-composite-key-join_02.sqlpp       |   2 +-
 .../secondary-composite-key-join_03.sqlpp       |   2 +-
 ...secondary-composite-key-prefix-join_01.sqlpp |   2 +-
 ...secondary-composite-key-prefix-join_02.sqlpp |   2 +-
 ...secondary-composite-key-prefix-join_03.sqlpp |   2 +-
 ...secondary-composite-key-prefix-join_04.sqlpp |   2 +-
 ...secondary-composite-key-prefix-join_05.sqlpp |   2 +-
 ...secondary-composite-key-prefix-join_06.sqlpp |   2 +-
 .../secondary-equi-join-multiindex.sqlpp        |   2 +-
 .../secondary-equi-join-multipred.sqlpp         |   2 +-
 .../secondary-equi-join_01.sqlpp                |   2 +-
 .../secondary-equi-join_02.sqlpp                |   2 +-
 .../secondary-equi-join_03.sqlpp                |   2 +-
 .../secondary-equi-join_04.sqlpp                |   4 +--
 .../secondary-equi-join_05.sqlpp                |   2 +-
 .../btree-index/btree-secondary-33.sqlpp        |   2 +-
 .../btree-index/btree-secondary-34.sqlpp        |   2 +-
 .../btree-index/btree-secondary-35.sqlpp        |   2 +-
 .../btree-index/btree-secondary-36.sqlpp        |   2 +-
 .../btree-index/btree-secondary-37.sqlpp        |   2 +-
 .../btree-index/btree-secondary-38.sqlpp        |   2 +-
 .../btree-index/btree-secondary-39.sqlpp        |   2 +-
 .../btree-index/btree-secondary-40.sqlpp        |   2 +-
 .../btree-index/btree-secondary-41.sqlpp        |   2 +-
 .../btree-index/btree-secondary-42.sqlpp        |   2 +-
 .../btree-index/btree-secondary-43.sqlpp        |   2 +-
 .../btree-index/btree-secondary-44.sqlpp        |   2 +-
 .../btree-index/btree-secondary-45.sqlpp        |   2 +-
 .../btree-index/btree-secondary-46.sqlpp        |   2 +-
 .../btree-index/btree-secondary-47.sqlpp        |   2 +-
 .../btree-index/btree-secondary-48.sqlpp        |   2 +-
 .../btree-index/btree-secondary-49.sqlpp        |   2 +-
 .../btree-index/btree-secondary-50.sqlpp        |   2 +-
 .../btree-index/btree-secondary-51.sqlpp        |   2 +-
 .../btree-index/btree-secondary-52.sqlpp        |   2 +-
 .../btree-index/btree-secondary-53.sqlpp        |   2 +-
 .../btree-index/btree-secondary-54.sqlpp        |   2 +-
 .../btree-index/btree-secondary-55.sqlpp        |   2 +-
 .../btree-index/btree-secondary-56.sqlpp        |   2 +-
 .../btree-index/btree-secondary-57.sqlpp        |   2 +-
 .../btree-index/btree-secondary-58.sqlpp        |   2 +-
 .../btree-index/btree-secondary-59.sqlpp        |   2 +-
 .../btree-index/btree-secondary-60.sqlpp        |   2 +-
 .../btree-index/btree-secondary-61.sqlpp        |   2 +-
 .../btree-index/btree-secondary-62.sqlpp        |   2 +-
 .../btree-index/btree-secondary-63.sqlpp        |   2 +-
 .../ngram-contains-panic.sqlpp                  |   2 +-
 .../inverted-index-basic/ngram-contains.sqlpp   |   2 +-
 .../ngram-edit-distance-check-panic.sqlpp       |   2 +-
 .../ngram-edit-distance-check.sqlpp             |   2 +-
 .../ngram-edit-distance-panic.sqlpp             |   2 +-
 .../ngram-edit-distance.sqlpp                   |   2 +-
 .../ngram-fuzzyeq-edit-distance.sqlpp           |   2 +-
 .../ngram-fuzzyeq-jaccard.sqlpp                 |   2 +-
 .../ngram-jaccard-check.sqlpp                   |   2 +-
 .../inverted-index-basic/ngram-jaccard.sqlpp    |   2 +-
 .../inverted-index-basic/word-contains.sqlpp    |   2 +-
 .../word-fuzzyeq-jaccard.sqlpp                  |   2 +-
 .../word-jaccard-check.sqlpp                    |   2 +-
 .../inverted-index-basic/word-jaccard.sqlpp     |   2 +-
 ...it-distance-check-let-panic-nopanic_01.sqlpp |   2 +-
 ...it-distance-check-let-panic-nopanic_02.sqlpp |   2 +-
 .../ngram-edit-distance-check-let-panic.sqlpp   |   2 +-
 .../ngram-edit-distance-check-let.sqlpp         |   2 +-
 .../ngram-edit-distance-check-substring.sqlpp   |   2 +-
 .../ngram-edit-distance-check-word-tokens.sqlpp |   2 +-
 .../ngram-jaccard-check-let.sqlpp               |   2 +-
 .../ngram-jaccard-check-multi-let.sqlpp         |   2 +-
 .../word-jaccard-check-let.sqlpp                |   2 +-
 .../word-jaccard-check-multi-let.sqlpp          |   2 +-
 ...x-with-join-edit-distance-check-idx_01.sqlpp |   2 +-
 .../inverted-index-join/ngram-contains_01.sqlpp |   2 +-
 .../inverted-index-join/ngram-contains_02.sqlpp |   2 +-
 .../inverted-index-join/ngram-contains_03.sqlpp |   2 +-
 .../inverted-index-join/ngram-contains_04.sqlpp |   4 +--
 .../ngram-edit-distance-check_01.sqlpp          |   4 +--
 .../ngram-edit-distance-check_02.sqlpp          |   4 +--
 .../ngram-edit-distance-check_03.sqlpp          |   4 +--
 .../ngram-edit-distance-check_04.sqlpp          |   6 ++--
 .../ngram-edit-distance-check_05.sqlpp          |   6 ++--
 .../ngram-edit-distance-check_inline_03.sqlpp   |   4 +--
 .../ngram-edit-distance-contains.sqlpp          |   2 +-
 .../ngram-edit-distance_01.sqlpp                |   4 +--
 .../ngram-edit-distance_02.sqlpp                |   4 +--
 .../ngram-edit-distance_03.sqlpp                |   4 +--
 .../ngram-edit-distance_04.sqlpp                |   6 ++--
 .../ngram-edit-distance_05.sqlpp                |   6 ++--
 .../ngram-edit-distance_inline_03.sqlpp         |   4 +--
 .../ngram-fuzzyeq-edit-distance_01.sqlpp        |   4 +--
 .../ngram-fuzzyeq-edit-distance_02.sqlpp        |   4 +--
 .../ngram-fuzzyeq-edit-distance_03.sqlpp        |   4 +--
 .../ngram-fuzzyeq-edit-distance_04.sqlpp        |   6 ++--
 .../ngram-fuzzyeq-edit-distance_05.sqlpp        |   6 ++--
 .../ngram-fuzzyeq-jaccard_01.sqlpp              |   4 +--
 .../ngram-fuzzyeq-jaccard_02.sqlpp              |   4 +--
 .../ngram-fuzzyeq-jaccard_03.sqlpp              |   4 +--
 .../ngram-fuzzyeq-jaccard_04.sqlpp              |   6 ++--
 .../ngram-jaccard-check_01.sqlpp                |   4 +--
 .../ngram-jaccard-check_02.sqlpp                |   4 +--
 .../ngram-jaccard-check_03.sqlpp                |   4 +--
 .../ngram-jaccard-check_04.sqlpp                |   6 ++--
 .../ngram-jaccard-check_inline_03.sqlpp         |   4 +--
 .../inverted-index-join/ngram-jaccard_01.sqlpp  |   4 +--
 .../inverted-index-join/ngram-jaccard_02.sqlpp  |   4 +--
 .../inverted-index-join/ngram-jaccard_03.sqlpp  |   4 +--
 .../inverted-index-join/ngram-jaccard_04.sqlpp  |   6 ++--
 .../ngram-jaccard_inline_03.sqlpp               |   4 +--
 .../word-fuzzyeq-jaccard_01.sqlpp               |   4 +--
 .../word-fuzzyeq-jaccard_02.sqlpp               |   4 +--
 .../word-fuzzyeq-jaccard_03.sqlpp               |   4 +--
 .../word-fuzzyeq-jaccard_04.sqlpp               |   6 ++--
 .../word-jaccard-check-after-btree-access.sqlpp |   2 +-
 .../word-jaccard-check_01.sqlpp                 |   4 +--
 .../word-jaccard-check_02.sqlpp                 |   4 +--
 .../word-jaccard-check_03.sqlpp                 |   4 +--
 .../word-jaccard-check_04.sqlpp                 |   6 ++--
 .../word-jaccard-check_inline_03.sqlpp          |   4 +--
 .../inverted-index-join/word-jaccard_01.sqlpp   |   4 +--
 .../inverted-index-join/word-jaccard_02.sqlpp   |   4 +--
 .../inverted-index-join/word-jaccard_03.sqlpp   |   4 +--
 .../inverted-index-join/word-jaccard_04.sqlpp   |   6 ++--
 .../word-jaccard_inline_03.sqlpp                |   4 +--
 ...oin-probe-pidx-with-join-rtree-sidx_01.sqlpp |   2 +-
 ...oin-probe-pidx-with-join-rtree-sidx_02.sqlpp |   2 +-
 .../spatial-intersect-point_01.sqlpp            |   4 +--
 .../spatial-intersect-point_02.sqlpp            |   4 +--
 .../spatial-intersect-point_03.sqlpp            |   4 +--
 .../spatial-intersect-point_04.sqlpp            |   6 ++--
 .../spatial-intersect-point_05.sqlpp            |   4 +--
 .../drop-empty-secondary-indexes.1.ddl.aql      |   6 ++--
 ...n-dataset-with-index-on-open-field.1.ddl.aql |   2 +-
 .../load-with-index-open.1.ddl.aql              |   2 +-
 .../load-with-index-open_02.1.ddl.aql           |   6 ++--
 .../load-with-ngram-index-open.1.ddl.aql        |   2 +-
 .../load-with-rtree-index-open.1.ddl.aql        |   2 +-
 .../load-with-word-index-open.1.ddl.aql         |   2 +-
 ...-delete-btree-secondary-index-open.3.ddl.aql |   2 +-
 ...d-index-ngram-secondary-index-open.3.ddl.aql |   2 +-
 ...ed-index-word-secondary-index-open.3.ddl.aql |   2 +-
 ...-delete-rtree-secondary-index-open.3.ddl.aql |   2 +-
 ...-insert-btree-secondary-index-open.3.ddl.aql |   2 +-
 ...d-index-ngram-secondary-index-open.3.ddl.aql |   2 +-
 ...ed-index-word-secondary-index-open.3.ddl.aql |   2 +-
 ...-insert-rtree-secondary-index-open.3.ddl.aql |   2 +-
 ...-feed-with-meta-open-index-in-meta.1.ddl.aql |   2 +-
 ...ta-index-with-missing-after-ingest.3.ddl.aql |   2 +-
 ...eta-pk-in-meta-open-index-in-value.1.ddl.aql |   2 +-
 ...pk-in-meta-open-index-with-missing.1.ddl.aql |   2 +-
 ...th-external-parser-with-open-index.3.ddl.aql |   2 +-
 ...ernal-parser-with-two-open-indexes.3.ddl.aql |   4 +--
 .../feed-with-multiple-indexes.1.ddl.aql        |   8 +++---
 .../adm-format/adm-format.1.ddl.aql             |   2 +-
 .../leftouterjoin-rtree.1.ddl.aql               |   8 +++---
 .../leftouterjoin/leftouterjoin.1.ddl.aql       |   6 ++--
 .../rtree-index/rtree-index.1.ddl.aql           |   2 +-
 .../bottom-closed-top-closed.1.ddl.aql          |  14 +++++-----
 .../bottom-closed-top-open.1.ddl.aql            |  14 +++++-----
 .../bottom-open-top-closed.1.ddl.aql            |  18 ++++++------
 .../bottom-open-top-open.1.ddl.aql              |  18 ++++++------
 .../btree-secondary-equi-join.1.ddl.aql         |   2 +-
 .../btree-secondary-equi-join.2.update.aql      |   2 +-
 .../btree-secondary-equi-join.3.ddl.aql         |   4 +--
 .../btree-secondary-equi-join.4.query.aql       |   2 +-
 .../ngram-edit-distance-inline.3.ddl.aql        |   2 +-
 .../ngram-edit-distance.3.ddl.aql               |   2 +-
 .../ngram-jaccard-inline.3.ddl.aql              |   2 +-
 .../ngram-jaccard/ngram-jaccard.3.ddl.aql       |   2 +-
 .../rtree-spatial-intersect-point.1.ddl.aql     |   2 +-
 .../rtree-spatial-intersect-point.2.update.aql  |   2 +-
 .../rtree-spatial-intersect-point.3.ddl.aql     |   4 +--
 .../rtree-spatial-intersect-point.4.query.aql   |   2 +-
 .../word-jaccard-inline.3.ddl.aql               |   2 +-
 .../word-jaccard/word-jaccard.3.ddl.aql         |   2 +-
 .../probe-pidx-with-join-btree-sidx1.1.ddl.aql  |   2 +-
 .../probe-pidx-with-join-btree-sidx2.1.ddl.aql  |   2 +-
 .../probe-pidx-with-join-invidx-sidx2.1.ddl.aql |   2 +-
 .../probe-pidx-with-join-rtree-sidx1.1.ddl.aql  |   2 +-
 .../probe-pidx-with-join-rtree-sidx2.1.ddl.aql  |   2 +-
 ...ndex-composite-key-mixed-intervals.3.ddl.aql |   2 +-
 .../btree-index-composite-key.3.ddl.aql         |   2 +-
 .../btree-index-rewrite-multiple.3.ddl.aql      |   2 +-
 .../inverted-index-ngram-contains.3.ddl.aql     |   2 +-
 ...index-ngram-edit-distance-contains.3.ddl.aql |   2 +-
 ...ed-index-ngram-edit-distance-panic.3.ddl.aql |   2 +-
 ...ex-ngram-edit-distance-word-tokens.3.ddl.aql |   2 +-
 ...inverted-index-ngram-edit-distance.3.ddl.aql |   2 +-
 .../inverted-index-ngram-jaccard.3.ddl.aql      |   2 +-
 .../inverted-index-word-contains.3.ddl.aql      |   2 +-
 .../inverted-index-word-jaccard.3.ddl.aql       |   2 +-
 .../orders-index-custkey-conjunctive.3.ddl.aql  |   2 +-
 .../orders-index-custkey.3.ddl.aql              |   2 +-
 .../range-search/range-search.3.ddl.aql         |   2 +-
 .../rtree-secondary-index.3.ddl.aql             |   2 +-
 .../index-on-closed-type.1.ddl.aql              |   2 +-
 .../index-type-collision.1.ddl.aql              |   4 +--
 .../index-type-promotion-collision.1.ddl.aql    |   4 +--
 .../missing-enforce-statement.1.ddl.aql         |   2 +-
 .../missing-optionality.1.ddl.aql               |  28 +++++++++++++++++++
 .../record-collision.1.ddl.aql                  |   2 +-
 .../adm-format/adm-format.1.ddl.aql             |   2 +-
 .../leftouterjoin-rtree.1.ddl.aql               |   8 +++---
 .../leftouterjoin/leftouterjoin.1.ddl.aql       |   6 ++--
 .../rtree-index/rtree-index.1.ddl.aql           |   2 +-
 .../btree-secondary-equi-join.1.ddl.aql         |   2 +-
 .../btree-secondary-equi-join.2.update.aql      |   2 +-
 .../btree-secondary-equi-join.3.ddl.aql         |   4 +--
 .../btree-secondary-equi-join.4.query.aql       |   2 +-
 .../ngram-edit-distance-inline.3.ddl.aql        |   2 +-
 .../ngram-edit-distance.3.ddl.aql               |   2 +-
 .../ngram-jaccard-inline.3.ddl.aql              |   2 +-
 .../ngram-jaccard/ngram-jaccard.3.ddl.aql       |   2 +-
 .../rtree-spatial-intersect-point.1.ddl.aql     |   2 +-
 .../rtree-spatial-intersect-point.2.update.aql  |   2 +-
 .../rtree-spatial-intersect-point.3.ddl.aql     |   4 +--
 .../rtree-spatial-intersect-point.4.query.aql   |   2 +-
 .../word-jaccard-inline.3.ddl.aql               |   2 +-
 .../word-jaccard/word-jaccard.3.ddl.aql         |   2 +-
 .../probe-pidx-with-join-btree-sidx1.1.ddl.aql  |   2 +-
 .../probe-pidx-with-join-btree-sidx2.1.ddl.aql  |   2 +-
 .../probe-pidx-with-join-invidx-sidx2.1.ddl.aql |   2 +-
 .../probe-pidx-with-join-rtree-sidx1.1.ddl.aql  |   2 +-
 .../probe-pidx-with-join-rtree-sidx2.1.ddl.aql  |   2 +-
 ...ndex-composite-key-mixed-intervals.1.ddl.aql |   2 +-
 ...x-composite-key-mixed-intervals.2.update.aql |   2 +-
 ...ndex-composite-key-mixed-intervals.3.ddl.aql |   4 +--
 ...ex-composite-key-mixed-intervals.4.query.aql |   2 +-
 .../btree-index-composite-key.2.update.aql      |   2 +-
 .../btree-index-composite-key.3.ddl.aql         |   4 +--
 .../btree-index-composite-key.4.query.aql       |   2 +-
 .../btree-index-rewrite-multiple.3.ddl.aql      |   2 +-
 .../inverted-index-ngram-contains.3.ddl.aql     |   2 +-
 ...index-ngram-edit-distance-contains.3.ddl.aql |   2 +-
 ...ed-index-ngram-edit-distance-panic.3.ddl.aql |   2 +-
 ...ex-ngram-edit-distance-word-tokens.3.ddl.aql |   2 +-
 ...inverted-index-ngram-edit-distance.3.ddl.aql |   2 +-
 .../inverted-index-ngram-jaccard.3.ddl.aql      |   2 +-
 .../inverted-index-word-contains.3.ddl.aql      |   2 +-
 .../inverted-index-word-jaccard.3.ddl.aql       |   2 +-
 .../multi-index-composite-key.2.update.aql      |   2 +-
 .../multi-index-composite-key.3.ddl.aql         |   6 ++--
 .../multi-index-composite-key.4.query.aql       |   2 +-
 .../multi-index-composite-key.5.ddl.aql         |   2 +-
 .../multi-index-composite-key.6.query.aql       |   2 +-
 .../multi-index/multi-index.3.ddl.aql           |   6 ++--
 .../orders-index-custkey-conjunctive.3.ddl.aql  |   2 +-
 .../orders-index-custkey.3.ddl.aql              |   2 +-
 .../range-search/range-search.3.ddl.aql         |   2 +-
 .../rtree-secondary-index.3.ddl.aql             |   2 +-
 .../drop-empty-secondary-indexes.1.ddl.aql      |   6 ++--
 .../upsert/open-index/open-index.1.ddl.aql      |   2 +-
 .../drop-empty-secondary-indexes.1.ddl.sqlpp    |   6 ++--
 ...dataset-with-index-on-open-field.1.ddl.sqlpp |   2 +-
 .../load-with-index-open.1.ddl.sqlpp            |   2 +-
 .../load-with-ngram-index-open.1.ddl.sqlpp      |   2 +-
 .../load-with-rtree-index-open.1.ddl.sqlpp      |   2 +-
 .../load-with-word-index-open.1.ddl.sqlpp       |   2 +-
 ...elete-btree-secondary-index-open.3.ddl.sqlpp |   2 +-
 ...index-ngram-secondary-index-open.3.ddl.sqlpp |   2 +-
 ...-index-word-secondary-index-open.3.ddl.sqlpp |   2 +-
 ...elete-rtree-secondary-index-open.3.ddl.sqlpp |   2 +-
 ...nsert-btree-secondary-index-open.3.ddl.sqlpp |   2 +-
 ...index-ngram-secondary-index-open.3.ddl.sqlpp |   2 +-
 ...-index-word-secondary-index-open.3.ddl.sqlpp |   2 +-
 ...nsert-rtree-secondary-index-open.3.ddl.sqlpp |   2 +-
 .../global-aggregate/q01/q01.1.ddl.sqlpp        |   4 +--
 .../global-aggregate/q02/q02.1.ddl.sqlpp        |   4 +--
 .../global-aggregate/q03/q03.1.ddl.sqlpp        |   4 +--
 .../global-aggregate/q04/q04.1.ddl.sqlpp        |   4 +--
 .../q05_error/q05_error.1.ddl.sqlpp             |   4 +--
 .../q06_error/q06_error.1.ddl.sqlpp             |   4 +--
 .../q07_error/q07_error.1.ddl.sqlpp             |   4 +--
 .../global-aggregate/q08/q08.1.ddl.sqlpp        |   4 +--
 .../global-aggregate/q09/q09.1.ddl.sqlpp        |   4 +--
 .../global-aggregate/q10/q10.1.ddl.sqlpp        |   4 +--
 .../adm-format/adm-format.1.ddl.sqlpp           |   2 +-
 .../leftouterjoin-rtree.1.ddl.sqlpp             |   8 +++---
 .../leftouterjoin/leftouterjoin.1.ddl.sqlpp     |   6 ++--
 .../rtree-index/rtree-index.1.ddl.sqlpp         |   2 +-
 .../bottom-closed-top-closed.1.ddl.sqlpp        |  14 +++++-----
 .../bottom-closed-top-open.1.ddl.sqlpp          |  14 +++++-----
 .../bottom-open-top-closed.1.ddl.sqlpp          |  18 ++++++------
 .../bottom-open-top-open.1.ddl.sqlpp            |  18 ++++++------
 .../btree-secondary-equi-join.1.ddl.sqlpp       |   2 +-
 .../btree-secondary-equi-join.2.update.sqlpp    | Bin 1737 -> 1738 bytes
 .../btree-secondary-equi-join.3.ddl.sqlpp       |   4 +--
 .../btree-secondary-equi-join.4.query.sqlpp     |   2 +-
 .../ngram-edit-distance-inline.3.ddl.sqlpp      |   2 +-
 .../ngram-edit-distance.3.ddl.sqlpp             |   2 +-
 .../ngram-jaccard-inline.3.ddl.sqlpp            |   2 +-
 .../ngram-jaccard/ngram-jaccard.3.ddl.sqlpp     |   2 +-
 .../rtree-spatial-intersect-point.1.ddl.sqlpp   |   2 +-
 ...rtree-spatial-intersect-point.2.update.sqlpp |   2 +-
 .../rtree-spatial-intersect-point.3.ddl.sqlpp   |   4 +--
 .../rtree-spatial-intersect-point.4.query.sqlpp |   2 +-
 .../word-jaccard-inline.3.ddl.sqlpp             |   2 +-
 .../word-jaccard/word-jaccard.3.ddl.sqlpp       |   2 +-
 ...probe-pidx-with-join-btree-sidx1.1.ddl.sqlpp |   2 +-
 ...probe-pidx-with-join-btree-sidx2.1.ddl.sqlpp |   2 +-
 ...robe-pidx-with-join-invidx-sidx2.1.ddl.sqlpp |   2 +-
 ...probe-pidx-with-join-rtree-sidx1.1.ddl.sqlpp |   2 +-
 ...probe-pidx-with-join-rtree-sidx2.1.ddl.sqlpp |   2 +-
 ...ex-composite-key-mixed-intervals.3.ddl.sqlpp |   2 +-
 .../btree-index-composite-key.3.ddl.sqlpp       |   2 +-
 .../btree-index-rewrite-multiple.3.ddl.sqlpp    |   2 +-
 .../inverted-index-ngram-contains.3.ddl.sqlpp   |   2 +-
 ...dex-ngram-edit-distance-contains.3.ddl.sqlpp |   2 +-
 ...-index-ngram-edit-distance-panic.3.ddl.sqlpp |   2 +-
 ...-ngram-edit-distance-word-tokens.3.ddl.sqlpp |   2 +-
 ...verted-index-ngram-edit-distance.3.ddl.sqlpp |   2 +-
 .../inverted-index-ngram-jaccard.3.ddl.sqlpp    |   2 +-
 .../inverted-index-word-contains.3.ddl.sqlpp    |   2 +-
 .../inverted-index-word-jaccard.3.ddl.sqlpp     |   2 +-
 ...orders-index-custkey-conjunctive.3.ddl.sqlpp |   2 +-
 .../orders-index-custkey.3.ddl.sqlpp            |   2 +-
 .../range-search/range-search.3.ddl.sqlpp       |   2 +-
 .../rtree-secondary-index.3.ddl.sqlpp           |   2 +-
 .../enforced-field-name-collision.1.ddl.sqlpp   |   2 +-
 .../enforced-field-name-collision.1.ddl.sqlpp   |   2 +-
 .../index-on-closed-type.1.ddl.sqlpp            |   2 +-
 .../missing-enforce-statement.1.ddl.sqlpp       |   2 +-
 .../missing-optionality.1.ddl.sqlpp             |  28 +++++++++++++++++++
 .../adm-format/adm-format.1.ddl.sqlpp           |   2 +-
 .../leftouterjoin-rtree.1.ddl.sqlpp             |   8 +++---
 .../leftouterjoin/leftouterjoin.1.ddl.sqlpp     |   6 ++--
 .../rtree-index/rtree-index.1.ddl.sqlpp         |   2 +-
 .../btree-secondary-equi-join.1.ddl.sqlpp       |   2 +-
 .../btree-secondary-equi-join.2.update.sqlpp    | Bin 1647 -> 1648 bytes
 .../btree-secondary-equi-join.3.ddl.sqlpp       |   4 +--
 .../btree-secondary-equi-join.4.query.sqlpp     |   2 +-
 .../ngram-edit-distance-inline.3.ddl.sqlpp      |   2 +-
 .../ngram-edit-distance.3.ddl.sqlpp             |   2 +-
 .../ngram-jaccard-inline.3.ddl.sqlpp            |   2 +-
 .../ngram-jaccard/ngram-jaccard.3.ddl.sqlpp     |   2 +-
 .../rtree-spatial-intersect-point.1.ddl.sqlpp   |   2 +-
 ...rtree-spatial-intersect-point.2.update.sqlpp |   2 +-
 .../rtree-spatial-intersect-point.3.ddl.sqlpp   |   4 +--
 .../rtree-spatial-intersect-point.4.query.sqlpp |   2 +-
 .../word-jaccard-inline.3.ddl.sqlpp             |   2 +-
 .../word-jaccard/word-jaccard.3.ddl.sqlpp       |   2 +-
 ...probe-pidx-with-join-btree-sidx1.1.ddl.sqlpp |   2 +-
 ...probe-pidx-with-join-btree-sidx2.1.ddl.sqlpp |   2 +-
 ...robe-pidx-with-join-invidx-sidx2.1.ddl.sqlpp |   2 +-
 ...probe-pidx-with-join-rtree-sidx1.1.ddl.sqlpp |   2 +-
 ...probe-pidx-with-join-rtree-sidx2.1.ddl.sqlpp |   2 +-
 ...ex-composite-key-mixed-intervals.1.ddl.sqlpp |   2 +-
 ...composite-key-mixed-intervals.2.update.sqlpp |   2 +-
 ...ex-composite-key-mixed-intervals.3.ddl.sqlpp |   4 +--
 ...-composite-key-mixed-intervals.4.query.sqlpp |   2 +-
 .../btree-index-composite-key.2.update.sqlpp    |   2 +-
 .../btree-index-composite-key.3.ddl.sqlpp       |   4 +--
 .../btree-index-composite-key.4.query.sqlpp     |   2 +-
 .../btree-index-rewrite-multiple.3.ddl.sqlpp    |   2 +-
 .../inverted-index-ngram-contains.3.ddl.sqlpp   |   2 +-
 ...dex-ngram-edit-distance-contains.3.ddl.sqlpp |   2 +-
 ...-index-ngram-edit-distance-panic.3.ddl.sqlpp |   2 +-
 ...-ngram-edit-distance-word-tokens.3.ddl.sqlpp |   2 +-
 ...verted-index-ngram-edit-distance.3.ddl.sqlpp |   2 +-
 .../inverted-index-ngram-jaccard.3.ddl.sqlpp    |   2 +-
 .../inverted-index-word-contains.3.ddl.sqlpp    |   2 +-
 .../inverted-index-word-jaccard.3.ddl.sqlpp     |   2 +-
 ...orders-index-custkey-conjunctive.3.ddl.sqlpp |   2 +-
 .../orders-index-custkey.3.ddl.sqlpp            |   2 +-
 .../range-search/range-search.3.ddl.sqlpp       |   2 +-
 .../rtree-secondary-index.3.ddl.sqlpp           |   2 +-
 .../drop-empty-secondary-indexes.1.ddl.sqlpp    |   6 ++--
 .../tinysocial-suite.2.ddl.sqlpp                |   4 +--
 .../src/test/resources/runtimets/testsuite.xml  |   6 ++++
 .../resources/runtimets/testsuite_sqlpp.xml     |   6 ++++
 .../asterix-lang-aql/src/main/javacc/AQL.jj     |   2 +-
 .../asterix-lang-sqlpp/src/main/javacc/SQLPP.jj |   2 +-
 788 files changed, 1140 insertions(+), 1072 deletions(-)
----------------------------------------------------------------------


http://git-wip-us.apache.org/repos/asf/asterixdb/blob/af8e19df/asterixdb/asterix-app/src/test/resources/metadata/queries/basic/meta16/meta16.1.ddl.aql
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/metadata/queries/basic/meta16/meta16.1.ddl.aql b/asterixdb/asterix-app/src/test/resources/metadata/queries/basic/meta16/meta16.1.ddl.aql
index a64569f..cd0c11a 100644
--- a/asterixdb/asterix-app/src/test/resources/metadata/queries/basic/meta16/meta16.1.ddl.aql
+++ b/asterixdb/asterix-app/src/test/resources/metadata/queries/basic/meta16/meta16.1.ddl.aql
@@ -31,6 +31,6 @@ id : int32
 
 create dataset testdv.t1(testtype) primary key id;
 
-create index idx1 on testdv.t1(name: string) enforced;
+create index idx1 on testdv.t1(name: string?) enforced;
 
 /* drop index testdv.t1.idx1; */

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/af8e19df/asterixdb/asterix-app/src/test/resources/metadata/queries/basic/meta17/meta17.1.ddl.aql
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/metadata/queries/basic/meta17/meta17.1.ddl.aql b/asterixdb/asterix-app/src/test/resources/metadata/queries/basic/meta17/meta17.1.ddl.aql
index 0f92326..4205378 100644
--- a/asterixdb/asterix-app/src/test/resources/metadata/queries/basic/meta17/meta17.1.ddl.aql
+++ b/asterixdb/asterix-app/src/test/resources/metadata/queries/basic/meta17/meta17.1.ddl.aql
@@ -32,4 +32,4 @@ name : string?
 
 create dataset testdv.t1(testtype) primary key id;
 
-create index idx1 on testdv.t1(location: point) type rtree enforced;
+create index idx1 on testdv.t1(location: point?) type rtree enforced;

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/af8e19df/asterixdb/asterix-app/src/test/resources/metadata/queries/basic/meta24/meta24.1.ddl.aql
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/metadata/queries/basic/meta24/meta24.1.ddl.aql b/asterixdb/asterix-app/src/test/resources/metadata/queries/basic/meta24/meta24.1.ddl.aql
index 7ae4adb..2d6b3c0 100644
--- a/asterixdb/asterix-app/src/test/resources/metadata/queries/basic/meta24/meta24.1.ddl.aql
+++ b/asterixdb/asterix-app/src/test/resources/metadata/queries/basic/meta24/meta24.1.ddl.aql
@@ -31,4 +31,4 @@ id : int32
 
 create dataset testdv.t1(testtype) primary key id;
 
-create index idx1 on testdv.t1(name: string) type btree enforced;
+create index idx1 on testdv.t1(name: string?) type btree enforced;

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/af8e19df/asterixdb/asterix-app/src/test/resources/optimizerts/queries/meta/secondary_index-lojoin_with_meta-1.aql
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/meta/secondary_index-lojoin_with_meta-1.aql b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/meta/secondary_index-lojoin_with_meta-1.aql
index 788db55..4107ad2 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/meta/secondary_index-lojoin_with_meta-1.aql
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/meta/secondary_index-lojoin_with_meta-1.aql
@@ -33,9 +33,9 @@ create dataset Book(LineType) with meta(AuxiliaryType)
 primary key meta().id;
 
 create index NumIndex1 on Book(meta().num);
-create index NumIndex2 on Book(linenum:int32) enforced;
-create index NumIndex3 on Book(count1:int32) enforced;
-create index NumIndex4 on Book(count2:int32) enforced;
+create index NumIndex2 on Book(linenum:int32?) enforced;
+create index NumIndex3 on Book(count1:int32?) enforced;
+create index NumIndex4 on Book(count2:int32?) enforced;
 
 for $t1 in dataset Book
 where $t1.linenum < 10
@@ -48,4 +48,4 @@ return {
           order by $t2.linenum
           return {"linenum2": $t2.linenum,
                   "count2":$t2.count2}
-};
\ No newline at end of file
+};

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/af8e19df/asterixdb/asterix-app/src/test/resources/optimizerts/queries/meta/secondary_index-nljoin_with_meta-1.aql
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/meta/secondary_index-nljoin_with_meta-1.aql b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/meta/secondary_index-nljoin_with_meta-1.aql
index 447c25c..1dc3b44 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/meta/secondary_index-nljoin_with_meta-1.aql
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/meta/secondary_index-nljoin_with_meta-1.aql
@@ -32,9 +32,9 @@ create type LineType as open {
 create dataset Book(LineType) with meta(AuxiliaryType)
 primary key meta().id;
 
-create index NumIndex on Book(lineid:int64) enforced;
+create index NumIndex on Book(lineid:int64?) enforced;
 
 for $x in dataset Book
 for $y in dataset Book
 where $x.lineid /*+ indexnl */ = $y.lineid
-return {"authx":$x.author,"authy":$y.author};
\ No newline at end of file
+return {"authx":$x.author,"authy":$y.author};

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/af8e19df/asterixdb/asterix-app/src/test/resources/optimizerts/queries/meta/secondary_index-nljoin_with_meta-2.aql
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/meta/secondary_index-nljoin_with_meta-2.aql b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/meta/secondary_index-nljoin_with_meta-2.aql
index 1545f33..09ffd0a 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/meta/secondary_index-nljoin_with_meta-2.aql
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/meta/secondary_index-nljoin_with_meta-2.aql
@@ -38,9 +38,9 @@ primary key meta().id;
 create dataset Book2(LineTypeWithNum) with meta(AuxiliaryType)
 primary key meta().id;
 
-create index NumIndex on Book1(lineid:int64) enforced;
+create index NumIndex on Book1(lineid:int64?) enforced;
 
 for $y in dataset Book2
 for $x in dataset Book1
 where $y.lineid  /*+ indexnl */=  $x.lineid
-return {"authx":$x.author,"authy":$y.author};
\ No newline at end of file
+return {"authx":$x.author,"authy":$y.author};

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/af8e19df/asterixdb/asterix-app/src/test/resources/optimizerts/queries/meta/secondary_index_with_meta-2.aql
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/meta/secondary_index_with_meta-2.aql b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/meta/secondary_index_with_meta-2.aql
index 7f13ac3..b570498 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/meta/secondary_index_with_meta-2.aql
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/meta/secondary_index_with_meta-2.aql
@@ -32,7 +32,7 @@ create type LineType as open {
 create dataset Book(LineType) with meta(AuxiliaryType)
 primary key meta().id;
 
-create index NumIndex on Book(lineid:int64) enforced;
+create index NumIndex on Book(lineid:int64?) enforced;
 
 for $x in dataset Book
 where $x.lineid >10

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/af8e19df/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-index/rtree-index-join/spatial-intersect-point_01.aql
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-index/rtree-index-join/spatial-intersect-point_01.aql b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-index/rtree-index-join/spatial-intersect-point_01.aql
index b5f36e7..1812b3b 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-index/rtree-index-join/spatial-intersect-point_01.aql
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-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-index/rtree-index-join/spatial-intersect-point_02.aql
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-index/rtree-index-join/spatial-intersect-point_02.aql b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-index/rtree-index-join/spatial-intersect-point_02.aql
index 76eb7c9..bed6626 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-index/rtree-index-join/spatial-intersect-point_02.aql
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-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-index/rtree-index-join/spatial-intersect-point_03.aql
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-index/rtree-index-join/spatial-intersect-point_03.aql b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-index/rtree-index-join/spatial-intersect-point_03.aql
index 5d0b806..e991ee8 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-index/rtree-index-join/spatial-intersect-point_03.aql
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-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/btree-index-join/disjunction-to-join.aql
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/btree-index-join/disjunction-to-join.aql b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/btree-index-join/disjunction-to-join.aql
index f72b875..707ba4d 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/btree-index-join/disjunction-to-join.aql
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/btree-index-join/disjunction-to-join.aql
@@ -37,7 +37,7 @@ create type TestType as open {
 
 
 create dataset TestSet(TestType) primary key "id";
-create index TestSetIndex on TestSet(nested.idx: string) enforced;
+create index TestSetIndex on TestSet(nested.idx: string?) enforced;
 
 for $x in dataset TestSet 
 where $x.nested.idx = "one" or $x.nested.idx = "two"

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/af8e19df/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/btree-index-join/leftouterjoin-probe-pidx-with-join-btree-sidx_01_1.aql
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/btree-index-join/leftouterjoin-probe-pidx-with-join-btree-sidx_01_1.aql b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/btree-index-join/leftouterjoin-probe-pidx-with-join-btree-sidx_01_1.aql
index 7991694..20d8a7c 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/btree-index-join/leftouterjoin-probe-pidx-with-join-btree-sidx_01_1.aql
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/btree-index-join/leftouterjoin-probe-pidx-with-join-btree-sidx_01_1.aql
@@ -53,7 +53,7 @@ create type TweetMessageType as open {
 create dataset TweetMessages(TweetMessageType)
 primary key nested.tweetid;
 
-create index msgCountBIx on TweetMessages(nested.countB: int32) type btree enforced;
+create index msgCountBIx on TweetMessages(nested.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/nested-open-index/btree-index-join/leftouterjoin-probe-pidx-with-join-btree-sidx_01_2.aql
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/btree-index-join/leftouterjoin-probe-pidx-with-join-btree-sidx_01_2.aql b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/btree-index-join/leftouterjoin-probe-pidx-with-join-btree-sidx_01_2.aql
index 81746b9..84d653f 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/btree-index-join/leftouterjoin-probe-pidx-with-join-btree-sidx_01_2.aql
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/btree-index-join/leftouterjoin-probe-pidx-with-join-btree-sidx_01_2.aql
@@ -52,8 +52,8 @@ create type TweetMessageType as open {
 create dataset TweetMessages(TweetMessageType)
 primary key nested.tweetid;
 
-create index msgCountAIx on TweetMessages(nested.countA: int32) type btree enforced;
-create index msgCountBIx on TweetMessages(nested.countB: int32) type btree enforced;
+create index msgCountAIx on TweetMessages(nested.countA: int32?) type btree enforced;
+create index msgCountBIx on TweetMessages(nested.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/nested-open-index/btree-index-join/leftouterjoin-probe-pidx-with-join-btree-sidx_02_1.aql
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/btree-index-join/leftouterjoin-probe-pidx-with-join-btree-sidx_02_1.aql b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/btree-index-join/leftouterjoin-probe-pidx-with-join-btree-sidx_02_1.aql
index d23c8fa..8cc857b 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/btree-index-join/leftouterjoin-probe-pidx-with-join-btree-sidx_02_1.aql
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/btree-index-join/leftouterjoin-probe-pidx-with-join-btree-sidx_02_1.aql
@@ -53,7 +53,7 @@ create type TweetMessageType as open {
 create dataset TweetMessages(TweetMessageType)
 primary key nested.tweetid;
 
-create index msgCountBIx on TweetMessages(nested.countB: int32) type btree enforced;
+create index msgCountBIx on TweetMessages(nested.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/nested-open-index/btree-index-join/leftouterjoin-probe-pidx-with-join-btree-sidx_02_2.aql
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/btree-index-join/leftouterjoin-probe-pidx-with-join-btree-sidx_02_2.aql b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/btree-index-join/leftouterjoin-probe-pidx-with-join-btree-sidx_02_2.aql
index f58b102..7b7cb85 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/btree-index-join/leftouterjoin-probe-pidx-with-join-btree-sidx_02_2.aql
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/btree-index-join/leftouterjoin-probe-pidx-with-join-btree-sidx_02_2.aql
@@ -52,8 +52,8 @@ create type TweetMessageType as open {
 create dataset TweetMessages(TweetMessageType)
 primary key nested.tweetid;
 
-create index msgCountAIx on TweetMessages(nested.countA: int32) type btree enforced;
-create index msgCountBIx on TweetMessages(nested.countB: int32) type btree enforced;
+create index msgCountAIx on TweetMessages(nested.countA: int32?) type btree enforced;
+create index msgCountBIx on TweetMessages(nested.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/nested-open-index/btree-index-join/secondary-composite-key-join_01.aql
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/btree-index-join/secondary-composite-key-join_01.aql b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/btree-index-join/secondary-composite-key-join_01.aql
index ad3769c..6792ae4 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/btree-index-join/secondary-composite-key-join_01.aql
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/btree-index-join/secondary-composite-key-join_01.aql
@@ -36,7 +36,7 @@ create type NameType as open {
 }
 
 create dataset Names(NameType) primary key nested.id;
-create index Name_idx on Names(nested.fname: string,lnested.name: string) enforced;
+create index Name_idx on Names(nested.fname: string?,lnested.name: 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/nested-open-index/btree-index-join/secondary-composite-key-join_02.aql
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/btree-index-join/secondary-composite-key-join_02.aql b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/btree-index-join/secondary-composite-key-join_02.aql
index 5d8db16..a4a2dbd 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/btree-index-join/secondary-composite-key-join_02.aql
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/btree-index-join/secondary-composite-key-join_02.aql
@@ -36,7 +36,7 @@ create type NameType as open {
 }
 
 create dataset Names(NameType) primary key nested.id;
-create index Name_idx on Names(nested.fname: string,lnested.name: string) enforced;
+create index Name_idx on Names(nested.fname: string?,lnested.name: 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/nested-open-index/btree-index-join/secondary-composite-key-join_03.aql
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/btree-index-join/secondary-composite-key-join_03.aql b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/btree-index-join/secondary-composite-key-join_03.aql
index f33a1d0..6a1e4e9 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/btree-index-join/secondary-composite-key-join_03.aql
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/btree-index-join/secondary-composite-key-join_03.aql
@@ -36,7 +36,7 @@ create type NameType as open {
 }
 
 create dataset Names(NameType) primary key nested.id;
-create index Name_idx on Names(nested.fname: string,lnested.name: string) enforced;
+create index Name_idx on Names(nested.fname: string?,lnested.name: 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/nested-open-index/btree-index-join/secondary-composite-key-prefix-join_01.aql
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/btree-index-join/secondary-composite-key-prefix-join_01.aql b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/btree-index-join/secondary-composite-key-prefix-join_01.aql
index e0db31b..c92b4e5 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/btree-index-join/secondary-composite-key-prefix-join_01.aql
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/btree-index-join/secondary-composite-key-prefix-join_01.aql
@@ -36,7 +36,7 @@ create type NameType as open {
 }
 
 create dataset Names(NameType) primary key nested.id;
-create index Name_idx on Names(nested.fname: string,lnested.name: string) enforced;
+create index Name_idx on Names(nested.fname: string?,lnested.name: 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/nested-open-index/btree-index-join/secondary-composite-key-prefix-join_02.aql
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/btree-index-join/secondary-composite-key-prefix-join_02.aql b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/btree-index-join/secondary-composite-key-prefix-join_02.aql
index 7fdd838..064abc8 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/btree-index-join/secondary-composite-key-prefix-join_02.aql
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/btree-index-join/secondary-composite-key-prefix-join_02.aql
@@ -36,7 +36,7 @@ create type NameType as open {
 }
 
 create dataset Names(NameType) primary key nested.id;
-create index Name_idx on Names(nested.fname: string,lnested.name: string) enforced;
+create index Name_idx on Names(nested.fname: string?,lnested.name: 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/nested-open-index/btree-index-join/secondary-composite-key-prefix-join_03.aql
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/btree-index-join/secondary-composite-key-prefix-join_03.aql b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/btree-index-join/secondary-composite-key-prefix-join_03.aql
index e1dfd2c..ec9520c 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/btree-index-join/secondary-composite-key-prefix-join_03.aql
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/btree-index-join/secondary-composite-key-prefix-join_03.aql
@@ -36,7 +36,7 @@ create type NameType as open {
 }
 
 create dataset Names(NameType) primary key nested.id;
-create index Name_idx on Names(nested.fname: string,lnested.name: string) enforced;
+create index Name_idx on Names(nested.fname: string?,lnested.name: 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/nested-open-index/btree-index-join/secondary-composite-key-prefix-join_04.aql
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/btree-index-join/secondary-composite-key-prefix-join_04.aql b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/btree-index-join/secondary-composite-key-prefix-join_04.aql
index 01ce4ce..0370ad9 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/btree-index-join/secondary-composite-key-prefix-join_04.aql
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/btree-index-join/secondary-composite-key-prefix-join_04.aql
@@ -36,7 +36,7 @@ create type NameType as open {
 }
 
 create dataset Names(NameType) primary key nested.id;
-create index Name_idx on Names(nested.fname: string,lnested.name: string) enforced;
+create index Name_idx on Names(nested.fname: string?,lnested.name: 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/nested-open-index/btree-index-join/secondary-composite-key-prefix-join_05.aql
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/btree-index-join/secondary-composite-key-prefix-join_05.aql b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/btree-index-join/secondary-composite-key-prefix-join_05.aql
index a1e2581..4911f67 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/btree-index-join/secondary-composite-key-prefix-join_05.aql
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/btree-index-join/secondary-composite-key-prefix-join_05.aql
@@ -36,7 +36,7 @@ create type NameType as open {
 }
 
 create dataset Names(NameType) primary key nested.id;
-create index Name_idx on Names(nested.fname: string,lnested.name: string) enforced;
+create index Name_idx on Names(nested.fname: string?,lnested.name: 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/nested-open-index/btree-index-join/secondary-composite-key-prefix-join_06.aql
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/btree-index-join/secondary-composite-key-prefix-join_06.aql b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/btree-index-join/secondary-composite-key-prefix-join_06.aql
index 4765190..67a8e12 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/btree-index-join/secondary-composite-key-prefix-join_06.aql
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/btree-index-join/secondary-composite-key-prefix-join_06.aql
@@ -36,7 +36,7 @@ create type NameType as open {
 }
 
 create dataset Names(NameType) primary key nested.id;
-create index Name_idx on Names(nested.fname: string,lnested.name: string) enforced;
+create index Name_idx on Names(nested.fname: string?,lnested.name: 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/nested-open-index/btree-index-join/secondary-equi-join-multiindex.aql
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/btree-index-join/secondary-equi-join-multiindex.aql b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/btree-index-join/secondary-equi-join-multiindex.aql
index bcaaf61..4c2e45c 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/btree-index-join/secondary-equi-join-multiindex.aql
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/btree-index-join/secondary-equi-join-multiindex.aql
@@ -69,7 +69,7 @@ primary key nested.id;
 create dataset FacebookMessages(FacebookMessageType)
 primary key nested.message-id;
 
-create index fbmIdxAutId if not exists on FacebookMessages(nested.author-id-copy: int32) enforced;
+create index fbmIdxAutId if not exists on FacebookMessages(nested.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/nested-open-index/btree-index-join/secondary-equi-join-multipred.aql
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/btree-index-join/secondary-equi-join-multipred.aql b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/btree-index-join/secondary-equi-join-multipred.aql
index b4e7e78..c46530c 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/btree-index-join/secondary-equi-join-multipred.aql
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/btree-index-join/secondary-equi-join-multipred.aql
@@ -56,7 +56,7 @@ create dataset DBLP(DBLPType) primary key nested.id;
 
 create dataset CSX(CSXType) primary key nested.id;
 
-create index title_index on DBLP(nested.title:string) enforced;
+create index title_index on DBLP(nested.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/nested-open-index/btree-index-join/secondary-equi-join_01.aql
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/btree-index-join/secondary-equi-join_01.aql b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/btree-index-join/secondary-equi-join_01.aql
index fca3294..1306f66 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/btree-index-join/secondary-equi-join_01.aql
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/btree-index-join/secondary-equi-join_01.aql
@@ -54,7 +54,7 @@ create dataset DBLP(DBLPType) primary key nested.id;
 
 create dataset CSX(CSXType) primary key nested.id;
 
-create index title_index on DBLP(nested.title: string) enforced;
+create index title_index on DBLP(nested.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/nested-open-index/btree-index-join/secondary-equi-join_02.aql
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/btree-index-join/secondary-equi-join_02.aql b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/btree-index-join/secondary-equi-join_02.aql
index 3706a38..bf3fdb3 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/btree-index-join/secondary-equi-join_02.aql
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/btree-index-join/secondary-equi-join_02.aql
@@ -54,7 +54,7 @@ create dataset DBLP(DBLPType) primary key nested.id;
 
 create dataset CSX(CSXType) primary key nested.id;
 
-create index title_index on CSX(nested.title: string) enforced;
+create index title_index on CSX(nested.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/nested-open-index/btree-index-join/secondary-equi-join_03.aql
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/btree-index-join/secondary-equi-join_03.aql b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/btree-index-join/secondary-equi-join_03.aql
index ebf2a45..6447343 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/btree-index-join/secondary-equi-join_03.aql
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/btree-index-join/secondary-equi-join_03.aql
@@ -53,9 +53,9 @@ create dataset DBLP(DBLPType) primary key nested.id;
 
 create dataset CSX(CSXType) primary key nested.id;
 
-create index title_index_DBLP on DBLP(nested.title: string) enforced;
+create index title_index_DBLP on DBLP(nested.title: string?) enforced;
 
-create index title_index_CSX on CSX(nested.title: string) enforced;
+create index title_index_CSX on CSX(nested.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/nested-open-index/btree-index-join/secondary-equi-join_04.aql
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/btree-index-join/secondary-equi-join_04.aql b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/btree-index-join/secondary-equi-join_04.aql
index bccab0d..5b77bb4 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/btree-index-join/secondary-equi-join_04.aql
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/btree-index-join/secondary-equi-join_04.aql
@@ -40,7 +40,7 @@ create type DBLPType as open {
 
 create dataset DBLP(DBLPType) primary key nested.id;
 
-create index title_index on DBLP(nested.title: string) enforced;
+create index title_index on DBLP(nested.title: string?) enforced;
 
 write output to asterix_nc1:"rttest/btree-index-join_title-secondary-equi-join_04.adm";
 

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/af8e19df/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/btree-index-join/secondary-equi-join_05.aql
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/btree-index-join/secondary-equi-join_05.aql b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/btree-index-join/secondary-equi-join_05.aql
index 88dd85a..83ed7b0 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/btree-index-join/secondary-equi-join_05.aql
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/btree-index-join/secondary-equi-join_05.aql
@@ -53,7 +53,7 @@ create dataset DBLP(DBLPType) primary key nested.id;
 
 create dataset CSX(CSXType) primary key nested.id;
 
-create index title_index on DBLP(nested.title: string) enforced;
+create index title_index on DBLP(nested.title: string?) enforced;
 
 write output to asterix_nc1:"rttest/btree-index-join_title-secondary-equi-join_05.adm";
 

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/af8e19df/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/btree-index/btree-secondary-33.aql
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/btree-index/btree-secondary-33.aql b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/btree-index/btree-secondary-33.aql
index e0d0c21..a73ec15 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/btree-index/btree-secondary-33.aql
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/btree-index/btree-secondary-33.aql
@@ -42,7 +42,7 @@ create type TestType as open {
 
 create dataset testdst(TestType) primary key nested.id;
 
-create index sec_Idx on testdst(nested.fname: string,nested.lname: string) enforced;
+create index sec_Idx on testdst(nested.fname: string?,nested.lname: string?) enforced;
 
 for $emp in dataset('testdst')
 where $emp.nested.fname > "Roger"

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/af8e19df/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/btree-index/btree-secondary-34.aql
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/btree-index/btree-secondary-34.aql b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/btree-index/btree-secondary-34.aql
index 4da27c0..351b6f3 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/btree-index/btree-secondary-34.aql
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/btree-index/btree-secondary-34.aql
@@ -42,7 +42,7 @@ create type TestType as open {
 
 create dataset testdst(TestType) primary key nested.id;
 
-create index sec_Idx on testdst(nested.fname:string,nested.lname:string) enforced;
+create index sec_Idx on testdst(nested.fname:string?,nested.lname:string?) enforced;
 
 for $emp in dataset('testdst')
 where $emp.nested.fname >= "Susan"

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/af8e19df/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/btree-index/btree-secondary-35.aql
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/btree-index/btree-secondary-35.aql b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/btree-index/btree-secondary-35.aql
index 5733c4d..d20add6 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/btree-index/btree-secondary-35.aql
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/btree-index/btree-secondary-35.aql
@@ -42,7 +42,7 @@ create type TestType as open {
 
 create dataset testdst(TestType) primary key nested.id;
 
-create index sec_Idx on testdst(nested.fname:string,nested.lname:string) enforced;
+create index sec_Idx on testdst(nested.fname:string?,nested.lname:string?) enforced;
 
 for $emp in dataset('testdst')
 where $emp.nested.fname < "Isa"

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/af8e19df/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/btree-index/btree-secondary-36.aql
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/btree-index/btree-secondary-36.aql b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/btree-index/btree-secondary-36.aql
index 75e3002..447d73a 100644
--- a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/btree-index/btree-secondary-36.aql
+++ b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/nested-open-index/btree-index/btree-secondary-36.aql
@@ -42,7 +42,7 @@ create type TestType as open {
 
 create dataset testdst(TestType) primary key nested.id;
 
-create index sec_Idx on testdst(nested.fname:string,nested.lname:string) enforced;
+create index sec_Idx on testdst(nested.fname:string?,nested.lname:string?) enforced;
 
 for $emp in dataset('testdst')
 where $emp.nested.fname <= "Vanpatten"


Mime
View raw message