Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
5.3.12
-
None
-
None
Description
The following query over the 'world' database incorrectly produces wrong result
of 1 row instead of an empty result:
create database world;
use world;
source mysql-test/include/world_schema.inc
source mysql-test/include/world.inc
set @@optimizer_switch='materialization=on,semijoin=on';
MariaDB [world]> select * from CountryLanguage where (Language, Country) IN (SELECT City.Name, Country.Code FROM City LEFT JOIN Country ON (Country = Code and Code > 'LLL'));
---------------------------
| Country | Language | Percentage |
---------------------------
| KEN | Meru | 5.5 |
---------------------------
1 row in set (0.22 sec)
set @@optimizer_switch='materialization=on,semijoin=off';
=> empty result;