Migrating from 4.1.22 to 5.0.45

[Bob Chojnacki]

Hi,

This statement is working on MySQL 4.1.22, but not on 5.0.45:

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

According to the 5.0 reference manual, it says it is correct. But I keep on getting the error:

com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Unknown column 'p.project_sid' in 'on clause'

Any Ideas?