I was looking through the ToDo list on the web page and would suggest
removing the item concerning the SUM aggregate in RELIABILITY:
RELIABILITY
- -----------
...
- -SUM aggregate on no rows or null value should return NULL, not
zero(Thomas)
...
And modifying the item concerning SUM() in v6.1 Bug Fixes:
Bug Fixes
- ---------
...
select SUM(x) and AVG(x) on NULL or zero rows returns NULL (Thomas)
...
Additional things to add for future enhancements:
There is currently a problem using count(*) in table joins (the parser
tries to choose the OID column and complains that there is more than one
column by that name).
Also, we currently do not do implicit type conversions for column
inserts or updates from other columns or tables.
Thanks.
- Tom
------------------------------
