Debian Codegraph @

mysql-test/suite/compat/oracle/r/plugin.result

raw
1 SET sql_mode=ORACLE;
2 #
3 # MDEV-16294: INSTALL PLUGIN IF NOT EXISTS / UNINSTALL PLUGIN IF EXISTS
4 #
5 # INSTALL IF NOT EXISTS PLUGIN name SONAME library /
6 # UNINSTALL IF EXISTS PLUGIN|SONAME name
7 #
8 select PLUGIN_NAME,PLUGIN_STATUS,PLUGIN_TYPE from information_schema.plugins where plugin_library like 'ha_example%';
9 PLUGIN_NAME PLUGIN_STATUS PLUGIN_TYPE
10 INSTALL PLUGIN IF NOT EXISTS example SONAME 'ha_example';
11 select PLUGIN_NAME,PLUGIN_STATUS,PLUGIN_TYPE from information_schema.plugins where plugin_library like 'ha_example%';
12 PLUGIN_NAME PLUGIN_STATUS PLUGIN_TYPE
13 EXAMPLE ACTIVE STORAGE ENGINE
14 INSTALL PLUGIN example SONAME 'ha_example';
15 ERROR HY000: Plugin 'example' already installed
16 INSTALL PLUGIN IF NOT EXISTS example SONAME 'ha_example';
17 Warnings:
18 Note 1968 Plugin 'example' already installed
19 SHOW WARNINGS;
20 Level Code Message
21 Note 1968 Plugin 'example' already installed
22 UNINSTALL PLUGIN IF EXISTS example;
23 select PLUGIN_NAME,PLUGIN_STATUS,PLUGIN_TYPE from information_schema.plugins where plugin_library like 'ha_example%';
24 PLUGIN_NAME PLUGIN_STATUS PLUGIN_TYPE
25 UNINSTALL PLUGIN IF EXISTS example;
26 Warnings:
27 Note 1305 PLUGIN example does not exist
28 SHOW WARNINGS;
29 Level Code Message
30 Note 1305 PLUGIN example does not exist
31 UNINSTALL PLUGIN example;
32 ERROR 42000: PLUGIN example does not exist
33 INSTALL SONAME 'ha_example';
34 select PLUGIN_NAME,PLUGIN_STATUS,PLUGIN_TYPE from information_schema.plugins where plugin_library like 'ha_example%';
35 PLUGIN_NAME PLUGIN_STATUS PLUGIN_TYPE
36 EXAMPLE ACTIVE STORAGE ENGINE
37 UNUSABLE ACTIVE DAEMON
38 UNINSTALL SONAME IF EXISTS 'ha_example';
39 UNINSTALL SONAME IF EXISTS 'ha_example';
40 Warnings:
41 Note 1305 SONAME ha_example.so does not exist
42 SHOW WARNINGS;
43 Level Code Message
44 Note 1305 SONAME ha_example.so does not exist
45 select PLUGIN_NAME,PLUGIN_STATUS,PLUGIN_TYPE from information_schema.plugins where plugin_library like 'ha_example%';
46 PLUGIN_NAME PLUGIN_STATUS PLUGIN_TYPE
47 UNINSTALL SONAME 'ha_example';
48 ERROR 42000: SONAME ha_example.so does not exist