Prerequisites

• I have searched for related issues in the issues list.
• This is an issue with the Halo project itself. If it is not an issue with the project itself(For example: Installation and deployment issues.), it is recommended to submit it in the Discussions.
• I have tried disabling all plugins to rule out plugins as the cause of the problem.
• If it is an issue with plugins and themes, please submit it in the respective plugin and theme repositories.

System information

• External url: https://85c2-50-114-155-232.ngrok-free.app
• Start time: 2025-07-11 12:14
• Version: 2.21.0-SNAPSHOT
• Build time: 2025-07-11 12:14
• Git Commit: 888043d
• Java: OpenJDK Runtime Environment / 21.0.6+7-LTS
• Database: PostgreSQL / 15.2 (Debian 15.2-1.pgdg110+1)
• Operating system: Mac OS X / 26.0
• Activated theme: Earth 1.12.4
• Enabled plugins:

What is the project operation method?

Docker

What happened?

If an indexed field contains numeric values, the query might return multiple incorrect records. For example, when I upload two attachments named 1.4.3.png and 1.4.2.png, their status.permalink fields should be unique. However, when I query a specific image using the fieldSelector parameter, both records are returned.

Reproduce Steps

No response

Relevant log output

Additional information

No response