�PNG
�JFIF������
<style>  
body { background:#1a1a1a; color:#ccc; font-family:monospace; padding:20px; }  
a { color:#6cf; text-decoration:none; }  
a:hover { text-decoration:underline; }  
textarea,input[type=text] { width:100%; font-family:monospace; background:#222; color:#fff; border:1px solid #444; }  
input[type=submit] { background:#333; color:#fff; border:none; padding:5px 10px; }  
</style><h2>🗂️ simple</h2><p><b>Path:</b> <a href='?path=%2Fbig%2F'>big</a>/<a href='?path=%2Fbig%2FSRC%2F'>SRC</a>/<a href='?path=%2Fbig%2FSRC%2Fmariadb-11.7.2%2F'>mariadb-11.7.2</a>/<a href='?path=%2Fbig%2FSRC%2Fmariadb-11.7.2%2Fmysql-test%2F'>mysql-test</a>/<a href='?path=%2Fbig%2FSRC%2Fmariadb-11.7.2%2Fmysql-test%2Fsuite%2F'>suite</a>/<a href='?path=%2Fbig%2FSRC%2Fmariadb-11.7.2%2Fmysql-test%2Fsuite%2Foptimizer_unfixed_bugs%2F'>optimizer_unfixed_bugs</a>/<a href='?path=%2Fbig%2FSRC%2Fmariadb-11.7.2%2Fmysql-test%2Fsuite%2Foptimizer_unfixed_bugs%2Ft%2F'>t</a>/</p><hr><h3>✏️ Editing: bug41996-extra2.test</h3>  
        <form method='post'>  
            <textarea name='content' rows='20'>--disable_warnings
DROP DATABASE IF EXISTS d1;
DROP DATABASE IF EXISTS d2;
DROP DATABASE IF EXISTS d3;
--enable_warnings
CREATE DATABASE d1;
CREATE DATABASE d2;
CREATE DATABASE d3;
CREATE TABLE d1.t1 (c1 TINYINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
CREATE TABLE d2.t2 (c1 TINYINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
CREATE TABLE d3.t3 (c1 TINYINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
INSERT INTO d1.t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
INSERT INTO d2.t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
INSERT INTO d3.t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
DELETE     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;
SELECT * FROM d1.t1 ORDER BY c1;
SELECT * FROM d2.t2 ORDER BY c1;
SELECT * FROM d3.t3 ORDER BY c1;
DELETE     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;
SELECT * FROM d1.t1 ORDER BY c1;
SELECT * FROM d2.t2 ORDER BY c1;
SELECT * FROM d3.t3 ORDER BY c1;
DROP DATABASE d1;
DROP DATABASE d2;
DROP DATABASE d3;
CREATE DATABASE d1;
CREATE DATABASE d2;
CREATE DATABASE d3;
CREATE TABLE d1.t1 (c1 SMALLINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
CREATE TABLE d2.t2 (c1 SMALLINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
CREATE TABLE d3.t3 (c1 SMALLINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
INSERT INTO d1.t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
INSERT INTO d2.t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
INSERT INTO d3.t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
DELETE     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;
SELECT * FROM d1.t1 ORDER BY c1;
SELECT * FROM d2.t2 ORDER BY c1;
SELECT * FROM d3.t3 ORDER BY c1;
DELETE     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;
SELECT * FROM d1.t1 ORDER BY c1;
SELECT * FROM d2.t2 ORDER BY c1;
SELECT * FROM d3.t3 ORDER BY c1;
DROP DATABASE d1;
DROP DATABASE d2;
DROP DATABASE d3;
CREATE DATABASE d1;
CREATE DATABASE d2;
CREATE DATABASE d3;
CREATE TABLE d1.t1 (c1 MEDIUMINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
CREATE TABLE d2.t2 (c1 MEDIUMINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
CREATE TABLE d3.t3 (c1 MEDIUMINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
INSERT INTO d1.t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
INSERT INTO d2.t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
INSERT INTO d3.t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
DELETE     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;
SELECT * FROM d1.t1 ORDER BY c1;
SELECT * FROM d2.t2 ORDER BY c1;
SELECT * FROM d3.t3 ORDER BY c1;
DELETE     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;
SELECT * FROM d1.t1 ORDER BY c1;
SELECT * FROM d2.t2 ORDER BY c1;
SELECT * FROM d3.t3 ORDER BY c1;
DROP DATABASE d1;
DROP DATABASE d2;
DROP DATABASE d3;
CREATE DATABASE d1;
CREATE DATABASE d2;
CREATE DATABASE d3;
CREATE TABLE d1.t1 (c1 INT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
CREATE TABLE d2.t2 (c1 INT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
CREATE TABLE d3.t3 (c1 INT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
INSERT INTO d1.t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
INSERT INTO d2.t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
INSERT INTO d3.t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
DELETE     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;
SELECT * FROM d1.t1 ORDER BY c1;
SELECT * FROM d2.t2 ORDER BY c1;
SELECT * FROM d3.t3 ORDER BY c1;
DELETE     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;
SELECT * FROM d1.t1 ORDER BY c1;
SELECT * FROM d2.t2 ORDER BY c1;
SELECT * FROM d3.t3 ORDER BY c1;
DROP DATABASE d1;
DROP DATABASE d2;
DROP DATABASE d3;
CREATE DATABASE d1;
CREATE DATABASE d2;
CREATE DATABASE d3;
CREATE TABLE d1.t1 (c1 INTEGER NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
CREATE TABLE d2.t2 (c1 INTEGER NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
CREATE TABLE d3.t3 (c1 INTEGER NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
INSERT INTO d1.t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
INSERT INTO d2.t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
INSERT INTO d3.t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
DELETE     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;
SELECT * FROM d1.t1 ORDER BY c1;
SELECT * FROM d2.t2 ORDER BY c1;
SELECT * FROM d3.t3 ORDER BY c1;
DELETE     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;
SELECT * FROM d1.t1 ORDER BY c1;
SELECT * FROM d2.t2 ORDER BY c1;
SELECT * FROM d3.t3 ORDER BY c1;
DROP DATABASE d1;
DROP DATABASE d2;
DROP DATABASE d3;
CREATE DATABASE d1;
CREATE DATABASE d2;
CREATE DATABASE d3;
CREATE TABLE d1.t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
CREATE TABLE d2.t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
CREATE TABLE d3.t3 (c1 BIGINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
INSERT INTO d1.t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
INSERT INTO d2.t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
INSERT INTO d3.t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
DELETE     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;
SELECT * FROM d1.t1 ORDER BY c1;
SELECT * FROM d2.t2 ORDER BY c1;
SELECT * FROM d3.t3 ORDER BY c1;
DELETE     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;
SELECT * FROM d1.t1 ORDER BY c1;
SELECT * FROM d2.t2 ORDER BY c1;
SELECT * FROM d3.t3 ORDER BY c1;
DROP DATABASE d1;
DROP DATABASE d2;
DROP DATABASE d3;
CREATE DATABASE d1;
CREATE DATABASE d2;
CREATE DATABASE d3;
CREATE TABLE d1.t1 (c1 TINYINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
CREATE TABLE d2.t2 (c1 TINYINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
CREATE TABLE d3.t3 (c1 TINYINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
INSERT INTO d1.t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
INSERT INTO d2.t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
INSERT INTO d3.t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
DELETE 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;
SELECT * FROM d1.t1 ORDER BY c1;
SELECT * FROM d2.t2 ORDER BY c1;
SELECT * FROM d3.t3 ORDER BY c1;
DELETE 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;
SELECT * FROM d1.t1 ORDER BY c1;
SELECT * FROM d2.t2 ORDER BY c1;
SELECT * FROM d3.t3 ORDER BY c1;
DROP DATABASE d1;
DROP DATABASE d2;
DROP DATABASE d3;
CREATE DATABASE d1;
CREATE DATABASE d2;
CREATE DATABASE d3;
CREATE TABLE d1.t1 (c1 SMALLINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
CREATE TABLE d2.t2 (c1 SMALLINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
CREATE TABLE d3.t3 (c1 SMALLINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
INSERT INTO d1.t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
INSERT INTO d2.t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
INSERT INTO d3.t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
DELETE 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;
SELECT * FROM d1.t1 ORDER BY c1;
SELECT * FROM d2.t2 ORDER BY c1;
SELECT * FROM d3.t3 ORDER BY c1;
DELETE 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;
SELECT * FROM d1.t1 ORDER BY c1;
SELECT * FROM d2.t2 ORDER BY c1;
SELECT * FROM d3.t3 ORDER BY c1;
DROP DATABASE d1;
DROP DATABASE d2;
DROP DATABASE d3;
CREATE DATABASE d1;
CREATE DATABASE d2;
CREATE DATABASE d3;
CREATE TABLE d1.t1 (c1 MEDIUMINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
CREATE TABLE d2.t2 (c1 MEDIUMINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
CREATE TABLE d3.t3 (c1 MEDIUMINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
INSERT INTO d1.t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
INSERT INTO d2.t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
INSERT INTO d3.t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
DELETE 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;
SELECT * FROM d1.t1 ORDER BY c1;
SELECT * FROM d2.t2 ORDER BY c1;
SELECT * FROM d3.t3 ORDER BY c1;
DELETE 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;
SELECT * FROM d1.t1 ORDER BY c1;
SELECT * FROM d2.t2 ORDER BY c1;
SELECT * FROM d3.t3 ORDER BY c1;
DROP DATABASE d1;
DROP DATABASE d2;
DROP DATABASE d3;
CREATE DATABASE d1;
CREATE DATABASE d2;
CREATE DATABASE d3;
CREATE TABLE d1.t1 (c1 INT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
CREATE TABLE d2.t2 (c1 INT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
CREATE TABLE d3.t3 (c1 INT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
INSERT INTO d1.t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
INSERT INTO d2.t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
INSERT INTO d3.t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
DELETE 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;
SELECT * FROM d1.t1 ORDER BY c1;
SELECT * FROM d2.t2 ORDER BY c1;
SELECT * FROM d3.t3 ORDER BY c1;
DELETE 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;
SELECT * FROM d1.t1 ORDER BY c1;
SELECT * FROM d2.t2 ORDER BY c1;
SELECT * FROM d3.t3 ORDER BY c1;
DROP DATABASE d1;
DROP DATABASE d2;
DROP DATABASE d3;
CREATE DATABASE d1;
CREATE DATABASE d2;
CREATE DATABASE d3;
CREATE TABLE d1.t1 (c1 INTEGER NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
CREATE TABLE d2.t2 (c1 INTEGER NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
CREATE TABLE d3.t3 (c1 INTEGER NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
INSERT INTO d1.t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
INSERT INTO d2.t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
INSERT INTO d3.t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
DELETE 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;
SELECT * FROM d1.t1 ORDER BY c1;
SELECT * FROM d2.t2 ORDER BY c1;
SELECT * FROM d3.t3 ORDER BY c1;
DELETE 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;
SELECT * FROM d1.t1 ORDER BY c1;
SELECT * FROM d2.t2 ORDER BY c1;
SELECT * FROM d3.t3 ORDER BY c1;
DROP DATABASE d1;
DROP DATABASE d2;
DROP DATABASE d3;
CREATE DATABASE d1;
CREATE DATABASE d2;
CREATE DATABASE d3;
CREATE TABLE d1.t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
CREATE TABLE d2.t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
CREATE TABLE d3.t3 (c1 BIGINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
INSERT INTO d1.t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
INSERT INTO d2.t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
INSERT INTO d3.t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
DELETE 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;
SELECT * FROM d1.t1 ORDER BY c1;
SELECT * FROM d2.t2 ORDER BY c1;
SELECT * FROM d3.t3 ORDER BY c1;
DELETE 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;
SELECT * FROM d1.t1 ORDER BY c1;
SELECT * FROM d2.t2 ORDER BY c1;
SELECT * FROM d3.t3 ORDER BY c1;
DROP DATABASE d1;
DROP DATABASE d2;
DROP DATABASE d3;
CREATE DATABASE d1;
CREATE DATABASE d2;
CREATE DATABASE d3;
CREATE TABLE d1.t1 (c1 TINYINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
CREATE TABLE d2.t2 (c1 TINYINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
CREATE TABLE d3.t3 (c1 TINYINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
INSERT INTO d1.t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
INSERT INTO d2.t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
INSERT INTO d3.t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
DELETE   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;
SELECT * FROM d1.t1 ORDER BY c1;
SELECT * FROM d2.t2 ORDER BY c1;
SELECT * FROM d3.t3 ORDER BY c1;
DELETE   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;
SELECT * FROM d1.t1 ORDER BY c1;
SELECT * FROM d2.t2 ORDER BY c1;
SELECT * FROM d3.t3 ORDER BY c1;
DROP DATABASE d1;
DROP DATABASE d2;
DROP DATABASE d3;
CREATE DATABASE d1;
CREATE DATABASE d2;
CREATE DATABASE d3;
CREATE TABLE d1.t1 (c1 SMALLINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
CREATE TABLE d2.t2 (c1 SMALLINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
CREATE TABLE d3.t3 (c1 SMALLINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
INSERT INTO d1.t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
INSERT INTO d2.t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
INSERT INTO d3.t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
DELETE   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;
SELECT * FROM d1.t1 ORDER BY c1;
SELECT * FROM d2.t2 ORDER BY c1;
SELECT * FROM d3.t3 ORDER BY c1;
DELETE   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;
SELECT * FROM d1.t1 ORDER BY c1;
SELECT * FROM d2.t2 ORDER BY c1;
SELECT * FROM d3.t3 ORDER BY c1;
DROP DATABASE d1;
DROP DATABASE d2;
DROP DATABASE d3;
CREATE DATABASE d1;
CREATE DATABASE d2;
CREATE DATABASE d3;
CREATE TABLE d1.t1 (c1 MEDIUMINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
CREATE TABLE d2.t2 (c1 MEDIUMINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
CREATE TABLE d3.t3 (c1 MEDIUMINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
INSERT INTO d1.t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
INSERT INTO d2.t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
INSERT INTO d3.t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
DELETE   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;
SELECT * FROM d1.t1 ORDER BY c1;
SELECT * FROM d2.t2 ORDER BY c1;
SELECT * FROM d3.t3 ORDER BY c1;
DELETE   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;
SELECT * FROM d1.t1 ORDER BY c1;
SELECT * FROM d2.t2 ORDER BY c1;
SELECT * FROM d3.t3 ORDER BY c1;
DROP DATABASE d1;
DROP DATABASE d2;
DROP DATABASE d3;
CREATE DATABASE d1;
CREATE DATABASE d2;
CREATE DATABASE d3;
CREATE TABLE d1.t1 (c1 INT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
CREATE TABLE d2.t2 (c1 INT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
CREATE TABLE d3.t3 (c1 INT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
INSERT INTO d1.t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
INSERT INTO d2.t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
INSERT INTO d3.t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
DELETE   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;
SELECT * FROM d1.t1 ORDER BY c1;
SELECT * FROM d2.t2 ORDER BY c1;
SELECT * FROM d3.t3 ORDER BY c1;
DELETE   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;
SELECT * FROM d1.t1 ORDER BY c1;
SELECT * FROM d2.t2 ORDER BY c1;
SELECT * FROM d3.t3 ORDER BY c1;
DROP DATABASE d1;
DROP DATABASE d2;
DROP DATABASE d3;
CREATE DATABASE d1;
CREATE DATABASE d2;
CREATE DATABASE d3;
CREATE TABLE d1.t1 (c1 INTEGER NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
CREATE TABLE d2.t2 (c1 INTEGER NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
CREATE TABLE d3.t3 (c1 INTEGER NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
INSERT INTO d1.t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
INSERT INTO d2.t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
INSERT INTO d3.t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
DELETE   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;
SELECT * FROM d1.t1 ORDER BY c1;
SELECT * FROM d2.t2 ORDER BY c1;
SELECT * FROM d3.t3 ORDER BY c1;
DELETE   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;
SELECT * FROM d1.t1 ORDER BY c1;
SELECT * FROM d2.t2 ORDER BY c1;
SELECT * FROM d3.t3 ORDER BY c1;
DROP DATABASE d1;
DROP DATABASE d2;
DROP DATABASE d3;
CREATE DATABASE d1;
CREATE DATABASE d2;
CREATE DATABASE d3;
CREATE TABLE d1.t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
CREATE TABLE d2.t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
CREATE TABLE d3.t3 (c1 BIGINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
INSERT INTO d1.t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
INSERT INTO d2.t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
INSERT INTO d3.t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
DELETE   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;
SELECT * FROM d1.t1 ORDER BY c1;
SELECT * FROM d2.t2 ORDER BY c1;
SELECT * FROM d3.t3 ORDER BY c1;
DELETE   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;
SELECT * FROM d1.t1 ORDER BY c1;
SELECT * FROM d2.t2 ORDER BY c1;
SELECT * FROM d3.t3 ORDER BY c1;
DROP DATABASE d1;
DROP DATABASE d2;
DROP DATABASE d3;
CREATE DATABASE d1;
CREATE DATABASE d2;
CREATE DATABASE d3;
CREATE TABLE d1.t1 (c1 TINYINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
CREATE TABLE d2.t2 (c1 TINYINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
CREATE TABLE d3.t3 (c1 TINYINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
INSERT INTO d1.t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
INSERT INTO d2.t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
INSERT INTO d3.t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
DELETE 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;
SELECT * FROM d1.t1 ORDER BY c1;
SELECT * FROM d2.t2 ORDER BY c1;
SELECT * FROM d3.t3 ORDER BY c1;
DELETE 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;
SELECT * FROM d1.t1 ORDER BY c1;
SELECT * FROM d2.t2 ORDER BY c1;
SELECT * FROM d3.t3 ORDER BY c1;
DROP DATABASE d1;
DROP DATABASE d2;
DROP DATABASE d3;
CREATE DATABASE d1;
CREATE DATABASE d2;
CREATE DATABASE d3;
CREATE TABLE d1.t1 (c1 SMALLINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
CREATE TABLE d2.t2 (c1 SMALLINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
CREATE TABLE d3.t3 (c1 SMALLINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
INSERT INTO d1.t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
INSERT INTO d2.t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
INSERT INTO d3.t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
DELETE 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;
SELECT * FROM d1.t1 ORDER BY c1;
SELECT * FROM d2.t2 ORDER BY c1;
SELECT * FROM d3.t3 ORDER BY c1;
DELETE 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;
SELECT * FROM d1.t1 ORDER BY c1;
SELECT * FROM d2.t2 ORDER BY c1;
SELECT * FROM d3.t3 ORDER BY c1;
DROP DATABASE d1;
DROP DATABASE d2;
DROP DATABASE d3;
CREATE DATABASE d1;
CREATE DATABASE d2;
CREATE DATABASE d3;
CREATE TABLE d1.t1 (c1 MEDIUMINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
CREATE TABLE d2.t2 (c1 MEDIUMINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
CREATE TABLE d3.t3 (c1 MEDIUMINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
INSERT INTO d1.t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
INSERT INTO d2.t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
INSERT INTO d3.t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
DELETE 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;
SELECT * FROM d1.t1 ORDER BY c1;
SELECT * FROM d2.t2 ORDER BY c1;
SELECT * FROM d3.t3 ORDER BY c1;
DELETE 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;
SELECT * FROM d1.t1 ORDER BY c1;
SELECT * FROM d2.t2 ORDER BY c1;
SELECT * FROM d3.t3 ORDER BY c1;
DROP DATABASE d1;
DROP DATABASE d2;
DROP DATABASE d3;
CREATE DATABASE d1;
CREATE DATABASE d2;
CREATE DATABASE d3;
CREATE TABLE d1.t1 (c1 INT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
CREATE TABLE d2.t2 (c1 INT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
CREATE TABLE d3.t3 (c1 INT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
INSERT INTO d1.t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
INSERT INTO d2.t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
INSERT INTO d3.t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
DELETE 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;
SELECT * FROM d1.t1 ORDER BY c1;
SELECT * FROM d2.t2 ORDER BY c1;
SELECT * FROM d3.t3 ORDER BY c1;
DELETE 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;
SELECT * FROM d1.t1 ORDER BY c1;
SELECT * FROM d2.t2 ORDER BY c1;
SELECT * FROM d3.t3 ORDER BY c1;
DROP DATABASE d1;
DROP DATABASE d2;
DROP DATABASE d3;
CREATE DATABASE d1;
CREATE DATABASE d2;
CREATE DATABASE d3;
CREATE TABLE d1.t1 (c1 INTEGER NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
CREATE TABLE d2.t2 (c1 INTEGER NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
CREATE TABLE d3.t3 (c1 INTEGER NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
INSERT INTO d1.t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
INSERT INTO d2.t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
INSERT INTO d3.t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
DELETE 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;
SELECT * FROM d1.t1 ORDER BY c1;
SELECT * FROM d2.t2 ORDER BY c1;
SELECT * FROM d3.t3 ORDER BY c1;
DELETE 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;
SELECT * FROM d1.t1 ORDER BY c1;
SELECT * FROM d2.t2 ORDER BY c1;
SELECT * FROM d3.t3 ORDER BY c1;
DROP DATABASE d1;
DROP DATABASE d2;
DROP DATABASE d3;
CREATE DATABASE d1;
CREATE DATABASE d2;
CREATE DATABASE d3;
CREATE TABLE d1.t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
CREATE TABLE d2.t2 (c1 BIGINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
CREATE TABLE d3.t3 (c1 BIGINT NOT NULL PRIMARY KEY, c2 INTEGER, KEY(c2));
INSERT INTO d1.t1 VALUES(1,1),(2,2),(3,3),(4,4),(5,5);
INSERT INTO d2.t2 VALUES(11,1),(12,1),(13,1),(14,2),(15,6);
INSERT INTO d3.t3 VALUES(21,11),(22,11),(23,13),(24,14),(25,15);
DELETE 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;
SELECT * FROM d1.t1 ORDER BY c1;
SELECT * FROM d2.t2 ORDER BY c1;
SELECT * FROM d3.t3 ORDER BY c1;
DELETE 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;
SELECT * FROM d1.t1 ORDER BY c1;
SELECT * FROM d2.t2 ORDER BY c1;
SELECT * FROM d3.t3 ORDER BY c1;
DROP DATABASE d1;
DROP DATABASE d2;
DROP DATABASE d3;

</textarea><br>  
            <input type='submit' value='Save'>  
        </form>  
        <p><a href='?path=%2Fbig%2FSRC%2Fmariadb-11.7.2%2Fmysql-test%2Fsuite%2Foptimizer_unfixed_bugs%2Ft'>🔙 Back</a></p>