pk表insert之后 查询会出现2条数据互相切换

Viewed 3

doris-2.1.10

create table : UNIQUE KEY(aaaid)
seq: "function_column.sequence_col" = "update_time"

sql插入:

INSERT INTO companyInfo ( DORIS_DELETE_SIGN,aaaid,orgtype,credate_time,update_time ) VALUES
( 1,'156107564734','91','2025-06-30 16:08:04','2025-09-23 18:10:12' )
,( 0,'156107564734','91','2025-06-30 16:08:04','2025-10-11 11:28:40.563' )

多次查询会出现上面2条数据里面随机返回一条

0 Answers