group by and count(*) behaviour in 8.3

[Edoardo Panfili <edoardo@xxxxxxxx>]

I am using this query in 8.3beta4 (compiled from source) in MacOS X 10.5.1

SELECT webName,count(*) FROM contenitore NATURAL JOIN cartellino WHERE
contenitore.tipo='e' GROUP BY webName;

this is the result
                      webName                      | count
--------------------------------------------------+-------
  test palermo                                     | 36679
  Herbarium Camerinensis - CAME                    | 36679
  Herbarium Universitatis Aeserniae - IS           | 36679
  Herbarium Universitatis Civitatis Perusii - PERU | 36679
  Herbarium Anconitanum - ANC                      | 36679
  Test database - São Paulo                        | 36679
  Herbarium Universitatis Genuensis - GE           | 36679
  Herbarium Universitatis Senensis - SIENA         | 36679
  Segnalazioni Siena                               | 36679
  Herbarium Aquilanum - AQUI                       | 36679
(10 rows)

but 36679 is the total number of row of the table.
The same query in 8.1.4 retrieves the aspected result (the number of
elements for each webName).

Is this a bug or a change in the semantic of SQL?

thank you
Edoardo

--
Jabber: edoardopa@xxxxxxxxxxxxxxx
tel: 075 9142766

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings