Mercurial > gemma

diff 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
line wrap: on
line diff
--- a/schema/gemma_tests.sql	Mon Sep 02 18:45:15 2019 +0200
+++ b/schema/gemma_tests.sql	Tue Sep 03 18:00:50 2019 +0200
@@ -21,6 +21,9 @@
 SELECT ok(NOT is_valid_from_item('This is not SQL'),
     'Arbitrary text does not pass check');
 
+SELECT ok(is_valid_from_item(NULL) IS NULL,
+    'NULL value is not checked');
+
 SELECT throws_ok($$
     INSERT INTO waterway.waterway_axis (wtwaxs, objnam) VALUES
         (ST_GeogFromText('LINESTRING(0 0, 1 1)'), 'test'),