403Webshell
Server IP : 104.21.38.3  /  Your IP : 172.69.176.171
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/parts/inc/

Upload File :
current_dir [ Writeable ] document_root [ Writeable ]

 

Command :


[ Back ]     

Current File : /www/server/mysql/src/mysql-test/suite/parts/inc/part_exch_ext_sel.inc
SHOW CREATE TABLE t_10;
SHOW CREATE TABLE t_100;
SHOW CREATE TABLE t_1000;
SHOW CREATE TABLE tp_r;
SHOW CREATE TABLE tsp_r;

--sorted_result
SELECT * FROM t_10;
--sorted_result
SELECT * FROM t_100;
--sorted_result
SELECT * FROM t_1000;

--sorted_result
SELECT * FROM tp_r;
--sorted_result
SELECT * FROM tp_r WHERE a< 10;
--sorted_result
SELECT * FROM tp_r WHERE a BETWEEN 11 AND 100;
--sorted_result
SELECT * FROM tp_r WHERE a BETWEEN 101 AND 200;
--sorted_result
SELECT * FROM tsp_r;

--sorted_result
SELECT * FROM tp_r PARTITION (p0);
--sorted_result
SELECT * FROM tp_r PARTITION (p1);
--sorted_result
SELECT * FROM tp_r PARTITION (p2);

--sorted_result
SELECT * FROM tsp_r PARTITION (p0);
--sorted_result
SELECT * FROM tsp_r PARTITION (p1);
--sorted_result
SELECT * FROM tsp_r PARTITION (p2);

--sorted_result
SELECT * FROM tsp_r PARTITION (sp00);
--sorted_result
SELECT * FROM tsp_r PARTITION (sp01);
--sorted_result
SELECT * FROM tsp_r PARTITION (sp02);
--sorted_result
SELECT * FROM tsp_r PARTITION (sp03);
--sorted_result
SELECT * FROM tsp_r PARTITION (sp04);
--sorted_result
SELECT * FROM tsp_r PARTITION (sp10);
--sorted_result
SELECT * FROM tsp_r PARTITION (sp11);
--sorted_result
SELECT * FROM tsp_r PARTITION (sp12);
--sorted_result
SELECT * FROM tsp_r PARTITION (sp13);
--sorted_result
SELECT * FROM tsp_r PARTITION (sp14);
--sorted_result
SELECT * FROM tsp_r PARTITION (sp20);
--sorted_result
SELECT * FROM tsp_r PARTITION (sp21);
--sorted_result
SELECT * FROM tsp_r PARTITION (sp22);
--sorted_result
SELECT * FROM tsp_r PARTITION (sp23);
--sorted_result
SELECT * FROM tsp_r PARTITION (sp24);

--sorted_result
SELECT * FROM tp_rintvar PARTITION (p0);
--sorted_result
SELECT * FROM tp_rintvar PARTITION (p1);
--sorted_result
SELECT * FROM tp_rintvar PARTITION (p2);

--sorted_result
SELECT * FROM tp_rvar PARTITION (p0);
--sorted_result
SELECT * FROM tp_rvar PARTITION (p1);
--sorted_result
SELECT * FROM tp_rvar PARTITION (p2);

--sorted_result
SELECT * FROM tp_rintdate PARTITION (p0);
--sorted_result
SELECT * FROM tp_rintdate PARTITION (p1);
--sorted_result
SELECT * FROM tp_rintdate PARTITION (p2);

--sorted_result
SELECT * FROM tp_rdate PARTITION (p0);
--sorted_result
SELECT * FROM tp_rdate PARTITION (p1);
--sorted_result
SELECT * FROM tp_rdate PARTITION (p2);

--sorted_result
SELECT * FROM tsp_rvar PARTITION (p0);
--sorted_result
SELECT * FROM tsp_rvar PARTITION (p1);
--sorted_result
SELECT * FROM tsp_rvar PARTITION (p2);

--sorted_result
SELECT * FROM tsp_rvar PARTITION (sp00);
--sorted_result
SELECT * FROM tsp_rvar PARTITION (sp01);
--sorted_result
SELECT * FROM tsp_rvar PARTITION (sp02);
--sorted_result
SELECT * FROM tsp_rvar PARTITION (sp03);
--sorted_result
SELECT * FROM tsp_rvar PARTITION (sp04);
--sorted_result
SELECT * FROM tsp_rvar PARTITION (sp10);
--sorted_result
SELECT * FROM tsp_rvar PARTITION (sp11);
--sorted_result
SELECT * FROM tsp_rvar PARTITION (sp12);
--sorted_result
SELECT * FROM tsp_rvar PARTITION (sp13);
--sorted_result
SELECT * FROM tsp_rvar PARTITION (sp20);
--sorted_result
SELECT * FROM tsp_rvar PARTITION (sp21);
--sorted_result
SELECT * FROM tsp_rvar PARTITION (sp22);
--sorted_result
SELECT * FROM tsp_rvar PARTITION (sp23);

SELECT count(a) FROM tsp_rvar;

SELECT partition_name, subpartition_name FROM information_schema.partitions 
       WHERE table_name LIKE 'tsp_rvar1';
--sorted_result
SELECT * FROM tsp_rvar1 PARTITION (p0);
--sorted_result
SELECT * FROM tsp_rvar1 PARTITION (p1);
--sorted_result
SELECT * FROM tsp_rvar1 PARTITION (p2);
--sorted_result
SELECT * FROM tsp_rvar1 PARTITION (p0sp0);
--sorted_result
SELECT * FROM tsp_rvar1 PARTITION (p0sp1);
--sorted_result
SELECT * FROM tsp_rvar1 PARTITION (p0sp2);
--sorted_result
SELECT * FROM tsp_rvar1 PARTITION (p0sp3);
--sorted_result
SELECT * FROM tsp_rvar1 PARTITION (p0sp4);
--sorted_result
SELECT * FROM tsp_rvar1 PARTITION (p1sp0);
--sorted_result
SELECT * FROM tsp_rvar1 PARTITION (p1sp1);
--sorted_result
SELECT * FROM tsp_rvar1 PARTITION (p1sp2);
--sorted_result
SELECT * FROM tsp_rvar1 PARTITION (p1sp3);
--sorted_result
SELECT * FROM tsp_rvar1 PARTITION (p1sp4);
--sorted_result
SELECT * FROM tsp_rvar1 PARTITION (p2sp0);
--sorted_result
SELECT * FROM tsp_rvar1 PARTITION (p2sp1);
--sorted_result
SELECT * FROM tsp_rvar1 PARTITION (p2sp2);
--sorted_result
SELECT * FROM tsp_rvar1 PARTITION (p2sp3);
--sorted_result
SELECT * FROM tsp_rvar1 PARTITION (p2sp4);

SELECT count(a) FROM tsp_rvar1;

SELECT partition_name, subpartition_name FROM information_schema.partitions 
      WHERE table_name LIKE 'tp_l';

SELECT * FROM tp_l PARTITION (p0);
--sorted_result
SELECT * FROM tp_l PARTITION (p1);
--sorted_result
SELECT * FROM tp_l PARTITION (p2);

SELECT count(a) FROM tp_l;

SELECT partition_name, subpartition_name FROM information_schema.partitions 
      WHERE table_name LIKE 'tsp_l';

--sorted_result
SELECT * FROM tsp_l PARTITION (p0);
--sorted_result
SELECT * FROM tsp_l PARTITION (p1);
--sorted_result
SELECT * FROM tsp_l PARTITION (p2);

--sorted_result
SELECT * FROM tsp_l PARTITION (sp00);
--sorted_result
SELECT * FROM tsp_l PARTITION (sp01);
--sorted_result
SELECT * FROM tsp_l PARTITION (sp02);
--sorted_result
SELECT * FROM tsp_l PARTITION (sp03);
--sorted_result
SELECT * FROM tsp_l PARTITION (sp04);
--sorted_result
SELECT * FROM tsp_l PARTITION (sp10);
--sorted_result
SELECT * FROM tsp_l PARTITION (sp11);
--sorted_result
SELECT * FROM tsp_l PARTITION (sp12);
--sorted_result
SELECT * FROM tsp_l PARTITION (sp13);
--sorted_result
SELECT * FROM tsp_l PARTITION (sp20);
--sorted_result
SELECT * FROM tsp_l PARTITION (sp21);
--sorted_result
SELECT * FROM tsp_l PARTITION (sp22);
--sorted_result
SELECT * FROM tsp_l PARTITION (sp23);
--sorted_result
SELECT * FROM tsp_l PARTITION (sp24);

SELECT count(a) FROM tsp_l;

--sorted_result
SELECT * FROM tp_k PARTITION (p0);
--sorted_result
SELECT * FROM tp_k PARTITION (p1);
--sorted_result
SELECT * FROM tp_k PARTITION (p2);

SELECT count(a) FROM tp_k;

--sorted_result
SELECT * FROM tp_kvar PARTITION (p0);
--sorted_result
SELECT * FROM tp_kvar PARTITION (p1);
--sorted_result
SELECT * FROM tp_kvar PARTITION (p2);

SELECT count(a) FROM tp_kvar;

--sorted_result
SELECT * FROM tp_kdate PARTITION (p0);
--sorted_result
SELECT * FROM tp_kdate PARTITION (p1);
--sorted_result
SELECT * FROM tp_kdate PARTITION (p2);

SELECT count(a) FROM tp_kdate;

--sorted_result
SELECT * FROM tp_h PARTITION (p0);
--sorted_result
SELECT * FROM tp_h PARTITION (p1);
--sorted_result
SELECT * FROM tp_h PARTITION (p2);

SELECT count(a) FROM tp_h;

--sorted_result
SELECT * FROM tp_hvar PARTITION (p0);
--sorted_result
SELECT * FROM tp_hvar PARTITION (p1);
--sorted_result
SELECT * FROM tp_hvar PARTITION (p2);

SELECT count(a) FROM tp_hvar;

--sorted_result
SELECT * FROM tp_hdate PARTITION (p0);
--sorted_result
SELECT * FROM tp_hdate PARTITION (p1);
--sorted_result
SELECT * FROM tp_hdate PARTITION (p2);

SELECT count(a) FROM tp_hdate;


Youez - 2016 - github.com/yon3zu
LinuXploit