Bug report #21225
sql "order by" does not work with the "Add/Edit Virtual Layer" feature
| Status: | Open | ||
|---|---|---|---|
| Priority: | Normal | ||
| Assignee: | - | ||
| Category: | Virtual Layers | ||
| Affected QGIS version: | 3.4.4 | Regression?: | No |
| Operating System: | Easy fix?: | No | |
| Pull Request or Patch supplied: | No | Resolution: | |
| Crashes QGIS or corrupts data: | No | Copied to github as #: | 29043 |
Description
On a simple example
add a virtual layer with the functionality "Add/Edit a virtual layer" :
SELECT * FROM mylayer ORDER BY myfield
the virtual layer created is not sorted.
If you use DBmanager it works correctly.
History
#1
Updated by Alain FERRATON over 5 years ago
In addition...
It seems to be a display problem of "open attribute table",
If you run a SQL query in DBManager (SELECT * FROM MyVirtualLayer) or if you display the attribute table in a layout, the data is correctly sorted.