1CREATE TABLE t1 (
2id INT AUTO_INCREMENT NOT NULL PRIMARY KEY,
3value VARCHAR(1024)
4) ENGINE=InnoDB;
5CREATE FULLTEXT INDEX idx1 ON t1(value);
6SET @save_debug = @@GLOBAL.debug_dbug;
7SET GLOBAL debug_dbug = '+d,fts_instrument_sync_request,fts_instrument_sync_before_syncing,ib_trunc_sleep_before_fts_cache_clear';
8INSERT INTO t1 (value) VALUES
9('By default or with the IN NATURAL LANGUAGE MODE modifier')
10;
11TRUNCATE TABLE t1;
12DROP TABLE t1;
13SET GLOBAL debug_dbug = @save_debug;
14CREATE TABLE t1 (
15id INT AUTO_INCREMENT NOT NULL PRIMARY KEY,
16value VARCHAR(1024)
17) ENGINE=InnoDB;
18CREATE FULLTEXT INDEX idx1 ON t1(value);
19SET GLOBAL debug_dbug = '+d,fts_instrument_sync_request,fts_instrument_write_words_before_select_index,ib_trunc_sleep_before_fts_cache_clear';
20INSERT INTO t1 (value) VALUES
21('By default or with the IN NATURAL LANGUAGE MODE modifier'),
22('performs a natural language search for a string'),
23('collection is a set of one or more columns included'),
24('returns a relevance value; that is, a similarity measure'),
25('and the text in that row in the columns named in'),
26('By default, the search is performed in case-insensitive'),
27('sensitive full-text search, use a binary collation '),
28('example, a column that uses the latin1 character'),
29('collation of latin1_bin to make it case sensitive')
30;
31TRUNCATE TABLE t1;
32DROP TABLE t1;
33SET GLOBAL debug_dbug = @save_debug;
34CREATE TABLE t1 (
35value VARCHAR(1024)
36) ENGINE=InnoDB;
37CREATE FULLTEXT INDEX idx1 ON t1(value);
38SET GLOBAL debug_dbug = '+d,fts_instrument_sync_request,fts_instrument_msg_sync_sleep';
39INSERT INTO t1 (value) VALUES
40('By default or with the IN NATURAL LANGUAGE MODE modifier'),
41('performs a natural language search for a string'),
42('collection is a set of one or more columns included'),
43('returns a relevance value; that is, a similarity measure'),
44('and the text in that row in the columns named in'),
45('By default, the search is performed in case-insensitive'),
46('sensitive full-text search, use a binary collation '),
47('example, a column that uses the latin1 character'),
48('collation of latin1_bin to make it case sensitive')
49;
50DROP INDEX idx1 ON t1;
51DROP TABLE t1;
52SET GLOBAL debug_dbug = @save_debug;
53CREATE TABLE t1 (
54value VARCHAR(1024)
55) ENGINE=InnoDB;
56CREATE FULLTEXT INDEX idx1 ON t1(value);
57SET GLOBAL debug_dbug = '+d,fts_instrument_sync_request,fts_instrument_msg_sync_sleep';
58INSERT INTO t1 (value) VALUES
59('By default or with the IN NATURAL LANGUAGE MODE modifier'),
60('performs a natural language search for a string'),
61('collection is a set of one or more columns included'),
62('returns a relevance value; that is, a similarity measure'),
63('and the text in that row in the columns named in'),
64('By default, the search is performed in case-insensitive'),
65('sensitive full-text search, use a binary collation '),
66('example, a column that uses the latin1 character'),
67('collation of latin1_bin to make it case sensitive')
68;
69ALTER TABLE t1
70DROP INDEX idx1,
71ALGORITHM=INPLACE;
72DROP TABLE t1;
73SET GLOBAL debug_dbug = @save_debug;
74CREATE TABLE t1 (
75value VARCHAR(1024)
76) ENGINE=InnoDB;
77CREATE FULLTEXT INDEX idx1 ON t1(value);
78SET GLOBAL debug_dbug = '+d,fts_instrument_sync_request,fts_instrument_msg_sync_sleep';
79INSERT INTO t1 (value) VALUES
80('example, a column that uses the latin1 character'),
81('collation of latin1_bin to make it case sensitive')
82;
83ALTER TABLE t1
84DROP INDEX idx1,
85ALGORITHM=COPY;
86DROP TABLE t1;
87SET GLOBAL debug_dbug = @save_debug;
88CREATE TABLE t1 (
89id1 INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
90value VARCHAR(1024)
91) ENGINE=InnoDB;
92CREATE FULLTEXT INDEX idx1 ON t1(value);
93SET GLOBAL debug_dbug = '+d,fts_instrument_sync_request,fts_instrument_msg_sync_sleep';
94INSERT INTO t1 (value) VALUES
95('example, a column that uses the latin1 character'),
96('collation of latin1_bin to make it case sensitive')
97;
98ALTER TABLE t1
99DROP COLUMN id1,
100ADD COLUMN id2 INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
101DROP INDEX idx1,
102ADD FULLTEXT INDEX idx2(value),
103ALGORITHM=INPLACE;
104DROP TABLE t1;
105SET GLOBAL debug_dbug = @save_debug;
106