Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Cannot Reproduce
-
5.5, 10.1
-
None
Description
Debug |
SELECT COUNT(*) FROM ( ( SELECT DISTINCT SQ1_alias1.* FROM ( table1000_aria_latin1 AS SQ1_alias1 INNER JOIN view_table10_innodb_latin1_0 AS SQ1_alias2 ON (SQ1_alias2.`col_smallint_null` = SQ1_alias1.`col_tinyint_null` ) ) WHERE SQ1_alias1.`col_tinyint_unsigned_not_null` <> 0 ) AS alias1, `table20_aria_utf8` AS alias2 ) WHERE alias1.`col_bit_null` IN ( SELECT SQ2_alias1.`col_bigint_not_null` AS SQ2_ifield1 FROM table20_myisam_latin1 AS SQ2_alias1 ) |
;
|
COUNT(*) |
0
|
non-debug |
SELECT COUNT(*) FROM ( ( SELECT DISTINCT SQ1_alias1.* FROM ( table1000_aria_latin1 AS SQ1_alias1 INNER JOIN view_table10_innodb_latin1_0 AS SQ1_alias2 ON (SQ1_alias2.`col_smallint_null` = SQ1_alias1.`col_tinyint_null` ) ) WHERE SQ1_alias1.`col_tinyint_unsigned_not_null` <> 0 ) AS alias1, `table20_aria_utf8` AS alias2 ) WHERE alias1.`col_bit_null` IN ( SELECT SQ2_alias1.`col_bigint_not_null` AS SQ2_ifield1 FROM table20_myisam_latin1 AS SQ2_alias1 ) |
;
|
COUNT(*) |
1
|
15f9931f6d2b0eb4006fdc42072c2905fd67c1aa