• Mithun C Y's avatar
    Bug #21350175: SUBQUERIES IN PROCEDURE CLAUSE OF SELECT STATEMENT CAUSES SERVER FAILURES. · 557a57f3
    Mithun C Y authored
    Analysis :
    ==========
    During JOIN::prepare of sub-query which creates the
    derived tables we call setup_procedure. Here we call
    fix_fields for parameters of procedure clause. Calling
    setup_procedure at this point may cause issue. If
    sub-query is one of parameter being fixed it might
    lead to complicated dependencies on derived tables
    being prepared.
    
    SOLUTION :
    ==========
    In 5.6 with WL#6242, we have made procedure clause
    parameters can only be NUM, so sub-queries are not
    allowed as parameters. So in 5.5 we can block
    sub-queries in procedure clause parameters.
    This eliminates above conflicting dependencies.
    557a57f3
subselect.test 131 KB