Update tests/integration/test_replicated_database/test.py

Algunenano · web-flow · commit 9d2043f59135 · 2025-11-19T20:36:59.000+01:00
diff --git a/tests/integration/test_replicated_database/test.py b/tests/integration/test_replicated_database/test.py
@@ -1940,7 +1940,7 @@ def test_mv_false_cyclic_dependency(started_cluster):
         f"""
         CREATE DATABASE {db_name} ENGINE = Replicated('/clickhouse/databases/{db_name}', '{{shard}}', '{{replica}}');
         CREATE TABLE {db_name}.table_1 (id Int32) ENGINE = MergeTree ORDER BY id;
-        CREATE MATERIALIZED VIEW {db_name}.table_2 (id Int32) ENGINE = MergeTree ORDER BY id AS WITH table_3 AS (SELECT id AS id FROM {db_name}.table_1) SELECT * FROM {db_name}.table_3;
+        CREATE MATERIALIZED VIEW {db_name}.table_2 (id Int32) ENGINE = MergeTree ORDER BY id AS WITH table_3 AS (SELECT id AS id FROM {db_name}.table_1) SELECT * FROM table_3;
         CREATE MATERIALIZED VIEW {db_name}.table_3 (id Int32) ENGINE = MergeTree ORDER BY id AS SELECT id AS id FROM {db_name}.table_2;
         """
     )

Original file line number	Diff line number	Diff line change
`@@ -1940,7 +1940,7 @@ def test_mv_false_cyclic_dependency(started_cluster):`
`1940`	`1940`	`f"""`
`1941`	`1941`	`CREATE DATABASE {db_name} ENGINE = Replicated('/clickhouse/databases/{db_name}', '{{shard}}', '{{replica}}');`
`1942`	`1942`	`CREATE TABLE {db_name}.table_1 (id Int32) ENGINE = MergeTree ORDER BY id;`
`1943`		`- CREATE MATERIALIZED VIEW {db_name}.table_2 (id Int32) ENGINE = MergeTree ORDER BY id AS WITH table_3 AS (SELECT id AS id FROM {db_name}.table_1) SELECT * FROM {db_name}.table_3;`
	`1943`	`+ CREATE MATERIALIZED VIEW {db_name}.table_2 (id Int32) ENGINE = MergeTree ORDER BY id AS WITH table_3 AS (SELECT id AS id FROM {db_name}.table_1) SELECT * FROM table_3;`
`1944`	`1944`	`CREATE MATERIALIZED VIEW {db_name}.table_3 (id Int32) ENGINE = MergeTree ORDER BY id AS SELECT id AS id FROM {db_name}.table_2;`
`1945`	`1945`	`"""`
`1946`	`1946`	`)`