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条数据里面随机返回一条