Matthias Pigulla wrote:
Hi all,
can someone explain me why this query gets executed the way it is? I
simplified it as much as possible and think it's a conceptual/logical
thing, so I'll omit - at least for now - the table definitions and
sample data for brevity.
-- "Superquery"
EXPLAIN SELECT t
Hello.
See:
http://bugs.mysql.com/bug.php?id=12106
"Matthias Pigulla" <[EMAIL PROTECTED]> wrote:
> Hi all,
>
> can someone explain me why this query gets executed the way it is? I
> simplified it as much as possible and think it's a conceptual/logical
> thing, so I'll omit - at l
On 14/09/2005, "Matthias Pigulla" wrote:
> However - why do we need the dependent subquery at all? The subquery
> can be executed on its own, as it does not depend on any information
> of the "superquery".
This is a subquery optimizer bug.
See http://bugs.mysql.com/bug.php?id=10309
--
felix
-
Hi all,
can someone explain me why this query gets executed the way it is? I
simplified it as much as possible and think it's a conceptual/logical
thing, so I'll omit - at least for now - the table definitions and
sample data for brevity.
-- "Superquery"
EXPLAIN SELECT t1.id, t1.name
FROM documen
