This is an automated email from the ASF dual-hosted git repository.
gongchao pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/hertzbeat.git
The following commit(s) were added to refs/heads/master by this push:
new a3def497b [fix] remove v174 and add v180 flway script (#3787)
a3def497b is described below
commit a3def497b4c5c30898534acdc934acd958cf45d9
Author: Yang Chen <[email protected]>
AuthorDate: Wed Oct 1 00:20:55 2025 +0800
[fix] remove v174 and add v180 flway script (#3787)
Co-authored-by: Tomsun28 <[email protected]>
---
...__update_column.sql => V180__update_column.sql} | 4 ++--
...__update_column.sql => V180__update_column.sql} | 26 +++++++++++-----------
...__update_column.sql => V180__update_column.sql} | 8 +++----
3 files changed, 19 insertions(+), 19 deletions(-)
diff --git
a/hertzbeat-manager/src/main/resources/db/migration/h2/V174__update_column.sql
b/hertzbeat-manager/src/main/resources/db/migration/h2/V180__update_column.sql
similarity index 95%
rename from
hertzbeat-manager/src/main/resources/db/migration/h2/V174__update_column.sql
rename to
hertzbeat-manager/src/main/resources/db/migration/h2/V180__update_column.sql
index 7fd010171..70e80cb00 100644
---
a/hertzbeat-manager/src/main/resources/db/migration/h2/V174__update_column.sql
+++
b/hertzbeat-manager/src/main/resources/db/migration/h2/V180__update_column.sql
@@ -18,11 +18,11 @@
-- ensure every sql can rerun without error
-- Update type from 'realtime' to 'realtime_metric'
-UPDATE HZB_ALERT_DEFINE
+UPDATE HZB_ALERT_DEFINE
SET type = 'realtime_metric'
WHERE type = 'realtime';
-- Update type from 'periodic' to 'periodic_metric'
-UPDATE HZB_ALERT_DEFINE
+UPDATE HZB_ALERT_DEFINE
SET type = 'periodic_metric'
WHERE type = 'periodic';
diff --git
a/hertzbeat-manager/src/main/resources/db/migration/mysql/V174__update_column.sql
b/hertzbeat-manager/src/main/resources/db/migration/mysql/V180__update_column.sql
similarity index 73%
rename from
hertzbeat-manager/src/main/resources/db/migration/mysql/V174__update_column.sql
rename to
hertzbeat-manager/src/main/resources/db/migration/mysql/V180__update_column.sql
index 7e4933458..dbc21060f 100644
---
a/hertzbeat-manager/src/main/resources/db/migration/mysql/V174__update_column.sql
+++
b/hertzbeat-manager/src/main/resources/db/migration/mysql/V180__update_column.sql
@@ -23,19 +23,19 @@ CREATE PROCEDURE UpdateAlertDefineColumns()
BEGIN
DECLARE table_exists INT;
- SELECT COUNT(*) INTO table_exists
- FROM INFORMATION_SCHEMA.TABLES
- WHERE TABLE_SCHEMA = DATABASE() AND TABLE_NAME = 'hzb_alert_define';
-
- IF table_exists = 1 THEN
- UPDATE hzb_alert_define
- SET type = 'realtime_metric'
- WHERE type = 'realtime';
-
- UPDATE hzb_alert_define
- SET type = 'periodic_metric'
- WHERE type = 'periodic';
- END IF;
+SELECT COUNT(*) INTO table_exists
+FROM INFORMATION_SCHEMA.TABLES
+WHERE TABLE_SCHEMA = DATABASE() AND TABLE_NAME = 'hzb_alert_define';
+
+IF table_exists = 1 THEN
+UPDATE hzb_alert_define
+SET type = 'realtime_metric'
+WHERE type = 'realtime';
+
+UPDATE hzb_alert_define
+SET type = 'periodic_metric'
+WHERE type = 'periodic';
+END IF;
END //
DELIMITER ;
diff --git
a/hertzbeat-manager/src/main/resources/db/migration/postgresql/V174__update_column.sql
b/hertzbeat-manager/src/main/resources/db/migration/postgresql/V180__update_column.sql
similarity index 90%
rename from
hertzbeat-manager/src/main/resources/db/migration/postgresql/V174__update_column.sql
rename to
hertzbeat-manager/src/main/resources/db/migration/postgresql/V180__update_column.sql
index 3129d5fa5..4e8b4046b 100644
---
a/hertzbeat-manager/src/main/resources/db/migration/postgresql/V174__update_column.sql
+++
b/hertzbeat-manager/src/main/resources/db/migration/postgresql/V180__update_column.sql
@@ -18,13 +18,13 @@
-- ensure every sql can rerun without error
-- Update type from 'realtime' to 'realtime_metric'
-UPDATE HZB_ALERT_DEFINE
-SET type = 'realtime_metric'
+UPDATE HZB_ALERT_DEFINE
+SET type = 'realtime_metric'
WHERE type = 'realtime';
-- Update type from 'periodic' to 'periodic_metric'
-UPDATE HZB_ALERT_DEFINE
-SET type = 'periodic_metric'
+UPDATE HZB_ALERT_DEFINE
+SET type = 'periodic_metric'
WHERE type = 'periodic';
commit;
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
