Mercurial > gemma

comparison tap_tests.sql @ 110:c86b20edb398

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Comment on understand of docs.
author Tom Gottfried <tom@intevation.de>
date Fri, 15 Jun 2018 20:16:53 +0200
parents f6aba3ee3a75
children 894f633e2d3f
comparison
equal deleted inserted replaced
109:0e486e6ee60d 110:c86b20edb398
51 ('AT', 'XXX', '00001', '00000', 1)::isrs, 51 ('AT', 'XXX', '00001', '00000', 1)::isrs,
52 isrsrange(('AT', 'XXX', '00001', '00000', 0)::isrs, 52 isrsrange(('AT', 'XXX', '00001', '00000', 0)::isrs,
53 ('AT', 'XXX', '00001', '00000', 2)::isrs), 53 ('AT', 'XXX', '00001', '00000', 2)::isrs),
54 $2, 'AT', 'AT', 'AT', 54 $2, 'AT', 'AT', 'AT',
55 1, 'depth', 'testorganization'); 55 1, 'depth', 'testorganization');
56 -- XXX: In contrast to what table 240 in the PostgreSQL docs says
57 -- (https://www.postgresql.org/docs/10/static/sql-createpolicy.html),
58 -- the following tests seem to show that the USING expression is applied
59 -- also to an INSERT:
56 SELECT lives_ok('EXECUTE bn_insert(''test1'', 60 SELECT lives_ok('EXECUTE bn_insert(''test1'',
57 ST_geomfromtext(''POLYGON((0 0, 0 1, 1 1, 1 0, 0 0))'', 61 ST_geomfromtext(''POLYGON((0 0, 0 1, 1 1, 1 0, 0 0))'',
58 4326))', 62 4326))',
59 'Waterway admin can insert data within his region'); 63 'Waterway admin can insert data within his region');
60 SELECT throws_ok('EXECUTE bn_insert(''test2'', 64 SELECT throws_ok('EXECUTE bn_insert(''test2'',