Debian Codegraph @

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

raw
1 CREATE TABLE t1 (
2 id INT AUTO_INCREMENT NOT NULL PRIMARY KEY,
3 value VARCHAR(1024)
4 ) ENGINE=InnoDB;
5 CREATE FULLTEXT INDEX idx1 ON t1(value);
6 SET @save_debug = @@GLOBAL.debug_dbug;
7 SET GLOBAL debug_dbug = '+d,fts_instrument_sync_request,fts_instrument_sync_before_syncing,ib_trunc_sleep_before_fts_cache_clear';
8 INSERT INTO t1 (value) VALUES
9 ('By default or with the IN NATURAL LANGUAGE MODE modifier')
10 ;
11 TRUNCATE TABLE t1;
12 DROP TABLE t1;
13 SET GLOBAL debug_dbug = @save_debug;
14 CREATE TABLE t1 (
15 id INT AUTO_INCREMENT NOT NULL PRIMARY KEY,
16 value VARCHAR(1024)
17 ) ENGINE=InnoDB;
18 CREATE FULLTEXT INDEX idx1 ON t1(value);
19 SET GLOBAL debug_dbug = '+d,fts_instrument_sync_request,fts_instrument_write_words_before_select_index,ib_trunc_sleep_before_fts_cache_clear';
20 INSERT 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 ;
31 TRUNCATE TABLE t1;
32 DROP TABLE t1;
33 SET GLOBAL debug_dbug = @save_debug;
34 CREATE TABLE t1 (
35 value VARCHAR(1024)
36 ) ENGINE=InnoDB;
37 CREATE FULLTEXT INDEX idx1 ON t1(value);
38 SET GLOBAL debug_dbug = '+d,fts_instrument_sync_request,fts_instrument_msg_sync_sleep';
39 INSERT 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 ;
50 DROP INDEX idx1 ON t1;
51 DROP TABLE t1;
52 SET GLOBAL debug_dbug = @save_debug;
53 CREATE TABLE t1 (
54 value VARCHAR(1024)
55 ) ENGINE=InnoDB;
56 CREATE FULLTEXT INDEX idx1 ON t1(value);
57 SET GLOBAL debug_dbug = '+d,fts_instrument_sync_request,fts_instrument_msg_sync_sleep';
58 INSERT 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 ;
69 ALTER TABLE t1
70 DROP INDEX idx1,
71 ALGORITHM=INPLACE;
72 DROP TABLE t1;
73 SET GLOBAL debug_dbug = @save_debug;
74 CREATE TABLE t1 (
75 value VARCHAR(1024)
76 ) ENGINE=InnoDB;
77 CREATE FULLTEXT INDEX idx1 ON t1(value);
78 SET GLOBAL debug_dbug = '+d,fts_instrument_sync_request,fts_instrument_msg_sync_sleep';
79 INSERT INTO t1 (value) VALUES
80 ('example, a column that uses the latin1 character'),
81 ('collation of latin1_bin to make it case sensitive')
82 ;
83 ALTER TABLE t1
84 DROP INDEX idx1,
85 ALGORITHM=COPY;
86 DROP TABLE t1;
87 SET GLOBAL debug_dbug = @save_debug;
88 CREATE TABLE t1 (
89 id1 INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
90 value VARCHAR(1024)
91 ) ENGINE=InnoDB;
92 CREATE FULLTEXT INDEX idx1 ON t1(value);
93 SET GLOBAL debug_dbug = '+d,fts_instrument_sync_request,fts_instrument_msg_sync_sleep';
94 INSERT INTO t1 (value) VALUES
95 ('example, a column that uses the latin1 character'),
96 ('collation of latin1_bin to make it case sensitive')
97 ;
98 ALTER TABLE t1
99 DROP COLUMN id1,
100 ADD COLUMN id2 INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
101 DROP INDEX idx1,
102 ADD FULLTEXT INDEX idx2(value);
103 affected rows: 0
104 info: Records: 0 Duplicates: 0 Warnings: 0
105 DROP TABLE t1;
106 SET GLOBAL debug_dbug = @save_debug;