On this page
Sets a sync variable to propagate to all leaves in the workspace.
SET LEAF variable_name = value
variable_: name of the sync variable.
value: value to be assigned to the sync variable.
variable_must be a sync variable that can sync to all nodes (aggregators and leaves).
You cannot this command on a non-sync variable.
This command must be run on the master aggregator.
The following example syncs the variable
regexp_ to all leaves.
SET LEAF can be run on
regexp_ is a variable that can sync to all nodes (leaves and aggregators).
SET LEAF regexp_format = "extended";
Retrieve the variable’s value:
+-----------------+ | @@regexp_format | +-----------------+ | extended | +-----------------+
The following example attempts to sync the variable
auto_ to all leaves.
SET LEAF fails because
auto_ is a variable that can sync to all aggregators, only.
SET LEAF auto_attach = 1;
ERROR 2324 (HY000): This workspace-wide variable exists only on aggregators, it's not possible to set a value for leaves
Last modified: June 22, 2022