403Webshell
Server IP : 172.67.216.182  /  Your IP : 172.70.143.132
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/r/

Upload File :
current_dir [ Writeable ] document_root [ Writeable ]

 

Command :


[ Back ]     

Current File : /www/server/mysql/src/mysql-test/suite/parts/r/partition_exch_qa.result
use test;
SELECT * FROM t_10;
a	b
1	One
3	Three
5	Five
9	Nine
SELECT * FROM t_100;
a	b
11	Eleven
13	Thirdteen
15	Fifeteen
19	Nineteen
91	Ninety-one
93	Ninety-three
95	Ninety-five
99	Ninety-nine
SELECT * FROM t_1000;
a	b
111	Hundred elven
113	Hundred thirdteen
115	Hundred fiveteen
119	Hundred nineteen
131	Hundred thirty-one
133	Hundred thirty-three
135	Hundred thirty-five
139	Hundred thirty-nine
151	Hundred fifty-one
153	Hundred fifty-three
155	Hundred fity-five
159	Hundred fifty-nine
191	Hundred ninety-one
193	Hundred ninety-three
195	Hundred ninety-five
199	Hundred ninety-nine
SELECT * FROM tp;
a	b
112	Hundred twelve
114	Hundred fourteen
116	Hundred sixteen
118	Hundred eightteen
12	twelve
122	Hundred twenty-two
124	Hundred twenty-four
126	Hundred twenty-six
128	Hundred twenty-eight
14	Fourteen
16	Sixteen
162	Hundred sixty-two
164	Hundred sixty-four
166	Hundred sixty-six
168	Hundred sixty-eight
18	Eightteen
182	Hundred eighty-two
184	Hundred eighty-four
186	Hundred eighty-six
188	Hundred eighty-eight
2	Two
4	Four
6	Six
8	Eight
SELECT * FROM tsp;
a	b
112	Hundred twelve
114	Hundred fourteen
116	Hundred sixteen
118	Hundred eightteen
12	twelve
122	Hundred twenty-two
124	Hundred twenty-four
126	Hundred twenty-six
128	Hundred twenty-eight
14	Fourteen
16	Sixteen
162	Hundred sixty-two
164	Hundred sixty-four
166	Hundred sixty-six
168	Hundred sixty-eight
18	Eightteen
182	Hundred eight-two
184	Hundred eighty-four
186	Hundred eighty-six
188	Hundred eighty-eight
2	Two
4	Four
6	Six
8	Eight
SELECT * FROM tsp_00;
a	b
5	Five
SELECT * FROM tsp_01;
a	b
1	One
SELECT * FROM tsp_02;
a	b
SELECT * FROM tsp_03;
a	b
3	Three
SELECT * FROM tsp_04;
a	b
9	Nine
ALTER TABLE tp EXCHANGE PARTITION p0 WITH TABLE t_10;
SELECT * FROM t_10;
a	b
2	Two
4	Four
6	Six
8	Eight
SELECT * FROM tp WHERE a BETWEEN 0 AND 10;
a	b
1	One
3	Three
5	Five
9	Nine
Warning	1287	The partition engine, used by table 'test.tp', is deprecated and will be removed in a future release. Please use native partitioning instead.
Warnings:
ALTER TABLE tp EXCHANGE PARTITION p0 WITH TABLE t_10;
SELECT * FROM t_10;
a	b
1	One
3	Three
5	Five
9	Nine
SELECT * FROM tp WHERE a BETWEEN 0 AND 10;
a	b
2	Two
4	Four
6	Six
8	Eight
Warning	1287	The partition engine, used by table 'test.tp', is deprecated and will be removed in a future release. Please use native partitioning instead.
Warnings:
ALTER TABLE tp EXCHANGE PARTITION p0 WITH TABLE t_empty;
SELECT * FROM t_empty;
a	b
2	Two
4	Four
6	Six
8	Eight
SELECT * FROM tp WHERE a BETWEEN 0 AND 10;
a	b
Warning	1287	The partition engine, used by table 'test.tp', is deprecated and will be removed in a future release. Please use native partitioning instead.
Warnings:
ALTER TABLE tp EXCHANGE PARTITION p0 WITH TABLE t_empty;
SELECT * FROM t_empty;
a	b
SELECT * FROM tp WHERE a BETWEEN 0 AND 10;
a	b
2	Two
4	Four
6	Six
8	Eight
Warning	1287	The partition engine, used by table 'test.tp', is deprecated and will be removed in a future release. Please use native partitioning instead.
Warnings:
ALTER TABLE tp EXCHANGE PARTITION p0 WITH TABLE t_null;
SELECT * FROM t_null;
a	b
2	Two
4	Four
6	Six
8	Eight
SELECT * FROM tp WHERE a BETWEEN 0 AND 10;
a	b
1	NULL
Warning	1287	The partition engine, used by table 'test.tp', is deprecated and will be removed in a future release. Please use native partitioning instead.
Warnings:
ALTER TABLE tp EXCHANGE PARTITION p0 WITH TABLE t_null;
SELECT * FROM t_null;
a	b
1	NULL
SELECT * FROM tp WHERE a BETWEEN 0 AND 10;
a	b
2	Two
4	Four
6	Six
8	Eight
Warning	1287	The partition engine, used by table 'test.tp', is deprecated and will be removed in a future release. Please use native partitioning instead.
Warnings:
ALTER TABLE tp EXCHANGE PARTITION p1 WITH TABLE t_100;
SELECT * FROM t_100;
a	b
12	twelve
14	Fourteen
16	Sixteen
18	Eightteen
SELECT * FROM tp WHERE a BETWEEN 10 AND 100;
a	b
11	Eleven
13	Thirdteen
15	Fifeteen
19	Nineteen
91	Ninety-one
93	Ninety-three
95	Ninety-five
99	Ninety-nine
Warning	1287	The partition engine, used by table 'test.tp', is deprecated and will be removed in a future release. Please use native partitioning instead.
Warnings:
ALTER TABLE tp EXCHANGE PARTITION p1 WITH TABLE t_100;
SELECT * FROM t_100;
a	b
11	Eleven
13	Thirdteen
15	Fifeteen
19	Nineteen
91	Ninety-one
93	Ninety-three
95	Ninety-five
99	Ninety-nine
SELECT * FROM tp WHERE a BETWEEN 10 AND 100;
a	b
12	twelve
14	Fourteen
16	Sixteen
18	Eightteen
Warning	1287	The partition engine, used by table 'test.tp', is deprecated and will be removed in a future release. Please use native partitioning instead.
Warnings:
ALTER TABLE tp EXCHANGE PARTITION p2 WITH TABLE t_1000;
SELECT * FROM t_1000;
a	b
112	Hundred twelve
114	Hundred fourteen
116	Hundred sixteen
118	Hundred eightteen
122	Hundred twenty-two
124	Hundred twenty-four
126	Hundred twenty-six
128	Hundred twenty-eight
162	Hundred sixty-two
164	Hundred sixty-four
166	Hundred sixty-six
168	Hundred sixty-eight
182	Hundred eighty-two
184	Hundred eighty-four
186	Hundred eighty-six
188	Hundred eighty-eight
SELECT * FROM tp WHERE a BETWEEN 100 AND 1000;
a	b
111	Hundred elven
113	Hundred thirdteen
115	Hundred fiveteen
119	Hundred nineteen
131	Hundred thirty-one
133	Hundred thirty-three
135	Hundred thirty-five
139	Hundred thirty-nine
151	Hundred fifty-one
153	Hundred fifty-three
155	Hundred fity-five
159	Hundred fifty-nine
191	Hundred ninety-one
193	Hundred ninety-three
195	Hundred ninety-five
199	Hundred ninety-nine
Warning	1287	The partition engine, used by table 'test.tp', is deprecated and will be removed in a future release. Please use native partitioning instead.
Warnings:
ALTER TABLE tp EXCHANGE PARTITION p2 WITH TABLE t_1000;
SELECT * FROM t_1000;
a	b
111	Hundred elven
113	Hundred thirdteen
115	Hundred fiveteen
119	Hundred nineteen
131	Hundred thirty-one
133	Hundred thirty-three
135	Hundred thirty-five
139	Hundred thirty-nine
151	Hundred fifty-one
153	Hundred fifty-three
155	Hundred fity-five
159	Hundred fifty-nine
191	Hundred ninety-one
193	Hundred ninety-three
195	Hundred ninety-five
199	Hundred ninety-nine
SELECT * FROM tp WHERE a BETWEEN 100 AND 1000;
a	b
112	Hundred twelve
114	Hundred fourteen
116	Hundred sixteen
118	Hundred eightteen
122	Hundred twenty-two
124	Hundred twenty-four
126	Hundred twenty-six
128	Hundred twenty-eight
162	Hundred sixty-two
164	Hundred sixty-four
166	Hundred sixty-six
168	Hundred sixty-eight
182	Hundred eighty-two
184	Hundred eighty-four
186	Hundred eighty-six
188	Hundred eighty-eight
Warning	1287	The partition engine, used by table 'test.tp', is deprecated and will be removed in a future release. Please use native partitioning instead.
Warnings:
ALTER TABLE tsp EXCHANGE PARTITION sp00 WITH TABLE tsp_00;
ALTER TABLE tsp EXCHANGE PARTITION sp01 WITH TABLE tsp_01;
Warnings:
Warning	1287	The partition engine, used by table 'test.tsp', is deprecated and will be removed in a future release. Please use native partitioning instead.
ALTER TABLE tsp EXCHANGE PARTITION sp02 WITH TABLE tsp_02;
Warnings:
Warning	1287	The partition engine, used by table 'test.tsp', is deprecated and will be removed in a future release. Please use native partitioning instead.
ALTER TABLE tsp EXCHANGE PARTITION sp03 WITH TABLE tsp_03;
Warnings:
Warning	1287	The partition engine, used by table 'test.tsp', is deprecated and will be removed in a future release. Please use native partitioning instead.
ALTER TABLE tsp EXCHANGE PARTITION sp04 WITH TABLE tsp_04;
Warnings:
Warning	1287	The partition engine, used by table 'test.tsp', is deprecated and will be removed in a future release. Please use native partitioning instead.
SELECT * FROM tsp_00;
a	b
SELECT * FROM tsp_01;
a	b
6	Six
SELECT * FROM tsp_02;
a	b
2	Two
SELECT * FROM tsp_03;
a	b
8	Eight
SELECT * FROM tsp_04;
a	b
4	Four
SELECT * FROM tsp WHERE a BETWEEN 0 AND 10;
a	b
1	One
3	Three
5	Five
9	Nine
Warning	1287	The partition engine, used by table 'test.tsp', is deprecated and will be removed in a future release. Please use native partitioning instead.
Warnings:
ALTER TABLE tsp EXCHANGE PARTITION sp00 WITH TABLE tsp_00;
ALTER TABLE tsp EXCHANGE PARTITION sp01 WITH TABLE tsp_01;
Warnings:
Warning	1287	The partition engine, used by table 'test.tsp', is deprecated and will be removed in a future release. Please use native partitioning instead.
ALTER TABLE tsp EXCHANGE PARTITION sp02 WITH TABLE tsp_02;
Warnings:
Warning	1287	The partition engine, used by table 'test.tsp', is deprecated and will be removed in a future release. Please use native partitioning instead.
ALTER TABLE tsp EXCHANGE PARTITION sp03 WITH TABLE tsp_03;
Warnings:
Warning	1287	The partition engine, used by table 'test.tsp', is deprecated and will be removed in a future release. Please use native partitioning instead.
ALTER TABLE tsp EXCHANGE PARTITION sp04 WITH TABLE tsp_04;
Warnings:
Warning	1287	The partition engine, used by table 'test.tsp', is deprecated and will be removed in a future release. Please use native partitioning instead.
SELECT * FROM tsp_00;
a	b
5	Five
SELECT * FROM tsp_01;
a	b
1	One
SELECT * FROM tsp_02;
a	b
SELECT * FROM tsp_03;
a	b
3	Three
SELECT * FROM tsp_04;
a	b
9	Nine
SELECT * FROM tsp WHERE a BETWEEN 0 AND 10;
a	b
2	Two
4	Four
6	Six
8	Eight
Warning	1287	The partition engine, used by table 'test.tsp', is deprecated and will be removed in a future release. Please use native partitioning instead.
Warnings:
ALTER TABLE tsp EXCHANGE PARTITION sp01 WITH TABLE t_null;
SELECT * FROM t_null;
a	b
6	Six
SELECT * FROM tsp WHERE a BETWEEN 0 AND 10;
a	b
1	NULL
2	Two
4	Four
8	Eight
Warning	1287	The partition engine, used by table 'test.tsp', is deprecated and will be removed in a future release. Please use native partitioning instead.
Warnings:
ALTER TABLE tsp EXCHANGE PARTITION sp01 WITH TABLE t_null;
SELECT * FROM t_null;
a	b
1	NULL
SELECT * FROM tsp WHERE a BETWEEN 0 AND 10;
a	b
2	Two
4	Four
6	Six
8	Eight
Warning	1287	The partition engine, used by table 'test.tsp', is deprecated and will be removed in a future release. Please use native partitioning instead.
Warnings:
DROP TABLE IF EXISTS t_10;
DROP TABLE IF EXISTS t_100;
DROP TABLE IF EXISTS t_1000;
DROP TABLE IF EXISTS tp;
DROP TABLE IF EXISTS tsp;
DROP TABLE IF EXISTS tsp_00;
DROP TABLE IF EXISTS tsp_01;
DROP TABLE IF EXISTS tsp_02;
DROP TABLE IF EXISTS tsp_03;
DROP TABLE IF EXISTS tsp_04;
DROP TABLE IF EXISTS t_empty;
DROP TABLE IF EXISTS t_null;

Youez - 2016 - github.com/yon3zu
LinuXploit