Crash on a query over a table with ZEROFILL column whose where condition contains IN predicate using this column

Bug #1001505 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 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)

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