Crash on a query whose where condition contains CASE expression
Bug #1001510 reported by
Igor Babaev
This bug affects 1 person
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
MariaDB |
Fix Released
|
Critical
|
Oleksandr "Sanja" Byelkin |
Bug Description
The following simple test case causes a crash of the server in MariaDB 5.2/5.3/5.5:
CREATE TABLE t1(a YEAR);
SELECT 1 FROM t1 WHERE a=1 AND CASE 1 WHEN a THEN 1 ELSE 1 END;
DROP TABLE t1;
See also bug #57135 from bugs.mysql.com
This bug is similar to LP bug #1001505.
Changed in maria: | |
status: | New → Confirmed |
importance: | Undecided → Critical |
assignee: | nobody → Oleksandr "Sanja" Byelkin (sanja-byelkin) |
milestone: | none → 5.2 |
tags: | added: assertion optimizer |
Changed in maria: | |
status: | Confirmed → In Progress |
Changed in maria: | |
status: | In Progress → Fix Committed |
Changed in maria: | |
status: | Fix Committed → Fix Released |
To post a comment you must log in.
It is somehow connected to qualities propagation of zerofield so it can't be fixed fast by me... Will be postponed after dynamic columns.