ORDER BY clause in filter does not accept quoted field names

[qgib]

Author Name: mlennert - (mlennert -)
Original Redmine Issue: 12638
Affected QGIS version: master
Redmine category:data_provider

---

Trying to order my shapefile point data in QGIS 2.4 (Debian testing version) for proportionate symbol mapping in order to have the largest symbols below the smallest, I use the following clause in the layer's filter:

1=1 ORDER BY "pop_2001" desc

This however gives me

OGR [3] error 1: SQL Expression Parsing Error: syntax error

When I leave out the quotation marks (inserted automatically by the GUI):

1=1 ORDER BY pop_2001 desc

everything works as expected.

I don't have this problem when I access a postgis table via the OGR provider, i.e. I can use quoted field names there.

However, when I access the same table via the postgis provider, the result of the query is empty !

So the whole thing seems to be provider specific...

[qgib]

Author Name: Giovanni Manghi (@gioman)

---

It happens also on 2.8.1/master.

---

• version was changed from 2.4.0 to master

[qgib]

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

---

The subset strings are indeed provider specific, but they are generally supposed to be where clauses only - using "ORDER BY" isn't supported.

---

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