repro: materialized_views_ignore_errors metes errors from source table

CheSema · CheSema · commit 1433a389f4e1 · 2024-07-12T15:40:13.000+02:00
diff --git a/tests/queries/0_stateless/03203_materialized_views_ignore_errors.reference b/tests/queries/0_stateless/03203_materialized_views_ignore_errors.reference
@@ -0,0 +1,14 @@
+-- { echoOn }
+
+insert into testX select number from numbers(20)
+    settings materialized_views_ignore_errors = 0; -- { serverError FUNCTION_THROW_IF_VALUE_IS_NON_ZERO }
+select count() from testX;
+0
+select count() from testXA;
+0
+insert into testX select number from numbers(20)
+    settings materialized_views_ignore_errors = 1;
+select count() from testX;
+0
+select count() from testXA;
+0
diff --git a/tests/queries/0_stateless/03203_materialized_views_ignore_errors.sql b/tests/queries/0_stateless/03203_materialized_views_ignore_errors.sql
@@ -0,0 +1,28 @@
+-- more blocks to process
+set max_block_size = 10;
+set min_insert_block_size_rows = 10;
+
+drop table if exists testX;
+drop table if exists testXA;
+
+create table testX (A Int64) engine=MergeTree partition by (intDiv(A, 10), throwIf(A=2)) order by tuple();
+create materialized view testXA engine=MergeTree order by tuple() as select sleep(0.1) from testX;
+
+-- { echoOn }
+
+insert into testX select number from numbers(20)
+    settings materialized_views_ignore_errors = 0; -- { serverError FUNCTION_THROW_IF_VALUE_IS_NON_ZERO }
+
+select count() from testX;
+select count() from testXA;
+
+insert into testX select number from numbers(20)
+    settings materialized_views_ignore_errors = 1;
+
+select count() from testX;
+select count() from testXA;
+
+-- { echoOff }
+
+drop table testX;
+drop view testXA;
