Mercurial > gemma
diff schema/isrs_tests.sql @ 578:61af85a432bf
Fix extraction of object reference code
Use something more distinguishing in test to make it more likely
to catch similar errors.
| author | Tom Gottfried <tom@intevation.de> |
|---|---|
| date | Thu, 06 Sep 2018 13:19:51 +0200 |
| parents | ad07846b09d1 |
| children | 6590208e3ee1 |
line wrap: on
line diff
--- 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');