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 joinsManuel Lemos9 Jul
  • Re: SELECT DISTINCT is not working properly with three table joinsKen Farwell10 Jul
    • REGEXP - rangesg-larowe10 Jul
  • SELECT DISTINCT is not working properly with three table joinsMichael Widenius29 Jul