From: Rémi BOURGAREL <bourgarel.remi@gmail.com>
Date: Tue, 4 Oct 2016 13:49:31 +0000 (+0200)
Subject: Change on get_addressdata check for matching the condition in placex_update
X-Git-Tag: v3.0.0~116
X-Git-Url: https://git.openstreetmap.org./nominatim.git/commitdiff_plain/8a2e4010257543cee432e0f7c17aa1fded96700a?ds=sidebyside

Change on get_addressdata check for matching the condition in placex_update

On placex_update we stop the indexing to the first parent if the rank_search is above 27. We should do the same check in get_adressdata, because place with a rank_address != 30 and a search_rank > 27 will have only 1 parent.
https://github.com/twain47/Nominatim/issues/534
---

diff --git a/sql/functions.sql b/sql/functions.sql
index dc5c754b..949e4cae 100644
--- a/sql/functions.sql
+++ b/sql/functions.sql
@@ -2343,7 +2343,7 @@ BEGIN
 
   IF for_place_id IS NULL THEN
     select parent_place_id, calculated_country_code, housenumber, rank_search, postcode, name, class, type from placex 
-      WHERE place_id = in_place_id and rank_address = 30 
+      WHERE place_id = in_place_id and  rank_search > 27
       INTO for_place_id, searchcountrycode, searchhousenumber, searchrankaddress, searchpostcode, searchhousename, searchclass, searchtype;
   END IF;