Re: [PR] [bug](partial update)fix insert after delete where like '%%' no data on partial update mode [doris]

["zhannngchen (via GitHub)" <gi...@apache.org>]

zhannngchen commented on code in PR #34297:
URL: https://github.com/apache/doris/pull/34297#discussion_r1626824704


##########
regression-test/suites/nereids_p0/insert_into_table/partial_update.groovy:
##########
@@ -283,6 +283,47 @@ suite("nereids_partial_update_native_insert_stmt", "p0") {
             sql "set enable_insert_strict = false;"
             sql "set enable_fallback_to_original_planner=true;"
             sql "sync;"
+
+            // test native paitial update insert after delete
+            // in nereids
+            sql "set enable_unique_key_partial_update=true;"
+            sql "set enable_insert_strict = false;"
+            sql "set enable_fallback_to_original_planner=false;"
+            sql "set experimental_enable_nereids_planner=true;"
+            sql "sync;"
+            def tableName10 = "nereids_partial_update_native_insert_stmt10"
+            sql """ DROP TABLE IF EXISTS ${tableName10} """
+            sql """create table ${tableName10} (
+                k int null,
+                v int null
+            ) unique key (k) distributed by hash(k) buckets 1
+            properties("replication_num" = "1",
+            "enable_unique_key_merge_on_write"="true",
+            "disable_auto_compaction"="true",
+            "store_row_column" = "${use_row_store}"); """
+
+            sql "insert into ${tableName10}(k,v) values(1,100);"
+            sql "delete from ${tableName10} where k like '%%';"
+            sql "insert into ${tableName10}(k,v) values(1,100);"

Review Comment:
   Thanks for your contribution, but this PR can't fix the issue. e.g.
   If your table's schema have 3 columns, say `k, v1, v2`
   then insert with values (1, 100, 200);
   then delete them all
   then you set `enable_unique_key_partial_update=true`, and `insert into ${tableName10}(k,v1) values(1,100);`, you should expect to get a result `1, 100, null,` but actually you will get a resut `1, 100, 200`.



-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org