At file:///home/psergey/dev/maria-5.3-subqueries-r7/ ------------------------------------------------------------ revno: 2763 revision-id: psergey@askmonty.org-20100220082329-9esvom4n6mpgeqvk parent: psergey@askmonty.org-20100217225459-4mum80lxuu3cwmjz committer: Sergey Petrunya <psergey@askmonty.org> branch nick: maria-5.3-subqueries-r7 timestamp: Sat 2010-02-20 11:23:29 +0300 message: Fix Item_subselect::update_used_tables() and fix_after_pullout() to work with prepared statements: re-collect list of upper refs on every PS re-execution. === modified file 'sql/item_subselect.cc' --- a/sql/item_subselect.cc 2010-02-17 21:59:41 +0000 +++ b/sql/item_subselect.cc 2010-02-20 08:23:29 +0000 @@ -167,6 +167,11 @@ { done_first_fix_fields= TRUE; inside_first_fix_fields= TRUE; + upper_refs.empty(); + /* + psergey-todo: remove _first_fix_fields calls, we need changes on every + execution + */ } eliminated= FALSE; @@ -181,6 +186,8 @@ changed= 1; inside_first_fix_fields= FALSE; + done_first_fix_fields= FALSE; + if (!res) { // all transformation is done (used by prepared statements)