Skip to content

Commit cadc1e0

Browse files
committed
[test](regression) Update IVM drop column expectations
### What problem does this PR solve? Issue Number: close apache#27313 Related PR: apache#28 Problem Summary: Update the IVM DROP COLUMN regression case to verify that dropping an unused base-table column does not require a complete fallback. The case now checks that incremental refresh succeeds immediately and remains usable for a following incremental refresh. ### Release note None ### Check List (For Author) - Test: Not run (the owner will rebuild FE and regenerate the expected output) - Behavior changed: No - Does this need documentation: No
1 parent 04983d6 commit cadc1e0

1 file changed

Lines changed: 5 additions & 13 deletions

File tree

‎regression-test/suites/mtmv_p0/ivm/test_ivm_drop_column_fallback_reason.groovy‎

Lines changed: 5 additions & 13 deletions
Original file line numberDiff line numberDiff line change
@@ -87,32 +87,24 @@ suite("test_ivm_drop_column_fallback_reason", "nonConcurrent") {
8787

8888
sql """REFRESH MATERIALIZED VIEW ivm_drop_col_reason_mv INCREMENTAL"""
8989
taskId = waitForNewTask(taskId)
90-
order_qt_strict_task """
91-
SELECT Status, RefreshMode, IvmFallbackReason
92-
FROM tasks('type'='mv') WHERE TaskId = '${taskId}'
93-
ORDER BY TaskId
94-
"""
95-
96-
sql """REFRESH MATERIALIZED VIEW ivm_drop_col_reason_mv INCREMENTAL FALLBACK"""
97-
taskId = waitForNewTask(taskId)
98-
order_qt_fallback_task """
99-
SELECT Status, RefreshMode, IvmFallbackReason
90+
order_qt_after_drop_column_task """
91+
SELECT Status, IFNULL(IvmFallbackReason, 'NONE')
10092
FROM tasks('type'='mv') WHERE TaskId = '${taskId}'
10193
ORDER BY TaskId
10294
"""
103-
order_qt_rows_after_fallback """
95+
order_qt_rows_after_drop_column """
10496
SELECT id, value FROM ivm_drop_col_reason_mv ORDER BY id
10597
"""
10698

10799
sql """INSERT INTO ivm_drop_col_reason_t(id, value) VALUES (4, 40)"""
108100
sql """REFRESH MATERIALIZED VIEW ivm_drop_col_reason_mv INCREMENTAL"""
109101
taskId = waitForNewTask(taskId)
110-
order_qt_recovered_task """
102+
order_qt_following_incremental_task """
111103
SELECT Status, IFNULL(IvmFallbackReason, 'NONE')
112104
FROM tasks('type'='mv') WHERE TaskId = '${taskId}'
113105
ORDER BY TaskId
114106
"""
115-
order_qt_rows_after_recovered_incremental """
107+
order_qt_rows_after_following_incremental """
116108
SELECT id, value FROM ivm_drop_col_reason_mv ORDER BY id
117109
"""
118110
}

0 commit comments

Comments
 (0)