package Mysqlx.Notice

Get desktop application:
View/edit binary Protocol Buffers messages

* Common frame for all notices | ``.type`` | Value | |---------------------------------------------------|------ | | @ref Mysqlx::Notice::Warning | 1 | | @ref Mysqlx::Notice::SessionVariableChanged | 2 | | @ref Mysqlx::Notice::SessionStateChanged | 3 | | @ref Mysqlx::Notice::GroupReplicationStateChanged | 4 | | @ref Mysqlx::Notice::ServerHello | 5 |

• required uint32 type = 1

  * the type of the payload

• optional Frame.Scope scope = 2

  * global or local notification

• optional bytes payload = 3

  * the payload of the notification

* scope of notice

Used in: Frame

• GLOBAL = 1

• LOCAL = 2

* type of notice payload

• WARNING = 1

• SESSION_VARIABLE_CHANGED = 2

• SESSION_STATE_CHANGED = 3

• GROUP_REPLICATION_STATE_CHANGED = 4

• SERVER_HELLO = 5

* Notify clients about group replication state changes | @ref Mysqlx::Notice::Frame Field | Value | |-----------------------------------|------------| |``.type`` | 4 | |``.scope`` | ``global`` |

• required uint32 type = 1

  * type of group replication event

• optional string view_id = 2

  * view identifier

• MEMBERSHIP_QUORUM_LOSS = 1

• MEMBERSHIP_VIEW_CHANGE = 2

• MEMBER_ROLE_CHANGE = 3

• MEMBER_STATE_CHANGE = 4

* Notify clients about connection to X Protocol server | @ref Mysqlx::Notice::Frame Field | Value | |-----------------------------------|------------| |``.type`` | 5 | |``.scope`` | ``global`` |

(message has no fields)

• required SessionStateChanged.Parameter param = 1

  * parameter key

• repeated Datatypes.Scalar value = 2

  * updated value

Used in: SessionStateChanged

• CURRENT_SCHEMA = 1

• ACCOUNT_EXPIRED = 2

• GENERATED_INSERT_ID = 3

• ROWS_AFFECTED = 4

• ROWS_FOUND = 5

• ROWS_MATCHED = 6

• TRX_COMMITTED = 7

• TRX_ROLLEDBACK = 9

• PRODUCED_MESSAGE = 10

• CLIENT_ID_ASSIGNED = 11

• GENERATED_DOCUMENT_IDS = 12

  .. more to be added

* Notify clients about changes to the current session variables. Every change to a variable that is accessible through: @code{sql} SHOW SESSION VARIABLES @endcode | @ref Mysqlx::Notice::Frame Field | Value | |-----------------------------------|----------| | ``.type`` | 2 | | ``.scope`` | ``local``|

• required string param = 1

  * name of the variable

• optional Datatypes.Scalar value = 2

  * the changed value of param

* Server-side warnings and notes @par ``.scope`` == ``local`` ``.level``, ``.code`` and ``.msg`` map the content of: @code{sql} SHOW WARNINGS @endcode @par ``.scope`` == ``global`` (undefined) Will be used for global, unstructured messages like: - server is shutting down - a node disconnected from group - schema or table dropped | @ref Mysqlx::Notice::Frame Field | Value | |-----------------------------------|-------------------------| | ``.type`` | 1 | | ``.scope`` | ``local`` or ``global`` |

• optional Warning.Level level = 1

  * Note or Warning

• required uint32 code = 2

  * warning code

• required string msg = 3

  * warning message

Used in: Warning

• NOTE = 1

• WARNING = 2

• ERROR = 3