FIX: Merge replication non-convergence occurs with SQL Server CE subscribers (867879)

MORE INFORMATION

Steps to reproduce the problem

1. In SQL Server, Run the following code to set up the database, the tables, and merge replication:

   create database cesimplerepro
   GO
   use cesimplerepro
   GO
   create table main (mainid int not null primary key, id_user int)
   GO
   create table child (childid int not null primary key, id_user int, mainid int foreign key references main(mainid))
   GO
   insert into main (mainid, id_user) values (3, 5)
   GO
   insert into child (childid, id_user, mainid) values (1, 10, 3)
   GO
   exec sp_replicationdboption @dbname = N'cesimplerepro', @optname = N'merge publish', @value = N'true'
   GO
   -- Add the merge publication.
   exec sp_addmergepublication @publication = N'cesimplerepro',  @retention = 14, @sync_mode = N'character', @allow_push = N'true', @allow_pull = N'true', @allow_anonymous = N'true', @enabled_for_internet = N'false', @centralized_conflicts = N'true', @dynamic_filters = N'true', @snapshot_in_defaultfolder = N'true', @compress_snapshot = N'false', @ftp_port = 21, @ftp_login = N'anonymous', @conflict_retention = 14, @keep_partition_changes = N'true', @allow_subscription_copy = N'false', @allow_synctoalternate = N'false',@add_to_active_directory = N'false', @max_concurrent_merge = 0, @max_concurrent_dynamic_snapshots = 0
   GO
   exec sp_addpublication_snapshot @publication = N'cesimplerepro',@frequency_type = 4, @frequency_interval = 1, @frequency_relative_interval = 1, @frequency_recurrence_factor = 0, @frequency_subday = 1, @frequency_subday_interval = 5, @active_start_date = 0, @active_end_date = 0, @active_start_time_of_day = 500, @active_end_time_of_day = 235959
   GO
   exec sp_grant_publication_access @publication = N'cesimplerepro', @login = N'BUILTIN\Administrators'
   GO
   exec sp_grant_publication_access @publication = N'cesimplerepro', @login = N'distributor_admin'
   GO
   exec sp_grant_publication_access @publication = N'cesimplerepro', @login = N'sa'
   GO
   -- Add the merge articles.
   exec sp_addmergearticle @publication = N'cesimplerepro', @article = N'main', @source_owner = N'dbo', @source_object = N'main', @type = N'table', @description = null, @column_tracking = N'true', @pre_creation_cmd = N'drop', @creation_script = null, @schema_option = 0x000000000000CFF1, @article_resolver = null, @subset_filterclause = N'ID_User = 5', @vertical_partition = N'false', @destination_owner = N'dbo', @auto_identity_range = N'false', @verify_resolver_signature = 0, @allow_interactive_resolver = N'false', @fast_multicol_updateproc = N'true', @check_permissions = 0
   GO
   exec sp_addmergearticle @publication = N'cesimplerepro', @article = N'child', @source_owner = N'dbo', @source_object = N'child', @type = N'table', @description = null, @column_tracking = N'true', @pre_creation_cmd = N'drop', @creation_script = null, @schema_option = 0x000000000000CFF1, @article_resolver = null, @subset_filterclause = null, @vertical_partition = N'false', @destination_owner = N'dbo', @auto_identity_range = N'false', @verify_resolver_signature = 0, @allow_interactive_resolver = N'false', @fast_multicol_updateproc = N'true', @check_permissions = 0
   GO
   -- Add the article subset filter.
   exec sp_addmergefilter @publication = N'cesimplerepro', @article = N'Child', @filtername = N'child_main', @join_articlename = N'main', @join_filterclause = N'main.mainid = Child.mainid', @join_unique_key = 0
   GO

2. Run the Snapshot Agent, and then download the snapshot to a SQL Server CE Subscriber.
3. Run the following queries at the Subscriber:

   update main set id_user = 0  -- Take this row out of the partition.
   update child set id_user = 10 -- This is a dummy update on the child table.
   

4. Synchronize the changes to the publisher. Notice that the SQL Server CE Subscriber has no rows for the main table and the child table because the filter is no longer satisfied.
5. Run the following query in Publisher:

   Update main set id_user = 5 -- Satisfies the filter clause again. The row will get into partition on the next synch.

6. Synchronize the changes to the SQL Server CE subscriber.
   
   On the Subscriber, you will see one row for the main table. This behavior is correct. But you do not see any rows for the child table. This is incorrect.