[raster] ST_ApproxSummaryStat fails under some condition

[pracine]

This works:

SELECT ST_ApproxSummaryStats(ST_AddBand(ST_MakeEmptyRaster(10, 10, 0, 0, 1, 1, 0, 0, 4326), '16BSI'::text, 0, 0));

but if I clip the raster:

SELECT ST_ApproxSummaryStats(ST_Clip(ST_AddBand(ST_MakeEmptyRaster(10, 10, 0, 0, 1, 1, 0, 0, 4326), '16BSI'::text, 0, 0), ST_MakeEnvelope(0, 0, 10, 5, 4326)), 1, true, 0.1);

it fails with this message:

ERROR: floating-point exception DETAIL: An invalid floating-point operation was signaled. This probably means an out-of-range result or an invalid operation, such as division by zero. CONTEXT: SQL function "st_approxsummarystats" statement 1

[Bborie Park]

Confirmed. I'm on it. Strange that ST_ApproxSummaryStats fails while ST_SummaryStats works.

[Bborie Park]

The error occurs because of an unexpected division by zero. Fixed for 2.0 in r9922. Need to fix in trunk

[Bborie Park]

Fixed in r9940 for trunk.