Bug 404895 - Sorting is random for non-unique values
Summary: Sorting is random for non-unique values
Status: CONFIRMED
Alias: None
Product: KEXI
Classification: Applications
Component: Tables (show other bugs)
Version: 3.2.0 Beta
Platform: Other All
: NOR minor
Target Milestone: 3.2.1
Assignee: Jarosław Staniek
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2019-02-28 08:17 UTC by Jarosław Staniek
Modified: 2019-02-28 08:18 UTC (History)
2 users (show)

See Also:
Latest Commit:
Version Fixed In:

Attachments
Add an attachment

Note You need to log in before you can comment on or make changes to this bug.
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.