Debian Codegraph @

mysql-test/suite/innodb_fts/t/tablespace.test

raw
1 --echo 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
9 INSERT INTO articles (title, body) VALUES
10 ('MySQL Tutorial','DBMS stands for MySQL DataBase ...');
11
12 SELECT title, body FROM articles WHERE
13 MATCH(title, body) AGAINST('mysql');
14
15 --source include/restart_mysqld.inc
16
17 INSERT INTO articles (title, body) VALUES
18 ('MySQL Tutorial','DBMS stands for MySQL DataBase ...');
19
20 SELECT title, body FROM articles WHERE
21 MATCH(title, body) AGAINST('mysql');
22
23 DROP TABLE articles;
24
25 --echo Test Case 2 : User-defined Tablespace
26 CREATE TABLESPACE s_def ADD DATAFILE 's_def.ibd';
27
28 CREATE TABLE articles (
29 id INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY,
30 title VARCHAR(200),
31 body TEXT,
32 FULLTEXT (title, body)
33 ) ENGINE=InnoDB tablespace s_def;
34
35 INSERT INTO articles (title, body) VALUES
36 ('MySQL Tutorial','DBMS stands for MySQL DataBase ...');
37
38 SELECT title, body FROM articles WHERE
39 MATCH(title, body) AGAINST('mysql');
40
41 --source include/restart_mysqld.inc
42
43 INSERT INTO articles (title, body) VALUES
44 ('MySQL Tutorial','DBMS stands for MySQL DataBase ...');
45
46 SELECT title, body FROM articles WHERE
47 MATCH(title, body) AGAINST('mysql');
48
49 DROP TABLE articles;
50
51 DROP TABLESPACE s_def;
52
53 --echo Test Case 3 : File-Per-Tablespace
54 CREATE TABLE articles (
55 id INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY,
56 title VARCHAR(200),
57 body TEXT,
58 FULLTEXT (title, body)
59 ) ENGINE=InnoDB;
60
61 INSERT INTO articles (title, body) VALUES
62 ('MySQL Tutorial','DBMS stands for MySQL DataBase ...');
63
64 SELECT title, body FROM articles WHERE
65 MATCH(title, body) AGAINST('mysql');
66
67 --source include/restart_mysqld.inc
68
69 INSERT INTO articles (title, body) VALUES
70 ('MySQL Tutorial','DBMS stands for MySQL DataBase ...');
71
72 SELECT title, body FROM articles WHERE
73 MATCH(title, body) AGAINST('mysql');
74
75 DROP TABLE articles;