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:
1 Like
PR for 7 - thanks to @bdw429s
@Zackster @Michael_Offner
Just to follow up on this - it was fixed in Jira
as you can see we addressed the issue , but we needed a bit a different approach
1 Like