Connector does not handle SUM(table_name.Column)

[jacek.blaszczynski]

Hello!

The following SQL query works perfect with any DB I use in my development work (MSDE, Oracle 9i, MySQL 4.1.7) with all connectors except MySQL Connector

SELECT u.UserID, User, Password, email, RegisteredSince, LastModified, UNameModified, sum(r.RoleID) FROM Users u, UsersRoles r WHERE User=@user AND r.UserID = u.UserID GROUP BY u.UserID;

ATTENTION: I have replaced @ with ? there for MySQL Connector - its nonsense syntax anyway.

Is it a bug?

Cheers

Jacek