View Revisions: Issue #760

Summary 0000760: Prevent creation of duplicate users at synchronization
Revision 2016-12-14 12:46 by rijkr
Description IST: The user set from the database is compared with the user set from the synchronization source in a "balanced line" batch process. Both sets are sorted by user id: database users ordered by SQL and source users by a Java SortedSet (lexicographical order). If the SQL "order by" does not sort lexicographical, the balanced line breaks, leading to the creation of duplicate users. Sorting order typically breaks on diacritical characters. For example: the lexicographical order "guy, günther" is SQL ordered like "günther, guy".
SOLL: Convert the SQL ordered result into a Java SortedSet before entering the synchronization process.
Revision 2016-12-14 12:55 by rijkr
Description IST: The user set from the database is compared with the user set from the synchronization source in a "balanced line" batch process. Both sets are sorted by user id: database users ordered by SQL and source users by a Java SortedSet (lexicographical order). If the SQL "order by" does not sort lexicographical, the balanced line breaks, leading to the creation of duplicate users. Sorting order typically breaks on diacritical characters. For example: when the lexicographical order "guy, günther" is SQL ordered like "günther, guy".
SOLL: Convert the SQL ordered result into a Java SortedSet before entering the synchronization process.