[MDEV-2606] LP:1001510 - Crash on a query whose where condition contains CASE expression Created: 2012-05-19  Updated: 2015-02-02  Resolved: 2012-10-04

Status: Closed
Project: MariaDB Server
Component/s: None
Affects Version/s: None
Fix Version/s: None

Type: Bug Priority: Critical
Reporter: Igor Babaev Assignee: Oleksandr Byelkin
Resolution: Fixed Votes: 0
Labels: Launchpad

Attachments: XML File LPexportBug1001510.xml    

 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.



 Comments   
Comment by Oleksandr Byelkin [ 2012-05-23 ]

Re: Crash on a query whose where condition contains CASE expression
It is somehow connected to qualities propagation of zerofield so it can't be fixed fast by me... Will be postponed after dynamic columns.

Comment by Rasmus Johansson (Inactive) [ 2012-06-26 ]

Launchpad bug id: 1001510

Generated at Thu Feb 08 06:42:59 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.