MySQL Bugs: #33876: Query run OK in Mysql 5.0.27 but not run at 4.1.16

Bug #33876	Query run OK in Mysql 5.0.27 but not run at 4.1.16
Submitted:	15 Jan 2008 17:14	Modified:	15 Feb 2008 17:47
Reporter:	Marco Túlio	Email Updates:
Status:	No Feedback	Impact on me:	None
Category:	MySQL Server: General	Severity:	S3 (Non-critical)
Version:	4.1.16	OS:	Any (Not return correct result)
Assigned to:		CPU Architecture:	Any
Tags:	error diferent version

Description:
Sorry iam brazillian i don´t speak inglish...
Well i have try run my query in my online bd server version 4.1.16... But always  return all same values to field maiorLance, when a try same query into Mysql 5.0.27 she´s return OK, cause she not replace lanceRefBem with anything, version 5.0 return  " "  (blank) and 4.0 return things like cartesian

SELECT CodBem,leilao_id_ref, leilao_data_fech, cli.Nome, InfComplemen, MAX( lance ) AS maiorLance
FROM(
	sig_leilao_leilao AS leilao INNER JOIN sig_bem AS bem 
      ON leilao.leilao_id = bem.leilao_id_ref
	)LEFT JOIN(
	          sig_lance AS lanc INNER JOIN sig_clientes AS cli 
		      ON cli.CodCliente = lanc.id_ref_cliente
    )ON lanc.lanceRefBem = bem.CodBem
GROUP BY `CodBem`
HAVING CodBem = 1

How to repeat:
In my test, i think the BUG in LEFT JOIN but iam not shure.

Thank you for a problem report. Please, try to repeat with a newer version, 4.1.23, and inform about the results. In case of the same problem, please, send a complete test case, with CREATE TABLE and some data for all the tables involved.

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".