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 'optimization' .... how can I make a query
> without using the LEFT JOIN optimization of MySQL 4.1.7 ?
What is the query ?
Can you provide a repeatable test case ?
Regards,
Sergei
--
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Senior Software Developer
/_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany
<___/ www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
