Changes between Version 1 and Version 2 of Ticket #4354


Ignore:
Timestamp:
Nov 25, 2011, 2:11:43 PM (12 years ago)
Author:
Even Rouault
Comment:

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(*)
     1Currently, 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(*)
    22
    33The same applies for COUNT(DISTINCT a_column): it should only count unique non-NULL values.