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.217.52.224
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_gbk.result
drop table if exists t1; SET @test_character_set= 'gbk'; SET @test_collation= 'gbk_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) gbk_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) gbk_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=gbk 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 gbk; SET collation_connection='gbk_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) gbk_chinese_ci 6109 gbk_chinese_ci 61 gbk_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) gbk_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 gbk_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,7E Zz 5A,7A ] 5D [ 5B \ 5C ^ 5E _ 5F ` 60 { 7B | 7C } 7D 7F drop table t1; SET collation_connection='gbk_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) gbk_bin 6109 gbk_bin 61 gbk_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) gbk_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 gbk_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; SET NAMES gbk; CREATE TABLE t1 (a text) character set gbk; INSERT INTO t1 VALUES (0xA3A0),(0xA1A1); SELECT hex(a) FROM t1 ORDER BY a; hex(a) A1A1 A3A0 DROP TABLE t1; select hex(convert(_gbk 0xA14041 using ucs2)); hex(convert(_gbk 0xA14041 using ucs2)) 003F0041 create table t1 (c1 text not null, c2 text not null) character set gbk; alter table t1 change c1 c1 mediumtext character set gbk 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=gbk drop table t1; CREATE TABLE t1(a MEDIUMTEXT CHARACTER SET gbk, 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; End of 5.0 tests # # Start of 5.5 tests # # # Testing WL#4583 Case conversion in Asian character sets # SET NAMES utf8; SET collation_connection=gbk_chinese_ci; CREATE TABLE t1 (b VARCHAR(2)); INSERT INTO t1 VALUES ('0'),('1'),('2'),('3'),('4'),('5'),('6'),('7'); INSERT INTO t1 VALUES ('8'),('9'),('A'),('B'),('C'),('D'),('E'),('F'); CREATE TEMPORARY TABLE head AS SELECT concat(b1.b, b2.b) AS head FROM t1 b1, t1 b2; CREATE TEMPORARY TABLE tail AS SELECT concat(b1.b, b2.b) AS tail FROM t1 b1, t1 b2; DROP TABLE t1; CREATE TABLE t1 AS SELECT concat(head, tail) AS code, ' ' AS a FROM head, tail WHERE (head BETWEEN '80' AND 'FF') AND (tail BETWEEN '20' AND 'FF') ORDER BY head, tail; DROP TEMPORARY TABLE head, tail; SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( `code` varchar(8) DEFAULT NULL, `a` varchar(1) CHARACTER SET gbk NOT NULL DEFAULT '' ) ENGINE=default_engine DEFAULT CHARSET=latin1 UPDATE IGNORE t1 SET a=unhex(code) ORDER BY code; Warnings: Warning 1366 Incorrect string value: '\x80 ' for column 'a' at row 1 Warning 1366 Incorrect string value: '\x80!' for column 'a' at row 2 Warning 1366 Incorrect string value: '\x80"' for column 'a' at row 3 Warning 1366 Incorrect string value: '\x80#' for column 'a' at row 4 Warning 1366 Incorrect string value: '\x80$' for column 'a' at row 5 Warning 1366 Incorrect string value: '\x80%' for column 'a' at row 6 Warning 1366 Incorrect string value: '\x80&' for column 'a' at row 7 Warning 1366 Incorrect string value: '\x80'' for column 'a' at row 8 Warning 1366 Incorrect string value: '\x80(' for column 'a' at row 9 Warning 1366 Incorrect string value: '\x80)' for column 'a' at row 10 Warning 1366 Incorrect string value: '\x80*' for column 'a' at row 11 Warning 1366 Incorrect string value: '\x80+' for column 'a' at row 12 Warning 1366 Incorrect string value: '\x80,' for column 'a' at row 13 Warning 1366 Incorrect string value: '\x80-' for column 'a' at row 14 Warning 1366 Incorrect string value: '\x80.' for column 'a' at row 15 Warning 1366 Incorrect string value: '\x80/' for column 'a' at row 16 Warning 1366 Incorrect string value: '\x800' for column 'a' at row 17 Warning 1366 Incorrect string value: '\x801' for column 'a' at row 18 Warning 1366 Incorrect string value: '\x802' for column 'a' at row 19 Warning 1366 Incorrect string value: '\x803' for column 'a' at row 20 Warning 1366 Incorrect string value: '\x804' for column 'a' at row 21 Warning 1366 Incorrect string value: '\x805' for column 'a' at row 22 Warning 1366 Incorrect string value: '\x806' for column 'a' at row 23 Warning 1366 Incorrect string value: '\x807' for column 'a' at row 24 Warning 1366 Incorrect string value: '\x808' for column 'a' at row 25 Warning 1366 Incorrect string value: '\x809' for column 'a' at row 26 Warning 1366 Incorrect string value: '\x80:' for column 'a' at row 27 Warning 1366 Incorrect string value: '\x80;' for column 'a' at row 28 Warning 1366 Incorrect string value: '\x80<' for column 'a' at row 29 Warning 1366 Incorrect string value: '\x80=' for column 'a' at row 30 Warning 1366 Incorrect string value: '\x80>' for column 'a' at row 31 Warning 1366 Incorrect string value: '\x80?' for column 'a' at row 32 Warning 1366 Incorrect string value: '\x80@' for column 'a' at row 33 Warning 1366 Incorrect string value: '\x80A' for column 'a' at row 34 Warning 1366 Incorrect string value: '\x80B' for column 'a' at row 35 Warning 1366 Incorrect string value: '\x80C' for column 'a' at row 36 Warning 1366 Incorrect string value: '\x80D' for column 'a' at row 37 Warning 1366 Incorrect string value: '\x80E' for column 'a' at row 38 Warning 1366 Incorrect string value: '\x80F' for column 'a' at row 39 Warning 1366 Incorrect string value: '\x80G' for column 'a' at row 40 Warning 1366 Incorrect string value: '\x80H' for column 'a' at row 41 Warning 1366 Incorrect string value: '\x80I' for column 'a' at row 42 Warning 1366 Incorrect string value: '\x80J' for column 'a' at row 43 Warning 1366 Incorrect string value: '\x80K' for column 'a' at row 44 Warning 1366 Incorrect string value: '\x80L' for column 'a' at row 45 Warning 1366 Incorrect string value: '\x80M' for column 'a' at row 46 Warning 1366 Incorrect string value: '\x80N' for column 'a' at row 47 Warning 1366 Incorrect string value: '\x80O' for column 'a' at row 48 Warning 1366 Incorrect string value: '\x80P' for column 'a' at row 49 Warning 1366 Incorrect string value: '\x80Q' for column 'a' at row 50 Warning 1366 Incorrect string value: '\x80R' for column 'a' at row 51 Warning 1366 Incorrect string value: '\x80S' for column 'a' at row 52 Warning 1366 Incorrect string value: '\x80T' for column 'a' at row 53 Warning 1366 Incorrect string value: '\x80U' for column 'a' at row 54 Warning 1366 Incorrect string value: '\x80V' for column 'a' at row 55 Warning 1366 Incorrect string value: '\x80W' for column 'a' at row 56 Warning 1366 Incorrect string value: '\x80X' for column 'a' at row 57 Warning 1366 Incorrect string value: '\x80Y' for column 'a' at row 58 Warning 1366 Incorrect string value: '\x80Z' for column 'a' at row 59 Warning 1366 Incorrect string value: '\x80[' for column 'a' at row 60 Warning 1366 Incorrect string value: '\x80\' for column 'a' at row 61 Warning 1366 Incorrect string value: '\x80]' for column 'a' at row 62 Warning 1366 Incorrect string value: '\x80^' for column 'a' at row 63 Warning 1366 Incorrect string value: '\x80_' for column 'a' at row 64 SELECT COUNT(*) FROM t1 WHERE a<>''; COUNT(*) 23940 SELECT code, hex(upper(a)), hex(lower(a)),a, upper(a), lower(a) FROM t1 WHERE hex(a)<>hex(upper(a)) OR hex(a)<>hex(lower(a)); code hex(upper(a)) hex(lower(a)) a upper(a) lower(a) A2A1 A2F1 A2A1 ⅰ Ⅰ ⅰ A2A2 A2F2 A2A2 ⅱ Ⅱ ⅱ A2A3 A2F3 A2A3 ⅲ Ⅲ ⅲ A2A4 A2F4 A2A4 ⅳ Ⅳ ⅳ A2A5 A2F5 A2A5 ⅴ Ⅴ ⅴ A2A6 A2F6 A2A6 ⅵ Ⅵ ⅵ A2A7 A2F7 A2A7 ⅶ Ⅶ ⅶ A2A8 A2F8 A2A8 ⅷ Ⅷ ⅷ A2A9 A2F9 A2A9 ⅸ Ⅸ ⅸ A2AA A2FA A2AA ⅹ Ⅹ ⅹ A2F1 A2F1 A2A1 Ⅰ Ⅰ ⅰ A2F2 A2F2 A2A2 Ⅱ Ⅱ ⅱ A2F3 A2F3 A2A3 Ⅲ Ⅲ ⅲ A2F4 A2F4 A2A4 Ⅳ Ⅳ ⅳ A2F5 A2F5 A2A5 Ⅴ Ⅴ ⅴ A2F6 A2F6 A2A6 Ⅵ Ⅵ ⅵ A2F7 A2F7 A2A7 Ⅶ Ⅶ ⅶ A2F8 A2F8 A2A8 Ⅷ Ⅷ ⅷ A2F9 A2F9 A2A9 Ⅸ Ⅸ ⅸ A2FA A2FA A2AA Ⅹ Ⅹ ⅹ A3C1 A3C1 A3E1 A A a A3C2 A3C2 A3E2 B B b A3C3 A3C3 A3E3 C C c A3C4 A3C4 A3E4 D D d A3C5 A3C5 A3E5 E E e A3C6 A3C6 A3E6 F F f A3C7 A3C7 A3E7 G G g A3C8 A3C8 A3E8 H H h A3C9 A3C9 A3E9 I I i A3CA A3CA A3EA J J j A3CB A3CB A3EB K K k A3CC A3CC A3EC L L l A3CD A3CD A3ED M M m A3CE A3CE A3EE N N n A3CF A3CF A3EF O O o A3D0 A3D0 A3F0 P P p A3D1 A3D1 A3F1 Q Q q A3D2 A3D2 A3F2 R R r A3D3 A3D3 A3F3 S S s A3D4 A3D4 A3F4 T T t A3D5 A3D5 A3F5 U U u A3D6 A3D6 A3F6 V V v A3D7 A3D7 A3F7 W W w A3D8 A3D8 A3F8 X X x A3D9 A3D9 A3F9 Y Y y A3DA A3DA A3FA Z Z z A3E1 A3C1 A3E1 a A a A3E2 A3C2 A3E2 b B b A3E3 A3C3 A3E3 c C c A3E4 A3C4 A3E4 d D d A3E5 A3C5 A3E5 e E e A3E6 A3C6 A3E6 f F f A3E7 A3C7 A3E7 g G g A3E8 A3C8 A3E8 h H h A3E9 A3C9 A3E9 i I i A3EA A3CA A3EA j J j A3EB A3CB A3EB k K k A3EC A3CC A3EC l L l A3ED A3CD A3ED m M m A3EE A3CE A3EE n N n A3EF A3CF A3EF o O o A3F0 A3D0 A3F0 p P p A3F1 A3D1 A3F1 q Q q A3F2 A3D2 A3F2 r R r A3F3 A3D3 A3F3 s S s A3F4 A3D4 A3F4 t T t A3F5 A3D5 A3F5 u U u A3F6 A3D6 A3F6 v V v A3F7 A3D7 A3F7 w W w A3F8 A3D8 A3F8 x X x A3F9 A3D9 A3F9 y Y y A3FA A3DA A3FA z Z z A6A1 A6A1 A6C1 Α Α α A6A2 A6A2 A6C2 Β Β β A6A3 A6A3 A6C3 Γ Γ γ A6A4 A6A4 A6C4 Δ Δ δ A6A5 A6A5 A6C5 Ε Ε ε A6A6 A6A6 A6C6 Ζ Ζ ζ A6A7 A6A7 A6C7 Η Η η A6A8 A6A8 A6C8 Θ Θ θ A6A9 A6A9 A6C9 Ι Ι ι A6AA A6AA A6CA Κ Κ κ A6AB A6AB A6CB Λ Λ λ A6AC A6AC A6CC Μ Μ μ A6AD A6AD A6CD Ν Ν ν A6AE A6AE A6CE Ξ Ξ ξ A6AF A6AF A6CF Ο Ο ο A6B0 A6B0 A6D0 Π Π π A6B1 A6B1 A6D1 Ρ Ρ ρ A6B2 A6B2 A6D2 Σ Σ σ A6B3 A6B3 A6D3 Τ Τ τ A6B4 A6B4 A6D4 Υ Υ υ A6B5 A6B5 A6D5 Φ Φ φ A6B6 A6B6 A6D6 Χ Χ χ A6B7 A6B7 A6D7 Ψ Ψ ψ A6B8 A6B8 A6D8 Ω Ω ω A6C1 A6A1 A6C1 α Α α A6C2 A6A2 A6C2 β Β β A6C3 A6A3 A6C3 γ Γ γ A6C4 A6A4 A6C4 δ Δ δ A6C5 A6A5 A6C5 ε Ε ε A6C6 A6A6 A6C6 ζ Ζ ζ A6C7 A6A7 A6C7 η Η η A6C8 A6A8 A6C8 θ Θ θ A6C9 A6A9 A6C9 ι Ι ι A6CA A6AA A6CA κ Κ κ A6CB A6AB A6CB λ Λ λ A6CC A6AC A6CC μ Μ μ A6CD A6AD A6CD ν Ν ν A6CE A6AE A6CE ξ Ξ ξ A6CF A6AF A6CF ο Ο ο A6D0 A6B0 A6D0 π Π π A6D1 A6B1 A6D1 ρ Ρ ρ A6D2 A6B2 A6D2 σ Σ σ A6D3 A6B3 A6D3 τ Τ τ A6D4 A6B4 A6D4 υ Υ υ A6D5 A6B5 A6D5 φ Φ φ A6D6 A6B6 A6D6 χ Χ χ A6D7 A6B7 A6D7 ψ Ψ ψ A6D8 A6B8 A6D8 ω Ω ω A7A1 A7A1 A7D1 А А а A7A2 A7A2 A7D2 Б Б б A7A3 A7A3 A7D3 В В в A7A4 A7A4 A7D4 Г Г г A7A5 A7A5 A7D5 Д Д д A7A6 A7A6 A7D6 Е Е е A7A7 A7A7 A7D7 Ё Ё ё A7A8 A7A8 A7D8 Ж Ж ж A7A9 A7A9 A7D9 З З з A7AA A7AA A7DA И И и A7AB A7AB A7DB Й Й й A7AC A7AC A7DC К К к A7AD A7AD A7DD Л Л л A7AE A7AE A7DE М М м A7AF A7AF A7DF Н Н н A7B0 A7B0 A7E0 О О о A7B1 A7B1 A7E1 П П п A7B2 A7B2 A7E2 Р Р р A7B3 A7B3 A7E3 С С с A7B4 A7B4 A7E4 Т Т т A7B5 A7B5 A7E5 У У у A7B6 A7B6 A7E6 Ф Ф ф A7B7 A7B7 A7E7 Х Х х A7B8 A7B8 A7E8 Ц Ц ц A7B9 A7B9 A7E9 Ч Ч ч A7BA A7BA A7EA Ш Ш ш A7BB A7BB A7EB Щ Щ щ A7BC A7BC A7EC Ъ Ъ ъ A7BD A7BD A7ED Ы Ы ы A7BE A7BE A7EE Ь Ь ь A7BF A7BF A7EF Э Э э A7C0 A7C0 A7F0 Ю Ю ю A7C1 A7C1 A7F1 Я Я я A7D1 A7A1 A7D1 а А а A7D2 A7A2 A7D2 б Б б A7D3 A7A3 A7D3 в В в A7D4 A7A4 A7D4 г Г г A7D5 A7A5 A7D5 д Д д A7D6 A7A6 A7D6 е Е е A7D7 A7A7 A7D7 ё Ё ё A7D8 A7A8 A7D8 ж Ж ж A7D9 A7A9 A7D9 з З з A7DA A7AA A7DA и И и A7DB A7AB A7DB й Й й A7DC A7AC A7DC к К к A7DD A7AD A7DD л Л л A7DE A7AE A7DE м М м A7DF A7AF A7DF н Н н A7E0 A7B0 A7E0 о О о A7E1 A7B1 A7E1 п П п A7E2 A7B2 A7E2 р Р р A7E3 A7B3 A7E3 с С с A7E4 A7B4 A7E4 т Т т A7E5 A7B5 A7E5 у У у A7E6 A7B6 A7E6 ф Ф ф A7E7 A7B7 A7E7 х Х х A7E8 A7B8 A7E8 ц Ц ц A7E9 A7B9 A7E9 ч Ч ч A7EA A7BA A7EA ш Ш ш A7EB A7BB A7EB щ Щ щ A7EC A7BC A7EC ъ Ъ ъ A7ED A7BD A7ED ы Ы ы A7EE A7BE A7EE ь Ь ь A7EF A7BF A7EF э Э э A7F0 A7C0 A7F0 ю Ю ю A7F1 A7C1 A7F1 я Я я SELECT * FROM t1 WHERE HEX(CAST(LOWER(a) AS CHAR CHARACTER SET utf8)) <> HEX(LOWER(CAST(a AS CHAR CHARACTER SET utf8))) ORDER BY code; code a A2FB Ⅺ A2FC Ⅻ SELECT * FROM t1 WHERE HEX(CAST(UPPER(a) AS CHAR CHARACTER SET utf8)) <> HEX(UPPER(CAST(a AS CHAR CHARACTER SET utf8))) ORDER BY code; code a A8A1 ā A8A2 á A8A3 ǎ A8A4 à A8A5 ē A8A6 é A8A7 ě A8A8 è A8A9 ī A8AA í A8AB ǐ A8AC ì A8AD ō A8AE ó A8AF ǒ A8B0 ò A8B1 ū A8B2 ú A8B3 ǔ A8B4 ù A8B5 ǖ A8B6 ǘ A8B7 ǚ A8B8 ǜ A8B9 ü A8BA ê A8BD ń A8BE ň DROP TABLE t1; # # End of 5.5 tests # # # Start of 5.6 tests # # # WL#3664 WEIGHT_STRING # set names gbk; select @@collation_connection; @@collation_connection gbk_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 gbk_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)) gbk_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))) 810B select hex(weight_string(cast(0xA1A1 as char) as char(1))); hex(weight_string(cast(0xA1A1 as char) as char(1))) 810B select hex(weight_string(cast(0xA1A1A1A1 as char) as char(1))); hex(weight_string(cast(0xA1A1A1A1 as char) as char(1))) 810B select hex(weight_string(cast(0xA1A1 as char) as char(3))); hex(weight_string(cast(0xA1A1 as char) as char(3))) 810B2020 select hex(weight_string(cast(0xA1A1A1A1 as char) as char(3))); hex(weight_string(cast(0xA1A1A1A1 as char) as char(3))) 810B810B20 select hex(weight_string(cast(0x40A1A1 as char) as char(3))); hex(weight_string(cast(0x40A1A1 as char) as char(3))) 40810B20 select hex(weight_string(cast(0x40A1A1A1A1 as char) as char(3))); hex(weight_string(cast(0x40A1A1A1A1 as char) as char(3))) 40810B810B select hex(weight_string(cast(0x40A1A1A1A1A1A1 as char) as char(3))); hex(weight_string(cast(0x40A1A1A1A1A1A1 as char) as char(3))) 40810B810B select hex(weight_string(cast(0x4040A1A1A1A1A1A1 as char) as char(3))); hex(weight_string(cast(0x4040A1A1A1A1A1A1 as char) as char(3))) 4040810B select hex(weight_string(cast(0xA1A1A1A1A1A1 as char), 1, 2, 0xC0)); hex(weight_string(cast(0xA1A1A1A1A1A1 as char), 1, 2, 0xC0)) 81 select hex(weight_string(cast(0xA1A1A1A1A1A1 as char), 2, 2, 0xC0)); hex(weight_string(cast(0xA1A1A1A1A1A1 as char), 2, 2, 0xC0)) 810B select hex(weight_string(cast(0xA1A1A1A1A1A1 as char), 3, 2, 0xC0)); hex(weight_string(cast(0xA1A1A1A1A1A1 as char), 3, 2, 0xC0)) 810B81 select hex(weight_string(cast(0xA1A1A1A1A1A1 as char), 4, 2, 0xC0)); hex(weight_string(cast(0xA1A1A1A1A1A1 as char), 4, 2, 0xC0)) 810B810B select hex(weight_string(cast(0xA1A1A1A1A1A1 as char), 5, 2, 0xC0)); hex(weight_string(cast(0xA1A1A1A1A1A1 as char), 5, 2, 0xC0)) 810B810B20 select hex(weight_string(cast(0xA1A1A1A1A1A1 as char),25, 2, 0xC0)); hex(weight_string(cast(0xA1A1A1A1A1A1 as char),25, 2, 0xC0)) 810B810B202020202020202020202020202020202020202020 select hex(weight_string(cast(0xA1A1A1A1A1A1 as char), 1, 3, 0xC0)); hex(weight_string(cast(0xA1A1A1A1A1A1 as char), 1, 3, 0xC0)) 81 select hex(weight_string(cast(0xA1A1A1A1A1A1 as char), 2, 3, 0xC0)); hex(weight_string(cast(0xA1A1A1A1A1A1 as char), 2, 3, 0xC0)) 810B select hex(weight_string(cast(0xA1A1A1A1A1A1 as char), 3, 3, 0xC0)); hex(weight_string(cast(0xA1A1A1A1A1A1 as char), 3, 3, 0xC0)) 810B81 select hex(weight_string(cast(0xA1A1A1A1A1A1 as char), 4, 3, 0xC0)); hex(weight_string(cast(0xA1A1A1A1A1A1 as char), 4, 3, 0xC0)) 810B810B select hex(weight_string(cast(0xA1A1A1A1A1A1 as char), 5, 3, 0xC0)); hex(weight_string(cast(0xA1A1A1A1A1A1 as char), 5, 3, 0xC0)) 810B810B81 select hex(weight_string(cast(0xA1A1A1A1A1A1 as char),25, 3, 0xC0)); hex(weight_string(cast(0xA1A1A1A1A1A1 as char),25, 3, 0xC0)) 810B810B810B20202020202020202020202020202020202020 select hex(weight_string(cast(0xA1A1A1A1A1A1 as char), 1, 4, 0xC0)); hex(weight_string(cast(0xA1A1A1A1A1A1 as char), 1, 4, 0xC0)) 81 select hex(weight_string(cast(0xA1A1A1A1A1A1 as char), 2, 4, 0xC0)); hex(weight_string(cast(0xA1A1A1A1A1A1 as char), 2, 4, 0xC0)) 810B select hex(weight_string(cast(0xA1A1A1A1A1A1 as char), 3, 4, 0xC0)); hex(weight_string(cast(0xA1A1A1A1A1A1 as char), 3, 4, 0xC0)) 810B81 select hex(weight_string(cast(0xA1A1A1A1A1A1 as char), 4, 4, 0xC0)); hex(weight_string(cast(0xA1A1A1A1A1A1 as char), 4, 4, 0xC0)) 810B810B select hex(weight_string(cast(0xA1A1A1A1A1A1 as char), 5, 4, 0xC0)); hex(weight_string(cast(0xA1A1A1A1A1A1 as char), 5, 4, 0xC0)) 810B810B81 select hex(weight_string(cast(0xA1A1A1A1A1A1 as char),25, 4, 0xC0)); hex(weight_string(cast(0xA1A1A1A1A1A1 as char),25, 4, 0xC0)) 810B810B810B20202020202020202020202020202020202020 select collation(cast(0x8140 as char)); collation(cast(0x8140 as char)) gbk_chinese_ci select hex(weight_string(cast(0x6141 as char))); hex(weight_string(cast(0x6141 as char))) 4141 select hex(weight_string(cast(0x8140 as char))); hex(weight_string(cast(0x8140 as char))) A2CD select hex(weight_string(cast(0x8140 as char) as char(1))); hex(weight_string(cast(0x8140 as char) as char(1))) A2CD select hex(weight_string(cast(0x81408140 as char) as char(1))); hex(weight_string(cast(0x81408140 as char) as char(1))) A2CD select hex(weight_string(cast(0x8140 as char) as char(3))); hex(weight_string(cast(0x8140 as char) as char(3))) A2CD2020 select hex(weight_string(cast(0x81408140 as char) as char(3))); hex(weight_string(cast(0x81408140 as char) as char(3))) A2CDA2CD20 select hex(weight_string(cast(0x408140 as char) as char(3))); hex(weight_string(cast(0x408140 as char) as char(3))) 40A2CD20 select hex(weight_string(cast(0x4081408140 as char) as char(3))); hex(weight_string(cast(0x4081408140 as char) as char(3))) 40A2CDA2CD select hex(weight_string(cast(0x40814081408140 as char) as char(3))); hex(weight_string(cast(0x40814081408140 as char) as char(3))) 40A2CDA2CD select hex(weight_string(cast(0x4040814081408140 as char) as char(3))); hex(weight_string(cast(0x4040814081408140 as char) as char(3))) 4040A2CD select hex(weight_string(cast(0x814081408140 as char), 1, 2, 0xC0)); hex(weight_string(cast(0x814081408140 as char), 1, 2, 0xC0)) A2 select hex(weight_string(cast(0x814081408140 as char), 2, 2, 0xC0)); hex(weight_string(cast(0x814081408140 as char), 2, 2, 0xC0)) A2CD select hex(weight_string(cast(0x814081408140 as char), 3, 2, 0xC0)); hex(weight_string(cast(0x814081408140 as char), 3, 2, 0xC0)) A2CDA2 select hex(weight_string(cast(0x814081408140 as char), 4, 2, 0xC0)); hex(weight_string(cast(0x814081408140 as char), 4, 2, 0xC0)) A2CDA2CD select hex(weight_string(cast(0x814081408140 as char), 5, 2, 0xC0)); hex(weight_string(cast(0x814081408140 as char), 5, 2, 0xC0)) A2CDA2CD20 select hex(weight_string(cast(0x814081408140 as char),25, 2, 0xC0)); hex(weight_string(cast(0x814081408140 as char),25, 2, 0xC0)) A2CDA2CD202020202020202020202020202020202020202020 select hex(weight_string(cast(0x814081408140 as char), 1, 3, 0xC0)); hex(weight_string(cast(0x814081408140 as char), 1, 3, 0xC0)) A2 select hex(weight_string(cast(0x814081408140 as char), 2, 3, 0xC0)); hex(weight_string(cast(0x814081408140 as char), 2, 3, 0xC0)) A2CD select hex(weight_string(cast(0x814081408140 as char), 3, 3, 0xC0)); hex(weight_string(cast(0x814081408140 as char), 3, 3, 0xC0)) A2CDA2 select hex(weight_string(cast(0x814081408140 as char), 4, 3, 0xC0)); hex(weight_string(cast(0x814081408140 as char), 4, 3, 0xC0)) A2CDA2CD select hex(weight_string(cast(0x814081408140 as char), 5, 3, 0xC0)); hex(weight_string(cast(0x814081408140 as char), 5, 3, 0xC0)) A2CDA2CDA2 select hex(weight_string(cast(0x814081408140 as char),25, 3, 0xC0)); hex(weight_string(cast(0x814081408140 as char),25, 3, 0xC0)) A2CDA2CDA2CD20202020202020202020202020202020202020 select hex(weight_string(cast(0x814081408140 as char), 1, 4, 0xC0)); hex(weight_string(cast(0x814081408140 as char), 1, 4, 0xC0)) A2 select hex(weight_string(cast(0x814081408140 as char), 2, 4, 0xC0)); hex(weight_string(cast(0x814081408140 as char), 2, 4, 0xC0)) A2CD select hex(weight_string(cast(0x814081408140 as char), 3, 4, 0xC0)); hex(weight_string(cast(0x814081408140 as char), 3, 4, 0xC0)) A2CDA2 select hex(weight_string(cast(0x814081408140 as char), 4, 4, 0xC0)); hex(weight_string(cast(0x814081408140 as char), 4, 4, 0xC0)) A2CDA2CD select hex(weight_string(cast(0x814081408140 as char), 5, 4, 0xC0)); hex(weight_string(cast(0x814081408140 as char), 5, 4, 0xC0)) A2CDA2CDA2 select hex(weight_string(cast(0x814081408140 as char),25, 4, 0xC0)); hex(weight_string(cast(0x814081408140 as char),25, 4, 0xC0)) A2CDA2CDA2CD20202020202020202020202020202020202020 select collation(cast(0xA1A1 as char)); collation(cast(0xA1A1 as char)) gbk_chinese_ci select hex(weight_string(cast(0x6141 as char))); hex(weight_string(cast(0x6141 as char))) 4141 select hex(weight_string(cast(0x8EA1 as char))); hex(weight_string(cast(0x8EA1 as char))) 8E08 select hex(weight_string(cast(0x8EA1 as char) as char(1))); hex(weight_string(cast(0x8EA1 as char) as char(1))) 8E08 select hex(weight_string(cast(0x8EA18EA1 as char) as char(1))); hex(weight_string(cast(0x8EA18EA1 as char) as char(1))) 8E08 select hex(weight_string(cast(0x8EA1 as char) as char(3))); hex(weight_string(cast(0x8EA1 as char) as char(3))) 8E082020 select hex(weight_string(cast(0x8EA18EA1 as char) as char(3))); hex(weight_string(cast(0x8EA18EA1 as char) as char(3))) 8E088E0820 select hex(weight_string(cast(0x408EA1 as char) as char(3))); hex(weight_string(cast(0x408EA1 as char) as char(3))) 408E0820 select hex(weight_string(cast(0x408EA18EA1 as char) as char(3))); hex(weight_string(cast(0x408EA18EA1 as char) as char(3))) 408E088E08 select hex(weight_string(cast(0x408EA18EA18EA1 as char) as char(3))); hex(weight_string(cast(0x408EA18EA18EA1 as char) as char(3))) 408E088E08 select hex(weight_string(cast(0x40408EA18EA18EA1 as char) as char(3))); hex(weight_string(cast(0x40408EA18EA18EA1 as char) as char(3))) 40408E08 select hex(weight_string(cast(0x8EA18EA18EA1 as char), 1, 2, 0xC0)); hex(weight_string(cast(0x8EA18EA18EA1 as char), 1, 2, 0xC0)) 8E select hex(weight_string(cast(0x8EA18EA18EA1 as char), 2, 2, 0xC0)); hex(weight_string(cast(0x8EA18EA18EA1 as char), 2, 2, 0xC0)) 8E08 select hex(weight_string(cast(0x8EA18EA18EA1 as char), 3, 2, 0xC0)); hex(weight_string(cast(0x8EA18EA18EA1 as char), 3, 2, 0xC0)) 8E088E select hex(weight_string(cast(0x8EA18EA18EA1 as char), 4, 2, 0xC0)); hex(weight_string(cast(0x8EA18EA18EA1 as char), 4, 2, 0xC0)) 8E088E08 select hex(weight_string(cast(0x8EA18EA18EA1 as char), 5, 2, 0xC0)); hex(weight_string(cast(0x8EA18EA18EA1 as char), 5, 2, 0xC0)) 8E088E0820 select hex(weight_string(cast(0x8EA18EA18EA1 as char),25, 2, 0xC0)); hex(weight_string(cast(0x8EA18EA18EA1 as char),25, 2, 0xC0)) 8E088E08202020202020202020202020202020202020202020 select hex(weight_string(cast(0x8EA18EA18EA1 as char), 1, 3, 0xC0)); hex(weight_string(cast(0x8EA18EA18EA1 as char), 1, 3, 0xC0)) 8E select hex(weight_string(cast(0x8EA18EA18EA1 as char), 2, 3, 0xC0)); hex(weight_string(cast(0x8EA18EA18EA1 as char), 2, 3, 0xC0)) 8E08 select hex(weight_string(cast(0x8EA18EA18EA1 as char), 3, 3, 0xC0)); hex(weight_string(cast(0x8EA18EA18EA1 as char), 3, 3, 0xC0)) 8E088E select hex(weight_string(cast(0x8EA18EA18EA1 as char), 4, 3, 0xC0)); hex(weight_string(cast(0x8EA18EA18EA1 as char), 4, 3, 0xC0)) 8E088E08 select hex(weight_string(cast(0x8EA18EA18EA1 as char), 5, 3, 0xC0)); hex(weight_string(cast(0x8EA18EA18EA1 as char), 5, 3, 0xC0)) 8E088E088E select hex(weight_string(cast(0x8EA18EA18EA1 as char),25, 3, 0xC0)); hex(weight_string(cast(0x8EA18EA18EA1 as char),25, 3, 0xC0)) 8E088E088E0820202020202020202020202020202020202020 select hex(weight_string(cast(0x8EA18EA18EA1 as char), 1, 4, 0xC0)); hex(weight_string(cast(0x8EA18EA18EA1 as char), 1, 4, 0xC0)) 8E select hex(weight_string(cast(0x8EA18EA18EA1 as char), 2, 4, 0xC0)); hex(weight_string(cast(0x8EA18EA18EA1 as char), 2, 4, 0xC0)) 8E08 select hex(weight_string(cast(0x8EA18EA18EA1 as char), 3, 4, 0xC0)); hex(weight_string(cast(0x8EA18EA18EA1 as char), 3, 4, 0xC0)) 8E088E select hex(weight_string(cast(0x8EA18EA18EA1 as char), 4, 4, 0xC0)); hex(weight_string(cast(0x8EA18EA18EA1 as char), 4, 4, 0xC0)) 8E088E08 select hex(weight_string(cast(0x8EA18EA18EA1 as char), 5, 4, 0xC0)); hex(weight_string(cast(0x8EA18EA18EA1 as char), 5, 4, 0xC0)) 8E088E088E select hex(weight_string(cast(0x8EA18EA18EA1 as char),25, 4, 0xC0)); hex(weight_string(cast(0x8EA18EA18EA1 as char),25, 4, 0xC0)) 8E088E088E0820202020202020202020202020202020202020 set collation_connection=gbk_bin; select @@collation_connection; @@collation_connection gbk_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 gbk_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)) gbk_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(0x8140 as char)); collation(cast(0x8140 as char)) gbk_bin select hex(weight_string(cast(0x6141 as char))); hex(weight_string(cast(0x6141 as char))) 6141 select hex(weight_string(cast(0x8140 as char))); hex(weight_string(cast(0x8140 as char))) 8140 select hex(weight_string(cast(0x8140 as char) as char(1))); hex(weight_string(cast(0x8140 as char) as char(1))) 8140 select hex(weight_string(cast(0x81408140 as char) as char(1))); hex(weight_string(cast(0x81408140 as char) as char(1))) 8140 select hex(weight_string(cast(0x8140 as char) as char(3))); hex(weight_string(cast(0x8140 as char) as char(3))) 81402020 select hex(weight_string(cast(0x81408140 as char) as char(3))); hex(weight_string(cast(0x81408140 as char) as char(3))) 8140814020 select hex(weight_string(cast(0x408140 as char) as char(3))); hex(weight_string(cast(0x408140 as char) as char(3))) 40814020 select hex(weight_string(cast(0x4081408140 as char) as char(3))); hex(weight_string(cast(0x4081408140 as char) as char(3))) 4081408140 select hex(weight_string(cast(0x40814081408140 as char) as char(3))); hex(weight_string(cast(0x40814081408140 as char) as char(3))) 4081408140 select hex(weight_string(cast(0x4040814081408140 as char) as char(3))); hex(weight_string(cast(0x4040814081408140 as char) as char(3))) 40408140 select hex(weight_string(cast(0x814081408140 as char), 1, 2, 0xC0)); hex(weight_string(cast(0x814081408140 as char), 1, 2, 0xC0)) 81 select hex(weight_string(cast(0x814081408140 as char), 2, 2, 0xC0)); hex(weight_string(cast(0x814081408140 as char), 2, 2, 0xC0)) 8140 select hex(weight_string(cast(0x814081408140 as char), 3, 2, 0xC0)); hex(weight_string(cast(0x814081408140 as char), 3, 2, 0xC0)) 814081 select hex(weight_string(cast(0x814081408140 as char), 4, 2, 0xC0)); hex(weight_string(cast(0x814081408140 as char), 4, 2, 0xC0)) 81408140 select hex(weight_string(cast(0x814081408140 as char), 5, 2, 0xC0)); hex(weight_string(cast(0x814081408140 as char), 5, 2, 0xC0)) 8140814020 select hex(weight_string(cast(0x814081408140 as char),25, 2, 0xC0)); hex(weight_string(cast(0x814081408140 as char),25, 2, 0xC0)) 81408140202020202020202020202020202020202020202020 select hex(weight_string(cast(0x814081408140 as char), 1, 3, 0xC0)); hex(weight_string(cast(0x814081408140 as char), 1, 3, 0xC0)) 81 select hex(weight_string(cast(0x814081408140 as char), 2, 3, 0xC0)); hex(weight_string(cast(0x814081408140 as char), 2, 3, 0xC0)) 8140 select hex(weight_string(cast(0x814081408140 as char), 3, 3, 0xC0)); hex(weight_string(cast(0x814081408140 as char), 3, 3, 0xC0)) 814081 select hex(weight_string(cast(0x814081408140 as char), 4, 3, 0xC0)); hex(weight_string(cast(0x814081408140 as char), 4, 3, 0xC0)) 81408140 select hex(weight_string(cast(0x814081408140 as char), 5, 3, 0xC0)); hex(weight_string(cast(0x814081408140 as char), 5, 3, 0xC0)) 8140814081 select hex(weight_string(cast(0x814081408140 as char),25, 3, 0xC0)); hex(weight_string(cast(0x814081408140 as char),25, 3, 0xC0)) 81408140814020202020202020202020202020202020202020 select hex(weight_string(cast(0x814081408140 as char), 1, 4, 0xC0)); hex(weight_string(cast(0x814081408140 as char), 1, 4, 0xC0)) 81 select hex(weight_string(cast(0x814081408140 as char), 2, 4, 0xC0)); hex(weight_string(cast(0x814081408140 as char), 2, 4, 0xC0)) 8140 select hex(weight_string(cast(0x814081408140 as char), 3, 4, 0xC0)); hex(weight_string(cast(0x814081408140 as char), 3, 4, 0xC0)) 814081 select hex(weight_string(cast(0x814081408140 as char), 4, 4, 0xC0)); hex(weight_string(cast(0x814081408140 as char), 4, 4, 0xC0)) 81408140 select hex(weight_string(cast(0x814081408140 as char), 5, 4, 0xC0)); hex(weight_string(cast(0x814081408140 as char), 5, 4, 0xC0)) 8140814081 select hex(weight_string(cast(0x814081408140 as char),25, 4, 0xC0)); hex(weight_string(cast(0x814081408140 as char),25, 4, 0xC0)) 81408140814020202020202020202020202020202020202020 select collation(cast(0xA1A1 as char)); collation(cast(0xA1A1 as char)) gbk_bin select hex(weight_string(cast(0x6141 as char))); hex(weight_string(cast(0x6141 as char))) 6141 select hex(weight_string(cast(0x8EA1 as char))); hex(weight_string(cast(0x8EA1 as char))) 8EA1 select hex(weight_string(cast(0x8EA1 as char) as char(1))); hex(weight_string(cast(0x8EA1 as char) as char(1))) 8EA1 select hex(weight_string(cast(0x8EA18EA1 as char) as char(1))); hex(weight_string(cast(0x8EA18EA1 as char) as char(1))) 8EA1 select hex(weight_string(cast(0x8EA1 as char) as char(3))); hex(weight_string(cast(0x8EA1 as char) as char(3))) 8EA12020 select hex(weight_string(cast(0x8EA18EA1 as char) as char(3))); hex(weight_string(cast(0x8EA18EA1 as char) as char(3))) 8EA18EA120 select hex(weight_string(cast(0x408EA1 as char) as char(3))); hex(weight_string(cast(0x408EA1 as char) as char(3))) 408EA120 select hex(weight_string(cast(0x408EA18EA1 as char) as char(3))); hex(weight_string(cast(0x408EA18EA1 as char) as char(3))) 408EA18EA1 select hex(weight_string(cast(0x408EA18EA18EA1 as char) as char(3))); hex(weight_string(cast(0x408EA18EA18EA1 as char) as char(3))) 408EA18EA1 select hex(weight_string(cast(0x40408EA18EA18EA1 as char) as char(3))); hex(weight_string(cast(0x40408EA18EA18EA1 as char) as char(3))) 40408EA1 select hex(weight_string(cast(0x8EA18EA18EA1 as char), 1, 2, 0xC0)); hex(weight_string(cast(0x8EA18EA18EA1 as char), 1, 2, 0xC0)) 8E select hex(weight_string(cast(0x8EA18EA18EA1 as char), 2, 2, 0xC0)); hex(weight_string(cast(0x8EA18EA18EA1 as char), 2, 2, 0xC0)) 8EA1 select hex(weight_string(cast(0x8EA18EA18EA1 as char), 3, 2, 0xC0)); hex(weight_string(cast(0x8EA18EA18EA1 as char), 3, 2, 0xC0)) 8EA18E select hex(weight_string(cast(0x8EA18EA18EA1 as char), 4, 2, 0xC0)); hex(weight_string(cast(0x8EA18EA18EA1 as char), 4, 2, 0xC0)) 8EA18EA1 select hex(weight_string(cast(0x8EA18EA18EA1 as char), 5, 2, 0xC0)); hex(weight_string(cast(0x8EA18EA18EA1 as char), 5, 2, 0xC0)) 8EA18EA120 select hex(weight_string(cast(0x8EA18EA18EA1 as char),25, 2, 0xC0)); hex(weight_string(cast(0x8EA18EA18EA1 as char),25, 2, 0xC0)) 8EA18EA1202020202020202020202020202020202020202020 select hex(weight_string(cast(0x8EA18EA18EA1 as char), 1, 3, 0xC0)); hex(weight_string(cast(0x8EA18EA18EA1 as char), 1, 3, 0xC0)) 8E select hex(weight_string(cast(0x8EA18EA18EA1 as char), 2, 3, 0xC0)); hex(weight_string(cast(0x8EA18EA18EA1 as char), 2, 3, 0xC0)) 8EA1 select hex(weight_string(cast(0x8EA18EA18EA1 as char), 3, 3, 0xC0)); hex(weight_string(cast(0x8EA18EA18EA1 as char), 3, 3, 0xC0)) 8EA18E select hex(weight_string(cast(0x8EA18EA18EA1 as char), 4, 3, 0xC0)); hex(weight_string(cast(0x8EA18EA18EA1 as char), 4, 3, 0xC0)) 8EA18EA1 select hex(weight_string(cast(0x8EA18EA18EA1 as char), 5, 3, 0xC0)); hex(weight_string(cast(0x8EA18EA18EA1 as char), 5, 3, 0xC0)) 8EA18EA18E select hex(weight_string(cast(0x8EA18EA18EA1 as char),25, 3, 0xC0)); hex(weight_string(cast(0x8EA18EA18EA1 as char),25, 3, 0xC0)) 8EA18EA18EA120202020202020202020202020202020202020 select hex(weight_string(cast(0x8EA18EA18EA1 as char), 1, 4, 0xC0)); hex(weight_string(cast(0x8EA18EA18EA1 as char), 1, 4, 0xC0)) 8E select hex(weight_string(cast(0x8EA18EA18EA1 as char), 2, 4, 0xC0)); hex(weight_string(cast(0x8EA18EA18EA1 as char), 2, 4, 0xC0)) 8EA1 select hex(weight_string(cast(0x8EA18EA18EA1 as char), 3, 4, 0xC0)); hex(weight_string(cast(0x8EA18EA18EA1 as char), 3, 4, 0xC0)) 8EA18E select hex(weight_string(cast(0x8EA18EA18EA1 as char), 4, 4, 0xC0)); hex(weight_string(cast(0x8EA18EA18EA1 as char), 4, 4, 0xC0)) 8EA18EA1 select hex(weight_string(cast(0x8EA18EA18EA1 as char), 5, 4, 0xC0)); hex(weight_string(cast(0x8EA18EA18EA1 as char), 5, 4, 0xC0)) 8EA18EA18E select hex(weight_string(cast(0x8EA18EA18EA1 as char),25, 4, 0xC0)); hex(weight_string(cast(0x8EA18EA18EA1 as char),25, 4, 0xC0)) 8EA18EA18EA120202020202020202020202020202020202020 # # Bugs#12635232: VALGRIND WARNINGS: IS_IPV6, IS_IPV4, INET6_ATON, # INET6_NTOA + MULTIBYTE CHARSET. # SET NAMES gbk; 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 gbk))); Warnings: Warning 1411 Incorrect string value: 'convert(_ascii'a:' using gbk)' for function inet6_aton # # End of 5.6 tests #
Close