Project

General

Profile

« Previous | Next » 

Revision 5963

inputs/.TNRS/tnrs_*/create.sql: Fixed bug where need to COALESCE the WHERE condition with false to ensure that a boolean value, not NULL, is negated by NOT. Otherwise, tnrs_other's query would exclude rows for which the condition returned NULL rather than false.

View differences:

create.sql
1 1
SELECT *
2 2
FROM tnrs
3
WHERE
3
WHERE COALESCE(
4 4
"Name_submitted" = NULLIF(:schema.array_to_string(ARRAY[
5 5
    NULLIF("Accepted_name_family", 'Unknown')
6 6
    , "Accepted_name"
7 7
    , "Accepted_name_author"
8 8
], ' '), '')
9
, false)
9 10
ORDER BY "Name_submitted"
10 11
;
11 12

  

Also available in: Unified diff