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

Attachments

1

Activity

Michael Offner 
4 May 2020 at 17:06

Michael Offner 
4 May 2020 at 16:54
(edited)

it only fixes the fallback of QoQ and the function querySort

Pothys - MitrahSoft 
12 December 2019 at 13:10

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

Pothys - MitrahSoft 
11 February 2019 at 16:45

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

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

Fixed

Details

Assignee

Reporter

Priority

Labels

Fix versions

New Issue warning screen

Before you create a new Issue, please post to the mailing list first https://dev.lucee.org

Once the issue has been verified, one of the Lucee team will ask you to file an issue

Sprint

Affects versions

Created 10 February 2019 at 14:13
Updated 8 February 2021 at 11:11
Resolved 5 May 2020 at 06:25