Bug report #20071
Updated by Jürgen Fischer over 5 years ago
This is a revival of #13999.
In the attached screenshots, I use the Else shortcut in one case and the full rule in the other. counted features are not the same:
1/ The "Route secondaire" level "instead of displaying 0" #20070, 0":https://issues.qgis.org/issues/20070, would return 296389 in one case (correct!) and, 304445 with the Else rule (corresponding to the whole layer).
2/ At the bottom of the rules, the _Autres_ nature subclass should return 213037 features as of
@select count(nature) from layer where importance not in ('1','2') and nature not in ('Bac auto', 'Escalier','Piste cyclable','Sentier','Chemin')@
but it instead returns the same value shown at its upper level:
* 296389 features which is the result of @select count(nature) from layer where importance not in ('1','2')@
* or 304445 features with the Else rule used for "Route secondaire".
In the attached screenshots, I use the Else shortcut in one case and the full rule in the other. counted features are not the same:
1/ The "Route secondaire" level "instead of displaying 0" #20070, 0":https://issues.qgis.org/issues/20070, would return 296389 in one case (correct!) and, 304445 with the Else rule (corresponding to the whole layer).
2/ At the bottom of the rules, the _Autres_ nature subclass should return 213037 features as of
@select count(nature) from layer where importance not in ('1','2') and nature not in ('Bac auto', 'Escalier','Piste cyclable','Sentier','Chemin')@
but it instead returns the same value shown at its upper level:
* 296389 features which is the result of @select count(nature) from layer where importance not in ('1','2')@
* or 304445 features with the Else rule used for "Route secondaire".