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.142.124.139
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 : partition.test
--source include/have_innodb.inc --echo # --echo # Test of optimizer estimates --echo # CREATE TABLE t0 (a int PRIMARY KEY, b int, c varchar(64)); CREATE TABLE t1 (a int, b int, c varchar(64), PRIMARY KEY (a), KEY (b), KEY (c,b)) ENGINE = InnoDB PARTITION BY HASH (a) PARTITIONS 5; --echo # Set up the rows so that the following query would match --echo # 100 PK values but only 10 'b' values. But 90 of the matching --echo # PKs will be in the smallest partition. --echo # Since the fix for bug#1364811 will ha_partition only check the biggest --echo # partitions, but ha_innopart will check all partitions when estimating --echo # numbers of records in range. Resulting in ha_partition will --echo # assume there are only 10 matching PK values and choose to do search --echo # by PK but ha_innopart will search by secondary index 'b' since it --echo # will prefer to read 10 records from the secondary index over reading --echo # 100 records from the PRIMARY index. --echo # SELECT * FROM t1 WHERE a BETWEEN 1 AND 450 AND b BETWEEN 1 AND 10; --echo # Using t0 to prevent any issues with purge in t1. INSERT INTO t0 VALUES (1,0,"common"),(2,0,"common"),(3,0,"common"), (4,0,"common"),(5,0,"common"), (6,0,"common"),(7,0,"common"),(8,0,"common"), (9,0,"common"),(10,0,"common"); INSERT INTO t0 SELECT a + 10, b, c FROM t0; INSERT INTO t0 SELECT a + 20, b, c FROM t0; INSERT INTO t0 SELECT a + 40, b, c FROM t0; INSERT INTO t0 SELECT a + 80, b, c FROM t0; INSERT INTO t0 SELECT a + 160, b, c FROM t0; INSERT INTO t0 SELECT a + 320, b, c FROM t0; INSERT INTO t0 SELECT a + 640, b, c FROM t0; DELETE FROM t0 WHERE a BETWEEN 13 AND 450 AND (a % 5) <> 0; DELETE FROM t0 WHERE a > 450 AND (a % 5) = 0 LIMIT 250; # Uncomment these to see the resulting distribution... #SELECT COUNT(*) FROM t0 WHERE a BETWEEN 1 AND 450; #SELECT COUNT(*) FROM t0 WHERE a BETWEEN 1 AND 450 AND (a % 5) = 0; #SELECT (a % 5) as part, COUNT(*) FROM t0 GROUP BY part; UPDATE t0 SET b = a, c = "MATCH!" WHERE a <= 10; #SELECT COUNT(*) FROM t0 WHERE b BETWEEN 1 AND 10; #SELECT (a % 5) as part, COUNT(*) FROM t0 WHERE b BETWEEN 1 AND 10 GROUP BY part; INSERT INTO t1 SELECT * FROM t0; DROP TABLE t0; ANALYZE TABLE t1; EXPLAIN SELECT * FROM t1 WHERE a BETWEEN 1 AND 450 AND b BETWEEN 1 AND 10; FLUSH STATUS; --sorted_result SELECT * FROM t1 WHERE a BETWEEN 1 AND 450 AND b BETWEEN 1 AND 10; let $get_handler_status_counts= SELECT * FROM INFORMATION_SCHEMA.SESSION_STATUS WHERE VARIABLE_NAME LIKE 'HANDLER_%' AND VARIABLE_VALUE > 0; --source include/get_handler_status_counts.inc DROP TABLE t1; --echo # Test of index_merge and delete CREATE TABLE `t1` ( `a` int(11) NOT NULL, `b` int(11) NOT NULL, KEY `a` (`a`), KEY `b` (`b`) ) /*!50100 PARTITION BY HASH (a) PARTITIONS 3 */; INSERT INTO t1 VALUES (0,0),(0,0),(1,0),(1,0),(2,0),(2,0),(0,0); INSERT INTO t1 SELECT t1.a,t1.b FROM t1, t1 t2; INSERT INTO t1 VALUES (1,1),(2,2); ANALYZE TABLE t1; --replace_column 10 # EXPLAIN SELECT * FROM t1 WHERE a = 4 OR b > 0; --replace_column 10 # EXPLAIN DELETE FROM t1 WHERE a = 4 OR b > 0; SELECT * FROM t1 WHERE a = 4 OR b > 0; SELECT COUNT(*) FROM t1; DELETE FROM t1 WHERE a = 4 OR b > 0; SELECT COUNT(*) FROM t1; SELECT * FROM t1 WHERE a = 4 OR b > 0; DROP TABLE t1; --echo # more testing of index_merge and delete CREATE TABLE t1 (a int not null, b int not null, INDEX(a), INDEX(b)) engine=InnoDB PARTITION BY KEY(a,b) PARTITIONS 5; INSERT INTO t1 VALUES (0,0),(1,1), (2,2), (3,3), (4,4),(5,5),(6,6),(7,7),(8,8),(9,9); INSERT INTO t1 SELECT a + 10, b + 10 FROM t1; INSERT INTO t1 SELECT a + 20, b + 20 FROM t1; INSERT INTO t1 SELECT a + 40, b + 40 FROM t1; INSERT INTO t1 SELECT a + 80, b + 80 FROM t1; INSERT INTO t1 SELECT a + 160, b + 160 FROM t1; ANALYZE TABLE t1; --replace_column 10 # EXPLAIN SELECT * FROM t1 WHERE a = 4 OR b < 3; SELECT * FROM t1 WHERE a = 4 OR b < 3; --replace_column 10 # EXPLAIN SELECT * FROM t1 WHERE a BETWEEN 0 AND 20 OR b BETWEEN 10 AND 20; SELECT * FROM t1 WHERE a BETWEEN 0 AND 20 OR b BETWEEN 10 AND 20; --replace_column 10 # EXPLAIN DELETE FROM t1 WHERE a = 4 OR b < 3; DELETE FROM t1 WHERE a = 4 OR b < 3; --replace_column 10 # EXPLAIN DELETE FROM t1 WHERE a BETWEEN 0 AND 20 OR b BETWEEN 10 AND 20; SELECT * FROM INFORMATION_SCHEMA.OPTIMIZER_TRACE; DELETE FROM t1 WHERE a BETWEEN 0 AND 20 OR b BETWEEN 10 AND 20; DROP TABLE t1; --echo # --echo # Bug#20584754: CAN'T FIND RECORD IN 'TABLE100_KEY_PK_PARTS_2_DATETIME_3' --echo # let $MYSQLD_DATADIR=`SELECT @@datadir`; CREATE TABLE `t1` ( `c1` tinyint unsigned DEFAULT NULL, `c2` char(1) DEFAULT NULL, `pk` tinyint NOT NULL, PRIMARY KEY (`pk`), KEY `c1` (`c1`), KEY `c2` (`c2`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 /*!50100 PARTITION BY HASH (pk) PARTITIONS 2 */; --echo # Create the dataset in a separate table, so it can be loaded --echo # directly without update/delete which may give unstable EXPLAIN --echo # due to background pruning. CREATE TABLE t0 (a tinyint not null auto_increment primary key, b char(1) DEFAULT 'a', c tinyint DEFAULT 1); INSERT INTO t0 (a) VALUES (1), (2), (3), (4), (5), (6), (7), (8); INSERT INTO t0 (a) SELECT NULL FROM t0, t0 t0_2 LIMIT 50; UPDATE t0 SET c = NULL WHERE a IN (2,3,6,13,18); INSERT INTO t1 SELECT c,b,a FROM t0; DROP TABLE t0; ANALYZE TABLE t1; --replace_column 10 # EXPLAIN SELECT pk FROM `t1` WHERE `c1` IS NULL OR `c2` = '0'; SELECT pk FROM `t1` WHERE `c1` IS NULL OR `c2` = '0'; DROP TABLE t1; --echo # --echo # Bug#20516390: PARTITIONED TABLE, TBLSPACE MOVE, ALTER, ASSERT --echo # !(M_FILE_PER_TABLE && M_USE_SHAR --echo # CREATE TABLESPACE ts1 ADD DATAFILE 'ts1.ibd'; CREATE TABLE t1 (a int not null, d int not null, b varchar(198) not null, c varchar(177), index(d), index(a), PRIMARY KEY (b(10), a, d), INDEX (c(95), b(95)), INDEX (b(5), c(10), a)) ENGINE=InnoDB stats_persistent=DEFAULT PARTITION BY LINEAR HASH(d) PARTITIONS 2; ALTER TABLE t1 TABLESPACE ts1; ALTER TABLE t1 DROP PRIMARY KEY, ALGORITHM=DEFAULT; DROP TABLE t1; DROP TABLESPACE ts1; --echo # --echo # Bug #20593808: CRASH WITH PARTITIONED TABLES --echo # MULTITABLE DELETE --echo # --echo Test DML with index scan on partitioned table --echo #1. test delete with join using PK index scan on partitioned table eval CREATE TABLE t1 ( col_1_int int, col_2_text text) ENGINE=InnoDB; SHOW CREATE TABLE t1; --echo #insert two records in t1 INSERT INTO t1 VALUES (5, 'row to delete'); INSERT INTO t1 VALUES (3, 'row to keep'); SELECT * FROM t1 ORDER BY col_1_int; eval CREATE TABLE t2 ( col_1_int int, col_2_int int, col_3_text text, PRIMARY KEY(col_1_int, col_3_text(100)), KEY idx1 (col_2_int, col_1_int)) ENGINE=InnoDB PARTITION BY KEY(col_1_int) partitions 5; SHOW CREATE TABLE t2; --echo #insert five records in t2 INSERT INTO t2 VALUES (91, 11, 'bigger value for no-op'); INSERT INTO t2 VALUES ( 4, 25, 'smaller value to trigger delete'); INSERT INTO t2 VALUES (35, 33, 'bigger value for no-op addlen'); INSERT INTO t2 VALUES (55, 42, 'bigger value for no-op addlen + addlen + addlen'); INSERT INTO t2 VALUES (82, 54, 'bigger value for no-op addlen + addlen'); SELECT * FROM t2 ORDER BY col_1_int; --echo # test delete with join and index scan DELETE t1 FROM t2, t1 WHERE t2.col_1_int <= t1.col_1_int; --echo expect one record SELECT * FROM t1; DROP TABLE t1; DROP TABLE t2; --echo #2. test delete with join using secondary index scan on partitioned table eval CREATE TABLE t1 ( col_1_int int, col_2_text text) ENGINE=InnoDB; SHOW CREATE TABLE t1; --echo #insert two records in t1 INSERT INTO t1 VALUES (5, 'row to delete'); INSERT INTO t1 VALUES (3, 'row to keep'); SELECT * FROM t1 ORDER BY col_1_int; eval CREATE TABLE t2 ( col_1_int int, col_2_int int, col_3_text text, PRIMARY KEY(col_2_int, col_1_int), KEY idx1(col_1_int, col_3_text(100))) ENGINE=InnoDB PARTITION BY KEY(col_2_int) partitions 5; SHOW CREATE TABLE t2; --echo #insert five records in t2 INSERT INTO t2 VALUES (91, 11, 'bigger value for no-op'); INSERT INTO t2 VALUES ( 4, 25, 'smaller value to trigger delete'); INSERT INTO t2 VALUES (35, 33, 'bigger value for no-op addlen'); INSERT INTO t2 VALUES (55, 42, 'bigger value for no-op addlen + addlen + addlen'); INSERT INTO t2 VALUES (82, 54, 'bigger value for no-op addlen + addlen'); SELECT * FROM t2 ORDER BY col_1_int; --echo # test delete with join and index scan DELETE t1 FROM t2, t1 WHERE t2.col_1_int <= t1.col_1_int; --echo expect one record SELECT * FROM t1; DROP TABLE t1; DROP TABLE t2; --echo # --echo # Bug #20949314: PARTITION_HELPER::PH_RND_INIT(BOOL): ASSERTION --echo # CREATE TABLE t1 (c1 INT); INSERT INTO t1 VALUES (3), (4), (5), (1), (2); CREATE TABLE t2 PARTITION BY KEY (c1) PARTITIONS 3 AS SELECT * FROM t1; DELETE A FROM t1 AS A WHERE A.c1 IN (SELECT c1 FROM t2 AS B WHERE B.c1 = A.c1); SELECT * from t1; DROP TABLE t1; DROP TABLE t2; --echo # --echo # Bug#20819189: Assert if .frm exists but no partitioned InnoDB table --echo # CREATE TABLE t1 (a int) ENGINE=InnoDB PARTITION BY HASH (a) PARTITIONS 2; --copy_file $MYSQLD_DATADIR/test/t1.frm $MYSQLD_DATADIR/test/t2.frm --error ER_GET_ERRNO SELECT * FROM t2; --remove_file $MYSQLD_DATADIR/test/t2.frm # Flush table is needed to remove the 'orphan' t2 definition. FLUSH TABLE t2; DROP TABLE t1; --echo # --echo # Bug#21211524: CRASH IN ACTUAL_KEY_PARTS WITH PARTITIONED TABLES --echo # CREATE TABLE t1( col1 SET('') CHARACTER SET UTF16 COLLATE UTF16_SPANISH_CI, col2 INT, PRIMARY KEY (col2, col1), UNIQUE KEY (col1, col2)) ENGINE=INNODB PARTITION BY KEY (col1); SELECT * from t1 WHERE col1 BETWEEN 0x92 AND ""; DROP TABLE t1; --echo # --echo # Bug#21794110: ASSERTION `MP->COUNT > 0 && MY_THREAD_EQUAL --echo # CREATE TABLE t1(col1 INT PRIMARY KEY, col2 CHAR(10)) ENGINE=INNODB PARTITION BY HASH(col1) PARTITIONS 2; INSERT INTO t1 VALUES(0, 'string1'); ALTER TABLE t1 CHANGE col1 col1 INT UNSIGNED AUTO_INCREMENT; SHOW CREATE TABLE t1; DROP TABLE t1; --echo # --echo # Bug#21620577: ASSERTION H->ACTIVE_INDEX == 64 --echo # CREATE TABLE t1(col1 YEAR(4) not null, col2 int, KEY(col1), KEY(col1, col2)) ENGINE=INNODB PARTITION BY KEY(col1) PARTITIONS 2; INSERT INTO t1 VALUES('2015', 10); SELECT /*+ bka()*/ a.col2 from t1 AS a RIGHT JOIN t1 AS b on a.col1<=>null RIGHT JOIN t1 AS c on 1; DROP TABLE t1; --echo # --echo # Bug#21754608: HANDLE_FATAL_SIGNAL PARTITION_HELPER::PH_READ_RANGE_FIRST --echo # CREATE TABLE t1(col1 int PRIMARY KEY, col2 int, col3 int) ENGINE=INNODB PARTITION BY LIST(col1) PARTITIONS 2 (PARTITION p0 VALUES IN (11,12), PARTITION p1 VALUES IN (0,1)); INSERT INTO t1 values(1, 10, 100); --disable_warnings SELECT * from t1 WHERE col1 BETWEEN '2000-01-01 01:02:00' AND '2000-01-01 01:03:00'; --enable_warnings DROP TABLE t1; --echo # --echo # Bug#21755994 ALTER INPLACE CRASHES ON A INNODB TABLE WITH PARTITION ON SEPARATE TABLESPACE --echo # CREATE TABLESPACE ts1 ADD DATAFILE 'ts1.ibd'; CREATE TABLE t1 ( a INT NOT NULL, PRIMARY KEY (a)) ENGINE=InnoDB PARTITION BY RANGE (a) PARTITIONS 3 ( PARTITION P1 VALUES LESS THAN (2) TABLESPACE ts1, PARTITION P2 VALUES LESS THAN (4) TABLESPACE `innodb_system`, PARTITION P3 VALUES LESS THAN (6)); ALTER TABLE t1 ADD COLUMN f int; DROP TABLE t1; DROP TABLESPACE ts1; --echo # --echo # Bug#21796845 ASSERT ERR == DB_SUCCESS, ROW_QUIESCE_TABLE_START(), FLUSH TABLES FOR EXPORT --echo # CREATE TABLESPACE ts1 ADD DATAFILE 'ts1.ibd'; CREATE TABLE t1 (a INT, b INT) ENGINE = InnoDB PARTITION BY RANGE(a) ( PARTITION p1 VALUES LESS THAN (100) TABLESPACE innodb_system, PARTITION p2 VALUES LESS THAN (200), PARTITION p3 VALUES LESS THAN (300) TABLESPACE ts1, PARTITION p4 VALUES LESS THAN (400) TABLESPACE innodb_system); FLUSH table t1 FOR EXPORT; UNLOCK TABLES; DROP TABLE t1; DROP TABLESPACE ts1; --echo # --echo # Bug#21957001 INNODB: FAILING ASSERTION: 0 IN FILE HA_INNOPART.CC LINE 3526 --echo # call mtr.add_suppression("\\[Warning\\] InnoDB: Trying to access missing tablespace .*"); call mtr.add_suppression("\\[Warning\\] InnoDB: Missing .ibd file for table `test`\.`t1` .* "); CREATE TABLE t1(c1 INT,c2 CHAR(1)) PARTITION BY KEY(c1) PARTITIONS 4; ALTER TABLE t1 DISCARD PARTITION p3 TABLESPACE; SELECT TABLE_ROWS FROM information_schema.tables where table_name = 't1'; ALTER TABLE t1 DISCARD PARTITION p1 TABLESPACE; SELECT TABLE_ROWS FROM information_schema.tables where table_name = 't1'; ALTER TABLE t1 DISCARD PARTITION p2 TABLESPACE; SELECT TABLE_ROWS FROM information_schema.tables where table_name = 't1'; ALTER TABLE t1 DISCARD PARTITION p0 TABLESPACE; SELECT TABLE_ROWS FROM information_schema.tables where table_name = 't1'; DROP TABLE t1; CREATE TABLE t1(c1 INT,c2 CHAR(1)) PARTITION BY KEY(c1) PARTITIONS 4; ALTER TABLE t1 DISCARD TABLESPACE; SELECT TABLE_ROWS FROM information_schema.tables where table_name = 't1'; DROP TABLE t1; --echo # --echo # Bug#21864838: SIG11 IN FIELD_BLOB::CMP| AT SQL/FIELD.CC --echo # CREATE TABLE t1 (col1 INT PRIMARY KEY, col2 VARCHAR(1), col3 BLOB AS (REPEAT(col2, 500)) VIRTUAL, KEY(col3(100))) ENGINE=INNODB PARTITION BY HASH(col1) PARTITIONS 2; CREATE TABLE t2 (col1 INT PRIMARY KEY, col2 VARCHAR(1), col3 BLOB AS (REPEAT(col2, 500)) VIRTUAL, KEY(col3(100))) ENGINE=INNODB PARTITION BY HASH(col1) PARTITIONS 2; INSERT INTO t1 (col1, col2) VALUES(1, 'd'), (2, 'c'), (3, 'b'), (4, 'a'); INSERT INTO t2 (col1, col2) VALUES(1, 'd'), (2, 'c'), (3, 'b'), (4, 'a'); SELECT t1.col1 FROM t1, t2 where t1.col1 = 3 AND t1.col3 = t2.col3 ORDER BY t2.col1 DESC; DROP TABLE t1; DROP TABLE t2; --echo # --echo # Bug #21881155: UNINTIALIZED READ IN KEY_REC_CMP CAUSE CRASH LATER --echo # CREATE TABLE t1 (col1 int, col2 BLOB AS ('a') VIRTUAL, col3 INT, PRIMARY KEY(col1), KEY (col3, col2(1), col1)) ENGINE=INNODB PARTITION BY KEY (col1) PARTITIONS 2; INSERT INTO t1(col1) values (1),(2); SELECT 1 FROM t1 WHERE col2 > 'a' GROUP BY col3; DROP TABLE t1; --echo # --echo # Bug#21914047 SHOW CREATE DUMPS AFTER ALTER ON INNODB TABLE WITH PARTITIONS USING TABLESPACE --echo # CREATE TABLESPACE ts1 ADD DATAFILE 'ts1.ibd'; CREATE TABLESPACE ts2 ADD DATAFILE 'ts2.ibd'; CREATE TABLE t1 (a INT NOT NULL, PRIMARY KEY (a)) ENGINE=InnoDB TABLESPACE ts2 PARTITION BY RANGE(a) PARTITIONS 4 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1, PARTITION p2 VALUES LESS THAN (4) TABLESPACE innodb_system, PARTITION p3 VALUES LESS THAN (6), PARTITION p4 VALUES LESS THAN (8) TABLESPACE innodb_file_per_table); SHOW CREATE TABLE t1; --replace_result #P# #p# SELECT A.NAME as partition_name, A.SPACE_TYPE as space_type, B.NAME as space_name FROM information_schema.innodb_sys_tables A LEFT JOIN information_schema.innodb_sys_tablespaces B ON A.SPACE = B.SPACE WHERE A.NAME LIKE '%t1%' ORDER BY A.NAME; ALTER TABLE t1 ADD COLUMN b int; SHOW CREATE TABLE t1; --replace_result #P# #p# SELECT A.NAME as partition_name, A.SPACE_TYPE as space_type, B.NAME as space_name FROM information_schema.innodb_sys_tables A LEFT JOIN information_schema.innodb_sys_tablespaces B ON A.SPACE = B.SPACE WHERE A.NAME LIKE '%t1%' ORDER BY A.NAME; ALTER TABLE t1 ADD COLUMN c int, TABLESPACE ts1; SHOW CREATE TABLE t1; --replace_result #P# #p# SELECT A.NAME as partition_name, A.SPACE_TYPE as space_type, B.NAME as space_name FROM information_schema.innodb_sys_tables A LEFT JOIN information_schema.innodb_sys_tablespaces B ON A.SPACE = B.SPACE WHERE A.NAME LIKE '%t1%' ORDER BY A.NAME; ALTER TABLE t1 ADD PARTITION (PARTITION p5 VALUES LESS THAN (10) TABLESPACE ts2); SHOW CREATE TABLE t1; --replace_result #P# #p# SELECT A.NAME as partition_name, A.SPACE_TYPE as space_type, B.NAME as space_name FROM information_schema.innodb_sys_tables A LEFT JOIN information_schema.innodb_sys_tablespaces B ON A.SPACE = B.SPACE WHERE A.NAME LIKE '%t1%' ORDER BY A.NAME; ALTER TABLE t1 ADD PARTITION (PARTITION p6 VALUES LESS THAN (12)); SHOW CREATE TABLE t1; --replace_result #P# #p# SELECT A.NAME as partition_name, A.SPACE_TYPE as space_type, B.NAME as space_name FROM information_schema.innodb_sys_tables A LEFT JOIN information_schema.innodb_sys_tablespaces B ON A.SPACE = B.SPACE WHERE A.NAME LIKE '%t1%' ORDER BY A.NAME; ALTER TABLE t1 REORGANIZE PARTITION p4 INTO (PARTITION p4 VALUES LESS THAN (8)); SHOW CREATE TABLE t1; --replace_result #P# #p# SELECT A.NAME as partition_name, A.SPACE_TYPE as space_type, B.NAME as space_name FROM information_schema.innodb_sys_tables A LEFT JOIN information_schema.innodb_sys_tablespaces B ON A.SPACE = B.SPACE WHERE A.NAME LIKE '%t1%' ORDER BY A.NAME; ALTER TABLE t1 REORGANIZE PARTITION p3 INTO (PARTITION p3 VALUES LESS THAN (6) TABLESPACE innodb_system); SHOW CREATE TABLE t1; --replace_result #P# #p# SELECT A.NAME as partition_name, A.SPACE_TYPE as space_type, B.NAME as space_name FROM information_schema.innodb_sys_tables A LEFT JOIN information_schema.innodb_sys_tablespaces B ON A.SPACE = B.SPACE WHERE A.NAME LIKE '%t1%' ORDER BY A.NAME; DROP TABLE t1; CREATE TABLE t1 (a INT NOT NULL, PRIMARY KEY (a)) ENGINE=InnoDB PARTITION BY RANGE(a) PARTITIONS 4 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1, PARTITION p2 VALUES LESS THAN (4) TABLESPACE innodb_system, PARTITION p3 VALUES LESS THAN (6), PARTITION p4 VALUES LESS THAN (8) TABLESPACE innodb_file_per_table); SHOW CREATE TABLE t1; --replace_result #P# #p# SELECT A.NAME as partition_name, A.SPACE_TYPE as space_type, B.NAME as space_name FROM information_schema.innodb_sys_tables A LEFT JOIN information_schema.innodb_sys_tablespaces B ON A.SPACE = B.SPACE WHERE A.NAME LIKE '%t1%' ORDER BY A.NAME; ALTER TABLE t1 ADD COLUMN b int; SHOW CREATE TABLE t1; --replace_result #P# #p# SELECT A.NAME as partition_name, A.SPACE_TYPE as space_type, B.NAME as space_name FROM information_schema.innodb_sys_tables A LEFT JOIN information_schema.innodb_sys_tablespaces B ON A.SPACE = B.SPACE WHERE A.NAME LIKE '%t1%' ORDER BY A.NAME; ALTER TABLE t1 ADD COLUMN c int, TABLESPACE ts1; SHOW CREATE TABLE t1; --replace_result #P# #p# SELECT A.NAME as partition_name, A.SPACE_TYPE as space_type, B.NAME as space_name FROM information_schema.innodb_sys_tables A LEFT JOIN information_schema.innodb_sys_tablespaces B ON A.SPACE = B.SPACE WHERE A.NAME LIKE '%t1%' ORDER BY A.NAME; ALTER TABLE t1 ADD PARTITION (PARTITION p5 VALUES LESS THAN (10) TABLESPACE ts2); SHOW CREATE TABLE t1; --replace_result #P# #p# SELECT A.NAME as partition_name, A.SPACE_TYPE as space_type, B.NAME as space_name FROM information_schema.innodb_sys_tables A LEFT JOIN information_schema.innodb_sys_tablespaces B ON A.SPACE = B.SPACE WHERE A.NAME LIKE '%t1%' ORDER BY A.NAME; ALTER TABLE t1 ADD PARTITION (PARTITION p6 VALUES LESS THAN (12)); SHOW CREATE TABLE t1; --replace_result #P# #p# SELECT A.NAME as partition_name, A.SPACE_TYPE as space_type, B.NAME as space_name FROM information_schema.innodb_sys_tables A LEFT JOIN information_schema.innodb_sys_tablespaces B ON A.SPACE = B.SPACE WHERE A.NAME LIKE '%t1%' ORDER BY A.NAME; ALTER TABLE t1 REORGANIZE PARTITION p4 INTO (PARTITION p4 VALUES LESS THAN (8)); SHOW CREATE TABLE t1; --replace_result #P# #p# SELECT A.NAME as partition_name, A.SPACE_TYPE as space_type, B.NAME as space_name FROM information_schema.innodb_sys_tables A LEFT JOIN information_schema.innodb_sys_tablespaces B ON A.SPACE = B.SPACE WHERE A.NAME LIKE '%t1%' ORDER BY A.NAME; ALTER TABLE t1 REORGANIZE PARTITION p3 INTO (PARTITION p3 VALUES LESS THAN (6) TABLESPACE innodb_system); SHOW CREATE TABLE t1; --replace_result #P# #p# SELECT A.NAME as partition_name, A.SPACE_TYPE as space_type, B.NAME as space_name FROM information_schema.innodb_sys_tables A LEFT JOIN information_schema.innodb_sys_tablespaces B ON A.SPACE = B.SPACE WHERE A.NAME LIKE '%t1%' ORDER BY A.NAME; DROP TABLE t1; DROP TABLESPACE ts1; DROP TABLESPACE ts2; --echo # --echo # Bug#22444530 - GCOLS + PARTITIONED TABLE, CRASH IN --echo # set sql_mode=''; create table t ( a int not null, b int generated always as (1) virtual not null, c int generated always as (1) virtual not null, key (c) ) engine=innodb partition by key (a) partitions 2; insert into t(a) values(1); select b from t group by c; drop table t; # Make column b a BLOB create table t ( a int not null, b blob generated always as ("a") virtual not null, c int generated always as (1) virtual not null, key (c) ) engine=innodb partition by key (a) partitions 2; insert into t(a) values(1); select b from t group by c; drop table t; --echo # --echo # Bug#23037025 COL+PARTITION SIG11 IN ROW_SEL_STORE_MYSQL_REC --echo # set sql_mode=''; CREATE TABLE t1 ( col1 INT, col2 INT AS (col1) VIRTUAL NOT NULL, col3 INT AS (1) VIRTUAL, KEY (col3) ) ENGINE=INNODB PARTITION BY KEY (col1) PARTITIONS 2; CREATE TABLE t2 (col1 INTEGER); CREATE TABLE t3 (col1 INTEGER); CREATE TRIGGER t2_trig1 BEFORE INSERT ON t2 FOR EACH ROW INSERT INTO t3 SELECT col2 FROM t1 GROUP BY col3; --disable_warnings INSERT IGNORE INTO t1(col1) values(NULL); --enable_warnings --error ER_BAD_NULL_ERROR INSERT INTO t2 VALUES(1); DROP TRIGGER t2_trig1; DROP TABLE t3; DROP TABLE t2; DROP TABLE t1; --echo # --echo # Bug#23194259 ASSERTION FAILURE:TRX0TRX.H:1416:SRV_READ_ONLY_MODE --echo # CREATE TABLE t1(col1 INT AS(1), KEY(col1)) ENGINE=INNODB PARTITION BY KEY(col1) PARTITIONS 2; SELECT * FROM t1 WHERE sha(uuid_short()); DROP TABLE t1;
Close