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.148.250.110
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_more.test
-- source include/have_ndb.inc -- source include/not_embedded.inc -- source include/not_windows.inc --echo # bug#17275798 # use a canned backup with NULL char(10) log entries promoted to char(20) create table t1 ( a int unsigned primary key, b char(20), c int unsigned ) engine=ndb; --echo # restore canned backup --exec $NDB_RESTORE --no-defaults -b 1 -n 21 -r --promote-attributes $MYSQL_TEST_DIR/suite/ndb/backups/bug17275798 >> $NDB_TOOLS_OUTPUT select sum(1),sum(isnull(b)),min(b),max(b) from t1; drop table t1; --echo # bug#17395298 create table t1 ( a int primary key, b text, c int ) engine=ndb; insert into t1 values (1,repeat('a',1000),10); insert into t1 values (2,repeat('b',2000),20); insert into t1 values (3,repeat('c',3000),30); --echo # run backup --source include/ndb_backup.inc rename table t1 to t1old; create table t1 ( a int primary key, c int, b text ) engine=ndb; --echo # run restore --exec $NDB_RESTORE --no-defaults -b $the_backup_id -n 1 -r $NDB_BACKUPS-$the_backup_id >> $NDB_TOOLS_OUTPUT --exec $NDB_RESTORE --no-defaults -b $the_backup_id -n 2 -r $NDB_BACKUPS-$the_backup_id >> $NDB_TOOLS_OUTPUT select count(*) from t1 x, t1old y where x.a = y.a and x.b = y.b and x.c = y.c; drop table t1old; drop table t1; --echo # bug#17235051 : char<->binary --echo # plain restore create table t1 ( c1 char(10), c2 varchar(100), c3 varchar(1000), b1 binary(10), b2 varbinary(100), b3 varbinary(1000), d varchar(8000), a int unsigned primary key ) engine=ndb; let $ins = insert into t1 values ('aaa1','bbb1','ccc1','ddd1','eee1','fff1',repeat('x',2000),1), ('aaa2','bbb2','ccc2','ddd2','eee2','fff2',repeat('y',4000),2), ('aaa3','bbb3','ccc3','ddd3','eee3','fff3',repeat('z',6000),3); --eval $ins let $qry = select a, trim(trailing char(0) from c1) as c1,c2,c3, trim(trailing char(0) from b1) as b1,b2,b3 from t1 order by a; --eval $qry --echo # run backup --source include/ndb_backup.inc drop table t1; create table t1 ( b1 char(10), b2 varchar(100), b3 varchar(1000), c1 binary(10), c2 varbinary(100), c3 varbinary(1000), d varchar(8000), a int unsigned primary key ) engine=ndb; --echo # run restore --exec $NDB_RESTORE --no-defaults -b $the_backup_id -n 1 -r -A $NDB_BACKUPS-$the_backup_id >> $NDB_TOOLS_OUTPUT --exec $NDB_RESTORE --no-defaults -b $the_backup_id -n 2 -r -A $NDB_BACKUPS-$the_backup_id >> $NDB_TOOLS_OUTPUT --eval $qry drop table t1; --echo # staging restore create table t1 ( c1 char(10), c2 varchar(100), c3 varchar(1000), b1 binary(10), b2 varbinary(100), b3 varbinary(1000), d varchar(8000), a int unsigned primary key ) engine=ndb; --eval $ins --eval $qry --echo # run backup --source include/ndb_backup.inc drop table t1; create table t1 ( b1 char(10), b2 varchar(100), b3 varchar(1000), c1 binary(10), c2 varbinary(100), c3 varbinary(1000), d text, a int unsigned primary key ) engine=ndb; --echo # run restore --exec $NDB_RESTORE --no-defaults -b $the_backup_id -n 1 -r -A $NDB_BACKUPS-$the_backup_id >> $NDB_TOOLS_OUTPUT --exec $NDB_RESTORE --no-defaults -b $the_backup_id -n 2 -r -A $NDB_BACKUPS-$the_backup_id >> $NDB_TOOLS_OUTPUT --eval $qry drop table t1; --echo # create tablespace create logfile group lg1 add undofile 'undofile1.dat' initial_size 8M undo_buffer_size 1M engine=ndb; create tablespace ts1 add datafile 'datafile1.dat' use logfile group lg1 initial_size 96M engine=ndb; --echo # bug#17235051 : char<->text create table t1 ( b text, c varchar(8000), d text, a int unsigned primary key ) engine=ndb; insert into t1 values (repeat('a',3333),repeat('b',5555),repeat('c',7777),1); insert into t1 values (repeat('d',7777),repeat('e',5555),repeat('f',3333),2); insert into t1 values (null,repeat('h',5555),repeat('i',3333),3); insert into t1 values (repeat('j',7777),null,repeat('l',3333),4); insert into t1 values (repeat('m',7777),repeat('n',5555),null,5); --let $qry = select count(*),sum(crc32(concat(a,ifnull(b,'x'),ifnull(c,'y'),ifnull(d,'z')))) from t1 --eval $qry --echo # run backup --source include/ndb_backup.inc drop table t1; create table t1 ( b varchar(8000), c text, d text, a int unsigned primary key ) engine=ndb; --echo # run restore --exec $NDB_RESTORE --no-defaults -b $the_backup_id -n 1 -r -A -L $NDB_BACKUPS-$the_backup_id >> $NDB_TOOLS_OUTPUT --exec $NDB_RESTORE --no-defaults -b $the_backup_id -n 2 -r -A -L $NDB_BACKUPS-$the_backup_id >> $NDB_TOOLS_OUTPUT --eval $qry drop table t1; --echo # bug#17235051 : remap columns and missing columns create table t1 ( x int, a int primary key auto_increment, b int, c bigint, y int, d varchar(8000) ) engine=ndb; insert into t1 (x,b,c,d) values (1,10,100,repeat('d',30)); let $i=8; while ($i) { eval insert into t1 (x,b,c,d) select x*2,b*3,c*4,concat(d,d) from t1; dec $i; } select count(*),max(a),max(b),max(c),max(length(d)) from t1; # non-deterministic??? try something else #select sum(crc32(concat(a,b,c,d))) from t1; --echo # run backup --source include/ndb_backup.inc rename table t1 to t1old; create table t1 ( d text, z char(10), b int, w char(10), c bigint, a int primary key auto_increment ) engine=ndb; --echo # run restore --exec $NDB_RESTORE --no-defaults -b $the_backup_id -n 1 -r --exclude-missing-columns -A $NDB_BACKUPS-$the_backup_id >> $NDB_TOOLS_OUTPUT --exec $NDB_RESTORE --no-defaults -b $the_backup_id -n 2 -r --exclude-missing-columns -A $NDB_BACKUPS-$the_backup_id >> $NDB_TOOLS_OUTPUT select count(*),max(a),max(b),max(c),max(length(d)) from t1; select count(*) from t1 x, t1old y where x.a = y.a and x.b = y.b and x.c = y.c and x.d = y.d; drop table t1old; drop table t1; --echo # bug#17235051 : lossy conversions create table t1 ( a char(1) primary key, b text, c varchar(10) ) engine=ndb; insert into t1 values ('a',concat('x',repeat('a',1000)),'0123456789'); insert into t1 values ('b',concat('y',repeat('b',2000)),'012345'); insert into t1 values ('c',concat('z',repeat('c',3000)),'01234'); let $qry = select a,length(b),trim(trailing a from b),c from t1 order by a; --eval $qry --echo # run backup --source include/ndb_backup.inc drop table t1; create table t1 ( a char(1) primary key, b varchar(2001), c varchar(5) ) engine=ndb; --echo # run restore --exec $NDB_RESTORE --no-defaults -b $the_backup_id -n 1 -r -L $NDB_BACKUPS-$the_backup_id >> $NDB_TOOLS_OUTPUT --exec $NDB_RESTORE --no-defaults -b $the_backup_id -n 2 -r -L $NDB_BACKUPS-$the_backup_id >> $NDB_TOOLS_OUTPUT --eval $qry drop table t1; --echo # bug#17235051 : char<->text + disk data create table t1old ( a int unsigned primary key auto_increment, b text, c varchar(8000), d text, e varchar(20), f int ) engine=ndb; insert into t1old (b,c,d,e,f) values (repeat('b',20),repeat('c',30),repeat('d',40),'e',1); let $i=8; while ($i) { eval insert into t1old (b,c,d,e,f) select concat(b,c),concat(c,d),concat(d,b),concat(e,'e'),2*f from t1old; dec $i; } select count(*),max(length(b)),max(length(c)),max(length(d)),max(length(e)),max(f) from t1old; let $qry = select count(*) from t1 x, t1old y where x.a = y.a and x.b = y.b and x.c = y.c and x.d = y.d and x.e = y.e and x.f = y.f; let $cre1 = create table t1 ( a int unsigned primary key auto_increment, b text, c varchar(8000), d text, e varchar(20), f int ) engine=ndb; let $cre2 = create table t1 ( e varchar(20), f int, a int unsigned primary key auto_increment, b varchar(8000), c text, d text ) engine=ndb; --echo # restore mem->mem --eval $cre1 insert into t1 select * from t1old; --eval $qry --echo # run backup --source include/ndb_backup.inc drop table t1; --eval $cre2 --echo # run restore --exec $NDB_RESTORE --no-defaults -b $the_backup_id -n 1 -r -A -L $NDB_BACKUPS-$the_backup_id >> $NDB_TOOLS_OUTPUT --exec $NDB_RESTORE --no-defaults -b $the_backup_id -n 2 -r -A -L $NDB_BACKUPS-$the_backup_id >> $NDB_TOOLS_OUTPUT --eval $qry drop table t1; --echo # restore disk->disk --eval $cre1 tablespace ts1 storage disk insert into t1 select * from t1old; --eval $qry --echo # run backup --source include/ndb_backup.inc drop table t1; --eval $cre2 tablespace ts1 storage disk --echo # run restore --exec $NDB_RESTORE --no-defaults -b $the_backup_id -n 1 -r -A -L $NDB_BACKUPS-$the_backup_id >> $NDB_TOOLS_OUTPUT --exec $NDB_RESTORE --no-defaults -b $the_backup_id -n 2 -r -A -L $NDB_BACKUPS-$the_backup_id >> $NDB_TOOLS_OUTPUT --eval $qry drop table t1; drop table t1old; --echo # bug#17235051 : hybrid failure # would fail in obsolete hybrid solution with 738 (Record too big) create table t1 ( a int primary key, b varchar(5000), c varchar(5000) ) engine=ndb; insert into t1 values (1,null,null); select * from t1; --echo # run backup --source include/ndb_backup.inc drop table t1; create table t1 ( a int primary key, b text, c varchar(10000) ) engine=ndb; --echo # run restore --exec $NDB_RESTORE --no-defaults -b $the_backup_id -n 1 -r -A $NDB_BACKUPS-$the_backup_id >> $NDB_TOOLS_OUTPUT --exec $NDB_RESTORE --no-defaults -b $the_backup_id -n 2 -r -A $NDB_BACKUPS-$the_backup_id >> $NDB_TOOLS_OUTPUT select * from t1; drop table t1; --echo # Ignore dynamic column diffs between staging and 'main' --echo # If backed-up had dynamic (due to online alter), and --echo # new does not (due to lack of alter), staging table --echo # should not care. create table t1( a int unsigned primary key, b varchar(6144) ) engine=ndb; --echo # alter causing varchar to become 'dynamic' alter table t1 add column c int; show warnings; insert into t1 values (1,repeat('b',2000), 10); insert into t1 values (2,repeat('t',2000), 20); insert into t1 values (3,repeat('g',2000), 30); --echo # run backup --source include/ndb_backup.inc rename table t1 to t1old; --echo # create t1 with text + without alter (not dynamic by default) create table t1( a int unsigned primary key, b text, c int ) engine=ndb; --echo # run restore --exec $NDB_RESTORE --no-defaults -b $the_backup_id -n 1 -r --promote-attributes $NDB_BACKUPS-$the_backup_id >> $NDB_TOOLS_OUTPUT --exec $NDB_RESTORE --no-defaults -b $the_backup_id -n 2 -r --promote-attributes $NDB_BACKUPS-$the_backup_id >> $NDB_TOOLS_OUTPUT select count(*) from t1 x, t1old y where x.a = y.a and x.b = y.b and x.c = y.c; drop table t1old; drop table t1; --echo # bug#18875137: ndb_restore type conversions --echo # run restore with lossy conversions create table text2text (pk int primary key, t1 tinytext, t2 text, t3 mediumtext, t4 longtext, t5 tinytext, t6 text, t7 mediumtext, t8 longtext, t9 tinytext, t10 text, t11 mediumtext, t12 longtext, t13 tinytext, t14 text, t15 mediumtext, t16 longtext)engine=NDB; insert into text2text values(1, REPEAT("A",255), REPEAT("A",5000), REPEAT("A",65536), REPEAT("A", 30000), REPEAT("A",255), REPEAT("A",5000), REPEAT("A",65537), REPEAT("A", 30000), REPEAT("A",255), REPEAT("A",5000), REPEAT("A",65540), REPEAT("A", 30000), NULL, NULL, NULL, NULL); insert into text2text values(2, "", "", "", "", "", "", "", "", "", "", "", "", NULL, NULL, NULL, NULL); insert into text2text values(3, REPEAT(" -,.;",51), REPEAT(" -,.;",1000), REPEAT(" -,.;",2000), REPEAT(" -,.;", 6000), REPEAT(" -,.;",51), REPEAT(" -,.;",1000), REPEAT(" -,.;",2001), REPEAT(" -,.;", 6000), REPEAT(" -,.;",51), REPEAT(" -,.;",1000), REPEAT(" -,.;",2002), REPEAT(" -,.;", 6000), NULL, NULL, NULL, NULL); insert into text2text values(4, REPEAT("12345",51), REPEAT("12345",1000), REPEAT("12345",2000), REPEAT("12345", 6000), REPEAT("12345",51), REPEAT("12345",1000), REPEAT("12345",2001), REPEAT("12345", 6000), REPEAT("12345",51), REPEAT("12345",1000), REPEAT("12345",2002), REPEAT("12345", 6000), NULL, NULL, NULL, NULL); insert into text2text values(5, REPEAT("abcde",51), REPEAT("abcde",1000), REPEAT("abcde",2000), REPEAT("abcde", 6000), REPEAT("abcde",51), REPEAT("abcde",1000), REPEAT("abcde",2001), REPEAT("abcde", 6000), REPEAT("abcde",51), REPEAT("abcde",1000), REPEAT("abcde",2002), REPEAT("abcde", 6000), NULL, NULL, NULL, NULL); insert into text2text values(6, REPEAT(" ",51), REPEAT(" ",1000), REPEAT(" ",2000), REPEAT(" ", 6000), REPEAT(" ",51), REPEAT(" ",1000), REPEAT(" ",2001), REPEAT(" ", 6000), REPEAT(" ",51), REPEAT(" ",1000), REPEAT(" ",2002), REPEAT(" ", 6000), NULL, NULL, NULL, NULL); insert into text2text values(7, REPEAT("a%d4 ",51), REPEAT("a%d4 ",1000), REPEAT("a%d4 ",2000), REPEAT("a%d4 ", 6000), REPEAT("a%d4 ",51), REPEAT("a%d4 ",1000), REPEAT("a%d4 ",2001), REPEAT("a%d4 ", 6000), REPEAT("a%d4 ",51), REPEAT("a%d4 ",1000), REPEAT("a%d4 ",2002), REPEAT("a%d4 ", 6000), NULL, NULL, NULL, NULL); insert into text2text values(8, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL); --echo # run backup --source include/ndb_backup.inc drop table text2text; create table text2text (pk int primary key, t1 text, t2 mediumtext, t3 longtext, t4 tinytext, t5 mediumtext, t6 longtext, t7 tinytext, t8 text, t9 longtext, t10 tinytext, t11 text, t12 mediumtext, t13 text, t14 mediumtext, t15 longtext, t16 tinytext)engine=NDB; --echo # run restore --exec $NDB_RESTORE --no-defaults -b $the_backup_id -n 1 -r --promote-attributes --lossy-conversions $NDB_BACKUPS-$the_backup_id >> $NDB_TOOLS_OUTPUT --exec $NDB_RESTORE --no-defaults -b $the_backup_id -n 2 -r --promote-attributes --lossy-conversions $NDB_BACKUPS-$the_backup_id >> $NDB_TOOLS_OUTPUT --echo # run ndb_select_all to print restored table --exec $NDB_SELECT_ALL -d test text2text | sort --echo # run select query to see truncation in mysqld select LENGTH(t1), LENGTH(t2), LENGTH(t3), LENGTH(t4), LENGTH(t5), LENGTH(t6), LENGTH(t7), LENGTH(t8), LENGTH(t9), LENGTH(t10), LENGTH(t11), LENGTH(t12) from text2text order by pk; --echo # run restore with no lossy conversions drop table text2text; create table text2text (pk int primary key, t1 text, t2 mediumtext, t3 longtext, t4 tinytext, t5 mediumtext, t6 longtext, t7 tinytext, t8 text, t9 longtext, t10 tinytext, t11 text, t12 mediumtext, t13 text, t14 mediumtext, t15 longtext, t16 tinytext)engine=NDB; --echo # run restore --error 1 --exec $NDB_RESTORE --no-defaults --core-file=0 -b $the_backup_id -n 1 -r --promote-attributes $NDB_BACKUPS-$the_backup_id >> $NDB_TOOLS_OUTPUT 2>&1 --echo # ndb_restore fails with error 1 --error 1 --exec $NDB_RESTORE --no-defaults --core-file=0 -b $the_backup_id -n 2 -r --promote-attributes $NDB_BACKUPS-$the_backup_id >> $NDB_TOOLS_OUTPUT 2>&1 --echo # ndb_restore fails with error 1 --echo # restore NULL values into non-nullable columns drop table text2text; create table text2text (pk int primary key, t1 text not null, t2 mediumtext not null, t3 longtext not null, t4 tinytext not null, t5 mediumtext not null, t6 longtext not null, t7 tinytext not null, t8 text not null, t9 longtext not null, t10 tinytext not null, t11 text not null, t12 mediumtext not null, t13 text not null, t14 mediumtext not null, t15 longtext not null, t16 tinytext not null)engine=NDB; --echo # run restore --error 1 --exec $NDB_RESTORE --no-defaults --core-file=0 -b $the_backup_id -n 1 -r --promote-attributes --lossy-conversions $NDB_BACKUPS-$the_backup_id >> $NDB_TOOLS_OUTPUT 2>&1 --echo # ndb_restore fails with error 1 --exec $NDB_DROP_TABLE --no-defaults -d test text2text\$ST1 >> $NDB_TOOLS_OUTPUT --error 1 --exec $NDB_RESTORE --no-defaults --core-file=0 -b $the_backup_id -n 2 -r --promote-attributes --lossy-conversions $NDB_BACKUPS-$the_backup_id >> $NDB_TOOLS_OUTPUT 2>&1 --echo # ndb_restore fails with error 1 --exec $NDB_DROP_TABLE --no-defaults -d test text2text\$ST2 >> $NDB_TOOLS_OUTPUT --echo # restore to text column with different charset drop table text2text; create table text2text (pk int primary key, t1 text character set utf8, t2 mediumtext character set utf8, t3 longtext character set utf8, t4 tinytext character set utf8, t5 mediumtext character set utf8, t6 longtext character set utf8, t7 tinytext character set utf8, t8 text character set utf8, t9 longtext character set utf8, t10 tinytext character set utf8, t11 text character set utf8, t12 mediumtext character set utf8, t13 text character set utf8, t14 mediumtext character set utf8, t15 longtext character set utf8, t16 tinytext character set utf8)engine=NDB; --echo # run restore --error 1 --exec $NDB_RESTORE --no-defaults --core-file=0 -b $the_backup_id -n 1 -r --promote-attributes --lossy-conversions $NDB_BACKUPS-$the_backup_id >> $NDB_TOOLS_OUTPUT 2>&1 --echo # ndb_restore fails with error 1 --error 1 --exec $NDB_RESTORE --no-defaults --core-file=0 -b $the_backup_id -n 2 -r --promote-attributes --lossy-conversions $NDB_BACKUPS-$the_backup_id >> $NDB_TOOLS_OUTPUT 2>&1 --echo # ndb_restore fails with error 1 --echo # restore with mix of staging and built-in conversions drop table text2text; create table text2text (pk mediumint primary key, t1 text, t2 mediumtext, t3 longtext, t4 tinytext, t5 mediumtext, t6 longtext, t7 tinytext, t8 text, t9 longtext, t10 tinytext, t11 text, t12 mediumtext, t13 text, t14 mediumtext, t15 longtext, t16 tinytext)engine=NDB; --echo # run restore --exec $NDB_RESTORE --no-defaults --core-file=0 -b $the_backup_id -n 1 -r --lossy-conversions --promote-attributes $NDB_BACKUPS-$the_backup_id >> $NDB_TOOLS_OUTPUT 2>&1 --exec $NDB_RESTORE --no-defaults --core-file=0 -b $the_backup_id -n 2 -r --lossy-conversions --promote-attributes $NDB_BACKUPS-$the_backup_id >> $NDB_TOOLS_OUTPUT 2>&1 --echo # run ndb_select_all to print restored table --exec $NDB_SELECT_ALL -d test text2text | sort drop table text2text; --echo # restore with pk built-in conversion and blob staging conversion create table text2text(id char(10) primary key, val text)engine=ndb; insert into text2text values("1111111111", REPEAT("A", 500)); insert into text2text values("2222222222", REPEAT("B", 500)); --echo # run backup --source include/ndb_backup.inc drop table text2text; create table text2text(id varchar(5) primary key, val mediumtext)engine=ndb; --echo # run restore --exec $NDB_RESTORE --no-defaults -b $the_backup_id -n 1 -r --promote-attributes --lossy-conversions $NDB_BACKUPS-$the_backup_id >> $NDB_TOOLS_OUTPUT --exec $NDB_RESTORE --no-defaults -b $the_backup_id -n 2 -r --promote-attributes --lossy-conversions $NDB_BACKUPS-$the_backup_id >> $NDB_TOOLS_OUTPUT --echo # run ndb_select_all to print restored table --exec $NDB_SELECT_ALL -d test text2text | sort --echo # ndb_restore TEXT -> TINYTEXT truncation with utf8 drop table text2text; set character_set_client=utf8; create table text2text(id int primary key, val text character set utf8)engine=ndb; insert into text2text values(11111, REPEAT(UNHEX("E38182"), 100)); insert into text2text values(22222, CONCAT("A",REPEAT(UNHEX("E38182"), 100))); --echo # run backup --source include/ndb_backup.inc drop table text2text; create table text2text(id int primary key, val tinytext character set utf8)engine=ndb; --echo # run restore --exec $NDB_RESTORE --no-defaults -b $the_backup_id -n 1 -r --promote-attributes --lossy-conversions $NDB_BACKUPS-$the_backup_id >> $NDB_TOOLS_OUTPUT --exec $NDB_RESTORE --no-defaults -b $the_backup_id -n 2 -r --promote-attributes --lossy-conversions $NDB_BACKUPS-$the_backup_id >> $NDB_TOOLS_OUTPUT --echo # run ndb_select_all to see charset-aware truncation in ndb --exec $NDB_SELECT_ALL -d test text2text | grep "11111" --echo # run mysql select to see charset-aware truncation in mysqld --echo # truncation in pk-based read select length(val), char_length(val) from text2text where id = 22222; --echo # truncation in scan select length(val), char_length(val) from text2text order by id; drop table text2text; --echo # drop tablespace alter tablespace ts1 drop datafile 'datafile1.dat' engine=ndb; drop tablespace ts1 engine=ndb; drop logfile group lg1 engine=ndb;
Close