[Bug] UNIQUE KEY 模型，根据唯一key查询结果不唯一 #15675
Description
Search before asking
- I had searched in the issues and found no similar issues.
Version
1.2.0
What's Wrong?
建表信息如下：
create table xxx (.....)
UNIQUE KEY(account_id)
COMMENT 'OLAP'
DISTRIBUTED BY HASH(account_id) BUCKETS 1
PROPERTIES (
"replication_allocation" = "tag.location.default: 5",
"in_memory" = "true",
"storage_format" = "V2",
"enable_unique_key_merge_on_write" = "true",
"disable_auto_compaction" = "false"
);
根据key查询结果如下：
MySQL [tmp]> select count(1),count(distinct account_id) from xxx ;
+----------+------------------------------+
| count(1) | count(DISTINCT account_id) |
+----------+------------------------------+
| 5441977 | 5203241 |
+----------+------------------------------+
1 row in set (0.49 sec)
MySQL [tmp]> select account_id,count(1) cnt from xxx group by account_id having cnt > 1 limit 10;
+---------------------+------+
| account_id | cnt |
+---------------------+------+
| 1521310411738078519 | 2 |
| 1521310422026706202 | 2 |
| 1521310437558213893 | 2 |
| 1521310445032463735 | 2 |
| 1521310445946821889 | 2 |
| 1521310447788121403 | 2 |
| 1521310479111183664 | 2 |
| 1521310483565534521 | 2 |
| 1521310486451215735 | 2 |
| 1521310494445559157 | 2 |
+---------------------+------+
10 rows in set (0.40 sec)
What You Expected?
使用的1.2.0版本，有routine load 任务，配置了merge_on_write 模式
How to Reproduce?
No response
Anything Else?
No response
Are you willing to submit PR?
- Yes I am willing to submit a PR!
Code of Conduct
- I agree to follow this project's Code of Conduct