tracker issue : CF-3783011

Problem Description: Basically, I have 2 queries, qrA and qrB.  I do a join of the two in joinQr, after which I do a query of qrA.  Since I didn't alter qrA in any way, I would expect newQrA to give me the same result as qrA.  However it only gives me one row ("D").  Now, here's the strange thing:  If I start off qrA with the letters in ascending order ["A", "B", "C", "D"], then newQrA gives me the right result.

Steps to Reproduce:

<cfset qrA = queryNew("")>  
<cfset queryAddColumn( qrA, "size", "varchar", [ "D", "A", "B", "C" ] )>  
  
<cfset qrB = queryNew("")>  
<cfset queryAddColumn( qrB, "size", "varchar", [ "A" ] )>  
<cfset queryAddColumn( qrB, "quantity", "integer", [ 0 ] )>  
  
  
<cfquery name="joinQr" dbtype="query">  
    select qrA.*, qrB.quantity  
    from qrA, qrB  
    where qrA.size = qrB.size  
</cfquery>  
  
<cfquery name="newQrA" dbtype="query">  
    select *  
    from qrA  
</cfquery>  
  
  
<cfdump var="#qrA#">  
<cfdump var="#qrB#">  
<cfdump var="#joinQr#">  
<cfdump var="#newQrA#"> 

Actual Result: A query of one row ("D")

Expected Result: A query of 4 rows ("A", "B", "C", "D")

Any Workarounds:  None / avoid QoQ

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

Watson Bug ID:	3783011

External Customer Info:
External Company:  
External Customer Name: minli98
External Customer Email:  
External Test Config: My Hardware and Environment details:

Attachments:

Comments: