mydb
, this variable will be called @@mydb_head_ref
and be set to the current head.refs/heads/branchName
or just branchName
:SET @@mydb_head_ref = 'feature-branch'
1
, this system variable creates a Dolt commit for every SQL transaction commit. Commits have an auto-generated commit message. Defaults to 0
.1
, this system variable allows transactions with merge conflicts to be committed. When set to 0
, merge conflicts must be resolved before committing a transaction, and attempting to commit a transaction with conflicts fails and rolls back the transaction. Defaults to 0
.1
, this system variable ignores all merge conflicts, constraint violations, and other correctness issues resulting from a merge and allows them to be committed. Defaults to 0
.@@dolt_replicate_to_remote
). When enabled, Dolt commits will be pushed asynchronously to the remote specified in the @@dolt_replicate_to_remote
system variable, instead of synchronously completing the push before returning from the Dolt commit operation. This setting can cause commits to complete faster since the push to remote is not synchronous, but it may also increase the remote replication delay. Because of the asynchronous nature, replication errors may also be less obvious.START TRANSACTION
. Setting autocommit = 1
will wrap every query in a transaction.dolt_replicate_heads
or dolt_replicate_all_heads
is required.dolt_read_replica_remote
. Use is mutually exclusive with dolt_replicate_all_heads
.dolt_read_replica_remote
. Use is mutually exclusive with dolt_replicate_heads
.repo.json
HEAD. New session active branches and working sets will reflect the new default. Sessions started before a variable change are unimpacted.SET
, global variables can be persisted to disk with SET PERSIST
. Persisted system variables survive restarts, loading back into the global variables namespace on startup.SET PERSIST
and SET PERSIST_ONLY
by writing system variables to the local .dolt/config.json
. The same result can be achieved with the CLI by appending sqlserver.global.
prefix to keys with the dolt config add --local
command. System variables are used as session variables, and the SQL interface is the encouraged access point. Variables that affect server startup, like replication, must be set before instantiation.SET PERSIST
SET PERSIST_ONLY
RESET PERSIST
is not supported.