STEPS TO REPRODUCE:
Query the results of an existing query
Example table data:
id,title
1,A
2,B
3,C
4,A
5,C
6,C
7,A
8,A
9,A
EXPECTED RESULT:
Return only distinct (different) values: A,B,C
*ACTUAL RESULT: *
Returns A,B,C,A,C,A
Note
I noticed that QoQ returns correct data if data on column that distinct is used are one after the other. Example:
id, title
1, A
2, A
3, A
will return only A
Gist: https://trycf.com/gist/068c92daa6b103e2d5cbcbca4cc72954/lucee5?theme=monokai
I've added a test case for this ticket and confirmed the issue happened on lucee.
Pull request: https://github.com/lucee/Lucee/pull/726
I've added a fix for this ticket.
Pull Request: https://github.com/lucee/Lucee/pull/761
can you please resolve the merge conflict
, I've checked this ticket and this issue was fixed ticket fix, So no need for this fix here and I close this PR. And one more thing, the fix has an incompatibility with ACF.