[postgis-devel] [PostGIS] #1140: loader/PointZ test failing on my windows 9.0/9.1

[PostGIS]

#1140: loader/PointZ test failing on my windows 9.0/9.1
---------------------+------------------------------------------------------
 Reporter:  robe     |       Owner:  pramsey      
     Type:  defect   |      Status:  new          
 Priority:  medium   |   Milestone:  PostGIS 2.0.0
Component:  postgis  |     Version:  trunk        
 Keywords:           |  
---------------------+------------------------------------------------------
 I haven't tried my 8.4 yet, I presume it's strk's last r7656 change?

 It seems now my results are sorted differently from expected:
 The PointZ.select.expected has:

 {{{
 POINT(0 1 2 3)
 POINT(9 -1 -20 -123)
 POINT(9 -1 -2 -3)
 }}}


 But I'm getting

 {{{
 POINT(0 1 2 3)
 POINT(9 -1 -2 -3)
 POINT(9 -1 -20 -123)
 }}}

 I guess 0 sorts after space on windows.

 What do you get strk:

 e.g.

 {{{
 SELECT *
 FROM (values ('01'),(' 03')) As f
 ORDER By 1;
 }}}

 on my box gives:


 {{{
  03
 01
 }}}

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/1140>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.