Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.4(EOL)
Description
--- a/mysql-test/main/subselect_exists2in_costmat.test
|
+++ b/mysql-test/main/subselect_exists2in_costmat.test
|
@@ -65,19 +65,24 @@ set @@optimizer_switch = 'exists_to_in=on,in_to_exists=on,semijoin=on,materializ
|
-- echo Q1.1m:
|
-- echo MATERIALIZATION: there are too many rows in the outer query
|
-- echo to be looked up in the inner table.
|
-EXPLAIN
|
+EXPLAIN EXTENDED
|
SELECT Name FROM Country
|
WHERE (EXISTS (select 1 from City where City.Population > 100000 and
|
Code = Country) OR
|
Name LIKE 'L%') AND
|
surfacearea > 1000000;
|
|
+
|
+set optimizer_trace=1;
|
+
|
SELECT Name FROM Country
|
WHERE (EXISTS (select 1 from City where City.Population > 100000 and
|
Code = Country) OR
|
Name LIKE 'L%') AND
|
surfacearea > 1000000;
|
|
+select * from information_schema.optimizer_trace;
|
+
|
drop database world;
|
|
set optimizer_switch=@subselect_mat_cost;
|
Attachments
Issue Links
- relates to
-
MDEV-21095 Index condition push down is not reflected in optimizer trace
- Closed
-
MDEV-29997 Partition Pruning not included in optimizer tracing
- Closed