Hi Florin,
I get a very strange error from a join in Mantis and this started after I
upgraded from Mysql4 to Mysql5. I know there were some changes regarding the
joins but this error doesn't say anything about the join.
And the error I get is
ERROR 1054 (42S22): Unknown column 'p.field_id' in 'on clause'
It say something related to the join: the error is in the 'on clause'.
When it evaluating the join, it's not yet know that field_id.
It's like this:
select p.field_id from othertable
I haven't tried, but I think it will give the same unknown column error
message. The p.field_id is there, but not included in the query.
Your error is related to operator precedence, "join" is stronger than
"," (natural join), so evaluated before it.
Bye,
Andras
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
