Add Deduplicate_blocks_in_dependent_materialized_views Option to Control the Behaviour of Idempotent Inserts into Tables with Materialized Views

Why it matters

This feature solves the problem of controlling how deduplication is handled when performing idempotent inserts on tables that have dependent materialized views. It provides users with the ability to enable or disable deduplication in such scenarios, improving data consistency and preventing unintended duplicates.

How to use it

Users can enable or disable this behavior by setting the deduplicate_blocks_in_dependent_materialized_views option in the server configuration or as a session setting. For example, to enable deduplication, set:

SET deduplicate_blocks_in_dependent_materialized_views = 1;

To disable it, set the value to 0.