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

["Joshua Singer (JIRA)" <ji...@apache.org>]

Joshua Singer created CAY-2145:
----------------------------------

             Summary: Ordering.setNullSortedFirst(...) doesn't do anything on MySQL
                 Key: CAY-2145
                 URL: https://issues.apache.org/jira/browse/CAY-2145
             Project: Cayenne
          Issue Type: Bug
          Components: Database integration
    Affects Versions: 3.1.1, 3.1
         Environment: Mac OSX
            Reporter: Joshua Singer
            Priority: Minor


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



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)