summaryrefslogtreecommitdiffstats
path: root/cps-ri/src/main/resources/changelog/db/changes/16-insert-cm-handle-state-rollback.sql
diff options
context:
space:
mode:
authorJoseph Keenan <joseph.keenan@est.tech>2022-10-18 08:42:10 +0000
committerGerrit Code Review <gerrit@onap.org>2022-10-18 08:42:10 +0000
commit7edfab1993effb42c97a7e770a4a03267bde771b (patch)
tree9e43b75356ed6f3206c53460cf47a5c808fe45e2 /cps-ri/src/main/resources/changelog/db/changes/16-insert-cm-handle-state-rollback.sql
parent0727f3f713e37230d2b088adfcdf8ebbc56ba211 (diff)
parent2455cf3aabbdbcfd1d299caad558dede96ac85fe (diff)
Merge "Default CMHandles to READY during upgrade" into kohn
Diffstat (limited to 'cps-ri/src/main/resources/changelog/db/changes/16-insert-cm-handle-state-rollback.sql')
-rw-r--r--cps-ri/src/main/resources/changelog/db/changes/16-insert-cm-handle-state-rollback.sql8
1 files changed, 4 insertions, 4 deletions
diff --git a/cps-ri/src/main/resources/changelog/db/changes/16-insert-cm-handle-state-rollback.sql b/cps-ri/src/main/resources/changelog/db/changes/16-insert-cm-handle-state-rollback.sql
index aaf05a24cb..4b006ef0e2 100644
--- a/cps-ri/src/main/resources/changelog/db/changes/16-insert-cm-handle-state-rollback.sql
+++ b/cps-ri/src/main/resources/changelog/db/changes/16-insert-cm-handle-state-rollback.sql
@@ -1,4 +1,4 @@
-delete from fragment where xpath ~* '^/dmi-registry/cm-handles\[@id=''[\w\-]+''\]/state/lock-reason$';
-delete from fragment where xpath ~* '^/dmi-registry/cm-handles\[@id=''[\w\-]+''\]/state/datastores/operational$';
-delete from fragment where xpath ~* '^/dmi-registry/cm-handles\[@id=''[\w\-]+''\]/state/datastores$';
-delete from fragment where xpath ~* '^/dmi-registry/cm-handles\[@id=''[\w\-]+''\]/state$'; \ No newline at end of file
+DELETE FROM fragment WHERE xpath ~* '^/dmi-registry/cm-handles\[@id=''[\w\-]+''\]/state/lock-reason$';
+DELETE FROM fragment WHERE xpath ~* '^/dmi-registry/cm-handles\[@id=''[\w\-]+''\]/state/datastores/operational$';
+DELETE FROM fragment WHERE xpath ~* '^/dmi-registry/cm-handles\[@id=''[\w\-]+''\]/state/datastores$';
+DELETE FROM fragment WHERE xpath ~* '^/dmi-registry/cm-handles\[@id=''[\w\-]+''\]/state$'; \ No newline at end of file