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.224.5.46
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_integral.result
************************************************************ * Creating table with integral types ************************************************************ CREATE TABLE t1( t1 tinyint, t2 tinyint, ut1 tinyint unsigned, s1 smallint, s2 smallint, us1 smallint unsigned, m1 mediumint, m2 mediumint, um1 mediumint unsigned, i1 int, i2 int, ui1 int unsigned, b1 bigint, b2 bigint, ub1 bigint unsigned ) ENGINE=NDB; INSERT INTO t1 VALUES( -128, 127, 255, -32768, 32767, 65535, -8388608, 8388607, 16777215, -2147483648, 2147483647, 4294967295, -9223372036854775808, 9223372036854775807, 18446744073709551615 ); ************************************************************ * Backing up table with integral types ************************************************************ ************************************************************ * Restoring table with unchanged integral types: * tinyint[unsigned] --> tinyint[unsigned] * smallint[unsigned] --> smallint[unsigned] * mediumint[unsigned] --> mediumint[unsigned] * int[unsigned] --> int[unsigned] * bigint[unsigned] --> bigint[unsigned] ************************************************************ CREATE TABLE t1_myisam ENGINE=MYISAM AS SELECT * FROM t1; DELETE FROM t1; SELECT * FROM t1; t1 t2 ut1 s1 s2 us1 m1 m2 um1 i1 i2 ui1 b1 b2 ub1 -128 127 255 -32768 32767 65535 -8388608 8388607 16777215 -2147483648 2147483647 4294967295 -9223372036854775808 9223372036854775807 18446744073709551615 SELECT COUNT(*) FROM t1 NATURAL JOIN t1_myisam; COUNT(*) 1 DROP TABLE t1_myisam; ************************************************************ * Restoring table with 1st degree demoted integral types: * tinyint[unsigned] --> tinyint[unsigned] * smallint[unsigned] --> tinyint[unsigned] * mediumint[unsigned] --> smallint[unsigned] * int[unsigned] --> mediumint[unsigned] * bigint[unsigned] --> int[unsigned] ************************************************************ ALTER TABLE t1 modify t1 tinyint, modify t2 tinyint, modify ut1 tinyint unsigned, modify s1 tinyint, modify s2 tinyint, modify us1 tinyint unsigned, modify m1 smallint, modify m2 smallint, modify um1 smallint unsigned, modify i1 mediumint, modify i2 mediumint, modify ui1 mediumint unsigned, modify b1 int, modify b2 int, modify ub1 int unsigned; SELECT * FROM t1; t1 t2 ut1 s1 s2 us1 m1 m2 um1 i1 i2 ui1 b1 b2 ub1 -128 127 255 -128 127 255 -32768 32767 65535 -8388608 8388607 16777215 -2147483648 2147483647 4294967295 CREATE TABLE t1_myisam ENGINE=MYISAM AS SELECT * FROM t1; DELETE FROM t1; SELECT * FROM t1; t1 t2 ut1 s1 s2 us1 m1 m2 um1 i1 i2 ui1 b1 b2 ub1 -128 127 255 -128 127 255 -32768 32767 65535 -8388608 8388607 16777215 -2147483648 2147483647 4294967295 SELECT COUNT(*) FROM t1 NATURAL JOIN t1_myisam; COUNT(*) 1 DROP TABLE t1_myisam; ************************************************************ * Restoring table with 2nd degree demoted integral types: * tinyint[unsigned] --> tinyint[unsigned] * smallint[unsigned] --> tinyint[unsigned] * mediumint[unsigned] --> tinyint[unsigned] * int[unsigned] --> smallint[unsigned] * bigint[unsigned] --> mediumint[unsigned] ************************************************************ ALTER TABLE t1 modify t1 tinyint, modify t2 tinyint, modify ut1 tinyint unsigned, modify s1 tinyint, modify s2 tinyint, modify us1 tinyint unsigned, modify m1 tinyint, modify m2 tinyint, modify um1 tinyint unsigned, modify i1 smallint, modify i2 smallint, modify ui1 smallint unsigned, modify b1 mediumint, modify b2 mediumint, modify ub1 mediumint unsigned; SELECT * FROM t1; t1 t2 ut1 s1 s2 us1 m1 m2 um1 i1 i2 ui1 b1 b2 ub1 -128 127 255 -128 127 255 -128 127 255 -32768 32767 65535 -8388608 8388607 16777215 CREATE TABLE t1_myisam ENGINE=MYISAM AS SELECT * FROM t1; DELETE FROM t1; SELECT * FROM t1; t1 t2 ut1 s1 s2 us1 m1 m2 um1 i1 i2 ui1 b1 b2 ub1 -128 127 255 -128 127 255 -128 127 255 -32768 32767 65535 -8388608 8388607 16777215 SELECT COUNT(*) FROM t1 NATURAL JOIN t1_myisam; COUNT(*) 1 DROP TABLE t1_myisam; ************************************************************ * Restoring table with 3rd degree demoted integral types: * tinyint[unsigned] --> tinyint[unsigned] * smallint[unsigned] --> tinyint[unsigned] * mediumint[unsigned] --> tinyint[unsigned] * int[unsigned] --> tinyint[unsigned] * bigint[unsigned] --> smallint[unsigned] ************************************************************ ALTER TABLE t1 modify t1 tinyint, modify t2 tinyint, modify ut1 tinyint unsigned, modify s1 tinyint, modify s2 tinyint, modify us1 tinyint unsigned, modify m1 tinyint, modify m2 tinyint, modify um1 tinyint unsigned, modify i1 tinyint, modify i2 tinyint, modify ui1 tinyint unsigned, modify b1 smallint, modify b2 smallint, modify ub1 smallint unsigned; SELECT * FROM t1; t1 t2 ut1 s1 s2 us1 m1 m2 um1 i1 i2 ui1 b1 b2 ub1 -128 127 255 -128 127 255 -128 127 255 -128 127 255 -32768 32767 65535 CREATE TABLE t1_myisam ENGINE=MYISAM AS SELECT * FROM t1; DELETE FROM t1; SELECT * FROM t1; t1 t2 ut1 s1 s2 us1 m1 m2 um1 i1 i2 ui1 b1 b2 ub1 -128 127 255 -128 127 255 -128 127 255 -128 127 255 -32768 32767 65535 SELECT COUNT(*) FROM t1 NATURAL JOIN t1_myisam; COUNT(*) 1 DROP TABLE t1_myisam; ************************************************************ * Restoring table with 4th degree demoted integral types: * tinyint[unsigned] --> tinyint[unsigned] * smallint[unsigned] --> tinyint[unsigned] * mediumint[unsigned] --> tinyint[unsigned] * int[unsigned] --> tinyint[unsigned] * bigint[unsigned] --> tinyint[unsigned] ************************************************************ ALTER TABLE t1 modify t1 tinyint, modify t2 tinyint, modify ut1 tinyint unsigned, modify s1 tinyint, modify s2 tinyint, modify us1 tinyint unsigned, modify m1 tinyint, modify m2 tinyint, modify um1 tinyint unsigned, modify i1 tinyint, modify i2 tinyint, modify ui1 tinyint unsigned, modify b1 tinyint, modify b2 tinyint, modify ub1 tinyint unsigned; SELECT * FROM t1; t1 t2 ut1 s1 s2 us1 m1 m2 um1 i1 i2 ui1 b1 b2 ub1 -128 127 255 -128 127 255 -128 127 255 -128 127 255 -128 127 255 CREATE TABLE t1_myisam ENGINE=MYISAM AS SELECT * FROM t1; DELETE FROM t1; SELECT * FROM t1; t1 t2 ut1 s1 s2 us1 m1 m2 um1 i1 i2 ui1 b1 b2 ub1 -128 127 255 -128 127 255 -128 127 255 -128 127 255 -128 127 255 SELECT COUNT(*) FROM t1 NATURAL JOIN t1_myisam; COUNT(*) 1 DROP TABLE t1_myisam; ************************************************************ * Restoring table with changed signedness: * tinyint unsigned/signed --> tinyint signed/unsigned * smallint unsigned/signed --> smallint signed/unsigned * mediumint unsigned/signed --> mediumint signed/unsigned * int unsigned/signed --> int signed/unsigned * bigint unsigned/signed --> bigint signed/unsigned ************************************************************ DELETE FROM t1; ALTER TABLE t1 modify t1 tinyint unsigned, modify t2 tinyint unsigned, modify ut1 tinyint signed, modify s1 smallint unsigned, modify s2 smallint unsigned, modify us1 smallint signed, modify m1 mediumint unsigned, modify m2 mediumint unsigned, modify um1 mediumint signed, modify i1 int unsigned, modify i2 int unsigned, modify ui1 int signed, modify b1 bigint unsigned, modify b2 bigint unsigned, modify ub1 bigint signed; INSERT INTO t1 VALUES( -128, 127, 255, -32768, 32767, 65535, -8388608, 8388607, 16777215, -2147483648, 2147483647, 4294967295, -9223372036854775808, 9223372036854775807, 18446744073709551615 ); SELECT * FROM t1; t1 t2 ut1 s1 s2 us1 m1 m2 um1 i1 i2 ui1 b1 b2 ub1 0 127 127 0 32767 32767 0 8388607 8388607 0 2147483647 2147483647 0 9223372036854775807 9223372036854775807 CREATE TABLE t1_myisam ENGINE=MYISAM AS SELECT * FROM t1; DELETE FROM t1; SELECT * FROM t1; t1 t2 ut1 s1 s2 us1 m1 m2 um1 i1 i2 ui1 b1 b2 ub1 0 127 127 0 32767 32767 0 8388607 8388607 0 2147483647 2147483647 0 9223372036854775807 9223372036854775807 SELECT COUNT(*) FROM t1 NATURAL JOIN t1_myisam; COUNT(*) 1 DROP TABLE t1_myisam; ************************************************************ * Restoring table with changed signedness + 1st degree promoted types: * tinyint unsigned/signed --> smallint signed/unsigned * smallint unsigned/signed --> mediumint signed/unsigned * mediumint unsigned/signed --> int signed/unsigned * int unsigned/signed --> bigint signed/unsigned * bigint unsigned/signed --> bigint signed/unsigned ************************************************************ DELETE FROM t1; ALTER TABLE t1 modify t1 smallint unsigned, modify t2 smallint unsigned, modify ut1 smallint signed, modify s1 mediumint unsigned, modify s2 mediumint unsigned, modify us1 mediumint signed, modify m1 int unsigned, modify m2 int unsigned, modify um1 int signed, modify i1 bigint unsigned, modify i2 bigint unsigned, modify ui1 bigint signed, modify b1 bigint unsigned, modify b2 bigint unsigned, modify ub1 bigint signed; INSERT INTO t1 VALUES( -128, 127, 255, -32768, 32767, 65535, -8388608, 8388607, 16777215, -2147483648, 2147483647, 4294967295, -9223372036854775808, 9223372036854775807, 18446744073709551615 ); SELECT * FROM t1; t1 t2 ut1 s1 s2 us1 m1 m2 um1 i1 i2 ui1 b1 b2 ub1 0 127 255 0 32767 65535 0 8388607 16777215 0 2147483647 4294967295 0 9223372036854775807 9223372036854775807 CREATE TABLE t1_myisam ENGINE=MYISAM AS SELECT * FROM t1; DELETE FROM t1; SELECT * FROM t1; t1 t2 ut1 s1 s2 us1 m1 m2 um1 i1 i2 ui1 b1 b2 ub1 0 127 255 0 32767 65535 0 8388607 16777215 0 2147483647 4294967295 0 9223372036854775807 9223372036854775807 SELECT COUNT(*) FROM t1 NATURAL JOIN t1_myisam; COUNT(*) 1 DROP TABLE t1_myisam; ************************************************************ * Restoring table with changed signedness + 2nd degree promoted types: * tinyint unsigned/signed --> mediumint signed/unsigned * smallint unsigned/signed --> int signed/unsigned * mediumint unsigned/signed --> bigint signed/unsigned * int unsigned/signed --> bigint signed/unsigned * bigint unsigned/signed --> bigint signed/unsigned ************************************************************ DELETE FROM t1; ALTER TABLE t1 modify t1 mediumint unsigned, modify t2 mediumint unsigned, modify ut1 mediumint signed, modify s1 int unsigned, modify s2 int unsigned, modify us1 int signed, modify m1 bigint unsigned, modify m2 bigint unsigned, modify um1 bigint signed, modify i1 bigint unsigned, modify i2 bigint unsigned, modify ui1 bigint signed, modify b1 bigint unsigned, modify b2 bigint unsigned, modify ub1 bigint signed; INSERT INTO t1 VALUES( -128, 127, 255, -32768, 32767, 65535, -8388608, 8388607, 16777215, -2147483648, 2147483647, 4294967295, -9223372036854775808, 9223372036854775807, 18446744073709551615 ); SELECT * FROM t1; t1 t2 ut1 s1 s2 us1 m1 m2 um1 i1 i2 ui1 b1 b2 ub1 0 127 255 0 32767 65535 0 8388607 16777215 0 2147483647 4294967295 0 9223372036854775807 9223372036854775807 CREATE TABLE t1_myisam ENGINE=MYISAM AS SELECT * FROM t1; DELETE FROM t1; SELECT * FROM t1; t1 t2 ut1 s1 s2 us1 m1 m2 um1 i1 i2 ui1 b1 b2 ub1 0 127 255 0 32767 65535 0 8388607 16777215 0 2147483647 4294967295 0 9223372036854775807 9223372036854775807 SELECT COUNT(*) FROM t1 NATURAL JOIN t1_myisam; COUNT(*) 1 DROP TABLE t1_myisam; ************************************************************ * Restoring table with changed signedness + 3rd degree promoted types: * tinyint unsigned/signed --> int signed/unsigned * smallint unsigned/signed --> bigint signed/unsigned * mediumint unsigned/signed --> bigint signed/unsigned * int unsigned/signed --> bigint signed/unsigned * bigint unsigned/signed --> bigint signed/unsigned ************************************************************ DELETE FROM t1; ALTER TABLE t1 modify t1 int unsigned, modify t2 int unsigned, modify ut1 int signed, modify s1 bigint unsigned, modify s2 bigint unsigned, modify us1 bigint signed, modify m1 bigint unsigned, modify m2 bigint unsigned, modify um1 bigint signed, modify i1 bigint unsigned, modify i2 bigint unsigned, modify ui1 bigint signed, modify b1 bigint unsigned, modify b2 bigint unsigned, modify ub1 bigint signed; INSERT INTO t1 VALUES( -128, 127, 255, -32768, 32767, 65535, -8388608, 8388607, 16777215, -2147483648, 2147483647, 4294967295, -9223372036854775808, 9223372036854775807, 18446744073709551615 ); SELECT * FROM t1; t1 t2 ut1 s1 s2 us1 m1 m2 um1 i1 i2 ui1 b1 b2 ub1 0 127 255 0 32767 65535 0 8388607 16777215 0 2147483647 4294967295 0 9223372036854775807 9223372036854775807 CREATE TABLE t1_myisam ENGINE=MYISAM AS SELECT * FROM t1; DELETE FROM t1; SELECT * FROM t1; t1 t2 ut1 s1 s2 us1 m1 m2 um1 i1 i2 ui1 b1 b2 ub1 0 127 255 0 32767 65535 0 8388607 16777215 0 2147483647 4294967295 0 9223372036854775807 9223372036854775807 SELECT COUNT(*) FROM t1 NATURAL JOIN t1_myisam; COUNT(*) 1 DROP TABLE t1_myisam; ************************************************************ * Restoring table with changed signedness + 4th degree promoted types: * tinyint unsigned/signed --> bigint signed/unsigned * smallint unsigned/signed --> bigint signed/unsigned * mediumint unsigned/signed --> bigint signed/unsigned * int unsigned/signed --> bigint signed/unsigned * bigint unsigned/signed --> bigint signed/unsigned ************************************************************ DELETE FROM t1; ALTER TABLE t1 modify t1 bigint unsigned, modify t2 bigint unsigned, modify ut1 bigint signed, modify s1 bigint unsigned, modify s2 bigint unsigned, modify us1 bigint signed, modify m1 bigint unsigned, modify m2 bigint unsigned, modify um1 bigint signed, modify i1 bigint unsigned, modify i2 bigint unsigned, modify ui1 bigint signed, modify b1 bigint unsigned, modify b2 bigint unsigned, modify ub1 bigint signed; INSERT INTO t1 VALUES( -128, 127, 255, -32768, 32767, 65535, -8388608, 8388607, 16777215, -2147483648, 2147483647, 4294967295, -9223372036854775808, 9223372036854775807, 18446744073709551615 ); SELECT * FROM t1; t1 t2 ut1 s1 s2 us1 m1 m2 um1 i1 i2 ui1 b1 b2 ub1 0 127 255 0 32767 65535 0 8388607 16777215 0 2147483647 4294967295 0 9223372036854775807 9223372036854775807 CREATE TABLE t1_myisam ENGINE=MYISAM AS SELECT * FROM t1; DELETE FROM t1; SELECT * FROM t1; t1 t2 ut1 s1 s2 us1 m1 m2 um1 i1 i2 ui1 b1 b2 ub1 0 127 255 0 32767 65535 0 8388607 16777215 0 2147483647 4294967295 0 9223372036854775807 9223372036854775807 SELECT COUNT(*) FROM t1 NATURAL JOIN t1_myisam; COUNT(*) 1 DROP TABLE t1_myisam; ************************************************************ * Restoring table with changed signedness + 1st degree demoted types: * tinyint unsigned/signed --> tinyint signed/unsigned * smallint unsigned/signed --> tinyint signed/unsigned * mediumint unsigned/signed --> smallint signed/unsigned * int unsigned/signed --> mediumint signed/unsigned * bigint unsigned/signed --> int signed/unsigned ************************************************************ DELETE FROM t1; ALTER TABLE t1 modify t1 tinyint unsigned, modify t2 tinyint unsigned, modify ut1 tinyint signed, modify s1 tinyint unsigned, modify s2 tinyint unsigned, modify us1 tinyint signed, modify m1 smallint unsigned, modify m2 smallint unsigned, modify um1 smallint signed, modify i1 mediumint unsigned, modify i2 mediumint unsigned, modify ui1 mediumint signed, modify b1 int unsigned, modify b2 int unsigned, modify ub1 int signed; INSERT INTO t1 VALUES( -128, 127, 255, -32768, 32767, 65535, -8388608, 8388607, 16777215, -2147483648, 2147483647, 4294967295, -9223372036854775808, 9223372036854775807, 18446744073709551615 ); SELECT * FROM t1; t1 t2 ut1 s1 s2 us1 m1 m2 um1 i1 i2 ui1 b1 b2 ub1 0 127 127 0 255 127 0 65535 32767 0 16777215 8388607 0 4294967295 2147483647 CREATE TABLE t1_myisam ENGINE=MYISAM AS SELECT * FROM t1; DELETE FROM t1; SELECT * FROM t1; t1 t2 ut1 s1 s2 us1 m1 m2 um1 i1 i2 ui1 b1 b2 ub1 0 127 127 0 255 127 0 65535 32767 0 16777215 8388607 0 4294967295 2147483647 SELECT COUNT(*) FROM t1 NATURAL JOIN t1_myisam; COUNT(*) 1 DROP TABLE t1_myisam; ************************************************************ * Restoring table with changed signedness + 2nd degree demoted types: * tinyint unsigned/signed --> tinyint signed/unsigned * smallint unsigned/signed --> tinyint signed/unsigned * mediumint unsigned/signed --> tinyint signed/unsigned * int unsigned/signed --> smallint signed/unsigned * bigint unsigned/signed --> mediumint signed/unsigned ************************************************************ DELETE FROM t1; ALTER TABLE t1 modify t1 tinyint unsigned, modify t2 tinyint unsigned, modify ut1 tinyint signed, modify s1 tinyint unsigned, modify s2 tinyint unsigned, modify us1 tinyint signed, modify m1 tinyint unsigned, modify m2 tinyint unsigned, modify um1 tinyint signed, modify i1 smallint unsigned, modify i2 smallint unsigned, modify ui1 smallint signed, modify b1 mediumint unsigned, modify b2 mediumint unsigned, modify ub1 mediumint signed; INSERT INTO t1 VALUES( -128, 127, 255, -32768, 32767, 65535, -8388608, 8388607, 16777215, -2147483648, 2147483647, 4294967295, -9223372036854775808, 9223372036854775807, 18446744073709551615 ); SELECT * FROM t1; t1 t2 ut1 s1 s2 us1 m1 m2 um1 i1 i2 ui1 b1 b2 ub1 0 127 127 0 255 127 0 255 127 0 65535 32767 0 16777215 8388607 CREATE TABLE t1_myisam ENGINE=MYISAM AS SELECT * FROM t1; DELETE FROM t1; SELECT * FROM t1; t1 t2 ut1 s1 s2 us1 m1 m2 um1 i1 i2 ui1 b1 b2 ub1 0 127 127 0 255 127 0 255 127 0 65535 32767 0 16777215 8388607 SELECT COUNT(*) FROM t1 NATURAL JOIN t1_myisam; COUNT(*) 1 DROP TABLE t1_myisam; ************************************************************ * Restoring table with changed signedness + 3rd degree demoted types: * tinyint unsigned/signed --> tinyint signed/unsigned * smallint unsigned/signed --> tinyint signed/unsigned * mediumint unsigned/signed --> tinyint signed/unsigned * int unsigned/signed --> tinyint signed/unsigned * bigint unsigned/signed --> smallint signed/unsigned ************************************************************ DELETE FROM t1; ALTER TABLE t1 modify t1 tinyint unsigned, modify t2 tinyint unsigned, modify ut1 tinyint signed, modify s1 tinyint unsigned, modify s2 tinyint unsigned, modify us1 tinyint signed, modify m1 tinyint unsigned, modify m2 tinyint unsigned, modify um1 tinyint signed, modify i1 tinyint unsigned, modify i2 tinyint unsigned, modify ui1 tinyint signed, modify b1 smallint unsigned, modify b2 smallint unsigned, modify ub1 smallint signed; INSERT INTO t1 VALUES( -128, 127, 255, -32768, 32767, 65535, -8388608, 8388607, 16777215, -2147483648, 2147483647, 4294967295, -9223372036854775808, 9223372036854775807, 18446744073709551615 ); SELECT * FROM t1; t1 t2 ut1 s1 s2 us1 m1 m2 um1 i1 i2 ui1 b1 b2 ub1 0 127 127 0 255 127 0 255 127 0 255 127 0 65535 32767 CREATE TABLE t1_myisam ENGINE=MYISAM AS SELECT * FROM t1; DELETE FROM t1; SELECT * FROM t1; t1 t2 ut1 s1 s2 us1 m1 m2 um1 i1 i2 ui1 b1 b2 ub1 0 127 127 0 255 127 0 255 127 0 255 127 0 65535 32767 SELECT COUNT(*) FROM t1 NATURAL JOIN t1_myisam; COUNT(*) 1 DROP TABLE t1_myisam; ************************************************************ * Restoring table with changed signedness + 4th degree demoted types: * tinyint unsigned/signed --> tinyint signed/unsigned * smallint unsigned/signed --> tinyint signed/unsigned * mediumint unsigned/signed --> tinyint signed/unsigned * int unsigned/signed --> tinyint signed/unsigned * bigint unsigned/signed --> tinyint signed/unsigned ************************************************************ DELETE FROM t1; ALTER TABLE t1 modify t1 tinyint unsigned, modify t2 tinyint unsigned, modify ut1 tinyint signed, modify s1 tinyint unsigned, modify s2 tinyint unsigned, modify us1 tinyint signed, modify m1 tinyint unsigned, modify m2 tinyint unsigned, modify um1 tinyint signed, modify i1 tinyint unsigned, modify i2 tinyint unsigned, modify ui1 tinyint signed, modify b1 tinyint unsigned, modify b2 tinyint unsigned, modify ub1 tinyint signed; INSERT INTO t1 VALUES( -128, 127, 255, -32768, 32767, 65535, -8388608, 8388607, 16777215, -2147483648, 2147483647, 4294967295, -9223372036854775808, 9223372036854775807, 18446744073709551615 ); SELECT * FROM t1; t1 t2 ut1 s1 s2 us1 m1 m2 um1 i1 i2 ui1 b1 b2 ub1 0 127 127 0 255 127 0 255 127 0 255 127 0 255 127 CREATE TABLE t1_myisam ENGINE=MYISAM AS SELECT * FROM t1; DELETE FROM t1; SELECT * FROM t1; t1 t2 ut1 s1 s2 us1 m1 m2 um1 i1 i2 ui1 b1 b2 ub1 0 127 127 0 255 127 0 255 127 0 255 127 0 255 127 SELECT COUNT(*) FROM t1 NATURAL JOIN t1_myisam; COUNT(*) 1 DROP TABLE t1_myisam; ************************************************************ * Deleting table with integral types ************************************************************ DROP TABLE t1;
Close