Debian Codegraph @

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

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