| List: | General Discussion | « Previous MessageNext Message » | |
| From: | Michael Widenius | Date: | July 29 1999 6:32pm |
| Subject: | SELECT DISTINCT is not working properly with three table joins | ||
| View as plain text | |||
>>>>> "Manuel" == Manuel Lemos <mlemos@stripped> writes: >> Description: Manuel> SELECT DISTINCT fails when join query with three tables. Try the Manuel> following example. <cut> Manuel> SELECT DISTINCT c.b FROM c,b,a WHERE c.a=a.b AND a.a=b.a Hi! The problem is using DISTINCT on a BLOB column. I have now fixed this for 3.22.26 (This already works in 3.23) Regards, Monty
| Thread | ||
|---|---|---|
| • SELECT DISTINCT is not working properly with three table joins | Manuel Lemos | 9 Jul |
| • Re: SELECT DISTINCT is not working properly with three table joins | Ken Farwell | 10 Jul |
| • REGEXP - ranges | g-larowe | 10 Jul |
| • SELECT DISTINCT is not working properly with three table joins | Michael Widenius | 29 Jul |
