Debian Codegraph @

mysql-test/suite/sys_vars/t/mysqlx_document_id_unique_prefix_basic.test

raw
1 # Variable: mysqlx_document_id_unique_prefix
2 # Default : 0
3 # Scope : GLOBAL
4 # Dynamic : Yes
5
6 SET @mysqlx_document_id_unique_prefix_sav= @@global.mysqlx_document_id_unique_prefix;
7 ## Valid cases
8 SET GLOBAL mysqlx_document_id_unique_prefix=7;
9 SET @@global.mysqlx_document_id_unique_prefix=7;
10 show variables like 'mysqlx_document_id_unique_prefix';
11 #Max valid value
12 SET @@global.mysqlx_document_id_unique_prefix=3600;
13 show variables like 'mysqlx_document_id_unique_prefix';
14
15 ## Invalid cases
16 --error ER_GLOBAL_VARIABLE
17 SET mysqlx_document_id_unique_prefix=7;
18 --error ER_GLOBAL_VARIABLE
19 SET @@local.mysqlx_document_id_unique_prefix=7;
20 --error ER_GLOBAL_VARIABLE
21 SET @@mysqlx_document_id_unique_prefix=7;
22 --error ER_GLOBAL_VARIABLE
23 SET @@session.mysqlx_document_id_unique_prefix=7;
24 --error ER_GLOBAL_VARIABLE
25 SET SESSION mysqlx_document_id_unique_prefix=7;
26 # Warning: Truncated incorrect mysqlx_document_id_unique_prefix value
27 SET @@global.mysqlx_document_id_unique_prefix=3601;
28
29 #--error ER_GLOBAL_VARIABLE
30 SET GLOBAL mysqlx_document_id_unique_prefix=0;
31 # Warning for negative values
32 SET GLOBAL mysqlx_document_id_unique_prefix=-1;
33 --error ER_WRONG_TYPE_FOR_VAR
34 SET GLOBAL mysqlx_document_id_unique_prefix='invaid%char';
35
36 show variables like 'mysqlx_document_id_unique_prefix';
37 SET GLOBAL mysqlx_document_id_unique_prefix=65535;
38 show variables like 'mysqlx_document_id_unique_prefix';
39 SET GLOBAL mysqlx_document_id_unique_prefix=65536;
40 show variables like 'mysqlx_document_id_unique_prefix';
41
42 SET GLOBAL mysqlx_document_id_unique_prefix= @mysqlx_document_id_unique_prefix_sav;