# HG changeset patch
# User Tom Gottfried <tom@intevation.de>
# Date 1536232791 -7200
# Node ID 61af85a432bfc954e40a69948018d8d38b02b8fc
# Parent  e6c9d2da2e201d203194ef76f286d03a18973976
Fix extraction of object reference code

Use something more distinguishing in test to make it more likely
to catch similar errors.

diff -r e6c9d2da2e20 -r 61af85a432bf schema/isrs.sql
--- a/schema/isrs.sql	Wed Sep 05 19:13:37 2018 +0200
+++ b/schema/isrs.sql	Thu Sep 06 13:19:51 2018 +0200
@@ -45,7 +45,7 @@
             substring(isrs_text from 1 for 2),
             substring(isrs_text from 3 for 3),
             substring(isrs_text from 6 for 5),
-            substring(isrs_text from 10 for 5),
+            substring(isrs_text from 11 for 5),
             CAST(substring(isrs_text from 16 for 5) AS int))
             AS isrs);
     END IF;
diff -r e6c9d2da2e20 -r 61af85a432bf schema/isrs_tests.sql
--- a/schema/isrs_tests.sql	Wed Sep 05 19:13:37 2018 +0200
+++ b/schema/isrs_tests.sql	Thu Sep 06 13:19:51 2018 +0200
@@ -3,10 +3,10 @@
 --
 
 SELECT results_eq($$
-    SELECT isrs_fromText('DEXXX039000000005023')
+    SELECT isrs_fromText('DEBON03901G007906548')
     $$,
     $$
-    SELECT CAST(('DE', 'XXX', '03900', '00000', 5023) AS isrs)
+    SELECT CAST(('DE', 'BON', '03901', 'G0079', 6548) AS isrs)
     $$,
     'Correct ISRS text input gives respective ISRS location code');