"Strict" age queries are not working properly

[grantfitzsimmons]

Reference Query: https://calvertmarinemuseum20241114-production.test.specifysystems.org/specify/query/19/

In the calvertmarinemuseum_2024_11_14 database, the "Cretaceous" period has a startPeriod of 145 and an endPeriod of 66. (/specify/view/geologictimeperiod/35/)

Non-strict:

See that 119 results are returned, all of which belong specifically to the Paleocence series/epoch, which has a startPeriod of 66 and endPeriod of 56:

OK– follows the logic described. Because 66 falls within the range 145-66, though narrowly, it meets the requirements written for the feature.

Strict:

Same query, but it's strict this time:

Still 119 results, which doesn't make sense if the intention is to exclude any results that do not fall completely within that range, which would exclude the Paleocene records from the results.

That's a 🐛 👀

Originally posted by @grantfitzsimmons in #5465 (comment)