From: Sarah Hoffmann <lonvia@denofr.de>
Date: Wed, 23 Sep 2020 13:26:36 +0000 (+0200)
Subject: Merge remote-tracking branch 'upstream/master'
X-Git-Tag: deploy~211
X-Git-Url: https://git.openstreetmap.org./nominatim.git/commitdiff_plain/bda330a87d7e6de044d4a47e61ded8c4a49fe61e?hp=-c

Merge remote-tracking branch 'upstream/master'
---

bda330a87d7e6de044d4a47e61ded8c4a49fe61e
diff --combined sql/functions/address_lookup.sql
index 196fb434,b20cb364..53bc1ae3
--- a/sql/functions/address_lookup.sql
+++ b/sql/functions/address_lookup.sql
@@@ -101,6 -101,7 +101,7 @@@ DECLAR
    postcode_isexact BOOL;
    searchclass TEXT;
    searchtype TEXT;
+   search_unlisted_place TEXT;
    countryname HSTORE;
  BEGIN
    -- The place ein question might not have a direct entry in place_addressline.
@@@ -155,11 -156,13 +156,13 @@@
    IF for_place_id IS NULL THEN
      SELECT parent_place_id, country_code, housenumber, rank_search,
             postcode, address is not null and address ? 'postcode',
-            name, class, type
+            name, class, type,
+            address -> '_unlisted_place' as unlisted_place
        FROM placex
        WHERE place_id = in_place_id and rank_search > 27
        INTO for_place_id, searchcountrycode, searchhousenumber, searchrankaddress,
-            searchpostcode, postcode_isexact, searchhousename, searchclass, searchtype;
+            searchpostcode, postcode_isexact, searchhousename, searchclass,
+            searchtype, search_unlisted_place;
    END IF;
  
    -- If for_place_id is still NULL at this point then the object has its own
@@@ -210,7 -213,7 +213,7 @@@
    FOR location IN
      SELECT placex.place_id, osm_type, osm_id, name, class, type,
             coalesce(extratags->'linked_place', extratags->'place') as place_type,
 -           admin_level, fromarea, isaddress,
 +           admin_level, fromarea, isaddress and linked_place_id is NULL as isaddress,
             CASE WHEN rank_address = 11 THEN 5 ELSE rank_address END as rank_address,
             distance, country_code, postcode
        FROM place_addressline join placex on (address_place_id = placex.place_id)
@@@ -279,6 -282,11 +282,11 @@@
      RETURN NEXT location;
    END IF;
  
+   IF search_unlisted_place is not null THEN
+     RETURN NEXT ROW(null, null, null, hstore('name', search_unlisted_place),
+                     'place', 'locality', null, null, true, true, 26, 0)::addressline;
+   END IF;
+ 
    IF searchpostcode IS NOT NULL THEN
      location := ROW(null, null, null, hstore('ref', searchpostcode), 'place',
                      'postcode', null, null, false, true, 5, 0)::addressline;