ALERT()

USAGE

ALERT(severity, message)

Argument Name

Description

severity

An integer that indicates the severity of the error

message

A string that provides the alert message

DETAILS

ALERT() is a function that sends an alert via email.

The severity integer can be in the range of 0 to 3:

Number

Severity

0

Critical

1

Error

2

Warning

3

Informational

The return value is NULL if the arguments are invalid.

See Email Alerts for MariaDB Xpand for details on Email Alerts and how to configure them.

SYNONYMS

SCHEMA

PARAMETERS

SKYSQL

PRIVILEGES

EXAMPLES

SELECT ALERT(3, 'This is an info alert test.') AS rc;
+------+
| rc   |
+------+
|    0 |
+------+
SELECT ALERT(1, 'This is an error alert test.') AS rc;
+------+
| rc   |
+------+
|    0 |
+------+

ERROR HANDLING

FEATURE INTERACTION

RESPONSES

DIAGNOSIS

ISO 9075:2016

CHANGE HISTORY

Release Series

History

23.09

  • Present starting in MariaDB Xpand 23.09.1.

6.1

  • Present starting in MariaDB Xpand 6.1.0.

6.0

  • Present starting in MariaDB Xpand 6.0.3.

5.3

  • Present starting in MariaDB Xpand 5.3.13.

Release Series

History

6.0

  • Present starting in MariaDB Xpand 6.0.3.

5.3

  • Present starting in MariaDB Xpand 5.3.13.

Release Series

History

6.1

  • Present starting in MariaDB Xpand 6.1.0.

EXTERNAL REFERENCES