Query of Query doesn't return correct results when UPPER() is used

Description

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

Environment

None

Activity

Show:
Pothys - MitrahSoft
July 23, 2019, 3:03 PM

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

Pothys - MitrahSoft
September 24, 2019, 5:54 PM

I've added a fix for this ticket.

Pull Request: https://github.com/lucee/Lucee/pull/761

Michael Offner
December 19, 2020, 3:39 AM

can you please resolve the merge conflict

Pothys - MitrahSoft
December 23, 2020, 10:01 PM

, 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.

Fixed

Assignee

Pothys - MitrahSoft

Reporter

Arif Alili

Priority

Critical

Labels

Fix versions