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:54 UTC

[19/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_sqlpp.xml
----------------------------------------------------------------------
diff --cc asterixdb/asterix-app/src/test/resources/runtimets/testsuite_sqlpp.xml
index c343570,0000000..f9d1a0e
mode 100644,000000..100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/testsuite_sqlpp.xml
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/testsuite_sqlpp.xml
@@@ -1,7067 -1,0 +1,7112 @@@
 +<!--
 + ! 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 RecordsQueries SYSTEM "queries_sqlpp/records/RecordsQueries.xml">
 +
 +        ]>
 +<test-suite
 +        xmlns="urn:xml.testframework.asterix.apache.org"
 +        ResultOffsetPath="results"
 +        QueryOffsetPath="queries_sqlpp"
 +        QueryFileExtension=".sqlpp">
 +    <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-group>
 +    -->
 +    <test-case FilePath="flwor">
 +        <compilation-unit name="let33">
 +            <output-dir compare="Text">let33</output-dir>
 +        </compilation-unit>
 +    </test-case>
 +    <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</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</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</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="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">
 +        <test-case FilePath="comparison">
 +            <compilation-unit name="year_month_duration_order">
 +                <output-dir compare="Text">year_month_duration_order</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="comparison">
 +            <compilation-unit name="datetime_order">
 +                <output-dir compare="Text">datetime_order</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="comparison">
 +            <compilation-unit name="datetime_range">
 +                <output-dir compare="Text">datetime_range</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="comparison">
 +            <compilation-unit name="datetime_tzeq">
 +                <output-dir compare="Text">datetime_tzeq</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="comparison">
 +            <compilation-unit name="double">
 +                <output-dir compare="Text">double</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="comparison">
 +            <compilation-unit name="double_gte_01">
 +                <output-dir compare="Text">double_gte_01</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="comparison">
 +            <compilation-unit name="double_null">
 +                <output-dir compare="Text">double_null</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="comparison">
 +            <compilation-unit name="eq_01">
 +                <output-dir compare="Text">eq_01</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="comparison">
 +            <compilation-unit name="float">
 +                <output-dir compare="Text">float</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="comparison">
 +            <compilation-unit name="float_null">
 +                <output-dir compare="Text">float_null</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="comparison">
 +            <compilation-unit name="gt_01">
 +                <output-dir compare="Text">gt_01</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="comparison">
 +            <compilation-unit name="gte_01">
 +                <output-dir compare="Text">gte_01</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="comparison">
 +            <compilation-unit name="int16">
 +                <output-dir compare="Text">int16</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="comparison">
 +            <compilation-unit name="int16_null">
 +                <output-dir compare="Text">int16_null</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="comparison">
 +            <compilation-unit name="int32">
 +                <output-dir compare="Text">int32</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="comparison">
 +            <compilation-unit name="int32_null">
 +                <output-dir compare="Text">int32_null</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="comparison">
 +            <compilation-unit name="int64">
 +                <output-dir compare="Text">int64</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="comparison">
 +            <compilation-unit name="int64_null">
 +                <output-dir compare="Text">int64_null</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="comparison">
 +            <compilation-unit name="int8">
 +                <output-dir compare="Text">int8</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="comparison">
 +            <compilation-unit name="int8_null">
 +                <output-dir compare="Text">int8_null</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="comparison">
 +            <compilation-unit name="lt_01">
 +                <output-dir compare="Text">lt_01</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="comparison">
 +            <compilation-unit name="lte_01">
 +                <output-dir compare="Text">lte_01</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="comparison">
 +            <compilation-unit name="neq_01">
 +                <output-dir compare="Text">neq_01</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <!--
 +        <test-case FilePath="comparison">
 +          <compilation-unit name="numeric-comparison_01">
 +            <output-dir compare="Text">numeric-comparison_01</output-dir>
 +          </compilation-unit>
 +        </test-case>
 +        -->
 +        <test-case FilePath="comparison">
 +            <compilation-unit name="string">
 +                <output-dir compare="Text">string</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="comparison">
 +            <compilation-unit name="string_null">
 +                <output-dir compare="Text">string_null</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="comparison">
 +            <compilation-unit name="issue363_equality">
 +                <output-dir compare="Text">issue363_equality</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="comparison">
 +            <compilation-unit name="issue363_inequality_duration">
 +                <output-dir compare="Text">issue363_inequality_duration</output-dir>
 +                <expected-error>org.apache.hyracks.algebricks.common.exceptions.AlgebricksException: Comparison operations (GT, GE, LT, and LE) for the DURATION type are not defined</expected-error>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="comparison">
 +            <compilation-unit name="issue363_inequality_interval">
 +                <output-dir compare="Text">issue363_inequality_interval</output-dir>
 +                <expected-error>org.apache.hyracks.algebricks.common.exceptions.AlgebricksException: Comparison operations (GT, GE, LT, and LE) for the INTERVAL type are not defined</expected-error>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="comparison">
 +            <compilation-unit name="issue363_inequality_point">
 +                <output-dir compare="Text">issue363_inequality_point</output-dir>
 +                <expected-error>org.apache.hyracks.algebricks.common.exceptions.AlgebricksException: Comparison operations (GT, GE, LT, and LE) for the POINT type are not defined</expected-error>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="comparison">
 +            <compilation-unit name="issue363_inequality_line">
 +                <output-dir compare="Text">issue363_inequality_line</output-dir>
 +                <expected-error>org.apache.hyracks.algebricks.common.exceptions.AlgebricksException: Comparison operations (GT, GE, LT, and LE) for the LINE type are not defined</expected-error>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="comparison">
 +            <compilation-unit name="issue363_inequality_polygon">
 +                <output-dir compare="Text">issue363_inequality_polygon</output-dir>
 +                <expected-error>org.apache.hyracks.algebricks.common.exceptions.AlgebricksException: Comparison operations (GT, GE, LT, and LE) for the POLYGON type are not defined</expected-error>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="comparison">
 +            <compilation-unit name="issue363_inequality_rectangle">
 +                <output-dir compare="Text">issue363_inequality_rectangle</output-dir>
 +                <expected-error>org.apache.hyracks.algebricks.common.exceptions.AlgebricksException: Comparison operations (GT, GE, LT, and LE) for the RECTANGLE type are not defined</expected-error>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="comparison">
 +            <compilation-unit name="issue363_inequality_circle">
 +                <output-dir compare="Text">issue363_inequality_circle</output-dir>
 +                <expected-error>org.apache.hyracks.algebricks.common.exceptions.AlgebricksException: Comparison operations (GT, GE, LT, and LE) for the CIRCLE type are not defined</expected-error>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="comparison">
 +            <compilation-unit name="binary">
 +                <output-dir compare="Text">binary</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="comparison">
 +            <compilation-unit name="binary_null">
 +                <output-dir compare="Text">binary_null</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +    </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="join_q_05">
 +                <output-dir compare="Text">join_q_01</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="custord">
 +            <compilation-unit name="join_q_06">
 +                <output-dir compare="Text">join_q_06</output-dir>
 +            </compilation-unit>
 +        </test-case>
 +        <test-case FilePath="custord">
 +            <compilation-unit name="join_q_07">
 +                <output-dir compare="Text">join_q_06</output-dir>
 +                 <expected-error>org.apache.hyracks.algebricks.common.exceptions.AlgebricksException: Could not find dataset c in dataverse test</expected-error>
 +            </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="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">
 +                <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-ngram-index">
 +                <output-dir compare="Text">load-with-ngram-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-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 compare="Text">for01</output-dir>
 +        </compilation-unit>
 +      </test-case>
 +      <test-case FilePath="flwor">
 +        <compilation-unit name="for02">
 +          <output-dir compare="Text">for02</output-dir>
 +        </compilation-unit>
 +      </test-case>
 +      <test-case FilePath="flwor">
 +        <compilation-unit name="for03">
 +          <output-dir compare="Text">for03</output-dir>
 +        </compilation-unit>
 +      </test-case>
 +      <test-case FilePath="flwor">
 +        <compilation-unit name="for04">
 +          <output-dir compare="Text">for04</output-dir>
 +        </compilation-unit>
 +      </test-case>
 +      <test-case FilePath="flwor">
 +        <compilation-unit name="for05">
 +          <output-dir compare="Text">for05</output-dir>
 +        </compilation-unit>
 +      </test-case>
 +      <test-case FilePath="flwor">
 +        <compilation-unit name="for06">
 +          <output-dir compare="Text">for06</output-dir>
 +        </compilation-unit>
 +      </test-case>
 +      <test-case FilePath="flwor">
 +        <compilation-unit name="for07">
 +          <output-dir compare="Text">for07</output-dir>
 +        </compilation-unit>
 +      </test-case>
 +      <test-case FilePath="flwor">
 +        <compilation-unit name="for08">
 +          <output-dir compare="Text">for08</output-dir>
 +        </compilation-unit>
 +      </test-case>
 +      <test-case FilePath="flwor">
 +        <compilation-unit name="for09">
 +          <output-dir compare="Text">for09</output-dir>
 +        </compilation-unit>
 +      </test-case>
 +      <test-case FilePath="flwor">
 +        <compilation-unit name="for10">
 +          <output-dir compare="Text">for10</output-dir>
 +        </compilation-unit>
 +      </test-case>
 +      <test-case FilePath="flwor">
 +        <compilation-unit name="for11">
 +          <output-dir compare="Text">for11</output-dir>
 +        </compilation-unit>
 +      </test-case>
 +      <test-case FilePath="flwor">
 +        <compilation-unit name="for12">
 +          <output-dir compare="Text">for12</output-dir>
 +        </compilation-unit>
 +      </test-case>
 +      <test-case FilePath="flwor">
 +        <compilation-unit name="for13">
 +          <output-dir compare="Text">for13</output-dir>
 +        </compilation-unit>
 +      </test-case>
 +      <test-case FilePath="flwor">
 +        <compilation-unit name="for14">
 +          <output-dir compare="Text">for14</output-dir>
 +        </compilation-unit>
 +      </test-case>
 +      <test-case FilePath="flwor">
 +        <compilation-unit name="for15">
 +          <output-dir compare="Text">for15</output-dir>
 +        </compilation-unit>
 +      </test-case>
 +      <test-case FilePath="flwor">
 +        <compilation-unit name="for16">
 +          <output-dir compare="Text">for16</output-dir>
 +        </compilation-unit>
 +      </test-case>
 +      <test-case FilePath="flwor">
 +        <compilation-unit name="for17">
 +          <output-dir compare="Text">for17</output-dir>
 +        </compilation-unit>
 +      </test-case>
 +      <test-case FilePath="flwor">
 +        <compilation-unit name="for18">
 +          <output-dir compare="Text">for18</output-dir>
 +        </compilation-unit>
 +      </test-case>
 +      <test-case FilePath="flwor">
 +        <compilation-unit name="for19">
 +          <output-dir compare="Text">for19</output-dir>
 +        </compilation-unit>
 +      </test-case>
 +      <test-case FilePath="flwor">
 +        <compilation-unit name="grpby01">
 +          <output-dir compare="Text">grpby01</output-dir>
 +        </compilation-unit>
 +      </test-case>
 +      <test-case FilePath="flwor">
 +        <compilation-unit name="grpby02">
 +          <output-dir compare="Text">grpby02</output-dir>
 +        </compilation-unit>
 +      </test-case>
 +      <test-case FilePath="flwor">
 +        <compilation-unit name="let01">
 +          <output-dir compare="Text

<TRUNCATED>