Primary COG Inheritance preference breaks `equal` filter in queries

[emenslin]

Describe the bug
In collection preferences if the 'Primary Catalog Number Inheritance' setting is checked, when you try to query on cat # Equal all catalog numbers show up. When the preference is disabled, only the matching catalog number appears in results. Also the results when set to does not equal shows the incorrect number of results, and appears to just keep looping. Not sure if the count is the same problem or not, if they are not related I can write up a separate issue for it.

To Reproduce
Steps to reproduce the behavior:

1. Find or create multiple COGs with child COs
2. Go to Collection Preferences
3. Uncheck Primary cat # inheritance if not unchecked already
4. Query on the COG base table
5. Add a mapping to Children -> Child Collection Object -> Catalog Number
6. Set Catalog Number to Equal and type in one of the cat # from a COG
7. See correct result returned
8. Go to collection preferences and enable primary inheritance
9. Rerun the query
10. See different cat numbers are returned

Expected behavior
When the preference is enabled it should show only the CO with that catalog number, and if it is a primary CO then the siblings with an empty catalog number should also be shown

Screenshots

12-23_15.10.mp4

Incorrect count:

12-24_13.40.mp4

Please fill out the following information manually:

• OS: Windows 11
• Browser: Chrome
• Specify 7 Version: 7.11.3
• Database Name: ojsmnh and ciscollections
• Collection name: fossil invertebrates and rocks
• User Name: spadmin
• URL: https://ojsmnh20251211-main.test.specifysystems.org/specify/