Changes between Version 1 and Version 2 of Ticket #4354
- Timestamp:
- Nov 25, 2011, 2:11:43 PM (12 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
Ticket #4354 – Description
v1 v2 1 Currently, OGR SQL considers COUNT(a_column) as a synonym of COUNT(*). However the standard mandates that COUNT(a_column) only count non-NULL values, whereas COUNT(*) count all values, including NULL ones. So COUNT(a_column) should not be considered as equivalent to COUNT(*)1 Currently, OGR SQL considers COUNT(a_column) as a synonym of COUNT(*). However the standard mandates that COUNT(a_column) only count non-NULL values, whereas COUNT(*) count all rows (after the effect of WHERE clause of course). So COUNT(a_column) should not be considered as equivalent to COUNT(*) 2 2 3 3 The same applies for COUNT(DISTINCT a_column): it should only count unique non-NULL values.