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 | : 3.145.125.13
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_utf16_uca.result
DROP TABLE IF EXISTS t1; # # Start of 5.5 tests # set names utf8; set collation_connection=utf16_unicode_ci; select hex('a'), hex('a '); hex('a') hex('a ') 0061 00610020 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 utf16 COLLATE utf16_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 utf16 collate utf16_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 utf16_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 utf16_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 utf16_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 utf16_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 utf16_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 utf16_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 utf16_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 utf16_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 utf16_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 utf16_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 utf16_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 utf16_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 utf16_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 utf16_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 utf16_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 utf16_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 utf16_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 utf16_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 utf16_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 utf16_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 utf16_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 utf16_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 utf16 COLLATE utf16_general_ci NOT NULL, INDEX (c)); INSERT INTO t1 VALUES (0x039C03C903B403B11F770308); SELECT * FROM t1 WHERE c LIKE _utf16 0x039C0025 COLLATE utf16_general_ci; c Μωδαί̈ INSERT INTO t1 VALUES (0x039C03C903B4); SELECT * FROM t1 WHERE c LIKE _utf16 0x039C0025 COLLATE utf16_general_ci ORDER BY c; c Μωδ Μωδαί̈ DROP TABLE t1; CREATE TABLE t1 (c varchar(150) CHARACTER SET utf16 COLLATE utf16_unicode_ci NOT NULL, INDEX (c)); INSERT INTO t1 VALUES (0x039C03C903B403B11F770308); SELECT * FROM t1 WHERE c LIKE _utf16 0x039C0025 COLLATE utf16_unicode_ci; c Μωδαί̈ INSERT INTO t1 VALUES (0x039C03C903B4); SELECT * FROM t1 WHERE c LIKE _utf16 0x039C0025 COLLATE utf16_unicode_ci ORDER BY c; c Μωδ Μωδαί̈ DROP TABLE t1; CREATE TABLE t1 (c varchar(150) CHARACTER SET utf16 COLLATE utf16_unicode_ci NOT NULL, INDEX (c)); INSERT INTO t1 VALUES (0x039C03C903B403B11F770308); SELECT * FROM t1 WHERE c LIKE _utf16 0x039C0025 COLLATE utf16_unicode_ci; c Μωδαί̈ INSERT INTO t1 VALUES (0x039C03C903B4); SELECT * FROM t1 WHERE c LIKE _utf16 0x039C0025 COLLATE utf16_unicode_ci ORDER BY c; c Μωδ Μωδαί̈ DROP TABLE t1; SET NAMES utf8; SET @test_character_set='utf16'; SET @test_collation='utf16_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) utf16_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) utf16_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 utf16_swedish_ci DEFAULT NULL, `level` smallint(5) unsigned DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf16 COLLATE=utf16_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='utf16_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) utf16_unicode_ci 00610009 utf16_unicode_ci 0061 utf16_unicode_ci 00610020 drop table t1; select @@collation_connection; @@collation_connection utf16_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 utf16); INSERT INTO t1 VALUES (1, 0x01310069), (2, 0x01310131); INSERT INTO t1 VALUES (3, 0x00690069), (4, 0x01300049); INSERT INTO t1 VALUES (5, 0x01300130), (6, 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 4 ıi 4 II 4 ıı 4 ıı 4 II 4 ii 4 ii 4 II 4 İI 4 ii 4 İI 4 İİ 4 ii 4 İİ 4 II 4 ii 4 II 4 ALTER TABLE t1 MODIFY a VARCHAR(30) character set utf16 collate utf16_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 4 ıi 4 Iİ 4 ıı 4 ıı 4 II 4 ii 4 ii 4 İİ 4 İI 4 iı 4 İI 4 İİ 4 ii 4 İİ 4 II 4 ıı 4 II 4 DROP TABLE t1; CREATE TABLE t1 ( c1 text character set utf16 collate utf16_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=utf16_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 utf16 COLLATE utf16_unicode_ci DEFAULT NULL, `s2` varchar(64) CHARACTER SET utf16 COLLATE utf16_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=utf16_czech_ci; SELECT @@collation_connection; @@collation_connection utf16_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 utf16_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) 0061000000000000000000000009 0061 ALTER TABLE t1 ADD KEY s1 (s1); SELECT HEX(s1) FROM t1 WHERE s1 LIKE 'a%'; HEX(s1) 0061000000000000000000000009 0061 DROP TABLE t1; # # End of 5.5 tests # # # Start of 5.6 tests # # # WL#3664 WEIGHT_STRING # set collation_connection=utf16_unicode_ci; select @@collation_connection; @@collation_connection utf16_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 utf16_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(_utf16 0xD800DC00 collate utf16_unicode_ci)); hex(weight_string(_utf16 0xD800DC00 collate utf16_unicode_ci)) FFFD select hex(weight_string(_utf16 0xD800DC01 collate utf16_unicode_ci)); hex(weight_string(_utf16 0xD800DC01 collate utf16_unicode_ci)) FFFD select @@collation_connection; @@collation_connection utf16_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=utf16_czech_ci; select @@collation_connection; @@collation_connection utf16_czech_ci select collation(cast(_latin1 0xDF as char)); collation(cast(_latin1 0xDF as char)) utf16_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=utf16_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) utf16_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 0061 ad 00610064 ae 00610065 Æ 00C6 ä 00E4 æ 00E6 af 00610066 e 0065 o 006F od 006F0064 oe 006F0065 ö 00F6 Œ 0152 œ 0153 of 006F0066 s 0073 ss 00730073 ß 00DF u 0075 ud 00750064 ue 00750065 ü 00FC uf 00750066 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 0061 0E33 ad 00610064 0E330E6D ae 00610065 0E330E8B Æ 00C6 0E330E8B ä 00E4 0E330E8B æ 00E6 0E330E8B af 00610066 0E330EB9 e 0065 0E8B o 006F 0F82 od 006F0064 0F820E6D oe 006F0065 0F820E8B ö 00F6 0F820E8B Œ 0152 0F820E8B œ 0153 0F820E8B of 006F0066 0F820EB9 s 0073 0FEA ss 00730073 0FEA0FEA ß 00DF 0FEA0FEA u 0075 101F ud 00750064 101F0E6D ue 00750065 101F0E8B ü 00FC 101F0E8B uf 00750066 101F0EB9 SELECT s1, hex(s1) FROM t1 WHERE s1='ae' ORDER BY s1, BINARY(s1); s1 hex(s1) ae 00610065 Æ 00C6 ä 00E4 æ 00E6 drop table t1; "END ctype_german.inc" # # WL#2673 Unicode Collation Algorithm new version # SET NAMES utf8mb4; SET collation_connection=utf16_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 utf16 COLLATE utf16_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 023A 2C65 023A 1214 Ⱥ 2C65 2C65 023A 1214 ⱥ 0180 0180 0243 122D ƀ 0243 0180 0243 122D Ƀ 023B 023C 023B 1242 Ȼ 023C 023C 023B 1242 ȼ 2183 2184 2183 124E Ↄ 2184 2184 2183 124E ↄ 0246 0247 0246 1270 Ɇ 0247 0247 0246 1270 ɇ 2132 214E 2132 12AE Ⅎ 214E 214E 2132 12AE ⅎ 2C67 2C68 2C67 12E3 Ⱨ 2C68 2C68 2C67 12E3 ⱨ 2C75 2C76 2C75 12E4 Ⱶ 2C76 2C76 2C75 12E4 ⱶ A726 A727 A726 12E5 Ꜧ A727 A727 A726 12E5 ꜧ 0248 0249 0248 130E Ɉ 0249 0249 0248 130E ɉ 2C69 2C6A 2C69 1328 Ⱪ 2C6A 2C6A 2C69 1328 ⱪ 023D 019A 023D 133B Ƚ 2C60 2C61 2C60 133F Ⱡ 2C61 2C61 2C60 133F ⱡ 026B 026B 2C62 1340 ɫ 2C62 026B 2C62 1340 Ɫ 1D7D 1D7D 2C63 13B8 ᵽ 2C63 1D7D 2C63 13B8 Ᵽ 024A 024B 024A 13D2 Ɋ 024B 024B 024A 13D2 ɋ 024C 024D 024C 13E4 Ɍ 024D 024D 024C 13E4 ɍ 027D 027D 2C64 13FC ɽ 2C64 027D 2C64 13FC Ɽ A728 A729 A728 143314AD Ꜩ A729 A729 A728 143314AD ꜩ 023E 2C66 023E 143C Ⱦ 2C66 2C66 023E 143C ⱦ 0244 0289 0244 145B Ʉ 0289 0289 0244 145B ʉ 0245 028C 0245 1489 Ʌ 028C 028C 0245 1489 ʌ 024E 024F 024E 14A4 Ɏ 024F 024F 024E 14A4 ɏ 2C6B 2C6C 2C6B 14C8 Ⱬ 2C6C 2C6C 2C6B 14C8 ⱬ A72A A72B A72A 14F3 Ꜫ A72B A72B A72A 14F3 ꜫ 0241 0242 0241 1506 Ɂ 0242 0242 0241 1506 ɂ A722 A723 A722 150E Ꜣ A723 A723 A722 150E ꜣ A724 A725 A724 1518 Ꜥ A725 A725 A724 1518 ꜥ 0370 0371 0370 154F Ͱ 0371 0371 0370 154F ͱ 037C 037C 03FE 1564 ͼ 03FE 037C 03FE 1564 Ͼ 037B 037B 03FD 1565 ͻ 03FD 037B 03FD 1565 Ͻ 037D 037D 03FF 1566 ͽ 03FF 037D 03FF 1566 Ͽ 0372 0373 0372 156F Ͳ 0373 0373 0372 156F ͳ 2C80 2C81 2C80 1571 Ⲁ 2C81 2C81 2C80 1571 ⲁ 2C82 2C83 2C82 1572 Ⲃ 2C83 2C83 2C82 1572 ⲃ 2C84 2C85 2C84 1573 Ⲅ 2C85 2C85 2C84 1573 ⲅ 2C86 2C87 2C86 1574 Ⲇ 2C87 2C87 2C86 1574 ⲇ 2C88 2C89 2C88 1575 Ⲉ 2C89 2C89 2C88 1575 ⲉ 2C8A 2C8B 2C8A 1577 Ⲋ 2C8B 2C8B 2C8A 1577 ⲋ 2C8C 2C8D 2C8C 1578 Ⲍ 2C8D 2C8D 2C8C 1578 ⲍ 2C8E 2C8F 2C8E 1579 Ⲏ 2C8F 2C8F 2C8E 1579 ⲏ 2CEB 2CEC 2CEB 1591 Ⳬ 2CEC 2CEC 2CEB 1591 ⳬ 2CED 2CEE 2CED 15A0 Ⳮ 2CEE 2CEE 2CED 15A0 ⳮ 04FA 04FB 04FA 15D4 Ӻ 04FB 04FB 04FA 15D4 ӻ 04F6 04F7 04F6 15DC Ӷ 04F7 04F7 04F6 15DC ӷ A640 A641 A640 1611 Ꙁ A641 A641 A640 1611 ꙁ 0510 0511 0510 1613 Ԑ 0511 0511 0510 1613 ԑ A642 A643 A642 1618 Ꙃ A643 A643 A642 1618 ꙃ 0512 0513 0512 1666 Ԓ 0513 0513 0512 1666 ԓ 0514 0515 0514 166E Ԕ 0515 0515 0514 166E ԕ 0516 0517 0516 16B7 Ԗ 0517 0517 0516 16B7 ԗ 04FC 04FD 04FC 16F9 Ӽ 04FD 04FD 04FC 16F9 ӽ 04FE 04FF 04FE 16FD Ӿ 04FF 04FF 04FE 16FD ӿ 04C0 04CF 04C0 17B1 Ӏ 04CF 04CF 04C0 17B1 ӏ 2C00 2C30 2C00 17B5 Ⰰ 2C30 2C30 2C00 17B5 ⰰ 2C01 2C31 2C01 17B6 Ⰱ 2C31 2C31 2C01 17B6 ⰱ 2C02 2C32 2C02 17B7 Ⰲ 2C32 2C32 2C02 17B7 ⰲ 2C03 2C33 2C03 17B8 Ⰳ 2C33 2C33 2C03 17B8 ⰳ 2C04 2C34 2C04 17B9 Ⰴ 2C34 2C34 2C04 17B9 ⰴ 2C05 2C35 2C05 17BA Ⰵ 2C35 2C35 2C05 17BA ⰵ 2C06 2C36 2C06 17BB Ⰶ 2C36 2C36 2C06 17BB ⰶ 2C07 2C37 2C07 17BC Ⰷ 2C37 2C37 2C07 17BC ⰷ 10A0 2D00 10A0 17E5 Ⴀ 2D00 2D00 10A0 17E5 ⴀ 10A1 2D01 10A1 17E7 Ⴁ 2D01 2D01 10A1 17E7 ⴁ 10A2 2D02 10A2 17E9 Ⴂ 2D02 2D02 10A2 17E9 ⴂ 10A3 2D03 10A3 17EB Ⴃ 2D03 2D03 10A3 17EB ⴃ 10A4 2D04 10A4 17ED Ⴄ 2D04 2D04 10A4 17ED ⴄ 10A5 2D05 10A5 17EF Ⴅ 2D05 2D05 10A5 17EF ⴅ 10A6 2D06 10A6 17F1 Ⴆ 2D06 2D06 10A6 17F1 ⴆ 10A7 2D07 10A7 17F5 Ⴇ 2D07 2D07 10A7 17F5 ⴇ D801DC00 D801DC28 D801DC00 30D2 𐐀 D801DC28 D801DC28 D801DC00 30D2 𐐨 D801DC01 D801DC29 D801DC01 30D3 𐐁 D801DC29 D801DC29 D801DC01 30D3 𐐩 D801DC02 D801DC2A D801DC02 30D4 𐐂 D801DC2A D801DC2A D801DC02 30D4 𐐪 D801DC03 D801DC2B D801DC03 30D5 𐐃 D801DC2B D801DC2B D801DC03 30D5 𐐫 D801DC04 D801DC2C D801DC04 30D6 𐐄 D801DC2C D801DC2C D801DC04 30D6 𐐬 D801DC05 D801DC2D D801DC05 30D7 𐐅 D801DC2D D801DC2D D801DC05 30D7 𐐭 D801DC06 D801DC2E D801DC06 30D8 𐐆 D801DC2E D801DC2E D801DC06 30D8 𐐮 D801DC07 D801DC2F D801DC07 30D9 𐐇 D801DC2F D801DC2F D801DC07 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)) 0061 120F 0061D801DC00 120F30D2 0061FFFF 120FFBC1FFFF 0061DBFFDFFF 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 D801DC00 30D2 𐐀 D801DC28 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 D801DC00 30D2 𐐀 D801DC28 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)) 0061 120F 0061D801DC00 120F30D2 0061FFFF 120FFBC1FFFF 0061DBFFDFFF 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 D801DC00 30D2 𐐀 D801DC28 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 D801DC00 30D2 𐐀 D801DC28 30D2 𐐨 DROP TABLE t1; # # End of 5.6 tests #
Close