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, SGreen@stripped wrote:
>
>
> hcir <hcir@stripped> 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.
