From: Sarah Hoffmann <lonvia@denofr.de>
Date: Wed, 1 Jul 2020 13:46:08 +0000 (+0200)
Subject: sql: fix rank variable type
X-Git-Tag: v3.6.0~120
X-Git-Url: https://git.openstreetmap.org./nominatim.git/commitdiff_plain/2edefd9e80ac27600dbd2fdebfa29735b29587d8?ds=inline;hp=-c

sql: fix rank variable type

The rank type needs to match the parameter type of
update_place_diameter().

Fixes #1851.
---

2edefd9e80ac27600dbd2fdebfa29735b29587d8
diff --git a/sql/functions/utils.sql b/sql/functions/utils.sql
index 2b3db04a..33ae340a 100644
--- a/sql/functions/utils.sql
+++ b/sql/functions/utils.sql
@@ -467,7 +467,7 @@ DECLARE
   placegeom GEOMETRY;
   geom GEOMETRY;
   diameter FLOAT;
-  rank INTEGER;
+  rank SMALLINT;
 BEGIN
   UPDATE placex SET indexed_status = 2 WHERE place_id = placeid;
   SELECT geometry, rank_search FROM placex WHERE place_id = placeid INTO placegeom, rank;