count distinct support?

Current version of dbd-mysql doesn't seem to support COUNT(DISTINCT xx)
support, although current versions of mysql do:

mysql> select count(distinct ip) from hit where client=1;
+--------------------+
| count(distinct ip) |
+--------------------+
|              28409 |
+--------------------+
1 row in set (0.39 sec)


DBD::mysql::st execute failed: You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right 
syntax to use near '( DISTINCT ip) FROM hit WHERE client='1'



-- 
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe:    http://lists.mysql.com/[email protected]