Crash when creating PS for a query with subquery in WHERE

Bug #992380 reported by Igor Babaev on 2012-05-01
6
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)
Elena Stepanova (elenst) on 2012-05-10
tags: added: assertion optimizer

It is not repeatable on 5.3

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.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers