From 76a808502b18d4fb8d77b7dfcd960613f9f7f085 Mon Sep 17 00:00:00 2001 From: Bill Erickson Date: Tue, 19 Dec 2017 15:58:02 -0500 Subject: [PATCH] JBAS-1764 A/T purge SQL COMMIT Signed-off-by: Bill Erickson --- KCLS/sql/schema/deploy/at-purge-interval-data.sql | 12 ++++++------ 1 file changed, 6 insertions(+), 6 deletions(-) diff --git a/KCLS/sql/schema/deploy/at-purge-interval-data.sql b/KCLS/sql/schema/deploy/at-purge-interval-data.sql index 34b65ff405..451350a650 100644 --- a/KCLS/sql/schema/deploy/at-purge-interval-data.sql +++ b/KCLS/sql/schema/deploy/at-purge-interval-data.sql @@ -145,14 +145,14 @@ INSERT INTO action_trigger.event SELECT * FROM tmp_at_event; SELECT CLOCK_TIMESTAMP(), 'action_trigger.event rebuilt', (SELECT COUNT(*) FROM action_trigger.event); --- TESTING -ROLLBACK; -/* -COMMIT; +-- TESTING -- +-- ROLLBACK; +-- END_TESTING -- +-- DEPLOYMENT -- +COMMIT; ANALYZE action_trigger.event; ANALYZE action_trigger.event_output; -*/ - +-- END_DEPLOYMENT -- -- 2.11.0