Mercurial > gemma

comparison schema/gemma_tests.sql @ 4603:d24e951206ca geoserver_sql_views

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Do not try to execute NULL as a subquery
author Tom Gottfried <tom@intevation.de>
date Tue, 03 Sep 2019 18:00:50 +0200
parents 9fef9930aa8a
children e8b2dc771f9e
comparison
equal deleted inserted replaced
4602:9fef9930aa8a 4603:d24e951206ca
19 'Valid statement passes check'); 19 'Valid statement passes check');
20 20
21 SELECT ok(NOT is_valid_from_item('This is not SQL'), 21 SELECT ok(NOT is_valid_from_item('This is not SQL'),
22 'Arbitrary text does not pass check'); 22 'Arbitrary text does not pass check');
23 23
24 SELECT ok(is_valid_from_item(NULL) IS NULL,
25 'NULL value is not checked');
26
24 SELECT throws_ok($$ 27 SELECT throws_ok($$
25 INSERT INTO waterway.waterway_axis (wtwaxs, objnam) VALUES 28 INSERT INTO waterway.waterway_axis (wtwaxs, objnam) VALUES
26 (ST_GeogFromText('LINESTRING(0 0, 1 1)'), 'test'), 29 (ST_GeogFromText('LINESTRING(0 0, 1 1)'), 'test'),
27 (ST_GeogFromText('LINESTRING(0 0, 1 1)'), 'test') 30 (ST_GeogFromText('LINESTRING(0 0, 1 1)'), 'test')
28 $$, 31 $$,