I don't think this is a bug.

Your query is wrong, I believe. You either want:

SELECT code, classno, MY_UDF_FUNC(code) FROM T1 WHERE classno = 10 GROUP BY
code, classno

OR

SELECT code, MY_UDF_FUNC(code) FROM T1 WHERE classno = 10 GROUP BY code

- Brad ----- Original Message ----- From: OmniSoft To: bu...@lists.mysql.com Sent: Sunday, November 19, 2000 5:26 PM Subject: UDF aggregate function bug !?!

I'm trying implement a aggregate function with the purpose of group a set of
unique rows on a table t1 by a field "code" having n occurrences of same "code"
on 2 others tables t2 and t3. I do some as this: SELECT code, MY_UDF_FUNC(code) FROM T1 GROUP BY CODE This function uses internaly callers of mysql_real_connect(), mysql_init() and
others C API functions. Its result very good! But if I use a sentence like: SELECT code, classno, MY_UDF_FUNC(code) FROM T1 WHERE classno = 10 GROUP BY
CODE all results of MY_UDF_FUNC(code) in all rows of the result set returns NULL. What I do?

The code of this function is attached for reference.

Thanks!

gest...@vento.com.br

------------------------------------------------------------------------------

--------------------------------------------------------------------- Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before posting. To request this thread, e-mail bugs...@lists.mysql.com

To unsubscribe, send a message to the address shown in the List-Unsubscribe header of this message. If you cannot see it, e-mail bugs...@lists.mysql.com instead.