Debian Codegraph @

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

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