X-Git-Url: https://git.openstreetmap.org./nominatim.git/blobdiff_plain/7dd0a63b688c14b49179c47b592bdf309abe6d08..72c0898409d5c496538287cea3c71edc3c170e62:/sql/tiger_import_start.sql?ds=sidebyside diff --git a/sql/tiger_import_start.sql b/sql/tiger_import_start.sql index 5acb3e59..ef55e11c 100644 --- a/sql/tiger_import_start.sql +++ b/sql/tiger_import_start.sql @@ -26,6 +26,11 @@ BEGIN endnumber = in_startnumber; END IF; + IF startnumber < 0 THEN + RAISE WARNING 'Negative house number range (% to %) on %, %', startnumber, endnumber, in_street, in_isin; + RETURN 0; + END IF; + numberrange := endnumber - startnumber; IF (interpolationtype = 'odd' AND startnumber%2 = 0) OR (interpolationtype = 'even' AND startnumber%2 = 1) THEN