Debian Codegraph @

mysql-test/suite/innodb_fts/r/truncate.result

raw
1 # Case 1 : CREATE FULLTEXT/ID + TRUNCATE
2 CREATE TABLE articles (
3 id INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY,
4 title VARCHAR(200),
5 body TEXT,
6 FULLTEXT fidx(title, body)
7 ) ENGINE=InnoDB;
8 INSERT INTO articles (title, body) VALUES
9 ('MySQL Tutorial','DBMS stands for MySQL DataBase ...');
10 SELECT title, body FROM articles WHERE
11 MATCH(title, body) AGAINST('mysql');
12 title body
13 MySQL Tutorial DBMS stands for MySQL DataBase ...
14 TRUNCATE TABLE articles;
15 INSERT INTO articles (title, body) VALUES
16 ('MySQL Tutorial','DBMS stands for MySQL DataBase ...');
17 SELECT title, body FROM articles WHERE
18 MATCH(title, body) AGAINST('mysql');
19 title body
20 MySQL Tutorial DBMS stands for MySQL DataBase ...
21 ALTER TABLE articles DROP KEY fidx;
22 INSERT INTO articles (title, body) VALUES
23 ('MySQL Tutorial','DBMS stands for MySQL DataBase ...');
24 TRUNCATE TABLE articles;
25 INSERT INTO articles (title, body) VALUES
26 ('MySQL Tutorial','DBMS stands for MySQL DataBase ...');
27 SELECT title, body FROM articles WHERE
28 MATCH(title, body) AGAINST('mysql');
29 ERROR HY000: Can't find FULLTEXT index matching the column list
30 ALTER TABLE articles ADD FULLTEXT KEY fidx(title, body);
31 INSERT INTO articles (title, body) VALUES
32 ('MySQL Tutorial','DBMS stands for MySQL DataBase ...');
33 SELECT title, body FROM articles WHERE
34 MATCH(title, body) AGAINST('mysql');
35 title body
36 MySQL Tutorial DBMS stands for MySQL DataBase ...
37 MySQL Tutorial DBMS stands for MySQL DataBase ...
38 DROP TABLE articles;
39 # Case 2 : CREATE FULLTEXT/ID + ALTER + TRUNCATE
40 CREATE TABLE articles (
41 id INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY,
42 title VARCHAR(200),
43 body TEXT
44 ) ENGINE=InnoDB;
45 ALTER TABLE articles ADD FULLTEXT KEY fidx(title, body);
46 Warnings:
47 Warning 124 InnoDB rebuilding table to add column FTS_DOC_ID
48 INSERT INTO articles (title, body) VALUES
49 ('MySQL Tutorial','DBMS stands for MySQL DataBase ...');
50 SELECT title, body FROM articles WHERE
51 MATCH(title, body) AGAINST('mysql');
52 title body
53 MySQL Tutorial DBMS stands for MySQL DataBase ...
54 TRUNCATE TABLE articles;
55 INSERT INTO articles (title, body) VALUES
56 ('MySQL Tutorial','DBMS stands for MySQL DataBase ...');
57 SELECT title, body FROM articles WHERE
58 MATCH(title, body) AGAINST('mysql');
59 title body
60 MySQL Tutorial DBMS stands for MySQL DataBase ...
61 ALTER TABLE articles DROP KEY fidx;
62 INSERT INTO articles (title, body) VALUES
63 ('MySQL Tutorial','DBMS stands for MySQL DataBase ...');
64 TRUNCATE TABLE articles;
65 # restart
66 INSERT INTO articles (title, body) VALUES
67 ('MySQL Tutorial','DBMS stands for MySQL DataBase ...');
68 SELECT title, body FROM articles WHERE
69 MATCH(title, body) AGAINST('mysql');
70 ERROR HY000: Can't find FULLTEXT index matching the column list
71 ALTER TABLE articles ADD FULLTEXT KEY fidx(title, body);
72 INSERT INTO articles (title, body) VALUES
73 ('MySQL Tutorial','DBMS stands for MySQL DataBase ...');
74 SELECT title, body FROM articles WHERE
75 MATCH(title, body) AGAINST('mysql');
76 title body
77 MySQL Tutorial DBMS stands for MySQL DataBase ...
78 MySQL Tutorial DBMS stands for MySQL DataBase ...
79 DROP TABLE articles;
80 # Case 3 : CREATE FULLTEXT + TRUNCATE
81 CREATE TABLE articles (
82 title VARCHAR(200),
83 body TEXT,
84 FULLTEXT fidx(title, body)
85 ) ENGINE=InnoDB;
86 INSERT INTO articles (title, body) VALUES
87 ('MySQL Tutorial','DBMS stands for MySQL DataBase ...');
88 SELECT title, body FROM articles WHERE
89 MATCH(title, body) AGAINST('mysql');
90 title body
91 MySQL Tutorial DBMS stands for MySQL DataBase ...
92 TRUNCATE TABLE articles;
93 INSERT INTO articles (title, body) VALUES
94 ('MySQL Tutorial','DBMS stands for MySQL DataBase ...');
95 SELECT title, body FROM articles WHERE
96 MATCH(title, body) AGAINST('mysql');
97 title body
98 MySQL Tutorial DBMS stands for MySQL DataBase ...
99 ALTER TABLE articles DROP KEY fidx;
100 INSERT INTO articles (title, body) VALUES
101 ('MySQL Tutorial','DBMS stands for MySQL DataBase ...');
102 TRUNCATE TABLE articles;
103 INSERT INTO articles (title, body) VALUES
104 ('MySQL Tutorial','DBMS stands for MySQL DataBase ...');
105 SELECT title, body FROM articles WHERE
106 MATCH(title, body) AGAINST('mysql');
107 ERROR HY000: Can't find FULLTEXT index matching the column list
108 ALTER TABLE articles ADD FULLTEXT KEY fidx(title, body);
109 INSERT INTO articles (title, body) VALUES
110 ('MySQL Tutorial','DBMS stands for MySQL DataBase ...');
111 SELECT title, body FROM articles WHERE
112 MATCH(title, body) AGAINST('mysql');
113 title body
114 MySQL Tutorial DBMS stands for MySQL DataBase ...
115 MySQL Tutorial DBMS stands for MySQL DataBase ...
116 DROP TABLE articles;
117 # Case 4 : CREATE FULLTEXT + ALTER + TRUNCATE
118 CREATE TABLE articles (
119 title VARCHAR(200),
120 body TEXT
121 ) ENGINE=InnoDB;
122 ALTER TABLE articles ADD FULLTEXT KEY fidx(title, body);
123 Warnings:
124 Warning 124 InnoDB rebuilding table to add column FTS_DOC_ID
125 INSERT INTO articles (title, body) VALUES
126 ('MySQL Tutorial','DBMS stands for MySQL DataBase ...');
127 SELECT title, body FROM articles WHERE
128 MATCH(title, body) AGAINST('mysql');
129 title body
130 MySQL Tutorial DBMS stands for MySQL DataBase ...
131 TRUNCATE TABLE articles;
132 INSERT INTO articles (title, body) VALUES
133 ('MySQL Tutorial','DBMS stands for MySQL DataBase ...');
134 SELECT title, body FROM articles WHERE
135 MATCH(title, body) AGAINST('mysql');
136 title body
137 MySQL Tutorial DBMS stands for MySQL DataBase ...
138 ALTER TABLE articles DROP KEY fidx;
139 INSERT INTO articles (title, body) VALUES
140 ('MySQL Tutorial','DBMS stands for MySQL DataBase ...');
141 TRUNCATE TABLE articles;
142 # restart
143 INSERT INTO articles (title, body) VALUES
144 ('MySQL Tutorial','DBMS stands for MySQL DataBase ...');
145 SELECT title, body FROM articles WHERE
146 MATCH(title, body) AGAINST('mysql');
147 ERROR HY000: Can't find FULLTEXT index matching the column list
148 ALTER TABLE articles ADD FULLTEXT KEY fidx(title, body);
149 INSERT INTO articles (title, body) VALUES
150 ('MySQL Tutorial','DBMS stands for MySQL DataBase ...');
151 SELECT title, body FROM articles WHERE
152 MATCH(title, body) AGAINST('mysql');
153 title body
154 MySQL Tutorial DBMS stands for MySQL DataBase ...
155 MySQL Tutorial DBMS stands for MySQL DataBase ...
156 DROP TABLE articles;