Regression: preserveCaseForQueryColumn=false not working in 6.x with remote methods

Description

As originally noted here:


https://dev.lucee.org/t/preservecaseforquerycolumn-no-longer-working/14269

 

setting this.serialization.preserveCaseForQueryColumn = false; in Application.cfc no longer seems to have any effect; query column names are not converted to uppercase.

It’s working as expected for me in lucee 5.4.6.9, and seems to be not working as of 6.x (verified not working in 6.2.0.321 and 6.2.1.116).

Tested using lucee Docker images with the above version (e.g. lucee/lucee:6.2.0.321-tomcat10.1-jre21-temurin-jammy).

Environment

Docker images (lucee/lucee:6.2.0.321-tomcat10.1-jre21-temurin-jammy etc)

Activity

Shane St Savage 
3 May 2025 at 03:23

Looks like preserveCaseForQueryColumn=false still doesn’t work in 6.2.1.122, which I think is expected after reviewing the regression safe commit (https://github.com/lucee/Lucee/commit/5e1ab484c67e2d66741771552677cb7908955d41) where only the serializationSettings alias was added. Just noting for others as I was confused for a minute. Like Pothys, I can verify that 6.2.2.5-SNAPSHOT is honoring this.serialization.preserveCaseForQueryColumn = false

Pothys - MitrahSoft 
29 April 2025 at 14:14

I tested this ticket with Lucee version 6.2.2.5-SNAPSHOT. After setting this.serialization.preserveCaseForQueryColumn = false in Application.cfc, I executed a cfquery within a remote method. The query column names were converted to uppercase as expected, and it works fine now.

Michael Offner 
28 April 2025 at 12:01

Michael Offner 
28 April 2025 at 11:56

Fixed

Details

Assignee

Reporter

Priority

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 16 April 2025 at 17:56
Updated 3 May 2025 at 03:23
Resolved 29 April 2025 at 14:14