1use test; 2SELECT * FROM t_10; 3a b 41 One 53 Three 65 Five 79 Nine 8SELECT * FROM t_100; 9a b 1011 Eleven 1113 Thirdteen 1215 Fifeteen 1319 Nineteen 1491 Ninety-one 1593 Ninety-three 1695 Ninety-five 1799 Ninety-nine 18SELECT * FROM t_1000; 19a b 20111 Hundred elven 21113 Hundred thirdteen 22115 Hundred fiveteen 23119 Hundred nineteen 24131 Hundred thirty-one 25133 Hundred thirty-three 26135 Hundred thirty-five 27139 Hundred thirty-nine 28151 Hundred fifty-one 29153 Hundred fifty-three 30155 Hundred fity-five 31159 Hundred fifty-nine 32191 Hundred ninety-one 33193 Hundred ninety-three 34195 Hundred ninety-five 35199 Hundred ninety-nine 36SELECT * FROM tp; 37a b 38112 Hundred twelve 39114 Hundred fourteen 40116 Hundred sixteen 41118 Hundred eightteen 4212 twelve 43122 Hundred twenty-two 44124 Hundred twenty-four 45126 Hundred twenty-six 46128 Hundred twenty-eight 4714 Fourteen 4816 Sixteen 49162 Hundred sixty-two 50164 Hundred sixty-four 51166 Hundred sixty-six 52168 Hundred sixty-eight 5318 Eightteen 54182 Hundred eighty-two 55184 Hundred eighty-four 56186 Hundred eighty-six 57188 Hundred eighty-eight 582 Two 594 Four 606 Six 618 Eight 62SELECT * FROM tsp; 63a b 64112 Hundred twelve 65114 Hundred fourteen 66116 Hundred sixteen 67118 Hundred eightteen 6812 twelve 69122 Hundred twenty-two 70124 Hundred twenty-four 71126 Hundred twenty-six 72128 Hundred twenty-eight 7314 Fourteen 7416 Sixteen 75162 Hundred sixty-two 76164 Hundred sixty-four 77166 Hundred sixty-six 78168 Hundred sixty-eight 7918 Eightteen 80182 Hundred eight-two 81184 Hundred eighty-four 82186 Hundred eighty-six 83188 Hundred eighty-eight 842 Two 854 Four 866 Six 878 Eight 88SELECT * FROM tsp_00; 89a b 905 Five 91SELECT * FROM tsp_01; 92a b 931 One 94SELECT * FROM tsp_02; 95a b 96SELECT * FROM tsp_03; 97a b 983 Three 99SELECT * FROM tsp_04; 100a b 1019 Nine 102ALTER TABLE tp EXCHANGE PARTITION p0 WITH TABLE t_10; 103SELECT * FROM t_10; 104a b 1052 Two 1064 Four 1076 Six 1088 Eight 109SELECT * FROM tp WHERE a BETWEEN 0 AND 10; 110a b 1111 One 1123 Three 1135 Five 1149 Nine 115ALTER TABLE tp EXCHANGE PARTITION p0 WITH TABLE t_10; 116SELECT * FROM t_10; 117a b 1181 One 1193 Three 1205 Five 1219 Nine 122SELECT * FROM tp WHERE a BETWEEN 0 AND 10; 123a b 1242 Two 1254 Four 1266 Six 1278 Eight 128ALTER TABLE tp EXCHANGE PARTITION p0 WITH TABLE t_empty; 129SELECT * FROM t_empty; 130a b 1312 Two 1324 Four 1336 Six 1348 Eight 135SELECT * FROM tp WHERE a BETWEEN 0 AND 10; 136a b 137ALTER TABLE tp EXCHANGE PARTITION p0 WITH TABLE t_empty; 138SELECT * FROM t_empty; 139a b 140SELECT * FROM tp WHERE a BETWEEN 0 AND 10; 141a b 1422 Two 1434 Four 1446 Six 1458 Eight 146ALTER TABLE tp EXCHANGE PARTITION p0 WITH TABLE t_null; 147SELECT * FROM t_null; 148a b 1492 Two 1504 Four 1516 Six 1528 Eight 153SELECT * FROM tp WHERE a BETWEEN 0 AND 10; 154a b 1551 NULL 156ALTER TABLE tp EXCHANGE PARTITION p0 WITH TABLE t_null; 157SELECT * FROM t_null; 158a b 1591 NULL 160SELECT * FROM tp WHERE a BETWEEN 0 AND 10; 161a b 1622 Two 1634 Four 1646 Six 1658 Eight 166ALTER TABLE tp EXCHANGE PARTITION p1 WITH TABLE t_100; 167SELECT * FROM t_100; 168a b 16912 twelve 17014 Fourteen 17116 Sixteen 17218 Eightteen 173SELECT * FROM tp WHERE a BETWEEN 10 AND 100; 174a b 17511 Eleven 17613 Thirdteen 17715 Fifeteen 17819 Nineteen 17991 Ninety-one 18093 Ninety-three 18195 Ninety-five 18299 Ninety-nine 183ALTER TABLE tp EXCHANGE PARTITION p1 WITH TABLE t_100; 184SELECT * FROM t_100; 185a b 18611 Eleven 18713 Thirdteen 18815 Fifeteen 18919 Nineteen 19091 Ninety-one 19193 Ninety-three 19295 Ninety-five 19399 Ninety-nine 194SELECT * FROM tp WHERE a BETWEEN 10 AND 100; 195a b 19612 twelve 19714 Fourteen 19816 Sixteen 19918 Eightteen 200ALTER TABLE tp EXCHANGE PARTITION p2 WITH TABLE t_1000; 201SELECT * FROM t_1000; 202a b 203112 Hundred twelve 204114 Hundred fourteen 205116 Hundred sixteen 206118 Hundred eightteen 207122 Hundred twenty-two 208124 Hundred twenty-four 209126 Hundred twenty-six 210128 Hundred twenty-eight 211162 Hundred sixty-two 212164 Hundred sixty-four 213166 Hundred sixty-six 214168 Hundred sixty-eight 215182 Hundred eighty-two 216184 Hundred eighty-four 217186 Hundred eighty-six 218188 Hundred eighty-eight 219SELECT * FROM tp WHERE a BETWEEN 100 AND 1000; 220a b 221111 Hundred elven 222113 Hundred thirdteen 223115 Hundred fiveteen 224119 Hundred nineteen 225131 Hundred thirty-one 226133 Hundred thirty-three 227135 Hundred thirty-five 228139 Hundred thirty-nine 229151 Hundred fifty-one 230153 Hundred fifty-three 231155 Hundred fity-five 232159 Hundred fifty-nine 233191 Hundred ninety-one 234193 Hundred ninety-three 235195 Hundred ninety-five 236199 Hundred ninety-nine 237ALTER TABLE tp EXCHANGE PARTITION p2 WITH TABLE t_1000; 238SELECT * FROM t_1000; 239a b 240111 Hundred elven 241113 Hundred thirdteen 242115 Hundred fiveteen 243119 Hundred nineteen 244131 Hundred thirty-one 245133 Hundred thirty-three 246135 Hundred thirty-five 247139 Hundred thirty-nine 248151 Hundred fifty-one 249153 Hundred fifty-three 250155 Hundred fity-five 251159 Hundred fifty-nine 252191 Hundred ninety-one 253193 Hundred ninety-three 254195 Hundred ninety-five 255199 Hundred ninety-nine 256SELECT * FROM tp WHERE a BETWEEN 100 AND 1000; 257a b 258112 Hundred twelve 259114 Hundred fourteen 260116 Hundred sixteen 261118 Hundred eightteen 262122 Hundred twenty-two 263124 Hundred twenty-four 264126 Hundred twenty-six 265128 Hundred twenty-eight 266162 Hundred sixty-two 267164 Hundred sixty-four 268166 Hundred sixty-six 269168 Hundred sixty-eight 270182 Hundred eighty-two 271184 Hundred eighty-four 272186 Hundred eighty-six 273188 Hundred eighty-eight 274ALTER TABLE tsp EXCHANGE PARTITION sp00 WITH TABLE tsp_00; 275ALTER TABLE tsp EXCHANGE PARTITION sp01 WITH TABLE tsp_01; 276ALTER TABLE tsp EXCHANGE PARTITION sp02 WITH TABLE tsp_02; 277ALTER TABLE tsp EXCHANGE PARTITION sp03 WITH TABLE tsp_03; 278ALTER TABLE tsp EXCHANGE PARTITION sp04 WITH TABLE tsp_04; 279SELECT * FROM tsp_00; 280a b 281SELECT * FROM tsp_01; 282a b 2836 Six 284SELECT * FROM tsp_02; 285a b 2862 Two 287SELECT * FROM tsp_03; 288a b 2898 Eight 290SELECT * FROM tsp_04; 291a b 2924 Four 293SELECT * FROM tsp WHERE a BETWEEN 0 AND 10; 294a b 2951 One 2963 Three 2975 Five 2989 Nine 299ALTER TABLE tsp EXCHANGE PARTITION sp00 WITH TABLE tsp_00; 300ALTER TABLE tsp EXCHANGE PARTITION sp01 WITH TABLE tsp_01; 301ALTER TABLE tsp EXCHANGE PARTITION sp02 WITH TABLE tsp_02; 302ALTER TABLE tsp EXCHANGE PARTITION sp03 WITH TABLE tsp_03; 303ALTER TABLE tsp EXCHANGE PARTITION sp04 WITH TABLE tsp_04; 304SELECT * FROM tsp_00; 305a b 3065 Five 307SELECT * FROM tsp_01; 308a b 3091 One 310SELECT * FROM tsp_02; 311a b 312SELECT * FROM tsp_03; 313a b 3143 Three 315SELECT * FROM tsp_04; 316a b 3179 Nine 318SELECT * FROM tsp WHERE a BETWEEN 0 AND 10; 319a b 3202 Two 3214 Four 3226 Six 3238 Eight 324ALTER TABLE tsp EXCHANGE PARTITION sp01 WITH TABLE t_null; 325SELECT * FROM t_null; 326a b 3276 Six 328SELECT * FROM tsp WHERE a BETWEEN 0 AND 10; 329a b 3301 NULL 3312 Two 3324 Four 3338 Eight 334ALTER TABLE tsp EXCHANGE PARTITION sp01 WITH TABLE t_null; 335SELECT * FROM t_null; 336a b 3371 NULL 338SELECT * FROM tsp WHERE a BETWEEN 0 AND 10; 339a b 3402 Two 3414 Four 3426 Six 3438 Eight 344DROP TABLE IF EXISTS t_10; 345DROP TABLE IF EXISTS t_100; 346DROP TABLE IF EXISTS t_1000; 347DROP TABLE IF EXISTS tp; 348DROP TABLE IF EXISTS tsp; 349DROP TABLE IF EXISTS tsp_00; 350DROP TABLE IF EXISTS tsp_01; 351DROP TABLE IF EXISTS tsp_02; 352DROP TABLE IF EXISTS tsp_03; 353DROP TABLE IF EXISTS tsp_04; 354DROP TABLE IF EXISTS t_empty; 355DROP TABLE IF EXISTS t_null; 356