Linux ip-172-26-2-223 5.4.0-1018-aws #18-Ubuntu SMP Wed Jun 24 01:15:00 UTC 2020 x86_64
Apache
: 172.26.2.223 | : 18.218.54.80
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_gb18030.result
SET @test_character_set= 'gb18030'; SET @test_collation= 'gb18030_chinese_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) gb18030_chinese_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) gb18030_chinese_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) DEFAULT NULL, `level` smallint(5) unsigned DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=gb18030 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 NAMES utf8; SET collation_connection='gb18030_chinese_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) gb18030_chinese_ci 6109 gb18030_chinese_ci 61 gb18030_chinese_ci 6120 drop table t1; create table t1 engine=innodb select repeat('a',50) as c1; alter table t1 add index(c1(5)); insert into t1 values ('abcdefg'),('abcde100'),('abcde110'),('abcde111'); select collation(c1) from t1 limit 1; collation(c1) gb18030_chinese_ci select c1 from t1 where c1 like 'abcdef%' order by c1; c1 abcdefg select c1 from t1 where c1 like 'abcde1%' order by c1; c1 abcde100 abcde110 abcde111 select c1 from t1 where c1 like 'abcde11%' order by c1; c1 abcde110 abcde111 select c1 from t1 where c1 like 'abcde111%' order by c1; c1 abcde111 drop table t1; select @@collation_connection; @@collation_connection gb18030_chinese_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; CREATE TABLE t1 AS SELECT 10 AS a, REPEAT('a',20) AS b, REPEAT('a',8) AS c, REPEAT('a',8) AS d; ALTER TABLE t1 ADD PRIMARY KEY(a), ADD KEY(b); INSERT INTO t1 (a, b) VALUES (1, repeat(0xF1F2,5)); INSERT INTO t1 (a, b) VALUES (2, repeat(0xF1F2,10)); INSERT INTO t1 (a, b) VALUES (3, repeat(0xF1F2,11)); INSERT INTO t1 (a, b) VALUES (4, repeat(0xF1F2,12)); SELECT hex(concat(repeat(0xF1F2, 10), '%')); hex(concat(repeat(0xF1F2, 10), '%')) F1F2F1F2F1F2F1F2F1F2F1F2F1F2F1F2F1F2F1F225 3 rows expected SELECT a, hex(b), c FROM t1 WHERE b LIKE concat(repeat(0xF1F2,10), '%'); a hex(b) c 2 F1F2F1F2F1F2F1F2F1F2F1F2F1F2F1F2F1F2F1F2 NULL 3 F1F2F1F2F1F2F1F2F1F2F1F2F1F2F1F2F1F2F1F2F1F2 NULL 4 F1F2F1F2F1F2F1F2F1F2F1F2F1F2F1F2F1F2F1F2F1F2F1F2 NULL DROP TABLE t1; drop table if exists t1; create table t1 select repeat('a',10) as c1; delete from t1; insert into t1 values (0x20),(0x21),(0x22),(0x23),(0x24),(0x25),(0x26),(0x27),(0x28),(0x29),(0x2A),(0x2B),(0x2C),(0x2D),(0x2E),(0x2F); insert into t1 values (0x30),(0x31),(0x32),(0x33),(0x34),(0x35),(0x36),(0x37),(0x38),(0x39),(0x3A),(0x3B),(0x3C),(0x3D),(0x3E),(0x3F); insert into t1 values (0x40),(0x41),(0x42),(0x43),(0x44),(0x45),(0x46),(0x47),(0x48),(0x49),(0x4A),(0x4B),(0x4C),(0x4D),(0x4E),(0x4F); insert into t1 values (0x50),(0x51),(0x52),(0x53),(0x54),(0x55),(0x56),(0x57),(0x58),(0x59),(0x5A),(0x5B),(0x5C),(0x5D),(0x5E),(0x5F); insert into t1 values (0x60),(0x61),(0x62),(0x63),(0x64),(0x65),(0x66),(0x67),(0x68),(0x69),(0x6A),(0x6B),(0x6C),(0x6D),(0x6E),(0x6F); insert into t1 values (0x70),(0x71),(0x72),(0x73),(0x74),(0x75),(0x76),(0x77),(0x78),(0x79),(0x7A),(0x7B),(0x7C),(0x7D),(0x7E),(0x7F); SELECT GROUP_CONCAT(c1 ORDER BY binary c1 SEPARATOR ''), GROUP_CONCAT(hex(c1) ORDER BY BINARY c1) FROM t1 GROUP BY c1; GROUP_CONCAT(c1 ORDER BY binary c1 SEPARATOR '') GROUP_CONCAT(hex(c1) ORDER BY BINARY c1) 20 ! 21 " 22 # 23 $ 24 % 25 & 26 ' 27 ( 28 ) 29 * 2A + 2B , 2C - 2D . 2E / 2F 0 30 1 31 2 32 3 33 4 34 5 35 6 36 7 37 8 38 9 39 : 3A ; 3B < 3C = 3D > 3E ? 3F @ 40 Aa 41,61 Bb 42,62 Cc 43,63 Dd 44,64 Ee 45,65 Ff 46,66 Gg 47,67 Hh 48,68 Ii 49,69 Jj 4A,6A Kk 4B,6B Ll 4C,6C Mm 4D,6D Nn 4E,6E Oo 4F,6F Pp 50,70 Qq 51,71 Rr 52,72 Ss 53,73 Tt 54,74 Uu 55,75 Vv 56,76 Ww 57,77 Xx 58,78 Yy 59,79 Zz 5A,7A [ 5B \ 5C ] 5D ^ 5E _ 5F ` 60 { 7B | 7C } 7D ~ 7E 7F drop table t1; SET collation_connection='gb18030_bin'; 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) gb18030_bin 6109 gb18030_bin 61 gb18030_bin 6120 drop table t1; create table t1 engine=innodb select repeat('a',50) as c1; alter table t1 add index(c1(5)); insert into t1 values ('abcdefg'),('abcde100'),('abcde110'),('abcde111'); select collation(c1) from t1 limit 1; collation(c1) gb18030_bin select c1 from t1 where c1 like 'abcdef%' order by c1; c1 abcdefg select c1 from t1 where c1 like 'abcde1%' order by c1; c1 abcde100 abcde110 abcde111 select c1 from t1 where c1 like 'abcde11%' order by c1; c1 abcde110 abcde111 select c1 from t1 where c1 like 'abcde111%' order by c1; c1 abcde111 drop table t1; select @@collation_connection; @@collation_connection gb18030_bin 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; CREATE TABLE t1 AS SELECT 10 AS a, REPEAT('a',20) AS b, REPEAT('a',8) AS c, REPEAT('a',8) AS d; ALTER TABLE t1 ADD PRIMARY KEY(a), ADD KEY(b); INSERT INTO t1 (a, b) VALUES (1, repeat(0xF1F2,5)); INSERT INTO t1 (a, b) VALUES (2, repeat(0xF1F2,10)); INSERT INTO t1 (a, b) VALUES (3, repeat(0xF1F2,11)); INSERT INTO t1 (a, b) VALUES (4, repeat(0xF1F2,12)); SELECT hex(concat(repeat(0xF1F2, 10), '%')); hex(concat(repeat(0xF1F2, 10), '%')) F1F2F1F2F1F2F1F2F1F2F1F2F1F2F1F2F1F2F1F225 3 rows expected SELECT a, hex(b), c FROM t1 WHERE b LIKE concat(repeat(0xF1F2,10), '%'); a hex(b) c 2 F1F2F1F2F1F2F1F2F1F2F1F2F1F2F1F2F1F2F1F2 NULL 3 F1F2F1F2F1F2F1F2F1F2F1F2F1F2F1F2F1F2F1F2F1F2 NULL 4 F1F2F1F2F1F2F1F2F1F2F1F2F1F2F1F2F1F2F1F2F1F2F1F2 NULL DROP TABLE t1; SELECT HEX(CONVERT(_gb18030 0xA14041 USING ucs2)); HEX(CONVERT(_gb18030 0xA14041 USING ucs2)) E4C60041 SELECT HEX(CONVERT(_gb18030 0xA14041 USING utf8)); HEX(CONVERT(_gb18030 0xA14041 USING utf8)) EE938641 SELECT HEX(CONVERT(_gb18030 0xFEFEFEFD814040 USING utf32)); HEX(CONVERT(_gb18030 0xFEFEFEFD814040 USING utf32)) 0000E4C50000E4C400004E0200000040 SELECT HEX(CONVERT(_gb18030 0x813081304041A140 USING utf32)); HEX(CONVERT(_gb18030 0x813081304041A140 USING utf32)) 0000008000000040000000410000E4C6 SELECT HEX(CONVERT(_gb18030 0xE3329A34 USING utf32)); HEX(CONVERT(_gb18030 0xE3329A34 USING utf32)) 0010FFFE SELECT HEX(CONVERT(_gb18030 0xE3329A35 USING utf32)); HEX(CONVERT(_gb18030 0xE3329A35 USING utf32)) 0010FFFF SELECT HEX(CONVERT(_gb18030 0xE3329A36 USING utf32)); HEX(CONVERT(_gb18030 0xE3329A36 USING utf32)) 0000003F SELECT HEX(CONVERT(_gb18030 0xFE39FE39 USING utf32)); HEX(CONVERT(_gb18030 0xFE39FE39 USING utf32)) 0000003F SELECT HEX(CONVERT(_ucs2 0xD800 USING gb18030)); HEX(CONVERT(_ucs2 0xD800 USING gb18030)) 3F SELECT HEX(CONVERT(_ucs2 0xDFFF USING gb18030)); HEX(CONVERT(_ucs2 0xDFFF USING gb18030)) 3F SELECT HEX(CONVERT(_ucs2 0xE000 USING gb18030)); HEX(CONVERT(_ucs2 0xE000 USING gb18030)) AAA1 SELECT HEX(CONVERT(_ucs2 0xF8FF USING gb18030)); HEX(CONVERT(_ucs2 0xF8FF USING gb18030)) 84308130 SELECT HEX(CONVERT(_gb18030 0xA13941 USING ucs2)); ERROR HY000: Invalid gb18030 character string: 'A13941' SELECT HEX(CONVERT(_gb18030 0xFFFE USING ucs2)); ERROR HY000: Invalid gb18030 character string: 'FFFE' SELECT HEX(CONVERT(_gb18030 0x81308140 USING ucs2)); ERROR HY000: Invalid gb18030 character string: '813081' SELECT LOCATE(_gb18030 0x8140, _gb18030 0x814181408142); LOCATE(_gb18030 0x8140, _gb18030 0x814181408142) 2 SELECT HEX(REVERSE(_gb18030 0x8140814181428130813081308131FE39FE39)); HEX(REVERSE(_gb18030 0x8140814181428130813081308131FE39FE39)) FE39FE398130813181308130814281418140 SELECT HEX(SUBSTRING(_gb18030 0x81308131813081328130813381308134, 1, 2)); HEX(SUBSTRING(_gb18030 0x81308131813081328130813381308134, 1, 2)) 8130813181308132 SELECT HEX(SUBSTRING(_gb18030 0x81308131813081328130813381308134, -3, 2)); HEX(SUBSTRING(_gb18030 0x81308131813081328130813381308134, -3, 2)) 8130813281308133 SELECT HEX(TRIM(_gb18030 0x20202081408141208144202020)); HEX(TRIM(_gb18030 0x20202081408141208144202020)) 81408141208144 CREATE TABLE t1 (c1 TEXT not null, c2 TEXT not null) CHARACTER SET gb18030; ALTER TABLE t1 CHANGE c1 c1 MEDIUMTEXT CHARACTER SET gb18030 NOT NULL; SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( `c1` mediumtext NOT NULL, `c2` text NOT NULL ) ENGINE=default_engine DEFAULT CHARSET=gb18030 DROP TABLE t1; CREATE TABLE t1(a MEDIUMTEXT CHARACTER SET gb18030, b MEDIUMTEXT CHARACTER SET big5); INSERT INTO t1 VALUES (REPEAT(0x1125,200000), REPEAT(0x1125,200000)), ('', ''), ('', ''); SELECT a FROM t1 GROUP BY 1 LIMIT 1 INTO @nullll; SELECT b FROM t1 GROUP BY 1 LIMIT 1 INTO @nullll; DROP TABLES t1; SET NAMES utf8mb4; SET collation_connection=gb18030_chinese_ci; select @@collation_connection; @@collation_connection gb18030_chinese_ci select hex(weight_string('a')); hex(weight_string('a')) 41 select hex(weight_string('A')); hex(weight_string('A')) 41 select hex(weight_string('abc')); hex(weight_string('abc')) 414243 select hex(weight_string('abc' as char(2))); hex(weight_string('abc' as char(2))) 4142 select hex(weight_string('abc' as char(3))); hex(weight_string('abc' as char(3))) 414243 select hex(weight_string('abc' as char(5))); hex(weight_string('abc' as char(5))) 4142432020 select hex(weight_string('abc', 1, 2, 0xC0)); hex(weight_string('abc', 1, 2, 0xC0)) 41 select hex(weight_string('abc', 2, 2, 0xC0)); hex(weight_string('abc', 2, 2, 0xC0)) 4142 select hex(weight_string('abc', 3, 2, 0xC0)); hex(weight_string('abc', 3, 2, 0xC0)) 414220 select hex(weight_string('abc', 4, 2, 0xC0)); hex(weight_string('abc', 4, 2, 0xC0)) 41422020 select hex(weight_string('abc', 5, 2, 0xC0)); hex(weight_string('abc', 5, 2, 0xC0)) 4142202020 select hex(weight_string('abc',25, 2, 0xC0)); hex(weight_string('abc',25, 2, 0xC0)) 41422020202020202020202020202020202020202020202020 select hex(weight_string('abc', 1, 3, 0xC0)); hex(weight_string('abc', 1, 3, 0xC0)) 41 select hex(weight_string('abc', 2, 3, 0xC0)); hex(weight_string('abc', 2, 3, 0xC0)) 4142 select hex(weight_string('abc', 3, 3, 0xC0)); hex(weight_string('abc', 3, 3, 0xC0)) 414243 select hex(weight_string('abc', 4, 3, 0xC0)); hex(weight_string('abc', 4, 3, 0xC0)) 41424320 select hex(weight_string('abc', 5, 3, 0xC0)); hex(weight_string('abc', 5, 3, 0xC0)) 4142432020 select hex(weight_string('abc',25, 3, 0xC0)); hex(weight_string('abc',25, 3, 0xC0)) 41424320202020202020202020202020202020202020202020 select hex(weight_string('abc', 1, 4, 0xC0)); hex(weight_string('abc', 1, 4, 0xC0)) 41 select hex(weight_string('abc', 2, 4, 0xC0)); hex(weight_string('abc', 2, 4, 0xC0)) 4142 select hex(weight_string('abc', 3, 4, 0xC0)); hex(weight_string('abc', 3, 4, 0xC0)) 414243 select hex(weight_string('abc', 4, 4, 0xC0)); hex(weight_string('abc', 4, 4, 0xC0)) 41424320 select hex(weight_string('abc', 5, 4, 0xC0)); hex(weight_string('abc', 5, 4, 0xC0)) 4142432020 select hex(weight_string('abc',25, 4, 0xC0)); hex(weight_string('abc',25, 4, 0xC0)) 41424320202020202020202020202020202020202020202020 select @@collation_connection; @@collation_connection gb18030_chinese_ci select hex(weight_string('a' LEVEL 1)); hex(weight_string('a' LEVEL 1)) 41 select hex(weight_string('A' LEVEL 1)); hex(weight_string('A' LEVEL 1)) 41 select hex(weight_string('abc' LEVEL 1)); hex(weight_string('abc' LEVEL 1)) 414243 select hex(weight_string('abc' as char(2) LEVEL 1)); hex(weight_string('abc' as char(2) LEVEL 1)) 4142 select hex(weight_string('abc' as char(3) LEVEL 1)); hex(weight_string('abc' as char(3) LEVEL 1)) 414243 select hex(weight_string('abc' as char(5) LEVEL 1)); hex(weight_string('abc' as char(5) LEVEL 1)) 4142432020 select hex(weight_string('abc' as char(5) LEVEL 1 REVERSE)); hex(weight_string('abc' as char(5) LEVEL 1 REVERSE)) 2020434241 select hex(weight_string('abc' as char(5) LEVEL 1 DESC)); hex(weight_string('abc' as char(5) LEVEL 1 DESC)) BEBDBCDFDF select hex(weight_string('abc' as char(5) LEVEL 1 DESC REVERSE)); hex(weight_string('abc' as char(5) LEVEL 1 DESC REVERSE)) DFDFBCBDBE select collation(cast(0xA1A1 as char)); collation(cast(0xA1A1 as char)) gb18030_chinese_ci select hex(weight_string(cast(0x6141 as char))); hex(weight_string(cast(0x6141 as char))) 4141 select hex(weight_string(cast(0xA1A1 as char))); hex(weight_string(cast(0xA1A1 as char))) A1A1 select hex(weight_string(cast(0xA1A1 as char) as char(1))); hex(weight_string(cast(0xA1A1 as char) as char(1))) A1A1 select hex(weight_string(cast(0xA1A1A1A1 as char) as char(1))); hex(weight_string(cast(0xA1A1A1A1 as char) as char(1))) A1A1 select hex(weight_string(cast(0xA1A1 as char) as char(3))); hex(weight_string(cast(0xA1A1 as char) as char(3))) A1A12020 select hex(weight_string(cast(0xA1A1A1A1 as char) as char(3))); hex(weight_string(cast(0xA1A1A1A1 as char) as char(3))) A1A1A1A120 select hex(weight_string(cast(0x40A1A1 as char) as char(3))); hex(weight_string(cast(0x40A1A1 as char) as char(3))) 40A1A120 select hex(weight_string(cast(0x40A1A1A1A1 as char) as char(3))); hex(weight_string(cast(0x40A1A1A1A1 as char) as char(3))) 40A1A1A1A1 select hex(weight_string(cast(0x40A1A1A1A1A1A1 as char) as char(3))); hex(weight_string(cast(0x40A1A1A1A1A1A1 as char) as char(3))) 40A1A1A1A1 select hex(weight_string(cast(0x4040A1A1A1A1A1A1 as char) as char(3))); hex(weight_string(cast(0x4040A1A1A1A1A1A1 as char) as char(3))) 4040A1A1 select hex(weight_string(cast(0xA1A1A1A1A1A1 as char), 1, 2, 0xC0)); hex(weight_string(cast(0xA1A1A1A1A1A1 as char), 1, 2, 0xC0)) A1 select hex(weight_string(cast(0xA1A1A1A1A1A1 as char), 2, 2, 0xC0)); hex(weight_string(cast(0xA1A1A1A1A1A1 as char), 2, 2, 0xC0)) A1A1 select hex(weight_string(cast(0xA1A1A1A1A1A1 as char), 3, 2, 0xC0)); hex(weight_string(cast(0xA1A1A1A1A1A1 as char), 3, 2, 0xC0)) A1A1A1 select hex(weight_string(cast(0xA1A1A1A1A1A1 as char), 4, 2, 0xC0)); hex(weight_string(cast(0xA1A1A1A1A1A1 as char), 4, 2, 0xC0)) A1A1A1A1 select hex(weight_string(cast(0xA1A1A1A1A1A1 as char), 5, 2, 0xC0)); hex(weight_string(cast(0xA1A1A1A1A1A1 as char), 5, 2, 0xC0)) A1A1A1A120 select hex(weight_string(cast(0xA1A1A1A1A1A1 as char),25, 2, 0xC0)); hex(weight_string(cast(0xA1A1A1A1A1A1 as char),25, 2, 0xC0)) A1A1A1A1202020202020202020202020202020202020202020 select hex(weight_string(cast(0xA1A1A1A1A1A1 as char), 1, 3, 0xC0)); hex(weight_string(cast(0xA1A1A1A1A1A1 as char), 1, 3, 0xC0)) A1 select hex(weight_string(cast(0xA1A1A1A1A1A1 as char), 2, 3, 0xC0)); hex(weight_string(cast(0xA1A1A1A1A1A1 as char), 2, 3, 0xC0)) A1A1 select hex(weight_string(cast(0xA1A1A1A1A1A1 as char), 3, 3, 0xC0)); hex(weight_string(cast(0xA1A1A1A1A1A1 as char), 3, 3, 0xC0)) A1A1A1 select hex(weight_string(cast(0xA1A1A1A1A1A1 as char), 4, 3, 0xC0)); hex(weight_string(cast(0xA1A1A1A1A1A1 as char), 4, 3, 0xC0)) A1A1A1A1 select hex(weight_string(cast(0xA1A1A1A1A1A1 as char), 5, 3, 0xC0)); hex(weight_string(cast(0xA1A1A1A1A1A1 as char), 5, 3, 0xC0)) A1A1A1A1A1 select hex(weight_string(cast(0xA1A1A1A1A1A1 as char),25, 3, 0xC0)); hex(weight_string(cast(0xA1A1A1A1A1A1 as char),25, 3, 0xC0)) A1A1A1A1A1A120202020202020202020202020202020202020 select hex(weight_string(cast(0xA1A1A1A1A1A1 as char), 1, 4, 0xC0)); hex(weight_string(cast(0xA1A1A1A1A1A1 as char), 1, 4, 0xC0)) A1 select hex(weight_string(cast(0xA1A1A1A1A1A1 as char), 2, 4, 0xC0)); hex(weight_string(cast(0xA1A1A1A1A1A1 as char), 2, 4, 0xC0)) A1A1 select hex(weight_string(cast(0xA1A1A1A1A1A1 as char), 3, 4, 0xC0)); hex(weight_string(cast(0xA1A1A1A1A1A1 as char), 3, 4, 0xC0)) A1A1A1 select hex(weight_string(cast(0xA1A1A1A1A1A1 as char), 4, 4, 0xC0)); hex(weight_string(cast(0xA1A1A1A1A1A1 as char), 4, 4, 0xC0)) A1A1A1A1 select hex(weight_string(cast(0xA1A1A1A1A1A1 as char), 5, 4, 0xC0)); hex(weight_string(cast(0xA1A1A1A1A1A1 as char), 5, 4, 0xC0)) A1A1A1A1A1 select hex(weight_string(cast(0xA1A1A1A1A1A1 as char),25, 4, 0xC0)); hex(weight_string(cast(0xA1A1A1A1A1A1 as char),25, 4, 0xC0)) A1A1A1A1A1A120202020202020202020202020202020202020 select collation(cast(0xA2A9 as char)); collation(cast(0xA2A9 as char)) gb18030_chinese_ci select hex(weight_string(cast(0x6141 as char))); hex(weight_string(cast(0x6141 as char))) 4141 select hex(weight_string(cast(0xA2A9 as char))); hex(weight_string(cast(0xA2A9 as char))) A2F9 select hex(weight_string(cast(0xA2A9 as char) as char(1))); hex(weight_string(cast(0xA2A9 as char) as char(1))) A2F9 select hex(weight_string(cast(0xA2A9A2A9 as char) as char(1))); hex(weight_string(cast(0xA2A9A2A9 as char) as char(1))) A2F9 select hex(weight_string(cast(0xA2A9 as char) as char(3))); hex(weight_string(cast(0xA2A9 as char) as char(3))) A2F92020 select hex(weight_string(cast(0xA2A9A2A9 as char) as char(3))); hex(weight_string(cast(0xA2A9A2A9 as char) as char(3))) A2F9A2F920 select hex(weight_string(cast(0x40A2A9 as char) as char(3))); hex(weight_string(cast(0x40A2A9 as char) as char(3))) 40A2F920 select hex(weight_string(cast(0x40A2A9A2A9 as char) as char(3))); hex(weight_string(cast(0x40A2A9A2A9 as char) as char(3))) 40A2F9A2F9 select hex(weight_string(cast(0x40A2A9A2A9A2A9 as char) as char(3))); hex(weight_string(cast(0x40A2A9A2A9A2A9 as char) as char(3))) 40A2F9A2F9 select hex(weight_string(cast(0x4040A2A9A2A9A2A9 as char) as char(3))); hex(weight_string(cast(0x4040A2A9A2A9A2A9 as char) as char(3))) 4040A2F9 select hex(weight_string(cast(0xA2A9A2A9A2A9 as char), 1, 2, 0xC0)); hex(weight_string(cast(0xA2A9A2A9A2A9 as char), 1, 2, 0xC0)) A2 select hex(weight_string(cast(0xA2A9A2A9A2A9 as char), 2, 2, 0xC0)); hex(weight_string(cast(0xA2A9A2A9A2A9 as char), 2, 2, 0xC0)) A2F9 select hex(weight_string(cast(0xA2A9A2A9A2A9 as char), 3, 2, 0xC0)); hex(weight_string(cast(0xA2A9A2A9A2A9 as char), 3, 2, 0xC0)) A2F9A2 select hex(weight_string(cast(0xA2A9A2A9A2A9 as char), 4, 2, 0xC0)); hex(weight_string(cast(0xA2A9A2A9A2A9 as char), 4, 2, 0xC0)) A2F9A2F9 select hex(weight_string(cast(0xA2A9A2A9A2A9 as char), 5, 2, 0xC0)); hex(weight_string(cast(0xA2A9A2A9A2A9 as char), 5, 2, 0xC0)) A2F9A2F920 select hex(weight_string(cast(0xA2A9A2A9A2A9 as char),25, 2, 0xC0)); hex(weight_string(cast(0xA2A9A2A9A2A9 as char),25, 2, 0xC0)) A2F9A2F9202020202020202020202020202020202020202020 select hex(weight_string(cast(0xA2A9A2A9A2A9 as char), 1, 3, 0xC0)); hex(weight_string(cast(0xA2A9A2A9A2A9 as char), 1, 3, 0xC0)) A2 select hex(weight_string(cast(0xA2A9A2A9A2A9 as char), 2, 3, 0xC0)); hex(weight_string(cast(0xA2A9A2A9A2A9 as char), 2, 3, 0xC0)) A2F9 select hex(weight_string(cast(0xA2A9A2A9A2A9 as char), 3, 3, 0xC0)); hex(weight_string(cast(0xA2A9A2A9A2A9 as char), 3, 3, 0xC0)) A2F9A2 select hex(weight_string(cast(0xA2A9A2A9A2A9 as char), 4, 3, 0xC0)); hex(weight_string(cast(0xA2A9A2A9A2A9 as char), 4, 3, 0xC0)) A2F9A2F9 select hex(weight_string(cast(0xA2A9A2A9A2A9 as char), 5, 3, 0xC0)); hex(weight_string(cast(0xA2A9A2A9A2A9 as char), 5, 3, 0xC0)) A2F9A2F9A2 select hex(weight_string(cast(0xA2A9A2A9A2A9 as char),25, 3, 0xC0)); hex(weight_string(cast(0xA2A9A2A9A2A9 as char),25, 3, 0xC0)) A2F9A2F9A2F920202020202020202020202020202020202020 select hex(weight_string(cast(0xA2A9A2A9A2A9 as char), 1, 4, 0xC0)); hex(weight_string(cast(0xA2A9A2A9A2A9 as char), 1, 4, 0xC0)) A2 select hex(weight_string(cast(0xA2A9A2A9A2A9 as char), 2, 4, 0xC0)); hex(weight_string(cast(0xA2A9A2A9A2A9 as char), 2, 4, 0xC0)) A2F9 select hex(weight_string(cast(0xA2A9A2A9A2A9 as char), 3, 4, 0xC0)); hex(weight_string(cast(0xA2A9A2A9A2A9 as char), 3, 4, 0xC0)) A2F9A2 select hex(weight_string(cast(0xA2A9A2A9A2A9 as char), 4, 4, 0xC0)); hex(weight_string(cast(0xA2A9A2A9A2A9 as char), 4, 4, 0xC0)) A2F9A2F9 select hex(weight_string(cast(0xA2A9A2A9A2A9 as char), 5, 4, 0xC0)); hex(weight_string(cast(0xA2A9A2A9A2A9 as char), 5, 4, 0xC0)) A2F9A2F9A2 select hex(weight_string(cast(0xA2A9A2A9A2A9 as char),25, 4, 0xC0)); hex(weight_string(cast(0xA2A9A2A9A2A9 as char),25, 4, 0xC0)) A2F9A2F9A2F920202020202020202020202020202020202020 SELECT collation(CAST(0x81309D30 AS CHAR)); collation(CAST(0x81309D30 AS CHAR)) gb18030_chinese_ci SELECT HEX(WEIGHT_STRING(CAST(0x6141 AS CHAR))); HEX(WEIGHT_STRING(CAST(0x6141 AS CHAR))) 4141 SELECT HEX(WEIGHT_STRING(CAST(0x81309D30 AS CHAR))); HEX(WEIGHT_STRING(CAST(0x81309D30 AS CHAR))) FF000117 SELECT HEX(WEIGHT_STRING(CAST(0x81309D30 AS CHAR) AS CHAR(1))); HEX(WEIGHT_STRING(CAST(0x81309D30 AS CHAR) AS CHAR(1))) FF000117 SELECT HEX(WEIGHT_STRING(CAST(0x81309D3081309D30 AS CHAR) AS CHAR(1))); HEX(WEIGHT_STRING(CAST(0x81309D3081309D30 AS CHAR) AS CHAR(1))) FF000117 SELECT HEX(WEIGHT_STRING(CAST(0x81309D30 AS CHAR) AS CHAR(3))); HEX(WEIGHT_STRING(CAST(0x81309D30 AS CHAR) AS CHAR(3))) FF0001172020 SELECT HEX(WEIGHT_STRING(CAST(0x81309D3081309D30 AS CHAR) AS CHAR(3))); HEX(WEIGHT_STRING(CAST(0x81309D3081309D30 AS CHAR) AS CHAR(3))) FF000117FF00011720 SELECT HEX(WEIGHT_STRING(CAST(0x4081309D30 AS CHAR) AS CHAR(3))); HEX(WEIGHT_STRING(CAST(0x4081309D30 AS CHAR) AS CHAR(3))) 40FF00011720 SELECT HEX(WEIGHT_STRING(CAST(0x4081309D3081309D30 AS CHAR) AS CHAR(3))); HEX(WEIGHT_STRING(CAST(0x4081309D3081309D30 AS CHAR) AS CHAR(3))) 40FF000117FF000117 SELECT HEX(WEIGHT_STRING(CAST(0x4081309D3081309D3081309D30 AS CHAR) AS CHAR(3))); HEX(WEIGHT_STRING(CAST(0x4081309D3081309D3081309D30 AS CHAR) AS CHAR(3))) 40FF000117FF000117 SELECT HEX(WEIGHT_STRING(CAST(0x404081309D3081309D3081309D30 AS CHAR) AS CHAR(3))); HEX(WEIGHT_STRING(CAST(0x404081309D3081309D3081309D30 AS CHAR) AS CHAR(3))) 4040FF000117 SELECT HEX(WEIGHT_STRING(CAST(0x81309D3081309D3081309D30 AS CHAR), 1, 2, 0xC0)); HEX(WEIGHT_STRING(CAST(0x81309D3081309D3081309D30 AS CHAR), 1, 2, 0xC0)) FF SELECT HEX(WEIGHT_STRING(CAST(0x81309D3081309D3081309D30 AS CHAR), 2, 2, 0xC0)); HEX(WEIGHT_STRING(CAST(0x81309D3081309D3081309D30 AS CHAR), 2, 2, 0xC0)) FF00 SELECT HEX(WEIGHT_STRING(CAST(0x81309D3081309D3081309D30 AS CHAR), 3, 2, 0xC0)); HEX(WEIGHT_STRING(CAST(0x81309D3081309D3081309D30 AS CHAR), 3, 2, 0xC0)) FF0001 SELECT HEX(WEIGHT_STRING(CAST(0x81309D3081309D3081309D30 AS CHAR), 4, 2, 0xC0)); HEX(WEIGHT_STRING(CAST(0x81309D3081309D3081309D30 AS CHAR), 4, 2, 0xC0)) FF000117 SELECT HEX(WEIGHT_STRING(CAST(0x81309D3081309D3081309D30 AS CHAR), 5, 2, 0xC0)); HEX(WEIGHT_STRING(CAST(0x81309D3081309D3081309D30 AS CHAR), 5, 2, 0xC0)) FF000117FF SELECT HEX(WEIGHT_STRING(CAST(0x81309D3081309D3081309D30 AS CHAR), 25, 2, 0xC0)); HEX(WEIGHT_STRING(CAST(0x81309D3081309D3081309D30 AS CHAR), 25, 2, 0xC0)) FF000117FF0001172020202020202020202020202020202020 SELECT HEX(WEIGHT_STRING(CAST(0x81309D3081309D3081309D30 AS CHAR), 1, 3, 0xC0)); HEX(WEIGHT_STRING(CAST(0x81309D3081309D3081309D30 AS CHAR), 1, 3, 0xC0)) FF SELECT HEX(WEIGHT_STRING(CAST(0x81309D3081309D3081309D30 AS CHAR), 2, 3, 0xC0)); HEX(WEIGHT_STRING(CAST(0x81309D3081309D3081309D30 AS CHAR), 2, 3, 0xC0)) FF00 SELECT HEX(WEIGHT_STRING(CAST(0x81309D3081309D3081309D30 AS CHAR), 3, 3, 0xC0)); HEX(WEIGHT_STRING(CAST(0x81309D3081309D3081309D30 AS CHAR), 3, 3, 0xC0)) FF0001 SELECT HEX(WEIGHT_STRING(CAST(0x81309D3081309D3081309D30 AS CHAR), 4, 3, 0xC0)); HEX(WEIGHT_STRING(CAST(0x81309D3081309D3081309D30 AS CHAR), 4, 3, 0xC0)) FF000117 SELECT HEX(WEIGHT_STRING(CAST(0x81309D3081309D3081309D30 AS CHAR), 5, 3, 0xC0)); HEX(WEIGHT_STRING(CAST(0x81309D3081309D3081309D30 AS CHAR), 5, 3, 0xC0)) FF000117FF SELECT HEX(WEIGHT_STRING(CAST(0x81309D3081309D3081309D30 AS CHAR), 25, 3, 0xC0)); HEX(WEIGHT_STRING(CAST(0x81309D3081309D3081309D30 AS CHAR), 25, 3, 0xC0)) FF000117FF000117FF00011720202020202020202020202020 SELECT HEX(WEIGHT_STRING(CAST(0x81309D3081309D3081309D30 AS CHAR), 1, 4, 0xC0)); HEX(WEIGHT_STRING(CAST(0x81309D3081309D3081309D30 AS CHAR), 1, 4, 0xC0)) FF SELECT HEX(WEIGHT_STRING(CAST(0x81309D3081309D3081309D30 AS CHAR), 2, 4, 0xC0)); HEX(WEIGHT_STRING(CAST(0x81309D3081309D3081309D30 AS CHAR), 2, 4, 0xC0)) FF00 SELECT HEX(WEIGHT_STRING(CAST(0x81309D3081309D3081309D30 AS CHAR), 3, 4, 0xC0)); HEX(WEIGHT_STRING(CAST(0x81309D3081309D3081309D30 AS CHAR), 3, 4, 0xC0)) FF0001 SELECT HEX(WEIGHT_STRING(CAST(0x81309D3081309D3081309D30 AS CHAR), 4, 4, 0xC0)); HEX(WEIGHT_STRING(CAST(0x81309D3081309D3081309D30 AS CHAR), 4, 4, 0xC0)) FF000117 SELECT HEX(WEIGHT_STRING(CAST(0x81309D3081309D3081309D30 AS CHAR), 5, 4, 0xC0)); HEX(WEIGHT_STRING(CAST(0x81309D3081309D3081309D30 AS CHAR), 5, 4, 0xC0)) FF000117FF SELECT HEX(WEIGHT_STRING(CAST(0x81309D3081309D3081309D30 AS CHAR), 25, 4, 0xC0)); HEX(WEIGHT_STRING(CAST(0x81309D3081309D3081309D30 AS CHAR), 25, 4, 0xC0)) FF000117FF000117FF00011720202020202020202020202020 SET collation_connection=gb18030_bin; select @@collation_connection; @@collation_connection gb18030_bin select hex(weight_string('a')); hex(weight_string('a')) 61 select hex(weight_string('A')); hex(weight_string('A')) 41 select hex(weight_string('abc')); hex(weight_string('abc')) 616263 select hex(weight_string('abc' as char(2))); hex(weight_string('abc' as char(2))) 6162 select hex(weight_string('abc' as char(3))); hex(weight_string('abc' as char(3))) 616263 select hex(weight_string('abc' as char(5))); hex(weight_string('abc' as char(5))) 6162632020 select hex(weight_string('abc', 1, 2, 0xC0)); hex(weight_string('abc', 1, 2, 0xC0)) 61 select hex(weight_string('abc', 2, 2, 0xC0)); hex(weight_string('abc', 2, 2, 0xC0)) 6162 select hex(weight_string('abc', 3, 2, 0xC0)); hex(weight_string('abc', 3, 2, 0xC0)) 616220 select hex(weight_string('abc', 4, 2, 0xC0)); hex(weight_string('abc', 4, 2, 0xC0)) 61622020 select hex(weight_string('abc', 5, 2, 0xC0)); hex(weight_string('abc', 5, 2, 0xC0)) 6162202020 select hex(weight_string('abc',25, 2, 0xC0)); hex(weight_string('abc',25, 2, 0xC0)) 61622020202020202020202020202020202020202020202020 select hex(weight_string('abc', 1, 3, 0xC0)); hex(weight_string('abc', 1, 3, 0xC0)) 61 select hex(weight_string('abc', 2, 3, 0xC0)); hex(weight_string('abc', 2, 3, 0xC0)) 6162 select hex(weight_string('abc', 3, 3, 0xC0)); hex(weight_string('abc', 3, 3, 0xC0)) 616263 select hex(weight_string('abc', 4, 3, 0xC0)); hex(weight_string('abc', 4, 3, 0xC0)) 61626320 select hex(weight_string('abc', 5, 3, 0xC0)); hex(weight_string('abc', 5, 3, 0xC0)) 6162632020 select hex(weight_string('abc',25, 3, 0xC0)); hex(weight_string('abc',25, 3, 0xC0)) 61626320202020202020202020202020202020202020202020 select hex(weight_string('abc', 1, 4, 0xC0)); hex(weight_string('abc', 1, 4, 0xC0)) 61 select hex(weight_string('abc', 2, 4, 0xC0)); hex(weight_string('abc', 2, 4, 0xC0)) 6162 select hex(weight_string('abc', 3, 4, 0xC0)); hex(weight_string('abc', 3, 4, 0xC0)) 616263 select hex(weight_string('abc', 4, 4, 0xC0)); hex(weight_string('abc', 4, 4, 0xC0)) 61626320 select hex(weight_string('abc', 5, 4, 0xC0)); hex(weight_string('abc', 5, 4, 0xC0)) 6162632020 select hex(weight_string('abc',25, 4, 0xC0)); hex(weight_string('abc',25, 4, 0xC0)) 61626320202020202020202020202020202020202020202020 select @@collation_connection; @@collation_connection gb18030_bin select hex(weight_string('a' LEVEL 1)); hex(weight_string('a' LEVEL 1)) 61 select hex(weight_string('A' LEVEL 1)); hex(weight_string('A' LEVEL 1)) 41 select hex(weight_string('abc' LEVEL 1)); hex(weight_string('abc' LEVEL 1)) 616263 select hex(weight_string('abc' as char(2) LEVEL 1)); hex(weight_string('abc' as char(2) LEVEL 1)) 6162 select hex(weight_string('abc' as char(3) LEVEL 1)); hex(weight_string('abc' as char(3) LEVEL 1)) 616263 select hex(weight_string('abc' as char(5) LEVEL 1)); hex(weight_string('abc' as char(5) LEVEL 1)) 6162632020 select hex(weight_string('abc' as char(5) LEVEL 1 REVERSE)); hex(weight_string('abc' as char(5) LEVEL 1 REVERSE)) 2020636261 select hex(weight_string('abc' as char(5) LEVEL 1 DESC)); hex(weight_string('abc' as char(5) LEVEL 1 DESC)) 9E9D9CDFDF select hex(weight_string('abc' as char(5) LEVEL 1 DESC REVERSE)); hex(weight_string('abc' as char(5) LEVEL 1 DESC REVERSE)) DFDF9C9D9E select collation(cast(0xA1A1 as char)); collation(cast(0xA1A1 as char)) gb18030_bin select hex(weight_string(cast(0x6141 as char))); hex(weight_string(cast(0x6141 as char))) 6141 select hex(weight_string(cast(0xA1A1 as char))); hex(weight_string(cast(0xA1A1 as char))) A1A1 select hex(weight_string(cast(0xA1A1 as char) as char(1))); hex(weight_string(cast(0xA1A1 as char) as char(1))) A1A1 select hex(weight_string(cast(0xA1A1A1A1 as char) as char(1))); hex(weight_string(cast(0xA1A1A1A1 as char) as char(1))) A1A1 select hex(weight_string(cast(0xA1A1 as char) as char(3))); hex(weight_string(cast(0xA1A1 as char) as char(3))) A1A12020 select hex(weight_string(cast(0xA1A1A1A1 as char) as char(3))); hex(weight_string(cast(0xA1A1A1A1 as char) as char(3))) A1A1A1A120 select hex(weight_string(cast(0x40A1A1 as char) as char(3))); hex(weight_string(cast(0x40A1A1 as char) as char(3))) 40A1A120 select hex(weight_string(cast(0x40A1A1A1A1 as char) as char(3))); hex(weight_string(cast(0x40A1A1A1A1 as char) as char(3))) 40A1A1A1A1 select hex(weight_string(cast(0x40A1A1A1A1A1A1 as char) as char(3))); hex(weight_string(cast(0x40A1A1A1A1A1A1 as char) as char(3))) 40A1A1A1A1 select hex(weight_string(cast(0x4040A1A1A1A1A1A1 as char) as char(3))); hex(weight_string(cast(0x4040A1A1A1A1A1A1 as char) as char(3))) 4040A1A1 select hex(weight_string(cast(0xA1A1A1A1A1A1 as char), 1, 2, 0xC0)); hex(weight_string(cast(0xA1A1A1A1A1A1 as char), 1, 2, 0xC0)) A1 select hex(weight_string(cast(0xA1A1A1A1A1A1 as char), 2, 2, 0xC0)); hex(weight_string(cast(0xA1A1A1A1A1A1 as char), 2, 2, 0xC0)) A1A1 select hex(weight_string(cast(0xA1A1A1A1A1A1 as char), 3, 2, 0xC0)); hex(weight_string(cast(0xA1A1A1A1A1A1 as char), 3, 2, 0xC0)) A1A1A1 select hex(weight_string(cast(0xA1A1A1A1A1A1 as char), 4, 2, 0xC0)); hex(weight_string(cast(0xA1A1A1A1A1A1 as char), 4, 2, 0xC0)) A1A1A1A1 select hex(weight_string(cast(0xA1A1A1A1A1A1 as char), 5, 2, 0xC0)); hex(weight_string(cast(0xA1A1A1A1A1A1 as char), 5, 2, 0xC0)) A1A1A1A120 select hex(weight_string(cast(0xA1A1A1A1A1A1 as char),25, 2, 0xC0)); hex(weight_string(cast(0xA1A1A1A1A1A1 as char),25, 2, 0xC0)) A1A1A1A1202020202020202020202020202020202020202020 select hex(weight_string(cast(0xA1A1A1A1A1A1 as char), 1, 3, 0xC0)); hex(weight_string(cast(0xA1A1A1A1A1A1 as char), 1, 3, 0xC0)) A1 select hex(weight_string(cast(0xA1A1A1A1A1A1 as char), 2, 3, 0xC0)); hex(weight_string(cast(0xA1A1A1A1A1A1 as char), 2, 3, 0xC0)) A1A1 select hex(weight_string(cast(0xA1A1A1A1A1A1 as char), 3, 3, 0xC0)); hex(weight_string(cast(0xA1A1A1A1A1A1 as char), 3, 3, 0xC0)) A1A1A1 select hex(weight_string(cast(0xA1A1A1A1A1A1 as char), 4, 3, 0xC0)); hex(weight_string(cast(0xA1A1A1A1A1A1 as char), 4, 3, 0xC0)) A1A1A1A1 select hex(weight_string(cast(0xA1A1A1A1A1A1 as char), 5, 3, 0xC0)); hex(weight_string(cast(0xA1A1A1A1A1A1 as char), 5, 3, 0xC0)) A1A1A1A1A1 select hex(weight_string(cast(0xA1A1A1A1A1A1 as char),25, 3, 0xC0)); hex(weight_string(cast(0xA1A1A1A1A1A1 as char),25, 3, 0xC0)) A1A1A1A1A1A120202020202020202020202020202020202020 select hex(weight_string(cast(0xA1A1A1A1A1A1 as char), 1, 4, 0xC0)); hex(weight_string(cast(0xA1A1A1A1A1A1 as char), 1, 4, 0xC0)) A1 select hex(weight_string(cast(0xA1A1A1A1A1A1 as char), 2, 4, 0xC0)); hex(weight_string(cast(0xA1A1A1A1A1A1 as char), 2, 4, 0xC0)) A1A1 select hex(weight_string(cast(0xA1A1A1A1A1A1 as char), 3, 4, 0xC0)); hex(weight_string(cast(0xA1A1A1A1A1A1 as char), 3, 4, 0xC0)) A1A1A1 select hex(weight_string(cast(0xA1A1A1A1A1A1 as char), 4, 4, 0xC0)); hex(weight_string(cast(0xA1A1A1A1A1A1 as char), 4, 4, 0xC0)) A1A1A1A1 select hex(weight_string(cast(0xA1A1A1A1A1A1 as char), 5, 4, 0xC0)); hex(weight_string(cast(0xA1A1A1A1A1A1 as char), 5, 4, 0xC0)) A1A1A1A1A1 select hex(weight_string(cast(0xA1A1A1A1A1A1 as char),25, 4, 0xC0)); hex(weight_string(cast(0xA1A1A1A1A1A1 as char),25, 4, 0xC0)) A1A1A1A1A1A120202020202020202020202020202020202020 select collation(cast(0xA2A9 as char)); collation(cast(0xA2A9 as char)) gb18030_bin select hex(weight_string(cast(0x6141 as char))); hex(weight_string(cast(0x6141 as char))) 6141 select hex(weight_string(cast(0xA2A9 as char))); hex(weight_string(cast(0xA2A9 as char))) A2A9 select hex(weight_string(cast(0xA2A9 as char) as char(1))); hex(weight_string(cast(0xA2A9 as char) as char(1))) A2A9 select hex(weight_string(cast(0xA2A9A2A9 as char) as char(1))); hex(weight_string(cast(0xA2A9A2A9 as char) as char(1))) A2A9 select hex(weight_string(cast(0xA2A9 as char) as char(3))); hex(weight_string(cast(0xA2A9 as char) as char(3))) A2A92020 select hex(weight_string(cast(0xA2A9A2A9 as char) as char(3))); hex(weight_string(cast(0xA2A9A2A9 as char) as char(3))) A2A9A2A920 select hex(weight_string(cast(0x40A2A9 as char) as char(3))); hex(weight_string(cast(0x40A2A9 as char) as char(3))) 40A2A920 select hex(weight_string(cast(0x40A2A9A2A9 as char) as char(3))); hex(weight_string(cast(0x40A2A9A2A9 as char) as char(3))) 40A2A9A2A9 select hex(weight_string(cast(0x40A2A9A2A9A2A9 as char) as char(3))); hex(weight_string(cast(0x40A2A9A2A9A2A9 as char) as char(3))) 40A2A9A2A9 select hex(weight_string(cast(0x4040A2A9A2A9A2A9 as char) as char(3))); hex(weight_string(cast(0x4040A2A9A2A9A2A9 as char) as char(3))) 4040A2A9 select hex(weight_string(cast(0xA2A9A2A9A2A9 as char), 1, 2, 0xC0)); hex(weight_string(cast(0xA2A9A2A9A2A9 as char), 1, 2, 0xC0)) A2 select hex(weight_string(cast(0xA2A9A2A9A2A9 as char), 2, 2, 0xC0)); hex(weight_string(cast(0xA2A9A2A9A2A9 as char), 2, 2, 0xC0)) A2A9 select hex(weight_string(cast(0xA2A9A2A9A2A9 as char), 3, 2, 0xC0)); hex(weight_string(cast(0xA2A9A2A9A2A9 as char), 3, 2, 0xC0)) A2A9A2 select hex(weight_string(cast(0xA2A9A2A9A2A9 as char), 4, 2, 0xC0)); hex(weight_string(cast(0xA2A9A2A9A2A9 as char), 4, 2, 0xC0)) A2A9A2A9 select hex(weight_string(cast(0xA2A9A2A9A2A9 as char), 5, 2, 0xC0)); hex(weight_string(cast(0xA2A9A2A9A2A9 as char), 5, 2, 0xC0)) A2A9A2A920 select hex(weight_string(cast(0xA2A9A2A9A2A9 as char),25, 2, 0xC0)); hex(weight_string(cast(0xA2A9A2A9A2A9 as char),25, 2, 0xC0)) A2A9A2A9202020202020202020202020202020202020202020 select hex(weight_string(cast(0xA2A9A2A9A2A9 as char), 1, 3, 0xC0)); hex(weight_string(cast(0xA2A9A2A9A2A9 as char), 1, 3, 0xC0)) A2 select hex(weight_string(cast(0xA2A9A2A9A2A9 as char), 2, 3, 0xC0)); hex(weight_string(cast(0xA2A9A2A9A2A9 as char), 2, 3, 0xC0)) A2A9 select hex(weight_string(cast(0xA2A9A2A9A2A9 as char), 3, 3, 0xC0)); hex(weight_string(cast(0xA2A9A2A9A2A9 as char), 3, 3, 0xC0)) A2A9A2 select hex(weight_string(cast(0xA2A9A2A9A2A9 as char), 4, 3, 0xC0)); hex(weight_string(cast(0xA2A9A2A9A2A9 as char), 4, 3, 0xC0)) A2A9A2A9 select hex(weight_string(cast(0xA2A9A2A9A2A9 as char), 5, 3, 0xC0)); hex(weight_string(cast(0xA2A9A2A9A2A9 as char), 5, 3, 0xC0)) A2A9A2A9A2 select hex(weight_string(cast(0xA2A9A2A9A2A9 as char),25, 3, 0xC0)); hex(weight_string(cast(0xA2A9A2A9A2A9 as char),25, 3, 0xC0)) A2A9A2A9A2A920202020202020202020202020202020202020 select hex(weight_string(cast(0xA2A9A2A9A2A9 as char), 1, 4, 0xC0)); hex(weight_string(cast(0xA2A9A2A9A2A9 as char), 1, 4, 0xC0)) A2 select hex(weight_string(cast(0xA2A9A2A9A2A9 as char), 2, 4, 0xC0)); hex(weight_string(cast(0xA2A9A2A9A2A9 as char), 2, 4, 0xC0)) A2A9 select hex(weight_string(cast(0xA2A9A2A9A2A9 as char), 3, 4, 0xC0)); hex(weight_string(cast(0xA2A9A2A9A2A9 as char), 3, 4, 0xC0)) A2A9A2 select hex(weight_string(cast(0xA2A9A2A9A2A9 as char), 4, 4, 0xC0)); hex(weight_string(cast(0xA2A9A2A9A2A9 as char), 4, 4, 0xC0)) A2A9A2A9 select hex(weight_string(cast(0xA2A9A2A9A2A9 as char), 5, 4, 0xC0)); hex(weight_string(cast(0xA2A9A2A9A2A9 as char), 5, 4, 0xC0)) A2A9A2A9A2 select hex(weight_string(cast(0xA2A9A2A9A2A9 as char),25, 4, 0xC0)); hex(weight_string(cast(0xA2A9A2A9A2A9 as char),25, 4, 0xC0)) A2A9A2A9A2A920202020202020202020202020202020202020 SELECT collation(CAST(0x81309D30 AS CHAR)); collation(CAST(0x81309D30 AS CHAR)) gb18030_bin SELECT HEX(WEIGHT_STRING(CAST(0x6141 AS CHAR))); HEX(WEIGHT_STRING(CAST(0x6141 AS CHAR))) 6141 SELECT HEX(WEIGHT_STRING(CAST(0x81309D30 AS CHAR))); HEX(WEIGHT_STRING(CAST(0x81309D30 AS CHAR))) 81309D30 SELECT HEX(WEIGHT_STRING(CAST(0x81309D30 AS CHAR) AS CHAR(1))); HEX(WEIGHT_STRING(CAST(0x81309D30 AS CHAR) AS CHAR(1))) 81309D30 SELECT HEX(WEIGHT_STRING(CAST(0x81309D3081309D30 AS CHAR) AS CHAR(1))); HEX(WEIGHT_STRING(CAST(0x81309D3081309D30 AS CHAR) AS CHAR(1))) 81309D30 SELECT HEX(WEIGHT_STRING(CAST(0x81309D30 AS CHAR) AS CHAR(3))); HEX(WEIGHT_STRING(CAST(0x81309D30 AS CHAR) AS CHAR(3))) 81309D302020 SELECT HEX(WEIGHT_STRING(CAST(0x81309D3081309D30 AS CHAR) AS CHAR(3))); HEX(WEIGHT_STRING(CAST(0x81309D3081309D30 AS CHAR) AS CHAR(3))) 81309D3081309D3020 SELECT HEX(WEIGHT_STRING(CAST(0x4081309D30 AS CHAR) AS CHAR(3))); HEX(WEIGHT_STRING(CAST(0x4081309D30 AS CHAR) AS CHAR(3))) 4081309D3020 SELECT HEX(WEIGHT_STRING(CAST(0x4081309D3081309D30 AS CHAR) AS CHAR(3))); HEX(WEIGHT_STRING(CAST(0x4081309D3081309D30 AS CHAR) AS CHAR(3))) 4081309D3081309D30 SELECT HEX(WEIGHT_STRING(CAST(0x4081309D3081309D3081309D30 AS CHAR) AS CHAR(3))); HEX(WEIGHT_STRING(CAST(0x4081309D3081309D3081309D30 AS CHAR) AS CHAR(3))) 4081309D3081309D30 SELECT HEX(WEIGHT_STRING(CAST(0x404081309D3081309D3081309D30 AS CHAR) AS CHAR(3))); HEX(WEIGHT_STRING(CAST(0x404081309D3081309D3081309D30 AS CHAR) AS CHAR(3))) 404081309D30 SELECT HEX(WEIGHT_STRING(CAST(0x81309D3081309D3081309D30 AS CHAR), 1, 2, 0xC0)); HEX(WEIGHT_STRING(CAST(0x81309D3081309D3081309D30 AS CHAR), 1, 2, 0xC0)) 81 SELECT HEX(WEIGHT_STRING(CAST(0x81309D3081309D3081309D30 AS CHAR), 2, 2, 0xC0)); HEX(WEIGHT_STRING(CAST(0x81309D3081309D3081309D30 AS CHAR), 2, 2, 0xC0)) 8130 SELECT HEX(WEIGHT_STRING(CAST(0x81309D3081309D3081309D30 AS CHAR), 3, 2, 0xC0)); HEX(WEIGHT_STRING(CAST(0x81309D3081309D3081309D30 AS CHAR), 3, 2, 0xC0)) 81309D SELECT HEX(WEIGHT_STRING(CAST(0x81309D3081309D3081309D30 AS CHAR), 4, 2, 0xC0)); HEX(WEIGHT_STRING(CAST(0x81309D3081309D3081309D30 AS CHAR), 4, 2, 0xC0)) 81309D30 SELECT HEX(WEIGHT_STRING(CAST(0x81309D3081309D3081309D30 AS CHAR), 5, 2, 0xC0)); HEX(WEIGHT_STRING(CAST(0x81309D3081309D3081309D30 AS CHAR), 5, 2, 0xC0)) 81309D3081 SELECT HEX(WEIGHT_STRING(CAST(0x81309D3081309D3081309D30 AS CHAR), 25, 2, 0xC0)); HEX(WEIGHT_STRING(CAST(0x81309D3081309D3081309D30 AS CHAR), 25, 2, 0xC0)) 81309D3081309D302020202020202020202020202020202020 SELECT HEX(WEIGHT_STRING(CAST(0x81309D3081309D3081309D30 AS CHAR), 1, 3, 0xC0)); HEX(WEIGHT_STRING(CAST(0x81309D3081309D3081309D30 AS CHAR), 1, 3, 0xC0)) 81 SELECT HEX(WEIGHT_STRING(CAST(0x81309D3081309D3081309D30 AS CHAR), 2, 3, 0xC0)); HEX(WEIGHT_STRING(CAST(0x81309D3081309D3081309D30 AS CHAR), 2, 3, 0xC0)) 8130 SELECT HEX(WEIGHT_STRING(CAST(0x81309D3081309D3081309D30 AS CHAR), 3, 3, 0xC0)); HEX(WEIGHT_STRING(CAST(0x81309D3081309D3081309D30 AS CHAR), 3, 3, 0xC0)) 81309D SELECT HEX(WEIGHT_STRING(CAST(0x81309D3081309D3081309D30 AS CHAR), 4, 3, 0xC0)); HEX(WEIGHT_STRING(CAST(0x81309D3081309D3081309D30 AS CHAR), 4, 3, 0xC0)) 81309D30 SELECT HEX(WEIGHT_STRING(CAST(0x81309D3081309D3081309D30 AS CHAR), 5, 3, 0xC0)); HEX(WEIGHT_STRING(CAST(0x81309D3081309D3081309D30 AS CHAR), 5, 3, 0xC0)) 81309D3081 SELECT HEX(WEIGHT_STRING(CAST(0x81309D3081309D3081309D30 AS CHAR), 25, 3, 0xC0)); HEX(WEIGHT_STRING(CAST(0x81309D3081309D3081309D30 AS CHAR), 25, 3, 0xC0)) 81309D3081309D3081309D3020202020202020202020202020 SELECT HEX(WEIGHT_STRING(CAST(0x81309D3081309D3081309D30 AS CHAR), 1, 4, 0xC0)); HEX(WEIGHT_STRING(CAST(0x81309D3081309D3081309D30 AS CHAR), 1, 4, 0xC0)) 81 SELECT HEX(WEIGHT_STRING(CAST(0x81309D3081309D3081309D30 AS CHAR), 2, 4, 0xC0)); HEX(WEIGHT_STRING(CAST(0x81309D3081309D3081309D30 AS CHAR), 2, 4, 0xC0)) 8130 SELECT HEX(WEIGHT_STRING(CAST(0x81309D3081309D3081309D30 AS CHAR), 3, 4, 0xC0)); HEX(WEIGHT_STRING(CAST(0x81309D3081309D3081309D30 AS CHAR), 3, 4, 0xC0)) 81309D SELECT HEX(WEIGHT_STRING(CAST(0x81309D3081309D3081309D30 AS CHAR), 4, 4, 0xC0)); HEX(WEIGHT_STRING(CAST(0x81309D3081309D3081309D30 AS CHAR), 4, 4, 0xC0)) 81309D30 SELECT HEX(WEIGHT_STRING(CAST(0x81309D3081309D3081309D30 AS CHAR), 5, 4, 0xC0)); HEX(WEIGHT_STRING(CAST(0x81309D3081309D3081309D30 AS CHAR), 5, 4, 0xC0)) 81309D3081 SELECT HEX(WEIGHT_STRING(CAST(0x81309D3081309D3081309D30 AS CHAR), 25, 4, 0xC0)); HEX(WEIGHT_STRING(CAST(0x81309D3081309D3081309D30 AS CHAR), 25, 4, 0xC0)) 81309D3081309D3081309D3020202020202020202020202020 # # Bugs#12635232: VALGRIND WARNINGS: IS_IPV6, IS_IPV4, INET6_ATON, # INETTO_NTOA + MULTIBYTE CHARSET. # SET sql_mode = 'NO_ENGINE_SUBSTITUTION'; Warnings: Warning 3090 Changing sql mode 'NO_AUTO_CREATE_USER' is deprecated. It will be removed in a future release. SELECT is_ipv4(inet_ntoa('1')); is_ipv4(inet_ntoa('1')) 1 SELECT is_ipv6(inet_ntoa('1')); is_ipv6(inet_ntoa('1')) 0 SELECT inet6_aton(inet_ntoa('1')); inet6_aton(inet_ntoa('1')) SELECT inet6_ntoa(inet_ntoa('1')); inet6_ntoa(inet_ntoa('1')) NULL Warnings: Warning 1411 Incorrect string value: 'inet_ntoa('1')' for function inet6_ntoa # # Bug#14040277 UNINITIALIZED VALUE REFERENCED IN STR_TO_IPV6 # SELECT inet6_aton(soundex('a')); inet6_aton(soundex('a')) NULL Warnings: Warning 1411 Incorrect string value: 'soundex('a')' for function inet6_aton # # Bug#19047425 UNINITIALISED VALUE IN STR_TO_IPV6 # do is_ipv4_mapped(inet6_aton(convert(_ascii "a:" using utf8mb4))); Warnings: Warning 1411 Incorrect string value: 'convert(_ascii'a:' using utf8mb4)' for function inet6_aton # # Test for gb18030_unicode_520_ci collation. # SET NAMES utf8mb4; SET collation_connection=gb18030_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 gb18030 COLLATE gb18030_unicode_520_ci NOT NULL DEFAULT '' ) 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 8130A935 8138C739 8130A935 1214 Ⱥ 8138C739 8138C739 8130A935 1214 ⱥ 81309738 81309738 8130AA34 122D ƀ 8130AA34 81309738 8130AA34 122D Ƀ 8130A936 8130A937 8130A936 1242 Ȼ 8130A937 8130A937 8130A936 1242 ȼ 8136C539 8136C630 8136C539 124E Ↄ 8136C630 8136C630 8136C539 124E ↄ 8130AA37 8130AA38 8130AA37 1270 Ɇ 8130AA38 8130AA38 8130AA37 1270 ɇ 8136C030 8136C238 8136C030 12AE Ⅎ 8136C238 8136C238 8136C030 12AE ⅎ 8138C831 8138C832 8138C831 12E3 Ⱨ 8138C832 8138C832 8138C831 12E3 ⱨ 8138C935 8138C936 8138C935 12E4 Ⱶ 8138C936 8138C936 8138C935 12E4 ⱶ 8236D133 8236D134 8236D133 12E5 Ꜧ 8236D134 8236D134 8236D133 12E5 ꜧ 8130AA39 8130AB30 8130AA39 130E Ɉ 8130AB30 8130AB30 8130AA39 130E ɉ 8138C833 8138C834 8138C833 1328 Ⱪ 8138C834 8138C834 8138C833 1328 ⱪ 8130A938 81309A34 8130A938 133B Ƚ 8138C734 8138C735 8138C734 133F Ⱡ 8138C735 8138C735 8138C734 133F ⱡ 8130AE32 8130AE32 8138C736 1340 ɫ 8138C736 8130AE32 8138C736 1340 Ɫ 8135E133 8135E133 8138C737 13B8 ᵽ 8138C737 8135E133 8138C737 13B8 Ᵽ 8130AB31 8130AB32 8130AB31 13D2 Ɋ 8130AB32 8130AB32 8130AB31 13D2 ɋ 8130AB33 8130AB34 8130AB33 13E4 Ɍ 8130AB34 8130AB34 8130AB33 13E4 ɍ 8130B030 8130B030 8138C738 13FC ɽ 8138C738 8130B030 8138C738 13FC Ɽ 8236D135 8236D136 8236D135 143314AD Ꜩ 8236D136 8236D136 8236D135 143314AD ꜩ 8130A939 8138C830 8130A939 143C Ⱦ 8138C830 8138C830 8130A939 143C ⱦ 8130AA35 8130B132 8130AA35 145B Ʉ 8130B132 8130B132 8130AA35 145B ʉ 8130AA36 8130B135 8130AA36 1489 Ʌ 8130B135 8130B135 8130AA36 1489 ʌ 8130AB35 8130AB36 8130AB35 14A4 Ɏ 8130AB36 8130AB36 8130AB35 14A4 ɏ 8138C835 8138C836 8138C835 14C8 Ⱬ 8138C836 8138C836 8138C835 14C8 ⱬ 8236D137 8236D138 8236D137 14F3 Ꜫ 8236D138 8236D138 8236D137 14F3 ꜫ 8130AA32 8130AA33 8130AA32 1506 Ɂ 8130AA33 8130AA33 8130AA32 1506 ɂ 8236D039 8236D130 8236D039 150E Ꜣ 8236D130 8236D130 8236D039 150E ꜣ 8236D131 8236D132 8236D131 1518 Ꜥ 8236D132 8236D132 8236D131 1518 ꜥ 8130C738 8130C739 8130C738 154F Ͱ 8130C739 8130C739 8130C738 154F ͱ 8130C930 8130C930 8130D132 1564 ͼ 8130D132 8130C930 8130D132 1564 Ͼ 8130C839 8130C839 8130D131 1565 ͻ 8130D131 8130C839 8130D131 1565 Ͻ 8130C931 8130C931 8130D133 1566 ͽ 8130D133 8130C931 8130D133 1566 Ͽ 8130C830 8130C831 8130C830 156F Ͳ 8130C831 8130C831 8130C830 156F ͳ 8138CA36 8138CA37 8138CA36 1571 Ⲁ 8138CA37 8138CA37 8138CA36 1571 ⲁ 8138CA38 8138CA39 8138CA38 1572 Ⲃ 8138CA39 8138CA39 8138CA38 1572 ⲃ 8138CB30 8138CB31 8138CB30 1573 Ⲅ 8138CB31 8138CB31 8138CB30 1573 ⲅ 8138CB32 8138CB33 8138CB32 1574 Ⲇ 8138CB33 8138CB33 8138CB32 1574 ⲇ 8138CB34 8138CB35 8138CB34 1575 Ⲉ 8138CB35 8138CB35 8138CB34 1575 ⲉ 8138CB36 8138CB37 8138CB36 1577 Ⲋ 8138CB37 8138CB37 8138CB36 1577 ⲋ 8138CB38 8138CB39 8138CB38 1578 Ⲍ 8138CB39 8138CB39 8138CB38 1578 ⲍ 8138CC30 8138CC31 8138CC30 1579 Ⲏ 8138CC31 8138CC31 8138CC30 1579 ⲏ 8138D533 8138D534 8138D533 1591 Ⳬ 8138D534 8138D534 8138D533 1591 ⳬ 8138D535 8138D536 8138D535 15A0 Ⳮ 8138D536 8138D536 8138D535 15A0 ⳮ 8130E338 8130E339 8130E338 15D4 Ӻ 8130E339 8130E339 8130E338 15D4 ӻ 8130E334 8130E335 8130E334 15DC Ӷ 8130E335 8130E335 8130E334 15DC ӷ 8236BA33 8236BA34 8236BA33 1611 Ꙁ 8236BA34 8236BA34 8236BA33 1611 ꙁ 8130E630 8130E631 8130E630 1613 Ԑ 8130E631 8130E631 8130E630 1613 ԑ 8236BA35 8236BA36 8236BA35 1618 Ꙃ 8236BA36 8236BA36 8236BA35 1618 ꙃ 8130E632 8130E633 8130E632 1666 Ԓ 8130E633 8130E633 8130E632 1666 ԓ 8130E634 8130E635 8130E634 166E Ԕ 8130E635 8130E635 8130E634 166E ԕ 8130E636 8130E637 8130E636 16B7 Ԗ 8130E637 8130E637 8130E636 16B7 ԗ 8130E430 8130E431 8130E430 16F9 Ӽ 8130E431 8130E431 8130E430 16F9 ӽ 8130E432 8130E433 8130E432 16FD Ӿ 8130E433 8130E433 8130E432 16FD ӿ 8130DE30 8130DF35 8130DE30 17B1 Ӏ 8130DF35 8130DF35 8130DE30 17B1 ӏ 8138BD38 8138C236 8138BD38 17B5 Ⰰ 8138C236 8138C236 8138BD38 17B5 ⰰ 8138BD39 8138C237 8138BD39 17B6 Ⰱ 8138C237 8138C237 8138BD39 17B6 ⰱ 8138BE30 8138C238 8138BE30 17B7 Ⰲ 8138C238 8138C238 8138BE30 17B7 ⰲ 8138BE31 8138C239 8138BE31 17B8 Ⰳ 8138C239 8138C239 8138BE31 17B8 ⰳ 8138BE32 8138C330 8138BE32 17B9 Ⰴ 8138C330 8138C330 8138BE32 17B9 ⰴ 8138BE33 8138C331 8138BE33 17BA Ⰵ 8138C331 8138C331 8138BE33 17BA ⰵ 8138BE34 8138C332 8138BE34 17BB Ⰶ 8138C332 8138C332 8138BE34 17BB ⰶ 8138BE35 8138C333 8138BE35 17BC Ⰷ 8138C333 8138C333 8138BE35 17BC ⰷ 81339430 8138D734 81339430 17E5 Ⴀ 8138D734 8138D734 81339430 17E5 ⴀ 81339431 8138D735 81339431 17E7 Ⴁ 8138D735 8138D735 81339431 17E7 ⴁ 81339432 8138D736 81339432 17E9 Ⴂ 8138D736 8138D736 81339432 17E9 ⴂ 81339433 8138D737 81339433 17EB Ⴃ 8138D737 8138D737 81339433 17EB ⴃ 81339434 8138D738 81339434 17ED Ⴄ 8138D738 8138D738 81339434 17ED ⴄ 81339435 8138D739 81339435 17EF Ⴅ 8138D739 8138D739 81339435 17EF ⴅ 81339436 8138D830 81339436 17F1 Ⴆ 8138D830 8138D830 81339436 17F1 ⴆ 81339437 8138D831 81339437 17F5 Ⴇ 8138D831 8138D831 81339437 17F5 ⴇ 9030E734 8130D239 8130D134 30D2 𐐀 9030EB34 A7EA A7BA 30D2 𐐨 9030E735 A7D7 A7A7 30D3 𐐁 9030EB35 A7EB A7BB 30D3 𐐩 9030E736 8130D330 8130D135 30D4 𐐂 9030EB36 A7EC A7BC 30D4 𐐪 9030E737 8130D331 8130D136 30D5 𐐃 9030EB37 A7ED A7BD 30D5 𐐫 9030E738 8130D332 8130D137 30D6 𐐄 9030EB38 A7EE A7BE 30D6 𐐬 9030E739 8130D333 8130D138 30D7 𐐅 9030EB39 A7EF A7BF 30D7 𐐭 9030E830 8130D334 8130D139 30D8 𐐆 9030EC30 A7F0 A7C0 30D8 𐐮 9030E831 8130D335 8130D230 30D9 𐐇 9030EC31 A7F1 A7C1 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)) 61 120F 619030E734 120F30D2 618431A439 120FFBC1FFFF 61E3329A35 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 9030E734 30D2 𐐀 9030EB34 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 9030E734 30D2 𐐀 9030EB34 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 42 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)) 61 120F 619030E734 120F30D2 618431A439 120FFBC1FFFF 61E3329A35 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 9030E734 30D2 𐐀 9030EB34 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 9030E734 30D2 𐐀 9030EB34 30D2 𐐨 DROP TABLE t1; SET NAMES gb18030 COLLATE gb18030_unicode_520_ci; SELECT 1 gb18030_unicode_520_ci; gb18030_unicode_520_ci 1 CREATE DATABASE gb18030 CHARSET=GB18030; SET NAMES utf8mb4; SET collation_connection='gb18030_chinese_ci'; CREATE TABLE t1(C VARCHAR(100) CHARACTER SET gb18030, KEY(c(20))); INSERT INTO t1 VALUES(0xC4EEC5ABBDBFA1A4B3E0B1DABBB3B9C520A1A4CBD5B6ABC6C2); INSERT INTO t1 VALUES(0xB4F3BDADB6ABC8A5A3ACC0CBCCD4BEA1A1A2C7A7B9C5B7E7C1F7C8CBCEEFA1A3); INSERT INTO t1 VALUES(0xB9CAC0DDCEF7B1DFA3ACC8CBB5C0CAC7A1A2C8FDB9FAD6DCC0C9B3E0B1DAA1A3); INSERT INTO t1 VALUES(0xC2D2CAAFB1C0D4C6A3ACBEAACCCEC1D1B0B6A3ACBEEDC6F0C7A7B6D1D1A9A1A3); INSERT INTO t1 VALUES(0xBDADC9BDC8E7BBADA3ACD2BBCAB1B6E0C9D9BAC0BDDCA3A1); INSERT INTO t1 VALUES(0xD2A3CFEBB9ABE8AAB5B1C4EAA3ACD0A1C7C7B3F5BCDEC1CBA3ACD0DBD7CBD3A2B7A2A1A3); INSERT INTO t1 VALUES(0xD3F0C9C8C2DABDEDA3ACCCB8D0A6BCE4A1A2E9C9E9D6BBD2B7C9D1CCC3F0A1A3); INSERT INTO t1 VALUES(0xB9CAB9FAC9F1D3CEA3ACB6E0C7E9D3A6D0A6CED2A1A2D4E7C9FABBAAB7A2A1A3); INSERT INTO t1 VALUES(0xC8CBBCE4C8E7C3CEA3ACD2BBE9D7BBB9F5AABDADD4C2A1A3); SELECT c, HEX(c), CONVERT(c USING utf8mb4) FROM t1; c HEX(c) CONVERT(c USING utf8mb4) 念奴娇·赤壁怀古 ·苏东坡 C4EEC5ABBDBFA1A4B3E0B1DABBB3B9C520A1A4CBD5B6ABC6C2 念奴娇·赤壁怀古 ·苏东坡 大江东去,浪淘尽、千古风流人物。 B4F3BDADB6ABC8A5A3ACC0CBCCD4BEA1A1A2C7A7B9C5B7E7C1F7C8CBCEEFA1A3 大江东去,浪淘尽、千古风流人物。 故垒西边,人道是、三国周郎赤壁。 B9CAC0DDCEF7B1DFA3ACC8CBB5C0CAC7A1A2C8FDB9FAD6DCC0C9B3E0B1DAA1A3 故垒西边,人道是、三国周郎赤壁。 乱石崩云,惊涛裂岸,卷起千堆雪。 C2D2CAAFB1C0D4C6A3ACBEAACCCEC1D1B0B6A3ACBEEDC6F0C7A7B6D1D1A9A1A3 乱石崩云,惊涛裂岸,卷起千堆雪。 江山如画,一时多少豪杰! BDADC9BDC8E7BBADA3ACD2BBCAB1B6E0C9D9BAC0BDDCA3A1 江山如画,一时多少豪杰! 遥想公瑾当年,小乔初嫁了,雄姿英发。 D2A3CFEBB9ABE8AAB5B1C4EAA3ACD0A1C7C7B3F5BCDEC1CBA3ACD0DBD7CBD3A2B7A2A1A3 遥想公瑾当年,小乔初嫁了,雄姿英发。 羽扇纶巾,谈笑间、樯橹灰飞烟灭。 D3F0C9C8C2DABDEDA3ACCCB8D0A6BCE4A1A2E9C9E9D6BBD2B7C9D1CCC3F0A1A3 羽扇纶巾,谈笑间、樯橹灰飞烟灭。 故国神游,多情应笑我、早生华发。 B9CAB9FAC9F1D3CEA3ACB6E0C7E9D3A6D0A6CED2A1A2D4E7C9FABBAAB7A2A1A3 故国神游,多情应笑我、早生华发。 人间如梦,一樽还酹江月。 C8CBBCE4C8E7C3CEA3ACD2BBE9D7BBB9F5AABDADD4C2A1A3 人间如梦,一樽还酹江月。 SELECT HEX(c), CONVERT(c USING utf8mb4) FROM t1 ORDER BY c; HEX(c) CONVERT(c USING utf8mb4) B4F3BDADB6ABC8A5A3ACC0CBCCD4BEA1A1A2C7A7B9C5B7E7C1F7C8CBCEEFA1A3 大江东去,浪淘尽、千古风流人物。 B9CAB9FAC9F1D3CEA3ACB6E0C7E9D3A6D0A6CED2A1A2D4E7C9FABBAAB7A2A1A3 故国神游,多情应笑我、早生华发。 B9CAC0DDCEF7B1DFA3ACC8CBB5C0CAC7A1A2C8FDB9FAD6DCC0C9B3E0B1DAA1A3 故垒西边,人道是、三国周郎赤壁。 BDADC9BDC8E7BBADA3ACD2BBCAB1B6E0C9D9BAC0BDDCA3A1 江山如画,一时多少豪杰! C2D2CAAFB1C0D4C6A3ACBEAACCCEC1D1B0B6A3ACBEEDC6F0C7A7B6D1D1A9A1A3 乱石崩云,惊涛裂岸,卷起千堆雪。 C4EEC5ABBDBFA1A4B3E0B1DABBB3B9C520A1A4CBD5B6ABC6C2 念奴娇·赤壁怀古 ·苏东坡 C8CBBCE4C8E7C3CEA3ACD2BBE9D7BBB9F5AABDADD4C2A1A3 人间如梦,一樽还酹江月。 D2A3CFEBB9ABE8AAB5B1C4EAA3ACD0A1C7C7B3F5BCDEC1CBA3ACD0DBD7CBD3A2B7A2A1A3 遥想公瑾当年,小乔初嫁了,雄姿英发。 D3F0C9C8C2DABDEDA3ACCCB8D0A6BCE4A1A2E9C9E9D6BBD2B7C9D1CCC3F0A1A3 羽扇纶巾,谈笑间、樯橹灰飞烟灭。 SELECT HEX(c), CONVERT(c USING utf8mb4) FROM t1 WHERE c LIKE CONCAT('%', _gb18030 0xD2BB, '%'); HEX(c) CONVERT(c USING utf8mb4) BDADC9BDC8E7BBADA3ACD2BBCAB1B6E0C9D9BAC0BDDCA3A1 江山如画,一时多少豪杰! C8CBBCE4C8E7C3CEA3ACD2BBE9D7BBB9F5AABDADD4C2A1A3 人间如梦,一樽还酹江月。 SELECT HEX(c), CONVERT(c USING utf8mb4) FROM t1 WHERE c LIKE CONCAT('%', _gb18030 0xC8CB, '%'); HEX(c) CONVERT(c USING utf8mb4) B4F3BDADB6ABC8A5A3ACC0CBCCD4BEA1A1A2C7A7B9C5B7E7C1F7C8CBCEEFA1A3 大江东去,浪淘尽、千古风流人物。 B9CAC0DDCEF7B1DFA3ACC8CBB5C0CAC7A1A2C8FDB9FAD6DCC0C9B3E0B1DAA1A3 故垒西边,人道是、三国周郎赤壁。 C8CBBCE4C8E7C3CEA3ACD2BBE9D7BBB9F5AABDADD4C2A1A3 人间如梦,一樽还酹江月。 SELECT HEX(c), CONVERT(c USING utf8mb4) FROM t1 WHERE c > 0xD2A3; HEX(c) CONVERT(c USING utf8mb4) D2A3CFEBB9ABE8AAB5B1C4EAA3ACD0A1C7C7B3F5BCDEC1CBA3ACD0DBD7CBD3A2B7A2A1A3 遥想公瑾当年,小乔初嫁了,雄姿英发。 D3F0C9C8C2DABDEDA3ACCCB8D0A6BCE4A1A2E9C9E9D6BBD2B7C9D1CCC3F0A1A3 羽扇纶巾,谈笑间、樯橹灰飞烟灭。 TRUNCATE TABLE t1; INSERT INTO t1 VALUES(0x5373547483329330); INSERT INTO t1 VALUES(0x8239AB318239AB358239AF3583308132833087348335EB39); INSERT INTO t1 VALUES(0x97339631973396339733A6359831C0359831C536); INSERT INTO t1 VALUES(0x9835CF329835CE359835F336); INSERT INTO t1 VALUES(0x833988318339883283398539); INSERT INTO t1 VALUES(0x823398318233973582339A3882348A32); INSERT INTO t1 VALUES(0x8134D5318134D6328134D832); INSERT INTO t1 VALUES(0x4A7320204B82339A35646566); INSERT INTO t1 VALUES(0x8130883281308833); INSERT INTO t1 VALUES(0xE05FE06A777682339230); INSERT INTO t1 VALUES(0x814081418139FE30); INSERT INTO t1 VALUES(0x81308130FEFE); INSERT INTO t1 VALUES(0xE3329A35E3329A34); INSERT INTO t1 VALUES(0xFE39FE39FE38FE38); INSERT INTO t1 VALUES(0xFE39FE38A976); SELECT c, HEX(c), CONVERT(c USING utf8mb4) FROM t1; c HEX(c) CONVERT(c USING utf8mb4) SsTt숿 5373547483329330 SsTt숿 둬둰뒘략럳푼 8239AB318239AB358239AF3583308132833087348335EB39 둬둰뒘략럳푼 𦠟𦠡𦣃𩄧𩅚 97339631973396339733A6359831C0359831C536 𦠟𦠡𦣃𩄧𩅚 𪕪𪕣𪛖 9835CF329835CE359835F336 𪕪𪕣𪛖 833988318339883283398539 䑠䑚䑻䣈 823398318233973582339A3882348A32 䑠䑚䑻䣈 ᠗ᠢᠶ 8134D5318134D6328134D832 ᠗ᠢᠶ Js K䑸def 4A7320204B82339A35646566 Js K䑸def ÎÏ 8130883281308833 ÎÏ 郷鄇wv䐣 E05FE06A777682339230 郷鄇wv䐣 丂丄㒙 814081418139FE30 丂丄㒙 81308130FEFE E3329A35E3329A34 ?? FE39FE39FE38FE38 ?? ?﹙ FE39FE38A976 ?﹙ SELECT c, HEX(c), CONVERT(c USING utf8mb4) FROM t1 WHERE c LIKE CONCAT('%', _gb18030 0x9835CE35, '%'); c HEX(c) CONVERT(c USING utf8mb4) 𪕪𪕣𪛖 9835CF329835CE359835F336 𪕪𪕣𪛖 SELECT c, HEX(c), CONVERT(c USING utf8mb4) FROM t1 WHERE c = 0x8130883281308833; c HEX(c) CONVERT(c USING utf8mb4) ÎÏ 8130883281308833 ÎÏ SELECT c, HEX(c), CONVERT(c USING utf8mb4) FROM t1 WHERE c > 0xE040 AND c < 0x8239AB31; c HEX(c) CONVERT(c USING utf8mb4) SELECT c, HEX(c), CONVERT(c USING utf8mb4) FROM t1 ORDER BY c; c HEX(c) CONVERT(c USING utf8mb4) Js K䑸def 4A7320204B82339A35646566 Js K䑸def SsTt숿 5373547483329330 SsTt숿 81308130FEFE ÎÏ 8130883281308833 ÎÏ ᠗ᠢᠶ 8134D5318134D6328134D832 ᠗ᠢᠶ 둬둰뒘략럳푼 8239AB318239AB358239AF3583308132833087348335EB39 둬둰뒘략럳푼 833988318339883283398539 𪕪𪕣𪛖 9835CF329835CE359835F336 𪕪𪕣𪛖 E3329A35E3329A34 ?﹙ FE39FE38A976 ?﹙ 丂丄㒙 814081418139FE30 丂丄㒙 䑠䑚䑻䣈 823398318233973582339A3882348A32 䑠䑚䑻䣈 郷鄇wv䐣 E05FE06A777682339230 郷鄇wv䐣 𦠟𦠡𦣃𩄧𩅚 97339631973396339733A6359831C0359831C536 𦠟𦠡𦣃𩄧𩅚 ?? FE39FE39FE38FE38 ?? TRUNCATE TABLE t1; INSERT INTO t1 VALUES(0x8139818F); Warnings: Warning 1366 Incorrect string value: '\x819\x81\x8F' for column 'C' at row 1 INSERT INTO t1 VALUES(0x8431A530); INSERT INTO t1 VALUES(0x9030813089398130); INSERT INTO t1 VALUES(0xE3329A36); INSERT INTO t1 VALUES(0xA6A78586E3329A38); INSERT INTO t1 VALUES(0xA69C8041); Warnings: Warning 1366 Incorrect string value: '\x80A' for column 'C' at row 1 INSERT INTO t1 VALUES(0xA9C6FEFF); Warnings: Warning 1366 Incorrect string value: '\xFE\xFF' for column 'C' at row 1 INSERT INTO t1 VALUES(0xFFFF); Warnings: Warning 1366 Incorrect string value: '\xFF\xFF' for column 'C' at row 1 INSERT INTO t1 VALUES(0x81408139); Warnings: Warning 1366 Incorrect string value: '\x819' for column 'C' at row 1 INSERT INTO t1 VALUES(0x962B); Warnings: Warning 1366 Incorrect string value: '\x96+' for column 'C' at row 1 INSERT INTO t1 VALUES(0x9F37823881308156); Warnings: Warning 1366 Incorrect string value: '\x810\x81V' for column 'C' at row 1 INSERT INTO t1 VALUES(0xFE35FF30); Warnings: Warning 1366 Incorrect string value: '\xFE5\xFF0' for column 'C' at row 1 INSERT INTO t1 VALUES(0x814281309CA4); Warnings: Warning 1366 Incorrect string value: '\x810\x9C\xA4' for column 'C' at row 1 INSERT INTO t1 VALUES(0xE3329A36); INSERT INTO t1 VALUES(0xFE39FE39FE39FE38); SELECT * FROM t1; C ? 𐀀? ? Η厗? ┢ 丂 丅 ? ?? UPDATE t1 SET c=0x81308130; SELECT COUNT(*) FROM t1 WHERE c <> 0x81308130; COUNT(*) 0 TRUNCATE TABLE t1; INSERT INTO t1 VALUES(_gb18030 0x9534A337), (_gb18030 0x8959), (_gb18030 0xB0F9), (_gb18030 0xB0F4), (_gb18030 0x95348B39), (_gb18030 0x9794), (_gb18030 0x8231AC35); INSERT INTO t1 VALUES(_gb18030 0xB0F8), (_gb18030 0xAB67), (_gb18030 0x8232B632), (_gb18030 0x9630ED37), (_gb18030 0x9539F933), (_gb18030 0xB0F6), (_gb18030 0x8233B931); INSERT INTO t1 VALUES(_gb18030 0xD143), (_gb18030 0xB2A4), (_gb18030 0xC08F), (_gb18030 0xBC9E), (_gb18030 0xB2A6), (_gb18030 0xB2A8), (_gb18030 0xB069); INSERT INTO t1 VALUES(_gb18030 0x9833A533), (_gb18030 0xE2C4), (_gb18030 0xB2A7), (_gb18030 0x97368632), (_gb18030 0xB2A3), (_gb18030 0x8483), (_gb18030 0xB0FE); INSERT INTO t1 VALUES(_gb18030 0x865C), (_gb18030 0xD093), (_gb18030 0xB36A), (_gb18030 0xB143); SELECT c, HEX(c) FROM t1 ORDER BY c; c HEX(c) 𠬣 9534A337 𠨵 95348B39 㭋 8231AC35 玤 AB67 䂜 8232B632 蚌 B0F6 𢜗 9539F933 𢮏 9630ED37 䖫 8233B931 傍 B0F8 棒 B0F4 棓 9794 谤 B0F9 塝 8959 拨 B2A6 波 B2A8 癷 B069 𩧯 9833A533 玻 B2A3 剝 8483 剥 B0FE 哱 865C 盋 B143 砵 B36A 袚 D093 𧙄 97368632 钵 B2A7 饽 E2C4 紴 BC9E 缽 C08F 菠 B2A4 袰 D143 SELECT c, HEX(c) FROM t1 WHERE c >= 0x8483 and c < 0xE2C4 ORDER BY c; c HEX(c) 剝 8483 剥 B0FE 哱 865C 盋 B143 砵 B36A 袚 D093 𧙄 97368632 钵 B2A7 SELECT c, HEX(c) FROM t1 WHERE c LIKE 0xB0FE; c HEX(c) 剥 B0FE TRUNCATE TABLE t1; INSERT INTO t1 VALUES(_gb18030 0x81308130), (_gb18030 0x81308132); INSERT INTO t1 VALUES('A'), ('a'), ('1'), ('2'); INSERT INTO t1 VALUES(_gb18030 0xCDF5), (_gb18030 0xC0EE), (_gb18030 0xD5C5), (_gb18030 0xC1F5), (_gb18030 0xB3C2), (_gb18030 0xD1EE), (_gb18030 0xBBC6); INSERT INTO t1 VALUES(_gb18030 0xCEE2), (_gb18030 0xD5D4), (_gb18030 0xD6DC), (_gb18030 0xD0EC), (_gb18030 0xCBEF), (_gb18030 0xC2ED), (_gb18030 0xD6EC); INSERT INTO t1 VALUES(_gb18030 0xBAFA), (_gb18030 0xC1D6), (_gb18030 0xB9F9), (_gb18030 0xBACE), (_gb18030 0xB8DF), (_gb18030 0xC2DE), (_gb18030 0xD6A3); INSERT INTO t1 VALUES(_gb18030 0xE3329A35), (_gb18030 0xE3329A34); SELECT c, HEX(c) FROM t1 ORDER BY c; c HEX(c) 1 31 2 32 A 41 a 61 81308130 81308132 E3329A34 E3329A35 陈 B3C2 高 B8DF 郭 B9F9 何 BACE 胡 BAFA 黄 BBC6 李 C0EE 林 C1D6 刘 C1F5 罗 C2DE 马 C2ED 孙 CBEF 王 CDF5 吴 CEE2 徐 D0EC 杨 D1EE 张 D5C5 赵 D5D4 郑 D6A3 周 D6DC 朱 D6EC DROP TABLE t1; CREATE TABLE t1 (c CHAR(1) CHARACTER SET gb18030, v VARCHAR(100) CHARACTER SET gb18030); INSERT INTO t1 VALUES(0x8140, 0x81308132A6C9A6A985328338); SELECT HEX(c), c, HEX(v), v FROM t1; HEX(c) c HEX(v) v 8140 丂 81308132A6C9A6A985328338 ιΙ? ALTER TABLE t1 ADD COLUMN t TEXT CHARACTER SET gb18030; INSERT INTO t1 VALUES(0xBC81, 0x82358132FE39FE3940414281308135, 0x84678578); SELECT HEX(c), c, HEX(v), v, HEX(t), t FROM t1; HEX(c) c HEX(v) v HEX(t) t 8140 丂 81308132A6C9A6A985328338 ιΙ? NULL NULL BC81 紒 82358132FE39FE3940414281308135 䵲?@AB 84678578 刧厁 DROP TABLE t1; CREATE TABLE t1 (c VARCHAR(10) CHARACTER SET gb18030); INSERT INTO t1 VALUES(0x81308A3181308A3181308A3181308A3181308732); INSERT INTO t1 VALUES(0x81308A3181308A318130873281308A31); INSERT INTO t1 VALUES(0x81308A318130873281309636); INSERT INTO t1 VALUES(0x81308A318130873281309637); INSERT INTO t1 VALUES(0x81308A31813087328130963781309636); INSERT INTO t1 VALUES(0x8130963681308A31); INSERT INTO t1 VALUES(0xA8A581308D35); INSERT INTO t1 VALUES(0x81308D35A8A5); INSERT INTO t1 VALUES(0x81308D35A8A5A8A5); SELECT HEX(c) FROM t1; HEX(c) 81308A3181308A3181308A3181308A3181308732 81308A3181308A318130873281308A31 81308A318130873281309636 81308A318130873281309637 81308A31813087328130963781309636 8130963681308A31 A8A581308D35 81308D35A8A5 81308D35A8A5A8A5 SELECT HEX(c) FROM t1 WHERE c LIKE CONCAT('%', _gb18030 0x81308A31); HEX(c) 81308A3181308A3181308A3181308A3181308732 81308A3181308A318130873281308A31 8130963681308A31 SELECT HEX(c) FROM t1 WHERE c LIKE CONCAT('%', _gb18030 0x8130873281308A31, '%'); HEX(c) 81308A3181308A3181308A3181308A3181308732 81308A3181308A318130873281308A31 81308A318130873281309636 81308A318130873281309637 81308A31813087328130963781309636 SELECT HEX(c) FROM t1 WHERE c LIKE CONCAT('%', _gb18030 0x8130873281309636); HEX(c) 81308A318130873281309636 81308A318130873281309637 SELECT HEX(c) FROM t1 WHERE c LIKE CONCAT('%', _gb18030 0x8130963781309636); HEX(c) 81308A31813087328130963781309636 SELECT HEX(c) FROM t1 WHERE c LIKE CONCAT(_gb18030 0x81309636, '%'); HEX(c) 8130963681308A31 SELECT HEX(c) FROM t1 WHERE c LIKE CONCAT('%', _gb18030 0x8130963781309636); HEX(c) 81308A31813087328130963781309636 SELECT HEX(c) FROM t1 WHERE c LIKE CONCAT('%', _gb18030 0x8130963781309636) ESCAPE _gb18030 0x81309637; HEX(c) 81308A318130873281309636 81308A318130873281309637 81308A31813087328130963781309636 SELECT HEX(c) FROM t1 WHERE c LIKE CONCAT(_gb18030 0xA8A5, '%'); HEX(c) A8A581308D35 81308D35A8A5 81308D35A8A5A8A5 SELECT HEX(c) FROM t1 WHERE c LIKE CONCAT(_gb18030 0xA8A5, '_'); HEX(c) A8A581308D35 81308D35A8A5 SELECT HEX(c) FROM t1 WHERE c LIKE CONCAT(_gb18030 0xA8A5, '_', _gb18030 0x81308D35); HEX(c) 81308D35A8A5A8A5 SELECT HEX(c) FROM t1 WHERE c LIKE CONCAT('%_', _gb18030 0xA8A5); HEX(c) A8A581308D35 81308D35A8A5 81308D35A8A5A8A5 DROP TABLE t1; SET NAMES utf8mb4; CREATE TABLE t1 (c VARCHAR(10) CHARACTER SET gb18030); INSERT INTO t1 VALUES (_gb18030 0x8BF5819AEDC3), (_gb18030 0x99CC), (_gb18030 0x90459958), (_gb18030 0xAA95C0E59E509AED), (_gb18030 0xCCE7), (_gb18030 0x9068), (_gb18030 0x90459958); SELECT ANY_VALUE(HEX(c)), COUNT(c) FROM t1 GROUP BY c COLLATE gb18030_chinese_ci; ANY_VALUE(HEX(c)) COUNT(c) 90459958 2 9068 1 AA95C0E59E509AED 1 CCE7 1 99CC 1 8BF5819AEDC3 1 DROP TABLE t1; CREATE TABLE t1 (a int) ENGINE=InnoDB; LOAD DATA INFILE '../../std_data/bug21542698.dat' INTO TABLE t1 CHARACTER SET gb18030; ERROR HY000: Invalid gb18030 character string: 'MZ' DROP TABLE t1; DROP DATABASE gb18030; SET sql_mode = default; # # End of 5.7 tests #
Close