Comment 3 for bug 611704
Revision history for this message
| Philip Stoev (pstoev-askmonty) wrote Re: Crash in replace_where_subcondition on executing a nested subquery as a stored procedure or prepared statement | #3 |
Still repeatable with maria-5.3 . simplified test case:
CREATE TABLE t1 ( f1 int(11), f3 varchar(1), f4 varchar(1)) ;
CREATE TABLE t2 ( f2 int(11), KEY (f2));
CREATE TABLE t3 ( f4 varchar(1)) ;
PREPARE st1 FROM '
SELECT *
FROM t1
STRAIGHT_JOIN ( t2 STRAIGHT_JOIN t3 ON t2.f2 )
ON (t1.f3) IN ( SELECT f4 FROM t1 )
';
EXECUTE st1;