1DROP TABLE IF EXISTS t1; 2CREATE TABLE t1( a INT, b INT ); 3INSERT INTO t1 VALUES (1, 1), (2, 2), (3, 3), (4, 4); 4# 1. test regular tables 5# 1.1. test altering of columns that multiupdate doesn't use 6# 1.1.1. normal mode 7# 1.1.2. PS mode 8# 1.2. test altering of columns that multiupdate uses 9# 1.2.1. normal mode 10Warnings: 11Warning 1681 Integer display width is deprecated and will be removed in a future release. 12Warnings: 13Warning 1681 Integer display width is deprecated and will be removed in a future release. 14Warnings: 15Warning 1681 Integer display width is deprecated and will be removed in a future release. 16Warnings: 17Warning 1681 Integer display width is deprecated and will be removed in a future release. 18Warnings: 19Warning 1681 Integer display width is deprecated and will be removed in a future release. 20Warnings: 21Warning 1681 Integer display width is deprecated and will be removed in a future release. 22Warnings: 23Warning 1681 Integer display width is deprecated and will be removed in a future release. 24Warnings: 25Warning 1681 Integer display width is deprecated and will be removed in a future release. 26Warnings: 27Warning 1681 Integer display width is deprecated and will be removed in a future release. 28Warnings: 29Warning 1681 Integer display width is deprecated and will be removed in a future release. 30Warnings: 31Warning 1681 Integer display width is deprecated and will be removed in a future release. 32Warnings: 33Warning 1681 Integer display width is deprecated and will be removed in a future release. 34Warnings: 35Warning 1681 Integer display width is deprecated and will be removed in a future release. 36Warnings: 37Warning 1681 Integer display width is deprecated and will be removed in a future release. 38Warnings: 39Warning 1681 Integer display width is deprecated and will be removed in a future release. 40Warnings: 41Warning 1681 Integer display width is deprecated and will be removed in a future release. 42Warnings: 43Warning 1681 Integer display width is deprecated and will be removed in a future release. 44Warnings: 45Warning 1681 Integer display width is deprecated and will be removed in a future release. 46Warnings: 47Warning 1681 Integer display width is deprecated and will be removed in a future release. 48Warnings: 49Warning 1681 Integer display width is deprecated and will be removed in a future release. 50Warnings: 51Warning 1681 Integer display width is deprecated and will be removed in a future release. 52Warnings: 53Warning 1681 Integer display width is deprecated and will be removed in a future release. 54Warnings: 55Warning 1681 Integer display width is deprecated and will be removed in a future release. 56Warnings: 57Warning 1681 Integer display width is deprecated and will be removed in a future release. 58Warnings: 59Warning 1681 Integer display width is deprecated and will be removed in a future release. 60Warnings: 61Warning 1681 Integer display width is deprecated and will be removed in a future release. 62Warnings: 63Warning 1681 Integer display width is deprecated and will be removed in a future release. 64Warnings: 65Warning 1681 Integer display width is deprecated and will be removed in a future release. 66Warnings: 67Warning 1681 Integer display width is deprecated and will be removed in a future release. 68Warnings: 69Warning 1681 Integer display width is deprecated and will be removed in a future release. 70Warnings: 71Warning 1681 Integer display width is deprecated and will be removed in a future release. 72Warnings: 73Warning 1681 Integer display width is deprecated and will be removed in a future release. 74Warnings: 75Warning 1681 Integer display width is deprecated and will be removed in a future release. 76Warnings: 77Warning 1681 Integer display width is deprecated and will be removed in a future release. 78Warnings: 79Warning 1681 Integer display width is deprecated and will be removed in a future release. 80Warnings: 81Warning 1681 Integer display width is deprecated and will be removed in a future release. 82Warnings: 83Warning 1681 Integer display width is deprecated and will be removed in a future release. 84Warnings: 85Warning 1681 Integer display width is deprecated and will be removed in a future release. 86Warnings: 87Warning 1681 Integer display width is deprecated and will be removed in a future release. 88Warnings: 89Warning 1681 Integer display width is deprecated and will be removed in a future release. 90Warnings: 91Warning 1681 Integer display width is deprecated and will be removed in a future release. 92Warnings: 93Warning 1681 Integer display width is deprecated and will be removed in a future release. 94Warnings: 95Warning 1681 Integer display width is deprecated and will be removed in a future release. 96Warnings: 97Warning 1681 Integer display width is deprecated and will be removed in a future release. 98Warnings: 99Warning 1681 Integer display width is deprecated and will be removed in a future release. 100Warnings: 101Warning 1681 Integer display width is deprecated and will be removed in a future release. 102Warnings: 103Warning 1681 Integer display width is deprecated and will be removed in a future release. 104Warnings: 105Warning 1681 Integer display width is deprecated and will be removed in a future release. 106Warnings: 107Warning 1681 Integer display width is deprecated and will be removed in a future release. 108Warnings: 109Warning 1681 Integer display width is deprecated and will be removed in a future release. 110Warnings: 111Warning 1681 Integer display width is deprecated and will be removed in a future release. 112Warnings: 113Warning 1681 Integer display width is deprecated and will be removed in a future release. 114Warnings: 115Warning 1681 Integer display width is deprecated and will be removed in a future release. 116Warnings: 117Warning 1681 Integer display width is deprecated and will be removed in a future release. 118Warnings: 119Warning 1681 Integer display width is deprecated and will be removed in a future release. 120Warnings: 121Warning 1681 Integer display width is deprecated and will be removed in a future release. 122Warnings: 123Warning 1681 Integer display width is deprecated and will be removed in a future release. 124Warnings: 125Warning 1681 Integer display width is deprecated and will be removed in a future release. 126Warnings: 127Warning 1681 Integer display width is deprecated and will be removed in a future release. 128Warnings: 129Warning 1681 Integer display width is deprecated and will be removed in a future release. 130Warnings: 131Warning 1681 Integer display width is deprecated and will be removed in a future release. 132Warnings: 133Warning 1681 Integer display width is deprecated and will be removed in a future release. 134Warnings: 135Warning 1681 Integer display width is deprecated and will be removed in a future release. 136Warnings: 137Warning 1681 Integer display width is deprecated and will be removed in a future release. 138Warnings: 139Warning 1681 Integer display width is deprecated and will be removed in a future release. 140Warnings: 141Warning 1681 Integer display width is deprecated and will be removed in a future release. 142Warnings: 143Warning 1681 Integer display width is deprecated and will be removed in a future release. 144Warnings: 145Warning 1681 Integer display width is deprecated and will be removed in a future release. 146Warnings: 147Warning 1681 Integer display width is deprecated and will be removed in a future release. 148Warnings: 149Warning 1681 Integer display width is deprecated and will be removed in a future release. 150Warnings: 151Warning 1681 Integer display width is deprecated and will be removed in a future release. 152Warnings: 153Warning 1681 Integer display width is deprecated and will be removed in a future release. 154Warnings: 155Warning 1681 Integer display width is deprecated and will be removed in a future release. 156Warnings: 157Warning 1681 Integer display width is deprecated and will be removed in a future release. 158Warnings: 159Warning 1681 Integer display width is deprecated and will be removed in a future release. 160Warnings: 161Warning 1681 Integer display width is deprecated and will be removed in a future release. 162Warnings: 163Warning 1681 Integer display width is deprecated and will be removed in a future release. 164Warnings: 165Warning 1681 Integer display width is deprecated and will be removed in a future release. 166Warnings: 167Warning 1681 Integer display width is deprecated and will be removed in a future release. 168Warnings: 169Warning 1681 Integer display width is deprecated and will be removed in a future release. 170Warnings: 171Warning 1681 Integer display width is deprecated and will be removed in a future release. 172Warnings: 173Warning 1681 Integer display width is deprecated and will be removed in a future release. 174Warnings: 175Warning 1681 Integer display width is deprecated and will be removed in a future release. 176Warnings: 177Warning 1681 Integer display width is deprecated and will be removed in a future release. 178Warnings: 179Warning 1681 Integer display width is deprecated and will be removed in a future release. 180Warnings: 181Warning 1681 Integer display width is deprecated and will be removed in a future release. 182Warnings: 183Warning 1681 Integer display width is deprecated and will be removed in a future release. 184Warnings: 185Warning 1681 Integer display width is deprecated and will be removed in a future release. 186Warnings: 187Warning 1681 Integer display width is deprecated and will be removed in a future release. 188Warnings: 189Warning 1681 Integer display width is deprecated and will be removed in a future release. 190Warnings: 191Warning 1681 Integer display width is deprecated and will be removed in a future release. 192Warnings: 193Warning 1681 Integer display width is deprecated and will be removed in a future release. 194Warnings: 195Warning 1681 Integer display width is deprecated and will be removed in a future release. 196Warnings: 197Warning 1681 Integer display width is deprecated and will be removed in a future release. 198Warnings: 199Warning 1681 Integer display width is deprecated and will be removed in a future release. 200Warnings: 201Warning 1681 Integer display width is deprecated and will be removed in a future release. 202Warnings: 203Warning 1681 Integer display width is deprecated and will be removed in a future release. 204Warnings: 205Warning 1681 Integer display width is deprecated and will be removed in a future release. 206Warnings: 207Warning 1681 Integer display width is deprecated and will be removed in a future release. 208# 1.2.2. PS mode 209ALTER TABLE t1 ADD COLUMN a INT; 210# 2. test UNIONs 211# 2.1. test altering of columns that multiupdate doesn't use 212# 2.1.1. normal mode 213# 2.1.2. PS mode 214# 2.2. test altering of columns that multiupdate uses 215# 2.2.1. normal mode 216Warnings: 217Warning 1681 Integer display width is deprecated and will be removed in a future release. 218Warnings: 219Warning 1681 Integer display width is deprecated and will be removed in a future release. 220Warnings: 221Warning 1681 Integer display width is deprecated and will be removed in a future release. 222Warnings: 223Warning 1681 Integer display width is deprecated and will be removed in a future release. 224Warnings: 225Warning 1681 Integer display width is deprecated and will be removed in a future release. 226Warnings: 227Warning 1681 Integer display width is deprecated and will be removed in a future release. 228Warnings: 229Warning 1681 Integer display width is deprecated and will be removed in a future release. 230Warnings: 231Warning 1681 Integer display width is deprecated and will be removed in a future release. 232Warnings: 233Warning 1681 Integer display width is deprecated and will be removed in a future release. 234Warnings: 235Warning 1681 Integer display width is deprecated and will be removed in a future release. 236Warnings: 237Warning 1681 Integer display width is deprecated and will be removed in a future release. 238Warnings: 239Warning 1681 Integer display width is deprecated and will be removed in a future release. 240Warnings: 241Warning 1681 Integer display width is deprecated and will be removed in a future release. 242Warnings: 243Warning 1681 Integer display width is deprecated and will be removed in a future release. 244Warnings: 245Warning 1681 Integer display width is deprecated and will be removed in a future release. 246Warnings: 247Warning 1681 Integer display width is deprecated and will be removed in a future release. 248Warnings: 249Warning 1681 Integer display width is deprecated and will be removed in a future release. 250Warnings: 251Warning 1681 Integer display width is deprecated and will be removed in a future release. 252Warnings: 253Warning 1681 Integer display width is deprecated and will be removed in a future release. 254Warnings: 255Warning 1681 Integer display width is deprecated and will be removed in a future release. 256Warnings: 257Warning 1681 Integer display width is deprecated and will be removed in a future release. 258Warnings: 259Warning 1681 Integer display width is deprecated and will be removed in a future release. 260Warnings: 261Warning 1681 Integer display width is deprecated and will be removed in a future release. 262Warnings: 263Warning 1681 Integer display width is deprecated and will be removed in a future release. 264Warnings: 265Warning 1681 Integer display width is deprecated and will be removed in a future release. 266Warnings: 267Warning 1681 Integer display width is deprecated and will be removed in a future release. 268Warnings: 269Warning 1681 Integer display width is deprecated and will be removed in a future release. 270Warnings: 271Warning 1681 Integer display width is deprecated and will be removed in a future release. 272Warnings: 273Warning 1681 Integer display width is deprecated and will be removed in a future release. 274Warnings: 275Warning 1681 Integer display width is deprecated and will be removed in a future release. 276Warnings: 277Warning 1681 Integer display width is deprecated and will be removed in a future release. 278Warnings: 279Warning 1681 Integer display width is deprecated and will be removed in a future release. 280Warnings: 281Warning 1681 Integer display width is deprecated and will be removed in a future release. 282Warnings: 283Warning 1681 Integer display width is deprecated and will be removed in a future release. 284Warnings: 285Warning 1681 Integer display width is deprecated and will be removed in a future release. 286Warnings: 287Warning 1681 Integer display width is deprecated and will be removed in a future release. 288Warnings: 289Warning 1681 Integer display width is deprecated and will be removed in a future release. 290Warnings: 291Warning 1681 Integer display width is deprecated and will be removed in a future release. 292Warnings: 293Warning 1681 Integer display width is deprecated and will be removed in a future release. 294Warnings: 295Warning 1681 Integer display width is deprecated and will be removed in a future release. 296Warnings: 297Warning 1681 Integer display width is deprecated and will be removed in a future release. 298Warnings: 299Warning 1681 Integer display width is deprecated and will be removed in a future release. 300Warnings: 301Warning 1681 Integer display width is deprecated and will be removed in a future release. 302Warnings: 303Warning 1681 Integer display width is deprecated and will be removed in a future release. 304Warnings: 305Warning 1681 Integer display width is deprecated and will be removed in a future release. 306Warnings: 307Warning 1681 Integer display width is deprecated and will be removed in a future release. 308Warnings: 309Warning 1681 Integer display width is deprecated and will be removed in a future release. 310Warnings: 311Warning 1681 Integer display width is deprecated and will be removed in a future release. 312Warnings: 313Warning 1681 Integer display width is deprecated and will be removed in a future release. 314Warnings: 315Warning 1681 Integer display width is deprecated and will be removed in a future release. 316Warnings: 317Warning 1681 Integer display width is deprecated and will be removed in a future release. 318Warnings: 319Warning 1681 Integer display width is deprecated and will be removed in a future release. 320Warnings: 321Warning 1681 Integer display width is deprecated and will be removed in a future release. 322Warnings: 323Warning 1681 Integer display width is deprecated and will be removed in a future release. 324Warnings: 325Warning 1681 Integer display width is deprecated and will be removed in a future release. 326Warnings: 327Warning 1681 Integer display width is deprecated and will be removed in a future release. 328Warnings: 329Warning 1681 Integer display width is deprecated and will be removed in a future release. 330Warnings: 331Warning 1681 Integer display width is deprecated and will be removed in a future release. 332Warnings: 333Warning 1681 Integer display width is deprecated and will be removed in a future release. 334Warnings: 335Warning 1681 Integer display width is deprecated and will be removed in a future release. 336Warnings: 337Warning 1681 Integer display width is deprecated and will be removed in a future release. 338Warnings: 339Warning 1681 Integer display width is deprecated and will be removed in a future release. 340Warnings: 341Warning 1681 Integer display width is deprecated and will be removed in a future release. 342Warnings: 343Warning 1681 Integer display width is deprecated and will be removed in a future release. 344Warnings: 345Warning 1681 Integer display width is deprecated and will be removed in a future release. 346Warnings: 347Warning 1681 Integer display width is deprecated and will be removed in a future release. 348Warnings: 349Warning 1681 Integer display width is deprecated and will be removed in a future release. 350Warnings: 351Warning 1681 Integer display width is deprecated and will be removed in a future release. 352Warnings: 353Warning 1681 Integer display width is deprecated and will be removed in a future release. 354Warnings: 355Warning 1681 Integer display width is deprecated and will be removed in a future release. 356Warnings: 357Warning 1681 Integer display width is deprecated and will be removed in a future release. 358Warnings: 359Warning 1681 Integer display width is deprecated and will be removed in a future release. 360Warnings: 361Warning 1681 Integer display width is deprecated and will be removed in a future release. 362Warnings: 363Warning 1681 Integer display width is deprecated and will be removed in a future release. 364Warnings: 365Warning 1681 Integer display width is deprecated and will be removed in a future release. 366Warnings: 367Warning 1681 Integer display width is deprecated and will be removed in a future release. 368Warnings: 369Warning 1681 Integer display width is deprecated and will be removed in a future release. 370Warnings: 371Warning 1681 Integer display width is deprecated and will be removed in a future release. 372Warnings: 373Warning 1681 Integer display width is deprecated and will be removed in a future release. 374Warnings: 375Warning 1681 Integer display width is deprecated and will be removed in a future release. 376Warnings: 377Warning 1681 Integer display width is deprecated and will be removed in a future release. 378Warnings: 379Warning 1681 Integer display width is deprecated and will be removed in a future release. 380Warnings: 381Warning 1681 Integer display width is deprecated and will be removed in a future release. 382Warnings: 383Warning 1681 Integer display width is deprecated and will be removed in a future release. 384Warnings: 385Warning 1681 Integer display width is deprecated and will be removed in a future release. 386Warnings: 387Warning 1681 Integer display width is deprecated and will be removed in a future release. 388Warnings: 389Warning 1681 Integer display width is deprecated and will be removed in a future release. 390Warnings: 391Warning 1681 Integer display width is deprecated and will be removed in a future release. 392Warnings: 393Warning 1681 Integer display width is deprecated and will be removed in a future release. 394Warnings: 395Warning 1681 Integer display width is deprecated and will be removed in a future release. 396Warnings: 397Warning 1681 Integer display width is deprecated and will be removed in a future release. 398Warnings: 399Warning 1681 Integer display width is deprecated and will be removed in a future release. 400Warnings: 401Warning 1681 Integer display width is deprecated and will be removed in a future release. 402Warnings: 403Warning 1681 Integer display width is deprecated and will be removed in a future release. 404Warnings: 405Warning 1681 Integer display width is deprecated and will be removed in a future release. 406Warnings: 407Warning 1681 Integer display width is deprecated and will be removed in a future release. 408Warnings: 409Warning 1681 Integer display width is deprecated and will be removed in a future release. 410Warnings: 411Warning 1681 Integer display width is deprecated and will be removed in a future release. 412Warnings: 413Warning 1681 Integer display width is deprecated and will be removed in a future release. 414# 2.2.2. PS mode 415DROP TABLE t1; 416