Crash on a query whose where condition contains CASE expression

Bug #1001510 reported by Igor Babaev on 2012-05-19
6
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
Elena Stepanova (elenst) on 2012-05-20
tags: added: assertion optimizer

It is somehow connected to qualities propagation of zerofield so it can't be fixed fast by me... Will be postponed after dynamic columns.

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.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers