I was recently made aware that a hotfix for SQL Server Compact was made available in 2014 – but better late than never.
The hotfix can be requested via the Microsoft support knowledgebase here: https://support.microsoft.com/en-us/kb/2960153
The file/build version of the hotfix is: 4.0.8902.0 (The .NET assembly version stays at either 220.127.116.11 (or 18.104.22.168 for the “Private” .NET Assembly)
The hotfix includes the following fixes:
FIX: Unexpected ordering when you run ORDER BY statement on a column that contains “-” in SQL Server Compact 4.0
FIX: “ConnectionString cannot be null” when you use folder redirection with offline files
FIX: It takes longer time than flush interval to flush committed transactions in SQL Server Compact 4.0