Re: Migrating from 4.1.22 to 5.0.45

[Bob Chojnacki]

Sorry, digging a little deper, I found the fix on:

http://bugs.mysql.com/bug.php?id=13832

I just used parenthesis:

CREATE TEMPORARY TABLE project_1
AS SELECT p.* FROM (project AS p, workspace_project AS wp)
JOIN int_project_1 AS i ON (p.project_sid = i.project_sid AND p.revision = i.revision)
JOIN workspace_project_1 AS r ON (wp.project_sid = r.project_sid AND wp.revision = r.revision) WHERE p.project_sid = wp.project_sid
FOR UPDATE

I hope this will help others.