We’re in the middle of migrating from CF 2021 to Lucee and just ran into this blocker while testing in our production environment.
These work in ColdFusion and we use them a lot.
SELECT /* REPLICA:60:API_GET_domainrecords */ FROM...
We use these query routing directives to shuttle heavy queries to a db replica.
I haven’t dug through settings yet but is this expected? Is there a way to enable this or is it a bug? What’s odd is that these do work with cfquery.
Related Slack thread: