Resolve NXCALS-7195 "Feature improve constraints on changelog"

Merge request template

COMPATIBILITY NOTE

Please make sure that this change is BACKWARDS COMPATIBLE and a new server will work correctly with clients using old APIs versions.

It may be that data sent in the new format will break the old clients.

In case of any potential incompatibility we have to inform our clients and schedule release & deployment with them.

---

@acc-logging-team - please have a look for approval.

Please describe the merge request here.

Closes NXCALS-7195

service-db/src/main/resources/sql/versions/NXCALS-7195/NXCALS-7195-add-nn-constraints-to-changelogs.xml

@@ -10,7 +10,7 @@
                 CURSOR cursor_columns IS
                     SELECT table_name, column_name
                     FROM user_tab_columns
-                    where table_name = 'ENTITIES_CHANGELOG'
+                    WHERE table_name = 'ENTITIES_CHANGELOG'
                       and column_name = 'ENTITY_ID'
                       and nullable ='Y';
             BEGIN
@@ -25,7 +25,7 @@
                 CURSOR cursor_columns IS
                     SELECT table_name, column_name
                     FROM user_tab_columns
-                    where table_name = 'ENTITIES_HIST_CHANGELOG'
+                    WHERE table_name = 'ENTITIES_HIST_CHANGELOG'
                       and column_name = 'ENTITY_HIST_ID'
                       and nullable ='Y';
             BEGIN
@@ -40,7 +40,7 @@
                 CURSOR cursor_columns IS
                     SELECT table_name, column_name
                     FROM user_tab_columns
-                    where table_name = 'HIERARCHIES_CHANGELOG'
+                    WHERE table_name = 'HIERARCHIES_CHANGELOG'
                       and column_name = 'HIERARCHY_ID'
                       and nullable ='Y';
             BEGIN
@@ -55,7 +55,7 @@
                 CURSOR cursor_columns IS
                     SELECT table_name, column_name
                     FROM user_tab_columns
-                    where table_name = 'PARTITION_RESOURCE_HISTS_CHANGELOG'
+                    WHERE table_name = 'PARTITION_RESOURCE_HISTS_CHANGELOG'
                       and column_name = 'PARTITION_RESOURCE_HIST_ID'
                       and nullable ='Y';
             BEGIN
@@ -85,7 +85,7 @@
                 CURSOR cursor_columns IS
                     SELECT table_name, column_name
                     FROM user_tab_columns
-                    where table_name = 'PARTITIONS_CHANGELOG'
+                    WHERE table_name = 'PARTITIONS_CHANGELOG'
                       and column_name = 'PARTITION_ID'
                       and nullable ='Y';
             BEGIN
@@ -100,7 +100,7 @@
                 CURSOR cursor_columns IS
                     SELECT table_name, column_name
                     FROM user_tab_columns
-                    where table_name = 'SCHEMAS_CHANGELOG'
+                    WHERE table_name = 'SCHEMAS_CHANGELOG'
                       and column_name = 'SCHEMA_ID'
                       and nullable ='Y';
             BEGIN
@@ -115,7 +115,7 @@
                 CURSOR cursor_columns IS
                     SELECT table_name, column_name
                     FROM user_tab_columns
-                    where table_name = 'VARIABLE_CONFIGS_CHANGELOG'
+                    WHERE table_name = 'VARIABLE_CONFIGS_CHANGELOG'
                       and column_name = 'VARIABLE_CONFIG_ID'
                       and nullable ='Y';
             BEGIN
@@ -130,7 +130,7 @@
                 CURSOR cursor_columns IS
                     SELECT table_name, column_name
                     FROM user_tab_columns
-                    where table_name = 'VARIABLES_CHANGELOG'
+                    WHERE table_name = 'VARIABLES_CHANGELOG'
                       and column_name = 'VARIABLE_ID'
                       and nullable ='Y';
             BEGIN
@@ -145,7 +145,7 @@
             CURSOR cursor_columns IS
                 SELECT table_name, column_name
                 FROM user_tab_columns
-                where table_name in ('ENTITIES_CHANGELOG', 'ENTITIES_HIST_CHANGELOG', 'GROUP_ENTITIES_CHANGELOG',
+                WHERE table_name in ('ENTITIES_CHANGELOG', 'ENTITIES_HIST_CHANGELOG', 'GROUP_ENTITIES_CHANGELOG',
                                      'GROUP_PROPERTIES_CHANGELOG', 'GROUP_VARIABLES_CHANGELOG', 'GROUPS_CHANGELOG',
                                      'HIERARCHIES_CHANGELOG', 'PARTITION_RESOURCE_HISTS_CHANGELOG',
                                      'PARTITION_RESOURCES_CHANGELOG', 'PARTITIONS_CHANGELOG', 'SCHEMAS_CHANGELOG',