Crash when creating PS for a query with subquery in WHERE
Bug #992380 reported by
Igor Babaev
This bug affects 1 person
| Affects | Status | Importance | Assigned to | Milestone | |
|---|---|---|---|---|---|
| MariaDB |
Fix Released
|
High
|
Oleksandr "Sanja" Byelkin | ||
Bug Description
The following sequence of commands causes a crash of the server in MariaDB 5.2:
CREATE TABLE t1 (a INT);
PREPARE s FROM "SELECT 1 FROM t1 WHERE 1 < ALL (SELECT @:= (1 IN (SELECT 1 FROM t1)) FROM t1)";
(This is also bug#13012483 reported for mysql-5.1.)
| Changed in maria: | |
| importance: | Undecided → High |
| status: | New → Confirmed |
| milestone: | none → 5.2 |
| assignee: | nobody → Oleksandr "Sanja" Byelkin (sanja-byelkin) |
| tags: | added: assertion optimizer |
Revision history for this message
| Oleksandr "Sanja" Byelkin (sanja-byelkin) wrote | #1 |
| Changed in maria: | |
| status: | Confirmed → In Progress |
| status: | In Progress → Fix Committed |
| Changed in maria: | |
| status: | Fix Committed → Fix Released |
To post a comment you must log in.
It is not repeatable on 5.3