Wrong result with partial_match_rowid_merge , NOT IN , NULLs
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
MariaDB |
Fix Released
|
Critical
|
Timour Katchaounov |
Bug Description
The following query:
SELECT *
FROM t1
WHERE (t1.a, t1.b) NOT IN (
SELECT t2.a, t2.b
FROM t2
);
returns no rows when executed with partial_
EXPLAIN:
id select_type table type possible_keys key key_len ref rows Extra
1 PRIMARY t1 ALL NULL NULL NULL NULL 2 Using where
2 SUBQUERY t2 ALL NULL NULL NULL NULL 2
minimal switch: materialization
full switch: index_merge=
reproducible on both maria-5.3 and maria-5.3-mwl89
revision-id: <email address hidden>
date: 2011-11-20 04:53:07 -0800
build-date: 2011-11-22 10:41:56 +0200
revno: 3298
branch-nick: maria-5.3
test case:
SET SESSION optimizer_
CREATE TABLE t1 ( a int, b int);
INSERT INTO t1 VALUES (0,NULL),(0,NULL);
CREATE TABLE t2 (a int, b int);
INSERT INTO t2 VALUES (2,2),(2,2);
SELECT *
FROM t1
WHERE (t1.a, t1.b) NOT IN (
SELECT t2.a, t2.b
FROM t2
);
Related branches
Changed in maria: | |
milestone: | none → 5.3 |
assignee: | nobody → Timour Katchaounov (timour) |
Changed in maria: | |
importance: | Undecided → Critical |
status: | New → In Progress |
Changed in maria: | |
status: | In Progress → Fix Committed |
Changed in maria: | |
status: | Fix Committed → Fix Released |