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

[HAUBOURG]

Hi Matthias, Thanks for that. 

I won't be able to test soon, vacations are coming and we are on heavy load on catalogs and qgi server. 
Cheers

Régis


> -----Message d'origine-----
> De : Matthias Kuhn [mailto:matthias at opengis.ch]
> Envoyé : vendredi 10 juillet 2015 16:15
> À : HAUBOURG; qgis-developer at lists.osgeo.org
> Objet : Re: [Qgis-developer] NULL and zeroes get mixed in postgis provider
> 
> 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.
> 
> http://cp.mcafee.com/d/2DRPoA81MOrhopsvp7e6zBYTsSzssCOqemm3hOM
> rhKejpd7bbyrNJ6UVdAQsII6zBYSzssCqehPPVEVodNYzaD4Zr8lryh1nWSnR2Hs
> iV7oRx3-tyr_mO-
> Elryn8X6I8vPIjq3Xa3FEVvvW_ccK6zBYQsZuVtdBdzDD3hOUqekuEyemKCHuXf
> axVZicHs3jq9JYTvAXKc3xMVBdUTsSjDdqymohBcCSgVv1ozaC0e4wQoNpIY_4
> QXzzqKPCjBJ0llrU4pkWNcSOYqem3obZ8Qg6BI1OcG5Qfc-
> vlrUCBQQg0M9xkaCy3o86y0k-
> dvEq82fPd42Iw_Q3h1a1EwmHip6l3h0J6FCi7NdKe6_zboL5c0VLRd
> 
> 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://cp.mcafee.com/d/5fHCN0e6xESyMOU-
> Oesd7bVKVJ6UVdAQsII6zBwSzssCOqemn4TzqdNOr9EVpod7bVJ6UVcQszDD
> PhOMrzV6le9WSgGT4y2LRILG5mUBOeNH27YX4T-
> JBZgGT4KhSdog_DoCQ7Sk7jhO-_R-
> opsd7bVEVWZOWrar7fe6zBMQsEZh4sJtdmZSul3PWApmU6CQPrVK_9Tso73x
> ParNKVI06mGTdLy7Ul3Fbf61HM63MCi9E78CRtDcDbq0GGTM8OFRypJBUQsI6
> MnWhEwdbo3ApkbEupY-
> GTNdbFEw1wj2Eld46Mgd40FYq_gQg4vCq85p1_E6y2k3h0JmAOcG6y1qdjcAfy
> rssdDqk941j2OiKZ
> >
> <http://cp.mcafee.com/d/FZsSd2gw76Qm6n7ShPxEVvdTdET79ICzBBwQsI6Q
> rzASjh
> > OOUCYrhKejpd7bb1EVvdET79CzAsY-qem3sv8OFNfmO5mUAgl-
> JBZgGT4KhSdog_DoC_RI
> > LG5mUBOeNH27YX4Sw-OwWqenT-
> LP3bxEVvd7fnKnjpjoVVMQsK6zB7G8zBHFGTKPOEuvkz
> >
> aT0QSOrvdTVeXz0UsepjudTdw0ORmVJYg_2Et9pUMdu0Mu4Ohd0V4SHIVAV
> rg5lm-16leI
> > jdIL6zBwS2_id41Fr0szaxt3PfDRm-
> 9Ftd40c2ol2FEwS21Ew5fznW6y0zYPh0H8fZ0Qgi
> > wq85GQChBgQgbhGpAxYjrzxL-enhnYk>
> >
> > 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://cp.mcafee.com/d/1jWVIe6xAidEIcKfIzD3hO-
> rKrhKejpd7bb1EVodET79ICz
> > BBNdUSzssCOqemm3hO-rhKejd78VVYQsI6U-
> hBjyuJAaJN8wHZrbWxlK9szIqMx_eNd_Hp
> > vkaJNbAtzm4fVS9J1ZB1QQsLLZvC6n3hO-
> qeuLsKCOCNPPxEVsd7afkh7bnjlLtDBgY-F6
> > lK1FJwS-rLOtT61MUsOCYrKr01REh-Fs03ObXB-
> 3TexF0wv_bU30C5gGnS21sk-dvEn8_c
> >
> KH8fZ0La1tqJ9ApkbHhGpAxYiYRDQQnXKcs3zqKPCjBJ0llrU4pkWNcSOYqem3o
> bZ8Qg6B
> > I1OcG5Qfc-vlrUCBQQg0M9xkaCy3o86y0k-
> dvEq82fPd42Iw_Q3h1a1EwmHip6l3h0J6FC
> > i7NdKe6Z5THrugfIMUP Sent from the Quantum GIS - Developer mailing list
> > archive at Nabble.com.
> > _______________________________________________
> > Qgis-developer mailing list
> > Qgis-developer at lists.osgeo.org
> > http://cp.mcafee.com/d/5fHCNEp4xASyMOU-
> Oesd7bVKVJ6UVdAQsII6zBwSzssCOqe
> >
> mn4TzqdNOr9EVpod7bVJ6UVcQszDDPhOMrzV6le9WSgGT4y2LRILG5mUBOe
> NH27YX4T-JB
> > ZgGT4KhSdog_DoCQ7Sk7jhO-_R-
> opsd7bVEVWZOWrar7fe6zBMQsEZh4sJtdmZSul3PWAp
> >
> mU6CTPrVK_9Tso73xParNKVI06vaAWtmx7WY01MjlS67OFek7qUb4pkbEupY-
> GTNdGXepe
> >
> mQ1llLwhBjH4PrbNEVodwLQzh0qmM78OEngYPVZlLyqnjh030C5gGq8dwwq8
> 1jUR-xEw8_
> > cQgaO3_gd44E6y1qJ9Apkd42QqCp8v4SUUr-85NCrk4
>