after ColdFusion 2021 Hotfix 12, my MongoDB code stopped working. In another environment, ColdFusion 2021 with Hotfix 10 is installed, and I don't encounter this issue in the test environment where I use the same code and the same database. When I execute the query, it returns an empty response, but I am sure that the data is present.
<cfscript>
db = getmongoservice("xxx").db("xxx"); // create a db
response = db.xxx.find().sort( { createdAt: -1 } ).limit(1).toArray()[1];
</cfscript>
When I downgrade to hotfix 10, the problem is resolved. It does not work with hotfix 11 and above