3 messages in com.mysql.lists.mysqlRe: 5.0.15 error 1054| From | Sent On | Attachments |
|---|---|---|
| hcir | 31 Oct 2005 09:36 | |
| SGr...@unimin.com | 31 Oct 2005 10:12 | |
| hcir | 31 Oct 2005 10:32 |
| Subject: | Re: 5.0.15 error 1054 |
|---|---|
| From: | hcir (hc...@nosnowkennels.com) |
| Date: | 10/31/2005 10:32:00 AM |
| List: | com.mysql.lists.mysql |
iH Swawn,
thanks for the quick reply and the pointing out the change, after reading the new mysql syntax doc i have my query qorking again
On Oct 31, 2005, at 9:12 AM, SGr...@unimin.com wrote:
hcir <hc...@nosnowkennels.com> 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
Rich Allen A kidney transplant saved my life, plese consider being an organ donor.