[EMAIL PROTECTED] writes:
> count() gives 0 but count(distinct) gives 1. is this correct or
> a bug or is there something wrong with my SELECT?
>
> mysql> create table t1 (f1 int);
> mysql> insert into t1 values (1);
> mysql> create table t2 (f1 int,f2 int);
> mysql> select t1.f1,count(t2.f2) from t1
> -> left join t2 on t1.f1=t2.f1 group by t1.f1;
> +------+--------------+
> | f1 | count(t2.f2) |
> +------+--------------+
> | 1 | 0 |
> +------+--------------+
> 1 row in set (0.00 sec)
>
> mysql> select t1.f1,count(distinct t2.f2) from t1
> -> left join t2 on t1.f1=t2.f1 group by t1.f1;
> +------+-----------------------+
> | f1 | count(distinct t2.f2) |
> +------+-----------------------+
> | 1 | 1 |
> +------+-----------------------+
> 1 row in set (0.01 sec)
>
> regards,
> tommie
>
Hi!
Thanks for the bug report.
We shall investigate it.
--
Regards,
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer
/_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
<___/ www.mysql.com
---------------------------------------------------------------------
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