From d6ff7475f1777f66cfc94847f6ba279fc0d10c2e Mon Sep 17 00:00:00 2001 From: Sarah Hoffmann Date: Wed, 19 Aug 2020 11:37:21 +0200 Subject: [PATCH] make sure that addr:* tags can always be searched for Always add contents of addr:* tags into address part of the search table, even when there is no corresponding other name. This keeps search tolerant to the kind of tagging where parts show up in the address that have no corresponding object in the database or where it is only an unaddressable object. --- sql/functions/normalization.sql | 8 +++++++- test/bdd/db/import/search_name.feature | 4 ++-- 2 files changed, 9 insertions(+), 3 deletions(-) diff --git a/sql/functions/normalization.sql b/sql/functions/normalization.sql index 66d0214a..1a8bbd84 100644 --- a/sql/functions/normalization.sql +++ b/sql/functions/normalization.sql @@ -207,16 +207,22 @@ CREATE OR REPLACE FUNCTION addr_ids_from_name(lookup_word TEXT) AS $$ DECLARE lookup_token TEXT; + id INTEGER; return_word_id INTEGER[]; BEGIN lookup_token := make_standard_name(lookup_word); SELECT array_agg(word_id) FROM word WHERE word_token = lookup_token and class is null and type is null INTO return_word_id; + IF return_word_id IS NULL THEN + id := nextval('seq_word'); + INSERT INTO word VALUES (id, lookup_token, null, null, null, null, 0); + return_word_id = ARRAY[id]; + END IF; RETURN return_word_id; END; $$ -LANGUAGE plpgsql STABLE; +LANGUAGE plpgsql; -- Normalize a string and look up its name ids (full words). diff --git a/test/bdd/db/import/search_name.feature b/test/bdd/db/import/search_name.feature index c4e5bbce..8006045f 100644 --- a/test/bdd/db/import/search_name.feature +++ b/test/bdd/db/import/search_name.feature @@ -39,13 +39,13 @@ Feature: Creation of search terms | object | nameaddress_vector | | W1 | bonn, new york, smalltown | - Scenario: A known addr:* tag is not added if the name is unknown + Scenario: A known addr:* tag is added even if the name is unknown Given the scene roads-with-pois And the places | osm | class | type | name | addr+city | geometry | | W1 | highway | residential | Road | Nandu | :w-north | When importing - Then search_name contains not + Then search_name contains | object | nameaddress_vector | | W1 | nandu | -- 2.39.5