You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@asterixdb.apache.org by im...@apache.org on 2016/04/07 16:59:55 UTC

[20/50] [abbrv] incubator-asterixdb git commit: Merge branch 'master' into hyracks-merge2

http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/8516517e/asterixdb/asterix-app/src/test/resources/runtimets/testsuite.xml
----------------------------------------------------------------------
diff --cc asterixdb/asterix-app/src/test/resources/runtimets/testsuite.xml
index 3a5140c,0000000..43c754b
mode 100644,000000..100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/testsuite.xml
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/testsuite.xml
@@@ -1,7028 -1,0 +1,7053 @@@
 +<!--
 + ! 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.
 + !-->
 +<!DOCTYPE test-suite [
 +
 +<!ENTITY ComparisonQueries SYSTEM "queries/comparison/ComparisonQueries.xml">
 +<!ENTITY RecordsQueries SYSTEM "queries/records/RecordsQueries.xml">
 +<!ENTITY DeepEqualQueries SYSTEM "queries/comparison/deep_equal/DeepEqualQueries.xml">
 +]>
 +
 +<test-suite
 +        xmlns="urn:xml.testframework.asterix.apache.org"
 +        ResultOffsetPath="results"
 +        QueryOffsetPath="queries"
 +        QueryFileExtension=".aql">
++    <test-group name="external">
++        <test-case FilePath="external">
++            <compilation-unit name="invalid-format">
++                <output-dir compare="Text">invalid-format</output-dir>
++                <expected-error>Unknown format</expected-error>
++            </compilation-unit>
++        </test-case>
++    </test-group>
++    <test-group name="external-indexing">
++        <test-case FilePath="external-indexing">
++            <compilation-unit name="text-format">
++                <output-dir compare="Text">text-format</output-dir>
++            </compilation-unit>
++        </test-case>
++        <test-case FilePath="external-indexing">
++            <compilation-unit name="sequence-format">
++                <output-dir compare="Text">sequence-format</output-dir>
++            </compilation-unit>
++        </test-case>
++        <test-case FilePath="external-indexing">
++            <compilation-unit name="rc-format">
++                <output-dir compare="Text">rc-format</output-dir>
++            </compilation-unit>
++        </test-case>
++        <test-case FilePath="external-indexing">
++            <compilation-unit name="rtree-index">
++                <output-dir compare="Text">rtree-index</output-dir>
++            </compilation-unit>
++        </test-case>
++        <test-case FilePath="external-indexing">
++            <compilation-unit name="leftouterjoin">
++                <output-dir compare="Text">leftouterjoin</output-dir>
++            </compilation-unit>
++        </test-case>
++        <test-case FilePath="external-indexing">
++            <compilation-unit name="leftouterjoin-rtree">
++                <output-dir compare="Text">leftouterjoin-rtree</output-dir>
++            </compilation-unit>
++        </test-case>
++    </test-group>
 +    <test-group name="external-library">
 +        <test-case FilePath="external-library">
 +            <compilation-unit name="typed_adapter">
 +                <output-dir compare="Text">typed_adapter</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="external-library">
-             <compilation-unit name="classad-parser">
-                 <output-dir compare="Text">classad-parser</output-dir>
++            <compilation-unit name="classad-parser-new">
++                <output-dir compare="Text">classad-parser-new</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="external-library">
-             <compilation-unit name="classad-parser2">
-                 <output-dir compare="Text">classad-parser2</output-dir>
++            <compilation-unit name="classad-parser-old">
++                <output-dir compare="Text">classad-parser-old</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="external-library">
 +            <compilation-unit name="getCapital">
 +                <output-dir compare="Text">getCapital</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +    </test-group>
 +    <test-group name="feeds">
 +        <test-case FilePath="feeds">
++            <compilation-unit name="twitter-feed">
++                <output-dir compare="Text">twitter-feed</output-dir>
++                <expected-error>One or more parameters are missing from adapter configuration</expected-error>
++            </compilation-unit>
++        </test-case>
++        <test-case FilePath="feeds">
 +            <compilation-unit name="feed-with-external-parser">
 +                <output-dir compare="Text">feed-with-external-parser</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="feeds">
 +            <compilation-unit name="feed-with-external-function">
 +                <output-dir compare="Text">feed-with-external-function</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="feeds">
 +            <compilation-unit name="change-feed-with-meta-pk-in-meta">
 +                <output-dir compare="Text">change-feed-with-meta-pk-in-meta</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="feeds">
 +            <compilation-unit name="feed-with-filtered-dataset">
 +                <output-dir compare="Text">feed-with-filtered-dataset</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="feeds">
 +            <compilation-unit name="change-feed">
 +                <output-dir compare="Text">change-feed</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="feeds">
 +            <compilation-unit name="feed-with-meta-pk-in-meta">
 +                <output-dir compare="Text">feed-with-meta-pk-in-meta</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="feeds">
 +            <compilation-unit name="feeds_07">
 +                <output-dir compare="Text">feeds_07</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <!-- Fails constantly and not clear what is intended
 +        <test-case FilePath="feeds">
 +          <compilation-unit name="feeds_06">
 +            <output-dir compare="Text">feeds_06</output-dir>
 +          </compilation-unit>
 +        </test-case> -->
 +        <test-case FilePath="feeds">
 +            <compilation-unit name="drop-dataverse-with-disconnected-feed">
 +                <output-dir compare="Text">drop-dataverse-with-disconnected-feed</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="feeds">
 +            <compilation-unit name="feed-push-socket">
 +                <output-dir compare="Text">feed-push-socket</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="feeds">
 +            <compilation-unit name="feeds_01">
 +                <output-dir compare="Text">feeds_01</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="feeds">
 +            <compilation-unit name="feeds_02">
 +                <output-dir compare="Text">feeds_02</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="feeds">
 +            <compilation-unit name="feeds_03">
 +                <output-dir compare="Text">feeds_03</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <!-- Fails constantly
 +        <test-case FilePath="feeds">
 +            <compilation-unit name="feeds_04">
 +                <output-dir compare="Text">feeds_04</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +         -->
 +        <test-case FilePath="feeds">
 +            <compilation-unit name="feeds_08">
 +                <output-dir compare="Text">feeds_08</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="feeds">
 +            <compilation-unit name="feeds_09">
 +                <output-dir compare="Text">feeds_09</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +
 +        <test-case FilePath="feeds">
 +            <compilation-unit name="feeds_10">
 +                <output-dir compare="Text">feeds_10</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +
 +        <test-case FilePath="feeds">
 +            <compilation-unit name="feeds_11">
 +                <output-dir compare="Text">feeds_11</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="feeds">
 +            <compilation-unit name="feeds_12">
 +                <output-dir compare="Text">feeds_12</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +
 +        <test-case FilePath="feeds">
 +            <compilation-unit name="issue_230_feeds">
 +                <output-dir compare="Text">issue_230_feeds</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <!--<test-case FilePath="feeds">
 +            <compilation-unit name="issue_711_feeds">
 +                <output-dir compare="Text">issue_711_feeds</output-dir>
 +            </compilation-unit>
 +        </test-case>-->
 +    </test-group>
 +    <test-group name="upsert">
 +        <test-case FilePath="upsert">
 +            <compilation-unit name="filtered-dataset">
 +                <output-dir compare="Text">filtered-dataset</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="upsert">
 +            <compilation-unit name="nested-index">
 +                <output-dir compare="Text">nested-index</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="upsert">
 +            <compilation-unit name="primary-secondary-rtree">
 +                <output-dir compare="Text">primary-secondary-rtree</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="upsert">
 +            <compilation-unit name="upsert-with-self-read">
 +                <output-dir compare="Text">upsert-with-self-read</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="upsert">
 +            <compilation-unit name="nullable-index">
 +                <output-dir compare="Text">nullable-index</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="upsert">
 +            <compilation-unit name="open-index">
 +                <output-dir compare="Text">open-index</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="upsert">
 +            <compilation-unit name="primary-index">
 +                <output-dir compare="Text">primary-index</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="upsert">
 +            <compilation-unit name="primary-secondary-btree">
 +                <output-dir compare="Text">primary-secondary-btree</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="upsert">
 +            <compilation-unit name="primary-secondary-inverted">
 +                <output-dir compare="Text">primary-secondary-inverted</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="upsert">
 +            <compilation-unit name="multiple-secondaries">
 +                <output-dir compare="Text">multiple-secondaries</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +    </test-group>
 +    <test-group name="flwor">
 +        <test-case FilePath="flwor">
 +            <compilation-unit name="at00">
 +                <output-dir compare="Text">at00</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="flwor">
 +            <compilation-unit name="at01">
 +                <output-dir compare="Text">at01</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="flwor">
 +            <compilation-unit name="at02">
 +                <output-dir compare="Text">at02</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="flwor">
 +            <compilation-unit name="at03">
 +                <output-dir compare="Text">at03</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="flwor">
 +            <compilation-unit name="at04">
 +                <output-dir compare="Text">at04</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="flwor">
 +            <compilation-unit name="at05">
 +                <output-dir compare="Text">at05</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="flwor">
 +            <compilation-unit name="at06">
 +                <output-dir compare="Text">at06</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="flwor">
 +            <compilation-unit name="query-issue550">
 +                <output-dir compare="Text">query-issue550</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +    </test-group>
 +    <test-group name="union">
 +        <test-case FilePath="union">
 +            <compilation-unit name="union">
 +                <output-dir compare="Text">union</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="union">
 +            <compilation-unit name="union2">
 +                <output-dir compare="Text">union2</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="union">
 +            <compilation-unit name="query-ASTERIXDB-300">
 +                <output-dir compare="Text">query-ASTERIXDB-300</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="union">
 +            <compilation-unit name="query-ASTERIXDB-1205">
 +                <output-dir compare="Text">query-ASTERIXDB-1205</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="union">
 +            <compilation-unit name="query-ASTERIXDB-1205-2">
 +                <output-dir compare="Text">query-ASTERIXDB-1205-2</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="union">
 +            <compilation-unit name="query-ASTERIXDB-1205-3">
 +                <output-dir compare="Text">query-ASTERIXDB-1205-3</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="union">
 +            <compilation-unit name="query-ASTERIXDB-1047">
 +                <output-dir compare="Text">query-ASTERIXDB-1047</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +    </test-group>
 +    <test-group name="aggregate">
 +        <test-case FilePath="aggregate">
 +            <compilation-unit name="issue531_string_min_max">
 +                <output-dir compare="Text">issue531_string_min_max</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="aggregate">
 +            <compilation-unit name="agg_null">
 +                <output-dir compare="Text">agg_null</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="aggregate">
 +            <compilation-unit name="agg_null_rec">
 +                <output-dir compare="Text">agg_null_rec</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="aggregate">
 +            <compilation-unit name="agg_null_rec_1">
 +                <output-dir compare="Text">agg_null_rec_1</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="aggregate">
 +            <compilation-unit name="agg_number_rec">
 +                <output-dir compare="Text">agg_number_rec</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="aggregate">
 +            <compilation-unit name="avg_mixed">
 +                <output-dir compare="Text">avg_mixed</output-dir>
 +                <expected-error>org.apache.hyracks.algebricks.common.exceptions.AlgebricksException: Unexpected type STRING</expected-error>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="aggregate">
 +            <compilation-unit name="sum_mixed">
 +                <output-dir compare="Text">sum_mixed</output-dir>
 +                <expected-error>org.apache.hyracks.algebricks.common.exceptions.AlgebricksException: Unexpected type STRING</expected-error>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="aggregate">
 +            <compilation-unit name="min_mixed">
 +                <output-dir compare="Text">min_mixed</output-dir>
 +                <expected-error>org.apache.hyracks.algebricks.common.exceptions.AlgebricksException: Unexpected type STRING</expected-error>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="aggregate">
 +            <compilation-unit name="agg_number">
 +                <output-dir compare="Text">agg_number</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="aggregate">
 +            <compilation-unit name="issue425_min_hetero_list_1">
 +                <output-dir compare="Text">issue425_min_hetero_list_1</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="aggregate">
 +            <compilation-unit name="issue425_min_hetero_list">
 +                <output-dir compare="Text">issue425_min_hetero_list</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="aggregate">
 +            <compilation-unit name="issue425_sum_hetero_list_1">
 +                <output-dir compare="Text">issue425_sum_hetero_list_1</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="aggregate">
 +            <compilation-unit name="issue425_sum_hetero_list">
 +                <output-dir compare="Text">issue425_sum_hetero_list</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="aggregate">
 +            <compilation-unit name="query-issue400">
 +                <output-dir compare="Text">query-issue400</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="aggregate">
 +            <compilation-unit name="issue395">
 +                <output-dir compare="Text">issue395</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="aggregate">
 +            <compilation-unit name="issue412_0">
 +                <output-dir compare="Text">issue412_0</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="aggregate">
 +            <compilation-unit name="issue412_1">
 +                <output-dir compare="Text">issue412_1</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="aggregate">
 +            <compilation-unit name="avg_double">
 +                <output-dir compare="Text">avg_double</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="aggregate">
 +            <compilation-unit name="avg_double_null">
 +                <output-dir compare="Text">avg_double_null</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="aggregate">
 +            <compilation-unit name="avg_empty_01">
 +                <output-dir compare="Text">avg_empty_01</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="aggregate">
 +            <compilation-unit name="avg_empty_02">
 +                <output-dir compare="Text">avg_empty_02</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="aggregate">
 +            <compilation-unit name="avg_float">
 +                <output-dir compare="Text">avg_float</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="aggregate">
 +            <compilation-unit name="avg_float_null">
 +                <output-dir compare="Text">avg_float_null</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="aggregate">
 +            <compilation-unit name="avg_int16">
 +                <output-dir compare="Text">avg_int16</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="aggregate">
 +            <compilation-unit name="avg_int16_null">
 +                <output-dir compare="Text">avg_int16_null</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="aggregate">
 +            <compilation-unit name="avg_int32">
 +                <output-dir compare="Text">avg_int32</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="aggregate">
 +            <compilation-unit name="avg_int32_null">
 +                <output-dir compare="Text">avg_int32_null</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="aggregate">
 +            <compilation-unit name="avg_int64">
 +                <output-dir compare="Text">avg_int64</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="aggregate">
 +            <compilation-unit name="avg_int64_null">
 +                <output-dir compare="Text">avg_int64_null</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="aggregate">
 +            <compilation-unit name="avg_int8">
 +                <output-dir compare="Text">avg_int8</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="aggregate">
 +            <compilation-unit name="avg_int8_null">
 +                <output-dir compare="Text">avg_int8_null</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="aggregate">
 +            <compilation-unit name="count_01">
 +                <output-dir compare="Text">count_01</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="aggregate">
 +            <compilation-unit name="count_empty_01">
 +                <output-dir compare="Text">count_empty_01</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="aggregate">
 +            <compilation-unit name="count_empty_02">
 +                <output-dir compare="Text">count_empty_02</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="aggregate">
 +            <compilation-unit name="count_null">
 +                <output-dir compare="Text">count_null</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +         <test-case FilePath="aggregate">
 +            <compilation-unit name="query-ASTERIXDB-923">
 +                <output-dir compare="Text">query-ASTERIXDB-923</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="aggregate">
 +            <compilation-unit name="group_only">
 +                <output-dir compare="Text">group_only</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <!--
 +        <test-case FilePath="aggregate">
 +          <compilation-unit name="droptype">
 +            <output-dir compare="Text">droptype</output-dir>
 +          </compilation-unit>
 +        </test-case>
 +        -->
 +        <!-- TODO(madhusudancs): These tests that test for local_<agg>/global_<agg> functions should be removed, but
 +        before that we should modify the code to make sure those built-in functions are still defined but not exposed
 +        by AQL, so leaving these test cases commented.
 +        <test-case FilePath="aggregate">
 +          <compilation-unit name="global-avg_01">
 +            <output-dir compare="Text">global-avg_01</output-dir>
 +          </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="aggregate">
 +          <compilation-unit name="global-avg_null">
 +            <output-dir compare="Text">global-avg_null</output-dir>
 +          </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="aggregate">
 +          <compilation-unit name="local-avg_double">
 +            <output-dir compare="Text">local-avg_double</output-dir>
 +          </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="aggregate">
 +          <compilation-unit name="local-avg_double_null">
 +            <output-dir compare="Text">local-avg_double_null</output-dir>
 +          </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="aggregate">
 +          <compilation-unit name="local-avg_float">
 +            <output-dir compare="Text">local-avg_float</output-dir>
 +          </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="aggregate">
 +          <compilation-unit name="local-avg_float_null">
 +            <output-dir compare="Text">local-avg_float_null</output-dir>
 +          </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="aggregate">
 +          <compilation-unit name="local-avg_int16">
 +            <output-dir compare="Text">local-avg_int16</output-dir>
 +          </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="aggregate">
 +          <compilation-unit name="local-avg_int16_null">
 +            <output-dir compare="Text">local-avg_int16_null</output-dir>
 +          </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="aggregate">
 +          <compilation-unit name="local-avg_int32">
 +            <output-dir compare="Text">local-avg_int32</output-dir>
 +          </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="aggregate">
 +          <compilation-unit name="local-avg_int32_null">
 +            <output-dir compare="Text">local-avg_int32_null</output-dir>
 +          </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="aggregate">
 +          <compilation-unit name="local-avg_int64">
 +            <output-dir compare="Text">local-avg_int64</output-dir>
 +          </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="aggregate">
 +          <compilation-unit name="local-avg_int64_null">
 +            <output-dir compare="Text">local-avg_int64_null</output-dir>
 +          </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="aggregate">
 +          <compilation-unit name="local-avg_int8">
 +            <output-dir compare="Text">local-avg_int8</output-dir>
 +          </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="aggregate">
 +          <compilation-unit name="local-avg_int8_null">
 +            <output-dir compare="Text">local-avg_int8_null</output-dir>
 +          </compilation-unit>
 +        </test-case>
 +        -->
 +        <test-case FilePath="aggregate">
 +            <compilation-unit name="max_empty_01">
 +                <output-dir compare="Text">max_empty_01</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="aggregate">
 +            <compilation-unit name="max_empty_02">
 +                <output-dir compare="Text">max_empty_02</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="aggregate">
 +            <compilation-unit name="min_empty_01">
 +                <output-dir compare="Text">min_empty_01</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="aggregate">
 +            <compilation-unit name="min_empty_02">
 +                <output-dir compare="Text">min_empty_02</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="aggregate">
 +            <compilation-unit name="scalar_avg">
 +                <output-dir compare="Text">scalar_avg</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="aggregate">
 +            <compilation-unit name="scalar_avg_empty">
 +                <output-dir compare="Text">scalar_avg_empty</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="aggregate">
 +            <compilation-unit name="scalar_avg_null">
 +                <output-dir compare="Text">scalar_avg_null</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="aggregate">
 +            <compilation-unit name="scalar_count">
 +                <output-dir compare="Text">scalar_count</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="aggregate">
 +            <compilation-unit name="scalar_count_empty">
 +                <output-dir compare="Text">scalar_count_empty</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="aggregate">
 +            <compilation-unit name="scalar_count_null">
 +                <output-dir compare="Text">scalar_count_null</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="aggregate">
 +            <compilation-unit name="scalar_max">
 +                <output-dir compare="Text">scalar_max</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="aggregate">
 +            <compilation-unit name="scalar_max_empty">
 +                <output-dir compare="Text">scalar_max_empty</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="aggregate">
 +            <compilation-unit name="scalar_max_null">
 +                <output-dir compare="Text">scalar_max_null</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="aggregate">
 +            <compilation-unit name="scalar_min">
 +                <output-dir compare="Text">scalar_min</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="aggregate">
 +            <compilation-unit name="scalar_min_empty">
 +                <output-dir compare="Text">scalar_min_empty</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="aggregate">
 +            <compilation-unit name="scalar_min_null">
 +                <output-dir compare="Text">scalar_min_null</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="aggregate">
 +            <compilation-unit name="scalar_sum">
 +                <output-dir compare="Text">scalar_sum</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="aggregate">
 +            <compilation-unit name="scalar_sum_empty">
 +                <output-dir compare="Text">scalar_sum_empty</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="aggregate">
 +            <compilation-unit name="scalar_sum_null">
 +                <output-dir compare="Text">scalar_sum_null</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="aggregate">
 +            <compilation-unit name="sum_double">
 +                <output-dir compare="Text">sum_double</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="aggregate">
 +            <compilation-unit name="sum_double_null">
 +                <output-dir compare="Text">sum_double_null</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="aggregate">
 +            <compilation-unit name="sum_empty_01">
 +                <output-dir compare="Text">sum_empty_01</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="aggregate">
 +            <compilation-unit name="sum_empty_02">
 +                <output-dir compare="Text">sum_empty_02</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="aggregate">
 +            <compilation-unit name="sum_float">
 +                <output-dir compare="Text">sum_float</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="aggregate">
 +            <compilation-unit name="sum_float_null">
 +                <output-dir compare="Text">sum_float_null</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="aggregate">
 +            <compilation-unit name="sum_int16">
 +                <output-dir compare="Text">sum_int16</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="aggregate">
 +            <compilation-unit name="sum_int16_null">
 +                <output-dir compare="Text">sum_int16_null</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="aggregate">
 +            <compilation-unit name="sum_int32">
 +                <output-dir compare="Text">sum_int32</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="aggregate">
 +            <compilation-unit name="sum_int32_null">
 +                <output-dir compare="Text">sum_int32_null</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="aggregate">
 +            <compilation-unit name="sum_int64">
 +                <output-dir compare="Text">sum_int64</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="aggregate">
 +            <compilation-unit name="sum_int64_null">
 +                <output-dir compare="Text">sum_int64_null</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="aggregate">
 +            <compilation-unit name="sum_int8">
 +                <output-dir compare="Text">sum_int8</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="aggregate">
 +            <compilation-unit name="sum_int8_null">
 +                <output-dir compare="Text">sum_int8_null</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="aggregate">
 +            <compilation-unit name="sum_null-with-pred">
 +                <output-dir compare="Text">sum_null-with-pred</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="aggregate">
 +            <compilation-unit name="sum_numeric_null">
 +                <output-dir compare="Text">sum_numeric_null</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +    </test-group>
 +    <test-group name="aggregate-sql">
 +        <test-case FilePath="aggregate-sql">
 +            <compilation-unit name="issue531_string_min_max">
 +                <output-dir compare="Text">issue531_string_min_max</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="aggregate-sql">
 +            <compilation-unit name="agg_null">
 +                <output-dir compare="Text">agg_null</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="aggregate-sql">
 +            <compilation-unit name="agg_null_rec">
 +                <output-dir compare="Text">agg_null_rec</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="aggregate-sql">
 +            <compilation-unit name="agg_null_rec_1">
 +                <output-dir compare="Text">agg_null_rec_1</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="aggregate-sql">
 +            <compilation-unit name="agg_number_rec">
 +                <output-dir compare="Text">agg_number_rec</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="aggregate-sql">
 +            <compilation-unit name="avg_mixed">
 +                <output-dir compare="Text">avg_mixed</output-dir>
 +                <expected-error>org.apache.hyracks.algebricks.common.exceptions.AlgebricksException: Unexpected type STRING</expected-error>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="aggregate-sql">
 +            <compilation-unit name="sum_mixed">
 +                <output-dir compare="Text">sum_mixed</output-dir>
 +                <expected-error>org.apache.hyracks.algebricks.common.exceptions.AlgebricksException: Unexpected type STRING</expected-error>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="aggregate-sql">
 +            <compilation-unit name="min_mixed">
 +                <output-dir compare="Text">min_mixed</output-dir>
 +                <expected-error>org.apache.hyracks.algebricks.common.exceptions.AlgebricksException: Unexpected type STRING</expected-error>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="aggregate-sql">
 +            <compilation-unit name="agg_number">
 +                <output-dir compare="Text">agg_number</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="aggregate-sql">
 +            <compilation-unit name="issue425_min_hetero_list_1">
 +                <output-dir compare="Text">issue425_min_hetero_list_1</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="aggregate-sql">
 +            <compilation-unit name="issue425_min_hetero_list">
 +                <output-dir compare="Text">issue425_min_hetero_list</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="aggregate-sql">
 +            <compilation-unit name="issue425_sum_hetero_list_1">
 +                <output-dir compare="Text">issue425_sum_hetero_list_1</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="aggregate-sql">
 +            <compilation-unit name="issue425_sum_hetero_list">
 +                <output-dir compare="Text">issue425_sum_hetero_list</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="aggregate-sql">
 +            <compilation-unit name="query-issue400">
 +                <output-dir compare="Text">query-issue400</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="aggregate-sql">
 +            <compilation-unit name="issue395">
 +                <output-dir compare="Text">issue395</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="aggregate-sql">
 +            <compilation-unit name="issue412_0">
 +                <output-dir compare="Text">issue412_0</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="aggregate-sql">
 +            <compilation-unit name="issue412_1">
 +                <output-dir compare="Text">issue412_1</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="aggregate-sql">
 +            <compilation-unit name="avg_double">
 +                <output-dir compare="Text">avg_double</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="aggregate-sql">
 +            <compilation-unit name="avg_double_null">
 +                <output-dir compare="Text">avg_double_null</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="aggregate-sql">
 +            <compilation-unit name="avg_empty_01">
 +                <output-dir compare="Text">avg_empty_01</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="aggregate-sql">
 +            <compilation-unit name="avg_empty_02">
 +                <output-dir compare="Text">avg_empty_02</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="aggregate-sql">
 +            <compilation-unit name="avg_float">
 +                <output-dir compare="Text">avg_float</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="aggregate-sql">
 +            <compilation-unit name="avg_float_null">
 +                <output-dir compare="Text">avg_float_null</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="aggregate-sql">
 +            <compilation-unit name="avg_int16">
 +                <output-dir compare="Text">avg_int16</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="aggregate-sql">
 +            <compilation-unit name="avg_int16_null">
 +                <output-dir compare="Text">avg_int16_null</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="aggregate-sql">
 +            <compilation-unit name="avg_int32">
 +                <output-dir compare="Text">avg_int32</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="aggregate-sql">
 +            <compilation-unit name="avg_int32_null">
 +                <output-dir compare="Text">avg_int32_null</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="aggregate-sql">
 +            <compilation-unit name="avg_int64">
 +                <output-dir compare="Text">avg_int64</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="aggregate-sql">
 +            <compilation-unit name="avg_int64_null">
 +                <output-dir compare="Text">avg_int64_null</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="aggregate-sql">
 +            <compilation-unit name="avg_int8">
 +                <output-dir compare="Text">avg_int8</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="aggregate-sql">
 +            <compilation-unit name="avg_int8_null">
 +                <output-dir compare="Text">avg_int8_null</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="aggregate-sql">
 +            <compilation-unit name="count_01">
 +                <output-dir compare="Text">count_01</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="aggregate-sql">
 +            <compilation-unit name="count_empty_01">
 +                <output-dir compare="Text">count_empty_01</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="aggregate-sql">
 +            <compilation-unit name="count_empty_02">
 +                <output-dir compare="Text">count_empty_02</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="aggregate-sql">
 +            <compilation-unit name="count_null">
 +                <output-dir compare="Text">count_null</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="aggregate-sql">
 +            <compilation-unit name="max_empty_01">
 +                <output-dir compare="Text">max_empty_01</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="aggregate-sql">
 +            <compilation-unit name="max_empty_02">
 +                <output-dir compare="Text">max_empty_02</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="aggregate-sql">
 +            <compilation-unit name="min_empty_01">
 +                <output-dir compare="Text">min_empty_01</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="aggregate-sql">
 +            <compilation-unit name="min_empty_02">
 +                <output-dir compare="Text">min_empty_02</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="aggregate-sql">
 +            <compilation-unit name="scalar_avg">
 +                <output-dir compare="Text">scalar_avg</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="aggregate-sql">
 +            <compilation-unit name="scalar_avg_empty">
 +                <output-dir compare="Text">scalar_avg_empty</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="aggregate-sql">
 +            <compilation-unit name="scalar_avg_null">
 +                <output-dir compare="Text">scalar_avg_null</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="aggregate-sql">
 +            <compilation-unit name="scalar_count">
 +                <output-dir compare="Text">scalar_count</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="aggregate-sql">
 +            <compilation-unit name="scalar_count_empty">
 +                <output-dir compare="Text">scalar_count_empty</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="aggregate-sql">
 +            <compilation-unit name="scalar_count_null">
 +                <output-dir compare="Text">scalar_count_null</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="aggregate-sql">
 +            <compilation-unit name="scalar_max">
 +                <output-dir compare="Text">scalar_max</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="aggregate-sql">
 +            <compilation-unit name="scalar_max_empty">
 +                <output-dir compare="Text">scalar_max_empty</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="aggregate-sql">
 +            <compilation-unit name="scalar_max_null">
 +                <output-dir compare="Text">scalar_max_null</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="aggregate-sql">
 +            <compilation-unit name="scalar_min">
 +                <output-dir compare="Text">scalar_min</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="aggregate-sql">
 +            <compilation-unit name="scalar_min_empty">
 +                <output-dir compare="Text">scalar_min_empty</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="aggregate-sql">
 +            <compilation-unit name="scalar_min_null">
 +                <output-dir compare="Text">scalar_min_null</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="aggregate-sql">
 +            <compilation-unit name="scalar_sum">
 +                <output-dir compare="Text">scalar_sum</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="aggregate-sql">
 +            <compilation-unit name="scalar_sum_empty">
 +                <output-dir compare="Text">scalar_sum_empty</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="aggregate-sql">
 +            <compilation-unit name="scalar_sum_null">
 +                <output-dir compare="Text">scalar_sum_null</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="aggregate-sql">
 +            <compilation-unit name="sum_double">
 +                <output-dir compare="Text">sum_double</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="aggregate-sql">
 +            <compilation-unit name="sum_double_null">
 +                <output-dir compare="Text">sum_double_null</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="aggregate-sql">
 +            <compilation-unit name="sum_empty_01">
 +                <output-dir compare="Text">sum_empty_01</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="aggregate-sql">
 +            <compilation-unit name="sum_empty_02">
 +                <output-dir compare="Text">sum_empty_02</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="aggregate-sql">
 +            <compilation-unit name="sum_float">
 +                <output-dir compare="Text">sum_float</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="aggregate-sql">
 +            <compilation-unit name="sum_float_null">
 +                <output-dir compare="Text">sum_float_null</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="aggregate-sql">
 +            <compilation-unit name="sum_int16">
 +                <output-dir compare="Text">sum_int16</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="aggregate-sql">
 +            <compilation-unit name="sum_int16_null">
 +                <output-dir compare="Text">sum_int16_null</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="aggregate-sql">
 +            <compilation-unit name="sum_int32">
 +                <output-dir compare="Text">sum_int32</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="aggregate-sql">
 +            <compilation-unit name="sum_int32_null">
 +                <output-dir compare="Text">sum_int32_null</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="aggregate-sql">
 +            <compilation-unit name="sum_int64">
 +                <output-dir compare="Text">sum_int64</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="aggregate-sql">
 +            <compilation-unit name="sum_int64_null">
 +                <output-dir compare="Text">sum_int64_null</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="aggregate-sql">
 +            <compilation-unit name="sum_int8">
 +                <output-dir compare="Text">sum_int8</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="aggregate-sql">
 +            <compilation-unit name="sum_int8_null">
 +                <output-dir compare="Text">sum_int8_null</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="aggregate-sql">
 +            <compilation-unit name="sum_null-with-pred">
 +                <output-dir compare="Text">sum_null-with-pred</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="aggregate-sql">
 +            <compilation-unit name="sum_numeric_null">
 +                <output-dir compare="Text">sum_numeric_null</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +    </test-group>
 +    <test-group name="boolean">
 +        <test-case FilePath="boolean">
 +            <compilation-unit name="and_01">
 +                <output-dir compare="Text">and_01</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="boolean">
 +            <compilation-unit name="and_null">
 +                <output-dir compare="Text">and_null</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="boolean">
 +            <compilation-unit name="and_null_false">
 +                <output-dir compare="Text">and_null_false</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="boolean">
 +            <compilation-unit name="not_01">
 +                <output-dir compare="Text">not_01</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +    </test-group>
 +    <test-group name="comparison">
 +        &ComparisonQueries;
 +    </test-group>
 +    <test-group name="constructor">
 +        <test-case FilePath="constructor">
 +            <compilation-unit name="binary_01">
 +                <output-dir compare="Text">binary_01</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="constructor">
 +            <compilation-unit name="add-null">
 +                <output-dir compare="Text">add-null</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="constructor">
 +            <compilation-unit name="boolean_01">
 +                <output-dir compare="Text">boolean_01</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="constructor">
 +            <compilation-unit name="circle_01">
 +                <output-dir compare="Text">circle_01</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="constructor">
 +            <compilation-unit name="date_01">
 +                <output-dir compare="Text">date_01</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="constructor">
 +            <compilation-unit name="datetime_01">
 +                <output-dir compare="Text">datetime_01</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="constructor">
 +            <compilation-unit name="double_01">
 +                <output-dir compare="Text">double_01</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="constructor">
 +            <compilation-unit name="duration_01">
 +                <output-dir compare="Text">duration_01</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="constructor">
 +            <compilation-unit name="duration_02">
 +                <output-dir compare="Text">duration_02</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="constructor">
 +            <compilation-unit name="float_01">
 +                <output-dir compare="Text">float_01</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="constructor">
 +            <compilation-unit name="int_01">
 +                <output-dir compare="Text">int_01</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="constructor">
 +            <compilation-unit name="interval">
 +                <output-dir compare="Text">interval</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="constructor">
 +            <compilation-unit name="line_01">
 +                <output-dir compare="Text">line_01</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="constructor">
 +            <compilation-unit name="rectangle_01">
 +                <output-dir compare="Text">rectangle_01</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="constructor">
 +            <compilation-unit name="point_01">
 +                <output-dir compare="Text">point_01</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="constructor">
 +            <compilation-unit name="polygon_01">
 +                <output-dir compare="Text">polygon_01</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="constructor">
 +            <compilation-unit name="primitive-01">
 +                <output-dir compare="Text">primitive-01</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="constructor">
 +            <compilation-unit name="primitive-02">
 +                <output-dir compare="Text">primitive-02</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="constructor">
 +            <compilation-unit name="primitive-03">
 +                <output-dir compare="Text">primitive-03</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="constructor">
 +            <compilation-unit name="primitive-04">
 +                <output-dir compare="Text">primitive-04</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="constructor">
 +            <compilation-unit name="string_01">
 +                <output-dir compare="Text">string_01</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="constructor">
 +            <compilation-unit name="time_01">
 +                <output-dir compare="Text">time_01</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="constructor">
 +            <compilation-unit name="uuid_01">
 +                <output-dir compare="Text">uuid_01</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +    </test-group>
 +    <test-group name="custord">
 +        <!--
 +    <test-case FilePath="custord">
 +      <compilation-unit name="co">
 +        <output-dir compare="Text">co</output-dir>
 +      </compilation-unit>
 +    </test-case>
 +    -->
 +        <test-case FilePath="custord">
 +            <compilation-unit name="customer_q_01">
 +                <output-dir compare="Text">customer_q_01</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="custord">
 +            <compilation-unit name="customer_q_02">
 +                <output-dir compare="Text">customer_q_02</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="custord">
 +            <compilation-unit name="customer_q_03">
 +                <output-dir compare="Text">customer_q_03</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="custord">
 +            <compilation-unit name="customer_q_04">
 +                <output-dir compare="Text">customer_q_04</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="custord">
 +            <compilation-unit name="customer_q_05">
 +                <output-dir compare="Text">customer_q_05</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="custord">
 +            <compilation-unit name="customer_q_06">
 +                <output-dir compare="Text">customer_q_06</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="custord">
 +            <compilation-unit name="customer_q_07">
 +                <output-dir compare="Text">customer_q_07</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="custord">
 +            <compilation-unit name="customer_q_08">
 +                <output-dir compare="Text">customer_q_08</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <!--
 +        <test-case FilePath="custord">
 +          <compilation-unit name="denorm-cust-order_01">
 +            <output-dir compare="Text">denorm-cust-order_01</output-dir>
 +          </compilation-unit>
 +        </test-case>
 +        -->
 +        <test-case FilePath="custord">
 +            <compilation-unit name="denorm-cust-order_02">
 +                <output-dir compare="Text">denorm-cust-order_02</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <!--
 +        <test-case FilePath="custord">
 +          <compilation-unit name="denorm-cust-order_03">
 +            <output-dir compare="Text">denorm-cust-order_03</output-dir>
 +          </compilation-unit>
 +        </test-case>
 +        -->
 +        <!--
 +        <test-case FilePath="custord">
 +          <compilation-unit name="freq-clerk">
 +            <output-dir compare="Text">freq-clerk</output-dir>
 +          </compilation-unit>
 +        </test-case>
 +        -->
 +        <test-case FilePath="custord">
 +            <compilation-unit name="join_q_01">
 +                <output-dir compare="Text">join_q_01</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="custord">
 +            <compilation-unit name="join_q_02">
 +                <output-dir compare="Text">join_q_02</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="custord">
 +            <compilation-unit name="join_q_03">
 +                <output-dir compare="Text">join_q_03</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="custord">
 +            <compilation-unit name="join_q_04">
 +                <output-dir compare="Text">join_q_04</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="custord">
 +            <compilation-unit name="load-test">
 +                <output-dir compare="Text">load-test</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="custord">
 +            <compilation-unit name="order_q_01">
 +                <output-dir compare="Text">order_q_01</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="custord">
 +            <compilation-unit name="order_q_02">
 +                <output-dir compare="Text">order_q_02</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="custord">
 +            <compilation-unit name="order_q_03">
 +                <output-dir compare="Text">order_q_03</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="custord">
 +            <compilation-unit name="order_q_04">
 +                <output-dir compare="Text">order_q_04</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="custord">
 +            <compilation-unit name="order_q_05">
 +                <output-dir compare="Text">order_q_05</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="custord">
 +            <compilation-unit name="order_q_06">
 +                <output-dir compare="Text">order_q_06</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +    </test-group>
 +    <test-group name="dapd">
 +        <test-case FilePath="dapd">
 +            <compilation-unit name="q1">
 +                <output-dir compare="Text">q1</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="dapd">
 +            <compilation-unit name="q2">
 +                <output-dir compare="Text">q2</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <!--
 +        <test-case FilePath="dapd">
 +          <compilation-unit name="q3">
 +            <output-dir compare="Text">q3</output-dir>
 +          </compilation-unit>
 +        </test-case>
 +        -->
 +    </test-group>
 +    <test-group name="dml">
 +        <test-case FilePath="dml">
 +            <compilation-unit name="insert-dataset-with-meta">
 +                <output-dir compare="Text">insert-dataset-with-meta</output-dir>
 +                <expected-error>insert into dataset is not supported on Datasets with Meta records</expected-error>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="dml">
 +            <compilation-unit name="delete-dataset-with-meta">
 +                <output-dir compare="Text">delete-dataset-with-meta</output-dir>
 +                <expected-error>delete from dataset is not supported on Datasets with Meta records</expected-error>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="dml">
 +            <compilation-unit name="upsert-dataset-with-meta">
 +                <output-dir compare="Text">upsert-dataset-with-meta</output-dir>
 +                <expected-error>upsert into dataset is not supported on Datasets with Meta records</expected-error>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="dml">
 +            <compilation-unit name="load-with-ngram-index">
 +                <output-dir compare="Text">load-with-ngram-index</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +         <test-case FilePath="dml">
 +            <compilation-unit name="insert-duplicated-keys-from-query">
 +                <output-dir compare="Text">insert-duplicated-keys-from-query</output-dir>
 +                <expected-error>org.apache.hyracks.storage.am.common.exceptions.TreeIndexDuplicateKeyException: Failed to insert key since key already exists</expected-error>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="dml">
 +            <compilation-unit name="compact-dataset-and-its-indexes">
 +                <output-dir compare="Text">compact-dataset-and-its-indexes</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="dml">
 +            <compilation-unit name="using-constant-merge-policy">
 +                <output-dir compare="Text">using-constant-merge-policy</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="dml">
 +            <compilation-unit name="using-prefix-merge-policy">
 +                <output-dir compare="Text">using-prefix-merge-policy</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="dml">
 +            <compilation-unit name="using-correlated-prefix-merge-policy">
 +                <output-dir compare="Text">using-correlated-prefix-merge-policy</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="dml">
 +            <compilation-unit name="using-no-merge-policy">
 +                <output-dir compare="Text">using-no-merge-policy</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="dml">
 +            <compilation-unit name="query-issue382">
 +                <output-dir compare="Text">query-issue382</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="dml">
 +            <compilation-unit name="query-issue433">
 +                <output-dir compare="Text">query-issue433</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="dml">
 +            <compilation-unit name="query-issue288">
 +                <output-dir compare="Text">query-issue288</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="dml">
 +            <compilation-unit name="query-issue205">
 +                <output-dir compare="Text">query-issue205</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="dml">
 +            <compilation-unit name="delete-from-loaded-dataset-with-index">
 +                <output-dir compare="Text">delete-from-loaded-dataset-with-index</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="dml">
 +            <compilation-unit name="delete-from-loaded-dataset">
 +                <output-dir compare="Text">delete-from-loaded-dataset</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="dml">
 +            <compilation-unit name="delete-syntax-change">
 +                <output-dir compare="Text">delete-syntax-change</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="dml">
 +            <compilation-unit name="drop-empty-secondary-indexes">
 +                <output-dir compare="Text">drop-empty-secondary-indexes</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="dml">
 +            <compilation-unit name="drop-index">
 +                <output-dir compare="Text">drop-index</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="dml">
 +            <compilation-unit name="create-drop-cltype">
 +                <output-dir compare="Text">create-drop-cltype</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="dml">
 +            <compilation-unit name="create-drop-opntype">
 +                <output-dir compare="Text">create-drop-opntype</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="dml">
 +            <compilation-unit name="empty-load-with-index">
 +                <output-dir compare="Text">empty-load-with-index</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="dml">
 +            <compilation-unit name="insert-into-empty-dataset">
 +                <output-dir compare="Text">insert-into-empty-dataset</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="dml">
 +            <compilation-unit name="insert-into-empty-dataset-with-index">
 +                <output-dir compare="Text">insert-into-empty-dataset-with-index</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="dml">
 +            <compilation-unit name="insert-syntax">
 +                <output-dir compare="Text">insert-syntax</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="dml">
 +            <compilation-unit name="insert-and-scan-dataset">
 +                <output-dir compare="Text">insert-and-scan-dataset</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="dml">
 +            <compilation-unit name="insert-and-scan-dataset-with-index">
 +                <output-dir compare="Text">insert-and-scan-dataset-with-index</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="dml">
 +            <compilation-unit name="insert-and-scan-joined-datasets">
 +                <output-dir compare="Text">insert-and-scan-joined-datasets</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="dml">
 +            <compilation-unit name="insert-into-loaded-dataset-with-index_01">
 +                <output-dir compare="Text">insert-into-loaded-dataset-with-index_01</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="dml">
 +            <compilation-unit name="insert-into-loaded-dataset-with-index_02">
 +                <output-dir compare="Text">insert-into-loaded-dataset-with-index_02</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="dml">
 +            <compilation-unit name="insert-into-loaded-dataset_01">
 +                <output-dir compare="Text">insert-into-loaded-dataset_01</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="dml">
 +            <compilation-unit name="insert-into-loaded-dataset_02">
 +                <output-dir compare="Text">insert-into-loaded-dataset_02</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="dml">
 +            <compilation-unit name="insert-src-dst-01">
 +                <output-dir compare="Text">insert-src-dst-01</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="dml">
 +            <compilation-unit name="insert">
 +                <output-dir compare="Text">insert</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="dml">
 +            <compilation-unit name="insert-duplicated-keys">
 +                <output-dir compare="Text">insert-duplicated-keys</output-dir>
 +                <expected-error>org.apache.hyracks.storage.am.common.exceptions.TreeIndexDuplicateKeyException: Failed to insert key since key already exists</expected-error>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="dml">
 +            <compilation-unit name="insert_less_nc">
 +                <output-dir compare="Text">insert_less_nc</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <!--
 +        <test-case FilePath="dml">
 +          <compilation-unit name="load-from-hdfs">
 +            <output-dir compare="Text">load-from-hdfs</output-dir>
 +          </compilation-unit>
 +        </test-case>
 +        -->
 +        <test-case FilePath="dml">
 +            <compilation-unit name="insert-with-autogenerated-pk_adm_01">
 +                <output-dir compare="Text">insert-with-autogenerated-pk_adm_01</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="dml">
 +            <compilation-unit name="insert-with-autogenerated-pk_adm_02">
 +                <output-dir compare="Text">insert-with-autogenerated-pk_adm_02</output-dir>
 +                <expected-error>org.apache.hyracks.algebricks.common.exceptions.AlgebricksException: Duplicate field id encountered</expected-error>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="dml">
 +            <compilation-unit name="insert-with-autogenerated-pk_adm_03">
 +                <output-dir compare="Text">insert-with-autogenerated-pk_adm_03</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="dml">
 +            <compilation-unit name="load-with-autogenerated-pk_txt_01">
 +                <output-dir compare="Text">load-with-autogenerated-pk_txt_01</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="dml">
 +            <compilation-unit name="load-with-autogenerated-pk_adm_01">
 +                <output-dir compare="Text">load-with-autogenerated-pk_adm_01</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="dml">
 +            <compilation-unit name="load-with-autogenerated-pk_adm_02">
 +                <output-dir compare="Text">load-with-autogenerated-pk_adm_02</output-dir>
 +                <expected-error>org.apache.asterix.external.parser.ADMDataParser$ParseException</expected-error>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="dml">
 +            <compilation-unit name="load-with-autogenerated-pk_adm_03">
 +                <output-dir compare="Text">load-with-autogenerated-pk_adm_03</output-dir>
 +                <expected-error>org.apache.asterix.external.parser.ADMDataParser$ParseException</expected-error>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="dml">
 +            <compilation-unit name="load-with-autogenerated-pk_adm_04">
 +                <output-dir compare="Text">load-with-autogenerated-pk_adm_04</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="dml">
 +            <compilation-unit name="load-with-autogenerated-pk_csv_01">
 +                <output-dir compare="Text">load-with-autogenerated-pk_csv_01</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="dml">
 +            <compilation-unit name="load-with-autogenerated-pk_csv_02"><!-- Right now, this only throw exception on expected result!!! -->
 +                <output-dir compare="Text">load-with-autogenerated-pk_csv_02</output-dir>
 +                <expected-error>java.lang.Exception: Result</expected-error>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="dml">
 +            <compilation-unit name="load-with-index">
 +                <output-dir compare="Text">load-with-index</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="dml">
 +            <compilation-unit name="load-with-rtree-index">
 +                <output-dir compare="Text">load-with-rtree-index</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="dml">
 +            <compilation-unit name="load-with-word-index">
 +                <output-dir compare="Text">load-with-word-index</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="dml">
 +            <compilation-unit name="opentype-c2o-recursive">
 +                <output-dir compare="Text">opentype-c2o-recursive</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="dml">
 +            <compilation-unit name="opentype-c2o">
 +                <output-dir compare="Text">opentype-c2o</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="dml">
 +            <compilation-unit name="opentype-closed-optional">
 +                <output-dir compare="Text">opentype-closed-optional</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="dml">
 +            <compilation-unit name="opentype-insert">
 +                <output-dir compare="Text">opentype-insert</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="dml">
 +            <compilation-unit name="opentype-insert2">
 +                <output-dir compare="Text">opentype-insert2</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="dml">
 +            <compilation-unit name="opentype-noexpand">
 +                <output-dir compare="Text">opentype-noexpand</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="dml">
 +            <compilation-unit name="opentype-o2c-recursive">
 +                <output-dir compare="Text">opentype-o2c-recursive</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="dml">
 +            <compilation-unit name="opentype-o2c">
 +                <output-dir compare="Text">opentype-o2c</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="dml">
 +            <compilation-unit name="opentype-o2o">
 +                <output-dir compare="Text">opentype-o2o</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="dml">
 +            <compilation-unit name="scan-delete-btree-secondary-index-nullable">
 +                <output-dir compare="Text">scan-delete-btree-secondary-index-nullable</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="dml">
 +            <compilation-unit name="scan-delete-rtree-secondary-index-nullable">
 +                <output-dir compare="Text">scan-delete-rtree-secondary-index-nullable</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="dml">
 +            <compilation-unit name="scan-delete-rtree-secondary-index">
 +                <output-dir compare="Text">scan-delete-rtree-secondary-index</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="dml">
 +            <compilation-unit name="scan-insert-btree-secondary-index-nullable">
 +                <output-dir compare="Text">scan-insert-btree-secondary-index-nullable</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="dml">
 +            <compilation-unit name="scan-insert-rtree-secondary-index-nullable">
 +                <output-dir compare="Text">scan-insert-rtree-secondary-index-nullable</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="dml">
 +            <compilation-unit name="scan-insert-rtree-secondary-index">
 +                <output-dir compare="Text">scan-insert-rtree-secondary-index</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="dml">
 +            <compilation-unit name="scan-insert-inverted-index-ngram-secondary-index">
 +                <output-dir compare="Text">scan-insert-inverted-index-ngram-secondary-index</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="dml">
 +            <compilation-unit name="scan-insert-inverted-index-word-secondary-index">
 +                <output-dir compare="Text">scan-insert-inverted-index-word-secondary-index</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="dml">
 +            <compilation-unit name="scan-insert-inverted-index-ngram-secondary-index-nullable">
 +                <output-dir compare="Text">scan-insert-inverted-index-ngram-secondary-index-nullable</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="dml">
 +            <compilation-unit name="scan-insert-inverted-index-word-secondary-index-nullable">
 +                <output-dir compare="Text">scan-insert-inverted-index-word-secondary-index-nullable</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="dml">
 +            <compilation-unit name="scan-delete-inverted-index-ngram-secondary-index">
 +                <output-dir compare="Text">scan-delete-inverted-index-ngram-secondary-index</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="dml">
 +            <compilation-unit name="scan-delete-inverted-index-word-secondary-index">
 +                <output-dir compare="Text">scan-delete-inverted-index-word-secondary-index</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="dml">
 +            <compilation-unit name="scan-delete-inverted-index-ngram-secondary-index-nullable">
 +                <output-dir compare="Text">scan-delete-inverted-index-ngram-secondary-index-nullable</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="dml">
 +            <compilation-unit name="scan-delete-inverted-index-word-secondary-index-nullable">
 +                <output-dir compare="Text">scan-delete-inverted-index-word-secondary-index-nullable</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="dml">
 +            <compilation-unit name="load-with-index-open">
 +                <output-dir compare="Text">load-with-index-open</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="dml">
 +            <compilation-unit name="load-with-index-open_02">
 +                <output-dir compare="Text">load-with-index-open_02</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="dml">
 +            <compilation-unit name="load-with-ngram-index-open">
 +                <output-dir compare="Text">load-with-ngram-index-open</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="dml">
 +            <compilation-unit name="load-with-rtree-index-open">
 +                <output-dir compare="Text">load-with-rtree-index-open</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="dml">
 +            <compilation-unit name="load-with-word-index-open">
 +                <output-dir compare="Text">load-with-word-index-open</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="dml">
 +            <compilation-unit name="scan-delete-btree-secondary-index-open">
 +                <output-dir compare="Text">scan-delete-btree-secondary-index-open</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="dml">
 +            <compilation-unit name="scan-delete-inverted-index-ngram-secondary-index-open">
 +                <output-dir compare="Text">scan-delete-inverted-index-ngram-secondary-index-open</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="dml">
 +            <compilation-unit name="scan-delete-inverted-index-word-secondary-index-open">
 +                <output-dir compare="Text">scan-delete-inverted-index-word-secondary-index-open</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="dml">
 +            <compilation-unit name="scan-delete-rtree-secondary-index-open">
 +                <output-dir compare="Text">scan-delete-rtree-secondary-index-open</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="dml">
 +            <compilation-unit name="scan-insert-btree-secondary-index-open">
 +                <output-dir compare="Text">scan-insert-btree-secondary-index-open</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="dml">
 +            <compilation-unit name="scan-insert-inverted-index-ngram-secondary-index-open">
 +                <output-dir compare="Text">scan-insert-inverted-index-ngram-secondary-index-open</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="dml">
 +            <compilation-unit name="scan-insert-inverted-index-word-secondary-index-open">
 +                <output-dir compare="Text">scan-insert-inverted-index-word-secondary-index-open</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="dml">
 +            <compilation-unit name="scan-insert-rtree-secondary-index-open">
 +                <output-dir compare="Text">scan-insert-rtree-secondary-index-open</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="dml">
 +            <compilation-unit name="delete-multi-statement">
 +                <output-dir compare="Text">delete-multi-statement</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +    </test-group>
 +    <test-group name="employee">
 +        <test-case FilePath="employee">
 +            <compilation-unit name="q_01">
 +                <output-dir compare="Text">q_01</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="employee">
 +            <compilation-unit name="q_02">
 +                <output-dir compare="Text">q_02</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +    </test-group>
 +    <test-group name="failure">
 +        <!--
 +        <test-case FilePath="failure">
 +          <compilation-unit name="q1_pricing_summary_report_failure">
 +            <output-dir compare="Text">q1_pricing_summary_report_failure</output-dir>
 +          </compilation-unit>
 +        </test-case>
 +        -->
 +    </test-group>
 +    <!--
 +    <test-group name="flwor">
 +      <test-case FilePath="flwor">
 +        <compilation-unit name="for01">
 +          <output-dir co

<TRUNCATED>