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.15.10.50
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 /
ndb /
r /
[ HOME SHELL ]
Name
Size
Permission
Action
bug36547.result
455
B
-rw-r--r--
loaddata_autocom_ndb.result
740
B
-rw-r--r--
ndb_add_partition.result
13.36
KB
-rw-r--r--
ndb_addnode_restart.result
384
B
-rw-r--r--
ndb_addnode_restart2.result
454
B
-rw-r--r--
ndb_alter_table.result
19.49
KB
-rw-r--r--
ndb_alter_table2.result
685
B
-rw-r--r--
ndb_alter_table3.result
1.48
KB
-rw-r--r--
ndb_alter_table_backup.result
1.76
KB
-rw-r--r--
ndb_alter_table_dml.result
1.83
KB
-rw-r--r--
ndb_alter_table_error.result
664
B
-rw-r--r--
ndb_alter_table_online.result
29.02
KB
-rw-r--r--
ndb_alter_table_online2.result
3.21
KB
-rw-r--r--
ndb_alter_table_online_multi.r...
2
KB
-rw-r--r--
ndb_auto_increment.result
11.49
KB
-rw-r--r--
ndb_autoinc.result
2.69
KB
-rw-r--r--
ndb_backup_rate.result
912
B
-rw-r--r--
ndb_basic.result
32.68
KB
-rw-r--r--
ndb_bitfield.result
8.39
KB
-rw-r--r--
ndb_blob.result
26.47
KB
-rw-r--r--
ndb_blob_big.result
1.24
KB
-rw-r--r--
ndb_blob_partition.result
9.03
KB
-rw-r--r--
ndb_bug13563280.result
224
B
-rw-r--r--
ndb_bug14166590.result
416
B
-rw-r--r--
ndb_bug17624736.result
1.71
KB
-rw-r--r--
ndb_bug17719439.result
439
B
-rw-r--r--
ndb_bug19390895.result
1.67
KB
-rw-r--r--
ndb_bug26793.result
286
B
-rw-r--r--
ndb_bug31477.result
1.85
KB
-rw-r--r--
ndb_bulk_delete.result
1.87
KB
-rw-r--r--
ndb_bushy_joins.result
88.95
KB
-rw-r--r--
ndb_cache.result
9.35
KB
-rw-r--r--
ndb_cache2.result
13.9
KB
-rw-r--r--
ndb_cache_multi.result
2.44
KB
-rw-r--r--
ndb_cache_multi2.result
3.04
KB
-rw-r--r--
ndb_cache_trans.result
6.65
KB
-rw-r--r--
ndb_charset.result
5.77
KB
-rw-r--r--
ndb_checksum.result
38
B
-rw-r--r--
ndb_column_properties.result
16.01
KB
-rw-r--r--
ndb_condition_pushdown.result
131.71
KB
-rw-r--r--
ndb_config.result
3.36
KB
-rw-r--r--
ndb_config2.result
475
B
-rw-r--r--
ndb_create_table.result
1.02
KB
-rw-r--r--
ndb_cursor.result
792
B
-rw-r--r--
ndb_database.result
1.25
KB
-rw-r--r--
ndb_dbug_lock.result
1.64
KB
-rw-r--r--
ndb_dbug_tc_select.result
6.71
KB
-rw-r--r--
ndb_dd_alter.result
28.43
KB
-rw-r--r--
ndb_dd_basic.result
21.17
KB
-rw-r--r--
ndb_dd_bug12581213.result
334
B
-rw-r--r--
ndb_dd_ddl.result
5.94
KB
-rw-r--r--
ndb_dd_disk2memory.result
15.44
KB
-rw-r--r--
ndb_dd_dump.result
15.97
KB
-rw-r--r--
ndb_dd_initial_lg.result
941
B
-rw-r--r--
ndb_dd_restore_check_tablespac...
8.3
KB
-rw-r--r--
ndb_dd_restore_compat.result
3.73
KB
-rw-r--r--
ndb_dd_sql_features.result
22.62
KB
-rw-r--r--
ndb_ddl_open_trans.result
1.44
KB
-rw-r--r--
ndb_disconnect_ddl.result
291
B
-rw-r--r--
ndb_discover_db.result
1.92
KB
-rw-r--r--
ndb_dist_priv.result
6.36
KB
-rw-r--r--
ndb_dist_priv_bug_13340854.res...
248
B
-rw-r--r--
ndb_err4012.result
2.22
KB
-rw-r--r--
ndb_error_reporter.result
5.61
KB
-rw-r--r--
ndb_fired_trigger_shortage.res...
694
B
-rw-r--r--
ndb_fk_addnode.result
1.39
KB
-rw-r--r--
ndb_fk_alter.result
8.34
KB
-rw-r--r--
ndb_fk_bugs.result
27.58
KB
-rw-r--r--
ndb_fk_build.result
2.31
KB
-rw-r--r--
ndb_fk_cascade_delete.result
4.82
KB
-rw-r--r--
ndb_fk_cascade_delete_multi.re...
2.56
KB
-rw-r--r--
ndb_fk_cascade_update.result
1.66
KB
-rw-r--r--
ndb_fk_create_drop.result
4.8
KB
-rw-r--r--
ndb_fk_db.result
7.18
KB
-rw-r--r--
ndb_fk_deferred_cascade.result
2.82
KB
-rw-r--r--
ndb_fk_disable.result
11.64
KB
-rw-r--r--
ndb_fk_is.result
8.49
KB
-rw-r--r--
ndb_fk_locase.result
2.44
KB
-rw-r--r--
ndb_fk_locking.result
1.47
KB
-rw-r--r--
ndb_fk_multi_column.result
2.04
KB
-rw-r--r--
ndb_fk_mysqldump.result
2.93
KB
-rw-r--r--
ndb_fk_mysqldump2.result
72
B
-rw-r--r--
ndb_fk_no_fk.result
30.14
KB
-rw-r--r--
ndb_fk_no_fk_legacy.result
2.77
KB
-rw-r--r--
ndb_fk_noaction.result
5.68
KB
-rw-r--r--
ndb_fk_resources.result
2.58
KB
-rw-r--r--
ndb_fk_restore.result
14.08
KB
-rw-r--r--
ndb_fk_restrict.result
6.82
KB
-rw-r--r--
ndb_fk_self_ref.result
3.74
KB
-rw-r--r--
ndb_fk_setdefault.result
1.03
KB
-rw-r--r--
ndb_fk_setnull.result
3.23
KB
-rw-r--r--
ndb_global_schema_lock.result
3.6
KB
-rw-r--r--
ndb_global_schema_lock_error.r...
1.88
KB
-rw-r--r--
ndb_grant.result
17.65
KB
-rw-r--r--
ndb_hashmap.result
624
B
-rw-r--r--
ndb_hidden_pk.result
10.55
KB
-rw-r--r--
ndb_index.result
17.84
KB
-rw-r--r--
ndb_index_ordered.result
16.73
KB
-rw-r--r--
ndb_index_stat.result
17.74
KB
-rw-r--r--
ndb_index_stat_partitions.resu...
3.82
KB
-rw-r--r--
ndb_index_stat_restart.result
2.2
KB
-rw-r--r--
ndb_index_unique.result
20.29
KB
-rw-r--r--
ndb_insert.result
36.52
KB
-rw-r--r--
ndb_join_pushdown_bka.result
949.68
KB
-rw-r--r--
ndb_join_pushdown_default.resu...
865.61
KB
-rw-r--r--
ndb_join_pushdown_nobnl.result
864.87
KB
-rw-r--r--
ndb_join_pushdown_none.result
865.08
KB
-rw-r--r--
ndb_limit.result
1.99
KB
-rw-r--r--
ndb_load.result
2.66
KB
-rw-r--r--
ndb_loaddatalocal.result
1.57
KB
-rw-r--r--
ndb_lock.result
4.17
KB
-rw-r--r--
ndb_lock_table.result
205
B
-rw-r--r--
ndb_many_fragments.result
26.72
KB
-rw-r--r--
ndb_mgm.result
5.7
KB
-rw-r--r--
ndb_mgmd.result
198
B
-rw-r--r--
ndb_minmax.result
1.47
KB
-rw-r--r--
ndb_multi.result
8.83
KB
-rw-r--r--
ndb_multi_row.result
1.33
KB
-rw-r--r--
ndb_multi_update_delete.result
1.83
KB
-rw-r--r--
ndb_native_default_support.res...
50.29
KB
-rw-r--r--
ndb_one_fragment.result
4.05
KB
-rw-r--r--
ndb_optimize_table.result
2
KB
-rw-r--r--
ndb_optimized_node_selection.r...
1017
B
-rw-r--r--
ndb_partition_error.result
1.44
KB
-rw-r--r--
ndb_partition_error2.result
150
B
-rw-r--r--
ndb_partition_hash.result
890
B
-rw-r--r--
ndb_partition_key.result
8.82
KB
-rw-r--r--
ndb_partition_list.result
2.31
KB
-rw-r--r--
ndb_partition_range.result
7.91
KB
-rw-r--r--
ndb_print_file.result
709
B
-rw-r--r--
ndb_rbwr.result
0
B
-rw-r--r--
ndb_read_multi_range.result
15
KB
-rw-r--r--
ndb_reconnect.result
1.7
KB
-rw-r--r--
ndb_rename.result
910
B
-rw-r--r--
ndb_replace.result
3.64
KB
-rw-r--r--
ndb_restore_bug17916243.result
537
B
-rw-r--r--
ndb_restore_compat_downward.re...
132.43
KB
-rw-r--r--
ndb_restore_compat_endianness....
10.97
KB
-rw-r--r--
ndb_restore_conv_lossy_charbin...
15.46
KB
-rw-r--r--
ndb_restore_conv_lossy_integra...
20.72
KB
-rw-r--r--
ndb_restore_conv_more.result
56.57
KB
-rw-r--r--
ndb_restore_conv_padding.resul...
6.14
KB
-rw-r--r--
ndb_restore_conv_promotion.res...
23.26
KB
-rw-r--r--
ndb_restore_discover.result
540
B
-rw-r--r--
ndb_restore_misc.result
25.16
KB
-rw-r--r--
ndb_restore_print.result
9.8
KB
-rw-r--r--
ndb_restore_schema_blobs.resul...
6.44
KB
-rw-r--r--
ndb_restore_schema_partitions....
13.25
KB
-rw-r--r--
ndb_restore_schema_rewrites.re...
12.22
KB
-rw-r--r--
ndb_restore_schema_subsets.res...
95.9
KB
-rw-r--r--
ndb_restore_schema_tolerance.r...
4.53
KB
-rw-r--r--
ndb_restore_undolog.result
18.76
KB
-rw-r--r--
ndb_row_count.result
5.19
KB
-rw-r--r--
ndb_row_format.result
1.74
KB
-rw-r--r--
ndb_select_count.result
334
B
-rw-r--r--
ndb_share.result
11.29
KB
-rw-r--r--
ndb_short_sigs.result
2.54
KB
-rw-r--r--
ndb_single_user.result
4.01
KB
-rw-r--r--
ndb_sp.result
1.17
KB
-rw-r--r--
ndb_spj_dict.result
11.63
KB
-rw-r--r--
ndb_sql_allow_batching.result
918
B
-rw-r--r--
ndb_startup.result
358
B
-rw-r--r--
ndb_statistics0.result
16.23
KB
-rw-r--r--
ndb_statistics1.result
15.99
KB
-rw-r--r--
ndb_subquery.result
9.29
KB
-rw-r--r--
ndb_suma_handover.result
427
B
-rw-r--r--
ndb_temporary.result
949
B
-rw-r--r--
ndb_tmp_table_and_DDL.result
3.11
KB
-rw-r--r--
ndb_transaction.result
4.62
KB
-rw-r--r--
ndb_trigger.result
9.38
KB
-rw-r--r--
ndb_truncate.result
425
B
-rw-r--r--
ndb_types.result
4.91
KB
-rw-r--r--
ndb_update.result
2.97
KB
-rw-r--r--
ndb_update_no_read.result
11.23
KB
-rw-r--r--
ndb_view.result
597
B
-rw-r--r--
ndb_wait_until_ready.result
533
B
-rw-r--r--
ndb_wl946_main.result
19.39
KB
-rw-r--r--
ndb_wl946_post.result
3.7
KB
-rw-r--r--
ndb_wl946_pre.result
6.62
KB
-rw-r--r--
ndbapi-examples.result
3.34
KB
-rw-r--r--
ndbinfo.result
44.04
KB
-rw-r--r--
ndbinfo_cache.result
775
B
-rw-r--r--
ndbinfo_dump.result
95
B
-rw-r--r--
ndbinfo_upgrade.result
382
B
-rw-r--r--
ps_7ndb.result
103.05
KB
-rw-r--r--
strict_autoinc_5ndb.result
894
B
-rw-r--r--
wl10837.result
524
B
-rw-r--r--
Delete
Unzip
Zip
${this.title}
Close
Code Editor : ndb_restore_conv_lossy_charbinary.result
************************************************************ * Creating table with char+binary types ************************************************************ CREATE TABLE t2( c1 char(2), c2 char(128), c3 char(255), b1 binary(2), b2 binary(128), b3 binary(255), vc1 varchar(2), vc2 varchar(255), vc3 varchar(1024), vb1 varbinary(2), vb2 varbinary(255), vb3 varbinary(1024) ) ENGINE=NDB; INSERT INTO t2 VALUES( repeat('a', 2), repeat('b', 128), repeat('c', 255), repeat('d', 2), repeat('e', 128), repeat('f', 255), repeat('g', 2), repeat('h', 255), repeat('i', 1024), repeat('j', 2), repeat('k', 255), repeat('l', 1024) ); ************************************************************ * Backing up table with char+binary types ************************************************************ ************************************************************ * Restoring table with unchanged char+binary types: * char(2) --> char(2) * char(128) --> char(128) * char(255) --> char(255) * binary(2) --> binary(2) * binary(128) --> binary(128) * binary(255) --> binary(255) * varchar(2) --> varchar(2) * varchar(255) --> varchar(255) * varchar(1024) --> varchar(1024) * varbinary(2) --> varbinary(2) * varbinary(255) --> varbinary(255) * varbinary(1024) --> varbinary(1024) ************************************************************ CREATE TABLE t2_myisam ENGINE=MYISAM AS SELECT * FROM t2; DELETE FROM t2; SELECT length(c1), length(c2), length(c3), length(b1), length(b2), length(b2), length(vc1), length(vc2), length(vc3), length(vb1), length(vb2), length(vb3) FROM t2; length(c1) length(c2) length(c3) length(b1) length(b2) length(b2) length(vc1) length(vc2) length(vc3) length(vb1) length(vb2) length(vb3) 2 128 255 2 128 128 2 255 1024 2 255 1024 SELECT COUNT(*) FROM t2 NATURAL JOIN t2_myisam; COUNT(*) 1 DROP TABLE t2_myisam; ************************************************************ * Restoring table with 1st degree demoted char+binary types: * char(2) --> char(1) * char(128) --> char(2) * char(255) --> char(128) * binary(2) --> binary(1) * binary(128) --> binary(2) * binary(255) --> binary(128) * varchar(2) --> varchar(1) * varchar(255) --> varchar(2) * varchar(1024) --> varchar(512) * varbinary(2) --> varbinary(1) * varbinary(255) --> varbinary(2) * varbinary(1024) --> varbinary(512) ************************************************************ ALTER TABLE t2 modify c1 char(1), modify c2 char(2), modify c3 char(128), modify b1 binary(1), modify b2 binary(2), modify b3 binary(128), modify vc1 varchar(1), modify vc2 varchar(2), modify vc3 varchar(512), modify vb1 varbinary(1), modify vb2 varbinary(2), modify vb3 varbinary(512); SELECT length(c1), length(c2), length(c3), length(b1), length(b2), length(b2), length(vc1), length(vc2), length(vc3), length(vb1), length(vb2), length(vb3) FROM t2; length(c1) length(c2) length(c3) length(b1) length(b2) length(b2) length(vc1) length(vc2) length(vc3) length(vb1) length(vb2) length(vb3) 1 2 128 1 2 2 1 2 512 1 2 512 CREATE TABLE t2_myisam ENGINE=MYISAM AS SELECT * FROM t2; DELETE FROM t2; SELECT length(c1), length(c2), length(c3), length(b1), length(b2), length(b2), length(vc1), length(vc2), length(vc3), length(vb1), length(vb2), length(vb3) FROM t2; length(c1) length(c2) length(c3) length(b1) length(b2) length(b2) length(vc1) length(vc2) length(vc3) length(vb1) length(vb2) length(vb3) 1 2 128 1 2 2 1 2 512 1 2 512 SELECT COUNT(*) FROM t2 NATURAL JOIN t2_myisam; COUNT(*) 1 DROP TABLE t2_myisam; ************************************************************ * Restoring table with 2nd degree demoted char+binary types: * char(2) --> char(1) * char(128) --> char(1) * char(255) --> char(2) * binary(2) --> binary(1) * binary(128) --> binary(1) * binary(255) --> binary(2) * varchar(2) --> varchar(1) * varchar(255) --> varchar(1) * varchar(1024) --> varchar(255) * varbinary(2) --> varbinary(1) * varbinary(255) --> varbinary(1) * varbinary(1024) --> varbinary(255) ************************************************************ ALTER TABLE t2 modify c1 char(1), modify c2 char(1), modify c3 char(2), modify b1 binary(1), modify b2 binary(1), modify b3 binary(2), modify vc1 varchar(1), modify vc2 varchar(1), modify vc3 varchar(255), modify vb1 varbinary(1), modify vb2 varbinary(1), modify vb3 varbinary(255); SELECT length(c1), length(c2), length(c3), length(b1), length(b2), length(b2), length(vc1), length(vc2), length(vc3), length(vb1), length(vb2), length(vb3) FROM t2; length(c1) length(c2) length(c3) length(b1) length(b2) length(b2) length(vc1) length(vc2) length(vc3) length(vb1) length(vb2) length(vb3) 1 1 2 1 1 1 1 1 255 1 1 255 CREATE TABLE t2_myisam ENGINE=MYISAM AS SELECT * FROM t2; DELETE FROM t2; SELECT length(c1), length(c2), length(c3), length(b1), length(b2), length(b2), length(vc1), length(vc2), length(vc3), length(vb1), length(vb2), length(vb3) FROM t2; length(c1) length(c2) length(c3) length(b1) length(b2) length(b2) length(vc1) length(vc2) length(vc3) length(vb1) length(vb2) length(vb3) 1 1 2 1 1 1 1 1 255 1 1 255 SELECT COUNT(*) FROM t2 NATURAL JOIN t2_myisam; COUNT(*) 1 DROP TABLE t2_myisam; ************************************************************ * Restoring table with 3rd degree demoted char+binary types: * char(2) --> char(1) * char(128) --> char(1) * char(255) --> char(1) * binary(2) --> binary(1) * binary(128) --> binary(1) * binary(255) --> binary(1) * varchar(2) --> varchar(1) * varchar(255) --> varchar(1) * varchar(1024) --> varchar(1) * varbinary(2) --> varbinary(1) * varbinary(255) --> varbinary(1) * varbinary(1024) --> varbinary(1) ************************************************************ ALTER TABLE t2 modify c1 char(1), modify c2 char(1), modify c3 char(1), modify b1 binary(1), modify b2 binary(1), modify b3 binary(1), modify vc1 varchar(1), modify vc2 varchar(1), modify vc3 varchar(1), modify vb1 varbinary(1), modify vb2 varbinary(1), modify vb3 varbinary(1); SELECT length(c1), length(c2), length(c3), length(b1), length(b2), length(b2), length(vc1), length(vc2), length(vc3), length(vb1), length(vb2), length(vb3) FROM t2; length(c1) length(c2) length(c3) length(b1) length(b2) length(b2) length(vc1) length(vc2) length(vc3) length(vb1) length(vb2) length(vb3) 1 1 1 1 1 1 1 1 1 1 1 1 CREATE TABLE t2_myisam ENGINE=MYISAM AS SELECT * FROM t2; DELETE FROM t2; SELECT length(c1), length(c2), length(c3), length(b1), length(b2), length(b2), length(vc1), length(vc2), length(vc3), length(vb1), length(vb2), length(vb3) FROM t2; length(c1) length(c2) length(c3) length(b1) length(b2) length(b2) length(vc1) length(vc2) length(vc3) length(vb1) length(vb2) length(vb3) 1 1 1 1 1 1 1 1 1 1 1 1 SELECT COUNT(*) FROM t2 NATURAL JOIN t2_myisam; COUNT(*) 1 DROP TABLE t2_myisam; ************************************************************ * Restoring table with changed var-ness of char+binary types: * char(2) --> varchar(2) * char(128) --> varchar(128) * char(255) --> varchar(255) * binary(2) --> varbinary(2) * binary(128) --> varbinary(128) * binary(255) --> varbinary(255) * varchar(2) --> char(2) * varchar(255) --> char(255) * varchar(1024) --> varchar(1024) * varbinary(2) --> binary(2) * varbinary(255) --> binary(255) * varbinary(1024) --> varbinary(1024) ************************************************************ DELETE FROM t2; ALTER TABLE t2 modify c1 varchar(2), modify c2 varchar(128), modify c3 varchar(255), modify b1 varbinary(2), modify b2 varbinary(128), modify b3 varbinary(255), modify vc1 char(2), modify vc2 char(255), modify vc3 varchar(1024), modify vb1 binary(2), modify vb2 binary(255), modify vb3 varbinary(1024); INSERT INTO t2 VALUES( repeat('a', 2), repeat('b', 128), repeat('c', 255), repeat('d', 2), repeat('e', 128), repeat('f', 255), repeat('g', 2), repeat('h', 255), repeat('i', 1024), repeat('j', 2), repeat('k', 255), repeat('l', 1024) ); SELECT length(c1), length(c2), length(c3), length(b1), length(b2), length(b2), length(vc1), length(vc2), length(vc3), length(vb1), length(vb2), length(vb3) FROM t2; length(c1) length(c2) length(c3) length(b1) length(b2) length(b2) length(vc1) length(vc2) length(vc3) length(vb1) length(vb2) length(vb3) 2 128 255 2 128 128 2 255 1024 2 255 1024 CREATE TABLE t2_myisam ENGINE=MYISAM AS SELECT * FROM t2; DELETE FROM t2; SELECT length(c1), length(c2), length(c3), length(b1), length(b2), length(b2), length(vc1), length(vc2), length(vc3), length(vb1), length(vb2), length(vb3) FROM t2; length(c1) length(c2) length(c3) length(b1) length(b2) length(b2) length(vc1) length(vc2) length(vc3) length(vb1) length(vb2) length(vb3) 2 128 255 2 128 128 2 255 1024 2 255 1024 SELECT COUNT(*) FROM t2 NATURAL JOIN t2_myisam; COUNT(*) 1 DROP TABLE t2_myisam; ************************************************************ * Restoring table with changed varness + 1st degree demoted types: * char(2) --> varchar(1) * char(128) --> varchar(2) * char(255) --> varchar(128) * binary(2) --> varbinary(1) * binary(128) --> varbinary(2) * binary(255) --> varbinary(128) * varchar(2) --> char(1) * varchar(255) --> char(2) * varchar(1024) --> char(255) * varbinary(2) --> binary(1) * varbinary(255) --> binary(2) * varbinary(1024) --> binary(255) ************************************************************ DELETE FROM t2; ALTER TABLE t2 modify c1 varchar(1), modify c2 varchar(2), modify c3 varchar(128), modify b1 varbinary(1), modify b2 varbinary(2), modify b3 varbinary(128), modify vc1 char(1), modify vc2 char(2), modify vc3 char(255), modify vb1 binary(1), modify vb2 binary(2), modify vb3 binary(255); INSERT INTO t2 VALUES( repeat('a', 2), repeat('b', 128), repeat('c', 255), repeat('d', 2), repeat('e', 128), repeat('f', 255), repeat('g', 2), repeat('h', 255), repeat('i', 1024), repeat('j', 2), repeat('k', 255), repeat('l', 1024) ); SELECT length(c1), length(c2), length(c3), length(b1), length(b2), length(b2), length(vc1), length(vc2), length(vc3), length(vb1), length(vb2), length(vb3) FROM t2; length(c1) length(c2) length(c3) length(b1) length(b2) length(b2) length(vc1) length(vc2) length(vc3) length(vb1) length(vb2) length(vb3) 1 2 128 1 2 2 1 2 255 1 2 255 CREATE TABLE t2_myisam ENGINE=MYISAM AS SELECT * FROM t2; DELETE FROM t2; SELECT length(c1), length(c2), length(c3), length(b1), length(b2), length(b2), length(vc1), length(vc2), length(vc3), length(vb1), length(vb2), length(vb3) FROM t2; length(c1) length(c2) length(c3) length(b1) length(b2) length(b2) length(vc1) length(vc2) length(vc3) length(vb1) length(vb2) length(vb3) 1 2 128 1 2 2 1 2 255 1 2 255 SELECT COUNT(*) FROM t2 NATURAL JOIN t2_myisam; COUNT(*) 1 DROP TABLE t2_myisam; ************************************************************ * Restoring table with changed varness + 2nd degree demoted types: * char(2) --> varchar(1) * char(128) --> varchar(1) * char(255) --> varchar(2) * binary(2) --> varbinary(1) * binary(128) --> varbinary(1) * binary(255) --> varbinary(2) * varchar(2) --> char(1) * varchar(255) --> char(1) * varchar(1024) --> char(255) * varbinary(2) --> binary(1) * varbinary(255) --> binary(1) * varbinary(1024) --> binary(255) ************************************************************ DELETE FROM t2; ALTER TABLE t2 modify c1 varchar(1), modify c2 varchar(1), modify c3 varchar(2), modify b1 varbinary(1), modify b2 varbinary(1), modify b3 varbinary(2), modify vc1 char(1), modify vc2 char(1), modify vc3 char(255), modify vb1 binary(1), modify vb2 binary(1), modify vb3 binary(255); INSERT INTO t2 VALUES( repeat('a', 2), repeat('b', 128), repeat('c', 255), repeat('d', 2), repeat('e', 128), repeat('f', 255), repeat('g', 2), repeat('h', 255), repeat('i', 1024), repeat('j', 2), repeat('k', 255), repeat('l', 1024) ); SELECT length(c1), length(c2), length(c3), length(b1), length(b2), length(b2), length(vc1), length(vc2), length(vc3), length(vb1), length(vb2), length(vb3) FROM t2; length(c1) length(c2) length(c3) length(b1) length(b2) length(b2) length(vc1) length(vc2) length(vc3) length(vb1) length(vb2) length(vb3) 1 1 2 1 1 1 1 1 255 1 1 255 CREATE TABLE t2_myisam ENGINE=MYISAM AS SELECT * FROM t2; DELETE FROM t2; SELECT length(c1), length(c2), length(c3), length(b1), length(b2), length(b2), length(vc1), length(vc2), length(vc3), length(vb1), length(vb2), length(vb3) FROM t2; length(c1) length(c2) length(c3) length(b1) length(b2) length(b2) length(vc1) length(vc2) length(vc3) length(vb1) length(vb2) length(vb3) 1 1 2 1 1 1 1 1 255 1 1 255 SELECT COUNT(*) FROM t2 NATURAL JOIN t2_myisam; COUNT(*) 1 DROP TABLE t2_myisam; ************************************************************ * Restoring table with changed varness + 3rd degree demoted types: * char(2) --> varchar(1) * char(128) --> varchar(1) * char(255) --> varchar(1) * binary(2) --> varbinary(1) * binary(128) --> varbinary(1) * binary(255) --> varbinary(1) * varchar(2) --> char(1) * varchar(255) --> char(1) * varchar(1024) --> char(1) * varbinary(2) --> binary(1) * varbinary(255) --> binary(1) * varbinary(1024) --> binary(1) ************************************************************ DELETE FROM t2; ALTER TABLE t2 modify c1 varchar(1), modify c2 varchar(1), modify c3 varchar(1), modify b1 varbinary(1), modify b2 varbinary(1), modify b3 varbinary(1), modify vc1 char(1), modify vc2 char(1), modify vc3 char(1), modify vb1 binary(1), modify vb2 binary(1), modify vb3 binary(1); INSERT INTO t2 VALUES( repeat('a', 2), repeat('b', 128), repeat('c', 255), repeat('d', 2), repeat('e', 128), repeat('f', 255), repeat('g', 2), repeat('h', 255), repeat('i', 1024), repeat('j', 2), repeat('k', 255), repeat('l', 1024) ); SELECT length(c1), length(c2), length(c3), length(b1), length(b2), length(b2), length(vc1), length(vc2), length(vc3), length(vb1), length(vb2), length(vb3) FROM t2; length(c1) length(c2) length(c3) length(b1) length(b2) length(b2) length(vc1) length(vc2) length(vc3) length(vb1) length(vb2) length(vb3) 1 1 1 1 1 1 1 1 1 1 1 1 CREATE TABLE t2_myisam ENGINE=MYISAM AS SELECT * FROM t2; DELETE FROM t2; SELECT length(c1), length(c2), length(c3), length(b1), length(b2), length(b2), length(vc1), length(vc2), length(vc3), length(vb1), length(vb2), length(vb3) FROM t2; length(c1) length(c2) length(c3) length(b1) length(b2) length(b2) length(vc1) length(vc2) length(vc3) length(vb1) length(vb2) length(vb3) 1 1 1 1 1 1 1 1 1 1 1 1 SELECT COUNT(*) FROM t2 NATURAL JOIN t2_myisam; COUNT(*) 1 DROP TABLE t2_myisam; ************************************************************ * Deleting table with char+binary types ************************************************************ DROP TABLE t2;
Close