[Commits] Rev 3760: MDEV-5470: Cost-based subquery item pushdown must take into account semi-joins in file:///home/psergey/dev2/10.0-mdev83/

Sergey Petrunya psergey at askmonty.org
Sat Dec 28 00:02:16 EET 2013


At file:///home/psergey/dev2/10.0-mdev83/

------------------------------------------------------------
revno: 3760
revision-id: psergey at askmonty.org-20131227220214-o3qu14qw7iwavlc5
parent: psergey at askmonty.org-20131220142647-dp3e9n1itvi4wti5
committer: Sergey Petrunya <psergey at askmonty.org>
branch nick: 10.0-mdev83
timestamp: Sat 2013-12-28 02:02:14 +0400
message:
  MDEV-5470: Cost-based subquery item pushdown must take into account semi-joins
  - find_last_tab_for_dynamic_cond() should return the JOIN_TAB that's just 
    after the last allowed join tab.
=== modified file 'sql/sql_select.cc'
--- a/sql/sql_select.cc	2013-12-20 14:26:47 +0000
+++ b/sql/sql_select.cc	2013-12-27 22:02:14 +0000
@@ -24746,7 +24746,7 @@ JOIN_TAB *find_last_tab_for_dynamic_cond
         last_tab= sj_nest->sj_strategys_join_tab;
     }
   }
-  return join->join_tab + last_tab;
+  return join->join_tab + last_tab + 1;
 }
 
 



More information about the commits mailing list