[processing] Use null instead of nan for invalid stat values in join by location summary

nyalldawson · nyalldawson · commit c3347712bb98 · 2019-03-31T23:32:49.000Z
diff --git a/python/plugins/processing/algs/qgis/SpatialJoinSummary.py b/python/plugins/processing/algs/qgis/SpatialJoinSummary.py
@@ -26,6 +26,7 @@
 __revision__ = '$Format:%H$'
 
 import os
+import math
 
 from collections import defaultdict
 
@@ -339,7 +340,8 @@ def addField(original, stat, type):
                         stat.finalize()
                         for s in numeric_fields:
                             if s[0] in summaries:
-                                attrs.append(getattr(stat, s[2])())
+                                val = getattr(stat, s[2])()
+                                attrs.append(val if not math.isnan(val) else NULL)
                     elif field_type == 'datetime':
                         stat = QgsDateTimeStatisticalSummary()
                         stat.calculate(attribute_values)
