Bug 404895

Summary: Sorting is random for non-unique values
Product: [Applications] KEXI Reporter: Jarosław Staniek <staniek>
Component: TablesAssignee: Jarosław Staniek <staniek>
Status: CONFIRMED ---    
Severity: minor CC: adam, inksi
Priority: NOR    
Version: 3.2.0 Beta   
Target Milestone: 3.2.1   
Platform: Other   
OS: All   
Latest Commit: Version Fixed In:
Sentry Crash Report:

Description Jarosław Staniek 2019-02-28 08:17:23 UTC
STEPS TO REPRODUCE
1. Open table with non-unique values (can be text or numbers) in given column, let the table have primary key too
2. Sort by this column ascending, then descending
3. Repeat step 2 and look at primary keys

OBSERVED RESULT
Observe how records with identical value in the tested column change the order rather randomly

EXPECTED RESULT
Sorting ascending again should preserve the order, e.g. with regard to primary key, if present. The same for descending.

SOFTWARE/OS VERSIONS
All
Comment 1 Jarosław Staniek 2019-02-28 08:18:00 UTC
Note to myself: solution kept in private branch 404895.