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
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 |
| tags: | added: assertion optimizer |
Revision history for this message
| Oleksandr "Sanja" Byelkin (sanja-byelkin) wrote | #1 |
| 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.