Debian Codegraph @

mysql-test/suite/sys_vars/r/mysqlx_document_id_unique_prefix_basic.result

raw
1 SET @mysqlx_document_id_unique_prefix_sav= @@global.mysqlx_document_id_unique_prefix;
2 SET GLOBAL mysqlx_document_id_unique_prefix=7;
3 SET @@global.mysqlx_document_id_unique_prefix=7;
4 show variables like 'mysqlx_document_id_unique_prefix';
5 Variable_name Value
6 mysqlx_document_id_unique_prefix 7
7 SET @@global.mysqlx_document_id_unique_prefix=3600;
8 show variables like 'mysqlx_document_id_unique_prefix';
9 Variable_name Value
10 mysqlx_document_id_unique_prefix 3600
11 SET mysqlx_document_id_unique_prefix=7;
12 ERROR HY000: Variable 'mysqlx_document_id_unique_prefix' is a GLOBAL variable and should be set with SET GLOBAL
13 SET @@local.mysqlx_document_id_unique_prefix=7;
14 ERROR HY000: Variable 'mysqlx_document_id_unique_prefix' is a GLOBAL variable and should be set with SET GLOBAL
15 SET @@mysqlx_document_id_unique_prefix=7;
16 ERROR HY000: Variable 'mysqlx_document_id_unique_prefix' is a GLOBAL variable and should be set with SET GLOBAL
17 SET @@session.mysqlx_document_id_unique_prefix=7;
18 ERROR HY000: Variable 'mysqlx_document_id_unique_prefix' is a GLOBAL variable and should be set with SET GLOBAL
19 SET SESSION mysqlx_document_id_unique_prefix=7;
20 ERROR HY000: Variable 'mysqlx_document_id_unique_prefix' is a GLOBAL variable and should be set with SET GLOBAL
21 SET @@global.mysqlx_document_id_unique_prefix=3601;
22 SET GLOBAL mysqlx_document_id_unique_prefix=0;
23 SET GLOBAL mysqlx_document_id_unique_prefix=-1;
24 Warnings:
25 Warning 1292 Truncated incorrect mysqlx_document_id_unique_prefix value: '-1'
26 SET GLOBAL mysqlx_document_id_unique_prefix='invaid%char';
27 ERROR 42000: Incorrect argument type to variable 'mysqlx_document_id_unique_prefix'
28 show variables like 'mysqlx_document_id_unique_prefix';
29 Variable_name Value
30 mysqlx_document_id_unique_prefix 0
31 SET GLOBAL mysqlx_document_id_unique_prefix=65535;
32 show variables like 'mysqlx_document_id_unique_prefix';
33 Variable_name Value
34 mysqlx_document_id_unique_prefix 65535
35 SET GLOBAL mysqlx_document_id_unique_prefix=65536;
36 Warnings:
37 Warning 1292 Truncated incorrect mysqlx_document_id_unique_prefix value: '65536'
38 show variables like 'mysqlx_document_id_unique_prefix';
39 Variable_name Value
40 mysqlx_document_id_unique_prefix 65535
41 SET GLOBAL mysqlx_document_id_unique_prefix= @mysqlx_document_id_unique_prefix_sav;