Debian Codegraph @

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

raw
1 CREATE TABLE t1 (v VARCHAR(100), FULLTEXT INDEX (v)) ENGINE=InnoDB;
2 insert into t1 VALUES('First record'),('Second record'),('Third record');
3 SET @save_ft_aux_table = @@GLOBAL.innodb_ft_aux_table;
4 connect con1,localhost,root,,;
5 SET GLOBAL innodb_ft_aux_table = 'test/t0';
6 ERROR 42000: Variable 'innodb_ft_aux_table' can't be set to the value of 'test/t0'
7 connection default;
8 SELECT * FROM INFORMATION_SCHEMA.INNODB_FT_DEFAULT_STOPWORD;
9 value
10 a
11 about
12 an
13 are
14 as
15 at
16 be
17 by
18 com
19 de
20 en
21 for
22 from
23 how
24 i
25 in
26 is
27 it
28 la
29 of
30 on
31 or
32 that
33 the
34 this
35 to
36 was
37 what
38 when
39 where
40 who
41 will
42 with
43 und
44 the
45 www
46 SELECT * FROM INFORMATION_SCHEMA.INNODB_FT_DELETED;
47 DOC_ID
48 SELECT * FROM INFORMATION_SCHEMA.INNODB_FT_BEING_DELETED;
49 DOC_ID
50 SELECT * FROM INFORMATION_SCHEMA.INNODB_FT_INDEX_CACHE;
51 WORD FIRST_DOC_ID LAST_DOC_ID DOC_COUNT DOC_ID POSITION
52 SELECT * FROM INFORMATION_SCHEMA.INNODB_FT_INDEX_TABLE;
53 WORD FIRST_DOC_ID LAST_DOC_ID DOC_COUNT DOC_ID POSITION
54 SELECT * FROM INFORMATION_SCHEMA.INNODB_FT_CONFIG;
55 KEY VALUE
56 connection con1;
57 SET GLOBAL innodb_ft_aux_table = 'test/t1';
58 disconnect con1;
59 connection default;
60 SELECT * FROM INFORMATION_SCHEMA.INNODB_FT_DELETED;
61 DOC_ID
62 SELECT * FROM INFORMATION_SCHEMA.INNODB_FT_BEING_DELETED;
63 DOC_ID
64 SELECT * FROM INFORMATION_SCHEMA.INNODB_FT_INDEX_CACHE;
65 WORD FIRST_DOC_ID LAST_DOC_ID DOC_COUNT DOC_ID POSITION
66 first 1 1 1 1 0
67 record 1 3 3 1 6
68 record 1 3 3 2 7
69 record 1 3 3 3 6
70 second 2 2 1 2 0
71 third 3 3 1 3 0
72 SELECT * FROM INFORMATION_SCHEMA.INNODB_FT_INDEX_TABLE;
73 WORD FIRST_DOC_ID LAST_DOC_ID DOC_COUNT DOC_ID POSITION
74 SELECT * FROM INFORMATION_SCHEMA.INNODB_FT_CONFIG;
75 KEY VALUE
76 optimize_checkpoint_limit 180
77 synced_doc_id 0
78 stopword_table_name
79 use_stopword 1
80 SELECT @@GLOBAL.innodb_ft_aux_table;
81 @@GLOBAL.innodb_ft_aux_table
82 test/t1
83 RENAME TABLE t1 TO t2;
84 SELECT * FROM INFORMATION_SCHEMA.INNODB_FT_DELETED;
85 DOC_ID
86 SELECT * FROM INFORMATION_SCHEMA.INNODB_FT_BEING_DELETED;
87 DOC_ID
88 SELECT * FROM INFORMATION_SCHEMA.INNODB_FT_INDEX_CACHE;
89 WORD FIRST_DOC_ID LAST_DOC_ID DOC_COUNT DOC_ID POSITION
90 first 1 1 1 1 0
91 record 1 3 3 1 6
92 record 1 3 3 2 7
93 record 1 3 3 3 6
94 second 2 2 1 2 0
95 third 3 3 1 3 0
96 SELECT * FROM INFORMATION_SCHEMA.INNODB_FT_INDEX_TABLE;
97 WORD FIRST_DOC_ID LAST_DOC_ID DOC_COUNT DOC_ID POSITION
98 SELECT * FROM INFORMATION_SCHEMA.INNODB_FT_CONFIG;
99 KEY VALUE
100 optimize_checkpoint_limit 180
101 synced_doc_id 0
102 stopword_table_name
103 use_stopword 1
104 SELECT @@GLOBAL.innodb_ft_aux_table;
105 @@GLOBAL.innodb_ft_aux_table
106 test/t1
107 DROP TABLE t2;
108 SELECT * FROM INFORMATION_SCHEMA.INNODB_FT_DELETED;
109 DOC_ID
110 SELECT * FROM INFORMATION_SCHEMA.INNODB_FT_BEING_DELETED;
111 DOC_ID
112 SELECT * FROM INFORMATION_SCHEMA.INNODB_FT_INDEX_CACHE;
113 WORD FIRST_DOC_ID LAST_DOC_ID DOC_COUNT DOC_ID POSITION
114 SELECT * FROM INFORMATION_SCHEMA.INNODB_FT_INDEX_TABLE;
115 WORD FIRST_DOC_ID LAST_DOC_ID DOC_COUNT DOC_ID POSITION
116 SELECT * FROM INFORMATION_SCHEMA.INNODB_FT_CONFIG;
117 KEY VALUE
118 SELECT @@GLOBAL.innodb_ft_aux_table;
119 @@GLOBAL.innodb_ft_aux_table
120 test/t1
121 CREATE TABLE t(a INT) ENGINE=InnoDB;
122 SET GLOBAL innodb_ft_aux_table='test/t';
123 ERROR 42000: Variable 'innodb_ft_aux_table' can't be set to the value of 'test/t'
124 DROP TABLE t;
125 SET GLOBAL innodb_ft_aux_table='test/t';
126 ERROR 42000: Variable 'innodb_ft_aux_table' can't be set to the value of 'test/t'
127 SELECT @@GLOBAL.innodb_ft_aux_table;
128 @@GLOBAL.innodb_ft_aux_table
129 test/t1
130 SET GLOBAL innodb_ft_aux_table = @save_ft_aux_table;