Debian Codegraph @

mysql-test/suite/plugins/r/fulltext_plugin.result

raw
1 #
2 # BUG#39746 - Debug flag breaks struct definition (server crash)
3 #
4 INSTALL PLUGIN simple_parser SONAME 'mypluglib.so';
5 CREATE TABLE t1(a TEXT, b TEXT, FULLTEXT(a) WITH PARSER simple_parser);
6 ALTER TABLE t1 ADD FULLTEXT(b) WITH PARSER simple_parser;
7 DROP TABLE t1;
8 UNINSTALL PLUGIN simple_parser;
9 show status like 'a%status';
10 Variable_name Value
11 # End of 10.5 tests
12 #
13 # MDEV-35308 NO_KEY_OPTIONS SQL mode has no effect on engine key options
14 #
15 install soname 'mypluglib';
16 set sql_mode=ignore_bad_table_options;
17 create table t1 (
18 f1 int foo=bar primary key auto_increment,
19 f2 int default 3 invisible,
20 f3 text,
21 vf1 int as (f2+2) invisible,
22 unique (f1) koo=12,
23 fulltext (f3) with parser simple_parser
24 ) too=yes;
25 Warnings:
26 Warning 1911 Unknown option 'foo'
27 Warning 1911 Unknown option 'koo'
28 Warning 1911 Unknown option 'too'
29 show create table t1;
30 Table Create Table
31 t1 CREATE TABLE `t1` (
32 `f1` int(11) NOT NULL AUTO_INCREMENT `foo`=bar,
33 `f2` int(11) DEFAULT 3 INVISIBLE,
34 `f3` text DEFAULT NULL,
35 `vf1` int(11) GENERATED ALWAYS AS (`f2` + 2) VIRTUAL INVISIBLE,
36 PRIMARY KEY (`f1`),
37 UNIQUE KEY `f1` (`f1`) `koo`=12,
38 FULLTEXT KEY `f3` (`f3`) WITH PARSER `simple_parser`
39 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci `too`=yes
40 set sql_mode=no_table_options;
41 show create table t1;
42 Table Create Table
43 t1 CREATE TABLE `t1` (
44 `f1` int(11) NOT NULL AUTO_INCREMENT /* `foo`=bar */,
45 `f2` int(11) DEFAULT 3 INVISIBLE,
46 `f3` text DEFAULT NULL,
47 `vf1` int(11) GENERATED ALWAYS AS (`f2` + 2) VIRTUAL INVISIBLE,
48 PRIMARY KEY (`f1`),
49 UNIQUE KEY `f1` (`f1`) /* `koo`=12 */,
50 FULLTEXT KEY `f3` (`f3`) WITH PARSER `simple_parser`
51 )
52 set sql_mode=no_field_options;
53 show create table t1;
54 Table Create Table
55 t1 CREATE TABLE `t1` (
56 `f1` int(11) NOT NULL,
57 `f2` int(11) DEFAULT 3,
58 `f3` text DEFAULT NULL,
59 `vf1` int(11) GENERATED ALWAYS AS (`f2` + 2) VIRTUAL,
60 PRIMARY KEY (`f1`),
61 UNIQUE KEY `f1` (`f1`) /* `koo`=12 */,
62 FULLTEXT KEY `f3` (`f3`) WITH PARSER `simple_parser`
63 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci /* `too`=yes */
64 set sql_mode=no_key_options;
65 show create table t1;
66 Table Create Table
67 t1 CREATE TABLE `t1` (
68 `f1` int(11) NOT NULL AUTO_INCREMENT /* `foo`=bar */,
69 `f2` int(11) DEFAULT 3 INVISIBLE,
70 `f3` text DEFAULT NULL,
71 `vf1` int(11) GENERATED ALWAYS AS (`f2` + 2) VIRTUAL INVISIBLE,
72 PRIMARY KEY (`f1`),
73 UNIQUE KEY `f1` (`f1`),
74 FULLTEXT KEY `f3` (`f3`)
75 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci /* `too`=yes */
76 drop table t1;
77 set sql_mode=default;
78 uninstall soname 'mypluglib';
79 # End of 11.7 tests