List:Commits« Previous MessageNext Message »
From:hery.ramilison Date:March 29 2012 6:30pm
Subject:bzr push into mysql-5.5 branch (hery.ramilison:3775 to 3776)
View as plain text  
 3776 Hery Ramilison	2012-03-29
      Starting 5.5.23 build

    modified:
      VERSION
 3775 Tor Didriksen	2012-03-29 {clone-5.5.23-build}
      Patch for Bug#13805127: Stored program cache produces wrong result in same THD.
      
      Background:
      
        - as described in MySQL Internals Prepared Stored
          (http://forge.mysql.com/wiki/MySQL_Internals_Prepared_Stored),
          the Optimizer sometimes does destructive changes to the parsed
          LEX-object (Item-tree), which makes it impossible to re-use
          that tree for PS/SP re-execution.
      
        - in order to be able to re-use the Item-tree, the destructive
          changes are remembered and rolled back after the statement execution.
      
      The problem, discovered by this bug, was that the objects representing
      GROUP-BY clause did not restored after query execution. So, the GROUP-BY
      part of the statement could not be properly re-initialized for re-execution
      after destructive changes.
      
      Those objects do not take part in the Item-tree, so they can not be saved
      using the approach for Item-tree.
      
      The fix is as follows:
      
        - introduce a new array in st_select_lex to store the original
          ORDER pointers, representing the GROUP-BY clause;
      
        - Initialize this array in fix_prepare_information().
      
        - restore the list of GROUP-BY items in reinit_stmt_before_use().

    added:
      sql/mem_root_array.h
    modified:
      mysql-test/r/ps.result
      mysql-test/r/sp.result
      mysql-test/t/ps.test
      mysql-test/t/sp.test
      sql/sql_lex.cc
      sql/sql_lex.h
      sql/sql_prepare.cc
=== modified file 'VERSION'
--- a/VERSION	2012-03-20 21:27:49 +0000
+++ b/VERSION	2012-03-29 18:29:14 +0000
@@ -1,4 +1,4 @@
 MYSQL_VERSION_MAJOR=5
 MYSQL_VERSION_MINOR=5
-MYSQL_VERSION_PATCH=23
+MYSQL_VERSION_PATCH=24
 MYSQL_VERSION_EXTRA=

No bundle (reason: useless for push emails).
Thread
bzr push into mysql-5.5 branch (hery.ramilison:3775 to 3776) hery.ramilison29 Mar