Re: [Modeling-users] [patch] Switch to generic nested join for recent versions of MySQL

[Sebastien B. <sbi...@us...>]

        Hi,

  Thanks for the report. I've searched the mysql-site for about half an
  hour but couldn't find any hints on when the change happened. Do you
  (or anyone here) have any clue?

  Second, could you possibly confirm that the test
test_11_allQualifierOperators() in test_EditingContext_Global.py fails
when you patch is /not/ applied, and succeeds when it is applied? If it
does not, then I'll need to write a new one revealing that bug.

  Given that this particular test behaves as expected, your patch will
  be applied as-is and integrated to the main trunk. Thanks again for
  reporting.

-- S=E9bastien.


John Georgiadis <ig...@do...> wrote:
> Hi Sebastian,
>=20
> I get a syntax error from MySQL-4.0.11 when using nested JOINS created by
> MySQLAdaptorLayer.MySQLExpression._addTableJoinsForAlias(). If I switch to
> Modeling.SQLExpression._addTableJoinsForAlias(), the problem is gone.
>=20
> The following patch does this for mysql version >=3D 4.0.11. If anyone can
> confirm this for an older version of MySQL, then feel free to lower the
> version numbers in the tuple.