Linux ip-172-26-2-223 5.4.0-1018-aws #18-Ubuntu SMP Wed Jun 24 01:15:00 UTC 2020 x86_64
Apache
: 172.26.2.223 | : 18.221.207.166
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 : default_row_format_16k.result
# # BUG#21816041 - ROW_FORMAT=DYNAMIC IS RESTRICTIVE THAN ROW_FORMAT=COMPACT # CREATE TABLE t1 (a VARCHAR(300), b VARCHAR(16383) CHARACTER SET UTF8MB3, PRIMARY KEY(a(255), b(255))) ENGINE=INNODB ROW_FORMAT=DYNAMIC; DROP TABLE t1; CREATE TABLE t1 (a VARCHAR(300), b VARCHAR(16383) CHARACTER SET UTF8MB3, PRIMARY KEY(a(255))) ENGINE=INNODB ROW_FORMAT=DYNAMIC; DROP TABLE t1; CREATE TABLE t1 (a VARCHAR(300), b VARCHAR(16280) CHARACTER SET UTF8MB4, PRIMARY KEY(a(255), b(255))) ENGINE=INNODB ROW_FORMAT=DYNAMIC; DROP TABLE t1; CREATE TABLE t1 (a VARCHAR(16383) CHARACTER SET UTF8MB4) ENGINE=INNODB ROW_FORMAT=DYNAMIC; ALTER TABLE t1 ADD PRIMARY KEY(a(100)); DROP TABLE t1; CREATE TABLE t1 (a VARCHAR(16383) CHARACTER SET UTF8MB3, PRIMARY KEY(a(255))) ENGINE=INNODB ROW_FORMAT=DYNAMIC; DROP TABLE t1; CREATE TABLE t1 (a VARCHAR(12383) CHARACTER SET UTF8MB3, PRIMARY KEY(a(255)), KEY k1(a(1024))) ENGINE=INNODB ROW_FORMAT=DYNAMIC; INSERT INTO t1 VALUES(REPEAT('A', 500)); UPDATE t1 SET a = REPEAT('B', 999); DROP TABLE t1; CREATE TABLE t1 (a VARCHAR(16383) CHARACTER SET UTF8MB3, PRIMARY KEY(a(255))) ENGINE=INNODB ROW_FORMAT=DYNAMIC; DROP TABLE t1; CREATE TABLE t1 (a VARCHAR(16383), b VARCHAR(3000), c TEXT, PRIMARY KEY(a(255), c(10)), KEY k1(a(500)), KEY k2(b(72), c(3000))) ENGINE=INNODB ROW_FORMAT=DYNAMIC; DROP TABLE t1; CREATE TABLE t1 (a VARCHAR(3070) , b TEXT, PRIMARY KEY(a(400)), KEY k1(a)) ENGINE=INNODB ROW_FORMAT=DYNAMIC; DROP TABLE t1; CREATE TABLE t1 (a VARCHAR(3000) , b TEXT, c INT, d TEXT, PRIMARY KEY(a, b(3), c), KEY k1(a, b(25))) ENGINE=INNODB ROW_FORMAT=DYNAMIC; DROP TABLE t1; CREATE TABLE t1 (a INT , b TEXT, PRIMARY KEY(a, b(3)), KEY k1(a)) ENGINE=INNODB ROW_FORMAT=DYNAMIC; DROP TABLE t1; CREATE TABLE t1(a CHAR(10), KEY(a(5))); DROP TABLE t1; CREATE TABLE t1(a CHAR(255), KEY(a(200))); DROP TABLE t1; CREATE TABLE t1(a CHAR(255), KEY(a)); DROP TABLE t1; CREATE TABLE t1(a VARCHAR(4000), KEY(a(2000))); DROP TABLE t1; CREATE TABLE t1(a VARCHAR(2000), PRIMARY KEY (a), KEY k1(a(2000))); DROP TABLE t1; CREATE TABLE t1(a VARCHAR(5000), PRIMARY KEY (a(3000)), KEY k1(a(2000))); DROP TABLE t1; CREATE TABLE t1 ( c1 INT AUTO_INCREMENT, c2 GEOMETRY NOT NULL, PRIMARY KEY(c1), SPATIAL INDEX(c2) ) ENGINE=INNODB; DROP TABLE t1; CREATE TABLE t1(a TEXT, b TEXT, c TEXT, FULLTEXT `AB`(a, b), FULLTEXT `C1`(c)); DROP TABLE t1; CREATE TABLE t1 ( col_1_VARBINARY VARBINARY (4000) , col_2_VARCHAR VARCHAR (4000) , col_3_TEXT TEXT (4000), col_4_BLOB BLOB (4000), col_5_TEXT TEXT (4000), col_6_TEXT TEXT (4000), col_7_TEXT TEXT (4000), col_8_TEXT TEXT (4000), col_9_TEXT TEXT (4000), col_10_TEXT TEXT (4000), col_11_TEXT TEXT (4000), col_12_TEXT TEXT (4000), col_13_TEXT TEXT (4000), col_14_TEXT TEXT (4000), col_15_TEXT TEXT (4000), col_16_TEXT TEXT (4000), col_17_TEXT TEXT (4000), col_18_TEXT TEXT (4000), col_19_TEXT TEXT (4000), col_20_TEXT TEXT (4000), col_21_TEXT TEXT (4000), col_22_TEXT TEXT (4000), col_23_TEXT TEXT (4000), col_24_BINARY BINARY (255) ) ROW_FORMAT=DYNAMIC, engine = innodb; INSERT INTO t1 VALUES( repeat("a", 4000), repeat("o", 4000), repeat("a", 4000), repeat("o", 4000), repeat("a", 4000), repeat("o", 4000), repeat("a", 4000), repeat("o", 4000), repeat("a", 4000), repeat("o", 4000), repeat("a", 4000), repeat("o", 4000), repeat("a", 4000), repeat("o", 4000), repeat("a", 4000), repeat("o", 4000), repeat("a", 4000), repeat("o", 4000), repeat("a", 4000), repeat("o", 4000), repeat("a", 4000), repeat("o", 4000), repeat("a", 4000), repeat("a", 255) ); CREATE INDEX prefix_idx1 ON t1(col_1_VARBINARY (767)); CREATE INDEX prefix_idx2 ON t1(col_2_VARCHAR (767)); CREATE INDEX prefix_idx3 ON t1(col_3_TEXT (767)); CREATE INDEX prefix_idx4 ON t1(col_4_BLOB (767)); CREATE INDEX prefix_idx5 ON t1(col_5_TEXT (767)); CREATE INDEX prefix_idx6 ON t1(col_6_TEXT (767)); CREATE INDEX prefix_idx7 ON t1(col_7_TEXT (767)); CREATE INDEX prefix_idx8 ON t1(col_8_TEXT (767)); CREATE INDEX prefix_idx9 ON t1(col_9_TEXT (767)); CREATE INDEX prefix_idx10 ON t1(col_10_TEXT (767)); CREATE INDEX prefix_idx11 ON t1(col_11_TEXT (767)); CREATE INDEX prefix_idx12 ON t1(col_12_TEXT (767)); CREATE INDEX prefix_idx13 ON t1(col_13_TEXT (767)); CREATE INDEX prefix_idx14 ON t1(col_14_TEXT (767)); CREATE INDEX prefix_idx15 ON t1(col_15_TEXT (767)); CREATE INDEX prefix_idx16 ON t1(col_16_TEXT (767)); CREATE INDEX prefix_idx17 ON t1(col_17_TEXT (767)); CREATE INDEX prefix_idx18 ON t1(col_18_TEXT (767)); CREATE INDEX prefix_idx19 ON t1(col_19_TEXT (767)); CREATE INDEX prefix_idx24 ON t1(col_24_BINARY (250)); UPDATE t1 SET col_1_VARBINARY = repeat("x", 4000), col_2_VARCHAR= repeat("c", 4000) WHERE col_1_VARBINARY = repeat("a", 4000) AND col_2_VARCHAR = repeat("o", 4000); ERROR HY000: Undo log record is too big. DROP TABLE t1; CREATE TABLE t1(a INT, b FLOAT, c CHAR(10), v1 VARCHAR(1001), v2 VARCHAR(1002), vx_blob BLOB, vx_text TEXT, vx_varchar VARCHAR(3005), v3 VARCHAR(1006), v4 VARCHAR(1007), PRIMARY KEY (a,b,c,vx_text(200))) ROW_FORMAT=DYNAMIC; CREATE INDEX idx1 ON t1(a,b,c); CREATE INDEX idx2 ON t1(a,v1(101)); CREATE INDEX idx3 ON t1(b,v2(102)); CREATE INDEX idx4 ON t1(c,vx_blob(3003)); CREATE INDEX idx5 ON t1(a,vx_text(1004)); SHOW WARNINGS; Level Code Message INSERT INTO t1 VALUES(1,1,'111111111', repeat('a',1001), repeat('a',1002), repeat('a',4003), repeat('a',3004), repeat('a',3005), repeat('a',1006), repeat('a',1007)); UPDATE t1 SET v1=repeat('b',1001), v2=repeat('b',1002), vx_blob=repeat('b',4003), vx_varchar=repeat('b',3005), v3=repeat('b',1006), v4=repeat('b',1007); DROP TABLE t1; create table t1(a int, b float, c char(10), d date, vx_varchar varchar(10000), vx_text text, vx_blob BLOB, v1 varchar(1000), v2 varchar(1000), v3 varchar(1000), v4 varchar(3000)) ROW_FORMAT=DYNAMIC; create index idx1 on t1(a,b,c,d); create index idx2 on t1(vx_varchar(2000)); create index idx3 on t1(vx_text(2000)); create index idx8 on t1(vx_blob(2000)); create index idx4 on t1(v1); create index idx5 on t1(v2); create index idx6 on t1(v3); create index idx7 on t1(v4); insert into t1 values(1,1,'111111111', '2011-07-11', repeat('a',10000), repeat('a',10000), repeat('a',10000), repeat('a',1000), repeat('a',1000), repeat('a',1000), repeat('a',3000)); update t1 set a=2,b=2,c='2222222222',d='2011-07-12', vx_varchar=repeat('b',10000), vx_text=repeat('b',10000), vx_blob=repeat('b',10000), v1=repeat('b',1000), v2=repeat('b',1000), v3=repeat('b',1000), v4=repeat('b',3000); ERROR HY000: Undo log record is too big. drop table t1; CREATE TABLE t1(x VARCHAR(300), y VARCHAR(200), KEY k1(y,x)); ALTER TABLE t1 ADD INDEX k2(x(10)); DROP TABLE t1; SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( `c1` text, `c2` text, `c3` text, `c4` text, `c5` text, `c6` text, `c7` text, `c8` text, `c9` text, `c10` text, `c11` text, `c12` text, `c13` text, `c14` text, `c15` text, `c16` text, `c17` text, `c18` text, `c19` text, `c20` text, `c21` text, `c22` text, `c23` text, `c24` text, `c25` text, `c26` text, `c27` text, `c28` text, `c29` text, `c30` text, `c31` text, `c32` text, `c33` text, `c34` text, `c35` text, `c36` text, `c37` text, `c38` text, `c39` text, `c40` text, `c41` text, `c42` text, `c43` text, `c44` text, `c45` text, `c46` text, `c47` text, `c48` text, `c49` text, `c50` text, `c51` text, `c52` text, `c53` text, `c54` text, `c55` text, `c56` text, `c57` text, `c58` text, `c59` text, `c60` text, `c61` text, `c62` text, `c63` text, `c64` text, `c65` text, `c66` text, `c67` text, `c68` text, `c69` text, `c70` text, `c71` text, `c72` text, `c73` text, `c74` text, `c75` text, `c76` text, `c77` text, `c78` text, `c79` text, `c80` text, `c81` text, `c82` text, `c83` text, `c84` text, `c85` text, `c86` text, `c87` text, `c88` text, `c89` text, `c90` text, `c91` text, `c92` text, `c93` text, `c94` text, `c95` text, `c96` text, `c97` text, `c98` text, `c99` text, `c100` text, `c101` text, `c102` text, `c103` text, `c104` text, `c105` text, `c106` text, `c107` text, `c108` text, `c109` text, `c110` text, `c111` text, `c112` text, `c113` text, `c114` text, `c115` text, `c116` text, `c117` text, `c118` text, `c119` text, `c120` text, `c121` text, `c122` text, `c123` text, `c124` text, `c125` text, `c126` text, `c127` text, `c128` text, `c129` text, `c130` text, `c131` text, `c132` text, `c133` text, `c134` text, `c135` text, `c136` text, `c137` text, `c138` text, `c139` text, `c140` text, `c141` text, `c142` text, `c143` text, `c144` text, `c145` text, `c146` text, `c147` text, `c148` text, `c149` text, `c150` text, `c151` text, `c152` text, `c153` text, `c154` text, `c155` text, `c156` text, `c157` text, `c158` text, `c159` text, `c160` text, `c161` text, `c162` text, `c163` text, `c164` text, `c165` text, `c166` text, `c167` text, `c168` text, `c169` text, `c170` text, `c171` text, `c172` text, `c173` text, `c174` text, `c175` text, `c176` text, `c177` text, `c178` text, `c179` text, `c180` text, `c181` text, `c182` text, `c183` text, `c184` text, `c185` text, `c186` text, `c187` text, `c188` text, `c189` text, `c190` text, `c191` text, `c192` text, `c193` text, `c194` text, `c195` text, `c196` text, KEY `k1` (`c1`(767)), KEY `k2` (`c2`(767)), KEY `k3` (`c3`(767)), KEY `k4` (`c4`(767)), KEY `k5` (`c5`(767)), KEY `k6` (`c6`(767)), KEY `k7` (`c7`(767)), KEY `k8` (`c8`(767)), KEY `k9` (`c9`(767)), KEY `k10` (`c10`(767)), KEY `k11` (`c11`(767)), KEY `k12` (`c12`(767)), KEY `k13` (`c13`(767)), KEY `k14` (`c14`(767)), KEY `k15` (`c15`(767)), KEY `k16` (`c16`(767)), KEY `k17` (`c17`(767)), KEY `k18` (`c18`(767)), KEY `k19` (`c19`(767)), KEY `k20` (`c20`(767)), KEY `k21` (`c21`(767)), KEY `k22` (`c22`(767)), KEY `k23` (`c23`(767)), KEY `k24` (`c24`(767)), KEY `k25` (`c25`(767)), KEY `k26` (`c26`(767)), KEY `k27` (`c27`(767)), KEY `k28` (`c28`(767)), KEY `k29` (`c29`(767)), KEY `k30` (`c30`(767)), KEY `k31` (`c31`(767)), KEY `k32` (`c32`(767)), KEY `k33` (`c33`(767)), KEY `k34` (`c34`(767)), KEY `k35` (`c35`(767)), KEY `k36` (`c36`(767)), KEY `k37` (`c37`(767)), KEY `k38` (`c38`(767)), KEY `k39` (`c39`(767)), KEY `k40` (`c40`(767)), KEY `k41` (`c41`(767)), KEY `k42` (`c42`(767)), KEY `k43` (`c43`(767)), KEY `k44` (`c44`(767)), KEY `k45` (`c45`(767)), KEY `k46` (`c46`(767)), KEY `k47` (`c47`(767)), KEY `k48` (`c48`(767)), KEY `k49` (`c49`(767)), KEY `k50` (`c50`(767)), KEY `k51` (`c51`(767)), KEY `k52` (`c52`(767)), KEY `k53` (`c53`(767)), KEY `k54` (`c54`(767)), KEY `k55` (`c55`(767)), KEY `k56` (`c56`(767)), KEY `k57` (`c57`(767)), KEY `k58` (`c58`(767)), KEY `k59` (`c59`(767)), KEY `k60` (`c60`(767)), KEY `k61` (`c61`(767)), KEY `k62` (`c62`(767)), KEY `k63` (`c63`(767)), KEY `k64` (`c64`(767)) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC UPDATE t1 SET c1=REPEAT('a', 65535), c2=REPEAT('b', 65535), c3=REPEAT('c', 65535), c4=REPEAT('d', 65535), c5=REPEAT('e', 65535), c6=REPEAT('f', 65535), c7=REPEAT('g', 65535), c8=REPEAT('h', 65535), c9=REPEAT('i', 65535), c10=REPEAT('j', 65535), c11=REPEAT('k', 65535), c12=REPEAT('l', 65535), c13=REPEAT('m', 65535), c14=REPEAT('n', 65535), c15=REPEAT('o', 65535); UPDATE t1 SET c14=REPEAT('a', 65535), c13=REPEAT('b', 65535), c12=REPEAT('c', 65535), c11=REPEAT('d', 65535), c10=REPEAT('e', 65535), c9=REPEAT('f', 65535), c8=REPEAT('g', 65535), c7=REPEAT('h', 65535), c6=REPEAT('i', 65535), c5=REPEAT('j', 65535), c4=REPEAT('k', 65535), c3=REPEAT('l', 65535), c2=REPEAT('m', 65535), c1=REPEAT('n', 65535); ERROR HY000: Undo log record is too big. UPDATE t1 SET c14 = REPEAT('a', 65535); DROP TABLE t1; SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( `c1` text, `c2` text, `c3` text, `c4` text, `c5` text, `c6` text, `c7` text, `c8` text, `c9` text, `c10` text, `c11` text, `c12` text, `c13` text, `c14` text, `c15` text, `c16` text, `c17` text, `c18` text, `c19` text, `c20` text, `c21` text, `c22` text, `c23` text, `c24` text, `c25` text, `c26` text, `c27` text, `c28` text, `c29` text, `c30` text, `c31` text, `c32` text, `c33` text, `c34` text, `c35` text, `c36` text, `c37` text, `c38` text, `c39` text, `c40` text, `c41` text, `c42` text, `c43` text, `c44` text, `c45` text, `c46` text, `c47` text, `c48` text, `c49` text, `c50` text, `c51` text, `c52` text, `c53` text, `c54` text, `c55` text, `c56` text, `c57` text, `c58` text, `c59` text, `c60` text, `c61` text, `c62` text, `c63` text, `c64` text, `c65` text, `c66` text, `c67` text, `c68` text, `c69` text, `c70` text, `c71` text, `c72` text, `c73` text, `c74` text, `c75` text, `c76` text, `c77` text, `c78` text, `c79` text, `c80` text, `c81` text, `c82` text, `c83` text, `c84` text, `c85` text, `c86` text, `c87` text, `c88` text, `c89` text, `c90` text, `c91` text, `c92` text, `c93` text, `c94` text, `c95` text, `c96` text, `c97` text, `c98` text, `c99` text, `c100` text, `c101` text, `c102` text, `c103` text, `c104` text, `c105` text, `c106` text, `c107` text, `c108` text, `c109` text, `c110` text, `c111` text, `c112` text, `c113` text, `c114` text, `c115` text, `c116` text, `c117` text, `c118` text, `c119` text, `c120` text, `c121` text, `c122` text, `c123` text, `c124` text, `c125` text, `c126` text, `c127` text, `c128` text, `c129` text, `c130` text, `c131` text, `c132` text, `c133` text, `c134` text, `c135` text, `c136` text, `c137` text, `c138` text, `c139` text, `c140` text, `c141` text, `c142` text, `c143` text, `c144` text, `c145` text, `c146` text, `c147` text, `c148` text, `c149` text, `c150` text, `c151` text, `c152` text, `c153` text, `c154` text, `c155` text, `c156` text, `c157` text, `c158` text, `c159` text, `c160` text, `c161` text, `c162` text, `c163` text, `c164` text, `c165` text, `c166` text, `c167` text, `c168` text, `c169` text, `c170` text, `c171` text, `c172` text, `c173` text, `c174` text, `c175` text, `c176` text, `c177` text, `c178` text, `c179` text, `c180` text, `c181` text, `c182` text, `c183` text, `c184` text, `c185` text, `c186` text, `c187` text, `c188` text, `c189` text, `c190` text, `c191` text, `c192` text, `c193` text, `c194` text, `c195` text, `c196` text, KEY `k1` (`c1`(3072)), KEY `k2` (`c2`(3072)), KEY `k3` (`c3`(3072)), KEY `k4` (`c4`(3072)), KEY `k5` (`c5`(3072)), KEY `k6` (`c6`(3072)), KEY `k7` (`c7`(3072)), KEY `k8` (`c8`(3072)), KEY `k9` (`c9`(3072)), KEY `k10` (`c10`(3072)), KEY `k11` (`c11`(3072)), KEY `k12` (`c12`(3072)), KEY `k13` (`c13`(3072)), KEY `k14` (`c14`(3072)), KEY `k15` (`c15`(3072)), KEY `k16` (`c16`(3072)), KEY `k17` (`c17`(3072)), KEY `k18` (`c18`(3072)), KEY `k19` (`c19`(3072)), KEY `k20` (`c20`(3072)), KEY `k21` (`c21`(3072)), KEY `k22` (`c22`(3072)), KEY `k23` (`c23`(3072)), KEY `k24` (`c24`(3072)), KEY `k25` (`c25`(3072)), KEY `k26` (`c26`(3072)), KEY `k27` (`c27`(3072)), KEY `k28` (`c28`(3072)), KEY `k29` (`c29`(3072)), KEY `k30` (`c30`(3072)), KEY `k31` (`c31`(3072)), KEY `k32` (`c32`(3072)), KEY `k33` (`c33`(3072)), KEY `k34` (`c34`(3072)), KEY `k35` (`c35`(3072)), KEY `k36` (`c36`(3072)), KEY `k37` (`c37`(3072)), KEY `k38` (`c38`(3072)), KEY `k39` (`c39`(3072)), KEY `k40` (`c40`(3072)), KEY `k41` (`c41`(3072)), KEY `k42` (`c42`(3072)), KEY `k43` (`c43`(3072)), KEY `k44` (`c44`(3072)), KEY `k45` (`c45`(3072)), KEY `k46` (`c46`(3072)), KEY `k47` (`c47`(3072)), KEY `k48` (`c48`(3072)), KEY `k49` (`c49`(3072)), KEY `k50` (`c50`(3072)), KEY `k51` (`c51`(3072)), KEY `k52` (`c52`(3072)), KEY `k53` (`c53`(3072)), KEY `k54` (`c54`(3072)), KEY `k55` (`c55`(3072)), KEY `k56` (`c56`(3072)), KEY `k57` (`c57`(3072)), KEY `k58` (`c58`(3072)), KEY `k59` (`c59`(3072)), KEY `k60` (`c60`(3072)), KEY `k61` (`c61`(3072)), KEY `k62` (`c62`(3072)), KEY `k63` (`c63`(3072)), KEY `k64` (`c64`(3072)) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC UPDATE t1 SET c1=REPEAT('a', 65535), c2=REPEAT('b', 65535), c3=REPEAT('c', 65535), c4=REPEAT('d', 65535), c5=REPEAT('e', 65535), c6=REPEAT('f', 65535), c7=REPEAT('g', 65535), c8=REPEAT('h', 65535), c9=REPEAT('i', 65535), c10=REPEAT('j', 65535), c11=REPEAT('k', 65535), c12=REPEAT('l', 65535), c13=REPEAT('m', 65535), c14=REPEAT('n', 65535), c15=REPEAT('o', 65535); UPDATE t1 SET c14=REPEAT('a', 65535), c13=REPEAT('b', 65535), c12=REPEAT('c', 65535), c11=REPEAT('d', 65535), c10=REPEAT('e', 65535), c9=REPEAT('f', 65535), c8=REPEAT('g', 65535), c7=REPEAT('h', 65535), c6=REPEAT('i', 65535), c5=REPEAT('j', 65535), c4=REPEAT('k', 65535), c3=REPEAT('l', 65535), c2=REPEAT('m', 65535), c1=REPEAT('n', 65535); ERROR HY000: Undo log record is too big. UPDATE t1 SET c14 = REPEAT('a', 65535); ERROR HY000: Undo log record is too big. DROP TABLE t1; # # Bug#21880445 - FAILING ASSERTION: !FIELD->PREFIX_LEN || # FIELD->FIXED_LEN == FIELD->PREFIX_LEN # CREATE TABLE t1( a CHAR(255) CHARACTER SET UTF32, KEY k1(a(254)) ) ENGINE=INNODB; DROP TABLE t1; CREATE TABLE t1( a VARCHAR(16383) CHARACTER SET UTF32, KEY k1(a(768)) ) ENGINE=INNODB; DROP TABLE t1; CREATE TABLE t1( a TEXT CHARACTER SET UTF32, KEY k1(a(768)) ) ENGINE=INNODB; DROP TABLE t1; CREATE TABLE t1( a CHAR(255) CHARACTER SET UTF32, KEY k1(a) )ENGINE=INNODB; DROP TABLE t1; CREATE TABLE t1( a CHAR(20) CHARACTER SET UTF32, KEY k1(a(5)) ) ENGINE=INNODB; DROP TABLE t1; CREATE TABLE t1( a CHAR(255) CHARACTER SET UTF32, KEY k1(a(195)) ) ENGINE=INNODB; ALTER TABLE t1 ADD COLUMN b CHAR(255) CHARACTER SET UTF32; ALTER TABLE t1 ADD COLUMN c CHAR(255) CHARACTER SET UTF32; ALTER TABLE t1 ADD INDEX k2(b); ALTER TABLE t1 ADD INDEX k3(c); DROP TABLE t1;
Close