Linux ip-172-26-2-223 5.4.0-1018-aws #18-Ubuntu SMP Wed Jun 24 01:15:00 UTC 2020 x86_64
Apache
: 172.26.2.223 | : 18.217.142.228
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-alter.test
--source include/have_innodb.inc SET NAMES utf8; CREATE TABLE t1 ( c1 INT PRIMARY KEY, c2 INT DEFAULT 1, ct TEXT, INDEX(c2)) ENGINE=InnoDB; INSERT INTO t1 SET c1=1; CREATE TABLE sys_tables SELECT * FROM INFORMATION_SCHEMA.INNODB_SYS_TABLES WHERE NAME LIKE 'test/t%'; CREATE TABLE sys_indexes SELECT i.* FROM INFORMATION_SCHEMA.INNODB_SYS_INDEXES i INNER JOIN sys_tables st ON i.TABLE_ID=st.TABLE_ID; CREATE TABLE t1p LIKE t1; CREATE TABLE t1c (c1 INT PRIMARY KEY, c2 INT, c3 INT, INDEX(c2), INDEX(c3), CONSTRAINT t1c2 FOREIGN KEY (c2) REFERENCES t1(c2), CONSTRAINT t1c3 FOREIGN KEY (c3) REFERENCES t1p(c2)) ENGINE=InnoDB; CREATE TABLE sys_foreign SELECT i.* FROM INFORMATION_SCHEMA.INNODB_SYS_FOREIGN i WHERE FOR_NAME LIKE 'test/t%'; SELECT i.* FROM INFORMATION_SCHEMA.INNODB_SYS_FOREIGN_COLS i INNER JOIN sys_foreign sf ON i.ID = sf.ID; -- source suite/innodb/include/innodb_dict.inc SHOW CREATE TABLE t1; ALTER TABLE t1 ALTER c2 DROP DEFAULT; SHOW CREATE TABLE t1; -- source suite/innodb/include/innodb_dict.inc # These should be no-op. ALTER TABLE t1 CHANGE c2 c2 INT AFTER c1; ALTER TABLE t1 CHANGE c1 c1 INT FIRST; -- source suite/innodb/include/innodb_dict.inc ALTER TABLE t1 CHANGE C2 c3 INT; -- source suite/innodb/include/innodb_dict.inc ALTER TABLE t1 CHANGE c3 C INT; -- source suite/innodb/include/innodb_dict.inc ALTER TABLE t1 CHANGE C Cöŀumň_TWO INT; SELECT i.* FROM INFORMATION_SCHEMA.INNODB_SYS_FOREIGN_COLS i INNER JOIN sys_foreign sf ON i.ID = sf.ID; -- source suite/innodb/include/innodb_dict.inc -- error ER_BAD_FIELD_ERROR ALTER TABLE t1 CHANGE cöĿǖmň_two c3 INT; ALTER TABLE t1 CHANGE cÖĿUMŇ_two c3 INT, RENAME TO t3; SELECT st.NAME, i.NAME FROM sys_tables st INNER JOIN INFORMATION_SCHEMA.INNODB_SYS_TABLES i ON i.TABLE_ID=st.TABLE_ID; SHOW CREATE TABLE t3; SHOW CREATE TABLE t1c; # The maximum column name length should be 64 characters. --error ER_TOO_LONG_IDENT ALTER TABLE t3 CHANGE c3 `12345678901234567890123456789012345678901234567890123456789012345` INT; ALTER TABLE t3 CHANGE c3 `1234567890123456789012345678901234567890123456789012345678901234` INT; SHOW CREATE TABLE t3; # Test the length limit with non-ASCII utf-8 characters. --error ER_TOO_LONG_IDENT ALTER TABLE t3 CHANGE `1234567890123456789012345678901234567890123456789012345678901234` `倀倁倂倃倄倅倆倇倈倉倊個倌倍倎倏倐們倒倓倔倕倖倗倘候倚倛倜倝倞借倠倡倢倣値倥倦倧倨倩倪倫倬倭倮倯倰倱倲倳倴倵倶倷倸倹债倻值倽倾倿偀` INT; --error ER_TOO_LONG_IDENT ALTER TABLE t3 CHANGE `1234567890123456789012345678901234567890123456789012345678901234` `倀倁倂倃倄倅倆倇倈倉倊個倌倍倎倏倐們倒倓倔倕倖倗倘候倚倛倜倝倞借倠倡倢倣値倥倦倧倨倩倪倫倬倭倮倯倰倱倲倳倴倵倶倷倸倹债倻值倽倾倿ä` INT; ALTER TABLE t3 CHANGE `1234567890123456789012345678901234567890123456789012345678901234` `倀倁倂倃倄倅倆倇倈倉倊個倌倍倎倏倐們倒倓倔倕倖倗倘候倚倛倜倝倞借倠倡倢倣値倥倦倧倨倩倪倫倬倭倮倯倰倱倲倳倴倵倶倷倸倹债倻值倽倾ä` INT; # check that the rename is case-insensitive (note the upper-case ä at end) ALTER TABLE t3 CHANGE `倀倁倂倃倄倅倆倇倈倉倊個倌倍倎倏倐們倒倓倔倕倖倗倘候倚倛倜倝倞借倠倡倢倣値倥倦倧倨倩倪倫倬倭倮倯倰倱倲倳倴倵倶倷倸倹债倻值倽倾Ä` c3 INT; # test with 4-byte UTF-8 (should be disallowed) --error ER_INVALID_CHARACTER_STRING ALTER TABLE t3 CHANGE c3 𐌀𐌁𐌂𐌃𐌄𐌅𐌆𐌇𐌈𐌉𐌊𐌋𐌌𐌍𐌎𐌏𐌐𐌑𐌒𐌓𐌔𐌕𐌖𐌗𐌘𐌙𐌚𐌛𐌜 INT; --error ER_INVALID_CHARACTER_STRING ALTER TABLE t3 CHANGE c3 😲 INT; ALTER TABLE t3 RENAME TO t2; SELECT st.NAME, i.NAME FROM sys_tables st INNER JOIN INFORMATION_SCHEMA.INNODB_SYS_TABLES i ON i.TABLE_ID=st.TABLE_ID; SHOW CREATE TABLE t2; RENAME TABLE t2 TO t1; SELECT st.NAME, i.NAME FROM sys_tables st INNER JOIN INFORMATION_SCHEMA.INNODB_SYS_TABLES i ON i.TABLE_ID=st.TABLE_ID; -- source suite/innodb/include/innodb_dict.inc --error ER_DROP_INDEX_FK ALTER TABLE t1 DROP INDEX c2; --error ER_CANT_DROP_FIELD_OR_KEY ALTER TABLE t1 DROP INDEX c4; --error ER_CANT_DROP_FIELD_OR_KEY ALTER TABLE t1c DROP FOREIGN KEY c2; --error ER_CANT_DROP_FIELD_OR_KEY ALTER TABLE t1c DROP FOREIGN KEY t1c2, DROP FOREIGN KEY c2; --error ER_CANT_DROP_FIELD_OR_KEY ALTER TABLE t1c DROP FOREIGN KEY t1c2, DROP FOREIGN KEY c2, DROP INDEX c2; --error ER_DROP_INDEX_FK ALTER TABLE t1c DROP INDEX c2; --error ER_CANT_DROP_FIELD_OR_KEY ALTER TABLE t1c DROP FOREIGN KEY ẗ1C2; SHOW CREATE TABLE t1c; SET foreign_key_checks=0; DROP TABLE t1p; SET foreign_key_checks=1; SHOW CREATE TABLE t1c; -- source suite/innodb/include/innodb_dict.inc CREATE TABLE t1p (c1 INT PRIMARY KEY, c2 INT, INDEX(c2)) ENGINE=InnoDB; --error ER_DROP_INDEX_FK ALTER TABLE t1c DROP INDEX C2, DROP INDEX C3; --error ER_DROP_INDEX_FK ALTER TABLE t1c DROP INDEX C3; SHOW CREATE TABLE t1c; -- source suite/innodb/include/innodb_dict.inc ALTER TABLE t1c DROP FOREIGN KEY t1C3; SHOW CREATE TABLE t1c; -- source suite/innodb/include/innodb_dict.inc ALTER TABLE t1c DROP INDEX c2, DROP FOREIGN KEY t1C2; SHOW CREATE TABLE t1c; -- source suite/innodb/include/innodb_dict.inc ALTER TABLE t1 DROP INDEX c2, CHANGE c3 c2 INT; -- source suite/innodb/include/innodb_dict.inc CREATE TABLE t1o LIKE t1; # This will implicitly add a FTS_DOC_ID column, which cannot be done online. --error ER_ALTER_OPERATION_NOT_SUPPORTED_REASON ALTER TABLE t1 ADD FULLTEXT INDEX (ct), CHANGE c1 pk INT, ALTER c2 SET DEFAULT 42, RENAME TO tt, ALGORITHM=INPLACE, LOCK=NONE; ALTER TABLE t1 ADD FULLTEXT INDEX (ct), CHANGE c1 pk INT, ALTER c2 SET DEFAULT 42, RENAME TO tt, ALGORITHM=INPLACE, LOCK=SHARED; # The output should be empty, because index->id was reassigned. -- source suite/innodb/include/innodb_dict.inc SHOW CREATE TABLE tt; # DB_ROW_ID, DB_TRX_ID, DB_ROLL_PTR are reserved InnoDB system column names. --error ER_WRONG_COLUMN_NAME ALTER TABLE t1o CHANGE c1 dB_row_Id INT, ALGORITHM=COPY; --error ER_WRONG_COLUMN_NAME ALTER TABLE t1o CHANGE c1 dB_row_Id INT, ALGORITHM=INPLACE; --error ER_WRONG_COLUMN_NAME ALTER TABLE t1o CHANGE c1 DB_TRX_ID INT; --error ER_WRONG_COLUMN_NAME ALTER TABLE t1o CHANGE c1 db_roll_ptr INT; --error ER_WRONG_COLUMN_NAME ALTER TABLE t1o ADD COLUMN DB_TRX_ID INT; --error ER_WRONG_COLUMN_NAME ALTER TABLE t1o ADD COLUMN db_roll_ptr INT; --error ER_INNODB_FT_WRONG_DOCID_COLUMN ALTER TABLE t1o ADD FULLTEXT INDEX(ct), ADD COLUMN FTS_DOC_ID BIGINT; --error ER_INNODB_FT_WRONG_DOCID_COLUMN ALTER TABLE t1o ADD FULLTEXT INDEX(ct), ADD COLUMN FTS_DOC_ID BIGINT UNSIGNED; ALTER TABLE t1o ADD FULLTEXT INDEX(ct), ADD COLUMN FTS_DOC_ID BIGINT UNSIGNED NOT NULL; --error ER_DUP_FIELDNAME ALTER TABLE t1o ADD FULLTEXT INDEX(ct), ADD COLUMN FTS_DOC_ID INT; --error ER_ALTER_OPERATION_NOT_SUPPORTED_REASON ALTER TABLE t1o DROP COLUMN FTS_DOC_ID, ALGORITHM=INPLACE; ALTER TABLE t1o DROP COLUMN FTS_DOC_ID, DROP INDEX ct, ALGORITHM=INPLACE; # This creates a hidden FTS_DOC_ID column. ALTER TABLE t1o ADD FULLTEXT INDEX(ct), ADD COLUMN cu TEXT; --error ER_ALTER_OPERATION_NOT_SUPPORTED_REASON ALTER TABLE t1o ADD FULLTEXT INDEX(cu), ADD COLUMN FTS_DOC_ID BIGINT, ALGORITHM=INPLACE; --error ER_WRONG_COLUMN_NAME ALTER TABLE t1o ADD FULLTEXT INDEX(cu), ADD COLUMN FTS_DOC_ID BIGINT; --error ER_ALTER_OPERATION_NOT_SUPPORTED_REASON ALTER TABLE t1o ADD FULLTEXT INDEX(cu), ADD COLUMN FTS_DOC_ID BIGINT UNSIGNED, ALGORITHM=INPLACE; --error ER_WRONG_COLUMN_NAME ALTER TABLE t1o ADD FULLTEXT INDEX(cu), ADD COLUMN FTS_DOC_ID BIGINT UNSIGNED; # This would drop the hidden FTS_DOC_ID column and create # a fulltext index on ct and another fulltext index on cu. --error ER_ALTER_OPERATION_NOT_SUPPORTED_REASON ALTER TABLE t1o ADD FULLTEXT INDEX(cu), ADD COLUMN FTS_DOC_ID BIGINT UNSIGNED NOT NULL, ALGORITHM=INPLACE; # Replace the hidden FTS_DOC_ID column with a user-visible one. # This used to work if there is at most one fulltext index. # Currently, we disallow native ALTER TABLE if the table # contains any FULLTEXT indexes. --error ER_ALTER_OPERATION_NOT_SUPPORTED_REASON ALTER TABLE t1o ADD COLUMN FTS_DOC_ID BIGINT UNSIGNED NOT NULL, ALGORITHM=INPLACE; ALTER TABLE t1o ADD COLUMN FTS_DOC_ID BIGINT UNSIGNED NOT NULL; # Replace the user-visible FTS_DOC_ID column with a hidden one. # We do not support this in-place. --error ER_ALTER_OPERATION_NOT_SUPPORTED_REASON ALTER TABLE t1o DROP COLUMN FTS_DOC_ID, ALGORITHM=INPLACE; ALTER TABLE t1o DROP COLUMN FTS_DOC_ID; # FTS_DOC_ID is the internal row identifier for full-text search. # It should be of type BIGINT UNSIGNED NOT NULL. --error ER_WRONG_COLUMN_NAME ALTER TABLE t1o ADD FULLTEXT INDEX(ct), CHANGE c1 FTS_DOC_ID INT, ALGORITHM=COPY; --error ER_WRONG_COLUMN_NAME ALTER TABLE t1o ADD FULLTEXT INDEX(ct), CHANGE c1 FTS_DOC_ID INT, ALGORITHM=INPLACE; --error ER_WRONG_COLUMN_NAME ALTER TABLE t1o ADD FULLTEXT INDEX(ct), CHANGE c1 FTS_Doc_ID INT, ALGORITHM=INPLACE; --error ER_ALTER_OPERATION_NOT_SUPPORTED_REASON ALTER TABLE t1o ADD FULLTEXT INDEX(ct), CHANGE c1 FTS_DOC_ID BIGINT UNSIGNED NOT NULL, ALGORITHM=INPLACE; CREATE TABLE t1n LIKE t1o; ALTER TABLE t1n ADD FULLTEXT INDEX(ct); --error ER_WRONG_COLUMN_NAME ALTER TABLE t1n CHANGE c1 Fts_DOC_ID INT, ALGORITHM=INPLACE; --error ER_WRONG_COLUMN_NAME ALTER TABLE t1n CHANGE c1 Fts_DOC_ID INT, ALGORITHM=COPY; --error ER_BAD_FIELD_ERROR ALTER TABLE t1n CHANGE FTS_DOC_ID c11 INT, ALGORITHM=INPLACE; ALTER TABLE t1n CHANGE c1 FTS_DOC_ïD INT, ALGORITHM=INPLACE; ALTER TABLE t1n CHANGE FTS_DOC_ÏD c1 INT, ALGORITHM=INPLACE; ALTER TABLE t1n CHANGE c1 c2 INT, CHANGE c2 ct INT, CHANGE ct c1 TEXT, ALGORITHM=INPLACE; SHOW CREATE TABLE t1n; ALTER TABLE t1n CHANGE c2 c1 INT, CHANGE ct c2 INT, CHANGE c1 ct TEXT, ALGORITHM=COPY; SHOW CREATE TABLE t1n; --error ER_KEY_COLUMN_DOES_NOT_EXITS ALTER TABLE t1n ADD INDEX(c2), CHANGE c2 c4 INT, ALGORITHM=INPLACE; --error ER_KEY_COLUMN_DOES_NOT_EXITS ALTER TABLE t1n ADD INDEX(c2), CHANGE c2 c4 INT, ALGORITHM=COPY; ALTER TABLE t1n ADD INDEX(c4), CHANGE c2 c4 INT, ALGORITHM=INPLACE; SHOW CREATE TABLE t1n; ALTER TABLE t1n DROP INDEX c4; --error ER_DUP_FIELDNAME ALTER TABLE t1n CHANGE c4 c1 INT, ADD INDEX(c1), ALGORITHM=INPLACE; ALTER TABLE t1n CHANGE c4 c11 INT, ADD INDEX(c11), ALGORITHM=INPLACE; SHOW CREATE TABLE t1n; DROP TABLE t1n; --error ER_ALTER_OPERATION_NOT_SUPPORTED_REASON ALTER TABLE t1o MODIFY c1 BIGINT UNSIGNED NOT NULL, DROP INDEX ct, ALGORITHM=INPLACE; # This will copy the table, removing the hidden FTS_DOC_ID column. ALTER TABLE t1o MODIFY c1 BIGINT UNSIGNED NOT NULL, DROP INDEX ct; ALTER TABLE t1o CHANGE c1 FTS_DOC_ID BIGINT UNSIGNED NOT NULL, ALGORITHM=INPLACE; ALTER TABLE t1o ADD FULLTEXT INDEX(ct), ALGORITHM=INPLACE; --error ER_ALTER_OPERATION_NOT_SUPPORTED_REASON ALTER TABLE t1o CHANGE FTS_DOC_ID foo_id BIGINT UNSIGNED NOT NULL, ALGORITHM=INPLACE; # This should not show duplicates. SELECT sc.pos FROM information_schema.innodb_sys_columns sc INNER JOIN information_schema.innodb_sys_tables st ON sc.TABLE_ID=st.TABLE_ID WHERE st.NAME='test/t1o' AND sc.NAME='FTS_DOC_ID'; SHOW CREATE TABLE t1o; ALTER TABLE t1o CHANGE FTS_DOC_ID foo_id BIGINT UNSIGNED NOT NULL, DROP INDEX ct, ALGORITHM=INPLACE; SHOW CREATE TABLE t1o; DROP TABLE t1c, t1p, sys_tables, sys_indexes, sys_foreign; # Check the internal schemata of tt, t1o. CREATE TABLE sys_tables SELECT * FROM INFORMATION_SCHEMA.INNODB_SYS_TABLES WHERE NAME='test/t1o'; CREATE TABLE sys_indexes SELECT i.* FROM INFORMATION_SCHEMA.INNODB_SYS_INDEXES i INNER JOIN sys_tables st ON i.TABLE_ID=st.TABLE_ID; CREATE TABLE sys_foreign SELECT i.* FROM INFORMATION_SCHEMA.INNODB_SYS_FOREIGN i WHERE FOR_NAME='test/t1o'; -- source suite/innodb/include/innodb_dict.inc # Ensure that there exists no hidden FTS_DOC_ID_INDEX on foo_id. ALTER TABLE t1o ADD UNIQUE INDEX FTS_DOC_ID_INDEX(FTS_DOC_ID), ADD FULLTEXT INDEX(ct), CHANGE foo_id FTS_DOC_ID BIGINT UNSIGNED NOT NULL; ALTER TABLE t1o DROP INDEX ct, DROP INDEX FTS_DOC_ID_INDEX, CHANGE FTS_DOC_ID foo_id BIGINT UNSIGNED NOT NULL; ALTER TABLE t1o ADD UNIQUE INDEX FTS_DOC_ID_INDEX(foo_id); ALTER TABLE t1o CHANGE foo_id FTS_DOC_ID BIGINT UNSIGNED NOT NULL, ADD FULLTEXT INDEX(ct); --error ER_ALTER_OPERATION_NOT_SUPPORTED_REASON ALTER TABLE t1o CHANGE FTS_DOC_ID foo_id BIGINT UNSIGNED NOT NULL, ALGORITHM=INPLACE; DROP TABLE sys_indexes; CREATE TABLE sys_indexes SELECT i.* FROM INFORMATION_SCHEMA.INNODB_SYS_INDEXES i INNER JOIN sys_tables st ON i.TABLE_ID=st.TABLE_ID; -- source suite/innodb/include/innodb_dict.inc DROP TABLE tt, t1o, sys_tables, sys_indexes, sys_foreign; CREATE TABLE t (t TEXT, FULLTEXT(t)) ENGINE=InnoDB; DROP INDEX t ON t; LET $regexp=/FTS_([0-9a-f_]+)([A-Z_]+)/FTS_AUX_\2/; --replace_regex $regexp SELECT SUBSTRING(name, LOCATE('_', name) - 3, 5) AS prefix, name FROM INFORMATION_SCHEMA.INNODB_SYS_TABLES WHERE name LIKE '%FTS_%' ORDER BY 1, 2; SELECT sc.pos, sc.NAME FROM information_schema.innodb_sys_columns sc INNER JOIN information_schema.innodb_sys_tables st ON sc.TABLE_ID=st.TABLE_ID WHERE st.NAME='test/t'; ALTER TABLE t ROW_FORMAT=REDUNDANT, ALGORITHM=INPLACE; --replace_regex $regexp SELECT SUBSTRING(name, LOCATE('_', name) - 3, 5) AS prefix, name FROM INFORMATION_SCHEMA.INNODB_SYS_TABLES WHERE name LIKE '%FTS_%' ORDER BY 1, 2; ALTER TABLE t ADD FULLTEXT INDEX(t); SELECT sc.pos, sc.NAME FROM information_schema.innodb_sys_columns sc INNER JOIN information_schema.innodb_sys_tables st ON sc.TABLE_ID=st.TABLE_ID WHERE st.NAME='test/t'; DROP TABLE t; --disable_query_log call mtr.add_suppression("deleting orphaned .ibd file"); --enable_query_log --echo # --echo # Bug #19465984 INNODB DATA DICTIONARY IS NOT UPDATED WHILE --echo # RENAMING THE COLUMN --echo # CREATE TABLE t1(c1 INT NOT NULL, PRIMARY KEY(c1))ENGINE=INNODB; CREATE TABLE t2(c2 INT NOT NULL, FOREIGN KEY(c2) REFERENCES t1(c1))ENGINE=INNODB; SHOW CREATE TABLE t1; SHOW CREATE TABLE t2; ALTER TABLE t1 CHANGE COLUMN c1 C1 INT; SHOW CREATE TABLE t1; SHOW CREATE TABLE t2; ALTER TABLE t1 CHANGE COLUMN C1 c5 INT; SHOW CREATE TABLE t1; SHOW CREATE TABLE t2; DROP TABLE t2, t1; --echo # --echo #BUG#21514135 SCHEMA MISMATCH ERROR WHEN IMPORTING TABLESPACE AFTER --echo #DROPPING AN INDEX --echo # let $source_db = source_db; let $dest_db = dest_db; eval CREATE DATABASE $source_db; eval CREATE DATABASE $dest_db; eval CREATE TABLE $source_db.t1 ( id int(11) NOT NULL, age int(11) DEFAULT NULL, name varchar(20), PRIMARY KEY (id), KEY index1 (age) ) ENGINE=InnoDB; eval ALTER TABLE $source_db.t1 DROP INDEX index1, ADD INDEX index2(name, age), algorithm=inplace; --source suite/innodb/include/import.inc eval ALTER TABLE $source_db.t1 DROP INDEX index2, algorithm=inplace; --source suite/innodb/include/import.inc eval DROP TABLE $source_db.t1; eval DROP DATABASE $source_db; eval DROP DATABASE $dest_db; --echo # --echo # Bug#22005726 ASSERT COL->ORD_PART IN ROW_BUILD_INDEX_ENTRY_LOW AT --echo # ROW0ROW.CC:299 --echo # USE test; CREATE TABLE t1 (col1 INT, col2 TEXT) ENGINE = InnoDB; INSERT INTO t1 (col1, col2) VALUES (2 , 'A'); ALTER TABLE t1 ADD KEY idx (col2(10)); INSERT INTO t1 (col1, col2) VALUES (2 , 'A'); --error ER_DUP_ENTRY ALTER TABLE t1 DROP KEY idx, ADD UNIQUE KEY uidx (col1); DELETE FROM t1 WHERE col1 = 2; DROP TABLE t1; --echo # --echo # BUG #26334149 MYSQL CRASHES WHEN FULL TEXT INDEXES IBD FILES ARE --echo # ORPHANED DUE TO RENAME TABLE --echo # CREATE DATABASE db1; USE db1; CREATE TABLE notes ( id int(11) NOT NULL AUTO_INCREMENT, body text COLLATE utf8_unicode_ci, PRIMARY KEY (id) ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; ALTER TABLE notes ADD FULLTEXT INDEX index_ft_body (body(255)); DROP INDEX index_ft_body ON notes; CREATE DATABASE db2; RENAME TABLE db1.notes TO db2.notes; DROP DATABASE db1; DROP DATABASE db2;
Close