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.138.119.75
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 /
t /
[ HOME SHELL ]
Name
Size
Permission
Action
add_foreign_key.test
1.35
KB
-rw-r--r--
alter_crash.test
6.71
KB
-rw-r--r--
alter_foreign_crash.test
956
B
-rw-r--r--
alter_kill-master.opt
68
B
-rw-r--r--
alter_kill.test
5.1
KB
-rw-r--r--
alter_missing_tablespace.test
3.05
KB
-rw-r--r--
alter_page_size.test
705
B
-rw-r--r--
alter_rename_existing.test
5.49
KB
-rw-r--r--
alter_rename_files.test
746
B
-rw-r--r--
alter_row_format.test
1.47
KB
-rw-r--r--
alter_table_redundant.test
481
B
-rw-r--r--
alter_table_stage_progress-mas...
53
B
-rw-r--r--
alter_table_stage_progress.tes...
1.04
KB
-rw-r--r--
analyze_index.test
994
B
-rw-r--r--
analyze_table.test
896
B
-rw-r--r--
attachable_trx.test
3.32
KB
-rw-r--r--
autoinc_debug.test
2.14
KB
-rw-r--r--
blob-crash-16k.test
2.66
KB
-rw-r--r--
blob-crash-4k.test
2.76
KB
-rw-r--r--
blob-crash.test
5.95
KB
-rw-r--r--
blob-update-debug.test
525
B
-rw-r--r--
blob_page_reserve.test
3.73
KB
-rw-r--r--
blob_redo-master.opt
57
B
-rw-r--r--
blob_redo.test
1.71
KB
-rw-r--r--
buf_pool_resize_oom-master.opt
37
B
-rw-r--r--
buf_pool_resize_oom.test
1.72
KB
-rw-r--r--
bulk_create_index_online.test
1.96
KB
-rw-r--r--
cascade_lock_wait.test
1014
B
-rw-r--r--
check_ibd_filesize_16k.test
1.89
KB
-rw-r--r--
check_sector_size-master.opt
125
B
-rw-r--r--
check_sector_size.test
1.95
KB
-rw-r--r--
checksum.test
681
B
-rw-r--r--
cmp_per_index-master.opt
63
B
-rw-r--r--
cmp_per_index.test
2.5
KB
-rw-r--r--
crc32_endianness.test
1.67
KB
-rw-r--r--
crc32_endianness.zip
1.86
KB
-rw-r--r--
create-index.test
314
B
-rw-r--r--
create_isl_with_direct-master....
31
B
-rw-r--r--
create_isl_with_direct.test
1.1
KB
-rw-r--r--
create_table.test
1.33
KB
-rw-r--r--
create_tablespace.test
36.63
KB
-rw-r--r--
create_tablespace_16k.test
26.23
KB
-rw-r--r--
create_tablespace_32k.test
3.97
KB
-rw-r--r--
create_tablespace_4k.test
14.72
KB
-rw-r--r--
create_tablespace_64k.test
4.12
KB
-rw-r--r--
create_tablespace_8k.test
19.2
KB
-rw-r--r--
create_tablespace_debug.test
3.97
KB
-rw-r--r--
create_tablespace_notembedded....
670
B
-rw-r--r--
create_tablespace_partition.te...
10.38
KB
-rw-r--r--
create_tablespace_replication....
1.76
KB
-rw-r--r--
deadlock_detect.test
921
B
-rw-r--r--
default_row_format.test
1.62
KB
-rw-r--r--
default_row_format_16k.test
9.49
KB
-rw-r--r--
default_row_format_compatibili...
5.75
KB
-rw-r--r--
default_row_format_tablespace....
1.16
KB
-rw-r--r--
deprecate_part_in_shared_ts.te...
4.38
KB
-rw-r--r--
disabled.def
404
B
-rw-r--r--
doublewrite.test
10.88
KB
-rw-r--r--
dropdb.test
251
B
-rw-r--r--
end_range_check.test
3.2
KB
-rw-r--r--
end_range_check_2.test
1.25
KB
-rw-r--r--
events-merge-tmp-path-master.o...
149
B
-rw-r--r--
events-merge-tmp-path.test
1.65
KB
-rw-r--r--
file_format_defaults-master.op...
122
B
-rw-r--r--
file_format_defaults.test
2.14
KB
-rw-r--r--
file_format_upgrade_16k.test
1.91
KB
-rw-r--r--
flush-hang.test
1.51
KB
-rw-r--r--
foreign_key.test
7.61
KB
-rw-r--r--
fts_exec_interrupt.test
961
B
-rw-r--r--
help_verbose.test
1.01
KB
-rw-r--r--
high_prio_trx_1.test
1.24
KB
-rw-r--r--
high_prio_trx_2.test
1.3
KB
-rw-r--r--
high_prio_trx_3.test
1.86
KB
-rw-r--r--
high_prio_trx_4.test
1.5
KB
-rw-r--r--
high_prio_trx_5.test
2.24
KB
-rw-r--r--
high_prio_trx_6.test
2
KB
-rw-r--r--
high_prio_trx_7.test
11.13
KB
-rw-r--r--
high_prio_trx_commit_crash.tes...
2.05
KB
-rw-r--r--
high_prio_trx_debug.test
1.6
KB
-rw-r--r--
high_prio_trx_fk.test
1.42
KB
-rw-r--r--
high_prio_trx_predicate.test
1.41
KB
-rw-r--r--
high_prio_trx_rpl.test
1.95
KB
-rw-r--r--
i_s_files_debug.test
751
B
-rw-r--r--
ibuf_not_empty-master.opt
30
B
-rw-r--r--
ibuf_not_empty.test
1.67
KB
-rw-r--r--
import.test
763
B
-rw-r--r--
import_compress_encrypt.test
6.84
KB
-rw-r--r--
import_compress_encrypt_upgrad...
2.46
KB
-rw-r--r--
import_export_4k.test
1.06
KB
-rw-r--r--
import_tablespace_page_corrupt...
1.2
KB
-rw-r--r--
import_tablespace_schema_missm...
3.56
KB
-rw-r--r--
import_update_stats.test
1.46
KB
-rw-r--r--
index-online-norebuild.test
1.8
KB
-rw-r--r--
index_length.test
1.28
KB
-rw-r--r--
index_merge_threshold.test
6.25
KB
-rw-r--r--
index_tree_operation.test
2.36
KB
-rw-r--r--
innodb-2byte-collation-master....
48
B
-rw-r--r--
innodb-2byte-collation.test
2.95
KB
-rw-r--r--
innodb-ac-non-locking-select.t...
3
KB
-rw-r--r--
innodb-alter-autoinc.test
2.53
KB
-rw-r--r--
innodb-alter-debug-wl6554-mast...
21
B
-rw-r--r--
innodb-alter-debug-wl6554.test
8.65
KB
-rw-r--r--
innodb-alter-debug.test
2.68
KB
-rw-r--r--
innodb-alter-nullable.test
1.93
KB
-rw-r--r--
innodb-alter-wl6554.test
2.26
KB
-rw-r--r--
innodb-alter.test
15.61
KB
-rw-r--r--
innodb-analyze.test
1.65
KB
-rw-r--r--
innodb-autoinc-18274.test
661
B
-rw-r--r--
innodb-autoinc-44030-master.op...
81
B
-rw-r--r--
innodb-autoinc-44030.test
1.61
KB
-rw-r--r--
innodb-autoinc-56228-master.op...
29
B
-rw-r--r--
innodb-autoinc-56228.test
784
B
-rw-r--r--
innodb-autoinc-master.opt
81
B
-rw-r--r--
innodb-autoinc-optimize.test
432
B
-rw-r--r--
innodb-autoinc.test
26.79
KB
-rw-r--r--
innodb-blob.test
6.62
KB
-rw-r--r--
innodb-bug-14068765.test
2.97
KB
-rw-r--r--
innodb-bug-14084530.test
966
B
-rw-r--r--
innodb-bug12552164.test
1.46
KB
-rw-r--r--
innodb-bug14219515.test
472
B
-rw-r--r--
innodb-change-buffer-recovery-...
92
B
-rw-r--r--
innodb-change-buffer-recovery....
2.3
KB
-rw-r--r--
innodb-consistent-master.opt
29
B
-rw-r--r--
innodb-consistent.test
1.24
KB
-rw-r--r--
innodb-import-partition-rpl.te...
3.46
KB
-rw-r--r--
innodb-import-partition.test
9.51
KB
-rw-r--r--
innodb-index-debug-master.opt
30
B
-rw-r--r--
innodb-index-debug.test
4.39
KB
-rw-r--r--
innodb-index-master.opt
30
B
-rw-r--r--
innodb-index-online-delete.tes...
1.06
KB
-rw-r--r--
innodb-index-online-fk.test
15.6
KB
-rw-r--r--
innodb-index-online-master.opt
127
B
-rw-r--r--
innodb-index-online-purge.test
2.07
KB
-rw-r--r--
innodb-index-online.test
13.83
KB
-rw-r--r--
innodb-index.test
33.48
KB
-rw-r--r--
innodb-index_ucs2.test
124
B
-rw-r--r--
innodb-isolation.test
11.03
KB
-rw-r--r--
innodb-large-prefix.test
1.13
KB
-rw-r--r--
innodb-lock-inherit-read_commi...
2.58
KB
-rw-r--r--
innodb-lock.test
4.86
KB
-rw-r--r--
innodb-master.opt
136
B
-rw-r--r--
innodb-multiple-tablespaces.te...
18.21
KB
-rw-r--r--
innodb-read-view.test
4.52
KB
-rw-r--r--
innodb-replace-debug.test
399
B
-rw-r--r--
innodb-semi-consistent-master....
29
B
-rw-r--r--
innodb-semi-consistent.test
1.83
KB
-rw-r--r--
innodb-status-output.test
2.86
KB
-rw-r--r--
innodb-system-table-view.test
5.99
KB
-rw-r--r--
innodb-table-online-master.opt
126
B
-rw-r--r--
innodb-table-online.test
11.63
KB
-rw-r--r--
innodb-timeout.test
3.63
KB
-rw-r--r--
innodb-truncate-debug.test
5.27
KB
-rw-r--r--
innodb-truncate.test
2.03
KB
-rw-r--r--
innodb-ucs2.test
11.43
KB
-rw-r--r--
innodb-update-insert.test
848
B
-rw-r--r--
innodb-wl5522-1.test
145
B
-rw-r--r--
innodb-wl5522-debug.test
31
KB
-rw-r--r--
innodb-wl5522.test
20.25
KB
-rw-r--r--
innodb-wl5980-alter.test
18.47
KB
-rw-r--r--
innodb-wl5980-debug.test
2.58
KB
-rw-r--r--
innodb-wl5980-discard.test
23.6
KB
-rw-r--r--
innodb-wl5980-linux-master.opt
28
B
-rw-r--r--
innodb-wl5980-linux.test
7.75
KB
-rw-r--r--
innodb-wl5980-windows-master.o...
28
B
-rw-r--r--
innodb-wl5980-windows.test
8.42
KB
-rw-r--r--
innodb-wl6045-1-master.opt
77
B
-rw-r--r--
innodb-wl6045-1.test
6.84
KB
-rw-r--r--
innodb-wl6045-linux.test
12.82
KB
-rw-r--r--
innodb-wl6445-1.test
21.96
KB
-rw-r--r--
innodb-wl6445-2.test
7.4
KB
-rw-r--r--
innodb-wl6445.test
2.3
KB
-rw-r--r--
innodb.test
79.88
KB
-rw-r--r--
innodb_32k.test
198
B
-rw-r--r--
innodb_64k-master.opt
29
B
-rw-r--r--
innodb_64k.test
663
B
-rw-r--r--
innodb_autoinc_lock_mode_zero-...
29
B
-rw-r--r--
innodb_autoinc_lock_mode_zero....
1.1
KB
-rw-r--r--
innodb_autoinc_reset.test
519
B
-rw-r--r--
innodb_buffer_pool_dump_pct.te...
4.74
KB
-rw-r--r--
innodb_buffer_pool_load-master...
30
B
-rw-r--r--
innodb_buffer_pool_load.test
7.62
KB
-rw-r--r--
innodb_buffer_pool_load_now-ma...
113
B
-rw-r--r--
innodb_buffer_pool_load_now.te...
5.88
KB
-rw-r--r--
innodb_buffer_pool_resize-mast...
29
B
-rw-r--r--
innodb_buffer_pool_resize.test
2.26
KB
-rw-r--r--
innodb_buffer_pool_resize_debu...
64
B
-rw-r--r--
innodb_buffer_pool_resize_debu...
7.37
KB
-rw-r--r--
innodb_buffer_pool_resize_with...
65
B
-rw-r--r--
innodb_buffer_pool_resize_with...
2.06
KB
-rw-r--r--
innodb_bug-13628249.test
2.26
KB
-rw-r--r--
innodb_bug11754376.test
406
B
-rw-r--r--
innodb_bug11766634-master.opt
16
B
-rw-r--r--
innodb_bug11766634.test
1.82
KB
-rw-r--r--
innodb_bug11789106.test
546
B
-rw-r--r--
innodb_bug11933790.test
928
B
-rw-r--r--
innodb_bug12400341-master.opt
75
B
-rw-r--r--
innodb_bug12400341.test
2.65
KB
-rw-r--r--
innodb_bug12429573.test
1.4
KB
-rw-r--r--
innodb_bug12661768.test
2.03
KB
-rw-r--r--
innodb_bug14006907.test
1.38
KB
-rw-r--r--
innodb_bug14007109.test
1.19
KB
-rw-r--r--
innodb_bug14007649.test
1.1
KB
-rw-r--r--
innodb_bug14147491-master.opt
103
B
-rw-r--r--
innodb_bug14147491.test
2.76
KB
-rw-r--r--
innodb_bug14169459.test
1.96
KB
-rw-r--r--
innodb_bug14676111.test
3.92
KB
-rw-r--r--
innodb_bug14704286.test
2.03
KB
-rw-r--r--
innodb_bug19164038-master.opt
30
B
-rw-r--r--
innodb_bug19164038.test
1.27
KB
-rw-r--r--
innodb_bug21704.test
1.66
KB
-rw-r--r--
innodb_bug30113362.test
6.65
KB
-rw-r--r--
innodb_bug30423.test
6.45
KB
-rw-r--r--
innodb_bug30594501-master.opt
31
B
-rw-r--r--
innodb_bug30594501.test
552
B
-rw-r--r--
innodb_bug30919-master.opt
29
B
-rw-r--r--
innodb_bug30919.test
2.31
KB
-rw-r--r--
innodb_bug31205266.test
1.56
KB
-rw-r--r--
innodb_bug34053.test
1.6
KB
-rw-r--r--
innodb_bug34300.test
881
B
-rw-r--r--
innodb_bug35220.test
416
B
-rw-r--r--
innodb_bug38231.test
1.64
KB
-rw-r--r--
innodb_bug39438-master.opt
26
B
-rw-r--r--
innodb_bug39438.test
2.19
KB
-rw-r--r--
innodb_bug40360.test
340
B
-rw-r--r--
innodb_bug40565.test
327
B
-rw-r--r--
innodb_bug41904.test
328
B
-rw-r--r--
innodb_bug42101-nonzero-master...
30
B
-rw-r--r--
innodb_bug42101-nonzero.test
653
B
-rw-r--r--
innodb_bug42101.test
577
B
-rw-r--r--
innodb_bug42419.test
2.19
KB
-rw-r--r--
innodb_bug44032.test
543
B
-rw-r--r--
innodb_bug44369.test
530
B
-rw-r--r--
innodb_bug44571.test
788
B
-rw-r--r--
innodb_bug45357.test
326
B
-rw-r--r--
innodb_bug46000.test
941
B
-rw-r--r--
innodb_bug46676.test
602
B
-rw-r--r--
innodb_bug47167-master.opt
16
B
-rw-r--r--
innodb_bug47167.test
1.41
KB
-rw-r--r--
innodb_bug47621.test
1.79
KB
-rw-r--r--
innodb_bug47622.test
1.58
KB
-rw-r--r--
innodb_bug47777.test
972
B
-rw-r--r--
innodb_bug48024.test
863
B
-rw-r--r--
innodb_bug49164.test
928
B
-rw-r--r--
innodb_bug51378.test
2.53
KB
-rw-r--r--
innodb_bug51920.test
988
B
-rw-r--r--
innodb_bug52199.test
210
B
-rw-r--r--
innodb_bug52663.test
1003
B
-rw-r--r--
innodb_bug53046.test
1.13
KB
-rw-r--r--
innodb_bug53290.test
840
B
-rw-r--r--
innodb_bug53592.test
2.6
KB
-rw-r--r--
innodb_bug53674-master.opt
65
B
-rw-r--r--
innodb_bug53674.test
259
B
-rw-r--r--
innodb_bug53756-master.opt
36
B
-rw-r--r--
innodb_bug53756.test
4.62
KB
-rw-r--r--
innodb_bug54044.test
606
B
-rw-r--r--
innodb_bug56143.test
74.27
KB
-rw-r--r--
innodb_bug56716.test
268
B
-rw-r--r--
innodb_bug56947.test
472
B
-rw-r--r--
innodb_bug57252.test
1.27
KB
-rw-r--r--
innodb_bug57255.test
889
B
-rw-r--r--
innodb_bug57904.test
908
B
-rw-r--r--
innodb_bug59307.test
633
B
-rw-r--r--
innodb_bug59410.test
926
B
-rw-r--r--
innodb_bug59641.test
1.17
KB
-rw-r--r--
innodb_bug59733.test
2
KB
-rw-r--r--
innodb_bug60049-master.opt
25
B
-rw-r--r--
innodb_bug60049.test
1.76
KB
-rw-r--r--
innodb_bug60196-master.opt
27
B
-rw-r--r--
innodb_bug60196.test
3.15
KB
-rw-r--r--
innodb_bug60229.test
1.34
KB
-rw-r--r--
innodb_bug70867.test
1.29
KB
-rw-r--r--
innodb_bulk_create_index.test
1.89
KB
-rw-r--r--
innodb_bulk_create_index_debug...
651
B
-rw-r--r--
innodb_bulk_create_index_flush...
1.34
KB
-rw-r--r--
innodb_bulk_create_index_repli...
4.66
KB
-rw-r--r--
innodb_bulk_create_index_small...
2.81
KB
-rw-r--r--
innodb_corrupt_bit.test
2.67
KB
-rw-r--r--
innodb_corrupt_readonly.test
1.34
KB
-rw-r--r--
innodb_ctype_ldml-master.opt
80
B
-rw-r--r--
innodb_ctype_ldml.test
15.36
KB
-rw-r--r--
innodb_deadlock_with_autoinc-m...
29
B
-rw-r--r--
innodb_deadlock_with_autoinc.t...
1.22
KB
-rw-r--r--
innodb_file_format-master.opt
16
B
-rw-r--r--
innodb_file_format.test
1.32
KB
-rw-r--r--
innodb_file_limit_check.test
829
B
-rw-r--r--
innodb_force_recovery.test
3.19
KB
-rw-r--r--
innodb_fts_limit_check.test
891
B
-rw-r--r--
innodb_i_s_innodb_locks.test
4.54
KB
-rw-r--r--
innodb_i_s_innodb_trx.test
2.36
KB
-rw-r--r--
innodb_information_schema_buff...
2.39
KB
-rw-r--r--
innodb_io_pf.test
398
B
-rw-r--r--
innodb_lock_wait_timeout_1-mas...
29
B
-rw-r--r--
innodb_lock_wait_timeout_1.tes...
8.06
KB
-rw-r--r--
innodb_misc1-master.opt
55
B
-rw-r--r--
innodb_misc1.test
31.97
KB
-rw-r--r--
innodb_multi_update.test
2.04
KB
-rw-r--r--
innodb_mysql-master.opt
82
B
-rw-r--r--
innodb_mysql.test
27.09
KB
-rw-r--r--
innodb_mysql_rbk-master.opt
60
B
-rw-r--r--
innodb_mysql_rbk.test
849
B
-rw-r--r--
innodb_notembedded.test
1.13
KB
-rw-r--r--
innodb_page_size_func.test
11.26
KB
-rw-r--r--
innodb_pagesize_max_recordsize...
17.3
KB
-rw-r--r--
innodb_prefix_index_check.test
1.25
KB
-rw-r--r--
innodb_prefix_index_restart_se...
3.51
KB
-rw-r--r--
innodb_rename_index.test
16.76
KB
-rw-r--r--
innodb_rename_index_err.test
2.01
KB
-rw-r--r--
innodb_replace.test
5.42
KB
-rw-r--r--
innodb_row_log_read.test
1.42
KB
-rw-r--r--
innodb_stats.test
1.89
KB
-rw-r--r--
innodb_stats_auto_recalc.test
1.76
KB
-rw-r--r--
innodb_stats_auto_recalc_ddl.t...
1.65
KB
-rw-r--r--
innodb_stats_auto_recalc_lots....
932
B
-rw-r--r--
innodb_stats_auto_recalc_on_no...
1.87
KB
-rw-r--r--
innodb_stats_create_on_corrupt...
1.32
KB
-rw-r--r--
innodb_stats_create_table.test
1.43
KB
-rw-r--r--
innodb_stats_del_mark-master.o...
40
B
-rw-r--r--
innodb_stats_del_mark.test
3.6
KB
-rw-r--r--
innodb_stats_drop_locked.test
1.41
KB
-rw-r--r--
innodb_stats_external_pages.te...
2.62
KB
-rw-r--r--
innodb_stats_fetch.test
2.13
KB
-rw-r--r--
innodb_stats_fetch_corrupted.t...
1.64
KB
-rw-r--r--
innodb_stats_fetch_nonexistent...
1.14
KB
-rw-r--r--
innodb_stats_flag_global_off-m...
28
B
-rw-r--r--
innodb_stats_flag_global_off.t...
324
B
-rw-r--r--
innodb_stats_flag_global_on-ma...
28
B
-rw-r--r--
innodb_stats_flag_global_on.te...
323
B
-rw-r--r--
innodb_stats_rename_table.test
1.25
KB
-rw-r--r--
innodb_stats_rename_table_if_e...
1.43
KB
-rw-r--r--
innodb_stats_sample_pages.test
1.72
KB
-rw-r--r--
innodb_stats_table_flag_auto_r...
2.23
KB
-rw-r--r--
innodb_stats_table_flag_sample...
2.73
KB
-rw-r--r--
innodb_sys_var_valgrind.test
1.99
KB
-rw-r--r--
innodb_tablespace.test
13.91
KB
-rw-r--r--
innodb_tablespace_zip.test
1.32
KB
-rw-r--r--
innodb_thread_concurrency_debu...
1.16
KB
-rw-r--r--
innodb_timeout_rollback-master...
58
B
-rw-r--r--
innodb_timeout_rollback.test
108
B
-rw-r--r--
innodb_trx_weight.test
3.72
KB
-rw-r--r--
innodb_upd_stats_if_needed_not...
1.04
KB
-rw-r--r--
innodb_ut_format_name.test
298
B
-rw-r--r--
innodb_wl6326.test
14.46
KB
-rw-r--r--
innodb_wl6326_big.test
24.37
KB
-rw-r--r--
innodb_wl6469_1.test
2.08
KB
-rw-r--r--
innodb_wl6469_debug.test
2.94
KB
-rw-r--r--
innodb_wl6470.test
4.42
KB
-rw-r--r--
innodb_wl6470_debug.test
1.78
KB
-rw-r--r--
innodb_wl6501_crash_1.test
798
B
-rw-r--r--
innodb_wl6501_crash_2.test
798
B
-rw-r--r--
innodb_wl6501_crash_6.test
713
B
-rw-r--r--
innodb_wl6501_crash_7.test
713
B
-rw-r--r--
innodb_wl6501_crash_8.test
2.39
KB
-rw-r--r--
innodb_wl6560_1.test
11.71
KB
-rw-r--r--
innodb_wl6560_debug.test
5.9
KB
-rw-r--r--
innodb_wl6915.test
3.99
KB
-rw-r--r--
innodb_wl6915_debug.test
5.43
KB
-rw-r--r--
innodb_wl8114.test
1.52
KB
-rw-r--r--
insert_debug.test
1.13
KB
-rw-r--r--
iodku.test
5.65
KB
-rw-r--r--
iodku_debug.test
6.38
KB
-rw-r--r--
log_alter_table.test
1.81
KB
-rw-r--r--
log_corruption.test
7.06
KB
-rw-r--r--
log_corruption.zip
92.47
KB
-rw-r--r--
log_corruption0.zip
1.18
KB
-rw-r--r--
log_corruption1.zip
1.23
KB
-rw-r--r--
log_corruption2.zip
1.27
KB
-rw-r--r--
log_corruption3.zip
1.27
KB
-rw-r--r--
log_corruption4.zip
1.28
KB
-rw-r--r--
log_corruption4a.zip
1.28
KB
-rw-r--r--
log_corruption5.zip
1.28
KB
-rw-r--r--
log_corruption6.zip
1.28
KB
-rw-r--r--
log_file.test
8.9
KB
-rw-r--r--
log_file_name.test
9.17
KB
-rw-r--r--
log_file_name_debug.test
751
B
-rw-r--r--
log_file_size.test
6.3
KB
-rw-r--r--
log_file_size_1-master.opt
14
B
-rw-r--r--
log_file_size_1.test
8.45
KB
-rw-r--r--
log_file_size_checkpoint.test
1.14
KB
-rw-r--r--
missing_tablespaces.test
2.34
KB
-rw-r--r--
monitor.test
13.96
KB
-rw-r--r--
monitor_restart.test
807
B
-rw-r--r--
mysqldump_max_recordsize.test
13.96
KB
-rw-r--r--
optimizer_temporary_table-mast...
15
B
-rw-r--r--
optimizer_temporary_table.test
4.63
KB
-rw-r--r--
page_reorganize.test
1.31
KB
-rw-r--r--
partition-blob.test
1.43
KB
-rw-r--r--
partition-upgrade.test
7.46
KB
-rw-r--r--
partition.test
20.89
KB
-rw-r--r--
portability_wl5980_linux.zip
473.02
KB
-rw-r--r--
portability_wl5980_windows.zip
514.24
KB
-rw-r--r--
readahead.test
679
B
-rw-r--r--
readonly.test
1.17
KB
-rw-r--r--
records_in_range.test
24.93
KB
-rw-r--r--
redo_log_during_checkpoint.tes...
2.59
KB
-rw-r--r--
rename_table.test
914
B
-rw-r--r--
row_format_redundant.test
2.71
KB
-rw-r--r--
sp_temp_table.test
2.51
KB
-rw-r--r--
stored_fk.test
3.46
KB
-rw-r--r--
strict_checksum.test
2.95
KB
-rw-r--r--
strict_mode.test
3.33
KB
-rw-r--r--
sys_tablestats.test
1.01
KB
-rw-r--r--
table_compress.test
14.09
KB
-rw-r--r--
table_encrypt_1.test
10.06
KB
-rw-r--r--
table_encrypt_2-master.opt
94
B
-rw-r--r--
table_encrypt_2.test
5.46
KB
-rw-r--r--
table_encrypt_3.test
31.16
KB
-rw-r--r--
table_encrypt_4.test
6.83
KB
-rw-r--r--
table_encrypt_5-master.opt
20
B
-rw-r--r--
table_encrypt_5.test
30.54
KB
-rw-r--r--
table_encrypt_debug.test
6.16
KB
-rw-r--r--
table_encrypt_fts.test
3.22
KB
-rw-r--r--
table_encrypt_kill.test
15.3
KB
-rw-r--r--
table_encryption-master.opt
20
B
-rw-r--r--
table_encryption.test
3.25
KB
-rw-r--r--
tablespace_crash.test
7.61
KB
-rw-r--r--
tablespace_embedded.test
246
B
-rw-r--r--
tablespace_embedded_windows.te...
242
B
-rw-r--r--
tablespace_per_table.test
13.03
KB
-rw-r--r--
tablespace_per_table_not_windo...
6.58
KB
-rw-r--r--
tablespace_per_table_windows.t...
3.13
KB
-rw-r--r--
tablespace_portability.test
1.64
KB
-rw-r--r--
tablespace_portability_windows...
751
B
-rw-r--r--
timestamp.test
787
B
-rw-r--r--
tinytext-groupby.test
1.26
KB
-rw-r--r--
tmpdir.test
1.9
KB
-rw-r--r--
trx_id_future.test
1.8
KB
-rw-r--r--
undo.test
1.48
KB
-rw-r--r--
update-cascade.test
6.46
KB
-rw-r--r--
update_time-master.opt
30
B
-rw-r--r--
update_time.test
2.25
KB
-rw-r--r--
update_time_wl6658.test
8.3
KB
-rw-r--r--
virtual_basic.test
44.54
KB
-rw-r--r--
virtual_blob.test
468
B
-rw-r--r--
virtual_debug.test
18.75
KB
-rw-r--r--
virtual_debug_purge.test
4.27
KB
-rw-r--r--
virtual_fk.test
25.3
KB
-rw-r--r--
virtual_fk_restart.test
1.59
KB
-rw-r--r--
virtual_index.test
8.38
KB
-rw-r--r--
virtual_purge.test
3.21
KB
-rw-r--r--
virtual_stats.test
1.43
KB
-rw-r--r--
xa_prepare_lock_release.test
1.57
KB
-rw-r--r--
xa_recovery.test
894
B
-rw-r--r--
xa_recovery_debug.test
989
B
-rw-r--r--
Delete
Unzip
Zip
${this.title}
Close
Code Editor : innodb-index.test
-- source include/no_valgrind_without_big.inc -- source include/have_innodb.inc let $MYSQLD_DATADIR= `select @@datadir`; SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS; # Bug#13654923 BOGUS DEBUG ASSERTION IN INDEX CREATION FOR ZERO-LENGTH RECORD create table t1(a varchar(2) primary key) engine=innodb; insert into t1 values(''); --enable_info create index t1a1 on t1(a(1)); --disable_info drop table t1; create table t1(a int not null, b int, c char(10) not null, d varchar(20)) engine = innodb; insert into t1 values (5,5,'oo','oo'),(4,4,'tr','tr'),(3,4,'ad','ad'),(2,3,'ak','ak'); commit; --error ER_DUP_KEYNAME alter table t1 add index b (b), add index b (b); --error ER_DUP_FIELDNAME alter table t1 add index (b,b); --enable_info alter table t1 add index d2 (d); --disable_info show create table t1; -- disable_result_log analyze table t1; -- enable_result_log explain select * from t1 force index(d2) order by d; select * from t1 force index (d2) order by d; --error ER_DUP_ENTRY alter table t1 add unique index (b); show create table t1; --enable_info alter table t1 add index (b); --disable_info show create table t1; --enable_info alter table t1 add unique index (c), add index (d); --disable_info show create table t1; analyze table t1; explain select * from t1 force index(c) order by c; --enable_info alter table t1 add primary key (a), drop index c; show create table t1; --error ER_MULTIPLE_PRI_KEY alter table t1 add primary key (c); --error ER_DUP_ENTRY alter table t1 drop primary key, add primary key (b); create unique index c on t1 (c); --disable_info show create table t1; analyze table t1; explain select * from t1 force index(c) order by c; select * from t1 force index(c) order by c; --enable_info alter table t1 drop index b, add index (b); --disable_info show create table t1; insert into t1 values(6,1,'ggg','ggg'); select * from t1; select * from t1 force index(b) order by b; select * from t1 force index(c) order by c; select * from t1 force index(d) order by d; -- disable_result_log analyze table t1; -- enable_result_log explain select * from t1 force index(b) order by b; explain select * from t1 force index(c) order by c; explain select * from t1 force index(d) order by d; show create table t1; drop table t1; create table t1(a int not null, b int, c char(10), d varchar(20), primary key (a)) engine = innodb; insert into t1 values (1,1,'ab','ab'),(2,2,'ac','ac'),(3,3,'ad','ad'),(4,4,'afe','afe'); commit; --enable_info alter table t1 add index (c(2)); show create table t1; alter table t1 add unique index (d(10)); show create table t1; --disable_info insert into t1 values(5,1,'ggg','ggg'); -- disable_result_log analyze table t1; -- enable_result_log select * from t1; select * from t1 force index(c) order by c; select * from t1 force index(d) order by d; explain select * from t1 order by b; explain select * from t1 force index(c) order by c; explain select * from t1 force index(d) order by d; show create table t1; --enable_info alter table t1 drop index d; --disable_info insert into t1 values(8,9,'fff','fff'); select * from t1; select * from t1 force index(c) order by c; -- disable_result_log analyze table t1; -- enable_result_log explain select * from t1 order by b; explain select * from t1 force index(c) order by c; explain select * from t1 order by d; show create table t1; drop table t1; create table t1(a int not null, b int, c char(10), d varchar(20), primary key (a)) engine = innodb; insert into t1 values (1,1,'ab','ab'),(2,2,'ac','ac'),(3,2,'ad','ad'),(4,4,'afe','afe'); commit; --enable_info alter table t1 add unique index (b,c); --disable_info insert into t1 values(8,9,'fff','fff'); select * from t1; select * from t1 force index(b) order by b; -- disable_result_log analyze table t1; -- enable_result_log explain select * from t1 force index(b) order by b; show create table t1; --enable_info alter table t1 add index (b,c); --disable_info insert into t1 values(11,11,'kkk','kkk'); select * from t1; select * from t1 force index(b) order by b; -- disable_result_log analyze table t1; -- enable_result_log explain select * from t1 force index(b) order by b; show create table t1; --enable_info alter table t1 add unique index (c,d); --disable_info insert into t1 values(13,13,'yyy','aaa'); select * from t1; select * from t1 force index(b) order by b; select * from t1 force index(c) order by c; -- disable_result_log analyze table t1; -- enable_result_log explain select * from t1 force index(b) order by b; explain select * from t1 force index(c) order by c; show create table t1; drop table t1; create table t1(a int not null, b int not null, c int, primary key (a), key (b)) engine = innodb; create table t3(a int not null, c int not null, d int, primary key (a), key (c)) engine = innodb; create table t4(a int not null, d int not null, e int, primary key (a), key (d)) engine = innodb; create table t2(a int not null, b int, c int, d int, e int, foreign key (b) references t1(b) on delete set null, foreign key (c) references t3(c), foreign key (d) references t4(d) on update set null) engine = innodb; --error ER_DROP_INDEX_FK alter table t1 drop index b; --error ER_DROP_INDEX_FK alter table t3 drop index c; --error ER_DROP_INDEX_FK alter table t4 drop index d; --error ER_DROP_INDEX_FK alter table t2 drop index b; --error ER_DROP_INDEX_FK alter table t2 drop index b, drop index c, drop index d; --error ER_FK_COLUMN_CANNOT_CHANGE alter table t2 MODIFY b INT NOT NULL, ALGORITHM=COPY; # NULL -> NOT NULL only allowed INPLACE if strict sql_mode is on. --error ER_FK_COLUMN_NOT_NULL alter table t2 MODIFY b INT NOT NULL, ALGORITHM=INPLACE; SET FOREIGN_KEY_CHECKS=0; --error ER_FK_COLUMN_CANNOT_DROP alter table t2 DROP COLUMN b, ALGORITHM=COPY; --error ER_DROP_INDEX_FK alter table t2 DROP COLUMN b; --error ER_FK_COLUMN_CANNOT_DROP_CHILD alter table t1 DROP COLUMN b, ALGORITHM=COPY; --error ER_DROP_INDEX_FK alter table t1 DROP COLUMN b; SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS; --enable_info # Apparently, the following makes mysql_alter_table() drop index d. create unique index dc on t2 (d,c); create index dc on t1 (b,c); # This should preserve the foreign key constraints. --disable_info # NULL -> NOT NULL only allowed INPLACE if strict sql_mode is on. # And adding a PRIMARY KEY will also add NOT NULL implicitly! --enable_info --error ER_FK_COLUMN_NOT_NULL alter table t2 add primary key (alpha), change a alpha int, change b beta int not null, change c charlie int not null; --error ER_FK_COLUMN_NOT_NULL alter table t2 add primary key (alpha), change a alpha int, change c charlie int not null, change d delta int not null; alter table t2 add primary key (alpha), change a alpha int, change b beta int, modify c int not null; --disable_info insert into t1 values (1,1,1); insert into t3 values (1,1,1); insert into t4 values (1,1,1); insert into t2 values (1,1,1,1,1); commit; --enable_info alter table t4 add constraint dc foreign key (a) references t1(a); --disable_info show create table t4; # mysqltest first does replace_regex, then replace_result --replace_regex /#sql-[0-9a-f_]*'/#sql-temporary'/ # Embedded server doesn't chdir to data directory --replace_result $MYSQLD_DATADIR ./ master-data/ '' # a foreign key 'test/dc' already exists --error ER_DUP_KEY alter table t3 add constraint dc foreign key (a) references t1(a); SET FOREIGN_KEY_CHECKS=0; --error ER_FK_FAIL_ADD_SYSTEM alter table t3 add constraint dc foreign key (a) references t1(a); SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS; show create table t3; --enable_info alter table t2 drop index b, add index (beta); --disable_info show create table t2; --error ER_ROW_IS_REFERENCED_2 delete from t1; --error ER_CANT_DROP_FIELD_OR_KEY drop index dc on t4; --enable_info --error ER_CANT_DROP_FIELD_OR_KEY alter table t3 drop foreign key dc; alter table t4 drop foreign key dc; --disable_info select * from t2; delete from t1; select * from t2; drop table t2,t4,t3,t1; -- let charset = utf8 -- source include/innodb-index.inc create table t1(a int not null, b int) engine = innodb; insert into t1 values (1,1),(1,1),(1,1),(1,1); --error ER_DUP_ENTRY alter table t1 add unique index (a); --error ER_DUP_ENTRY alter table t1 add unique index (b); --error ER_DUP_ENTRY alter table t1 add unique index (a), add unique index(b); show create table t1; drop table t1; create table t1(a int not null, c int not null,b int, primary key(a), unique key(c), key(b)) engine = innodb; alter table t1 drop index c, drop index b; show create table t1; drop table t1; create table t1(a int not null, b int, primary key(a)) engine = innodb; alter table t1 add index (b); show create table t1; drop table t1; create table t1(a int not null, b int, c char(10), d varchar(20), primary key (a)) engine = innodb; insert into t1 values (1,1,'ab','ab'),(2,2,'ac','ac'),(3,3,'ac','ac'),(4,4,'afe','afe'),(5,4,'affe','affe'); --error ER_DUP_ENTRY alter table t1 add unique index (b), add unique index (c), add unique index (d); --error ER_DUP_ENTRY alter table t1 add unique index (c), add unique index (b), add index (d); show create table t1; drop table t1; create table t1(a int not null, b int not null, c int, primary key (a), key(c)) engine=innodb; insert into t1 values (5,1,5),(4,2,4),(3,3,3),(2,4,2),(1,5,1); --enable_info alter table t1 add unique index (b); --disable_info insert into t1 values (10,20,20),(11,19,19),(12,18,18),(13,17,17); show create table t1; check table t1; -- disable_result_log analyze table t1; -- enable_result_log explain select * from t1 force index(c) order by c; explain select * from t1 order by a; explain select * from t1 force index(b) order by b; select * from t1 order by a; select * from t1 force index(b) order by b; select * from t1 force index(c) order by c; drop table t1; create table t1(a int not null, b int not null) engine=innodb; insert into t1 values (1,1); --enable_info alter table t1 add primary key(b); --disable_info insert into t1 values (2,2); show create table t1; check table t1; select * from t1; analyze table t1; explain select * from t1; explain select * from t1 order by a; explain select * from t1 order by b; checksum table t1; drop table t1; create table t1(a int not null) engine=innodb; insert into t1 values (1); --enable_info alter table t1 add primary key(a); --disable_info insert into t1 values (2); show create table t1; check table t1; commit; select * from t1; analyze table t1; explain select * from t1; explain select * from t1 order by a; drop table t1; # # Test to check whether CREATE INDEX handles implicit foreign key # constraint modifications (Issue #70, Bug #38786) # SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0; SET FOREIGN_KEY_CHECKS=0; CREATE TABLE t1( c1 BIGINT(12) NOT NULL, PRIMARY KEY (c1) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; CREATE TABLE t2( c1 BIGINT(16) NOT NULL, c2 BIGINT(12) NOT NULL, c3 BIGINT(12) NOT NULL, PRIMARY KEY (c1) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; ALTER TABLE t2 ADD CONSTRAINT fk_t2_ca FOREIGN KEY (c3) REFERENCES t1(c1); SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS; SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS; SHOW CREATE TABLE t2; CREATE INDEX i_t2_c3_c2 ON t2(c3, c2); SHOW CREATE TABLE t2; SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS; SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS; --error ER_NO_REFERENCED_ROW_2 INSERT INTO t2 VALUES(0,0,0); INSERT INTO t1 VALUES(0); INSERT INTO t2 VALUES(0,0,0); DROP TABLE t2; CREATE TABLE t2( c1 BIGINT(16) NOT NULL, c2 BIGINT(12) NOT NULL, c3 BIGINT(12) NOT NULL, PRIMARY KEY (c1,c2,c3) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; SET FOREIGN_KEY_CHECKS=0; ALTER TABLE t2 ADD CONSTRAINT fk_t2_ca FOREIGN KEY (c3) REFERENCES t1(c1); SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS; SHOW CREATE TABLE t2; CREATE INDEX i_t2_c3_c2 ON t2(c3, c2); SHOW CREATE TABLE t2; --error ER_NO_REFERENCED_ROW_2 INSERT INTO t2 VALUES(0,0,1); INSERT INTO t2 VALUES(0,0,0); --error ER_ROW_IS_REFERENCED_2 DELETE FROM t1; DELETE FROM t2; DROP TABLE t2; DROP TABLE t1; CREATE TABLE t1( c1 BIGINT(12) NOT NULL, c2 INT(4) NOT NULL, PRIMARY KEY (c2,c1) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; CREATE TABLE t2( c1 BIGINT(16) NOT NULL, c2 BIGINT(12) NOT NULL, c3 BIGINT(12) NOT NULL, PRIMARY KEY (c1) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; SET FOREIGN_KEY_CHECKS=0; --enable_info # mysqltest first does replace_regex, then replace_result --replace_regex /#sql-[0-9a-f_]*'/#sql-temporary'/ # Embedded server doesn't chdir to data directory --replace_result $MYSQLD_DATADIR ./ master-data/ '' --error ER_CANNOT_ADD_FOREIGN ALTER TABLE t2 ADD CONSTRAINT fk_t2_ca FOREIGN KEY (c3,c2) REFERENCES t1(c1,c1), ALGORITHM=COPY; --error ER_FK_NO_INDEX_PARENT ALTER TABLE t2 ADD CONSTRAINT fk_t2_ca FOREIGN KEY (c3,c2) REFERENCES t1(c1,c1); # mysqltest first does replace_regex, then replace_result --replace_regex /#sql-[0-9a-f_]*'/#sql-temporary'/ # Embedded server doesn't chdir to data directory --replace_result $MYSQLD_DATADIR ./ master-data/ '' --error ER_CANNOT_ADD_FOREIGN ALTER TABLE t2 ADD CONSTRAINT fk_t2_ca FOREIGN KEY (c3,c2) REFERENCES t1(c1,c2), ALGORITHM=COPY; --error ER_FK_NO_INDEX_PARENT ALTER TABLE t2 ADD CONSTRAINT fk_t2_ca FOREIGN KEY (c3,c2) REFERENCES t1(c1,c2); --error ER_FK_INCORRECT_OPTION ALTER TABLE t2 ADD CONSTRAINT fk_t2_ca FOREIGN KEY (c3,c2) REFERENCES t1(c2,c1), ALGORITHM=INPLACE; # mysqltest first does replace_regex, then replace_result --replace_regex /#sql-[0-9a-f_]*'/#sql-temporary'/ # Embedded server doesn't chdir to data directory --replace_result $MYSQLD_DATADIR ./ master-data/ '' --error ER_CANNOT_ADD_FOREIGN ALTER TABLE t2 ADD CONSTRAINT fk_t2_ca FOREIGN KEY (c3,c2) REFERENCES t1(c2,c1), ALGORITHM=COPY; ALTER TABLE t1 MODIFY COLUMN c2 BIGINT(12) NOT NULL; # mysqltest first does replace_regex, then replace_result --replace_regex /#sql-[0-9a-f_]*'/#sql-temporary'/ # Embedded server doesn't chdir to data directory --replace_result $MYSQLD_DATADIR ./ master-data/ '' --error ER_CANNOT_ADD_FOREIGN ALTER TABLE t2 ADD CONSTRAINT fk_t2_ca FOREIGN KEY (c3,c2) REFERENCES t1(c1,c2), ALGORITHM=COPY; --error ER_FK_NO_INDEX_PARENT ALTER TABLE t2 ADD CONSTRAINT fk_t2_ca FOREIGN KEY (c3,c2) REFERENCES t1(c1,c2); ALTER TABLE t2 ADD CONSTRAINT fk_t2_ca FOREIGN KEY (c3,c2) REFERENCES t1(c2,c1); SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS; SHOW CREATE TABLE t1; SHOW CREATE TABLE t2; CREATE INDEX i_t2_c2_c1 ON t2(c2, c1); SHOW CREATE TABLE t2; CREATE INDEX i_t2_c3_c1_c2 ON t2(c3, c1, c2); SHOW CREATE TABLE t2; CREATE INDEX i_t2_c3_c2 ON t2(c3, c2); SHOW CREATE TABLE t2; --disable_info DROP TABLE t2; DROP TABLE t1; connect (a,localhost,root,,); connect (b,localhost,root,,); connection a; CREATE TABLE t1 (a INT, b CHAR(1)) ENGINE=InnoDB; INSERT INTO t1 VALUES (3,'a'),(3,'b'),(1,'c'),(0,'d'),(1,'e'); CREATE TABLE t2 (a INT, b CHAR(1)) ENGINE=InnoDB; CREATE TABLE t2i (a INT, b CHAR(1) NOT NULL) ENGINE=InnoDB; CREATE TABLE t2c (a INT, b CHAR(1) NOT NULL) ENGINE=InnoDB; INSERT INTO t2 SELECT * FROM t1; INSERT INTO t2i SELECT * FROM t1; INSERT INTO t2c SELECT * FROM t1; connection b; BEGIN; # This acquires a MDL lock on t1 until commit. SELECT * FROM t1; connection a; # This times out before of the MDL lock held by connection b. SET lock_wait_timeout=1; --error ER_LOCK_WAIT_TIMEOUT CREATE INDEX t1a ON t1(a); --enable_info CREATE INDEX t2a ON t2(a); # NULL -> NOT NULL only allowed INPLACE if strict sql_mode is on. # And adding a PRIMARY KEY will also add NOT NULL implicitly! ALTER TABLE t2i ADD PRIMARY KEY(a,b), ADD INDEX t2a(a), ALGORITHM=INPLACE; ALTER TABLE t2c ADD PRIMARY KEY(a,b), ADD INDEX t2a(a), ALGORITHM=COPY; --disable_info connection b; # t2i and t2c are too new for this transaction, because they were rebuilt --error ER_TABLE_DEF_CHANGED SELECT * FROM t2i; --error ER_TABLE_DEF_CHANGED SELECT * FROM t2i FORCE INDEX(t2a) ORDER BY a; --error ER_TABLE_DEF_CHANGED SELECT * FROM t2c; --error ER_TABLE_DEF_CHANGED SELECT * FROM t2c FORCE INDEX(t2a) ORDER BY a; # In t2, only the new index t2a is too new for this transaction. SELECT * FROM t2; --error ER_TABLE_DEF_CHANGED SELECT * FROM t2 FORCE INDEX(t2a) ORDER BY a; SELECT * FROM t2; COMMIT; # For a new transaction, all of t2, t2i, t2c are accessible. SELECT * FROM t2; SELECT * FROM t2 FORCE INDEX(t2a) ORDER BY a; SELECT * FROM t2i; SELECT * FROM t2i FORCE INDEX(t2a) ORDER BY a; SELECT * FROM t2c; SELECT * FROM t2c FORCE INDEX(t2a) ORDER BY a; connection default; disconnect a; disconnect b; --error ER_DUP_KEYNAME alter table t2 add index t2a(b); alter table t2 drop index t2a, add index t2a(b); show create table t2; show create table t2i; show create table t2c; --disable_info DROP TABLE t1,t2,t2c,t2i; --echo # --echo # Bug #17657223 EXCESSIVE TEMPORARY FILE USAGE IN ALTER TABLE --echo # SET GLOBAL innodb_monitor_enable = module_ddl; let $innodb_metrics_select= SELECT name, count_reset FROM INFORMATION_SCHEMA.INNODB_METRICS WHERE subsystem = 'ddl' and count_reset > 0; # Table with Blob data. create table t1(f1 int not null, f2 blob)engine=innodb; insert into t1 values(1, repeat('a',20000)); --echo # Skip sort --echo # Reusing the same pk --enable_info alter table t1 force; --disable_info eval $innodb_metrics_select; SET GLOBAL innodb_monitor_reset = module_ddl; drop table t1; # Table with small data. create table t1(f1 int not null, f2 int not null, primary key(f1))engine=innodb; insert into t1 values(1,2), (3,4); --echo # Add Secondary index. --echo # Skip temp file usage due to small table size --enable_info alter table t1 add key(f2); --disable_info eval $innodb_metrics_select; SET GLOBAL innodb_monitor_reset = module_ddl; drop table t1; # Table with large data which is greater than sort buffer create table t480(a serial)engine=innodb; insert into t480 values(),(),(),(),(),(),(),(),(),(),(),(),(),(),(),(),(),(),(),(),(),(), (),(),(),(),(),(),(),(); insert into t480 select 0 from t480; insert into t480 select 0 from t480; insert into t480 select 0 from t480; insert into t480 select 0 from t480; create table t1(f1 int auto_increment not null, f2 char(200) not null, f3 char(200) not null, f4 char(200) not null,primary key(f1))engine=innodb; insert into t1 select NULL,'aaa','bbb','ccc' from t480; insert into t1 select NULL,'aaaa','bbbb','cccc' from t480; insert into t1 select NULL,'aaaaa','bbbbb','ccccc' from t480; insert into t1 select NULL,'aaaaaa','bbbbbb','cccccc' from t480; insert into t1 select NULL,'aaaaaaa','bbbbbbb','ccccccc' from t480; insert into t1 select NULL,'aaaaaaaa','bbbbbbbb','cccccccc' from t480; select count(*) from t1; --echo # Skip sort --echo # Change PK from (f1) to (f1,f2,f3,f4) --enable_info alter table t1 drop primary key, add primary key(f1,f2,f3,f4); --disable_info eval $innodb_metrics_select; SET GLOBAL innodb_monitor_reset = module_ddl; # Temp file not used during clustered index rebuild # for the following alter table commands. --echo # Skip sort --echo # Change PK from (f1,f2,f3,f4) to (f1,f2,added_columns) --enable_info alter table t1 drop primary key,add column f5 int not null, add column f6 int not null,add primary key(f1,f2,f5,f6); --disable_info eval $innodb_metrics_select; SET GLOBAL innodb_monitor_reset = module_ddl; --echo # Skip sort --echo # Change PK from (f1,f2,f5,f6) to (f1,f2,f5) --enable_info alter table t1 drop column f6; --disable_info eval $innodb_metrics_select; SET GLOBAL innodb_monitor_reset = module_ddl; --echo # Skip sort --echo # Reusing the same PK --enable_info alter table t1 add column f6 int; --disable_info eval $innodb_metrics_select; SET GLOBAL innodb_monitor_reset = module_ddl; --echo # Skip sort --echo # Reusing the same pk --enable_info alter table t1 drop column f6; --disable_info eval $innodb_metrics_select; SET GLOBAL innodb_monitor_reset = module_ddl; --echo # Must sort --echo # Change PK from (f1,f2,f5) to (f1,f5) --enable_info alter table t1 drop column f2; --disable_info eval $innodb_metrics_select; SET GLOBAL innodb_monitor_reset = module_ddl; --echo # Skip sort --echo # Reusing the same pk --enable_info alter table t1 add column f2n int after f1, drop primary key, add primary key (f1,f5,f2n); --disable_info eval $innodb_metrics_select; SET GLOBAL innodb_monitor_reset = module_ddl; --echo # Skip sort --echo # Reusing the same pk --enable_info alter table t1 change f5 f2n int not null,change f2n f5 int not null, add column f8 int not null; --disable_info eval $innodb_metrics_select; SET GLOBAL innodb_monitor_reset = module_ddl; --echo # Skip sort --echo # Change PK from (f1,f4,f2n) to (f1,f4,added_column,f2n) --enable_info alter table t1 add column f7 int, drop primary key, add primary key (f1,f5,f7,f2n); --disable_info eval $innodb_metrics_select; SET GLOBAL innodb_monitor_reset = module_ddl; --echo # Skip sort --echo # Reusing the same pk --enable_info alter table t1 force; --disable_info eval $innodb_metrics_select; SET GLOBAL innodb_monitor_reset = module_ddl; --echo # Skip sort --echo # Reusing the same pk --enable_info alter table t1 row_format=compact; --disable_info eval $innodb_metrics_select; SET GLOBAL innodb_monitor_reset = module_ddl; --echo # Skip sort --echo # Reusing the same pk --enable_info alter table t1 engine=innodb; --disable_info eval $innodb_metrics_select; SET GLOBAL innodb_monitor_reset = module_ddl; --echo # Skip sort --echo # Optimize table --enable_info optimize table t1; --disable_info eval $innodb_metrics_select; SET GLOBAL innodb_monitor_reset = module_ddl; --echo # Sort files used for adding secondary index --enable_info alter table t1 drop primary key, add primary key(f1,f5,f7), add index i(f3); --disable_info eval $innodb_metrics_select; SET GLOBAL innodb_monitor_reset = module_ddl; --echo # No sort files used for dropping secondary index --enable_info alter table t1 drop primary key, add primary key(f1,f5),drop index i; --disable_info eval $innodb_metrics_select; SET GLOBAL innodb_monitor_reset = module_ddl; --echo # Skip sort --echo # Change PK(f1,f5) to (f1,added_columns) and drop f5 --enable_info alter table t1 drop primary key, add primary key(f1,f12), drop column f5, add column f12 int not null; --disable_info eval $innodb_metrics_select; SET GLOBAL innodb_monitor_reset = module_ddl; --echo # Must sort --echo # Change PK(f1,f12) to (f1,existing_columns) --enable_info alter table t1 drop primary key, add primary key(f1,f3); --disable_info eval $innodb_metrics_select; SET GLOBAL innodb_monitor_reset = module_ddl; --echo # Skip sort --echo # Change PK(f1,f3) to (f1,added_column,f3,added_column) --enable_info alter table t1 drop primary key, add column f3n int, add column f4n int, add primary key(f1,f3n,f3,f4n); --disable_info eval $innodb_metrics_select; SET GLOBAL innodb_monitor_reset = module_ddl; --echo # Adding Secondary index alone. --enable_info alter table t1 add key(f1); --disable_info eval $innodb_metrics_select; SET GLOBAL innodb_monitor_reset = module_ddl; --echo # Must sort --echo # Change PK(f1,f3) to (existing_column,f1) --enable_info alter table t1 drop primary key, add primary key(f4,f1); --disable_info eval $innodb_metrics_select; SET GLOBAL innodb_monitor_reset = module_ddl; --echo # Skip sort for PK. --echo # Change PK(f4,f1) to (added_columns,f4,f1) --echo # Secondary index rebuild happens --enable_info alter table t1 drop primary key, add column f5n int, add column f6n int, add primary key(f5n,f6n,f4,f1); --disable_info eval $innodb_metrics_select; SET GLOBAL innodb_monitor_reset = module_ddl; --echo # Skip sort for PK. --echo # Change PK(f5n,f6n,f4,f1) to --echo # (added_columns,f5n,added_column,f6n,f4,f1) --echo # Secondary index rebuild happens --enable_info alter table t1 drop primary key, add column f7n int, add column f8n int, add primary key(f7n,f5n,f8n,f6n,f4,f1); --disable_info eval $innodb_metrics_select; SET GLOBAL innodb_monitor_reset = module_ddl; SET GLOBAL innodb_monitor_disable = module_ddl; select count(*) from t1; drop table t1; --disable_warnings SET GLOBAL innodb_monitor_reset = default; SET GLOBAL innodb_monitor_enable = default; SET GLOBAL innodb_monitor_disable = default; --enable_warnings --echo # Bug#19163915 INNODB: DUPLICATE RECORDS COULD EXIST --echo # WHEN SKIPPING SORT FOR CLUSTER INDEX # last mtuple in previous buffer and first mtuple in next buffer # are equal. SELECT @@innodb_sort_buffer_size; create table t1(f1 int auto_increment not null, f2 char(200) not null, f3 char(200) not null, f4 char(200) not null,primary key(f1,f2,f3,f4)); insert into t1 select NULL,'aaa','bbb','ccc' from t480; insert into t1 values(106, 'aaa','bbb','cccc'); select count(*) from t1; --echo # Skip sort --echo # Change PK from (f1,f2,f3,f4) to (f1,f2,f3) --error ER_DUP_ENTRY alter table t1 drop primary key, add primary key(f1,f2,f3); select count(*) from t1; drop table t1; # Duplicates exist with in the buffer create table t1(f1 int auto_increment not null, f2 char(200) not null, f3 char(200) not null, f4 char(200) not null,primary key(f1,f2,f3,f4)); insert into t1 select NULL,'aaa','bbb','ccc' from t480; insert into t1 values(108,'aaa','bbb','cccc'); select count(*) from t1; --error ER_DUP_ENTRY alter table t1 drop primary key, add primary key(f1,f2,f3); select count(*) from t1; drop table t1, t480; --echo # --echo # Bug #19896922 SORTING SKIPPED WHEN PREFIX LENGTH OF THE PK --echo # FIELD IS CHANGED --echo # # Prefix length changes for the varchar column. create table t1(a int not null, b varchar(30) not null, primary key (b(10), a)) engine = innodb; insert into t1 values(0,'khdHps6UxW8Lwaoxa604oK6zkb'),(1,'khdHps6UxW8L'); select * from t1; alter table t1 drop primary key, add primary key (b(18),a); select * from t1; drop table t1; create table t1(a int not null, b varchar(30) not null, primary key (b(10), a)) engine = innodb; insert into t1 values(0,'khdHps6UxW8Lwaoxa604oK6zkb'),(1,'khdHps6UtW8L'); select * from t1; alter table t1 drop primary key, add primary key (b(8),a); select * from t1; drop table t1; --echo # --echo # Bug #21103101 SORTING SKIPPED WHEN DROPPING THE SINGLE --echo # COLUMN PRIMARY KEY --echo # # Drop primary key column. create table t1(f1 int not null, f2 int not null, primary key (f1), unique key(f1, f2))engine=innodb; insert into t1 values(1,3), (2,2); alter table t1 drop column f1; drop table t1; # Drop Primary key when lock is none. create table t1(f1 int not null, f2 int not null, primary key (f1), unique key(f1, f2))engine=innodb; insert into t1 values(1,3), (2,2); --error ER_ALTER_OPERATION_NOT_SUPPORTED_REASON alter table t1 drop primary key, lock=none; drop table t1; --echo # --echo # BUG#21612714 ALTER TABLE SORTING SKIPPED WHEN CHANGE PK AND DROP --echo # LAST COLUMN OF OLD PK --echo # # no skip sort cases # pk(o1,o2) to pk(o1,o3), drop o2 create table t1(o1 int, o2 int, o3 int not null, primary key(o1,o2)) engine = innodb; insert into t1 values(1,1,2),(1,2,1); alter table t1 drop primary key, add primary key(o1,o3), drop o2, lock=none; drop table t1; # pk(o1,o2) to pk(o3), drop o1, o2 create table t1(o1 int, o2 int, o3 int not null, primary key(o1,o2)) engine = innodb; insert into t1 values(1,1,2),(1,2,1); alter table t1 drop o1, drop o2, add primary key(o3), lock=none; drop table t1; # pk(o1,o2) to pk(o1,o3) create table t1(o1 int, o2 int, o3 int not null, primary key(o1,o2)) engine = innodb; insert into t1 values(1,1,2),(1,2,1); alter table t1 drop primary key, add primary key(o1,o3), lock=none; drop table t1; # pk(o1,o2) to pk(o3) create table t1(o1 int, o2 int, o3 int not null, primary key(o1,o2)) engine = innodb; insert into t1 values(1,1,2),(1,2,1); alter table t1 drop primary key, add primary key(o3), lock=none; drop table t1; # pk(o1,o2) to pk(n1,o3) create table t1(o1 int, o2 int, o3 int not null, primary key(o1,o2)) engine = innodb; insert into t1 values(1,1,2),(1,2,1); alter table t1 add column n1 int not null, drop primary key, add primary key(n1,o3), lock=none; drop table t1; # pk(o1,o2) to pk(o3,n1) create table t1(o1 int, o2 int, o3 int not null, primary key(o1,o2)) engine = innodb; insert into t1 values(1,1,2),(2,2,1); alter table t1 add column n1 int not null, drop primary key, add primary key(o3,n1), lock=none; drop table t1; # pk(o1,o2) to pk(o2,o1) create table t1(o1 int, o2 int, o3 int not null, primary key(o1,o2)) engine = innodb; insert into t1 values(1,2,2),(2,1,1); alter table t1 drop primary key, add primary key(o2, o1), lock=none; drop table t1; # pk(o1,o2) to pk(o2) create table t1(o1 int, o2 int, o3 int not null, primary key(o1,o2)) engine = innodb; insert into t1 values(1,2,2),(2,1,1); alter table t1 drop primary key, add primary key(o2), lock=none; drop table t1; # pk(o1,o2) to pk(o2,o3) create table t1(o1 int, o2 int, o3 int not null, primary key(o1,o2)) engine = innodb; insert into t1 values(1,2,2),(2,1,1); alter table t1 drop primary key, add primary key(o2,o3), lock=none; drop table t1; # pk(o2,o1) to pk(o2,o3) create table t1(o1 int, o2 int, o3 int not null, primary key(o2,o1)) engine = innodb; insert into t1 values(1,1,2),(2,1,1); alter table t1 drop primary key, add primary key(o2,o3), lock=none; drop table t1; # pk(o1,o2) to pk(o1,o3,o2) create table t1(o1 int, o2 int, o3 int not null, primary key(o1,o2)) engine = innodb; insert into t1 values(1,1,2),(1,2,1); alter table t1 drop primary key, add primary key(o1,o3,o2), lock=none; drop table t1; # pk(o1,o2) to pk(o3,o1,o2) create table t1(o1 int, o2 int, o3 int not null, primary key(o1,o2)) engine = innodb; insert into t1 values(1,2,2),(2,1,1); alter table t1 drop primary key, add primary key(o3,o1,o2), lock=none; drop table t1; # pk(o1,o2,o3) to pk(o1,o3) create table t1(o1 int, o2 int, o3 int, primary key(o1,o2,o3)) engine = innodb; insert into t1 values(1,1,2),(1,2,1); alter table t1 drop primary key, add primary key(o1,o3), lock=none; drop table t1; # pk(o1,o2,o3) to pk(o2,o3) by drop o1 create table t1(o1 int, o2 int, o3 int, primary key(o1,o2,o3)) engine = innodb; insert into t1 values(1,2,2),(2,1,1); alter table t1 drop o1, lock=none; drop table t1; # pk(o1,o2,o3) to pk(o1,o3) by drop o2 create table t1(o1 int, o2 int, o3 int, primary key(o1,o2,o3)) engine = innodb; insert into t1 values(1,1,2),(1,2,1); alter table t1 drop o2, lock=none; drop table t1; # pk(o1,o2,o3) to pk(o3) by drop o1,o2 create table t1(o1 int, o2 int, o3 int, primary key(o1,o2,o3)) engine = innodb; insert into t1 values(1,2,2),(2,1,1); alter table t1 drop o1, drop o2, lock=none; drop table t1; # no skip sort for prefix change # pk(o1(2),o2) to pk(o1(3),o2) create table t1(o1 varchar(10), o2 int, o3 int not null, primary key(o1(2), o2)) engine = innodb; insert into t1 values('abd', 1, 1), ('abc', 2, 2); alter table t1 drop primary key, add primary key(o1(3), o2), lock=none; drop table t1; # pk(o1(2),o2) to pk(o1,o2) create table t1(o1 varchar(10), o2 int, o3 int not null, primary key(o1(2), o2)) engine = innodb; insert into t1 values('abd', 1, 1), ('abc', 2, 2); alter table t1 drop primary key, add primary key(o1, o2), lock=none; drop table t1; # pk(o1(2),o2) to pk(o1(3),o3) create table t1(o1 varchar(10), o2 int, o3 int not null, primary key(o1(2), o2)) engine = innodb; insert into t1 values('abd', 1, 1), ('abc', 2, 2); alter table t1 drop primary key, add primary key(o1(3), o3), lock=none; drop table t1; # pk(o1(2),o2) to pk(o1,o3) create table t1(o1 varchar(10), o2 int, o3 int not null, primary key(o1(2), o2)) engine = innodb; insert into t1 values('abd', 1, 1), ('abc', 2, 2); alter table t1 drop primary key, add primary key(o1, o3), lock=none; drop table t1; # pk(o1(3),o2) to pk(o1(2),o2) create table t1(o1 varchar(10), o2 int, o3 int not null, primary key(o1(3), o2)) engine = innodb; insert into t1 values('abc', 2, 1), ('abd', 1, 2); alter table t1 drop primary key, add primary key(o1(2), o2), lock=none; drop table t1; # pk(o1,o2) to pk(o1(2),o2) create table t1(o1 varchar(10), o2 int, o3 int not null, primary key(o1, o2)) engine = innodb; insert into t1 values('abc', 2, 1), ('abd', 1, 2); alter table t1 drop primary key, add primary key(o1(2), o2), lock=none; drop table t1; # pk(o1(3),o2) to pk(o1(2),o3) create table t1(o1 varchar(10), o2 int, o3 int not null, primary key(o1(3), o2)) engine = innodb; insert into t1 values('abc', 2, 2), ('abd', 1, 1); alter table t1 drop primary key, add primary key(o1(2), o3), lock=none; drop table t1; # pk(o1,o2) to pk(o1(2),o3) create table t1(o1 varchar(10), o2 int, o3 int not null, primary key(o1, o2)) engine = innodb; insert into t1 values('abc', 2, 2), ('abd', 1, 1); alter table t1 drop primary key, add primary key(o1(2), o3), lock=none; drop table t1; # pk(o1,o2(2),o3) to pk(o1,o2(3)) create table t1(o1 int, o2 varchar(10), o3 int, primary key(o1,o2(2),o3)) engine = innodb; insert into t1 values(1, 'abd', 1), (1, 'abc', 2); alter table t1 drop primary key, add primary key(o1,o2(3)), lock=none; drop table t1; # pk(o1,o2(2),o3) to pk(o1,o2) create table t1(o1 int, o2 varchar(10), o3 int, primary key(o1,o2(2),o3)) engine = innodb; insert into t1 values(1, 'abd', 1), (1, 'abc', 2); alter table t1 drop primary key, add primary key(o1,o2), lock=none; drop table t1; # pk(o1(3),o2(3)) to pk(o1(2),o2(3)) create table t1(o1 varchar(10), o2 varchar(10), primary key(o1(3),o2(3))) engine = innodb; insert into t1 values('abc', 'acd'), ('abd', 'abd'); alter table t1 drop primary key, add primary key(o1(2),o2(3)), lock=none; drop table t1; # pk(o1,o2) to pk(o1(2),o2) create table t1(o1 varchar(10), o2 varchar(10), primary key(o1,o2)) engine = innodb; insert into t1 values('abc', 'acd'), ('abd', 'abd'); alter table t1 drop primary key, add primary key(o1(2),o2), lock=none; drop table t1; # pk(o1(3),o2(3)) to pk(o2(3),o1(3)) create table t1(o1 varchar(10), o2 varchar(10), primary key(o1(3),o2(3))) engine = innodb; insert into t1 values('abd', 'acd'), ('acd', 'abd'); alter table t1 drop primary key, add primary key(o2(3),o1(3)), lock=none; drop table t1; # pk(o1,o2) to pk(o2,o1) create table t1(o1 varchar(10), o2 varchar(10), primary key(o1,o2)) engine = innodb; insert into t1 values('abd', 'acd'), ('acd', 'abd'); alter table t1 drop primary key, add primary key(o2,o1), lock=none; drop table t1; # no skip sort cases --source suite/innodb/include/alter_table_pk_no_sort.inc
Close