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:
> > >
> > >
> &
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.
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
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
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
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
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
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