                                                                                                                                                                                                                                                                
Received-SPF: pass (google.com: domain of sirac...@gmail.com designates 209.85.216.170 as permitted sender) client-ip=209.85.216.170;
MIME-Version: 1.0
In-Reply-To: <d5e99c85-4842-4607-8e79-e253ee5f1cea@googlegroups.com>
References: <3cfbb716-19ff-4db7-b396-79fdc7a36f0d@googlegroups.com>
 <CAJu6bqubAC1tXwncZabWhAtdOYqajHZhOyeQcAf-SmRS-h2...@mail.gmail.com> <d5e99c85-4842-4607-8e79-e253ee5f1cea@googlegroups.com>
From: John Siracusa <sirac...@gmail.com>
Date: Fri, 24 Aug 2012 09:22:08 -0400
Message-ID: <CAJu6bqun5Fw46ewWrdgL4GRzZQZY_KOi0HBJd=TQVhrb2Nu...@mail.gmail.com>
Subject: Re: (limit_with_subselect => 0, limit => 1) doesn't affect generated SQL
To: rose-db-object@googlegroups.com
Content-Type: text/plain; charset=UTF-8

On Fri, Aug 24, 2012 at 9:12 AM, kirill <kmatu...@mgcom.ru> wrote:
> The problem is that database freezes when i run it.

That sounds like a different problem.  Or maybe it's just a really
slow query due to database size and available memory and other server
resources?

> But when i copy the query and manually run it in mysql console adding '
> limit 10;' it gives me the right results in "0.00 sec".

Why are you explicitly disabling the subselect limit?  Does MySQL not
support it?

> The only option i have is to generate sql into a string and then manually
> append limits i need?

That query would be incorrect.  You'd be limiting it to 10 rows, not
10 Offers.  If the first Offer has 7 associated MarketBidsRecommended
objects and the second has 5, a "LIMIT 10" clause on the query would
result in one Offer with its 7 associated MarketBidsRecommended
objects and a second Offer with 3 of its 5 associated
MarketBidsRecommended objects.

-John