Re: SELECT, LEFT JOIN, and user variables

2001-03-15 Thread Michael Widenius
Hi! > "Gary" == Gary Shea <[EMAIL PROTECTED]> writes: Gary> Today, Sinisa Milivojevic ([EMAIL PROTECTED]) wrote: >> [EMAIL PROTECTED] writes: >> > >Description: >> > >> > It appears that if a column generated by a select is >> > a sum of variables generated in other columns of the >

Re: SELECT, LEFT JOIN, and user variables

2001-03-12 Thread Sinisa Milivojevic
Gary Shea writes: > > Sorry, this is my fault for not describing the problem better. > Here's the result I get with DISTINCT (I've given the columns > names to make the table smaller, but not changed the SQL from what > I sent in the bug report): > > +---+ > | i | > +---+ > | 1 | > |

Re: SELECT, LEFT JOIN, and user variables

2001-03-11 Thread Gary Shea
Today, Sinisa Milivojevic ([EMAIL PROTECTED]) wrote: > [EMAIL PROTECTED] writes: > > >Description: > > > > It appears that if a column generated by a select is > > a sum of variables generated in other columns of the > > select (see example below!), the column will have a > >

Re: SELECT, LEFT JOIN, and user variables

2001-03-11 Thread Sinisa Milivojevic
[EMAIL PROTECTED] writes: > >Description: > > It appears that if a column generated by a select is > a sum of variables generated in other columns of the > select (see example below!), the column will have a > bogus result if the select is 'DISTINCT'. If the > DISTINCT