hcir <[EMAIL PROTECTED]> wrote on 10/31/2005 12:37:15 PM: > iH > > i saw this report as a bug for previous mysql versions but not for > 5.0.15 > > ERROR 1054 (42S22): Unknown column 'c.len' in 'on clause' > > the query that generated this works fine of mysql 5.0.11 > > others having this issue? using OS X 10.4 (32bit) > > thanks > Rich Allen > Dare & Do > >
To bring MySQL JOIN processing in line with the SQL:2003 specification, certain processing priorities had to be adjusted. This fixed MANY bugs (see change notice) but broke some queries that should have never worked. If you post your actual SQL statement we can probably help you to adjust it so that you no longer get this error. Basically, what had to happen is that explicit JOIN statements were given a higher associative priority than comma-joined tables. You can read an excellent explanation about the entire change here: http://dev.mysql.com/doc/refman/5.0/en/join.html The change notice is here: http://dev.mysql.com/doc/refman/5.0/en/news-5-0-12.html Shawn Green Database Administrator Unimin Corporation - Spruce Pine
