diff options
author | Jesse Luehrs <doy@tozt.net> | 2020-11-14 16:34:38 -0500 |
---|---|---|
committer | Jesse Luehrs <doy@tozt.net> | 2020-11-14 16:34:38 -0500 |
commit | 53d5fc4854fff3fe4eab421add896192e80bec42 (patch) | |
tree | e2bcc3090ea64eb4b785a4bc2729b6480302aa77 | |
parent | ad1374de1ad3c201ca311535783c1ab7926b68bc (diff) | |
download | metabase-utils-53d5fc4854fff3fe4eab421add896192e80bec42.tar.gz metabase-utils-53d5fc4854fff3fe4eab421add896192e80bec42.zip |
fix null handling
-rw-r--r-- | data/denorm.sql | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/data/denorm.sql b/data/denorm.sql index 51080bf..cca7884 100644 --- a/data/denorm.sql +++ b/data/denorm.sql @@ -349,5 +349,5 @@ CREATE VIEW spending AS ( category != 'Donations' and category != 'Family' and category != 'Reimbursables' and - memo != 'down payment' + (memo IS NULL or memo != 'down payment') ); |