"sort" funcionality of attributes table sort numeric fields as text

[gioman]

3.10.3 and 3.12

Add the "alaska" shapefile from the QGIS sample dataset

Open the attribute table and use the "sort" function to sort the records using the "cat" field, that is of type integer.

The records will be ordered as expected.

Save the project.

Close the project and reopen it, open the attribute table > records are ordered as the "cat" column was of type text (i.e. 1,10,100,11,110,111...).

[roya0045]

If you have a few moment could you test to see if this https://github.com/roya0045/QGIS_1/actions/runs/68192864 solves this issue?

[gioman]

Close the project and reopen it, open the attribute table > records are ordered as the "cat" column was of type text (i.e. 1,10,100,11,110,111...).

or just close and reopen the table. Still a bug in the latest master.

[gioman]

Still true on the latest master, also with a PostGIS table.

[MrChebur]

Bug confirmed with PostgreSQL database with PostGIS extension and geopackage file.
QGIS version 3.22.2-Białowieża
QGIS code revision 1601ec4

Manual sorting by clicking on the field name sorts as expected, but using the sort function (in the context menu) does not work correctly. Testet with integer and data types.

Here is data for tesing and the video:
test_sorting.zip