Debian Codegraph @

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

raw
1 Test Case 1 : System Tablespace
2 CREATE TABLE articles (
3 id INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY,
4 title VARCHAR(200),
5 body TEXT,
6 FULLTEXT (title, body)
7 ) ENGINE=InnoDB tablespace innodb_system;
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 # restart
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 MySQL Tutorial DBMS stands for MySQL DataBase ...
22 DROP TABLE articles;
23 Test Case 2 : User-defined Tablespace
24 CREATE TABLESPACE s_def ADD DATAFILE 's_def.ibd';
25 CREATE TABLE articles (
26 id INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY,
27 title VARCHAR(200),
28 body TEXT,
29 FULLTEXT (title, body)
30 ) ENGINE=InnoDB tablespace s_def;
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 # restart
38 INSERT INTO articles (title, body) VALUES
39 ('MySQL Tutorial','DBMS stands for MySQL DataBase ...');
40 SELECT title, body FROM articles WHERE
41 MATCH(title, body) AGAINST('mysql');
42 title body
43 MySQL Tutorial DBMS stands for MySQL DataBase ...
44 MySQL Tutorial DBMS stands for MySQL DataBase ...
45 DROP TABLE articles;
46 DROP TABLESPACE s_def;
47 Test Case 3 : File-Per-Tablespace
48 CREATE TABLE articles (
49 id INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY,
50 title VARCHAR(200),
51 body TEXT,
52 FULLTEXT (title, body)
53 ) ENGINE=InnoDB;
54 INSERT INTO articles (title, body) VALUES
55 ('MySQL Tutorial','DBMS stands for MySQL DataBase ...');
56 SELECT title, body FROM articles WHERE
57 MATCH(title, body) AGAINST('mysql');
58 title body
59 MySQL Tutorial DBMS stands for MySQL DataBase ...
60 # restart
61 INSERT INTO articles (title, body) VALUES
62 ('MySQL Tutorial','DBMS stands for MySQL DataBase ...');
63 SELECT title, body FROM articles WHERE
64 MATCH(title, body) AGAINST('mysql');
65 title body
66 MySQL Tutorial DBMS stands for MySQL DataBase ...
67 MySQL Tutorial DBMS stands for MySQL DataBase ...
68 DROP TABLE articles;