* rename SetAssignmentsSegment to SetAssignmentSegment

* add ColumnAssert

* refactor ExpressionAssert

* add expected assignment

* add SetAssignmentAssert

* fix case for update_equal_with_geography

* fix case for update_with_alias

* fix case for update_without_alias

* fix case for update_with_extra_keywords

* fix case for update_with_or

* fix case for update_with_special_character

* fix case for update_with_special_comments

* fix case for update_without_condition

* fix case for update_without_parameters

* for code style

* remove table check in public assert

* add where assert for delete and update

* fix table assert for alter table

* fix test case for delete_with_alias

* fix test case for delete_with_sharding_value

* fix test case for delete_with_special_character_without_sharding_value

* fix test case for delete_with_special_comments_return_without_sharding_value

* fix test case for delete_with_special_comments_returning_without_sharding_value

* fix test case for delete_without_sharding_value

* fix test case for update_equal_with_geography

* fix test case for update_with_alias

* fix test case for update_with_extra_keywords

* fix test case for update_with_or

* fix test case for update_with_special_character

* fix test case for update_with_special_comments

* fix test case for update_without_alias

* fix test case for update_without_parameters

* fix test case for update_with_special_character

* remove zero parameter-marker-start-index

* add segment and statement package for assert

* rename SQLStatementAssertMessage to SQLCaseAssertMessage

* remove sql case type for assert

* rename SQLCaseAssertMessage to SQLCaseAssertContext

* add SelectStatementAssert

* add InsertStatementAssert

* add UpdateStatementAssert

* add DeleteStatementAssert

* add AlterTableStatementAssert

* add TCLStatementAssert

* refactor orderby package

* extends AbstractExpectedSQLSegment for ExpectedPaginationValue

* add more assertion with limit

* fix test case for select_group_by_with_limit

* fix test case for select_group_by_with_order_by_and_limit

* fix test case for select_pagination_with_diff_group_by_and_order_by

* fix test case for select_pagination_with_group_by_and_order_by

* fix test case for select_pagination_with_limit_and_offset_keyword

* fix test case for select_pagination_with_limit_with_back_quotes

* fix test case for select_pagination_with_offset

* fix test case for select_pagination_with_offset_and_limit

* fix test case for select_pagination_with_row_count

* add OrderByItemAssert

* add more assertions for order by

* rename ExpectedGroupBy to ExpectedOrderBy

* fix test case for select_comparison_symbol_with_single_table

* fix test case for select_distinct_with_count_group_by

* fix test case for select_distinct_with_multi_column

* fix test case for select_distinct_with_owner_column

* fix test case for select_distinct_with_owner_star

* fix test case for select_distinct_with_single_count_group_by

* fix test case for select_distinct_with_star

* fix test case for select_exclamation_equal_with_single_table

* fix test case for select_full_route_with_binding_tables

* fix test case for select_distinct_with_owner_star

* fix test case for select_group_by_with_avg

* fix test case for select_group_by_with_count

* fix test case for select_group_by_with_count_without_column_name

* fix test case for select_group_by_with_limit

* fix test case for select_group_by_with_max

* fix test case for select_group_by_with_min

* fix test case for select_group_by_with_order_by_and_limit

* fix test case for select_group_by_with_order_by_desc

* fix test case for select_group_by_with_sum

* fix test case for select_in_with_same_sharding_column

* fix test case for select_in_with_single_table

* fix test case for select_keyword_table_name_with_back_quotes

* fix test case for select_keyword_table_name_with_double_quotes

* fix test case for select_keyword_table_name_with_square_brackets

* fix test case for select_not_between_with_single_table

* fix test case for select_not_equal_with_single_table

* fix test case for select_not_in_with_single_table

* fix test case for select_order_by_asc_and_index_desc

* fix test case for select_order_by_desc_and_index_asc

* fix test case for select_order_by_for_nulls_first

* fix test case for select_order_by_for_nulls_last

* fix test case for select_order_by_with_alias_star_alias_name

* fix test case for select_order_by_with_date

* fix test case for select_order_by_with_multiple_stars

* fix test case for select_order_by_with_ordered_column

* fix test case for select_order_by_with_star_no_table_alias

* fix test case for select_order_by_with_star_table_alias

* fix test case for select_order_by_with_table_star_table_name

* fix test case for select_order_by_with_table_star_without_table_name

* fix test case for select_pagination_with_diff_group_by_and_order_by

* fix test case for select_pagination_with_group_by_and_order_by

* fix test case for select_pagination_with_limit_and_offset_keyword

* fix test case for select_pagination_with_limit_with_back_quotes

* fix test case for select_pagination_with_offset

* fix test case for select_pagination_with_offset_and_limit

* fix test case for select_pagination_with_offset_fetch

* fix test case for select_pagination_with_row_count

* fix test case for select_pagination_with_row_number

* fix test case for select_pagination_with_row_number_for_greater_than

* fix test case for select_pagination_with_row_number_and_diff_group_by_and_order_by

* fix test case for select_pagination_with_row_number_and_group_by_and_order_by

* fix test case for select_pagination_with_row_number_for_greater_than_and_equal

* fix test case for select_pagination_with_row_number_not_at_end

* fix test case for select_pagination_with_top

* fix test case for select_pagination_with_top_and_diff_group_by_and_order_by

* fix test case for select_pagination_with_top_and_diff_group_by_and_order_by_and_parentheses

* fix test case for select_pagination_with_top_and_group_by_and_order_by

* fix test case for select_pagination_with_top_and_group_by_and_order_by_and_parentheses

* fix test case for select_pagination_with_top_for_greater_than

* fix test case for select_pagination_with_top_for_greater_than_and_equal

* fix test case for select_sharding_route_with_binding_tables

* fix test case for select_sharding_route_with_broadcast_table

* fix test case for select_with_date_function

* fix test case for select_with_double_quotes

* fix test case for select_with_expression

* fix test case for select_with_item_alias_match_order_by_and_group_by_items

* remove useless group-by-columns and order-by-columns

* fix test case for select_pagination_with_diff_group_by_and_order_by

* fix test case for select_pagination_with_group_by_and_order_by

* fix test case for select_pagination_with_row_number_and_diff_group_by_and_order_by

* fix test case for select_pagination_with_top_and_diff_group_by_and_order_by

* fix test case for select_pagination_with_top_and_diff_group_by_and_order_by_and_parentheses

* fix test case for select_pagination_with_top_and_group_by_and_order_by

* fix test case for select_pagination_with_top_and_group_by_and_order_by_and_parentheses

* add OwnerAssert

* add todo

* Add more assertion for group by column item

* add assertOrderInfo

* Add more assertion for group by

* fix test case select_distinct_with_count_group_by

* fix test case select_distinct_with_single_count_group_by

* fix test case select_group_by_with_avg

* fix test case select_group_by_with_count

* fix test case select_group_by_with_count_without_column_name

* fix test case select_group_by_with_date_function

* fix test case select_group_by_with_date_function

* add index assertion

* fix test case for select_group_by_with_keyword_alias

* fix test case for select_group_by_with_limit

* fix test case for select_group_by_with_max

* fix test case for select_group_by_with_min

* fix test case for select_group_by_with_order_by_and_limit

* fix test case for select_group_by_with_order_by_desc

* fix test case for select_group_by_with_sum

* fix test case for select_group_by_without_grouped_column

* fix test case for select_pagination_with_group_by_and_order_by

* fix test case for select_pagination_with_row_number_and_diff_group_by_and_order_by

* fix test case for select_pagination_with_row_number_and_group_by_and_order_by

* fix test case for select_pagination_with_top_and_diff_group_by_and_order_by

* fix test case for select_pagination_with_top_and_group_by_and_order_by

* fix test case for select_with_item_alias_match_order_by_and_group_by_items

* refactor SQLStatementAssert's assert group by

* refactor SQLStatementAssert's assert where

* refactor SQLStatementAssert's assert order by

* refactor SQLStatementAssert's assert select

* refactor TableAssert

* add more null assert for SQLStatementAssert

* add more null assert for ProjectionAssert

* add shardingsphere-ui-bin-distribution module

* add shardingsphere-ui-src-distribution module

* add final name for shardingsphere-ui

* assert between predicate

* fix test case for select_between_with_geography

* add null assert

* remove IN operator

* fix test case for select_between_with_single_table

* fix test case for select_count_like_concat

* fix test case for select_count_like_concat

* fix test case for select_count_with_binding_tables_with_join

* fix test case for select_count_tilde_concat

* fix test case for select_count_with_binding_tables_without_join

* fix test case for select_group_by_without_grouped_column

* fix test case for select_keyword_table_name_with_back_quotes

* fix test case for select_keyword_table_name_with_double_quotes

* fix test case for select_keyword_table_name_with_square_brackets

* fix test case for select_pagination_with_diff_group_by_and_order_by

* fix test case for select_pagination_with_group_by_and_order_by

* fix test case for select_pagination_with_limit_and_offset_keyword

* fix test case for select_pagination_with_limit_with_back_quotes

* fix test case for select_pagination_with_offset_and_limit

* fix test case for select_pagination_with_row_count

* fix test case for select_pagination_with_top

* fix test case for select_sharding_route_with_binding_tables

* fix test case for select_sharding_route_with_broadcast_table

* fix all cases

* remove useless condition assert

* add shardingsphere-ui-bin-distribution module

* add shardingsphere-ui-src-distribution module

* add final name for shardingsphere-ui

* assert between predicate

* fix test case for select_between_with_geography

* add null assert

* remove IN operator

* fix test case for select_between_with_single_table

* fix test case for select_count_like_concat

* fix test case for select_count_like_concat

* fix test case for select_count_with_binding_tables_with_join

* fix test case for select_count_tilde_concat

* fix test case for select_count_with_binding_tables_without_join

* fix test case for select_group_by_without_grouped_column

* fix test case for select_keyword_table_name_with_back_quotes

* fix test case for select_keyword_table_name_with_double_quotes

* fix test case for select_keyword_table_name_with_square_brackets

* fix test case for select_pagination_with_diff_group_by_and_order_by

* fix test case for select_pagination_with_group_by_and_order_by

* fix test case for select_pagination_with_limit_and_offset_keyword

* fix test case for select_pagination_with_limit_with_back_quotes

* fix test case for select_pagination_with_offset_and_limit

* fix test case for select_pagination_with_row_count

* fix test case for select_pagination_with_top

* fix test case for select_sharding_route_with_binding_tables

* fix test case for select_sharding_route_with_broadcast_table

* fix all cases

* add shardingsphere-ui-bin-distribution module

* add shardingsphere-ui-src-distribution module

* add final name for shardingsphere-ui

* assert in predicate

* refactor WhereAssert

* fix test case select_count_like_concat

* fix test case select_count_tilde_concat

* fix test case select_count_with_binding_tables_with_join

* fix test case select_count_with_binding_tables_without_join

* fix test case select_group_by_with_date_function

* fix test case select_group_by_without_grouped_column

* fix test case select_in_with_geography

* fix test case select_in_with_same_sharding_column

* fix test case select_in_with_single_table

* fix test case select_keyword_table_name_with_back_quotes

* fix test case select_keyword_table_name_with_double_quotes

* fix test case select_keyword_table_name_with_square_brackets

* fix test case select_pagination_with_diff_group_by_and_order_by

* fix test case select_pagination_with_group_by_and_order_by

* fix test case select_pagination_with_limit_and_offset_keyword

* fix test case select_pagination_with_limit_with_back_quotes

* fix test case select_pagination_with_offset

* fix test case select_pagination_with_offset_and_limit

* fix test case select_pagination_with_row_count

* fix test case select_pagination_with_top

* fix test case select_sharding_route_with_binding_tables

* fix test case select_sharding_route_with_broadcast_table

* fix test case select_with_regexp

* add todo

* add ExpressionAssert

* add shardingsphere-ui-bin-distribution module

* add shardingsphere-ui-src-distribution module

* add final name for shardingsphere-ui

* remove useless assert

* rename param-marker to parameter-marker

* refactor assertCompareRightValue

* refactor ExpectedPredicateCompareRightValue

* refactor ExpectedPredicateBetweenRightValue

* refactor ExpectedPredicateInRightValue

* refactor ExpectedPredicateBetweenRightValue

* remove ExpectedPredicate.findExpectedRightValue()

* add ExpectedOperator

* refactor assert compare predicate for right value

* fix case for select_alias_as_keyword

* fix case for select_alias_as_keyword

* fix case for select_comparison_symbol_with_single_table

* fix case for select_count

* fix case for select_count_with_sub_with_whitespace

* fix case for select_distinct_with_aggregation_functions

* fix case for select_distinct_with_avg

* fix case for select_distinct_with_count

* fix case for select_distinct_with_count_sum

* fix case for select_distinct_with_single_count_group_by

* fix case for select_distinct_with_star

* fix case for select_distinct_with_sum

* fix case for select_equal_with_geography

* fix case for select_equal_with_same_sharding_column

* fix case for select_equal_with_single_table

* fix case for select_escape_with_single_quota

* fix case for select_exclamation_equal_with_single_table

* fix case for select_for_update

* fix case for select_in_with_geography

* fix case for select_inner_join_related_with_alias

* fix case for select_inner_join_related_with_name

* fix case for select_join_using

* fix case for select_keyword_table_name_with_back_quotes

* fix case for select_keyword_table_name_with_double_quotes

* fix case for select_keyword_table_name_with_double_quotes

* fix case for select_keyword_table_name_with_square_brackets

* fix case for select_not_equal_with_single_table

* fix case for select_or_mix_and_for_complex_pattern

* fix case for select_or_mix_and_for_simple_pattern

* fix case for select_or_mix_and_with_binding_and_broadcast_tables

* fix case for select_or_mix_and_with_binding_tables

* fix case for select_or_with_different_sharding_columns

* fix case for select_or_with_none_sharding_columns

* fix case for select_or_with_same_sharding_columns

* fix case for select_order_by_desc_and_index_asc

* fix case for select_order_by_with_date

* fix case for select_pagination_with_row_number

* fix case for select_pagination_with_row_number_and_diff_group_by_and_order_by

* fix case for select_pagination_with_row_number_and_group_by_and_order_by

* fix case for select_pagination_with_row_number_for_greater_than

* fix case for select_pagination_with_row_number_for_greater_than_and_equal

* fix case for select_pagination_with_row_number_not_at_end

* fix case for select_pagination_with_top_and_diff_group_by_and_order_by

* fix case for select_pagination_with_top_and_diff_group_by_and_order_by_and_parentheses

* fix case for select_pagination_with_top_and_group_by_and_order_by

* fix case for select_pagination_with_top_and_group_by_and_order_by_and_parentheses

* fix case for select_pagination_with_top_for_greater_than

* fix case for select_pagination_with_top_for_greater_than_and_equal

* fix case for select_sharding_route_with_broadcast_table

* fix case for select_special_function_nested

* fix case for select_with_block_comment

* fix case for select_with_double_quotes

* fix case for select_with_force_index_join

* fix case for select_with_interval_function

* fix case for select_with_left_function

* fix case for select_with_same_table_name_and_alias

* fix case for select_with_same_table_name_and_alias_column_with_owner

* fix case for select_with_single_comment

* add shardingsphere-ui-bin-distribution module

* add shardingsphere-ui-src-distribution module

* add final name for shardingsphere-ui

* add column-left-value

* fix case select_count_with_binding_tables_without_join

* fix case select_distinct_with_owner_star

* fix case select_escape_with_double_quota

* fix case select_order_by_desc_and_index_asc

* fix case select_order_by_with_date

* add shardingsphere-ui-bin-distribution module

* add shardingsphere-ui-src-distribution module

* add final name for shardingsphere-ui

* fix case for select_between_with_single_table

* refactor select_comparison_symbol_with_single_table

* refactor select_count_like_concat

* refactor select_count_tilde_concat

* refactor select_count_with_binding_tables_with_join

* refactor select_count_with_binding_tables_without_join

* refactor select_count_with_sub

* refactor select_count_with_sub_with_whitespace

* refactor select_distinct_with_aggregation_functions

* refactor select_distinct_with_avg

* fix test case for select_distinct_with_count

* fix test case for select_distinct_with_owner_star

* fix test case for select_distinct_with_star

* fix test case for select_distinct_with_sum

* fix test case for select_equal_with_geography

* fix test case for select_equal_with_same_sharding_column

* fix test case for select_equal_with_same_sharding_column

* fix test case for select_equal_with_single_table

* fix test case for select_escape_with_double_quota

* fix test case for select_escape_with_single_quota

* fix test case for select_exclamation_equal_with_single_table

* fix test case for select_for_update

* fix test case for select_group_by_without_grouped_column

* fix test case for select_in_with_geography

* fix test case for select_in_with_same_sharding_column

* fix test case for select_in_with_single_table

* fix test case for select_inner_join_related_with_alias

* fix test case for select_inner_join_related_with_name

* fix test case for select_join_using

* fix test case for select_keyword_table_name_with_back_quotes

* fix test case for select_keyword_table_name_with_double_quotes

* fix test case for select_keyword_table_name_with_square_brackets

* fix test case for select_not_between_with_single_table

* fix test case for select_not_equal_with_single_table

* fix test case for select_not_equal_with_single_table

* fix test case for select_not_in_with_single_table

* fix test case for select_or_mix_and_for_complex_pattern

* fix test case for select_or_mix_and_for_simple_pattern

* fix test case for select_or_mix_and_with_binding_and_broadcast_tables

* fix test case for select_or_mix_and_with_binding_tables

* fix test case for select_or_with_different_sharding_columns

* fix test case for select_order_by_desc_and_index_asc

* fix test case for select_order_by_with_date

* fix test case for select_pagination_with_diff_group_by_and_order_by

* fix test case for select_pagination_with_group_by_and_order_by

* fix test case for select_pagination_with_limit_and_offset_keyword

* fix test case for select_pagination_with_limit_with_back_quotes

* fix test case for select_pagination_with_offset_and_limit

* fix test case for select_pagination_with_offset

* fix test case for select_pagination_with_row_count

* fix test case for select_pagination_with_row_number

* fix test case for select_pagination_with_row_number_and_diff_group_by_and_order_by

* fix test case for select_pagination_with_row_number_and_group_by_and_order_by

* fix test case for select_pagination_with_row_number_for_greater_than

* fix test case for select_pagination_with_row_number_for_greater_than_and_equal

* fix test case for select_pagination_with_row_number_not_at_end

* fix test case for select_pagination_with_top

* fix test case for select_pagination_with_top_and_diff_group_by_and_order_by

* fix test case for select_pagination_with_top_and_diff_group_by_and_order_by_and_parentheses

* fix test case for select_pagination_with_top_and_group_by_and_order_by

* fix test case for select_pagination_with_top_for_greater_than

* fix test case for select_pagination_with_top_for_greater_than_and_equal

* fix test case for select_sharding_route_with_binding_tables

* fix test case for select_sharding_route_with_broadcast_table

* fix test case for select_special_function_nested

* fix test case for select_with_block_comment

* fix test case for select_with_date_format_function

* fix test case for select_with_double_quotes

* fix test case for select_with_force_index_join

* fix test case for select_with_interval_function

* fix test case for select_with_left_function

* fix test case for select_with_mod_function

* fix test case for select_with_regexp

* fix test case for select_with_row_subquery

* fix test case for select_with_row_subquery_without_row_keyword

* fix test case for select_with_same_table_name_and_alias

* fix test case for select_with_same_table_name_and_alias_column_with_owner

* fix test case for select_with_single_comment

* fix test case for select_with_spatial_function

* skip assert for long sql

* skip long sql

* fix #3929 support range sharding to broadcast sql to all actual tables

* add test config files

* add a property named allow.range.query.with.inline.sharding.

* revert config files and add new parameter

This reverts commit dc20bad32c68d7ab6152c8f4aec4ce978a92c2d6.

* correct spellings

Fix  #4062 to allow more than one proxy server running by start scripts with different config directories. (#4065)

* modify start-script to support proxy config path and jta config file

* add path param to support config path

* rename jta.properties to transactions.properties to fix #4602

* remove pid check in start.sh and add echo statement in start.bat

* fix testcase for ShardingConfigurationLoaderTest and polish codes

* rename a method parameter

* add shardingsphere-ui-bin-distribution module

* add shardingsphere-ui-src-distribution module

* add final name for shardingsphere-ui

* code style for ShardingTableMetaDataLoader.getTableNamesInputGroups

* code style for ShardingTableMetaDataLoader.loadDefaultTables

* pull down instanceDataSourceMap to BaseDCLIT

* refactor BaseIT

* rename BaseIT.shardingRuleType to ruleType

* public for BaseIT.NOT_VERIFY_FLAG

* remove useless fields on IT

* fix IntegrateTestEnvironment.shardingRuleTypes to ruleTypes

* update rule.types

* refactor BaseIT

* Get ciphertext column as a string

* code style

* add shardingsphere-ui-bin-distribution module

* add shardingsphere-ui-src-distribution module

* add final name for shardingsphere-ui

* rename PositionAssert to SQLSegmentAssert

* add package of projection.impl

* move ExpectedTableOwner to owner package

* refactor projection.impl

* add ExpectedTopValue

* move ExpectedSchemaOwner to owner package

* move SQLSegmentAssert to root package

* rename ExpectedSQLSegment

* add shardingsphere-ui-bin-distribution module

* add shardingsphere-ui-src-distribution module

* add final name for shardingsphere-ui

* rename parameterStartIndex to parameterMarkerStartIndex

* rename PredicateAssert to WhereAssert

* refactor WhereAssert.assertAndPredicate()

* rename ExpectedPredicateSegment to ExpectedPredicate

* rename ExpectedColumnSegment to ExpectedColumn

* refactor predicate.value

* refactor WhereAssert.assertColumn

* refactor WhereAssert.assertCompareRightValue

* add literalStartIndex and literalStopIndex

* refactor domain of ExpectedWhere

* fix case for select_alias_as_keyword

* fix case for select_between_with_geography

* add PositionAssert

* mysql date funcation

* Fix log configuration error for none sharding strategy.

* For checkstyle

fixed for #4044

* #4042, Use the two-stage parsing strategy

* #4042, for comments

* docs:Update shardingsphere UI package and Add document description #4026

* docs:Modify path format

* docs:Modify document display format

* fix link of build status

* add jenkinsfile for ui

* add shardingsphere-ui-bin-distribution module

* add shardingsphere-ui-src-distribution module

* add final name for shardingsphere-ui

* remove useless fixme

* rename ExpectedWhereSegment to ExpectedWhere

* rename ExpectedBaseSegment to AbstractExpectedSegment

* move AbstractExpectedSegment to generic package

* extends AbstractExpectedSegment

* extends AbstractExpectedSegment

* add ExpectedSegment

* remove AbstractExpectedProjection

* remove useless ExpectedSchemaSegment

* remove useless @XmlAccessorType(XmlAccessType.FIELD)

* add more expected segment to extends AbstractExpectedSegment

* add ExpectedDelimiterSegment

* move details jaxb to impl package

* add shardingsphere-ui-bin-distribution module

* add shardingsphere-ui-src-distribution module

* add final name for shardingsphere-ui

* add mvnw

* add mvnw notice for ui bin

* add shardingsphere-ui-bin-distribution module

* add shardingsphere-ui-src-distribution module

* add final name for shardingsphere-ui