mirror of
https://github.com/MariaDB/server.git
synced 2025-08-01 03:47:19 +03:00
d632c85bb7
A simple "SET SESSION gtid_seq_no= DEFAULT" did not work, it would straight up crash the server! Also, explicitly setting gtid_seq_no to 0 gave an error in --gtid-strict-mode=1. Setting to DEFAULT or 0 should disable any prior setting of gtid_seq_no, so that the next transaction is allocated the next GTID in sequence, as normal. Reviewed-by: Monty <monty@mariadb.org> Signed-off-by: Kristian Nielsen <knielsen@knielsen-hq.org>
18 lines
600 B
Plaintext
18 lines
600 B
Plaintext
SELECT @@global.gtid_seq_no;
|
|
ERROR HY000: Variable 'gtid_seq_no' is a SESSION variable
|
|
SET GLOBAL gtid_seq_no= 10;
|
|
ERROR HY000: Variable 'gtid_seq_no' is a SESSION variable and can't be used with SET GLOBAL
|
|
SET SESSION gtid_seq_no= 20;
|
|
SELECT @@session.gtid_seq_no;
|
|
@@session.gtid_seq_no
|
|
20
|
|
SET GLOBAL gtid_seq_no= DEFAULT;
|
|
ERROR HY000: Variable 'gtid_seq_no' is a SESSION variable and can't be used with SET GLOBAL
|
|
SET SESSION gtid_seq_no= DEFAULT;
|
|
SET SESSION gtid_seq_no= -1;
|
|
Warnings:
|
|
Warning 1292 Truncated incorrect gtid_seq_no value: '-1'
|
|
SELECT @@session.gtid_seq_no;
|
|
@@session.gtid_seq_no
|
|
0
|