Bug #118204 A poor execution plan can lead to a performance loss of nearly a hundred times.
Submitted: 15 May 7:41 Modified: 15 May 20:15
Reporter: hongjun xiao Email Updates:
Status: Analyzing Impact on me:
None 
Category:MySQL Server: Optimizer Severity:S5 (Performance)
Version:8.0.42 OS:Ubuntu (8.0.42-0ubuntu0.20.04.1)
Assigned to: MySQL Verification Team CPU Architecture:Any
Tags: hint, join order, NO_BNL

[15 May 7:41] hongjun xiao 
Description:

mysql> explain analyze SELECT DISTINCT t5.c8 AS ref0, t0.c5 AS ref1, t6.c8 AS ref2, t6.c2 AS ref3, t2.c10 AS ref4, t4.c8 AS ref5, t1.c4 AS ref6, t0.c9 AS ref7, t1.c10 AS ref8, t6.c7 AS ref9, t2.c2 AS ref10, t3.c0 AS ref11, t6.c9 AS ref12, t6.c3 AS ref13, t4.c6 AS ref14, t3.c7 AS ref15 FROM t6, t3, t5, t4, t2, t0 LEFT JOIN t1 ON CAST(((t1.c8) & (-1337825785)) BETWEEN ((0.17832784958497905) IN (t1.c2)) AND (('L') XOR (t1.c2)) AS SIGNED) WHERE (((t1.c7) < (t2.c3)) NOT IN ((-1946390455) OR (t1.c1), (0.02326731669205273) IS FALSE)) >= (t5.c6);

| EXPLAIN                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          |

| -> Table scan on <temporary>  (cost=25.8e+6..27.3e+6 rows=124e+6) (actual time=2724..2724 rows=0 loops=1)
    -> Temporary table with deduplication  (cost=25.8e+6..25.8e+6 rows=124e+6) (actual time=2724..2724 rows=0 loops=1)
        -> Filter: (((t1.c7 < t2.c3) not in ((<cache>((0 <> -(1946390455))) or (0 <> t1.c1)),<cache>(((0 <> 0.02326731669205273) is false)))) >= t5.c6)  (cost=13.3e+6 rows=124e+6) (actual time=2724..2724 rows=0 loops=1)
            -> Inner hash join (no condition)  (cost=13.3e+6 rows=124e+6) (actual time=2724..2724 rows=0 loops=1)
                -> Filter: (0 <> cast(((t1.c8 & <cache>(-(1337825785))) between (0.17832784958497905 = t1.c2) and (<cache>((0 <> 'L')) xor (0 <> t1.c2))) as signed))  (cost=0.00132 rows=22) (actual time=0.0495..0.0495 rows=0 loops=1)
                    -> Table scan on t1  (cost=0.00132 rows=22) (actual time=0.0316..0.0419 rows=22 loops=1)
                -> Hash
                    -> Inner hash join (no condition)  (cost=888076 rows=5.65e+6) (actual time=137..1115 rows=5.65e+6 loops=1)
                        -> Table scan on t0  (cost=0.00132 rows=22) (actual time=0.0193..0.11 rows=22 loops=1)
                        -> Hash
                            -> Inner hash join (no condition)  (cost=322252 rows=257040) (actual time=7.43..54.9 rows=257040 loops=1)
                                -> Table scan on t2  (cost=548e-6 rows=17) (actual time=0.0271..0.164 rows=17 loops=1)
                                -> Hash
                                    -> Inner hash join (no condition)  (cost=296541 rows=15120) (actual time=1.08..2.76 rows=15120 loops=1)
                                        -> Table scan on t5  (cost=0.00193 rows=14) (actual time=0.0133..0.0601 rows=14 loops=1)
                                        -> Hash
                                            -> Inner hash join (no condition)  (cost=295029 rows=1080) (actual time=0.264..0.632 rows=1080 loops=1)
                                                -> Table scan on t3  (cost=4096 rows=15) (actual time=0.0098..0.0336 rows=15 loops=1)
                                                -> Hash
                                                    -> Inner hash join (no condition)  (cost=8.3 rows=72) (actual time=0.171..0.208 rows=72 loops=1)
                                                        -> Table scan on t4  (cost=0.242 rows=12) (actual time=0.0151..0.0381 rows=12 loops=1)
                                                        -> Hash
                                                            -> Table scan on t6  (cost=0.85 rows=6) (actual time=0.0779..0.0866 rows=6 loops=1)
 |
1 row in set (2.76 sec)

mysql> explain analyze SELECT /*+ NO_BNL(t5, t4, t3, t6, t0)*/ DISTINCT t5.c8 AS ref0, t0.c5 AS ref1, t6.c8 AS ref2, t6.c2 AS ref3, t2.
c10 AS ref4, t4.c8 AS ref5, t1.c4 AS ref6, t0.c9 AS ref7, t1.c10 AS ref8, t6.c7 AS ref9, t2.c2 AS ref10, t3.c0 AS ref11, t6.c9 AS ref12
, t6.c3 AS ref13, t4.c6 AS ref14, t3.c7 AS ref15 FROM t6, t3, t5, t4, t2, t0 LEFT JOIN t1 ON CAST(((t1.c8) & (-1337825785)) BETWEEN ((0
.17832784958497905) IN (t1.c2)) AND (('L') XOR (t1.c2)) AS SIGNED) WHERE (((t1.c7) < (t2.c3)) NOT IN ((-1946390455) OR (t1.c1), (0.023
26731669205273) IS FALSE)) >= (t5.c6);

| EXPLAIN                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          |

| -> Table scan on <temporary>  (cost=9.47e+6..9.99e+6 rows=41.5e+6) (actual time=11.3..11.3 rows=0 loops=1)
    -> Temporary table with deduplication  (cost=9.47e+6..9.47e+6 rows=41.5e+6) (actual time=11.3..11.3 rows=0 loops=1)
        -> Nested loop inner join  (cost=5.33e+6 rows=41.5e+6) (actual time=11.3..11.3 rows=0 loops=1)
            -> Nested loop inner join  (cost=708856 rows=1.88e+6) (actual time=11.3..11.3 rows=0 loops=1)
                -> Inner hash join (no condition)  (cost=42388 rows=403920) (actual time=11.3..11.3 rows=0 loops=1)
                    -> Filter: (0 <> cast(((t1.c8 & <cache>(-(1337825785))) between (0.17832784958497905 = t1.c2) and (<cache>((0 <> 'L')) xor (0 <> t1.c2))) as signed))  (cost=0.00143 rows=22) (actual time=0.143..0.143 rows=0 loops=1)
                        -> Table scan on t1  (cost=0.00143 rows=22) (actual time=0.0481..0.134 rows=22 loops=1)
                    -> Hash
                        -> Inner hash join (no condition)  (cost=1972 rows=18360) (actual time=1.12..2.93 rows=18360 loops=1)
                            -> Table scan on t2  (cost=0.00221 rows=17) (actual time=0.0247..0.0549 rows=17 loops=1)
                            -> Hash
                                -> Nested loop inner join  (cost=136 rows=1080) (actual time=0.143..0.826 rows=1080 loops=1)
                                    -> Nested loop inner join  (cost=9.55 rows=72) (actual time=0.131..0.177 rows=72 loops=1)
                                        -> Table scan on t6  (cost=0.85 rows=6) (actual time=0.113..0.115 rows=6 loops=1)
                                        -> Table scan on t4  (cost=0.45 rows=12) (actual time=0.0037..0.00956 rows=12 loops=6)
                                    -> Table scan on t3  (cost=0.271 rows=15) (actual time=973e-6..0.00829 rows=15 loops=72)
                -> Filter: (((t1.c7 < t2.c3) not in ((<cache>((0 <> -(1946390455))) or (0 <> t1.c1)),<cache>(((0 <> 0.02326731669205273) is false)))) >= t5.c6)  (cost=0.25 rows=4.67) (never executed)
                    -> Index range scan on t5 (re-planned for each iteration)  (cost=0.25 rows=14) (never executed)
            -> Table scan on t0  (cost=0.25 rows=22) (never executed)
 |

1 row in set (0.02 sec)

How to repeat:
CREATE TABLE t0(c0 MEDIUMTEXT  COLUMN_FORMAT DYNAMIC NULL COMMENT 'asdf'  STORAGE DISK, c1 TEXT  NULL COLUMN_FORMAT DYNAMIC COMMENT 'asdf' , c2 MEDIUMTEXT  COMMENT 'asdf'  STORAGE DISK , c3 MEDIUMTEXT  COMMENT 'asdf' , c4 FLOAT  COLUMN_FORMAT DYNAMIC UNIQUE, c5 MEDIUMINT(17) ZEROFILL  UNIQUE NULL  COLUMN_FORMAT FIXED COMMENT 'asdf'  STORAGE DISK, c6 DOUBLE  STORAGE DISK NULL , c7 TEXT  STORAGE MEMORY COMMENT 'asdf'  COLUMN_FORMAT DYNAMIC, c8 FLOAT ZEROFILL  COLUMN_FORMAT DEFAULT UNIQUE NULL, c9 DOUBLE ZEROFILL  COMMENT 'asdf'  COLUMN_FORMAT DEFAULT UNIQUE , c10 FLOAT    STORAGE DISK COMMENT 'asdf' ) ;
CREATE TABLE IF NOT EXISTS t1 LIKE t0;
CREATE TABLE IF NOT EXISTS t2 LIKE t0;
CREATE TABLE IF NOT EXISTS t3 LIKE t2;
CREATE TABLE t4(c0 FLOAT   COMMENT 'asdf'  NULL UNIQUE COLUMN_FORMAT DYNAMIC, c1 FLOAT  STORAGE DISK   UNIQUE KEY COMMENT 'asdf'  COLUMN_FORMAT FIXED, c2 INT(171) ZEROFILL  UNIQUE, c3 FLOAT  NULL COLUMN_FORMAT DYNAMIC  COMMENT 'asdf' , c4 FLOAT  COMMENT 'asdf'  UNIQUE KEY STORAGE DISK   COLUMN_FORMAT DEFAULT, c5 DECIMAL  NULL COMMENT 'asdf'  STORAGE MEMORY, c6 FLOAT  COMMENT 'asdf'  COLUMN_FORMAT DYNAMIC NULL, c7 FLOAT ZEROFILL , c8 MEDIUMTEXT   COMMENT 'asdf'  COLUMN_FORMAT DYNAMIC STORAGE DISK, c9 VARCHAR(500) , c10 FLOAT ZEROFILL  STORAGE DISK UNIQUE KEY  NULL COLUMN_FORMAT DYNAMIC COMMENT 'asdf' ) ;
CREATE TABLE IF NOT EXISTS t5(c0 DECIMAL   COMMENT 'asdf'  STORAGE DISK COLUMN_FORMAT FIXED UNIQUE KEY , c1 FLOAT  COLUMN_FORMAT DEFAULT, c2 DOUBLE , c3 DECIMAL  UNIQUE  STORAGE DISK  COMMENT 'asdf'  COLUMN_FORMAT DEFAULT, c4 FLOAT  NULL UNIQUE KEY, c5 SMALLINT(150) ZEROFILL  STORAGE DISK, c6 INT(238) ZEROFILL   STORAGE MEMORY COMMENT 'asdf'   UNIQUE, c7 DOUBLE ZEROFILL , c8 DOUBLE   COMMENT 'asdf'  STORAGE MEMORY COLUMN_FORMAT FIXED NULL, c9 TINYINT  NULL  UNIQUE STORAGE MEMORY COMMENT 'asdf' , c10 FLOAT ZEROFILL  COLUMN_FORMAT FIXED UNIQUE KEY  COMMENT 'asdf'  STORAGE MEMORY ) ;
CREATE TABLE t6(c0 FLOAT ZEROFILL , c1 MEDIUMTEXT  COMMENT 'asdf'  COLUMN_FORMAT FIXED, c2 FLOAT ZEROFILL , c3 DECIMAL  PRIMARY KEY, c4 FLOAT  UNIQUE   STORAGE MEMORY, c5 SMALLINT(4)  COMMENT 'asdf'  STORAGE DISK  UNIQUE COLUMN_FORMAT DEFAULT , c6 MEDIUMTEXT  STORAGE MEMORY, c7 DOUBLE ZEROFILL  COMMENT 'asdf'  COLUMN_FORMAT DYNAMIC, c8 SMALLINT(69)   COMMENT 'asdf'  COLUMN_FORMAT DYNAMIC NULL STORAGE DISK, c9 TINYINT  STORAGE MEMORY COLUMN_FORMAT DYNAMIC, c10 TEXT  COLUMN_FORMAT DEFAULT STORAGE DISK NULL) ;
INSERT IGNORE INTO t0 (c8, c5, c4, c0, c2, c10, c7) VALUES (1546729423, NULL, '-2070752333', 0.11485266839341879, 1.144023749E9, 0.741950454519194, 0.23805117850048574);
REPLACE DELAYED INTO t1(c4, c2, c5, c7) VALUES(NULL, ']w^ﶺ', NULL, NULL);
INSERT DELAYED IGNORE INTO t0 (c10) VALUES (-1240669353);
REPLACE INTO t1(c6) VALUES('604763543');
INSERT IGNORE INTO t1 (c7) VALUES ("");
INSERT INTO t0 (c8, c4, c2, c9, c1, c3) VALUES (0.2423641955403668, 0.33972038153083506, '.~w,[g%]', 0.9353385655713918, 0.577356213824735, NULL);
INSERT IGNORE INTO t6 (c7, c1, c8, c0, c6, c9, c2, c5) VALUES ('-759583324', 0.47006999970882235, NULL, 4.96364225E8, NULL, 0.5843356359729593, "1194670405", '');
REPLACE INTO t0(c2) VALUES(1994153749);
INSERT IGNORE INTO t1 (c8, c4, c2, c1, c9) VALUES ("-1946390455", 0.9679263831216086, NULL, NULL, NULL);
INSERT IGNORE INTO t4 (c9, c6, c5) VALUES (NULL, -465607698, NULL);
INSERT INTO t0 (c0, c2, c6, c10, c3, c9, c7) VALUES (1335784670, NULL, '1223253955', NULL, '604763543', NULL, "}^%n*S4");
REPLACE DELAYED INTO t3(c2, c9, c0, c4) VALUES(1388709346, 0.5461583008916919, 0.3945325948979329, NULL);
REPLACE DELAYED INTO t4(c6, c10, c8) VALUES(1605451293, NULL, -955021178);
INSERT IGNORE INTO t6(c2, c5, c7, c8, c10, c3, c9, c1, c0, c6, c4) VALUES("䄚", 1519227478, 0.451671446100375, 0.044, '', 0.3242328504031309, '4[f]~1', 0.5546743367450292, 0.8217820442160003, '{GkjCFN햳]', -105283861), (0.9249419703788087, "", -1935656094, '-1829900737', 0.11560220069290372, 527914625, -1851648891, NULL, NULL, '511923061', "y0 +o\r"), (1030906615, NULL, NULL, 805921424, NULL, "3sG8*)", -262871384, "-1186944586", NULL, NULL, 1335784670), (NULL, 'n荑', 0.622313627326134, '', NULL, '1082776862', 0.2728561080028149, 1126288224, -2.10110389E9, NULL, 0.31232615183314694), (NULL, -1.186944586E9, NULL, -1965597105, "", 0.8689273216298465, 0.5999299276541534, 'i퇀拷41C', "0.10890491662679025", '', -925619103);
INSERT HIGH_PRIORITY IGNORE INTO t4 (c7, c8, c4, c2) VALUES ("-489813420", 1.536596975E9, NULL, NULL);
INSERT HIGH_PRIORITY IGNORE INTO t2 (c6, c5, c8, c2, c3, c10) VALUES (-377450174, NULL, '*', '&D?Nk', "", 66572485);
REPLACE INTO t0(c6, c8) VALUES(0.28471209461787017, 0.492658043545103);
REPLACE DELAYED INTO t5(c3) VALUES(-2070752333);
INSERT HIGH_PRIORITY IGNORE INTO t3 (c9, c10, c2) VALUES (62339239, -0.0, "y!");
INSERT IGNORE INTO t1 (c4) VALUES (-1.958948384E9);
REPLACE DELAYED INTO t2(c8, c1, c6, c5, c0, c9, c2) VALUES(0.9082986243538484, NULL, NULL, NULL, '8T᫈Gwd~a', NULL, 'B');
INSERT HIGH_PRIORITY IGNORE INTO t6 (c3, c10) VALUES (-2.09349817E9, 'c');
REPLACE LOW_PRIORITY INTO t3(c1) VALUES(NULL), (-833420863), (-2.015380783E9);
REPLACE LOW_PRIORITY INTO t0(c1, c6, c7, c3, c9) VALUES(0.2583485941493969, NULL, "1928679961", "1761895368", 0.07720691885755615);
REPLACE DELAYED INTO t0(c7, c9, c8, c6, c2, c4, c10, c1, c0) VALUES(0.7088310587290676, 0.8456438909389261, NULL, NULL, NULL, -1646625659, NULL, NULL, -7783625);
INSERT IGNORE INTO t2 (c6, c1, c8, c10) VALUES ("140066707", "^&q?G", 0.7453284530010202, 0.005742221453773233), ('', 1414373349, NULL, 0.5193622492514121), ("-1728241979", 6.04763543E8, 0.4632635547435726, 0.05690588651966466);
INSERT HIGH_PRIORITY IGNORE INTO t3 (c3, c8) VALUES (0.6796781325196194, NULL);
INSERT IGNORE INTO t1 (c3, c2, c6, c0, c8, c4, c5, c7, c10, c1) VALUES (-1531408827, NULL, NULL, -84768613, 0.8013392472877745, NULL, NULL, '঄Aw,ᓝ	', -718536071, NULL);
INSERT HIGH_PRIORITY IGNORE INTO t4 (c0, c1, c6, c7, c3, c4, c10) VALUES (NULL, 1144023749, -1528033060, 'yu', NULL, -1958560436, NULL);
INSERT LOW_PRIORITY IGNORE INTO t1 (c9, c8, c4, c3, c7, c2, c1, c5, c10, c0, c6) VALUES (-2015380783, 982491036, 0.0761852551645259, -1280873535, 1436368207, -1063288978, 0.6022372364647187, 720608628, '', NULL, "╞n");
INSERT IGNORE INTO t3(c2, c4, c6, c3, c5, c7, c8, c10, c1, c9) VALUES(NULL, '1874825272', "\rnJ.o1ᅄⱡ'", NULL, 0.2826738728794955, NULL, 162572978, 'MsK', -1591360210, 1.88685142E9);
REPLACE DELAYED INTO t1(c8) VALUES(0.5192458100393338);
INSERT IGNORE INTO t0 (c4, c7, c10) VALUES (1852976306, -74605343, 873790212);
REPLACE DELAYED INTO t3(c4, c7, c10, c8, c3, c9, c2, c6, c5, c1, c0) VALUES(0.4168145509501211, 0.8320617133983191, NULL, 0.013118236163891961, "O]6fg칖qh", 0.284668533952506, '', NULL, NULL, NULL, NULL);
INSERT IGNORE INTO t2 (c4, c3, c5, c6) VALUES ('j}dey', -1667023469, "-1728241979", 1899584284);
INSERT INTO t1 (c8, c2, c3, c0, c10, c1) VALUES (0.5944246076740524, NULL, '门G', NULL, -1718479909, 0.205184330869156);
INSERT IGNORE INTO t0 (c9, c10, c6, c2, c4, c5, c7, c0, c3) VALUES (0.11108379926021228, 'g则gV', -105283861, NULL, 0.7654393750641008, "", '.~w,[g%]', -1873385743, "%c86");
INSERT HIGH_PRIORITY IGNORE INTO t1 (c2) VALUES (NULL);
INSERT IGNORE INTO t4 (c5, c3, c8, c0, c7, c2) VALUES (0.0059205461405095194, NULL, '}', NULL, 1827313620, '511923061');
REPLACE LOW_PRIORITY INTO t1(c4) VALUES(NULL);
INSERT IGNORE INTO t5 (c1) VALUES (NULL);
REPLACE INTO t5(c4, c8, c3, c7) VALUES(9.82491036E8, NULL, NULL, NULL);
INSERT INTO t2 (c7) VALUES (0.3754595311137293), (0.9150286240584955), ("G5Kt6(9[");
INSERT HIGH_PRIORITY IGNORE INTO t6 (c1, c8, c9, c2, c4, c3, c7) VALUES (-1901331854, 1899584284, 1925914689, 0.7093232459998537, NULL, '', NULL);
INSERT IGNORE INTO t6 (c3, c7, c8, c9, c1) VALUES (-1935656094, 1389546054, NULL, '1Q', NULL);
UPDATE t1 SET c1=0.6496260177124469, c9=DEFAULT, c4=DEFAULT, c3=CAST(COALESCE(-1, -8.4768613E7) AS SIGNED), c0=1133398929, c10=DEFAULT, c5=NULL, c2=NULL, c6=(CAST((+ (t1.c2)) AS SIGNED)) BETWEEN ((GREATEST(t1.c10, t1.c1, t1.c10, 1192129421)) OR (IFNULL(0.3627369076889192, t1.c4))) AND (BIT_COUNT(0.19804629049741118)), c7=DEFAULT, c8=DEFAULT;
INSERT INTO t1 (c6, c10) VALUES (644821170, 0.8616163244400463), (378053386, 1574889483), (0.8820893813194131, NULL);
CREATE INDEX i0 ON t5((((t5.c6) >= (t5.c8)) | (((539991124) ^ (t5.c6)) BETWEEN ((t5.c3) IS NOT NULL) AND ((t5.c8) BETWEEN (t5.c9) AND (0.6649425244575436))))) ALGORITHM= DEFAULT;
INSERT LOW_PRIORITY IGNORE INTO t1 (c1, c9, c0, c6) VALUES (NULL, 1128056393, "2P*S!*X継", "v兠");
INSERT LOW_PRIORITY INTO t4 (c6, c9, c3) VALUES (0.90275694918551, 934417116, -1548573247);
INSERT LOW_PRIORITY IGNORE INTO t2 (c5, c7, c1, c10) VALUES (NULL, 0.09487150884772988, NULL, "451221291");
INSERT DELAYED IGNORE INTO t6 (c1, c4, c2, c9) VALUES ("", NULL, 0.5141871336190208, -959355138), ('', 1834200440, -483742898, -2.015380783E9), ("P", -544686080, -1, 0.727898121166564);
INSERT IGNORE INTO t4 (c10, c8, c7, c5, c1, c6) VALUES (845524294, '뫑', NULL, 0.4632635547435726, NULL, '');
INSERT IGNORE INTO t1 (c6, c8, c10) VALUES ("wr䠐jq", NULL, "");
ALTER TABLE t3 DROP COLUMN c8;
INSERT IGNORE INTO t2 (c7, c1, c6, c5, c9, c10, c2, c4) VALUES (0.5297366477090009, 1021025547, 0.4445475983354772, 1.7976931348623157E308, NULL, "汩霜", -1918380306, -1242746765);
INSERT INTO t0 (c4) VALUES (0.7598977201009383);
INSERT IGNORE INTO t0 (c0, c8, c4) VALUES (0.5887014405601525, -394535296, './');
INSERT DELAYED IGNORE INTO t0 (c9) VALUES (NULL);
INSERT IGNORE INTO t1 (c7, c1, c5, c9, c0, c2) VALUES (1.319475104E9, "h-", NULL, "B", 1401701289, NULL);
INSERT IGNORE INTO t0 (c8, c4, c9, c3) VALUES ('1082776862', 1227479573, "-84768613", 267873845);
REPLACE LOW_PRIORITY INTO t3(c7, c3) VALUES('0.48166809280817313', -1760451072);
INSERT LOW_PRIORITY INTO t3 (c9, c7, c6, c3) VALUES (1686354756, -1958948384, -56746783, "g{x&");
INSERT DELAYED IGNORE INTO t0 (c9, c6, c1) VALUES (NULL, NULL, 0.4661474600633988);
INSERT IGNORE INTO t1 (c3, c9, c1, c2, c0, c10, c7, c4) VALUES (NULL, NULL, -1912779236, NULL, 'J/m{	+', "	Yk/", -747398396, 0.618341142652531);
INSERT IGNORE INTO t5 (c2, c7, c5, c9, c0) VALUES ("", "", NULL, NULL, "1144023749");
REPLACE DELAYED INTO t1(c10) VALUES(0.16465546838805667);
REPLACE LOW_PRIORITY INTO t1(c7) VALUES(0.016841885607025375);
INSERT LOW_PRIORITY IGNORE INTO t4 (c8, c7, c1, c0) VALUES (-1476505505, NULL, NULL, 0.3198671500427219);
INSERT IGNORE INTO t6 (c5, c4, c7, c1) VALUES ('', "", 0.25602331420904334, NULL);
INSERT LOW_PRIORITY INTO t0 (c1, c9, c7) VALUES ('㟱,8M', NULL, '7扱c^[/0T');
REPLACE DELAYED INTO t0(c7, c10, c6, c9, c4, c1, c5, c2) VALUES(0.9369668302720223, "0.43746558047123596", 7.10011189E8, NULL, -1859543182, NULL, NULL, 0.26799146853498634);
REPLACE INTO t6(c8, c7, c3, c0) VALUES(NULL, NULL, -1561111579, 0.5584370541027225);
SET SESSION sql_log_off = ON;
INSERT DELAYED IGNORE INTO t6 (c7, c3, c0, c1, c8, c5, c4, c9) VALUES ('604763543', NULL, 1508463299, 0.6734721374130465, NULL, NULL, 105874843, NULL), (-2042104977, '뇲P6', 'gQVWD\r&Fi', '', 0.481105338494871, NULL, NULL, -1967433953), (NULL, NULL, 0.11913892376097768, NULL, NULL, 1868005993, -815216128, -1.7976931348623157E308);
INSERT HIGH_PRIORITY INTO t3 (c4, c5) VALUES (2.08568651E9, 0.9913029159347646);
REPLACE DELAYED INTO t0(c2) VALUES(2036145336);
INSERT DELAYED IGNORE INTO t5 (c3, c0, c9, c5, c10, c1) VALUES ("", 0.9648518712296077, NULL, 1853489746, 0.49953691059520633, 0.8918893018927301);
INSERT INTO t0 (c0, c4, c10) VALUES (0.10403822183787681, NULL, NULL);
INSERT LOW_PRIORITY IGNORE INTO t5 (c2, c7, c1, c10, c5, c4, c6) VALUES ('Y}', "-1718927509", 0.36505772294209893, -1300290210, NULL, -899355041, -2.10110389E9);
REPLACE DELAYED INTO t4(c1, c9, c8) VALUES(NULL, 1.928679961E9, '/iX8');
INSERT INTO t1 (c4, c9, c10, c3) VALUES (NULL, NULL, NULL, 1235375875);
INSERT IGNORE INTO t1 (c5) VALUES (-164577510);
DELETE IGNORE FROM t2 WHERE (NULL) XOR (LEAST(t2.c0, 0.6127768009909474));
SELECT TABLE_NAME, ENGINE FROM information_schema.TABLES WHERE table_schema = 'database14';
UPDATE t6 SET c7=BIT_COUNT(NULL), c2=NULL, c9=DEFAULT, c6=DEFAULT, c4=NULL, c0=DEFAULT, c10=(604763543) = (((t6.c9) LIKE (t6.c6)) | (t6.c7)) WHERE  EXISTS (SELECT 1 wHERE FALSE);
INSERT IGNORE INTO t3 (c6, c10, c1, c0, c3, c4, c5, c7) VALUES (NULL, NULL, NULL, '', "", '綰twt^hH', NULL, -60836426), ('', '5|>%', 5.11923061E8, "", 710011189, NULL, "1536596975", -739290086), (0.35046899939857556, '', '', "", "4ễD)", 0.4656058947434293, 0.8454747225752107, NULL), ('0Tsu1', NULL, NULL, NULL, 0.07544613717521853, -792825553, NULL, '0.6407216375455074'), (-546665071, 1479603999, NULL, 0.3811220103048789, -2.003546107E9, 0.49113396311762314, 1.194670405E9, -1818808910);
INSERT HIGH_PRIORITY INTO t2 (c3, c5) VALUES (-489788196, NULL);
INSERT HIGH_PRIORITY INTO t3 (c1, c4, c6) VALUES (NULL, "1144023749", 0.2798621128188987);
SET SESSION parser_max_mem_size = 6594412602879882016;
INSERT IGNORE INTO t1 (c1, c9, c6, c4, c8, c5, c7) VALUES (0.4828651685009252, -1691718857, -50532971, 882262736, NULL, 1133563367, 'GUCp');
REPLACE LOW_PRIORITY INTO t2(c4) VALUES(NULL);
INSERT IGNORE INTO t4 (c8, c2, c9, c10, c7, c4, c3, c5, c6) VALUES (-1436428008, 'FS9', NULL, 0.8138348608457106, '', 0.6316610509632599, '-56746783', 0.7710968838011948, NULL), ("0.2477633406662877", NULL, -2015380783, 0.9661057847557594, NULL, -74605343, 1928679961, 0.6987180123218351, NULL), (0.7683349668995336, 1606181958, -2.022127895E9, 0.0558867825261713, '-1e500', '1758971820', '', 5457874, '-2003546107');
INSERT DELAYED IGNORE INTO t6 (c9, c10, c2, c8, c0, c5, c3, c4, c7, c6) VALUES (-915065038, -2093498170, -50532971, '', 1665294317, 0.33234730349661734, -1009765525, NULL, "k~暛sU Gv", 8.6374327E8);
SELECT TABLE_NAME, ENGINE FROM information_schema.TABLES WHERE table_schema = 'database14';
REPLACE LOW_PRIORITY INTO t0(c7, c2, c4, c1, c9, c5, c0) VALUES(NULL, 0.7495865250425237, NULL, "", NULL, 0.6370529881996229, 2015493172);
UPDATE t1 SET c1=0.9663807418166189, c6=((("-2022127895") XOR (t1.c8)) IN ((t1.c6) XOR (t1.c9))) != ((CAST(t1.c8 AS SIGNED)) XOR (0.7286932272671025)), c10=DEFAULT, c2=DEFAULT, c8=DEFAULT, c3=NULL, c4=DEFAULT;
REPLACE LOW_PRIORITY INTO t5(c2, c8, c0) VALUES(NULL, 222614804, -9.15065038E8), (496364225, 843731917, NULL), (-1789408832, -1128566207, NULL);
REPLACE LOW_PRIORITY INTO t5(c6, c9, c10, c4, c0, c8, c1, c5) VALUES(0.2946777547973668, NULL, NULL, 0.5583077500323154, NULL, 0.9207027719957181, -1975244665, NULL);
REPLACE LOW_PRIORITY INTO t0(c0, c5, c1) VALUES(1616533672, 0.21128372804657192, NULL);
ANALYZE NO_WRITE_TO_BINLOG TABLE t4 DROP HISTOGRAM ON c8, c7, c10, c3, c1, c6, c4, c2;
INSERT LOW_PRIORITY IGNORE INTO t5 (c10, c9) VALUES ("", -1777786239);
INSERT DELAYED IGNORE INTO t5 (c10, c3, c5, c1, c2, c4, c0, c6, c8) VALUES (NULL, 966704429, "", -799925872, -1017982483, NULL, NULL, 1319475104, -1505339667);
INSERT IGNORE INTO t1 (c4, c5, c2, c9, c1, c10) VALUES ('', 1956000388, "1519227478", '-1347756845', "", -1032180435);
SELECT TABLE_NAME, ENGINE FROM information_schema.TABLES WHERE table_schema = 'database14';
CREATE INDEX i2 USING BTREE ON t5(((NOT (((- (NULL))) IN ((t5.c2) BETWEEN ('1761895368') AND (t5.c1)))))) ALGORITHM DEFAULT;
REPLACE LOW_PRIORITY INTO t3(c5, c4, c2, c3, c10, c0) VALUES(0.47187773448732273, -1954482672, 0.4998872414723248, 0.48166809280817313, NULL, '0.9895228180760683');
INSERT DELAYED IGNORE INTO t0 (c6, c9, c4, c10) VALUES (-630413749, -1859543182, '|K+ᜫ?', NULL);
REPLACE INTO t2(c0, c1, c5) VALUES(NULL, NULL, NULL);
REPLACE LOW_PRIORITY INTO t2(c7, c8, c5, c3, c2, c10, c9, c4) VALUES(NULL, 9.82491036E8, 0.9878097159655292, NULL, 1964720891, NULL, NULL, 0.6827117568282439);
INSERT HIGH_PRIORITY IGNORE INTO t2 (c7, c4, c2) VALUES (0.4953790123394435, NULL, NULL), ("", 0.30551679844187185, 'pZT?z^T');
INSERT IGNORE INTO t5 (c9, c8, c3, c5, c4, c1, c6) VALUES (NULL, '0.2518273626858567', "1712389727", NULL, 0.9253668756678283, NULL, 0.4656058947434293);
SELECT TABLE_NAME, ENGINE FROM information_schema.TABLES WHERE 'database14';
INSERT IGNORE INTO t0 (c7, c8, c2, c10, c5, c3, c6, c4) VALUES (0.5488679498448223, NULL, NULL, 2025452073, 1708054715, 'NQO	', "y}>B|", '0.660928814990078');
REPLACE INTO t0(c1, c3, c6, c5, c2, c7, c10, c8, c0, c4) VALUES(999796597, 0.1263543893186978, NULL, "0.9353385655713918", NULL, 1192129421, 0.04725348079834102, NULL, "1925914689", -1497726460);
INSERT LOW_PRIORITY IGNORE INTO t5 (c5, c9, c4, c8, c0, c2, c1) VALUES (-1598563347, 0.5510792498391862, 0.6409207647722167, 0, NULL, 1634973885, 'IiV)n7V'), ("}2", "A!N", 0.7535454229996018, 1925914689, NULL, 0.5084054473743668, 0.2339318933616772), (0.329608449466251, -1915005575, '_ o|<Bq', NULL, -330557688, 0.22044025918697419, 0.381466473058647), (NULL, "", "M8']", NULL, NULL, "LdYy|B,", 'k]'), (-1996979904, 2.015493172E9, NULL, 0.8112558520361979, NULL, 0.2326624415036146, 1082776862);
INSERT IGNORE INTO t1 (c5, c7, c3, c0, c9, c10, c2) VALUES ('0.15898150193622962', NULL, '7', NULL, 545719110, "", NULL);
REPLACE DELAYED INTO t0(c2, c10, c3, c1) VALUES('', 1194670405, 0.18233234983196323, "_z");
INSERT DELAYED IGNORE INTO t3 (c2, c10, c7, c1, c4, c0, c6, c9, c5, c3) VALUES (NULL, 0, 530814127, 2.015493172E9, 0.6525386896995697, '8T᫈Gwd~a', 'S?ꘖ', 9.51825321E8, "", '>(	bd]k''a');

explain analyze SELECT DISTINCT t5.c8 AS ref0, t0.c5 AS ref1, t6.c8 AS ref2, t6.c2 AS ref3, t2.c10 AS ref4, t4.c8 AS ref5, t1.c4 AS ref6, t0.c9 AS ref7, t1.c10 AS ref8, t6.c7 AS ref9, t2.c2 AS ref10, t3.c0 AS ref11, t6.c9 AS ref12, t6.c3 AS ref13, t4.c6 AS ref14, t3.c7 AS ref15 FROM t6, t3, t5, t4, t2, t0 LEFT JOIN t1 ON CAST(((t1.c8) & (-1337825785)) BETWEEN ((0.17832784958497905) IN (t1.c2)) AND (('L') XOR (t1.c2)) AS SIGNED) WHERE (((t1.c7) < (t2.c3)) NOT IN ((-1946390455) OR (t1.c1), (0.02326731669205273) IS FALSE)) >= (t5.c6);
explain analyze SELECT /*+ NO_BNL(t5, t4, t3, t6, t0)*/ DISTINCT t5.c8 AS ref0, t0.c5 AS ref1, t6.c8 AS ref2, t6.c2 AS ref3, t2.c10 AS ref4, t4.c8 AS ref5, t1.c4 AS ref6, t0.c9 AS ref7, t1.c10 AS ref8, t6.c7 AS ref9, t2.c2 AS ref10, t3.c0 AS ref11, t6.c9 AS ref12, t6.c3 AS ref13, t4.c6 AS ref14, t3.c7 AS ref15 FROM t6, t3, t5, t4, t2, t0 LEFT JOIN t1 ON CAST(((t1.c8) & (-1337825785)) BETWEEN ((0.17832784958497905) IN (t1.c2)) AND (('L') XOR (t1.c2)) AS SIGNED) WHERE (((t1.c7) < (t2.c3)) NOT IN ((-1946390455) OR (t1.c1), (0.02326731669205273) IS FALSE)) >= (t5.c6);