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: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
