Re: [gdal-dev] OGR SQL, COUNT([DISTINCT] xx) and NULL values

2011-11-28 Thread Even Rouault
Le vendredi 25 novembre 2011 23:14:31, Even Rouault a écrit : > Hi, > > http://trac.osgeo.org/gdal/ticket/4354 : > > """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

[gdal-dev] OGR SQL, COUNT([DISTINCT] xx) and NULL values

2011-11-25 Thread Even Rouault
Hi, http://trac.osgeo.org/gdal/ticket/4354 : """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)