Bug report #21225

sql "order by" does not work with the "Add/Edit Virtual Layer" feature

Added by Alain FERRATON about 1 year ago. Updated about 1 year ago.

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 about 1 year 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.

Also available in: Atom PDF