QoQ Count(*) crashes when object columns present

Description

Query of Query count crashes with objects in columns, even when they aren't referenced

Can't cast Complex Object Type Struct to String
Use Built-In-Function "serialize(Struct):String" to create a String from Struct

This works in ACF

Environment

None

Activity

Show:
Zac Spitzer
January 26, 2016, 1:05 PM

all that's thrown is the following

Zac Spitzer
June 26, 2017, 5:46 AM

this also fails with count(mod)

further discussion here https://dev.lucee.org/t/objects-in-qoq-group-by-throwing-an-error/2531

Pothys - MitrahSoft
January 3, 2018, 12:24 PM

I've added test case for this ticket & confirmed the issue happened on latest version of lucee 5.2.6.29 snapshot also. If we try to take a count in QoQ having complex structure in column, it throw error like Error.png even though it's not refereed in QoQ. In ACF, It working as expected.

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

Zac Spitzer
October 26, 2020, 10:39 AM

Looks like this was solved by 's QoQ work with

Michael Offner
October 28, 2020, 1:45 PM

fixed with the QoQ changes

Fixed

Assignee

Michael Offner

Reporter

Zac Spitzer

Priority

Major

Fix versions

Affects versions

Configure