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:[email protected]] > Envoyé : vendredi 10 juillet 2015 16:15 > À : HAUBOURG; [email protected] > 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 > > [email protected] > > http://cp.mcafee.com/d/5fHCNEp4xASyMOU- > Oesd7bVKVJ6UVdAQsII6zBwSzssCOqe > > > mn4TzqdNOr9EVpod7bVJ6UVcQszDDPhOMrzV6le9WSgGT4y2LRILG5mUBOe > NH27YX4T-JB > > ZgGT4KhSdog_DoCQ7Sk7jhO-_R- > opsd7bVEVWZOWrar7fe6zBMQsEZh4sJtdmZSul3PWAp > > > mU6CTPrVK_9Tso73xParNKVI06vaAWtmx7WY01MjlS67OFek7qUb4pkbEupY- > GTNdGXepe > > > mQ1llLwhBjH4PrbNEVodwLQzh0qmM78OEngYPVZlLyqnjh030C5gGq8dwwq8 > 1jUR-xEw8_ > > cQgaO3_gd44E6y1qJ9Apkd42QqCp8v4SUUr-85NCrk4 > _______________________________________________ Qgis-developer mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/qgis-developer
