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 real LEFT JOIN

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

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.1.7 differs

RE: 4.0.18 - 4.1.7 LEFT JOIN problem

2004-11-23 Thread Donny Simonton
: 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: Hi! On Nov 22, Dilipan Sebastiampillai wrote: I moved a db from 4.0.18 to 4.1.7 and I realise

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

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

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

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: