From: Rogan Hamby <rhamby@equinoxinitiative.org>
Date: Tue, 14 Jul 2020 13:34:39 +0000 (-0400)
Subject: making the null out columns functions able to handle the term NULL and a single space... 
X-Git-Url: http://git.equinoxoli.org/?p=migration-tools.git;a=commitdiff_plain;h=f0ee39dc063f53fdabdb105c2e89041ca299dc96

making the null out columns functions able to handle the term NULL and a single space in case they haven't been trimmed
---

diff --git a/sql/base/09-misc.sql b/sql/base/09-misc.sql
index e8c342a..66faa4a 100644
--- a/sql/base/09-misc.sql
+++ b/sql/base/09-misc.sql
@@ -61,6 +61,8 @@ BEGIN
             AND column_name like 'l_%'
     LOOP
        EXECUTE FORMAT('UPDATE ' || s_name || '.' || t_name || ' SET ' || c_name || ' = NULL WHERE ' || c_name || ' = '''' '); 
+	   EXECUTE FORMAT('UPDATE ' || s_name || '.' || t_name || ' SET ' || c_name || ' = NULL WHERE ' || c_name || ' = '' '' '); 
+       EXECUTE FORMAT('UPDATE ' || s_name || '.' || t_name || ' SET ' || c_name || ' = NULL WHERE ' || c_name || ' = ''NULL'' '); 
     END LOOP;  
 
     RETURN TRUE;
@@ -81,6 +83,8 @@ BEGIN
             AND (data_type='text' OR data_type='character varying')
     LOOP
        EXECUTE FORMAT('UPDATE ' || s_name || '.' || t_name || ' SET ' || c_name || ' = NULL WHERE ' || c_name || ' = '''' ');
+       EXECUTE FORMAT('UPDATE ' || s_name || '.' || t_name || ' SET ' || c_name || ' = NULL WHERE ' || c_name || ' = '' '' ');
+       EXECUTE FORMAT('UPDATE ' || s_name || '.' || t_name || ' SET ' || c_name || ' = NULL WHERE ' || c_name || ' = ''NULL'' ');
     END LOOP;
 
     RETURN TRUE;