<!--
  ~ 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.
  -->

<integrate-test-cases>
    <dql-test-case sql-case-id="select_constant_without_table">
        <assertion expected-data-file="select_constant_without_table.xml" />
    </dql-test-case>
    
    <dql-test-case sql-case-id="select_with_same_table_name_and_alias">
        <assertion parameters="10:int, 1000:int" expected-data-file="select_equal_with_single_table.xml" />
        <assertion parameters="12:int, 1000:int" expected-data-file="empty_order.xml" />
    </dql-test-case>
    
    <dql-test-case sql-case-id="select_with_same_table_name_and_alias_column_with_owner">
        <assertion parameters="10:int, 1000:int" expected-data-file="select_equal_with_single_table.xml" />
        <assertion parameters="12:int, 1000:int" expected-data-file="empty_order.xml" />
    </dql-test-case>
    
    <dql-test-case sql-case-id="select_not_equal_with_single_table">
        <assertion parameters="100001:int" expected-data-file="select_not_equal_with_single_table.xml" />
    </dql-test-case>
    
    <dql-test-case sql-case-id="select_exclamation_equal_with_single_table">
        <assertion parameters="100001:int" expected-data-file="select_not_equal_with_single_table.xml" />
    </dql-test-case>
    
    <dql-test-case sql-case-id="select_not_in_with_single_table">
        <assertion parameters="100000:int, 100001:int" expected-data-file="select_not_in_with_single_table.xml" />
    </dql-test-case>
    
    <dql-test-case sql-case-id="select_not_between_with_single_table">
        <assertion parameters="100000:int, 100001:int" expected-data-file="select_not_in_with_single_table.xml" />
    </dql-test-case>
    
    <dql-test-case sql-case-id="select_equal_with_single_table">
        <assertion parameters="10:int, 1000:int" expected-data-file="select_equal_with_single_table.xml" />
        <assertion parameters="12:int, 1000:int" expected-data-file="empty_order.xml" />
    </dql-test-case>
    
    <dql-test-case sql-case-id="select_equal_with_same_sharding_column">
        <assertion parameters="1000:int, 1001:int" expected-data-file="empty_order.xml" />
    </dql-test-case>
    
    <dql-test-case sql-case-id="select_in_with_same_sharding_column">
        <assertion parameters="1000:int, 1001:int, 1001:int, 1100:int" expected-data-file="select_in_with_same_sharding_column.xml" />
    </dql-test-case>
    
    <dql-test-case sql-case-id="select_in_with_single_table">
        <assertion parameters="10:int, 12:int, 15:int, 1000:int, 1101:int" expected-data-file="select_in_with_single_table.xml" />
        <assertion parameters="10:int, 12:int, 15:int, 1309:int, 1408:int" expected-data-file="empty_order.xml" />
    </dql-test-case>
    
    <dql-test-case sql-case-id="select_between_with_single_table">
        <assertion parameters="10:int, 12:int, 1009:int, 1108:int" expected-data-file="select_between_with_single_table.xml" />
        <assertion parameters="10:int, 12:int, 1309:int, 1408:int" expected-data-file="empty_order.xml" />
    </dql-test-case>

    <dql-test-case sql-case-id="select_comparison_symbol_with_single_table">
        <assertion parameters="10:int, 12:int, 1009:int, 1108:int" expected-data-file="select_comparison_symbol_with_single_table.xml" />
        <assertion parameters="10:int, 12:int, 1309:int, 1408:int" expected-data-file="empty_order.xml" />
    </dql-test-case>
    
    <dql-test-case sql-case-id="select_count_like_concat">
        <assertion parameters="init:String, 10:int, 11:int, 1000:int, 2901:int" expected-data-file="select_count_like_concat.xml" />
    </dql-test-case>

    <dql-test-case sql-case-id="select_count_tilde_concat">
        <assertion parameters="init:String, 10:int, 11:int, 1000:int, 2901:int" expected-data-file="select_count_tilde_concat.xml" />
    </dql-test-case>
    
    <dql-test-case sql-case-id="select_sharding_route_with_binding_tables">
        <assertion parameters="10:int, 11:int, 1000:int, 1909:int" expected-data-file="select_sharding_route_with_binding_tables.xml" />
    </dql-test-case>
    
    <dql-test-case sql-case-id="select_full_route_with_binding_tables">
        <assertion expected-data-file="select_full_route_with_binding_tables.xml" />
    </dql-test-case>
    
    <dql-test-case sql-case-id="select_sharding_route_with_broadcast_table">
        <assertion parameters="10:int, 11:int, 1001:int, 1100:int, init:String" expected-data-file="select_sharding_route_with_broadcast_table.xml" />
        <assertion parameters="10:int, 11:int, 1009:int, 1108:int, none:String" expected-data-file="empty_order_item.xml" />
    </dql-test-case>
    
    <dql-test-case sql-case-id="select_keyword_table_name_with_back_quotes">
        <assertion parameters="10:int, 11:int, 1001:int, 1100:int, init:String" expected-data-file="select_sharding_route_with_broadcast_table.xml" />
        <assertion parameters="10:int, 11:int, 1009:int, 1108:int, none:String" expected-data-file="empty_order_item.xml" />
    </dql-test-case>
    
    <dql-test-case sql-case-id="select_keyword_table_name_with_double_quotes">
        <assertion parameters="10:int, 11:int, 1001:int, 1100:int, init:String" expected-data-file="select_sharding_route_with_broadcast_table.xml" />
        <assertion parameters="10:int, 11:int, 1009:int, 1108:int, none:String" expected-data-file="empty_order_item.xml" />
    </dql-test-case>
    
    <dql-test-case sql-case-id="select_keyword_table_name_with_square_brackets">
        <assertion parameters="10:int, 11:int, 1001:int, 1100:int, init:String" expected-data-file="select_sharding_route_with_broadcast_table.xml" />
        <assertion parameters="10:int, 11:int, 1009:int, 1108:int, none:String" expected-data-file="empty_order_item.xml" />
    </dql-test-case>
    
    <dql-test-case sql-case-id="select_alias_as_keyword">
        <assertion parameters="100001:int" expected-data-file="select_alias_as_keyword.xml" />
    </dql-test-case>
    
    <dql-test-case sql-case-id="select_with_force_index_join">
        <assertion parameters="1000:int" expected-data-file="select_with_force_index_join.xml" />
    </dql-test-case>

    <dql-test-case sql-case-id="select_equal_with_geography">
        <assertion parameters="'{&quot;rule2&quot;:&quot;null&quot;}', 100:int, 200:int, 10:int, 1000:int" expected-data-file="select_equal_with_single_table.xml" />
        <assertion parameters="'{&quot;rule2&quot;:&quot;null&quot;}', 100:int, 200:int, 12:int, 1000:int" expected-data-file="empty_order.xml" />
    </dql-test-case>

    <dql-test-case sql-case-id="select_in_with_geography">
        <assertion parameters="'{&quot;rule2&quot;:&quot;null&quot;}', '{&quot;rule2&quot;:&quot;null&quot;}', 100:int, 200:int, 10:int, 1000:int" expected-data-file="select_equal_with_single_table.xml" />
        <assertion parameters="'{&quot;rule2&quot;:&quot;null&quot;}', '{&quot;rule2&quot;:&quot;null&quot;}', 100:int, 200:int, 12:int, 1000:int" expected-data-file="empty_order.xml" />
    </dql-test-case>
    
    <dql-test-case sql-case-id="select_sum">
        <assertion expected-data-file="select_sum.xml" />
    </dql-test-case>
    
    <dql-test-case sql-case-id="select_count">
        <assertion expected-data-file="select_count.xml" />
    </dql-test-case>
    
    <dql-test-case sql-case-id="select_count_with_sub">
        <assertion expected-data-file="select_count_with_sub.xml" />
    </dql-test-case>
    
    <dql-test-case sql-case-id="select_count_with_sub_with_whitespace">
        <assertion expected-data-file="select_count_with_sub_with_whitespace.xml" />
    </dql-test-case>
    
    <dql-test-case sql-case-id="select_max">
        <assertion expected-data-file="select_max.xml" />
    </dql-test-case>
    
    <dql-test-case sql-case-id="select_min">
        <assertion expected-data-file="select_min.xml" />
    </dql-test-case>
    
    <dql-test-case sql-case-id="select_avg">
        <assertion expected-data-file="select_avg.xml" />
    </dql-test-case>
    
    <dql-test-case sql-case-id="select_count_with_binding_tables_without_join">
        <assertion parameters="10:int, 11:int, 1000:int, 1909:int" expected-data-file="select_count_with_binding_tables.xml" />
    </dql-test-case>
    
    <dql-test-case sql-case-id="select_count_with_binding_tables_with_join">
        <assertion parameters="10:int, 11:int, 1000:int, 1909:int" expected-data-file="select_count_with_binding_tables.xml" />
    </dql-test-case>
    
    <dql-test-case sql-case-id="select_count_with_escape_character">
        <assertion expected-data-file="select_count.xml" />
    </dql-test-case>

    <dql-test-case sql-case-id="select_with_block_comment">
        <assertion expected-data-file="empty_order.xml" />
    </dql-test-case>

    <dql-test-case sql-case-id="select_with_single_comment">
        <assertion expected-data-file="empty_order.xml" />
    </dql-test-case>

    <dql-test-case sql-case-id="select_with_expression">
        <assertion expected-data-file="select_with_expression.xml" />
    </dql-test-case>
    
    <dql-test-case sql-case-id="select_with_date_function">
        <assertion expected-data-file="select_with_date_function.xml" />
    </dql-test-case>
    
    <dql-test-case sql-case-id="select_with_regexp">
        <assertion parameters="init:String, 100000:int, 100001:int" expected-data-file="select_with_regexp.xml" />
    </dql-test-case>
    
    <dql-test-case sql-case-id="select_group_by_with_sum">
        <assertion expected-data-file="select_group_by_with_sum.xml" />
    </dql-test-case>
    
    <dql-test-case sql-case-id="select_group_by_with_count">
        <assertion expected-data-file="select_group_by_with_count.xml" />
    </dql-test-case>
    
    <dql-test-case sql-case-id="select_group_by_with_max">
        <assertion expected-data-file="select_group_by_with_max.xml" />
    </dql-test-case>
    
    <dql-test-case sql-case-id="select_group_by_with_min">
        <assertion expected-data-file="select_group_by_with_min.xml" />
    </dql-test-case>
    
    <dql-test-case sql-case-id="select_group_by_with_avg">
        <assertion expected-data-file="select_group_by_with_avg.xml" />
    </dql-test-case>
    
    <dql-test-case sql-case-id="select_group_by_with_order_by_desc">
        <assertion expected-data-file="select_group_by_with_order_by_desc.xml" />
    </dql-test-case>
    
    <dql-test-case sql-case-id="select_group_by_without_grouped_column">
        <assertion parameters="10:int, 11:int, 1000:int, 1109:int" expected-data-file="select_group_by_without_grouped_column.xml" />
    </dql-test-case>
    
    <dql-test-case sql-case-id="select_group_by_with_limit">
        <assertion parameters="1:int" expected-data-file="select_group_by_with_limit.xml" />
    </dql-test-case>
    
    <dql-test-case sql-case-id="select_group_by_with_order_by_and_limit">
        <assertion parameters="1:int" expected-data-file="select_group_by_with_order_by_and_limit.xml" />
    </dql-test-case>
    
    <dql-test-case sql-case-id="select_with_item_alias_match_order_by_and_group_by_items">
        <assertion expected-data-file="select_with_item_alias_match_order_by_and_group_by_items.xml" />
    </dql-test-case>
    
    <dql-test-case sql-case-id="select_group_by_with_keyword_alias">
        <assertion expected-data-file="select_group_by_with_keyword_alias.xml" />
    </dql-test-case>

    <dql-test-case sql-case-id="select_group_by_with_count_without_column_name">
        <assertion expected-data-file="select_group_by_with_count_without_column_name.xml" />
    </dql-test-case>
    
    <!--<dql-test-case sql-case-id="select_group_by_with_date_function">-->
        <!--<assertion sharding-rule-type="dbtbl_with_masterslave" parameters="1000:int, 1100:int" expected-data-file="select_group_by_with_date_function.xml" />-->
    <!--</dql-test-case>-->
    
    <dql-test-case sql-case-id="select_or_with_same_sharding_columns">
        <assertion parameters="1000:int, 1001:int" expected-data-file="select_or_with_same_sharding_columns.xml" />
    </dql-test-case>
    
    <dql-test-case sql-case-id="select_or_with_different_sharding_columns">
        <assertion parameters="1000:int, 11:int" expected-data-file="select_or_with_different_sharding_columns.xml" />
    </dql-test-case>
    
    <dql-test-case sql-case-id="select_or_with_none_sharding_columns">
        <assertion parameters="1000:int, init:String" expected-data-file="select_or_with_none_sharding_columns.xml" />
    </dql-test-case>
    
    <dql-test-case sql-case-id="select_or_mix_and_for_simple_pattern">
        <assertion parameters="1000:int, init:String, 11:int" expected-data-file="select_or_mix_and_for_simple_pattern.xml" />
    </dql-test-case>
    
    <dql-test-case sql-case-id="select_or_mix_and_for_complex_pattern">
        <assertion parameters="init:String, 1000:int, 1100:int, 10:int, 11:int" expected-data-file="select_or_mix_and_for_complex_pattern.xml" />
    </dql-test-case>
    
    <dql-test-case sql-case-id="select_or_mix_and_with_binding_tables">
        <assertion parameters="1000:int, 1100:int, 11:int" expected-data-file="select_or_mix_and_with_binding_tables.xml" />
    </dql-test-case>
    
    <dql-test-case sql-case-id="select_or_mix_and_with_binding_and_broadcast_tables">
        <assertion parameters="1000:int, 1100:int, 11:int, init:String" expected-data-file="select_or_mix_and_with_binding_and_broadcast_tables.xml" />
    </dql-test-case>
    
    <dql-test-case sql-case-id="select_order_by_asc_and_index_desc">
        <assertion expected-data-file="select_order_by_asc_and_index_desc.xml" />
    </dql-test-case>
    
    <dql-test-case sql-case-id="select_order_by_desc_and_index_asc">
        <assertion expected-data-file="select_order_by_desc_and_index_asc.xml" />
    </dql-test-case>
    
    <dql-test-case sql-case-id="select_order_by_with_ordered_column">
        <assertion expected-data-file="select_order_by_with_ordered_column.xml" />
    </dql-test-case>
    
    <dql-test-case sql-case-id="select_order_by_with_date">
        <assertion expected-data-file="select_order_by_with_date.xml" />
    </dql-test-case>
    
    <!-- // TODO add null data -->
    <dql-test-case sql-case-id="select_order_by_for_nulls_first">
        <assertion expected-data-file="select_order_by_with_ordered_column.xml" />
    </dql-test-case>
    
    <!-- // TODO add null data -->
    <dql-test-case sql-case-id="select_order_by_for_nulls_last">
        <assertion expected-data-file="select_order_by_with_ordered_column.xml" />
    </dql-test-case>
    
    <dql-test-case sql-case-id="select_order_by_with_multiple_stars">
        <assertion expected-data-file="select_order_by_with_multiple_stars.xml" />
    </dql-test-case>
    
    <dql-test-case sql-case-id="select_order_by_with_alias_star_alias_name">
        <assertion expected-data-file="select_order_by_with_alias_star_alias_name.xml" />
    </dql-test-case>
    
    <dql-test-case sql-case-id="select_order_by_with_alias_star_alias_name">
        <assertion expected-data-file="select_order_by_with_alias_star_alias_name.xml" />
    </dql-test-case>
    
    <dql-test-case sql-case-id="select_order_by_with_star_table_alias">
        <assertion expected-data-file="select_order_by_with_star_table_alias.xml" />
    </dql-test-case>
    
    <dql-test-case sql-case-id="select_order_by_with_table_star_table_name">
        <assertion expected-data-file="select_order_by_with_table_star_table_name.xml" />
    </dql-test-case>
    
    <!--TODO need to add later-->
    <!--<dql-test-case sql-case-id="select_order_by_with_parameter">-->
        <!--<assertion parameters="order_id:String" expected-data-file="select_order_by_with_star_table_alias.xml" />-->
    <!--</dql-test-case>-->
    
    <dql-test-case sql-case-id="select_order_by_with_star_no_table_alias">
        <assertion expected-data-file="select_order_by_with_star_no_table_alias.xml" />
    </dql-test-case>
    
    <dql-test-case sql-case-id="select_pagination_with_offset">
        <assertion parameters="10:int, 19:int, 1000:int, 1909:int, 6:int" expected-data-file="select_pagination_with_offset.xml" />
    </dql-test-case>

    <dql-test-case sql-case-id="select_order_by_with_table_star_without_table_name">
        <assertion expected-data-file="select_order_by_with_table_star_without_table_name.xml" />
    </dql-test-case>
    
    <dql-test-case sql-case-id="select_pagination_with_row_count">
        <assertion parameters="10:int, 19:int, 1000:int, 1909:int, 2:int" expected-data-file="select_pagination_with_row_count.xml" />
    </dql-test-case>
    
    <dql-test-case sql-case-id="select_pagination_with_top">
        <assertion parameters="2:int, 10:int, 19:int, 1000:int, 1909:int" expected-data-file="select_pagination_with_row_count.xml" />
    </dql-test-case>
    
    <dql-test-case sql-case-id="select_pagination_with_row_number">
        <assertion parameters="10:int, 19:int, 1000:int, 1909:int, 2:int" expected-data-file="select_pagination_with_row_count.xml" />
    </dql-test-case>
    
    <dql-test-case sql-case-id="select_pagination_with_limit_with_back_quotes">
        <assertion parameters="10:int, 19:int, 1000:int, 1909:int, 2:int, 2:int" expected-data-file="select_pagination_with_offset_and_row_count.xml" />
    </dql-test-case>
    
    <dql-test-case sql-case-id="select_pagination_with_limit_and_offset_keyword">
        <assertion parameters="10:int, 19:int, 1000:int, 1909:int, 2:int, 2:int" expected-data-file="select_pagination_with_offset_and_row_count.xml" />
    </dql-test-case>
    
    <dql-test-case sql-case-id="select_pagination_with_offset_and_limit">
        <assertion parameters="10:int, 19:int, 1000:int, 1909:int, 2:int, 2:int" expected-data-file="select_pagination_with_offset_and_limit.xml" />
    </dql-test-case>
    
    <dql-test-case sql-case-id="select_pagination_with_top_for_greater_than">
        <assertion parameters="4:int, 10:int, 19:int, 1000:int, 1909:int, 2:int" expected-data-file="select_pagination_with_top_and_limit.xml" />
    </dql-test-case>
    
    <dql-test-case sql-case-id="select_pagination_with_top_for_greater_than_and_equal">
        <assertion parameters="4:int, 10:int, 19:int, 1000:int, 1909:int, 3:int" expected-data-file="select_pagination_with_top_and_limit.xml" />
    </dql-test-case>
    
    <dql-test-case sql-case-id="select_pagination_with_row_number_for_greater_than">
        <assertion parameters="10:int, 19:int, 1000:int, 1909:int, 4:int, 2:int" expected-data-file="select_pagination_with_row_number_and_limit.xml" />
    </dql-test-case>
    
    <dql-test-case sql-case-id="select_pagination_with_row_number_for_greater_than_and_equal">
        <assertion parameters="10:int, 19:int, 1000:int, 1909:int, 4:int, 3:int" expected-data-file="select_pagination_with_row_number_and_limit.xml" />
    </dql-test-case>
    
    <dql-test-case sql-case-id="select_pagination_with_row_number_not_at_end">
        <assertion parameters="20:int" expected-data-file="select_pagination_with_row_number_not_at_end.xml" />
    </dql-test-case>

    <dql-test-case sql-case-id="select_pagination_with_offset_fetch">
        <assertion parameters="20:int" expected-data-file="select_pagination_with_offset_fetch.xml" />
    </dql-test-case>
    
    <dql-test-case sql-case-id="select_pagination_with_group_by_and_order_by">
        <assertion parameters="10:int, 19:int, 1000:int, 1909:int, 1:int, 10:int" expected-data-file="select_pagination_with_group_by_and_order_by.xml" />
    </dql-test-case>
    
    <dql-test-case sql-case-id="select_pagination_with_diff_group_by_and_order_by">
        <assertion parameters="10:int, 19:int, 1000:int, 1909:int, 1:int, 10:int" expected-data-file="select_pagination_with_diff_group_by_and_order_by.xml" />
    </dql-test-case>
    
    <dql-test-case sql-case-id="select_inner_join_related_with_alias">
        <assertion parameters="1000:int" expected-data-file="select_inner_join.xml" />
    </dql-test-case>
    
    <dql-test-case sql-case-id="select_inner_join_related_with_name">
        <assertion parameters="1000:int" expected-data-file="select_inner_join.xml" />
    </dql-test-case>
    
    <dql-test-case sql-case-id="select_join_using">
        <assertion parameters="1000:int" expected-data-file="select_inner_join.xml" />
    </dql-test-case>
    
    <!--<dql-test-case sql-case-id="select_sub_query_with_multiple_tables">-->
    <!--<assertion parameters="1000:int, 1001:int" expected-data-file="select_sub_query_with_multiple_tables.xml" />-->
    <!--</dql-test-case>-->
    
    <!-- TODO Can not support subquery at current
    <dql-test-case sql-case-id="select_sub_query_with_order_by">
        <assertion expected-data-file="select_sub_query_with_order_by.xml" />
    </dql-test-case>
    
    <dql-test-case sql-case-id="select_sub_query_with_group_by">
        <assertion expected-data-file="select_sub_query_with_group_by.xml" />
    </dql-test-case>
    -->
    
    <dql-test-case sql-case-id="select_with_double_quotes">
        <assertion parameters="100001:int" expected-data-file="select_not_equal_with_single_table.xml" />
    </dql-test-case>

    <dql-test-case sql-case-id="select_escape_with_single_quota">
        <assertion expected-data-file="empty_order.xml" />
    </dql-test-case>

    <dql-test-case sql-case-id="select_escape_with_double_quota">
        <assertion expected-data-file="empty_order.xml" />
    </dql-test-case>
   
    <dql-test-case sql-case-id="select_alias_as_single_quote_string">
        <assertion expected-data-file="select_alias_as_single_quote_string.xml" />
    </dql-test-case>

    <dql-test-case sql-case-id="select_alias_as_string_double_quote">
        <assertion expected-data-file="select_alias_as_single_quote_string.xml" />
    </dql-test-case>

    <dql-test-case sql-case-id="select_distinct_with_single_column_without_order_by">
        <assertion expected-data-file="select_distinct_with_single_column_without_order_by.xml" />
    </dql-test-case>

    <dql-test-case sql-case-id="select_distinct_with_multi_column_without_order_by">
        <assertion expected-data-file="select_distinct_with_multi_column_without_order_by.xml" />
    </dql-test-case>

    <dql-test-case sql-case-id="select_distinct_with_owner_column_without_order_by">
        <assertion expected-data-file="select_distinct_with_owner_column_without_order_by.xml" />
    </dql-test-case>

    <dql-test-case sql-case-id="select_distinct_with_owner_star_without_order_by">
        <assertion expected-data-file="select_distinct_with_owner_star_without_order_by.xml" />
    </dql-test-case>

    <dql-test-case sql-case-id="select_distinct_with_single_column">
        <assertion expected-data-file="select_distinct_with_single_column.xml" />
    </dql-test-case>

    <dql-test-case sql-case-id="select_distinct_with_owner_column">
        <assertion expected-data-file="select_distinct_with_owner_column.xml" />
    </dql-test-case>

    <dql-test-case sql-case-id="select_distinct_with_multi_column">
        <assertion expected-data-file="select_distinct_with_multi_column.xml" />
    </dql-test-case>

    <dql-test-case sql-case-id="select_distinct_with_star">
        <assertion expected-data-file="select_distinct_with_star.xml" />
    </dql-test-case>
    
    <dql-test-case sql-case-id="select_distinct_with_owner_star">
        <assertion expected-data-file="select_distinct_with_owner_star.xml" />
    </dql-test-case>
    
    <dql-test-case sql-case-id="select_distinct_with_sum">
        <assertion expected-data-file="select_distinct_with_sum.xml" />
    </dql-test-case>
    
    <dql-test-case sql-case-id="select_distinct_with_count">
        <assertion expected-data-file="select_distinct_with_count.xml" />
    </dql-test-case>
    
    <dql-test-case sql-case-id="select_distinct_with_avg">
        <assertion expected-data-file="select_distinct_with_avg.xml" />
    </dql-test-case>
    
    <dql-test-case sql-case-id="select_distinct_function">
        <assertion expected-data-file="select_distinct_function.xml" />
    </dql-test-case>
    
    <dql-test-case sql-case-id="select_distinct_with_count_sum">
        <assertion expected-data-file="select_distinct_with_count_sum.xml" />
    </dql-test-case>
    
    <dql-test-case sql-case-id="select_distinct_with_count_calculation">
        <assertion expected-data-file="select_distinct_with_count_calculation.xml" />
    </dql-test-case>
    
    <dql-test-case sql-case-id="select_distinct_with_single_count_group_by">
        <assertion expected-data-file="select_distinct_with_single_count_group_by.xml" />
    </dql-test-case>
    
    <dql-test-case sql-case-id="select_distinct_with_count_group_by">
        <assertion expected-data-file="select_distinct_with_count_group_by.xml" />
    </dql-test-case>

    <dql-test-case sql-case-id="select_special_function_nested">
        <assertion parameters="12:int, 1000:int" expected-data-file="select_special_function_nested.xml" />
    </dql-test-case>

    <dql-test-case sql-case-id="select_with_interval_function">
        <assertion parameters="12:int, 1000:int" expected-data-file="select_with_interval_function.xml" />
    </dql-test-case>

    <dql-test-case sql-case-id="select_for_update">
        <assertion parameters="10:int" expected-data-file="select_for_update.xml" />
    </dql-test-case>

    <dql-test-case sql-case-id="select_with_case_expression">
        <assertion expected-data-file="select_with_case_expression.xml" />
    </dql-test-case>
</integrate-test-cases>
