This is an automated email from the ASF dual-hosted git repository.
morrysnow pushed a commit to branch branch-3.1
in repository https://gitbox.apache.org/repos/asf/doris.git
The following commit(s) were added to refs/heads/branch-3.1 by this push:
new 7cd37a90666 branch-3.1: [fix](regression) fix unstable case
test_iceberg_sys_table #53631 (#53771)
7cd37a90666 is described below
commit 7cd37a9066652a7fdc12da86d33fb63ef508711f
Author: github-actions[bot]
<41898282+github-actions[bot]@users.noreply.github.com>
AuthorDate: Thu Jul 24 10:36:39 2025 +0800
branch-3.1: [fix](regression) fix unstable case test_iceberg_sys_table
#53631 (#53771)
Cherry-picked from #53631
Co-authored-by: Socrates <[email protected]>
---
.../create_preinstalled_scripts/iceberg/run13.sql | 27 ++++++++++++++-------
.../iceberg/test_iceberg_sys_table.out | Bin 33420 -> 38164 bytes
2 files changed, 18 insertions(+), 9 deletions(-)
diff --git
a/docker/thirdparties/docker-compose/iceberg/scripts/create_preinstalled_scripts/iceberg/run13.sql
b/docker/thirdparties/docker-compose/iceberg/scripts/create_preinstalled_scripts/iceberg/run13.sql
index 4d680f009df..8bf10ad7d58 100644
---
a/docker/thirdparties/docker-compose/iceberg/scripts/create_preinstalled_scripts/iceberg/run13.sql
+++
b/docker/thirdparties/docker-compose/iceberg/scripts/create_preinstalled_scripts/iceberg/run13.sql
@@ -1,28 +1,37 @@
use demo.test_db;
-SET spark.sql.catalog.spark_catalog.write.delete.mode = merge-on-read;
-SET spark.sql.catalog.spark_catalog.write.update.mode = merge-on-read;
-
CREATE TABLE test_iceberg_systable_unpartitioned (
id INT,
name STRING
)
-USING ICEBERG;
+USING ICEBERG
+TBLPROPERTIES (
+ 'primary-key' = 'id',
+ 'write.upsert.enabled' = 'true'
+);
CREATE TABLE test_iceberg_systable_partitioned (
id INT,
name STRING
)
USING ICEBERG
-PARTITIONED BY (id);
+PARTITIONED BY (id)
+TBLPROPERTIES (
+ 'primary-key' = 'id',
+ 'write.upsert.enabled' = 'true'
+);
INSERT INTO test_iceberg_systable_unpartitioned VALUES
(1, 'Alice'), (2, 'Bob'), (3, 'Carol'), (4, 'Dave'), (5, 'Eve'),
(6, 'Frank'), (7, 'Grace'), (8, 'Heidi'), (9, 'Ivan'), (10, 'Judy');
+INSERT INTO test_iceberg_systable_unpartitioned VALUES (2, 'Bob Updated');
+DELETE FROM test_iceberg_systable_unpartitioned WHERE id = 3;
+
INSERT INTO test_iceberg_systable_partitioned VALUES
-(1, 'Alice'), (2, 'Bob'), (3, 'Carol'), (4, 'Dave'), (5, 'Eve'),
-(6, 'Frank'), (7, 'Grace'), (8, 'Heidi'), (9, 'Ivan'), (10, 'Judy');
+(1, 'Alice'), (2, 'Bob'), (3, 'Carol'), (4, 'Dave'),
+(5, 'Eve'), (6, 'Frank'), (7, 'Grace'), (8, 'Heidi'),
+(9, 'Ivan'), (10, 'Judy');
-DELETE FROM test_iceberg_systable_unpartitioned WHERE id % 2 = 1;
-DELETE FROM test_iceberg_systable_partitioned WHERE id % 2 = 1;
\ No newline at end of file
+INSERT INTO test_iceberg_systable_partitioned VALUES (2, 'Bob Updated');
+DELETE FROM test_iceberg_systable_partitioned WHERE id = 3;
\ No newline at end of file
diff --git
a/regression-test/data/external_table_p0/iceberg/test_iceberg_sys_table.out
b/regression-test/data/external_table_p0/iceberg/test_iceberg_sys_table.out
index d637ee94c14..f6b7072cc54 100644
Binary files
a/regression-test/data/external_table_p0/iceberg/test_iceberg_sys_table.out and
b/regression-test/data/external_table_p0/iceberg/test_iceberg_sys_table.out
differ
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
