• unknown's avatar
    BUG#20492: Subsequent calls to stored procedure yield incorrect result · ee09b41e
    unknown authored
               if join is used
    
    For procedures with selects that use complicated joins with ON expression
    re-execution could erroneously ignore this ON expression, giving
    incorrect result.
    
    The problem was that optimized ON expression wasn't saved for
    re-execution.  The solution is to properly save it.
    
    
    mysql-test/r/sp.result:
      Add result for bug#20492: Subsequent calls to stored procedure yield
      incorrect result if join is used.
    mysql-test/t/sp.test:
      Add test case for bug#20492: Subsequent calls to stored procedure yield
      incorrect result if join is used.
    sql/sql_select.cc:
      Save modified ON expression for re-execution.
    ee09b41e
sp.result 123 KB