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

[Bruno Dumon (JIRA)]

     [ http://issues.cocoondev.org//browse/DSY-427?page=all ]
     
Bruno Dumon resolved DSY-427:
-----------------------------

    Resolution: Fixed

> 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