1 CREATE TABLE t1(a int) ENGINE=EXAMPLE;
3 Warning 1286 Unknown table engine 'EXAMPLE'
4 Warning 1266 Using storage engine MyISAM for table 't1'
6 INSTALL PLUGIN example SONAME 'ha_example.so';
7 INSTALL PLUGIN EXAMPLE SONAME 'ha_example.so';
8 ERROR HY000: Function 'EXAMPLE' already exists
9 UNINSTALL PLUGIN example;
10 INSTALL PLUGIN example SONAME 'ha_example.so';
11 CREATE TABLE t1(a int) ENGINE=EXAMPLE;
15 UNINSTALL PLUGIN example;
16 UNINSTALL PLUGIN EXAMPLE;
17 ERROR 42000: PLUGIN EXAMPLE does not exist
18 UNINSTALL PLUGIN non_exist;
19 ERROR 42000: PLUGIN non_exist does not exist
21 # Bug#32034: check_func_enum() does not check correct values but set it
22 # to impossible int val
24 INSTALL PLUGIN example SONAME 'ha_example.so';
25 SET GLOBAL example_enum_var= e1;
26 SET GLOBAL example_enum_var= e2;
27 SET GLOBAL example_enum_var= impossible;
28 ERROR 42000: Variable 'enum_var' can't be set to the value of 'impossible'
29 UNINSTALL PLUGIN example;
30 INSTALL PLUGIN example SONAME 'ha_example.so';
31 select @@session.sql_mode into @old_sql_mode;
32 set session sql_mode='';
33 set global example_ulong_var=500;
34 select @@global.example_ulong_var;
35 @@global.example_ulong_var
37 set global example_ulong_var=1111;
39 Warning 1292 Truncated incorrect ulong_var value: '1111'
40 select @@global.example_ulong_var;
41 @@global.example_ulong_var
43 set session sql_mode='STRICT_ALL_TABLES';
44 set global example_ulong_var=500;
45 select @@global.example_ulong_var;
46 @@global.example_ulong_var
48 set global example_ulong_var=1111;
49 ERROR 42000: Variable 'ulong_var' can't be set to the value of '1111'
50 select @@global.example_ulong_var;
51 @@global.example_ulong_var
53 set session sql_mode=@old_sql_mode;
55 ERROR HY000: Variable 'old' is a read only variable
56 UNINSTALL PLUGIN example;