Linux ip-172-26-2-223 5.4.0-1018-aws #18-Ubuntu SMP Wed Jun 24 01:15:00 UTC 2020 x86_64
Apache
: 172.26.2.223 | : 3.145.167.178
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 /
suite /
innodb /
r /
[ HOME SHELL ]
Name
Size
Permission
Action
add_foreign_key.result
1.28
KB
-rw-r--r--
alter_crash.result
4.43
KB
-rw-r--r--
alter_foreign_crash.result
751
B
-rw-r--r--
alter_kill.result
2.42
KB
-rw-r--r--
alter_missing_tablespace.resul...
1.46
KB
-rw-r--r--
alter_page_size.result
1.14
KB
-rw-r--r--
alter_rename_existing.result
5.32
KB
-rw-r--r--
alter_rename_files.result
557
B
-rw-r--r--
alter_row_format.result
1.59
KB
-rw-r--r--
alter_table_redundant.result
278
B
-rw-r--r--
alter_table_stage_progress.res...
942
B
-rw-r--r--
analyze_index.result
705
B
-rw-r--r--
analyze_table.result
538
B
-rw-r--r--
attachable_trx.result
2.48
KB
-rw-r--r--
autoinc_debug.result
2.53
KB
-rw-r--r--
blob-crash-16k.result
2.1
KB
-rw-r--r--
blob-crash-4k.result
2.1
KB
-rw-r--r--
blob-crash.result
4.59
KB
-rw-r--r--
blob-update-debug.result
489
B
-rw-r--r--
blob_page_reserve.result
3.81
KB
-rw-r--r--
blob_redo.result
1.05
KB
-rw-r--r--
buf_pool_resize_oom.result
493
B
-rw-r--r--
bulk_create_index_online.resul...
1.21
KB
-rw-r--r--
cascade_lock_wait.result
1.52
KB
-rw-r--r--
check_ibd_filesize_16k.result
1.58
KB
-rw-r--r--
check_sector_size.result
276
B
-rw-r--r--
checksum.result
331
B
-rw-r--r--
cmp_per_index.result
2.96
KB
-rw-r--r--
crc32_endianness.result
540
B
-rw-r--r--
create-index.result
283
B
-rw-r--r--
create_isl_with_direct.result
328
B
-rw-r--r--
create_table.result
1.97
KB
-rw-r--r--
create_tablespace.result
81.15
KB
-rw-r--r--
create_tablespace_16k.result
69.23
KB
-rw-r--r--
create_tablespace_32k.result
7.33
KB
-rw-r--r--
create_tablespace_4k.result
36.13
KB
-rw-r--r--
create_tablespace_64k.result
7.64
KB
-rw-r--r--
create_tablespace_8k.result
50.53
KB
-rw-r--r--
create_tablespace_debug.result
5.02
KB
-rw-r--r--
create_tablespace_notembedded....
692
B
-rw-r--r--
create_tablespace_partition.re...
33.17
KB
-rw-r--r--
create_tablespace_replication....
2.02
KB
-rw-r--r--
deadlock_detect.result
562
B
-rw-r--r--
default_row_format.result
17.56
KB
-rw-r--r--
default_row_format_16k.result
17.91
KB
-rw-r--r--
default_row_format_compatibili...
4.14
KB
-rw-r--r--
default_row_format_tablespace....
8.64
KB
-rw-r--r--
deprecate_part_in_shared_ts.re...
5.87
KB
-rw-r--r--
doublewrite.result
8.1
KB
-rw-r--r--
dropdb.result
222
B
-rw-r--r--
end_range_check.result
3.06
KB
-rw-r--r--
end_range_check_2.result
811
B
-rw-r--r--
events-merge-tmp-path.result
1.33
KB
-rw-r--r--
file_format_defaults.result
2.84
KB
-rw-r--r--
file_format_upgrade_16k.result
420
B
-rw-r--r--
flush-hang.result
1.27
KB
-rw-r--r--
foreign_key.result
9.21
KB
-rw-r--r--
fts_exec_interrupt.result
723
B
-rw-r--r--
help_verbose.result
80
B
-rw-r--r--
high_prio_trx_1.result
505
B
-rw-r--r--
high_prio_trx_2.result
581
B
-rw-r--r--
high_prio_trx_3.result
665
B
-rw-r--r--
high_prio_trx_4.result
711
B
-rw-r--r--
high_prio_trx_5.result
858
B
-rw-r--r--
high_prio_trx_6.result
775
B
-rw-r--r--
high_prio_trx_7.result
5.67
KB
-rw-r--r--
high_prio_trx_commit_crash.res...
1
KB
-rw-r--r--
high_prio_trx_debug.result
1.09
KB
-rw-r--r--
high_prio_trx_fk.result
918
B
-rw-r--r--
high_prio_trx_predicate.result
824
B
-rw-r--r--
high_prio_trx_rpl.result
1.65
KB
-rw-r--r--
i_s_files_debug.result
471
B
-rw-r--r--
ibuf_not_empty.result
969
B
-rw-r--r--
import.result
1.72
KB
-rw-r--r--
import_compress_encrypt.result
5.28
KB
-rw-r--r--
import_compress_encrypt_upgrad...
2.53
KB
-rw-r--r--
import_export_4k.result
724
B
-rw-r--r--
import_tablespace_page_corrupt...
555
B
-rw-r--r--
import_tablespace_schema_missm...
2.11
KB
-rw-r--r--
import_update_stats.result
2.86
KB
-rw-r--r--
index-online-norebuild.result
897
B
-rw-r--r--
index_length.result
1.28
KB
-rw-r--r--
index_merge_threshold.result
54.7
KB
-rw-r--r--
index_tree_operation.result
1.65
KB
-rw-r--r--
innodb-2byte-collation.result
3.28
KB
-rw-r--r--
innodb-ac-non-locking-select.r...
861
B
-rw-r--r--
innodb-alter-autoinc.result
4.27
KB
-rw-r--r--
innodb-alter-debug-wl6554.resu...
12.79
KB
-rw-r--r--
innodb-alter-debug.result
2.64
KB
-rw-r--r--
innodb-alter-nullable.result
1.52
KB
-rw-r--r--
innodb-alter-wl6554.result
3.13
KB
-rw-r--r--
innodb-alter.result
30.33
KB
-rw-r--r--
innodb-analyze.result
58
B
-rw-r--r--
innodb-autoinc-18274.result
805
B
-rw-r--r--
innodb-autoinc-44030.result
732
B
-rw-r--r--
innodb-autoinc-56228.result
847
B
-rw-r--r--
innodb-autoinc-optimize.result
321
B
-rw-r--r--
innodb-autoinc.result
41.48
KB
-rw-r--r--
innodb-blob.result
4.91
KB
-rw-r--r--
innodb-bug-14068765.result
2.81
KB
-rw-r--r--
innodb-bug-14084530.result
701
B
-rw-r--r--
innodb-bug12552164.result
1.73
KB
-rw-r--r--
innodb-bug14219515.result
244
B
-rw-r--r--
innodb-change-buffer-recovery....
1.08
KB
-rw-r--r--
innodb-consistent.result
670
B
-rw-r--r--
innodb-import-partition-rpl.re...
2.46
KB
-rw-r--r--
innodb-import-partition.result
40.01
KB
-rw-r--r--
innodb-index-debug.result
13.64
KB
-rw-r--r--
innodb-index-online-delete.res...
642
B
-rw-r--r--
innodb-index-online-fk.result
26.4
KB
-rw-r--r--
innodb-index-online-purge.resu...
1.2
KB
-rw-r--r--
innodb-index-online.result
13.35
KB
-rw-r--r--
innodb-index.result
67.62
KB
-rw-r--r--
innodb-index_ucs2.result
3.62
KB
-rw-r--r--
innodb-isolation.result
43.25
KB
-rw-r--r--
innodb-large-prefix.result
1.27
KB
-rw-r--r--
innodb-lock-inherit-read_commi...
4.18
KB
-rw-r--r--
innodb-lock.result
3.22
KB
-rw-r--r--
innodb-multiple-tablespaces.re...
14.79
KB
-rw-r--r--
innodb-read-view.result
2.73
KB
-rw-r--r--
innodb-replace-debug.result
309
B
-rw-r--r--
innodb-semi-consistent.result
1.35
KB
-rw-r--r--
innodb-status-output.result
1.3
KB
-rw-r--r--
innodb-system-table-view.resul...
9.07
KB
-rw-r--r--
innodb-table-online.result
13.11
KB
-rw-r--r--
innodb-timeout.result
953
B
-rw-r--r--
innodb-truncate-debug.result
4.46
KB
-rw-r--r--
innodb-truncate.result
2.28
KB
-rw-r--r--
innodb-ucs2.result
15.38
KB
-rw-r--r--
innodb-update-insert.result
1.1
KB
-rw-r--r--
innodb-wl5522-1.result
29.45
KB
-rw-r--r--
innodb-wl5522-debug.result
30.05
KB
-rw-r--r--
innodb-wl5522.result
20.99
KB
-rw-r--r--
innodb-wl5980-alter.result
38.86
KB
-rw-r--r--
innodb-wl5980-debug.result
1.33
KB
-rw-r--r--
innodb-wl5980-discard.result
29.2
KB
-rw-r--r--
innodb-wl5980-linux.result
9.7
KB
-rw-r--r--
innodb-wl5980-windows.result
10.07
KB
-rw-r--r--
innodb-wl6045-1.result
3.72
KB
-rw-r--r--
innodb-wl6045-linux.result
11.11
KB
-rw-r--r--
innodb-wl6445-1.result
69
KB
-rw-r--r--
innodb-wl6445-2.result
3.57
KB
-rw-r--r--
innodb-wl6445.result
1.78
KB
-rw-r--r--
innodb.result
108.76
KB
-rw-r--r--
innodb_32k.result
3.25
KB
-rw-r--r--
innodb_64k.result
3.47
KB
-rw-r--r--
innodb_autoinc_lock_mode_zero....
1.22
KB
-rw-r--r--
innodb_autoinc_reset.result
423
B
-rw-r--r--
innodb_buffer_pool_dump_pct.re...
1.49
KB
-rw-r--r--
innodb_buffer_pool_load.result
2.02
KB
-rw-r--r--
innodb_buffer_pool_load_now.re...
1.6
KB
-rw-r--r--
innodb_buffer_pool_resize.resu...
1.29
KB
-rw-r--r--
innodb_buffer_pool_resize_debu...
3.24
KB
-rw-r--r--
innodb_buffer_pool_resize_with...
1.08
KB
-rw-r--r--
innodb_bug-13628249.result
988
B
-rw-r--r--
innodb_bug11754376.result
180
B
-rw-r--r--
innodb_bug11766634.result
396
B
-rw-r--r--
innodb_bug11789106.result
404
B
-rw-r--r--
innodb_bug11933790.result
135
B
-rw-r--r--
innodb_bug12400341.result
966
B
-rw-r--r--
innodb_bug12429573.result
708
B
-rw-r--r--
innodb_bug12661768.result
524
B
-rw-r--r--
innodb_bug14006907.result
934
B
-rw-r--r--
innodb_bug14007109.result
223
B
-rw-r--r--
innodb_bug14007649.result
1.17
KB
-rw-r--r--
innodb_bug14147491.result
730
B
-rw-r--r--
innodb_bug14169459.result
1.48
KB
-rw-r--r--
innodb_bug14676111.result
1.99
KB
-rw-r--r--
innodb_bug14704286.result
1.12
KB
-rw-r--r--
innodb_bug19164038.result
1023
B
-rw-r--r--
innodb_bug21704.result
2.65
KB
-rw-r--r--
innodb_bug30113362.result
2.95
KB
-rw-r--r--
innodb_bug30423.result
3.79
KB
-rw-r--r--
innodb_bug30594501.result
317
B
-rw-r--r--
innodb_bug30919.result
17.44
KB
-rw-r--r--
innodb_bug31205266.result
798
B
-rw-r--r--
innodb_bug34053.result
35
B
-rw-r--r--
innodb_bug34300.result
439
B
-rw-r--r--
innodb_bug35220.result
35
B
-rw-r--r--
innodb_bug38231.result
35
B
-rw-r--r--
innodb_bug39438.result
35
B
-rw-r--r--
innodb_bug40360.result
274
B
-rw-r--r--
innodb_bug40565.result
311
B
-rw-r--r--
innodb_bug41904.result
195
B
-rw-r--r--
innodb_bug42101-nonzero.result
810
B
-rw-r--r--
innodb_bug42101.result
704
B
-rw-r--r--
innodb_bug42419.result
858
B
-rw-r--r--
innodb_bug44032.result
313
B
-rw-r--r--
innodb_bug44369.result
300
B
-rw-r--r--
innodb_bug44571.result
334
B
-rw-r--r--
innodb_bug45357.result
290
B
-rw-r--r--
innodb_bug46000.result
906
B
-rw-r--r--
innodb_bug46676.result
362
B
-rw-r--r--
innodb_bug47167.result
1.51
KB
-rw-r--r--
innodb_bug47621.result
777
B
-rw-r--r--
innodb_bug47622.result
748
B
-rw-r--r--
innodb_bug47777.result
612
B
-rw-r--r--
innodb_bug48024.result
592
B
-rw-r--r--
innodb_bug49164.result
913
B
-rw-r--r--
innodb_bug51378.result
2.19
KB
-rw-r--r--
innodb_bug51920.result
316
B
-rw-r--r--
innodb_bug52199.result
175
B
-rw-r--r--
innodb_bug52663.result
857
B
-rw-r--r--
innodb_bug53046.result
1016
B
-rw-r--r--
innodb_bug53290.result
771
B
-rw-r--r--
innodb_bug53592.result
1.9
KB
-rw-r--r--
innodb_bug53674.result
234
B
-rw-r--r--
innodb_bug53756.result
3.62
KB
-rw-r--r--
innodb_bug54044.result
678
B
-rw-r--r--
innodb_bug56143.result
73.71
KB
-rw-r--r--
innodb_bug56716.result
168
B
-rw-r--r--
innodb_bug56947.result
406
B
-rw-r--r--
innodb_bug57252.result
89
B
-rw-r--r--
innodb_bug57255.result
501
B
-rw-r--r--
innodb_bug57904.result
1.3
KB
-rw-r--r--
innodb_bug59307.result
483
B
-rw-r--r--
innodb_bug59410.result
529
B
-rw-r--r--
innodb_bug59641.result
927
B
-rw-r--r--
innodb_bug59733.result
822
B
-rw-r--r--
innodb_bug60049.result
258
B
-rw-r--r--
innodb_bug60196.result
2.86
KB
-rw-r--r--
innodb_bug60229.result
955
B
-rw-r--r--
innodb_bug70867.result
126
B
-rw-r--r--
innodb_bulk_create_index.resul...
29.62
KB
-rw-r--r--
innodb_bulk_create_index_debug...
11.38
KB
-rw-r--r--
innodb_bulk_create_index_flush...
1.46
KB
-rw-r--r--
innodb_bulk_create_index_repli...
5.82
KB
-rw-r--r--
innodb_bulk_create_index_small...
4.26
KB
-rw-r--r--
innodb_corrupt_bit.result
2.61
KB
-rw-r--r--
innodb_corrupt_readonly.result
1011
B
-rw-r--r--
innodb_ctype_ldml.result
27.55
KB
-rw-r--r--
innodb_deadlock_with_autoinc.r...
565
B
-rw-r--r--
innodb_file_format.result
3.11
KB
-rw-r--r--
innodb_file_limit_check.result
457
B
-rw-r--r--
innodb_force_recovery.result
3.7
KB
-rw-r--r--
innodb_fts_limit_check.result
1.04
KB
-rw-r--r--
innodb_high_prio_commit_crash....
1.13
KB
-rw-r--r--
innodb_high_prio_rpl.result
1.07
KB
-rw-r--r--
innodb_i_s_innodb_locks.result
4.89
KB
-rw-r--r--
innodb_i_s_innodb_trx.result
2.85
KB
-rw-r--r--
innodb_information_schema_buff...
2.29
KB
-rw-r--r--
innodb_io_pf.result
407
B
-rw-r--r--
innodb_lock_wait_timeout_1.res...
9.04
KB
-rw-r--r--
innodb_misc1.result
29.29
KB
-rw-r--r--
innodb_multi_update.result
1.62
KB
-rw-r--r--
innodb_mysql.result
95.87
KB
-rw-r--r--
innodb_mysql_rbk.result
629
B
-rw-r--r--
innodb_notembedded.result
637
B
-rw-r--r--
innodb_page_size_func.result
1.49
KB
-rw-r--r--
innodb_pagesize_max_recordsize...
14.37
KB
-rw-r--r--
innodb_prefix_index_check.resu...
1.14
KB
-rw-r--r--
innodb_prefix_index_restart_se...
2.69
KB
-rw-r--r--
innodb_rename_index.result
31.12
KB
-rw-r--r--
innodb_rename_index_err.result
1.81
KB
-rw-r--r--
innodb_replace.result
2.7
KB
-rw-r--r--
innodb_row_log_read.result
867
B
-rw-r--r--
innodb_stats.result
11.62
KB
-rw-r--r--
innodb_stats_auto_recalc.resul...
1.33
KB
-rw-r--r--
innodb_stats_auto_recalc_ddl.r...
1.13
KB
-rw-r--r--
innodb_stats_auto_recalc_lots....
2.07
KB
-rw-r--r--
innodb_stats_auto_recalc_on_no...
2.19
KB
-rw-r--r--
innodb_stats_create_on_corrupt...
705
B
-rw-r--r--
innodb_stats_create_table.resu...
1.1
KB
-rw-r--r--
innodb_stats_del_mark.result
2.81
KB
-rw-r--r--
innodb_stats_drop_locked.resul...
1.55
KB
-rw-r--r--
innodb_stats_external_pages.re...
880
B
-rw-r--r--
innodb_stats_fetch.result
3.35
KB
-rw-r--r--
innodb_stats_fetch_corrupted.r...
1.01
KB
-rw-r--r--
innodb_stats_fetch_nonexistent...
980
B
-rw-r--r--
innodb_stats_flag_global_off.r...
7.36
KB
-rw-r--r--
innodb_stats_flag_global_on.re...
7.36
KB
-rw-r--r--
innodb_stats_rename_table.resu...
1.48
KB
-rw-r--r--
innodb_stats_rename_table_if_e...
1.89
KB
-rw-r--r--
innodb_stats_sample_pages.resu...
1023
B
-rw-r--r--
innodb_stats_table_flag_auto_r...
2.97
KB
-rw-r--r--
innodb_stats_table_flag_sample...
4.23
KB
-rw-r--r--
innodb_sys_var_valgrind.result
2.35
KB
-rw-r--r--
innodb_tablespace.result
22.76
KB
-rw-r--r--
innodb_tablespace_zip.result
1.13
KB
-rw-r--r--
innodb_thread_concurrency_debu...
824
B
-rw-r--r--
innodb_timeout_rollback.result
570
B
-rw-r--r--
innodb_trx_weight.result
35
B
-rw-r--r--
innodb_upd_stats_if_needed_not...
466
B
-rw-r--r--
innodb_ut_format_name.result
140
B
-rw-r--r--
innodb_wl6326.result
10.95
KB
-rw-r--r--
innodb_wl6326_big.result
17.67
KB
-rw-r--r--
innodb_wl6469_1.result
1.48
KB
-rw-r--r--
innodb_wl6469_debug.result
1.63
KB
-rw-r--r--
innodb_wl6470.result
3.11
KB
-rw-r--r--
innodb_wl6470_debug.result
1.42
KB
-rw-r--r--
innodb_wl6501_crash_1.result
15.37
KB
-rw-r--r--
innodb_wl6501_crash_2.result
15.37
KB
-rw-r--r--
innodb_wl6501_crash_6.result
13.07
KB
-rw-r--r--
innodb_wl6501_crash_7.result
13.07
KB
-rw-r--r--
innodb_wl6501_crash_8.result
468
B
-rw-r--r--
innodb_wl6560_1.result
7.27
KB
-rw-r--r--
innodb_wl6560_debug.result
3.36
KB
-rw-r--r--
innodb_wl6915.result
3.99
KB
-rw-r--r--
innodb_wl6915_debug.result
2.88
KB
-rw-r--r--
innodb_wl8114.result
1.78
KB
-rw-r--r--
insert_debug.result
956
B
-rw-r--r--
iodku.result
6.34
KB
-rw-r--r--
iodku_debug.result
2.71
KB
-rw-r--r--
log_alter_table.result
521
B
-rw-r--r--
log_corruption.result
843
B
-rw-r--r--
log_file.result
4.84
KB
-rw-r--r--
log_file_name.result
1.55
KB
-rw-r--r--
log_file_name_debug.result
345
B
-rw-r--r--
log_file_size.result
1.09
KB
-rw-r--r--
log_file_size_1.result
4.85
KB
-rw-r--r--
log_file_size_checkpoint.resul...
106
B
-rw-r--r--
missing_tablespaces.result
664
B
-rw-r--r--
monitor.result
23.64
KB
-rw-r--r--
monitor_restart.result
324
B
-rw-r--r--
mysqldump_max_recordsize.resul...
8.78
KB
-rw-r--r--
optimizer_temporary_table.resu...
114.72
KB
-rw-r--r--
page_reorganize.result
638
B
-rw-r--r--
partition-blob.result
1.53
KB
-rw-r--r--
partition-upgrade.result
33.24
KB
-rw-r--r--
partition.result
39.54
KB
-rw-r--r--
readahead.result
398
B
-rw-r--r--
readonly.result
713
B
-rw-r--r--
records_in_range.result
35.31
KB
-rw-r--r--
redo_log_during_checkpoint.res...
827
B
-rw-r--r--
rename_table.result
890
B
-rw-r--r--
row_format_redundant.result
1.71
KB
-rw-r--r--
sp_temp_table.result
5.72
KB
-rw-r--r--
stored_fk.result
3.52
KB
-rw-r--r--
strict_checksum.result
1.02
KB
-rw-r--r--
strict_mode.result
3.54
KB
-rw-r--r--
sys_tablestats.result
571
B
-rw-r--r--
table_compress.result
25.4
KB
-rw-r--r--
table_encrypt_1.result
6.82
KB
-rw-r--r--
table_encrypt_2.result
3.44
KB
-rw-r--r--
table_encrypt_3.result
66.48
KB
-rw-r--r--
table_encrypt_4.result
3.64
KB
-rw-r--r--
table_encrypt_5.result
56.6
KB
-rw-r--r--
table_encrypt_debug.result
3.22
KB
-rw-r--r--
table_encrypt_fts.result
1.7
KB
-rw-r--r--
table_encrypt_kill.result
7.59
KB
-rw-r--r--
table_encryption.result
3.42
KB
-rw-r--r--
tablespace_crash.result
8.16
KB
-rw-r--r--
tablespace_embedded.result
6.89
KB
-rw-r--r--
tablespace_embedded_windows.re...
6.93
KB
-rw-r--r--
tablespace_per_table.result
21.6
KB
-rw-r--r--
tablespace_per_table_not_windo...
9.11
KB
-rw-r--r--
tablespace_per_table_windows.r...
3.12
KB
-rw-r--r--
tablespace_portability.result
24.68
KB
-rw-r--r--
tablespace_portability_windows...
24.41
KB
-rw-r--r--
timestamp.result
790
B
-rw-r--r--
tinytext-groupby.result
1.33
KB
-rw-r--r--
tmpdir.result
1.8
KB
-rw-r--r--
trx_id_future.result
329
B
-rw-r--r--
undo.result
850
B
-rw-r--r--
update-cascade.result
8.04
KB
-rw-r--r--
update_time.result
1.62
KB
-rw-r--r--
update_time_wl6658.result
8.08
KB
-rw-r--r--
virtual_basic.result
53.55
KB
-rw-r--r--
virtual_blob.result
359
B
-rw-r--r--
virtual_debug.result
53.92
KB
-rw-r--r--
virtual_debug_purge.result
3.98
KB
-rw-r--r--
virtual_fk.result
28.34
KB
-rw-r--r--
virtual_fk_restart.result
1.48
KB
-rw-r--r--
virtual_index.result
7.71
KB
-rw-r--r--
virtual_purge.result
3.95
KB
-rw-r--r--
virtual_stats.result
4.84
KB
-rw-r--r--
xa_prepare_lock_release.result
1.21
KB
-rw-r--r--
xa_recovery.result
381
B
-rw-r--r--
xa_recovery_debug.result
528
B
-rw-r--r--
Delete
Unzip
Zip
${this.title}
Close
Code Editor : innodb_ctype_ldml.result
drop table if exists t1; In the following tests we change the order of letter "b" making it equal to letter "a", and check that it works with all Unicode character sets set names utf8; show variables like 'character_sets_dir%'; Variable_name Value character_sets_dir MYSQL_TEST_DIR/std_data/ show collation like 'utf8_phone_ci'; Collation Charset Id Default Compiled Sortlen utf8_phone_ci utf8 352 8 CREATE TABLE t1 ( name VARCHAR(64), phone VARCHAR(64) CHARACTER SET utf8 COLLATE utf8_phone_ci ); INSERT INTO t1 VALUES ('Svoj','+7 912 800 80 02'); INSERT INTO t1 VALUES ('Hf','+7 (912) 800 80 04'); INSERT INTO t1 VALUES ('Bar','+7-912-800-80-01'); INSERT INTO t1 VALUES ('Ramil','(7912) 800 80 03'); INSERT INTO t1 VALUES ('Sanja','+380 (912) 8008005'); SELECT * FROM t1 ORDER BY phone; name phone Sanja +380 (912) 8008005 Bar +7-912-800-80-01 Svoj +7 912 800 80 02 Ramil (7912) 800 80 03 Hf +7 (912) 800 80 04 SELECT * FROM t1 WHERE phone='+7(912)800-80-01'; name phone Bar +7-912-800-80-01 SELECT * FROM t1 WHERE phone='79128008001'; name phone Bar +7-912-800-80-01 SELECT * FROM t1 WHERE phone='7 9 1 2 8 0 0 8 0 0 1'; name phone Bar +7-912-800-80-01 DROP TABLE t1; show collation like 'utf8_test_ci'; Collation Charset Id Default Compiled Sortlen utf8_test_ci utf8 353 8 create table t1 (c1 char(1) character set utf8 collate utf8_test_ci); insert into t1 values ('a'); select * from t1 where c1='b'; c1 a drop table t1; show collation like 'ucs2_test_ci'; Collation Charset Id Default Compiled Sortlen ucs2_test_ci ucs2 358 8 create table t1 (c1 char(1) character set ucs2 collate ucs2_test_ci); insert into t1 values ('a'); select * from t1 where c1='b'; c1 a drop table t1; show collation like 'utf8mb4_test_ci'; Collation Charset Id Default Compiled Sortlen utf8mb4_test_ci utf8mb4 326 8 create table t1 (c1 char(1) character set utf8mb4 collate utf8mb4_test_ci); insert into t1 values ('a'); select * from t1 where c1='b'; c1 a drop table t1; show collation like 'utf16_test_ci'; Collation Charset Id Default Compiled Sortlen utf16_test_ci utf16 327 8 create table t1 (c1 char(1) character set utf16 collate utf16_test_ci); insert into t1 values ('a'); select * from t1 where c1='b'; c1 a drop table t1; show collation like 'utf32_test_ci'; Collation Charset Id Default Compiled Sortlen utf32_test_ci utf32 391 8 create table t1 (c1 char(1) character set utf32 collate utf32_test_ci); insert into t1 values ('a'); select * from t1 where c1='b'; c1 a drop table t1; SELECT hex(weight_string(_utf8mb4'a' collate utf8mb4_test_ci)); hex(weight_string(_utf8mb4'a' collate utf8mb4_test_ci)) 120F SELECT hex(weight_string(convert(_utf32 0x10002 using utf8mb4) collate utf8mb4_test_ci)); hex(weight_string(convert(_utf32 0x10002 using utf8mb4) collate utf8mb4_test_ci)) 314A SELECT hex(@a:=convert(_utf32 0x10400 using utf8mb4) collate utf8mb4_test_ci), hex(lower(@a)); hex(@a:=convert(_utf32 0x10400 using utf8mb4) collate utf8mb4_test_ci) hex(lower(@a)) F0909080 F09090A8 SELECT hex(@a:=convert(_utf32 0x10428 using utf8mb4) collate utf8mb4_test_ci), hex(upper(@a)); hex(@a:=convert(_utf32 0x10428 using utf8mb4) collate utf8mb4_test_ci) hex(upper(@a)) F09090A8 F0909080 SELECT hex(@a:=convert(_utf32 0x2C00 using utf8mb4) collate utf8mb4_test_ci), hex(lower(@a)); hex(@a:=convert(_utf32 0x2C00 using utf8mb4) collate utf8mb4_test_ci) hex(lower(@a)) E2B080 E2B0B0 SELECT hex(@a:=convert(_utf32 0x2C30 using utf8mb4) collate utf8mb4_test_ci), hex(upper(@a)); hex(@a:=convert(_utf32 0x2C30 using utf8mb4) collate utf8mb4_test_ci) hex(upper(@a)) E2B0B0 E2B080 SELECT hex(weight_string(convert(_utf32 0x61 using utf8mb4) collate utf8mb4_test_ci)); hex(weight_string(convert(_utf32 0x61 using utf8mb4) collate utf8mb4_test_ci)) 120F SELECT hex(weight_string(convert(_utf32 0x62 using utf8mb4) collate utf8mb4_test_ci)); hex(weight_string(convert(_utf32 0x62 using utf8mb4) collate utf8mb4_test_ci)) 120F SELECT hex(weight_string(convert(_utf32 0x10062 using utf8mb4) collate utf8mb4_test_ci)); hex(weight_string(convert(_utf32 0x10062 using utf8mb4) collate utf8mb4_test_ci)) 120F SELECT hex(weight_string(convert(_utf32 0x10400 using utf8mb4) collate utf8mb4_test_ci)); hex(weight_string(convert(_utf32 0x10400 using utf8mb4) collate utf8mb4_test_ci)) 30D2 SELECT hex(weight_string(convert(_utf32 0x100400 using utf8mb4) collate utf8mb4_test_ci)); hex(weight_string(convert(_utf32 0x100400 using utf8mb4) collate utf8mb4_test_ci)) 30D2 SELECT hex(weight_string(_utf8mb4 0x64 collate utf8mb4_test_ci)); hex(weight_string(_utf8mb4 0x64 collate utf8mb4_test_ci)) 1250 SELECT hex(weight_string(convert(_ucs2 0x0064017e using utf8mb4) collate utf8mb4_test_ci)); hex(weight_string(convert(_ucs2 0x0064017e using utf8mb4) collate utf8mb4_test_ci)) 1251 SELECT hex(weight_string(convert(_ucs2 0x0044017e using utf8mb4) collate utf8mb4_test_ci)); hex(weight_string(convert(_ucs2 0x0044017e using utf8mb4) collate utf8mb4_test_ci)) 1251 SELECT hex(weight_string(convert(_ucs2 0x0044017d using utf8mb4) collate utf8mb4_test_ci)); hex(weight_string(convert(_ucs2 0x0044017d using utf8mb4) collate utf8mb4_test_ci)) 1251 # # Bug#45645 Mysql server close all connection and restart using lower function # CREATE TABLE t1 (a VARCHAR(10)) CHARACTER SET utf8 COLLATE utf8_test_ci; INSERT INTO t1 (a) VALUES ('hello!'); SELECT * FROM t1 WHERE LOWER(a)=LOWER('N'); a DROP TABLE t1; # # Bug#51976 LDML collations issue (cyrillic example) # CREATE TABLE t1 (a VARCHAR(10) CHARACTER SET utf8 COLLATE utf8_test_ci); INSERT INTO t1 (a) VALUES ('Hello'); SELECT a, UPPER(a), LOWER(a) FROM t1; a UPPER(a) LOWER(a) Hello HELLO hello DROP TABLE t1; # # Bug#43827 Server closes connections and restarts # CREATE TABLE t1 (c1 VARCHAR(10) CHARACTER SET utf8 COLLATE utf8_test_ci); INSERT IGNORE INTO t1 SELECT REPEAT('a',11); Warnings: Warning 1265 Data truncated for column 'c1' at row 1 DROP TABLE t1; Vietnamese experimental collation show collation like 'ucs2_vn_ci'; Collation Charset Id Default Compiled Sortlen ucs2_vn_ci ucs2 359 8 create table t1 (c1 char(1) character set ucs2 collate ucs2_vn_ci); insert into t1 values (0x0061),(0x0041),(0x00E0),(0x00C0),(0x1EA3),(0x1EA2), (0x00E3),(0x00C3),(0x00E1),(0x00C1),(0x1EA1),(0x1EA0); insert into t1 values (0x0103),(0x0102),(0x1EB1),(0x1EB0),(0x1EB3),(0x1EB2), (0x1EB5),(0x1EB4),(0x1EAF),(0x1EAE),(0x1EB7),(0x1EB6); insert into t1 values (0x00E2),(0x00C2),(0x1EA7),(0x1EA6),(0x1EA9),(0x1EA8), (0x1EAB),(0x1EAA),(0x1EA5),(0x1EA4),(0x1EAD),(0x1EAC); insert into t1 values ('b'),('B'),('c'),('C'); insert into t1 values ('d'),('D'),(0x0111),(0x0110); insert into t1 values (0x0065),(0x0045),(0x00E8),(0x00C8),(0x1EBB),(0x1EBA), (0x1EBD),(0x1EBC),(0x00E9),(0x00C9),(0x1EB9),(0x1EB8); insert into t1 values (0x00EA),(0x00CA),(0x1EC1),(0x1EC0),(0x1EC3),(0x1EC2), (0x1EC5),(0x1EC4),(0x1EBF),(0x1EBE),(0x1EC7),(0x1EC6); insert into t1 values ('g'),('G'),('h'),('H'); insert into t1 values (0x0069),(0x0049),(0x00EC),(0x00CC),(0x1EC9),(0x1EC8), (0x0129),(0x0128),(0x00ED),(0x00CD),(0x1ECB),(0x1ECA); insert into t1 values ('k'),('K'),('l'),('L'),('m'),('M'); insert into t1 values (0x006F),(0x004F),(0x00F2),(0x00D2),(0x1ECF),(0x1ECE), (0x00F5),(0x00D5),(0x00F3),(0x00D3),(0x1ECD),(0x1ECC); insert into t1 values (0x00F4),(0x00D4),(0x1ED3),(0x1ED2),(0x1ED5),(0x1ED4), (0x1ED7),(0x1ED6),(0x1ED1),(0x1ED0),(0x1ED9),(0x1ED8); insert into t1 values (0x01A1),(0x01A0),(0x1EDD),(0x1EDC),(0x1EDF),(0x1EDE), (0x1EE1),(0x1EE0),(0x1EDB),(0x1EDA),(0x1EE3),(0x1EE2); insert into t1 values ('p'),('P'),('q'),('Q'),('r'),('R'),('s'),('S'),('t'),('T'); insert into t1 values (0x0075),(0x0055),(0x00F9),(0x00D9),(0x1EE7),(0x1EE6), (0x0169),(0x0168),(0x00FA),(0x00DA),(0x1EE5),(0x1EE4); insert into t1 values (0x01B0),(0x01AF),(0x1EEB),(0x1EEA),(0x1EED),(0x1EEC), (0x1EEF),(0x1EEE),(0x1EE9),(0x1EE8),(0x1EF1),(0x1EF0); insert into t1 values ('v'),('V'),('x'),('X'); insert into t1 values (0x0079),(0x0059),(0x1EF3),(0x1EF2),(0x1EF7),(0x1EF6), (0x1EF9),(0x1EF8),(0x00FD),(0x00DD),(0x1EF5),(0x1EF4); select hex(c1) as h, c1 from t1 order by c1, h; h c1 0041 A 0061 a 00C0 À 00C1 Á 00C3 Ã 00E0 à 00E1 á 00E3 ã 1EA0 Ạ 1EA1 ạ 1EA2 Ả 1EA3 ả 0102 Ă 0103 ă 1EAE Ắ 1EAF ắ 1EB0 Ằ 1EB1 ằ 1EB2 Ẳ 1EB3 ẳ 1EB4 Ẵ 1EB5 ẵ 1EB6 Ặ 1EB7 ặ 00C2 Â 00E2 â 1EA4 Ấ 1EA5 ấ 1EA6 Ầ 1EA7 ầ 1EA8 Ẩ 1EA9 ẩ 1EAA Ẫ 1EAB ẫ 1EAC Ậ 1EAD ậ 0042 B 0062 b 0043 C 0063 c 0044 D 0064 d 0110 Đ 0111 đ 0045 E 0065 e 00C8 È 00C9 É 00E8 è 00E9 é 1EB8 Ẹ 1EB9 ẹ 1EBA Ẻ 1EBB ẻ 1EBC Ẽ 1EBD ẽ 00CA Ê 00EA ê 1EBE Ế 1EBF ế 1EC0 Ề 1EC1 ề 1EC2 Ể 1EC3 ể 1EC4 Ễ 1EC5 ễ 1EC6 Ệ 1EC7 ệ 0047 G 0067 g 0048 H 0068 h 0049 I 0069 i 00CC Ì 00CD Í 00EC ì 00ED í 0128 Ĩ 0129 ĩ 1EC8 Ỉ 1EC9 ỉ 1ECA Ị 1ECB ị 004B K 006B k 004C L 006C l 004D M 006D m 004F O 006F o 00D2 Ò 00D3 Ó 00D5 Õ 00F2 ò 00F3 ó 00F5 õ 1ECC Ọ 1ECD ọ 1ECE Ỏ 1ECF ỏ 00D4 Ô 00F4 ô 1ED0 Ố 1ED1 ố 1ED2 Ồ 1ED3 ồ 1ED4 Ổ 1ED5 ổ 1ED6 Ỗ 1ED7 ỗ 1ED8 Ộ 1ED9 ộ 01A0 Ơ 01A1 ơ 1EDA Ớ 1EDB ớ 1EDC Ờ 1EDD ờ 1EDE Ở 1EDF ở 1EE0 Ỡ 1EE1 ỡ 1EE2 Ợ 1EE3 ợ 0050 P 0070 p 0051 Q 0071 q 0052 R 0072 r 0053 S 0073 s 0054 T 0074 t 0055 U 0075 u 00D9 Ù 00DA Ú 00F9 ù 00FA ú 0168 Ũ 0169 ũ 1EE4 Ụ 1EE5 ụ 1EE6 Ủ 1EE7 ủ 01AF Ư 01B0 ư 1EE8 Ứ 1EE9 ứ 1EEA Ừ 1EEB ừ 1EEC Ử 1EED ử 1EEE Ữ 1EEF ữ 1EF0 Ự 1EF1 ự 0056 V 0076 v 0058 X 0078 x 0059 Y 0079 y 00DD Ý 00FD ý 1EF2 Ỳ 1EF3 ỳ 1EF4 Ỵ 1EF5 ỵ 1EF6 Ỷ 1EF7 ỷ 1EF8 Ỹ 1EF9 ỹ select group_concat(hex(c1) order by hex(c1)) from t1 group by c1; group_concat(hex(c1) order by hex(c1)) 0041,0061,00C0,00C1,00C3,00E0,00E1,00E3,1EA0,1EA1,1EA2,1EA3 0102,0103,1EAE,1EAF,1EB0,1EB1,1EB2,1EB3,1EB4,1EB5,1EB6,1EB7 00C2,00E2,1EA4,1EA5,1EA6,1EA7,1EA8,1EA9,1EAA,1EAB,1EAC,1EAD 0042,0062 0043,0063 0044,0064 0110,0111 0045,0065,00C8,00C9,00E8,00E9,1EB8,1EB9,1EBA,1EBB,1EBC,1EBD 00CA,00EA,1EBE,1EBF,1EC0,1EC1,1EC2,1EC3,1EC4,1EC5,1EC6,1EC7 0047,0067 0048,0068 0049,0069,00CC,00CD,00EC,00ED,0128,0129,1EC8,1EC9,1ECA,1ECB 004B,006B 004C,006C 004D,006D 004F,006F,00D2,00D3,00D5,00F2,00F3,00F5,1ECC,1ECD,1ECE,1ECF 00D4,00F4,1ED0,1ED1,1ED2,1ED3,1ED4,1ED5,1ED6,1ED7,1ED8,1ED9 01A0,01A1,1EDA,1EDB,1EDC,1EDD,1EDE,1EDF,1EE0,1EE1,1EE2,1EE3 0050,0070 0051,0071 0052,0072 0053,0073 0054,0074 0055,0075,00D9,00DA,00F9,00FA,0168,0169,1EE4,1EE5,1EE6,1EE7 01AF,01B0,1EE8,1EE9,1EEA,1EEB,1EEC,1EED,1EEE,1EEF,1EF0,1EF1 0056,0076 0058,0078 0059,0079,00DD,00FD,1EF2,1EF3,1EF4,1EF5,1EF6,1EF7,1EF8,1EF9 select group_concat(c1 order by hex(c1) SEPARATOR '') from t1 group by c1; group_concat(c1 order by hex(c1) SEPARATOR '') AaÀÁÃàáãẠạẢả ĂăẮắẰằẲẳẴẵẶặ ÂâẤấẦầẨẩẪẫẬậ Bb Cc Dd Đđ EeÈÉèéẸẹẺẻẼẽ ÊêẾếỀềỂểỄễỆệ Gg Hh IiÌÍìíĨĩỈỉỊị Kk Ll Mm OoÒÓÕòóõỌọỎỏ ÔôỐốỒồỔổỖỗỘộ ƠơỚớỜờỞởỠỡỢợ Pp Qq Rr Ss Tt UuÙÚùúŨũỤụỦủ ƯưỨứỪừỬửỮữỰự Vv Xx YyÝýỲỳỴỵỶỷỸỹ drop table t1; Bug#46448 trailing spaces are not ignored when user collation maps space != 0x20 set names latin1; show collation like 'latin1_test'; Collation Charset Id Default Compiled Sortlen latin1_test latin1 99 Yes 1 select "foo" = "foo " collate latin1_test; "foo" = "foo " collate latin1_test 1 The following tests check that two-byte collation IDs work select * from information_schema.collations where id>256 order by id; COLLATION_NAME CHARACTER_SET_NAME ID IS_DEFAULT IS_COMPILED SORTLEN utf8mb4_test_ci utf8mb4 326 8 utf16_test_ci utf16 327 8 utf8mb4_test_400_ci utf8mb4 328 8 utf8_bengali_standard_ci utf8 336 8 utf8_bengali_traditional_ci utf8 337 8 utf8_phone_ci utf8 352 8 utf8_test_ci utf8 353 8 utf8_5624_1 utf8 354 8 utf8_5624_2 utf8 355 8 utf8_5624_3 utf8 356 8 utf8_5624_4 utf8 357 8 ucs2_test_ci ucs2 358 8 ucs2_vn_ci ucs2 359 8 ucs2_5624_1 ucs2 360 8 utf8_5624_5 utf8 368 8 utf32_test_ci utf32 391 8 utf8_maxuserid_ci utf8 2047 8 show collation like '%test%'; Collation Charset Id Default Compiled Sortlen latin1_test latin1 99 Yes 1 utf8_test_ci utf8 353 8 ucs2_test_ci ucs2 358 8 utf8mb4_test_ci utf8mb4 326 8 utf8mb4_test_400_ci utf8mb4 328 8 utf16_test_ci utf16 327 8 utf32_test_ci utf32 391 8 show collation like 'ucs2_vn_ci'; Collation Charset Id Default Compiled Sortlen ucs2_vn_ci ucs2 359 8 create table t1 (c1 char(1) character set ucs2 collate ucs2_vn_ci); show create table t1; Table Create Table t1 CREATE TABLE `t1` ( `c1` char(1) CHARACTER SET ucs2 COLLATE ucs2_vn_ci DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 insert into t1 values (0x0061); set @@character_set_results=NULL; select * from t1; Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr def test t1 t1 c1 c1 254 2 2 Y 0 0 359 c1 a drop table t1; CREATE TABLE t1 (s1 char(10) character set utf8 collate utf8_maxuserid_ci); INSERT INTO t1 VALUES ('a'),('b'); SELECT * FROM t1 WHERE s1='a' ORDER BY BINARY s1; s1 a b DROP TABLE t1; SET NAMES utf8 COLLATE utf8_phone_ci; SHOW COLLATION LIKE 'utf8_phone_ci'; Collation Charset Id Default Compiled Sortlen utf8_phone_ci utf8 352 8 SET NAMES utf8; SELECT hex(weight_string(_utf8mb4'a' collate utf8mb4_test_400_ci)); hex(weight_string(_utf8mb4'a' collate utf8mb4_test_400_ci)) 0E33 SELECT hex(weight_string(convert(_utf32 0x10002 using utf8mb4) collate utf8mb4_test_400_ci)); hex(weight_string(convert(_utf32 0x10002 using utf8mb4) collate utf8mb4_test_400_ci)) FFFD SELECT hex(@a:=convert(_utf32 0x10400 using utf8mb4) collate utf8mb4_test_400_ci), hex(lower(@a)); hex(@a:=convert(_utf32 0x10400 using utf8mb4) collate utf8mb4_test_400_ci) hex(lower(@a)) F0909080 F09090A8 SELECT hex(@a:=convert(_utf32 0x10428 using utf8mb4) collate utf8mb4_test_400_ci), hex(upper(@a)); hex(@a:=convert(_utf32 0x10428 using utf8mb4) collate utf8mb4_test_400_ci) hex(upper(@a)) F09090A8 F09090A8 SELECT hex(@a:=convert(_utf32 0x2C00 using utf8mb4) collate utf8mb4_test_400_ci), hex(lower(@a)); hex(@a:=convert(_utf32 0x2C00 using utf8mb4) collate utf8mb4_test_400_ci) hex(lower(@a)) E2B080 E2B080 SELECT hex(@a:=convert(_utf32 0x2C30 using utf8mb4) collate utf8mb4_test_400_ci), hex(upper(@a)); hex(@a:=convert(_utf32 0x2C30 using utf8mb4) collate utf8mb4_test_400_ci) hex(upper(@a)) E2B0B0 E2B0B0 # # WL#5624 Collation customization improvements # SET NAMES utf8 COLLATE utf8_5624_1; CREATE TABLE t1 AS SELECT REPEAT(' ', 16) AS a LIMIT 0; INSERT INTO t1 VALUES ('012345'),('001234'),('000123'),('000012'),('000001'); INSERT INTO t1 VALUES ('12345'),('01234'),('00123'),('00012'),('00001'); INSERT INTO t1 VALUES ('1234'),('0123'),('0012'),('0001'); INSERT INTO t1 VALUES ('123'),('012'),('001'); INSERT INTO t1 VALUES ('12'),('01'); INSERT INTO t1 VALUES ('1'),('9'); INSERT INTO t1 VALUES ('ГАИ'),('ГИБДД'); INSERT INTO t1 VALUES ('a'),('b'),('c'),('d'),('e'); INSERT INTO t1 VALUES ('cz'),('Ċ'),('ċ'); INSERT INTO t1 VALUES ('f'),('fz'),('g'),('Ġ'),('ġ'); INSERT INTO t1 VALUES ('h'),('hz'),('GĦ'),('Għ'),('gĦ'),('għ'); INSERT INTO t1 VALUES ('i'),('iz'),('Ħ'),('ħ'); INSERT INTO t1 VALUES ('y'),('yz'),('z'),('Ż'),('ż'); INSERT INTO t1 VALUES ('ā'),('Ā'),('á'),('Á'),('à'),('À'); INSERT INTO t1 VALUES ('ē'),('é'),('ě'),('ê'),('Ē'),('É'),('Ě'),('Ê'); INSERT INTO t1 VALUES ('a'),('~'),('!'),('@'),('#'),('$'),('%'),('^'); INSERT INTO t1 VALUES ('('),(')'),('-'),('+'),('|'),('='),(':'),(';'); INSERT INTO t1 VALUES ('"'),('\''),('?'); INSERT INTO t1 VALUES ('ch'),('k'),('cs'),('ccs'),('cscs'); INSERT INTO t1 VALUES ('aa-'),('ab-'),('ac-'),('ad-'),('ae-'),('af-'),('az-'); INSERT INTO t1 VALUES ('lp-fni'),('lp-lni'); INSERT INTO t1 VALUES ('lp-fpi'),('lp-lpi'); INSERT INTO t1 VALUES ('lp-fsi'),('lp-lsi'); INSERT INTO t1 VALUES ('lp-fti'),('lp-lti'); INSERT INTO t1 VALUES ('lp-ft'),('lp-lt'); INSERT INTO t1 VALUES ('lp-fv'),('lp-lv'); INSERT INTO t1 VALUES ('lb-fni'),('lb-lni'); INSERT INTO t1 VALUES ('lb-fv'),('lb-lv'); INSERT INTO t1 VALUES (_ucs2 0x3106),(_ucs2 0x3110), (_ucs2 0x3111), (_ucs2 0x3112); INSERT INTO t1 VALUES (_ucs2 0x32A3), (_ucs2 0x3231); INSERT INTO t1 VALUES (_ucs2 0x84D9), (_ucs2 0x98F5), (_ucs2 0x7CF3), (_ucs2 0x5497); SELECT a, HEX(WEIGHT_STRING(a)) FROM t1 ORDER BY a, LENGTH(a), BINARY a; a HEX(WEIGHT_STRING(a)) lp-ft 0001 lp-lt 0001 lp-fpi 0001 lp-fsi 0001 lp-fti 0001 lp-lpi 0001 lp-lsi 0001 lp-lti 0001 lb-fv 0200233E lb-fni 0200233E lp-fv 0202 lp-fni 0202 - 0221 = 042D | 0430 lb-lv 0DD9233E lp-lv 0DDB 1 0E2A 01 0E2A 001 0E2A 0001 0E2A 00001 0E2A 000001 0E2A 12 0E2A0E2B 012 0E2A0E2B 0012 0E2A0E2B 00012 0E2A0E2B 000012 0E2A0E2B 123 0E2A0E2B0E2C 0123 0E2A0E2B0E2C 00123 0E2A0E2B0E2C 000123 0E2A0E2B0E2C 1234 0E2A0E2B0E2C0E2D 01234 0E2A0E2B0E2C0E2D 001234 0E2A0E2B0E2C0E2D 12345 0E2A0E2B0E2C0E2D0E2E 012345 0E2A0E2B0E2C0E2D0E2E 9 0E32 ~ 0E32233E ! 0E32233F @ 0E322340 # 0E322341 $ 0E322342 % 0E322343 ^ 0E322344 ( 0E322346 ) 0E322347 + 0E322348 : 0E322349 ; 0E32234A " 0E32234B ' 0E32234C ? 0E32234D a 0E33 a 0E33 aa- 0E330E330221 ab- 0E330E4A0E34 ac- 0E330E600E60 ad- 0E330E6D0E6D ae- 0E330E8B0E8B af- 0E330EB90EB9 az- 0E33106A0221 b 0E4A À 0E4A Á 0E4A à 0E4A á 0E4A Ā 0E4A ā 0E4A c 0E60 k 0E600EE1 ch 0E600EE1 cs 0E600FEA ccs 0E600FEA0E600FEA cscs 0E600FEA0E600FEA cz 0E60106A Ċ 0E6C233E ċ 0E6C233E d 0E6D É 0E6D Ê 0E6D é 0E6D ê 0E6D Ē 0E6D ē 0E6D Ě 0E6D ě 0E6D e 0E8B f 0EB9 fz 0EB9106A Ġ 0EC0233E ġ 0EC0233E g 0EC1 GĦ 0EE0233E Għ 0EE0233E gĦ 0EE0233E għ 0EE0233E h 0EE1 hz 0EE1106A Ħ 0EFA233E ħ 0EFA233E i 0EFB iz 0EFB106A y 105E yz 105E106A Ż 1069233E ż 1069233E z 106A ГАИ 11341114117C ГИБДД 11341114117C lb-lni 233C233E lp-lni 233E ㄆ 233F ㄐ 2349 ㄑ 234A ㄒ 234B ㊣ 7147 ㈱ 72D5 蓙 753C 飵 753D 糳 753E 咗 753F # # WL#5624, the same test with UCS2 # ALTER TABLE t1 CONVERT TO CHARACTER SET ucs2 COLLATE ucs2_5624_1; SELECT a, HEX(WEIGHT_STRING(a)) FROM t1 ORDER BY a, LENGTH(a), BINARY(a); a HEX(WEIGHT_STRING(a)) lp-ft 0001 lp-lt 0001 lp-fpi 0001 lp-fsi 0001 lp-fti 0001 lp-lpi 0001 lp-lsi 0001 lp-lti 0001 lb-fv 0200233E lb-fni 0200233E lp-fv 0202 lp-fni 0202 - 0221 = 042D | 0430 lb-lv 0DD9233E lp-lv 0DDB 1 0E2A 01 0E2A 001 0E2A 0001 0E2A 00001 0E2A 000001 0E2A 12 0E2A0E2B 012 0E2A0E2B 0012 0E2A0E2B 00012 0E2A0E2B 000012 0E2A0E2B 123 0E2A0E2B0E2C 0123 0E2A0E2B0E2C 00123 0E2A0E2B0E2C 000123 0E2A0E2B0E2C 1234 0E2A0E2B0E2C0E2D 01234 0E2A0E2B0E2C0E2D 001234 0E2A0E2B0E2C0E2D 12345 0E2A0E2B0E2C0E2D0E2E 012345 0E2A0E2B0E2C0E2D0E2E 9 0E32 ~ 0E32233E ! 0E32233F @ 0E322340 # 0E322341 $ 0E322342 % 0E322343 ^ 0E322344 ( 0E322346 ) 0E322347 + 0E322348 : 0E322349 ; 0E32234A " 0E32234B ' 0E32234C ? 0E32234D a 0E33 a 0E33 aa- 0E330E330221 ab- 0E330E4A0E34 ac- 0E330E600E60 ad- 0E330E6D0E6D ae- 0E330E8B0E8B af- 0E330EB90EB9 az- 0E33106A0221 b 0E4A À 0E4A Á 0E4A à 0E4A á 0E4A Ā 0E4A ā 0E4A c 0E60 k 0E600EE1 ch 0E600EE1 cs 0E600FEA ccs 0E600FEA0E600FEA cscs 0E600FEA0E600FEA cz 0E60106A Ċ 0E6C233E ċ 0E6C233E d 0E6D É 0E6D Ê 0E6D é 0E6D ê 0E6D Ē 0E6D ē 0E6D Ě 0E6D ě 0E6D e 0E8B f 0EB9 fz 0EB9106A Ġ 0EC0233E ġ 0EC0233E g 0EC1 GĦ 0EE0233E Għ 0EE0233E gĦ 0EE0233E għ 0EE0233E h 0EE1 hz 0EE1106A Ħ 0EFA233E ħ 0EFA233E i 0EFB iz 0EFB106A y 105E yz 105E106A Ż 1069233E ż 1069233E z 106A ГАИ 11341114117C ГИБДД 11341114117C lb-lni 233C233E lp-lni 233E ㄆ 233F ㄐ 2349 ㄑ 234A ㄒ 234B ㊣ 7147 ㈱ 72D5 蓙 753C 飵 753D 糳 753E 咗 753F DROP TABLE t1; # # WL#5624, unsupported features # SET NAMES utf8 COLLATE utf8_5624_2; ERROR HY000: Unknown collation: 'utf8_5624_2' SHOW WARNINGS; Level Code Message Error 1273 Unknown collation: 'utf8_5624_2' Warning 1273 Syntax error at '[strength tertiary]' for COLLATION : utf8_5624_2 # # WL#5624, reset before primary ignorable # SET NAMES utf8 COLLATE utf8_5624_3; ERROR HY000: Unknown collation: 'utf8_5624_3' SHOW WARNINGS; Level Code Message Error 1273 Unknown collation: 'utf8_5624_3' Warning 1273 Can't reset before a primary ignorable character U+A48C # # WL#5624, \u without hex digits is equal to {'\', 'u'} # SET NAMES utf8 COLLATE utf8_5624_4; CREATE TABLE t1 AS SELECT REPEAT(' ', 10) AS a LIMIT 0; INSERT INTO t1 VALUES ('\\'),('u'),('x'),('X'); SELECT a, HEX(WEIGHT_STRING(a)) FROM t1 ORDER BY a, LENGTH(a), BINARY(a); a HEX(WEIGHT_STRING(a)) \ 02CE x 02CE101F u 101F X 105A DROP TABLE t1; # # WL#5624, testing Bengali collations # SET NAMES utf8, collation_connection=utf8_bengali_standard_ci; CREATE TABLE t1 AS SELECT REPEAT (' ', 10) AS a LIMIT 0; INSERT INTO t1 VALUES (_ucs2 0x09FA), (_ucs2 0x09F8), (_ucs2 0x09F9), (_ucs2 0x09F2); INSERT INTO t1 VALUES (_ucs2 0x09DC), (_ucs2 0x09A109BC); INSERT INTO t1 VALUES (_ucs2 0x09A2), (_ucs2 0x09DD), (_ucs2 0x09A209BC); INSERT INTO t1 VALUES (_ucs2 0x09A3); SELECT HEX(WEIGHT_STRING(a)), HEX(CONVERT(a USING ucs2)), HEX(a) FROM t1 ORDER BY a, BINARY a; HEX(WEIGHT_STRING(a)) HEX(CONVERT(a USING ucs2)) HEX(a) 0350 09FA E0A7BA 0351 09F8 E0A7B8 0352 09F9 E0A7B9 0353 09F2 E0A7B2 0374 09A109BC E0A6A1E0A6BC 0374 09DC E0A79C 0375 09A2 E0A6A2 0376 09A209BC E0A6A2E0A6BC 0376 09DD E0A79D 0377 09A3 E0A6A3 DROP TABLE t1; SET NAMES utf8, collation_connection=utf8_bengali_traditional_ci; CREATE TABLE t1 AS SELECT REPEAT (' ', 10) AS a LIMIT 0; INSERT INTO t1 VALUES (_ucs2 0x0985),(_ucs2 0x0986),(_ucs2 0x0987),(_ucs2 0x0988), (_ucs2 0x0989),(_ucs2 0x098A),(_ucs2 0x098B),(_ucs2 0x09E0), (_ucs2 0x098C),(_ucs2 0x09E1),(_ucs2 0x098F),(_ucs2 0x0990), (_ucs2 0x0993); INSERT INTO t1 VALUES (_ucs2 0x0994),(_ucs2 0x0982),(_ucs2 0x0983),(_ucs2 0x0981), (_ucs2 0x099509CD), (_ucs2 0x099609CD), (_ucs2 0x099709CD), (_ucs2 0x099809CD), (_ucs2 0x099909CD), (_ucs2 0x099A09CD), (_ucs2 0x099B09CD), (_ucs2 0x099C09CD), (_ucs2 0x099D09CD), (_ucs2 0x099E09CD), (_ucs2 0x099F09CD), (_ucs2 0x09A009CD), (_ucs2 0x09A109CD), (_ucs2 0x09A209CD), (_ucs2 0x09A309CD), (_ucs2 0x09CE), (_ucs2 0x09A409CD200D), (_ucs2 0x09A409CD), (_ucs2 0x09A509CD),(_ucs2 0x09A609CD), (_ucs2 0x09A709CD), (_ucs2 0x09A809CD), (_ucs2 0x09AA09CD), (_ucs2 0x09AB09CD), (_ucs2 0x09AC09CD), (_ucs2 0x09AD09CD), (_ucs2 0x09AE09CD), (_ucs2 0x09AF09CD), (_ucs2 0x09B009CD), (_ucs2 0x09F009CD), (_ucs2 0x09B209CD), (_ucs2 0x09F109CD), (_ucs2 0x09B609CD), (_ucs2 0x09B709CD), (_ucs2 0x09B809CD), (_ucs2 0x09B909CD); INSERT INTO t1 VALUES (_ucs2 0x099509CD0985),(_ucs2 0x0995), (_ucs2 0x099509CD0986),(_ucs2 0x099509BE), (_ucs2 0x099509CD0987),(_ucs2 0x099509BF), (_ucs2 0x099509CD0988),(_ucs2 0x099509C0), (_ucs2 0x099509CD0989),(_ucs2 0x099509C1), (_ucs2 0x099509CD098A),(_ucs2 0x099509C2), (_ucs2 0x099509CD098B),(_ucs2 0x099509C3), (_ucs2 0x099509CD09E0),(_ucs2 0x099509C4), (_ucs2 0x099509CD098C),(_ucs2 0x099509E2), (_ucs2 0x099509CD09E1),(_ucs2 0x099509E3), (_ucs2 0x099509CD098F),(_ucs2 0x099509C7), (_ucs2 0x099509CD0990),(_ucs2 0x099509C8), (_ucs2 0x099509CD0993),(_ucs2 0x099509CB), (_ucs2 0x099509CD0994),(_ucs2 0x099509CC); SELECT HEX(WEIGHT_STRING(a)), HEX(CONVERT(a USING ucs2)), HEX(a) FROM t1 ORDER BY a, BINARY(a); HEX(WEIGHT_STRING(a)) HEX(CONVERT(a USING ucs2)) HEX(a) 15A2 0985 E0A685 15A3 0986 E0A686 15A4 0987 E0A687 15A5 0988 E0A688 15A6 0989 E0A689 15A7 098A E0A68A 15A8 098B E0A68B 15A9 09E0 E0A7A0 15AA 098C E0A68C 15AB 09E1 E0A7A1 15AC 098F E0A68F 15AD 0990 E0A690 15AE 0993 E0A693 15AF 0994 E0A694 15B0 0982 E0A682 15B1 0983 E0A683 15B2 0981 E0A681 15B3 099509CD E0A695E0A78D 15B315A2 0995 E0A695 15B315A2 099509CD0985 E0A695E0A78DE0A685 15B315A3 099509BE E0A695E0A6BE 15B315A3 099509CD0986 E0A695E0A78DE0A686 15B315A4 099509BF E0A695E0A6BF 15B315A4 099509CD0987 E0A695E0A78DE0A687 15B315A5 099509C0 E0A695E0A780 15B315A5 099509CD0988 E0A695E0A78DE0A688 15B315A6 099509C1 E0A695E0A781 15B315A6 099509CD0989 E0A695E0A78DE0A689 15B315A7 099509C2 E0A695E0A782 15B315A7 099509CD098A E0A695E0A78DE0A68A 15B315A8 099509C3 E0A695E0A783 15B315A8 099509CD098B E0A695E0A78DE0A68B 15B315A9 099509C4 E0A695E0A784 15B315A9 099509CD09E0 E0A695E0A78DE0A7A0 15B315AA 099509CD098C E0A695E0A78DE0A68C 15B315AA 099509E2 E0A695E0A7A2 15B315AB 099509CD09E1 E0A695E0A78DE0A7A1 15B315AB 099509E3 E0A695E0A7A3 15B315AC 099509C7 E0A695E0A787 15B315AC 099509CD098F E0A695E0A78DE0A68F 15B315AD 099509C8 E0A695E0A788 15B315AD 099509CD0990 E0A695E0A78DE0A690 15B315AE 099509CB E0A695E0A78B 15B315AE 099509CD0993 E0A695E0A78DE0A693 15B315AF 099509CC E0A695E0A78C 15B315AF 099509CD0994 E0A695E0A78DE0A694 15B4 099609CD E0A696E0A78D 15B5 099709CD E0A697E0A78D 15B6 099809CD E0A698E0A78D 15B7 099909CD E0A699E0A78D 15B8 099A09CD E0A69AE0A78D 15B9 099B09CD E0A69BE0A78D 15BA 099C09CD E0A69CE0A78D 15BB 099D09CD E0A69DE0A78D 15BC 099E09CD E0A69EE0A78D 15BD 099F09CD E0A69FE0A78D 15BE 09A009CD E0A6A0E0A78D 15BF 09A109CD E0A6A1E0A78D 15C0 09A209CD E0A6A2E0A78D 15C1 09A309CD E0A6A3E0A78D 15C2 09A409CD E0A6A4E0A78D 15C2 09A409CD200D E0A6A4E0A78DE2808D 15C2 09CE E0A78E 15C3 09A509CD E0A6A5E0A78D 15C4 09A609CD E0A6A6E0A78D 15C5 09A709CD E0A6A7E0A78D 15C6 09A809CD E0A6A8E0A78D 15C7 09AA09CD E0A6AAE0A78D 15C8 09AB09CD E0A6ABE0A78D 15C9 09AC09CD E0A6ACE0A78D 15CA 09AD09CD E0A6ADE0A78D 15CB 09AE09CD E0A6AEE0A78D 15CC 09AF09CD E0A6AFE0A78D 15CD 09B009CD E0A6B0E0A78D 15CE 09F009CD E0A7B0E0A78D 15CF 09B209CD E0A6B2E0A78D 15D0 09F109CD E0A7B1E0A78D 15D1 09B609CD E0A6B6E0A78D 15D2 09B709CD E0A6B7E0A78D 15D3 09B809CD E0A6B8E0A78D 15D4 09B909CD E0A6B9E0A78D SELECT HEX(WEIGHT_STRING(a)) as wa, GROUP_CONCAT(HEX(CONVERT(a USING ucs2)) ORDER BY LENGTH(a), BINARY a) FROM t1 GROUP BY a ORDER BY a; wa GROUP_CONCAT(HEX(CONVERT(a USING ucs2)) ORDER BY LENGTH(a), BINARY a) 15A2 0985 15A3 0986 15A4 0987 15A5 0988 15A6 0989 15A7 098A 15A8 098B 15A9 09E0 15AA 098C 15AB 09E1 15AC 098F 15AD 0990 15AE 0993 15AF 0994 15B0 0982 15B1 0983 15B2 0981 15B3 099509CD 15B315A2 0995,099509CD0985 15B315A3 099509BE,099509CD0986 15B315A4 099509BF,099509CD0987 15B315A5 099509C0,099509CD0988 15B315A6 099509C1,099509CD0989 15B315A7 099509C2,099509CD098A 15B315A8 099509C3,099509CD098B 15B315A9 099509C4,099509CD09E0 15B315AA 099509E2,099509CD098C 15B315AB 099509E3,099509CD09E1 15B315AC 099509C7,099509CD098F 15B315AD 099509C8,099509CD0990 15B315AE 099509CB,099509CD0993 15B315AF 099509CC,099509CD0994 15B4 099609CD 15B5 099709CD 15B6 099809CD 15B7 099909CD 15B8 099A09CD 15B9 099B09CD 15BA 099C09CD 15BB 099D09CD 15BC 099E09CD 15BD 099F09CD 15BE 09A009CD 15BF 09A109CD 15C0 09A209CD 15C1 09A309CD 15C2 09CE,09A409CD,09A409CD200D 15C3 09A509CD 15C4 09A609CD 15C5 09A709CD 15C6 09A809CD 15C7 09AA09CD 15C8 09AB09CD 15C9 09AC09CD 15CA 09AD09CD 15CB 09AE09CD 15CC 09AF09CD 15CD 09B009CD 15CE 09F009CD 15CF 09B209CD 15D0 09F109CD 15D1 09B609CD 15D2 09B709CD 15D3 09B809CD 15D4 09B909CD DROP TABLE t1; # # WL#5624, shift after, using expansion # SET NAMES utf8 COLLATE utf8_5624_5; CREATE TABLE t1 AS SELECT REPEAT(' ', 10) AS a LIMIT 0; INSERT INTO t1 VALUES ('0'),('1'),('0z'),(_ucs2 0x0030FF9D); INSERT INTO t1 VALUES ('a'),('b'),('c'),('d'),('e'),('f'),('g'),('h'),('i'); INSERT INTO t1 VALUES ('j'),('k'),('l'),('m'),('n'),('o'),('p'),('q'),('r'); INSERT INTO t1 VALUES ('s'),('t'),('u'),('v'),('w'),('x'),('y'),('z'); INSERT INTO t1 VALUES ('aa'),('aaa'); INSERT INTO t1 VALUES ('A'),('B'),('C'),('D'),('E'),('F'),('G'),('H'),('I'); INSERT INTO t1 VALUES ('J'),('K'),('L'),('M'),('N'),('O'),('P'),('Q'),('R'); INSERT INTO t1 VALUES ('S'),('T'),('U'),('V'),('W'),('X'),('Y'),('Z'); INSERT INTO t1 VALUES ('AA'),('AAA'); SELECT a, HEX(WEIGHT_STRING(a)) FROM t1 ORDER BY a, LENGTH(a), BINARY(a); a HEX(WEIGHT_STRING(a)) 0 0E29 0z 0E290E292357 0ン 0E291E81 a 0E29233E b 0E29233F c 0E292340 d 0E292341 e 0E292342 f 0E292343 g 0E292344 h 0E292345 i 0E292346 j 0E292347 k 0E292348 l 0E292349 m 0E29234A n 0E29234B o 0E29234C p 0E29234D q 0E29234E r 0E29234F s 0E292350 t 0E292351 u 0E292352 v 0E292353 w 0E292354 x 0E292355 y 0E292356 z 0E292357 aa 0E292358 aaa 0E292359 A 0E29333E B 0E29333F C 0E293340 D 0E293341 E 0E293342 F 0E293343 G 0E293344 H 0E293345 I 0E293346 J 0E293347 K 0E293348 L 0E293349 M 0E29334A N 0E29334B O 0E29334C P 0E29334D Q 0E29334E R 0E29334F S 0E293350 T 0E293351 U 0E293352 V 0E293353 W 0E293354 X 0E293355 Y 0E293356 Z 0E293357 AA 0E293358 AAA 0E293359 1 0E2A DROP TABLE t1; # # End of WL#5624 #
Close