i am trying to filter updates to a column on a table in the replicat. I want to discard any update that sets a specific column of the table to NULL. I also have statement in the config to map source_schema.* to target_schema.* I noticed that the filter or where statement has to come before the global map statement or the filter map is ignored. I have tried using filter on update, where clause, and several other methods to accomplish this. What I am finding is that once I setup a filter or where clause on the table all other transactions on the table are ignored. I still want to process all inserts and updates on the table but also want to discard updates if the update is to set a specific column to NULL. we are using GG 12.3 with integrated replicat. can anyone provide me a statement that will work for this purpose?
Thank you