tracker issue : CF-4202730

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

Query-of-query has incorrect letter sorting

| View in Tracker

Status/Resolution/Reason: Needs Review//Investigate

Reporter/Name(from Bugbase): ALEXANDER HASS / ()

Created: 06/05/2018

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

Versions: 2016

Failure Type: Incorrectly functioning

Found In Build/Fixed In Build: Updater 6 /

Priority/Frequency: Normal / All users will encounter

Locale/System: German / Win 2016

Vote Count: 0

Problem Description: If we build up a query and select names with order, the order of names is incorrect compared to MsSQL query result sets that are ordered properly.

Steps to Reproduce: See attached example

Actual Result: Names with UpperCaseFirst are ordered first and LowerCaseFirst are ordered after the last UpperCaseFirst 

Expected Result: "Order by letter" and not by "letter and casing"

Any Workarounds: lcase the name column in order statement

Attachments:

Comments:

Provided hotfix has bug with DISTINCT, MAX or GROUP BY. Waiting for new hotfix.
Comment by ALEXANDER H.
29155 | July 04, 2018 03:27:19 PM GMT