RE: 4.0.18 -> 4.1.7 LEFT JOIN problem

2004-11-23 Thread Donny Simonton
olubchik [mailto:[EMAIL PROTECTED] > Sent: Tuesday, November 23, 2004 2:13 PM > To: Dilipan Sebastiampillai > Cc: [EMAIL PROTECTED] > Subject: Re: 4.0.18 -> 4.1.7 LEFT JOIN problem > > Hi! > > On Nov 23, Dilipan Sebastiampillai wrote: > > > > > > > &

Re: 4.0.18 -> 4.1.7 LEFT JOIN problem

2004-11-23 Thread Sergei Golubchik
Hi! On Nov 23, Dilipan Sebastiampillai wrote: > > > > > >Hi! > > > >On Nov 22, Dilipan Sebastiampillai wrote: > > > > > >>I moved a db from 4.0.18 to 4.1.7 and I realise that the SAME sql query > >>using LEFT JOIN gives me different result. > >>The result from 4.0.18 does s real LEFT JOIN but 4.

Re: 4.0.18 -> 4.1.7 LEFT JOIN problem

2004-11-23 Thread Dilipan Sebastiampillai
Hi! On Nov 22, Dilipan Sebastiampillai wrote: I moved a db from 4.0.18 to 4.1.7 and I realise that the SAME sql query using LEFT JOIN gives me different result. The result from 4.0.18 does s real LEFT JOIN but 4.1.7 differs sometimes and I don't want that. I think it comes from an 'optimiza

Re: 4.0.18 -> 4.1.7 LEFT JOIN problem

2004-11-23 Thread Sergei Golubchik
Hi! On Nov 22, Santino wrote: > At 15:23 +0100 22-11-2004, Sergei Golubchik wrote: > >Hi! > > > >On Nov 22, Dilipan Sebastiampillai wrote: > >> I moved a db from 4.0.18 to 4.1.7 and I realise that the SAME sql query > >> using LEFT JOIN gives me different result. > >> The result from 4.0.18 does s

Re: 4.0.18 -> 4.1.7 LEFT JOIN problem

2004-11-22 Thread Jeff Smelser
On Monday 22 November 2004 04:15 pm, Santino wrote: I can confirm it anyway: I think we have a bug.. Unless someone else see something, might want to take this to bugs.mysql.com Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 578 to server version: 4.1.7-log

Re: 4.0.18 -> 4.1.7 LEFT JOIN problem

2004-11-22 Thread Santino
At 15:23 +0100 22-11-2004, Sergei Golubchik wrote: Hi! On Nov 22, Dilipan Sebastiampillai wrote: I moved a db from 4.0.18 to 4.1.7 and I realise that the SAME sql query using LEFT JOIN gives me different result. The result from 4.0.18 does s real LEFT JOIN but 4.1.7 differs sometimes and I don

Re: 4.0.18 -> 4.1.7 LEFT JOIN problem

2004-11-22 Thread Sergei Golubchik
Hi! On Nov 22, Dilipan Sebastiampillai wrote: > I moved a db from 4.0.18 to 4.1.7 and I realise that the SAME sql query > using LEFT JOIN gives me different result. > The result from 4.0.18 does s real LEFT JOIN but 4.1.7 differs > sometimes and I don't want that. > > I think it comes from an

4.0.18 -> 4.1.7 LEFT JOIN problem

2004-11-22 Thread Dilipan Sebastiampillai
I moved a db from 4.0.18 to 4.1.7 and I realise that the SAME sql query using LEFT JOIN gives me different result. The result from 4.0.18 does s real LEFT JOIN but 4.1.7 differs sometimes and I don't want that. I think it comes from an 'optimization' how can I make a query without using t