List:General Discussion« Previous MessageNext Message »
From:Martin Ramsch Date:September 23 1999 12:55am
Subject:Re: I wish I could use LIMIT but....
View as plain text  
On Thu, 1999-09-23 02:40:02 +0200, I wrote:
> Even without such a change of field definition it's possible, though
> much more inefficient:
>   SELECT LabelID,
>          MAKE_SET(
>            BIT_OR(
>              POW(2,
>                FIND_IN_SET(genre,'name1,name2,list,of,all,genres')
>              )
>            ),
>            'name1,name2,list,of,all,genres'
             ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
>          ) AS genre
>   FROM ...
>   GROUP BY LabelID;
>
> (I think I found a bug here, as MAKE_SET in itself does work,
>  the large BOT_OR term does, too, but in this combination MAKE_SET
>  always gives an empty string ...)

The marked part above should read
  'name1','name2','list','of','all','genres'
(cut & paste error from earlier version).
The bug remains.
 
Regards,
  Martin
-- 
Martin Ramsch <m.ramsch@stripped> <URL: http://home.pages.de/~ramsch/ >
PGP KeyID=0xE8EF4F75 FiPr=52 44 5E F3 B0 B1 38 26  E4 EC 80 58 7B 31 3A D7
Thread
I wish I could use LIMIT but....a rancid amoeba22 Sep
  • Re: I wish I could use LIMIT but....Martin Ramsch23 Sep
    • Re: I wish I could use LIMIT but....Martin Ramsch23 Sep