[daisy] [JIRA] Created: (DSY-427) ORDER BY works incorrectly on NULL fields

[Min Idzelis (JIRA)]

ORDER BY works incorrectly on NULL fields
-----------------------------------------

         Key: DSY-427
         URL: http://issues.cocoondev.org//browse/DSY-427
     Project: Daisy
        Type: Bug
 Reporter: Min Idzelis
    Priority: Minor


Please see: http://demo.daisycms.org/daisy/DemoSite_A/g1/53-Demo.html

You have a document type that has 4 fields. Some of the fields are blank. If you ORDER BY these blank fields, it doesn't order fields that appear later in the query statement. 

For instance: 
select $FieldA, $FieldB, $FieldC, $FieldC, $FieldD, name where documentType = 'BuggyDoc' order by $FieldA, $FieldB, $FieldC, $FieldC, $FieldD 

Will show the documents in a table like this:

FieldA	FieldB	FieldC	FieldC	FieldD	Name	Actions

Testing				Zebra	BuggyDoc1	show
Testing		Yellow	Yellow		BuggyDoc2	show
Testing				Potatoe	BuggyDoc3	show
Testing				apple	BuggyDoc4	show
Testing				igloo	BuggyDoc5	show

-- when it should be like this:

FieldA	FieldB	FieldC	FieldC	FieldD	Name	Actions

Testing				apple	BuggyDoc4	show
Testing				igloo	BuggyDoc5	show
Testing				Potatoe	BuggyDoc3	show
Testing				Zebra	BuggyDoc1	show
Testing		Yellow	Yellow		BuggyDoc2	show



-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://issues.cocoondev.org//secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira