403Webshell
Server IP : 172.67.216.182  /  Your IP : 172.71.152.78
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_bug19390895.result
create table t1 (
a int,
b int not null,
c1 char(255),
c2 char(255),
key k1(b, c1, c2)
)
engine = ndb;
insert into t1(a,b,c1,c2) values
(0, 0, 0, 0),
(1, 1, 1, 1),
(2, 2, 2, 1),
(3, 3, 3, 3),
(4, 4, 4, 4),
(5, 5, 5, 5),
(6, 6, 6, 6),
(7, 7, 7, 7),
(8, 8, 8, 8),
(9, 9, 9, 9);
insert into t1 select a + 10,  b, c1, c2 from t1;
insert into t1 select a + 20,  b, c1, c2 from t1;
insert into t1 select a + 40,  b, c1, c2 from t1;
insert into t1 select a + 80,  b, c1, c2 from t1;
insert into t1 select a + 160, b, c1, c2 from t1;
insert into t1 select a + 320, b, c1, c2 from t1;
insert into t1 select a + 640, b, c1, c2 from t1;
insert into t1 select a + 1280, b, c1, c2 from t1;
explain
select * from t1 as x, t1 as y
where y.b = x.a and y.c1 = x.c1 and y.c2 = x.c1;
id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	x	p0,p1,p2,p3,p4,p5,p6,p7	ALL	NULL	NULL	NULL	NULL	2560	100.00	Parent of 2 pushed join@1; Using where with pushed condition ((`test`.`x`.`a` is not null) and (`test`.`x`.`c1` is not null) and (`test`.`x`.`c1` is not null))
1	SIMPLE	y	p0,p1,p2,p3,p4,p5,p6,p7	ref	k1	k1	516	test.x.a,test.x.c1,test.x.c1	10	100.00	Child of 'x' in pushed join@1
Warnings:
Note	1003	/* select#1 */ select `test`.`x`.`a` AS `a`,`test`.`x`.`b` AS `b`,`test`.`x`.`c1` AS `c1`,`test`.`x`.`c2` AS `c2`,`test`.`y`.`a` AS `a`,`test`.`y`.`b` AS `b`,`test`.`y`.`c1` AS `c1`,`test`.`y`.`c2` AS `c2` from `test`.`t1` `x` join `test`.`t1` `y` where ((`test`.`y`.`c1` = `test`.`x`.`c1`) and (`test`.`y`.`c2` = `test`.`x`.`c1`) and (`test`.`y`.`b` = `test`.`x`.`a`))
select count(*) from t1 as x, t1 as y
where y.b = x.a and y.c1 = x.c1 and y.c2 = x.c1;
count(*)
2304
drop table t1;

Youez - 2016 - github.com/yon3zu
LinuXploit