RE: MySQL 5 problem after upgrade

2006-05-27 Thread Moritz Möller
Hi, i've noticed similar behaviour as we upgraded to mysql 5.0. The query optimizer seems to been "optimized" a little too much :-\ -Original Message- From: Szymon Kosok [mailto:[EMAIL PROTECTED] Sent: Saturday, May 27, 2006 5:42 PM Cc: mysql@lists.mysql.com Subje

Re: MySQL 5 problem after upgrade

2006-05-27 Thread Szymon Kosok
Hello again, SELECT shout_avatar, shout_own, timestamp, tekst, imie, pseudo, wiek, City, Country, plec, wlosy_kol, gra_gwiazdy.id, gra_gm.gid AS gm FROM gra_shoutbox INNER JOIN (gra_gwiazdy) ON (gra_gwiazdy.id = gra_shoutbox.gid) INNER JOIN (swiat_miasta) ON (swiat_miasta.CityId = gra_gwiazdy.mi