[MDEV-3663] LP:1001505 - Crash on a query over a table with ZEROFILL column whose where condition contains IN predicate using this column 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 LPexportBug1001505.xml    

 Description   

The following simple test case causes an assertion abort in MariaDB 5.2/5.3/5.5

CREATE TABLE t1(a INT ZEROFILL);
SELECT 1 FROM t1 WHERE t1.a IN (1, t1.a) AND t1.a=2;
DROP TABLE t1;

(see also bug #57692 from bugs.mysql.com)

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

Re: Crash on a query over a table with ZEROFILL column whose where condition contains IN predicate using this column
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: 1001505

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