tracker issue : CF-4204486

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

Alphabetical ordering in query of queries differs from ordering in query from database

| View in Tracker

Status/Resolution/Reason: Closed/Withdrawn/Duplicate

Reporter/Name(from Bugbase): Michael C. / ()

Created: 06/08/2019

Components: Database, CFQuery

Versions: 2016

Failure Type: Incorrectly functioning

Found In Build/Fixed In Build: 2016,0,07,311392 /

Priority/Frequency: Normal / All users will encounter

Locale/System: English / Win 2012 Server x64

Vote Count: 0

Problem Description:

When a VARCHAR column that has some values which contain all upper case letters is ordered in a QoQ, the ordering differs from that when the query is executed against the database directly.

Steps to Reproduce:

<cfquery name="Test1" datasource="myDSN">
	SELECT * FROM Nations
	ORDER BY NationName
	WHERE NationName IN ('United Kingdom', 'USA')
</cfquery>

<cfquery name="Test2" dbtype="query">
	SELECT * FROM Test1
	ORDER BY NationName
	WHERE NationName  IN ('United Kingdom', 'USA')
</cfquery>

<cfdump var="#Test1#">
<cfdump var="#Test2#">

Actual Result:

1. USA
2. United Kingdom

Expected Result:

1. United Kingdom
2. USA

Any Workarounds:

None

Attachments:

Comments:

Hi Michael, This is a duplicate of another bug CF-4204484 Hence, I am withdrawing this bug. -Nimit    
Comment by Nimit S.
30892 | June 10, 2019 04:58:40 AM GMT