MySQL 5.0.12+ JOIN Syntax Changed

Description

With 5.0.12 MySQL changed the JOIN syntax to be SQL:2003 compliant. (See MySQL 5.0.12 Release Notes at http://dev.mysql.com/doc/refman/5.0/en/news-5-0-12.html and JOIN syntax information at http://dev.mysql.com/doc/refman/5.0/en/join.html for more information)

Previous to this change the following query was valid:

SELECT * FROM t1, t2 JOIN t3 ON (t1.i1 = t3.i3);

Now it must be written as:

SELECT * FROM (t1, t2) JOIN t3 ON (t1.i1 = t3.i3);
or
SELECT * FROM t1 JOIN t2 JOIN t3 ON (t1.i1 = t3.i3);

Environment

Tested with Hibernate Core 3.2.1 and 3.2.3, MySQL 5.0.27, 5.0.33, 5.0.37

Status

Assignee

Diego Plentz

Reporter

Brian Rozmierski

Fix versions

None

Labels

None

backPortable

None

Suitable for new contributors

None

Requires Release Note

None

Pull Request

None

backportDecision

None

Components

Affects versions

Priority

Critical
Configure