Comma separated JOINS strikes again!!!
[...]
Here is where you will find this change documented in the manual:
http://dev.mysql.com/doc/refman/5.0/en/upgrading-from-4-1.html
I read that page over and over again... probably too late at night.
thanks for that info. Thanks to Peter, too.
Jan,
>While my query has a cardinality of 23,124*1=23,124 on mysql4,
it hasĀ
>6,412*34,341=220,194,492 on mysql5 - and takes forever and makes
>me
think everything hangs?!
Yep, MySQL improved the SQL compatibility of its join syntax beginning
with 5.0.12, see http://dev.mysql.com/doc/refma
Jan Kirchhoff <[EMAIL PROTECTED]> wrote on 02/01/2006 06:31:20 AM:
>
> As I already wrote I try do get a replication running from a
> mysql-4.1.13 (32bit) master to a 5.0.18 (64bit) slave. It only runs
> for a few minutes and then a query hangs.
> I think I now found out why:
> I modified a mul
As I already wrote I try do get a replication running from a mysql-4.1.13
(32bit) master to a 5.0.18 (64bit) slave. It only runs for a few minutes and
then a query hangs.
I think I now found out why:
I modified a multi-table-update that hung to a select. The same query on the absolutely
ident