Bug 404895

Summary:	Sorting is random for non-unique values
Product:	[Applications] KEXI	Reporter:	Jarosław Staniek <staniek>
Component:	Tables	Assignee:	Jarosław Staniek <staniek>
Status:	CONFIRMED ---
Severity:	minor	CC:	adam, inksi
Priority:	NOR
Version First Reported In:	3.2.0 Beta
Target Milestone:	3.2.1
Platform:	Other
OS:	All
Latest Commit:		Version Fixed/Implemented 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.