asterixdb-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From buyin...@apache.org
Subject [34/34] incubator-asterixdb git commit: SQL++ support in AsterixDB: 1. implemented SQL++ expression to logical plan translator; 2. refactored REST API to be agnostic of query languages; 3. disabled fuzzy join queries for SQL++ runtime tests; 4. fixed sev
Date Tue, 17 Nov 2015 00:57:06 GMT
SQL++ support in AsterixDB:
1. implemented SQL++ expression to logical plan translator;
2. refactored REST API to be agnostic of query languages;
3. disabled fuzzy join queries for SQL++ runtime tests;
4. fixed several rewriting rules.

Change-Id: I82919c4527b304325059519d819a2c30cf2902a9
Reviewed-on: https://asterix-gerrit.ics.uci.edu/479
Reviewed-by: Till Westmann <tillw@apache.org>
Tested-by: Jenkins <jenkins@fulliautomatix.ics.uci.edu>


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

Branch: refs/heads/master
Commit: caea8f0e982065c4347b62c50c5ec6d5fabbba6b
Parents: d03d673
Author: Yingyi Bu <buyingyi@gmail.com>
Authored: Mon Nov 16 15:12:15 2015 -0800
Committer: Yingyi Bu <buyingyi@gmail.com>
Committed: Mon Nov 16 16:52:32 2015 -0800

----------------------------------------------------------------------
 .../base/ILangExpressionToPlanTranslator.java   |   62 +
 .../ILangExpressionToPlanTranslatorFactory.java |   37 +
 .../base/LogicalOperatorDeepCopyVisitor.java    |   13 +
 .../provider/AqlCompilationProvider.java        |   52 +
 .../provider/ILangCompilationProvider.java      |   48 +
 .../provider/SqlppCompilationProvider.java      |   52 +
 .../jobgen/AqlLogicalExpressionJobGen.java      |  221 -
 .../jobgen/QueryLogicalExpressionJobGen.java    |  221 +
 .../asterix/optimizer/base/FuzzyUtils.java      |   10 +-
 .../asterix/optimizer/base/RuleCollections.java |   10 +-
 ...quivalenceClassForRecordConstructorRule.java |   10 +-
 .../rules/ByNameToByHandleFieldAccessRule.java  |   12 +-
 .../rules/ByNameToByIndexFieldAccessRule.java   |    8 +-
 .../CancelUnnestWithNestedListifyRule.java      |   16 +-
 .../optimizer/rules/ConstantFoldingRule.java    |    4 +-
 .../rules/FeedScanCollectionToUnnest.java       |    6 +-
 .../asterix/optimizer/rules/FuzzyEqRule.java    |   15 +-
 .../rules/IfElseToSwitchCaseFunctionRule.java   |    9 +-
 .../rules/IntroduceAutogenerateIDRule.java      |   27 +-
 .../rules/IntroduceDynamicTypeCastRule.java     |   16 +-
 ...IntroduceSecondaryIndexInsertDeleteRule.java |  119 +-
 ...roduceUnnestForCollectionToSequenceRule.java |   15 +-
 .../PullPositionalVariableFromUnnestRule.java   |    9 +-
 .../optimizer/rules/PushFieldAccessRule.java    |   23 +-
 .../rules/RemoveRedundantListifyRule.java       |   20 +-
 .../rules/RemoveUnusedOneToOneEquiJoinRule.java |   16 +-
 .../rules/SetClosedRecordConstructorsRule.java  |   16 +-
 .../optimizer/rules/SimilarityCheckRule.java    |   46 +-
 .../SweepIllegalNonfunctionalFunctions.java     |    6 +
 .../am/AbstractIntroduceAccessMethodRule.java   |    8 +-
 .../optimizer/rules/am/AccessMethodUtils.java   |   10 +-
 .../optimizer/rules/am/BTreeAccessMethod.java   |    9 +-
 .../rules/am/InvertedIndexAccessMethod.java     |   12 +-
 .../optimizer/rules/am/RTreeAccessMethod.java   |    5 +-
 .../TranslateIntervalExpressionRule.java        |   11 +-
 .../rules/typecast/StaticTypeCastUtil.java      |   48 +-
 .../rules/util/EquivalenceClassUtils.java       |   18 +-
 .../translator/AbstractAqlTranslator.java       |  189 -
 .../translator/AbstractLangTranslator.java      |  190 +
 .../AqlExpressionToPlanTranslator.java          | 1451 +---
 .../AqlExpressionToPlanTranslatorFactory.java   |   34 +
 .../AqlPlusExpressionToPlanTranslator.java      |   38 +-
 .../asterix/translator/CompiledStatements.java  |   67 +-
 .../LangExpressionToPlanTranslator.java         | 1241 ++++
 .../SqlppExpressionToPlanTranslator.java        |  492 ++
 .../SqlppExpressionToPlanTranslatorFactory.java |   34 +
 .../asterix/translator/TranslationContext.java  |   51 +-
 .../apache/asterix/api/common/APIFramework.java |   75 +-
 .../asterix/api/common/FeedWorkCollection.java  |   18 +-
 .../asterix/api/http/servlet/APIServlet.java    |   42 +-
 .../asterix/api/http/servlet/AQLAPIServlet.java |    5 +
 .../asterix/api/http/servlet/DDLAPIServlet.java |    8 +-
 .../api/http/servlet/QueryAPIServlet.java       |    8 +-
 .../api/http/servlet/RESTAPIServlet.java        |   43 +-
 .../api/http/servlet/UpdateAPIServlet.java      |    8 +-
 .../asterix/api/java/AsterixJavaClient.java     |   33 +-
 .../asterix/aql/translator/AqlTranslator.java   | 3075 --------
 .../asterix/aql/translator/QueryTranslator.java | 3083 ++++++++
 .../org/apache/asterix/drivers/AsterixCLI.java  |   13 +-
 .../asterix/drivers/AsterixClientDriver.java    |   12 +-
 .../asterix/drivers/AsterixWebServer.java       |    3 +-
 .../asterix/feeds/CentralFeedManager.java       |   19 +-
 .../asterix/feeds/FeedLifecycleListener.java    |    9 +-
 .../apache/asterix/feeds/FeedsActivator.java    |   10 +-
 .../bootstrap/CCApplicationEntryPoint.java      |   24 +-
 .../src/main/resources/webui/querytemplate.html |    6 +
 .../apache/asterix/test/aql/AQLTestCase.java    |   11 +-
 .../org/apache/asterix/test/dml/DmlTest.java    |    4 +-
 .../asterix/test/optimizer/OptimizerTest.java   |   40 +-
 .../test/querygen/AQLToSQLPPConverter.java      |   26 +-
 .../asterix/test/runtime/ExecutionTest.java     |   76 +-
 .../asterix/test/runtime/ExecutionTestUtil.java |  117 +
 .../test/runtime/SqlppExecutionTest.java        |  103 +
 .../asterix/test/sqlpp/ParserTestExecutor.java  |   40 +-
 .../queries_sqlpp/limit-issue353.sqlpp          |    4 +
 .../results/disjunction-to-join-delete-1.plan   |   14 +-
 .../results/disjunction-to-join-delete-2.plan   |   27 +-
 .../results/disjunction-to-join-delete-3.plan   |   26 +-
 .../optimizerts/results/scan-delete-all.plan    |    9 +-
 .../scan-delete-rtree-secondary-index.plan      |   11 +-
 .../optimizerts/results/scan-delete.plan        |   12 +-
 ...ont-skip-primary-index-search-in-delete.plan |   11 +-
 .../skip-ngram-index-search-in-delete.plan      |   12 +-
 .../skip-rtree-index-search-in-delete.plan      |   12 +-
 ...-secondary-btree-index-search-in-delete.plan |   12 +-
 .../skip-word-index-search-in-delete.plan       |   12 +-
 .../optimizerts/results/sort-cust.plan          |   13 +-
 .../consolidate-selects-complex.ast             |    4 +-
 .../results_parser_sqlpp/const-folding.ast      |    5 +-
 .../results_parser_sqlpp/fj-phase1.ast          |    3 -
 .../fj-phase2-with-hints.ast                    |    2 -
 .../ngram-edit-distance-check-panic.ast         |    2 +-
 .../ngram-edit-distance-check.ast               |    9 +-
 .../ngram-jaccard-check.ast                     |   17 +-
 .../olist-edit-distance-check-panic.ast         |   13 +-
 .../olist-edit-distance-check.ast               |   13 +-
 .../olist-jaccard-check.ast                     |   13 +-
 .../ulist-jaccard-check.ast                     |   13 +-
 .../inverted-index-basic/word-jaccard-check.ast |   13 +-
 ...edit-distance-check-let-panic-nopanic_01.ast |    4 +-
 ...edit-distance-check-let-panic-nopanic_02.ast |    4 +-
 .../ngram-edit-distance-check-let-panic.ast     |    2 +-
 .../ngram-edit-distance-check-let.ast           |    2 +-
 .../ngram-edit-distance-check-substring.ast     |   13 +-
 .../ngram-edit-distance-check-word-tokens.ast   |    6 +-
 .../ngram-jaccard-check-let.ast                 |    2 +-
 .../ngram-jaccard-check-multi-let.ast           |    2 +-
 .../olist-edit-distance-check-let-panic.ast     |    2 +-
 .../olist-edit-distance-check-let.ast           |    2 +-
 .../olist-jaccard-check-let.ast                 |    2 +-
 .../ulist-jaccard-check-let.ast                 |    2 +-
 .../word-jaccard-check-let.ast                  |    2 +-
 .../word-jaccard-check-multi-let.ast            |    2 +-
 .../inverted-index-join/issue741.ast            |    2 +-
 ...idx-with-join-edit-distance-check-idx_01.ast |    2 +-
 ...robe-pidx-with-join-jaccard-check-idx_01.ast |    2 +-
 .../ngram-edit-distance-check_01.ast            |   12 +-
 .../ngram-edit-distance-check_02.ast            |   12 +-
 .../ngram-edit-distance-check_03.ast            |   12 +-
 .../ngram-edit-distance-check_04.ast            |    4 +-
 .../ngram-edit-distance-contains.ast            |   12 +-
 .../ngram-jaccard-check_01.ast                  |   20 +-
 .../ngram-jaccard-check_02.ast                  |   20 +-
 .../ngram-jaccard-check_03.ast                  |   20 +-
 .../ngram-jaccard-check_04.ast                  |    4 +-
 .../olist-edit-distance-check_01.ast            |   12 +-
 .../olist-edit-distance-check_02.ast            |   12 +-
 .../olist-edit-distance-check_03.ast            |   12 +-
 .../olist-edit-distance-check_04.ast            |    4 +-
 .../olist-jaccard-check_01.ast                  |   12 +-
 .../olist-jaccard-check_02.ast                  |   12 +-
 .../olist-jaccard-check_03.ast                  |   12 +-
 .../olist-jaccard-check_04.ast                  |    4 +-
 .../ulist-jaccard-check_01.ast                  |   12 +-
 .../ulist-jaccard-check_02.ast                  |   12 +-
 .../ulist-jaccard-check_03.ast                  |   12 +-
 .../ulist-jaccard-check_04.ast                  |    4 +-
 .../word-jaccard-check-after-btree-access.ast   |    4 +-
 .../word-jaccard-check_01.ast                   |   16 +-
 .../word-jaccard-check_02.ast                   |   16 +-
 .../word-jaccard-check_03.ast                   |   16 +-
 .../word-jaccard-check_04.ast                   |    4 +-
 .../results_parser_sqlpp/limit-issue353.ast     |   60 +
 .../ngram-edit-distance-check-panic.ast         |    2 +-
 .../ngram-edit-distance-check.ast               |   12 +-
 .../ngram-jaccard-check.ast                     |   20 +-
 .../olist-edit-distance-check-panic.ast         |   16 +-
 .../olist-edit-distance-check.ast               |   16 +-
 .../olist-jaccard-check.ast                     |   16 +-
 .../ulist-jaccard-check.ast                     |   16 +-
 .../inverted-index-basic/word-jaccard-check.ast |   16 +-
 ...edit-distance-check-let-panic-nopanic_01.ast |    4 +-
 ...edit-distance-check-let-panic-nopanic_02.ast |    4 +-
 .../ngram-edit-distance-check-let-panic.ast     |    2 +-
 .../ngram-edit-distance-check-let.ast           |    2 +-
 .../ngram-edit-distance-check-substring.ast     |   16 +-
 .../ngram-edit-distance-check-word-tokens.ast   |    6 +-
 .../ngram-jaccard-check-let.ast                 |    2 +-
 .../ngram-jaccard-check-multi-let.ast           |    2 +-
 .../olist-edit-distance-check-let-panic.ast     |    2 +-
 .../olist-edit-distance-check-let.ast           |    2 +-
 .../olist-jaccard-check-let.ast                 |    2 +-
 .../ulist-jaccard-check-let.ast                 |    2 +-
 .../word-jaccard-check-let.ast                  |    2 +-
 .../word-jaccard-check-multi-let.ast            |    2 +-
 ...idx-with-join-edit-distance-check-idx_01.ast |    2 +-
 ...robe-pidx-with-join-jaccard-check-idx_01.ast |    2 +-
 .../ngram-edit-distance-check_01.ast            |   18 +-
 .../ngram-edit-distance-contains.ast            |   18 +-
 .../ngram-jaccard-check_01.ast                  |   26 +-
 .../olist-edit-distance-check_01.ast            |   18 +-
 .../olist-jaccard-check_01.ast                  |   18 +-
 .../ulist-jaccard-check_01.ast                  |   18 +-
 .../word-jaccard-check-after-btree-access.ast   |    4 +-
 .../word-jaccard-check_01.ast                   |   22 +-
 .../ngram-edit-distance-check-panic.ast         |    2 +-
 .../ngram-edit-distance-check.ast               |   12 +-
 .../ngram-jaccard-check.ast                     |   20 +-
 .../inverted-index-basic/word-jaccard-check.ast |   16 +-
 ...edit-distance-check-let-panic-nopanic_01.ast |    4 +-
 ...edit-distance-check-let-panic-nopanic_02.ast |    4 +-
 .../ngram-edit-distance-check-let-panic.ast     |    2 +-
 .../ngram-edit-distance-check-let.ast           |    2 +-
 .../ngram-edit-distance-check-substring.ast     |   16 +-
 .../ngram-edit-distance-check-word-tokens.ast   |    6 +-
 .../ngram-jaccard-check-let.ast                 |    2 +-
 .../ngram-jaccard-check-multi-let.ast           |    2 +-
 .../word-jaccard-check-let.ast                  |    2 +-
 .../word-jaccard-check-multi-let.ast            |    2 +-
 ...idx-with-join-edit-distance-check-idx_01.ast |    2 +-
 .../ngram-edit-distance-check_01.ast            |   18 +-
 .../ngram-edit-distance-check_02.ast            |   18 +-
 .../ngram-edit-distance-check_03.ast            |   18 +-
 .../ngram-edit-distance-check_04.ast            |   18 +-
 .../ngram-edit-distance-check_05.ast            |   18 +-
 .../ngram-edit-distance-contains.ast            |   18 +-
 .../ngram-jaccard-check_01.ast                  |   26 +-
 .../ngram-jaccard-check_02.ast                  |   26 +-
 .../ngram-jaccard-check_03.ast                  |   26 +-
 .../ngram-jaccard-check_04.ast                  |   26 +-
 .../word-jaccard-check-after-btree-access.ast   |    4 +-
 .../word-jaccard-check_01.ast                   |   22 +-
 .../word-jaccard-check_02.ast                   |   22 +-
 .../word-jaccard-check_03.ast                   |   22 +-
 .../word-jaccard-check_04.ast                   |   22 +-
 .../ngram-edit-distance-check-panic.ast         |    2 +-
 .../ngram-edit-distance-check.ast               |    9 +-
 .../ngram-jaccard-check.ast                     |   17 +-
 .../inverted-index-basic/word-jaccard-check.ast |   13 +-
 ...edit-distance-check-let-panic-nopanic_01.ast |    4 +-
 ...edit-distance-check-let-panic-nopanic_02.ast |    4 +-
 .../ngram-edit-distance-check-let-panic.ast     |    2 +-
 .../ngram-edit-distance-check-let.ast           |    2 +-
 .../ngram-edit-distance-check-substring.ast     |   13 +-
 .../ngram-edit-distance-check-word-tokens.ast   |    6 +-
 .../ngram-jaccard-check-let.ast                 |    2 +-
 .../ngram-jaccard-check-multi-let.ast           |    2 +-
 .../word-jaccard-check-let.ast                  |    2 +-
 .../word-jaccard-check-multi-let.ast            |    2 +-
 ...idx-with-join-edit-distance-check-idx_01.ast |    2 +-
 .../ngram-edit-distance-check_01.ast            |   12 +-
 .../ngram-edit-distance-check_02.ast            |   12 +-
 .../ngram-edit-distance-check_03.ast            |   12 +-
 .../ngram-edit-distance-check_04.ast            |   12 +-
 .../ngram-edit-distance-check_05.ast            |   12 +-
 .../ngram-edit-distance-check_inline_03.ast     |    4 +-
 .../ngram-edit-distance-contains.ast            |   12 +-
 .../ngram-jaccard-check_01.ast                  |   20 +-
 .../ngram-jaccard-check_02.ast                  |   20 +-
 .../ngram-jaccard-check_03.ast                  |   20 +-
 .../ngram-jaccard-check_04.ast                  |   20 +-
 .../ngram-jaccard-check_inline_03.ast           |    4 +-
 .../word-jaccard-check-after-btree-access.ast   |    4 +-
 .../word-jaccard-check_01.ast                   |   16 +-
 .../word-jaccard-check_02.ast                   |   16 +-
 .../word-jaccard-check_03.ast                   |   16 +-
 .../word-jaccard-check_04.ast                   |   16 +-
 .../word-jaccard-check_inline_03.ast            |    4 +-
 .../optimizerts/results_parser_sqlpp/q2.ast     |    4 +-
 .../results_parser_sqlpp/query-issue785.ast     |    1 -
 .../split-materialization-above-join.ast        |   10 +-
 .../parserts/results_parser_sqlpp/2.ast         |    4 +-
 .../results_parser_sqlpp/from_inner_join.ast    |    1 +
 .../from_left_outer_join.ast                    |    1 +
 .../results_parser_sqlpp/nestedFLWOGR3.ast      |    4 +-
 .../numberInFieldAccessor.ast                   |    5 +-
 .../src/test/resources/runtimets/only_sqlpp.xml |   23 +
 .../query-issue400/query-issue400.3.query.aql   |    2 +-
 .../query-issue400/query-issue400.3.query.aql   |    2 +-
 .../big_object_groupby.3.query.aql              |    2 +-
 .../big_object_sort/big_object_sort.1.ddl.aql   |    2 +-
 .../big_object_sort/big_object_sort.3.query.aql |    2 +-
 .../cross-dv15/cross-dv15.3.query.aql           |    8 +-
 .../insert-and-scan-joined-datasets.3.query.aql |    4 +-
 .../rc-format/rc-format.3.query.aql             |   10 +-
 .../sequence-format/sequence-format.3.query.aql |   10 +-
 .../text-format/text-format.3.query.aql         |   10 +-
 .../overlap_bins_gby_0.3.query.aql              |    1 +
 .../nest_aggregate/nest_aggregate.3.query.aql   |    3 +-
 .../issue531_string_min_max.2.update.sqlpp      |    4 +-
 .../issue531_string_min_max.3.query.sqlpp       |    4 +-
 .../query-issue400/query-issue400.3.query.sqlpp |    6 +-
 .../aggregate/droptype/droptype.1.ddl.sqlpp     |    2 +-
 .../aggregate/droptype/droptype.2.update.sqlpp  |    2 +-
 .../aggregate/droptype/droptype.3.query.sqlpp   |    2 +-
 .../issue531_string_min_max.1.ddl.sqlpp         |    4 +-
 .../issue531_string_min_max.2.update.sqlpp      |    4 +-
 .../issue531_string_min_max.3.query.sqlpp       |    4 +-
 .../query-issue400/query-issue400.3.query.sqlpp |    8 +-
 .../big_object_groupby.1.ddl.sqlpp              |    5 +
 .../big_object_groupby.3.query.sqlpp            |    6 +-
 .../big_object_groupby.1.ddl.sqlpp              |    5 +-
 .../big_object_groupby.2.update.sqlpp           |    5 +-
 .../big_object_groupby.3.query.sqlpp            |    5 +
 .../big_object_join/big_object_join.1.ddl.sqlpp |    4 +
 .../big_object_join.2.update.sqlpp              |    5 +-
 .../big_object_join.3.query.sqlpp               |    4 +
 .../big_object_load/big_object_load.1.ddl.sqlpp |   82 +
 .../big_object_load.2.update.sqlpp              |   24 +
 .../big_object_load.3.query.sqlpp               |   31 +
 .../big_object_sort/big_object_sort.1.ddl.sqlpp |    4 +
 .../big_object_sort.2.update.sqlpp              |    5 +-
 .../big_object_sort.3.query.sqlpp               |    4 +
 .../binary/find/find.3.query.sqlpp              |    2 +-
 .../binary/subbinary/subbinary_01.3.query.sqlpp |    2 +-
 .../boolean/and_01/and_01.3.query.sqlpp         |    5 +-
 .../duration_01/duration_01.1.ddl.sqlpp         |    2 +-
 .../duration_01/duration_01.2.update.sqlpp      |    2 +-
 .../duration_01/duration_01.3.query.sqlpp       |    2 +-
 .../duration_02/duration_02.1.ddl.sqlpp         |    2 +-
 .../duration_02/duration_02.2.update.sqlpp      |    2 +-
 .../duration_02/duration_02.3.query.sqlpp       |    2 +-
 .../cross-dv04/cross-dv04.1.ddl.sqlpp           |    2 +-
 .../cross-dv04/cross-dv04.2.update.sqlpp        |    2 +-
 .../cross-dv04/cross-dv04.3.query.sqlpp         |    2 +-
 .../cross-dv09/cross-dv09.1.ddl.sqlpp           |   14 +-
 .../cross-dv11/cross-dv11.1.ddl.sqlpp           |   16 +-
 .../cross-dv11/cross-dv11.2.update.sqlpp        |    2 +-
 .../cross-dv11/cross-dv11.3.query.sqlpp         |    2 +-
 .../cross-dv12/cross-dv12.1.ddl.sqlpp           |   16 +-
 .../cross-dv12/cross-dv12.2.update.sqlpp        |    2 +-
 .../cross-dv12/cross-dv12.3.query.sqlpp         |    2 +-
 .../cross-dv13/cross-dv13.1.ddl.sqlpp           |   22 +-
 .../cross-dv13/cross-dv13.2.update.sqlpp        |    4 +-
 .../cross-dv13/cross-dv13.3.query.sqlpp         |    4 +-
 .../cross-dv14/cross-dv14.1.ddl.sqlpp           |    6 +
 .../cross-dv15/cross-dv15.1.ddl.sqlpp           |   19 +-
 .../cross-dv15/cross-dv15.3.query.sqlpp         |    8 +-
 .../cross-dv16/cross-dv16.1.ddl.sqlpp           |   17 +
 .../cross-dv17/cross-dv17.1.ddl.sqlpp           |   29 +-
 .../custord/join_q_04/join_q_04.2.update.sqlpp  |    4 +
 .../custord/join_q_04/join_q_04.3.query.sqlpp   |    4 +
 .../query-issue443-2.3.query.sqlpp              |    4 +-
 .../query-issue443/query-issue443.3.query.sqlpp |    6 +-
 .../empty-load-with-index.2.update.sqlpp        |    2 +-
 .../empty-load-with-index.3.query.sqlpp         |    2 +-
 ...t-and-scan-dataset-with-index.2.update.sqlpp |    2 +-
 ...rt-and-scan-dataset-with-index.3.query.sqlpp |    2 +-
 .../insert-and-scan-dataset.2.update.sqlpp      |    2 +-
 .../insert-and-scan-dataset.3.query.sqlpp       |    2 +-
 .../insert-and-scan-joined-datasets.1.ddl.sqlpp |    5 +
 ...sert-and-scan-joined-datasets.2.update.sqlpp |    7 +-
 ...nsert-and-scan-joined-datasets.3.query.sqlpp |    7 +-
 ...into-empty-dataset-with-index.2.update.sqlpp |    4 +-
 ...-into-empty-dataset-with-index.3.query.sqlpp |    4 +-
 .../insert-into-empty-dataset.2.update.sqlpp    |    4 +-
 .../insert-into-empty-dataset.3.query.sqlpp     |    4 +-
 .../insert-record-function.1.ddl.sqlpp          |    4 +-
 .../insert-record-function.2.update.sqlpp       |    4 +-
 .../insert-record-function.3.query.sqlpp        |    4 +-
 .../queries_sqlpp/dml/insert-syntax.sqlpp       |    2 +-
 .../opentype-c2o-recursive.2.update.sqlpp       |    4 +-
 .../opentype-c2o-recursive.3.query.sqlpp        |    4 +-
 .../dml/opentype-c2o/opentype-c2o.1.ddl.sqlpp   |    4 +-
 .../opentype-c2o/opentype-c2o.2.update.sqlpp    |    4 +-
 .../dml/opentype-c2o/opentype-c2o.3.query.sqlpp |    4 +-
 .../opentype-closed-optional.1.ddl.sqlpp        |    2 +-
 .../opentype-closed-optional.2.update.sqlpp     |    2 +-
 .../opentype-closed-optional.3.query.sqlpp      |    2 +-
 .../opentype-insert/opentype-insert.1.ddl.sqlpp |    2 +-
 .../opentype-insert.2.update.sqlpp              |    2 +-
 .../opentype-insert.3.query.sqlpp               |    2 +-
 .../opentype-insert2.1.ddl.sqlpp                |    2 +-
 .../opentype-insert2.2.update.sqlpp             |    4 +-
 .../opentype-insert2.3.query.sqlpp              |    4 +-
 .../opentype-noexpand.1.ddl.sqlpp               |    4 +-
 .../opentype-noexpand.2.update.sqlpp            |    4 +-
 .../opentype-noexpand.3.query.sqlpp             |    4 +-
 .../opentype-o2c-recursive.2.update.sqlpp       |    4 +-
 .../opentype-o2c-recursive.3.query.sqlpp        |    4 +-
 .../dml/opentype-o2c/opentype-o2c.1.ddl.sqlpp   |    4 +-
 .../opentype-o2c/opentype-o2c.2.update.sqlpp    |    4 +-
 .../dml/opentype-o2c/opentype-o2c.3.query.sqlpp |    4 +-
 .../dml/opentype-o2o/opentype-o2o.1.ddl.sqlpp   |    4 +-
 .../opentype-o2o/opentype-o2o.2.update.sqlpp    |    4 +-
 .../dml/opentype-o2o/opentype-o2o.3.query.sqlpp |    4 +-
 .../query-issue205/query-issue205.1.ddl.sqlpp   |    4 +
 .../query-issue205.2.update.sqlpp               |    4 +
 .../query-issue205/query-issue205.3.query.sqlpp |    4 +
 .../query-issue288/query-issue288.1.ddl.sqlpp   |    4 +
 .../query-issue288.2.update.sqlpp               |    4 +
 .../query-issue288/query-issue288.3.ddl.sqlpp   |    4 +
 .../query-issue288.4.update.sqlpp               |    4 +
 .../query-issue288/query-issue288.5.query.sqlpp |    4 +
 .../query-issue433/query-issue433.1.ddl.sqlpp   |    4 +
 .../query-issue433.2.update.sqlpp               |    4 +
 .../query-issue433/query-issue433.3.query.sqlpp |    4 +
 ...tree-secondary-index-nullable.2.update.sqlpp |    4 +-
 ...btree-secondary-index-nullable.5.query.sqlpp |    4 +-
 ...elete-btree-secondary-index-open.1.ddl.sqlpp |    4 +-
 ...ete-btree-secondary-index-open.5.query.sqlpp |    4 +-
 ...gram-secondary-index-nullable.2.update.sqlpp |    4 +-
 ...x-ngram-secondary-index-nullable.3.ddl.sqlpp |    4 +-
 ...gram-secondary-index-nullable.4.update.sqlpp |    4 +-
 ...ngram-secondary-index-nullable.5.query.sqlpp |    4 +-
 ...d-index-ngram-secondary-index.2.update.sqlpp |    2 +-
 ...rted-index-ngram-secondary-index.3.ddl.sqlpp |    2 +-
 ...d-index-ngram-secondary-index.4.update.sqlpp |    2 +-
 ...ed-index-ngram-secondary-index.5.query.sqlpp |    2 +-
 ...word-secondary-index-nullable.2.update.sqlpp |    4 +-
 ...ex-word-secondary-index-nullable.3.ddl.sqlpp |    4 +-
 ...word-secondary-index-nullable.4.update.sqlpp |    2 +-
 ...-word-secondary-index-nullable.5.query.sqlpp |    4 +-
 ...ed-index-word-secondary-index.2.update.sqlpp |    2 +-
 ...erted-index-word-secondary-index.3.ddl.sqlpp |    2 +-
 ...ed-index-word-secondary-index.4.update.sqlpp |    2 +-
 ...ted-index-word-secondary-index.5.query.sqlpp |    2 +-
 ...tree-secondary-index-nullable.2.update.sqlpp |    4 +-
 ...rtree-secondary-index-nullable.5.query.sqlpp |    4 +-
 ...tree-secondary-index-nullable.2.update.sqlpp |    4 +-
 ...btree-secondary-index-nullable.5.query.sqlpp |    4 +-
 ...gram-secondary-index-nullable.2.update.sqlpp |    4 +-
 ...x-ngram-secondary-index-nullable.3.ddl.sqlpp |    4 +-
 ...gram-secondary-index-nullable.4.update.sqlpp |    4 +-
 ...ngram-secondary-index-nullable.5.query.sqlpp |    4 +-
 ...d-index-ngram-secondary-index.2.update.sqlpp |    4 +-
 ...rted-index-ngram-secondary-index.3.ddl.sqlpp |    4 +-
 ...d-index-ngram-secondary-index.4.update.sqlpp |    4 +-
 ...ed-index-ngram-secondary-index.5.query.sqlpp |    4 +-
 ...word-secondary-index-nullable.2.update.sqlpp |    4 +-
 ...ex-word-secondary-index-nullable.3.ddl.sqlpp |    4 +-
 ...word-secondary-index-nullable.4.update.sqlpp |    4 +-
 ...-word-secondary-index-nullable.5.query.sqlpp |    4 +-
 ...ed-index-word-secondary-index.2.update.sqlpp |    4 +-
 ...erted-index-word-secondary-index.3.ddl.sqlpp |    4 +-
 ...ed-index-word-secondary-index.4.update.sqlpp |    4 +-
 ...ted-index-word-secondary-index.5.query.sqlpp |    4 +-
 ...tree-secondary-index-nullable.2.update.sqlpp |    4 +-
 ...rtree-secondary-index-nullable.5.query.sqlpp |    4 +-
 ...rt-rtree-secondary-index-open.2.update.sqlpp |    4 +-
 .../leftouterjoin-rtree.3.query.sqlpp           |    2 +-
 .../leftouterjoin/leftouterjoin.2.update.sqlpp  |    2 +-
 .../rc-format/rc-format.1.ddl.sqlpp             |    7 +-
 .../rc-format/rc-format.2.update.sqlpp          |    8 +-
 .../rc-format/rc-format.3.query.sqlpp           |    7 +-
 .../sequence-format/sequence-format.1.ddl.sqlpp |    7 +-
 .../sequence-format.2.update.sqlpp              |    8 +-
 .../sequence-format.3.query.sqlpp               |    7 +-
 .../text-format/text-format.1.ddl.sqlpp         |    5 +
 .../text-format/text-format.2.update.sqlpp      |    5 +
 .../text-format/text-format.3.query.sqlpp       |    7 +-
 .../feeds/feeds_02/feeds_02.1.ddl.sqlpp         |    2 +-
 .../feeds/feeds_02/feeds_02.2.update.sqlpp      |    2 +-
 .../feeds/feeds_02/feeds_02.3.query.sqlpp       |    2 +-
 .../feeds/feeds_04/feeds_04.1.ddl.sqlpp         |    2 +-
 .../feeds/feeds_04/feeds_04.2.update.sqlpp      |    2 +-
 .../feeds/feeds_04/feeds_04.3.query.sqlpp       |    2 +-
 .../feeds/feeds_05/feeds_05.1.ddl.sqlpp         |    2 +-
 .../feeds/feeds_06/feeds_06.1.ddl.sqlpp         |    2 +-
 .../feeds/feeds_07/feeds_07.1.ddl.sqlpp         |    2 +-
 .../feeds/feeds_07/feeds_07.2.update.sqlpp      |    2 +-
 .../feeds/feeds_07/feeds_07.3.query.sqlpp       |    2 +-
 .../feeds/feeds_08/feeds_08.1.ddl.sqlpp         |    2 +-
 .../feeds/feeds_08/feeds_08.2.update.sqlpp      |    2 +-
 .../feeds/feeds_08/feeds_08.3.query.sqlpp       |    2 +-
 .../feeds/feeds_09/feeds_09.1.ddl.sqlpp         |    2 +-
 .../feeds/feeds_09/feeds_09.2.update.sqlpp      |    2 +-
 .../feeds/feeds_09/feeds_09.3.query.sqlpp       |    2 +-
 .../feeds/feeds_11/feeds_11.1.ddl.sqlpp         |    2 +-
 .../feeds/feeds_11/feeds_11.2.update.sqlpp      |    2 +-
 .../feeds/feeds_11/feeds_11.3.query.sqlpp       |    2 +-
 .../feeds/feeds_12/feeds_12.1.ddl.sqlpp         |    2 +-
 .../feeds/feeds_12/feeds_12.2.update.sqlpp      |    2 +-
 .../feeds/feeds_12/feeds_12.3.query.sqlpp       |    2 +-
 .../issue_230_feeds/issue_230_feeds.1.ddl.sqlpp |    2 +-
 .../issue_230_feeds.2.update.sqlpp              |    2 +-
 .../issue_230_feeds.3.query.sqlpp               |    2 +-
 .../queries_sqlpp/flwor/at00/at00.3.query.sqlpp |    7 +-
 .../flwor/at00/at00.4.asyncdefer.sqlpp          |    9 +-
 .../queries_sqlpp/flwor/at00/at00.5.async.sqlpp |    8 +-
 .../queries_sqlpp/flwor/at06/at06.3.query.sqlpp |    4 +-
 .../queries_sqlpp/flwor/let01/let01.1.ddl.sqlpp |    2 +-
 .../flwor/let01/let01.2.update.sqlpp            |    2 +-
 .../flwor/let01/let01.3.query.sqlpp             |    2 +-
 .../queries_sqlpp/flwor/let02/let02.1.ddl.sqlpp |    2 +-
 .../flwor/let02/let02.2.update.sqlpp            |    2 +-
 .../flwor/let02/let02.3.query.sqlpp             |    2 +-
 .../queries_sqlpp/flwor/let03/let03.1.ddl.sqlpp |    2 +-
 .../flwor/let03/let03.2.update.sqlpp            |    2 +-
 .../flwor/let03/let03.3.query.sqlpp             |    2 +-
 .../queries_sqlpp/flwor/let04/let04.1.ddl.sqlpp |    2 +-
 .../flwor/let04/let04.2.update.sqlpp            |    2 +-
 .../flwor/let04/let04.3.query.sqlpp             |    2 +-
 .../queries_sqlpp/flwor/let05/let05.1.ddl.sqlpp |    2 +-
 .../flwor/let05/let05.2.update.sqlpp            |    2 +-
 .../flwor/let05/let05.3.query.sqlpp             |    2 +-
 .../queries_sqlpp/flwor/let06/let06.1.ddl.sqlpp |    2 +-
 .../flwor/let06/let06.2.update.sqlpp            |    2 +-
 .../flwor/let06/let06.3.query.sqlpp             |    2 +-
 .../queries_sqlpp/flwor/let07/let07.1.ddl.sqlpp |    2 +-
 .../flwor/let07/let07.2.update.sqlpp            |    2 +-
 .../flwor/let07/let07.3.query.sqlpp             |    2 +-
 .../queries_sqlpp/flwor/let08/let08.1.ddl.sqlpp |    2 +-
 .../flwor/let08/let08.2.update.sqlpp            |    2 +-
 .../flwor/let08/let08.3.query.sqlpp             |    2 +-
 .../queries_sqlpp/flwor/let09/let09.1.ddl.sqlpp |    2 +-
 .../flwor/let09/let09.2.update.sqlpp            |    2 +-
 .../flwor/let09/let09.3.query.sqlpp             |    2 +-
 .../queries_sqlpp/flwor/let10/let10.1.ddl.sqlpp |    2 +-
 .../flwor/let10/let10.2.update.sqlpp            |    2 +-
 .../flwor/let10/let10.3.query.sqlpp             |    2 +-
 .../queries_sqlpp/flwor/let11/let11.1.ddl.sqlpp |    2 +-
 .../flwor/let11/let11.2.update.sqlpp            |    2 +-
 .../flwor/let11/let11.3.query.sqlpp             |    2 +-
 .../queries_sqlpp/flwor/let12/let12.1.ddl.sqlpp |    2 +-
 .../flwor/let12/let12.2.update.sqlpp            |    2 +-
 .../flwor/let12/let12.3.query.sqlpp             |    2 +-
 .../queries_sqlpp/flwor/let13/let13.1.ddl.sqlpp |    2 +-
 .../flwor/let13/let13.2.update.sqlpp            |    2 +-
 .../flwor/let13/let13.3.query.sqlpp             |    2 +-
 .../queries_sqlpp/flwor/let14/let14.1.ddl.sqlpp |    2 +-
 .../flwor/let14/let14.2.update.sqlpp            |    2 +-
 .../flwor/let14/let14.3.query.sqlpp             |    2 +-
 .../queries_sqlpp/flwor/let15/let15.1.ddl.sqlpp |    2 +-
 .../flwor/let15/let15.2.update.sqlpp            |    2 +-
 .../flwor/let15/let15.3.query.sqlpp             |    2 +-
 .../queries_sqlpp/flwor/let16/let16.1.ddl.sqlpp |    2 +-
 .../flwor/let16/let16.2.update.sqlpp            |    2 +-
 .../flwor/let16/let16.3.query.sqlpp             |    2 +-
 .../queries_sqlpp/flwor/let17/let17.1.ddl.sqlpp |    2 +-
 .../flwor/let17/let17.2.update.sqlpp            |    2 +-
 .../flwor/let17/let17.3.query.sqlpp             |    2 +-
 .../queries_sqlpp/flwor/let18/let18.1.ddl.sqlpp |    2 +-
 .../flwor/let18/let18.2.update.sqlpp            |    2 +-
 .../flwor/let18/let18.3.query.sqlpp             |    2 +-
 .../queries_sqlpp/flwor/let19/let19.1.ddl.sqlpp |    2 +-
 .../flwor/let19/let19.2.update.sqlpp            |    2 +-
 .../flwor/let19/let19.3.query.sqlpp             |    2 +-
 .../queries_sqlpp/flwor/let20/let20.1.ddl.sqlpp |    2 +-
 .../flwor/let20/let20.2.update.sqlpp            |    2 +-
 .../flwor/let20/let20.3.query.sqlpp             |    2 +-
 .../queries_sqlpp/flwor/let22/let22.1.ddl.sqlpp |    2 +-
 .../flwor/let22/let22.2.update.sqlpp            |    2 +-
 .../flwor/let22/let22.3.query.sqlpp             |    2 +-
 .../queries_sqlpp/flwor/let26/let26.1.ddl.sqlpp |    4 +-
 .../flwor/let26/let26.2.update.sqlpp            |    4 +-
 .../flwor/let26/let26.3.query.sqlpp             |    4 +-
 .../queries_sqlpp/flwor/let27/let27.1.ddl.sqlpp |    6 +-
 .../flwor/let27/let27.2.update.sqlpp            |    6 +-
 .../flwor/let27/let27.3.query.sqlpp             |    6 +-
 .../flwor/ret-03/ret-03.1.ddl.sqlpp             |    2 +-
 .../flwor/ret-03/ret-03.2.update.sqlpp          |    2 +-
 .../flwor/ret-03/ret-03.3.query.sqlpp           |    2 +-
 .../hdfs/hdfs_02/hdfs_02.1.ddl.sqlpp            |    4 +
 .../hdfs/hdfs_02/hdfs_02.2.update.sqlpp         |    5 +-
 .../hdfs/hdfs_02/hdfs_02.3.query.sqlpp          |    7 +-
 .../hdfs/hdfs_03/hdfs_03.1.ddl.sqlpp            |    6 +
 .../hdfs/hdfs_03/hdfs_03.2.update.sqlpp         |    7 +-
 .../hdfs/hdfs_03/hdfs_03.3.query.sqlpp          |    9 +-
 .../hdfs_shortcircuit.1.ddl.sqlpp               |    5 +
 .../hdfs_shortcircuit.2.update.sqlpp            |    6 +-
 .../hdfs_shortcircuit.3.query.sqlpp             |    8 +-
 .../issue_245_hdfs/issue_245_hdfs.1.ddl.sqlpp   |    5 +
 .../issue_245_hdfs.2.update.sqlpp               |    6 +-
 .../issue_245_hdfs/issue_245_hdfs.3.query.sqlpp |    5 +
 .../issue_251_dataset_hint_5.1.ddl.sqlpp        |    4 +
 .../issue_251_dataset_hint_5.2.update.sqlpp     |    6 +-
 .../issue_251_dataset_hint_5.3.query.sqlpp      |    6 +-
 .../issue_251_dataset_hint_6.1.ddl.sqlpp        |    5 +
 .../issue_251_dataset_hint_6.2.update.sqlpp     |    6 +-
 .../issue_251_dataset_hint_6.3.query.sqlpp      |    8 +-
 .../issue_251_dataset_hint_7.1.ddl.sqlpp        |    7 +-
 .../issue_251_dataset_hint_7.2.update.sqlpp     |    7 +-
 .../issue_251_dataset_hint_7.3.query.sqlpp      |    8 +-
 ...rtree-spatial-intersect-point.2.update.sqlpp |    2 +-
 .../rtree-spatial-intersect-point.3.ddl.sqlpp   |    2 +-
 .../rtree-spatial-intersect-point.4.query.sqlpp |    2 +-
 ...be-pidx-with-join-btree-sidx1.2.update.sqlpp |    2 +-
 ...obe-pidx-with-join-btree-sidx1.3.query.sqlpp |    2 +-
 ...be-pidx-with-join-btree-sidx2.2.update.sqlpp |    2 +-
 ...obe-pidx-with-join-btree-sidx2.3.query.sqlpp |    2 +-
 ...e-pidx-with-join-invidx-sidx1.2.update.sqlpp |    2 +-
 ...be-pidx-with-join-invidx-sidx1.3.query.sqlpp |    2 +-
 ...e-pidx-with-join-invidx-sidx2.2.update.sqlpp |    2 +-
 ...be-pidx-with-join-invidx-sidx2.3.query.sqlpp |    2 +-
 ...be-pidx-with-join-rtree-sidx1.2.update.sqlpp |    2 +-
 ...obe-pidx-with-join-rtree-sidx1.3.query.sqlpp |    2 +-
 ...be-pidx-with-join-rtree-sidx2.2.update.sqlpp |    2 +-
 ...obe-pidx-with-join-rtree-sidx2.3.query.sqlpp |    2 +-
 ...ex-composite-key-mixed-intervals.1.ddl.sqlpp |    2 +-
 ...composite-key-mixed-intervals.2.update.sqlpp |    2 +-
 ...-composite-key-mixed-intervals.3.query.sqlpp |    2 +-
 .../inverted-index-ngram-contains.1.ddl.sqlpp   |    2 +-
 ...dex-ngram-edit-distance-contains.1.ddl.sqlpp |    2 +-
 ...-index-ngram-edit-distance-panic.1.ddl.sqlpp |    2 +-
 ...-ngram-edit-distance-word-tokens.1.ddl.sqlpp |    2 +-
 ...verted-index-ngram-edit-distance.1.ddl.sqlpp |    2 +-
 .../inverted-index-ngram-jaccard.1.ddl.sqlpp    |    2 +-
 ...-index-olist-edit-distance-panic.1.ddl.sqlpp |    2 +-
 ...verted-index-olist-edit-distance.1.ddl.sqlpp |    2 +-
 .../inverted-index-olist-jaccard.1.ddl.sqlpp    |    2 +-
 .../inverted-index-ulist-jaccard.1.ddl.sqlpp    |    2 +-
 .../inverted-index-word-contains.1.ddl.sqlpp    |    2 +-
 .../inverted-index-word-jaccard.1.ddl.sqlpp     |    2 +-
 .../orders-index-custkey-open.1.ddl.sqlpp       |    2 +-
 .../query_issue285-2.3.query.sqlpp              |    8 +-
 .../query_issue285/query_issue285.3.query.sqlpp |    8 +-
 .../list/listify_01/listify_01.3.query.sqlpp    |    6 +-
 .../list/listify_02/listify_02.3.query.sqlpp    |    6 +-
 .../query-issue428/query-issue428.3.query.sqlpp |    4 +
 .../groupby-orderby-count.3.query.sqlpp         |    3 +-
 ...from-loaded-dataset-with-index.5.query.sqlpp |    1 +
 ...o-loaded-dataset-with-index_02.5.query.sqlpp |    1 +
 .../adm-format/adm-format.1.ddl.sqlpp           |    5 +
 .../adm-format/adm-format.2.update.sqlpp        |    6 +-
 .../adm-format/adm-format.3.query.sqlpp         |    5 +
 .../leftouterjoin-rtree.1.ddl.sqlpp             |    2 +-
 .../leftouterjoin-rtree.3.query.sqlpp           |    2 +-
 .../leftouterjoin/leftouterjoin.1.ddl.sqlpp     |    2 +-
 .../leftouterjoin/leftouterjoin.2.update.sqlpp  |    2 +-
 ...ex-composite-key-mixed-intervals.1.ddl.sqlpp |    2 +-
 ...composite-key-mixed-intervals.2.update.sqlpp |    2 +-
 ...-composite-key-mixed-intervals.4.query.sqlpp |    2 +-
 .../inverted-index-ngram-contains.1.ddl.sqlpp   |    2 +-
 ...dex-ngram-edit-distance-contains.1.ddl.sqlpp |    2 +-
 ...-index-ngram-edit-distance-panic.1.ddl.sqlpp |    2 +-
 ...-ngram-edit-distance-word-tokens.1.ddl.sqlpp |    2 +-
 ...verted-index-ngram-edit-distance.1.ddl.sqlpp |    2 +-
 .../inverted-index-ngram-jaccard.1.ddl.sqlpp    |    2 +-
 ...-index-olist-edit-distance-panic.1.ddl.sqlpp |    2 +-
 ...verted-index-olist-edit-distance.1.ddl.sqlpp |    2 +-
 .../inverted-index-olist-jaccard.1.ddl.sqlpp    |    2 +-
 .../inverted-index-ulist-jaccard.1.ddl.sqlpp    |    2 +-
 .../inverted-index-word-contains.1.ddl.sqlpp    |    2 +-
 .../inverted-index-word-jaccard.1.ddl.sqlpp     |    2 +-
 .../adm-format/adm-format.1.ddl.sqlpp           |    6 +-
 .../adm-format/adm-format.2.update.sqlpp        |    6 +-
 .../adm-format/adm-format.3.query.sqlpp         |    5 +
 .../leftouterjoin-rtree.1.ddl.sqlpp             |    2 +-
 .../leftouterjoin-rtree.3.query.sqlpp           |    2 +-
 .../leftouterjoin/leftouterjoin.1.ddl.sqlpp     |    2 +-
 .../leftouterjoin/leftouterjoin.2.update.sqlpp  |    2 +-
 .../bottom-closed-top-closed.1.ddl.sqlpp        |    6 +
 .../bottom-closed-top-closed.2.update.sqlpp     |    6 +
 .../bottom-closed-top-closed.3.query.sqlpp      |    6 +
 .../bottom-closed-top-open.1.ddl.sqlpp          |    6 +
 .../bottom-closed-top-open.2.update.sqlpp       |    6 +
 .../bottom-closed-top-open.3.query.sqlpp        |    6 +
 .../bottom-open-top-closed.1.ddl.sqlpp          |    6 +
 .../bottom-open-top-closed.2.update.sqlpp       |    6 +
 .../bottom-open-top-closed.3.query.sqlpp        |    6 +
 .../bottom-open-top-open.1.ddl.sqlpp            |    6 +
 .../bottom-open-top-open.2.update.sqlpp         |    6 +
 .../bottom-open-top-open.3.query.sqlpp          |    6 +
 ...rtree-spatial-intersect-point.2.update.sqlpp |    2 +-
 ...robe-pidx-with-join-invidx-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 |    2 +-
 ...-composite-key-mixed-intervals.4.query.sqlpp |    2 +-
 .../inverted-index-ngram-contains.1.ddl.sqlpp   |    2 +-
 ...dex-ngram-edit-distance-contains.1.ddl.sqlpp |    2 +-
 ...-index-ngram-edit-distance-panic.1.ddl.sqlpp |    2 +-
 ...-ngram-edit-distance-word-tokens.1.ddl.sqlpp |    2 +-
 ...verted-index-ngram-edit-distance.1.ddl.sqlpp |    2 +-
 .../inverted-index-ngram-jaccard.1.ddl.sqlpp    |    2 +-
 .../inverted-index-word-contains.1.ddl.sqlpp    |    2 +-
 .../inverted-index-word-jaccard.1.ddl.sqlpp     |    2 +-
 .../nestrecord/nestrecord.1.ddl.sqlpp           |    4 +-
 .../nestrecord/nestrecord.2.update.sqlpp        |    4 +-
 .../nestrecord/nestrecord.3.query.sqlpp         |    4 +-
 .../heterog-list-ordered01.2.update.sqlpp       |    2 +-
 .../heterog-list-ordered01.3.query.sqlpp        |    2 +-
 .../heterog-list01.2.update.sqlpp               |    2 +-
 .../heterog-list01/heterog-list01.3.query.sqlpp |    2 +-
 .../heterog-list02/heterog-list02.1.ddl.sqlpp   |    2 +-
 .../heterog-list02.2.update.sqlpp               |    2 +-
 .../heterog-list02/heterog-list02.3.query.sqlpp |    2 +-
 .../heterog-list03/heterog-list03.1.ddl.sqlpp   |    2 +-
 .../heterog-list03.2.update.sqlpp               |    2 +-
 .../heterog-list03/heterog-list03.3.query.sqlpp |    2 +-
 .../open-closed-01.2.update.sqlpp               |    4 +-
 .../open-closed-01/open-closed-01.3.query.sqlpp |    4 +-
 .../open-closed-15/open-closed-15.1.ddl.sqlpp   |    2 +-
 .../open-closed-15.2.update.sqlpp               |    2 +-
 .../open-closed-15/open-closed-15.3.query.sqlpp |    2 +-
 .../open-closed-16/open-closed-16.1.ddl.sqlpp   |    2 +-
 .../open-closed-16.2.update.sqlpp               |    2 +-
 .../open-closed-16/open-closed-16.3.query.sqlpp |    2 +-
 .../open-closed-24.2.update.sqlpp               |    2 +-
 .../open-closed-24/open-closed-24.3.query.sqlpp |    2 +-
 .../open-closed-25.2.update.sqlpp               |    2 +-
 .../open-closed-25/open-closed-25.3.query.sqlpp |    2 +-
 .../open-closed-26.2.update.sqlpp               |    2 +-
 .../open-closed-26/open-closed-26.3.query.sqlpp |    2 +-
 .../open-closed-31/open-closed-31.1.ddl.sqlpp   |    2 +-
 .../open-closed-31.2.update.sqlpp               |    2 +-
 .../open-closed-31/open-closed-31.3.query.sqlpp |    2 +-
 .../open-closed-32/open-closed-32.1.ddl.sqlpp   |    2 +-
 .../open-closed-32.2.update.sqlpp               |    2 +-
 .../open-closed-32/open-closed-32.3.query.sqlpp |    2 +-
 .../query-issue134/query-issue134.1.ddl.sqlpp   |    4 +
 .../query-issue134.2.update.sqlpp               |    4 +
 .../query-issue134/query-issue134.3.query.sqlpp |    4 +
 .../query-issue166/query-issue166.1.ddl.sqlpp   |    4 +
 .../query-issue166.2.update.sqlpp               |    4 +
 .../query-issue166/query-issue166.3.query.sqlpp |    4 +
 .../query-issue196/query-issue196.1.ddl.sqlpp   |    4 +
 .../query-issue196.2.update.sqlpp               |    4 +
 .../query-issue196/query-issue196.3.query.sqlpp |    4 +
 .../query-issue208/query-issue208.1.ddl.sqlpp   |    4 +
 .../query-issue208.2.update.sqlpp               |    4 +
 .../query-issue208/query-issue208.3.query.sqlpp |    4 +
 .../query-issue236/query-issue236.1.ddl.sqlpp   |    4 +
 .../query-issue236.2.update.sqlpp               |    4 +
 .../query-issue236/query-issue236.3.query.sqlpp |    4 +
 .../query-issue258/query-issue258.1.ddl.sqlpp   |    4 +
 .../query-issue258.2.update.sqlpp               |    4 +
 .../query-issue258/query-issue258.3.query.sqlpp |    4 +
 .../query-issue29/query-issue29.1.ddl.sqlpp     |    4 +
 .../query-issue29/query-issue29.2.update.sqlpp  |    4 +
 .../query-issue29/query-issue29.3.query.sqlpp   |    4 +
 .../query-issue343-2.1.ddl.sqlpp                |    4 +
 .../query-issue343-2.2.update.sqlpp             |    4 +
 .../query-issue343-2.3.query.sqlpp              |    4 +
 .../query-issue343/query-issue343.1.ddl.sqlpp   |    4 +
 .../query-issue343.2.update.sqlpp               |    4 +
 .../query-issue343/query-issue343.3.query.sqlpp |    4 +
 .../query-issue350-2.1.ddl.sqlpp                |    4 +
 .../query-issue350-2.2.update.sqlpp             |    4 +
 .../query-issue350-2.3.query.sqlpp              |    4 +
 .../query-issue350/query-issue350.1.ddl.sqlpp   |    4 +
 .../query-issue350.2.update.sqlpp               |    4 +
 .../query-issue350/query-issue350.3.query.sqlpp |    4 +
 .../query-issue377/query-issue377.1.ddl.sqlpp   |    4 +
 .../query-issue377.2.update.sqlpp               |    4 +
 .../query-issue377/query-issue377.3.query.sqlpp |    4 +
 .../query-issue410/query-issue410.1.ddl.sqlpp   |    4 +
 .../query-issue410.2.update.sqlpp               |    4 +
 .../query-issue410/query-issue410.3.query.sqlpp |    4 +
 .../query-issue423-2.1.ddl.sqlpp                |    5 +
 .../query-issue423-2.2.update.sqlpp             |    5 +
 .../query-issue423-2.3.query.sqlpp              |    5 +
 .../query-issue423/query-issue423.1.ddl.sqlpp   |    5 +
 .../query-issue423.2.update.sqlpp               |    5 +
 .../query-issue423/query-issue423.3.query.sqlpp |    5 +
 .../query-issue442/query-issue442.3.query.sqlpp |    4 +
 .../query-issue453-2.1.ddl.sqlpp                |    4 +
 .../query-issue453-2.2.update.sqlpp             |    4 +
 .../query-issue453-2.3.query.sqlpp              |    4 +
 .../query-issue453/query-issue453.1.ddl.sqlpp   |    4 +
 .../query-issue453.2.update.sqlpp               |    4 +
 .../query-issue453/query-issue453.3.query.sqlpp |    4 +
 .../query-issue456.2.update.sqlpp               |    2 +-
 .../query-issue456/query-issue456.3.query.sqlpp |    2 +-
 .../query-issue465/query-issue465.1.ddl.sqlpp   |    2 +-
 .../query-issue465.2.update.sqlpp               |    2 +-
 .../query-issue465/query-issue465.3.query.sqlpp |    2 +-
 .../query-issue487/query-issue487.1.ddl.sqlpp   |    4 +
 .../query-issue487.2.update.sqlpp               |    4 +
 .../query-issue487/query-issue487.3.query.sqlpp |    4 +
 .../query-issue55-1/query-issue55-1.1.ddl.sqlpp |    4 +
 .../query-issue55-1.2.update.sqlpp              |    4 +
 .../query-issue55-1.3.query.sqlpp               |    4 +
 .../query-issue55/query-issue55.1.ddl.sqlpp     |    4 +
 .../query-issue55/query-issue55.2.update.sqlpp  |    4 +
 .../query-issue55/query-issue55.3.query.sqlpp   |    4 +
 .../adm-format/adm-format.1.ddl.sqlpp           |    5 +
 .../adm-format/adm-format.2.update.sqlpp        |    6 +-
 .../adm-format/adm-format.3.query.sqlpp         |    6 +-
 .../leftouterjoin-rtree.1.ddl.sqlpp             |    2 +-
 .../leftouterjoin-rtree.3.query.sqlpp           |    2 +-
 .../leftouterjoin/leftouterjoin.1.ddl.sqlpp     |    2 +-
 .../leftouterjoin/leftouterjoin.2.update.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 |    2 +-
 ...-composite-key-mixed-intervals.4.query.sqlpp |    2 +-
 .../inverted-index-ngram-contains.1.ddl.sqlpp   |    2 +-
 ...dex-ngram-edit-distance-contains.1.ddl.sqlpp |    2 +-
 ...-index-ngram-edit-distance-panic.1.ddl.sqlpp |    2 +-
 ...-ngram-edit-distance-word-tokens.1.ddl.sqlpp |    2 +-
 ...verted-index-ngram-edit-distance.1.ddl.sqlpp |    2 +-
 .../inverted-index-ngram-jaccard.1.ddl.sqlpp    |    2 +-
 .../inverted-index-word-contains.1.ddl.sqlpp    |    2 +-
 .../inverted-index-word-jaccard.1.ddl.sqlpp     |    2 +-
 .../everysat_02/everysat_02.1.ddl.sqlpp         |    2 +-
 .../everysat_02/everysat_02.2.update.sqlpp      |    2 +-
 .../everysat_02/everysat_02.3.query.sqlpp       |    2 +-
 .../everysat_03/everysat_03.1.ddl.sqlpp         |    2 +-
 .../everysat_03/everysat_03.2.update.sqlpp      |    2 +-
 .../everysat_03/everysat_03.3.query.sqlpp       |    2 +-
 .../somesat_05/somesat_05.1.ddl.sqlpp           |    2 +-
 .../somesat_05/somesat_05.2.update.sqlpp        |    2 +-
 .../somesat_05/somesat_05.3.query.sqlpp         |    2 +-
 .../scan/invalid-scan-syntax.sqlpp              |    2 +-
 .../invalid-scan-syntax.1.ddl.sqlpp             |    2 +-
 .../invalid-scan-syntax.2.update.sqlpp          |    2 +-
 .../invalid-scan-syntax.3.query.sqlpp           |    2 +-
 .../issue238_query_1.1.ddl.sqlpp                |    7 +
 .../issue238_query_1.2.update.sqlpp             |    9 +-
 .../issue238_query_1.3.query.sqlpp              |   10 +-
 .../issue238_query_2.1.ddl.sqlpp                |    7 +
 .../issue238_query_2.2.update.sqlpp             |    9 +-
 .../issue238_query_2.3.query.sqlpp              |    9 +-
 .../fuzzyeq-edit-distance.1.ddl.sqlpp           |    2 +-
 .../fuzzyeq-similarity-jaccard.1.ddl.sqlpp      |    2 +-
 .../similarity-jaccard-check_query.1.ddl.sqlpp  |    2 +-
 ...arity-jaccard-sorted-check_query.1.ddl.sqlpp |    2 +-
 .../similarity-jaccard-sorted_query.1.ddl.sqlpp |    2 +-
 .../similarity-jaccard_query.1.ddl.sqlpp        |    2 +-
 .../cell-aggregation-with-filtering.1.ddl.sqlpp |    2 +-
 .../string/cpttostr01/cpttostr01.1.ddl.sqlpp    |    2 +-
 .../string/cpttostr01/cpttostr01.2.update.sqlpp |    2 +-
 .../string/cpttostr01/cpttostr01.3.query.sqlpp  |    2 +-
 .../string/end-with1/end-with1.1.ddl.sqlpp      |   22 -
 .../string/end-with1/end-with1.2.update.sqlpp   |   19 -
 .../string/end-with1/end-with1.3.query.sqlpp    |   23 -
 .../string/end-with2/end-with2.1.ddl.sqlpp      |   22 -
 .../string/end-with2/end-with2.2.update.sqlpp   |   19 -
 .../string/end-with2/end-with2.3.query.sqlpp    |   23 -
 .../string/end-with3/end-with3.1.ddl.sqlpp      |   22 -
 .../string/end-with3/end-with3.2.update.sqlpp   |   19 -
 .../string/end-with3/end-with3.3.query.sqlpp    |   23 -
 .../string/end-with4/end-with4.1.ddl.sqlpp      |   22 -
 .../string/end-with4/end-with4.2.update.sqlpp   |   19 -
 .../string/end-with4/end-with4.3.query.sqlpp    |   23 -
 .../string/end-with5/end-with5.1.ddl.sqlpp      |   22 -
 .../string/end-with5/end-with5.2.update.sqlpp   |   19 -
 .../string/end-with5/end-with5.3.query.sqlpp    |   23 -
 .../string/ends-with1/ends-with1.1.ddl.sqlpp    |   22 +
 .../string/ends-with1/ends-with1.2.update.sqlpp |   19 +
 .../string/ends-with1/ends-with1.3.query.sqlpp  |   23 +
 .../string/ends-with2/ends-with2.1.ddl.sqlpp    |   22 +
 .../string/ends-with2/ends-with2.2.update.sqlpp |   19 +
 .../string/ends-with2/ends-with2.3.query.sqlpp  |   23 +
 .../string/ends-with3/ends-with3.1.ddl.sqlpp    |   22 +
 .../string/ends-with3/ends-with3.2.update.sqlpp |   19 +
 .../string/ends-with3/ends-with3.3.query.sqlpp  |   23 +
 .../string/ends-with4/ends-with4.1.ddl.sqlpp    |   22 +
 .../string/ends-with4/ends-with4.2.update.sqlpp |   19 +
 .../string/ends-with4/ends-with4.3.query.sqlpp  |   23 +
 .../string/ends-with5/ends-with5.1.ddl.sqlpp    |   22 +
 .../string/ends-with5/ends-with5.2.update.sqlpp |   19 +
 .../string/ends-with5/ends-with5.3.query.sqlpp  |   23 +
 .../string/ends-with6/ends-with6.1.ddl.sqlpp    |   22 +
 .../string/ends-with6/ends-with6.2.update.sqlpp |   19 +
 .../string/ends-with6/ends-with6.3.query.sqlpp  |   26 +
 .../string/ends-with7/ends-with7.1.ddl.sqlpp    |   25 +
 .../string/ends-with7/ends-with7.2.update.sqlpp |   25 +
 .../string/ends-with7/ends-with7.3.query.sqlpp  |   28 +
 .../string/ends-with8/ends-with8.1.ddl.sqlpp    |   38 +
 .../string/ends-with8/ends-with8.2.update.sqlpp |   40 +
 .../string/ends-with8/ends-with8.3.query.sqlpp  |   33 +
 .../ends-with_01/ends-with_01.1.ddl.sqlpp       |   22 -
 .../ends-with_01/ends-with_01.2.update.sqlpp    |   19 -
 .../ends-with_01/ends-with_01.3.query.sqlpp     |   26 -
 .../string/endwith02/endwith02.1.ddl.sqlpp      |   25 -
 .../string/endwith02/endwith02.2.update.sqlpp   |   25 -
 .../string/endwith02/endwith02.3.query.sqlpp    |   28 -
 .../string/endwith03/endwith03.1.ddl.sqlpp      |   38 -
 .../string/endwith03/endwith03.2.update.sqlpp   |   40 -
 .../string/endwith03/endwith03.3.query.sqlpp    |   33 -
 .../string/matches11/matches11.3.query.sqlpp    |    2 +-
 .../string/start-with1/start-with1.1.ddl.sqlpp  |   22 -
 .../start-with1/start-with1.2.update.sqlpp      |   19 -
 .../start-with1/start-with1.3.query.sqlpp       |   23 -
 .../string/start-with2/start-with2.1.ddl.sqlpp  |   22 -
 .../start-with2/start-with2.2.update.sqlpp      |   19 -
 .../start-with2/start-with2.3.query.sqlpp       |   23 -
 .../string/start-with3/start-with3.1.ddl.sqlpp  |   22 -
 .../start-with3/start-with3.2.update.sqlpp      |   19 -
 .../start-with3/start-with3.3.query.sqlpp       |   23 -
 .../string/start-with4/start-with4.1.ddl.sqlpp  |   22 -
 .../start-with4/start-with4.2.update.sqlpp      |   19 -
 .../start-with4/start-with4.3.query.sqlpp       |   23 -
 .../string/start-with5/start-with5.1.ddl.sqlpp  |   22 -
 .../start-with5/start-with5.2.update.sqlpp      |   19 -
 .../start-with5/start-with5.3.query.sqlpp       |   23 -
 .../starts-with1/starts-with1.1.ddl.sqlpp       |   22 +
 .../starts-with1/starts-with1.2.update.sqlpp    |   19 +
 .../starts-with1/starts-with1.3.query.sqlpp     |   23 +
 .../starts-with2/starts-with2.1.ddl.sqlpp       |   22 +
 .../starts-with2/starts-with2.2.update.sqlpp    |   19 +
 .../starts-with2/starts-with2.3.query.sqlpp     |   23 +
 .../starts-with3/starts-with3.1.ddl.sqlpp       |   22 +
 .../starts-with3/starts-with3.2.update.sqlpp    |   19 +
 .../starts-with3/starts-with3.3.query.sqlpp     |   23 +
 .../starts-with4/starts-with4.1.ddl.sqlpp       |   22 +
 .../starts-with4/starts-with4.2.update.sqlpp    |   19 +
 .../starts-with4/starts-with4.3.query.sqlpp     |   23 +
 .../starts-with5/starts-with5.1.ddl.sqlpp       |   22 +
 .../starts-with5/starts-with5.2.update.sqlpp    |   19 +
 .../starts-with5/starts-with5.3.query.sqlpp     |   23 +
 .../starts-with6/starts-with6.1.ddl.sqlpp       |   22 +
 .../starts-with6/starts-with6.2.update.sqlpp    |   19 +
 .../starts-with6/starts-with6.3.query.sqlpp     |   26 +
 .../starts-with7/starts-with7.1.ddl.sqlpp       |   25 +
 .../starts-with7/starts-with7.2.update.sqlpp    |   25 +
 .../starts-with7/starts-with7.3.query.sqlpp     |   28 +
 .../starts-with8/starts-with8.1.ddl.sqlpp       |   38 +
 .../starts-with8/starts-with8.2.update.sqlpp    |   42 +
 .../starts-with8/starts-with8.3.query.sqlpp     |   33 +
 .../starts-with_01/starts-with_01.1.ddl.sqlpp   |   22 -
 .../starts-with_01.2.update.sqlpp               |   19 -
 .../starts-with_01/starts-with_01.3.query.sqlpp |   26 -
 .../string/startwith02/startwith02.1.ddl.sqlpp  |   25 -
 .../startwith02/startwith02.2.update.sqlpp      |   25 -
 .../startwith02/startwith02.3.query.sqlpp       |   28 -
 .../string/startwith03/startwith03.1.ddl.sqlpp  |   38 -
 .../startwith03/startwith03.2.update.sqlpp      |   42 -
 .../startwith03/startwith03.3.query.sqlpp       |   33 -
 .../string/strconcat01/strconcat01.1.ddl.sqlpp  |    2 +-
 .../strconcat01/strconcat01.2.update.sqlpp      |    2 +-
 .../strconcat01/strconcat01.3.query.sqlpp       |    2 +-
 .../string/strlen02/strlen02.1.ddl.sqlpp        |    2 +-
 .../string/strlen02/strlen02.2.update.sqlpp     |    2 +-
 .../string/strlen02/strlen02.3.query.sqlpp      |    2 +-
 .../string/strlen03/strlen03.1.ddl.sqlpp        |    2 +-
 .../string/strlen03/strlen03.2.update.sqlpp     |    2 +-
 .../string/strlen03/strlen03.3.query.sqlpp      |    2 +-
 .../string/strtocpt02/strtocpt02.1.ddl.sqlpp    |    2 +-
 .../string/strtocpt02/strtocpt02.2.update.sqlpp |    2 +-
 .../string/strtocpt02/strtocpt02.3.query.sqlpp  |    2 +-
 .../string/strtocpt03/strtocpt03.1.ddl.sqlpp    |    2 +-
 .../string/strtocpt03/strtocpt03.2.update.sqlpp |    2 +-
 .../string/strtocpt03/strtocpt03.3.query.sqlpp  |    2 +-
 .../toLowerCase03/toLowerCase03.1.ddl.sqlpp     |    2 +-
 .../toLowerCase03/toLowerCase03.2.update.sqlpp  |    2 +-
 .../toLowerCase03/toLowerCase03.3.query.sqlpp   |    2 +-
 .../toLowerCase04/toLowerCase04.1.ddl.sqlpp     |    2 +-
 .../toLowerCase04/toLowerCase04.2.update.sqlpp  |    2 +-
 .../toLowerCase04/toLowerCase04.3.query.sqlpp   |    2 +-
 .../varlen-encoding/varlen-encoding.1.ddl.sqlpp |   19 +
 .../varlen-encoding.2.update.sqlpp              |   19 +
 .../varlen-encoding.3.query.sqlpp               |   35 +
 .../insert-and-scan-dataset.2.update.sqlpp      |    2 +-
 .../insert-and-scan-dataset.3.query.sqlpp       |    2 +-
 .../scan-insert-persistent-to-temp.1.ddl.sqlpp  |    2 +-
 ...can-insert-persistent-to-temp.2.update.sqlpp |    2 +-
 .../scan-insert-persistent-to-temp.3.ddl.sqlpp  |    2 +-
 ...can-insert-persistent-to-temp.4.update.sqlpp |    2 +-
 ...scan-insert-persistent-to-temp.5.query.sqlpp |    2 +-
 ...can-insert-rtree-secondary-index.1.ddl.sqlpp |    2 +-
 ...-insert-rtree-secondary-index.2.update.sqlpp |    2 +-
 ...can-insert-rtree-secondary-index.3.ddl.sqlpp |    2 +-
 ...-insert-rtree-secondary-index.4.update.sqlpp |    2 +-
 ...n-insert-rtree-secondary-index.5.query.sqlpp |    2 +-
 .../scan-insert-temp-to-persistent.1.ddl.sqlpp  |    2 +-
 ...can-insert-temp-to-persistent.2.update.sqlpp |    2 +-
 .../scan-insert-temp-to-persistent.3.ddl.sqlpp  |    2 +-
 ...can-insert-temp-to-persistent.4.update.sqlpp |    2 +-
 ...scan-insert-temp-to-persistent.5.query.sqlpp |    2 +-
 .../interval_bin_gby_0.2.update.sqlpp           |   24 +-
 .../interval_functions.3.query.sqlpp            |   56 +-
 .../overlap_bins_gby_0.3.query.sqlpp            |    8 +-
 .../tinysocial-suite.11.query.sqlpp             |    2 +-
 .../tinysocial-suite.6.query.sqlpp              |    2 +-
 .../q04_order_priority.3.query.sqlpp            |    2 +-
 ...7_small_quantity_order_revenue.3.query.sqlpp |    1 +
 .../q20_potential_part_promotion.3.query.sqlpp  |    4 +-
 .../tpch/distinct_by/distinct_by.3.query.sqlpp  |    2 +-
 .../nest_aggregate/nest_aggregate.3.query.sqlpp |    3 +-
 .../q04_order_priority.3.query.sqlpp            |   10 +-
 .../q09_product_type_profit_nt.3.query.sqlpp    |   12 +-
 ...7_small_quantity_order_revenue.3.query.sqlpp |    9 +-
 .../q18_large_volume_customer.3.query.sqlpp     |    2 +-
 .../q20_potential_part_promotion.3.query.sqlpp  |    4 +-
 ...pliers_who_kept_orders_waiting.3.query.sqlpp |   24 +-
 .../query-issue172/query-issue172.1.ddl.sqlpp   |    4 +
 .../query-issue172.2.update.sqlpp               |    4 +
 .../query-issue172/query-issue172.3.query.sqlpp |    4 +
 .../query-issue201/query-issue201.1.ddl.sqlpp   |    4 +
 .../query-issue201.2.update.sqlpp               |    4 +
 .../query-issue201/query-issue201.3.query.sqlpp |    4 +
 .../query-issue218-2.1.ddl.sqlpp                |   14 +
 .../query-issue218-2.2.update.sqlpp             |    4 +
 .../query-issue218-2.3.query.sqlpp              |    4 +
 .../query-issue218/query-issue218.1.ddl.sqlpp   |   14 +
 .../query-issue218.2.update.sqlpp               |    4 +
 .../query-issue218/query-issue218.3.query.sqlpp |    4 +
 .../query-issue244/query-issue244.1.ddl.sqlpp   |   22 +
 .../query-issue244.2.update.sqlpp               |   21 +-
 .../query-issue244/query-issue244.3.query.sqlpp |    4 +
 .../query-issue455/query-issue455.1.ddl.sqlpp   |   12 +
 .../query-issue455.2.update.sqlpp               |    4 +
 .../query-issue455/query-issue455.3.query.sqlpp |    4 +
 .../query-issue455/query-issue455.4.ddl.sqlpp   |    4 +
 .../query-issue455/query-issue455.5.query.sqlpp |    4 +
 .../query-issue489/query-issue489.1.ddl.sqlpp   |   17 +
 .../query-issue489/query-issue489.2.query.sqlpp |    4 +
 .../query-issue489/query-issue489.3.ddl.sqlpp   |    4 +
 .../query-issue489/query-issue489.4.query.sqlpp |    4 +
 .../udf01/udf01.1.ddl.sqlpp                     |   10 +
 .../udf02/udf02.1.ddl.sqlpp                     |    8 +
 .../udf03/udf03.1.ddl.sqlpp                     |   11 +
 .../udf04/udf04.1.ddl.sqlpp                     |    8 +
 .../udf05/udf05.1.ddl.sqlpp                     |    8 +
 .../udf06/udf06.1.ddl.sqlpp                     |    9 +
 .../udf07/udf07.1.ddl.sqlpp                     |    8 +
 .../udf08/udf08.1.ddl.sqlpp                     |    8 +
 .../udf09/udf09.1.ddl.sqlpp                     |   14 +
 .../udf09/udf09.2.update.sqlpp                  |    2 +-
 .../udf09/udf09.3.query.sqlpp                   |    2 +-
 .../udf10/udf10.1.ddl.sqlpp                     |    8 +
 .../udf11/udf11.1.ddl.sqlpp                     |    9 +
 .../udf12/udf12.1.ddl.sqlpp                     |    9 +
 .../udf13/udf13.1.ddl.sqlpp                     |    8 +
 .../udf14/udf14.1.ddl.sqlpp                     |    8 +
 .../udf15/udf15.1.ddl.sqlpp                     |   10 +
 .../udf16/udf16.1.ddl.sqlpp                     |    9 +
 .../udf17/udf17.1.ddl.sqlpp                     |   15 +-
 .../udf17/udf17.2.update.sqlpp                  |    2 +-
 .../udf17/udf17.3.query.sqlpp                   |    2 +-
 .../udf18/udf18.1.ddl.sqlpp                     |    8 +
 .../udf19/udf19.1.ddl.sqlpp                     |   13 +
 .../udf20/udf20.1.ddl.sqlpp                     |   13 +
 .../udf21/udf21.1.ddl.sqlpp                     |   10 +
 .../udf22/udf22.1.ddl.sqlpp                     |    9 +
 .../udf23/udf23.1.ddl.sqlpp                     |    8 +
 .../udf24/udf24.1.ddl.sqlpp                     |   16 +-
 .../udf25/udf25.1.ddl.sqlpp                     |   14 +
 .../udf26/udf26.1.ddl.sqlpp                     |    8 +
 .../udf27/udf27.1.ddl.sqlpp                     |   13 +
 .../udf28/udf28.1.ddl.sqlpp                     |   12 +
 .../udf30/udf30.1.query.sqlpp                   |    7 +
 .../udf31/udf31.1.ddl.sqlpp                     |   26 +
 .../big-object/big_object_groupby/groupby.1.adm |  400 +-
 .../cross-dataverse/cross-dv15/cross-dv15.1.adm |    6 +-
 .../tpch/nest_aggregate/nest_aggregate.1.adm    |    8 +-
 .../query-issue400/query-issue400.3.ast         |   26 +
 .../query-issue400/query-issue400.3.ast         |   26 +
 .../big_object_groupby.1.ast                    |   49 +
 .../big_object_groupby.3.ast                    |   55 +
 .../big_object_groupby/big_object_groupby.1.ast |   49 +
 .../big_object_groupby/big_object_groupby.3.ast |   36 +
 .../big_object_join/big_object_join.1.ast       |   49 +
 .../big_object_join/big_object_join.3.ast       |   74 +
 .../big_object_sort/big_object_sort.1.ast       |   49 +
 .../big_object_sort/big_object_sort.3.ast       |   58 +
 .../results_parser_sqlpp/binary/find/find.3.ast |  172 +-
 .../binary/subbinary/subbinary_01.3.ast         |   15 +-
 .../boolean/and_01/and_01.3.ast                 |   16 +-
 .../comparison/binary_null/binary_null.3.ast    |   24 +-
 .../comparison/double_null/double_null.3.ast    |   24 +-
 .../comparison/float_null/float_null.3.ast      |   24 +-
 .../comparison/int16_null/int16_null.3.ast      |   24 +-
 .../comparison/int32_null/int32_null.3.ast      |   24 +-
 .../comparison/int64_null/int64_null.3.ast      |   24 +-
 .../comparison/int8_null/int8_null.3.ast        |   24 +-
 .../comparison/string_null/string_null.3.ast    |   24 +-
 .../cross-dataverse/cross-dv15/cross-dv15.3.ast |   43 +-
 .../custord/customer_q_06/customer_q_06.3.ast   |    4 +-
 .../custord/customer_q_07/customer_q_07.3.ast   |    4 +-
 .../custord/join_q_03/join_q_03.3.ast           |    6 +-
 .../custord/join_q_04/join_q_04.3.ast           |   64 +
 .../custord/order_q_03/order_q_03.3.ast         |    6 +-
 .../custord/order_q_04/order_q_04.3.ast         |    8 +-
 .../custord/order_q_05/order_q_05.3.ast         |    4 +-
 .../results_parser_sqlpp/dapd/q2/q2.3.ast       |    4 +-
 .../query-issue443-2/query-issue443-2.1.ast     |    2 +-
 .../query-issue443/query-issue443.1.ast         |   44 +
 .../insert-and-scan-joined-datasets.1.ast       |    8 +
 .../insert-and-scan-joined-datasets.2.ast       |    1 +
 .../insert-and-scan-joined-datasets.3.ast       |   18 +
 .../load-with-word-index-open.3.ast             |    2 +-
 .../load-with-word-index.3.ast                  |    2 +-
 .../dml/query-issue205/query-issue205.1.ast     |   15 +
 .../dml/query-issue205/query-issue205.2.ast     |    1 +
 .../dml/query-issue205/query-issue205.3.ast     |   11 +
 .../dml/query-issue288/query-issue288.1.ast     |   10 +
 .../dml/query-issue288/query-issue288.2.ast     |    1 +
 .../dml/query-issue288/query-issue288.3.ast     |    1 +
 .../dml/query-issue288/query-issue288.4.ast     |    1 +
 .../dml/query-issue288/query-issue288.5.ast     |   20 +
 .../dml/query-issue433/query-issue433.1.ast     |   16 +
 .../dml/query-issue433/query-issue433.2.ast     |    1 +
 .../dml/query-issue433/query-issue433.3.ast     |   18 +
 ...ed-index-word-secondary-index-nullable.5.ast |    2 +-
 ...verted-index-word-secondary-index-open.5.ast |    2 +-
 ...te-inverted-index-word-secondary-index.5.ast |    2 +-
 ...ed-index-word-secondary-index-nullable.5.ast |    2 +-
 ...verted-index-word-secondary-index-open.5.ast |    2 +-
 ...rt-inverted-index-word-secondary-index.5.ast |    2 +-
 .../employee/q_02/q_02.3.ast                    |    5 +-
 .../external-indexing/rc-format/rc-format.1.ast |    9 +
 .../external-indexing/rc-format/rc-format.3.ast |   20 +
 .../sequence-format/sequence-format.1.ast       |    9 +
 .../sequence-format/sequence-format.3.ast       |   20 +
 .../text-format/text-format.1.ast               |    9 +
 .../text-format/text-format.3.ast               |   27 +
 .../results_parser_sqlpp/flwor/at00/at00.3.ast  |   26 +-
 .../results_parser_sqlpp/flwor/at00/at00.4.ast  |   26 +-
 .../results_parser_sqlpp/flwor/at00/at00.5.ast  |   26 +-
 .../results_parser_sqlpp/flwor/at06/at06.3.ast  |   29 +-
 .../fuzzyjoin/dblp-2.1_5.3.1/dblp-2.3.ast       |    1 -
 .../fuzzyjoin/dblp-2_1/dblp-2_1.3.ast           |    1 -
 .../fuzzyjoin/dblp-2_2/dblp-2_2.3.ast           |    1 -
 .../fuzzyjoin/dblp-2_3/dblp-2_3.3.ast           |    1 -
 .../fuzzyjoin/dblp-2_4/dblp-2_4.3.ast           |    1 -
 .../fuzzyjoin/dblp-2_5.1/dblp-2_5.3.ast         |    1 -
 .../fuzzyjoin/dblp-2_5.2/dblp-2_5.3.ast         |    1 -
 .../fuzzyjoin/dblp-2_5.3.1/dblp-2_5.3.ast       |    1 -
 .../fuzzyjoin/dblp-2_5.3/dblp-2_5.3.ast         |    1 -
 .../fuzzyjoin/dblp-2_5/dblp-2_5.3.ast           |    1 -
 .../fuzzyjoin/dblp-3_1.1/dblp-3_1.3.ast         |    4 +-
 .../fuzzyjoin/dblp-3_1.2/dblp-3_1.3.ast         |    4 +-
 .../fuzzyjoin/dblp-3_1/dblp-3_1.3.ast           |   10 +-
 .../fuzzyjoin/dblp-csx-2_1/dblp-csx-2_1.3.ast   |    4 +-
 .../fuzzyjoin/dblp-csx-2_2/dblp-csx-2_2.3.ast   |    4 +-
 .../fuzzyjoin/dblp-csx-2_3/dblp-csx-2_3.3.ast   |    4 +-
 .../fuzzyjoin/dblp-csx-2_4/dblp-csx-2_4.3.ast   |    4 +-
 .../fuzzyjoin/dblp-csx-2_5.1/dblp-csx-2_5.3.ast |    4 +-
 .../fuzzyjoin/dblp-csx-2_5.2/dblp-csx-2_5.3.ast |    4 +-
 .../dblp-csx-2_5.3.1/dblp-csx-2_5.3.ast         |    4 +-
 .../fuzzyjoin/dblp-csx-2_5.3/dblp-csx-2_5.3.ast |    4 +-
 .../fuzzyjoin/dblp-csx-2_5/dblp-csx-2_5.3.ast   |    4 +-
 .../fuzzyjoin/dblp-csx-3_1/dblp-csx-3_1.3.ast   |    4 +-
 .../fuzzyjoin/dblp-csx-3_2/dblp-csx-3_2.3.ast   |    4 +-
 .../fuzzyjoin/dblp-csx-3_3/dblp-csx-3_3.3.ast   |    4 +-
 .../fuzzyjoin/dblp-csx-3_4/dblp-csx-3_4.3.ast   |    4 +-
 .../fuzzyjoin/dblp-csx-3_5.1/dblp-csx-3_5.3.ast |    4 +-
 .../fuzzyjoin/dblp-csx-3_5.2/dblp-csx-3_5.3.ast |    4 +-
 .../dblp-csx-3_5.3.1/dblp-csx-3_5.3.ast         |    4 +-
 .../fuzzyjoin/dblp-csx-3_5.3/dblp-csx-3_5.3.ast |    4 +-
 .../dblp-csx-3_5.4.1/dblp-csx-3_5.3.ast         |   10 +-
 .../fuzzyjoin/dblp-csx-3_5.4/dblp-csx-3_5.3.ast |   10 +-
 .../fuzzyjoin/dblp-csx-3_5/dblp-csx-3_5.3.ast   |    4 +-
 .../hdfs/hdfs_02/hdfs_02.1.ast                  |    7 +
 .../hdfs/hdfs_02/hdfs_02.3.ast                  |   45 +
 .../hdfs/hdfs_03/hdfs_03.1.ast                  |    7 +
 .../hdfs/hdfs_03/hdfs_03.3.ast                  |   45 +
 .../hdfs_shortcircuit/hdfs_shortcircuit.1.ast   |    7 +
 .../hdfs_shortcircuit/hdfs_shortcircuit.3.ast   |   45 +
 .../hdfs/issue_245_hdfs/issue_245_hdfs.1.ast    |    7 +
 .../hdfs/issue_245_hdfs/issue_245_hdfs.3.ast    |   18 +
 .../issue_251_dataset_hint_5.1.ast              |   11 +
 .../issue_251_dataset_hint_5.2.ast              |    1 +
 .../issue_251_dataset_hint_5.3.ast              |   18 +
 .../issue_251_dataset_hint_6.1.ast              |    7 +
 .../issue_251_dataset_hint_6.3.ast              |   45 +
 .../issue_251_dataset_hint_7.1.ast              |   11 +
 .../issue_251_dataset_hint_7.2.ast              |    2 +
 .../issue_251_dataset_hint_7.3.ast              |   18 +
 .../probe-pidx-with-join-invidx-sidx1.3.ast     |    2 +-
 .../probe-pidx-with-join-invidx-sidx2.3.ast     |    2 +-
 ...ted-index-ngram-edit-distance-contains.4.ast |    9 +-
 ...verted-index-ngram-edit-distance-panic.4.ast |    2 +-
 ...-index-ngram-edit-distance-word-tokens.4.ast |    6 +-
 .../inverted-index-ngram-edit-distance.4.ast    |    2 +-
 .../inverted-index-ngram-jaccard.4.ast          |    2 +-
 ...verted-index-olist-edit-distance-panic.4.ast |    2 +-
 .../inverted-index-olist-edit-distance.4.ast    |    2 +-
 .../inverted-index-olist-jaccard.4.ast          |    2 +-
 .../inverted-index-ulist-jaccard.4.ast          |    2 +-
 .../inverted-index-word-jaccard.4.ast           |    2 +-
 .../list/get-item_01/get-item_01.3.ast          |    7 +-
 .../list/get-item_02/get-item_02.3.ast          |    7 +-
 .../list/listify_01/listify_01.3.ast            |   25 +-
 .../list/listify_02/listify_02.3.ast            |   23 +-
 .../list/query-issue428/query-issue428.3.ast    |   48 +
 .../groupby-orderby-count.3.ast                 |   12 +-
 .../delete-from-loaded-dataset-with-index.5.ast |    7 +
 ...sert-into-loaded-dataset-with-index_02.5.ast |    7 +
 .../load-with-word-index.3.ast                  |    2 +-
 ...ed-index-word-secondary-index-nullable.5.ast |    2 +-
 ...te-inverted-index-word-secondary-index.5.ast |    2 +-
 ...ed-index-word-secondary-index-nullable.5.ast |    2 +-
 ...rt-inverted-index-word-secondary-index.5.ast |    2 +-
 .../adm-format/adm-format.1.ast                 |   20 +
 .../adm-format/adm-format.3.ast                 |  123 +
 .../probe-pidx-with-join-invidx-sidx1.3.ast     |    2 +-
 .../probe-pidx-with-join-invidx-sidx2.3.ast     |    2 +-
 ...ted-index-ngram-edit-distance-contains.4.ast |   12 +-
 ...verted-index-ngram-edit-distance-panic.4.ast |    2 +-
 ...-index-ngram-edit-distance-word-tokens.4.ast |    6 +-
 .../inverted-index-ngram-edit-distance.4.ast    |    2 +-
 .../inverted-index-ngram-jaccard.4.ast          |    2 +-
 ...verted-index-olist-edit-distance-panic.4.ast |    2 +-
 .../inverted-index-olist-edit-distance.4.ast    |    2 +-
 .../inverted-index-olist-jaccard.4.ast          |    2 +-
 .../inverted-index-ulist-jaccard.4.ast          |    2 +-
 .../inverted-index-word-jaccard.4.ast           |    2 +-
 .../adm-format/adm-format.1.ast                 |   19 +
 .../adm-format/adm-format.3.ast                 |  123 +
 .../bottom-closed-top-closed.1.ast              |   68 +
 .../bottom-closed-top-closed.2.ast              |    1 +
 .../bottom-closed-top-closed.3.ast              |   44 +
 .../bottom-closed-top-open.1.ast                |   67 +
 .../bottom-closed-top-open.2.ast                |    1 +
 .../bottom-closed-top-open.3.ast                |   44 +
 .../bottom-open-top-closed.1.ast                |   67 +
 .../bottom-open-top-closed.2.ast                |    1 +
 .../bottom-open-top-closed.3.ast                |   44 +
 .../bottom-open-top-open.1.ast                  |   66 +
 .../bottom-open-top-open.2.ast                  |    1 +
 .../bottom-open-top-open.3.ast                  |   44 +
 .../probe-pidx-with-join-invidx-sidx2.3.ast     |    2 +-
 ...ted-index-ngram-edit-distance-contains.4.ast |   12 +-
 ...verted-index-ngram-edit-distance-panic.4.ast |    2 +-
 .../inverted-index-ngram-edit-distance.4.ast    |    2 +-
 .../inverted-index-ngram-jaccard.4.ast          |    2 +-
 .../inverted-index-word-jaccard.4.ast           |    2 +-
 .../numeric/add_double/add_double.3.ast         |    4 +-
 .../numeric/add_float/add_float.3.ast           |    4 +-
 .../numeric/add_int16/add_int16.3.ast           |    4 +-
 .../numeric/add_int32/add_int32.3.ast           |    4 +-
 .../numeric/add_int64/add_int64.3.ast           |    4 +-
 .../numeric/add_int8/add_int8.3.ast             |    4 +-
 .../numeric/divide_double/divide_double.3.ast   |    4 +-
 .../numeric/divide_float/divide_float.3.ast     |    4 +-
 .../numeric/divide_int16/divide_int16.3.ast     |    4 +-
 .../numeric/divide_int32/divide_int32.3.ast     |    4 +-
 .../numeric/divide_int64/divide_int64.3.ast     |    4 +-
 .../numeric/divide_int8/divide_int8.3.ast       |    4 +-
 .../multiply_double/multiply_double.3.ast       |    4 +-
 .../numeric/multiply_float/multiply_float.3.ast |    4 +-
 .../numeric/multiply_int16/multiply_int16.3.ast |    4 +-
 .../numeric/multiply_int32/multiply_int32.3.ast |    4 +-
 .../numeric/multiply_int64/multiply_int64.3.ast |    4 +-
 .../numeric/multiply_int8/multiply_int8.3.ast   |    4 +-
 .../subtract_double/subtract_double.3.ast       |    4 +-
 .../numeric/subtract_float/subtract_float.3.ast |    4 +-
 .../numeric/subtract_int16/subtract_int16.3.ast |    4 +-
 .../numeric/subtract_int32/subtract_int32.3.ast |    4 +-
 .../numeric/subtract_int64/subtract_int64.3.ast |    4 +-
 .../numeric/subtract_int8/subtract_int8.3.ast   |    4 +-
 .../unary-minus_null/unary-minus_null.3.ast     |    4 +-
 .../query-issue134/query-issue134.3.ast         |   25 +
 .../query-issue166/query-issue166.3.ast         |   17 +
 .../query-issue196/query-issue196.1.ast         |   13 +
 .../query-issue196/query-issue196.2.ast         |    1 +
 .../query-issue196/query-issue196.3.ast         |   48 +
 .../query-issue208/query-issue208.1.ast         |   19 +
 .../query-issue208/query-issue208.2.ast         |    1 +
 .../query-issue208/query-issue208.3.ast         |   65 +
 .../query-issue236/query-issue236.1.ast         |   25 +
 .../query-issue236/query-issue236.2.ast         |    1 +
 .../query-issue236/query-issue236.3.ast         |   11 +
 .../query-issue258/query-issue258.1.ast         |    8 +
 .../query-issue258/query-issue258.2.ast         |    1 +
 .../query-issue258/query-issue258.3.ast         |   11 +
 .../query-issue343-2/query-issue343-2.1.ast     |   40 +
 .../query-issue343-2/query-issue343-2.2.ast     |    1 +
 .../query-issue343-2/query-issue343-2.3.ast     |   11 +
 .../query-issue343/query-issue343.1.ast         |   32 +
 .../query-issue343/query-issue343.2.ast         |    1 +
 .../query-issue343/query-issue343.3.ast         |   11 +
 .../query-issue350-2/query-issue350-2.1.ast     |    7 +
 .../query-issue350-2/query-issue350-2.2.ast     |    1 +
 .../query-issue350-2/query-issue350-2.3.ast     |   38 +
 .../query-issue350/query-issue350.1.ast         |    7 +
 .../query-issue350/query-issue350.2.ast         |    1 +
 .../query-issue350/query-issue350.3.ast         |   31 +
 .../query-issue377/query-issue377.1.ast         |   25 +
 .../query-issue377/query-issue377.2.ast         |    1 +
 .../query-issue377/query-issue377.3.ast         |   87 +
 .../query-issue410/query-issue410.1.ast         |    8 +
 .../query-issue410/query-issue410.2.ast         |    1 +
 .../query-issue410/query-issue410.3.ast         |   11 +
 .../query-issue423-2/query-issue423-2.1.ast     |   10 +
 .../query-issue423-2/query-issue423-2.2.ast     |    1 +
 .../query-issue423-2/query-issue423-2.3.ast     |   40 +
 .../query-issue423/query-issue423.1.ast         |   10 +
 .../query-issue423/query-issue423.2.ast         |    1 +
 .../query-issue423/query-issue423.3.ast         |   40 +
 .../query-issue442/query-issue442.1.ast         |   65 +
 .../query-issue453-2/query-issue453-2.1.ast     |   11 +
 .../query-issue453-2/query-issue453-2.2.ast     |    1 +
 .../query-issue453-2/query-issue453-2.3.ast     |   18 +
 .../query-issue453/query-issue453.1.ast         |   11 +
 .../query-issue453/query-issue453.2.ast         |    1 +
 .../query-issue453/query-issue453.3.ast         |   18 +
 .../query-issue487/query-issue487.1.ast         |    8 +
 .../query-issue487/query-issue487.2.ast         |    1 +
 .../query-issue487/query-issue487.3.ast         |   11 +
 .../query-issue55-1/query-issue55-1.3.ast       |   56 +
 .../query-issue55/query-issue55.3.ast           |   26 +
 .../adm-format/adm-format.1.ast                 |   14 +
 .../adm-format/adm-format.3.ast                 |   20 +
 .../probe-pidx-with-join-invidx-sidx2.3.ast     |    2 +-
 ...ted-index-ngram-edit-distance-contains.4.ast |    9 +-
 ...verted-index-ngram-edit-distance-panic.4.ast |    2 +-
 ...-index-ngram-edit-distance-word-tokens.4.ast |    6 +-
 .../inverted-index-ngram-edit-distance.4.ast    |    2 +-
 .../inverted-index-ngram-jaccard.4.ast          |    2 +-
 .../inverted-index-word-jaccard.4.ast           |    2 +-
 .../issue238_query_1/issue238_query_1.1.ast     |   11 +
 .../issue238_query_1/issue238_query_1.2.ast     |    1 +
 .../issue238_query_1/issue238_query_1.3.ast     |   18 +
 .../issue238_query_2/issue238_query_2.1.ast     |   11 +
 .../issue238_query_2/issue238_query_2.2.ast     |    1 +
 .../issue238_query_2/issue238_query_2.3.ast     |   18 +
 .../similarity-jaccard-check_query.3.ast        |    2 +-
 .../similarity-jaccard-sorted-check_query.3.ast |    2 +-
 .../cell-aggregation/cell-aggregation.3.ast     |    1 -
 .../string/matches11/matches11.3.ast            |    1 +
 .../interval_functions/interval_functions.3.ast |  567 +-
 .../overlap_bins_gby_0/overlap_bins_gby_0.3.ast |   38 +-
 .../query-issue785-2/query-issue785-2.3.ast     |    1 -
 .../query-issue785/query-issue785.3.ast         |    1 +
 .../tpch/nest_aggregate/nest_aggregate.3.ast    |    7 +
 .../q04_order_priority/q04_order_priority.3.ast |   18 +-
 .../q09_product_type_profit_nt.3.ast            |  438 +-
 .../q18_large_volume_customer.3.ast             |   38 +-
 .../q21_suppliers_who_kept_orders_waiting.3.ast |   40 +-
 .../query-issue785-2/query-issue785-2.3.ast     |    1 -
 .../tpch/query-issue785/query-issue785.3.ast    |    1 +
 .../query-issue172/query-issue172.3.ast         |    9 +
 .../query-issue201/query-issue201.3.ast         |   15 +
 .../query-issue218-2/query-issue218-2.3.ast     |    7 +
 .../query-issue218/query-issue218.3.ast         |    2 +
 .../query-issue244/query-issue244.1.ast         |    9 +
 .../query-issue244/query-issue244.2.ast         |    1 +
 .../query-issue244/query-issue244.3.ast         |   18 +
 .../query-issue455/query-issue455.2.ast         |    5 +
 .../query-issue455/query-issue455.4.ast         |   15 +
 .../query-issue489/query-issue489.1.ast         |    1 +
 .../query-issue489/query-issue489.2.ast         |   25 +
 .../query-issue489/query-issue489.4.ast         |   25 +
 .../user-defined-functions/udf01/udf01.1.ast    |    1 +
 .../user-defined-functions/udf02/udf02.1.ast    |    1 +
 .../user-defined-functions/udf04/udf04.1.ast    |    1 +
 .../user-defined-functions/udf05/udf05.1.ast    |    1 +
 .../user-defined-functions/udf06/udf06.1.ast    |    1 +
 .../user-defined-functions/udf07/udf07.1.ast    |    1 +
 .../user-defined-functions/udf08/udf08.1.ast    |    1 +
 .../user-defined-functions/udf09/udf09.1.ast    |    7 +
 .../user-defined-functions/udf10/udf10.1.ast    |    1 +
 .../user-defined-functions/udf11/udf11.1.ast    |    1 +
 .../user-defined-functions/udf12/udf12.1.ast    |    1 +
 .../user-defined-functions/udf13/udf13.1.ast    |    1 +
 .../user-defined-functions/udf14/udf14.1.ast    |    1 +
 .../user-defined-functions/udf16/udf16.1.ast    |    1 +
 .../user-defined-functions/udf17/udf17.1.ast    |    1 +
 .../user-defined-functions/udf18/udf18.1.ast    |    1 +
 .../user-defined-functions/udf19/udf19.1.ast    |    1 +
 .../user-defined-functions/udf20/udf20.1.ast    |    1 +
 .../user-defined-functions/udf21/udf21.1.ast    |    1 +
 .../user-defined-functions/udf22/udf22.1.ast    |    1 +
 .../user-defined-functions/udf23/udf23.1.ast    |    1 +
 .../user-defined-functions/udf26/udf26.1.ast    |    1 +
 .../user-defined-functions/udf27/udf27.1.ast    |    1 +
 .../user-defined-functions/udf28/udf28.1.ast    |    1 +
 .../resources/runtimets/testsuite_sqlpp.xml     | 6587 ++++++++++++++++++
 .../apache/asterix/test/aql/TestExecutor.java   |   86 +-
 .../org/apache/asterix/test/aql/TestsUtils.java |  574 --
 .../asterix/lang/aql/clause/DistinctClause.java |    4 +
 .../lang/aql/parser/AQLParserFactory.java       |   38 +
 .../asterix/lang/aql/parser/FunctionParser.java |   73 +
 .../lang/aql/rewrites/AQLRewriterFactory.java   |   37 +
 .../lang/aql/rewrites/AqlQueryRewriter.java     |  238 +
 .../asterix/lang/aql/rewrites/AqlRewriter.java  |  234 -
 .../lang/aql/rewrites/AqlStatementRewriter.java |   39 +
 .../aql/statement/SubscribeFeedStatement.java   |   16 +-
 .../aql/util/AQLVariableSubstitutionUtil.java   |   14 -
 .../asterix/lang/aql/util/FunctionUtils.java    |   81 -
 .../asterix/lang/aql/util/RangeMapBuilder.java  |    7 +-
 .../lang/aql/visitor/AQLAstPrintVisitor.java    |   87 +
 .../aql/visitor/AQLAstPrintVisitorFactory.java  |   33 +
 .../AQLCloneAndSubstituteVariablesVisitor.java  |    2 +-
 .../lang/aql/visitor/AQLInlineUdfsVisitor.java  |   16 +-
 .../lang/aql/visitor/AQLPrintVisitor.java       |   87 -
 .../aql/visitor/AqlDeleteRewriteVisitor.java    |   73 +
 .../aql/visitor/base/AbstractAqlAstVisitor.java |   50 +
 asterix-lang-aql/src/main/javacc/AQL.jj         |    4 +-
 .../common/base/IAstPrintVisitorFactory.java    |   29 +
 .../lang/common/base/IParserFactory.java        |    6 +-
 .../lang/common/base/IQueryRewriter.java        |   45 +
 .../lang/common/base/IRewriterFactory.java      |   27 +
 .../lang/common/base/IStatementRewriter.java    |   31 +
 .../asterix/lang/common/context/Scope.java      |   32 +-
 .../common/rewrites/LangRewritingContext.java   |    4 +
 .../lang/common/statement/DeleteStatement.java  |    9 +
 .../asterix/lang/common/util/FunctionUtil.java  |   39 +
 .../util/VariableCloneAndSubstitutionUtil.java  |   73 +
 .../utils/VariableCloneAndSubstitutionUtil.java |   73 -
 .../visitor/AbstractInlineUdfsVisitor.java      |   36 +-
 .../CloneAndSubstituteVariablesVisitor.java     |    2 +-
 .../common/visitor/base/AbstractAstVisitor.java |  133 +
 .../asterix/lang/sqlpp/clause/FromTerm.java     |    4 +-
 .../lang/sqlpp/clause/SelectSetOperation.java   |    3 +-
 .../lang/sqlpp/expression/SelectExpression.java |    4 +
 .../lang/sqlpp/parser/FunctionParser.java       |   73 +
 .../lang/sqlpp/parser/SqlppParserFactory.java   |   37 +
 .../rewrites/SqlppFunctionBodyRewriter.java     |   47 +
 .../SqlppFunctionBodyRewriterFactory.java       |   37 +
 .../lang/sqlpp/rewrites/SqlppQueryRewriter.java |  328 +
 .../lang/sqlpp/rewrites/SqlppRewriter.java      |  318 -
 .../sqlpp/rewrites/SqlppRewriterFactory.java    |   37 +
 .../sqlpp/rewrites/SqlppStatementRewriter.java  |   39 +
 .../lang/sqlpp/struct/SetOperationRight.java    |    2 +-
 .../asterix/lang/sqlpp/util/FunctionUtils.java  |   87 -
 .../lang/sqlpp/util/SqlppAstPrintUtil.java      |   18 +-
 .../lang/sqlpp/util/SqlppFormatPrintUtil.java   |    4 +-
 .../util/SqlppVariableSubstitutionUtil.java     |   76 +-
 .../sqlpp/visitor/InlineColumnAliasVisitor.java |    8 +-
 .../sqlpp/visitor/SqlppAstPrintVisitor.java     |  240 +
 .../visitor/SqlppAstPrintVisitorFactory.java    |   33 +
 ...SqlppCloneAndSubstituteVariablesVisitor.java |    2 +-
 .../visitor/SqlppDeleteRewriteVisitor.java      |   95 +
 .../sqlpp/visitor/SqlppFormatPrintVisitor.java  |    2 +-
 .../sqlpp/visitor/SqlppInlineUdfsVisitor.java   |   34 +-
 .../lang/sqlpp/visitor/SqlppPrintVisitor.java   |  238 -
 .../SqlppSubstituteVariablesVisitor.java        |    4 +-
 .../visitor/VariableCheckAndRewriteVisitor.java |   29 +-
 .../visitor/base/AbstractSqlppAstVisitor.java   |  107 +
 asterix-lang-sqlpp/src/main/javacc/SQLPP.jj     |   24 +-
 .../asterix/tools/datagen/AdmDataGen.java       |   51 +-
 .../tools/translator/ADGenDmlTranslator.java    |    4 +-
 1380 files changed, 23406 insertions(+), 11981 deletions(-)
----------------------------------------------------------------------


http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/caea8f0e/asterix-algebra/src/main/java/org/apache/asterix/algebra/base/ILangExpressionToPlanTranslator.java
----------------------------------------------------------------------
diff --git a/asterix-algebra/src/main/java/org/apache/asterix/algebra/base/ILangExpressionToPlanTranslator.java b/asterix-algebra/src/main/java/org/apache/asterix/algebra/base/ILangExpressionToPlanTranslator.java
new file mode 100644
index 0000000..ca6710f
--- /dev/null
+++ b/asterix-algebra/src/main/java/org/apache/asterix/algebra/base/ILangExpressionToPlanTranslator.java
@@ -0,0 +1,62 @@
+/*
+ * Licensed to the Apache Software Foundation (ASF) under one
+ * or more contributor license agreements.  See the NOTICE file
+ * distributed with this work for additional information
+ * regarding copyright ownership.  The ASF licenses this file
+ * to you under the Apache License, Version 2.0 (the
+ * "License"); you may not use this file except in compliance
+ * with the License.  You may obtain a copy of the License at
+ *
+ *   http://www.apache.org/licenses/LICENSE-2.0
+ *
+ * Unless required by applicable law or agreed to in writing,
+ * software distributed under the License is distributed on an
+ * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+ * KIND, either express or implied.  See the License for the
+ * specific language governing permissions and limitations
+ * under the License.
+ */
+package org.apache.asterix.algebra.base;
+
+import org.apache.asterix.common.exceptions.AsterixException;
+import org.apache.asterix.lang.common.statement.Query;
+import org.apache.asterix.translator.CompiledStatements.ICompiledDmlStatement;
+import org.apache.hyracks.algebricks.common.exceptions.AlgebricksException;
+import org.apache.hyracks.algebricks.core.algebra.base.ILogicalPlan;
+
+/**
+ * The interface is in charge of translating language expressions into logical query plans.
+ */
+public interface ILangExpressionToPlanTranslator {
+
+    /**
+     * Translate a query.
+     *
+     * @param query,
+     *            the AST of a query.
+     * @param outputDatasetName,
+     *            the output dataset name (only for insert/delete).
+     * @param stmt,
+     *            the compiled dml statement (only for insert/delete).
+     * @return a logical query plan for the query.
+     * @throws AlgebricksException
+     * @throws AsterixException
+     */
+    public ILogicalPlan translate(Query query, String outputDatasetName, ICompiledDmlStatement stmt)
+            throws AlgebricksException, AsterixException;
+
+    /**
+     * Translates a load statement.
+     *
+     * @param stmt,
+     *            the compiled load statement.
+     * @return a logical query plan for the load statement.
+     * @throws AlgebricksException
+     */
+    public ILogicalPlan translateLoad(ICompiledDmlStatement stmt) throws AlgebricksException;
+
+    /**
+     * @return the current minimum available variable id.
+     */
+    public int getVarCounter();
+}

http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/caea8f0e/asterix-algebra/src/main/java/org/apache/asterix/algebra/base/ILangExpressionToPlanTranslatorFactory.java
----------------------------------------------------------------------
diff --git a/asterix-algebra/src/main/java/org/apache/asterix/algebra/base/ILangExpressionToPlanTranslatorFactory.java b/asterix-algebra/src/main/java/org/apache/asterix/algebra/base/ILangExpressionToPlanTranslatorFactory.java
new file mode 100644
index 0000000..1c241e7
--- /dev/null
+++ b/asterix-algebra/src/main/java/org/apache/asterix/algebra/base/ILangExpressionToPlanTranslatorFactory.java
@@ -0,0 +1,37 @@
+/*
+ * Licensed to the Apache Software Foundation (ASF) under one
+ * or more contributor license agreements.  See the NOTICE file
+ * distributed with this work for additional information
+ * regarding copyright ownership.  The ASF licenses this file
+ * to you under the Apache License, Version 2.0 (the
+ * "License"); you may not use this file except in compliance
+ * with the License.  You may obtain a copy of the License at
+ *
+ *   http://www.apache.org/licenses/LICENSE-2.0
+ *
+ * Unless required by applicable law or agreed to in writing,
+ * software distributed under the License is distributed on an
+ * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+ * KIND, either express or implied.  See the License for the
+ * specific language governing permissions and limitations
+ * under the License.
+ */
+package org.apache.asterix.algebra.base;
+
+import org.apache.asterix.metadata.declared.AqlMetadataProvider;
+import org.apache.hyracks.algebricks.common.exceptions.AlgebricksException;
+
+public interface ILangExpressionToPlanTranslatorFactory {
+
+    /**
+     * @param metadataProvider,
+     *            providing the definition of created (i.e., stored) user-defined functions.
+     * @param currentVarCounter,
+     *            the current minimum available variable id.
+     * @return a logical query plan.
+     * @throws AlgebricksException
+     */
+    ILangExpressionToPlanTranslator createExpressionToPlanTranslator(AqlMetadataProvider metadataProvider,
+            int currentVarCountert) throws AlgebricksException;
+
+}

http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/caea8f0e/asterix-algebra/src/main/java/org/apache/asterix/algebra/base/LogicalOperatorDeepCopyVisitor.java
----------------------------------------------------------------------
diff --git a/asterix-algebra/src/main/java/org/apache/asterix/algebra/base/LogicalOperatorDeepCopyVisitor.java b/asterix-algebra/src/main/java/org/apache/asterix/algebra/base/LogicalOperatorDeepCopyVisitor.java
index 7d63ecc..7992936 100644
--- a/asterix-algebra/src/main/java/org/apache/asterix/algebra/base/LogicalOperatorDeepCopyVisitor.java
+++ b/asterix-algebra/src/main/java/org/apache/asterix/algebra/base/LogicalOperatorDeepCopyVisitor.java
@@ -53,6 +53,7 @@ import org.apache.hyracks.algebricks.core.algebra.operators.logical.MaterializeO
 import org.apache.hyracks.algebricks.core.algebra.operators.logical.NestedTupleSourceOperator;
 import org.apache.hyracks.algebricks.core.algebra.operators.logical.OrderOperator;
 import org.apache.hyracks.algebricks.core.algebra.operators.logical.OrderOperator.IOrder;
+import org.apache.hyracks.algebricks.core.algebra.operators.logical.OuterUnnestOperator;
 import org.apache.hyracks.algebricks.core.algebra.operators.logical.PartitioningSplitOperator;
 import org.apache.hyracks.algebricks.core.algebra.operators.logical.ProjectOperator;
 import org.apache.hyracks.algebricks.core.algebra.operators.logical.ReplicateOperator;
@@ -474,4 +475,16 @@ public class LogicalOperatorDeepCopyVisitor implements ILogicalOperatorVisitor<I
         throw new UnsupportedOperationException();
     }
 
+    @Override
+    public ILogicalOperator visitOuterUnnestOperator(OuterUnnestOperator op, ILogicalOperator arg)
+            throws AlgebricksException {
+        OuterUnnestOperator opCopy = new OuterUnnestOperator(deepCopyVariable(op.getVariable()),
+                exprDeepCopyVisitor.deepCopyExpressionReference(op.getExpressionRef()),
+                deepCopyVariable(op.getPositionalVariable()), op.getPositionalVariableType(), op.getPositionWriter());
+        deepCopyInputs(op, opCopy, arg);
+        copyAnnotations(op, opCopy);
+        opCopy.setExecutionMode(op.getExecutionMode());
+        return opCopy;
+    }
+
 }



Mime
View raw message