tracker issue : CF-3928373

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

Query of queries doesn't support subqueries

| View in Tracker

Status/Resolution/Reason: To Fix//NeedMoreInfo

Reporter/Name(from Bugbase): Dorin Moise / Dorin Moise (Dorin Moise)

Created: 01/27/2015

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

Versions: 9.0

Failure Type: Enhancement Request

Found In Build/Fixed In Build: 9.0 /

Priority/Frequency: Major / Some users will encounter

Locale/System: ALL / Linux CentOS 6.4

Vote Count: 4

Problem Description: An old problem described here:
http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:43227

Steps to Reproduce: 

{code:java}
<cfquery name="q1" datasource="database" >
SELECT foo FROM bar
</cfquery>

<cfquery name="q2"  dbtype="Query" >
select * from ( 
       select rownum r, q1.* from q1
       where rownum <= 10
) 
where r >= 1;
</cfquery>
{code}


Actual Result:
DB Error

Expected Result:
No DB Error
Any Workarounds:
-

----------------------------- Additional Watson Details -----------------------------

Watson Bug ID:	3928373

External Customer Info:
External Company:  
External Customer Name: Dorin
External Customer Email:  
External Test Config: My Hardware and Environment details: CF9.0.2

Attachments:

Comments:

Definitely. QoQ is only really proof of concept with its current level of SQL support. Needs enhancement.
Vote by External U.
8774 | January 27, 2015 07:47:32 AM GMT
+1... underachieving, is still achieving
Vote by External U.
8775 | January 27, 2015 08:33:34 AM GMT
Yup, it's painful to work around this missing functionality.
Vote by External U.
8776 | January 27, 2015 02:59:46 PM GMT
+1 for sure ......................
Vote by External U.
8777 | January 29, 2015 05:57:13 AM GMT