Issues
- Incorrect QoQ results when ordering aggregate selecftLDEV-5031Resolved issue: LDEV-5031Pothys - MitrahSoft
- QoQ doesn't handle | and * correctly in LIKE expressionsLDEV-4829Resolved issue: LDEV-4829Pothys - MitrahSoft
- Lucee 6: Query of Queries Loses Original OrderLDEV-4778Resolved issue: LDEV-4778
- Support native rand() and rand( seed ) in QoQLDEV-4446Resolved issue: LDEV-4446Pothys - MitrahSoft
- RAND() in query of queries failsLDEV-4445Resolved issue: LDEV-4445Pothys - MitrahSoft
- Improve QoQ performance for large resultsLDEV-4298Resolved issue: LDEV-4298Brad Wood
- QoQ: different recordcount of empty datasetLDEV-3884Resolved issue: LDEV-3884
- QoQ UNION can still return duplicatesLDEV-3830Resolved issue: LDEV-3830Brad Wood
- QoQ doesn't support ordinal position syntax for ORDER BYLDEV-3823Resolved issue: LDEV-3823Brad Wood
- QoQ - using ORDER BY with commented line throws NPELDEV-3806Resolved issue: LDEV-3806
- ArrayIndexOutOfBoundsException in QoQ with using ORDER BYLDEV-3801Resolved issue: LDEV-3801Brad Wood
- QoQ doesn't convert empty strings to 0 in arithmetic operationsLDEV-3736Resolved issue: LDEV-3736Brad Wood
- QoQ allows divide by zeroLDEV-3735Resolved issue: LDEV-3735Brad Wood
- QoQ treats nulls differently than real DB's in arithmetic expressionsLDEV-3734Resolved issue: LDEV-3734Brad Wood
- Query of Query, where statement zero not correctLDEV-3727Resolved issue: LDEV-3727
- QoQ needs to preserve nulls internally regardless of full null supportLDEV-3640Resolved issue: LDEV-3640Brad Wood
- Aggregates don't return empty row for empty set with where clauseLDEV-3632Resolved issue: LDEV-3632Brad Wood
- Query of Query on Lucee 5.3.8.189LDEV-3626Resolved issue: LDEV-3626
- QoQ mishandles null and boolean column aliasesLDEV-3615Resolved issue: LDEV-3615Pothys - MitrahSoft
- QoQ cast()/convert() functions not fully implementedLDEV-3522Resolved issue: LDEV-3522Brad Wood
- Lucee redefines query types when setting invalid data instead of throwing exceptionLDEV-3521Michael Offner
- Query containing CFC Object throws error when queriedLDEV-3514Michael Offner
- log native QoQ SQL errors as a debug exceptionLDEV-3400Resolved issue: LDEV-3400Zac Spitzer
- Null values replaced with zeros in numeric columns with certain queries using query of query and in operatorLDEV-3395Resolved issue: LDEV-3395Pothys - MitrahSoft
- QoQ should allow reserved words as column namesLDEV-3311Resolved issue: LDEV-3311Zac Spitzer
- QoQ regression - Sort orderLDEV-3099Brad Wood
- QoQ column exception, includes the source query sql, not the QoQ sqlLDEV-3055Pothys - MitrahSoft
- Query of Query performance is very bad and single threaded for complex SQLLDEV-3042Resolved issue: LDEV-3042Pothys - MitrahSoft
- New "unique" property of scheduled tasks causes queries produced by cfschedule to throw exception when joined in QoQLDEV-2755Pothys - MitrahSoft
- Query of Query generating "Unexpected token" errorLDEV-2678Resolved issue: LDEV-2678Pothys - MitrahSoft
- Query of Query UNION doesn't distinct the resultsetLDEV-2541Michael Offner
- Query returns result differs - Incompatible with ACFLDEV-2530Resolved issue: LDEV-2530Michael Offner
- QoQ and QuerySort don't sort varchar columns correctlyLDEV-2487Resolved issue: LDEV-2487Michael Offner
- QoQ joins on columns with type numeric doesn't workLDEV-2470Resolved issue: LDEV-2470Pothys - MitrahSoft
- Query of Query doesn't return correct results when UPPER() is usedLDEV-2382Resolved issue: LDEV-2382Pothys - MitrahSoft
- Query of Queries UNION returns incorrect results with cfqueryparamLDEV-2128Resolved issue: LDEV-2128Michael Offner
- QoQ over agressively applies column aliasesLDEV-1867Michael Offner
- update HyperSQL 2.7.2 (HSQLDB) for QoQ (CVE)LDEV-1526Resolved issue: LDEV-1526Zac Spitzer
- error message for missing column in QoQ is org.hsqldb.Expression@70e4800dLDEV-1525Resolved issue: LDEV-1525Michael Offner
- QoQ throws an error when variables scoped as [local]LDEV-1508Resolved issue: LDEV-1508Michael Offner
- Query of query maxrows returns incorrect value when used with DISTINCTLDEV-1272Michael Offner
- Numeric value out of range in QoQLDEV-1269Resolved issue: LDEV-1269Pothys - MitrahSoft
- QoQ crash using NOT LIKE with ESCAPELDEV-1165Michael Offner
- QoQ Count(*) crashes when object columns presentLDEV-691Resolved issue: LDEV-691Michael Offner
- Query of Query with Aggregate Function Max Returns Error when Reserved Word in Orignal QueryLDEV-685
- select count()` in a query of query with an empty recordset returns empty stringLDEV-526Resolved issue: LDEV-526Michael Offner
- Running a Query of Queries with UNION does not merge the recordsLDEV-237Resolved issue: LDEV-237Michael Offner
- Query.cfc Query of Queries fails when "Q" is used as the name of the query attributeLDEV-173Resolved issue: LDEV-173Michael Offner
48 of 48
Incorrect QoQ results when ordering aggregate selecft
Fixed
Description
Environment
None
Details
Assignee
Pothys - MitrahSoftPothys - MitrahSoftReporter
Brad WoodBrad WoodPriority
NewLabels
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
NoneAffects versions
Details
Details
Assignee
Pothys - MitrahSoft
Pothys - MitrahSoft
Reporter
Brad Wood
Brad Wood
Priority
NewLabels
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
None
Affects versions
Created 18 July 2024 at 19:06
Updated 12 August 2024 at 06:02
Resolved 12 August 2024 at 06:02
Activity
Show:
Pothys - MitrahSoft12 August 2024 at 06:02
I've checked this ticket with the Lucee fixed version 6.2.0.41-SNAPSHOT, and the issue is now resolved. The ordering of the aggregate QOQ works correctly.
Michael Offner9 August 2024 at 13:49
merged PR
Zac Spitzer19 July 2024 at 10:03
PRs failing to to the docker creds problem, thanks for the PR, you need to add some docker login creds to your repo
(help wanted, if you have any idea how to solve!)
there was a typo in the test case, i have fixed it
running the PR locally, all tests pass
Brad Wood18 July 2024 at 19:14
Adding ORDER BY to aggregate QOQ select without GROUP BY where the ordered column is not part of the select list causes the result to group on the additional column instead of getting a single row back.
Ex:
See: