Comment 4 for bug 595305

Revision history for this message
PrafullaT (prafulla-t) wrote :

Simpler query to reproduce on above-mentioned tables:

select outr . `col_text`
from bb as outr
where outr . `col_bigint_key` IN (SELECT innr . `pk` AS y
                                   FROM bb AS innr
                                   WHERE
       innr . `col_bigint_key` > innr . `col_int`)
       AND outr . `col_bigint_key` = 9;