After we upgraded to 2.4.5-p1, our search engine stopped working when someone searches for a product by its SKU.
After some debugging, I noticed that when the SKU is 9 characters or longer, Magento tries to fetch all the products from our large database, which contains over 2 million products, and then only shows the product with the exact SKU.
We are experiencing this issue specifically when searching by SKU