403Webshell
Server IP : 172.67.216.182  /  Your IP : 172.69.176.9
Web Server : Apache
System : Linux krdc-ubuntu-s-2vcpu-4gb-amd-blr1-01.localdomain 5.15.0-142-generic #152-Ubuntu SMP Mon May 19 10:54:31 UTC 2025 x86_64
User : www ( 1000)
PHP Version : 7.4.33
Disable Function : passthru,exec,system,putenv,chroot,chgrp,chown,shell_exec,popen,proc_open,pcntl_exec,ini_alter,ini_restore,dl,openlog,syslog,readlink,symlink,popepassthru,pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wifcontinued,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority,imap_open,apache_setenv
MySQL : OFF  |  cURL : ON  |  WGET : ON  |  Perl : ON  |  Python : OFF  |  Sudo : ON  |  Pkexec : ON
Directory :  /www/server/mysql/src/mysql-test/suite/ndb/r/

Upload File :
current_dir [ Writeable ] document_root [ Writeable ]

 

Command :


[ Back ]     

Current File : /www/server/mysql/src/mysql-test/suite/ndb/r/ndb_fk_cascade_update.result
create table parent (
a int primary key auto_increment,
b int,
c int,
unique(b) using hash,
index(c)) engine = ndb;
Warnings:
Warning	1121	Ndb does not support unique index on NULL valued attributes, index access with NULL value will become full table scan
create table child (
a int primary key auto_increment,
b int,
c int,
unique(b) using hash,
index(c)) engine = ndb;
Warnings:
Warning	1121	Ndb does not support unique index on NULL valued attributes, index access with NULL value will become full table scan
alter table child add constraint fkname foreign key (b) references parent(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);
begin;
update parent set b = 1 where a = 1;
select * from child order by 1,2,3;
a	b	c
1	1	1
2	2	2
rollback;
begin;
update parent set b = null where a = 1;
select * from child order by 1,2,3;
a	b	c
1	NULL	1
2	2	2
rollback;
begin;
update parent set b = 3 where a = 1;
select * from child order by 1,2,3;
a	b	c
1	3	1
2	2	2
rollback;
delete from child;
delete from parent;
alter table child drop foreign key fkname;
alter table child add constraint fkname foreign key (c) references parent(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),(3,3,1),(4,4,2);
begin;
update parent set b = null where a = 1;
select * from child order by 1,2,3;
a	b	c
1	1	NULL
2	2	2
3	3	NULL
4	4	2
rollback;
begin;
update parent set b = 3 where a = 1;
select * from child order by 1,2,3;
a	b	c
1	1	3
2	2	2
3	3	3
4	4	2
rollback;
delete from child;
delete from parent;
alter table child drop foreign key fkname;
drop table parent, child;

Youez - 2016 - github.com/yon3zu
LinuXploit