QoQ joins on columns with type numeric doesn't work

Description

If i get some data from ms sql, it comes back with the numeric data type

If i try to do a join with these in a QoQ, they don't work with the numeric data type, but only with integer

(note ACF doesn't seem to support the numeric type for querynew)

https://trycf.com/gist/a11f0ec7587133644d4368e93b310fc2/lucee5?theme=monokai

 

 

Environment

None

Attachments

1

Activity

Pothys - MitrahSoft 14 May 2024 at 10:50

I checked this issue with Lucee version 6.1.0.136-SNAPSHOT. Now, QoQ joins columns with numeric type, works as expected.

Zac Spitzer 14 May 2024 at 09:51

doing my semi irregular sweep of disabled tests, i found that this disabled test case is now passing (with 6.1)

Pothys - MitrahSoft 23 October 2019 at 11:55

I've added a test case for this ticket.

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

Zac Spitzer 17 September 2019 at 12:31

I was chatting to about this, he was wondering if this relates to a recentish optimisation for QoQ smaller queries?

Pretty sure this is a regression, my Lucee loader is quite new so I can’t go back so far to find out which version this happened with.

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

Original estimate

Time tracking

No time logged

Affects versions

Created 13 September 2019 at 13:10
Updated 23 January 2025 at 17:36
Resolved 14 May 2024 at 10:51