[Qgis-developer] NULL and zeroes get mixed in postgis provider

[Matthias Kuhn]

Hi Régis,

I used the time I had while doing an exam supervision today to
investigate this.
If you have the possibility to validate the pull request, that would be
great.

https://github.com/qgis/QGIS/pull/2207

Cheers,
Matthias

On 07/09/2015 04:03 PM, Régis Haubourg wrote:
> Hi all, 
>
> we discovered quite a nasty issue here, probably here for a long time but I
> could'nt reproduce it correctly before. 
>
> With postgis tables or views, when numeric fields (tested with int, real and
> numeric) bears null values, and also 0 values, NULLs and zeroes are mixed
> randomly, at some zoom or pan levels only! 
>
> we got aware of this because of rendering rules :
> -With categorized renderer, styling and labeing change, which is more than
> weird. 
> -With graduated renderer, features simply disappear because NULL values
> can't be rendered in a class because it requires numeric values. 
>
> But that seems to come from provider since we have a nice effect on
> attribute table:
>  -We clearly see those value changes in attribute tables
>  -When filtering attribute table on visible features in mapcanvas extent,
> those renderer with NULL just don't appear!
>
>
> See the video here :   http://youtu.be/kDip8wEeXxU?hd=1
> <http://youtu.be/kDip8wEeXxU?hd=1>  
>
> reproduced on 2.8.2 too,  but not on 2.6.1. 
>
> Not putting it as a blocker, because it seems a rare use case, but certainly
> a "must fix", and probably deserves backports.
>
> Cheers
>
> Régis
>
> Ticket will be filed, when redmine will be fixed ;-)
>
>
>
> --
> View this message in context: http://osgeo-org.1560.x6.nabble.com/NULL-and-zeroes-get-mixed-in-postgis-provider-tp5215064.html
> Sent from the Quantum GIS - Developer mailing list archive at Nabble.com.
> _______________________________________________
> Qgis-developer mailing list
> Qgis-developer at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/qgis-developer