Re: LEFT JOIN fails to correctly join tables

2001-12-01 Thread Dale Woolridge
On 1-Dec-2001 16:49 Sinisa Milivojevic wrote: | | Thank you for the repeatable test case. I've just tested this with 3.23.46 and it still fails. regards. -- -Dale - Before posting, please check: http://www.mysql.com/ma

Re: LEFT JOIN fails to correctly join tables

2001-12-01 Thread Sinisa Milivojevic
[EMAIL PROTECTED] writes: > >Description: > It seems that that the use of LEFT JOIN when the joined table > uses multiple primary key conditions fails to include rows which > are clearly matching on those conditions. > > >How-To-Repeat: > mysql> create table foo (fooID sma

LEFT JOIN fails to correctly join tables

2001-11-30 Thread dale-list-mysql-bug
>Description: It seems that that the use of LEFT JOIN when the joined table uses multiple primary key conditions fails to include rows which are clearly matching on those conditions. >How-To-Repeat: mysql> create table foo (fooID smallint unsigned auto_increment, p