[postgis-tickets] [PostGIS] #3756: GROUP BY groups reversed segments into single bucket

[PostGIS]

#3756: GROUP BY groups reversed segments into single bucket
---------------------+---------------------------
 Reporter:  komzpa   |      Owner:  pramsey
     Type:  defect   |     Status:  new
 Priority:  medium   |  Milestone:  PostGIS 2.3.3
Component:  postgis  |    Version:  2.3.x
 Keywords:           |
---------------------+---------------------------
 I'm making a traffic model of a city.

 I have a table with (geom, speed), where geom is two-point line
 representing edge of a graph, and speed is a floating point value. Edges
 can be duplicate and can be reversed.

 When I create summary, (select geom, avg(speed) from table group by 1), it
 groups reversed segments into same buckets.

 Expected behavior: reversed segments go to different buckets.

--
Ticket URL: <https://trac.osgeo.org/postgis/ticket/3756>
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.