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 | : 13.59.210.36
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_fk_restore.result
drop table if exists t2, t1; # bug#16285826 create table t1 ( a1 int primary key ) engine ndb; insert into t1 (a1) values (1),(2),(3),(4),(5),(6),(7),(8),(9); create table t2 ( a2 int primary key auto_increment, b2 int not null, key xb2 (b2), foreign key fkb2a1 (b2) references t1 (a1) ) engine ndb; # TEST: basic meta # show meta show create table t2; Table Create Table t2 CREATE TABLE `t2` ( `a2` int(11) NOT NULL AUTO_INCREMENT, `b2` int(11) NOT NULL, PRIMARY KEY (`a2`), KEY `xb2` (`b2`), CONSTRAINT `fkb2a1` FOREIGN KEY (`b2`) REFERENCES `t1` (`a1`) ON DELETE NO ACTION ON UPDATE NO ACTION ) ENGINE=ndbcluster DEFAULT CHARSET=latin1 ndb_show_tables completed..... select type,name from ndb_show_tables_results where type in ('''ForeignKey''','''FKParentTrigger''','''FKChildTrigger'''); type name 'FKChildTrigger' 'NDB$FK_XX_CHILD_XX' 'FKParentTrigger' 'NDB$FK_XX_PARENT_XX' 'ForeignKey' 'XX/XX/fkb2a1' # show counts select count(*) from t1; count(*) 9 select count(*) from t2; count(*) 0 # run backup # drop tables drop table t2, t1; # restore meta # restore data # show meta show create table t2; Table Create Table t2 CREATE TABLE `t2` ( `a2` int(11) NOT NULL AUTO_INCREMENT, `b2` int(11) NOT NULL, PRIMARY KEY (`a2`), KEY `xb2` (`b2`), CONSTRAINT `fkb2a1` FOREIGN KEY (`b2`) REFERENCES `t1` (`a1`) ON DELETE NO ACTION ON UPDATE NO ACTION ) ENGINE=ndbcluster DEFAULT CHARSET=latin1 ndb_show_tables completed..... select type,name from ndb_show_tables_results where type in ('''ForeignKey''','''FKParentTrigger''','''FKChildTrigger'''); type name 'FKChildTrigger' 'NDB$FK_XX_CHILD_XX' 'FKParentTrigger' 'NDB$FK_XX_PARENT_XX' 'ForeignKey' 'XX/XX/fkb2a1' # show counts select count(*) from t1; count(*) 9 select count(*) from t2; count(*) 0 # TEST: basic data insert into t2 (b2) select x.a1 from t1 x,t1 y; insert into t2 (b2) values (10); ERROR 23000: Cannot add or update a child row: a foreign key constraint fails (Unknown error code) delete from t1 where a1 = 1; ERROR 23000: Cannot delete or update a parent row: a foreign key constraint fails (Unknown error code) # show meta show create table t2; Table Create Table t2 CREATE TABLE `t2` ( `a2` int(11) NOT NULL AUTO_INCREMENT, `b2` int(11) NOT NULL, PRIMARY KEY (`a2`), KEY `xb2` (`b2`), CONSTRAINT `fkb2a1` FOREIGN KEY (`b2`) REFERENCES `t1` (`a1`) ON DELETE NO ACTION ON UPDATE NO ACTION ) ENGINE=ndbcluster AUTO_INCREMENT=83 DEFAULT CHARSET=latin1 ndb_show_tables completed..... select type,name from ndb_show_tables_results where type in ('''ForeignKey''','''FKParentTrigger''','''FKChildTrigger'''); type name 'FKChildTrigger' 'NDB$FK_XX_CHILD_XX' 'FKParentTrigger' 'NDB$FK_XX_PARENT_XX' 'ForeignKey' 'XX/XX/fkb2a1' # show counts select count(*) from t1; count(*) 9 select count(*) from t2; count(*) 81 # run backup # drop tables drop table t2, t1; # restore meta # restore data # show meta show create table t2; Table Create Table t2 CREATE TABLE `t2` ( `a2` int(11) NOT NULL AUTO_INCREMENT, `b2` int(11) NOT NULL, PRIMARY KEY (`a2`), KEY `xb2` (`b2`), CONSTRAINT `fkb2a1` FOREIGN KEY (`b2`) REFERENCES `t1` (`a1`) ON DELETE NO ACTION ON UPDATE NO ACTION ) ENGINE=ndbcluster AUTO_INCREMENT=97 DEFAULT CHARSET=latin1 ndb_show_tables completed..... select type,name from ndb_show_tables_results where type in ('''ForeignKey''','''FKParentTrigger''','''FKChildTrigger'''); type name 'FKChildTrigger' 'NDB$FK_XX_CHILD_XX' 'FKParentTrigger' 'NDB$FK_XX_PARENT_XX' 'ForeignKey' 'XX/XX/fkb2a1' # show counts select count(*) from t1; count(*) 9 select count(*) from t2; count(*) 81 insert into t2 (b2) values (10); ERROR 23000: Cannot add or update a child row: a foreign key constraint fails (Unknown error code) delete from t1 where a1 = 1; ERROR 23000: Cannot delete or update a parent row: a foreign key constraint fails (Unknown error code) # TEST: child part key drop table t2; create table t2 ( a2 int primary key auto_increment, b2 int not null, c2 int not null, key xb2c2 (b2,c2), foreign key fkb2a1 (b2) references t1 (a1) ) engine ndb; insert into t2 (b2,c2) select x.a1,99 from t1 x,t1 y; insert into t2 (b2,c2) values (10,99); ERROR 23000: Cannot add or update a child row: a foreign key constraint fails (Unknown error code) delete from t1 where a1 = 1; ERROR 23000: Cannot delete or update a parent row: a foreign key constraint fails (Unknown error code) # show meta show create table t2; Table Create Table t2 CREATE TABLE `t2` ( `a2` int(11) NOT NULL AUTO_INCREMENT, `b2` int(11) NOT NULL, `c2` int(11) NOT NULL, PRIMARY KEY (`a2`), KEY `xb2c2` (`b2`,`c2`), CONSTRAINT `fkb2a1` FOREIGN KEY (`b2`) REFERENCES `t1` (`a1`) ON DELETE NO ACTION ON UPDATE NO ACTION ) ENGINE=ndbcluster AUTO_INCREMENT=83 DEFAULT CHARSET=latin1 ndb_show_tables completed..... select type,name from ndb_show_tables_results where type in ('''ForeignKey''','''FKParentTrigger''','''FKChildTrigger'''); type name 'FKChildTrigger' 'NDB$FK_XX_CHILD_XX' 'FKParentTrigger' 'NDB$FK_XX_PARENT_XX' 'ForeignKey' 'XX/XX/fkb2a1' # show counts select count(*) from t1; count(*) 9 select count(*) from t2; count(*) 81 # run backup # drop tables drop table t2, t1; # restore meta # restore data # show meta show create table t2; Table Create Table t2 CREATE TABLE `t2` ( `a2` int(11) NOT NULL AUTO_INCREMENT, `b2` int(11) NOT NULL, `c2` int(11) NOT NULL, PRIMARY KEY (`a2`), KEY `xb2c2` (`b2`,`c2`), CONSTRAINT `fkb2a1` FOREIGN KEY (`b2`) REFERENCES `t1` (`a1`) ON DELETE NO ACTION ON UPDATE NO ACTION ) ENGINE=ndbcluster AUTO_INCREMENT=97 DEFAULT CHARSET=latin1 ndb_show_tables completed..... select type,name from ndb_show_tables_results where type in ('''ForeignKey''','''FKParentTrigger''','''FKChildTrigger'''); type name 'FKChildTrigger' 'NDB$FK_XX_CHILD_XX' 'FKParentTrigger' 'NDB$FK_XX_PARENT_XX' 'ForeignKey' 'XX/XX/fkb2a1' # show counts select count(*) from t1; count(*) 9 select count(*) from t2; count(*) 81 insert into t2 (b2,c2) values (10,99); ERROR 23000: Cannot add or update a child row: a foreign key constraint fails (Unknown error code) delete from t1 where a1 = 1; ERROR 23000: Cannot delete or update a parent row: a foreign key constraint fails (Unknown error code) # TEST: column order drop table t2,t1; create table t1 ( a1 int primary key, b1 int not null, c1 int not null, unique key (b1,c1) using hash ) engine ndb; insert into t1 (a1,b1,c1) values (1,11,12),(2,21,22),(3,31,32),(4,41,42),(5,51,52),(6,61,62); create table t2 ( a2 int primary key auto_increment, b2 int not null, c2 int not null, key xb2c2 (b2,c2), foreign key fkb2c2c1b1 (b2,c2) references t1 (c1,b1) ) engine ndb; insert into t2 (b2,c2) select x.c1,x.b1 from t1 x,t1 y; insert into t2 (b2,c2) values (61,62); ERROR 23000: Cannot add or update a child row: a foreign key constraint fails (Unknown error code) delete from t1 where b1=61 and c1=62; ERROR 23000: Cannot delete or update a parent row: a foreign key constraint fails (Unknown error code) # show meta show create table t2; Table Create Table t2 CREATE TABLE `t2` ( `a2` int(11) NOT NULL AUTO_INCREMENT, `b2` int(11) NOT NULL, `c2` int(11) NOT NULL, PRIMARY KEY (`a2`), KEY `xb2c2` (`b2`,`c2`), CONSTRAINT `fkb2c2c1b1` FOREIGN KEY (`b2`,`c2`) REFERENCES `t1` (`c1`,`b1`) ON DELETE NO ACTION ON UPDATE NO ACTION ) ENGINE=ndbcluster AUTO_INCREMENT=38 DEFAULT CHARSET=latin1 ndb_show_tables completed..... select type,name from ndb_show_tables_results where type in ('''ForeignKey''','''FKParentTrigger''','''FKChildTrigger'''); type name 'FKChildTrigger' 'NDB$FK_XX_CHILD_XX' 'FKParentTrigger' 'NDB$FK_XX_PARENT_XX' 'ForeignKey' 'XX/XX/fkb2c2c1b1' # show counts select count(*) from t1; count(*) 6 select count(*) from t2; count(*) 36 # run backup # drop tables drop table t2, t1; # restore meta # restore data # show meta show create table t2; Table Create Table t2 CREATE TABLE `t2` ( `a2` int(11) NOT NULL AUTO_INCREMENT, `b2` int(11) NOT NULL, `c2` int(11) NOT NULL, PRIMARY KEY (`a2`), KEY `xb2c2` (`b2`,`c2`), CONSTRAINT `fkb2c2c1b1` FOREIGN KEY (`b2`,`c2`) REFERENCES `t1` (`c1`,`b1`) ON DELETE NO ACTION ON UPDATE NO ACTION ) ENGINE=ndbcluster AUTO_INCREMENT=65 DEFAULT CHARSET=latin1 ndb_show_tables completed..... select type,name from ndb_show_tables_results where type in ('''ForeignKey''','''FKParentTrigger''','''FKChildTrigger'''); type name 'FKChildTrigger' 'NDB$FK_XX_CHILD_XX' 'FKParentTrigger' 'NDB$FK_XX_PARENT_XX' 'ForeignKey' 'XX/XX/fkb2c2c1b1' # show counts select count(*) from t1; count(*) 6 select count(*) from t2; count(*) 36 insert into t2 (b2,c2) values (61,62); ERROR 23000: Cannot add or update a child row: a foreign key constraint fails (Unknown error code) delete from t1 where b1=61 and c1=62; ERROR 23000: Cannot delete or update a parent row: a foreign key constraint fails (Unknown error code) # TEST: disable indexes # show meta show create table t2; Table Create Table t2 CREATE TABLE `t2` ( `a2` int(11) NOT NULL AUTO_INCREMENT, `b2` int(11) NOT NULL, `c2` int(11) NOT NULL, PRIMARY KEY (`a2`), KEY `xb2c2` (`b2`,`c2`), CONSTRAINT `fkb2c2c1b1` FOREIGN KEY (`b2`,`c2`) REFERENCES `t1` (`c1`,`b1`) ON DELETE NO ACTION ON UPDATE NO ACTION ) ENGINE=ndbcluster AUTO_INCREMENT=66 DEFAULT CHARSET=latin1 ndb_show_tables completed..... select type,name from ndb_show_tables_results where type in ('''ForeignKey''','''FKParentTrigger''','''FKChildTrigger'''); type name 'FKChildTrigger' 'NDB$FK_XX_CHILD_XX' 'FKParentTrigger' 'NDB$FK_XX_PARENT_XX' 'ForeignKey' 'XX/XX/fkb2c2c1b1' # show counts select count(*) from t1; count(*) 6 select count(*) from t2; count(*) 36 # run backup # drop tables drop table t2, t1; # restore meta (disable indexes) # restore data (disable indexes) # show meta ndb_show_tables completed..... select type,name from ndb_show_tables_results where type in ('''ForeignKey''','''FKParentTrigger''','''FKChildTrigger'''); type name # show counts # TEST: rebuild indexes meta drop table t2, t1; create table t1 ( a1 int primary key, b1 int not null, c1 int not null, unique key (b1,c1) using hash ) engine ndb; create table t2 ( a2 int primary key auto_increment, b2 int not null, c2 int not null, key xb2c2 (b2,c2), foreign key fkb2c2c1b1 (b2,c2) references t1 (c1,b1) ) engine ndb; # show meta show create table t2; Table Create Table t2 CREATE TABLE `t2` ( `a2` int(11) NOT NULL AUTO_INCREMENT, `b2` int(11) NOT NULL, `c2` int(11) NOT NULL, PRIMARY KEY (`a2`), KEY `xb2c2` (`b2`,`c2`), CONSTRAINT `fkb2c2c1b1` FOREIGN KEY (`b2`,`c2`) REFERENCES `t1` (`c1`,`b1`) ON DELETE NO ACTION ON UPDATE NO ACTION ) ENGINE=ndbcluster DEFAULT CHARSET=latin1 ndb_show_tables completed..... select type,name from ndb_show_tables_results where type in ('''ForeignKey''','''FKParentTrigger''','''FKChildTrigger'''); type name 'FKChildTrigger' 'NDB$FK_XX_CHILD_XX' 'FKParentTrigger' 'NDB$FK_XX_PARENT_XX' 'ForeignKey' 'XX/XX/fkb2c2c1b1' # show counts select count(*) from t1; count(*) 0 select count(*) from t2; count(*) 0 # run backup # drop tables drop table t2, t1; # restore meta (disable indexes) # restore data (disable indexes) # rebuild indexes # show meta show create table t2; Table Create Table t2 CREATE TABLE `t2` ( `a2` int(11) NOT NULL AUTO_INCREMENT, `b2` int(11) NOT NULL, `c2` int(11) NOT NULL, PRIMARY KEY (`a2`), KEY `xb2c2` (`b2`,`c2`), CONSTRAINT `fkb2c2c1b1` FOREIGN KEY (`b2`,`c2`) REFERENCES `t1` (`c1`,`b1`) ON DELETE NO ACTION ON UPDATE NO ACTION ) ENGINE=ndbcluster DEFAULT CHARSET=latin1 ndb_show_tables completed..... select type,name from ndb_show_tables_results where type in ('''ForeignKey''','''FKParentTrigger''','''FKChildTrigger'''); type name 'FKChildTrigger' 'NDB$FK_XX_CHILD_XX' 'FKParentTrigger' 'NDB$FK_XX_PARENT_XX' 'ForeignKey' 'XX/XX/fkb2c2c1b1' # show counts select count(*) from t1; count(*) 0 select count(*) from t2; count(*) 0 # TEST: rebuild indexes data alter table t2 algorithm=inplace, drop foreign key fkb2c2c1b1; alter table t2 algorithm=inplace, add foreign key fkb2c2b1c1 (b2,c2) references t1 (b1,c1); insert into t1 (a1,b1,c1) values (1,11,12),(2,21,22),(3,31,32),(4,41,42),(5,51,52),(6,61,62); insert into t2 (b2,c2) select x.b1,x.c1 from t1 x,t1 y; insert into t2 (b2,c2) values (62,61); ERROR 23000: Cannot add or update a child row: a foreign key constraint fails (Unknown error code) delete from t1 where b1=61 and c1=62; ERROR 23000: Cannot delete or update a parent row: a foreign key constraint fails (Unknown error code) # show meta show create table t2; Table Create Table t2 CREATE TABLE `t2` ( `a2` int(11) NOT NULL AUTO_INCREMENT, `b2` int(11) NOT NULL, `c2` int(11) NOT NULL, PRIMARY KEY (`a2`), KEY `xb2c2` (`b2`,`c2`), CONSTRAINT `fkb2c2b1c1` FOREIGN KEY (`b2`,`c2`) REFERENCES `t1` (`b1`,`c1`) ON DELETE NO ACTION ON UPDATE NO ACTION ) ENGINE=ndbcluster AUTO_INCREMENT=38 DEFAULT CHARSET=latin1 ndb_show_tables completed..... select type,name from ndb_show_tables_results where type in ('''ForeignKey''','''FKParentTrigger''','''FKChildTrigger'''); type name 'FKChildTrigger' 'NDB$FK_XX_CHILD_XX' 'FKParentTrigger' 'NDB$FK_XX_PARENT_XX' 'ForeignKey' 'XX/XX/fkb2c2b1c1' # show counts select count(*) from t1; count(*) 6 select count(*) from t2; count(*) 36 # run backup # drop tables drop table t2, t1; # restore meta (disable indexes) # restore data (disable indexes) # rebuild indexes # show meta show create table t2; Table Create Table t2 CREATE TABLE `t2` ( `a2` int(11) NOT NULL AUTO_INCREMENT, `b2` int(11) NOT NULL, `c2` int(11) NOT NULL, PRIMARY KEY (`a2`), KEY `xb2c2` (`b2`,`c2`), CONSTRAINT `fkb2c2b1c1` FOREIGN KEY (`b2`,`c2`) REFERENCES `t1` (`b1`,`c1`) ON DELETE NO ACTION ON UPDATE NO ACTION ) ENGINE=ndbcluster AUTO_INCREMENT=65 DEFAULT CHARSET=latin1 ndb_show_tables completed..... select type,name from ndb_show_tables_results where type in ('''ForeignKey''','''FKParentTrigger''','''FKChildTrigger'''); type name 'FKChildTrigger' 'NDB$FK_XX_CHILD_XX' 'FKParentTrigger' 'NDB$FK_XX_PARENT_XX' 'ForeignKey' 'XX/XX/fkb2c2b1c1' # show counts select count(*) from t1; count(*) 6 select count(*) from t2; count(*) 36 insert into t2 (b2,c2) values (62,61); ERROR 23000: Cannot add or update a child row: a foreign key constraint fails (Unknown error code) delete from t1 where b1=61 and c1=62; ERROR 23000: Cannot delete or update a parent row: a foreign key constraint fails (Unknown error code) drop table t2, t1;
Close