Re: [Maria-developers] 5.3: optimizer status update andtest requests

2011-12-01 Thread Philip Stoev
REQUEST: I'm not exactly sure what to do with @@debug_optimizer_prefer_join_prefix, we both should think about how to use it (take a query, and try forcing all possible join orders?). At least, it should be easier to repeat the bugs now. Elena, The reason I asked for this feature is becaus

Re: [Maria-developers] 5.3: optimizer status update and test requests

2011-12-01 Thread Sergei Petrunia
On Thu, Dec 01, 2011 at 10:29:44PM +0400, Sergei Petrunia wrote: > To be continued... Continued: == Optimizer debugging == We have discussed something like this in Athens and even before it. I've just implemented it, please take a look at http://kb.askmonty.org/en/mariadb-53-optimizer-debugg

[Maria-developers] 5.3: optimizer status update and test requests

2011-12-01 Thread Sergei Petrunia
Hi Elena, A quick update on what has been happening in 5.3 optimizer recently. The text is FYI, requests for QA are marked with 'REQUEST': == Semi-joins: no non-PS crashes, optimizations refactoring == When I was fixing BUG#887468, I have made some refactorings to semi-join optimization code an

Re: [Maria-developers] Proposal: change SUBQUERY to MATERIALIZE

2011-12-01 Thread Michael Widenius
Hi! > "Sergei" == Sergei Petrunia writes: Sergei> Reply-To: Sergei> Hello, Sergei> I think we have already discussed this before (multiple times), and the Sergei> idea was received with some conditional approval of the idea. Nothing has Sergei> been done or put to paper, though, so now

Re: [Maria-developers] Proposal: change SUBQUERY to MATERIALIZE

2011-12-01 Thread Sergei Petrunia
On Thu, Dec 01, 2011 at 01:12:00PM +0200, Timour Katchaounov wrote: > Ok, I agree to change to MATERIALIZED (not MATERIALIZE). > Who will do the change? > > In addition, in the EXTRA field there should be info > which materialization is used. If I am not mistaken, > there are three variants: > - SJ

Re: [Maria-developers] Proposal: change SUBQUERY to MATERIALIZE

2011-12-01 Thread Sergei Petrunia
On Thu, Dec 01, 2011 at 01:12:00PM +0200, Timour Katchaounov wrote: > Ok, I agree to change to MATERIALIZED (not MATERIALIZE). > Who will do the change? I could make it after I'm done with my current crashing bug. > In addition, in the EXTRA field there should be info > which materialization is u

[Maria-developers] Proposal: change SUBQUERY to MATERIALIZE

2011-12-01 Thread Sergei Petrunia
Reply-To: Hello, I think we have already discussed this before (multiple times), and the idea was received with some conditional approval of the idea. Nothing has been done or put to paper, though, so now I'm posting this in writing. I'm posting this now, because we're close to RC and I think