Debian Codegraph @

mysql-test/suite/innodb_fts/include/tablespace_location_error.inc

raw
1 --let MYSQLD_DATADIR=`SELECT @@datadir`
2
3 SET DEBUG = '+d,ib_fts_aux_table_error';
4 --error 1030
5 --eval CREATE TABLE t1(a TEXT, b TEXT, c TEXT, d TEXT, FULLTEXT idx(a,b), FULLTEXT idx2(c,d)) $EXTRA_PARAMS
6 SET DEBUG = '-d,ib_fts_aux_table_error';
7
8 --source suite/innodb/include/show_i_s_tables.inc
9
10 --echo # list files in datadir/test
11 --list_files $MYSQLD_DATADIR/test
12
13 SET DEBUG = '+d,ib_fts_index_table_error';
14 --error 1030
15 --eval CREATE TABLE t1(a TEXT, b TEXT, c TEXT, d TEXT, FULLTEXT idx(a,b), FULLTEXT idx2(c,d)) $EXTRA_PARAMS
16 SET DEBUG = '-d,ib_fts_index_table_error';
17
18 --source suite/innodb/include/show_i_s_tables.inc
19
20 --echo # list files in datadir/test
21 --list_files $MYSQLD_DATADIR/test
22
23 --eval CREATE TABLE t1 (id INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY, title VARCHAR(200)) ENGINE=InnoDB $EXTRA_PARAMS
24 --source suite/innodb/include/show_i_s_tables.inc
25
26 --echo # list files in datadir/test
27 --list_files $MYSQLD_DATADIR/test
28
29 SET DEBUG = '+d,ib_fts_aux_table_error';
30 --error 1030
31 ALTER TABLE t1 ADD FULLTEXT INDEX (title);
32 SET DEBUG = '-d,ib_fts_aux_table_error';
33
34 --source suite/innodb/include/show_i_s_tables.inc
35 --echo # list files in datadir/test
36 --let $regexp=/fts_([0-9a-f_]+)([A-Z0-9_]+)/fts_aux\2/
37 --replace_regex $regexp
38 --list_files $MYSQLD_DATADIR/test
39
40 SET DEBUG = '+d,ib_fts_index_table_error';
41 --error 1030
42 ALTER TABLE t1 ADD FULLTEXT INDEX (title);
43 SET DEBUG = '-d,ib_fts_index_table_error';
44
45 --source suite/innodb/include/show_i_s_tables.inc
46 --echo # list files in datadir/test
47 --replace_regex $regexp
48 --list_files $MYSQLD_DATADIR/test
49 DROP TABLE t1;
50
51 --eval CREATE TABLE t1 (a VARCHAR(200), b TEXT, FULLTEXT fts_idx(a,b), c INT PRIMARY KEY) $EXTRA_PARAMS
52
53 INSERT INTO t1 VALUES
54 ('MySQL Tutorial','DBMS stands for DataBase', 1) ,
55 ('How To Use MySQL Well','After you went through a', 2),
56 ('Optimizing MySQL','In this tutorial we will show', 3);
57
58 INSERT INTO t1 VALUES
59 ('1001 MySQL Tricks','1. Never run mysqld as root', 4),
60 ('MySQL vs. YourSQL','In the following database comparison', 5),
61 ('MySQL Security','When configured properly, MySQL', 6);
62
63 SELECT c FROM t1 WHERE MATCH (a,b)
64 AGAINST ('Tutorial' IN NATURAL LANGUAGE MODE);
65
66 --source suite/innodb/include/show_i_s_tables.inc
67 --echo # list files in datadir/test
68 --replace_regex $regexp
69 --list_files $MYSQLD_DATADIR/test
70
71 SET DEBUG = '+d,ib_fts_aux_table_error';
72 --error 1030
73 ALTER TABLE t1 ADD COLUMN pk INT NOT NULL AUTO_INCREMENT, DROP PRIMARY KEY, ADD PRIMARY KEY(pk), ALGORITHM=copy;
74 SET DEBUG = '-d,ib_fts_aux_table_error';
75
76 --source suite/innodb/include/show_i_s_tables.inc
77 --echo # list files in datadir/test
78 --replace_regex $regexp
79 --list_files $MYSQLD_DATADIR/test
80
81 SET DEBUG = '+d,ib_fts_index_table_error';
82 --error 1030
83 ALTER TABLE t1 ADD COLUMN pk INT NOT NULL AUTO_INCREMENT, DROP PRIMARY KEY, ADD PRIMARY KEY(pk), ALGORITHM=copy;
84 SET DEBUG = '-d,ib_fts_index_table_error';
85
86 --source suite/innodb/include/show_i_s_tables.inc
87 --echo # list files in datadir/test
88 --replace_regex $regexp
89 --list_files $MYSQLD_DATADIR/test
90
91 SET DEBUG = '+d,ib_fts_aux_table_error';
92 ALTER TABLE t1 DROP INDEX fts_idx, ADD FULLTEXT INDEX fts_idx(a,b);
93 SET DEBUG = '-d,ib_fts_aux_table_error';
94
95 --source suite/innodb/include/show_i_s_tables.inc
96 --echo # list files in datadir/test
97 --replace_regex $regexp
98 --list_files $MYSQLD_DATADIR/test
99
100 SET DEBUG = '+d,ib_fts_index_table_error';
101 --error 1030
102 ALTER TABLE t1 DROP INDEX fts_idx, ADD FULLTEXT INDEX fts_idx(a);
103 SET DEBUG = '-d,ib_fts_index_table_error';
104
105 --source suite/innodb/include/show_i_s_tables.inc
106 --echo # list files in datadir/test
107 --replace_regex $regexp
108 --list_files $MYSQLD_DATADIR/test
109
110 DROP TABLE t1;