Issues

Select view

Select search mode

 

Query filter/map functions alter datatypes

Description

The query functions (and member methods), such as queryFilter() and queryMap() are changing the datatype of values. This can lead to issues when using functions like queryColumnData() because the results after filtering will end up being different than expected.

For example:

This ends up generating the following output:

I would expect all the values to be the same.

You can see this behavior in the following TryCF examples:

These show the datatype are changing:

This appears to relate to .

Environment

None

Details

Assignee

Reporter

Priority

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

Created 7 August 2023 at 19:44
Updated 14 August 2023 at 11:47

Activity

Show:

Pothys - MitrahSoft14 August 2023 at 11:36

I updated the querymap() testcase for this ticket: [disabled].

Zac Spitzer10 August 2023 at 09:06

Pothys - MitrahSoft9 August 2023 at 12:09

I added a testcase for this ticket : [disabled].

dan.switzer@givainc.com7 August 2023 at 19:47

Posted the following in the Slack channel which relates to were the issue starts:

https://github.com/zspitzer/Lucee/blob/6.0/core/src/main/java/lucee/runtime/functions/closure/Filter.java#L188

Iā€™m guessing the fix is we just need to get the datatypes from the original query and pass them into the QueryImpl() call.

Flag notifications