Has anyone seen a weird anomaly with Query of Queries that seems to have been introduced in ACF version 2018.0.12+328566. Version 2018.0.11+326016 doesn't exhibit this behavior. If you have an ORDER BY clause in your query and use a lower case name for the column to order by then the column is duplicated and added to the resulting query. I came across this with some code that did a CFDirectory then did a QoQ on the resulting query to select out records based on the name column and sort the resulting query by the name column. I noticed that the CFDirectory tag will return the query with lower cased column names. The QoQ will upper case the column names and if the ORDER BY clause references the

name

column in lower case the column is duplicated in the resulting query once with

NAME

as the column name and once with

name

as the column name.

Sounds like this: https://tracker.adobe.com/#/view/CF-4212383

Thanks Adam.

Just FYI, we ran into other QoQ issues in CF 2018, which required an ad hoc patch provided by Adobe support. The underlying issue seems to be that some operations corrupt the internal query metadata, leading to strange errors on later calls.

@Dave Merrill do you happen to know how to acquire that patch?

@ehoffman I think you have to specifically request it from support, for some reason. They'll know what you mean if you mention QoQ errors in 2018, or hf201800-4212383.jar. For CF2021 I think it's hf202100-4212383.jar, which has to be requested separately.