Hello all,
Having a column
item set('a','b','c','d')
it is possible to select
bit_count(bit_or(item))
to get the total number of used positions; and also to do a
sum(bit_count(item))
to get the total number of set positions. However, I would also like to
add a
make_set(bit_or(item),'a','b','c','d')
to get a direct list of all used labels as well. Instead I get an ERROR
1140: Mixing of GROUP columns ... with no GROUP columns... Alternatively,
if I add a "group by NULL" the result is no labels (or all lables for
bit_and). The make_set() function seems to clobber the internal grouping
function bit_or(), or is there some other reason this construct is
illegal?
Tore (using MySQL 4.0.3-beta on Tru64 UNIX)
_______________________________________________________________
Tore Eriksson [tore.eriksson ad po.rd.taisho.co.jp]
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
