Debian Codegraph @

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

raw
1 '#---------------------BS_STVARS_017_01----------------------#'
2 SELECT COUNT(@@GLOBAL.have_ssl);
3 COUNT(@@GLOBAL.have_ssl)
4 1
5 Warnings:
6 Warning 1287 '@@have_ssl' is deprecated and will be removed in a future release. Please use performance_schema.tls_channel_status table instead.
7 1 Expected
8 '#---------------------BS_STVARS_017_02----------------------#'
9 SET @@GLOBAL.have_ssl=1;
10 ERROR HY000: Variable 'have_ssl' is a read only variable
11 Expected error 'Read only variable'
12 SELECT COUNT(@@GLOBAL.have_ssl);
13 COUNT(@@GLOBAL.have_ssl)
14 1
15 Warnings:
16 Warning 1287 '@@have_ssl' is deprecated and will be removed in a future release. Please use performance_schema.tls_channel_status table instead.
17 1 Expected
18 '#---------------------BS_STVARS_017_03----------------------#'
19 SELECT @@GLOBAL.have_ssl = VARIABLE_VALUE
20 FROM performance_schema.global_variables
21 WHERE VARIABLE_NAME='have_ssl';
22 @@GLOBAL.have_ssl = VARIABLE_VALUE
23 1
24 1 Expected
25 SELECT COUNT(@@GLOBAL.have_ssl);
26 COUNT(@@GLOBAL.have_ssl)
27 1
28 Warnings:
29 Warning 1287 '@@have_ssl' is deprecated and will be removed in a future release. Please use performance_schema.tls_channel_status table instead.
30 1 Expected
31 SELECT COUNT(VARIABLE_VALUE)
32 FROM performance_schema.global_variables
33 WHERE VARIABLE_NAME='have_ssl';
34 COUNT(VARIABLE_VALUE)
35 1
36 1 Expected
37 '#---------------------BS_STVARS_017_04----------------------#'
38 SELECT @@have_ssl = @@GLOBAL.have_ssl;
39 @@have_ssl = @@GLOBAL.have_ssl
40 1
41 Warnings:
42 Warning 1287 '@@have_ssl' is deprecated and will be removed in a future release. Please use performance_schema.tls_channel_status table instead.
43 Warning 1287 '@@have_ssl' is deprecated and will be removed in a future release. Please use performance_schema.tls_channel_status table instead.
44 1 Expected
45 '#---------------------BS_STVARS_017_05----------------------#'
46 SELECT COUNT(@@have_ssl);
47 COUNT(@@have_ssl)
48 1
49 Warnings:
50 Warning 1287 '@@have_ssl' is deprecated and will be removed in a future release. Please use performance_schema.tls_channel_status table instead.
51 1 Expected
52 SELECT COUNT(@@local.have_ssl);
53 ERROR HY000: Variable 'have_ssl' is a GLOBAL variable
54 Expected error 'Variable is a GLOBAL variable'
55 SELECT COUNT(@@SESSION.have_ssl);
56 ERROR HY000: Variable 'have_ssl' is a GLOBAL variable
57 Expected error 'Variable is a GLOBAL variable'
58 SELECT COUNT(@@GLOBAL.have_ssl);
59 COUNT(@@GLOBAL.have_ssl)
60 1
61 Warnings:
62 Warning 1287 '@@have_ssl' is deprecated and will be removed in a future release. Please use performance_schema.tls_channel_status table instead.
63 1 Expected
64 SELECT have_ssl;
65 ERROR 42S22: Unknown column 'have_ssl' in 'field list'
66 Expected error 'Unknown column'