1--disable_warnings 2DROP DATABASE IF EXISTS d1; 3DROP DATABASE IF EXISTS d2; 4DROP DATABASE IF EXISTS d3; 5--enable_warnings 6CREATE DATABASE d1; 7CREATE DATABASE d2; 8CREATE DATABASE d3; 9CREATE TABLE d1.t1 (c1 TINYINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2)); 10CREATE TABLE d2.t2 (c1 TINYINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2)); 11CREATE TABLE d3.t3 (c1 TINYINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2)); 12INSERT INTO d1.t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5); 13INSERT INTO d2.t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6); 14INSERT INTO d3.t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15); 15DELETE FROM d1.t1, d2.t2 USING d1.t1, d2.t2, d3.t3 WHERE d1.t1.c1=d2.t2.c2 AND d2.t2.c1=d3.t3.c2; 16SELECT * FROM d1.t1 ORDER BY c1; 17SELECT * FROM d2.t2 ORDER BY c1; 18SELECT * FROM d3.t3 ORDER BY c1; 19DELETE FROM d1.t1, d2.t2, d3.t3 USING d1.t1, d2.t2, d3.t3 WHERE d1.t1.c1=d2.t2.c2 AND d2.t2.c1=d3.t3.c2; 20SELECT * FROM d1.t1 ORDER BY c1; 21SELECT * FROM d2.t2 ORDER BY c1; 22SELECT * FROM d3.t3 ORDER BY c1; 23DROP DATABASE d1; 24DROP DATABASE d2; 25DROP DATABASE d3; 26CREATE DATABASE d1; 27CREATE DATABASE d2; 28CREATE DATABASE d3; 29CREATE TABLE d1.t1 (c1 SMALLINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2)); 30CREATE TABLE d2.t2 (c1 SMALLINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2)); 31CREATE TABLE d3.t3 (c1 SMALLINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2)); 32INSERT INTO d1.t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5); 33INSERT INTO d2.t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6); 34INSERT INTO d3.t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15); 35DELETE FROM d1.t1, d2.t2 USING d1.t1, d2.t2, d3.t3 WHERE d1.t1.c1=d2.t2.c2 AND d2.t2.c1=d3.t3.c2; 36SELECT * FROM d1.t1 ORDER BY c1; 37SELECT * FROM d2.t2 ORDER BY c1; 38SELECT * FROM d3.t3 ORDER BY c1; 39DELETE FROM d1.t1, d2.t2, d3.t3 USING d1.t1, d2.t2, d3.t3 WHERE d1.t1.c1=d2.t2.c2 AND d2.t2.c1=d3.t3.c2; 40SELECT * FROM d1.t1 ORDER BY c1; 41SELECT * FROM d2.t2 ORDER BY c1; 42SELECT * FROM d3.t3 ORDER BY c1; 43DROP DATABASE d1; 44DROP DATABASE d2; 45DROP DATABASE d3; 46CREATE DATABASE d1; 47CREATE DATABASE d2; 48CREATE DATABASE d3; 49CREATE TABLE d1.t1 (c1 MEDIUMINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2)); 50CREATE TABLE d2.t2 (c1 MEDIUMINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2)); 51CREATE TABLE d3.t3 (c1 MEDIUMINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2)); 52INSERT INTO d1.t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5); 53INSERT INTO d2.t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6); 54INSERT INTO d3.t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15); 55DELETE FROM d1.t1, d2.t2 USING d1.t1, d2.t2, d3.t3 WHERE d1.t1.c1=d2.t2.c2 AND d2.t2.c1=d3.t3.c2; 56SELECT * FROM d1.t1 ORDER BY c1; 57SELECT * FROM d2.t2 ORDER BY c1; 58SELECT * FROM d3.t3 ORDER BY c1; 59DELETE FROM d1.t1, d2.t2, d3.t3 USING d1.t1, d2.t2, d3.t3 WHERE d1.t1.c1=d2.t2.c2 AND d2.t2.c1=d3.t3.c2; 60SELECT * FROM d1.t1 ORDER BY c1; 61SELECT * FROM d2.t2 ORDER BY c1; 62SELECT * FROM d3.t3 ORDER BY c1; 63DROP DATABASE d1; 64DROP DATABASE d2; 65DROP DATABASE d3; 66CREATE DATABASE d1; 67CREATE DATABASE d2; 68CREATE DATABASE d3; 69CREATE TABLE d1.t1 (c1 INT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2)); 70CREATE TABLE d2.t2 (c1 INT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2)); 71CREATE TABLE d3.t3 (c1 INT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2)); 72INSERT INTO d1.t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5); 73INSERT INTO d2.t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6); 74INSERT INTO d3.t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15); 75DELETE FROM d1.t1, d2.t2 USING d1.t1, d2.t2, d3.t3 WHERE d1.t1.c1=d2.t2.c2 AND d2.t2.c1=d3.t3.c2; 76SELECT * FROM d1.t1 ORDER BY c1; 77SELECT * FROM d2.t2 ORDER BY c1; 78SELECT * FROM d3.t3 ORDER BY c1; 79DELETE FROM d1.t1, d2.t2, d3.t3 USING d1.t1, d2.t2, d3.t3 WHERE d1.t1.c1=d2.t2.c2 AND d2.t2.c1=d3.t3.c2; 80SELECT * FROM d1.t1 ORDER BY c1; 81SELECT * FROM d2.t2 ORDER BY c1; 82SELECT * FROM d3.t3 ORDER BY c1; 83DROP DATABASE d1; 84DROP DATABASE d2; 85DROP DATABASE d3; 86CREATE DATABASE d1; 87CREATE DATABASE d2; 88CREATE DATABASE d3; 89CREATE TABLE d1.t1 (c1 INTEGER NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2)); 90CREATE TABLE d2.t2 (c1 INTEGER NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2)); 91CREATE TABLE d3.t3 (c1 INTEGER NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2)); 92INSERT INTO d1.t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5); 93INSERT INTO d2.t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6); 94INSERT INTO d3.t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15); 95DELETE FROM d1.t1, d2.t2 USING d1.t1, d2.t2, d3.t3 WHERE d1.t1.c1=d2.t2.c2 AND d2.t2.c1=d3.t3.c2; 96SELECT * FROM d1.t1 ORDER BY c1; 97SELECT * FROM d2.t2 ORDER BY c1; 98SELECT * FROM d3.t3 ORDER BY c1; 99DELETE FROM d1.t1, d2.t2, d3.t3 USING d1.t1, d2.t2, d3.t3 WHERE d1.t1.c1=d2.t2.c2 AND d2.t2.c1=d3.t3.c2; 100SELECT * FROM d1.t1 ORDER BY c1; 101SELECT * FROM d2.t2 ORDER BY c1; 102SELECT * FROM d3.t3 ORDER BY c1; 103DROP DATABASE d1; 104DROP DATABASE d2; 105DROP DATABASE d3; 106CREATE DATABASE d1; 107CREATE DATABASE d2; 108CREATE DATABASE d3; 109CREATE TABLE d1.t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2)); 110CREATE TABLE d2.t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2)); 111CREATE TABLE d3.t3 (c1 BIGINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2)); 112INSERT INTO d1.t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5); 113INSERT INTO d2.t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6); 114INSERT INTO d3.t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15); 115DELETE FROM d1.t1, d2.t2 USING d1.t1, d2.t2, d3.t3 WHERE d1.t1.c1=d2.t2.c2 AND d2.t2.c1=d3.t3.c2; 116SELECT * FROM d1.t1 ORDER BY c1; 117SELECT * FROM d2.t2 ORDER BY c1; 118SELECT * FROM d3.t3 ORDER BY c1; 119DELETE FROM d1.t1, d2.t2, d3.t3 USING d1.t1, d2.t2, d3.t3 WHERE d1.t1.c1=d2.t2.c2 AND d2.t2.c1=d3.t3.c2; 120SELECT * FROM d1.t1 ORDER BY c1; 121SELECT * FROM d2.t2 ORDER BY c1; 122SELECT * FROM d3.t3 ORDER BY c1; 123DROP DATABASE d1; 124DROP DATABASE d2; 125DROP DATABASE d3; 126CREATE DATABASE d1; 127CREATE DATABASE d2; 128CREATE DATABASE d3; 129CREATE TABLE d1.t1 (c1 TINYINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2)); 130CREATE TABLE d2.t2 (c1 TINYINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2)); 131CREATE TABLE d3.t3 (c1 TINYINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2)); 132INSERT INTO d1.t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5); 133INSERT INTO d2.t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6); 134INSERT INTO d3.t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15); 135DELETE QUICK FROM d1.t1, d2.t2 USING d1.t1, d2.t2, d3.t3 WHERE d1.t1.c1=d2.t2.c2 AND d2.t2.c1=d3.t3.c2; 136SELECT * FROM d1.t1 ORDER BY c1; 137SELECT * FROM d2.t2 ORDER BY c1; 138SELECT * FROM d3.t3 ORDER BY c1; 139DELETE QUICK FROM d1.t1, d2.t2, d3.t3 USING d1.t1, d2.t2, d3.t3 WHERE d1.t1.c1=d2.t2.c2 AND d2.t2.c1=d3.t3.c2; 140SELECT * FROM d1.t1 ORDER BY c1; 141SELECT * FROM d2.t2 ORDER BY c1; 142SELECT * FROM d3.t3 ORDER BY c1; 143DROP DATABASE d1; 144DROP DATABASE d2; 145DROP DATABASE d3; 146CREATE DATABASE d1; 147CREATE DATABASE d2; 148CREATE DATABASE d3; 149CREATE TABLE d1.t1 (c1 SMALLINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2)); 150CREATE TABLE d2.t2 (c1 SMALLINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2)); 151CREATE TABLE d3.t3 (c1 SMALLINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2)); 152INSERT INTO d1.t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5); 153INSERT INTO d2.t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6); 154INSERT INTO d3.t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15); 155DELETE QUICK FROM d1.t1, d2.t2 USING d1.t1, d2.t2, d3.t3 WHERE d1.t1.c1=d2.t2.c2 AND d2.t2.c1=d3.t3.c2; 156SELECT * FROM d1.t1 ORDER BY c1; 157SELECT * FROM d2.t2 ORDER BY c1; 158SELECT * FROM d3.t3 ORDER BY c1; 159DELETE QUICK FROM d1.t1, d2.t2, d3.t3 USING d1.t1, d2.t2, d3.t3 WHERE d1.t1.c1=d2.t2.c2 AND d2.t2.c1=d3.t3.c2; 160SELECT * FROM d1.t1 ORDER BY c1; 161SELECT * FROM d2.t2 ORDER BY c1; 162SELECT * FROM d3.t3 ORDER BY c1; 163DROP DATABASE d1; 164DROP DATABASE d2; 165DROP DATABASE d3; 166CREATE DATABASE d1; 167CREATE DATABASE d2; 168CREATE DATABASE d3; 169CREATE TABLE d1.t1 (c1 MEDIUMINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2)); 170CREATE TABLE d2.t2 (c1 MEDIUMINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2)); 171CREATE TABLE d3.t3 (c1 MEDIUMINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2)); 172INSERT INTO d1.t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5); 173INSERT INTO d2.t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6); 174INSERT INTO d3.t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15); 175DELETE QUICK FROM d1.t1, d2.t2 USING d1.t1, d2.t2, d3.t3 WHERE d1.t1.c1=d2.t2.c2 AND d2.t2.c1=d3.t3.c2; 176SELECT * FROM d1.t1 ORDER BY c1; 177SELECT * FROM d2.t2 ORDER BY c1; 178SELECT * FROM d3.t3 ORDER BY c1; 179DELETE QUICK FROM d1.t1, d2.t2, d3.t3 USING d1.t1, d2.t2, d3.t3 WHERE d1.t1.c1=d2.t2.c2 AND d2.t2.c1=d3.t3.c2; 180SELECT * FROM d1.t1 ORDER BY c1; 181SELECT * FROM d2.t2 ORDER BY c1; 182SELECT * FROM d3.t3 ORDER BY c1; 183DROP DATABASE d1; 184DROP DATABASE d2; 185DROP DATABASE d3; 186CREATE DATABASE d1; 187CREATE DATABASE d2; 188CREATE DATABASE d3; 189CREATE TABLE d1.t1 (c1 INT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2)); 190CREATE TABLE d2.t2 (c1 INT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2)); 191CREATE TABLE d3.t3 (c1 INT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2)); 192INSERT INTO d1.t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5); 193INSERT INTO d2.t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6); 194INSERT INTO d3.t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15); 195DELETE QUICK FROM d1.t1, d2.t2 USING d1.t1, d2.t2, d3.t3 WHERE d1.t1.c1=d2.t2.c2 AND d2.t2.c1=d3.t3.c2; 196SELECT * FROM d1.t1 ORDER BY c1; 197SELECT * FROM d2.t2 ORDER BY c1; 198SELECT * FROM d3.t3 ORDER BY c1; 199DELETE QUICK FROM d1.t1, d2.t2, d3.t3 USING d1.t1, d2.t2, d3.t3 WHERE d1.t1.c1=d2.t2.c2 AND d2.t2.c1=d3.t3.c2; 200SELECT * FROM d1.t1 ORDER BY c1; 201SELECT * FROM d2.t2 ORDER BY c1; 202SELECT * FROM d3.t3 ORDER BY c1; 203DROP DATABASE d1; 204DROP DATABASE d2; 205DROP DATABASE d3; 206CREATE DATABASE d1; 207CREATE DATABASE d2; 208CREATE DATABASE d3; 209CREATE TABLE d1.t1 (c1 INTEGER NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2)); 210CREATE TABLE d2.t2 (c1 INTEGER NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2)); 211CREATE TABLE d3.t3 (c1 INTEGER NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2)); 212INSERT INTO d1.t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5); 213INSERT INTO d2.t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6); 214INSERT INTO d3.t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15); 215DELETE QUICK FROM d1.t1, d2.t2 USING d1.t1, d2.t2, d3.t3 WHERE d1.t1.c1=d2.t2.c2 AND d2.t2.c1=d3.t3.c2; 216SELECT * FROM d1.t1 ORDER BY c1; 217SELECT * FROM d2.t2 ORDER BY c1; 218SELECT * FROM d3.t3 ORDER BY c1; 219DELETE QUICK FROM d1.t1, d2.t2, d3.t3 USING d1.t1, d2.t2, d3.t3 WHERE d1.t1.c1=d2.t2.c2 AND d2.t2.c1=d3.t3.c2; 220SELECT * FROM d1.t1 ORDER BY c1; 221SELECT * FROM d2.t2 ORDER BY c1; 222SELECT * FROM d3.t3 ORDER BY c1; 223DROP DATABASE d1; 224DROP DATABASE d2; 225DROP DATABASE d3; 226CREATE DATABASE d1; 227CREATE DATABASE d2; 228CREATE DATABASE d3; 229CREATE TABLE d1.t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2)); 230CREATE TABLE d2.t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2)); 231CREATE TABLE d3.t3 (c1 BIGINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2)); 232INSERT INTO d1.t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5); 233INSERT INTO d2.t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6); 234INSERT INTO d3.t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15); 235DELETE QUICK FROM d1.t1, d2.t2 USING d1.t1, d2.t2, d3.t3 WHERE d1.t1.c1=d2.t2.c2 AND d2.t2.c1=d3.t3.c2; 236SELECT * FROM d1.t1 ORDER BY c1; 237SELECT * FROM d2.t2 ORDER BY c1; 238SELECT * FROM d3.t3 ORDER BY c1; 239DELETE QUICK FROM d1.t1, d2.t2, d3.t3 USING d1.t1, d2.t2, d3.t3 WHERE d1.t1.c1=d2.t2.c2 AND d2.t2.c1=d3.t3.c2; 240SELECT * FROM d1.t1 ORDER BY c1; 241SELECT * FROM d2.t2 ORDER BY c1; 242SELECT * FROM d3.t3 ORDER BY c1; 243DROP DATABASE d1; 244DROP DATABASE d2; 245DROP DATABASE d3; 246CREATE DATABASE d1; 247CREATE DATABASE d2; 248CREATE DATABASE d3; 249CREATE TABLE d1.t1 (c1 TINYINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2)); 250CREATE TABLE d2.t2 (c1 TINYINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2)); 251CREATE TABLE d3.t3 (c1 TINYINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2)); 252INSERT INTO d1.t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5); 253INSERT INTO d2.t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6); 254INSERT INTO d3.t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15); 255DELETE IGNORE FROM d1.t1, d2.t2 USING d1.t1, d2.t2, d3.t3 WHERE d1.t1.c1=d2.t2.c2 AND d2.t2.c1=d3.t3.c2; 256SELECT * FROM d1.t1 ORDER BY c1; 257SELECT * FROM d2.t2 ORDER BY c1; 258SELECT * FROM d3.t3 ORDER BY c1; 259DELETE IGNORE FROM d1.t1, d2.t2, d3.t3 USING d1.t1, d2.t2, d3.t3 WHERE d1.t1.c1=d2.t2.c2 AND d2.t2.c1=d3.t3.c2; 260SELECT * FROM d1.t1 ORDER BY c1; 261SELECT * FROM d2.t2 ORDER BY c1; 262SELECT * FROM d3.t3 ORDER BY c1; 263DROP DATABASE d1; 264DROP DATABASE d2; 265DROP DATABASE d3; 266CREATE DATABASE d1; 267CREATE DATABASE d2; 268CREATE DATABASE d3; 269CREATE TABLE d1.t1 (c1 SMALLINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2)); 270CREATE TABLE d2.t2 (c1 SMALLINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2)); 271CREATE TABLE d3.t3 (c1 SMALLINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2)); 272INSERT INTO d1.t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5); 273INSERT INTO d2.t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6); 274INSERT INTO d3.t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15); 275DELETE IGNORE FROM d1.t1, d2.t2 USING d1.t1, d2.t2, d3.t3 WHERE d1.t1.c1=d2.t2.c2 AND d2.t2.c1=d3.t3.c2; 276SELECT * FROM d1.t1 ORDER BY c1; 277SELECT * FROM d2.t2 ORDER BY c1; 278SELECT * FROM d3.t3 ORDER BY c1; 279DELETE IGNORE FROM d1.t1, d2.t2, d3.t3 USING d1.t1, d2.t2, d3.t3 WHERE d1.t1.c1=d2.t2.c2 AND d2.t2.c1=d3.t3.c2; 280SELECT * FROM d1.t1 ORDER BY c1; 281SELECT * FROM d2.t2 ORDER BY c1; 282SELECT * FROM d3.t3 ORDER BY c1; 283DROP DATABASE d1; 284DROP DATABASE d2; 285DROP DATABASE d3; 286CREATE DATABASE d1; 287CREATE DATABASE d2; 288CREATE DATABASE d3; 289CREATE TABLE d1.t1 (c1 MEDIUMINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2)); 290CREATE TABLE d2.t2 (c1 MEDIUMINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2)); 291CREATE TABLE d3.t3 (c1 MEDIUMINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2)); 292INSERT INTO d1.t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5); 293INSERT INTO d2.t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6); 294INSERT INTO d3.t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15); 295DELETE IGNORE FROM d1.t1, d2.t2 USING d1.t1, d2.t2, d3.t3 WHERE d1.t1.c1=d2.t2.c2 AND d2.t2.c1=d3.t3.c2; 296SELECT * FROM d1.t1 ORDER BY c1; 297SELECT * FROM d2.t2 ORDER BY c1; 298SELECT * FROM d3.t3 ORDER BY c1; 299DELETE IGNORE FROM d1.t1, d2.t2, d3.t3 USING d1.t1, d2.t2, d3.t3 WHERE d1.t1.c1=d2.t2.c2 AND d2.t2.c1=d3.t3.c2; 300SELECT * FROM d1.t1 ORDER BY c1; 301SELECT * FROM d2.t2 ORDER BY c1; 302SELECT * FROM d3.t3 ORDER BY c1; 303DROP DATABASE d1; 304DROP DATABASE d2; 305DROP DATABASE d3; 306CREATE DATABASE d1; 307CREATE DATABASE d2; 308CREATE DATABASE d3; 309CREATE TABLE d1.t1 (c1 INT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2)); 310CREATE TABLE d2.t2 (c1 INT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2)); 311CREATE TABLE d3.t3 (c1 INT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2)); 312INSERT INTO d1.t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5); 313INSERT INTO d2.t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6); 314INSERT INTO d3.t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15); 315DELETE IGNORE FROM d1.t1, d2.t2 USING d1.t1, d2.t2, d3.t3 WHERE d1.t1.c1=d2.t2.c2 AND d2.t2.c1=d3.t3.c2; 316SELECT * FROM d1.t1 ORDER BY c1; 317SELECT * FROM d2.t2 ORDER BY c1; 318SELECT * FROM d3.t3 ORDER BY c1; 319DELETE IGNORE FROM d1.t1, d2.t2, d3.t3 USING d1.t1, d2.t2, d3.t3 WHERE d1.t1.c1=d2.t2.c2 AND d2.t2.c1=d3.t3.c2; 320SELECT * FROM d1.t1 ORDER BY c1; 321SELECT * FROM d2.t2 ORDER BY c1; 322SELECT * FROM d3.t3 ORDER BY c1; 323DROP DATABASE d1; 324DROP DATABASE d2; 325DROP DATABASE d3; 326CREATE DATABASE d1; 327CREATE DATABASE d2; 328CREATE DATABASE d3; 329CREATE TABLE d1.t1 (c1 INTEGER NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2)); 330CREATE TABLE d2.t2 (c1 INTEGER NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2)); 331CREATE TABLE d3.t3 (c1 INTEGER NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2)); 332INSERT INTO d1.t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5); 333INSERT INTO d2.t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6); 334INSERT INTO d3.t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15); 335DELETE IGNORE FROM d1.t1, d2.t2 USING d1.t1, d2.t2, d3.t3 WHERE d1.t1.c1=d2.t2.c2 AND d2.t2.c1=d3.t3.c2; 336SELECT * FROM d1.t1 ORDER BY c1; 337SELECT * FROM d2.t2 ORDER BY c1; 338SELECT * FROM d3.t3 ORDER BY c1; 339DELETE IGNORE FROM d1.t1, d2.t2, d3.t3 USING d1.t1, d2.t2, d3.t3 WHERE d1.t1.c1=d2.t2.c2 AND d2.t2.c1=d3.t3.c2; 340SELECT * FROM d1.t1 ORDER BY c1; 341SELECT * FROM d2.t2 ORDER BY c1; 342SELECT * FROM d3.t3 ORDER BY c1; 343DROP DATABASE d1; 344DROP DATABASE d2; 345DROP DATABASE d3; 346CREATE DATABASE d1; 347CREATE DATABASE d2; 348CREATE DATABASE d3; 349CREATE TABLE d1.t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2)); 350CREATE TABLE d2.t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2)); 351CREATE TABLE d3.t3 (c1 BIGINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2)); 352INSERT INTO d1.t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5); 353INSERT INTO d2.t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6); 354INSERT INTO d3.t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15); 355DELETE IGNORE FROM d1.t1, d2.t2 USING d1.t1, d2.t2, d3.t3 WHERE d1.t1.c1=d2.t2.c2 AND d2.t2.c1=d3.t3.c2; 356SELECT * FROM d1.t1 ORDER BY c1; 357SELECT * FROM d2.t2 ORDER BY c1; 358SELECT * FROM d3.t3 ORDER BY c1; 359DELETE IGNORE FROM d1.t1, d2.t2, d3.t3 USING d1.t1, d2.t2, d3.t3 WHERE d1.t1.c1=d2.t2.c2 AND d2.t2.c1=d3.t3.c2; 360SELECT * FROM d1.t1 ORDER BY c1; 361SELECT * FROM d2.t2 ORDER BY c1; 362SELECT * FROM d3.t3 ORDER BY c1; 363DROP DATABASE d1; 364DROP DATABASE d2; 365DROP DATABASE d3; 366CREATE DATABASE d1; 367CREATE DATABASE d2; 368CREATE DATABASE d3; 369CREATE TABLE d1.t1 (c1 TINYINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2)); 370CREATE TABLE d2.t2 (c1 TINYINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2)); 371CREATE TABLE d3.t3 (c1 TINYINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2)); 372INSERT INTO d1.t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5); 373INSERT INTO d2.t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6); 374INSERT INTO d3.t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15); 375DELETE QUICK IGNORE FROM d1.t1, d2.t2 USING d1.t1, d2.t2, d3.t3 WHERE d1.t1.c1=d2.t2.c2 AND d2.t2.c1=d3.t3.c2; 376SELECT * FROM d1.t1 ORDER BY c1; 377SELECT * FROM d2.t2 ORDER BY c1; 378SELECT * FROM d3.t3 ORDER BY c1; 379DELETE QUICK IGNORE FROM d1.t1, d2.t2, d3.t3 USING d1.t1, d2.t2, d3.t3 WHERE d1.t1.c1=d2.t2.c2 AND d2.t2.c1=d3.t3.c2; 380SELECT * FROM d1.t1 ORDER BY c1; 381SELECT * FROM d2.t2 ORDER BY c1; 382SELECT * FROM d3.t3 ORDER BY c1; 383DROP DATABASE d1; 384DROP DATABASE d2; 385DROP DATABASE d3; 386CREATE DATABASE d1; 387CREATE DATABASE d2; 388CREATE DATABASE d3; 389CREATE TABLE d1.t1 (c1 SMALLINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2)); 390CREATE TABLE d2.t2 (c1 SMALLINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2)); 391CREATE TABLE d3.t3 (c1 SMALLINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2)); 392INSERT INTO d1.t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5); 393INSERT INTO d2.t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6); 394INSERT INTO d3.t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15); 395DELETE QUICK IGNORE FROM d1.t1, d2.t2 USING d1.t1, d2.t2, d3.t3 WHERE d1.t1.c1=d2.t2.c2 AND d2.t2.c1=d3.t3.c2; 396SELECT * FROM d1.t1 ORDER BY c1; 397SELECT * FROM d2.t2 ORDER BY c1; 398SELECT * FROM d3.t3 ORDER BY c1; 399DELETE QUICK IGNORE FROM d1.t1, d2.t2, d3.t3 USING d1.t1, d2.t2, d3.t3 WHERE d1.t1.c1=d2.t2.c2 AND d2.t2.c1=d3.t3.c2; 400SELECT * FROM d1.t1 ORDER BY c1; 401SELECT * FROM d2.t2 ORDER BY c1; 402SELECT * FROM d3.t3 ORDER BY c1; 403DROP DATABASE d1; 404DROP DATABASE d2; 405DROP DATABASE d3; 406CREATE DATABASE d1; 407CREATE DATABASE d2; 408CREATE DATABASE d3; 409CREATE TABLE d1.t1 (c1 MEDIUMINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2)); 410CREATE TABLE d2.t2 (c1 MEDIUMINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2)); 411CREATE TABLE d3.t3 (c1 MEDIUMINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2)); 412INSERT INTO d1.t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5); 413INSERT INTO d2.t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6); 414INSERT INTO d3.t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15); 415DELETE QUICK IGNORE FROM d1.t1, d2.t2 USING d1.t1, d2.t2, d3.t3 WHERE d1.t1.c1=d2.t2.c2 AND d2.t2.c1=d3.t3.c2; 416SELECT * FROM d1.t1 ORDER BY c1; 417SELECT * FROM d2.t2 ORDER BY c1; 418SELECT * FROM d3.t3 ORDER BY c1; 419DELETE QUICK IGNORE FROM d1.t1, d2.t2, d3.t3 USING d1.t1, d2.t2, d3.t3 WHERE d1.t1.c1=d2.t2.c2 AND d2.t2.c1=d3.t3.c2; 420SELECT * FROM d1.t1 ORDER BY c1; 421SELECT * FROM d2.t2 ORDER BY c1; 422SELECT * FROM d3.t3 ORDER BY c1; 423DROP DATABASE d1; 424DROP DATABASE d2; 425DROP DATABASE d3; 426CREATE DATABASE d1; 427CREATE DATABASE d2; 428CREATE DATABASE d3; 429CREATE TABLE d1.t1 (c1 INT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2)); 430CREATE TABLE d2.t2 (c1 INT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2)); 431CREATE TABLE d3.t3 (c1 INT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2)); 432INSERT INTO d1.t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5); 433INSERT INTO d2.t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6); 434INSERT INTO d3.t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15); 435DELETE QUICK IGNORE FROM d1.t1, d2.t2 USING d1.t1, d2.t2, d3.t3 WHERE d1.t1.c1=d2.t2.c2 AND d2.t2.c1=d3.t3.c2; 436SELECT * FROM d1.t1 ORDER BY c1; 437SELECT * FROM d2.t2 ORDER BY c1; 438SELECT * FROM d3.t3 ORDER BY c1; 439DELETE QUICK IGNORE FROM d1.t1, d2.t2, d3.t3 USING d1.t1, d2.t2, d3.t3 WHERE d1.t1.c1=d2.t2.c2 AND d2.t2.c1=d3.t3.c2; 440SELECT * FROM d1.t1 ORDER BY c1; 441SELECT * FROM d2.t2 ORDER BY c1; 442SELECT * FROM d3.t3 ORDER BY c1; 443DROP DATABASE d1; 444DROP DATABASE d2; 445DROP DATABASE d3; 446CREATE DATABASE d1; 447CREATE DATABASE d2; 448CREATE DATABASE d3; 449CREATE TABLE d1.t1 (c1 INTEGER NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2)); 450CREATE TABLE d2.t2 (c1 INTEGER NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2)); 451CREATE TABLE d3.t3 (c1 INTEGER NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2)); 452INSERT INTO d1.t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5); 453INSERT INTO d2.t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6); 454INSERT INTO d3.t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15); 455DELETE QUICK IGNORE FROM d1.t1, d2.t2 USING d1.t1, d2.t2, d3.t3 WHERE d1.t1.c1=d2.t2.c2 AND d2.t2.c1=d3.t3.c2; 456SELECT * FROM d1.t1 ORDER BY c1; 457SELECT * FROM d2.t2 ORDER BY c1; 458SELECT * FROM d3.t3 ORDER BY c1; 459DELETE QUICK IGNORE FROM d1.t1, d2.t2, d3.t3 USING d1.t1, d2.t2, d3.t3 WHERE d1.t1.c1=d2.t2.c2 AND d2.t2.c1=d3.t3.c2; 460SELECT * FROM d1.t1 ORDER BY c1; 461SELECT * FROM d2.t2 ORDER BY c1; 462SELECT * FROM d3.t3 ORDER BY c1; 463DROP DATABASE d1; 464DROP DATABASE d2; 465DROP DATABASE d3; 466CREATE DATABASE d1; 467CREATE DATABASE d2; 468CREATE DATABASE d3; 469CREATE TABLE d1.t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2)); 470CREATE TABLE d2.t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2)); 471CREATE TABLE d3.t3 (c1 BIGINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2)); 472INSERT INTO d1.t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5); 473INSERT INTO d2.t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6); 474INSERT INTO d3.t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15); 475DELETE QUICK IGNORE FROM d1.t1, d2.t2 USING d1.t1, d2.t2, d3.t3 WHERE d1.t1.c1=d2.t2.c2 AND d2.t2.c1=d3.t3.c2; 476SELECT * FROM d1.t1 ORDER BY c1; 477SELECT * FROM d2.t2 ORDER BY c1; 478SELECT * FROM d3.t3 ORDER BY c1; 479DELETE QUICK IGNORE FROM d1.t1, d2.t2, d3.t3 USING d1.t1, d2.t2, d3.t3 WHERE d1.t1.c1=d2.t2.c2 AND d2.t2.c1=d3.t3.c2; 480SELECT * FROM d1.t1 ORDER BY c1; 481SELECT * FROM d2.t2 ORDER BY c1; 482SELECT * FROM d3.t3 ORDER BY c1; 483DROP DATABASE d1; 484DROP DATABASE d2; 485DROP DATABASE d3; 486 487