Dynamic datasource definitions aren't uniquely cached with query caching

Description

Recently we migrated a server from ACF. We have a number of queries that are dynamic datasources but cached for short amounts of time to alleviate recalls. We started noticing data switching for customers, and after a bunch of testing…Lucee doesn’t cache the datasource as well? For example, if we need to grab a same-content dataset from DB1, Select * From Customers Where Name = “Joe”, then another call comes in for the data in DB2…we’re presenting the data from DB1 because of the cache.

With ACF, it caches to datasource…so we get all of the Joe’s in DB1 when the call comes in for DB1, and DB2 etc…

is this a bug? Obviously it would seem that if you’re truly caching the data…SELECT from Datasource2 and getting data from datasource1 is incorrect…and a pretty big issue…at least for us…

Environment

Windows, mysql (souldnt matter)...Lucee 5.3.6.61...

Assignee

Michael Offner

Reporter

John Egbert

Priority

Critical

Fix versions

None

Affects versions

Configure