Description:
This is a minimized reproducer for pair 2424. The mutated query only adds a logically redundant OR FALSE to the original predicate:
WHERE P
=>
WHERE P OR FALSE
P OR FALSE is equivalent to P under SQL three-valued logic. Both queries return the same result, COUNT(*) = 0, but the OR FALSE version is consistently slower on this minimized setup.
Final verification from the minimized SQL file, without ANALYZE TABLE:
original median: 3.587 ms
mutated median: 98.263 ms
ratio original/mutated: 0.0365
slowdown: about 27x
A second run with ANALYZE TABLE showed the same behavior:
original median: 3.369 ms
mutated median: 96.921 ms
ratio original/mutated: 0.0348
slowdown: about 29x
The schema is intentionally small: t1 and t3 are empty; t2 has only two rows; no indexes are required.
Expected behavior:
The optimizer should simplify P OR FALSE to P, or choose a plan with comparable performance.
Actual behavior:
The redundant OR FALSE predicate changes optimization enough to produce a stable execution-time regression.
How to repeat:
Run the following SQL on MySQL 9.5.0.
DROP DATABASE IF EXISTS pair2424_min_repro;
CREATE DATABASE pair2424_min_repro;
USE pair2424_min_repro;
CREATE TABLE t1(c1 INT,c2 CHAR(1),c3 CHAR(1),c4 INT,c5 DATE,c6 CHAR(1));
CREATE TABLE t2(c1 INT,c2 INT,c3 INT,c4 CHAR(1),c5 DATE,c6 CHAR(1),c7 CHAR(1),c8 CHAR(1),c9 CHAR(1),c10 CHAR(1),c11 CHAR(1),c13 DATE,c14 INT,c15 INT);
CREATE TABLE t3(c1 INT,c2 INT,c3 INT,c4 INT,c5 DATE,c6 INT,c7 INT,c8 INT,c9 INT,c10 CHAR(1),c12 CHAR(1),c14 CHAR(1),c15 INT);
INSERT INTO t2(c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c13,c14,c15) VALUES
(1,10,2,'s','2026-01-01','s','1','x','y','v','a','2026-01-01',1,1),
(2,20,3,'s','2026-01-01','s','2','x','y','v','a','2026-01-01',2,2);
-- Original query. Expected result: cnt = 0.
WITH cte_1 AS (SELECT LOG(10, t2.c3) AS col_1, (t2.c1 + t2.c7) AS col_2 FROM t2 AS t1 INNER JOIN t3 AS t2 ON (((t1.c2 >= t2.c1) OR (t1.c2 >= 26)) AND (t1.c13 <> t2.c5)) LEFT JOIN (SELECT t5.c9 AS col_1, (SELECT DEGREES(t9.c4) AS col_1 FROM t3 AS t9 WHERE NOT (t9.c4 IS NULL) LIMIT 1) AS col_2, LAST_VALUE(t5.c7) OVER (ORDER BY t5.c5 DESC) AS col_3 FROM t1 AS t4 LEFT JOIN t2 AS t5 ON (((NOT t5.c2 BETWEEN 45 AND 87 AND t5.c7 IN (SELECT t6.c6 AS col_1 FROM t2 AS t6 INNER JOIN t3 AS t7 ON (NOT (t6.c3 IS NULL) AND (t6.c7 = t7.c12)) CROSS JOIN t1 AS t8 ON (t6.c15 <= t8.c4) WHERE ((NOT t6.c14 BETWEEN 47 AND 96 OR (t6.c1 >= 78)) OR (t6.c4 = 'sample_87')))) AND (t4.c4 = 98)) AND NOT t5.c1 BETWEEN 37 AND 46) WHERE ((t4.c4 <> 85) AND NOT t5.c8 IS NULL)) AS sq3 ON (((NOT t2.c10 IN (SELECT t10.c11 AS col_1 FROM t2 AS t10 RIGHT JOIN t3 AS t11 ON (((NOT t11.c14 IS NULL OR (t10.c14 > t11.c1)) OR t11.c5 IN (SELECT BIT_OR(t12.c1) AS col_1 FROM t3 AS t12 WHERE NOT (t12.c1 BETWEEN 48 AND 90))) AND EXISTS(SELECT t13.c5 AS col_1 FROM t3 AS t13 RIGHT JOIN t2 AS t14 ON (t14.c5 = '2023-01-01') WHERE (NOT REGEXP_LIKE(t14.c7, '[a-zA-Z0-9]{3,12}')))) CROSS JOIN (SELECT ACOS(t16.c1) AS col_3, STDDEV_POP(t16.c14) AS col_5 FROM t2 AS t16 WHERE (t16.c4 <> 'sample_40') GROUP BY ACOS(t16.c1), t16.c1, t16.c14) AS sq15 ON (NOT ((t10.c2 >= sq15.col_3)) OR (t10.c3 = sq15.col_5)) WHERE (((NOT t10.c11 LIKE '%sample_81') AND NOT t10.c3 BETWEEN 34 AND 82) AND (t11.c10 <> 'sample_41'))) AND (t2.c12 = sq3.col_3)) AND (t2.c1 > sq3.col_2)) AND (t2.c6 >= sq3.col_2)) ) SELECT COUNT(*) AS cnt FROM t2 AS t28 LEFT JOIN (SELECT t34.c4 AS col_1, 0 AS col_2, t31.c11 AS col_3, 0 AS col_4, NULL AS col_5 FROM t3 AS t30 CROSS JOIN t2 AS t31 ON EXISTS(SELECT STR_TO_DATE(sq32.col_2, sq32.col_2) AS col_1 FROM (SELECT CAST(t33.c1 AS DECIMAL(10, 2)) AS col_1, SCHEMA() AS col_2, STDDEV_SAMP(t33.c1) AS col_3, LENGTH(t33.c3) AS col_4 FROM t1 AS t33 WHERE (REGEXP_LIKE(t33.c6, '^sample_[0-9]+$')) GROUP BY CAST(t33.c1 AS DECIMAL(10, 2)), t33.c1, LENGTH(t33.c3), t33.c3 LIMIT 22) AS sq32 ORDER BY sq32.col_4 DESC) INNER JOIN t1 AS t34 ON (NOT ((t31.c13 = '2023-01-01')) AND EXISTS(SELECT t35.c5 AS col_1 FROM t2 AS t35 INNER JOIN (SELECT t37.c7 AS col_1, t37.c15 AS col_2, t37.c11 AS col_3, t37.c7 AS col_4 FROM t2 AS t37 WHERE (t37.c5 <> '2023-01-01')) AS sq36 ON NOT ((t35.c11 <> sq36.col_3)) CROSS JOIN cte_1 AS t38 ON (((t35.c3 BETWEEN 46 AND 89 AND (t35.c15 > t38.col_1)) AND t35.c11 IN (SELECT STDDEV_SAMP(t39.c4) AS col_1 FROM t1 AS t39 WHERE NOT t39.c1 BETWEEN 6 AND 25)) AND (t35.c14 > t38.col_1)) WHERE (t35.c2 BETWEEN 2 AND 10 AND sq36.col_1 IN (SELECT t40.c2 AS col_1 FROM t1 AS t40 CROSS JOIN t3 AS t41 ON (NOT t41.c12 IS NULL OR NOT t41.c15 BETWEEN 43 AND 68))) LIMIT 29))) AS sq29 ON (t28.c14 >= sq29.col_1) WHERE (((t28.c13 = '2023-01-01') AND EXISTS(SELECT DEGREES(t54.col_2) AS col_1 FROM cte_1 AS t54 WHERE (t54.col_2 = ALL (SELECT LN(t55.c3) AS col_1 FROM t2 AS t55 ORDER BY t55.c13 ASC)))) AND sq29.col_1 IN (SELECT t57.col_1 AS col_1 FROM t3 AS t56 INNER JOIN cte_1 AS t57 ON (((t56.c14 LIKE '%sample_51') OR (t56.c1 <= t57.col_2)) AND t56.c4 BETWEEN 11 AND 55) CROSS JOIN t2 AS t58 ON (((t56.c12 = t58.c6) AND (t56.c6 < t58.c3)) OR t56.c14 IS NULL) WHERE (NOT t56.c5 BETWEEN '2023-01-01 00:00:00' AND '2023-12-31 23:59:59' AND NOT t56.c7 BETWEEN 26 AND 53)));
-- Mutated query. Expected result: cnt = 0, but slower.
WITH cte_1 AS (SELECT LOG(10, t2.c3) AS col_1, (t2.c1 + t2.c7) AS col_2 FROM t2 AS t1 INNER JOIN t3 AS t2 ON (((t1.c2 >= t2.c1) OR (t1.c2 >= 26)) AND (t1.c13 <> t2.c5)) LEFT JOIN (SELECT t5.c9 AS col_1, (SELECT DEGREES(t9.c4) AS col_1 FROM t3 AS t9 WHERE NOT (t9.c4 IS NULL) LIMIT 1) AS col_2, LAST_VALUE(t5.c7) OVER (ORDER BY t5.c5 DESC) AS col_3 FROM t1 AS t4 LEFT JOIN t2 AS t5 ON (((NOT t5.c2 BETWEEN 45 AND 87 AND t5.c7 IN (SELECT t6.c6 AS col_1 FROM t2 AS t6 INNER JOIN t3 AS t7 ON (NOT (t6.c3 IS NULL) AND (t6.c7 = t7.c12)) CROSS JOIN t1 AS t8 ON (t6.c15 <= t8.c4) WHERE ((NOT t6.c14 BETWEEN 47 AND 96 OR (t6.c1 >= 78)) OR (t6.c4 = 'sample_87')))) AND (t4.c4 = 98)) AND NOT t5.c1 BETWEEN 37 AND 46) WHERE ((t4.c4 <> 85) AND NOT t5.c8 IS NULL)) AS sq3 ON (((NOT t2.c10 IN (SELECT t10.c11 AS col_1 FROM t2 AS t10 RIGHT JOIN t3 AS t11 ON (((NOT t11.c14 IS NULL OR (t10.c14 > t11.c1)) OR t11.c5 IN (SELECT BIT_OR(t12.c1) AS col_1 FROM t3 AS t12 WHERE NOT (t12.c1 BETWEEN 48 AND 90))) AND EXISTS(SELECT t13.c5 AS col_1 FROM t3 AS t13 RIGHT JOIN t2 AS t14 ON (t14.c5 = '2023-01-01') WHERE (NOT REGEXP_LIKE(t14.c7, '[a-zA-Z0-9]{3,12}')))) CROSS JOIN (SELECT ACOS(t16.c1) AS col_3, STDDEV_POP(t16.c14) AS col_5 FROM t2 AS t16 WHERE (t16.c4 <> 'sample_40') GROUP BY ACOS(t16.c1), t16.c1, t16.c14) AS sq15 ON (NOT ((t10.c2 >= sq15.col_3)) OR (t10.c3 = sq15.col_5)) WHERE (((NOT t10.c11 LIKE '%sample_81') AND NOT t10.c3 BETWEEN 34 AND 82) AND (t11.c10 <> 'sample_41'))) AND (t2.c12 = sq3.col_3)) AND (t2.c1 > sq3.col_2)) AND (t2.c6 >= sq3.col_2)) ) SELECT COUNT(*) AS cnt FROM t2 AS t28 LEFT JOIN (SELECT t34.c4 AS col_1, 0 AS col_2, t31.c11 AS col_3, 0 AS col_4, NULL AS col_5 FROM t3 AS t30 CROSS JOIN t2 AS t31 ON EXISTS(SELECT STR_TO_DATE(sq32.col_2, sq32.col_2) AS col_1 FROM (SELECT CAST(t33.c1 AS DECIMAL(10, 2)) AS col_1, SCHEMA() AS col_2, STDDEV_SAMP(t33.c1) AS col_3, LENGTH(t33.c3) AS col_4 FROM t1 AS t33 WHERE (REGEXP_LIKE(t33.c6, '^sample_[0-9]+$')) GROUP BY CAST(t33.c1 AS DECIMAL(10, 2)), t33.c1, LENGTH(t33.c3), t33.c3 LIMIT 22) AS sq32 ORDER BY sq32.col_4 DESC) INNER JOIN t1 AS t34 ON (NOT ((t31.c13 = '2023-01-01')) AND EXISTS(SELECT t35.c5 AS col_1 FROM t2 AS t35 INNER JOIN (SELECT t37.c7 AS col_1, t37.c15 AS col_2, t37.c11 AS col_3, t37.c7 AS col_4 FROM t2 AS t37 WHERE (t37.c5 <> '2023-01-01')) AS sq36 ON NOT ((t35.c11 <> sq36.col_3)) CROSS JOIN cte_1 AS t38 ON (((t35.c3 BETWEEN 46 AND 89 AND (t35.c15 > t38.col_1)) AND t35.c11 IN (SELECT STDDEV_SAMP(t39.c4) AS col_1 FROM t1 AS t39 WHERE NOT t39.c1 BETWEEN 6 AND 25)) AND (t35.c14 > t38.col_1)) WHERE (t35.c2 BETWEEN 2 AND 10 AND sq36.col_1 IN (SELECT t40.c2 AS col_1 FROM t1 AS t40 CROSS JOIN t3 AS t41 ON (NOT t41.c12 IS NULL OR NOT t41.c15 BETWEEN 43 AND 68))) LIMIT 29))) AS sq29 ON (t28.c14 >= sq29.col_1) WHERE (sq29.col_1 IN (SELECT t57.col_1 AS col_1 FROM t3 AS t56 INNER JOIN cte_1 AS t57 ON (((t56.c14 LIKE '%sample_51') OR (t56.c1 <= t57.col_2)) AND t56.c4 BETWEEN 11 AND 55) CROSS JOIN t2 AS t58 ON (((t56.c12 = t58.c6) AND (t56.c6 < t58.c3)) OR t56.c14 IS NULL) WHERE (NOT t56.c5 BETWEEN '2023-01-01 00:00:00' AND '2023-12-31 23:59:59' AND NOT t56.c7 BETWEEN 26 AND 53)) AND ((t28.c13 = '2023-01-01') AND EXISTS(SELECT DEGREES(t54.col_2) AS col_1 FROM cte_1 AS t54 WHERE (t54.col_2 = ALL (SELECT LN(t55.c3) AS col_1 FROM t2 AS t55 ORDER BY t55.c13 ASC)))) AND sq29.col_1 IN (SELECT t57.col_1 AS col_1 FROM t3 AS t56 INNER JOIN cte_1 AS t57 ON (((t56.c14 LIKE '%sample_51') OR (t56.c1 <= t57.col_2)) AND t56.c4 BETWEEN 11 AND 55) CROSS JOIN t2 AS t58 ON (((t56.c12 = t58.c6) AND (t56.c6 < t58.c3)) OR t56.c14 IS NULL) WHERE (NOT t56.c5 BETWEEN '2023-01-01 00:00:00' AND '2023-12-31 23:59:59' AND NOT t56.c7 BETWEEN 26 AND 53)));
Description: This is a minimized reproducer for pair 2424. The mutated query only adds a logically redundant OR FALSE to the original predicate: WHERE P => WHERE P OR FALSE P OR FALSE is equivalent to P under SQL three-valued logic. Both queries return the same result, COUNT(*) = 0, but the OR FALSE version is consistently slower on this minimized setup. Final verification from the minimized SQL file, without ANALYZE TABLE: original median: 3.587 ms mutated median: 98.263 ms ratio original/mutated: 0.0365 slowdown: about 27x A second run with ANALYZE TABLE showed the same behavior: original median: 3.369 ms mutated median: 96.921 ms ratio original/mutated: 0.0348 slowdown: about 29x The schema is intentionally small: t1 and t3 are empty; t2 has only two rows; no indexes are required. Expected behavior: The optimizer should simplify P OR FALSE to P, or choose a plan with comparable performance. Actual behavior: The redundant OR FALSE predicate changes optimization enough to produce a stable execution-time regression. How to repeat: Run the following SQL on MySQL 9.5.0. DROP DATABASE IF EXISTS pair2424_min_repro; CREATE DATABASE pair2424_min_repro; USE pair2424_min_repro; CREATE TABLE t1(c1 INT,c2 CHAR(1),c3 CHAR(1),c4 INT,c5 DATE,c6 CHAR(1)); CREATE TABLE t2(c1 INT,c2 INT,c3 INT,c4 CHAR(1),c5 DATE,c6 CHAR(1),c7 CHAR(1),c8 CHAR(1),c9 CHAR(1),c10 CHAR(1),c11 CHAR(1),c13 DATE,c14 INT,c15 INT); CREATE TABLE t3(c1 INT,c2 INT,c3 INT,c4 INT,c5 DATE,c6 INT,c7 INT,c8 INT,c9 INT,c10 CHAR(1),c12 CHAR(1),c14 CHAR(1),c15 INT); INSERT INTO t2(c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c13,c14,c15) VALUES (1,10,2,'s','2026-01-01','s','1','x','y','v','a','2026-01-01',1,1), (2,20,3,'s','2026-01-01','s','2','x','y','v','a','2026-01-01',2,2); -- Original query. Expected result: cnt = 0. WITH cte_1 AS (SELECT LOG(10, t2.c3) AS col_1, (t2.c1 + t2.c7) AS col_2 FROM t2 AS t1 INNER JOIN t3 AS t2 ON (((t1.c2 >= t2.c1) OR (t1.c2 >= 26)) AND (t1.c13 <> t2.c5)) LEFT JOIN (SELECT t5.c9 AS col_1, (SELECT DEGREES(t9.c4) AS col_1 FROM t3 AS t9 WHERE NOT (t9.c4 IS NULL) LIMIT 1) AS col_2, LAST_VALUE(t5.c7) OVER (ORDER BY t5.c5 DESC) AS col_3 FROM t1 AS t4 LEFT JOIN t2 AS t5 ON (((NOT t5.c2 BETWEEN 45 AND 87 AND t5.c7 IN (SELECT t6.c6 AS col_1 FROM t2 AS t6 INNER JOIN t3 AS t7 ON (NOT (t6.c3 IS NULL) AND (t6.c7 = t7.c12)) CROSS JOIN t1 AS t8 ON (t6.c15 <= t8.c4) WHERE ((NOT t6.c14 BETWEEN 47 AND 96 OR (t6.c1 >= 78)) OR (t6.c4 = 'sample_87')))) AND (t4.c4 = 98)) AND NOT t5.c1 BETWEEN 37 AND 46) WHERE ((t4.c4 <> 85) AND NOT t5.c8 IS NULL)) AS sq3 ON (((NOT t2.c10 IN (SELECT t10.c11 AS col_1 FROM t2 AS t10 RIGHT JOIN t3 AS t11 ON (((NOT t11.c14 IS NULL OR (t10.c14 > t11.c1)) OR t11.c5 IN (SELECT BIT_OR(t12.c1) AS col_1 FROM t3 AS t12 WHERE NOT (t12.c1 BETWEEN 48 AND 90))) AND EXISTS(SELECT t13.c5 AS col_1 FROM t3 AS t13 RIGHT JOIN t2 AS t14 ON (t14.c5 = '2023-01-01') WHERE (NOT REGEXP_LIKE(t14.c7, '[a-zA-Z0-9]{3,12}')))) CROSS JOIN (SELECT ACOS(t16.c1) AS col_3, STDDEV_POP(t16.c14) AS col_5 FROM t2 AS t16 WHERE (t16.c4 <> 'sample_40') GROUP BY ACOS(t16.c1), t16.c1, t16.c14) AS sq15 ON (NOT ((t10.c2 >= sq15.col_3)) OR (t10.c3 = sq15.col_5)) WHERE (((NOT t10.c11 LIKE '%sample_81') AND NOT t10.c3 BETWEEN 34 AND 82) AND (t11.c10 <> 'sample_41'))) AND (t2.c12 = sq3.col_3)) AND (t2.c1 > sq3.col_2)) AND (t2.c6 >= sq3.col_2)) ) SELECT COUNT(*) AS cnt FROM t2 AS t28 LEFT JOIN (SELECT t34.c4 AS col_1, 0 AS col_2, t31.c11 AS col_3, 0 AS col_4, NULL AS col_5 FROM t3 AS t30 CROSS JOIN t2 AS t31 ON EXISTS(SELECT STR_TO_DATE(sq32.col_2, sq32.col_2) AS col_1 FROM (SELECT CAST(t33.c1 AS DECIMAL(10, 2)) AS col_1, SCHEMA() AS col_2, STDDEV_SAMP(t33.c1) AS col_3, LENGTH(t33.c3) AS col_4 FROM t1 AS t33 WHERE (REGEXP_LIKE(t33.c6, '^sample_[0-9]+$')) GROUP BY CAST(t33.c1 AS DECIMAL(10, 2)), t33.c1, LENGTH(t33.c3), t33.c3 LIMIT 22) AS sq32 ORDER BY sq32.col_4 DESC) INNER JOIN t1 AS t34 ON (NOT ((t31.c13 = '2023-01-01')) AND EXISTS(SELECT t35.c5 AS col_1 FROM t2 AS t35 INNER JOIN (SELECT t37.c7 AS col_1, t37.c15 AS col_2, t37.c11 AS col_3, t37.c7 AS col_4 FROM t2 AS t37 WHERE (t37.c5 <> '2023-01-01')) AS sq36 ON NOT ((t35.c11 <> sq36.col_3)) CROSS JOIN cte_1 AS t38 ON (((t35.c3 BETWEEN 46 AND 89 AND (t35.c15 > t38.col_1)) AND t35.c11 IN (SELECT STDDEV_SAMP(t39.c4) AS col_1 FROM t1 AS t39 WHERE NOT t39.c1 BETWEEN 6 AND 25)) AND (t35.c14 > t38.col_1)) WHERE (t35.c2 BETWEEN 2 AND 10 AND sq36.col_1 IN (SELECT t40.c2 AS col_1 FROM t1 AS t40 CROSS JOIN t3 AS t41 ON (NOT t41.c12 IS NULL OR NOT t41.c15 BETWEEN 43 AND 68))) LIMIT 29))) AS sq29 ON (t28.c14 >= sq29.col_1) WHERE (((t28.c13 = '2023-01-01') AND EXISTS(SELECT DEGREES(t54.col_2) AS col_1 FROM cte_1 AS t54 WHERE (t54.col_2 = ALL (SELECT LN(t55.c3) AS col_1 FROM t2 AS t55 ORDER BY t55.c13 ASC)))) AND sq29.col_1 IN (SELECT t57.col_1 AS col_1 FROM t3 AS t56 INNER JOIN cte_1 AS t57 ON (((t56.c14 LIKE '%sample_51') OR (t56.c1 <= t57.col_2)) AND t56.c4 BETWEEN 11 AND 55) CROSS JOIN t2 AS t58 ON (((t56.c12 = t58.c6) AND (t56.c6 < t58.c3)) OR t56.c14 IS NULL) WHERE (NOT t56.c5 BETWEEN '2023-01-01 00:00:00' AND '2023-12-31 23:59:59' AND NOT t56.c7 BETWEEN 26 AND 53))); -- Mutated query. Expected result: cnt = 0, but slower. WITH cte_1 AS (SELECT LOG(10, t2.c3) AS col_1, (t2.c1 + t2.c7) AS col_2 FROM t2 AS t1 INNER JOIN t3 AS t2 ON (((t1.c2 >= t2.c1) OR (t1.c2 >= 26)) AND (t1.c13 <> t2.c5)) LEFT JOIN (SELECT t5.c9 AS col_1, (SELECT DEGREES(t9.c4) AS col_1 FROM t3 AS t9 WHERE NOT (t9.c4 IS NULL) LIMIT 1) AS col_2, LAST_VALUE(t5.c7) OVER (ORDER BY t5.c5 DESC) AS col_3 FROM t1 AS t4 LEFT JOIN t2 AS t5 ON (((NOT t5.c2 BETWEEN 45 AND 87 AND t5.c7 IN (SELECT t6.c6 AS col_1 FROM t2 AS t6 INNER JOIN t3 AS t7 ON (NOT (t6.c3 IS NULL) AND (t6.c7 = t7.c12)) CROSS JOIN t1 AS t8 ON (t6.c15 <= t8.c4) WHERE ((NOT t6.c14 BETWEEN 47 AND 96 OR (t6.c1 >= 78)) OR (t6.c4 = 'sample_87')))) AND (t4.c4 = 98)) AND NOT t5.c1 BETWEEN 37 AND 46) WHERE ((t4.c4 <> 85) AND NOT t5.c8 IS NULL)) AS sq3 ON (((NOT t2.c10 IN (SELECT t10.c11 AS col_1 FROM t2 AS t10 RIGHT JOIN t3 AS t11 ON (((NOT t11.c14 IS NULL OR (t10.c14 > t11.c1)) OR t11.c5 IN (SELECT BIT_OR(t12.c1) AS col_1 FROM t3 AS t12 WHERE NOT (t12.c1 BETWEEN 48 AND 90))) AND EXISTS(SELECT t13.c5 AS col_1 FROM t3 AS t13 RIGHT JOIN t2 AS t14 ON (t14.c5 = '2023-01-01') WHERE (NOT REGEXP_LIKE(t14.c7, '[a-zA-Z0-9]{3,12}')))) CROSS JOIN (SELECT ACOS(t16.c1) AS col_3, STDDEV_POP(t16.c14) AS col_5 FROM t2 AS t16 WHERE (t16.c4 <> 'sample_40') GROUP BY ACOS(t16.c1), t16.c1, t16.c14) AS sq15 ON (NOT ((t10.c2 >= sq15.col_3)) OR (t10.c3 = sq15.col_5)) WHERE (((NOT t10.c11 LIKE '%sample_81') AND NOT t10.c3 BETWEEN 34 AND 82) AND (t11.c10 <> 'sample_41'))) AND (t2.c12 = sq3.col_3)) AND (t2.c1 > sq3.col_2)) AND (t2.c6 >= sq3.col_2)) ) SELECT COUNT(*) AS cnt FROM t2 AS t28 LEFT JOIN (SELECT t34.c4 AS col_1, 0 AS col_2, t31.c11 AS col_3, 0 AS col_4, NULL AS col_5 FROM t3 AS t30 CROSS JOIN t2 AS t31 ON EXISTS(SELECT STR_TO_DATE(sq32.col_2, sq32.col_2) AS col_1 FROM (SELECT CAST(t33.c1 AS DECIMAL(10, 2)) AS col_1, SCHEMA() AS col_2, STDDEV_SAMP(t33.c1) AS col_3, LENGTH(t33.c3) AS col_4 FROM t1 AS t33 WHERE (REGEXP_LIKE(t33.c6, '^sample_[0-9]+$')) GROUP BY CAST(t33.c1 AS DECIMAL(10, 2)), t33.c1, LENGTH(t33.c3), t33.c3 LIMIT 22) AS sq32 ORDER BY sq32.col_4 DESC) INNER JOIN t1 AS t34 ON (NOT ((t31.c13 = '2023-01-01')) AND EXISTS(SELECT t35.c5 AS col_1 FROM t2 AS t35 INNER JOIN (SELECT t37.c7 AS col_1, t37.c15 AS col_2, t37.c11 AS col_3, t37.c7 AS col_4 FROM t2 AS t37 WHERE (t37.c5 <> '2023-01-01')) AS sq36 ON NOT ((t35.c11 <> sq36.col_3)) CROSS JOIN cte_1 AS t38 ON (((t35.c3 BETWEEN 46 AND 89 AND (t35.c15 > t38.col_1)) AND t35.c11 IN (SELECT STDDEV_SAMP(t39.c4) AS col_1 FROM t1 AS t39 WHERE NOT t39.c1 BETWEEN 6 AND 25)) AND (t35.c14 > t38.col_1)) WHERE (t35.c2 BETWEEN 2 AND 10 AND sq36.col_1 IN (SELECT t40.c2 AS col_1 FROM t1 AS t40 CROSS JOIN t3 AS t41 ON (NOT t41.c12 IS NULL OR NOT t41.c15 BETWEEN 43 AND 68))) LIMIT 29))) AS sq29 ON (t28.c14 >= sq29.col_1) WHERE (sq29.col_1 IN (SELECT t57.col_1 AS col_1 FROM t3 AS t56 INNER JOIN cte_1 AS t57 ON (((t56.c14 LIKE '%sample_51') OR (t56.c1 <= t57.col_2)) AND t56.c4 BETWEEN 11 AND 55) CROSS JOIN t2 AS t58 ON (((t56.c12 = t58.c6) AND (t56.c6 < t58.c3)) OR t56.c14 IS NULL) WHERE (NOT t56.c5 BETWEEN '2023-01-01 00:00:00' AND '2023-12-31 23:59:59' AND NOT t56.c7 BETWEEN 26 AND 53)) AND ((t28.c13 = '2023-01-01') AND EXISTS(SELECT DEGREES(t54.col_2) AS col_1 FROM cte_1 AS t54 WHERE (t54.col_2 = ALL (SELECT LN(t55.c3) AS col_1 FROM t2 AS t55 ORDER BY t55.c13 ASC)))) AND sq29.col_1 IN (SELECT t57.col_1 AS col_1 FROM t3 AS t56 INNER JOIN cte_1 AS t57 ON (((t56.c14 LIKE '%sample_51') OR (t56.c1 <= t57.col_2)) AND t56.c4 BETWEEN 11 AND 55) CROSS JOIN t2 AS t58 ON (((t56.c12 = t58.c6) AND (t56.c6 < t58.c3)) OR t56.c14 IS NULL) WHERE (NOT t56.c5 BETWEEN '2023-01-01 00:00:00' AND '2023-12-31 23:59:59' AND NOT t56.c7 BETWEEN 26 AND 53)));