Debian Codegraph @

mysql-test/suite/innodb_fts/r/stopword,vers.rdiff

raw
1 --- stopword.result
2 +++ stopword,vers.reject
3 @@ -46,7 +46,7 @@
4 title VARCHAR(200),
5 body TEXT,
6 FULLTEXT (title,body)
7 -) ENGINE=InnoDB;
8 +) WITH SYSTEM VERSIONING ENGINE=InnoDB;
9 INSERT INTO articles (title,body) VALUES
10 ('MySQL Tutorial','DBMS stands for DataBase ...') ,
11 ('How To Use MySQL Well','After you went through a ...'),
12 @@ -60,7 +60,7 @@
13 set global innodb_ft_server_stopword_table = "not_defined";
14 ERROR 42000: Variable 'innodb_ft_server_stopword_table' can't be set to the value of 'not_defined'
15 set global innodb_ft_server_stopword_table = NULL;
16 -create table user_stopword(value varchar(30)) engine = innodb;
17 +create table user_stopword(value varchar(30)) WITH SYSTEM VERSIONING engine = innodb;
18 set global innodb_ft_server_stopword_table = "test/user_stopword";
19 drop index title on articles;
20 create fulltext index idx on articles(title, body);
21 @@ -73,7 +73,7 @@
22 title VARCHAR(200),
23 body TEXT,
24 FULLTEXT (title,body)
25 -) ENGINE=InnoDB;
26 +) WITH SYSTEM VERSIONING ENGINE=InnoDB;
27 INSERT INTO articles_2 (title, body)
28 VALUES ('test for stopwords','this is it...');
29 SELECT * FROM articles_2 WHERE MATCH (title,body)
30 @@ -88,13 +88,13 @@
31 title VARCHAR(200),
32 body TEXT,
33 FULLTEXT (title,body)
34 -) ENGINE=InnoDB;
35 +) WITH SYSTEM VERSIONING ENGINE=InnoDB;
36 INSERT INTO articles_3 (title, body)
37 VALUES ('test for stopwords','this is it...');
38 SELECT * FROM articles_3 WHERE MATCH (title,body)
39 AGAINST ('this' IN NATURAL LANGUAGE MODE);
40 id title body
41 -create table user_stopword_session(value varchar(30)) engine = innodb;
42 +create table user_stopword_session(value varchar(30)) WITH SYSTEM VERSIONING engine = innodb;
43 insert into user_stopword values("this");
44 delete from user_stopword;
45 insert into user_stopword_session values("session");
46 @@ -104,7 +104,7 @@
47 title VARCHAR(200),
48 body TEXT,
49 FULLTEXT (title,body)
50 -) ENGINE=InnoDB;
51 +) WITH SYSTEM VERSIONING ENGINE=InnoDB;
52 INSERT INTO articles_4 (title, body)
53 VALUES ('test for session stopwords','this should also be excluded...');
54 SELECT * FROM articles_4 WHERE MATCH (title,body)
55 @@ -120,7 +120,7 @@
56 title VARCHAR(200),
57 body TEXT,
58 FULLTEXT (title,body)
59 -) ENGINE=InnoDB;
60 +) WITH SYSTEM VERSIONING ENGINE=InnoDB;
61 INSERT INTO articles_5 (title, body)
62 VALUES ('test for session stopwords','this should also be excluded...');
63 SELECT * FROM articles_5 WHERE MATCH (title,body)
64 @@ -142,7 +142,7 @@
65 title VARCHAR(200),
66 body TEXT,
67 FULLTEXT `idx` (title,body)
68 -) ENGINE=InnoDB;
69 +) WITH SYSTEM VERSIONING ENGINE=InnoDB;
70 SHOW CREATE TABLE articles;
71 Table Create Table
72 articles CREATE TABLE `articles` (
73 @@ -151,7 +151,7 @@
74 `body` text DEFAULT NULL,
75 PRIMARY KEY (`id`),
76 FULLTEXT KEY `idx` (`title`,`body`)
77 -) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
78 +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci WITH SYSTEM VERSIONING
79 INSERT INTO articles (title,body) VALUES
80 ('MySQL from Tutorial','DBMS stands for DataBase ...') ,
81 ('when To Use MySQL Well','After that you went through a ...'),
82 @@ -248,7 +248,7 @@
83 `title` varchar(200) DEFAULT NULL,
84 `body` text DEFAULT NULL,
85 PRIMARY KEY (`id`)
86 -) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
87 +) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci WITH SYSTEM VERSIONING
88 ALTER TABLE articles ADD FULLTEXT INDEX idx (title,body);
89 ANALYZE TABLE articles;
90 Table Op Msg_type Msg_text
91 @@ -322,7 +322,7 @@
92 title VARCHAR(200),
93 body TEXT,
94 FULLTEXT `idx` (title,body)
95 -) ENGINE=InnoDB;
96 +) WITH SYSTEM VERSIONING ENGINE=InnoDB;
97 INSERT INTO articles (title,body) VALUES
98 ('MySQL from Tutorial','DBMS stands for DataBase ...') ,
99 ('when To Use MySQL Well','After that you went through a ...'),
100 @@ -334,9 +334,9 @@
101 id title body
102 SELECT * FROM articles WHERE MATCH (title,body) AGAINST ('will');
103 id title body
104 -create table user_stopword(value varchar(30)) engine = innodb;
105 +create table user_stopword(value varchar(30)) WITH SYSTEM VERSIONING engine = innodb;
106 set session innodb_ft_user_stopword_table = "test/user_stopword";
107 -create table server_stopword(value varchar(30)) engine = innodb;
108 +create table server_stopword(value varchar(30)) WITH SYSTEM VERSIONING engine = innodb;
109 set global innodb_ft_server_stopword_table = "test/server_stopword";
110 insert into user_stopword values("when"),("where");
111 delete from user_stopword;
112 @@ -421,7 +421,7 @@
113 title VARCHAR(200),
114 body TEXT,
115 FULLTEXT `idx` (title,body)
116 -) ENGINE=InnoDB;
117 +) WITH SYSTEM VERSIONING ENGINE=InnoDB;
118 SHOW CREATE TABLE articles;
119 Table Create Table
120 articles CREATE TABLE `articles` (
121 @@ -430,7 +430,7 @@
122 `body` text DEFAULT NULL,
123 PRIMARY KEY (`id`),
124 FULLTEXT KEY `idx` (`title`,`body`)
125 -) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
126 +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci WITH SYSTEM VERSIONING
127 INSERT INTO articles (title,body) VALUES
128 ('MySQL from Tutorial','DBMS stands for DataBase ...') ,
129 ('when To Use MySQL Well','After that you went through a ...'),
130 @@ -442,7 +442,7 @@
131 id title body
132 SELECT * FROM articles WHERE MATCH (title,body) AGAINST ('will');
133 id title body
134 -create table user_stopword(value varchar(30)) engine = innodb;
135 +create table user_stopword(value varchar(30)) WITH SYSTEM VERSIONING engine = innodb;
136 set session innodb_ft_user_stopword_table = "test/user_stopword";
137 insert into user_stopword values("mysqld"),("DBMS");
138 SELECT * FROM articles WHERE MATCH(title,body) AGAINST("+wha* +where" IN BOOLEAN MODE);
139 @@ -468,7 +468,7 @@
140 SELECT * FROM articles WHERE MATCH (title,body) AGAINST ('mysqld');
141 id title body
142 set session innodb_ft_user_stopword_table = default;
143 -create table server_stopword(value varchar(30)) engine = innodb;
144 +create table server_stopword(value varchar(30)) WITH SYSTEM VERSIONING engine = innodb;
145 set global innodb_ft_server_stopword_table = "test/server_stopword";
146 insert into server_stopword values("root"),("properly");
147 ALTER TABLE articles DROP INDEX idx;
148 @@ -532,7 +532,7 @@
149 title VARCHAR(200),
150 body TEXT,
151 FULLTEXT `idx` (title,body)
152 -) ENGINE=InnoDB;
153 +) WITH SYSTEM VERSIONING ENGINE=InnoDB;
154 SHOW CREATE TABLE articles;
155 Table Create Table
156 articles CREATE TABLE `articles` (
157 @@ -541,7 +541,7 @@
158 `body` text DEFAULT NULL,
159 PRIMARY KEY (`id`),
160 FULLTEXT KEY `idx` (`title`,`body`)
161 -) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
162 +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci WITH SYSTEM VERSIONING
163 INSERT INTO articles (title,body) VALUES
164 ('MySQL from Tutorial','DBMS stands for DataBase ...') ,
165 ('when To Use MySQL Well','After that you went through a ...'),
166 @@ -660,7 +660,7 @@
167 "In connection 1"
168 connection con1;
169 SET SESSION innodb_ft_enable_stopword = 1;
170 -create table user_stopword(value varchar(30)) engine = innodb;
171 +create table user_stopword(value varchar(30)) WITH SYSTEM VERSIONING engine = innodb;
172 set session innodb_ft_user_stopword_table = "test/user_stopword";
173 insert into user_stopword values("this"),("will"),("the");
174 ALTER TABLE articles DROP INDEX idx;
175 @@ -678,7 +678,7 @@
176 select @@innodb_ft_user_stopword_table;
177 @@innodb_ft_user_stopword_table
178 NULL
179 -create table user_stopword_1(value varchar(30)) engine = innodb;
180 +create table user_stopword_1(value varchar(30)) WITH SYSTEM VERSIONING engine = innodb;
181 set session innodb_ft_user_stopword_table = "test/user_stopword_1";
182 insert into user_stopword_1 values("when");
183 SET SESSION innodb_ft_enable_stopword = 1;
184 @@ -706,7 +706,7 @@
185 select @@innodb_ft_server_stopword_table;
186 @@innodb_ft_server_stopword_table
187 NULL
188 -create table server_stopword(value varchar(30)) engine = innodb;
189 +create table server_stopword(value varchar(30)) WITH SYSTEM VERSIONING engine = innodb;
190 SET GLOBAL innodb_ft_server_stopword_table = "test/server_stopword";
191 select @@innodb_ft_server_stopword_table;
192 @@innodb_ft_server_stopword_table