Debian Codegraph @

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

raw
1 SET default_regex_flags='';
2 SELECT @@default_regex_flags;
3 @@default_regex_flags
4
5 SET default_regex_flags=DEFAULT;
6 SELECT @@default_regex_flags;
7 @@default_regex_flags
8
9 SET default_regex_flags=NULL;
10 ERROR 42000: Variable 'default_regex_flags' can't be set to the value of 'NULL'
11 SELECT @@default_regex_flags;
12 @@default_regex_flags
13
14 SET default_regex_flags='UNKNOWN';
15 ERROR 42000: Variable 'default_regex_flags' can't be set to the value of 'UNKNOWN'
16 SET default_regex_flags=325;
17 ERROR 42000: Variable 'default_regex_flags' can't be set to the value of '325'
18 SET default_regex_flags=123.0;
19 ERROR 42000: Incorrect argument type to variable 'default_regex_flags'
20 SET default_regex_flags=123e0;
21 ERROR 42000: Incorrect argument type to variable 'default_regex_flags'
22 SET default_regex_flags='DOTALL';
23 SELECT @@default_regex_flags;
24 @@default_regex_flags
25 DOTALL
26 SET default_regex_flags=NULL;
27 ERROR 42000: Variable 'default_regex_flags' can't be set to the value of 'NULL'
28 SELECT @@default_regex_flags;
29 @@default_regex_flags
30 DOTALL
31 SET @@default_regex_flags=63;
32 SELECT @@default_regex_flags;
33 @@default_regex_flags
34 DOTALL,DUPNAMES,EXTENDED,EXTENDED_MORE,EXTRA,MULTILINE
35 SET @@default_regex_flags='DOTALL';
36 SELECT @@default_regex_flags;
37 @@default_regex_flags
38 DOTALL
39 SET @@default_regex_flags='DOTALL,DUPNAMES,EXTENDED,EXTRA,MULTILINE,UNGREEDY';
40 SELECT @@default_regex_flags;
41 @@default_regex_flags
42 DOTALL,DUPNAMES,EXTENDED,EXTRA,MULTILINE,UNGREEDY
43 SET @@default_regex_flags=DEFAULT;
44 SET @@global.default_regex_flags='MULTILINE';
45 SELECT @@session.default_regex_flags;
46 @@session.default_regex_flags
47
48 connect con1,localhost,root,,;
49 connection con1;
50 SELECT @@session.default_regex_flags;
51 @@session.default_regex_flags
52 MULTILINE
53 connection default;
54 disconnect con1;
55 SELECT @@session.default_regex_flags;
56 @@session.default_regex_flags
57
58 SET @@global.default_regex_flags=DEFAULT;
59 SET default_regex_flags=DEFAULT;