slave_type_conversions
This page is part of MariaDB's Documentation.
The parent of this page is: System Variables for MariaDB Enterprise Server
Topics on this page:
Overview
Configures how data type conversions are handled when row-based binary log events are applied. When set to the empty string, data types must match exactly, and no conversions are allowed.
DETAILS
The slave_type_conversions system variable configures how data type conversions are handled when row-based binary log events are applied. Statement-based binary log events are not impacted by this system variable.
The slave_type_conversions system variable can impact anything that uses row-based binary log events, including , , and .
Value | Description |
|---|---|
| All safe conversions (no data loss) are allowed. |
| All lossy conversions are allowed, such as |
| All conversions are allowed, both lossy and lossless. |
"" (an empty string) | The server returns an error if the table definition between the primary and replica differs and replication stops. |
PARAMETERS
Command-line | --slave_type_conversions={ALL_LOSSY| |
Configuration file | Supported |
Dynamic | Yes |
Scope | Global |
Data Type | SET (ALL_LOSSY, ALL_NON_LOSSY) |
Product Default Value | "" (an empty string) |
SKYSQL
EXAMPLES
Show Value with SHOW VARIABLES
Use the SHOW GLOBAL VARIABLES SQL statement to show the global value:
SHOW GLOBAL VARIABLES
LIKE 'slave_type_conversions';
Since this system variable is only global scope, SHOW VARIABLES and SHOW SESSION VARIABLES also show the global value.
Query Value using @@global
In SELECT and other SQL statements, @@global can be queried for the global value:
SELECT @@global.slave_type_conversions;
Since this system variable is only global scope, @@session can't be queried for this variable.
Query Information Schema
The information_schema.SYSTEM_VARIABLES table can be queried to obtain details about the system variable:
SELECT *
FROM information_schema.SYSTEM_VARIABLES
WHERE VARIABLE_NAME LIKE 'slave_type_conversions';
The information_schema.GLOBAL_VARIABLES table can be queried to obtain the global value:
SELECT *
FROM information_schema.GLOBAL_VARIABLES
WHERE VARIABLE_NAME LIKE 'slave_type_conversions';
This system variable is only global scope, so the information_schema.SESSION_VARIABLES table can also be queried to obtain the global value:
SELECT *
FROM information_schema.SESSION_VARIABLES
WHERE VARIABLE_NAME LIKE 'slave_type_conversions';