Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

QoQ sum with different cased group by has different column case result

Description

Sinve I upgrade my lucee to version 5.4.1.8 have a different result is the column in Select and Group By has different capital letter. See my example result

 

my dump result

Environment

None

Attachments

1

relates to

Activity

Show:

Andri Senjaya 18 July 2023 at 00:31

ok

Zac Spitzer 17 July 2023 at 13:24
Edited

next time please post to before creating a ticket please

Zac Spitzer 17 July 2023 at 11:35

cool, closing this off then

Andri Senjaya 17 July 2023 at 11:28

when I test with lucee@5.4.2-SNAPSHOT+8, the result is correct

Zac Spitzer 17 July 2023 at 11:15

those tests are passing, so the problem is only in the SQL listing in the debug? or have I missed something?

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

Affects versions

Created 17 July 2023 at 09:22
Updated 1 September 2023 at 14:21
Resolved 17 July 2023 at 11:35