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 /
r /
[ HOME SHELL ]
Name
Size
Permission
Action
add_foreign_key.result
1.28
KB
-rw-r--r--
alter_crash.result
4.43
KB
-rw-r--r--
alter_foreign_crash.result
751
B
-rw-r--r--
alter_kill.result
2.42
KB
-rw-r--r--
alter_missing_tablespace.resul...
1.46
KB
-rw-r--r--
alter_page_size.result
1.14
KB
-rw-r--r--
alter_rename_existing.result
5.32
KB
-rw-r--r--
alter_rename_files.result
557
B
-rw-r--r--
alter_row_format.result
1.59
KB
-rw-r--r--
alter_table_redundant.result
278
B
-rw-r--r--
alter_table_stage_progress.res...
942
B
-rw-r--r--
analyze_index.result
705
B
-rw-r--r--
analyze_table.result
538
B
-rw-r--r--
attachable_trx.result
2.48
KB
-rw-r--r--
autoinc_debug.result
2.53
KB
-rw-r--r--
blob-crash-16k.result
2.1
KB
-rw-r--r--
blob-crash-4k.result
2.1
KB
-rw-r--r--
blob-crash.result
4.59
KB
-rw-r--r--
blob-update-debug.result
489
B
-rw-r--r--
blob_page_reserve.result
3.81
KB
-rw-r--r--
blob_redo.result
1.05
KB
-rw-r--r--
buf_pool_resize_oom.result
493
B
-rw-r--r--
bulk_create_index_online.resul...
1.21
KB
-rw-r--r--
cascade_lock_wait.result
1.52
KB
-rw-r--r--
check_ibd_filesize_16k.result
1.58
KB
-rw-r--r--
check_sector_size.result
276
B
-rw-r--r--
checksum.result
331
B
-rw-r--r--
cmp_per_index.result
2.96
KB
-rw-r--r--
crc32_endianness.result
540
B
-rw-r--r--
create-index.result
283
B
-rw-r--r--
create_isl_with_direct.result
328
B
-rw-r--r--
create_table.result
1.97
KB
-rw-r--r--
create_tablespace.result
81.15
KB
-rw-r--r--
create_tablespace_16k.result
69.23
KB
-rw-r--r--
create_tablespace_32k.result
7.33
KB
-rw-r--r--
create_tablespace_4k.result
36.13
KB
-rw-r--r--
create_tablespace_64k.result
7.64
KB
-rw-r--r--
create_tablespace_8k.result
50.53
KB
-rw-r--r--
create_tablespace_debug.result
5.02
KB
-rw-r--r--
create_tablespace_notembedded....
692
B
-rw-r--r--
create_tablespace_partition.re...
33.17
KB
-rw-r--r--
create_tablespace_replication....
2.02
KB
-rw-r--r--
deadlock_detect.result
562
B
-rw-r--r--
default_row_format.result
17.56
KB
-rw-r--r--
default_row_format_16k.result
17.91
KB
-rw-r--r--
default_row_format_compatibili...
4.14
KB
-rw-r--r--
default_row_format_tablespace....
8.64
KB
-rw-r--r--
deprecate_part_in_shared_ts.re...
5.87
KB
-rw-r--r--
doublewrite.result
8.1
KB
-rw-r--r--
dropdb.result
222
B
-rw-r--r--
end_range_check.result
3.06
KB
-rw-r--r--
end_range_check_2.result
811
B
-rw-r--r--
events-merge-tmp-path.result
1.33
KB
-rw-r--r--
file_format_defaults.result
2.84
KB
-rw-r--r--
file_format_upgrade_16k.result
420
B
-rw-r--r--
flush-hang.result
1.27
KB
-rw-r--r--
foreign_key.result
9.21
KB
-rw-r--r--
fts_exec_interrupt.result
723
B
-rw-r--r--
help_verbose.result
80
B
-rw-r--r--
high_prio_trx_1.result
505
B
-rw-r--r--
high_prio_trx_2.result
581
B
-rw-r--r--
high_prio_trx_3.result
665
B
-rw-r--r--
high_prio_trx_4.result
711
B
-rw-r--r--
high_prio_trx_5.result
858
B
-rw-r--r--
high_prio_trx_6.result
775
B
-rw-r--r--
high_prio_trx_7.result
5.67
KB
-rw-r--r--
high_prio_trx_commit_crash.res...
1
KB
-rw-r--r--
high_prio_trx_debug.result
1.09
KB
-rw-r--r--
high_prio_trx_fk.result
918
B
-rw-r--r--
high_prio_trx_predicate.result
824
B
-rw-r--r--
high_prio_trx_rpl.result
1.65
KB
-rw-r--r--
i_s_files_debug.result
471
B
-rw-r--r--
ibuf_not_empty.result
969
B
-rw-r--r--
import.result
1.72
KB
-rw-r--r--
import_compress_encrypt.result
5.28
KB
-rw-r--r--
import_compress_encrypt_upgrad...
2.53
KB
-rw-r--r--
import_export_4k.result
724
B
-rw-r--r--
import_tablespace_page_corrupt...
555
B
-rw-r--r--
import_tablespace_schema_missm...
2.11
KB
-rw-r--r--
import_update_stats.result
2.86
KB
-rw-r--r--
index-online-norebuild.result
897
B
-rw-r--r--
index_length.result
1.28
KB
-rw-r--r--
index_merge_threshold.result
54.7
KB
-rw-r--r--
index_tree_operation.result
1.65
KB
-rw-r--r--
innodb-2byte-collation.result
3.28
KB
-rw-r--r--
innodb-ac-non-locking-select.r...
861
B
-rw-r--r--
innodb-alter-autoinc.result
4.27
KB
-rw-r--r--
innodb-alter-debug-wl6554.resu...
12.79
KB
-rw-r--r--
innodb-alter-debug.result
2.64
KB
-rw-r--r--
innodb-alter-nullable.result
1.52
KB
-rw-r--r--
innodb-alter-wl6554.result
3.13
KB
-rw-r--r--
innodb-alter.result
30.33
KB
-rw-r--r--
innodb-analyze.result
58
B
-rw-r--r--
innodb-autoinc-18274.result
805
B
-rw-r--r--
innodb-autoinc-44030.result
732
B
-rw-r--r--
innodb-autoinc-56228.result
847
B
-rw-r--r--
innodb-autoinc-optimize.result
321
B
-rw-r--r--
innodb-autoinc.result
41.48
KB
-rw-r--r--
innodb-blob.result
4.91
KB
-rw-r--r--
innodb-bug-14068765.result
2.81
KB
-rw-r--r--
innodb-bug-14084530.result
701
B
-rw-r--r--
innodb-bug12552164.result
1.73
KB
-rw-r--r--
innodb-bug14219515.result
244
B
-rw-r--r--
innodb-change-buffer-recovery....
1.08
KB
-rw-r--r--
innodb-consistent.result
670
B
-rw-r--r--
innodb-import-partition-rpl.re...
2.46
KB
-rw-r--r--
innodb-import-partition.result
40.01
KB
-rw-r--r--
innodb-index-debug.result
13.64
KB
-rw-r--r--
innodb-index-online-delete.res...
642
B
-rw-r--r--
innodb-index-online-fk.result
26.4
KB
-rw-r--r--
innodb-index-online-purge.resu...
1.2
KB
-rw-r--r--
innodb-index-online.result
13.35
KB
-rw-r--r--
innodb-index.result
67.62
KB
-rw-r--r--
innodb-index_ucs2.result
3.62
KB
-rw-r--r--
innodb-isolation.result
43.25
KB
-rw-r--r--
innodb-large-prefix.result
1.27
KB
-rw-r--r--
innodb-lock-inherit-read_commi...
4.18
KB
-rw-r--r--
innodb-lock.result
3.22
KB
-rw-r--r--
innodb-multiple-tablespaces.re...
14.79
KB
-rw-r--r--
innodb-read-view.result
2.73
KB
-rw-r--r--
innodb-replace-debug.result
309
B
-rw-r--r--
innodb-semi-consistent.result
1.35
KB
-rw-r--r--
innodb-status-output.result
1.3
KB
-rw-r--r--
innodb-system-table-view.resul...
9.07
KB
-rw-r--r--
innodb-table-online.result
13.11
KB
-rw-r--r--
innodb-timeout.result
953
B
-rw-r--r--
innodb-truncate-debug.result
4.46
KB
-rw-r--r--
innodb-truncate.result
2.28
KB
-rw-r--r--
innodb-ucs2.result
15.38
KB
-rw-r--r--
innodb-update-insert.result
1.1
KB
-rw-r--r--
innodb-wl5522-1.result
29.45
KB
-rw-r--r--
innodb-wl5522-debug.result
30.05
KB
-rw-r--r--
innodb-wl5522.result
20.99
KB
-rw-r--r--
innodb-wl5980-alter.result
38.86
KB
-rw-r--r--
innodb-wl5980-debug.result
1.33
KB
-rw-r--r--
innodb-wl5980-discard.result
29.2
KB
-rw-r--r--
innodb-wl5980-linux.result
9.7
KB
-rw-r--r--
innodb-wl5980-windows.result
10.07
KB
-rw-r--r--
innodb-wl6045-1.result
3.72
KB
-rw-r--r--
innodb-wl6045-linux.result
11.11
KB
-rw-r--r--
innodb-wl6445-1.result
69
KB
-rw-r--r--
innodb-wl6445-2.result
3.57
KB
-rw-r--r--
innodb-wl6445.result
1.78
KB
-rw-r--r--
innodb.result
108.76
KB
-rw-r--r--
innodb_32k.result
3.25
KB
-rw-r--r--
innodb_64k.result
3.47
KB
-rw-r--r--
innodb_autoinc_lock_mode_zero....
1.22
KB
-rw-r--r--
innodb_autoinc_reset.result
423
B
-rw-r--r--
innodb_buffer_pool_dump_pct.re...
1.49
KB
-rw-r--r--
innodb_buffer_pool_load.result
2.02
KB
-rw-r--r--
innodb_buffer_pool_load_now.re...
1.6
KB
-rw-r--r--
innodb_buffer_pool_resize.resu...
1.29
KB
-rw-r--r--
innodb_buffer_pool_resize_debu...
3.24
KB
-rw-r--r--
innodb_buffer_pool_resize_with...
1.08
KB
-rw-r--r--
innodb_bug-13628249.result
988
B
-rw-r--r--
innodb_bug11754376.result
180
B
-rw-r--r--
innodb_bug11766634.result
396
B
-rw-r--r--
innodb_bug11789106.result
404
B
-rw-r--r--
innodb_bug11933790.result
135
B
-rw-r--r--
innodb_bug12400341.result
966
B
-rw-r--r--
innodb_bug12429573.result
708
B
-rw-r--r--
innodb_bug12661768.result
524
B
-rw-r--r--
innodb_bug14006907.result
934
B
-rw-r--r--
innodb_bug14007109.result
223
B
-rw-r--r--
innodb_bug14007649.result
1.17
KB
-rw-r--r--
innodb_bug14147491.result
730
B
-rw-r--r--
innodb_bug14169459.result
1.48
KB
-rw-r--r--
innodb_bug14676111.result
1.99
KB
-rw-r--r--
innodb_bug14704286.result
1.12
KB
-rw-r--r--
innodb_bug19164038.result
1023
B
-rw-r--r--
innodb_bug21704.result
2.65
KB
-rw-r--r--
innodb_bug30113362.result
2.95
KB
-rw-r--r--
innodb_bug30423.result
3.79
KB
-rw-r--r--
innodb_bug30594501.result
317
B
-rw-r--r--
innodb_bug30919.result
17.44
KB
-rw-r--r--
innodb_bug31205266.result
798
B
-rw-r--r--
innodb_bug34053.result
35
B
-rw-r--r--
innodb_bug34300.result
439
B
-rw-r--r--
innodb_bug35220.result
35
B
-rw-r--r--
innodb_bug38231.result
35
B
-rw-r--r--
innodb_bug39438.result
35
B
-rw-r--r--
innodb_bug40360.result
274
B
-rw-r--r--
innodb_bug40565.result
311
B
-rw-r--r--
innodb_bug41904.result
195
B
-rw-r--r--
innodb_bug42101-nonzero.result
810
B
-rw-r--r--
innodb_bug42101.result
704
B
-rw-r--r--
innodb_bug42419.result
858
B
-rw-r--r--
innodb_bug44032.result
313
B
-rw-r--r--
innodb_bug44369.result
300
B
-rw-r--r--
innodb_bug44571.result
334
B
-rw-r--r--
innodb_bug45357.result
290
B
-rw-r--r--
innodb_bug46000.result
906
B
-rw-r--r--
innodb_bug46676.result
362
B
-rw-r--r--
innodb_bug47167.result
1.51
KB
-rw-r--r--
innodb_bug47621.result
777
B
-rw-r--r--
innodb_bug47622.result
748
B
-rw-r--r--
innodb_bug47777.result
612
B
-rw-r--r--
innodb_bug48024.result
592
B
-rw-r--r--
innodb_bug49164.result
913
B
-rw-r--r--
innodb_bug51378.result
2.19
KB
-rw-r--r--
innodb_bug51920.result
316
B
-rw-r--r--
innodb_bug52199.result
175
B
-rw-r--r--
innodb_bug52663.result
857
B
-rw-r--r--
innodb_bug53046.result
1016
B
-rw-r--r--
innodb_bug53290.result
771
B
-rw-r--r--
innodb_bug53592.result
1.9
KB
-rw-r--r--
innodb_bug53674.result
234
B
-rw-r--r--
innodb_bug53756.result
3.62
KB
-rw-r--r--
innodb_bug54044.result
678
B
-rw-r--r--
innodb_bug56143.result
73.71
KB
-rw-r--r--
innodb_bug56716.result
168
B
-rw-r--r--
innodb_bug56947.result
406
B
-rw-r--r--
innodb_bug57252.result
89
B
-rw-r--r--
innodb_bug57255.result
501
B
-rw-r--r--
innodb_bug57904.result
1.3
KB
-rw-r--r--
innodb_bug59307.result
483
B
-rw-r--r--
innodb_bug59410.result
529
B
-rw-r--r--
innodb_bug59641.result
927
B
-rw-r--r--
innodb_bug59733.result
822
B
-rw-r--r--
innodb_bug60049.result
258
B
-rw-r--r--
innodb_bug60196.result
2.86
KB
-rw-r--r--
innodb_bug60229.result
955
B
-rw-r--r--
innodb_bug70867.result
126
B
-rw-r--r--
innodb_bulk_create_index.resul...
29.62
KB
-rw-r--r--
innodb_bulk_create_index_debug...
11.38
KB
-rw-r--r--
innodb_bulk_create_index_flush...
1.46
KB
-rw-r--r--
innodb_bulk_create_index_repli...
5.82
KB
-rw-r--r--
innodb_bulk_create_index_small...
4.26
KB
-rw-r--r--
innodb_corrupt_bit.result
2.61
KB
-rw-r--r--
innodb_corrupt_readonly.result
1011
B
-rw-r--r--
innodb_ctype_ldml.result
27.55
KB
-rw-r--r--
innodb_deadlock_with_autoinc.r...
565
B
-rw-r--r--
innodb_file_format.result
3.11
KB
-rw-r--r--
innodb_file_limit_check.result
457
B
-rw-r--r--
innodb_force_recovery.result
3.7
KB
-rw-r--r--
innodb_fts_limit_check.result
1.04
KB
-rw-r--r--
innodb_high_prio_commit_crash....
1.13
KB
-rw-r--r--
innodb_high_prio_rpl.result
1.07
KB
-rw-r--r--
innodb_i_s_innodb_locks.result
4.89
KB
-rw-r--r--
innodb_i_s_innodb_trx.result
2.85
KB
-rw-r--r--
innodb_information_schema_buff...
2.29
KB
-rw-r--r--
innodb_io_pf.result
407
B
-rw-r--r--
innodb_lock_wait_timeout_1.res...
9.04
KB
-rw-r--r--
innodb_misc1.result
29.29
KB
-rw-r--r--
innodb_multi_update.result
1.62
KB
-rw-r--r--
innodb_mysql.result
95.87
KB
-rw-r--r--
innodb_mysql_rbk.result
629
B
-rw-r--r--
innodb_notembedded.result
637
B
-rw-r--r--
innodb_page_size_func.result
1.49
KB
-rw-r--r--
innodb_pagesize_max_recordsize...
14.37
KB
-rw-r--r--
innodb_prefix_index_check.resu...
1.14
KB
-rw-r--r--
innodb_prefix_index_restart_se...
2.69
KB
-rw-r--r--
innodb_rename_index.result
31.12
KB
-rw-r--r--
innodb_rename_index_err.result
1.81
KB
-rw-r--r--
innodb_replace.result
2.7
KB
-rw-r--r--
innodb_row_log_read.result
867
B
-rw-r--r--
innodb_stats.result
11.62
KB
-rw-r--r--
innodb_stats_auto_recalc.resul...
1.33
KB
-rw-r--r--
innodb_stats_auto_recalc_ddl.r...
1.13
KB
-rw-r--r--
innodb_stats_auto_recalc_lots....
2.07
KB
-rw-r--r--
innodb_stats_auto_recalc_on_no...
2.19
KB
-rw-r--r--
innodb_stats_create_on_corrupt...
705
B
-rw-r--r--
innodb_stats_create_table.resu...
1.1
KB
-rw-r--r--
innodb_stats_del_mark.result
2.81
KB
-rw-r--r--
innodb_stats_drop_locked.resul...
1.55
KB
-rw-r--r--
innodb_stats_external_pages.re...
880
B
-rw-r--r--
innodb_stats_fetch.result
3.35
KB
-rw-r--r--
innodb_stats_fetch_corrupted.r...
1.01
KB
-rw-r--r--
innodb_stats_fetch_nonexistent...
980
B
-rw-r--r--
innodb_stats_flag_global_off.r...
7.36
KB
-rw-r--r--
innodb_stats_flag_global_on.re...
7.36
KB
-rw-r--r--
innodb_stats_rename_table.resu...
1.48
KB
-rw-r--r--
innodb_stats_rename_table_if_e...
1.89
KB
-rw-r--r--
innodb_stats_sample_pages.resu...
1023
B
-rw-r--r--
innodb_stats_table_flag_auto_r...
2.97
KB
-rw-r--r--
innodb_stats_table_flag_sample...
4.23
KB
-rw-r--r--
innodb_sys_var_valgrind.result
2.35
KB
-rw-r--r--
innodb_tablespace.result
22.76
KB
-rw-r--r--
innodb_tablespace_zip.result
1.13
KB
-rw-r--r--
innodb_thread_concurrency_debu...
824
B
-rw-r--r--
innodb_timeout_rollback.result
570
B
-rw-r--r--
innodb_trx_weight.result
35
B
-rw-r--r--
innodb_upd_stats_if_needed_not...
466
B
-rw-r--r--
innodb_ut_format_name.result
140
B
-rw-r--r--
innodb_wl6326.result
10.95
KB
-rw-r--r--
innodb_wl6326_big.result
17.67
KB
-rw-r--r--
innodb_wl6469_1.result
1.48
KB
-rw-r--r--
innodb_wl6469_debug.result
1.63
KB
-rw-r--r--
innodb_wl6470.result
3.11
KB
-rw-r--r--
innodb_wl6470_debug.result
1.42
KB
-rw-r--r--
innodb_wl6501_crash_1.result
15.37
KB
-rw-r--r--
innodb_wl6501_crash_2.result
15.37
KB
-rw-r--r--
innodb_wl6501_crash_6.result
13.07
KB
-rw-r--r--
innodb_wl6501_crash_7.result
13.07
KB
-rw-r--r--
innodb_wl6501_crash_8.result
468
B
-rw-r--r--
innodb_wl6560_1.result
7.27
KB
-rw-r--r--
innodb_wl6560_debug.result
3.36
KB
-rw-r--r--
innodb_wl6915.result
3.99
KB
-rw-r--r--
innodb_wl6915_debug.result
2.88
KB
-rw-r--r--
innodb_wl8114.result
1.78
KB
-rw-r--r--
insert_debug.result
956
B
-rw-r--r--
iodku.result
6.34
KB
-rw-r--r--
iodku_debug.result
2.71
KB
-rw-r--r--
log_alter_table.result
521
B
-rw-r--r--
log_corruption.result
843
B
-rw-r--r--
log_file.result
4.84
KB
-rw-r--r--
log_file_name.result
1.55
KB
-rw-r--r--
log_file_name_debug.result
345
B
-rw-r--r--
log_file_size.result
1.09
KB
-rw-r--r--
log_file_size_1.result
4.85
KB
-rw-r--r--
log_file_size_checkpoint.resul...
106
B
-rw-r--r--
missing_tablespaces.result
664
B
-rw-r--r--
monitor.result
23.64
KB
-rw-r--r--
monitor_restart.result
324
B
-rw-r--r--
mysqldump_max_recordsize.resul...
8.78
KB
-rw-r--r--
optimizer_temporary_table.resu...
114.72
KB
-rw-r--r--
page_reorganize.result
638
B
-rw-r--r--
partition-blob.result
1.53
KB
-rw-r--r--
partition-upgrade.result
33.24
KB
-rw-r--r--
partition.result
39.54
KB
-rw-r--r--
readahead.result
398
B
-rw-r--r--
readonly.result
713
B
-rw-r--r--
records_in_range.result
35.31
KB
-rw-r--r--
redo_log_during_checkpoint.res...
827
B
-rw-r--r--
rename_table.result
890
B
-rw-r--r--
row_format_redundant.result
1.71
KB
-rw-r--r--
sp_temp_table.result
5.72
KB
-rw-r--r--
stored_fk.result
3.52
KB
-rw-r--r--
strict_checksum.result
1.02
KB
-rw-r--r--
strict_mode.result
3.54
KB
-rw-r--r--
sys_tablestats.result
571
B
-rw-r--r--
table_compress.result
25.4
KB
-rw-r--r--
table_encrypt_1.result
6.82
KB
-rw-r--r--
table_encrypt_2.result
3.44
KB
-rw-r--r--
table_encrypt_3.result
66.48
KB
-rw-r--r--
table_encrypt_4.result
3.64
KB
-rw-r--r--
table_encrypt_5.result
56.6
KB
-rw-r--r--
table_encrypt_debug.result
3.22
KB
-rw-r--r--
table_encrypt_fts.result
1.7
KB
-rw-r--r--
table_encrypt_kill.result
7.59
KB
-rw-r--r--
table_encryption.result
3.42
KB
-rw-r--r--
tablespace_crash.result
8.16
KB
-rw-r--r--
tablespace_embedded.result
6.89
KB
-rw-r--r--
tablespace_embedded_windows.re...
6.93
KB
-rw-r--r--
tablespace_per_table.result
21.6
KB
-rw-r--r--
tablespace_per_table_not_windo...
9.11
KB
-rw-r--r--
tablespace_per_table_windows.r...
3.12
KB
-rw-r--r--
tablespace_portability.result
24.68
KB
-rw-r--r--
tablespace_portability_windows...
24.41
KB
-rw-r--r--
timestamp.result
790
B
-rw-r--r--
tinytext-groupby.result
1.33
KB
-rw-r--r--
tmpdir.result
1.8
KB
-rw-r--r--
trx_id_future.result
329
B
-rw-r--r--
undo.result
850
B
-rw-r--r--
update-cascade.result
8.04
KB
-rw-r--r--
update_time.result
1.62
KB
-rw-r--r--
update_time_wl6658.result
8.08
KB
-rw-r--r--
virtual_basic.result
53.55
KB
-rw-r--r--
virtual_blob.result
359
B
-rw-r--r--
virtual_debug.result
53.92
KB
-rw-r--r--
virtual_debug_purge.result
3.98
KB
-rw-r--r--
virtual_fk.result
28.34
KB
-rw-r--r--
virtual_fk_restart.result
1.48
KB
-rw-r--r--
virtual_index.result
7.71
KB
-rw-r--r--
virtual_purge.result
3.95
KB
-rw-r--r--
virtual_stats.result
4.84
KB
-rw-r--r--
xa_prepare_lock_release.result
1.21
KB
-rw-r--r--
xa_recovery.result
381
B
-rw-r--r--
xa_recovery_debug.result
528
B
-rw-r--r--
Delete
Unzip
Zip
${this.title}
Close
Code Editor : partition.result
# # Test of optimizer estimates # 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; # Set up the rows so that the following query would match # 100 PK values but only 10 'b' values. But 90 of the matching # PKs will be in the smallest partition. # Since the fix for bug#1364811 will ha_partition only check the biggest # partitions, but ha_innopart will check all partitions when estimating # numbers of records in range. Resulting in ha_partition will # assume there are only 10 matching PK values and choose to do search # by PK but ha_innopart will search by secondary index 'b' since it # will prefer to read 10 records from the secondary index over reading # 100 records from the PRIMARY index. # SELECT * FROM t1 WHERE a BETWEEN 1 AND 450 AND b BETWEEN 1 AND 10; # 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; UPDATE t0 SET b = a, c = "MATCH!" WHERE a <= 10; INSERT INTO t1 SELECT * FROM t0; DROP TABLE t0; ANALYZE TABLE t1; Table Op Msg_type Msg_text test.t1 analyze status OK EXPLAIN SELECT * FROM t1 WHERE a BETWEEN 1 AND 450 AND b BETWEEN 1 AND 10; id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE t1 p0,p1,p2,p3,p4 range PRIMARY,b b 9 NULL 10 13.09 Using index condition Warnings: Note 1003 /* select#1 */ select `test`.`t1`.`a` AS `a`,`test`.`t1`.`b` AS `b`,`test`.`t1`.`c` AS `c` from `test`.`t1` where ((`test`.`t1`.`a` between 1 and 450) and (`test`.`t1`.`b` between 1 and 10)) FLUSH STATUS; SELECT * FROM t1 WHERE a BETWEEN 1 AND 450 AND b BETWEEN 1 AND 10; a b c 1 1 MATCH! 10 10 MATCH! 2 2 MATCH! 3 3 MATCH! 4 4 MATCH! 5 5 MATCH! 6 6 MATCH! 7 7 MATCH! 8 8 MATCH! 9 9 MATCH! SELECT * FROM INFORMATION_SCHEMA.SESSION_STATUS WHERE VARIABLE_NAME LIKE 'HANDLER_%' AND VARIABLE_VALUE > 0; VARIABLE_NAME VARIABLE_VALUE HANDLER_COMMIT 1 HANDLER_EXTERNAL_LOCK 2 HANDLER_READ_KEY 5 HANDLER_READ_NEXT 10 HANDLER_WRITE 17 DROP TABLE t1; # 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; Table Op Msg_type Msg_text test.t1 analyze status OK EXPLAIN SELECT * FROM t1 WHERE a = 4 OR b > 0; id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE t1 p0,p1,p2 index_merge a,b a,b 4,4 NULL # 100.00 Using sort_union(a,b); Using where Warnings: Note 1003 /* select#1 */ select `test`.`t1`.`a` AS `a`,`test`.`t1`.`b` AS `b` from `test`.`t1` where ((`test`.`t1`.`a` = 4) or (`test`.`t1`.`b` > 0)) EXPLAIN DELETE FROM t1 WHERE a = 4 OR b > 0; id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 DELETE t1 p0,p1,p2 index_merge a,b a,b 4,4 NULL # 100.00 Using sort_union(a,b); Using where SELECT * FROM t1 WHERE a = 4 OR b > 0; a b 1 1 2 2 SELECT COUNT(*) FROM t1; COUNT(*) 58 DELETE FROM t1 WHERE a = 4 OR b > 0; SELECT COUNT(*) FROM t1; COUNT(*) 56 SELECT * FROM t1 WHERE a = 4 OR b > 0; a b DROP TABLE t1; # 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; Table Op Msg_type Msg_text test.t1 analyze status OK EXPLAIN SELECT * FROM t1 WHERE a = 4 OR b < 3; id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE t1 p0,p1,p2,p3,p4 index_merge a,b a,b 4,4 NULL # 100.00 Using sort_union(a,b); Using where Warnings: Note 1003 /* select#1 */ select `test`.`t1`.`a` AS `a`,`test`.`t1`.`b` AS `b` from `test`.`t1` where ((`test`.`t1`.`a` = 4) or (`test`.`t1`.`b` < 3)) SELECT * FROM t1 WHERE a = 4 OR b < 3; a b 0 0 1 1 2 2 4 4 EXPLAIN SELECT * FROM t1 WHERE a BETWEEN 0 AND 20 OR b BETWEEN 10 AND 20; id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE t1 p0,p1,p2,p3,p4 index_merge a,b a,b 4,4 NULL # 100.00 Using sort_union(a,b); Using where Warnings: Note 1003 /* select#1 */ select `test`.`t1`.`a` AS `a`,`test`.`t1`.`b` AS `b` from `test`.`t1` where ((`test`.`t1`.`a` between 0 and 20) or (`test`.`t1`.`b` between 10 and 20)) SELECT * FROM t1 WHERE a BETWEEN 0 AND 20 OR b BETWEEN 10 AND 20; a b 0 0 1 1 2 2 3 3 4 4 5 5 6 6 7 7 8 8 9 9 15 15 10 10 12 12 17 17 18 18 19 19 11 11 16 16 14 14 13 13 20 20 EXPLAIN DELETE FROM t1 WHERE a = 4 OR b < 3; id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 DELETE t1 p0,p1,p2,p3,p4 index_merge a,b a,b 4,4 NULL # 100.00 Using sort_union(a,b); Using where DELETE FROM t1 WHERE a = 4 OR b < 3; EXPLAIN DELETE FROM t1 WHERE a BETWEEN 0 AND 20 OR b BETWEEN 10 AND 20; id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 DELETE t1 p0,p1,p2,p3,p4 index_merge a,b a,b 4,4 NULL # 100.00 Using sort_union(a,b); Using where SELECT * FROM INFORMATION_SCHEMA.OPTIMIZER_TRACE; QUERY TRACE MISSING_BYTES_BEYOND_MAX_MEM_SIZE INSUFFICIENT_PRIVILEGES DELETE FROM t1 WHERE a BETWEEN 0 AND 20 OR b BETWEEN 10 AND 20; DROP TABLE t1; # # Bug#20584754: CAN'T FIND RECORD IN 'TABLE100_KEY_PK_PARTS_2_DATETIME_3' # 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 */; # Create the dataset in a separate table, so it can be loaded # directly without update/delete which may give unstable EXPLAIN # 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; Table Op Msg_type Msg_text test.t1 analyze status OK EXPLAIN SELECT pk FROM `t1` WHERE `c1` IS NULL OR `c2` = '0'; id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE t1 p0,p1 index_merge c1,c2 c1,c2 2,2 NULL # 100.00 Using union(c1,c2); Using where Warnings: Note 1003 /* select#1 */ select `test`.`t1`.`pk` AS `pk` from `test`.`t1` where (isnull(`test`.`t1`.`c1`) or (`test`.`t1`.`c2` = '0')) SELECT pk FROM `t1` WHERE `c1` IS NULL OR `c2` = '0'; pk 2 3 6 13 18 DROP TABLE t1; # # Bug#20516390: PARTITIONED TABLE, TBLSPACE MOVE, ALTER, ASSERT # !(M_FILE_PER_TABLE && M_USE_SHAR # 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; Warnings: Warning 1681 'InnoDB : A table partition in a shared tablespace' is deprecated and will be removed in a future release. ALTER TABLE t1 DROP PRIMARY KEY, ALGORITHM=DEFAULT; Warnings: Warning 1681 'InnoDB : A table partition in a shared tablespace' is deprecated and will be removed in a future release. DROP TABLE t1; DROP TABLESPACE ts1; # # Bug #20593808: CRASH WITH PARTITIONED TABLES # MULTITABLE DELETE # Test DML with index scan on partitioned table #1. test delete with join using PK index scan on partitioned table CREATE TABLE t1 ( col_1_int int, col_2_text text) ENGINE=InnoDB; SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( `col_1_int` int(11) DEFAULT NULL, `col_2_text` text ) ENGINE=InnoDB DEFAULT CHARSET=latin1 #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; col_1_int col_2_text 3 row to keep 5 row to delete 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; Table Create Table t2 CREATE TABLE `t2` ( `col_1_int` int(11) NOT NULL, `col_2_int` int(11) DEFAULT NULL, `col_3_text` text NOT NULL, PRIMARY KEY (`col_1_int`,`col_3_text`(100)), KEY `idx1` (`col_2_int`,`col_1_int`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 /*!50100 PARTITION BY KEY (col_1_int) PARTITIONS 5 */ #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; col_1_int col_2_int col_3_text 4 25 smaller value to trigger delete 35 33 bigger value for no-op addlen 55 42 bigger value for no-op addlen + addlen + addlen 82 54 bigger value for no-op addlen + addlen 91 11 bigger value for no-op # test delete with join and index scan DELETE t1 FROM t2, t1 WHERE t2.col_1_int <= t1.col_1_int; expect one record SELECT * FROM t1; col_1_int col_2_text 3 row to keep DROP TABLE t1; DROP TABLE t2; #2. test delete with join using secondary index scan on partitioned table CREATE TABLE t1 ( col_1_int int, col_2_text text) ENGINE=InnoDB; SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( `col_1_int` int(11) DEFAULT NULL, `col_2_text` text ) ENGINE=InnoDB DEFAULT CHARSET=latin1 #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; col_1_int col_2_text 3 row to keep 5 row to delete 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; Table Create Table t2 CREATE TABLE `t2` ( `col_1_int` int(11) NOT NULL, `col_2_int` int(11) NOT NULL, `col_3_text` text, PRIMARY KEY (`col_2_int`,`col_1_int`), KEY `idx1` (`col_1_int`,`col_3_text`(100)) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 /*!50100 PARTITION BY KEY (col_2_int) PARTITIONS 5 */ #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; col_1_int col_2_int col_3_text 4 25 smaller value to trigger delete 35 33 bigger value for no-op addlen 55 42 bigger value for no-op addlen + addlen + addlen 82 54 bigger value for no-op addlen + addlen 91 11 bigger value for no-op # test delete with join and index scan DELETE t1 FROM t2, t1 WHERE t2.col_1_int <= t1.col_1_int; expect one record SELECT * FROM t1; col_1_int col_2_text 3 row to keep DROP TABLE t1; DROP TABLE t2; # # Bug #20949314: PARTITION_HELPER::PH_RND_INIT(BOOL): ASSERTION # 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; c1 DROP TABLE t1; DROP TABLE t2; # # Bug#20819189: Assert if .frm exists but no partitioned InnoDB table # CREATE TABLE t1 (a int) ENGINE=InnoDB PARTITION BY HASH (a) PARTITIONS 2; SELECT * FROM t2; ERROR HY000: Got error 122 from storage engine FLUSH TABLE t2; DROP TABLE t1; # # Bug#21211524: CRASH IN ACTUAL_KEY_PARTS WITH PARTITIONED TABLES # 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 ""; col1 col2 DROP TABLE t1; # # Bug#21794110: ASSERTION `MP->COUNT > 0 && MY_THREAD_EQUAL # 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; Table Create Table t1 CREATE TABLE `t1` ( `col1` int(10) unsigned NOT NULL AUTO_INCREMENT, `col2` char(10) DEFAULT NULL, PRIMARY KEY (`col1`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 /*!50100 PARTITION BY HASH (col1) PARTITIONS 2 */ DROP TABLE t1; # # Bug#21620577: ASSERTION H->ACTIVE_INDEX == 64 # 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; col2 NULL DROP TABLE t1; # # Bug#21754608: HANDLE_FATAL_SIGNAL PARTITION_HELPER::PH_READ_RANGE_FIRST # 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); SELECT * from t1 WHERE col1 BETWEEN '2000-01-01 01:02:00' AND '2000-01-01 01:03:00'; col1 col2 col3 DROP TABLE t1; # # Bug#21755994 ALTER INPLACE CRASHES ON A INNODB TABLE WITH PARTITION ON SEPARATE TABLESPACE # 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)); Warnings: Warning 1681 'InnoDB : A table partition in a shared tablespace' is deprecated and will be removed in a future release. ALTER TABLE t1 ADD COLUMN f int; DROP TABLE t1; DROP TABLESPACE ts1; # # Bug#21796845 ASSERT ERR == DB_SUCCESS, ROW_QUIESCE_TABLE_START(), FLUSH TABLES FOR EXPORT # 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); Warnings: Warning 1681 'InnoDB : A table partition in a shared tablespace' is deprecated and will be removed in a future release. FLUSH table t1 FOR EXPORT; Warnings: Warning 1809 InnoDB: Table '`test`.`t1` /* Partition `p1` */' in system tablespace Warning 1235 InnoDB: This version of MySQL doesn't yet support 'FLUSH TABLES FOR EXPORT on table `test`.`t1` /* Partition `p3` */ in a general tablespace.' Warning 1809 InnoDB: Table '`test`.`t1` /* Partition `p4` */' in system tablespace UNLOCK TABLES; DROP TABLE t1; DROP TABLESPACE ts1; # # Bug#21957001 INNODB: FAILING ASSERTION: 0 IN FILE HA_INNOPART.CC LINE 3526 # 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'; TABLE_ROWS 0 Warnings: Warning 1013 InnoDB: Trying to get the free space for partition `test`.`t1` /* Partition `p3` */ but its tablespace has been discarded or the .ibd file is missing. Setting the free space of the partition to zero. ALTER TABLE t1 DISCARD PARTITION p1 TABLESPACE; SELECT TABLE_ROWS FROM information_schema.tables where table_name = 't1'; TABLE_ROWS 0 Warnings: Warning 1013 InnoDB: Trying to get the free space for partition `test`.`t1` /* Partition `p1` */ but its tablespace has been discarded or the .ibd file is missing. Setting the free space of the partition to zero. Warning 1013 InnoDB: Trying to get the free space for partition `test`.`t1` /* Partition `p3` */ but its tablespace has been discarded or the .ibd file is missing. Setting the free space of the partition to zero. ALTER TABLE t1 DISCARD PARTITION p2 TABLESPACE; SELECT TABLE_ROWS FROM information_schema.tables where table_name = 't1'; TABLE_ROWS 0 Warnings: Warning 1013 InnoDB: Trying to get the free space for partition `test`.`t1` /* Partition `p1` */ but its tablespace has been discarded or the .ibd file is missing. Setting the free space of the partition to zero. Warning 1013 InnoDB: Trying to get the free space for partition `test`.`t1` /* Partition `p2` */ but its tablespace has been discarded or the .ibd file is missing. Setting the free space of the partition to zero. Warning 1013 InnoDB: Trying to get the free space for partition `test`.`t1` /* Partition `p3` */ but its tablespace has been discarded or the .ibd file is missing. Setting the free space of the partition to zero. ALTER TABLE t1 DISCARD PARTITION p0 TABLESPACE; SELECT TABLE_ROWS FROM information_schema.tables where table_name = 't1'; TABLE_ROWS 0 Warnings: Warning 1013 InnoDB: Trying to get the free space for partition `test`.`t1` /* Partition `p0` */ but its tablespace has been discarded or the .ibd file is missing. Setting the free space of the partition to zero. Warning 1013 InnoDB: Trying to get the free space for partition `test`.`t1` /* Partition `p1` */ but its tablespace has been discarded or the .ibd file is missing. Setting the free space of the partition to zero. Warning 1013 InnoDB: Trying to get the free space for partition `test`.`t1` /* Partition `p2` */ but its tablespace has been discarded or the .ibd file is missing. Setting the free space of the partition to zero. Warning 1013 InnoDB: Trying to get the free space for partition `test`.`t1` /* Partition `p3` */ but its tablespace has been discarded or the .ibd file is missing. Setting the free space of the partition to zero. 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'; TABLE_ROWS 0 Warnings: Warning 1013 InnoDB: Trying to get the free space for partition `test`.`t1` /* Partition `p0` */ but its tablespace has been discarded or the .ibd file is missing. Setting the free space of the partition to zero. Warning 1013 InnoDB: Trying to get the free space for partition `test`.`t1` /* Partition `p1` */ but its tablespace has been discarded or the .ibd file is missing. Setting the free space of the partition to zero. Warning 1013 InnoDB: Trying to get the free space for partition `test`.`t1` /* Partition `p2` */ but its tablespace has been discarded or the .ibd file is missing. Setting the free space of the partition to zero. Warning 1013 InnoDB: Trying to get the free space for partition `test`.`t1` /* Partition `p3` */ but its tablespace has been discarded or the .ibd file is missing. Setting the free space of the partition to zero. DROP TABLE t1; # # Bug#21864838: SIG11 IN FIELD_BLOB::CMP| AT SQL/FIELD.CC # 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; col1 3 DROP TABLE t1; DROP TABLE t2; # # Bug #21881155: UNINTIALIZED READ IN KEY_REC_CMP CAUSE CRASH LATER # 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; 1 DROP TABLE t1; # # Bug#21914047 SHOW CREATE DUMPS AFTER ALTER ON INNODB TABLE WITH PARTITIONS USING TABLESPACE # 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); Warnings: Warning 1681 'InnoDB : A table partition in a shared tablespace' is deprecated and will be removed in a future release. SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( `a` int(11) NOT NULL, PRIMARY KEY (`a`) ) /*!50100 TABLESPACE `ts2` */ ENGINE=InnoDB DEFAULT CHARSET=latin1 /*!50100 PARTITION BY RANGE (a) (PARTITION p1 VALUES LESS THAN (2) TABLESPACE = `ts1` ENGINE = InnoDB, PARTITION p2 VALUES LESS THAN (4) TABLESPACE = `innodb_system` ENGINE = InnoDB, PARTITION p3 VALUES LESS THAN (6) TABLESPACE = `ts2` ENGINE = InnoDB, PARTITION p4 VALUES LESS THAN (8) TABLESPACE = `innodb_file_per_table` ENGINE = InnoDB) */ 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; partition_name space_type space_name test/t1#p#p1 General ts1 test/t1#p#p2 System NULL test/t1#p#p3 General ts2 test/t1#p#p4 Single test/t1#p#p4 ALTER TABLE t1 ADD COLUMN b int; SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( `a` int(11) NOT NULL, `b` int(11) DEFAULT NULL, PRIMARY KEY (`a`) ) /*!50100 TABLESPACE `ts2` */ ENGINE=InnoDB DEFAULT CHARSET=latin1 /*!50100 PARTITION BY RANGE (a) (PARTITION p1 VALUES LESS THAN (2) TABLESPACE = `ts1` ENGINE = InnoDB, PARTITION p2 VALUES LESS THAN (4) TABLESPACE = `innodb_system` ENGINE = InnoDB, PARTITION p3 VALUES LESS THAN (6) TABLESPACE = `ts2` ENGINE = InnoDB, PARTITION p4 VALUES LESS THAN (8) TABLESPACE = `innodb_file_per_table` ENGINE = InnoDB) */ 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; partition_name space_type space_name test/t1#p#p1 General ts1 test/t1#p#p2 System NULL test/t1#p#p3 General ts2 test/t1#p#p4 Single test/t1#p#p4 ALTER TABLE t1 ADD COLUMN c int, TABLESPACE ts1; Warnings: Warning 1681 'InnoDB : A table partition in a shared tablespace' is deprecated and will be removed in a future release. SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( `a` int(11) NOT NULL, `b` int(11) DEFAULT NULL, `c` int(11) DEFAULT NULL, PRIMARY KEY (`a`) ) /*!50100 TABLESPACE `ts1` */ ENGINE=InnoDB DEFAULT CHARSET=latin1 /*!50100 PARTITION BY RANGE (a) (PARTITION p1 VALUES LESS THAN (2) TABLESPACE = `ts1` ENGINE = InnoDB, PARTITION p2 VALUES LESS THAN (4) TABLESPACE = `innodb_system` ENGINE = InnoDB, PARTITION p3 VALUES LESS THAN (6) TABLESPACE = `ts2` ENGINE = InnoDB, PARTITION p4 VALUES LESS THAN (8) TABLESPACE = `innodb_file_per_table` ENGINE = InnoDB) */ 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; partition_name space_type space_name test/t1#p#p1 General ts1 test/t1#p#p2 System NULL test/t1#p#p3 General ts2 test/t1#p#p4 Single test/t1#p#p4 ALTER TABLE t1 ADD PARTITION (PARTITION p5 VALUES LESS THAN (10) TABLESPACE ts2); Warnings: Warning 1681 'InnoDB : A table partition in a shared tablespace' is deprecated and will be removed in a future release. SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( `a` int(11) NOT NULL, `b` int(11) DEFAULT NULL, `c` int(11) DEFAULT NULL, PRIMARY KEY (`a`) ) /*!50100 TABLESPACE `ts1` */ ENGINE=InnoDB DEFAULT CHARSET=latin1 /*!50100 PARTITION BY RANGE (a) (PARTITION p1 VALUES LESS THAN (2) TABLESPACE = `ts1` ENGINE = InnoDB, PARTITION p2 VALUES LESS THAN (4) TABLESPACE = `innodb_system` ENGINE = InnoDB, PARTITION p3 VALUES LESS THAN (6) TABLESPACE = `ts2` ENGINE = InnoDB, PARTITION p4 VALUES LESS THAN (8) TABLESPACE = `innodb_file_per_table` ENGINE = InnoDB, PARTITION p5 VALUES LESS THAN (10) TABLESPACE = `ts2` ENGINE = InnoDB) */ 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; partition_name space_type space_name test/t1#p#p1 General ts1 test/t1#p#p2 System NULL test/t1#p#p3 General ts2 test/t1#p#p4 Single test/t1#p#p4 test/t1#p#p5 General ts2 ALTER TABLE t1 ADD PARTITION (PARTITION p6 VALUES LESS THAN (12)); Warnings: Warning 1681 'InnoDB : A table partition in a shared tablespace' is deprecated and will be removed in a future release. SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( `a` int(11) NOT NULL, `b` int(11) DEFAULT NULL, `c` int(11) DEFAULT NULL, PRIMARY KEY (`a`) ) /*!50100 TABLESPACE `ts1` */ ENGINE=InnoDB DEFAULT CHARSET=latin1 /*!50100 PARTITION BY RANGE (a) (PARTITION p1 VALUES LESS THAN (2) TABLESPACE = `ts1` ENGINE = InnoDB, PARTITION p2 VALUES LESS THAN (4) TABLESPACE = `innodb_system` ENGINE = InnoDB, PARTITION p3 VALUES LESS THAN (6) TABLESPACE = `ts2` ENGINE = InnoDB, PARTITION p4 VALUES LESS THAN (8) TABLESPACE = `innodb_file_per_table` ENGINE = InnoDB, PARTITION p5 VALUES LESS THAN (10) TABLESPACE = `ts2` ENGINE = InnoDB, PARTITION p6 VALUES LESS THAN (12) TABLESPACE = `ts1` ENGINE = InnoDB) */ 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; partition_name space_type space_name test/t1#p#p1 General ts1 test/t1#p#p2 System NULL test/t1#p#p3 General ts2 test/t1#p#p4 Single test/t1#p#p4 test/t1#p#p5 General ts2 test/t1#p#p6 General ts1 ALTER TABLE t1 REORGANIZE PARTITION p4 INTO (PARTITION p4 VALUES LESS THAN (8)); Warnings: Warning 1681 'InnoDB : A table partition in a shared tablespace' is deprecated and will be removed in a future release. SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( `a` int(11) NOT NULL, `b` int(11) DEFAULT NULL, `c` int(11) DEFAULT NULL, PRIMARY KEY (`a`) ) /*!50100 TABLESPACE `ts1` */ ENGINE=InnoDB DEFAULT CHARSET=latin1 /*!50100 PARTITION BY RANGE (a) (PARTITION p1 VALUES LESS THAN (2) TABLESPACE = `ts1` ENGINE = InnoDB, PARTITION p2 VALUES LESS THAN (4) TABLESPACE = `innodb_system` ENGINE = InnoDB, PARTITION p3 VALUES LESS THAN (6) TABLESPACE = `ts2` ENGINE = InnoDB, PARTITION p4 VALUES LESS THAN (8) TABLESPACE = `ts1` ENGINE = InnoDB, PARTITION p5 VALUES LESS THAN (10) TABLESPACE = `ts2` ENGINE = InnoDB, PARTITION p6 VALUES LESS THAN (12) TABLESPACE = `ts1` ENGINE = InnoDB) */ 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; partition_name space_type space_name test/t1#p#p1 General ts1 test/t1#p#p2 System NULL test/t1#p#p3 General ts2 test/t1#p#p4 General ts1 test/t1#p#p5 General ts2 test/t1#p#p6 General ts1 ALTER TABLE t1 REORGANIZE PARTITION p3 INTO (PARTITION p3 VALUES LESS THAN (6) TABLESPACE innodb_system); Warnings: Warning 1681 'InnoDB : A table partition in a shared tablespace' is deprecated and will be removed in a future release. SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( `a` int(11) NOT NULL, `b` int(11) DEFAULT NULL, `c` int(11) DEFAULT NULL, PRIMARY KEY (`a`) ) /*!50100 TABLESPACE `ts1` */ ENGINE=InnoDB DEFAULT CHARSET=latin1 /*!50100 PARTITION BY RANGE (a) (PARTITION p1 VALUES LESS THAN (2) TABLESPACE = `ts1` ENGINE = InnoDB, PARTITION p2 VALUES LESS THAN (4) TABLESPACE = `innodb_system` ENGINE = InnoDB, PARTITION p3 VALUES LESS THAN (6) TABLESPACE = `innodb_system` ENGINE = InnoDB, PARTITION p4 VALUES LESS THAN (8) TABLESPACE = `ts1` ENGINE = InnoDB, PARTITION p5 VALUES LESS THAN (10) TABLESPACE = `ts2` ENGINE = InnoDB, PARTITION p6 VALUES LESS THAN (12) TABLESPACE = `ts1` ENGINE = InnoDB) */ 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; partition_name space_type space_name test/t1#p#p1 General ts1 test/t1#p#p2 System NULL test/t1#p#p3 System NULL test/t1#p#p4 General ts1 test/t1#p#p5 General ts2 test/t1#p#p6 General ts1 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); Warnings: Warning 1681 'InnoDB : A table partition in a shared tablespace' is deprecated and will be removed in a future release. SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( `a` int(11) NOT NULL, PRIMARY KEY (`a`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 /*!50100 PARTITION BY RANGE (a) (PARTITION p1 VALUES LESS THAN (2) TABLESPACE = `ts1` ENGINE = InnoDB, PARTITION p2 VALUES LESS THAN (4) TABLESPACE = `innodb_system` ENGINE = InnoDB, PARTITION p3 VALUES LESS THAN (6) ENGINE = InnoDB, PARTITION p4 VALUES LESS THAN (8) TABLESPACE = `innodb_file_per_table` ENGINE = InnoDB) */ 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; partition_name space_type space_name test/t1#p#p1 General ts1 test/t1#p#p2 System NULL test/t1#p#p3 Single test/t1#p#p3 test/t1#p#p4 Single test/t1#p#p4 ALTER TABLE t1 ADD COLUMN b int; SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( `a` int(11) NOT NULL, `b` int(11) DEFAULT NULL, PRIMARY KEY (`a`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 /*!50100 PARTITION BY RANGE (a) (PARTITION p1 VALUES LESS THAN (2) TABLESPACE = `ts1` ENGINE = InnoDB, PARTITION p2 VALUES LESS THAN (4) TABLESPACE = `innodb_system` ENGINE = InnoDB, PARTITION p3 VALUES LESS THAN (6) ENGINE = InnoDB, PARTITION p4 VALUES LESS THAN (8) TABLESPACE = `innodb_file_per_table` ENGINE = InnoDB) */ 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; partition_name space_type space_name test/t1#p#p1 General ts1 test/t1#p#p2 System NULL test/t1#p#p3 Single test/t1#p#p3 test/t1#p#p4 Single test/t1#p#p4 ALTER TABLE t1 ADD COLUMN c int, TABLESPACE ts1; Warnings: Warning 1681 'InnoDB : A table partition in a shared tablespace' is deprecated and will be removed in a future release. SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( `a` int(11) NOT NULL, `b` int(11) DEFAULT NULL, `c` int(11) DEFAULT NULL, PRIMARY KEY (`a`) ) /*!50100 TABLESPACE `ts1` */ ENGINE=InnoDB DEFAULT CHARSET=latin1 /*!50100 PARTITION BY RANGE (a) (PARTITION p1 VALUES LESS THAN (2) TABLESPACE = `ts1` ENGINE = InnoDB, PARTITION p2 VALUES LESS THAN (4) TABLESPACE = `innodb_system` ENGINE = InnoDB, PARTITION p3 VALUES LESS THAN (6) ENGINE = InnoDB, PARTITION p4 VALUES LESS THAN (8) TABLESPACE = `innodb_file_per_table` ENGINE = InnoDB) */ 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; partition_name space_type space_name test/t1#p#p1 General ts1 test/t1#p#p2 System NULL test/t1#p#p3 Single test/t1#p#p3 test/t1#p#p4 Single test/t1#p#p4 ALTER TABLE t1 ADD PARTITION (PARTITION p5 VALUES LESS THAN (10) TABLESPACE ts2); Warnings: Warning 1681 'InnoDB : A table partition in a shared tablespace' is deprecated and will be removed in a future release. SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( `a` int(11) NOT NULL, `b` int(11) DEFAULT NULL, `c` int(11) DEFAULT NULL, PRIMARY KEY (`a`) ) /*!50100 TABLESPACE `ts1` */ ENGINE=InnoDB DEFAULT CHARSET=latin1 /*!50100 PARTITION BY RANGE (a) (PARTITION p1 VALUES LESS THAN (2) TABLESPACE = `ts1` ENGINE = InnoDB, PARTITION p2 VALUES LESS THAN (4) TABLESPACE = `innodb_system` ENGINE = InnoDB, PARTITION p3 VALUES LESS THAN (6) ENGINE = InnoDB, PARTITION p4 VALUES LESS THAN (8) TABLESPACE = `innodb_file_per_table` ENGINE = InnoDB, PARTITION p5 VALUES LESS THAN (10) TABLESPACE = `ts2` ENGINE = InnoDB) */ 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; partition_name space_type space_name test/t1#p#p1 General ts1 test/t1#p#p2 System NULL test/t1#p#p3 Single test/t1#p#p3 test/t1#p#p4 Single test/t1#p#p4 test/t1#p#p5 General ts2 ALTER TABLE t1 ADD PARTITION (PARTITION p6 VALUES LESS THAN (12)); Warnings: Warning 1681 'InnoDB : A table partition in a shared tablespace' is deprecated and will be removed in a future release. SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( `a` int(11) NOT NULL, `b` int(11) DEFAULT NULL, `c` int(11) DEFAULT NULL, PRIMARY KEY (`a`) ) /*!50100 TABLESPACE `ts1` */ ENGINE=InnoDB DEFAULT CHARSET=latin1 /*!50100 PARTITION BY RANGE (a) (PARTITION p1 VALUES LESS THAN (2) TABLESPACE = `ts1` ENGINE = InnoDB, PARTITION p2 VALUES LESS THAN (4) TABLESPACE = `innodb_system` ENGINE = InnoDB, PARTITION p3 VALUES LESS THAN (6) ENGINE = InnoDB, PARTITION p4 VALUES LESS THAN (8) TABLESPACE = `innodb_file_per_table` ENGINE = InnoDB, PARTITION p5 VALUES LESS THAN (10) TABLESPACE = `ts2` ENGINE = InnoDB, PARTITION p6 VALUES LESS THAN (12) TABLESPACE = `ts1` ENGINE = InnoDB) */ 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; partition_name space_type space_name test/t1#p#p1 General ts1 test/t1#p#p2 System NULL test/t1#p#p3 Single test/t1#p#p3 test/t1#p#p4 Single test/t1#p#p4 test/t1#p#p5 General ts2 test/t1#p#p6 General ts1 ALTER TABLE t1 REORGANIZE PARTITION p4 INTO (PARTITION p4 VALUES LESS THAN (8)); Warnings: Warning 1681 'InnoDB : A table partition in a shared tablespace' is deprecated and will be removed in a future release. SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( `a` int(11) NOT NULL, `b` int(11) DEFAULT NULL, `c` int(11) DEFAULT NULL, PRIMARY KEY (`a`) ) /*!50100 TABLESPACE `ts1` */ ENGINE=InnoDB DEFAULT CHARSET=latin1 /*!50100 PARTITION BY RANGE (a) (PARTITION p1 VALUES LESS THAN (2) TABLESPACE = `ts1` ENGINE = InnoDB, PARTITION p2 VALUES LESS THAN (4) TABLESPACE = `innodb_system` ENGINE = InnoDB, PARTITION p3 VALUES LESS THAN (6) ENGINE = InnoDB, PARTITION p4 VALUES LESS THAN (8) TABLESPACE = `ts1` ENGINE = InnoDB, PARTITION p5 VALUES LESS THAN (10) TABLESPACE = `ts2` ENGINE = InnoDB, PARTITION p6 VALUES LESS THAN (12) TABLESPACE = `ts1` ENGINE = InnoDB) */ 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; partition_name space_type space_name test/t1#p#p1 General ts1 test/t1#p#p2 System NULL test/t1#p#p3 Single test/t1#p#p3 test/t1#p#p4 General ts1 test/t1#p#p5 General ts2 test/t1#p#p6 General ts1 ALTER TABLE t1 REORGANIZE PARTITION p3 INTO (PARTITION p3 VALUES LESS THAN (6) TABLESPACE innodb_system); Warnings: Warning 1681 'InnoDB : A table partition in a shared tablespace' is deprecated and will be removed in a future release. SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( `a` int(11) NOT NULL, `b` int(11) DEFAULT NULL, `c` int(11) DEFAULT NULL, PRIMARY KEY (`a`) ) /*!50100 TABLESPACE `ts1` */ ENGINE=InnoDB DEFAULT CHARSET=latin1 /*!50100 PARTITION BY RANGE (a) (PARTITION p1 VALUES LESS THAN (2) TABLESPACE = `ts1` ENGINE = InnoDB, PARTITION p2 VALUES LESS THAN (4) TABLESPACE = `innodb_system` ENGINE = InnoDB, PARTITION p3 VALUES LESS THAN (6) TABLESPACE = `innodb_system` ENGINE = InnoDB, PARTITION p4 VALUES LESS THAN (8) TABLESPACE = `ts1` ENGINE = InnoDB, PARTITION p5 VALUES LESS THAN (10) TABLESPACE = `ts2` ENGINE = InnoDB, PARTITION p6 VALUES LESS THAN (12) TABLESPACE = `ts1` ENGINE = InnoDB) */ 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; partition_name space_type space_name test/t1#p#p1 General ts1 test/t1#p#p2 System NULL test/t1#p#p3 System NULL test/t1#p#p4 General ts1 test/t1#p#p5 General ts2 test/t1#p#p6 General ts1 DROP TABLE t1; DROP TABLESPACE ts1; DROP TABLESPACE ts2; # # Bug#22444530 - GCOLS + PARTITIONED TABLE, CRASH IN # set sql_mode=''; Warnings: Warning 3090 Changing sql mode 'NO_AUTO_CREATE_USER' is deprecated. It will be removed in a future release. 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; b 1 drop table t; 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; b a drop table t; # # Bug#23037025 COL+PARTITION SIG11 IN ROW_SEL_STORE_MYSQL_REC # 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; INSERT IGNORE INTO t1(col1) values(NULL); INSERT INTO t2 VALUES(1); ERROR 23000: Column 'col2' cannot be null DROP TRIGGER t2_trig1; DROP TABLE t3; DROP TABLE t2; DROP TABLE t1; # # Bug#23194259 ASSERTION FAILURE:TRX0TRX.H:1416:SRV_READ_ONLY_MODE # CREATE TABLE t1(col1 INT AS(1), KEY(col1)) ENGINE=INNODB PARTITION BY KEY(col1) PARTITIONS 2; SELECT * FROM t1 WHERE sha(uuid_short()); col1 DROP TABLE t1;
Close