[Geocoding] [OpenStreetMap] #4815: reverse.php crashes in bulgaria.osm data (fix included)

[OpenStreetMap]

#4815: reverse.php crashes in bulgaria.osm data (fix included)
----------------------------+-------------------------
 Reporter:  alon.gingold@…  |      Owner:  geocoding@…
     Type:  defect          |     Status:  new
 Priority:  critical        |  Milestone:
Component:  nominatim       |    Version:  1.0
 Keywords:                  |
----------------------------+-------------------------
 I've imported bulgaria.osm into a Nominatim VM, and reverse.php with
 zoom=18 & addressdetails=1 returns a blank page for coordinates in
 Bulgaria (it works fine on other imports of other countries).
 After tracing it, I found the problem:
 inside the Nominatim "functions.sql", there is a type called
 "addressline". This type has a field called osm_id. This field is defined
 as INTEGER, but there are locations in Bulgaria (and I'm guessing
 elsewhere) that the OSM_ID is higher then the maximum INTEGER number.. I
 changed it to BIGINT, recreated the type and the get_addressdata function
 which depends on it, and everything is OK.
 I can see the problem in
 https://trac.openstreetmap.org/browser/subversion/applications/utils/nominatim/sql/functions.sql

-- 
Ticket URL: <https://trac.openstreetmap.org/ticket/4815>
OpenStreetMap <http://www.openstreetmap.org/>
OpenStreetMap is a free editable map of the whole world