mirror of
https://github.com/MariaDB/server.git
synced 2025-10-30 18:36:12 +01:00
fa137476ff
Revoked executable bit from files that are not supposed to be executed directly. Removed interpreted from files that are not supposed to be executed directly. Added interpreter to files that are supposed to be executed directly.
355 lines
6.5 KiB
Text
355 lines
6.5 KiB
Text
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
|
|
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
|
|
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
|
|
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
|
|
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
|
|
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
|
|
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
|
|
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
|
|
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
|
|
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
|
|
ALTER TABLE tsp EXCHANGE PARTITION sp00 WITH TABLE tsp_00;
|
|
ALTER TABLE tsp EXCHANGE PARTITION sp01 WITH TABLE tsp_01;
|
|
ALTER TABLE tsp EXCHANGE PARTITION sp02 WITH TABLE tsp_02;
|
|
ALTER TABLE tsp EXCHANGE PARTITION sp03 WITH TABLE tsp_03;
|
|
ALTER TABLE tsp EXCHANGE PARTITION sp04 WITH TABLE tsp_04;
|
|
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
|
|
ALTER TABLE tsp EXCHANGE PARTITION sp00 WITH TABLE tsp_00;
|
|
ALTER TABLE tsp EXCHANGE PARTITION sp01 WITH TABLE tsp_01;
|
|
ALTER TABLE tsp EXCHANGE PARTITION sp02 WITH TABLE tsp_02;
|
|
ALTER TABLE tsp EXCHANGE PARTITION sp03 WITH TABLE tsp_03;
|
|
ALTER TABLE tsp EXCHANGE PARTITION sp04 WITH TABLE tsp_04;
|
|
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
|
|
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
|
|
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
|
|
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;
|