Status/Resolution/Reason: Closed/Fixed/
Reporter/Name(from Bugbase): Ken Clark / Ken Clark (gr8white)
Created: 09/25/2012
Components: Database
Versions: 9.0.1
Failure Type: Incorrect w/Workaround
Found In Build/Fixed In Build: 9.0.1 /
Priority/Frequency: Trivial / Unknown
Locale/System: English / Linux All
Vote Count: 0
Problem Description: I have a query, query A, with two columns, fac_name and fac_seq_id, ordered by fac_name. A second query, query B, has some other information tied to query A by a column id. I then create query C by joining A and B in a Query of Queries. Now I output the results of query A and they display in fac_seq_id order rather than the original order.
Steps to Reproduce: I did a CFDUMP of query A before and after creating query C.
Actual Result: The first CFDUMP shows the results in the correct order, the second one shows the query has been reordered.
Expected Result: Query A should remain in its original state, the two CFDUMPs should display the same results.
Any Workarounds: The immediate workaround is to do another QoQ to order Query A in the original order, after creating Query C.
----------------------------- Additional Watson Details -----------------------------
Watson Bug ID: 3336700
External Customer Info:
External Company:
External Customer Name: gr8white
External Customer Email:
External Test Config: My Hardware and Environment details: Linux server.Attachments:
- October 29, 2013 00:00:00: 1_bugtest.cfm
Comments: