This is an automated email from the ASF dual-hosted git repository.

yiguolei pushed a commit to branch branch-4.0
in repository https://gitbox.apache.org/repos/asf/doris.git


The following commit(s) were added to refs/heads/branch-4.0 by this push:
     new 5ab0c35dcaf branch-4.0: [fix](regression) fix regression #56676 
(#56690)
5ab0c35dcaf is described below

commit 5ab0c35dcaf3f6ebbc286aad544fe11e359b697f
Author: github-actions[bot] 
<41898282+github-actions[bot]@users.noreply.github.com>
AuthorDate: Wed Oct 1 11:22:55 2025 +0800

    branch-4.0: [fix](regression) fix regression #56676 (#56690)
    
    Cherry-picked from #56676
    
    Co-authored-by: TengJianPing <[email protected]>
---
 .../base_cases/one_level_nestedtypes_with_s3data.groovy           | 2 ++
 .../need_read_data/test_dup_table_inverted_index.groovy           | 8 ++++++--
 2 files changed, 8 insertions(+), 2 deletions(-)

diff --git 
a/regression-test/suites/datatype_p0/nested_types/base_cases/one_level_nestedtypes_with_s3data.groovy
 
b/regression-test/suites/datatype_p0/nested_types/base_cases/one_level_nestedtypes_with_s3data.groovy
index a5cbe19bec5..57feffbb9eb 100644
--- 
a/regression-test/suites/datatype_p0/nested_types/base_cases/one_level_nestedtypes_with_s3data.groovy
+++ 
b/regression-test/suites/datatype_p0/nested_types/base_cases/one_level_nestedtypes_with_s3data.groovy
@@ -76,6 +76,7 @@ suite("one_level_nestedtypes_with_s3data") {
         }
     }
     def load_from_s3 = {table_name, uri_file, format ->
+        sql "set enable_insert_strict = false;"
         if (format == "csv") {
             order_qt_sql_s3 """select * from s3(
                 "uri" = "${uri_file}",
@@ -113,6 +114,7 @@ suite("one_level_nestedtypes_with_s3data") {
                     "provider" = "${getS3Provider()}",
                     "read_json_by_line"="true"); """
         }
+        sql "set enable_insert_strict = true;"
     }
 
     // step1. create table
diff --git 
a/regression-test/suites/inverted_index_p1/need_read_data/test_dup_table_inverted_index.groovy
 
b/regression-test/suites/inverted_index_p1/need_read_data/test_dup_table_inverted_index.groovy
index f2971dbc8b0..8b474788759 100644
--- 
a/regression-test/suites/inverted_index_p1/need_read_data/test_dup_table_inverted_index.groovy
+++ 
b/regression-test/suites/inverted_index_p1/need_read_data/test_dup_table_inverted_index.groovy
@@ -718,10 +718,12 @@ suite("test_dup_table_inverted_index", "p1") {
         sql """ INSERT INTO ${dupTableName} (`@timestamp`, clientip, request, 
status, size) VALUES (100, '.', '--', -2, -3) """
         sql """ INSERT INTO ${dupTableName} (`@timestamp`, clientip, request, 
status, size) VALUES (100, '?', '--', -2, -3) """
         sql """ INSERT INTO ${dupTableName} (`@timestamp`, clientip, request, 
status, size) VALUES (100, '@', '--', -2, -3) """
-        sql """ INSERT INTO ${dupTableName} (`@timestamp`, clientip, request, 
status, size) VALUES (100, 
'4DMXbAotfXMmKJ0KDtkFJm5qHkMr5wpYd0GIHWb18KH8JWijlincsqkjCV13m7VWOMcFz2z', 
'4DMXbAotfXMmKJ0KDtkFJm5qHkMr5wpYd0GIHWb18KH8JWijlincsqkjCV13m7VWOMcFz2z', -2, 
-3) """
         sql """ INSERT INTO ${dupTableName} (`@timestamp`, clientip, request, 
status, size) VALUES (100, '', '', -2, -3) """
+        sql "set enable_insert_strict = false;"
+        sql """ INSERT INTO ${dupTableName} (`@timestamp`, clientip, request, 
status, size) VALUES (100, 
'4DMXbAotfXMmKJ0KDtkFJm5qHkMr5wpYd0GIHWb18KH8JWijlincsqkjCV13m7VWOMcFz2z', 
'4DMXbAotfXMmKJ0KDtkFJm5qHkMr5wpYd0GIHWb18KH8JWijlincsqkjCV13m7VWOMcFz2z', -2, 
-3) """
         sql """ INSERT INTO ${dupTableName} (`@timestamp`, clientip, request, 
status, size) VALUES (100, 
'1zyvBkWVAy5H0DDDaQnrp9MmAhfo0UNB9bOGyvSEX9MW66eymeDElVzVmsvUKHORwWg2hRLN7yd253zhXGs6k7PVPHy6uqtYTaxvHWm7njZYWtlqraDGE1fvrtnyUvlrGFPJZzkuj5FQfpYl6dV2bJHV0A3gpzogKSXJSyfH02ryb2ObKaJC6dnkMic00P6R3rUCBotrU7KAaGieALbFUXBGTvjsFKUvLgJexqAEJcKwiioTp0JH9Y3NUWgi2y5kclPmUG4xVrKHWXu7bI1MYJ1DCL1eCQCuqXmUf7eFyKcR6pzTFpkurcYq5R3SjprK13EkuLmVcDJMS8DNiLVCcCIOpHQMNgVFNLI7SPCl461FPOrL1xSuULAsLNjP5xgjjp
 [...]
         sql """ INSERT INTO ${dupTableName} (`@timestamp`, clientip, request, 
status, size) VALUES (100, 
'1zyvBkWVAy5H0DDDaQnrp9MmAhfo0UNB9bOGyvSEX9MW66eymeDElVzVmsvUKHORwWg2hRLN7yd253zhXGs6k7PVPHy6uqtYTaxvHWm7njZYWtlqraDGE1fvrtnyUvlrGFPJZzkuj5FQfpYl6dV2bJHV0A3gpzogKSXJSyfH02ryb2ObKaJC6dnkMic00P6R3rUCBotrU7KAaGieALbFUXBGTvjsFKUvLgJexqAEJcKwiioTp0JH9Y3NUWgi2y5kclPmUG4xVrKHWXu7bI1MYJ1DCL1eCQCuqXmUf7eFyKcR6pzTFpkurcYq5R3SjprK13EkuLmVcDJMS8DNiLVCcCIOpHQMNgVFNLI7SPCl461FPOrL1xSuULAsLNjP5xgjjp
 [...]
+        sql "set enable_insert_strict = true;"
         sql """ sync """
         def all_dup_sql = generate_dup_mow_sql.call(dupTableName)
         def dup_result1 = execute_sql.call("enable_no_need_read_data_opt", 
"true", all_dup_sql)
@@ -803,10 +805,12 @@ suite("test_dup_table_inverted_index", "p1") {
         sql """ INSERT INTO ${mowTable} (`@timestamp`, clientip, request, 
status, size) VALUES (100, '.', '--', -2, -3) """
         sql """ INSERT INTO ${mowTable} (`@timestamp`, clientip, request, 
status, size) VALUES (100, '?', '--', -2, -3) """
         sql """ INSERT INTO ${mowTable} (`@timestamp`, clientip, request, 
status, size) VALUES (100, '@', '--', -2, -3) """
-        sql """ INSERT INTO ${mowTable} (`@timestamp`, clientip, request, 
status, size) VALUES (100, 
'4DMXbAotfXMmKJ0KDtkFJm5qHkMr5wpYd0GIHWb18KH8JWijlincsqkjCV13m7VWOMcFz2z', 
'4DMXbAotfXMmKJ0KDtkFJm5qHkMr5wpYd0GIHWb18KH8JWijlincsqkjCV13m7VWOMcFz2z', -2, 
-3) """
         sql """ INSERT INTO ${mowTable} (`@timestamp`, clientip, request, 
status, size) VALUES (100, '', '', -2, -3) """
+        sql "set enable_insert_strict = false;"
+        sql """ INSERT INTO ${mowTable} (`@timestamp`, clientip, request, 
status, size) VALUES (100, 
'4DMXbAotfXMmKJ0KDtkFJm5qHkMr5wpYd0GIHWb18KH8JWijlincsqkjCV13m7VWOMcFz2z', 
'4DMXbAotfXMmKJ0KDtkFJm5qHkMr5wpYd0GIHWb18KH8JWijlincsqkjCV13m7VWOMcFz2z', -2, 
-3) """
         sql """ INSERT INTO ${mowTable} (`@timestamp`, clientip, request, 
status, size) VALUES (100, 
'1zyvBkWVAy5H0DDDaQnrp9MmAhfo0UNB9bOGyvSEX9MW66eymeDElVzVmsvUKHORwWg2hRLN7yd253zhXGs6k7PVPHy6uqtYTaxvHWm7njZYWtlqraDGE1fvrtnyUvlrGFPJZzkuj5FQfpYl6dV2bJHV0A3gpzogKSXJSyfH02ryb2ObKaJC6dnkMic00P6R3rUCBotrU7KAaGieALbFUXBGTvjsFKUvLgJexqAEJcKwiioTp0JH9Y3NUWgi2y5kclPmUG4xVrKHWXu7bI1MYJ1DCL1eCQCuqXmUf7eFyKcR6pzTFpkurcYq5R3SjprK13EkuLmVcDJMS8DNiLVCcCIOpHQMNgVFNLI7SPCl461FPOrL1xSuULAsLNjP5xgjjpn5Bu
 [...]
         sql """ INSERT INTO ${mowTable} (`@timestamp`, clientip, request, 
status, size) VALUES (100, 
'1zyvBkWVAy5H0DDDaQnrp9MmAhfo0UNB9bOGyvSEX9MW66eymeDElVzVmsvUKHORwWg2hRLN7yd253zhXGs6k7PVPHy6uqtYTaxvHWm7njZYWtlqraDGE1fvrtnyUvlrGFPJZzkuj5FQfpYl6dV2bJHV0A3gpzogKSXJSyfH02ryb2ObKaJC6dnkMic00P6R3rUCBotrU7KAaGieALbFUXBGTvjsFKUvLgJexqAEJcKwiioTp0JH9Y3NUWgi2y5kclPmUG4xVrKHWXu7bI1MYJ1DCL1eCQCuqXmUf7eFyKcR6pzTFpkurcYq5R3SjprK13EkuLmVcDJMS8DNiLVCcCIOpHQMNgVFNLI7SPCl461FPOrL1xSuULAsLNjP5xgjjpn5Bu
 [...]
+        sql "set enable_insert_strict = true;"
         sql """ sync """
 
         def all_mow_sql = generate_dup_mow_sql.call(mowTable)


---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to