This is an automated email from the ASF dual-hosted git repository.
hello-stephen pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/doris.git
The following commit(s) were added to refs/heads/master by this push:
new 8ea88fcede6 [fix](regression) Disable auto compaction in manual
compaction cases (#65211)
8ea88fcede6 is described below
commit 8ea88fcede66e4905ad1abf3b1c1b5b49e6823e4
Author: shuke <[email protected]>
AuthorDate: Mon Jul 6 14:34:08 2026 +0800
[fix](regression) Disable auto compaction in manual compaction cases
(#65211)
## Proposed changes
- Disable table-level auto compaction in regression cases that
explicitly call `trigger_and_wait_compaction(...)`.
- Cover manual compaction checks in compaction, schema_change, cloud
cache/balance, point_query, and variant analyzer cases.
- Keep shared DDL changes local to the case call sites where possible.
## Why
These cases want to control compaction timing through explicit helper
calls. If table auto compaction is still enabled, background compaction
can consume the target rowsets first, making the manual trigger get
ignored or observe a different intermediate rowset state.
## Validation
- `git diff --cached --check`
- `git diff --check`
- Scanned `regression-test/suites` for
`trigger_and_wait_compaction(...)`; remaining files without inline table
property are external-DDL cases already disabling auto compaction, or
internal statistics tables without case-owned DDL.
---
.../test_balance_warm_up_with_compaction_use_peer_cache.groovy | 2 +-
regression-test/suites/cloud_p0/cache/ddl/nation.sql | 3 +++
.../cache/multi_cluster/read_write/test_multi_stale_rowset.groovy | 2 +-
.../suites/compaction/test_compacation_with_delete.groovy | 2 +-
regression-test/suites/compaction/test_compaction_agg_keys.groovy | 2 +-
.../suites/compaction/test_compaction_agg_keys_with_array_map.groovy | 3 +--
.../suites/compaction/test_compaction_agg_keys_with_delete.groovy | 2 +-
regression-test/suites/compaction/test_compaction_dup_keys.groovy | 2 +-
.../suites/compaction/test_compaction_dup_keys_with_delete.groovy | 2 +-
regression-test/suites/compaction/test_compaction_uniq_keys.groovy | 2 +-
.../suites/compaction/test_compaction_uniq_keys_ck.groovy | 3 ++-
.../suites/compaction/test_compaction_uniq_keys_row_store.groovy | 1 +
.../suites/compaction/test_compaction_uniq_keys_row_store_ck.groovy | 1 +
.../suites/compaction/test_compaction_uniq_keys_with_delete.groovy | 2 +-
.../compaction/test_compaction_uniq_keys_with_delete_ck.groovy | 3 ++-
.../suites/compaction/test_compaction_with_empty_rowset.groovy | 3 ++-
.../suites/compaction/test_vertical_compaction_agg_keys.groovy | 2 +-
.../suites/compaction/test_vertical_compaction_agg_state.groovy | 2 +-
.../suites/compaction/test_vertical_compaction_dup_keys.groovy | 2 +-
.../suites/compaction/test_vertical_compaction_uniq_keys.groovy | 2 +-
.../suites/compaction/test_vertical_compaction_uniq_keys_ck.groovy | 2 +-
regression-test/suites/point_query_p0/test_point_query.groovy | 2 +-
.../datev2/test_agg_keys_schema_change_datev2.groovy | 2 +-
.../datev2/test_schema_change_varchar_to_datev2.groovy | 2 +-
.../decimalv2/test_agg_keys_schema_change_decimalv2.groovy | 2 +-
.../decimalv3/test_agg_keys_schema_change_decimalv3.groovy | 2 +-
.../suites/schema_change_p0/test_agg_keys_schema_change.groovy | 2 +-
.../suites/schema_change_p0/test_agg_mv_schema_change.groovy | 3 +--
.../suites/schema_change_p0/test_agg_rollup_schema_change.groovy | 2 +-
.../suites/schema_change_p0/test_agg_vals_schema_change.groovy | 2 +-
.../suites/schema_change_p0/test_dup_mv_schema_change.groovy | 2 +-
.../suites/schema_change_p0/test_dup_rollup_schema_change.groovy | 2 +-
.../suites/schema_change_p0/test_dup_vals_schema_change.groovy | 2 +-
.../schema_change_p0/test_schema_change_with_empty_rowset.groovy | 4 ++--
.../suites/schema_change_p0/test_uniq_mv_schema_change.groovy | 2 +-
.../suites/schema_change_p0/test_uniq_rollup_schema_change.groovy | 2 +-
.../suites/schema_change_p0/test_uniq_vals_schema_change.groovy | 2 +-
.../suites/schema_change_p0/test_varchar_schema_change.groovy | 2 +-
.../suites/variant_p0/predefine/test_custom_analyzer.groovy | 5 +++--
39 files changed, 47 insertions(+), 40 deletions(-)
diff --git
a/regression-test/suites/cloud_p0/balance/test_balance_warm_up_with_compaction_use_peer_cache.groovy
b/regression-test/suites/cloud_p0/balance/test_balance_warm_up_with_compaction_use_peer_cache.groovy
index f2209f37f85..39069b703d7 100644
---
a/regression-test/suites/cloud_p0/balance/test_balance_warm_up_with_compaction_use_peer_cache.groovy
+++
b/regression-test/suites/cloud_p0/balance/test_balance_warm_up_with_compaction_use_peer_cache.groovy
@@ -101,7 +101,7 @@
suite('test_balance_warm_up_with_compaction_use_peer_cache', 'docker') {
)
DUPLICATE KEY(`id`)
DISTRIBUTED BY HASH(`id`) BUCKETS 2
- PROPERTIES ("replication_num" = "1");
+ PROPERTIES ("replication_num" = "1", "disable_auto_compaction" =
"true");
"""
sql """
insert into $table values (344083, 1, 'comment', 'spez',
'2008-10-26 13:49:29', 'Stay tuned...', 0, 343906, 0, [31, 454446], '', 0, '',
[], 0), (33, 0, 'comment', 'spez', '2006-10-10 23:50:40', 'winnar winnar
chicken dinnar!', 0, 31, 0, [34, 454450], '', 0, '', [], 0);
diff --git a/regression-test/suites/cloud_p0/cache/ddl/nation.sql
b/regression-test/suites/cloud_p0/cache/ddl/nation.sql
index d6b36e58ec5..45209901c18 100644
--- a/regression-test/suites/cloud_p0/cache/ddl/nation.sql
+++ b/regression-test/suites/cloud_p0/cache/ddl/nation.sql
@@ -23,3 +23,6 @@ CREATE TABLE IF NOT EXISTS nation (
)
DUPLICATE KEY(N_NATIONKEY, N_NAME)
DISTRIBUTED BY HASH(N_NATIONKEY) BUCKETS 1
+PROPERTIES (
+ "disable_auto_compaction" = "true"
+)
diff --git
a/regression-test/suites/cloud_p0/cache/multi_cluster/read_write/test_multi_stale_rowset.groovy
b/regression-test/suites/cloud_p0/cache/multi_cluster/read_write/test_multi_stale_rowset.groovy
index 890691ef003..b2bc06ffd81 100644
---
a/regression-test/suites/cloud_p0/cache/multi_cluster/read_write/test_multi_stale_rowset.groovy
+++
b/regression-test/suites/cloud_p0/cache/multi_cluster/read_write/test_multi_stale_rowset.groovy
@@ -18,7 +18,7 @@
import org.codehaus.groovy.runtime.IOGroovyMethods
suite("test_multi_stale_rowset") {
- def ttlProperties = """ PROPERTIES("file_cache_ttl_seconds"="1200") """
+ def ttlProperties = """ PROPERTIES("file_cache_ttl_seconds"="1200",
"disable_auto_compaction"="true") """
List<String> ipList = new ArrayList<>();
List<String> hbPortList = new ArrayList<>()
List<String> httpPortList = new ArrayList<>()
diff --git
a/regression-test/suites/compaction/test_compacation_with_delete.groovy
b/regression-test/suites/compaction/test_compacation_with_delete.groovy
index 43aaaa5485a..dd5466fe8e3 100644
--- a/regression-test/suites/compaction/test_compacation_with_delete.groovy
+++ b/regression-test/suites/compaction/test_compacation_with_delete.groovy
@@ -61,7 +61,7 @@ suite("test_compaction_with_delete") {
`max_dwell_time` INT DEFAULT "0" COMMENT "用户最大停留时间",
`min_dwell_time` INT DEFAULT "99999" COMMENT "用户最小停留时间")
DUPLICATE KEY(`user_id`, `date`, `datev2`, `datetimev2_1`,
`datetimev2_2`, `city`, `age`, `sex`) DISTRIBUTED BY HASH(`user_id`)
- BUCKETS 1 PROPERTIES ( "replication_num" = "1" );
+ BUCKETS 1 PROPERTIES ( "replication_num" = "1",
"disable_auto_compaction" = "true" );
"""
sql """ INSERT INTO ${tableName} VALUES
diff --git a/regression-test/suites/compaction/test_compaction_agg_keys.groovy
b/regression-test/suites/compaction/test_compaction_agg_keys.groovy
index 480f4696e5f..85e1fd18e15 100644
--- a/regression-test/suites/compaction/test_compaction_agg_keys.groovy
+++ b/regression-test/suites/compaction/test_compaction_agg_keys.groovy
@@ -64,7 +64,7 @@ suite("test_compaction_agg_keys") {
`hll_col` HLL HLL_UNION NOT NULL COMMENT "HLL列",
`bitmap_col` Bitmap BITMAP_UNION NOT NULL COMMENT "bitmap列" )
AGGREGATE KEY(`user_id`, `date`, `datev2`, `datetimev2_1`,
`datetimev2_2`, `city`, `age`, `sex`) DISTRIBUTED BY HASH(`user_id`)
- PROPERTIES ( "replication_num" = "1" );
+ PROPERTIES ( "replication_num" = "1", "disable_auto_compaction" =
"true" );
"""
sql """ INSERT INTO ${tableName} VALUES
diff --git
a/regression-test/suites/compaction/test_compaction_agg_keys_with_array_map.groovy
b/regression-test/suites/compaction/test_compaction_agg_keys_with_array_map.groovy
index bad84c83295..f0e40dac0ce 100644
---
a/regression-test/suites/compaction/test_compaction_agg_keys_with_array_map.groovy
+++
b/regression-test/suites/compaction/test_compaction_agg_keys_with_array_map.groovy
@@ -55,7 +55,7 @@ suite("test_compaction_agg_keys_with_array_map") {
`array_col` ARRAY<STRING> REPLACE NULL COMMENT "array column",
`map_col` MAP<STRING, INT> REPLACE NULL COMMENT "map column")
AGGREGATE KEY(`user_id`, `date`, `datev2`, `datetimev2_1`,
`datetimev2_2`, `city`, `age`, `sex`) DISTRIBUTED BY HASH(`user_id`)
- PROPERTIES ( "replication_num" = "1" );
+ PROPERTIES ( "replication_num" = "1", "disable_auto_compaction" =
"true" );
"""
sql """ INSERT INTO ${tableName} VALUES
@@ -120,4 +120,3 @@ suite("test_compaction_agg_keys_with_array_map") {
try_sql("DROP TABLE IF EXISTS ${tableName}")
}
}
-
diff --git
a/regression-test/suites/compaction/test_compaction_agg_keys_with_delete.groovy
b/regression-test/suites/compaction/test_compaction_agg_keys_with_delete.groovy
index 99ea6077e46..0c6d2d53233 100644
---
a/regression-test/suites/compaction/test_compaction_agg_keys_with_delete.groovy
+++
b/regression-test/suites/compaction/test_compaction_agg_keys_with_delete.groovy
@@ -62,7 +62,7 @@ suite("test_compaction_agg_keys_with_delete") {
`hll_col` HLL HLL_UNION NOT NULL COMMENT "HLL列",
`bitmap_col` Bitmap BITMAP_UNION NOT NULL COMMENT "bitmap列" )
AGGREGATE KEY(`user_id`, `date`, `datev2`, `datetimev2_1`,
`datetimev2_2`, `city`, `age`, `sex`) DISTRIBUTED BY HASH(`user_id`)
- PROPERTIES ( "replication_num" = "1" );
+ PROPERTIES ( "replication_num" = "1", "disable_auto_compaction" =
"true" );
"""
sql """ INSERT INTO ${tableName} VALUES
diff --git a/regression-test/suites/compaction/test_compaction_dup_keys.groovy
b/regression-test/suites/compaction/test_compaction_dup_keys.groovy
index bf435a734b5..1f1f796ade9 100644
--- a/regression-test/suites/compaction/test_compaction_dup_keys.groovy
+++ b/regression-test/suites/compaction/test_compaction_dup_keys.groovy
@@ -62,7 +62,7 @@ suite("test_compaction_dup_keys") {
`max_dwell_time` INT DEFAULT "0" COMMENT "用户最大停留时间",
`min_dwell_time` INT DEFAULT "99999" COMMENT "用户最小停留时间")
DUPLICATE KEY(`user_id`, `date`, `datev2`, `datetimev2_1`,
`datetimev2_2`, `city`, `age`, `sex`) DISTRIBUTED BY HASH(`user_id`)
- PROPERTIES ( "replication_num" = "1" );
+ PROPERTIES ( "replication_num" = "1", "disable_auto_compaction" =
"true" );
"""
sql """ INSERT INTO ${tableName} VALUES
diff --git
a/regression-test/suites/compaction/test_compaction_dup_keys_with_delete.groovy
b/regression-test/suites/compaction/test_compaction_dup_keys_with_delete.groovy
index 02b5cfa95a6..eb8e440c916 100644
---
a/regression-test/suites/compaction/test_compaction_dup_keys_with_delete.groovy
+++
b/regression-test/suites/compaction/test_compaction_dup_keys_with_delete.groovy
@@ -62,7 +62,7 @@ suite("test_compaction_dup_keys_with_delete") {
`max_dwell_time` INT DEFAULT "0" COMMENT "用户最大停留时间",
`min_dwell_time` INT DEFAULT "99999" COMMENT "用户最小停留时间")
DUPLICATE KEY(`user_id`, `date`, `datev2`, `datetimev2_1`,
`datetimev2_2`, `city`, `age`, `sex`) DISTRIBUTED BY HASH(`user_id`)
- PROPERTIES ( "replication_num" = "1" );
+ PROPERTIES ( "replication_num" = "1", "disable_auto_compaction" =
"true" );
"""
sql """ INSERT INTO ${tableName} VALUES
diff --git a/regression-test/suites/compaction/test_compaction_uniq_keys.groovy
b/regression-test/suites/compaction/test_compaction_uniq_keys.groovy
index fac2cc4ac80..7c3fb55e0f0 100644
--- a/regression-test/suites/compaction/test_compaction_uniq_keys.groovy
+++ b/regression-test/suites/compaction/test_compaction_uniq_keys.groovy
@@ -63,7 +63,7 @@ suite("test_compaction_uniq_keys") {
`max_dwell_time` INT DEFAULT "0" COMMENT "用户最大停留时间",
`min_dwell_time` INT DEFAULT "99999" COMMENT "用户最小停留时间")
UNIQUE KEY(`user_id`, `date`, `datev2`, `datetimev2_1`,
`datetimev2_2`, `city`, `age`, `sex`) DISTRIBUTED BY HASH(`user_id`)
- PROPERTIES ( "replication_num" = "1" );
+ PROPERTIES ( "replication_num" = "1", "disable_auto_compaction" =
"true" );
"""
sql """ INSERT INTO ${tableName} VALUES
diff --git
a/regression-test/suites/compaction/test_compaction_uniq_keys_ck.groovy
b/regression-test/suites/compaction/test_compaction_uniq_keys_ck.groovy
index 807da7d067f..1b04bfe835a 100644
--- a/regression-test/suites/compaction/test_compaction_uniq_keys_ck.groovy
+++ b/regression-test/suites/compaction/test_compaction_uniq_keys_ck.groovy
@@ -66,7 +66,8 @@ suite("test_compaction_uniq_keys_ck") {
DISTRIBUTED BY HASH(`user_id`)
PROPERTIES (
"replication_num" = "1",
- "enable_unique_key_merge_on_write" = "true"
+ "enable_unique_key_merge_on_write" = "true",
+ "disable_auto_compaction" = "true"
);
"""
diff --git
a/regression-test/suites/compaction/test_compaction_uniq_keys_row_store.groovy
b/regression-test/suites/compaction/test_compaction_uniq_keys_row_store.groovy
index eecd26506aa..9189c30ef3f 100644
---
a/regression-test/suites/compaction/test_compaction_uniq_keys_row_store.groovy
+++
b/regression-test/suites/compaction/test_compaction_uniq_keys_row_store.groovy
@@ -140,6 +140,7 @@ suite("test_compaction_uniq_keys_row_store", "p0") {
`min_dwell_time` INT DEFAULT "99999" COMMENT "用户最小停留时间")
UNIQUE KEY(`user_id`, `date`, `datev2`, `datetimev2_1`,
`datetimev2_2`, `city`, `age`, `sex`) DISTRIBUTED BY HASH(`user_id`)
PROPERTIES ( "replication_num" = "1",
+ "disable_auto_compaction" = "true",
"enable_unique_key_merge_on_write" = "true",
"light_schema_change" = "true",
"enable_unique_key_skip_bitmap_column" = "false",
diff --git
a/regression-test/suites/compaction/test_compaction_uniq_keys_row_store_ck.groovy
b/regression-test/suites/compaction/test_compaction_uniq_keys_row_store_ck.groovy
index ddf48cde253..2451c2cc765 100644
---
a/regression-test/suites/compaction/test_compaction_uniq_keys_row_store_ck.groovy
+++
b/regression-test/suites/compaction/test_compaction_uniq_keys_row_store_ck.groovy
@@ -142,6 +142,7 @@ suite("test_compaction_uniq_keys_row_store_ck", "p0") {
ORDER BY(`last_visit_date`, `last_update_date`, `city`, `cost`)
DISTRIBUTED BY HASH(`user_id`)
PROPERTIES ( "replication_num" = "1",
+ "disable_auto_compaction" = "true",
"enable_unique_key_merge_on_write" = "true",
"light_schema_change" = "true",
"enable_unique_key_skip_bitmap_column" = "false",
diff --git
a/regression-test/suites/compaction/test_compaction_uniq_keys_with_delete.groovy
b/regression-test/suites/compaction/test_compaction_uniq_keys_with_delete.groovy
index 463597124c7..06f3a00088e 100644
---
a/regression-test/suites/compaction/test_compaction_uniq_keys_with_delete.groovy
+++
b/regression-test/suites/compaction/test_compaction_uniq_keys_with_delete.groovy
@@ -62,7 +62,7 @@ suite("test_compaction_uniq_keys_with_delete") {
`max_dwell_time` INT DEFAULT "0" COMMENT "用户最大停留时间",
`min_dwell_time` INT DEFAULT "99999" COMMENT "用户最小停留时间")
UNIQUE KEY(`user_id`, `date`, `datev2`, `datetimev2_1`,
`datetimev2_2`, `city`, `age`, `sex`) DISTRIBUTED BY HASH(`user_id`)
- PROPERTIES ( "replication_num" = "1" );
+ PROPERTIES ( "replication_num" = "1", "disable_auto_compaction" =
"true" );
"""
sql """ INSERT INTO ${tableName} VALUES
diff --git
a/regression-test/suites/compaction/test_compaction_uniq_keys_with_delete_ck.groovy
b/regression-test/suites/compaction/test_compaction_uniq_keys_with_delete_ck.groovy
index b2092542ce6..d311402612a 100644
---
a/regression-test/suites/compaction/test_compaction_uniq_keys_with_delete_ck.groovy
+++
b/regression-test/suites/compaction/test_compaction_uniq_keys_with_delete_ck.groovy
@@ -67,7 +67,8 @@ suite("test_compaction_uniq_keys_with_delete_ck") {
PROPERTIES (
"replication_num" = "1",
"enable_unique_key_merge_on_write" = "true",
- "enable_mow_light_delete" = "true"
+ "enable_mow_light_delete" = "true",
+ "disable_auto_compaction" = "true"
);
"""
diff --git
a/regression-test/suites/compaction/test_compaction_with_empty_rowset.groovy
b/regression-test/suites/compaction/test_compaction_with_empty_rowset.groovy
index 6f6f869917d..88507c6d8bd 100644
--- a/regression-test/suites/compaction/test_compaction_with_empty_rowset.groovy
+++ b/regression-test/suites/compaction/test_compaction_with_empty_rowset.groovy
@@ -43,7 +43,8 @@ suite("test_compaction_mow_with_empty_rowset", "p0") {
DISTRIBUTED BY HASH(`k1`) BUCKETS 2
PROPERTIES (
"replication_allocation" = "tag.location.default: 1",
- "enable_unique_key_merge_on_write" = "true"
+ "enable_unique_key_merge_on_write" = "true",
+ "disable_auto_compaction" = "true"
);
"""
diff --git
a/regression-test/suites/compaction/test_vertical_compaction_agg_keys.groovy
b/regression-test/suites/compaction/test_vertical_compaction_agg_keys.groovy
index 89493e15343..83adc0c77c8 100644
--- a/regression-test/suites/compaction/test_vertical_compaction_agg_keys.groovy
+++ b/regression-test/suites/compaction/test_vertical_compaction_agg_keys.groovy
@@ -63,7 +63,7 @@ suite("test_vertical_compaction_agg_keys") {
`hll_col` HLL HLL_UNION NOT NULL COMMENT "HLL列",
`bitmap_col` Bitmap BITMAP_UNION NOT NULL COMMENT "bitmap列" )
AGGREGATE KEY(`user_id`, `date`, `datev2`, `datetimev2_1`,
`datetimev2_2`, `city`, `age`, `sex`) DISTRIBUTED BY HASH(`user_id`) BUCKETS 10
- PROPERTIES ( "replication_num" = "1" );
+ PROPERTIES ( "replication_num" = "1", "disable_auto_compaction" =
"true" );
"""
sql """ INSERT INTO ${tableName} VALUES
diff --git
a/regression-test/suites/compaction/test_vertical_compaction_agg_state.groovy
b/regression-test/suites/compaction/test_vertical_compaction_agg_state.groovy
index 22a8f653b74..b9c56d2d5dd 100644
---
a/regression-test/suites/compaction/test_vertical_compaction_agg_state.groovy
+++
b/regression-test/suites/compaction/test_vertical_compaction_agg_state.groovy
@@ -51,7 +51,7 @@ suite("test_vertical_compaction_agg_state") {
AGGREGATE KEY(`user_id`)
COMMENT 'OLAP'
DISTRIBUTED BY HASH(`user_id`) BUCKETS 1
- PROPERTIES ( "replication_num" = "1" );
+ PROPERTIES ( "replication_num" = "1", "disable_auto_compaction" =
"true" );
"""
sql """ INSERT INTO ${tableName} VALUES
diff --git
a/regression-test/suites/compaction/test_vertical_compaction_dup_keys.groovy
b/regression-test/suites/compaction/test_vertical_compaction_dup_keys.groovy
index 7cdf6b67d40..f8557b3afa1 100644
--- a/regression-test/suites/compaction/test_vertical_compaction_dup_keys.groovy
+++ b/regression-test/suites/compaction/test_vertical_compaction_dup_keys.groovy
@@ -62,7 +62,7 @@ suite("test_vertical_compaction_dup_keys") {
`max_dwell_time` INT DEFAULT "0" COMMENT "用户最大停留时间",
`min_dwell_time` INT DEFAULT "99999" COMMENT "用户最小停留时间")
DUPLICATE KEY(`user_id`, `date`, `datev2`, `datetimev2_1`,
`datetimev2_2`, `city`, `age`, `sex`) DISTRIBUTED BY HASH(`user_id`)
- PROPERTIES ( "replication_num" = "1" );
+ PROPERTIES ( "replication_num" = "1", "disable_auto_compaction" =
"true" );
"""
sql """ INSERT INTO ${tableName} VALUES
diff --git
a/regression-test/suites/compaction/test_vertical_compaction_uniq_keys.groovy
b/regression-test/suites/compaction/test_vertical_compaction_uniq_keys.groovy
index 6bff003a028..90dfed237d1 100644
---
a/regression-test/suites/compaction/test_vertical_compaction_uniq_keys.groovy
+++
b/regression-test/suites/compaction/test_vertical_compaction_uniq_keys.groovy
@@ -61,7 +61,7 @@ suite("test_vertical_compaction_uniq_keys") {
`max_dwell_time` INT DEFAULT "0" COMMENT "用户最大停留时间",
`min_dwell_time` INT DEFAULT "99999" COMMENT "用户最小停留时间")
UNIQUE KEY(`user_id`, `date`, `datev2`, `datetimev2_1`,
`datetimev2_2`, `city`, `age`, `sex`) DISTRIBUTED BY HASH(`user_id`)
- PROPERTIES ( "replication_num" = "1",
"enable_unique_key_merge_on_write"="true" );
+ PROPERTIES ( "replication_num" = "1",
"enable_unique_key_merge_on_write"="true", "disable_auto_compaction" = "true" );
"""
sql """ INSERT INTO ${tableName} VALUES
diff --git
a/regression-test/suites/compaction/test_vertical_compaction_uniq_keys_ck.groovy
b/regression-test/suites/compaction/test_vertical_compaction_uniq_keys_ck.groovy
index 665cc9d47d8..aaaea4e8f1e 100644
---
a/regression-test/suites/compaction/test_vertical_compaction_uniq_keys_ck.groovy
+++
b/regression-test/suites/compaction/test_vertical_compaction_uniq_keys_ck.groovy
@@ -63,7 +63,7 @@ suite("test_vertical_compaction_uniq_keys_ck") {
UNIQUE KEY(`user_id`, `date`, `datev2`, `datetimev2_1`,
`datetimev2_2`, `city`, `age`, `sex`)
ORDER BY(`age`, `sex`, `user_id`)
DISTRIBUTED BY HASH(`user_id`)
- PROPERTIES ( "replication_num" = "1",
"enable_unique_key_merge_on_write"="true" );
+ PROPERTIES ( "replication_num" = "1",
"enable_unique_key_merge_on_write"="true", "disable_auto_compaction" = "true" );
"""
sql """ INSERT INTO ${tableName} VALUES
diff --git a/regression-test/suites/point_query_p0/test_point_query.groovy
b/regression-test/suites/point_query_p0/test_point_query.groovy
index e76cd14df80..5edc2660f3a 100644
--- a/regression-test/suites/point_query_p0/test_point_query.groovy
+++ b/regression-test/suites/point_query_p0/test_point_query.groovy
@@ -453,7 +453,7 @@ suite("test_point_query") {
INDEX col2 (`col2`) USING INVERTED )
ENGINE=OLAP UNIQUE KEY(`col1`, `col2`, `loc3`)
DISTRIBUTED BY HASH(`col1`, `col2`, `loc3`) BUCKETS 1
- PROPERTIES ( "replication_allocation" = "tag.location.default: 1",
"bloom_filter_columns" = "col1", "store_row_column" = "true",
"enable_mow_light_delete" = "false" );
+ PROPERTIES ( "replication_allocation" = "tag.location.default: 1",
"disable_auto_compaction" = "true", "bloom_filter_columns" = "col1",
"store_row_column" = "true", "enable_mow_light_delete" = "false" );
"""
explain {
sql("select * from table_3821461 where col1 = -10 and col2 = 20 and
loc3 = 'aabc'")
diff --git
a/regression-test/suites/schema_change_p0/datev2/test_agg_keys_schema_change_datev2.groovy
b/regression-test/suites/schema_change_p0/datev2/test_agg_keys_schema_change_datev2.groovy
index 14a5f046831..f05f26f910f 100644
---
a/regression-test/suites/schema_change_p0/datev2/test_agg_keys_schema_change_datev2.groovy
+++
b/regression-test/suites/schema_change_p0/datev2/test_agg_keys_schema_change_datev2.groovy
@@ -51,7 +51,7 @@ suite("test_agg_keys_schema_change_datev2") {
)
AGGREGATE KEY(`datek1`,`datek2`)
DISTRIBUTED BY HASH(`datek1`) BUCKETS 1
- PROPERTIES("replication_num" = "1", "light_schema_change" =
"false");
+ PROPERTIES("replication_num" = "1", "disable_auto_compaction" =
"true", "light_schema_change" = "false");
"""
// datev2
sql """ insert into ${tbName} values('2022-01-02', '2022-01-02 11:11:11',
'2022-01-02', '2022-01-02 11:11:11');"""
diff --git
a/regression-test/suites/schema_change_p0/datev2/test_schema_change_varchar_to_datev2.groovy
b/regression-test/suites/schema_change_p0/datev2/test_schema_change_varchar_to_datev2.groovy
index 56f8d288b4c..066ac1149f9 100644
---
a/regression-test/suites/schema_change_p0/datev2/test_schema_change_varchar_to_datev2.groovy
+++
b/regression-test/suites/schema_change_p0/datev2/test_schema_change_varchar_to_datev2.groovy
@@ -51,7 +51,7 @@ suite("test_schema_change_varchar_to_datev2") {
)
AGGREGATE KEY(`k1`,`k2`,`k3`)
DISTRIBUTED BY HASH(`k1`,`k2`) BUCKETS 1
- PROPERTIES("replication_num" = "1", "light_schema_change" =
"false");
+ PROPERTIES("replication_num" = "1", "disable_auto_compaction" =
"true", "light_schema_change" = "false");
"""
// insert
sql """ insert into ${tbName} values(1,"1","20200101",1,1),
(2,"2","2020/01/02",2,2), (3,"3","2020-01-03",3,3), (4,"4","200104",4,4),
(5,"5","20/01/05",5,5), (6,"6","20-01-06",6,6)"""
diff --git
a/regression-test/suites/schema_change_p0/decimalv2/test_agg_keys_schema_change_decimalv2.groovy
b/regression-test/suites/schema_change_p0/decimalv2/test_agg_keys_schema_change_decimalv2.groovy
index c455454db54..2dc68f815ae 100644
---
a/regression-test/suites/schema_change_p0/decimalv2/test_agg_keys_schema_change_decimalv2.groovy
+++
b/regression-test/suites/schema_change_p0/decimalv2/test_agg_keys_schema_change_decimalv2.groovy
@@ -65,7 +65,7 @@ suite("test_agg_keys_schema_change_decimalv2",
"nonConcurrent") {
)
AGGREGATE KEY(`decimalv2k1`,`decimalv2k2`, decimalv2k3)
DISTRIBUTED BY HASH(`decimalv2k1`) BUCKETS 1
- PROPERTIES("replication_num" = "1", "light_schema_change" =
"false");
+ PROPERTIES("replication_num" = "1", "disable_auto_compaction" =
"true", "light_schema_change" = "false");
"""
sql """ insert into ${tbName} values
(111111111111111111.111111111,999999999999999999.994,999999999999999999.999,999999999999999999.999999994,999999999999999999.995);
diff --git
a/regression-test/suites/schema_change_p0/decimalv3/test_agg_keys_schema_change_decimalv3.groovy
b/regression-test/suites/schema_change_p0/decimalv3/test_agg_keys_schema_change_decimalv3.groovy
index 0cbd8ec0823..475a8a1ce38 100644
---
a/regression-test/suites/schema_change_p0/decimalv3/test_agg_keys_schema_change_decimalv3.groovy
+++
b/regression-test/suites/schema_change_p0/decimalv3/test_agg_keys_schema_change_decimalv3.groovy
@@ -51,7 +51,7 @@ suite("test_agg_keys_schema_change_decimalv3") {
)
AGGREGATE KEY(`decimalv3k1`,`decimalv3k2`)
DISTRIBUTED BY HASH(`decimalv3k1`) BUCKETS 1
- PROPERTIES("replication_num" = "1", "light_schema_change" =
"false");
+ PROPERTIES("replication_num" = "1", "disable_auto_compaction" =
"true", "light_schema_change" = "false");
"""
sql """ insert into ${tbName}
values(0.111111111111111111111111111111111,11111111111111111111111111111.11,0.111111111111111111111111111111111,11111111111111111111111111111.11);"""
qt_sql """select * from ${tbName} ORDER BY `decimalv3k1`;"""
diff --git
a/regression-test/suites/schema_change_p0/test_agg_keys_schema_change.groovy
b/regression-test/suites/schema_change_p0/test_agg_keys_schema_change.groovy
index a23ee27801d..0c15f135733 100644
--- a/regression-test/suites/schema_change_p0/test_agg_keys_schema_change.groovy
+++ b/regression-test/suites/schema_change_p0/test_agg_keys_schema_change.groovy
@@ -47,7 +47,7 @@ suite ("test_agg_keys_schema_change") {
`bitmap_col` Bitmap BITMAP_UNION NOT NULL COMMENT
"bitmap列")
AGGREGATE KEY(`user_id`, `date`, `city`, `age`, `sex`)
DISTRIBUTED BY HASH(`user_id`)
BUCKETS 8
- PROPERTIES ( "replication_num" = "1", "light_schema_change" =
"false" );
+ PROPERTIES ( "replication_num" = "1",
"disable_auto_compaction" = "true", "light_schema_change" = "false" );
"""
sql """ INSERT INTO schema_change_agg_keys_regression_test VALUES
diff --git
a/regression-test/suites/schema_change_p0/test_agg_mv_schema_change.groovy
b/regression-test/suites/schema_change_p0/test_agg_mv_schema_change.groovy
index bccb30069dd..c36bd4567f9 100644
--- a/regression-test/suites/schema_change_p0/test_agg_mv_schema_change.groovy
+++ b/regression-test/suites/schema_change_p0/test_agg_mv_schema_change.groovy
@@ -64,7 +64,7 @@ suite ("test_agg_mv_schema_change") {
`bitmap_col` Bitmap BITMAP_UNION NOT NULL COMMENT
"bitmap列")
AGGREGATE KEY(`user_id`, `date`, `city`, `age`, `sex`)
DISTRIBUTED BY HASH(`user_id`)
BUCKETS 8
- PROPERTIES ( "replication_num" = "1", "light_schema_change" =
"false" );
+ PROPERTIES ( "replication_num" = "1",
"disable_auto_compaction" = "true", "light_schema_change" = "false" );
"""
sql """ INSERT INTO ${tableName} VALUES
@@ -160,4 +160,3 @@ suite ("test_agg_mv_schema_change") {
}
-
diff --git
a/regression-test/suites/schema_change_p0/test_agg_rollup_schema_change.groovy
b/regression-test/suites/schema_change_p0/test_agg_rollup_schema_change.groovy
index 73d9e9ad810..557d779607b 100644
---
a/regression-test/suites/schema_change_p0/test_agg_rollup_schema_change.groovy
+++
b/regression-test/suites/schema_change_p0/test_agg_rollup_schema_change.groovy
@@ -64,7 +64,7 @@ suite ("test_agg_rollup_schema_change") {
`bitmap_col` Bitmap BITMAP_UNION NOT NULL COMMENT
"bitmap列")
AGGREGATE KEY(`user_id`, `date`, `city`, `age`, `sex`)
DISTRIBUTED BY HASH(`user_id`)
BUCKETS 8
- PROPERTIES ( "replication_num" = "1", "light_schema_change" =
"false" );
+ PROPERTIES ( "replication_num" = "1",
"disable_auto_compaction" = "true", "light_schema_change" = "false" );
"""
//add rollup
diff --git
a/regression-test/suites/schema_change_p0/test_agg_vals_schema_change.groovy
b/regression-test/suites/schema_change_p0/test_agg_vals_schema_change.groovy
index 99831429860..7744d956182 100644
--- a/regression-test/suites/schema_change_p0/test_agg_vals_schema_change.groovy
+++ b/regression-test/suites/schema_change_p0/test_agg_vals_schema_change.groovy
@@ -45,7 +45,7 @@ suite ("test_agg_vals_schema_change") {
`bitmap_col` Bitmap BITMAP_UNION NOT NULL COMMENT
"bitmap列")
AGGREGATE KEY(`user_id`, `date`, `city`, `age`, `sex`)
DISTRIBUTED BY HASH(`user_id`)
BUCKETS 8
- PROPERTIES ( "replication_num" = "1", "light_schema_change" =
"false" );
+ PROPERTIES ( "replication_num" = "1",
"disable_auto_compaction" = "true", "light_schema_change" = "false" );
"""
sql """ INSERT INTO ${tableName} VALUES
diff --git
a/regression-test/suites/schema_change_p0/test_dup_mv_schema_change.groovy
b/regression-test/suites/schema_change_p0/test_dup_mv_schema_change.groovy
index dcf0a65cfec..4373257fb60 100644
--- a/regression-test/suites/schema_change_p0/test_dup_mv_schema_change.groovy
+++ b/regression-test/suites/schema_change_p0/test_dup_mv_schema_change.groovy
@@ -59,7 +59,7 @@ suite ("test_dup_mv_schema_change") {
`min_dwell_time` INT DEFAULT "99999" COMMENT "用户最小停留时间")
DUPLICATE KEY(`user_id`, `date`, `city`, `age`, `sex`)
DISTRIBUTED BY HASH(`user_id`)
BUCKETS 8
- PROPERTIES ( "replication_num" = "1", "light_schema_change" =
"false" );
+ PROPERTIES ( "replication_num" = "1",
"disable_auto_compaction" = "true", "light_schema_change" = "false" );
"""
sql """ INSERT INTO ${tableName} VALUES
diff --git
a/regression-test/suites/schema_change_p0/test_dup_rollup_schema_change.groovy
b/regression-test/suites/schema_change_p0/test_dup_rollup_schema_change.groovy
index c25ffe1039a..df36f0faba8 100644
---
a/regression-test/suites/schema_change_p0/test_dup_rollup_schema_change.groovy
+++
b/regression-test/suites/schema_change_p0/test_dup_rollup_schema_change.groovy
@@ -64,7 +64,7 @@ suite ("test_dup_rollup_schema_change") {
`min_dwell_time` INT DEFAULT "99999" COMMENT "用户最小停留时间")
DUPLICATE KEY(`user_id`, `date`, `city`, `age`, `sex`)
DISTRIBUTED BY HASH(`user_id`)
BUCKETS 8
- PROPERTIES ( "replication_num" = "1", "light_schema_change" =
"false" );
+ PROPERTIES ( "replication_num" = "1",
"disable_auto_compaction" = "true", "light_schema_change" = "false" );
"""
//add rollup
diff --git
a/regression-test/suites/schema_change_p0/test_dup_vals_schema_change.groovy
b/regression-test/suites/schema_change_p0/test_dup_vals_schema_change.groovy
index 2348daad9fa..6f53764d881 100644
--- a/regression-test/suites/schema_change_p0/test_dup_vals_schema_change.groovy
+++ b/regression-test/suites/schema_change_p0/test_dup_vals_schema_change.groovy
@@ -45,7 +45,7 @@ suite ("test_dup_vals_schema_change") {
`min_dwell_time` INT DEFAULT "99999" COMMENT "用户最小停留时间")
DUPLICATE KEY(`user_id`, `date`, `city`, `age`, `sex`)
DISTRIBUTED BY HASH(`user_id`)
BUCKETS 8
- PROPERTIES ( "replication_num" = "1", "light_schema_change" =
"false" );
+ PROPERTIES ( "replication_num" = "1",
"disable_auto_compaction" = "true", "light_schema_change" = "false" );
"""
sql """ INSERT INTO ${tableName} VALUES
diff --git
a/regression-test/suites/schema_change_p0/test_schema_change_with_empty_rowset.groovy
b/regression-test/suites/schema_change_p0/test_schema_change_with_empty_rowset.groovy
index 4f1eaebde6c..008b1033e9e 100644
---
a/regression-test/suites/schema_change_p0/test_schema_change_with_empty_rowset.groovy
+++
b/regression-test/suites/schema_change_p0/test_schema_change_with_empty_rowset.groovy
@@ -53,7 +53,8 @@ suite("test_schema_change_with_empty_rowset",
"p0,nonConcurrent") {
DISTRIBUTED BY HASH(`k1`) BUCKETS 2
PROPERTIES (
"replication_allocation" = "tag.location.default: 1",
- "enable_unique_key_merge_on_write" = "true"
+ "enable_unique_key_merge_on_write" = "true",
+ "disable_auto_compaction" = "true"
);
"""
@@ -88,4 +89,3 @@ suite("test_schema_change_with_empty_rowset",
"p0,nonConcurrent") {
qt_sql """ select sum(k1), sum(k2) from ${tableName} """
}
}
-
diff --git
a/regression-test/suites/schema_change_p0/test_uniq_mv_schema_change.groovy
b/regression-test/suites/schema_change_p0/test_uniq_mv_schema_change.groovy
index 8535c00ac82..d34ed7e993c 100644
--- a/regression-test/suites/schema_change_p0/test_uniq_mv_schema_change.groovy
+++ b/regression-test/suites/schema_change_p0/test_uniq_mv_schema_change.groovy
@@ -46,7 +46,7 @@ suite ("test_uniq_mv_schema_change") {
`min_dwell_time` INT DEFAULT "99999" COMMENT "用户最小停留时间")
UNIQUE KEY(`user_id`, `date`, `city`, `age`, `sex`) DISTRIBUTED BY
HASH(`user_id`)
BUCKETS 8
- PROPERTIES ( "replication_num" = "1", "light_schema_change" =
"false", 'enable_unique_key_merge_on_write' = 'false');
+ PROPERTIES ( "replication_num" = "1", "disable_auto_compaction" =
"true", "light_schema_change" = "false", 'enable_unique_key_merge_on_write' =
'false');
"""
sql """ INSERT INTO ${tableName} VALUES
diff --git
a/regression-test/suites/schema_change_p0/test_uniq_rollup_schema_change.groovy
b/regression-test/suites/schema_change_p0/test_uniq_rollup_schema_change.groovy
index 52372b3cc13..1118481c8b2 100644
---
a/regression-test/suites/schema_change_p0/test_uniq_rollup_schema_change.groovy
+++
b/regression-test/suites/schema_change_p0/test_uniq_rollup_schema_change.groovy
@@ -64,7 +64,7 @@ suite ("test_uniq_rollup_schema_change") {
`min_dwell_time` INT DEFAULT "99999" COMMENT "用户最小停留时间")
UNIQUE KEY(`user_id`, `date`, `city`, `age`, `sex`) DISTRIBUTED BY
HASH(`user_id`)
BUCKETS 8
- PROPERTIES ( "replication_num" = "1", "light_schema_change" =
"false", 'enable_unique_key_merge_on_write' = 'false');
+ PROPERTIES ( "replication_num" = "1", "disable_auto_compaction" =
"true", "light_schema_change" = "false", 'enable_unique_key_merge_on_write' =
'false');
"""
sql """ INSERT INTO ${tableName} VALUES
diff --git
a/regression-test/suites/schema_change_p0/test_uniq_vals_schema_change.groovy
b/regression-test/suites/schema_change_p0/test_uniq_vals_schema_change.groovy
index 72ff4fe564d..f3440dbedec 100644
---
a/regression-test/suites/schema_change_p0/test_uniq_vals_schema_change.groovy
+++
b/regression-test/suites/schema_change_p0/test_uniq_vals_schema_change.groovy
@@ -46,7 +46,7 @@ suite ("test_uniq_vals_schema_change") {
`min_dwell_time` INT DEFAULT "99999" COMMENT "用户最小停留时间")
UNIQUE KEY(`user_id`, `date`, `city`, `age`, `sex`)
DISTRIBUTED BY HASH(`user_id`)
BUCKETS 8
- PROPERTIES ( "replication_num" = "1", "light_schema_change" =
"false" );
+ PROPERTIES ( "replication_num" = "1",
"disable_auto_compaction" = "true", "light_schema_change" = "false" );
"""
sql """ INSERT INTO ${tableName} VALUES
diff --git
a/regression-test/suites/schema_change_p0/test_varchar_schema_change.groovy
b/regression-test/suites/schema_change_p0/test_varchar_schema_change.groovy
index 9387cdaed06..330d62b014b 100644
--- a/regression-test/suites/schema_change_p0/test_varchar_schema_change.groovy
+++ b/regression-test/suites/schema_change_p0/test_varchar_schema_change.groovy
@@ -42,7 +42,7 @@ suite ("test_varchar_schema_change") {
`c2` VARCHAR(20),
`c3` VARCHAR(5) DEFAULT '0'
) DISTRIBUTED BY HASH(c0) BUCKETS 1
- PROPERTIES ( "replication_num" = "1", "light_schema_change" =
"true" )
+ PROPERTIES ( "replication_num" = "1",
"disable_auto_compaction" = "true", "light_schema_change" = "true" )
"""
sql """ insert into ${tableName} values
diff --git
a/regression-test/suites/variant_p0/predefine/test_custom_analyzer.groovy
b/regression-test/suites/variant_p0/predefine/test_custom_analyzer.groovy
index a38a3cd755a..5febd310e4d 100644
--- a/regression-test/suites/variant_p0/predefine/test_custom_analyzer.groovy
+++ b/regression-test/suites/variant_p0/predefine/test_custom_analyzer.groovy
@@ -95,7 +95,8 @@ suite("test_variant_custom_analyzer", "p0") {
DUPLICATE KEY(`a`)
DISTRIBUTED BY RANDOM BUCKETS 1
PROPERTIES (
- "replication_allocation" = "tag.location.default: 1"
+ "replication_allocation" = "tag.location.default: 1",
+ "disable_auto_compaction" = "true"
);
"""
@@ -172,4 +173,4 @@ suite("test_variant_custom_analyzer", "p0") {
logger.info("used by index")
}
}
-}
\ No newline at end of file
+}
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
