[CAY-2145] Ordering.setNullSortedFirst(...) doesn't do anything on MySQL

• Type: Bug
• Status: Open
• Priority: Minor
• Resolution: Unresolved
• Affects Version/s: 3.1, 3.1.1
• Component/s: Database integration
• Environment: Mac OSX
• Assignee: Unassigned
• Reporter: Joshua Singer
• Created: 15/Nov/16 17:55
• Updated: 15/Nov/16 17:55

Description

In an ordered result set, rows with a NULL value in a column which is part of the ordering can come at the beginning or at the end of the results.

As I understand it, Cayenne's setNullSortedFirst on the Ordering class is supposed to switch between these two options, the default being true, i.e. rows with a NULL come at the start. However, I've set this to false in Cayenne 3.1.1 on MySQL, it doesn't have any effect. I put a breakpoint on the accessor for this boolean. It never seems to be read by Cayenne's OrderingTranslator class.

MySQL version: Ver 14.14 Distrib 5.6.25, for osx10.8