Azure Data Factory Data Flow - Does the max() function use the same sorting algorithm as a sort task?

Question

In a data flow I'm looking for the max() value from a set of strings.
For example,

1. D:\data\Publisher\Source\9781439876459.pdf
2. D:\data\Publisher\_Content\9781439876459.pdf

The max() function will return row 2. However if I sort the strings in descending order it will return row 1.
Furthermore:

• if I create a rank column and I sort in a descending order it will rank row 1 as 1
• in sql server if I sort or use the max() function it returns row 1.

Should the max() function be consistent with the sort and rank functionality?