From the CFQuery docs:

To use cached data, the current query must use the same SQL
statement, data source, query name, user name, and password.

https://cfdocs.org/cfquery#cachedwithin

Our current implementation fails to take the datasource, username, or password into account. This incorrectly causes a duplicate query run against two separate datasources or database connections to use the same cache entry, when obviously the data could be entirely different on a different datasource or with different user credentials.