regression - Sort order on QoQ - extension of LDEV-2158

Description

This is an extension of the Resolved issue to include characters prefixed with an underscore "_" commonly used to promote sorting on characters.

Using a modified test case from that Jira.

 

The sort order for “_A,_B,_C” was correct in Lucee 5.3.3.62

Environment

None

Activity

Show:
Pothys - MitrahSoft
October 14, 2020, 7:24 AM
Edited

I've checked this ticket with both affected and lucee latest version 5.3.8.81-SNAPSHOT.
Seems, Lucee result is as same as ACF.
will confirm it.

Pat Moody
October 14, 2020, 11:21 PM
Edited

, I suspect that the sort order on ACF is incorrect then. Underscores should be ahead of standard characters, when order by is ascending.

Pat Moody
October 14, 2020, 11:35 PM

Just as you would expect with SQL:

The results would be
_A
_B
_C
A
B
C

Assignee

Michael Offner

Reporter

Pat Moody

Priority

New

Labels

Fix versions

None

Affects versions

Configure