[GitHub] [incubator-doris] morningman removed a comment on pull request #3943: Fix bug that delete stmt with filter condition delete all data from table on segment v2

[GitBox <gi...@apache.org>]

morningman removed a comment on pull request #3943:
URL: https://github.com/apache/incubator-doris/pull/3943#issuecomment-649555591


   It is strange that the case you described in issue truly has problem. But the following case is OK:
   
   ```
   mysql> create table tbl4 (k1 int, k2 int) distributed by hash(k1) buckets 1 properties("replication_num" = "1");
   Query OK, 0 rows affected (0.01 sec)
   
   mysql> insert into tbl4 values(1,2),(3,4);
   Query OK, 2 rows affected (0.04 sec)
   {'label':'insert_20ddaec3-5d29-43a9-b065-7d3d680e9d33', 'status':'VISIBLE', 'txnId':'3014'}
   
   mysql> select * from tbl4;
   +------+------+
   | k1   | k2   |
   +------+------+
   |    1 |    2 |
   |    3 |    4 |
   +------+------+
   2 rows in set (0.01 sec)
   
   mysql> delete from tbl4 where k2=2 and k1=1;
   Query OK, 0 rows affected (0.04 sec)
   {'label':'delete_1e19b1ba-0a42-48ee-989c-813758ea9a36', 'status':'VISIBLE', 'txnId':'3015'}
   
   mysql> select * from tbl4;
   +------+------+
   | k1   | k2   |
   +------+------+
   |    3 |    4 |
   +------+------+
   1 row in set (0.01 sec)
   ```


----------------------------------------------------------------
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.

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