[QGIS-trac] Re: [Quantum GIS] #981: Attribute Table sorting not working as expected

[Quantum GIS]

#981: Attribute Table sorting not working as expected
-----------------------------------------------------+----------------------
        Reporter:  smizuno                           |         Owner:  mhugent      
            Type:  defect                            |        Status:  closed       
        Priority:  major: does not work as expected  |     Milestone:  Version 1.0.1
       Component:  GUI                               |       Version:  HEAD         
      Resolution:  fixed                             |      Keywords:  table sort   
Platform_version:                                    |      Platform:  All          
        Must_fix:  Yes                               |   Status_info:  0            
-----------------------------------------------------+----------------------
Changes (by smizuno):

  * status:  new => closed
  * resolution:  => fixed

Comment:

 Testing with r9954

 For number types, I have tried a mix of standard numeric notation and
 scientific notation and find that the sorting is correct, as long as there
 aren't the special values (like NaN, Infinity - note that infinity doesn't
 show in the attribute table view). Null cells sort at top or bottom
 depending on sort direction.

 I believe that the special values are not very likely to be seen in the
 GIS world, so I won't pursue this any farther.

 I can't be sure how text columns sort on null values (blank cells) as the
 word NULL is filled in for null data, so all cells have text in them.
 Therefore they sort properly.

 Since numbers now sort properly, I consider this closed.

 Thank you.

-- 
Ticket URL: <https://trac.osgeo.org/qgis/ticket/981#comment:3>
Quantum GIS <http://qgis.org>
Quantum GIS is an Open Source GIS viewer/editor supporting OGR, PostGIS, and GRASS formats