[PostGIS] #5695: standardize_address suspected of returning incorrect results

[PostGIS]

#5695: standardize_address suspected of returning incorrect results
----------------------------------+---------------------------
  Reporter:  tmcsys               |      Owner:  robe
      Type:  defect               |     Status:  new
  Priority:  medium               |  Milestone:  PostGIS 3.4.3
 Component:  pagc_address_parser  |    Version:  3.4.x
Resolution:                       |   Keywords:
----------------------------------+---------------------------
Comment (by robe):

 I isolated the issue down to the change in us_lex, by confirming an old
 backup I have if I swap out the new us_lex with the old us_lex, the
 directional processing is correct.

 However after purging the two entries I had introduced in #5299, the
 directional processing is still wrong.

 [722d8873/git#file3]

 The main difference between the old and new (besides the 2 entries I
 added) is the autogenerated id field
 which I had mistakenly assumed didn't matter but somehow even though the
 values are in same order as they were before, records are no longer in
 same order and that matters.

 So I guess two bugs, here, but work around for now I'll force the insert
 order, if I force the insert order of entries to be as it was before, then
 those examples you have seem to behave correctly.
-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5695#comment:3>
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.