Mercurial > gemma

changeset 1135:19a04b150b6c

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Fixed SQL syntax errors introduced with 1153:2e6b47cdb2ca.
author Sascha L. Teichmann <sascha.teichmann@intevation.de>
date Wed, 07 Nov 2018 23:03:59 +0100
parents 0420761c1c3f
children a5069da2f0b7
files pkg/octree/cache.go
diffstat 1 files changed, 2 insertions(+), 2 deletions(-) [+]
line wrap: on
line diff
--- a/pkg/octree/cache.go	Wed Nov 07 21:45:10 2018 +0100
+++ b/pkg/octree/cache.go	Wed Nov 07 23:03:59 2018 +0100
@@ -48,7 +48,7 @@
 SELECT octree_checksum, octree_index
 FROM waterway.sounding_results
 WHERE bottleneck_id = $1 AND date_info = $2::date
-  AND octree_checksum NOT NULL AND octree_index NOT NULL
+  AND octree_checksum IS NOT NULL AND octree_index IS NOT NULL
 `
 	checkOctreeSQL = `
 SELECT CASE
@@ -57,7 +57,7 @@
   END
 FROM waterway.sounding_results
 WHERE bottleneck_id = $1 AND date_info = $2::date
-  AND octree_checksum NOT NULL AND octree_index NOT NULL
+  AND octree_checksum IS NOT NULL AND octree_index IS NOT NULL
 `
 )