Query returns result differs - Incompatible with ACF

Description

If we select two columns from two tables according to the below test code, lucee returns one column in the query. But, in lucee returns a different result as compared to ACF.

Environment

None

Attachments

1

Activity

Zac Spitzer 15 May 2020 at 07:45
Edited

yeah I’m all for just throwing, it’s crappy code

I’m more concerned about

Michael Offner 15 May 2020 at 07:21

maybe Lucee should even throw an exception in this case. the Lucee design of the query object atm does not allow to have 2 columns with the same name, so support this would need a lot of work and impact performance.

Michael Offner 15 May 2020 at 07:18
Edited

Lucee does not allow 2 columns with the same name with QoQ like all datasource do as far i know. Is it a bug, in my opinion not.

what do you think about this?

Pothys - MitrahSoft 23 October 2019 at 14:29

I've added test case for this ticket & confirmed the issue happened on lucee latest version(5.3.5.21 SNAPSHOT)

Pull Request: https://github.com/lucee/Lucee/pull/779

Fixed

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

Affects versions

Created 23 October 2019 at 08:15
Updated 27 July 2024 at 06:27
Resolved 27 July 2024 at 06:27