Debian Codegraph @

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

raw
1 #
2 # MDEV-15935 Connection Redirection Mechanism in MariaDB Client/Server Protocol
3 #
4 connect con,localhost,anyone_but_root;
5 select @@redirect_url;
6 @@redirect_url
7 mysql://foobar
8 connection default;
9 set @old_global_redirect_url=@@global.redirect_url;
10 set @old_session_redirect_url=@@session.redirect_url;
11 set @old_session_track_system_variables=@@session_track_system_variables;
12 set session_track_system_variables="";
13 select @@global.redirect_url;
14 @@global.redirect_url
15
16 set global redirect_url=default;
17 select @@global.redirect_url;
18 @@global.redirect_url
19
20 set global redirect_url="mariadb.org";
21 ERROR 42000: Variable 'redirect_url' can't be set to the value of 'mariadb.org'
22 set global redirect_url="https://mariadb.org";
23 ERROR 42000: Variable 'redirect_url' can't be set to the value of 'https://mariadb.org'
24 set global redirect_url="mysql://mariadb.org:";
25 ERROR 42000: Variable 'redirect_url' can't be set to the value of 'mysql://mariadb.org:'
26 set global redirect_url="mysql://mariadb.org:hello";
27 ERROR 42000: Variable 'redirect_url' can't be set to the value of 'mysql://mariadb.org:hello'
28 set global redirect_url="mysql://";
29 ERROR 42000: Variable 'redirect_url' can't be set to the value of 'mysql://'
30 set global redirect_url="mysql://mariadb.org";
31 select @@global.redirect_url;
32 @@global.redirect_url
33 mysql://mariadb.org
34 set global redirect_url="mysql://mariadb.org:12a";
35 ERROR 42000: Variable 'redirect_url' can't be set to the value of 'mysql://mariadb.org:12a'
36 set global redirect_url="mysql://mariadb.org:66666";
37 ERROR 42000: Variable 'redirect_url' can't be set to the value of 'mysql://mariadb.org:66666'
38 set global redirect_url="mysql://mariadb.org:12345";
39 select @@global.redirect_url;
40 @@global.redirect_url
41 mysql://mariadb.org:12345
42 set global redirect_url="maria";
43 ERROR 42000: Variable 'redirect_url' can't be set to the value of 'maria'
44 set global redirect_url="mariadb://mariadb.org:";
45 ERROR 42000: Variable 'redirect_url' can't be set to the value of 'mariadb://mariadb.org:'
46 set global redirect_url="mariadb://mariadb.org:hello";
47 ERROR 42000: Variable 'redirect_url' can't be set to the value of 'mariadb://mariadb.org:hello'
48 set global redirect_url="mariadb://";
49 ERROR 42000: Variable 'redirect_url' can't be set to the value of 'mariadb://'
50 set global redirect_url="mariadb://mariadb.org";
51 select @@global.redirect_url;
52 @@global.redirect_url
53 mariadb://mariadb.org
54 set global redirect_url="mariadb://mariadb.org:12a";
55 ERROR 42000: Variable 'redirect_url' can't be set to the value of 'mariadb://mariadb.org:12a'
56 set global redirect_url="mariadb://mariadb.org:66666";
57 ERROR 42000: Variable 'redirect_url' can't be set to the value of 'mariadb://mariadb.org:66666'
58 set global redirect_url="mariadb://mariadb.org:12345";
59 select @@global.redirect_url;
60 @@global.redirect_url
61 mariadb://mariadb.org:12345
62 select @@session.redirect_url;
63 @@session.redirect_url
64
65 set session redirect_url=default;
66 select @@session.redirect_url;
67 @@session.redirect_url
68 mariadb://mariadb.org:12345
69 set session redirect_url="mysql://localhost";
70 select @@session.redirect_url;
71 @@session.redirect_url
72 mysql://localhost
73 select @@global.redirect_url;
74 @@global.redirect_url
75 mariadb://mariadb.org:12345
76 set global redirect_url=@old_global_redirect_url;
77 set session redirect_url=@old_session_redirect_url;
78 set session session_track_system_variables=@old_session_track_system_variables;
79 #
80 # end of test MDEV-15935
81 #