[Bug]: upsert into milvus use hybridSearch and search get same id result is diff

[I-am-DJ]

Is there an existing issue for this?

• I have searched the existing issues

Environment

- Milvus version:V2.4.5
- Deployment mode(standalone or cluster):
- MQ type(rocksmq, pulsar or kafka):    
- SDK version(e.g. pymilvus v2.0.0rc2):
- OS(Ubuntu or CentOS): 
- CPU/Memory: 
- GPU: 
- Others:

Current Behavior

对应collection结构

Expected Behavior

No response

Steps To Reproduce

No response

Milvus Log

No response

Anything else?

No response

[github-actions]

The title and description of this issue contains Chinese. Please use English to describe your issue.

[I-am-DJ]

对应collection结构

hybridSearch结果：

[I-am-DJ]

hybridSearch结果：

search：

[yanliang567]

@I-am-DJ could you please try
collection.query(expr='id==136300913', output_fields=['count(*)'] meanswhile, i will try to reproduce it in house.

/assign @I-am-DJ

[I-am-DJ]

@I-am-DJ您能否同时尝试 collection.query(expr='id==136300913', output_fields=['count(*)'] 一下，我会尝试在家里重现它。

/分配@I-am-DJ

[{"extInfo":{"count(*)":6}}] @yanliang567

[yanliang567]

[{"extInfo":{"count(*)":6}}]

it means that you have 6 entities that have the same id==136300913 :(
I believe that it was caused by duplicated id...

[I-am-DJ]

[{"extInfo":{"count(*)":6}}]

it means that you have 6 entities that have the same id==136300913 :( I believe that it was caused by duplicated id...

it not delete the original data when upsert the same id ? @yanliang567

[I-am-DJ]

i see the doc can be overwritten https://milvus.io/docs/insert-update-delete.md#Upsert-entities

[I-am-DJ]

is need update to v2.4.12 ? #36274 @yanliang567

[yanliang567]

do you only use upsert() for data ingestion? no insert() or bulk_insert()?

[I-am-DJ]

do you only use upsert() for data ingestion? no insert() or bulk_insert()?

yes only use upsert()

[xiaofan-luan]

maybe this is a bug for 2.4.5

[I-am-DJ]

maybe this is a bug for 2.4.5

how can i solve this problem, delete first then upsert? @xiaofan-luan

[yanliang567]

please try to upgrade to 2.4.15

[yanliang567]

@I-am-DJ any updates

[stale]

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions.
Rotten issues close after 30d of inactivity. Reopen the issue with /reopen.