Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
5.5, 10.0, 10.1, 10.2
-
None
Description
SELECT COUNT( alias1.`col_float_unsigned_null` ) AS field1 FROM ( ( SELECT SQ1_alias1.* FROM `view_table100_aria_0` AS SQ1_alias1 WHERE SQ1_alias1.`col_int_unsigned_not_null` < 6 ) AS alias1, `table20_aria` AS alias2 ) WHERE alias1.`col_int_unsigned_not_null` NOT IN ( SELECT SQ2_alias1.`col_int_null` AS SQ2_ifield1 FROM ( `view_table20_myisam_0` AS SQ2_alias1, `table1_innodb` AS SQ2_alias2 ) WHERE alias2.`col_int_unsigned_not_null` IN ( ( SELECT C_SQ1_alias1.`col_int_unsigned_null` AS C_SQ1_ifield1 FROM `table20_innodb` AS C_SQ1_alias1 GROUP BY C_SQ1_ifield1 ) ) AND SQ2_alias2.`col_char_2_null` < SQ2_alias1.`col_varchar_64_null` ) HAVING field1 >= 4 ORDER BY field1; |
field1
|
700
|
SET SESSION optimizer_switch = REPLACE( @@optimizer_switch, "=on", "=off" ); |
SET SESSION optimizer_switch = "in_to_exists=on"; |
SELECT COUNT( alias1.`col_float_unsigned_null` ) AS field1 FROM ( ( SELECT SQ1_alias1.* FROM `view_table100_aria_0` AS SQ1_alias1 WHERE SQ1_alias1.`col_int_unsigned_not_null` < 6 ) AS alias1, `table20_aria` AS alias2 ) WHERE alias1.`col_int_unsigned_not_null` NOT IN ( SELECT SQ2_alias1.`col_int_null` AS SQ2_ifield1 FROM ( `view_table20_myisam_0` AS SQ2_alias1, `table1_innodb` AS SQ2_alias2 ) WHERE alias2.`col_int_unsigned_not_null` IN ( ( SELECT C_SQ1_alias1.`col_int_unsigned_null` AS C_SQ1_ifield1 FROM `table20_innodb` AS C_SQ1_alias1 GROUP BY C_SQ1_ifield1 ) ) AND SQ2_alias2.`col_char_2_null` < SQ2_alias1.`col_varchar_64_null` ) HAVING field1 >= 4 ORDER BY field1; |
field1
|
525
|