hcq/oceanbase
1
0
Fork 0
Code Issues Pull Requests Actions 1 Packages Projects Releases Wiki Activity
Files
develop
oceanbase/unittest/sql/rewrite/test_query_range_collation.result
pe-99y 5c5e6da6ce [FEAT MERGE] DAS iterator refactor and keep order optimization 
Co-authored-by: saltonz <saltonzh@gmail.com>
Co-authored-by: zhenhan.gong@gmail.com <zhenhan.gong@gmail.com>
Co-authored-by: Tyshawn <tuyunshan@gmail.com>
2024-06-24 13:57:14 +00:00

1724 lines
63 KiB
Plaintext
Raw Permalink Blame History

[0] #f in ('a')
[1] f = 'a'
f = 'a'--------------connection_collation = 45 col_type = 45
is not min_to_max_range
ranges.count() = 1
all_single_value_ranges = 1
star_border_flag[0] = 1
end_border_flag[0] = 1
count of rang columns = 1
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,[{"VARCHAR":"a", collation:"utf8mb4_general_ci"};{"VARCHAR":"a", collation:"utf8mb4_general_ci"}]"}]
f = 'a'--------------connection_collation = 45 col_type = 46
is min_to_max_range
ranges.count() = 1
all_single_value_ranges = 0
star_border_flag[0] = 0
end_border_flag[0] = 0
count of rang columns = 1
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,(MIN;MAX)"}]
f = 'a'--------------connection_collation = 45 col_type = 63
is min_to_max_range
ranges.count() = 1
all_single_value_ranges = 0
star_border_flag[0] = 0
end_border_flag[0] = 0
count of rang columns = 1
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,(MIN;MAX)"}]
f = 'a'--------------connection_collation = 46 col_type = 45
is min_to_max_range
ranges.count() = 1
all_single_value_ranges = 0
star_border_flag[0] = 0
end_border_flag[0] = 0
count of rang columns = 1
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,(MIN;MAX)"}]
f = 'a'--------------connection_collation = 46 col_type = 46
is not min_to_max_range
ranges.count() = 1
all_single_value_ranges = 1
star_border_flag[0] = 1
end_border_flag[0] = 1
count of rang columns = 1
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,[{"VARCHAR":"a", collation:"utf8mb4_bin"};{"VARCHAR":"a", collation:"utf8mb4_bin"}]"}]
f = 'a'--------------connection_collation = 46 col_type = 63
is min_to_max_range
ranges.count() = 1
all_single_value_ranges = 0
star_border_flag[0] = 0
end_border_flag[0] = 0
count of rang columns = 1
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,(MIN;MAX)"}]
f = 'a'--------------connection_collation = 63 col_type = 45
is min_to_max_range
ranges.count() = 1
all_single_value_ranges = 0
star_border_flag[0] = 0
end_border_flag[0] = 0
count of rang columns = 1
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,(MIN;MAX)"}]
f = 'a'--------------connection_collation = 63 col_type = 46
is min_to_max_range
ranges.count() = 1
all_single_value_ranges = 0
star_border_flag[0] = 0
end_border_flag[0] = 0
count of rang columns = 1
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,(MIN;MAX)"}]
f = 'a'--------------connection_collation = 63 col_type = 63
is not min_to_max_range
ranges.count() = 1
all_single_value_ranges = 1
star_border_flag[0] = 1
end_border_flag[0] = 1
count of rang columns = 1
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,[{"VARCHAR":"a", collation:"binary"};{"VARCHAR":"a", collation:"binary"}]"}]
[2] f != 'a'
f != 'a'--------------connection_collation = 45 col_type = 45
is not min_to_max_range
ranges.count() = 2
all_single_value_ranges = 0
star_border_flag[0] = 0
end_border_flag[0] = 0
star_border_flag[1] = 0
end_border_flag[1] = 0
count of rang columns = 1
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,({"NULL":"NULL"};{"VARCHAR":"a", collation:"utf8mb4_general_ci"})"}, {"range":"table_id:3003,group_idx:0,index_ordered_idx:0,({"VARCHAR":"a", collation:"utf8mb4_general_ci"};MAX)"}]
f != 'a'--------------connection_collation = 45 col_type = 46
is min_to_max_range
ranges.count() = 1
all_single_value_ranges = 0
star_border_flag[0] = 0
end_border_flag[0] = 0
count of rang columns = 1
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,(MIN;MAX)"}]
f != 'a'--------------connection_collation = 45 col_type = 63
is min_to_max_range
ranges.count() = 1
all_single_value_ranges = 0
star_border_flag[0] = 0
end_border_flag[0] = 0
count of rang columns = 1
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,(MIN;MAX)"}]
f != 'a'--------------connection_collation = 46 col_type = 45
is min_to_max_range
ranges.count() = 1
all_single_value_ranges = 0
star_border_flag[0] = 0
end_border_flag[0] = 0
count of rang columns = 1
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,(MIN;MAX)"}]
f != 'a'--------------connection_collation = 46 col_type = 46
is not min_to_max_range
ranges.count() = 2
all_single_value_ranges = 0
star_border_flag[0] = 0
end_border_flag[0] = 0
star_border_flag[1] = 0
end_border_flag[1] = 0
count of rang columns = 1
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,({"NULL":"NULL"};{"VARCHAR":"a", collation:"utf8mb4_bin"})"}, {"range":"table_id:3003,group_idx:0,index_ordered_idx:0,({"VARCHAR":"a", collation:"utf8mb4_bin"};MAX)"}]
f != 'a'--------------connection_collation = 46 col_type = 63
is min_to_max_range
ranges.count() = 1
all_single_value_ranges = 0
star_border_flag[0] = 0
end_border_flag[0] = 0
count of rang columns = 1
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,(MIN;MAX)"}]
f != 'a'--------------connection_collation = 63 col_type = 45
is min_to_max_range
ranges.count() = 1
all_single_value_ranges = 0
star_border_flag[0] = 0
end_border_flag[0] = 0
count of rang columns = 1
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,(MIN;MAX)"}]
f != 'a'--------------connection_collation = 63 col_type = 46
is min_to_max_range
ranges.count() = 1
all_single_value_ranges = 0
star_border_flag[0] = 0
end_border_flag[0] = 0
count of rang columns = 1
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,(MIN;MAX)"}]
f != 'a'--------------connection_collation = 63 col_type = 63
is not min_to_max_range
ranges.count() = 2
all_single_value_ranges = 0
star_border_flag[0] = 0
end_border_flag[0] = 0
star_border_flag[1] = 0
end_border_flag[1] = 0
count of rang columns = 1
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,({"NULL":"NULL"};{"VARCHAR":"a", collation:"binary"})"}, {"range":"table_id:3003,group_idx:0,index_ordered_idx:0,({"VARCHAR":"a", collation:"binary"};MAX)"}]
[3] f > 'a'
f > 'a'--------------connection_collation = 45 col_type = 45
is not min_to_max_range
ranges.count() = 1
all_single_value_ranges = 0
star_border_flag[0] = 0
end_border_flag[0] = 0
count of rang columns = 1
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,({"VARCHAR":"a", collation:"utf8mb4_general_ci"};MAX)"}]
f > 'a'--------------connection_collation = 45 col_type = 46
is min_to_max_range
ranges.count() = 1
all_single_value_ranges = 0
star_border_flag[0] = 0
end_border_flag[0] = 0
count of rang columns = 1
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,(MIN;MAX)"}]
f > 'a'--------------connection_collation = 45 col_type = 63
is min_to_max_range
ranges.count() = 1
all_single_value_ranges = 0
star_border_flag[0] = 0
end_border_flag[0] = 0
count of rang columns = 1
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,(MIN;MAX)"}]
f > 'a'--------------connection_collation = 46 col_type = 45
is min_to_max_range
ranges.count() = 1
all_single_value_ranges = 0
star_border_flag[0] = 0
end_border_flag[0] = 0
count of rang columns = 1
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,(MIN;MAX)"}]
f > 'a'--------------connection_collation = 46 col_type = 46
is not min_to_max_range
ranges.count() = 1
all_single_value_ranges = 0
star_border_flag[0] = 0
end_border_flag[0] = 0
count of rang columns = 1
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,({"VARCHAR":"a", collation:"utf8mb4_bin"};MAX)"}]
f > 'a'--------------connection_collation = 46 col_type = 63
is min_to_max_range
ranges.count() = 1
all_single_value_ranges = 0
star_border_flag[0] = 0
end_border_flag[0] = 0
count of rang columns = 1
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,(MIN;MAX)"}]
f > 'a'--------------connection_collation = 63 col_type = 45
is min_to_max_range
ranges.count() = 1
all_single_value_ranges = 0
star_border_flag[0] = 0
end_border_flag[0] = 0
count of rang columns = 1
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,(MIN;MAX)"}]
f > 'a'--------------connection_collation = 63 col_type = 46
is min_to_max_range
ranges.count() = 1
all_single_value_ranges = 0
star_border_flag[0] = 0
end_border_flag[0] = 0
count of rang columns = 1
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,(MIN;MAX)"}]
f > 'a'--------------connection_collation = 63 col_type = 63
is not min_to_max_range
ranges.count() = 1
all_single_value_ranges = 0
star_border_flag[0] = 0
end_border_flag[0] = 0
count of rang columns = 1
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,({"VARCHAR":"a", collation:"binary"};MAX)"}]
[4] f < 'a'
f < 'a'--------------connection_collation = 45 col_type = 45
is not min_to_max_range
ranges.count() = 1
all_single_value_ranges = 0
star_border_flag[0] = 0
end_border_flag[0] = 0
count of rang columns = 1
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,({"NULL":"NULL"};{"VARCHAR":"a", collation:"utf8mb4_general_ci"})"}]
f < 'a'--------------connection_collation = 45 col_type = 46
is min_to_max_range
ranges.count() = 1
all_single_value_ranges = 0
star_border_flag[0] = 0
end_border_flag[0] = 0
count of rang columns = 1
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,(MIN;MAX)"}]
f < 'a'--------------connection_collation = 45 col_type = 63
is min_to_max_range
ranges.count() = 1
all_single_value_ranges = 0
star_border_flag[0] = 0
end_border_flag[0] = 0
count of rang columns = 1
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,(MIN;MAX)"}]
f < 'a'--------------connection_collation = 46 col_type = 45
is min_to_max_range
ranges.count() = 1
all_single_value_ranges = 0
star_border_flag[0] = 0
end_border_flag[0] = 0
count of rang columns = 1
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,(MIN;MAX)"}]
f < 'a'--------------connection_collation = 46 col_type = 46
is not min_to_max_range
ranges.count() = 1
all_single_value_ranges = 0
star_border_flag[0] = 0
end_border_flag[0] = 0
count of rang columns = 1
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,({"NULL":"NULL"};{"VARCHAR":"a", collation:"utf8mb4_bin"})"}]
f < 'a'--------------connection_collation = 46 col_type = 63
is min_to_max_range
ranges.count() = 1
all_single_value_ranges = 0
star_border_flag[0] = 0
end_border_flag[0] = 0
count of rang columns = 1
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,(MIN;MAX)"}]
f < 'a'--------------connection_collation = 63 col_type = 45
is min_to_max_range
ranges.count() = 1
all_single_value_ranges = 0
star_border_flag[0] = 0
end_border_flag[0] = 0
count of rang columns = 1
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,(MIN;MAX)"}]
f < 'a'--------------connection_collation = 63 col_type = 46
is min_to_max_range
ranges.count() = 1
all_single_value_ranges = 0
star_border_flag[0] = 0
end_border_flag[0] = 0
count of rang columns = 1
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,(MIN;MAX)"}]
f < 'a'--------------connection_collation = 63 col_type = 63
is not min_to_max_range
ranges.count() = 1
all_single_value_ranges = 0
star_border_flag[0] = 0
end_border_flag[0] = 0
count of rang columns = 1
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,({"NULL":"NULL"};{"VARCHAR":"a", collation:"binary"})"}]
[5] f >= 'a'
f >= 'a'--------------connection_collation = 45 col_type = 45
is not min_to_max_range
ranges.count() = 1
all_single_value_ranges = 0
star_border_flag[0] = 1
end_border_flag[0] = 0
count of rang columns = 1
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,[{"VARCHAR":"a", collation:"utf8mb4_general_ci"};MAX)"}]
f >= 'a'--------------connection_collation = 45 col_type = 46
is min_to_max_range
ranges.count() = 1
all_single_value_ranges = 0
star_border_flag[0] = 0
end_border_flag[0] = 0
count of rang columns = 1
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,(MIN;MAX)"}]
f >= 'a'--------------connection_collation = 45 col_type = 63
is min_to_max_range
ranges.count() = 1
all_single_value_ranges = 0
star_border_flag[0] = 0
end_border_flag[0] = 0
count of rang columns = 1
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,(MIN;MAX)"}]
f >= 'a'--------------connection_collation = 46 col_type = 45
is min_to_max_range
ranges.count() = 1
all_single_value_ranges = 0
star_border_flag[0] = 0
end_border_flag[0] = 0
count of rang columns = 1
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,(MIN;MAX)"}]
f >= 'a'--------------connection_collation = 46 col_type = 46
is not min_to_max_range
ranges.count() = 1
all_single_value_ranges = 0
star_border_flag[0] = 1
end_border_flag[0] = 0
count of rang columns = 1
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,[{"VARCHAR":"a", collation:"utf8mb4_bin"};MAX)"}]
f >= 'a'--------------connection_collation = 46 col_type = 63
is min_to_max_range
ranges.count() = 1
all_single_value_ranges = 0
star_border_flag[0] = 0
end_border_flag[0] = 0
count of rang columns = 1
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,(MIN;MAX)"}]
f >= 'a'--------------connection_collation = 63 col_type = 45
is min_to_max_range
ranges.count() = 1
all_single_value_ranges = 0
star_border_flag[0] = 0
end_border_flag[0] = 0
count of rang columns = 1
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,(MIN;MAX)"}]
f >= 'a'--------------connection_collation = 63 col_type = 46
is min_to_max_range
ranges.count() = 1
all_single_value_ranges = 0
star_border_flag[0] = 0
end_border_flag[0] = 0
count of rang columns = 1
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,(MIN;MAX)"}]
f >= 'a'--------------connection_collation = 63 col_type = 63
is not min_to_max_range
ranges.count() = 1
all_single_value_ranges = 0
star_border_flag[0] = 1
end_border_flag[0] = 0
count of rang columns = 1
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,[{"VARCHAR":"a", collation:"binary"};MAX)"}]
[6] f <= 'a'
f <= 'a'--------------connection_collation = 45 col_type = 45
is not min_to_max_range
ranges.count() = 1
all_single_value_ranges = 0
star_border_flag[0] = 0
end_border_flag[0] = 1
count of rang columns = 1
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,({"NULL":"NULL"};{"VARCHAR":"a", collation:"utf8mb4_general_ci"}]"}]
f <= 'a'--------------connection_collation = 45 col_type = 46
is min_to_max_range
ranges.count() = 1
all_single_value_ranges = 0
star_border_flag[0] = 0
end_border_flag[0] = 0
count of rang columns = 1
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,(MIN;MAX)"}]
f <= 'a'--------------connection_collation = 45 col_type = 63
is min_to_max_range
ranges.count() = 1
all_single_value_ranges = 0
star_border_flag[0] = 0
end_border_flag[0] = 0
count of rang columns = 1
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,(MIN;MAX)"}]
f <= 'a'--------------connection_collation = 46 col_type = 45
is min_to_max_range
ranges.count() = 1
all_single_value_ranges = 0
star_border_flag[0] = 0
end_border_flag[0] = 0
count of rang columns = 1
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,(MIN;MAX)"}]
f <= 'a'--------------connection_collation = 46 col_type = 46
is not min_to_max_range
ranges.count() = 1
all_single_value_ranges = 0
star_border_flag[0] = 0
end_border_flag[0] = 1
count of rang columns = 1
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,({"NULL":"NULL"};{"VARCHAR":"a", collation:"utf8mb4_bin"}]"}]
f <= 'a'--------------connection_collation = 46 col_type = 63
is min_to_max_range
ranges.count() = 1
all_single_value_ranges = 0
star_border_flag[0] = 0
end_border_flag[0] = 0
count of rang columns = 1
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,(MIN;MAX)"}]
f <= 'a'--------------connection_collation = 63 col_type = 45
is min_to_max_range
ranges.count() = 1
all_single_value_ranges = 0
star_border_flag[0] = 0
end_border_flag[0] = 0
count of rang columns = 1
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,(MIN;MAX)"}]
f <= 'a'--------------connection_collation = 63 col_type = 46
is min_to_max_range
ranges.count() = 1
all_single_value_ranges = 0
star_border_flag[0] = 0
end_border_flag[0] = 0
count of rang columns = 1
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,(MIN;MAX)"}]
f <= 'a'--------------connection_collation = 63 col_type = 63
is not min_to_max_range
ranges.count() = 1
all_single_value_ranges = 0
star_border_flag[0] = 0
end_border_flag[0] = 1
count of rang columns = 1
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,({"NULL":"NULL"};{"VARCHAR":"a", collation:"binary"}]"}]
[7] f is TRUE
f is TRUE--------------connection_collation = 45 col_type = 45
is min_to_max_range
ranges.count() = 1
all_single_value_ranges = 0
star_border_flag[0] = 0
end_border_flag[0] = 0
count of rang columns = 1
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,(MIN;MAX)"}]
f is TRUE--------------connection_collation = 45 col_type = 46
is min_to_max_range
ranges.count() = 1
all_single_value_ranges = 0
star_border_flag[0] = 0
end_border_flag[0] = 0
count of rang columns = 1
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,(MIN;MAX)"}]
f is TRUE--------------connection_collation = 45 col_type = 63
is min_to_max_range
ranges.count() = 1
all_single_value_ranges = 0
star_border_flag[0] = 0
end_border_flag[0] = 0
count of rang columns = 1
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,(MIN;MAX)"}]
f is TRUE--------------connection_collation = 46 col_type = 45
is min_to_max_range
ranges.count() = 1
all_single_value_ranges = 0
star_border_flag[0] = 0
end_border_flag[0] = 0
count of rang columns = 1
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,(MIN;MAX)"}]
f is TRUE--------------connection_collation = 46 col_type = 46
is min_to_max_range
ranges.count() = 1
all_single_value_ranges = 0
star_border_flag[0] = 0
end_border_flag[0] = 0
count of rang columns = 1
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,(MIN;MAX)"}]
f is TRUE--------------connection_collation = 46 col_type = 63
is min_to_max_range
ranges.count() = 1
all_single_value_ranges = 0
star_border_flag[0] = 0
end_border_flag[0] = 0
count of rang columns = 1
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,(MIN;MAX)"}]
f is TRUE--------------connection_collation = 63 col_type = 45
is min_to_max_range
ranges.count() = 1
all_single_value_ranges = 0
star_border_flag[0] = 0
end_border_flag[0] = 0
count of rang columns = 1
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,(MIN;MAX)"}]
f is TRUE--------------connection_collation = 63 col_type = 46
is min_to_max_range
ranges.count() = 1
all_single_value_ranges = 0
star_border_flag[0] = 0
end_border_flag[0] = 0
count of rang columns = 1
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,(MIN;MAX)"}]
f is TRUE--------------connection_collation = 63 col_type = 63
is min_to_max_range
ranges.count() = 1
all_single_value_ranges = 0
star_border_flag[0] = 0
end_border_flag[0] = 0
count of rang columns = 1
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,(MIN;MAX)"}]
[8] f is FALSE
f is FALSE--------------connection_collation = 45 col_type = 45
is min_to_max_range
ranges.count() = 1
all_single_value_ranges = 0
star_border_flag[0] = 0
end_border_flag[0] = 0
count of rang columns = 1
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,(MIN;MAX)"}]
f is FALSE--------------connection_collation = 45 col_type = 46
is min_to_max_range
ranges.count() = 1
all_single_value_ranges = 0
star_border_flag[0] = 0
end_border_flag[0] = 0
count of rang columns = 1
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,(MIN;MAX)"}]
f is FALSE--------------connection_collation = 45 col_type = 63
is min_to_max_range
ranges.count() = 1
all_single_value_ranges = 0
star_border_flag[0] = 0
end_border_flag[0] = 0
count of rang columns = 1
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,(MIN;MAX)"}]
f is FALSE--------------connection_collation = 46 col_type = 45
is min_to_max_range
ranges.count() = 1
all_single_value_ranges = 0
star_border_flag[0] = 0
end_border_flag[0] = 0
count of rang columns = 1
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,(MIN;MAX)"}]
f is FALSE--------------connection_collation = 46 col_type = 46
is min_to_max_range
ranges.count() = 1
all_single_value_ranges = 0
star_border_flag[0] = 0
end_border_flag[0] = 0
count of rang columns = 1
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,(MIN;MAX)"}]
f is FALSE--------------connection_collation = 46 col_type = 63
is min_to_max_range
ranges.count() = 1
all_single_value_ranges = 0
star_border_flag[0] = 0
end_border_flag[0] = 0
count of rang columns = 1
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,(MIN;MAX)"}]
f is FALSE--------------connection_collation = 63 col_type = 45
is min_to_max_range
ranges.count() = 1
all_single_value_ranges = 0
star_border_flag[0] = 0
end_border_flag[0] = 0
count of rang columns = 1
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,(MIN;MAX)"}]
f is FALSE--------------connection_collation = 63 col_type = 46
is min_to_max_range
ranges.count() = 1
all_single_value_ranges = 0
star_border_flag[0] = 0
end_border_flag[0] = 0
count of rang columns = 1
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,(MIN;MAX)"}]
f is FALSE--------------connection_collation = 63 col_type = 63
is min_to_max_range
ranges.count() = 1
all_single_value_ranges = 0
star_border_flag[0] = 0
end_border_flag[0] = 0
count of rang columns = 1
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,(MIN;MAX)"}]
[9] f is NULL
f is NULL--------------connection_collation = 45 col_type = 45
is not min_to_max_range
ranges.count() = 1
all_single_value_ranges = 1
star_border_flag[0] = 1
end_border_flag[0] = 1
count of rang columns = 1
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,[{"NULL":"NULL"};{"NULL":"NULL"}]"}]
f is NULL--------------connection_collation = 45 col_type = 46
is not min_to_max_range
ranges.count() = 1
all_single_value_ranges = 1
star_border_flag[0] = 1
end_border_flag[0] = 1
count of rang columns = 1
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,[{"NULL":"NULL"};{"NULL":"NULL"}]"}]
f is NULL--------------connection_collation = 45 col_type = 63
is not min_to_max_range
ranges.count() = 1
all_single_value_ranges = 1
star_border_flag[0] = 1
end_border_flag[0] = 1
count of rang columns = 1
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,[{"NULL":"NULL"};{"NULL":"NULL"}]"}]
f is NULL--------------connection_collation = 46 col_type = 45
is not min_to_max_range
ranges.count() = 1
all_single_value_ranges = 1
star_border_flag[0] = 1
end_border_flag[0] = 1
count of rang columns = 1
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,[{"NULL":"NULL"};{"NULL":"NULL"}]"}]
f is NULL--------------connection_collation = 46 col_type = 46
is not min_to_max_range
ranges.count() = 1
all_single_value_ranges = 1
star_border_flag[0] = 1
end_border_flag[0] = 1
count of rang columns = 1
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,[{"NULL":"NULL"};{"NULL":"NULL"}]"}]
f is NULL--------------connection_collation = 46 col_type = 63
is not min_to_max_range
ranges.count() = 1
all_single_value_ranges = 1
star_border_flag[0] = 1
end_border_flag[0] = 1
count of rang columns = 1
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,[{"NULL":"NULL"};{"NULL":"NULL"}]"}]
f is NULL--------------connection_collation = 63 col_type = 45
is not min_to_max_range
ranges.count() = 1
all_single_value_ranges = 1
star_border_flag[0] = 1
end_border_flag[0] = 1
count of rang columns = 1
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,[{"NULL":"NULL"};{"NULL":"NULL"}]"}]
f is NULL--------------connection_collation = 63 col_type = 46
is not min_to_max_range
ranges.count() = 1
all_single_value_ranges = 1
star_border_flag[0] = 1
end_border_flag[0] = 1
count of rang columns = 1
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,[{"NULL":"NULL"};{"NULL":"NULL"}]"}]
f is NULL--------------connection_collation = 63 col_type = 63
is not min_to_max_range
ranges.count() = 1
all_single_value_ranges = 1
star_border_flag[0] = 1
end_border_flag[0] = 1
count of rang columns = 1
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,[{"NULL":"NULL"};{"NULL":"NULL"}]"}]
[10] f > 'a' and false
f > 'a' and false--------------connection_collation = 45 col_type = 45
is not min_to_max_range
ranges.count() = 1
all_single_value_ranges = 0
star_border_flag[0] = 0
end_border_flag[0] = 0
count of rang columns = 1
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,({"VARCHAR":"a", collation:"utf8mb4_general_ci"};MAX)"}]
f > 'a' and false--------------connection_collation = 45 col_type = 46
is min_to_max_range
ranges.count() = 1
all_single_value_ranges = 0
star_border_flag[0] = 0
end_border_flag[0] = 0
count of rang columns = 1
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,(MIN;MAX)"}]
f > 'a' and false--------------connection_collation = 45 col_type = 63
is min_to_max_range
ranges.count() = 1
all_single_value_ranges = 0
star_border_flag[0] = 0
end_border_flag[0] = 0
count of rang columns = 1
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,(MIN;MAX)"}]
f > 'a' and false--------------connection_collation = 46 col_type = 45
is min_to_max_range
ranges.count() = 1
all_single_value_ranges = 0
star_border_flag[0] = 0
end_border_flag[0] = 0
count of rang columns = 1
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,(MIN;MAX)"}]
f > 'a' and false--------------connection_collation = 46 col_type = 46
is not min_to_max_range
ranges.count() = 1
all_single_value_ranges = 0
star_border_flag[0] = 0
end_border_flag[0] = 0
count of rang columns = 1
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,({"VARCHAR":"a", collation:"utf8mb4_bin"};MAX)"}]
f > 'a' and false--------------connection_collation = 46 col_type = 63
is min_to_max_range
ranges.count() = 1
all_single_value_ranges = 0
star_border_flag[0] = 0
end_border_flag[0] = 0
count of rang columns = 1
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,(MIN;MAX)"}]
f > 'a' and false--------------connection_collation = 63 col_type = 45
is min_to_max_range
ranges.count() = 1
all_single_value_ranges = 0
star_border_flag[0] = 0
end_border_flag[0] = 0
count of rang columns = 1
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,(MIN;MAX)"}]
f > 'a' and false--------------connection_collation = 63 col_type = 46
is min_to_max_range
ranges.count() = 1
all_single_value_ranges = 0
star_border_flag[0] = 0
end_border_flag[0] = 0
count of rang columns = 1
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,(MIN;MAX)"}]
f > 'a' and false--------------connection_collation = 63 col_type = 63
is not min_to_max_range
ranges.count() = 1
all_single_value_ranges = 0
star_border_flag[0] = 0
end_border_flag[0] = 0
count of rang columns = 1
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,({"VARCHAR":"a", collation:"binary"};MAX)"}]
[11] false and f > 'a'
false and f > 'a'--------------connection_collation = 45 col_type = 45
is not min_to_max_range
ranges.count() = 1
all_single_value_ranges = 0
star_border_flag[0] = 0
end_border_flag[0] = 0
count of rang columns = 1
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,({"VARCHAR":"a", collation:"utf8mb4_general_ci"};MAX)"}]
false and f > 'a'--------------connection_collation = 45 col_type = 46
is min_to_max_range
ranges.count() = 1
all_single_value_ranges = 0
star_border_flag[0] = 0
end_border_flag[0] = 0
count of rang columns = 1
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,(MIN;MAX)"}]
false and f > 'a'--------------connection_collation = 45 col_type = 63
is min_to_max_range
ranges.count() = 1
all_single_value_ranges = 0
star_border_flag[0] = 0
end_border_flag[0] = 0
count of rang columns = 1
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,(MIN;MAX)"}]
false and f > 'a'--------------connection_collation = 46 col_type = 45
is min_to_max_range
ranges.count() = 1
all_single_value_ranges = 0
star_border_flag[0] = 0
end_border_flag[0] = 0
count of rang columns = 1
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,(MIN;MAX)"}]
false and f > 'a'--------------connection_collation = 46 col_type = 46
is not min_to_max_range
ranges.count() = 1
all_single_value_ranges = 0
star_border_flag[0] = 0
end_border_flag[0] = 0
count of rang columns = 1
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,({"VARCHAR":"a", collation:"utf8mb4_bin"};MAX)"}]
false and f > 'a'--------------connection_collation = 46 col_type = 63
is min_to_max_range
ranges.count() = 1
all_single_value_ranges = 0
star_border_flag[0] = 0
end_border_flag[0] = 0
count of rang columns = 1
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,(MIN;MAX)"}]
false and f > 'a'--------------connection_collation = 63 col_type = 45
is min_to_max_range
ranges.count() = 1
all_single_value_ranges = 0
star_border_flag[0] = 0
end_border_flag[0] = 0
count of rang columns = 1
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,(MIN;MAX)"}]
false and f > 'a'--------------connection_collation = 63 col_type = 46
is min_to_max_range
ranges.count() = 1
all_single_value_ranges = 0
star_border_flag[0] = 0
end_border_flag[0] = 0
count of rang columns = 1
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,(MIN;MAX)"}]
false and f > 'a'--------------connection_collation = 63 col_type = 63
is not min_to_max_range
ranges.count() = 1
all_single_value_ranges = 0
star_border_flag[0] = 0
end_border_flag[0] = 0
count of rang columns = 1
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,({"VARCHAR":"a", collation:"binary"};MAX)"}]
[12] f < 'a' or f > 'b' or f > 'sda' and f > 'sds' or f = 'adas'
f < 'a' or f > 'b' or f > 'sda' and f > 'sds' or f = 'adas'--------------connection_collation = 45 col_type = 45
is not min_to_max_range
ranges.count() = 3
all_single_value_ranges = 0
star_border_flag[0] = 0
end_border_flag[0] = 0
star_border_flag[1] = 0
end_border_flag[1] = 0
star_border_flag[2] = 1
end_border_flag[2] = 1
count of rang columns = 1
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,({"NULL":"NULL"};{"VARCHAR":"a", collation:"utf8mb4_general_ci"})"}, {"range":"table_id:3003,group_idx:0,index_ordered_idx:0,({"VARCHAR":"b", collation:"utf8mb4_general_ci"};MAX)"}, {"range":"table_id:3003,group_idx:0,index_ordered_idx:0,[{"VARCHAR":"adas", collation:"utf8mb4_general_ci"};{"VARCHAR":"adas", collation:"utf8mb4_general_ci"}]"}]
f < 'a' or f > 'b' or f > 'sda' and f > 'sds' or f = 'adas'--------------connection_collation = 45 col_type = 46
is min_to_max_range
ranges.count() = 1
all_single_value_ranges = 0
star_border_flag[0] = 0
end_border_flag[0] = 0
count of rang columns = 1
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,(MIN;MAX)"}]
f < 'a' or f > 'b' or f > 'sda' and f > 'sds' or f = 'adas'--------------connection_collation = 45 col_type = 63
is min_to_max_range
ranges.count() = 1
all_single_value_ranges = 0
star_border_flag[0] = 0
end_border_flag[0] = 0
count of rang columns = 1
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,(MIN;MAX)"}]
f < 'a' or f > 'b' or f > 'sda' and f > 'sds' or f = 'adas'--------------connection_collation = 46 col_type = 45
is min_to_max_range
ranges.count() = 1
all_single_value_ranges = 0
star_border_flag[0] = 0
end_border_flag[0] = 0
count of rang columns = 1
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,(MIN;MAX)"}]
f < 'a' or f > 'b' or f > 'sda' and f > 'sds' or f = 'adas'--------------connection_collation = 46 col_type = 46
is not min_to_max_range
ranges.count() = 3
all_single_value_ranges = 0
star_border_flag[0] = 0
end_border_flag[0] = 0
star_border_flag[1] = 0
end_border_flag[1] = 0
star_border_flag[2] = 1
end_border_flag[2] = 1
count of rang columns = 1
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,({"NULL":"NULL"};{"VARCHAR":"a", collation:"utf8mb4_bin"})"}, {"range":"table_id:3003,group_idx:0,index_ordered_idx:0,({"VARCHAR":"b", collation:"utf8mb4_bin"};MAX)"}, {"range":"table_id:3003,group_idx:0,index_ordered_idx:0,[{"VARCHAR":"adas", collation:"utf8mb4_bin"};{"VARCHAR":"adas", collation:"utf8mb4_bin"}]"}]
f < 'a' or f > 'b' or f > 'sda' and f > 'sds' or f = 'adas'--------------connection_collation = 46 col_type = 63
is min_to_max_range
ranges.count() = 1
all_single_value_ranges = 0
star_border_flag[0] = 0
end_border_flag[0] = 0
count of rang columns = 1
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,(MIN;MAX)"}]
f < 'a' or f > 'b' or f > 'sda' and f > 'sds' or f = 'adas'--------------connection_collation = 63 col_type = 45
is min_to_max_range
ranges.count() = 1
all_single_value_ranges = 0
star_border_flag[0] = 0
end_border_flag[0] = 0
count of rang columns = 1
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,(MIN;MAX)"}]
f < 'a' or f > 'b' or f > 'sda' and f > 'sds' or f = 'adas'--------------connection_collation = 63 col_type = 46
is min_to_max_range
ranges.count() = 1
all_single_value_ranges = 0
star_border_flag[0] = 0
end_border_flag[0] = 0
count of rang columns = 1
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,(MIN;MAX)"}]
f < 'a' or f > 'b' or f > 'sda' and f > 'sds' or f = 'adas'--------------connection_collation = 63 col_type = 63
is not min_to_max_range
ranges.count() = 3
all_single_value_ranges = 0
star_border_flag[0] = 0
end_border_flag[0] = 0
star_border_flag[1] = 0
end_border_flag[1] = 0
star_border_flag[2] = 1
end_border_flag[2] = 1
count of rang columns = 1
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,({"NULL":"NULL"};{"VARCHAR":"a", collation:"binary"})"}, {"range":"table_id:3003,group_idx:0,index_ordered_idx:0,({"VARCHAR":"b", collation:"binary"};MAX)"}, {"range":"table_id:3003,group_idx:0,index_ordered_idx:0,[{"VARCHAR":"adas", collation:"binary"};{"VARCHAR":"adas", collation:"binary"}]"}]
[13] f > 'a' or f > 'b' and (g > 'a' or g > 'k') and (f > 'c')
f > 'a' or f > 'b' and (g > 'a' or g > 'k') and (f > 'c')--------------connection_collation = 45 col_type = 45
is not min_to_max_range
ranges.count() = 1
all_single_value_ranges = 0
star_border_flag[0] = 0
end_border_flag[0] = 0
count of rang columns = 2
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,({"VARCHAR":"a", collation:"utf8mb4_general_ci"},MAX;MAX,MAX)"}]
f > 'a' or f > 'b' and (g > 'a' or g > 'k') and (f > 'c')--------------connection_collation = 45 col_type = 46
is min_to_max_range
ranges.count() = 1
all_single_value_ranges = 0
star_border_flag[0] = 0
end_border_flag[0] = 0
count of rang columns = 2
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,(MIN,MIN;MAX,MAX)"}]
f > 'a' or f > 'b' and (g > 'a' or g > 'k') and (f > 'c')--------------connection_collation = 45 col_type = 63
is min_to_max_range
ranges.count() = 1
all_single_value_ranges = 0
star_border_flag[0] = 0
end_border_flag[0] = 0
count of rang columns = 2
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,(MIN,MIN;MAX,MAX)"}]
f > 'a' or f > 'b' and (g > 'a' or g > 'k') and (f > 'c')--------------connection_collation = 46 col_type = 45
is min_to_max_range
ranges.count() = 1
all_single_value_ranges = 0
star_border_flag[0] = 0
end_border_flag[0] = 0
count of rang columns = 2
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,(MIN,MIN;MAX,MAX)"}]
f > 'a' or f > 'b' and (g > 'a' or g > 'k') and (f > 'c')--------------connection_collation = 46 col_type = 46
is not min_to_max_range
ranges.count() = 1
all_single_value_ranges = 0
star_border_flag[0] = 0
end_border_flag[0] = 0
count of rang columns = 2
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,({"VARCHAR":"a", collation:"utf8mb4_bin"},MAX;MAX,MAX)"}]
f > 'a' or f > 'b' and (g > 'a' or g > 'k') and (f > 'c')--------------connection_collation = 46 col_type = 63
is min_to_max_range
ranges.count() = 1
all_single_value_ranges = 0
star_border_flag[0] = 0
end_border_flag[0] = 0
count of rang columns = 2
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,(MIN,MIN;MAX,MAX)"}]
f > 'a' or f > 'b' and (g > 'a' or g > 'k') and (f > 'c')--------------connection_collation = 63 col_type = 45
is min_to_max_range
ranges.count() = 1
all_single_value_ranges = 0
star_border_flag[0] = 0
end_border_flag[0] = 0
count of rang columns = 2
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,(MIN,MIN;MAX,MAX)"}]
f > 'a' or f > 'b' and (g > 'a' or g > 'k') and (f > 'c')--------------connection_collation = 63 col_type = 46
is min_to_max_range
ranges.count() = 1
all_single_value_ranges = 0
star_border_flag[0] = 0
end_border_flag[0] = 0
count of rang columns = 2
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,(MIN,MIN;MAX,MAX)"}]
f > 'a' or f > 'b' and (g > 'a' or g > 'k') and (f > 'c')--------------connection_collation = 63 col_type = 63
is not min_to_max_range
ranges.count() = 1
all_single_value_ranges = 0
star_border_flag[0] = 0
end_border_flag[0] = 0
count of rang columns = 2
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,({"VARCHAR":"a", collation:"binary"},MAX;MAX,MAX)"}]
[14] f > 'a' and g > 'a' and h > 'a' and i > 'a' and j > 'a'
f > 'a' and g > 'a' and h > 'a' and i > 'a' and j > 'a'--------------connection_collation = 45 col_type = 45
is not min_to_max_range
ranges.count() = 1
all_single_value_ranges = 0
star_border_flag[0] = 0
end_border_flag[0] = 0
count of rang columns = 5
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,({"VARCHAR":"a", collation:"utf8mb4_general_ci"},MAX,MAX,MAX,MAX;MAX,MAX,MAX,MAX,MAX)"}]
f > 'a' and g > 'a' and h > 'a' and i > 'a' and j > 'a'--------------connection_collation = 45 col_type = 46
is min_to_max_range
ranges.count() = 1
all_single_value_ranges = 0
star_border_flag[0] = 0
end_border_flag[0] = 0
count of rang columns = 5
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,(MIN,MIN,MIN,MIN,MIN;MAX,MAX,MAX,MAX,MAX)"}]
f > 'a' and g > 'a' and h > 'a' and i > 'a' and j > 'a'--------------connection_collation = 45 col_type = 63
is min_to_max_range
ranges.count() = 1
all_single_value_ranges = 0
star_border_flag[0] = 0
end_border_flag[0] = 0
count of rang columns = 5
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,(MIN,MIN,MIN,MIN,MIN;MAX,MAX,MAX,MAX,MAX)"}]
f > 'a' and g > 'a' and h > 'a' and i > 'a' and j > 'a'--------------connection_collation = 46 col_type = 45
is min_to_max_range
ranges.count() = 1
all_single_value_ranges = 0
star_border_flag[0] = 0
end_border_flag[0] = 0
count of rang columns = 5
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,(MIN,MIN,MIN,MIN,MIN;MAX,MAX,MAX,MAX,MAX)"}]
f > 'a' and g > 'a' and h > 'a' and i > 'a' and j > 'a'--------------connection_collation = 46 col_type = 46
is not min_to_max_range
ranges.count() = 1
all_single_value_ranges = 0
star_border_flag[0] = 0
end_border_flag[0] = 0
count of rang columns = 5
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,({"VARCHAR":"a", collation:"utf8mb4_bin"},MAX,MAX,MAX,MAX;MAX,MAX,MAX,MAX,MAX)"}]
f > 'a' and g > 'a' and h > 'a' and i > 'a' and j > 'a'--------------connection_collation = 46 col_type = 63
is min_to_max_range
ranges.count() = 1
all_single_value_ranges = 0
star_border_flag[0] = 0
end_border_flag[0] = 0
count of rang columns = 5
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,(MIN,MIN,MIN,MIN,MIN;MAX,MAX,MAX,MAX,MAX)"}]
f > 'a' and g > 'a' and h > 'a' and i > 'a' and j > 'a'--------------connection_collation = 63 col_type = 45
is min_to_max_range
ranges.count() = 1
all_single_value_ranges = 0
star_border_flag[0] = 0
end_border_flag[0] = 0
count of rang columns = 5
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,(MIN,MIN,MIN,MIN,MIN;MAX,MAX,MAX,MAX,MAX)"}]
f > 'a' and g > 'a' and h > 'a' and i > 'a' and j > 'a'--------------connection_collation = 63 col_type = 46
is min_to_max_range
ranges.count() = 1
all_single_value_ranges = 0
star_border_flag[0] = 0
end_border_flag[0] = 0
count of rang columns = 5
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,(MIN,MIN,MIN,MIN,MIN;MAX,MAX,MAX,MAX,MAX)"}]
f > 'a' and g > 'a' and h > 'a' and i > 'a' and j > 'a'--------------connection_collation = 63 col_type = 63
is not min_to_max_range
ranges.count() = 1
all_single_value_ranges = 0
star_border_flag[0] = 0
end_border_flag[0] = 0
count of rang columns = 5
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,({"VARCHAR":"a", collation:"binary"},MAX,MAX,MAX,MAX;MAX,MAX,MAX,MAX,MAX)"}]
[15] f > 'a' and f < 'B'
f > 'a' and f < 'B' --------------connection_collation = 45 col_type = 45
is not min_to_max_range
ranges.count() = 1
all_single_value_ranges = 0
star_border_flag[0] = 0
end_border_flag[0] = 0
count of rang columns = 1
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,({"VARCHAR":"a", collation:"utf8mb4_general_ci"};{"VARCHAR":"B", collation:"utf8mb4_general_ci"})"}]
f > 'a' and f < 'B' --------------connection_collation = 45 col_type = 46
is min_to_max_range
ranges.count() = 1
all_single_value_ranges = 0
star_border_flag[0] = 0
end_border_flag[0] = 0
count of rang columns = 1
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,(MIN;MAX)"}]
f > 'a' and f < 'B' --------------connection_collation = 45 col_type = 63
is min_to_max_range
ranges.count() = 1
all_single_value_ranges = 0
star_border_flag[0] = 0
end_border_flag[0] = 0
count of rang columns = 1
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,(MIN;MAX)"}]
f > 'a' and f < 'B' --------------connection_collation = 46 col_type = 45
is min_to_max_range
ranges.count() = 1
all_single_value_ranges = 0
star_border_flag[0] = 0
end_border_flag[0] = 0
count of rang columns = 1
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,(MIN;MAX)"}]
f > 'a' and f < 'B' --------------connection_collation = 46 col_type = 46
is not min_to_max_range
ranges.count() = 1
all_single_value_ranges = 0
star_border_flag[0] = 0
end_border_flag[0] = 0
count of rang columns = 1
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,(MAX;MIN)"}]
f > 'a' and f < 'B' --------------connection_collation = 46 col_type = 63
is min_to_max_range
ranges.count() = 1
all_single_value_ranges = 0
star_border_flag[0] = 0
end_border_flag[0] = 0
count of rang columns = 1
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,(MIN;MAX)"}]
f > 'a' and f < 'B' --------------connection_collation = 63 col_type = 45
is min_to_max_range
ranges.count() = 1
all_single_value_ranges = 0
star_border_flag[0] = 0
end_border_flag[0] = 0
count of rang columns = 1
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,(MIN;MAX)"}]
f > 'a' and f < 'B' --------------connection_collation = 63 col_type = 46
is min_to_max_range
ranges.count() = 1
all_single_value_ranges = 0
star_border_flag[0] = 0
end_border_flag[0] = 0
count of rang columns = 1
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,(MIN;MAX)"}]
f > 'a' and f < 'B' --------------connection_collation = 63 col_type = 63
is not min_to_max_range
ranges.count() = 1
all_single_value_ranges = 0
star_border_flag[0] = 0
end_border_flag[0] = 0
count of rang columns = 1
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,(MAX;MIN)"}]
[16] f > 'B' and f < 'a' and g > 'a' and g < 'b'
f > 'B' and f < 'a' and g > 'a' and g < 'b'--------------connection_collation = 45 col_type = 45
is not min_to_max_range
ranges.count() = 1
all_single_value_ranges = 0
star_border_flag[0] = 0
end_border_flag[0] = 0
count of rang columns = 2
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,(MAX,MAX;MIN,MIN)"}]
f > 'B' and f < 'a' and g > 'a' and g < 'b'--------------connection_collation = 45 col_type = 46
is min_to_max_range
ranges.count() = 1
all_single_value_ranges = 0
star_border_flag[0] = 0
end_border_flag[0] = 0
count of rang columns = 2
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,(MIN,MIN;MAX,MAX)"}]
f > 'B' and f < 'a' and g > 'a' and g < 'b'--------------connection_collation = 45 col_type = 63
is min_to_max_range
ranges.count() = 1
all_single_value_ranges = 0
star_border_flag[0] = 0
end_border_flag[0] = 0
count of rang columns = 2
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,(MIN,MIN;MAX,MAX)"}]
f > 'B' and f < 'a' and g > 'a' and g < 'b'--------------connection_collation = 46 col_type = 45
is min_to_max_range
ranges.count() = 1
all_single_value_ranges = 0
star_border_flag[0] = 0
end_border_flag[0] = 0
count of rang columns = 2
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,(MIN,MIN;MAX,MAX)"}]
f > 'B' and f < 'a' and g > 'a' and g < 'b'--------------connection_collation = 46 col_type = 46
is not min_to_max_range
ranges.count() = 1
all_single_value_ranges = 0
star_border_flag[0] = 0
end_border_flag[0] = 0
count of rang columns = 2
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,({"VARCHAR":"B", collation:"utf8mb4_bin"},MAX;{"VARCHAR":"a", collation:"utf8mb4_bin"},MIN)"}]
f > 'B' and f < 'a' and g > 'a' and g < 'b'--------------connection_collation = 46 col_type = 63
is min_to_max_range
ranges.count() = 1
all_single_value_ranges = 0
star_border_flag[0] = 0
end_border_flag[0] = 0
count of rang columns = 2
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,(MIN,MIN;MAX,MAX)"}]
f > 'B' and f < 'a' and g > 'a' and g < 'b'--------------connection_collation = 63 col_type = 45
is min_to_max_range
ranges.count() = 1
all_single_value_ranges = 0
star_border_flag[0] = 0
end_border_flag[0] = 0
count of rang columns = 2
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,(MIN,MIN;MAX,MAX)"}]
f > 'B' and f < 'a' and g > 'a' and g < 'b'--------------connection_collation = 63 col_type = 46
is min_to_max_range
ranges.count() = 1
all_single_value_ranges = 0
star_border_flag[0] = 0
end_border_flag[0] = 0
count of rang columns = 2
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,(MIN,MIN;MAX,MAX)"}]
f > 'B' and f < 'a' and g > 'a' and g < 'b'--------------connection_collation = 63 col_type = 63
is not min_to_max_range
ranges.count() = 1
all_single_value_ranges = 0
star_border_flag[0] = 0
end_border_flag[0] = 0
count of rang columns = 2
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,({"VARCHAR":"B", collation:"binary"},MAX;{"VARCHAR":"a", collation:"binary"},MIN)"}]
[17] f > 'B' or f < 'a' and g > 'a' or g < 'b'
f > 'B' or f < 'a' and g > 'a' or g < 'b'--------------connection_collation = 45 col_type = 45
is min_to_max_range
ranges.count() = 1
all_single_value_ranges = 0
star_border_flag[0] = 0
end_border_flag[0] = 0
count of rang columns = 2
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,(MIN,MIN;MAX,MAX)"}]
f > 'B' or f < 'a' and g > 'a' or g < 'b'--------------connection_collation = 45 col_type = 46
is min_to_max_range
ranges.count() = 1
all_single_value_ranges = 0
star_border_flag[0] = 0
end_border_flag[0] = 0
count of rang columns = 2
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,(MIN,MIN;MAX,MAX)"}]
f > 'B' or f < 'a' and g > 'a' or g < 'b'--------------connection_collation = 45 col_type = 63
is min_to_max_range
ranges.count() = 1
all_single_value_ranges = 0
star_border_flag[0] = 0
end_border_flag[0] = 0
count of rang columns = 2
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,(MIN,MIN;MAX,MAX)"}]
f > 'B' or f < 'a' and g > 'a' or g < 'b'--------------connection_collation = 46 col_type = 45
is min_to_max_range
ranges.count() = 1
all_single_value_ranges = 0
star_border_flag[0] = 0
end_border_flag[0] = 0
count of rang columns = 2
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,(MIN,MIN;MAX,MAX)"}]
f > 'B' or f < 'a' and g > 'a' or g < 'b'--------------connection_collation = 46 col_type = 46
is min_to_max_range
ranges.count() = 1
all_single_value_ranges = 0
star_border_flag[0] = 0
end_border_flag[0] = 0
count of rang columns = 2
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,(MIN,MIN;MAX,MAX)"}]
f > 'B' or f < 'a' and g > 'a' or g < 'b'--------------connection_collation = 46 col_type = 63
is min_to_max_range
ranges.count() = 1
all_single_value_ranges = 0
star_border_flag[0] = 0
end_border_flag[0] = 0
count of rang columns = 2
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,(MIN,MIN;MAX,MAX)"}]
f > 'B' or f < 'a' and g > 'a' or g < 'b'--------------connection_collation = 63 col_type = 45
is min_to_max_range
ranges.count() = 1
all_single_value_ranges = 0
star_border_flag[0] = 0
end_border_flag[0] = 0
count of rang columns = 2
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,(MIN,MIN;MAX,MAX)"}]
f > 'B' or f < 'a' and g > 'a' or g < 'b'--------------connection_collation = 63 col_type = 46
is min_to_max_range
ranges.count() = 1
all_single_value_ranges = 0
star_border_flag[0] = 0
end_border_flag[0] = 0
count of rang columns = 2
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,(MIN,MIN;MAX,MAX)"}]
f > 'B' or f < 'a' and g > 'a' or g < 'b'--------------connection_collation = 63 col_type = 63
is min_to_max_range
ranges.count() = 1
all_single_value_ranges = 0
star_border_flag[0] = 0
end_border_flag[0] = 0
count of rang columns = 2
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,(MIN,MIN;MAX,MAX)"}]
[18] f > 'B' and f < 'a' and g > 'a' and g < 'B'
f > 'B' and f < 'a' and g > 'a' and g < 'B'--------------connection_collation = 45 col_type = 45
is not min_to_max_range
ranges.count() = 1
all_single_value_ranges = 0
star_border_flag[0] = 0
end_border_flag[0] = 0
count of rang columns = 2
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,(MAX,MAX;MIN,MIN)"}]
f > 'B' and f < 'a' and g > 'a' and g < 'B'--------------connection_collation = 45 col_type = 46
is min_to_max_range
ranges.count() = 1
all_single_value_ranges = 0
star_border_flag[0] = 0
end_border_flag[0] = 0
count of rang columns = 2
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,(MIN,MIN;MAX,MAX)"}]
f > 'B' and f < 'a' and g > 'a' and g < 'B'--------------connection_collation = 45 col_type = 63
is min_to_max_range
ranges.count() = 1
all_single_value_ranges = 0
star_border_flag[0] = 0
end_border_flag[0] = 0
count of rang columns = 2
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,(MIN,MIN;MAX,MAX)"}]
f > 'B' and f < 'a' and g > 'a' and g < 'B'--------------connection_collation = 46 col_type = 45
is min_to_max_range
ranges.count() = 1
all_single_value_ranges = 0
star_border_flag[0] = 0
end_border_flag[0] = 0
count of rang columns = 2
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,(MIN,MIN;MAX,MAX)"}]
f > 'B' and f < 'a' and g > 'a' and g < 'B'--------------connection_collation = 46 col_type = 46
is not min_to_max_range
ranges.count() = 1
all_single_value_ranges = 0
star_border_flag[0] = 0
end_border_flag[0] = 0
count of rang columns = 2
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,(MAX,MAX;MIN,MIN)"}]
f > 'B' and f < 'a' and g > 'a' and g < 'B'--------------connection_collation = 46 col_type = 63
is min_to_max_range
ranges.count() = 1
all_single_value_ranges = 0
star_border_flag[0] = 0
end_border_flag[0] = 0
count of rang columns = 2
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,(MIN,MIN;MAX,MAX)"}]
f > 'B' and f < 'a' and g > 'a' and g < 'B'--------------connection_collation = 63 col_type = 45
is min_to_max_range
ranges.count() = 1
all_single_value_ranges = 0
star_border_flag[0] = 0
end_border_flag[0] = 0
count of rang columns = 2
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,(MIN,MIN;MAX,MAX)"}]
f > 'B' and f < 'a' and g > 'a' and g < 'B'--------------connection_collation = 63 col_type = 46
is min_to_max_range
ranges.count() = 1
all_single_value_ranges = 0
star_border_flag[0] = 0
end_border_flag[0] = 0
count of rang columns = 2
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,(MIN,MIN;MAX,MAX)"}]
f > 'B' and f < 'a' and g > 'a' and g < 'B'--------------connection_collation = 63 col_type = 63
is not min_to_max_range
ranges.count() = 1
all_single_value_ranges = 0
star_border_flag[0] = 0
end_border_flag[0] = 0
count of rang columns = 2
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,(MAX,MAX;MIN,MIN)"}]
[19] f > 'B' and 'a' = 'A'
f > 'B' and 'a' = 'A'--------------connection_collation = 45 col_type = 45
is not min_to_max_range
ranges.count() = 1
all_single_value_ranges = 0
star_border_flag[0] = 0
end_border_flag[0] = 0
count of rang columns = 1
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,({"VARCHAR":"B", collation:"utf8mb4_general_ci"};MAX)"}]
f > 'B' and 'a' = 'A'--------------connection_collation = 45 col_type = 46
is min_to_max_range
ranges.count() = 1
all_single_value_ranges = 0
star_border_flag[0] = 0
end_border_flag[0] = 0
count of rang columns = 1
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,(MIN;MAX)"}]
f > 'B' and 'a' = 'A'--------------connection_collation = 45 col_type = 63
is min_to_max_range
ranges.count() = 1
all_single_value_ranges = 0
star_border_flag[0] = 0
end_border_flag[0] = 0
count of rang columns = 1
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,(MIN;MAX)"}]
f > 'B' and 'a' = 'A'--------------connection_collation = 46 col_type = 45
is min_to_max_range
ranges.count() = 1
all_single_value_ranges = 0
star_border_flag[0] = 0
end_border_flag[0] = 0
count of rang columns = 1
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,(MIN;MAX)"}]
f > 'B' and 'a' = 'A'--------------connection_collation = 46 col_type = 46
is not min_to_max_range
ranges.count() = 1
all_single_value_ranges = 0
star_border_flag[0] = 0
end_border_flag[0] = 0
count of rang columns = 1
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,({"VARCHAR":"B", collation:"utf8mb4_bin"};MAX)"}]
f > 'B' and 'a' = 'A'--------------connection_collation = 46 col_type = 63
is min_to_max_range
ranges.count() = 1
all_single_value_ranges = 0
star_border_flag[0] = 0
end_border_flag[0] = 0
count of rang columns = 1
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,(MIN;MAX)"}]
f > 'B' and 'a' = 'A'--------------connection_collation = 63 col_type = 45
is min_to_max_range
ranges.count() = 1
all_single_value_ranges = 0
star_border_flag[0] = 0
end_border_flag[0] = 0
count of rang columns = 1
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,(MIN;MAX)"}]
f > 'B' and 'a' = 'A'--------------connection_collation = 63 col_type = 46
is min_to_max_range
ranges.count() = 1
all_single_value_ranges = 0
star_border_flag[0] = 0
end_border_flag[0] = 0
count of rang columns = 1
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,(MIN;MAX)"}]
f > 'B' and 'a' = 'A'--------------connection_collation = 63 col_type = 63
is not min_to_max_range
ranges.count() = 1
all_single_value_ranges = 0
star_border_flag[0] = 0
end_border_flag[0] = 0
count of rang columns = 1
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,({"VARCHAR":"B", collation:"binary"};MAX)"}]
[20] #(f, g) in (('a', 'b'), ('B', 'A'))
[21] #(f, g) > ('a', 'b') and (f, g) < ('B', 'A')
[22] f between 'a' and 'b'
f between 'a' and 'b'--------------connection_collation = 45 col_type = 45
is not min_to_max_range
ranges.count() = 1
all_single_value_ranges = 0
star_border_flag[0] = 1
end_border_flag[0] = 1
count of rang columns = 1
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,[{"VARCHAR":"a", collation:"utf8mb4_general_ci"};{"VARCHAR":"b", collation:"utf8mb4_general_ci"}]"}]
f between 'a' and 'b'--------------connection_collation = 45 col_type = 46
is min_to_max_range
ranges.count() = 1
all_single_value_ranges = 0
star_border_flag[0] = 0
end_border_flag[0] = 0
count of rang columns = 1
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,(MIN;MAX)"}]
f between 'a' and 'b'--------------connection_collation = 45 col_type = 63
is min_to_max_range
ranges.count() = 1
all_single_value_ranges = 0
star_border_flag[0] = 0
end_border_flag[0] = 0
count of rang columns = 1
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,(MIN;MAX)"}]
f between 'a' and 'b'--------------connection_collation = 46 col_type = 45
is min_to_max_range
ranges.count() = 1
all_single_value_ranges = 0
star_border_flag[0] = 0
end_border_flag[0] = 0
count of rang columns = 1
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,(MIN;MAX)"}]
f between 'a' and 'b'--------------connection_collation = 46 col_type = 46
is not min_to_max_range
ranges.count() = 1
all_single_value_ranges = 0
star_border_flag[0] = 1
end_border_flag[0] = 1
count of rang columns = 1
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,[{"VARCHAR":"a", collation:"utf8mb4_bin"};{"VARCHAR":"b", collation:"utf8mb4_bin"}]"}]
f between 'a' and 'b'--------------connection_collation = 46 col_type = 63
is min_to_max_range
ranges.count() = 1
all_single_value_ranges = 0
star_border_flag[0] = 0
end_border_flag[0] = 0
count of rang columns = 1
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,(MIN;MAX)"}]
f between 'a' and 'b'--------------connection_collation = 63 col_type = 45
is min_to_max_range
ranges.count() = 1
all_single_value_ranges = 0
star_border_flag[0] = 0
end_border_flag[0] = 0
count of rang columns = 1
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,(MIN;MAX)"}]
f between 'a' and 'b'--------------connection_collation = 63 col_type = 46
is min_to_max_range
ranges.count() = 1
all_single_value_ranges = 0
star_border_flag[0] = 0
end_border_flag[0] = 0
count of rang columns = 1
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,(MIN;MAX)"}]
f between 'a' and 'b'--------------connection_collation = 63 col_type = 63
is not min_to_max_range
ranges.count() = 1
all_single_value_ranges = 0
star_border_flag[0] = 1
end_border_flag[0] = 1
count of rang columns = 1
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,[{"VARCHAR":"a", collation:"binary"};{"VARCHAR":"b", collation:"binary"}]"}]
[23] f between 'B' and 'a'
f between 'B' and 'a'--------------connection_collation = 45 col_type = 45
is not min_to_max_range
ranges.count() = 1
all_single_value_ranges = 0
star_border_flag[0] = 0
end_border_flag[0] = 0
count of rang columns = 1
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,(MAX;MIN)"}]
f between 'B' and 'a'--------------connection_collation = 45 col_type = 46
is min_to_max_range
ranges.count() = 1
all_single_value_ranges = 0
star_border_flag[0] = 0
end_border_flag[0] = 0
count of rang columns = 1
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,(MIN;MAX)"}]
f between 'B' and 'a'--------------connection_collation = 45 col_type = 63
is min_to_max_range
ranges.count() = 1
all_single_value_ranges = 0
star_border_flag[0] = 0
end_border_flag[0] = 0
count of rang columns = 1
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,(MIN;MAX)"}]
f between 'B' and 'a'--------------connection_collation = 46 col_type = 45
is min_to_max_range
ranges.count() = 1
all_single_value_ranges = 0
star_border_flag[0] = 0
end_border_flag[0] = 0
count of rang columns = 1
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,(MIN;MAX)"}]
f between 'B' and 'a'--------------connection_collation = 46 col_type = 46
is not min_to_max_range
ranges.count() = 1
all_single_value_ranges = 0
star_border_flag[0] = 1
end_border_flag[0] = 1
count of rang columns = 1
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,[{"VARCHAR":"B", collation:"utf8mb4_bin"};{"VARCHAR":"a", collation:"utf8mb4_bin"}]"}]
f between 'B' and 'a'--------------connection_collation = 46 col_type = 63
is min_to_max_range
ranges.count() = 1
all_single_value_ranges = 0
star_border_flag[0] = 0
end_border_flag[0] = 0
count of rang columns = 1
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,(MIN;MAX)"}]
f between 'B' and 'a'--------------connection_collation = 63 col_type = 45
is min_to_max_range
ranges.count() = 1
all_single_value_ranges = 0
star_border_flag[0] = 0
end_border_flag[0] = 0
count of rang columns = 1
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,(MIN;MAX)"}]
f between 'B' and 'a'--------------connection_collation = 63 col_type = 46
is min_to_max_range
ranges.count() = 1
all_single_value_ranges = 0
star_border_flag[0] = 0
end_border_flag[0] = 0
count of rang columns = 1
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,(MIN;MAX)"}]
f between 'B' and 'a'--------------connection_collation = 63 col_type = 63
is not min_to_max_range
ranges.count() = 1
all_single_value_ranges = 0
star_border_flag[0] = 1
end_border_flag[0] = 1
count of rang columns = 1
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,[{"VARCHAR":"B", collation:"binary"};{"VARCHAR":"a", collation:"binary"}]"}]
[24] f not between 'a' and 'b'
f not between 'a' and 'b'--------------connection_collation = 45 col_type = 45
is min_to_max_range
ranges.count() = 1
all_single_value_ranges = 0
star_border_flag[0] = 0
end_border_flag[0] = 0
count of rang columns = 1
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,(MIN;MAX)"}]
f not between 'a' and 'b'--------------connection_collation = 45 col_type = 46
is min_to_max_range
ranges.count() = 1
all_single_value_ranges = 0
star_border_flag[0] = 0
end_border_flag[0] = 0
count of rang columns = 1
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,(MIN;MAX)"}]
f not between 'a' and 'b'--------------connection_collation = 45 col_type = 63
is min_to_max_range
ranges.count() = 1
all_single_value_ranges = 0
star_border_flag[0] = 0
end_border_flag[0] = 0
count of rang columns = 1
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,(MIN;MAX)"}]
f not between 'a' and 'b'--------------connection_collation = 46 col_type = 45
is min_to_max_range
ranges.count() = 1
all_single_value_ranges = 0
star_border_flag[0] = 0
end_border_flag[0] = 0
count of rang columns = 1
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,(MIN;MAX)"}]
f not between 'a' and 'b'--------------connection_collation = 46 col_type = 46
is min_to_max_range
ranges.count() = 1
all_single_value_ranges = 0
star_border_flag[0] = 0
end_border_flag[0] = 0
count of rang columns = 1
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,(MIN;MAX)"}]
f not between 'a' and 'b'--------------connection_collation = 46 col_type = 63
is min_to_max_range
ranges.count() = 1
all_single_value_ranges = 0
star_border_flag[0] = 0
end_border_flag[0] = 0
count of rang columns = 1
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,(MIN;MAX)"}]
f not between 'a' and 'b'--------------connection_collation = 63 col_type = 45
is min_to_max_range
ranges.count() = 1
all_single_value_ranges = 0
star_border_flag[0] = 0
end_border_flag[0] = 0
count of rang columns = 1
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,(MIN;MAX)"}]
f not between 'a' and 'b'--------------connection_collation = 63 col_type = 46
is min_to_max_range
ranges.count() = 1
all_single_value_ranges = 0
star_border_flag[0] = 0
end_border_flag[0] = 0
count of rang columns = 1
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,(MIN;MAX)"}]
f not between 'a' and 'b'--------------connection_collation = 63 col_type = 63
is min_to_max_range
ranges.count() = 1
all_single_value_ranges = 0
star_border_flag[0] = 0
end_border_flag[0] = 0
count of rang columns = 1
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,(MIN;MAX)"}]
[25] f = 'a' + 'b'
f = 'a' + 'b'--------------connection_collation = 45 col_type = 45
is min_to_max_range
ranges.count() = 1
all_single_value_ranges = 0
star_border_flag[0] = 0
end_border_flag[0] = 0
count of rang columns = 1
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,(MIN;MAX)"}]
f = 'a' + 'b'--------------connection_collation = 45 col_type = 46
is min_to_max_range
ranges.count() = 1
all_single_value_ranges = 0
star_border_flag[0] = 0
end_border_flag[0] = 0
count of rang columns = 1
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,(MIN;MAX)"}]
f = 'a' + 'b'--------------connection_collation = 45 col_type = 63
is min_to_max_range
ranges.count() = 1
all_single_value_ranges = 0
star_border_flag[0] = 0
end_border_flag[0] = 0
count of rang columns = 1
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,(MIN;MAX)"}]
f = 'a' + 'b'--------------connection_collation = 46 col_type = 45
is min_to_max_range
ranges.count() = 1
all_single_value_ranges = 0
star_border_flag[0] = 0
end_border_flag[0] = 0
count of rang columns = 1
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,(MIN;MAX)"}]
f = 'a' + 'b'--------------connection_collation = 46 col_type = 46
is min_to_max_range
ranges.count() = 1
all_single_value_ranges = 0
star_border_flag[0] = 0
end_border_flag[0] = 0
count of rang columns = 1
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,(MIN;MAX)"}]
f = 'a' + 'b'--------------connection_collation = 46 col_type = 63
is min_to_max_range
ranges.count() = 1
all_single_value_ranges = 0
star_border_flag[0] = 0
end_border_flag[0] = 0
count of rang columns = 1
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,(MIN;MAX)"}]
f = 'a' + 'b'--------------connection_collation = 63 col_type = 45
is min_to_max_range
ranges.count() = 1
all_single_value_ranges = 0
star_border_flag[0] = 0
end_border_flag[0] = 0
count of rang columns = 1
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,(MIN;MAX)"}]
f = 'a' + 'b'--------------connection_collation = 63 col_type = 46
is min_to_max_range
ranges.count() = 1
all_single_value_ranges = 0
star_border_flag[0] = 0
end_border_flag[0] = 0
count of rang columns = 1
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,(MIN;MAX)"}]
f = 'a' + 'b'--------------connection_collation = 63 col_type = 63
is min_to_max_range
ranges.count() = 1
all_single_value_ranges = 0
star_border_flag[0] = 0
end_border_flag[0] = 0
count of rang columns = 1
[{"range":"table_id:3003,group_idx:0,index_ordered_idx:0,(MIN;MAX)"}]
Reference in New Issue View Git Blame Copy Permalink