Select count group by returns only 1 row

General Discussions - English
1

hello,
I’m trying this query to return an aggregated view of my datas.
My query is :
SELECT ANNEE,COUNT(*) FROM idx_baz_news GROUP BY ANNEE
Manticore returns only one row, its a bug…dont know how i can fix this bug.
Any help ?
Thanks

2

Hello. I can’t reproduce this issue:

mysql> drop table if exists idx_baz_news; create table idx_baz_news(ANNEE int); insert into idx_baz_news values(1, 1),(2, 2); SELECT ANNEE,COUNT(*) FROM idx_baz_news GROUP BY ANNEE;
--------------
drop table if exists idx_baz_news
--------------

Query OK, 0 rows affected (0.01 sec)

--------------
create table idx_baz_news(ANNEE int)
--------------

Query OK, 0 rows affected (0.00 sec)

--------------
insert into idx_baz_news values(1, 1),(2, 2)
--------------

Query OK, 2 rows affected (0.00 sec)

--------------
SELECT ANNEE,COUNT(*) FROM idx_baz_news GROUP BY ANNEE
--------------

+-------+----------+
| annee | count(*) |
+-------+----------+
|     1 |        1 |
|     2 |        1 |
+-------+----------+
2 rows in set (0.00 sec)
--- 2 out of 2 results in 0ms ---