>
> 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)
Read the top of the file. The dash means it is being worked on for 6.1.
> ...
>
> 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).
We already have:
SELECT COUNT(*) FROM TAB1, TAB2 fails
>
> Also, we currently do not do implicit type conversions for column
> inserts or updates from other columns or tables.
We also have:
Allow INSERT INTO ... SELECT to convert column types
- --
Bruce Momjian
maillist@candle.pha.pa.us
------------------------------
