Re: [Maria-developers] Fwd: [Commits] Rev 2901: BNLH algorithm always used a full table scan over the joined table in file:///home/igor/maria/maria-5.3-mwl128-hashrange/

2011-03-02 Thread Sergey Petrunya
Hello Igor, Here's the promised proof of deadcode: On Fri, Feb 11, 2011 at 08:49:37PM -0800, Igor Babaev wrote: === modified file 'sql/sql_select.cc' --- a/sql/sql_select.cc 2011-02-06 04:57:03 + +++ b/sql/sql_select.cc 2011-02-12 04:41:22 + @@ -8419,6 +8438,11 @@

Re: [Maria-developers] Fwd: [Commits] Rev 2901: BNLH algorithm always used a full table scan over the joined table in file:///home/igor/maria/maria-5.3-mwl128-hashrange/

2011-02-22 Thread Sergey Petrunya
On Mon, Feb 21, 2011 at 03:20:13PM -0800, Igor Babaev wrote: === modified file 'sql/sql_select.cc' --- a/sql/sql_select.cc2011-02-06 04:57:03 + +++ b/sql/sql_select.cc2011-02-12 04:41:22 + ... @@ -8419,6 +8438,11 @@ sort_by_tab-type= JT_ALL;

Re: [Maria-developers] Fwd: [Commits] Rev 2901: BNLH algorithm always used a full table scan over the joined table in file:///home/igor/maria/maria-5.3-mwl128-hashrange/

2011-02-21 Thread Sergey Petrunya
On Fri, Feb 11, 2011 at 08:49:37PM -0800, Igor Babaev wrote: Hi Sergey, Please review this patch that fixes a defect of the current implementation of the mwl #128 that never couples hash join with range/index_merge scans. The patch also adds prefix #hash# to the names of the used hash