Query sorting ignores leading hyphen

Description

All query sorting appears to ignore a leading hyphen, more specifically that and a space after the hyphen.

This affects database and directory queries, as well as QoQ. Demo below uses QoQ because it's self-contained, but it appears to happen everywhere.

Result:

Note that a leading @, *, and 1 sort correctly, but a leading hyphen is ignored, with or without a space after it.

Seen in Lucee 5.2.9 and 4.5.5, not in any ACF version I tested.

Environment

Windows 7 x64, Windows 10 x64

Activity

Show:
Pothys - MitrahSoft
February 11, 2019, 4:45 PM

I've added a test case for this ticket & confirmed the issue happened on lucee.

Pull request: https://github.com/lucee/Lucee/pull/628

Pothys - MitrahSoft
December 12, 2019, 1:10 PM

If ticket PR is merged means, that will help to fix this ticket also.

Michael Offner
May 4, 2020, 4:54 PM
Edited

it only fixes the fallback of QoQ and the function querySort

Michael Offner
May 4, 2020, 5:06 PM

Fixed

Assignee

Michael Offner

Reporter

Dave Merrill

Priority

Minor

Labels

Fix versions

Sprint

None

Affects versions

Configure