Linux ip-172-26-2-223 5.4.0-1018-aws #18-Ubuntu SMP Wed Jun 24 01:15:00 UTC 2020 x86_64
Apache
: 172.26.2.223 | : 18.117.73.33
Cant Read [ /etc/named.conf ]
8.1.13
www
www.github.com/MadExploits
Terminal
AUTO ROOT
Adminer
Backdoor Destroyer
Linux Exploit
Lock Shell
Lock File
Create User
CREATE RDP
PHP Mailer
BACKCONNECT
UNLOCK SHELL
HASH IDENTIFIER
CPANEL RESET
CREATE WP USER
BLACK DEFEND!
README
+ Create Folder
+ Create File
/
www /
server /
mysql /
mysql-test /
r /
[ HOME SHELL ]
Name
Size
Permission
Action
1st.result
597
B
-rw-r--r--
acl_tables_errors_debug.result
8.93
KB
-rw-r--r--
alias.result
13.58
KB
-rw-r--r--
almost_full.result
1.11
KB
-rw-r--r--
alter_table-big.result
5.45
KB
-rw-r--r--
alter_table.result
154.41
KB
-rw-r--r--
analyze.result
3.69
KB
-rw-r--r--
ansi.result
1.92
KB
-rw-r--r--
archive-big.result
616
B
-rw-r--r--
archive.result
525.18
KB
-rw-r--r--
archive_bitfield.result
4.26
KB
-rw-r--r--
archive_debug.result
355
B
-rw-r--r--
archive_gis.result
25.98
KB
-rw-r--r--
archive_no_symlink.result
882
B
-rw-r--r--
archive_plugin.result
531
B
-rw-r--r--
archive_symlink.result
2.3
KB
-rw-r--r--
auth_rpl.result
1.85
KB
-rw-r--r--
auto_increment.result
12.11
KB
-rw-r--r--
backup.result
4.29
KB
-rw-r--r--
bench_count_distinct.result
557
B
-rw-r--r--
big_test.require
17
B
-rw-r--r--
bigint.result
23.33
KB
-rw-r--r--
binary.result
6.09
KB
-rw-r--r--
binary_to_hex.result
5.87
KB
-rw-r--r--
binlog_tx_isolation.result
1.71
KB
-rw-r--r--
blackhole.result
613
B
-rw-r--r--
blackhole_plugin.result
565
B
-rw-r--r--
bool.result
2.67
KB
-rw-r--r--
bootstrap.result
525
B
-rw-r--r--
bug12368203.result
2.77
KB
-rw-r--r--
bug12427262.result
1.86
KB
-rw-r--r--
bug12969156.result
952
B
-rw-r--r--
bug17076131.result
322
B
-rw-r--r--
bug33509.result
2.31
KB
-rw-r--r--
bug39022.result
1.2
KB
-rw-r--r--
bug46080.result
669
B
-rw-r--r--
bug46261.result
353
B
-rw-r--r--
bug46760.result
1.26
KB
-rw-r--r--
bug47671.result
287
B
-rw-r--r--
bug58669.result
480
B
-rw-r--r--
bulk_replace.result
281
B
-rw-r--r--
cache_innodb.result
6.96
KB
-rw-r--r--
case.result
10.63
KB
-rw-r--r--
case_insensitive_file_system.r...
46
B
-rw-r--r--
case_sensitive_file_system.req...
47
B
-rw-r--r--
cast.result
16.27
KB
-rw-r--r--
change_user.result
2.82
KB
-rw-r--r--
charset.result
2.14
KB
-rw-r--r--
check.result
2.05
KB
-rw-r--r--
check_auto_permission.result
261
B
-rw-r--r--
check_var_limit.require
8
B
-rw-r--r--
client_xml.result
2.38
KB
-rw-r--r--
comment_column.result
141.21
KB
-rw-r--r--
comment_column2.result
355.68
KB
-rw-r--r--
comment_index.result
173.32
KB
-rw-r--r--
comment_table.result
28.95
KB
-rw-r--r--
comments.result
2.34
KB
-rw-r--r--
commit.result
14.83
KB
-rw-r--r--
commit_1innodb.result
19.59
KB
-rw-r--r--
compare.result
5.07
KB
-rw-r--r--
compress.result
66.24
KB
-rw-r--r--
concurrent_innodb_safelog.resu...
32.01
KB
-rw-r--r--
concurrent_innodb_unsafelog.re...
31.74
KB
-rw-r--r--
condition_filter.result
2.17
KB
-rw-r--r--
connect.result
11.02
KB
-rw-r--r--
connect_debug.result
1.46
KB
-rw-r--r--
consistent_snapshot.result
1.14
KB
-rw-r--r--
constraints.result
2.56
KB
-rw-r--r--
count_distinct.result
8.04
KB
-rw-r--r--
count_distinct2.result
2.21
KB
-rw-r--r--
count_distinct3.result
278
B
-rw-r--r--
create-big.result
7.6
KB
-rw-r--r--
create.result
71.42
KB
-rw-r--r--
create_not_windows.result
961
B
-rw-r--r--
create_select_tmp.result
846
B
-rw-r--r--
create_w_max_indexes_64.result
84.46
KB
-rw-r--r--
csv.result
59.08
KB
-rw-r--r--
csv_alter_table.result
1.17
KB
-rw-r--r--
csv_not_null.result
1.93
KB
-rw-r--r--
ctype_ascii.result
2.5
KB
-rw-r--r--
ctype_big5.result
34.28
KB
-rw-r--r--
ctype_binary.result
82.78
KB
-rw-r--r--
ctype_collate.result
18.3
KB
-rw-r--r--
ctype_cp1250_ch.result
22.29
KB
-rw-r--r--
ctype_cp1251.result
96.48
KB
-rw-r--r--
ctype_cp932.result
996
B
-rw-r--r--
ctype_cp932_binlog_row.result
734
B
-rw-r--r--
ctype_cp932_binlog_stm.result
251.36
KB
-rw-r--r--
ctype_create.result
3.12
KB
-rw-r--r--
ctype_errors.result
1.66
KB
-rw-r--r--
ctype_eucjpms.result
400.48
KB
-rw-r--r--
ctype_euckr.result
435.54
KB
-rw-r--r--
ctype_filename.result
324
B
-rw-r--r--
ctype_filesystem.result
341
B
-rw-r--r--
ctype_gb18030.result
69.33
KB
-rw-r--r--
ctype_gb18030_binlog.result
909
B
-rw-r--r--
ctype_gb18030_conversion.resul...
1.17
MB
-rw-r--r--
ctype_gb18030_encoding_cn.resu...
41.39
KB
-rw-r--r--
ctype_gb18030_encoding_utf8.re...
40.64
KB
-rw-r--r--
ctype_gb18030_ligatures.result
24.81
KB
-rw-r--r--
ctype_gb2312.result
33.73
KB
-rw-r--r--
ctype_gbk.result
50.07
KB
-rw-r--r--
ctype_gbk_binlog.result
633
B
-rw-r--r--
ctype_hebrew.result
254
B
-rw-r--r--
ctype_latin1.result
119.29
KB
-rw-r--r--
ctype_latin1_de.result
15.74
KB
-rw-r--r--
ctype_latin2.result
13.71
KB
-rw-r--r--
ctype_latin2_ch.result
25.11
KB
-rw-r--r--
ctype_ldml.result
28.13
KB
-rw-r--r--
ctype_like_range.result
80.89
KB
-rw-r--r--
ctype_many.result
41.87
KB
-rw-r--r--
ctype_mb.result
2.13
KB
-rw-r--r--
ctype_recoding.result
9.6
KB
-rw-r--r--
ctype_sjis.result
195.81
KB
-rw-r--r--
ctype_tis620.result
101.02
KB
-rw-r--r--
ctype_uca.result
155.4
KB
-rw-r--r--
ctype_ucs.result
143.96
KB
-rw-r--r--
ctype_ucs2_def.result
1.05
KB
-rw-r--r--
ctype_ujis.result
365.3
KB
-rw-r--r--
ctype_ujis_ucs2.result
548.6
KB
-rw-r--r--
ctype_utf16.result
47.3
KB
-rw-r--r--
ctype_utf16_def.result
273
B
-rw-r--r--
ctype_utf16_uca.result
72.47
KB
-rw-r--r--
ctype_utf16le.result
52.96
KB
-rw-r--r--
ctype_utf32.result
50.55
KB
-rw-r--r--
ctype_utf32_uca.result
75.29
KB
-rw-r--r--
ctype_utf8.result
169.69
KB
-rw-r--r--
ctype_utf8mb4.result
83.57
KB
-rw-r--r--
ctype_utf8mb4_heap.result
75.01
KB
-rw-r--r--
ctype_utf8mb4_innodb.result
77.85
KB
-rw-r--r--
ctype_utf8mb4_myisam.result
77.43
KB
-rw-r--r--
ctype_utf8mb4_uca.result
38.82
KB
-rw-r--r--
daemonize_opt.result
14
B
-rw-r--r--
datadir_permission.result
1.09
KB
-rw-r--r--
date_formats.result
28.69
KB
-rw-r--r--
ddl_i18n_koi8r.result
123.56
KB
-rw-r--r--
ddl_i18n_utf8.result
126.58
KB
-rw-r--r--
deadlock_innodb.result
2.35
KB
-rw-r--r--
debug_sync.result
12.18
KB
-rw-r--r--
debug_sync2.result
1.15
KB
-rw-r--r--
default.result
8.17
KB
-rw-r--r--
delete.result
22.7
KB
-rw-r--r--
delete_all_rows.result
2.26
KB
-rw-r--r--
deprecate_eof.result
8
KB
-rw-r--r--
deprecated_features.result
2.03
KB
-rw-r--r--
derived.result
172.18
KB
-rw-r--r--
dirty_close.result
345
B
-rw-r--r--
disabled_replication.result
4.82
KB
-rw-r--r--
disabled_storage_engines.resul...
3.28
KB
-rw-r--r--
disconnect_on_expired_password...
1.42
KB
-rw-r--r--
disconnect_on_expired_password...
1.49
KB
-rw-r--r--
distinct.result
80.43
KB
-rw-r--r--
drop-no_root.result
454
B
-rw-r--r--
drop.result
6.71
KB
-rw-r--r--
drop_debug.result
485
B
-rw-r--r--
ds_mrr-big.result
2.93
KB
-rw-r--r--
dynamic_tracing.result
813
B
-rw-r--r--
empty_table.result
229
B
-rw-r--r--
enable_cleartext_plugin.result
1.4
KB
-rw-r--r--
endspace.result
7.25
KB
-rw-r--r--
eq_range_idx_stat.result
6.56
KB
-rw-r--r--
error_simulation.result
3.17
KB
-rw-r--r--
errors.result
6.11
KB
-rw-r--r--
events_1.result
28.3
KB
-rw-r--r--
events_2.result
17.79
KB
-rw-r--r--
events_and_binlog.result
297
B
-rw-r--r--
events_bugs.result
40.94
KB
-rw-r--r--
events_embedded.result
86
B
-rw-r--r--
events_grant.result
10.33
KB
-rw-r--r--
events_logs_tests.result
2.37
KB
-rw-r--r--
events_microsec.result
810
B
-rw-r--r--
events_restart.result
4.36
KB
-rw-r--r--
events_scheduling.result
3.11
KB
-rw-r--r--
events_stress.result
2.39
KB
-rw-r--r--
events_time_zone.result
5.4
KB
-rw-r--r--
events_trans.result
3.61
KB
-rw-r--r--
events_trans_notembedded.resul...
1.88
KB
-rw-r--r--
examined_rows.result
6.73
KB
-rw-r--r--
execution_constants.result
1.03
KB
-rw-r--r--
explain.result
39.39
KB
-rw-r--r--
explain_for_connection_crash.r...
1004
B
-rw-r--r--
explain_for_connection_rqg_jso...
87.48
KB
-rw-r--r--
explain_for_connection_rqg_tra...
35.98
KB
-rw-r--r--
explain_for_connection_small_j...
25.46
KB
-rw-r--r--
explain_for_connection_small_t...
10.3
KB
-rw-r--r--
explain_json_all.result
98.36
KB
-rw-r--r--
explain_json_none.result
102.18
KB
-rw-r--r--
explain_other.result
42.23
KB
-rw-r--r--
file_contents.result
181
B
-rw-r--r--
filesort_debug.result
4.59
KB
-rw-r--r--
filesort_merge.result
2.02
KB
-rw-r--r--
filesort_pack.result
675
B
-rw-r--r--
filter_single_col_idx_big.resu...
38.05
KB
-rw-r--r--
filter_single_col_idx_small.re...
42.99
KB
-rw-r--r--
fix_priv_tables.result
1.96
KB
-rw-r--r--
flush.result
13.78
KB
-rw-r--r--
flush2.result
1.06
KB
-rw-r--r--
flush_block_commit.result
1.47
KB
-rw-r--r--
flush_block_commit_notembedded...
872
B
-rw-r--r--
flush_read_lock.result
73.94
KB
-rw-r--r--
flush_read_lock_kill.result
1.12
KB
-rw-r--r--
flush_table.result
12.33
KB
-rw-r--r--
foreign_key.result
4.84
KB
-rw-r--r--
fulltext.result
32.93
KB
-rw-r--r--
fulltext2.result
7.54
KB
-rw-r--r--
fulltext3.result
815
B
-rw-r--r--
fulltext_cache.result
2.67
KB
-rw-r--r--
fulltext_distinct.result
1.45
KB
-rw-r--r--
fulltext_left_join.result
4
KB
-rw-r--r--
fulltext_multi.result
766
B
-rw-r--r--
fulltext_order_by.result
6.05
KB
-rw-r--r--
fulltext_plugin.result
229
B
-rw-r--r--
fulltext_update.result
1.11
KB
-rw-r--r--
fulltext_var.result
1.3
KB
-rw-r--r--
func_aes.result
12.97
KB
-rw-r--r--
func_aes_cfb1.result
4.5
KB
-rw-r--r--
func_aes_cfb128.result
4.57
KB
-rw-r--r--
func_aes_cfb8.result
4.5
KB
-rw-r--r--
func_aes_kdf_hkdf.result
3.94
KB
-rw-r--r--
func_aes_kdf_pbkdf2_hmac.resul...
6.79
KB
-rw-r--r--
func_aes_misc.result
8.46
KB
-rw-r--r--
func_aes_ofb.result
4.47
KB
-rw-r--r--
func_analyse.result
23.09
KB
-rw-r--r--
func_bitwise_ops.result
80.6
KB
-rw-r--r--
func_compress.result
5.46
KB
-rw-r--r--
func_concat.result
4.37
KB
-rw-r--r--
func_crypt.result
2.05
KB
-rw-r--r--
func_date_add.result
3.74
KB
-rw-r--r--
func_default.result
1.45
KB
-rw-r--r--
func_des_encrypt.result
2.68
KB
-rw-r--r--
func_digest.result
122.35
KB
-rw-r--r--
func_encrypt.result
19.82
KB
-rw-r--r--
func_encrypt_nossl.result
7.75
KB
-rw-r--r--
func_encrypt_ucs2.result
1.21
KB
-rw-r--r--
func_equal.result
1.27
KB
-rw-r--r--
func_found_rows.result
285
B
-rw-r--r--
func_gconcat.result
49.9
KB
-rw-r--r--
func_group.result
66.46
KB
-rw-r--r--
func_group_innodb.result
6.07
KB
-rw-r--r--
func_group_innodb_16k.result
693
B
-rw-r--r--
func_if.result
6.29
KB
-rw-r--r--
func_in_all.result
49.27
KB
-rw-r--r--
func_in_icp.result
48.91
KB
-rw-r--r--
func_in_icp_mrr.result
49.21
KB
-rw-r--r--
func_in_mrr.result
48.93
KB
-rw-r--r--
func_in_mrr_cost.result
48.65
KB
-rw-r--r--
func_in_none.result
48.6
KB
-rw-r--r--
func_isnull.result
827
B
-rw-r--r--
func_like.result
7.78
KB
-rw-r--r--
func_math.result
42.22
KB
-rw-r--r--
func_misc.result
36.8
KB
-rw-r--r--
func_op.result
2.12
KB
-rw-r--r--
func_regexp.result
4.47
KB
-rw-r--r--
func_rollback.result
13.02
KB
-rw-r--r--
func_sapdb.result
12.49
KB
-rw-r--r--
func_set.result
8.9
KB
-rw-r--r--
func_str.result
174.94
KB
-rw-r--r--
func_str_debug.result
349
B
-rw-r--r--
func_str_no_ps.result
1.3
KB
-rw-r--r--
func_system.result
2.9
KB
-rw-r--r--
func_test.result
14.47
KB
-rw-r--r--
func_time.result
71.47
KB
-rw-r--r--
func_timestamp.result
518
B
-rw-r--r--
func_weight_string.result
11.56
KB
-rw-r--r--
function_defaults.result
109.58
KB
-rw-r--r--
gcc296.result
528
B
-rw-r--r--
get_diagnostics.result
28.42
KB
-rw-r--r--
get_table_share.result
20.56
KB
-rw-r--r--
gis-debug.result
10.1
KB
-rw-r--r--
gis-precise.result
162.17
KB
-rw-r--r--
gis-rt-precise.result
2.42
KB
-rw-r--r--
gis-rtree.result
102.08
KB
-rw-r--r--
gis.result
131.8
KB
-rw-r--r--
grant.result
121.17
KB
-rw-r--r--
grant2.result
36.52
KB
-rw-r--r--
grant3.result
8.41
KB
-rw-r--r--
grant4.result
9.36
KB
-rw-r--r--
grant_alter_user.result
40.96
KB
-rw-r--r--
grant_alter_user_qa.result
98.38
KB
-rw-r--r--
grant_cache.result
6.71
KB
-rw-r--r--
grant_debug.result
8.5
KB
-rw-r--r--
grant_explain_non_select.resul...
10.27
KB
-rw-r--r--
grant_lowercase_fs.result
1.2
KB
-rw-r--r--
grant_user_lock.result
16.9
KB
-rw-r--r--
grant_user_lock_qa.result
41.4
KB
-rw-r--r--
greedy_optimizer.result
632.59
KB
-rw-r--r--
greedy_search.result
31.05
KB
-rw-r--r--
group_by.result
120.07
KB
-rw-r--r--
group_by_fd_no_prot.result
81.15
KB
-rw-r--r--
group_by_fd_ps_prot.result
61.28
KB
-rw-r--r--
group_min_max.result
189.52
KB
-rw-r--r--
group_min_max_innodb.result
25.09
KB
-rw-r--r--
gtid_next_xa_binlog_off.result
30.9
KB
-rw-r--r--
gtids_anonymous_trxs_violation...
687
B
-rw-r--r--
handler_innodb.result
41.58
KB
-rw-r--r--
handler_myisam.result
45.48
KB
-rw-r--r--
handler_read_last.result
1.15
KB
-rw-r--r--
have_big5.require
79
B
-rw-r--r--
have_binlog_format_mixed.requi...
40
B
-rw-r--r--
have_binlog_format_row.require
38
B
-rw-r--r--
have_binlog_format_statement.r...
44
B
-rw-r--r--
have_compress.require
38
B
-rw-r--r--
have_cp1250_ch.require
79
B
-rw-r--r--
have_cp1251.require
84
B
-rw-r--r--
have_cp866.require
82
B
-rw-r--r--
have_cp932.require
83
B
-rw-r--r--
have_crypt.require
35
B
-rw-r--r--
have_debug.require
8
B
-rw-r--r--
have_debug_sync.require
13
B
-rw-r--r--
have_eucjpms.require
87
B
-rw-r--r--
have_euckr.require
81
B
-rw-r--r--
have_gb18030.require
87
B
-rw-r--r--
have_gb2312.require
84
B
-rw-r--r--
have_gbk.require
78
B
-rw-r--r--
have_geometry.require
38
B
-rw-r--r--
have_koi8r.require
81
B
-rw-r--r--
have_latin2_ch.require
78
B
-rw-r--r--
have_local_infile.require
36
B
-rw-r--r--
have_log_bin.require
31
B
-rw-r--r--
have_met_timezone.require
43
B
-rw-r--r--
have_moscow_leap_timezone.requ...
46
B
-rw-r--r--
have_mysql_upgrade.result
21
B
-rw-r--r--
have_ndb_debug.require
17
B
-rw-r--r--
have_ndb_extra.require
14
B
-rw-r--r--
have_ndbapi_examples.require
19
B
-rw-r--r--
have_nodebug.require
8
B
-rw-r--r--
have_optimizer_switch.require
19
B
-rw-r--r--
have_outfile.require
55
B
-rw-r--r--
have_partition.require
42
B
-rw-r--r--
have_perror.require
14
B
-rw-r--r--
have_profiling.require
39
B
-rw-r--r--
have_query_cache.require
41
B
-rw-r--r--
have_sjis.require
81
B
-rw-r--r--
have_ssl.require
33
B
-rw-r--r--
have_ssl_is_yes_or_disabled_on...
43
B
-rw-r--r--
have_statement_timeout.require
47
B
-rw-r--r--
have_symlink.require
37
B
-rw-r--r--
have_tis620.require
81
B
-rw-r--r--
have_ucs2.require
80
B
-rw-r--r--
have_ujis.require
81
B
-rw-r--r--
have_utf16.require
82
B
-rw-r--r--
have_utf32.require
82
B
-rw-r--r--
have_utf8.require
80
B
-rw-r--r--
have_utf8mb4.require
86
B
-rw-r--r--
having.result
24.34
KB
-rw-r--r--
heap.result
24.75
KB
-rw-r--r--
heap_auto_increment.result
894
B
-rw-r--r--
heap_btree.result
11.76
KB
-rw-r--r--
heap_hash.result
20.83
KB
-rw-r--r--
help.result
6.64
KB
-rw-r--r--
help_verbose.result
326
B
-rw-r--r--
host_cache_size_functionality....
3.32
KB
-rw-r--r--
ignore_strict.result
30.82
KB
-rw-r--r--
implicit_char_to_num_conversio...
6.44
KB
-rw-r--r--
implicit_commit.result
18.33
KB
-rw-r--r--
import_schema_mismatch.result
478
B
-rw-r--r--
index_merge_delete.result
25.04
KB
-rw-r--r--
index_merge_innodb.result
124.56
KB
-rw-r--r--
index_merge_insert-and-replace...
14.54
KB
-rw-r--r--
index_merge_intersect_dml.resu...
5.85
KB
-rw-r--r--
index_merge_myisam.result
144.52
KB
-rw-r--r--
index_merge_update.result
17.22
KB
-rw-r--r--
information_schema-big.result
2.81
KB
-rw-r--r--
information_schema.result
107.92
KB
-rw-r--r--
information_schema_chmod.resul...
182
B
-rw-r--r--
information_schema_db.result
9.98
KB
-rw-r--r--
information_schema_inno.result
4.33
KB
-rw-r--r--
information_schema_parameters....
22.49
KB
-rw-r--r--
information_schema_part.result
11.97
KB
-rw-r--r--
information_schema_routines.re...
30.81
KB
-rw-r--r--
init_connect.result
3.57
KB
-rw-r--r--
init_file.result
323
B
-rw-r--r--
initialize-bug20350099.result
1.04
KB
-rw-r--r--
initialize-bug20504142.result
1.17
KB
-rw-r--r--
initialize-bug21335821.result
895
B
-rw-r--r--
initialize-errors.result
578
B
-rw-r--r--
initialize-ignore-db.result
742
B
-rw-r--r--
initialize-init-acls.result
1.12
KB
-rw-r--r--
initialize-sha256.result
1.09
KB
-rw-r--r--
initialize.result
3.89
KB
-rw-r--r--
initialize_gtid.result
465
B
-rw-r--r--
innodb_deadlock.result
1.25
KB
-rw-r--r--
innodb_disabled.result
208
B
-rw-r--r--
innodb_explain_json_non_select...
293.06
KB
-rw-r--r--
innodb_explain_json_non_select...
299.29
KB
-rw-r--r--
innodb_explain_non_select_all....
136.52
KB
-rw-r--r--
innodb_explain_non_select_none...
136.37
KB
-rw-r--r--
innodb_icp.result
32.81
KB
-rw-r--r--
innodb_icp_all.result
32.88
KB
-rw-r--r--
innodb_icp_none.result
32.72
KB
-rw-r--r--
innodb_ignore_builtin.result
354
B
-rw-r--r--
innodb_log_file_size_functiona...
2.79
KB
-rw-r--r--
innodb_mrr.result
25.74
KB
-rw-r--r--
innodb_mrr_all.result
25.88
KB
-rw-r--r--
innodb_mrr_cost.result
25.71
KB
-rw-r--r--
innodb_mrr_cost_all.result
25.85
KB
-rw-r--r--
innodb_mrr_cost_icp.result
25.82
KB
-rw-r--r--
innodb_mrr_icp.result
25.85
KB
-rw-r--r--
innodb_mrr_none.result
25.66
KB
-rw-r--r--
innodb_mysql_lock.result
4.05
KB
-rw-r--r--
innodb_mysql_lock2.result
21.4
KB
-rw-r--r--
innodb_mysql_sync.result
25.87
KB
-rw-r--r--
innodb_pk_extension_off.result
20.33
KB
-rw-r--r--
innodb_pk_extension_on.result
20.58
KB
-rw-r--r--
innodb_recovery_with_upper_cas...
1.21
KB
-rw-r--r--
insert.result
30.75
KB
-rw-r--r--
insert_debug.result
1.29
KB
-rw-r--r--
insert_notembedded.result
5.58
KB
-rw-r--r--
insert_select.result
15.34
KB
-rw-r--r--
insert_update.result
18.89
KB
-rw-r--r--
installdb-bad-cipher.result
128
B
-rw-r--r--
internal_tmp_disk_storage_engi...
146.97
KB
-rw-r--r--
ipv4_as_ipv6.result
23.83
KB
-rw-r--r--
ipv6.result
13.89
KB
-rw-r--r--
is_debug_build.require
32
B
-rw-r--r--
is_deprecation.result
558
B
-rw-r--r--
is_embedded.require
16
B
-rw-r--r--
isam.result
15.65
KB
-rw-r--r--
join.result
55.68
KB
-rw-r--r--
join_cache_bka.result
108.89
KB
-rw-r--r--
join_cache_bka_nixbnl.result
108.17
KB
-rw-r--r--
join_cache_bkaunique.result
109.32
KB
-rw-r--r--
join_cache_bnl.result
107.23
KB
-rw-r--r--
join_cache_nojb.result
106.25
KB
-rw-r--r--
join_crash.result
4.53
KB
-rw-r--r--
join_file_handler.result
1.04
KB
-rw-r--r--
join_nested.result
86.66
KB
-rw-r--r--
join_nested_bka.result
92.75
KB
-rw-r--r--
join_nested_bka_nixbnl.result
89.71
KB
-rw-r--r--
join_optimizer.result
2.54
KB
-rw-r--r--
join_outer.result
96.52
KB
-rw-r--r--
join_outer_bka.result
96.89
KB
-rw-r--r--
join_outer_bka_nixbnl.result
94.69
KB
-rw-r--r--
join_outer_innodb.result
3.27
KB
-rw-r--r--
key.result
22.58
KB
-rw-r--r--
key_cache.result
11.88
KB
-rw-r--r--
key_diff.result
1.15
KB
-rw-r--r--
key_primary.result
890
B
-rw-r--r--
keywords.result
6.63
KB
-rw-r--r--
kill.result
8.88
KB
-rw-r--r--
kill_debug.result
1.58
KB
-rw-r--r--
limit.result
8.31
KB
-rw-r--r--
loaddata.result
20.8
KB
-rw-r--r--
loaddata_autocom_innodb.result
651
B
-rw-r--r--
loadxml.result
2.7
KB
-rw-r--r--
locale.result
5.59
KB
-rw-r--r--
lock.result
14.09
KB
-rw-r--r--
lock_multi.result
63.2
KB
-rw-r--r--
lock_multi_bug38499.result
964
B
-rw-r--r--
lock_multi_bug38691.result
812
B
-rw-r--r--
lock_sync.result
27.44
KB
-rw-r--r--
lock_tables_lost_commit.result
150
B
-rw-r--r--
locking_service.result
31.09
KB
-rw-r--r--
log_errchk.result
663
B
-rw-r--r--
log_state.result
9.66
KB
-rw-r--r--
log_state_bug33693.result
111
B
-rw-r--r--
log_tables-big.result
996
B
-rw-r--r--
log_tables.result
41.81
KB
-rw-r--r--
log_tables_debug.result
770
B
-rw-r--r--
log_tables_upgrade.result
2.35
KB
-rw-r--r--
log_timestamps.result
71
B
-rw-r--r--
long_tmpdir.result
99
B
-rw-r--r--
lowercase0.require
45
B
-rw-r--r--
lowercase1.require
45
B
-rw-r--r--
lowercase2.require
45
B
-rw-r--r--
lowercase_fs_off.result
3.46
KB
-rw-r--r--
lowercase_fs_on.result
75
B
-rw-r--r--
lowercase_mixed_tmpdir.result
162
B
-rw-r--r--
lowercase_mixed_tmpdir_innodb....
190
B
-rw-r--r--
lowercase_table.result
3.24
KB
-rw-r--r--
lowercase_table2.result
8.66
KB
-rw-r--r--
lowercase_table4.result
4.63
KB
-rw-r--r--
lowercase_table5.result
673
B
-rw-r--r--
lowercase_table_grant.result
2.01
KB
-rw-r--r--
lowercase_table_qcache.result
847
B
-rw-r--r--
lowercase_utf8.result
173
B
-rw-r--r--
lowercase_view.result
10.21
KB
-rw-r--r--
m_i_db.result
15.5
KB
-rw-r--r--
max_statement_time.result
12.81
KB
-rw-r--r--
mdl_sync.result
113.92
KB
-rw-r--r--
mdl_tablespace.result
34.72
KB
-rw-r--r--
merge-big.result
728
B
-rw-r--r--
merge.result
100.14
KB
-rw-r--r--
merge_innodb.result
1.31
KB
-rw-r--r--
merge_mmap.result
3.33
KB
-rw-r--r--
metadata.result
17.03
KB
-rw-r--r--
mix2_myisam.result
66.36
KB
-rw-r--r--
mix2_myisam_ucs2.result
15.35
KB
-rw-r--r--
multi_plugin_load.result
347
B
-rw-r--r--
multi_plugin_load_add.result
455
B
-rw-r--r--
multi_plugin_load_add2.result
455
B
-rw-r--r--
multi_statement.result
563
B
-rw-r--r--
multi_update.result
26.47
KB
-rw-r--r--
multi_update2.result
1016
B
-rw-r--r--
multi_update_innodb.result
4.52
KB
-rw-r--r--
multi_update_tiny_hash.result
1.5
KB
-rw-r--r--
myisam-blob.result
1.41
KB
-rw-r--r--
myisam-system.result
394
B
-rw-r--r--
myisam.result
96.84
KB
-rw-r--r--
myisam_crash_before_flush_keys...
1.15
KB
-rw-r--r--
myisam_debug.result
1.21
KB
-rw-r--r--
myisam_explain_json_non_select...
287.97
KB
-rw-r--r--
myisam_explain_json_non_select...
294.08
KB
-rw-r--r--
myisam_explain_non_select_all....
133.64
KB
-rw-r--r--
myisam_explain_non_select_none...
133.36
KB
-rw-r--r--
myisam_icp.result
31.96
KB
-rw-r--r--
myisam_icp_all.result
32.02
KB
-rw-r--r--
myisam_icp_none.result
31.84
KB
-rw-r--r--
myisam_mrr.result
24.26
KB
-rw-r--r--
myisam_mrr_all.result
24.43
KB
-rw-r--r--
myisam_mrr_cost.result
24.21
KB
-rw-r--r--
myisam_mrr_cost_all.result
24.38
KB
-rw-r--r--
myisam_mrr_cost_icp.result
24.35
KB
-rw-r--r--
myisam_mrr_icp.result
24.4
KB
-rw-r--r--
myisam_mrr_none.result
24.16
KB
-rw-r--r--
myisam_recover.result
4.57
KB
-rw-r--r--
myisam_row_rpl.result
2.04
KB
-rw-r--r--
myisampack.result
7.56
KB
-rw-r--r--
mysql-bug41486.result
465
B
-rw-r--r--
mysql-bug45236.result
329
B
-rw-r--r--
mysql.result
9.77
KB
-rw-r--r--
mysql_batch_mode.result
84
B
-rw-r--r--
mysql_binary_mode.result
1.52
KB
-rw-r--r--
mysql_client_test.result
8.92
KB
-rw-r--r--
mysql_client_test_embedded.res...
111
B
-rw-r--r--
mysql_client_test_qcache.resul...
500
B
-rw-r--r--
mysql_comments.result
6.68
KB
-rw-r--r--
mysql_config_editor.result
8.01
KB
-rw-r--r--
mysql_cp932.result
37
B
-rw-r--r--
mysql_embedded.result
181
B
-rw-r--r--
mysql_embedded_client_test.res...
153
B
-rw-r--r--
mysql_locale_posix.result
973
B
-rw-r--r--
mysql_not_windows.result
477
B
-rw-r--r--
mysql_plugin.result
4.92
KB
-rw-r--r--
mysql_protocols.result
208
B
-rw-r--r--
mysql_ssl.result
152
B
-rw-r--r--
mysql_ssl_default.result
889
B
-rw-r--r--
mysql_tzinfo_to_sql.result
22.11
KB
-rw-r--r--
mysql_tzinfo_to_sql_sys.result
1.28
KB
-rw-r--r--
mysql_upgrade.result
136.32
KB
-rw-r--r--
mysql_upgrade_slave_master_inf...
5
KB
-rw-r--r--
mysql_upgrade_ssl.result
5.65
KB
-rw-r--r--
mysql_upgrade_with_session_use...
2.77
KB
-rw-r--r--
mysqladmin.result
1.22
KB
-rw-r--r--
mysqladmin_shutdown.result
170
B
-rw-r--r--
mysqlbinlog.result
31.28
KB
-rw-r--r--
mysqlbinlog_base64_flag.result
3.89
KB
-rw-r--r--
mysqlbinlog_debug.result
235
B
-rw-r--r--
mysqlbinlog_hexdump.result
6.5
KB
-rw-r--r--
mysqlbinlog_mixed_or_statment....
855
B
-rw-r--r--
mysqlbinlog_raw_mode.result
8.32
KB
-rw-r--r--
mysqlbinlog_raw_mode_win.resul...
8.08
KB
-rw-r--r--
mysqlbinlog_row_big.result
2.42
KB
-rw-r--r--
mysqlcheck.result
19.17
KB
-rw-r--r--
mysqld--defaults-file.result
908
B
-rw-r--r--
mysqld--help-notwin.result
67.99
KB
-rw-r--r--
mysqld--help-win.result
68.06
KB
-rw-r--r--
mysqld_daemon.result
66
B
-rw-r--r--
mysqld_safe.result
142
B
-rw-r--r--
mysqldump-binary.result
3.51
KB
-rw-r--r--
mysqldump-compat.result
111
B
-rw-r--r--
mysqldump-max.result
11.33
KB
-rw-r--r--
mysqldump-no-binlog.result
50
B
-rw-r--r--
mysqldump.result
295.21
KB
-rw-r--r--
mysqldump_bug29998457.result
3.47
KB
-rw-r--r--
mysqldump_bug30042589.result
3.05
KB
-rw-r--r--
mysqldump_bugs.result
5.04
KB
-rw-r--r--
mysqldump_gtid_state.result
2.69
KB
-rw-r--r--
mysqldump_restore.result
4.01
KB
-rw-r--r--
mysqldumpslow.result
1.13
KB
-rw-r--r--
mysqlimport.result
833
B
-rw-r--r--
mysqlpump.result
16.38
KB
-rw-r--r--
mysqlpump_basic.result
23.91
KB
-rw-r--r--
mysqlpump_bugs.result
850
B
-rw-r--r--
mysqlpump_charset.result
15.54
KB
-rw-r--r--
mysqlpump_concurrency.result
11.41
KB
-rw-r--r--
mysqlpump_extended.result
13.01
KB
-rw-r--r--
mysqlpump_filters.result
11.34
KB
-rw-r--r--
mysqlpump_multi_thread.result
11.53
KB
-rw-r--r--
mysqlpump_partial_bkp.result
797
B
-rw-r--r--
mysqlshow.result
9.96
KB
-rw-r--r--
mysqlslap.result
7.53
KB
-rw-r--r--
mysqltest.result
33.29
KB
-rw-r--r--
named_pipe.result
65.98
KB
-rw-r--r--
negation_elimination.result
13
KB
-rw-r--r--
no-threads.result
329
B
-rw-r--r--
no_binlog.result
64
B
-rw-r--r--
no_binlog_gtid_empty_statement...
675
B
-rw-r--r--
no_binlog_gtid_empty_transacti...
683
B
-rw-r--r--
no_binlog_gtid_mode_on.result
4.75
KB
-rw-r--r--
no_binlog_gtid_mode_on_explici...
3.84
KB
-rw-r--r--
no_binlog_gtid_next_begin_caus...
1.4
KB
-rw-r--r--
no_binlog_gtid_next_partially_...
11.91
KB
-rw-r--r--
no_binlog_gtid_next_partially_...
1.13
KB
-rw-r--r--
no_binlog_gtid_next_partially_...
2.3
KB
-rw-r--r--
no_binlog_gtid_next_single_stm...
9.6
KB
-rw-r--r--
no_binlog_gtid_next_temporary_...
1.1
KB
-rw-r--r--
no_engine_substitution.result
6.01
KB
-rw-r--r--
not_asan.require
7
B
-rw-r--r--
not_embedded.require
16
B
-rw-r--r--
not_embedded_server.result
5.86
KB
-rw-r--r--
not_ndb.require
39
B
-rw-r--r--
not_openssl.require
36
B
-rw-r--r--
not_partition.result
5.75
KB
-rw-r--r--
not_ssl.require
32
B
-rw-r--r--
not_true.require
10
B
-rw-r--r--
not_valgrind.require
17
B
-rw-r--r--
not_windows.require
7
B
-rw-r--r--
null.result
16.17
KB
-rw-r--r--
null_key_all.result
27.81
KB
-rw-r--r--
null_key_icp.result
27.74
KB
-rw-r--r--
null_key_none.result
27.68
KB
-rw-r--r--
odbc.result
1.41
KB
-rw-r--r--
olap.result
20.44
KB
-rw-r--r--
one_thread_per_connection.requ...
44
B
-rw-r--r--
openssl.require
37
B
-rw-r--r--
openssl_1.result
9.65
KB
-rw-r--r--
opt_costmodel.result
11.47
KB
-rw-r--r--
opt_costmodel_downgrade.result
2.55
KB
-rw-r--r--
opt_costmodel_flush.result
27.03
KB
-rw-r--r--
opt_costmodel_pfs.result
296
B
-rw-r--r--
opt_costmodel_restart.result
7.52
KB
-rw-r--r--
opt_costmodel_tables.result
5.59
KB
-rw-r--r--
opt_costmodel_warnings.result
2.52
KB
-rw-r--r--
opt_hint_timeout.result
3.21
KB
-rw-r--r--
opt_hints.result
110.61
KB
-rw-r--r--
opt_hints_lowercase.result
1.95
KB
-rw-r--r--
opt_hints_pfs.result
1.93
KB
-rw-r--r--
opt_hints_subquery.result
135.37
KB
-rw-r--r--
optimizer_bug12837084.result
13.97
KB
-rw-r--r--
optimizer_debug_sync.result
1.32
KB
-rw-r--r--
optimizer_switch.result
30.14
KB
-rw-r--r--
order_by_all.result
78.98
KB
-rw-r--r--
order_by_icp_mrr.result
78.93
KB
-rw-r--r--
order_by_limit.result
18.46
KB
-rw-r--r--
order_by_none.result
78.59
KB
-rw-r--r--
order_by_sortkey.result
3.19
KB
-rw-r--r--
order_fill_sortbuf.result
262
B
-rw-r--r--
outfile.result
2.2
KB
-rw-r--r--
outfile_loaddata.result
11.02
KB
-rw-r--r--
overflow.result
235
B
-rw-r--r--
packet.result
9.48
KB
-rw-r--r--
parser-big-32bit.result
1.35
KB
-rw-r--r--
parser-big-64bit.result
1.35
KB
-rw-r--r--
parser.result
60.1
KB
-rw-r--r--
parser_bug21114_innodb.result
25.39
KB
-rw-r--r--
parser_not_embedded.result
4.42
KB
-rw-r--r--
parser_precedence.result
23.96
KB
-rw-r--r--
parser_stack.result
9.54
KB
-rw-r--r--
partition.result
124.74
KB
-rw-r--r--
partition_archive.result
7.74
KB
-rw-r--r--
partition_binlog.result
2.41
KB
-rw-r--r--
partition_binlog_stmt.result
955
B
-rw-r--r--
partition_blackhole.result
531
B
-rw-r--r--
partition_bug18198.result
8.07
KB
-rw-r--r--
partition_cache.result
7.16
KB
-rw-r--r--
partition_charset.result
434
B
-rw-r--r--
partition_column.result
25.2
KB
-rw-r--r--
partition_column_prune.result
4.39
KB
-rw-r--r--
partition_csv.result
2.69
KB
-rw-r--r--
partition_datatype.result
47.14
KB
-rw-r--r--
partition_debug.result
985
B
-rw-r--r--
partition_debug_sync.result
6.26
KB
-rw-r--r--
partition_debug_sync_stmt.resu...
3.65
KB
-rw-r--r--
partition_deprecation.result
4.88
KB
-rw-r--r--
partition_error.result
84.03
KB
-rw-r--r--
partition_exchange.result
65.43
KB
-rw-r--r--
partition_explicit_prune.resul...
57.97
KB
-rw-r--r--
partition_federated.result
271
B
-rw-r--r--
partition_grant.result
1.67
KB
-rw-r--r--
partition_hash.result
11.15
KB
-rw-r--r--
partition_index_innodb.result
6.16
KB
-rw-r--r--
partition_index_myisam.result
5.35
KB
-rw-r--r--
partition_innodb.result
50.73
KB
-rw-r--r--
partition_innodb_plugin.result
3.11
KB
-rw-r--r--
partition_innodb_semi_consiste...
2.92
KB
-rw-r--r--
partition_innodb_stmt.result
1.12
KB
-rw-r--r--
partition_innodb_tablespace.re...
35.12
KB
-rw-r--r--
partition_key_cache.result
22.78
KB
-rw-r--r--
partition_list.result
13.93
KB
-rw-r--r--
partition_locking.result
246.59
KB
-rw-r--r--
partition_locking_4.result
1.7
KB
-rw-r--r--
partition_mgm.result
9.83
KB
-rw-r--r--
partition_mgm_err.result
7.48
KB
-rw-r--r--
partition_mgm_err2.result
373
B
-rw-r--r--
partition_myisam.result
10.25
KB
-rw-r--r--
partition_not_blackhole.result
456
B
-rw-r--r--
partition_not_windows.result
4.27
KB
-rw-r--r--
partition_order.result
16.29
KB
-rw-r--r--
partition_plugin.result
4.48
KB
-rw-r--r--
partition_pruning.result
290.58
KB
-rw-r--r--
partition_range.result
46.69
KB
-rw-r--r--
partition_rename_longfilename....
1.91
KB
-rw-r--r--
partition_symlink.result
6.25
KB
-rw-r--r--
partition_sync.result
1.35
KB
-rw-r--r--
partition_truncate.result
675
B
-rw-r--r--
partition_utf8.result
2.01
KB
-rw-r--r--
partition_windows.result
3.3
KB
-rw-r--r--
per_thread_connection_handler....
1.45
KB
-rw-r--r--
perror-win.result
453
B
-rw-r--r--
perror.result
471
B
-rw-r--r--
plugin.result
8.52
KB
-rw-r--r--
plugin_auth.result
33.72
KB
-rw-r--r--
plugin_auth_expire.result
644
B
-rw-r--r--
plugin_auth_qa.result
24.47
KB
-rw-r--r--
plugin_auth_qa_1.result
16.11
KB
-rw-r--r--
plugin_auth_qa_2.result
11.17
KB
-rw-r--r--
plugin_auth_qa_3.result
1.29
KB
-rw-r--r--
plugin_auth_sha256.result
5.52
KB
-rw-r--r--
plugin_auth_sha256_2.result
1.96
KB
-rw-r--r--
plugin_auth_sha256_server_defa...
3.7
KB
-rw-r--r--
plugin_auth_sha256_server_defa...
4.02
KB
-rw-r--r--
plugin_auth_sha256_tls.result
2.53
KB
-rw-r--r--
plugin_auth_user_lock.result
1
KB
-rw-r--r--
plugin_load.result
76
B
-rw-r--r--
plugin_load_option.result
321
B
-rw-r--r--
plugin_not_embedded.result
995
B
-rw-r--r--
preload.result
3.84
KB
-rw-r--r--
profiling.result
16.4
KB
-rw-r--r--
ps.result
125.1
KB
-rw-r--r--
ps_10nestset.result
2.08
KB
-rw-r--r--
ps_11bugs.result
6.01
KB
-rw-r--r--
ps_1general.result
35.8
KB
-rw-r--r--
ps_2myisam.result
103.52
KB
-rw-r--r--
ps_3innodb.result
103.06
KB
-rw-r--r--
ps_4heap.result
102.98
KB
-rw-r--r--
ps_5merge.result
201.74
KB
-rw-r--r--
ps_ddl.result
53.74
KB
-rw-r--r--
ps_ddl1.result
11.06
KB
-rw-r--r--
ps_grant.result
3.99
KB
-rw-r--r--
ps_not_windows.result
516
B
-rw-r--r--
ps_w_max_indexes_64.result
189.58
KB
-rw-r--r--
python_with_json.require
27
B
-rw-r--r--
query_cache.result
89.5
KB
-rw-r--r--
query_cache_28249.result
3.58
KB
-rw-r--r--
query_cache_debug.result
11.1
KB
-rw-r--r--
query_cache_disabled.result
1.96
KB
-rw-r--r--
query_cache_merge.result
32.8
KB
-rw-r--r--
query_cache_notembedded.result
11.37
KB
-rw-r--r--
query_cache_ps_no_prot.result
12.26
KB
-rw-r--r--
query_cache_ps_ps_prot.result
11.09
KB
-rw-r--r--
query_cache_size_functionality...
7.69
KB
-rw-r--r--
query_cache_type_functionality...
9.19
KB
-rw-r--r--
query_cache_with_views.result
6.02
KB
-rw-r--r--
range_all.result
145.86
KB
-rw-r--r--
range_icp.result
145.41
KB
-rw-r--r--
range_icp_mrr.result
145.8
KB
-rw-r--r--
range_mrr.result
145.32
KB
-rw-r--r--
range_mrr_cost.result
144.95
KB
-rw-r--r--
range_none.result
144.9
KB
-rw-r--r--
range_with_memory_limit.result
190.38
KB
-rw-r--r--
read_many_rows_innodb.result
2.83
KB
-rw-r--r--
read_only.result
23.09
KB
-rw-r--r--
read_only_innodb.result
5.42
KB
-rw-r--r--
relay_log_index_variables.resu...
469
B
-rw-r--r--
relay_log_variables.result
475
B
-rw-r--r--
rename.result
1.58
KB
-rw-r--r--
renamedb.result
880
B
-rw-r--r--
repair.result
6.43
KB
-rw-r--r--
replace.result
1.27
KB
-rw-r--r--
reset_connection.result
6.46
KB
-rw-r--r--
rewrite_general_log.result
6.48
KB
-rw-r--r--
rewrite_slow_log.result
3.75
KB
-rw-r--r--
rollback.result
574
B
-rw-r--r--
round.result
6.92
KB
-rw-r--r--
row.result
23.11
KB
-rw-r--r--
rowid_order_innodb.result
3.6
KB
-rw-r--r--
rpl_colSize.result
4.39
KB
-rw-r--r--
rpl_connect_attr.result
1.21
KB
-rw-r--r--
rpl_extraColmaster_innodb.resu...
23.85
KB
-rw-r--r--
rpl_extraColmaster_myisam.resu...
23.85
KB
-rw-r--r--
rpl_multi_source_mysqldump_sla...
1.5
KB
-rw-r--r--
rpl_mysqldump_slave.result
867
B
-rw-r--r--
schema.result
2.34
KB
-rw-r--r--
secure_file_priv_win.result
1.43
KB
-rw-r--r--
select_all.result
180.1
KB
-rw-r--r--
select_all_bka.result
180.83
KB
-rw-r--r--
select_all_bka_nixbnl.result
180.1
KB
-rw-r--r--
select_for_update.result
755
B
-rw-r--r--
select_found.result
6.96
KB
-rw-r--r--
select_icp_mrr.result
180.04
KB
-rw-r--r--
select_icp_mrr_bka.result
180.77
KB
-rw-r--r--
select_icp_mrr_bka_nixbnl.resu...
180.04
KB
-rw-r--r--
select_none.result
179.38
KB
-rw-r--r--
select_none_bka.result
179.47
KB
-rw-r--r--
select_none_bka_nixbnl.result
178.64
KB
-rw-r--r--
select_safe.result
9.97
KB
-rw-r--r--
server_id.require
32
B
-rw-r--r--
server_id1.require
34
B
-rw-r--r--
server_offline_1.result
2.03
KB
-rw-r--r--
server_offline_2.result
1.28
KB
-rw-r--r--
server_offline_3.result
1.31
KB
-rw-r--r--
server_offline_4.result
958
B
-rw-r--r--
server_offline_5.result
7.23
KB
-rw-r--r--
server_offline_6.result
1.2
KB
-rw-r--r--
server_uuid.result
785
B
-rw-r--r--
server_uuid_embedded.result
325
B
-rw-r--r--
session_tracker.result
23.61
KB
-rw-r--r--
session_tracker_trx_state.resu...
38.38
KB
-rw-r--r--
shm.result
66.48
KB
-rw-r--r--
shm_server_restart.result
20
B
-rw-r--r--
show_check.result
78.63
KB
-rw-r--r--
show_processlist_state.result
150
B
-rw-r--r--
show_profile.result
491
B
-rw-r--r--
show_variables.result
372
B
-rw-r--r--
shutdown.result
325
B
-rw-r--r--
signal.result
71.01
KB
-rw-r--r--
signal_code.result
1020
B
-rw-r--r--
signal_demo1.result
6.25
KB
-rw-r--r--
signal_demo2.result
3.86
KB
-rw-r--r--
signal_demo3.result
3.33
KB
-rw-r--r--
signal_sqlmode.result
2.63
KB
-rw-r--r--
single_delete_update.result
24.5
KB
-rw-r--r--
skip_grants.result
2.7
KB
-rw-r--r--
skip_grants_flush.result
352
B
-rw-r--r--
skip_log_bin.result
167
B
-rw-r--r--
skip_name_resolve.result
2.51
KB
-rw-r--r--
slave-running.result
71
B
-rw-r--r--
slave-stopped.result
72
B
-rw-r--r--
slow_log.result
2.57
KB
-rw-r--r--
sort_buffer_size_functionality...
6.61
KB
-rw-r--r--
sp-big.result
1.47
KB
-rw-r--r--
sp-bugs.result
11.46
KB
-rw-r--r--
sp-code.result
29.86
KB
-rw-r--r--
sp-destruct.result
7.02
KB
-rw-r--r--
sp-dynamic.result
9.73
KB
-rw-r--r--
sp-error.result
84.05
KB
-rw-r--r--
sp-fib.result
656
B
-rw-r--r--
sp-lock.result
21.56
KB
-rw-r--r--
sp-no-code.result
307
B
-rw-r--r--
sp-prelocking.result
7
KB
-rw-r--r--
sp-security.result
26.42
KB
-rw-r--r--
sp-threads.result
2.01
KB
-rw-r--r--
sp-ucs2.result
5.45
KB
-rw-r--r--
sp-vars.result
30.01
KB
-rw-r--r--
sp.result
192.98
KB
-rw-r--r--
sp_debug.result
735
B
-rw-r--r--
sp_gis.result
853
B
-rw-r--r--
sp_notembedded.result
14.61
KB
-rw-r--r--
sp_stress_case.result
2.53
KB
-rw-r--r--
sp_sync.result
3.17
KB
-rw-r--r--
sp_trans.result
14.83
KB
-rw-r--r--
sp_trans_log.result
891
B
-rw-r--r--
sp_validation.result
34.85
KB
-rw-r--r--
sql_mode.result
23.42
KB
-rw-r--r--
sql_mode_default.result
3.39
KB
-rw-r--r--
ssl-big.result
69
B
-rw-r--r--
ssl-crl-revoked-crl.result
76
B
-rw-r--r--
ssl-sha512.result
636
B
-rw-r--r--
ssl.result
66.63
KB
-rw-r--r--
ssl_8k_key.result
42
B
-rw-r--r--
ssl_and_innodb.result
306
B
-rw-r--r--
ssl_auto_detect_openssl.result
361
B
-rw-r--r--
ssl_ca.result
857
B
-rw-r--r--
ssl_cipher.result
295
B
-rw-r--r--
ssl_compress.result
66.25
KB
-rw-r--r--
ssl_connect.result
10
B
-rw-r--r--
ssl_crl.result
1.21
KB
-rw-r--r--
ssl_crl_clients-valid.result
1.01
KB
-rw-r--r--
ssl_crl_clients.result
427
B
-rw-r--r--
ssl_crl_clients_valid.result
673
B
-rw-r--r--
ssl_crl_crlpath.result
808
B
-rw-r--r--
ssl_deprecated_tls_versions.re...
334
B
-rw-r--r--
ssl_verify_identity.result
1.35
KB
-rw-r--r--
status.result
11.15
KB
-rw-r--r--
status2.result
1.35
KB
-rw-r--r--
status_bug17954.result
582
B
-rw-r--r--
status_debug.result
3.48
KB
-rw-r--r--
strict.result
78.07
KB
-rw-r--r--
strict_autoinc_1myisam.result
1.05
KB
-rw-r--r--
strict_autoinc_2innodb.result
1.05
KB
-rw-r--r--
strict_autoinc_3heap.result
1.05
KB
-rw-r--r--
subquery_all.result
298.58
KB
-rw-r--r--
subquery_all_bka.result
298.82
KB
-rw-r--r--
subquery_all_bka_nixbnl.result
298.37
KB
-rw-r--r--
subquery_bugs.result
4.36
KB
-rw-r--r--
subquery_mat.result
133.51
KB
-rw-r--r--
subquery_mat_all.result
123.66
KB
-rw-r--r--
subquery_mat_none.result
122.3
KB
-rw-r--r--
subquery_nomat_nosj.result
297.96
KB
-rw-r--r--
subquery_nomat_nosj_bka.result
298.16
KB
-rw-r--r--
subquery_nomat_nosj_bka_nixbnl...
297.81
KB
-rw-r--r--
subquery_none.result
297.84
KB
-rw-r--r--
subquery_none_bka.result
297.94
KB
-rw-r--r--
subquery_none_bka_nixbnl.resul...
297.58
KB
-rw-r--r--
subquery_sj_all.result
500.49
KB
-rw-r--r--
subquery_sj_all_bka.result
502.11
KB
-rw-r--r--
subquery_sj_all_bka_nixbnl.res...
490.45
KB
-rw-r--r--
subquery_sj_all_bkaunique.resu...
498.68
KB
-rw-r--r--
subquery_sj_dupsweed.result
502.87
KB
-rw-r--r--
subquery_sj_dupsweed_bka.resul...
502.97
KB
-rw-r--r--
subquery_sj_dupsweed_bka_nixbn...
484.75
KB
-rw-r--r--
subquery_sj_dupsweed_bkaunique...
503
KB
-rw-r--r--
subquery_sj_firstmatch.result
487.96
KB
-rw-r--r--
subquery_sj_firstmatch_bka.res...
488.05
KB
-rw-r--r--
subquery_sj_firstmatch_bka_nix...
480.97
KB
-rw-r--r--
subquery_sj_firstmatch_bkauniq...
488.09
KB
-rw-r--r--
subquery_sj_innodb_all.result
6.38
KB
-rw-r--r--
subquery_sj_innodb_all_bka.res...
6.57
KB
-rw-r--r--
subquery_sj_innodb_all_bka_nix...
6.6
KB
-rw-r--r--
subquery_sj_innodb_all_bkauniq...
6.63
KB
-rw-r--r--
subquery_sj_innodb_none.result
6.66
KB
-rw-r--r--
subquery_sj_innodb_none_bka.re...
6.75
KB
-rw-r--r--
subquery_sj_innodb_none_bka_ni...
6.74
KB
-rw-r--r--
subquery_sj_innodb_none_bkauni...
6.79
KB
-rw-r--r--
subquery_sj_loosescan.result
502.69
KB
-rw-r--r--
subquery_sj_loosescan_bka.resu...
502.79
KB
-rw-r--r--
subquery_sj_loosescan_bka_nixb...
484.38
KB
-rw-r--r--
subquery_sj_loosescan_bkauniqu...
502.82
KB
-rw-r--r--
subquery_sj_mat.result
522.25
KB
-rw-r--r--
subquery_sj_mat_bka.result
522.34
KB
-rw-r--r--
subquery_sj_mat_bka_nixbnl.res...
505.5
KB
-rw-r--r--
subquery_sj_mat_bkaunique.resu...
522.38
KB
-rw-r--r--
subquery_sj_mat_nosj.result
549.88
KB
-rw-r--r--
subquery_sj_none.result
516.26
KB
-rw-r--r--
subquery_sj_none_bka.result
516.35
KB
-rw-r--r--
subquery_sj_none_bka_nixbnl.re...
509.41
KB
-rw-r--r--
subquery_sj_none_bkaunique.res...
516.38
KB
-rw-r--r--
subselect_debug.result
662
B
-rw-r--r--
subselect_gis.result
320
B
-rw-r--r--
subselect_innodb.result
28.76
KB
-rw-r--r--
subselect_notembedded.result
752
B
-rw-r--r--
sum_distinct-big.result
2
KB
-rw-r--r--
sum_distinct.result
3.14
KB
-rw-r--r--
symlink.result
8.12
KB
-rw-r--r--
synchronization.result
4.05
KB
-rw-r--r--
sysdate_is_now.result
76
B
-rw-r--r--
system_mysql_db.result
13.71
KB
-rw-r--r--
system_mysql_db_refs.result
3.14
KB
-rw-r--r--
table_definition_cache_functio...
6.9
KB
-rw-r--r--
table_open_cache_functionality...
12.92
KB
-rw-r--r--
tablelock.result
1.5
KB
-rw-r--r--
tablespace.result
10.57
KB
-rw-r--r--
temp_pool.result
646
B
-rw-r--r--
temp_table.result
8.18
KB
-rw-r--r--
temporal_literal.result
13.62
KB
-rw-r--r--
test_security_context.result
1.06
KB
-rw-r--r--
testdb_only.require
45
B
-rw-r--r--
timezone.result
2.58
KB
-rw-r--r--
timezone2.result
13.21
KB
-rw-r--r--
timezone3.result
2.21
KB
-rw-r--r--
timezone4.result
148
B
-rw-r--r--
timezone_debug.result
926
B
-rw-r--r--
timezone_grant.result
4.42
KB
-rw-r--r--
trans_read_only.result
1.38
KB
-rw-r--r--
transaction_isolation.result
4.3
KB
-rw-r--r--
transaction_read_only.result
5.39
KB
-rw-r--r--
trigger-compat.result
7.98
KB
-rw-r--r--
trigger-trans.result
6.45
KB
-rw-r--r--
trigger.result
87.73
KB
-rw-r--r--
trigger_debug.result
627
B
-rw-r--r--
trigger_notembedded.result
19.95
KB
-rw-r--r--
trigger_wl3253.result
26.27
KB
-rw-r--r--
trigger_wl6030.result
53.61
KB
-rw-r--r--
true.require
7
B
-rw-r--r--
truncate.result
3.7
KB
-rw-r--r--
truncate_coverage.result
2.4
KB
-rw-r--r--
type_binary.result
9.62
KB
-rw-r--r--
type_bit.result
18.23
KB
-rw-r--r--
type_bit_innodb.result
8.2
KB
-rw-r--r--
type_blob.result
40.47
KB
-rw-r--r--
type_date.result
21.96
KB
-rw-r--r--
type_datetime.result
34.39
KB
-rw-r--r--
type_decimal.result
36.16
KB
-rw-r--r--
type_enum.result
101.64
KB
-rw-r--r--
type_float.result
12.43
KB
-rw-r--r--
type_nchar.result
1.44
KB
-rw-r--r--
type_newdecimal-big.result
678
B
-rw-r--r--
type_newdecimal.result
68.9
KB
-rw-r--r--
type_ranges.result
17.61
KB
-rw-r--r--
type_set.result
4.58
KB
-rw-r--r--
type_string.result
139
B
-rw-r--r--
type_temporal_fractional.resul...
645.37
KB
-rw-r--r--
type_temporal_upgrade.result
13.45
KB
-rw-r--r--
type_time.result
120.35
KB
-rw-r--r--
type_timestamp.result
25.71
KB
-rw-r--r--
type_timestamp_explicit.result
31.6
KB
-rw-r--r--
type_uint.result
380
B
-rw-r--r--
type_varchar.result
22.85
KB
-rw-r--r--
type_year.result
7.16
KB
-rw-r--r--
udf.result
17.31
KB
-rw-r--r--
udf_services.result
499
B
-rw-r--r--
udf_skip_grants.result
223
B
-rw-r--r--
union.result
87.33
KB
-rw-r--r--
unsafe_binlog_innodb.result
4.36
KB
-rw-r--r--
update.result
24.32
KB
-rw-r--r--
upgrade.result
5.28
KB
-rw-r--r--
user_if_exists.result
9.13
KB
-rw-r--r--
user_limits.result
5.82
KB
-rw-r--r--
user_lock.result
23.14
KB
-rw-r--r--
user_var-binlog.result
2.21
KB
-rw-r--r--
user_var.result
18.95
KB
-rw-r--r--
utility_warnings.result
7
KB
-rw-r--r--
validate_password_plugin.resul...
12.25
KB
-rw-r--r--
validate_password_plugin_check...
3.69
KB
-rw-r--r--
varbinary.result
58
KB
-rw-r--r--
variables-big.result
972
B
-rw-r--r--
variables-notembedded.result
5.97
KB
-rw-r--r--
variables-win.result
347
B
-rw-r--r--
variables.result
63.66
KB
-rw-r--r--
variables_community.result
182
B
-rw-r--r--
variables_debug.result
2.13
KB
-rw-r--r--
version_token.result
11.29
KB
-rw-r--r--
version_token_bug21280801.resu...
2.72
KB
-rw-r--r--
version_token_errors.result
2.21
KB
-rw-r--r--
view.result
258
KB
-rw-r--r--
view_alias.result
6.19
KB
-rw-r--r--
view_grant.result
126.95
KB
-rw-r--r--
view_gtid_mode_on_debug.result
1.37
KB
-rw-r--r--
wait_timeout.result
1.07
KB
-rw-r--r--
warnings.result
11.89
KB
-rw-r--r--
warnings_engine_disabled.resul...
475
B
-rw-r--r--
windows.require
7
B
-rw-r--r--
windows.result
1.98
KB
-rw-r--r--
wl3836.result
2.71
KB
-rw-r--r--
wl5928.result
15.47
KB
-rw-r--r--
wl6219-csv.result
5.16
KB
-rw-r--r--
wl6219-innodb.result
5.18
KB
-rw-r--r--
wl6219-memory.result
5.18
KB
-rw-r--r--
wl6219-merge.result
3.87
KB
-rw-r--r--
wl6219-myisam.result
5.18
KB
-rw-r--r--
wl6219-upgrade.result
10.52
KB
-rw-r--r--
wl6301_1_not_windows.result
44
B
-rw-r--r--
wl6301_2_not_windows.result
46
B
-rw-r--r--
wl6301_3.result
89
B
-rw-r--r--
wl6443_deprecation.result
10.81
KB
-rw-r--r--
wl6661.result
6.33
KB
-rw-r--r--
wl6711_heap_to_disk.result
6.07
KB
-rw-r--r--
wl6978.result
214
B
-rw-r--r--
xa.result
13.51
KB
-rw-r--r--
xa_deadlock_binlog.result
3.08
KB
-rw-r--r--
xa_debug.result
3.18
KB
-rw-r--r--
xa_gtid.result
878
B
-rw-r--r--
xa_prepared_binlog_off.result
19.77
KB
-rw-r--r--
xml.result
41.94
KB
-rw-r--r--
Delete
Unzip
Zip
${this.title}
Close
Code Editor : ctype_utf32_uca.result
DROP TABLE IF EXISTS t1; # # Start of 5.5 tests # set names utf8; set collation_connection=utf32_unicode_ci; select hex('a'), hex('a '); hex('a') hex('a ') 00000061 0000006100000020 select 'a' = 'a', 'a' = 'a ', 'a ' = 'a'; 'a' = 'a' 'a' = 'a ' 'a ' = 'a' 1 1 1 select 'a\0' = 'a', 'a\0' < 'a', 'a\0' > 'a'; 'a\0' = 'a' 'a\0' < 'a' 'a\0' > 'a' 1 0 0 select 'a' = 'a\0', 'a' < 'a\0', 'a' > 'a\0'; 'a' = 'a\0' 'a' < 'a\0' 'a' > 'a\0' 1 0 0 select 'a\0' = 'a ', 'a\0' < 'a ', 'a\0' > 'a '; 'a\0' = 'a ' 'a\0' < 'a ' 'a\0' > 'a ' 1 0 0 select 'a ' = 'a\0', 'a ' < 'a\0', 'a ' > 'a\0'; 'a ' = 'a\0' 'a ' < 'a\0' 'a ' > 'a\0' 1 0 0 select 'a a' > 'a', 'a \0' < 'a'; 'a a' > 'a' 'a \0' < 'a' 1 0 select binary 'a a' > 'a', binary 'a \0' > 'a', binary 'a\0' > 'a'; binary 'a a' > 'a' binary 'a \0' > 'a' binary 'a\0' > 'a' 1 1 1 select 'c' like '\_' as want0; want0 0 CREATE TABLE t ( c char(20) NOT NULL ) ENGINE=MyISAM DEFAULT CHARACTER SET utf32 COLLATE=utf32_unicode_ci; INSERT INTO t VALUES ('a'),('ab'),('aba'); ALTER TABLE t ADD INDEX (c); SELECT c FROM t WHERE c LIKE 'a%'; c a ab aba DROP TABLE t; create table t1 (c1 char(10) character set utf32 collate utf32_bin); insert into t1 values ('A'),('a'); insert into t1 values ('B'),('b'); insert into t1 values ('C'),('c'); insert into t1 values ('D'),('d'); insert into t1 values ('E'),('e'); insert into t1 values ('F'),('f'); insert into t1 values ('G'),('g'); insert into t1 values ('H'),('h'); insert into t1 values ('I'),('i'); insert into t1 values ('J'),('j'); insert into t1 values ('K'),('k'); insert into t1 values ('L'),('l'); insert into t1 values ('M'),('m'); insert into t1 values ('N'),('n'); insert into t1 values ('O'),('o'); insert into t1 values ('P'),('p'); insert into t1 values ('Q'),('q'); insert into t1 values ('R'),('r'); insert into t1 values ('S'),('s'); insert into t1 values ('T'),('t'); insert into t1 values ('U'),('u'); insert into t1 values ('V'),('v'); insert into t1 values ('W'),('w'); insert into t1 values ('X'),('x'); insert into t1 values ('Y'),('y'); insert into t1 values ('Z'),('z'); insert into t1 values (_ucs2 0x00e0),(_ucs2 0x00c0); insert into t1 values (_ucs2 0x00e1),(_ucs2 0x00c1); insert into t1 values (_ucs2 0x00e2),(_ucs2 0x00c2); insert into t1 values (_ucs2 0x00e3),(_ucs2 0x00c3); insert into t1 values (_ucs2 0x00e4),(_ucs2 0x00c4); insert into t1 values (_ucs2 0x00e5),(_ucs2 0x00c5); insert into t1 values (_ucs2 0x00e6),(_ucs2 0x00c6); insert into t1 values (_ucs2 0x00e7),(_ucs2 0x00c7); insert into t1 values (_ucs2 0x00e8),(_ucs2 0x00c8); insert into t1 values (_ucs2 0x00e9),(_ucs2 0x00c9); insert into t1 values (_ucs2 0x00ea),(_ucs2 0x00ca); insert into t1 values (_ucs2 0x00eb),(_ucs2 0x00cb); insert into t1 values (_ucs2 0x00ec),(_ucs2 0x00cc); insert into t1 values (_ucs2 0x00ed),(_ucs2 0x00cd); insert into t1 values (_ucs2 0x00ee),(_ucs2 0x00ce); insert into t1 values (_ucs2 0x00ef),(_ucs2 0x00cf); insert into t1 values (_ucs2 0x00f0),(_ucs2 0x00d0); insert into t1 values (_ucs2 0x00f1),(_ucs2 0x00d1); insert into t1 values (_ucs2 0x00f2),(_ucs2 0x00d2); insert into t1 values (_ucs2 0x00f3),(_ucs2 0x00d3); insert into t1 values (_ucs2 0x00f4),(_ucs2 0x00d4); insert into t1 values (_ucs2 0x00f5),(_ucs2 0x00d5); insert into t1 values (_ucs2 0x00f6),(_ucs2 0x00d6); insert into t1 values (_ucs2 0x00f7),(_ucs2 0x00d7); insert into t1 values (_ucs2 0x00f8),(_ucs2 0x00d8); insert into t1 values (_ucs2 0x00f9),(_ucs2 0x00d9); insert into t1 values (_ucs2 0x00fa),(_ucs2 0x00da); insert into t1 values (_ucs2 0x00fb),(_ucs2 0x00db); insert into t1 values (_ucs2 0x00fc),(_ucs2 0x00dc); insert into t1 values (_ucs2 0x00fd),(_ucs2 0x00dd); insert into t1 values (_ucs2 0x00fe),(_ucs2 0x00de); insert into t1 values (_ucs2 0x00ff),(_ucs2 0x00df); insert into t1 values (_ucs2 0x0100),(_ucs2 0x0101),(_ucs2 0x0102),(_ucs2 0x0103); insert into t1 values (_ucs2 0x0104),(_ucs2 0x0105),(_ucs2 0x0106),(_ucs2 0x0107); insert into t1 values (_ucs2 0x0108),(_ucs2 0x0109),(_ucs2 0x010a),(_ucs2 0x010b); insert into t1 values (_ucs2 0x010c),(_ucs2 0x010d),(_ucs2 0x010e),(_ucs2 0x010f); insert into t1 values (_ucs2 0x0110),(_ucs2 0x0111),(_ucs2 0x0112),(_ucs2 0x0113); insert into t1 values (_ucs2 0x0114),(_ucs2 0x0115),(_ucs2 0x0116),(_ucs2 0x0117); insert into t1 values (_ucs2 0x0118),(_ucs2 0x0119),(_ucs2 0x011a),(_ucs2 0x011b); insert into t1 values (_ucs2 0x011c),(_ucs2 0x011d),(_ucs2 0x011e),(_ucs2 0x011f); insert into t1 values (_ucs2 0x0120),(_ucs2 0x0121),(_ucs2 0x0122),(_ucs2 0x0123); insert into t1 values (_ucs2 0x0124),(_ucs2 0x0125),(_ucs2 0x0126),(_ucs2 0x0127); insert into t1 values (_ucs2 0x0128),(_ucs2 0x0129),(_ucs2 0x012a),(_ucs2 0x012b); insert into t1 values (_ucs2 0x012c),(_ucs2 0x012d),(_ucs2 0x012e),(_ucs2 0x012f); insert into t1 values (_ucs2 0x0130),(_ucs2 0x0131),(_ucs2 0x0132),(_ucs2 0x0133); insert into t1 values (_ucs2 0x0134),(_ucs2 0x0135),(_ucs2 0x0136),(_ucs2 0x0137); insert into t1 values (_ucs2 0x0138),(_ucs2 0x0139),(_ucs2 0x013a),(_ucs2 0x013b); insert into t1 values (_ucs2 0x013c),(_ucs2 0x013d),(_ucs2 0x013e),(_ucs2 0x013f); insert into t1 values (_ucs2 0x0140),(_ucs2 0x0141),(_ucs2 0x0142),(_ucs2 0x0143); insert into t1 values (_ucs2 0x0144),(_ucs2 0x0145),(_ucs2 0x0146),(_ucs2 0x0147); insert into t1 values (_ucs2 0x0148),(_ucs2 0x0149),(_ucs2 0x014a),(_ucs2 0x014b); insert into t1 values (_ucs2 0x014c),(_ucs2 0x014d),(_ucs2 0x014e),(_ucs2 0x014f); insert into t1 values (_ucs2 0x0150),(_ucs2 0x0151),(_ucs2 0x0152),(_ucs2 0x0153); insert into t1 values (_ucs2 0x0154),(_ucs2 0x0155),(_ucs2 0x0156),(_ucs2 0x0157); insert into t1 values (_ucs2 0x0158),(_ucs2 0x0159),(_ucs2 0x015a),(_ucs2 0x015b); insert into t1 values (_ucs2 0x015c),(_ucs2 0x015d),(_ucs2 0x015e),(_ucs2 0x015f); insert into t1 values (_ucs2 0x0160),(_ucs2 0x0161),(_ucs2 0x0162),(_ucs2 0x0163); insert into t1 values (_ucs2 0x0164),(_ucs2 0x0165),(_ucs2 0x0166),(_ucs2 0x0167); insert into t1 values (_ucs2 0x0168),(_ucs2 0x0169),(_ucs2 0x016a),(_ucs2 0x016b); insert into t1 values (_ucs2 0x016c),(_ucs2 0x016d),(_ucs2 0x016e),(_ucs2 0x016f); insert into t1 values (_ucs2 0x0170),(_ucs2 0x0171),(_ucs2 0x0172),(_ucs2 0x0173); insert into t1 values (_ucs2 0x0174),(_ucs2 0x0175),(_ucs2 0x0176),(_ucs2 0x0177); insert into t1 values (_ucs2 0x0178),(_ucs2 0x0179),(_ucs2 0x017a),(_ucs2 0x017b); insert into t1 values (_ucs2 0x017c),(_ucs2 0x017d),(_ucs2 0x017e),(_ucs2 0x017f); insert into t1 values (_ucs2 0x0180),(_ucs2 0x0181),(_ucs2 0x0182),(_ucs2 0x0183); insert into t1 values (_ucs2 0x0184),(_ucs2 0x0185),(_ucs2 0x0186),(_ucs2 0x0187); insert into t1 values (_ucs2 0x0188),(_ucs2 0x0189),(_ucs2 0x018a),(_ucs2 0x018b); insert into t1 values (_ucs2 0x018c),(_ucs2 0x018d),(_ucs2 0x018e),(_ucs2 0x018f); insert into t1 values (_ucs2 0x0190),(_ucs2 0x0191),(_ucs2 0x0192),(_ucs2 0x0193); insert into t1 values (_ucs2 0x0194),(_ucs2 0x0195),(_ucs2 0x0196),(_ucs2 0x0197); insert into t1 values (_ucs2 0x0198),(_ucs2 0x0199),(_ucs2 0x019a),(_ucs2 0x019b); insert into t1 values (_ucs2 0x019c),(_ucs2 0x019d),(_ucs2 0x019e),(_ucs2 0x019f); insert into t1 values (_ucs2 0x01a0),(_ucs2 0x01a1),(_ucs2 0x01a2),(_ucs2 0x01a3); insert into t1 values (_ucs2 0x01a4),(_ucs2 0x01a5),(_ucs2 0x01a6),(_ucs2 0x01a7); insert into t1 values (_ucs2 0x01a8),(_ucs2 0x01a9),(_ucs2 0x01aa),(_ucs2 0x01ab); insert into t1 values (_ucs2 0x01ac),(_ucs2 0x01ad),(_ucs2 0x01ae),(_ucs2 0x01af); insert into t1 values (_ucs2 0x01b0),(_ucs2 0x01b1),(_ucs2 0x01b2),(_ucs2 0x01b3); insert into t1 values (_ucs2 0x01b4),(_ucs2 0x01b5),(_ucs2 0x01b6),(_ucs2 0x01b7); insert into t1 values (_ucs2 0x01b8),(_ucs2 0x01b9),(_ucs2 0x01ba),(_ucs2 0x01bb); insert into t1 values (_ucs2 0x01bc),(_ucs2 0x01bd),(_ucs2 0x01be),(_ucs2 0x01bf); insert into t1 values (_ucs2 0x01c0),(_ucs2 0x01c1),(_ucs2 0x01c2),(_ucs2 0x01c3); insert into t1 values (_ucs2 0x01c4),(_ucs2 0x01c5),(_ucs2 0x01c6),(_ucs2 0x01c7); insert into t1 values (_ucs2 0x01c8),(_ucs2 0x01c9),(_ucs2 0x01ca),(_ucs2 0x01cb); insert into t1 values (_ucs2 0x01cc),(_ucs2 0x01cd),(_ucs2 0x01ce),(_ucs2 0x01cf); insert into t1 values (_ucs2 0x01d0),(_ucs2 0x01d1),(_ucs2 0x01d2),(_ucs2 0x01d3); insert into t1 values (_ucs2 0x01d4),(_ucs2 0x01d5),(_ucs2 0x01d6),(_ucs2 0x01d7); insert into t1 values (_ucs2 0x01d8),(_ucs2 0x01d9),(_ucs2 0x01da),(_ucs2 0x01db); insert into t1 values (_ucs2 0x01dc),(_ucs2 0x01dd),(_ucs2 0x01de),(_ucs2 0x01df); insert into t1 values (_ucs2 0x01e0),(_ucs2 0x01e1),(_ucs2 0x01e2),(_ucs2 0x01e3); insert into t1 values (_ucs2 0x01e4),(_ucs2 0x01e5),(_ucs2 0x01e6),(_ucs2 0x01e7); insert into t1 values (_ucs2 0x01e8),(_ucs2 0x01e9),(_ucs2 0x01ea),(_ucs2 0x01eb); insert into t1 values (_ucs2 0x01ec),(_ucs2 0x01ed),(_ucs2 0x01ee),(_ucs2 0x01ef); insert into t1 values (_ucs2 0x01f0),(_ucs2 0x01f1),(_ucs2 0x01f2),(_ucs2 0x01f3); insert into t1 values (_ucs2 0x01f4),(_ucs2 0x01f5),(_ucs2 0x01f6),(_ucs2 0x01f7); insert into t1 values (_ucs2 0x01f8),(_ucs2 0x01f9),(_ucs2 0x01fa),(_ucs2 0x01fb); insert into t1 values (_ucs2 0x01fc),(_ucs2 0x01fd),(_ucs2 0x01fe),(_ucs2 0x01ff); INSERT INTO t1 VALUES (_ucs2 0x1EA0),(_ucs2 0x1EA1),(_ucs2 0x1EA2),(_ucs2 0x1EA3); INSERT INTO t1 VALUES (_ucs2 0x1EA4),(_ucs2 0x1EA5),(_ucs2 0x1EA6),(_ucs2 0x1EA7); INSERT INTO t1 VALUES (_ucs2 0x1EA8),(_ucs2 0x1EA9),(_ucs2 0x1EAA),(_ucs2 0x1EAB); INSERT INTO t1 VALUES (_ucs2 0x1EAC),(_ucs2 0x1EAD),(_ucs2 0x1EAE),(_ucs2 0x1EAF); INSERT INTO t1 VALUES (_ucs2 0x1EB0),(_ucs2 0x1EB1),(_ucs2 0x1EB2),(_ucs2 0x1EB3); INSERT INTO t1 VALUES (_ucs2 0x1EB4),(_ucs2 0x1EB5),(_ucs2 0x1EB6),(_ucs2 0x1EB7); INSERT INTO t1 VALUES (_ucs2 0x1EB8),(_ucs2 0x1EB9),(_ucs2 0x1EBA),(_ucs2 0x1EBB); INSERT INTO t1 VALUES (_ucs2 0x1EBC),(_ucs2 0x1EBD),(_ucs2 0x1EBE),(_ucs2 0x1EBF); INSERT INTO t1 VALUES (_ucs2 0x1EC0),(_ucs2 0x1EC1),(_ucs2 0x1EC2),(_ucs2 0x1EC3); INSERT INTO t1 VALUES (_ucs2 0x1EC4),(_ucs2 0x1EC5),(_ucs2 0x1EC6),(_ucs2 0x1EC7); INSERT INTO t1 VALUES (_ucs2 0x1EC8),(_ucs2 0x1EC9),(_ucs2 0x1ECA),(_ucs2 0x1ECB); INSERT INTO t1 VALUES (_ucs2 0x1ECC),(_ucs2 0x1ECD),(_ucs2 0x1ECE),(_ucs2 0x1ECF); INSERT INTO t1 VALUES (_ucs2 0x1ED0),(_ucs2 0x1ED1),(_ucs2 0x1ED2),(_ucs2 0x1ED3); INSERT INTO t1 VALUES (_ucs2 0x1ED4),(_ucs2 0x1ED5),(_ucs2 0x1ED6),(_ucs2 0x1ED7); INSERT INTO t1 VALUES (_ucs2 0x1ED8),(_ucs2 0x1ED9),(_ucs2 0x1EDA),(_ucs2 0x1EDB); INSERT INTO t1 VALUES (_ucs2 0x1EDC),(_ucs2 0x1EDD),(_ucs2 0x1EDE),(_ucs2 0x1EDF); INSERT INTO t1 VALUES (_ucs2 0x1EE0),(_ucs2 0x1EE1),(_ucs2 0x1EE2),(_ucs2 0x1EE3); INSERT INTO t1 VALUES (_ucs2 0x1EE4),(_ucs2 0x1EE5),(_ucs2 0x1EE6),(_ucs2 0x1EE7); INSERT INTO t1 VALUES (_ucs2 0x1EE8),(_ucs2 0x1EE9),(_ucs2 0x1EEA),(_ucs2 0x1EEB); INSERT INTO t1 VALUES (_ucs2 0x1EEC),(_ucs2 0x1EED),(_ucs2 0x1EEE),(_ucs2 0x1EEF); INSERT INTO t1 VALUES (_ucs2 0x1EF0),(_ucs2 0x1EF1); insert into t1 values ('AA'),('Aa'),('aa'),('aA'); insert into t1 values ('AE'),('Ae'),('ae'),('aE'); insert into t1 values ('CH'),('Ch'),('ch'),('cH'); insert into t1 values ('DZ'),('Dz'),('dz'),('dZ'); insert into t1 values ('DŽ'),('Dž'),('dž'),('dŽ'); insert into t1 values ('IJ'),('Ij'),('ij'),('iJ'); insert into t1 values ('LJ'),('Lj'),('lj'),('lJ'); insert into t1 values ('LL'),('Ll'),('ll'),('lL'); insert into t1 values ('NJ'),('Nj'),('nj'),('nJ'); insert into t1 values ('OE'),('Oe'),('oe'),('oE'); insert into t1 values ('SS'),('Ss'),('ss'),('sS'); insert into t1 values ('RR'),('Rr'),('rr'),('rR'); select group_concat(c1 order by binary c1 separator '') from t1 group by c1 collate utf32_unicode_ci; group_concat(c1 order by binary c1 separator '') ÷ × AaÀÁÂÃÄÅàáâãäåĀāĂ㥹ǍǎǞǟǠǡǺǻẠạẢảẤấẦầẨẩẪẫẬậẮắẰằẲẳẴẵẶặ AAAaaAaa AEAeaEae ÆæǢǣǼǽ Bb ƀ Ɓ Ƃƃ CcÇçĆćĈĉĊċČč CHChcHch Ƈƈ DdĎď DZDzDŽDždZdzdŽdžDŽDždžDZDzdz Đđ Ɖ Ɗ Ƌƌ Ðð EeÈÉÊËèéêëĒēĔĕĖėĘęĚěẸẹẺẻẼẽẾếỀềỂểỄễỆệ Ǝǝ Ə Ɛ Ff Ƒƒ GgĜĝĞğĠġĢģǦǧǴǵ Ǥǥ Ɠ Ɣ Ƣƣ HhĤĥ ƕǶ Ħħ IiÌÍÎÏìíîïĨĩĪīĬĭĮįİǏǐỈỉỊị IJIjiJijIJij ı Ɨ Ɩ JjĴĵǰ KkĶķǨǩ Ƙƙ LlĹĺĻļĽľ Ŀŀ LJLjlJljLJLjlj LLLllLll Łł ƚ ƛ Mm NnÑñŃńŅņŇňǸǹ NJNjnJnjNJNjnj Ɲ ƞ Ŋŋ OoÒÓÔÕÖòóôõöŌōŎŏŐőƠơǑǒǪǫǬǭỌọỎỏỐốỒồỔổỖỗỘộỚớỜờỞởỠỡỢợ OEOeoEoeŒœ ØøǾǿ Ɔ Ɵ Pp Ƥƥ Qq ĸ RrŔŕŖŗŘř RRRrrRrr Ʀ SsŚśŜŝŞşŠšſ SSSssSssß Ʃ ƪ TtŢţŤť ƾ Ŧŧ ƫ Ƭƭ Ʈ UuÙÚÛÜùúûüŨũŪūŬŭŮůŰűŲųƯưǓǔǕǖǗǘǙǚǛǜỤụỦủỨứỪừỬửỮữỰự Ɯ Ʊ Vv Ʋ WwŴŵ Xx YyÝýÿŶŷŸ Ƴƴ ZzŹźŻżŽž ƍ Ƶƶ ƷǮǯ Ƹƹ ƺ Þþ ƿǷ ƻ Ƨƨ Ƽƽ Ƅƅ ʼn ǀ ǁ ǂ ǃ select group_concat(c1 order by binary c1 separator '') from t1 group by c1 collate utf32_icelandic_ci; group_concat(c1 order by binary c1 separator '') ÷ × AaÀÂÃàâãĀāĂ㥹ǍǎǞǟǠǡǺǻẠạẢảẤấẦầẨẩẪẫẬậẮắẰằẲẳẴẵẶặ AAAaaAaa AEAeaEae Áá ǢǣǼǽ Bb ƀ Ɓ Ƃƃ CcÇçĆćĈĉĊċČč CHChcHch Ƈƈ DdĎď DZDzDŽDždZdzdŽdžDŽDždžDZDzdz Ðð Đđ Ɖ Ɗ Ƌƌ EeÈÊËèêëĒēĔĕĖėĘęĚěẸẹẺẻẼẽẾếỀềỂểỄễỆệ Éé Ǝǝ Ə Ɛ Ff Ƒƒ GgĜĝĞğĠġĢģǦǧǴǵ Ǥǥ Ɠ Ɣ Ƣƣ HhĤĥ ƕǶ Ħħ IiÌÎÏìîïĨĩĪīĬĭĮįİǏǐỈỉỊị IJIjiJijIJij Íí ı Ɨ Ɩ JjĴĵǰ KkĶķǨǩ Ƙƙ LlĹĺĻļĽľ Ŀŀ LJLjlJljLJLjlj LLLllLll Łł ƚ ƛ Mm NnÑñŃńŅņŇňǸǹ NJNjnJnjNJNjnj Ɲ ƞ Ŋŋ OoÒÔÕòôõŌōŎŏŐőƠơǑǒǪǫǬǭỌọỎỏỐốỒồỔổỖỗỘộỚớỜờỞởỠỡỢợ OEOeoEoeŒœ Óó Ǿǿ Ɔ Ɵ Pp Ƥƥ Qq ĸ RrŔŕŖŗŘř RRRrrRrr Ʀ SsŚśŜŝŞşŠšſ SSSssSssß Ʃ ƪ TtŢţŤť ƾ Ŧŧ ƫ Ƭƭ Ʈ UuÙÛÜùûüŨũŪūŬŭŮůŰűŲųƯưǓǔǕǖǗǘǙǚǛǜỤụỦủỨứỪừỬửỮữỰự Úú Ɯ Ʊ Vv Ʋ WwŴŵ Xx YyÿŶŷŸ Ýý Ƴƴ ZzŹźŻżŽž ƍ Þþ ÄÆäæ ÖØöø Åå Ƶƶ ƷǮǯ Ƹƹ ƺ ƿǷ ƻ Ƨƨ Ƽƽ Ƅƅ ʼn ǀ ǁ ǂ ǃ select group_concat(c1 order by binary c1 separator '') from t1 group by c1 collate utf32_latvian_ci; group_concat(c1 order by binary c1 separator '') ÷ × AaÀÁÂÃÄÅàáâãäåĀāĂ㥹ǍǎǞǟǠǡǺǻẠạẢảẤấẦầẨẩẪẫẬậẮắẰằẲẳẴẵẶặ AAAaaAaa AEAeaEae ÆæǢǣǼǽ Bb ƀ Ɓ Ƃƃ CcÇçĆćĈĉĊċ CHChcHch Čč Ƈƈ DdĎď DZDzdZdzDŽDždžDZDzdz DŽDždŽdž Đđ Ɖ Ɗ Ƌƌ Ðð EeÈÉÊËèéêëĒēĔĕĖėĘęĚěẸẹẺẻẼẽẾếỀềỂểỄễỆệ Ǝǝ Ə Ɛ Ff Ƒƒ GgĜĝĞğĠġǦǧǴǵ Ģģ Ǥǥ Ɠ Ɣ Ƣƣ HhĤĥ ƕǶ Ħħ IiÌÍÎÏìíîïĨĩĪīĬĭĮįİǏǐỈỉỊị IJIjiJijIJij Yy ı Ɨ Ɩ JjĴĵǰ KkǨǩ Ķķ Ƙƙ LlĹ弾 Ŀŀ LJLjlJljLJLjlj LLLllLll Ļļ Łł ƚ ƛ Mm NnÑñŃńŇňǸǹ NJNjnJnjNJNjnj Ņņ Ɲ ƞ Ŋŋ OoÒÓÔÕÖòóôõöŌōŎŏŐőƠơǑǒǪǫǬǭỌọỎỏỐốỒồỔổỖỗỘộỚớỜờỞởỠỡỢợ OEOeoEoeŒœ ØøǾǿ Ɔ Ɵ Pp Ƥƥ Qq ĸ RrŔŕŘř RRRrrRrr Ŗŗ Ʀ SsŚśŜŝŞşſ SSSssSssß Šš Ʃ ƪ TtŢţŤť ƾ Ŧŧ ƫ Ƭƭ Ʈ UuÙÚÛÜùúûüŨũŪūŬŭŮůŰűŲųƯưǓǔǕǖǗǘǙǚǛǜỤụỦủỨứỪừỬửỮữỰự Ɯ Ʊ Vv Ʋ WwŴŵ Xx ÝýÿŶŷŸ Ƴƴ ZzŹźŻż ƍ Žž Ƶƶ ƷǮǯ Ƹƹ ƺ Þþ ƿǷ ƻ Ƨƨ Ƽƽ Ƅƅ ʼn ǀ ǁ ǂ ǃ select group_concat(c1 order by binary c1 separator '') from t1 group by c1 collate utf32_romanian_ci; group_concat(c1 order by binary c1 separator '') ÷ × AaÀÁÃÄÅàáãäåĀāĄąǍǎǞǟǠǡǺǻẠạẢảẤấẦầẨẩẪẫẬậẮắẰằẲẳẴẵẶặ AAAaaAaa AEAeaEae Ăă Ââ ÆæǢǣǼǽ Bb ƀ Ɓ Ƃƃ CcÇçĆćĈĉĊċČč CHChcHch Ƈƈ DdĎď DZDzDŽDždZdzdŽdžDŽDždžDZDzdz Đđ Ɖ Ɗ Ƌƌ Ðð EeÈÉÊËèéêëĒēĔĕĖėĘęĚěẸẹẺẻẼẽẾếỀềỂểỄễỆệ Ǝǝ Ə Ɛ Ff Ƒƒ GgĜĝĞğĠġĢģǦǧǴǵ Ǥǥ Ɠ Ɣ Ƣƣ HhĤĥ ƕǶ Ħħ IiÌÍÏìíïĨĩĪīĬĭĮįİǏǐỈỉỊị IJIjiJijIJij Îî ı Ɨ Ɩ JjĴĵǰ KkĶķǨǩ Ƙƙ LlĹĺĻļĽľ Ŀŀ LJLjlJljLJLjlj LLLllLll Łł ƚ ƛ Mm NnÑñŃńŅņŇňǸǹ NJNjnJnjNJNjnj Ɲ ƞ Ŋŋ OoÒÓÔÕÖòóôõöŌōŎŏŐőƠơǑǒǪǫǬǭỌọỎỏỐốỒồỔổỖỗỘộỚớỜờỞởỠỡỢợ OEOeoEoeŒœ ØøǾǿ Ɔ Ɵ Pp Ƥƥ Qq ĸ RrŔŕŖŗŘř RRRrrRrr Ʀ SsŚśŜŝŠšſ SSSssSssß Şş Ʃ ƪ TtŤť ƾ Ţţ Ŧŧ ƫ Ƭƭ Ʈ UuÙÚÛÜùúûüŨũŪūŬŭŮůŰűŲųƯưǓǔǕǖǗǘǙǚǛǜỤụỦủỨứỪừỬửỮữỰự Ɯ Ʊ Vv Ʋ WwŴŵ Xx YyÝýÿŶŷŸ Ƴƴ ZzŹźŻżŽž ƍ Ƶƶ ƷǮǯ Ƹƹ ƺ Þþ ƿǷ ƻ Ƨƨ Ƽƽ Ƅƅ ʼn ǀ ǁ ǂ ǃ select group_concat(c1 order by binary c1 separator '') from t1 group by c1 collate utf32_slovenian_ci; group_concat(c1 order by binary c1 separator '') ÷ × AaÀÁÂÃÄÅàáâãäåĀāĂ㥹ǍǎǞǟǠǡǺǻẠạẢảẤấẦầẨẩẪẫẬậẮắẰằẲẳẴẵẶặ AAAaaAaa AEAeaEae ÆæǢǣǼǽ Bb ƀ Ɓ Ƃƃ CcÇçĆćĈĉĊċ CHChcHch Čč Ƈƈ DdĎď DZDzdZdzDŽDždžDZDzdz DŽDždŽdž Đđ Ɖ Ɗ Ƌƌ Ðð EeÈÉÊËèéêëĒēĔĕĖėĘęĚěẸẹẺẻẼẽẾếỀềỂểỄễỆệ Ǝǝ Ə Ɛ Ff Ƒƒ GgĜĝĞğĠġĢģǦǧǴǵ Ǥǥ Ɠ Ɣ Ƣƣ HhĤĥ ƕǶ Ħħ IiÌÍÎÏìíîïĨĩĪīĬĭĮįİǏǐỈỉỊị IJIjiJijIJij ı Ɨ Ɩ JjĴĵǰ KkĶķǨǩ Ƙƙ LlĹĺĻļĽľ Ŀŀ LJLjlJljLJLjlj LLLllLll Łł ƚ ƛ Mm NnÑñŃńŅņŇňǸǹ NJNjnJnjNJNjnj Ɲ ƞ Ŋŋ OoÒÓÔÕÖòóôõöŌōŎŏŐőƠơǑǒǪǫǬǭỌọỎỏỐốỒồỔổỖỗỘộỚớỜờỞởỠỡỢợ OEOeoEoeŒœ ØøǾǿ Ɔ Ɵ Pp Ƥƥ Qq ĸ RrŔŕŖŗŘř RRRrrRrr Ʀ SsŚśŜŝŞşſ SSSssSssß Šš Ʃ ƪ TtŢţŤť ƾ Ŧŧ ƫ Ƭƭ Ʈ UuÙÚÛÜùúûüŨũŪūŬŭŮůŰűŲųƯưǓǔǕǖǗǘǙǚǛǜỤụỦủỨứỪừỬửỮữỰự Ɯ Ʊ Vv Ʋ WwŴŵ Xx YyÝýÿŶŷŸ Ƴƴ ZzŹźŻż ƍ Žž Ƶƶ ƷǮǯ Ƹƹ ƺ Þþ ƿǷ ƻ Ƨƨ Ƽƽ Ƅƅ ʼn ǀ ǁ ǂ ǃ select group_concat(c1 order by binary c1 separator '') from t1 group by c1 collate utf32_polish_ci; group_concat(c1 order by binary c1 separator '') ÷ × AaÀÁÂÃÄÅàáâãäåĀāĂăǍǎǞǟǠǡǺǻẠạẢảẤấẦầẨẩẪẫẬậẮắẰằẲẳẴẵẶặ AAAaaAaa AEAeaEae Ąą ÆæǢǣǼǽ Bb ƀ Ɓ Ƃƃ CcÇçĈĉĊċČč CHChcHch Ćć Ƈƈ DdĎď DZDzDŽDždZdzdŽdžDŽDždžDZDzdz Đđ Ɖ Ɗ Ƌƌ Ðð EeÈÉÊËèéêëĒēĔĕĖėĚěẸẹẺẻẼẽẾếỀềỂểỄễỆệ Ęę Ǝǝ Ə Ɛ Ff Ƒƒ GgĜĝĞğĠġĢģǦǧǴǵ Ǥǥ Ɠ Ɣ Ƣƣ HhĤĥ ƕǶ Ħħ IiÌÍÎÏìíîïĨĩĪīĬĭĮįİǏǐỈỉỊị IJIjiJijIJij ı Ɨ Ɩ JjĴĵǰ KkĶķǨǩ Ƙƙ LlĹĺĻļĽľ Ŀŀ LJLjlJljLJLjlj LLLllLll Łł ƚ ƛ Mm NnÑñŅņŇňǸǹ NJNjnJnjNJNjnj Ńń Ɲ ƞ Ŋŋ OoÒÔÕÖòôõöŌōŎŏŐőƠơǑǒǪǫǬǭỌọỎỏỐốỒồỔổỖỗỘộỚớỜờỞởỠỡỢợ OEOeoEoeŒœ Óó ØøǾǿ Ɔ Ɵ Pp Ƥƥ Qq ĸ RrŔŕŖŗŘř RRRrrRrr Ʀ SsŜŝŞşŠšſ SSSssSssß Śś Ʃ ƪ TtŢţŤť ƾ Ŧŧ ƫ Ƭƭ Ʈ UuÙÚÛÜùúûüŨũŪūŬŭŮůŰűŲųƯưǓǔǕǖǗǘǙǚǛǜỤụỦủỨứỪừỬửỮữỰự Ɯ Ʊ Vv Ʋ WwŴŵ Xx YyÝýÿŶŷŸ Ƴƴ ZzŽž ƍ Źź Żż Ƶƶ ƷǮǯ Ƹƹ ƺ Þþ ƿǷ ƻ Ƨƨ Ƽƽ Ƅƅ ʼn ǀ ǁ ǂ ǃ select group_concat(c1 order by binary c1 separator '') from t1 group by c1 collate utf32_estonian_ci; group_concat(c1 order by binary c1 separator '') ÷ × AaÀÁÂÃÅàáâãåĀāĂ㥹ǍǎǞǟǠǡǺǻẠạẢảẤấẦầẨẩẪẫẬậẮắẰằẲẳẴẵẶặ AAAaaAaa AEAeaEae ÆæǢǣǼǽ Bb ƀ Ɓ Ƃƃ CcÇçĆćĈĉĊċČč CHChcHch Ƈƈ DdĎď DZDzdZdz DŽDždŽdž DŽDždžDZDzdz Đđ Ɖ Ɗ Ƌƌ Ðð EeÈÉÊËèéêëĒēĔĕĖėĘęĚěẸẹẺẻẼẽẾếỀềỂểỄễỆệ Ǝǝ Ə Ɛ Ff Ƒƒ GgĜĝĞğĠġĢģǦǧǴǵ Ǥǥ Ɠ Ɣ Ƣƣ HhĤĥ ƕǶ Ħħ IiÌÍÎÏìíîïĨĩĪīĬĭĮįİǏǐỈỉỊị IJIjiJijIJij ı Ɨ Ɩ JjĴĵǰ KkĶķǨǩ Ƙƙ LlĹĺĻļĽľ Ŀŀ LJLjlJljLJLjlj LLLllLll Łł ƚ ƛ Mm NnÑñŃńŅņŇňǸǹ NJNjnJnjNJNjnj Ɲ ƞ Ŋŋ OoÒÓÔòóôŌōŎŏŐőƠơǑǒǪǫǬǭỌọỎỏỐốỒồỔổỖỗỘộỚớỜờỞởỠỡỢợ OEOeoEoeŒœ ØøǾǿ Ɔ Ɵ Pp Ƥƥ Qq ĸ RrŔŕŖŗŘř RRRrrRrr Ʀ SsŚśŜŝŞşſ SSSssSssß Šš Zz Žž Ʃ ƪ TtŢţŤť ƾ Ŧŧ ƫ Ƭƭ Ʈ UuÙÚÛùúûŨũŪūŬŭŮůŰűŲųƯưǓǔǕǖǗǘǙǚǛǜỤụỦủỨứỪừỬửỮữỰự Ɯ Ʊ Vv Ʋ WwŴŵ Õõ Ää Öö Üü Xx YyÝýÿŶŷŸ Ƴƴ ŹźŻż ƍ Ƶƶ ƷǮǯ Ƹƹ ƺ Þþ ƿǷ ƻ Ƨƨ Ƽƽ Ƅƅ ʼn ǀ ǁ ǂ ǃ select group_concat(c1 order by binary c1 separator '') from t1 group by c1 collate utf32_spanish_ci; group_concat(c1 order by binary c1 separator '') ÷ × AaÀÁÂÃÄÅàáâãäåĀāĂ㥹ǍǎǞǟǠǡǺǻẠạẢảẤấẦầẨẩẪẫẬậẮắẰằẲẳẴẵẶặ AAAaaAaa AEAeaEae ÆæǢǣǼǽ Bb ƀ Ɓ Ƃƃ CcÇçĆćĈĉĊċČč CHChcHch Ƈƈ DdĎď DZDzDŽDždZdzdŽdžDŽDždžDZDzdz Đđ Ɖ Ɗ Ƌƌ Ðð EeÈÉÊËèéêëĒēĔĕĖėĘęĚěẸẹẺẻẼẽẾếỀềỂểỄễỆệ Ǝǝ Ə Ɛ Ff Ƒƒ GgĜĝĞğĠġĢģǦǧǴǵ Ǥǥ Ɠ Ɣ Ƣƣ HhĤĥ ƕǶ Ħħ IiÌÍÎÏìíîïĨĩĪīĬĭĮįİǏǐỈỉỊị IJIjiJijIJij ı Ɨ Ɩ JjĴĵǰ KkĶķǨǩ Ƙƙ LlĹĺĻļĽľ Ŀŀ LJLjlJljLJLjlj LLLllLll Łł ƚ ƛ Mm NnŃńŅņŇňǸǹ NJNjnJnjNJNjnj Ññ Ɲ ƞ Ŋŋ OoÒÓÔÕÖòóôõöŌōŎŏŐőƠơǑǒǪǫǬǭỌọỎỏỐốỒồỔổỖỗỘộỚớỜờỞởỠỡỢợ OEOeoEoeŒœ ØøǾǿ Ɔ Ɵ Pp Ƥƥ Qq ĸ RrŔŕŖŗŘř RRRrrRrr Ʀ SsŚśŜŝŞşŠšſ SSSssSssß Ʃ ƪ TtŢţŤť ƾ Ŧŧ ƫ Ƭƭ Ʈ UuÙÚÛÜùúûüŨũŪūŬŭŮůŰűŲųƯưǓǔǕǖǗǘǙǚǛǜỤụỦủỨứỪừỬửỮữỰự Ɯ Ʊ Vv Ʋ WwŴŵ Xx YyÝýÿŶŷŸ Ƴƴ ZzŹźŻżŽž ƍ Ƶƶ ƷǮǯ Ƹƹ ƺ Þþ ƿǷ ƻ Ƨƨ Ƽƽ Ƅƅ ʼn ǀ ǁ ǂ ǃ select group_concat(c1 order by binary c1 separator '') from t1 group by c1 collate utf32_swedish_ci; group_concat(c1 order by binary c1 separator '') ÷ × AaÀÁÂÃàáâãĀāĂ㥹ǍǎǞǟǠǡǺǻẠạẢảẤấẦầẨẩẪẫẬậẮắẰằẲẳẴẵẶặ AAAaaAaa AEAeaEae ǢǣǼǽ Bb ƀ Ɓ Ƃƃ CcÇçĆćĈĉĊċČč CHChcHch Ƈƈ DdĎď DZDzDŽDždZdzdŽdžDŽDždžDZDzdz Đđ Ɖ Ɗ Ƌƌ Ðð EeÈÉÊËèéêëĒēĔĕĖėĘęĚěẸẹẺẻẼẽẾếỀềỂểỄễỆệ Ǝǝ Ə Ɛ Ff Ƒƒ GgĜĝĞğĠġĢģǦǧǴǵ Ǥǥ Ɠ Ɣ Ƣƣ HhĤĥ ƕǶ Ħħ IiÌÍÎÏìíîïĨĩĪīĬĭĮįİǏǐỈỉỊị IJIjiJijIJij ı Ɨ Ɩ JjĴĵǰ KkĶķǨǩ Ƙƙ LlĹĺĻļĽľ Ŀŀ LJLjlJljLJLjlj LLLllLll Łł ƚ ƛ Mm NnÑñŃńŅņŇňǸǹ NJNjnJnjNJNjnj Ɲ ƞ Ŋŋ OoÒÓÔÕòóôõŌōŎŏŐőƠơǑǒǪǫǬǭỌọỎỏỐốỒồỔổỖỗỘộỚớỜờỞởỠỡỢợ OEOeoEoeŒœ Ǿǿ Ɔ Ɵ Pp Ƥƥ Qq ĸ RrŔŕŖŗŘř RRRrrRrr Ʀ SsŚśŜŝŞşŠšſ SSSssSssß Ʃ ƪ TtŢţŤť ƾ Ŧŧ ƫ Ƭƭ Ʈ UuÙÚÛùúûŨũŪūŬŭŮůŰűŲųƯưǓǔǕǖǗǘǙǚǛǜỤụỦủỨứỪừỬửỮữỰự Ɯ Ʊ Vv Ʋ WwŴŵ Xx YyÜÝüýÿŶŷŸ Ƴƴ ZzŹźŻżŽž ƍ Åå ÄÆäæ ÖØöø Ƶƶ ƷǮǯ Ƹƹ ƺ Þþ ƿǷ ƻ Ƨƨ Ƽƽ Ƅƅ ʼn ǀ ǁ ǂ ǃ select group_concat(c1 order by binary c1 separator '') from t1 group by c1 collate utf32_turkish_ci; group_concat(c1 order by binary c1 separator '') ÷ × AaÀÁÂÃÄÅàáâãäåĀāĂ㥹ǍǎǞǟǠǡǺǻẠạẢảẤấẦầẨẩẪẫẬậẮắẰằẲẳẴẵẶặ AAAaaAaa AEAeaEae ÆæǢǣǼǽ Bb ƀ Ɓ Ƃƃ CcĆćĈĉĊċČč CHChcHch Çç Ƈƈ DdĎď DZDzDŽDždZdzdŽdžDŽDždžDZDzdz Đđ Ɖ Ɗ Ƌƌ Ðð EeÈÉÊËèéêëĒēĔĕĖėĘęĚěẸẹẺẻẼẽẾếỀềỂểỄễỆệ Ǝǝ Ə Ɛ Ff Ƒƒ GgĜĝĠġĢģǦǧǴǵ Ğğ Ǥǥ Ɠ Ɣ Ƣƣ HhĤĥ Iı IJIj ƕǶ Ħħ iÌÍÎÏìíîïĨĩĪīĬĭĮįİǏǐỈỉỊị iJijIJij Ɨ Ɩ JjĴĵǰ KkĶķǨǩ Ƙƙ LlĹĺĻļĽľ Ŀŀ LJLjlJljLJLjlj LLLllLll Łł ƚ ƛ Mm NnÑñŃńŅņŇňǸǹ NJNjnJnjNJNjnj Ɲ ƞ Ŋŋ OoÒÓÔÕòóôõŌōŎŏŐőƠơǑǒǪǫǬǭỌọỎỏỐốỒồỔổỖỗỘộỚớỜờỞởỠỡỢợ OEOeoEoeŒœ Öö ØøǾǿ Ɔ Ɵ Pp Ƥƥ Qq ĸ RrŔŕŖŗŘř RRRrrRrr Ʀ SsŚśŜŝŠšſ SSSssSssß Şş Ʃ ƪ TtŢţŤť ƾ Ŧŧ ƫ Ƭƭ Ʈ UuÙÚÛùúûŨũŪūŬŭŮůŰűŲųƯưǓǔǕǖǗǘǙǚǛǜỤụỦủỨứỪừỬửỮữỰự Üü Ɯ Ʊ Vv Ʋ WwŴŵ Xx YyÝýÿŶŷŸ Ƴƴ ZzŹźŻżŽž ƍ Ƶƶ ƷǮǯ Ƹƹ ƺ Þþ ƿǷ ƻ Ƨƨ Ƽƽ Ƅƅ ʼn ǀ ǁ ǂ ǃ select group_concat(c1 order by binary c1 separator '') from t1 group by c1 collate utf32_czech_ci; group_concat(c1 order by binary c1 separator '') ÷ × AaÀÁÂÃÄÅàáâãäåĀāĂ㥹ǍǎǞǟǠǡǺǻẠạẢảẤấẦầẨẩẪẫẬậẮắẰằẲẳẴẵẶặ AAAaaAaa AEAeaEae ÆæǢǣǼǽ Bb ƀ Ɓ Ƃƃ CcÇçĆćĈĉĊċ cH Čč Ƈƈ DdĎď DZDzdZdzDŽDždžDZDzdz DŽDždŽdž Đđ Ɖ Ɗ Ƌƌ Ðð EeÈÉÊËèéêëĒēĔĕĖėĘęĚěẸẹẺẻẼẽẾếỀềỂểỄễỆệ Ǝǝ Ə Ɛ Ff Ƒƒ GgĜĝĞğĠġĢģǦǧǴǵ Ǥǥ Ɠ Ɣ Ƣƣ HhĤĥ CHChch ƕǶ Ħħ IiÌÍÎÏìíîïĨĩĪīĬĭĮįİǏǐỈỉỊị IJIjiJijIJij ı Ɨ Ɩ JjĴĵǰ KkĶķǨǩ Ƙƙ LlĹĺĻļĽľ Ŀŀ LJLjlJljLJLjlj LLLllLll Łł ƚ ƛ Mm NnÑñŃńŅņŇňǸǹ NJNjnJnjNJNjnj Ɲ ƞ Ŋŋ OoÒÓÔÕÖòóôõöŌōŎŏŐőƠơǑǒǪǫǬǭỌọỎỏỐốỒồỔổỖỗỘộỚớỜờỞởỠỡỢợ OEOeoEoeŒœ ØøǾǿ Ɔ Ɵ Pp Ƥƥ Qq ĸ RrŔŕŖŗ RRRrrRrr Řř Ʀ SsŚśŜŝŞşſ SSSssSssß Šš Ʃ ƪ TtŢţŤť ƾ Ŧŧ ƫ Ƭƭ Ʈ UuÙÚÛÜùúûüŨũŪūŬŭŮůŰűŲųƯưǓǔǕǖǗǘǙǚǛǜỤụỦủỨứỪừỬửỮữỰự Ɯ Ʊ Vv Ʋ WwŴŵ Xx YyÝýÿŶŷŸ Ƴƴ ZzŹźŻż ƍ Žž Ƶƶ ƷǮǯ Ƹƹ ƺ Þþ ƿǷ ƻ Ƨƨ Ƽƽ Ƅƅ ʼn ǀ ǁ ǂ ǃ select group_concat(c1 order by binary c1 separator '') from t1 group by c1 collate utf32_danish_ci; group_concat(c1 order by binary c1 separator '') ÷ × AaÀÁÂÃàáâãĀāĂ㥹ǍǎǞǟǠǡǺǻẠạẢảẤấẦầẨẩẪẫẬậẮắẰằẲẳẴẵẶặ aA AEAeaEae ǢǣǼǽ Bb ƀ Ɓ Ƃƃ CcÇçĆćĈĉĊċČč CHChcHch Ƈƈ DdĎď DZDzDŽDždZdzdŽdžDŽDždžDZDzdz Đđ Ɖ Ɗ Ƌƌ Ðð EeÈÉÊËèéêëĒēĔĕĖėĘęĚěẸẹẺẻẼẽẾếỀềỂểỄễỆệ Ǝǝ Ə Ɛ Ff Ƒƒ GgĜĝĞğĠġĢģǦǧǴǵ Ǥǥ Ɠ Ɣ Ƣƣ HhĤĥ ƕǶ Ħħ IiÌÍÎÏìíîïĨĩĪīĬĭĮįİǏǐỈỉỊị IJIjiJijIJij ı Ɨ Ɩ JjĴĵǰ KkĶķǨǩ Ƙƙ LlĹĺĻļĽľ Ŀŀ LJLjlJljLJLjlj LLLllLll Łł ƚ ƛ Mm NnÑñŃńŅņŇňǸǹ NJNjnJnjNJNjnj Ɲ ƞ Ŋŋ OoÒÓÔÕòóôõŌōŎŏƠơǑǒǪǫǬǭỌọỎỏỐốỒồỔổỖỗỘộỚớỜờỞởỠỡỢợ OEOeoEoeŒœ Ǿǿ Ɔ Ɵ Pp Ƥƥ Qq ĸ RrŔŕŖŗŘř RRRrrRrr Ʀ SsŚśŜŝŞşŠšſ SSSssSssß Ʃ ƪ TtŢţŤť ƾ Ŧŧ ƫ Ƭƭ Ʈ UuÙÚÛùúûŨũŪūŬŭŮůŲųƯưǓǔǕǖǗǘǙǚǛǜỤụỦủỨứỪừỬửỮữỰự Ɯ Ʊ Vv Ʋ WwŴŵ Xx YyÜÝüýÿŰűŶŷŸ Ƴƴ ZzŹźŻżŽž ƍ ÄÆäæ ÖØöøŐő AAAaaaÅå Ƶƶ ƷǮǯ Ƹƹ ƺ Þþ ƿǷ ƻ Ƨƨ Ƽƽ Ƅƅ ʼn ǀ ǁ ǂ ǃ select group_concat(c1 order by binary c1 separator '') from t1 group by c1 collate utf32_lithuanian_ci; group_concat(c1 order by binary c1 separator '') ÷ × AaÀÁÂÃÄÅàáâãäåĀāĂ㥹ǍǎǞǟǠǡǺǻẠạẢảẤấẦầẨẩẪẫẬậẮắẰằẲẳẴẵẶặ AAAaaAaa AEAeaEae ÆæǢǣǼǽ Bb ƀ Ɓ Ƃƃ CCHChcchÇçĆćĈĉĊċ cH Čč Ƈƈ DdĎď DZDzdZdzDŽDždžDZDzdz DŽDždŽdž Đđ Ɖ Ɗ Ƌƌ Ðð EeÈÉÊËèéêëĒēĔĕĖėĘęĚěẸẹẺẻẼẽẾếỀềỂểỄễỆệ Ǝǝ Ə Ɛ Ff Ƒƒ GgĜĝĞğĠġĢģǦǧǴǵ Ǥǥ Ɠ Ɣ Ƣƣ HhĤĥ ƕǶ Ħħ IYiyÌÍÎÏìíîïĨĩĪīĬĭĮįİǏǐỈỉỊị IJIjiJijIJij ı Ɨ Ɩ JjĴĵǰ KkĶķǨǩ Ƙƙ LlĹĺĻļĽľ Ŀŀ LJLjlJljLJLjlj LLLllLll Łł ƚ ƛ Mm NnÑñŃńŅņŇňǸǹ NJNjnJnjNJNjnj Ɲ ƞ Ŋŋ OoÒÓÔÕÖòóôõöŌōŎŏŐőƠơǑǒǪǫǬǭỌọỎỏỐốỒồỔổỖỗỘộỚớỜờỞởỠỡỢợ OEOeoEoeŒœ ØøǾǿ Ɔ Ɵ Pp Ƥƥ Qq ĸ RrŔŕŖŗŘř RRRrrRrr Ʀ SsŚśŜŝŞşſ SSSssSssß Šš Ʃ ƪ TtŢţŤť ƾ Ŧŧ ƫ Ƭƭ Ʈ UuÙÚÛÜùúûüŨũŪūŬŭŮůŰűŲųƯưǓǔǕǖǗǘǙǚǛǜỤụỦủỨứỪừỬửỮữỰự Ɯ Ʊ Vv Ʋ WwŴŵ Xx ÝýÿŶŷŸ Ƴƴ ZzŹźŻż ƍ Žž Ƶƶ ƷǮǯ Ƹƹ ƺ Þþ ƿǷ ƻ Ƨƨ Ƽƽ Ƅƅ ʼn ǀ ǁ ǂ ǃ select group_concat(c1 order by binary c1 separator '') from t1 group by c1 collate utf32_slovak_ci; group_concat(c1 order by binary c1 separator '') ÷ × AaÀÁÂÃÅàáâãåĀāĂ㥹ǍǎǞǟǠǡǺǻẠạẢảẤấẦầẨẩẪẫẬậẮắẰằẲẳẴẵẶặ AAAaaAaa AEAeaEae Ää ÆæǢǣǼǽ Bb ƀ Ɓ Ƃƃ CcÇçĆćĈĉĊċ cH Čč Ƈƈ DdĎď DZDzdZdzDŽDždžDZDzdz DŽDždŽdž Đđ Ɖ Ɗ Ƌƌ Ðð EeÈÉÊËèéêëĒēĔĕĖėĘęĚěẸẹẺẻẼẽẾếỀềỂểỄễỆệ Ǝǝ Ə Ɛ Ff Ƒƒ GgĜĝĞğĠġĢģǦǧǴǵ Ǥǥ Ɠ Ɣ Ƣƣ HhĤĥ CHChch ƕǶ Ħħ IiÌÍÎÏìíîïĨĩĪīĬĭĮįİǏǐỈỉỊị IJIjiJijIJij ı Ɨ Ɩ JjĴĵǰ KkĶķǨǩ Ƙƙ LlĹĺĻļĽľ Ŀŀ LJLjlJljLJLjlj LLLllLll Łł ƚ ƛ Mm NnÑñŃńŅņŇňǸǹ NJNjnJnjNJNjnj Ɲ ƞ Ŋŋ OoÒÓÕÖòóõöŌōŎŏŐőƠơǑǒǪǫǬǭỌọỎỏỐốỒồỔổỖỗỘộỚớỜờỞởỠỡỢợ OEOeoEoeŒœ Ôô ØøǾǿ Ɔ Ɵ Pp Ƥƥ Qq ĸ RrŔŕŖŗŘř RRRrrRrr Ʀ SsŚśŜŝŞşſ SSSssSssß Šš Ʃ ƪ TtŢţŤť ƾ Ŧŧ ƫ Ƭƭ Ʈ UuÙÚÛÜùúûüŨũŪūŬŭŮůŰűŲųƯưǓǔǕǖǗǘǙǚǛǜỤụỦủỨứỪừỬửỮữỰự Ɯ Ʊ Vv Ʋ WwŴŵ Xx YyÝýÿŶŷŸ Ƴƴ ZzŹźŻż ƍ Žž Ƶƶ ƷǮǯ Ƹƹ ƺ Þþ ƿǷ ƻ Ƨƨ Ƽƽ Ƅƅ ʼn ǀ ǁ ǂ ǃ select group_concat(c1 order by binary c1 separator '') from t1 group by c1 collate utf32_spanish2_ci; group_concat(c1 order by binary c1 separator '') ÷ × AaÀÁÂÃÄÅàáâãäåĀāĂ㥹ǍǎǞǟǠǡǺǻẠạẢảẤấẦầẨẩẪẫẬậẮắẰằẲẳẴẵẶặ AAAaaAaa AEAeaEae ÆæǢǣǼǽ Bb ƀ Ɓ Ƃƃ CcÇçĆćĈĉĊċČč cH CHChch Ƈƈ DdĎď DZDzDŽDždZdzdŽdžDŽDždžDZDzdz Đđ Ɖ Ɗ Ƌƌ Ðð EeÈÉÊËèéêëĒēĔĕĖėĘęĚěẸẹẺẻẼẽẾếỀềỂểỄễỆệ Ǝǝ Ə Ɛ Ff Ƒƒ GgĜĝĞğĠġĢģǦǧǴǵ Ǥǥ Ɠ Ɣ Ƣƣ HhĤĥ ƕǶ Ħħ IiÌÍÎÏìíîïĨĩĪīĬĭĮįİǏǐỈỉỊị IJIjiJijIJij ı Ɨ Ɩ JjĴĵǰ KkĶķǨǩ Ƙƙ LlĹĺĻļĽľ Ŀŀ LJLjlJljLJLjlj lL LLLlll Łł ƚ ƛ Mm NnŃńŅņŇňǸǹ NJNjnJnjNJNjnj Ññ Ɲ ƞ Ŋŋ OoÒÓÔÕÖòóôõöŌōŎŏŐőƠơǑǒǪǫǬǭỌọỎỏỐốỒồỔổỖỗỘộỚớỜờỞởỠỡỢợ OEOeoEoeŒœ ØøǾǿ Ɔ Ɵ Pp Ƥƥ Qq ĸ RrŔŕŖŗŘř RRRrrRrr Ʀ SsŚśŜŝŞşŠšſ SSSssSssß Ʃ ƪ TtŢţŤť ƾ Ŧŧ ƫ Ƭƭ Ʈ UuÙÚÛÜùúûüŨũŪūŬŭŮůŰűŲųƯưǓǔǕǖǗǘǙǚǛǜỤụỦủỨứỪừỬửỮữỰự Ɯ Ʊ Vv Ʋ WwŴŵ Xx YyÝýÿŶŷŸ Ƴƴ ZzŹźŻżŽž ƍ Ƶƶ ƷǮǯ Ƹƹ ƺ Þþ ƿǷ ƻ Ƨƨ Ƽƽ Ƅƅ ʼn ǀ ǁ ǂ ǃ select group_concat(c1 order by binary c1 separator '') from t1 group by c1 collate utf32_roman_ci; group_concat(c1 order by binary c1 separator '') ÷ × AaÀÁÂÃÄÅàáâãäåĀāĂ㥹ǍǎǞǟǠǡǺǻẠạẢảẤấẦầẨẩẪẫẬậẮắẰằẲẳẴẵẶặ AAAaaAaa AEAeaEae ÆæǢǣǼǽ Bb ƀ Ɓ Ƃƃ CcÇçĆćĈĉĊċČč CHChcHch Ƈƈ DdĎď DZDzDŽDždZdzdŽdžDŽDždžDZDzdz Đđ Ɖ Ɗ Ƌƌ Ðð EeÈÉÊËèéêëĒēĔĕĖėĘęĚěẸẹẺẻẼẽẾếỀềỂểỄễỆệ Ǝǝ Ə Ɛ Ff Ƒƒ GgĜĝĞğĠġĢģǦǧǴǵ Ǥǥ Ɠ Ɣ Ƣƣ HhĤĥ ƕǶ Ħħ IJijÌÍÎÏìíîïĨĩĪīĬĭĮįİǏǐỈỉỊị IJIjiJij IJij ı Ɨ Ɩ Ĵĵǰ KkĶķǨǩ Ƙƙ LlĹĺĻļĽľ Ŀŀ LJLjlJlj LJLjlj LLLllLll Łł ƚ ƛ Mm NnÑñŃńŅņŇňǸǹ NJNjnJnj NJNjnj Ɲ ƞ Ŋŋ OoÒÓÔÕÖòóôõöŌōŎŏŐőƠơǑǒǪǫǬǭỌọỎỏỐốỒồỔổỖỗỘộỚớỜờỞởỠỡỢợ OEOeoEoeŒœ ØøǾǿ Ɔ Ɵ Pp Ƥƥ Qq ĸ RrŔŕŖŗŘř RRRrrRrr Ʀ SsŚśŜŝŞşŠšſ SSSssSssß Ʃ ƪ TtŢţŤť ƾ Ŧŧ ƫ Ƭƭ Ʈ ÙÚÛÜùúûüŨũŪūŬŭŮůŰűŲųƯưǓǔǕǖǗǘǙǚǛǜỤụỦủỨứỪừỬửỮữỰự Ɯ Ʊ UVuv Ʋ WwŴŵ Xx YyÝýÿŶŷŸ Ƴƴ ZzŹźŻżŽž ƍ Ƶƶ ƷǮǯ Ƹƹ ƺ Þþ ƿǷ ƻ Ƨƨ Ƽƽ Ƅƅ ʼn ǀ ǁ ǂ ǃ select group_concat(c1 order by binary c1 separator '') from t1 group by c1 collate utf32_esperanto_ci; group_concat(c1 order by binary c1 separator '') ÷ × AaÀÁÂÃÄÅàáâãäåĀāĂ㥹ǍǎǞǟǠǡǺǻẠạẢảẤấẦầẨẩẪẫẬậẮắẰằẲẳẴẵẶặ AAAaaAaa AEAeaEae ÆæǢǣǼǽ Bb ƀ Ɓ Ƃƃ CcÇçĆćĊċČč CHChcHch Ĉĉ Ƈƈ DdĎď DZDzDŽDždZdzdŽdžDŽDždžDZDzdz Đđ Ɖ Ɗ Ƌƌ Ðð EeÈÉÊËèéêëĒēĔĕĖėĘęĚěẸẹẺẻẼẽẾếỀềỂểỄễỆệ Ǝǝ Ə Ɛ Ff Ƒƒ GgĞğĠġĢģǦǧǴǵ Ĝĝ Ǥǥ Ɠ Ɣ Ƣƣ Hh Ĥĥ ƕǶ Ħħ IiÌÍÎÏìíîïĨĩĪīĬĭĮįİǏǐỈỉỊị IJIjiJijIJij ı Ɨ Ɩ Jjǰ Ĵĵ KkĶķǨǩ Ƙƙ LlĹĺĻļĽľ Ŀŀ LJLjlJljLJLjlj LLLllLll Łł ƚ ƛ Mm NnÑñŃńŅņŇňǸǹ NJNjnJnjNJNjnj Ɲ ƞ Ŋŋ OoÒÓÔÕÖòóôõöŌōŎŏŐőƠơǑǒǪǫǬǭỌọỎỏỐốỒồỔổỖỗỘộỚớỜờỞởỠỡỢợ OEOeoEoeŒœ ØøǾǿ Ɔ Ɵ Pp Ƥƥ Qq ĸ RrŔŕŖŗŘř RRRrrRrr Ʀ SsŚśŞşŠšſ SSSssSssß Ŝŝ Ʃ ƪ TtŢţŤť ƾ Ŧŧ ƫ Ƭƭ Ʈ UuÙÚÛÜùúûüŨũŪūŮůŰűŲųƯưǓǔǕǖǗǘǙǚǛǜỤụỦủỨứỪừỬửỮữỰự Ŭŭ Ɯ Ʊ Vv Ʋ WwŴŵ Xx YyÝýÿŶŷŸ Ƴƴ ZzŹźŻżŽž ƍ Ƶƶ ƷǮǯ Ƹƹ ƺ Þþ ƿǷ ƻ Ƨƨ Ƽƽ Ƅƅ ʼn ǀ ǁ ǂ ǃ select group_concat(c1 order by binary c1 separator '') from t1 group by c1 collate utf32_hungarian_ci; group_concat(c1 order by binary c1 separator '') ÷ × AaÀÁÂÃÄÅàáâãäåĀāĂ㥹ǍǎǞǟǠǡǺǻẠạẢảẤấẦầẨẩẪẫẬậẮắẰằẲẳẴẵẶặ AAAaaAaa AEAeaEae ÆæǢǣǼǽ Bb ƀ Ɓ Ƃƃ CcÇçĆćĈĉĊċČč CHChcHch Ƈƈ DdĎď DZDzDŽDždZdzdŽdžDŽDždžDZDzdz Đđ Ɖ Ɗ Ƌƌ Ðð EeÈÉÊËèéêëĒēĔĕĖėĘęĚěẸẹẺẻẼẽẾếỀềỂểỄễỆệ Ǝǝ Ə Ɛ Ff Ƒƒ GgĜĝĞğĠġĢģǦǧǴǵ Ǥǥ Ɠ Ɣ Ƣƣ HhĤĥ ƕǶ Ħħ IiÌÍÎÏìíîïĨĩĪīĬĭĮįİǏǐỈỉỊị IJIjiJijIJij ı Ɨ Ɩ JjĴĵǰ KkĶķǨǩ Ƙƙ LlĹĺĻļĽľ Ŀŀ LJLjlJljLJLjlj LLLllLll Łł ƚ ƛ Mm NnÑñŃńŅņŇňǸǹ NJNjnJnjNJNjnj Ɲ ƞ Ŋŋ OoÒÓÔÕòóôõŌōŎŏƠơǑǒǪǫǬǭỌọỎỏỐốỒồỔổỖỗỘộỚớỜờỞởỠỡỢợ OEOeoEoeŒœ ÖöŐő ØøǾǿ Ɔ Ɵ Pp Ƥƥ Qq ĸ RrŔŕŖŗŘř RRRrrRrr Ʀ SsŚśŜŝŞşŠšſ SSSssSssß Ʃ ƪ TtŢţŤť ƾ Ŧŧ ƫ Ƭƭ Ʈ UuÙÚÛùúûŨũŪūŬŭŮůŲųƯưǓǔǕǖǗǘǙǚǛǜỤụỦủỨứỪừỬửỮữỰự ÜüŰű Ɯ Ʊ Vv Ʋ WwŴŵ Xx YyÝýÿŶŷŸ Ƴƴ ZzŹźŻżŽž ƍ Ƶƶ ƷǮǯ Ƹƹ ƺ Þþ ƿǷ ƻ Ƨƨ Ƽƽ Ƅƅ ʼn ǀ ǁ ǂ ǃ select group_concat(c1 order by binary c1 separator '') from t1 group by c1 collate utf32_croatian_ci; group_concat(c1 order by binary c1 separator '') ÷ × AaÀÁÂÃÄÅàáâãäåĀāĂ㥹ǍǎǞǟǠǡǺǻẠạẢảẤấẦầẨẩẪẫẬậẮắẰằẲẳẴẵẶặ AAAaaAaa AEAeaEae ÆæǢǣǼǽ Bb ƀ Ɓ Ƃƃ CcÇçĈĉĊċ CHChcHch Čč Ćć Ƈƈ DdĎď DZDzdZdzDZDzdz DŽDždŽdžDŽDždž Đđ Ɖ Ɗ Ƌƌ Ðð EeÈÉÊËèéêëĒēĔĕĖėĘęĚěẸẹẺẻẼẽẾếỀềỂểỄễỆệ Ǝǝ Ə Ɛ Ff Ƒƒ GgĜĝĞğĠġĢģǦǧǴǵ Ǥǥ Ɠ Ɣ Ƣƣ HhĤĥ ƕǶ Ħħ IiÌÍÎÏìíîïĨĩĪīĬĭĮįİǏǐỈỉỊị IJIjiJijIJij ı Ɨ Ɩ JjĴĵǰ KkĶķǨǩ Ƙƙ LlĹĺĻļĽľ Ŀŀ LLLllLll LJLjlJljLJLjlj Łł ƚ ƛ Mm NnÑñŃńŅņŇňǸǹ NJNjnJnjNJNjnj Ɲ ƞ Ŋŋ OoÒÓÔÕÖòóôõöŌōŎŏŐőƠơǑǒǪǫǬǭỌọỎỏỐốỒồỔổỖỗỘộỚớỜờỞởỠỡỢợ OEOeoEoeŒœ ØøǾǿ Ɔ Ɵ Pp Ƥƥ Qq ĸ RrŔŕŖŗŘř RRRrrRrr Ʀ SsŚśŜŝŞşſ SSSssSssß Šš Ʃ ƪ TtŢţŤť ƾ Ŧŧ ƫ Ƭƭ Ʈ UuÙÚÛÜùúûüŨũŪūŬŭŮůŰűŲųƯưǓǔǕǖǗǘǙǚǛǜỤụỦủỨứỪừỬửỮữỰự Ɯ Ʊ Vv Ʋ WwŴŵ Xx YyÝýÿŶŷŸ Ƴƴ ZzŹźŻż ƍ Žž Ƶƶ ƷǮǯ Ƹƹ ƺ Þþ ƿǷ ƻ Ƨƨ Ƽƽ Ƅƅ ʼn ǀ ǁ ǂ ǃ select group_concat(c1 order by binary c1 separator '') from t1 group by c1 collate utf32_german2_ci; group_concat(c1 order by binary c1 separator '') ÷ × AaÀÁÂÃÅàáâãåĀāĂ㥹ǍǎǞǟǠǡǺǻẠạẢảẤấẦầẨẩẪẫẬậẮắẰằẲẳẴẵẶặ AAAaaAaa AEAeaEaeÄÆäæ ǢǣǼǽ Bb ƀ Ɓ Ƃƃ CcÇçĆćĈĉĊċČč CHChcHch Ƈƈ DdĎď DZDzDŽDždZdzdŽdžDŽDždžDZDzdz Đđ Ɖ Ɗ Ƌƌ Ðð EeÈÉÊËèéêëĒēĔĕĖėĘęĚěẸẹẺẻẼẽẾếỀềỂểỄễỆệ Ǝǝ Ə Ɛ Ff Ƒƒ GgĜĝĞğĠġĢģǦǧǴǵ Ǥǥ Ɠ Ɣ Ƣƣ HhĤĥ ƕǶ Ħħ IiÌÍÎÏìíîïĨĩĪīĬĭĮįİǏǐỈỉỊị IJIjiJijIJij ı Ɨ Ɩ JjĴĵǰ KkĶķǨǩ Ƙƙ LlĹĺĻļĽľ Ŀŀ LJLjlJljLJLjlj LLLllLll Łł ƚ ƛ Mm NnÑñŃńŅņŇňǸǹ NJNjnJnjNJNjnj Ɲ ƞ Ŋŋ OoÒÓÔÕòóôõŌōŎŏŐőƠơǑǒǪǫǬǭỌọỎỏỐốỒồỔổỖỗỘộỚớỜờỞởỠỡỢợ OEOeoEoeÖöŒœ ØøǾǿ Ɔ Ɵ Pp Ƥƥ Qq ĸ RrŔŕŖŗŘř RRRrrRrr Ʀ SsŚśŜŝŞşŠšſ SSSssSssß Ʃ ƪ TtŢţŤť ƾ Ŧŧ ƫ Ƭƭ Ʈ UuÙÚÛùúûŨũŪūŬŭŮůŰűŲųƯưǓǔǕǖǗǘǙǚǛǜỤụỦủỨứỪừỬửỮữỰự Üü Ɯ Ʊ Vv Ʋ WwŴŵ Xx YyÝýÿŶŷŸ Ƴƴ ZzŹźŻżŽž ƍ Ƶƶ ƷǮǯ Ƹƹ ƺ Þþ ƿǷ ƻ Ƨƨ Ƽƽ Ƅƅ ʼn ǀ ǁ ǂ ǃ select group_concat(c1 order by binary c1 separator '') from t1 group by c1 collate utf32_unicode_520_ci; group_concat(c1 order by binary c1 separator '') ÷ × AaÀÁÂÃÄÅàáâãäåĀāĂ㥹ǍǎǞǟǠǡǺǻẠạẢảẤấẦầẨẩẪẫẬậẮắẰằẲẳẴẵẶặ AAAaaAaa AEAeaEaeÆæǢǣǼǽ Bb ƀ Ɓ Ƃƃ CcÇçĆćĈĉĊċČč CHChcHch Ƈƈ DdÐðĎďĐđ DZDzDŽDždZdzdŽdžDŽDždžDZDzdz Ɖ Ɗ Ƌƌ EeÈÉÊËèéêëĒēĔĕĖėĘęĚěẸẹẺẻẼẽẾếỀềỂểỄễỆệ Ǝǝ Ə Ɛ Ff Ƒƒ GgĜĝĞğĠġĢģǦǧǴǵ Ǥǥ Ɠ Ɣ Ƣƣ HhĤĥĦħ ƕǶ IiÌÍÎÏìíîïĨĩĪīĬĭĮįİǏǐỈỉỊị IJIjiJijIJij ı Ɨ Ɩ JjĴĵǰ KkĶķǨǩ Ƙƙ LlĹĺĻļĽľĿŀŁł LJLjlJljLJLjlj LLLllLll ƚ ƛ Mm NnÑñŃńŅņŇňǸǹ NJNjnJnjNJNjnj Ɲ ƞ Ŋŋ OoÒÓÔÕÖØòóôõöøŌōŎŏŐőƠơǑǒǪǫǬǭǾǿỌọỎỏỐốỒồỔổỖỗỘộỚớỜờỞởỠỡỢợ OEOeoEoeŒœ Ɔ Ɵ Pp Ƥƥ Qq ĸ RrŔŕŖŗŘř RRRrrRrr Ʀ SsŚśŜŝŞşŠšſ SSSssSssß Ʃ ƪ TtŢţŤť ƾ Ŧŧ ƫ Ƭƭ Ʈ UuÙÚÛÜùúûüŨũŪūŬŭŮůŰűŲųƯưǓǔǕǖǗǘǙǚǛǜỤụỦủỨứỪừỬửỮữỰự Ɯ Ʊ Vv Ʋ WwŴŵ Xx YyÝýÿŶŷŸ Ƴƴ ZzŹźŻżŽž ƍ Ƶƶ ƷǮǯ Ƹƹ ƺ Þþ ƿǷ ƻ Ƨƨ Ƽƽ Ƅƅ ʼn ǀ ǁ ǂ ǃ select group_concat(c1 order by binary c1 separator '') from t1 group by c1 collate utf32_vietnamese_ci; group_concat(c1 order by binary c1 separator '') ÷ × AaÀÁÃÄÅàáãäåĀāĄąǍǎǞǟǠǡǺǻẠạẢả AAAaaAaa AEAeaEae ĂăẮắẰằẲẳẴẵẶặ ÂâẤấẦầẨẩẪẫẬậ ÆæǢǣǼǽ Bb ƀ Ɓ Ƃƃ CcÇçĆćĈĉĊċČč CHChcHch Ƈƈ DdĎď DZDzDŽDždZdzdŽdžDŽDždžDZDzdz Đđ Ɖ Ɗ Ƌƌ Ðð EeÈÉËèéëĒēĔĕĖėĘęĚěẸẹẺẻẼẽ ÊêẾếỀềỂểỄễỆệ Ǝǝ Ə Ɛ Ff Ƒƒ GgĜĝĞğĠġĢģǦǧǴǵ Ǥǥ Ɠ Ɣ Ƣƣ HhĤĥ ƕǶ Ħħ IiÌÍÎÏìíîïĨĩĪīĬĭĮįİǏǐỈỉỊị IJIjiJijIJij ı Ɨ Ɩ JjĴĵǰ KkĶķǨǩ Ƙƙ LlĹĺĻļĽľ Ŀŀ LJLjlJljLJLjlj LLLllLll Łł ƚ ƛ Mm NnÑñŃńŅņŇňǸǹ NJNjnJnjNJNjnj Ɲ ƞ Ŋŋ OoÒÓÕÖòóõöŌōŎŏŐőǑǒǪǫǬǭỌọỎỏ OEOeoEoeŒœ ÔôỐốỒồỔổỖỗỘộ ƠơỚớỜờỞởỠỡỢợ ØøǾǿ Ɔ Ɵ Pp Ƥƥ Qq ĸ RrŔŕŖŗŘř RRRrrRrr Ʀ SsŚśŜŝŞşŠšſ SSSssSssß Ʃ ƪ TtŢţŤť ƾ Ŧŧ ƫ Ƭƭ Ʈ UuÙÚÛÜùúûüŨũŪūŬŭŮůŰűŲųǓǔǕǖǗǘǙǚǛǜỤụỦủ ƯưỨứỪừỬửỮữỰự Ɯ Ʊ Vv Ʋ WwŴŵ Xx YyÝýÿŶŷŸ Ƴƴ ZzŹźŻżŽž ƍ Ƶƶ ƷǮǯ Ƹƹ ƺ Þþ ƿǷ ƻ Ƨƨ Ƽƽ Ƅƅ ʼn ǀ ǁ ǂ ǃ drop table t1; SET NAMES utf8; CREATE TABLE t1 (c varchar(150) CHARACTER SET utf32 COLLATE utf32_general_ci NOT NULL, INDEX (c)); INSERT INTO t1 VALUES (_ucs2 0x039C03C903B403B11F770308); SELECT * FROM t1 WHERE c LIKE _utf32 0x0000039C00000025 COLLATE utf32_general_ci; c Μωδαί̈ INSERT INTO t1 VALUES (CONVERT(_ucs2 0x039C03C903B4 USING utf8)); SELECT * FROM t1 WHERE c LIKE _utf32 0x0000039C00000025 COLLATE utf32_general_ci ORDER BY c; c Μωδ Μωδαί̈ DROP TABLE t1; CREATE TABLE t1 (c varchar(150) CHARACTER SET utf32 COLLATE utf32_unicode_ci NOT NULL, INDEX (c)); INSERT INTO t1 VALUES (_ucs2 0x039C03C903B403B11F770308); SELECT * FROM t1 WHERE c LIKE _utf32 0x0000039C00000025 COLLATE utf32_unicode_ci; c Μωδαί̈ INSERT INTO t1 VALUES (_ucs2 0x039C03C903B4); SELECT * FROM t1 WHERE c LIKE _utf32 0x0000039C00000025 COLLATE utf32_unicode_ci ORDER BY c; c Μωδ Μωδαί̈ DROP TABLE t1; CREATE TABLE t1 (c varchar(150) CHARACTER SET utf32 COLLATE utf32_unicode_ci NOT NULL, INDEX (c)); INSERT INTO t1 VALUES (_ucs2 0x039C03C903B403B11F770308); SELECT * FROM t1 WHERE c LIKE CONVERT(_ucs2 0x039C0025 USING utf32) COLLATE utf32_unicode_ci; c Μωδαί̈ INSERT INTO t1 VALUES (CONVERT(_ucs2 0x039C03C903B4 USING utf8)); SELECT * FROM t1 WHERE c LIKE CONVERT(_ucs2 0x039C0025 USING utf32) COLLATE utf32_unicode_ci ORDER BY c; c Μωδ Μωδαί̈ DROP TABLE t1; SET NAMES utf8; SET @test_character_set='utf32'; SET @test_collation='utf32_swedish_ci'; SET @safe_character_set_server= @@character_set_server; SET @safe_collation_server= @@collation_server; SET @safe_character_set_client= @@character_set_client; SET @safe_character_set_results= @@character_set_results; SET character_set_server= @test_character_set; SET collation_server= @test_collation; CREATE DATABASE d1; USE d1; CREATE TABLE t1 (c CHAR(10), KEY(c)); SHOW FULL COLUMNS FROM t1; Field Type Collation Null Key Default Extra Privileges Comment c char(10) utf32_swedish_ci YES MUL NULL INSERT INTO t1 VALUES ('aaa'),('aaaa'),('aaaaa'); SELECT c as want3results FROM t1 WHERE c LIKE 'aaa%'; want3results aaa aaaa aaaaa DROP TABLE t1; CREATE TABLE t1 (c1 varchar(15), KEY c1 (c1(2))); SHOW FULL COLUMNS FROM t1; Field Type Collation Null Key Default Extra Privileges Comment c1 varchar(15) utf32_swedish_ci YES MUL NULL INSERT INTO t1 VALUES ('location'),('loberge'),('lotre'),('boabab'); SELECT c1 as want3results from t1 where c1 like 'l%'; want3results location loberge lotre SELECT c1 as want3results from t1 where c1 like 'lo%'; want3results location loberge lotre SELECT c1 as want1result from t1 where c1 like 'loc%'; want1result location SELECT c1 as want1result from t1 where c1 like 'loca%'; want1result location SELECT c1 as want1result from t1 where c1 like 'locat%'; want1result location SELECT c1 as want1result from t1 where c1 like 'locati%'; want1result location SELECT c1 as want1result from t1 where c1 like 'locatio%'; want1result location SELECT c1 as want1result from t1 where c1 like 'location%'; want1result location DROP TABLE t1; create table t1 (a set('a') not null); insert ignore into t1 values (),(); Warnings: Warning 1364 Field 'a' doesn't have a default value select cast(a as char(1)) from t1; cast(a as char(1)) select a sounds like a from t1; a sounds like a 1 1 select 1 from t1 order by cast(a as char(1)); 1 1 1 drop table t1; set names utf8; create table t1 ( name varchar(10), level smallint unsigned); show create table t1; Table Create Table t1 CREATE TABLE `t1` ( `name` varchar(10) COLLATE utf32_swedish_ci DEFAULT NULL, `level` smallint(5) unsigned DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf32 COLLATE=utf32_swedish_ci insert into t1 values ('string',1); select concat(name,space(level)), concat(name, repeat(' ',level)) from t1; concat(name,space(level)) concat(name, repeat(' ',level)) string string drop table t1; DROP DATABASE d1; USE test; SET character_set_server= @safe_character_set_server; SET collation_server= @safe_collation_server; SET character_set_client= @safe_character_set_client; SET character_set_results= @safe_character_set_results; SET collation_connection='utf32_unicode_ci'; create table t1 select repeat('a',4000) a; delete from t1; insert into t1 values ('a'), ('a '), ('a\t'); select collation(a),hex(a) from t1 order by a; collation(a) hex(a) utf32_unicode_ci 0000006100000009 utf32_unicode_ci 00000061 utf32_unicode_ci 0000006100000020 drop table t1; select @@collation_connection; @@collation_connection utf32_unicode_ci create table t1 ROW_FORMAT=DYNAMIC select repeat('a',50) as c1 ; insert into t1 values('abcdef'); insert into t1 values('_bcdef'); insert into t1 values('a_cdef'); insert into t1 values('ab_def'); insert into t1 values('abc_ef'); insert into t1 values('abcd_f'); insert into t1 values('abcde_'); select c1 as c1u from t1 where c1 like 'ab\_def'; c1u ab_def select c1 as c2h from t1 where c1 like 'ab#_def' escape '#'; c2h ab_def drop table t1; End of 4.1 tests CREATE TABLE t1 (id int, a varchar(30) character set utf32); INSERT INTO t1 VALUES (1, _ucs2 0x01310069), (2, _ucs2 0x01310131); INSERT INTO t1 VALUES (3, _ucs2 0x00690069), (4, _ucs2 0x01300049); INSERT INTO t1 VALUES (5, _ucs2 0x01300130), (6, _ucs2 0x00490049); SELECT a, length(a) la, @l:=lower(a) l, length(@l) ll, @u:=upper(a) u, length(@u) lu FROM t1 ORDER BY id; a la l ll u lu ıi 8 ıi 8 II 8 ıı 8 ıı 8 II 8 ii 8 ii 8 II 8 İI 8 ii 8 İI 8 İİ 8 ii 8 İİ 8 II 8 ii 8 II 8 ALTER TABLE t1 MODIFY a VARCHAR(30) character set utf32 collate utf32_turkish_ci; SELECT a, length(a) la, @l:=lower(a) l, length(@l) ll, @u:=upper(a) u, length(@u) lu FROM t1 ORDER BY id; a la l ll u lu ıi 8 ıi 8 Iİ 8 ıı 8 ıı 8 II 8 ii 8 ii 8 İİ 8 İI 8 iı 8 İI 8 İİ 8 ii 8 İİ 8 II 8 ıı 8 II 8 DROP TABLE t1; CREATE TABLE t1 ( c1 text character set utf32 collate utf32_polish_ci NOT NULL ) ENGINE=MyISAM; insert into t1 values (''),('a'); SELECT COUNT(*), c1 FROM t1 GROUP BY c1; COUNT(*) c1 1 1 a DROP TABLE IF EXISTS t1; set collation_connection=utf32_unicode_ci; drop table if exists t1; create table t1 as select repeat(' ', 64) as s1, repeat(' ',64) as s2 union select null, null; show create table t1; Table Create Table t1 CREATE TABLE `t1` ( `s1` varchar(64) CHARACTER SET utf32 COLLATE utf32_unicode_ci DEFAULT NULL, `s2` varchar(64) CHARACTER SET utf32 COLLATE utf32_unicode_ci DEFAULT NULL ) ENGINE=default_engine DEFAULT CHARSET=latin1 delete from t1; insert into t1 values('aaa','aaa'); insert into t1 values('aaa|qqq','qqq'); insert into t1 values('gheis','^[^a-dXYZ]+$'); insert into t1 values('aab','^aa?b'); insert into t1 values('Baaan','^Ba*n'); insert into t1 values('aaa','qqq|aaa'); insert into t1 values('qqq','qqq|aaa'); insert into t1 values('bbb','qqq|aaa'); insert into t1 values('bbb','qqq'); insert into t1 values('aaa','aba'); insert into t1 values(null,'abc'); insert into t1 values('def',null); insert into t1 values(null,null); insert into t1 values('ghi','ghi['); select HIGH_PRIORITY s1 regexp s2 from t1; s1 regexp s2 1 1 1 1 1 1 1 0 0 0 NULL NULL NULL NULL drop table t1; SET collation_connection=utf32_czech_ci; SELECT @@collation_connection; @@collation_connection utf32_czech_ci # # Bug#57737 Character sets: search fails with like, contraction, index # CREATE TABLE t1 AS SELECT REPEAT(' ', 10) AS s1 LIMIT 0; INSERT INTO t1 VALUES ('c'),('ce'),('cé'),('ch'); SELECT * FROM t1 WHERE s1 LIKE 'c%'; s1 c ce cé ch ALTER TABLE t1 ADD KEY s1 (s1); SELECT * FROM t1 WHERE s1 LIKE 'c%'; s1 c ce cé ch ALTER TABLE t1 DROP KEY s1, ADD KEY(s1(1)); SELECT * FROM t1 WHERE s1 LIKE 'ch'; s1 ch DROP TABLE t1; SELECT @@collation_connection; @@collation_connection utf32_czech_ci # # Bug#57737 Character sets: search fails with like, contraction, index # Part#2 - ignorable characters # CREATE TABLE t1 AS SELECT REPEAT(' ', 10) AS s1 LIMIT 0; INSERT INTO t1 VALUES ('a\0\0\0\0\0\t'),('a'),('b'),('c'),('d'),('e'); SELECT HEX(s1) FROM t1 WHERE s1 LIKE 'a%'; HEX(s1) 00000061000000000000000000000000000000000000000000000009 00000061 ALTER TABLE t1 ADD KEY s1 (s1); SELECT HEX(s1) FROM t1 WHERE s1 LIKE 'a%'; HEX(s1) 00000061000000000000000000000000000000000000000000000009 00000061 DROP TABLE t1; # # Bug #12319710 : INVALID MEMORY READ AND/OR CRASH IN # MY_UCA_CHARCMP WITH UTF32 # SET collation_connection=utf32_unicode_ci; CREATE TABLE t1 (a TEXT CHARACTER SET utf32 COLLATE utf32_turkish_ci NOT NULL); INSERT INTO t1 VALUES ('a'), ('b'); CREATE TABLE t2 (b VARBINARY(5) NOT NULL); #insert chars outside of BMP INSERT INTO t2 VALUEs (0x082837),(0x082837); #test for read-out-of-bounds with non-BMP chars as a LIKE pattern SELECT * FROM t1,t2 WHERE a LIKE b; a b #test the original statement SELECT 1 FROM t1 AS t1_0 NATURAL LEFT OUTER JOIN t2 AS t2_0 RIGHT JOIN t1 AS t1_1 ON t1_0.a LIKE t2_0.b; 1 1 1 DROP TABLE t1,t2; # # End of 5.5 tests # # # Start of 5.6 tests # # # WL#3664 WEIGHT_STRING # set collation_connection=utf32_unicode_ci; select @@collation_connection; @@collation_connection utf32_unicode_ci select hex(weight_string('a')); hex(weight_string('a')) 0E33 select hex(weight_string('A')); hex(weight_string('A')) 0E33 select hex(weight_string('abc')); hex(weight_string('abc')) 0E330E4A0E60 select hex(weight_string('abc' as char(2))); hex(weight_string('abc' as char(2))) 0E330E4A select hex(weight_string('abc' as char(3))); hex(weight_string('abc' as char(3))) 0E330E4A0E60 select hex(weight_string('abc' as char(5))); hex(weight_string('abc' as char(5))) 0E330E4A0E6002090209 select hex(weight_string('abc', 1, 2, 0xC0)); hex(weight_string('abc', 1, 2, 0xC0)) 0E select hex(weight_string('abc', 2, 2, 0xC0)); hex(weight_string('abc', 2, 2, 0xC0)) 0E33 select hex(weight_string('abc', 3, 2, 0xC0)); hex(weight_string('abc', 3, 2, 0xC0)) 0E330E select hex(weight_string('abc', 4, 2, 0xC0)); hex(weight_string('abc', 4, 2, 0xC0)) 0E330E4A select hex(weight_string('abc', 5, 2, 0xC0)); hex(weight_string('abc', 5, 2, 0xC0)) 0E330E4A02 select hex(weight_string('abc',25, 2, 0xC0)); hex(weight_string('abc',25, 2, 0xC0)) 0E330E4A020902090209020902090209020902090209020902 select hex(weight_string('abc', 1, 3, 0xC0)); hex(weight_string('abc', 1, 3, 0xC0)) 0E select hex(weight_string('abc', 2, 3, 0xC0)); hex(weight_string('abc', 2, 3, 0xC0)) 0E33 select hex(weight_string('abc', 3, 3, 0xC0)); hex(weight_string('abc', 3, 3, 0xC0)) 0E330E select hex(weight_string('abc', 4, 3, 0xC0)); hex(weight_string('abc', 4, 3, 0xC0)) 0E330E4A select hex(weight_string('abc', 5, 3, 0xC0)); hex(weight_string('abc', 5, 3, 0xC0)) 0E330E4A0E select hex(weight_string('abc',25, 3, 0xC0)); hex(weight_string('abc',25, 3, 0xC0)) 0E330E4A0E6002090209020902090209020902090209020902 select hex(weight_string('abc', 1, 4, 0xC0)); hex(weight_string('abc', 1, 4, 0xC0)) 0E select hex(weight_string('abc', 2, 4, 0xC0)); hex(weight_string('abc', 2, 4, 0xC0)) 0E33 select hex(weight_string('abc', 3, 4, 0xC0)); hex(weight_string('abc', 3, 4, 0xC0)) 0E330E select hex(weight_string('abc', 4, 4, 0xC0)); hex(weight_string('abc', 4, 4, 0xC0)) 0E330E4A select hex(weight_string('abc', 5, 4, 0xC0)); hex(weight_string('abc', 5, 4, 0xC0)) 0E330E4A0E select hex(weight_string('abc',25, 4, 0xC0)); hex(weight_string('abc',25, 4, 0xC0)) 0E330E4A0E6002090209020902090209020902090209020902 select @@collation_connection; @@collation_connection utf32_unicode_ci select hex(weight_string(cast(_latin1 0x80 as char))); hex(weight_string(cast(_latin1 0x80 as char))) 0E23 select hex(weight_string(cast(_latin1 0x808080 as char))); hex(weight_string(cast(_latin1 0x808080 as char))) 0E230E230E23 select hex(weight_string(cast(_latin1 0x808080 as char) as char(2))); hex(weight_string(cast(_latin1 0x808080 as char) as char(2))) 0E230E23 select hex(weight_string(cast(_latin1 0x808080 as char) as char(3))); hex(weight_string(cast(_latin1 0x808080 as char) as char(3))) 0E230E230E23 select hex(weight_string(cast(_latin1 0x808080 as char) as char(5))); hex(weight_string(cast(_latin1 0x808080 as char) as char(5))) 0E230E230E2302090209 select hex(weight_string(cast(_latin1 0x808080 as char), 1, 2, 0xC0)); hex(weight_string(cast(_latin1 0x808080 as char), 1, 2, 0xC0)) 0E select hex(weight_string(cast(_latin1 0x808080 as char), 2, 2, 0xC0)); hex(weight_string(cast(_latin1 0x808080 as char), 2, 2, 0xC0)) 0E23 select hex(weight_string(cast(_latin1 0x808080 as char), 3, 2, 0xC0)); hex(weight_string(cast(_latin1 0x808080 as char), 3, 2, 0xC0)) 0E230E select hex(weight_string(cast(_latin1 0x808080 as char), 4, 2, 0xC0)); hex(weight_string(cast(_latin1 0x808080 as char), 4, 2, 0xC0)) 0E230E23 select hex(weight_string(cast(_latin1 0x808080 as char), 5, 2, 0xC0)); hex(weight_string(cast(_latin1 0x808080 as char), 5, 2, 0xC0)) 0E230E2302 select hex(weight_string(cast(_latin1 0x808080 as char),25, 2, 0xC0)); hex(weight_string(cast(_latin1 0x808080 as char),25, 2, 0xC0)) 0E230E23020902090209020902090209020902090209020902 select hex(weight_string(cast(_latin1 0x808080 as char), 1, 3, 0xC0)); hex(weight_string(cast(_latin1 0x808080 as char), 1, 3, 0xC0)) 0E select hex(weight_string(cast(_latin1 0x808080 as char), 2, 3, 0xC0)); hex(weight_string(cast(_latin1 0x808080 as char), 2, 3, 0xC0)) 0E23 select hex(weight_string(cast(_latin1 0x808080 as char), 3, 3, 0xC0)); hex(weight_string(cast(_latin1 0x808080 as char), 3, 3, 0xC0)) 0E230E select hex(weight_string(cast(_latin1 0x808080 as char), 4, 3, 0xC0)); hex(weight_string(cast(_latin1 0x808080 as char), 4, 3, 0xC0)) 0E230E23 select hex(weight_string(cast(_latin1 0x808080 as char), 5, 3, 0xC0)); hex(weight_string(cast(_latin1 0x808080 as char), 5, 3, 0xC0)) 0E230E230E select hex(weight_string(cast(_latin1 0x808080 as char),25, 3, 0xC0)); hex(weight_string(cast(_latin1 0x808080 as char),25, 3, 0xC0)) 0E230E230E2302090209020902090209020902090209020902 select hex(weight_string(cast(_latin1 0x808080 as char), 1, 4, 0xC0)); hex(weight_string(cast(_latin1 0x808080 as char), 1, 4, 0xC0)) 0E select hex(weight_string(cast(_latin1 0x808080 as char), 2, 4, 0xC0)); hex(weight_string(cast(_latin1 0x808080 as char), 2, 4, 0xC0)) 0E23 select hex(weight_string(cast(_latin1 0x808080 as char), 3, 4, 0xC0)); hex(weight_string(cast(_latin1 0x808080 as char), 3, 4, 0xC0)) 0E230E select hex(weight_string(cast(_latin1 0x808080 as char), 4, 4, 0xC0)); hex(weight_string(cast(_latin1 0x808080 as char), 4, 4, 0xC0)) 0E230E23 select hex(weight_string(cast(_latin1 0x808080 as char), 5, 4, 0xC0)); hex(weight_string(cast(_latin1 0x808080 as char), 5, 4, 0xC0)) 0E230E230E select hex(weight_string(cast(_latin1 0x808080 as char),25, 4, 0xC0)); hex(weight_string(cast(_latin1 0x808080 as char),25, 4, 0xC0)) 0E230E230E2302090209020902090209020902090209020902 select hex(weight_string(_utf32 0x10000 collate utf32_unicode_ci)); hex(weight_string(_utf32 0x10000 collate utf32_unicode_ci)) FFFD select hex(weight_string(_utf32 0x10001 collate utf32_unicode_ci)); hex(weight_string(_utf32 0x10001 collate utf32_unicode_ci)) FFFD select @@collation_connection; @@collation_connection utf32_unicode_ci select hex(weight_string('a' LEVEL 1)); hex(weight_string('a' LEVEL 1)) 0E33 select hex(weight_string('A' LEVEL 1)); hex(weight_string('A' LEVEL 1)) 0E33 select hex(weight_string('abc' LEVEL 1)); hex(weight_string('abc' LEVEL 1)) 0E330E4A0E60 select hex(weight_string('abc' as char(2) LEVEL 1)); hex(weight_string('abc' as char(2) LEVEL 1)) 0E330E4A select hex(weight_string('abc' as char(3) LEVEL 1)); hex(weight_string('abc' as char(3) LEVEL 1)) 0E330E4A0E60 select hex(weight_string('abc' as char(5) LEVEL 1)); hex(weight_string('abc' as char(5) LEVEL 1)) 0E330E4A0E6002090209 select hex(weight_string('abc' as char(5) LEVEL 1 REVERSE)); hex(weight_string('abc' as char(5) LEVEL 1 REVERSE)) 09020902600E4A0E330E select hex(weight_string('abc' as char(5) LEVEL 1 DESC)); hex(weight_string('abc' as char(5) LEVEL 1 DESC)) F1CCF1B5F19FFDF6FDF6 select hex(weight_string('abc' as char(5) LEVEL 1 DESC REVERSE)); hex(weight_string('abc' as char(5) LEVEL 1 DESC REVERSE)) F6FDF6FD9FF1B5F1CCF1 set @@collation_connection=utf32_czech_ci; select @@collation_connection; @@collation_connection utf32_czech_ci select collation(cast(_latin1 0xDF as char)); collation(cast(_latin1 0xDF as char)) utf32_czech_ci select hex(weight_string('s')); hex(weight_string('s')) 0FEA select hex(weight_string(cast(_latin1 0xDF as char))); hex(weight_string(cast(_latin1 0xDF as char))) 0FEA0FEA select hex(weight_string(cast(_latin1 0xDF as char) as char(1))); hex(weight_string(cast(_latin1 0xDF as char) as char(1))) 0FEA select hex(weight_string('c')); hex(weight_string('c')) 0E60 select hex(weight_string('h')); hex(weight_string('h')) 0EE1 select hex(weight_string('ch')); hex(weight_string('ch')) 0EE2 select hex(weight_string('i')); hex(weight_string('i')) 0EFB select hex(weight_string(cast(_latin1 0x6368DF as char))); hex(weight_string(cast(_latin1 0x6368DF as char))) 0EE20FEA0FEA select hex(weight_string(cast(_latin1 0x6368DF as char) as char(1))); hex(weight_string(cast(_latin1 0x6368DF as char) as char(1))) 0EE2 select hex(weight_string(cast(_latin1 0x6368DF as char) as char(2))); hex(weight_string(cast(_latin1 0x6368DF as char) as char(2))) 0EE20FEA select hex(weight_string(cast(_latin1 0x6368DF as char) as char(3))); hex(weight_string(cast(_latin1 0x6368DF as char) as char(3))) 0EE20FEA0FEA select hex(weight_string(cast(_latin1 0x6368DF as char) as char(4))); hex(weight_string(cast(_latin1 0x6368DF as char) as char(4))) 0EE20FEA0FEA0209 select hex(weight_string(cast(_latin1 0xDF6368 as char))); hex(weight_string(cast(_latin1 0xDF6368 as char))) 0FEA0FEA0EE2 select hex(weight_string(cast(_latin1 0xDF6368 as char) as char(1))); hex(weight_string(cast(_latin1 0xDF6368 as char) as char(1))) 0FEA select hex(weight_string(cast(_latin1 0xDF6368 as char) as char(2))); hex(weight_string(cast(_latin1 0xDF6368 as char) as char(2))) 0FEA0FEA select hex(weight_string(cast(_latin1 0xDF6368 as char) as char(3))); hex(weight_string(cast(_latin1 0xDF6368 as char) as char(3))) 0FEA0FEA0EE2 select hex(weight_string(cast(_latin1 0xDF6368 as char) as char(4))); hex(weight_string(cast(_latin1 0xDF6368 as char) as char(4))) 0FEA0FEA0EE20209 select hex(weight_string(cast(_latin1 0x6368DF as char), 1, 2, 0xC0)); hex(weight_string(cast(_latin1 0x6368DF as char), 1, 2, 0xC0)) 0E select hex(weight_string(cast(_latin1 0x6368DF as char), 2, 2, 0xC0)); hex(weight_string(cast(_latin1 0x6368DF as char), 2, 2, 0xC0)) 0EE2 select hex(weight_string(cast(_latin1 0x6368DF as char), 3, 2, 0xC0)); hex(weight_string(cast(_latin1 0x6368DF as char), 3, 2, 0xC0)) 0EE20F select hex(weight_string(cast(_latin1 0x6368DF as char), 4, 2, 0xC0)); hex(weight_string(cast(_latin1 0x6368DF as char), 4, 2, 0xC0)) 0EE20FEA select hex(weight_string(cast(_latin1 0x6368DF as char),25, 2, 0xC0)); hex(weight_string(cast(_latin1 0x6368DF as char),25, 2, 0xC0)) 0EE20FEA020902090209020902090209020902090209020902 select hex(weight_string(cast(_latin1 0x6368DF as char), 1, 3, 0xC0)); hex(weight_string(cast(_latin1 0x6368DF as char), 1, 3, 0xC0)) 0E select hex(weight_string(cast(_latin1 0x6368DF as char), 2, 3, 0xC0)); hex(weight_string(cast(_latin1 0x6368DF as char), 2, 3, 0xC0)) 0EE2 select hex(weight_string(cast(_latin1 0x6368DF as char), 3, 3, 0xC0)); hex(weight_string(cast(_latin1 0x6368DF as char), 3, 3, 0xC0)) 0EE20F select hex(weight_string(cast(_latin1 0x6368DF as char), 4, 3, 0xC0)); hex(weight_string(cast(_latin1 0x6368DF as char), 4, 3, 0xC0)) 0EE20FEA select hex(weight_string(cast(_latin1 0x6368DF as char),25, 3, 0xC0)); hex(weight_string(cast(_latin1 0x6368DF as char),25, 3, 0xC0)) 0EE20FEA0FEA02090209020902090209020902090209020902 select hex(weight_string(cast(_latin1 0x6368DF as char), 1, 4, 0xC0)); hex(weight_string(cast(_latin1 0x6368DF as char), 1, 4, 0xC0)) 0E select hex(weight_string(cast(_latin1 0x6368DF as char), 2, 4, 0xC0)); hex(weight_string(cast(_latin1 0x6368DF as char), 2, 4, 0xC0)) 0EE2 select hex(weight_string(cast(_latin1 0x6368DF as char), 3, 4, 0xC0)); hex(weight_string(cast(_latin1 0x6368DF as char), 3, 4, 0xC0)) 0EE20F select hex(weight_string(cast(_latin1 0x6368DF as char), 4, 4, 0xC0)); hex(weight_string(cast(_latin1 0x6368DF as char), 4, 4, 0xC0)) 0EE20FEA select hex(weight_string(cast(_latin1 0x6368DF as char),25, 4, 0xC0)); hex(weight_string(cast(_latin1 0x6368DF as char),25, 4, 0xC0)) 0EE20FEA0FEA02090209020902090209020902090209020902 select hex(weight_string(cast(_latin1 0xDF6368 as char), 1, 2,0xC0)); hex(weight_string(cast(_latin1 0xDF6368 as char), 1, 2,0xC0)) 0F select hex(weight_string(cast(_latin1 0xDF6368 as char), 2, 2,0xC0)); hex(weight_string(cast(_latin1 0xDF6368 as char), 2, 2,0xC0)) 0FEA select hex(weight_string(cast(_latin1 0xDF6368 as char), 3, 2,0xC0)); hex(weight_string(cast(_latin1 0xDF6368 as char), 3, 2,0xC0)) 0FEA0F select hex(weight_string(cast(_latin1 0xDF6368 as char), 4, 2,0xC0)); hex(weight_string(cast(_latin1 0xDF6368 as char), 4, 2,0xC0)) 0FEA0FEA select hex(weight_string(cast(_latin1 0xDF6368 as char),25, 2,0xC0)); hex(weight_string(cast(_latin1 0xDF6368 as char),25, 2,0xC0)) 0FEA0FEA020902090209020902090209020902090209020902 select hex(weight_string(cast(_latin1 0xDF6368 as char), 1, 3,0xC0)); hex(weight_string(cast(_latin1 0xDF6368 as char), 1, 3,0xC0)) 0F select hex(weight_string(cast(_latin1 0xDF6368 as char), 2, 3,0xC0)); hex(weight_string(cast(_latin1 0xDF6368 as char), 2, 3,0xC0)) 0FEA select hex(weight_string(cast(_latin1 0xDF6368 as char), 3, 3,0xC0)); hex(weight_string(cast(_latin1 0xDF6368 as char), 3, 3,0xC0)) 0FEA0F select hex(weight_string(cast(_latin1 0xDF6368 as char), 4, 3,0xC0)); hex(weight_string(cast(_latin1 0xDF6368 as char), 4, 3,0xC0)) 0FEA0FEA select hex(weight_string(cast(_latin1 0xDF6368 as char),25, 3,0xC0)); hex(weight_string(cast(_latin1 0xDF6368 as char),25, 3,0xC0)) 0FEA0FEA0EE202090209020902090209020902090209020902 select hex(weight_string(cast(_latin1 0xDF6368 as char), 1, 4,0xC0)); hex(weight_string(cast(_latin1 0xDF6368 as char), 1, 4,0xC0)) 0F select hex(weight_string(cast(_latin1 0xDF6368 as char), 2, 4,0xC0)); hex(weight_string(cast(_latin1 0xDF6368 as char), 2, 4,0xC0)) 0FEA select hex(weight_string(cast(_latin1 0xDF6368 as char), 3, 4,0xC0)); hex(weight_string(cast(_latin1 0xDF6368 as char), 3, 4,0xC0)) 0FEA0F select hex(weight_string(cast(_latin1 0xDF6368 as char), 4, 4,0xC0)); hex(weight_string(cast(_latin1 0xDF6368 as char), 4, 4,0xC0)) 0FEA0FEA select hex(weight_string(cast(_latin1 0xDF6368 as char),25, 4,0xC0)); hex(weight_string(cast(_latin1 0xDF6368 as char),25, 4,0xC0)) 0FEA0FEA0EE202090209020902090209020902090209020902 SET NAMES utf8; SET collation_connection=utf32_german2_ci; "BEGIN ctype_german.inc" drop table if exists t1; create table t1 as select repeat(' ', 64) as s1; select collation(s1) from t1; collation(s1) utf32_german2_ci delete from t1; INSERT INTO t1 VALUES ('ud'),('uf'); INSERT INTO t1 VALUES ('od'),('of'); INSERT INTO t1 VALUES ('e'); INSERT INTO t1 VALUES ('ad'),('af'); insert into t1 values ('a'),('ae'),(_latin1 0xE4); insert into t1 values ('o'),('oe'),(_latin1 0xF6); insert into t1 values ('s'),('ss'),(_latin1 0xDF); insert into t1 values ('u'),('ue'),(_latin1 0xFC); INSERT INTO t1 VALUES (_latin1 0xE6), (_latin1 0xC6); INSERT INTO t1 VALUES (_latin1 0x9C), (_latin1 0x8C); select s1, hex(s1) from t1 order by s1, binary s1; s1 hex(s1) a 00000061 ad 0000006100000064 ae 0000006100000065 Æ 000000C6 ä 000000E4 æ 000000E6 af 0000006100000066 e 00000065 o 0000006F od 0000006F00000064 oe 0000006F00000065 ö 000000F6 Œ 00000152 œ 00000153 of 0000006F00000066 s 00000073 ss 0000007300000073 ß 000000DF u 00000075 ud 0000007500000064 ue 0000007500000065 ü 000000FC uf 0000007500000066 select group_concat(s1 order by binary s1) from t1 group by s1; group_concat(s1 order by binary s1) a ad ae,Æ,ä,æ af e o od oe,ö,Œ,œ of s ss,ß u ud ue,ü uf SELECT s1, hex(s1), hex(weight_string(s1)) FROM t1 ORDER BY s1, BINARY(s1); s1 hex(s1) hex(weight_string(s1)) a 00000061 0E33 ad 0000006100000064 0E330E6D ae 0000006100000065 0E330E8B Æ 000000C6 0E330E8B ä 000000E4 0E330E8B æ 000000E6 0E330E8B af 0000006100000066 0E330EB9 e 00000065 0E8B o 0000006F 0F82 od 0000006F00000064 0F820E6D oe 0000006F00000065 0F820E8B ö 000000F6 0F820E8B Œ 00000152 0F820E8B œ 00000153 0F820E8B of 0000006F00000066 0F820EB9 s 00000073 0FEA ss 0000007300000073 0FEA0FEA ß 000000DF 0FEA0FEA u 00000075 101F ud 0000007500000064 101F0E6D ue 0000007500000065 101F0E8B ü 000000FC 101F0E8B uf 0000007500000066 101F0EB9 SELECT s1, hex(s1) FROM t1 WHERE s1='ae' ORDER BY s1, BINARY(s1); s1 hex(s1) ae 0000006100000065 Æ 000000C6 ä 000000E4 æ 000000E6 drop table t1; "END ctype_german.inc" # # WL#2673 Unicode Collation Algorithm new version # SET NAMES utf8mb4; SET collation_connection=utf32_unicode_520_ci; CREATE TABLE t1 AS SELECT repeat('a', 10) as c LIMIT 0; SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( `c` varchar(10) CHARACTER SET utf32 COLLATE utf32_unicode_520_ci DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 INSERT INTO t1 VALUES (_utf32 0x0180),(_utf32 0x023A); INSERT INTO t1 VALUES (_utf32 0x023B),(_utf32 0x023C); INSERT INTO t1 VALUES (_utf32 0x023D),(_utf32 0x023E); INSERT INTO t1 VALUES (_utf32 0x0241),(_utf32 0x0242); INSERT INTO t1 VALUES (_utf32 0x0243),(_utf32 0x0244); INSERT INTO t1 VALUES (_utf32 0x0245),(_utf32 0x0246); INSERT INTO t1 VALUES (_utf32 0x0247),(_utf32 0x0248); INSERT INTO t1 VALUES (_utf32 0x0249),(_utf32 0x024A); INSERT INTO t1 VALUES (_utf32 0x024B),(_utf32 0x024C); INSERT INTO t1 VALUES (_utf32 0x024D),(_utf32 0x024E); INSERT INTO t1 VALUES (_utf32 0x024F),(_utf32 0x026B); INSERT INTO t1 VALUES (_utf32 0x027D),(_utf32 0x0289); INSERT INTO t1 VALUES (_utf32 0x028C); INSERT INTO t1 VALUES (_utf32 0x037B), (_utf32 0x037C); INSERT INTO t1 VALUES (_utf32 0x037D), (_utf32 0x03FD); INSERT INTO t1 VALUES (_utf32 0x03FE), (_utf32 0x03FF); INSERT INTO t1 VALUES (_utf32 0x04C0), (_utf32 0x04CF); INSERT INTO t1 VALUES (_utf32 0x04F6), (_utf32 0x04F7); INSERT INTO t1 VALUES (_utf32 0x04FA), (_utf32 0x04FB); INSERT INTO t1 VALUES (_utf32 0x04FC), (_utf32 0x04FD); INSERT INTO t1 VALUES (_utf32 0x04FE), (_utf32 0x04FF); INSERT INTO t1 VALUES (_utf32 0x0510), (_utf32 0x0511); INSERT INTO t1 VALUES (_utf32 0x0512), (_utf32 0x0513); INSERT INTO t1 VALUES (_utf32 0x10A0), (_utf32 0x10A1); INSERT INTO t1 VALUES (_utf32 0x10A2), (_utf32 0x10A3); INSERT INTO t1 VALUES (_utf32 0x10A4), (_utf32 0x10A5); INSERT INTO t1 VALUES (_utf32 0x10A6), (_utf32 0x10A7); INSERT INTO t1 VALUES (_utf32 0x2D00), (_utf32 0x2D01); INSERT INTO t1 VALUES (_utf32 0x2D02), (_utf32 0x2D03); INSERT INTO t1 VALUES (_utf32 0x2D04), (_utf32 0x2D05); INSERT INTO t1 VALUES (_utf32 0x2D06), (_utf32 0x2D07); INSERT INTO t1 VALUES (_utf32 0x1D7D); INSERT INTO t1 VALUES (_utf32 0x2132),(_utf32 0x214E); INSERT INTO t1 VALUES (_utf32 0x2183),(_utf32 0x2184); INSERT INTO t1 VALUES (_utf32 0x2C80), (_utf32 0x2C81); INSERT INTO t1 VALUES (_utf32 0x2C82), (_utf32 0x2C83); INSERT INTO t1 VALUES (_utf32 0x2C84), (_utf32 0x2C85); INSERT INTO t1 VALUES (_utf32 0x2C86), (_utf32 0x2C87); INSERT INTO t1 VALUES (_utf32 0x2C88), (_utf32 0x2C89); INSERT INTO t1 VALUES (_utf32 0x2C8A), (_utf32 0x2C8B); INSERT INTO t1 VALUES (_utf32 0x2C8C), (_utf32 0x2C8D); INSERT INTO t1 VALUES (_utf32 0x2C8E), (_utf32 0x2C8F); INSERT INTO t1 VALUES (_utf32 0x2C60), (_utf32 0x2C61); INSERT INTO t1 VALUES (_utf32 0x2C62), (_utf32 0x2C63); INSERT INTO t1 VALUES (_utf32 0x2C64), (_utf32 0x2C65); INSERT INTO t1 VALUES (_utf32 0x2C66), (_utf32 0x2C67); INSERT INTO t1 VALUES (_utf32 0x2C68), (_utf32 0x2C69); INSERT INTO t1 VALUES (_utf32 0x2C6A), (_utf32 0x2C6B); INSERT INTO t1 VALUES (_utf32 0x2C6C), (_utf32 0x2C75); INSERT INTO t1 VALUES (_utf32 0x2C76); INSERT INTO t1 VALUES (_utf32 0x2C00), (_utf32 0x2C01); INSERT INTO t1 VALUES (_utf32 0x2C02), (_utf32 0x2C03); INSERT INTO t1 VALUES (_utf32 0x2C04), (_utf32 0x2C05); INSERT INTO t1 VALUES (_utf32 0x2C06), (_utf32 0x2C07); INSERT INTO t1 VALUES (_utf32 0x2C30), (_utf32 0x2C31); INSERT INTO t1 VALUES (_utf32 0x2C32), (_utf32 0x2C33); INSERT INTO t1 VALUES (_utf32 0x2C34), (_utf32 0x2C35); INSERT INTO t1 VALUES (_utf32 0x2C36), (_utf32 0x2C37); INSERT INTO t1 VALUES (_utf32 0x10400), (_utf32 0x10401); INSERT INTO t1 VALUES (_utf32 0x10402), (_utf32 0x10403); INSERT INTO t1 VALUES (_utf32 0x10404), (_utf32 0x10405); INSERT INTO t1 VALUES (_utf32 0x10406), (_utf32 0x10407); INSERT INTO t1 VALUES (_utf32 0x10428), (_utf32 0x10429); INSERT INTO t1 VALUES (_utf32 0x1042A), (_utf32 0x1042B); INSERT INTO t1 VALUES (_utf32 0x1042C), (_utf32 0x1042D); INSERT INTO t1 VALUES (_utf32 0x1042E), (_utf32 0x1042F); INSERT INTO t1 VALUES (_utf32 0x0370); INSERT INTO t1 VALUES (_utf32 0x0371); INSERT INTO t1 VALUES (_utf32 0x0372); INSERT INTO t1 VALUES (_utf32 0x0373); INSERT INTO t1 VALUES (_utf32 0x0514); INSERT INTO t1 VALUES (_utf32 0x0515); INSERT INTO t1 VALUES (_utf32 0x0516); INSERT INTO t1 VALUES (_utf32 0x0517); INSERT INTO t1 VALUES (_utf32 0xA640); INSERT INTO t1 VALUES (_utf32 0xA641); INSERT INTO t1 VALUES (_utf32 0xA642); INSERT INTO t1 VALUES (_utf32 0xA643); INSERT INTO t1 VALUES (_utf32 0xA722); INSERT INTO t1 VALUES (_utf32 0xA723); INSERT INTO t1 VALUES (_utf32 0xA724); INSERT INTO t1 VALUES (_utf32 0xA725); INSERT INTO t1 VALUES (_utf32 0xA726); INSERT INTO t1 VALUES (_utf32 0xA727); INSERT INTO t1 VALUES (_utf32 0xA728); INSERT INTO t1 VALUES (_utf32 0xA729); INSERT INTO t1 VALUES (_utf32 0xA72A); INSERT INTO t1 VALUES (_utf32 0xA72B); INSERT INTO t1 VALUES (_utf32 0x2CEB); INSERT INTO t1 VALUES (_utf32 0x2CEC); INSERT INTO t1 VALUES (_utf32 0x2CED); INSERT INTO t1 VALUES (_utf32 0x2CEE); SELECT hex(c), hex(lower(c)), hex(upper(c)), hex(weight_string(c)), c FROM t1 ORDER BY c, BINARY c; hex(c) hex(lower(c)) hex(upper(c)) hex(weight_string(c)) c 0000023A 00002C65 0000023A 1214 Ⱥ 00002C65 00002C65 0000023A 1214 ⱥ 00000180 00000180 00000243 122D ƀ 00000243 00000180 00000243 122D Ƀ 0000023B 0000023C 0000023B 1242 Ȼ 0000023C 0000023C 0000023B 1242 ȼ 00002183 00002184 00002183 124E Ↄ 00002184 00002184 00002183 124E ↄ 00000246 00000247 00000246 1270 Ɇ 00000247 00000247 00000246 1270 ɇ 00002132 0000214E 00002132 12AE Ⅎ 0000214E 0000214E 00002132 12AE ⅎ 00002C67 00002C68 00002C67 12E3 Ⱨ 00002C68 00002C68 00002C67 12E3 ⱨ 00002C75 00002C76 00002C75 12E4 Ⱶ 00002C76 00002C76 00002C75 12E4 ⱶ 0000A726 0000A727 0000A726 12E5 Ꜧ 0000A727 0000A727 0000A726 12E5 ꜧ 00000248 00000249 00000248 130E Ɉ 00000249 00000249 00000248 130E ɉ 00002C69 00002C6A 00002C69 1328 Ⱪ 00002C6A 00002C6A 00002C69 1328 ⱪ 0000023D 0000019A 0000023D 133B Ƚ 00002C60 00002C61 00002C60 133F Ⱡ 00002C61 00002C61 00002C60 133F ⱡ 0000026B 0000026B 00002C62 1340 ɫ 00002C62 0000026B 00002C62 1340 Ɫ 00001D7D 00001D7D 00002C63 13B8 ᵽ 00002C63 00001D7D 00002C63 13B8 Ᵽ 0000024A 0000024B 0000024A 13D2 Ɋ 0000024B 0000024B 0000024A 13D2 ɋ 0000024C 0000024D 0000024C 13E4 Ɍ 0000024D 0000024D 0000024C 13E4 ɍ 0000027D 0000027D 00002C64 13FC ɽ 00002C64 0000027D 00002C64 13FC Ɽ 0000A728 0000A729 0000A728 143314AD Ꜩ 0000A729 0000A729 0000A728 143314AD ꜩ 0000023E 00002C66 0000023E 143C Ⱦ 00002C66 00002C66 0000023E 143C ⱦ 00000244 00000289 00000244 145B Ʉ 00000289 00000289 00000244 145B ʉ 00000245 0000028C 00000245 1489 Ʌ 0000028C 0000028C 00000245 1489 ʌ 0000024E 0000024F 0000024E 14A4 Ɏ 0000024F 0000024F 0000024E 14A4 ɏ 00002C6B 00002C6C 00002C6B 14C8 Ⱬ 00002C6C 00002C6C 00002C6B 14C8 ⱬ 0000A72A 0000A72B 0000A72A 14F3 Ꜫ 0000A72B 0000A72B 0000A72A 14F3 ꜫ 00000241 00000242 00000241 1506 Ɂ 00000242 00000242 00000241 1506 ɂ 0000A722 0000A723 0000A722 150E Ꜣ 0000A723 0000A723 0000A722 150E ꜣ 0000A724 0000A725 0000A724 1518 Ꜥ 0000A725 0000A725 0000A724 1518 ꜥ 00000370 00000371 00000370 154F Ͱ 00000371 00000371 00000370 154F ͱ 0000037C 0000037C 000003FE 1564 ͼ 000003FE 0000037C 000003FE 1564 Ͼ 0000037B 0000037B 000003FD 1565 ͻ 000003FD 0000037B 000003FD 1565 Ͻ 0000037D 0000037D 000003FF 1566 ͽ 000003FF 0000037D 000003FF 1566 Ͽ 00000372 00000373 00000372 156F Ͳ 00000373 00000373 00000372 156F ͳ 00002C80 00002C81 00002C80 1571 Ⲁ 00002C81 00002C81 00002C80 1571 ⲁ 00002C82 00002C83 00002C82 1572 Ⲃ 00002C83 00002C83 00002C82 1572 ⲃ 00002C84 00002C85 00002C84 1573 Ⲅ 00002C85 00002C85 00002C84 1573 ⲅ 00002C86 00002C87 00002C86 1574 Ⲇ 00002C87 00002C87 00002C86 1574 ⲇ 00002C88 00002C89 00002C88 1575 Ⲉ 00002C89 00002C89 00002C88 1575 ⲉ 00002C8A 00002C8B 00002C8A 1577 Ⲋ 00002C8B 00002C8B 00002C8A 1577 ⲋ 00002C8C 00002C8D 00002C8C 1578 Ⲍ 00002C8D 00002C8D 00002C8C 1578 ⲍ 00002C8E 00002C8F 00002C8E 1579 Ⲏ 00002C8F 00002C8F 00002C8E 1579 ⲏ 00002CEB 00002CEC 00002CEB 1591 Ⳬ 00002CEC 00002CEC 00002CEB 1591 ⳬ 00002CED 00002CEE 00002CED 15A0 Ⳮ 00002CEE 00002CEE 00002CED 15A0 ⳮ 000004FA 000004FB 000004FA 15D4 Ӻ 000004FB 000004FB 000004FA 15D4 ӻ 000004F6 000004F7 000004F6 15DC Ӷ 000004F7 000004F7 000004F6 15DC ӷ 0000A640 0000A641 0000A640 1611 Ꙁ 0000A641 0000A641 0000A640 1611 ꙁ 00000510 00000511 00000510 1613 Ԑ 00000511 00000511 00000510 1613 ԑ 0000A642 0000A643 0000A642 1618 Ꙃ 0000A643 0000A643 0000A642 1618 ꙃ 00000512 00000513 00000512 1666 Ԓ 00000513 00000513 00000512 1666 ԓ 00000514 00000515 00000514 166E Ԕ 00000515 00000515 00000514 166E ԕ 00000516 00000517 00000516 16B7 Ԗ 00000517 00000517 00000516 16B7 ԗ 000004FC 000004FD 000004FC 16F9 Ӽ 000004FD 000004FD 000004FC 16F9 ӽ 000004FE 000004FF 000004FE 16FD Ӿ 000004FF 000004FF 000004FE 16FD ӿ 000004C0 000004CF 000004C0 17B1 Ӏ 000004CF 000004CF 000004C0 17B1 ӏ 00002C00 00002C30 00002C00 17B5 Ⰰ 00002C30 00002C30 00002C00 17B5 ⰰ 00002C01 00002C31 00002C01 17B6 Ⰱ 00002C31 00002C31 00002C01 17B6 ⰱ 00002C02 00002C32 00002C02 17B7 Ⰲ 00002C32 00002C32 00002C02 17B7 ⰲ 00002C03 00002C33 00002C03 17B8 Ⰳ 00002C33 00002C33 00002C03 17B8 ⰳ 00002C04 00002C34 00002C04 17B9 Ⰴ 00002C34 00002C34 00002C04 17B9 ⰴ 00002C05 00002C35 00002C05 17BA Ⰵ 00002C35 00002C35 00002C05 17BA ⰵ 00002C06 00002C36 00002C06 17BB Ⰶ 00002C36 00002C36 00002C06 17BB ⰶ 00002C07 00002C37 00002C07 17BC Ⰷ 00002C37 00002C37 00002C07 17BC ⰷ 000010A0 00002D00 000010A0 17E5 Ⴀ 00002D00 00002D00 000010A0 17E5 ⴀ 000010A1 00002D01 000010A1 17E7 Ⴁ 00002D01 00002D01 000010A1 17E7 ⴁ 000010A2 00002D02 000010A2 17E9 Ⴂ 00002D02 00002D02 000010A2 17E9 ⴂ 000010A3 00002D03 000010A3 17EB Ⴃ 00002D03 00002D03 000010A3 17EB ⴃ 000010A4 00002D04 000010A4 17ED Ⴄ 00002D04 00002D04 000010A4 17ED ⴄ 000010A5 00002D05 000010A5 17EF Ⴅ 00002D05 00002D05 000010A5 17EF ⴅ 000010A6 00002D06 000010A6 17F1 Ⴆ 00002D06 00002D06 000010A6 17F1 ⴆ 000010A7 00002D07 000010A7 17F5 Ⴇ 00002D07 00002D07 000010A7 17F5 ⴇ 00010400 00010428 00010400 30D2 𐐀 00010428 00010428 00010400 30D2 𐐨 00010401 00010429 00010401 30D3 𐐁 00010429 00010429 00010401 30D3 𐐩 00010402 0001042A 00010402 30D4 𐐂 0001042A 0001042A 00010402 30D4 𐐪 00010403 0001042B 00010403 30D5 𐐃 0001042B 0001042B 00010403 30D5 𐐫 00010404 0001042C 00010404 30D6 𐐄 0001042C 0001042C 00010404 30D6 𐐬 00010405 0001042D 00010405 30D7 𐐅 0001042D 0001042D 00010405 30D7 𐐭 00010406 0001042E 00010406 30D8 𐐆 0001042E 0001042E 00010406 30D8 𐐮 00010407 0001042F 00010407 30D9 𐐇 0001042F 0001042F 00010407 30D9 𐐯 INSERT INTO t1 VALUES ('a'); INSERT INTO t1 VALUES (concat(_utf32 0x61, _utf32 0xFFFF)); INSERT INTO t1 VALUES (concat(_utf32 0x61, _utf32 0x10FFFF)); INSERT INTO t1 VALUES (concat(_utf32 0x61, _utf32 0x10400)); SELECT hex(c), hex(weight_string(c)) FROM t1 WHERE c LIKE 'a%' ORDER BY c; hex(c) hex(weight_string(c)) 00000061 120F 0000006100010400 120F30D2 000000610000FFFF 120FFBC1FFFF 000000610010FFFF 120FFBE1FFFF SELECT hex(c), hex(weight_string(c)), c FROM t1 WHERE c LIKE _utf32 0x10400 ORDER BY c, BINARY c; hex(c) hex(weight_string(c)) c 00010400 30D2 𐐀 00010428 30D2 𐐨 SELECT hex(c), hex(weight_string(c)), c FROM t1 WHERE c LIKE _utf32 0x10428 ORDER BY c, BINARY c; hex(c) hex(weight_string(c)) c 00010400 30D2 𐐀 00010428 30D2 𐐨 ALTER TABLE t1 ADD KEY(c); EXPLAIN SELECT hex(c) FROM t1 WHERE c LIKE 'a%' ORDER BY c; id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE t1 NULL range c c 43 NULL 4 100.00 Using where; Using index Warnings: Note 1003 /* select#1 */ select hex(`test`.`t1`.`c`) AS `hex(c)` from `test`.`t1` where (`test`.`t1`.`c` like 'a%') order by `test`.`t1`.`c` SELECT hex(c), hex(weight_string(c)) FROM t1 WHERE c LIKE 'a%' ORDER BY c; hex(c) hex(weight_string(c)) 00000061 120F 0000006100010400 120F30D2 000000610000FFFF 120FFBC1FFFF 000000610010FFFF 120FFBE1FFFF SELECT hex(c), hex(weight_string(c)), c FROM t1 WHERE c LIKE _utf32 0x10400 ORDER BY c, BINARY c; hex(c) hex(weight_string(c)) c 00010400 30D2 𐐀 00010428 30D2 𐐨 SELECT hex(c), hex(weight_string(c)), c FROM t1 WHERE c LIKE _utf32 0x10428 ORDER BY c, BINARY c; hex(c) hex(weight_string(c)) c 00010400 30D2 𐐀 00010428 30D2 𐐨 DROP TABLE t1; # # End of 5.6 tests #
Close