From d763af61c5b6d3f25100d51144e04a0fd9d4b436 Mon Sep 17 00:00:00 2001 From: Jason Etheridge Date: Mon, 23 Mar 2020 12:52:12 -0400 Subject: [PATCH] for convenience, add some other values to handle_not_migrate Signed-off-by: Jason Etheridge --- sql/base/07-eg-specific.sql | 2 ++ 1 files changed, 2 insertions(+), 0 deletions(-) diff --git a/sql/base/07-eg-specific.sql b/sql/base/07-eg-specific.sql index 57e091f..c235d77 100644 --- a/sql/base/07-eg-specific.sql +++ b/sql/base/07-eg-specific.sql @@ -1105,9 +1105,11 @@ CREATE OR REPLACE FUNCTION migration_tools.handle_not_migrate (TEXT,TEXT) RETURN || ' SET x_migrate = CASE' || ' WHEN BTRIM(desired_not_migrate) = ''TRUE'' THEN FALSE' || ' WHEN BTRIM(desired_not_migrate) = ''DNM'' THEN FALSE' + || ' WHEN BTRIM(desired_not_migrate) = ''Delete'' THEN FALSE' || ' WHEN BTRIM(desired_not_migrate) = ''Do Not Migrate'' THEN FALSE' || ' WHEN BTRIM(desired_not_migrate) = ''FALSE'' THEN TRUE' || ' WHEN BTRIM(desired_not_migrate) = ''Migrate'' THEN TRUE' + || ' WHEN BTRIM(desired_not_migrate) = ''Keep'' THEN TRUE' || ' WHEN BTRIM(desired_not_migrate) = '''' THEN TRUE' || ' END'; -- 1.7.2.5