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. |
||
