jira.dmp.gz
[MDEV-14417] Incoherent result subqueries & materialization switch Created: 2017-11-16 Updated: 2017-11-16 Resolved: 2017-11-16 |
|
| Status: | Closed |
| Project: | MariaDB Server |
| Component/s: | Data Manipulation - Subquery |
| Affects Version/s: | 10.2.10 |
| Fix Version/s: | 10.2.11 |
| Type: | Bug | Priority: | Major |
| Reporter: | Roberto Ghidini | Assignee: | Unassigned |
| Resolution: | Fixed | Votes: | 0 |
| Labels: | None | ||
| Environment: |
Linux any |
||
| Attachments: |
jira.dmp.gz
|
| Description |
|
Create a db from the attached dump file, the following select gives a wrong result MariaDB [jira]> select fkey from t1 where fkey in (select distinct f4 from t2 where f1=147 and f5='S') order by fkey;
------
------ If I switch off materialization adding the following line to the my.cnf file optimizer_switch='materialization=off' the result is correct ------
------
------ Thanks |
| Comments |
| Comment by Alice Sherepa [ 2017-11-16 ] |
|
Thanks for the report! |