summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorjhh <jorge.hernandez-herrero@att.com>2022-08-23 20:26:21 -0500
committerjhh <jorge.hernandez-herrero@att.com>2022-08-24 09:12:15 -0500
commit6745bb97eba3b1e2a60ea2c5fc9f9298d79f13e6 (patch)
treece103708030af6af35b5bb9bb80fa32197a0f622
parentc7b8370b5f7a320e8f563df8271d9836845a8bca (diff)
made lock sql compatible with both mysql/mariadb
Issue-ID: POLICY-4329 Signed-off-by: jhh <jorge.hernandez-herrero@att.com> Change-Id: I784a3f8456a201262056803169204d499a4a68a2 Signed-off-by: jhh <jorge.hernandez-herrero@att.com>
-rw-r--r--feature-distributed-locking/src/main/feature/db/pooling/sql/1811-distributedlocking.upgrade.sql4
1 files changed, 2 insertions, 2 deletions
diff --git a/feature-distributed-locking/src/main/feature/db/pooling/sql/1811-distributedlocking.upgrade.sql b/feature-distributed-locking/src/main/feature/db/pooling/sql/1811-distributedlocking.upgrade.sql
index ed51879c..847c44ac 100644
--- a/feature-distributed-locking/src/main/feature/db/pooling/sql/1811-distributedlocking.upgrade.sql
+++ b/feature-distributed-locking/src/main/feature/db/pooling/sql/1811-distributedlocking.upgrade.sql
@@ -1,7 +1,7 @@
# ============LICENSE_START=======================================================
# feature-distributed-locking
# ================================================================================
-# Copyright (C) 2018, 2021 AT&T Intellectual Property. All rights reserved.
+# Copyright (C) 2018, 2021-2022 AT&T Intellectual Property. All rights reserved.
# ================================================================================
# Licensed under the Apache License, Version 2.0 (the "License");
# you may not use this file except in compliance with the License.
@@ -18,6 +18,6 @@
set foreign_key_checks=0;
- ALTER TABLE pooling.locks modify if exists expirationTime timestamp default '1971-01-01 00:00:00.000000';
+ ALTER TABLE pooling.locks modify expirationTime timestamp default '1971-01-01 00:00:00.000000';
set foreign_key_checks=1;