[MDEV-23739] Document aggregate functions returning NULL on no rows Created: 2020-09-15 Updated: 2020-10-19 Resolved: 2020-10-19 |
|
| Status: | Closed |
| Project: | MariaDB Server |
| Component/s: | Documentation |
| Affects Version/s: | N/A |
| Fix Version/s: | N/A |
| Type: | Bug | Priority: | Minor |
| Reporter: | Ian Gilfillan | Assignee: | Ian Gilfillan |
| Resolution: | Fixed | Votes: | 0 |
| Labels: | None | ||
| Description |
|
As per discussion at https://mariadb.zulipchat.com/#narrow/stream/256465-MariaDB-Server.20Fest/topic/sql_mode.3Dludicrous/near/210118431 |
| Comments |
| Comment by Ian Gilfillan [ 2020-10-19 ] |
|
Appears to be documented for each function. Not all functions return NULL, for example COUNT returns 0. COALESCE being used to replace NULL has now been documented as well. |