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 /
t /
[ HOME SHELL ]
Name
Size
Permission
Action
bug36547.test
596
B
-rw-r--r--
clusterj.cnf
169
B
-rw-r--r--
clusterj.test
2.28
KB
-rw-r--r--
clusterj_jpa.test
2.71
KB
-rw-r--r--
disabled.def
1.36
KB
-rw-r--r--
have_ndb_dist_priv.inc
944
B
-rw-r--r--
have_ndb_error_insert.inc
931
B
-rw-r--r--
loaddata_autocom_ndb.test
308
B
-rw-r--r--
ndb_add_partition.cnf
594
B
-rw-r--r--
ndb_add_partition.test
13.3
KB
-rw-r--r--
ndb_addnode.cnf
665
B
-rw-r--r--
ndb_addnode.test
5.12
KB
-rw-r--r--
ndb_addnode_restart.cnf
79
B
-rw-r--r--
ndb_addnode_restart.test
299
B
-rw-r--r--
ndb_addnode_restart2.cnf
79
B
-rw-r--r--
ndb_addnode_restart2.test
465
B
-rw-r--r--
ndb_addnode_withbinlog.cnf
869
B
-rw-r--r--
ndb_addnode_withbinlog.test
1.18
KB
-rw-r--r--
ndb_alter_table.test
18.09
KB
-rw-r--r--
ndb_alter_table2.test
1.52
KB
-rw-r--r--
ndb_alter_table3.test
1.68
KB
-rw-r--r--
ndb_alter_table_backup.test
1.73
KB
-rw-r--r--
ndb_alter_table_dml.test
2.8
KB
-rw-r--r--
ndb_alter_table_error.test
1.15
KB
-rw-r--r--
ndb_alter_table_online.test
24.07
KB
-rw-r--r--
ndb_alter_table_online2.test
6.24
KB
-rw-r--r--
ndb_alter_table_online_multi.t...
2.08
KB
-rw-r--r--
ndb_auto_increment.test
12.89
KB
-rw-r--r--
ndb_autoinc.test
2.05
KB
-rw-r--r--
ndb_backup_rate.cnf
286
B
-rw-r--r--
ndb_backup_rate.test
2.35
KB
-rw-r--r--
ndb_basic.test
21.28
KB
-rw-r--r--
ndb_bitfield.test
6.54
KB
-rw-r--r--
ndb_blob.test
18.61
KB
-rw-r--r--
ndb_blob_big.cnf
380
B
-rw-r--r--
ndb_blob_big.test
1.83
KB
-rw-r--r--
ndb_blob_partition.test
4.49
KB
-rw-r--r--
ndb_bug13563280.test
743
B
-rw-r--r--
ndb_bug14166590.cnf
63
B
-rw-r--r--
ndb_bug14166590.test
1.45
KB
-rw-r--r--
ndb_bug17624736.cnf
110
B
-rw-r--r--
ndb_bug17624736.test
2.15
KB
-rw-r--r--
ndb_bug17719439.cnf
63
B
-rw-r--r--
ndb_bug17719439.test
1.34
KB
-rw-r--r--
ndb_bug19390895.cnf
272
B
-rw-r--r--
ndb_bug19390895.test
1.06
KB
-rw-r--r--
ndb_bug26793.test
1.06
KB
-rw-r--r--
ndb_bug31477.test
2.33
KB
-rw-r--r--
ndb_bulk_delete.test
4.13
KB
-rw-r--r--
ndb_bushy_joins.cnf
476
B
-rw-r--r--
ndb_bushy_joins.test
9.03
KB
-rw-r--r--
ndb_cache.cnf
201
B
-rw-r--r--
ndb_cache.test
8.13
KB
-rw-r--r--
ndb_cache2.cnf
23
B
-rw-r--r--
ndb_cache2.test
11.26
KB
-rw-r--r--
ndb_cache_multi.cnf
23
B
-rw-r--r--
ndb_cache_multi.test
2.09
KB
-rw-r--r--
ndb_cache_multi2.cnf
23
B
-rw-r--r--
ndb_cache_multi2.test
4.5
KB
-rw-r--r--
ndb_cache_trans.cnf
23
B
-rw-r--r--
ndb_cache_trans.test
4.85
KB
-rw-r--r--
ndb_charset.test
6.63
KB
-rw-r--r--
ndb_checksum.cnf
50
B
-rw-r--r--
ndb_checksum.test
77
B
-rw-r--r--
ndb_column_properties.test
4.71
KB
-rw-r--r--
ndb_condition_pushdown.test
85.29
KB
-rw-r--r--
ndb_config.test
4.16
KB
-rw-r--r--
ndb_config2.test
514
B
-rw-r--r--
ndb_create_table.test
1005
B
-rw-r--r--
ndb_cursor.test
1.1
KB
-rw-r--r--
ndb_database.test
3.18
KB
-rw-r--r--
ndb_dbug_lock.test
2.15
KB
-rw-r--r--
ndb_dbug_tc_select.test
4.03
KB
-rw-r--r--
ndb_dbug_tc_select_1.inc
1.83
KB
-rw-r--r--
ndb_dbug_tc_select_2.inc
1.91
KB
-rw-r--r--
ndb_dbug_tc_select_3.inc
2.06
KB
-rw-r--r--
ndb_dd_alter.test
9
KB
-rw-r--r--
ndb_dd_basic.test
20.93
KB
-rw-r--r--
ndb_dd_bug12581213.cnf
111
B
-rw-r--r--
ndb_dd_bug12581213.test
580
B
-rw-r--r--
ndb_dd_ddl.test
8.07
KB
-rw-r--r--
ndb_dd_disk2memory.test
10.4
KB
-rw-r--r--
ndb_dd_dump.test
10.79
KB
-rw-r--r--
ndb_dd_initial_lg.cnf
796
B
-rw-r--r--
ndb_dd_initial_lg.test
1.11
KB
-rw-r--r--
ndb_dd_restore_check_tablespac...
12.25
KB
-rw-r--r--
ndb_dd_restore_compat.test
1.13
KB
-rw-r--r--
ndb_dd_sql_features.test
16.35
KB
-rw-r--r--
ndb_ddl_open_trans.test
3.03
KB
-rw-r--r--
ndb_disconnect_ddl.test
1.52
KB
-rw-r--r--
ndb_discover_db-master.opt
43
B
-rw-r--r--
ndb_discover_db.test
3.41
KB
-rw-r--r--
ndb_dist_priv.test
10.53
KB
-rw-r--r--
ndb_dist_priv_bug_13340854.tes...
1.31
KB
-rw-r--r--
ndb_err4012.test
2.79
KB
-rw-r--r--
ndb_error_reporter.ini
288
B
-rw-r--r--
ndb_error_reporter.test
3.3
KB
-rw-r--r--
ndb_fired_trigger_shortage.cnf
60
B
-rw-r--r--
ndb_fired_trigger_shortage.tes...
1.31
KB
-rw-r--r--
ndb_fk_addnode.cnf
931
B
-rw-r--r--
ndb_fk_addnode.test
2.07
KB
-rw-r--r--
ndb_fk_alter.test
3.95
KB
-rw-r--r--
ndb_fk_bugs.test
20.95
KB
-rw-r--r--
ndb_fk_build.test
2.18
KB
-rw-r--r--
ndb_fk_cascade_delete.test
3.86
KB
-rw-r--r--
ndb_fk_cascade_delete_multi.te...
1.96
KB
-rw-r--r--
ndb_fk_cascade_update.test
1.37
KB
-rw-r--r--
ndb_fk_create_drop.test
2.55
KB
-rw-r--r--
ndb_fk_db.test
2.59
KB
-rw-r--r--
ndb_fk_deferred_cascade.test
2.81
KB
-rw-r--r--
ndb_fk_disable.test
11.61
KB
-rw-r--r--
ndb_fk_is.inc
2.59
KB
-rw-r--r--
ndb_fk_is.test
161
B
-rw-r--r--
ndb_fk_locase.cnf
63
B
-rw-r--r--
ndb_fk_locase.test
1.54
KB
-rw-r--r--
ndb_fk_locking.test
2.1
KB
-rw-r--r--
ndb_fk_multi_column.test
1.5
KB
-rw-r--r--
ndb_fk_mysqldump.test
1.32
KB
-rw-r--r--
ndb_fk_mysqldump2.test
1.76
KB
-rw-r--r--
ndb_fk_no_fk.test
25.97
KB
-rw-r--r--
ndb_fk_no_fk_compat.inc
3.94
KB
-rw-r--r--
ndb_fk_no_fk_legacy.test
112
B
-rw-r--r--
ndb_fk_no_fk_ndb-master.opt
49
B
-rw-r--r--
ndb_fk_no_fk_ndb.test
139
B
-rw-r--r--
ndb_fk_noaction.test
4.78
KB
-rw-r--r--
ndb_fk_resources.cnf
91
B
-rw-r--r--
ndb_fk_resources.test
1.44
KB
-rw-r--r--
ndb_fk_restore.inc
2.9
KB
-rw-r--r--
ndb_fk_restore.test
3.63
KB
-rw-r--r--
ndb_fk_restrict.test
5.19
KB
-rw-r--r--
ndb_fk_self_ref.test
3.85
KB
-rw-r--r--
ndb_fk_setdefault.test
982
B
-rw-r--r--
ndb_fk_setnull.test
2.43
KB
-rw-r--r--
ndb_global_schema_lock.test
3.71
KB
-rw-r--r--
ndb_global_schema_lock_error.t...
1.73
KB
-rw-r--r--
ndb_grant.later
10.98
KB
-rw-r--r--
ndb_hashmap.cnf
61
B
-rw-r--r--
ndb_hashmap.test
821
B
-rw-r--r--
ndb_hidden_pk.test
2.76
KB
-rw-r--r--
ndb_index.test
13.42
KB
-rw-r--r--
ndb_index_ordered.test
15.67
KB
-rw-r--r--
ndb_index_stat.test
11.05
KB
-rw-r--r--
ndb_index_stat_enable.inc
1.18
KB
-rw-r--r--
ndb_index_stat_partitions-mast...
70
B
-rw-r--r--
ndb_index_stat_partitions.test
4.27
KB
-rw-r--r--
ndb_index_stat_restart.test
2.47
KB
-rw-r--r--
ndb_index_unique.test
16.63
KB
-rw-r--r--
ndb_init_schema_locks_count.in...
325
B
-rw-r--r--
ndb_insert.test
37.01
KB
-rw-r--r--
ndb_join_pushdown.inc
131.68
KB
-rw-r--r--
ndb_join_pushdown_bka.test
2.98
KB
-rw-r--r--
ndb_join_pushdown_default.test
356
B
-rw-r--r--
ndb_join_pushdown_nobnl.test
464
B
-rw-r--r--
ndb_join_pushdown_none.test
1.15
KB
-rw-r--r--
ndb_jtie.test
1.17
KB
-rw-r--r--
ndb_limit.test
2.44
KB
-rw-r--r--
ndb_load.test
2.33
KB
-rw-r--r--
ndb_loaddatalocal.test
2.63
KB
-rw-r--r--
ndb_lock.test
5.89
KB
-rw-r--r--
ndb_lock_table.test
494
B
-rw-r--r--
ndb_many_fragments.cnf
433
B
-rw-r--r--
ndb_many_fragments.test
1.91
KB
-rw-r--r--
ndb_mgm.cnf
172
B
-rw-r--r--
ndb_mgm.inc
130
B
-rw-r--r--
ndb_mgm.test
7.38
KB
-rw-r--r--
ndb_mgmd.cnf
99
B
-rw-r--r--
ndb_mgmd.test
637
B
-rw-r--r--
ndb_minmax.test
1.48
KB
-rw-r--r--
ndb_multi.test
11.13
KB
-rw-r--r--
ndb_multi_row.test
1.99
KB
-rw-r--r--
ndb_multi_update_delete.test
2.02
KB
-rw-r--r--
ndb_native_default_support.tes...
27.65
KB
-rw-r--r--
ndb_one_fragment.cnf
443
B
-rw-r--r--
ndb_one_fragment.test
3.14
KB
-rw-r--r--
ndb_optimize_table.test
2.65
KB
-rw-r--r--
ndb_optimized_node_selection.t...
1.09
KB
-rw-r--r--
ndb_partition_error.test
2.04
KB
-rw-r--r--
ndb_partition_error2.test
579
B
-rw-r--r--
ndb_partition_hash.test
1.73
KB
-rw-r--r--
ndb_partition_key.test
7.85
KB
-rw-r--r--
ndb_partition_list.test
2.88
KB
-rw-r--r--
ndb_partition_range.test
8.11
KB
-rw-r--r--
ndb_print_file.test
1.35
KB
-rw-r--r--
ndb_rbwr.inc
2.13
KB
-rw-r--r--
ndb_rbwr.test
11.15
KB
-rw-r--r--
ndb_read_multi_range.test
14.9
KB
-rw-r--r--
ndb_reconnect.test
4.03
KB
-rw-r--r--
ndb_rename.test
1.19
KB
-rw-r--r--
ndb_replace.test
4.34
KB
-rw-r--r--
ndb_restart_nostart.inc
147
B
-rw-r--r--
ndb_restart_start.inc
130
B
-rw-r--r--
ndb_restore_bug17916243.test
1.21
KB
-rw-r--r--
ndb_restore_compat_compression...
46
B
-rw-r--r--
ndb_restore_compat_compression...
799
B
-rw-r--r--
ndb_restore_compat_downward.te...
4.21
KB
-rw-r--r--
ndb_restore_compat_endianness....
6.94
KB
-rw-r--r--
ndb_restore_conv_lossy_charbin...
17.35
KB
-rw-r--r--
ndb_restore_conv_lossy_integra...
23.02
KB
-rw-r--r--
ndb_restore_conv_more.test
20.65
KB
-rw-r--r--
ndb_restore_conv_padding.test
9.58
KB
-rw-r--r--
ndb_restore_conv_promotion.tes...
12.91
KB
-rw-r--r--
ndb_restore_discover.test
1.72
KB
-rw-r--r--
ndb_restore_misc.cnf
147
B
-rw-r--r--
ndb_restore_misc.test
27.44
KB
-rw-r--r--
ndb_restore_print.test
6.98
KB
-rw-r--r--
ndb_restore_schema_blobs.test
4.43
KB
-rw-r--r--
ndb_restore_schema_partitions....
15.04
KB
-rw-r--r--
ndb_restore_schema_rewrites.te...
16.47
KB
-rw-r--r--
ndb_restore_schema_subsets.tes...
11.14
KB
-rw-r--r--
ndb_restore_schema_tolerance.t...
6.72
KB
-rw-r--r--
ndb_restore_undolog.cnf
509
B
-rw-r--r--
ndb_restore_undolog.test
16.89
KB
-rw-r--r--
ndb_row_count.test
3.16
KB
-rw-r--r--
ndb_row_format.test
2.28
KB
-rw-r--r--
ndb_schema_locks_count.inc
308
B
-rw-r--r--
ndb_select_count.test
574
B
-rw-r--r--
ndb_share.cnf
652
B
-rw-r--r--
ndb_share.test
9.86
KB
-rw-r--r--
ndb_short_sigs.cnf
170
B
-rw-r--r--
ndb_short_sigs.test
2.7
KB
-rw-r--r--
ndb_show_tables_result.inc
768
B
-rw-r--r--
ndb_single_user-master.opt
32
B
-rw-r--r--
ndb_single_user.test
4.92
KB
-rw-r--r--
ndb_sp.test
1.09
KB
-rw-r--r--
ndb_spj_dict.test
9.25
KB
-rw-r--r--
ndb_sql_allow_batching.test
1.33
KB
-rw-r--r--
ndb_startup.test
2.01
KB
-rw-r--r--
ndb_statistics.inc
3.31
KB
-rw-r--r--
ndb_statistics0.test
613
B
-rw-r--r--
ndb_statistics1.test
612
B
-rw-r--r--
ndb_subquery.test
7.14
KB
-rw-r--r--
ndb_suma_handover.cnf
324
B
-rw-r--r--
ndb_suma_handover.test
1.62
KB
-rw-r--r--
ndb_temporary.test
1.3
KB
-rw-r--r--
ndb_tmp_table_and_DDL.test
603
B
-rw-r--r--
ndb_transaction.test
5.97
KB
-rw-r--r--
ndb_trigger.test
8.98
KB
-rw-r--r--
ndb_truncate.test
1004
B
-rw-r--r--
ndb_types.test
4.9
KB
-rw-r--r--
ndb_update.test
2.94
KB
-rw-r--r--
ndb_update_no_read.test
17.18
KB
-rw-r--r--
ndb_view.test
817
B
-rw-r--r--
ndb_wait_nostart.inc
103
B
-rw-r--r--
ndb_wait_started.inc
84
B
-rw-r--r--
ndb_wait_until_ready.cnf
544
B
-rw-r--r--
ndb_wait_until_ready.test
4.19
KB
-rw-r--r--
ndb_waiter.inc
148
B
-rw-r--r--
ndb_wl946_create.inc
449
B
-rw-r--r--
ndb_wl946_main.test
7.1
KB
-rw-r--r--
ndb_wl946_main_query.inc
66.38
KB
-rw-r--r--
ndb_wl946_post.test
2.67
KB
-rw-r--r--
ndb_wl946_pre.test
2.67
KB
-rw-r--r--
ndb_wl946_pre_query.inc
589
B
-rw-r--r--
ndb_wl946_select_all.inc
1.41
KB
-rw-r--r--
ndbapi-examples.test
3.29
KB
-rw-r--r--
ndbinfo.test
24.32
KB
-rw-r--r--
ndbinfo_cache.cnf
23
B
-rw-r--r--
ndbinfo_cache.test
882
B
-rw-r--r--
ndbinfo_dump.test
780
B
-rw-r--r--
ndbinfo_upgrade.test
1.15
KB
-rw-r--r--
ps_7ndb.test
1.08
KB
-rw-r--r--
show_attributes.inc
664
B
-rw-r--r--
show_indexes.inc
674
B
-rw-r--r--
show_primary_keys.inc
609
B
-rw-r--r--
show_varpart.inc
762
B
-rw-r--r--
strict_autoinc_5ndb.test
356
B
-rw-r--r--
test_debugger.test
267
B
-rw-r--r--
test_mgm.test
262
B
-rw-r--r--
test_mgmd.cnf
232
B
-rw-r--r--
test_mgmd.test
473
B
-rw-r--r--
test_ndbinfo.test
439
B
-rw-r--r--
wl10837.test
274
B
-rw-r--r--
Delete
Unzip
Zip
${this.title}
Close
Code Editor : ndb_restore_conv_lossy_integral.test
# The include statement below is a temp one for tests that are yet to #be ported to run with InnoDB, #but needs to be kept for tests that would need MyISAM in future. --source include/force_myisam_default.inc ###################################################################### # Test restoring backups with lossy conversions on integral types ###################################################################### -- source include/have_ndb.inc # mysqld's configuration is not relevant to this test -- source include/not_embedded.inc # Turn off STRICT sql_mode since test intentionally truncates # data when preparing the test data(those offending statements # are within enable/disable_warnings) --source suite/ndb/include/turn_off_strict_sql_mode.inc --echo ************************************************************ --echo * Creating table with integral types --echo ************************************************************ 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 ); --echo ************************************************************ --echo * Backing up table with integral types --echo ************************************************************ --source include/ndb_backup.inc # command shortcuts --let $restore_cmd=$NDB_RESTORE --no-defaults -b $the_backup_id --let $restore_cmd=$restore_cmd -r --backup_path=$NDB_BACKUPS-$the_backup_id --echo ************************************************************ --echo * Restoring table with unchanged integral types: --echo * tinyint[unsigned] --> tinyint[unsigned] --echo * smallint[unsigned] --> smallint[unsigned] --echo * mediumint[unsigned] --> mediumint[unsigned] --echo * int[unsigned] --> int[unsigned] --echo * bigint[unsigned] --> bigint[unsigned] --echo ************************************************************ # create a MyISAM table from NDB table, against which to compare data CREATE TABLE t1_myisam ENGINE=MYISAM AS SELECT * FROM t1; # restore table DELETE FROM t1; # for debugging: # --exec $NDB_RESTORE --no-defaults -b $the_backup_id -n 1 -L -r --print $NDB_BACKUPS-$the_backup_id >> $NDB_TOOLS_OUTPUT # --exec $NDB_RESTORE --no-defaults -b $the_backup_id -n 2 -L -r --print $NDB_BACKUPS-$the_backup_id >> $NDB_TOOLS_OUTPUT --exec $restore_cmd -n 1 --print -L > /dev/null --exec $restore_cmd -n 2 --print -L > /dev/null SELECT * FROM t1; # verify data SELECT COUNT(*) FROM t1 NATURAL JOIN t1_myisam; DROP TABLE t1_myisam; --echo ************************************************************ --echo * Restoring table with 1st degree demoted integral types: --echo * tinyint[unsigned] --> tinyint[unsigned] --echo * smallint[unsigned] --> tinyint[unsigned] --echo * mediumint[unsigned] --> smallint[unsigned] --echo * int[unsigned] --> mediumint[unsigned] --echo * bigint[unsigned] --> int[unsigned] --echo ************************************************************ # demote integral type attibutes --disable_warnings 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; --enable_warnings SELECT * FROM t1; # create a MyISAM table from NDB table, against which to compare data CREATE TABLE t1_myisam ENGINE=MYISAM AS SELECT * FROM t1; # restore table DELETE FROM t1; --exec $restore_cmd -n 1 --print -L > /dev/null --exec $restore_cmd -n 2 --print -L > /dev/null SELECT * FROM t1; # verify data SELECT COUNT(*) FROM t1 NATURAL JOIN t1_myisam; DROP TABLE t1_myisam; --echo ************************************************************ --echo * Restoring table with 2nd degree demoted integral types: --echo * tinyint[unsigned] --> tinyint[unsigned] --echo * smallint[unsigned] --> tinyint[unsigned] --echo * mediumint[unsigned] --> tinyint[unsigned] --echo * int[unsigned] --> smallint[unsigned] --echo * bigint[unsigned] --> mediumint[unsigned] --echo ************************************************************ # demote integral type attibutes --disable_warnings 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; --enable_warnings SELECT * FROM t1; # create a MyISAM table from NDB table, against which to compare data CREATE TABLE t1_myisam ENGINE=MYISAM AS SELECT * FROM t1; # restore table DELETE FROM t1; --exec $restore_cmd -n 1 --print -L > /dev/null --exec $restore_cmd -n 2 --print -L > /dev/null SELECT * FROM t1; # verify data SELECT COUNT(*) FROM t1 NATURAL JOIN t1_myisam; DROP TABLE t1_myisam; --echo ************************************************************ --echo * Restoring table with 3rd degree demoted integral types: --echo * tinyint[unsigned] --> tinyint[unsigned] --echo * smallint[unsigned] --> tinyint[unsigned] --echo * mediumint[unsigned] --> tinyint[unsigned] --echo * int[unsigned] --> tinyint[unsigned] --echo * bigint[unsigned] --> smallint[unsigned] --echo ************************************************************ # demote integral type attibutes --disable_warnings 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; --enable_warnings SELECT * FROM t1; # create a MyISAM table from NDB table, against which to compare data CREATE TABLE t1_myisam ENGINE=MYISAM AS SELECT * FROM t1; # restore table DELETE FROM t1; --exec $restore_cmd -n 1 --print -L > /dev/null --exec $restore_cmd -n 2 --print -L > /dev/null SELECT * FROM t1; # verify data SELECT COUNT(*) FROM t1 NATURAL JOIN t1_myisam; DROP TABLE t1_myisam; --echo ************************************************************ --echo * Restoring table with 4th degree demoted integral types: --echo * tinyint[unsigned] --> tinyint[unsigned] --echo * smallint[unsigned] --> tinyint[unsigned] --echo * mediumint[unsigned] --> tinyint[unsigned] --echo * int[unsigned] --> tinyint[unsigned] --echo * bigint[unsigned] --> tinyint[unsigned] --echo ************************************************************ # demote integral type attibutes --disable_warnings 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; --enable_warnings SELECT * FROM t1; # create a MyISAM table from NDB table, against which to compare data CREATE TABLE t1_myisam ENGINE=MYISAM AS SELECT * FROM t1; # restore table DELETE FROM t1; --exec $restore_cmd -n 1 --print -L > /dev/null --exec $restore_cmd -n 2 --print -L > /dev/null SELECT * FROM t1; # verify data SELECT COUNT(*) FROM t1 NATURAL JOIN t1_myisam; DROP TABLE t1_myisam; --echo ************************************************************ --echo * Restoring table with changed signedness: --echo * tinyint unsigned/signed --> tinyint signed/unsigned --echo * smallint unsigned/signed --> smallint signed/unsigned --echo * mediumint unsigned/signed --> mediumint signed/unsigned --echo * int unsigned/signed --> int signed/unsigned --echo * bigint unsigned/signed --> bigint signed/unsigned --echo ************************************************************ # convert signedness of integral type attibutes --disable_warnings 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 ); --enable_warnings SELECT * FROM t1; # create a MyISAM table from NDB table, against which to compare data CREATE TABLE t1_myisam ENGINE=MYISAM AS SELECT * FROM t1; # restore table DELETE FROM t1; --exec $restore_cmd -n 1 --print -L > /dev/null --exec $restore_cmd -n 2 --print -L > /dev/null SELECT * FROM t1; # verify data SELECT COUNT(*) FROM t1 NATURAL JOIN t1_myisam; DROP TABLE t1_myisam; --echo ************************************************************ --echo * Restoring table with changed signedness + 1st degree promoted types: --echo * tinyint unsigned/signed --> smallint signed/unsigned --echo * smallint unsigned/signed --> mediumint signed/unsigned --echo * mediumint unsigned/signed --> int signed/unsigned --echo * int unsigned/signed --> bigint signed/unsigned --echo * bigint unsigned/signed --> bigint signed/unsigned --echo ************************************************************ # convert signedness of integral type attibutes --disable_warnings 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 ); --enable_warnings SELECT * FROM t1; # create a MyISAM table from NDB table, against which to compare data CREATE TABLE t1_myisam ENGINE=MYISAM AS SELECT * FROM t1; # restore table DELETE FROM t1; --exec $restore_cmd -n 1 --print -L > /dev/null --exec $restore_cmd -n 2 --print -L > /dev/null SELECT * FROM t1; # verify data SELECT COUNT(*) FROM t1 NATURAL JOIN t1_myisam; DROP TABLE t1_myisam; --echo ************************************************************ --echo * Restoring table with changed signedness + 2nd degree promoted types: --echo * tinyint unsigned/signed --> mediumint signed/unsigned --echo * smallint unsigned/signed --> int signed/unsigned --echo * mediumint unsigned/signed --> bigint signed/unsigned --echo * int unsigned/signed --> bigint signed/unsigned --echo * bigint unsigned/signed --> bigint signed/unsigned --echo ************************************************************ # convert signedness of integral type attibutes --disable_warnings 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 ); --enable_warnings SELECT * FROM t1; # create a MyISAM table from NDB table, against which to compare data CREATE TABLE t1_myisam ENGINE=MYISAM AS SELECT * FROM t1; # restore table DELETE FROM t1; --exec $restore_cmd -n 1 --print -L > /dev/null --exec $restore_cmd -n 2 --print -L > /dev/null SELECT * FROM t1; # verify data SELECT COUNT(*) FROM t1 NATURAL JOIN t1_myisam; DROP TABLE t1_myisam; --echo ************************************************************ --echo * Restoring table with changed signedness + 3rd degree promoted types: --echo * tinyint unsigned/signed --> int signed/unsigned --echo * smallint unsigned/signed --> bigint signed/unsigned --echo * mediumint unsigned/signed --> bigint signed/unsigned --echo * int unsigned/signed --> bigint signed/unsigned --echo * bigint unsigned/signed --> bigint signed/unsigned --echo ************************************************************ # convert signedness of integral type attibutes --disable_warnings 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 ); --enable_warnings SELECT * FROM t1; # create a MyISAM table from NDB table, against which to compare data CREATE TABLE t1_myisam ENGINE=MYISAM AS SELECT * FROM t1; # restore table DELETE FROM t1; --exec $restore_cmd -n 1 --print -L > /dev/null --exec $restore_cmd -n 2 --print -L > /dev/null SELECT * FROM t1; # verify data SELECT COUNT(*) FROM t1 NATURAL JOIN t1_myisam; DROP TABLE t1_myisam; --echo ************************************************************ --echo * Restoring table with changed signedness + 4th degree promoted types: --echo * tinyint unsigned/signed --> bigint signed/unsigned --echo * smallint unsigned/signed --> bigint signed/unsigned --echo * mediumint unsigned/signed --> bigint signed/unsigned --echo * int unsigned/signed --> bigint signed/unsigned --echo * bigint unsigned/signed --> bigint signed/unsigned --echo ************************************************************ # convert signedness of integral type attibutes --disable_warnings 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 ); --enable_warnings SELECT * FROM t1; # create a MyISAM table from NDB table, against which to compare data CREATE TABLE t1_myisam ENGINE=MYISAM AS SELECT * FROM t1; # restore table DELETE FROM t1; --exec $restore_cmd -n 1 --print -L > /dev/null --exec $restore_cmd -n 2 --print -L > /dev/null SELECT * FROM t1; # verify data SELECT COUNT(*) FROM t1 NATURAL JOIN t1_myisam; DROP TABLE t1_myisam; --echo ************************************************************ --echo * Restoring table with changed signedness + 1st degree demoted types: --echo * tinyint unsigned/signed --> tinyint signed/unsigned --echo * smallint unsigned/signed --> tinyint signed/unsigned --echo * mediumint unsigned/signed --> smallint signed/unsigned --echo * int unsigned/signed --> mediumint signed/unsigned --echo * bigint unsigned/signed --> int signed/unsigned --echo ************************************************************ # convert signedness of integral type attibutes --disable_warnings 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 ); --enable_warnings SELECT * FROM t1; # create a MyISAM table from NDB table, against which to compare data CREATE TABLE t1_myisam ENGINE=MYISAM AS SELECT * FROM t1; # restore table DELETE FROM t1; --exec $restore_cmd -n 1 --print -L > /dev/null --exec $restore_cmd -n 2 --print -L > /dev/null SELECT * FROM t1; # verify data SELECT COUNT(*) FROM t1 NATURAL JOIN t1_myisam; DROP TABLE t1_myisam; --echo ************************************************************ --echo * Restoring table with changed signedness + 2nd degree demoted types: --echo * tinyint unsigned/signed --> tinyint signed/unsigned --echo * smallint unsigned/signed --> tinyint signed/unsigned --echo * mediumint unsigned/signed --> tinyint signed/unsigned --echo * int unsigned/signed --> smallint signed/unsigned --echo * bigint unsigned/signed --> mediumint signed/unsigned --echo ************************************************************ # convert signedness of integral type attibutes --disable_warnings 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 ); --enable_warnings SELECT * FROM t1; # create a MyISAM table from NDB table, against which to compare data CREATE TABLE t1_myisam ENGINE=MYISAM AS SELECT * FROM t1; # restore table DELETE FROM t1; --exec $restore_cmd -n 1 --print -L > /dev/null --exec $restore_cmd -n 2 --print -L > /dev/null SELECT * FROM t1; # verify data SELECT COUNT(*) FROM t1 NATURAL JOIN t1_myisam; DROP TABLE t1_myisam; --echo ************************************************************ --echo * Restoring table with changed signedness + 3rd degree demoted types: --echo * tinyint unsigned/signed --> tinyint signed/unsigned --echo * smallint unsigned/signed --> tinyint signed/unsigned --echo * mediumint unsigned/signed --> tinyint signed/unsigned --echo * int unsigned/signed --> tinyint signed/unsigned --echo * bigint unsigned/signed --> smallint signed/unsigned --echo ************************************************************ # convert signedness of integral type attibutes --disable_warnings 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 ); --enable_warnings SELECT * FROM t1; # create a MyISAM table from NDB table, against which to compare data CREATE TABLE t1_myisam ENGINE=MYISAM AS SELECT * FROM t1; # restore table DELETE FROM t1; --exec $restore_cmd -n 1 --print -L > /dev/null --exec $restore_cmd -n 2 --print -L > /dev/null SELECT * FROM t1; # verify data SELECT COUNT(*) FROM t1 NATURAL JOIN t1_myisam; DROP TABLE t1_myisam; --echo ************************************************************ --echo * Restoring table with changed signedness + 4th degree demoted types: --echo * tinyint unsigned/signed --> tinyint signed/unsigned --echo * smallint unsigned/signed --> tinyint signed/unsigned --echo * mediumint unsigned/signed --> tinyint signed/unsigned --echo * int unsigned/signed --> tinyint signed/unsigned --echo * bigint unsigned/signed --> tinyint signed/unsigned --echo ************************************************************ # convert signedness of integral type attibutes --disable_warnings 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 ); --enable_warnings SELECT * FROM t1; # create a MyISAM table from NDB table, against which to compare data CREATE TABLE t1_myisam ENGINE=MYISAM AS SELECT * FROM t1; # restore table DELETE FROM t1; --exec $restore_cmd -n 1 --print -L > /dev/null --exec $restore_cmd -n 2 --print -L > /dev/null SELECT * FROM t1; # verify data SELECT COUNT(*) FROM t1 NATURAL JOIN t1_myisam; DROP TABLE t1_myisam; --echo ************************************************************ --echo * Deleting table with integral types --echo ************************************************************ DROP TABLE t1; --source suite/ndb/include/restore_sql_mode_after_turn_off_strict.inc
Close