tracker issue : CF-4200041

select a category, or use search below
(searches all categories and all time range)
Title:

modulus in QoQ

| View in Tracker

Status/Resolution/Reason: To Fix//EnhancementRequired

Reporter/Name(from Bugbase): Jack Drysdale Jr / Jack Drysdale Jr ()

Created: 10/19/2017

Components: Database, Query-of-Query(IMQ)

Versions: 11.0

Failure Type: Others

Found In Build/Fixed In Build: /

Priority/Frequency: Normal /

Locale/System: / Win All

Vote Count: 4

I know that QoQ doesn't have all of the functionality of most standard queries, but it would be nice if QoQ could support modulus.  For example, imagine I queried a database and named it myQry:
SELECT columnA, columnB, columnC FROM tableA ORDER BY columnA

columnA and columnB are varchar, columnC is integer.

Now I want to query that query:
SELECT columnA, columnB FROM myQry WHERE columnC % 2 = 0

OR 

SELECT columnA, columnB FROM myQry WHERE mod(columnC,2) = 0

Attachments:

Comments:

I tested this in CF11,0,13,303668 and can confirm that the modulus operator fails in a query of query scenario.
Vote by Eddie L.
218 | October 19, 2017 04:03:32 PM GMT
The MODULUS operator is crucial in query of query. As query of query is pure ColdFusion functionality, I expected MOD to work. It doesn't. I am on ColdFusion 2016.0.03.300232
Vote by A. B.
219 | October 19, 2017 04:15:22 PM GMT
This should not crash query
Vote by James M.
220 | January 03, 2018 04:15:57 PM GMT
I know it's only been five months since I submitted this bug, but I'm curious if this is even going to be considered and addressed for CF10+ in the form of an update.
Comment by Jack D.
217 | March 21, 2018 08:45:17 PM GMT
Okay, maybe not CF10, but at least CF11???
Comment by Jack D.
30173 | February 01, 2019 04:00:28 PM GMT
Related ticket: CF-3860956
Comment by Aaron N.
30178 | February 02, 2019 05:02:23 AM GMT
+1 - QoQ needs unhandcuffed
Vote by Aaron N.
30179 | February 02, 2019 05:02:49 AM GMT
Thanks, Aaron. I voted for yours, as well.
Comment by Jack D.
31780 | November 07, 2019 09:24:28 PM GMT