Same SQL expression behaving differently

[qgib]

Author Name: Paolo Cavallini (@pcav)
Original Redmine Issue: 13878
Affected QGIS version: 2.12.0
Redmine category:field_calculator

---

The same query:

"highway" ILIKE '%foot%' and not "man_made" ilike ‘%pier%’

returns 0 records when used in the field calculator, hundreds (in our case) when in the layer filter.
To obtain the same result in the field calc one should modify the expression as follows:

"highway" ILIKE '%foot%' and("man_made" is null or not "man_made" ilike '%pier%’)

So, apparently NULLs are handled differently. The behaviour of the filter is more understandable for the end user; in any case, this inconsistency does not appear good.

---

Related issue(s): #16352 (duplicates)
Redmine related issue(s): 7380

---

[qgib]

Author Name: Sebastian Dietrich (Sebastian Dietrich)

---

What type of layer is this (postgres, spatialite, ...)?

[qgib]

Author Name: Paolo Cavallini (@pcav)

---

shapefile (dbf)

---

• subject was changed from Same SQL xpression behaving differently to Same SQL expression behaving differently

[qgib]

Author Name: Jürgen Fischer (@jef-n)

---

duplicate of #16352

---

• resolution was changed from to duplicate
• status_id was changed from Open to Closed