Debian Codegraph @

mysql-test/suite/plugins/t/fulltext_plugin.test

raw
1 --source include/have_simple_parser.inc
2
3 --echo #
4 --echo # BUG#39746 - Debug flag breaks struct definition (server crash)
5 --echo #
6 --replace_result .dll .so
7 eval INSTALL PLUGIN simple_parser SONAME '$MYPLUGLIB_SO';
8 CREATE TABLE t1(a TEXT, b TEXT, FULLTEXT(a) WITH PARSER simple_parser);
9 ALTER TABLE t1 ADD FULLTEXT(b) WITH PARSER simple_parser;
10 DROP TABLE t1;
11 UNINSTALL PLUGIN simple_parser;
12
13 #
14 # Bug #69682 - mysqld crashes after uninstall of plugin with "first" status var
15 #
16 show status like 'a%status';
17
18 --echo # End of 10.5 tests
19
20 --echo #
21 --echo # MDEV-35308 NO_KEY_OPTIONS SQL mode has no effect on engine key options
22 --echo #
23 install soname 'mypluglib';
24 set sql_mode=ignore_bad_table_options;
25 create table t1 (
26 f1 int foo=bar primary key auto_increment,
27 f2 int default 3 invisible,
28 f3 text,
29 vf1 int as (f2+2) invisible,
30 unique (f1) koo=12,
31 fulltext (f3) with parser simple_parser
32 ) too=yes;
33 show create table t1;
34 set sql_mode=no_table_options;
35 show create table t1;
36 set sql_mode=no_field_options;
37 show create table t1;
38 set sql_mode=no_key_options;
39 show create table t1;
40 drop table t1;
41 set sql_mode=default;
42 uninstall soname 'mypluglib';
43
44 --echo # End of 11.7 tests