Bug: find_and_filter_query returns bad matches #1640

Initial Checks

• I have read and followed the docs and still think this is a bug

Description

_execute_find_and_filter_query is used by two doc indices - in_memory and hnsw

The function sorts documents from lowest to highest based on the score before returning them

This works for hnsw index, but for in_memory higher scores actually mean better matches. So as a result, we output bad matches first for in_memory index.

Example Code

No response

Python, Pydantic & OS Version

0.33.1

Affected Components

• Vector Database / Index
• Representing
• Sending
• storing
• multi modal data type