This is an automated email from the ASF dual-hosted git repository.
yiguolei pushed a commit to branch branch-4.1
in repository https://gitbox.apache.org/repos/asf/doris.git
The following commit(s) were added to refs/heads/branch-4.1 by this push:
new dd913a8f6be branch-4.1: [fix](regression) Disable auto compaction in
manual compaction cases #65211 (#65531)
dd913a8f6be is described below
commit dd913a8f6be7fc37846fdd3163a1d660fba73d90
Author: github-actions[bot]
<41898282+github-actions[bot]@users.noreply.github.com>
AuthorDate: Tue Jul 14 09:25:34 2026 +0800
branch-4.1: [fix](regression) Disable auto compaction in manual compaction
cases #65211 (#65531)
Cherry-picked from #65211
Co-authored-by: shuke <[email protected]>
---
.../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 3730a8f603a..a72ccb937be 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
@@ -98,7 +98,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 6bb17da5a09..aaa975a4e4f 100644
--- a/regression-test/suites/point_query_p0/test_point_query.groovy
+++ b/regression-test/suites/point_query_p0/test_point_query.groovy
@@ -352,7 +352,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 94987795c10..553ecb7f5d7 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]
