Debian Codegraph @

mysql-test/suite/x/r/admin_create_index_fulltext.result

raw
1 CREATE SCHEMA xtest DEFAULT CHARSET 'utf8mb4';
2
3 Create collection fulltext1
4 ===========================
5
6 command ok
7
8 check required status var updated
9 =================================
10 Variable_name Value
11 Mysqlx_stmt_create_collection_index 0
12 0 rows affected
13 Variable_name Value
14 Mysqlx_stmt_drop_collection_index 0
15 0 rows affected
16 Variable_name Value
17 Mysqlx_stmt_execute_mysqlx 1
18 0 rows affected
19
20 Create entire document fulltext index and drop it
21 =================================================
22
23 command ok
24 ### Columns of fulltext1
25 Field Type Null Key Default Extra
26 doc json YES null
27 _id varbinary(32) NO PRI null STORED GENERATED
28 _json_schema json YES null VIRTUAL GENERATED
29 $ix_ft_r_366242F9B1A1445156C6129A699299650D68D08A text NO MUL null STORED GENERATED
30 0 rows affected
31 ### Indexes of fulltext1
32 Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment Index_comment Visible Expression
33 fulltext1 0 PRIMARY 1 _id A 0 null null BTREE YES null
34 fulltext1 1 one 1 $ix_ft_r_366242F9B1A1445156C6129A699299650D68D08A null 0 null null FULLTEXT YES null
35 0 rows affected
36 ############################
37
38 command ok
39 ### Columns of fulltext1
40 Field Type Null Key Default Extra
41 doc json YES null
42 _id varbinary(32) NO PRI null STORED GENERATED
43 _json_schema json YES null VIRTUAL GENERATED
44 0 rows affected
45 ### Indexes of fulltext1
46 Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment Index_comment Visible Expression
47 fulltext1 0 PRIMARY 1 _id A 0 null null BTREE YES null
48 0 rows affected
49 ############################
50 Variable_name Value
51 Mysqlx_stmt_create_collection_index 1
52 0 rows affected
53 Variable_name Value
54 Mysqlx_stmt_drop_collection_index 1
55 0 rows affected
56 Variable_name Value
57 Mysqlx_stmt_execute_mysqlx 3
58 0 rows affected
59
60 Create fulltext index (without constraint.type) and drop it
61 ===========================================================
62
63 command ok
64 ### Columns of fulltext1
65 Field Type Null Key Default Extra
66 doc json YES null
67 _id varbinary(32) NO PRI null STORED GENERATED
68 _json_schema json YES null VIRTUAL GENERATED
69 $ix_ft_r_9BDE81F857CBD7E27CAED548ED36F57CE4307F0B text NO MUL null STORED GENERATED
70 0 rows affected
71 ### Indexes of fulltext1
72 Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment Index_comment Visible Expression
73 fulltext1 0 PRIMARY 1 _id A 0 null null BTREE YES null
74 fulltext1 1 one 1 $ix_ft_r_9BDE81F857CBD7E27CAED548ED36F57CE4307F0B null 0 null null FULLTEXT YES null
75 0 rows affected
76 ############################
77
78 command ok
79 ### Columns of fulltext1
80 Field Type Null Key Default Extra
81 doc json YES null
82 _id varbinary(32) NO PRI null STORED GENERATED
83 _json_schema json YES null VIRTUAL GENERATED
84 0 rows affected
85 ### Indexes of fulltext1
86 Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment Index_comment Visible Expression
87 fulltext1 0 PRIMARY 1 _id A 0 null null BTREE YES null
88 0 rows affected
89 ############################
90
91 Create two fulltext indexes on the same member and drop one
92 ===========================================================
93
94 command ok
95
96 command ok
97 ### Columns of fulltext1
98 Field Type Null Key Default Extra
99 doc json YES null
100 _id varbinary(32) NO PRI null STORED GENERATED
101 _json_schema json YES null VIRTUAL GENERATED
102 $ix_ft_r_9BDE81F857CBD7E27CAED548ED36F57CE4307F0B text NO MUL null STORED GENERATED
103 0 rows affected
104 ### Indexes of fulltext1
105 Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment Index_comment Visible Expression
106 fulltext1 0 PRIMARY 1 _id A 0 null null BTREE YES null
107 fulltext1 1 one 1 $ix_ft_r_9BDE81F857CBD7E27CAED548ED36F57CE4307F0B null 0 null null FULLTEXT YES null
108 fulltext1 1 two 1 $ix_ft_r_9BDE81F857CBD7E27CAED548ED36F57CE4307F0B null 0 null null FULLTEXT YES null
109 0 rows affected
110 ############################
111
112 Drop fulltext index on $.first
113 ==============================
114
115 command ok
116 ### Columns of fulltext1
117 Field Type Null Key Default Extra
118 doc json YES null
119 _id varbinary(32) NO PRI null STORED GENERATED
120 _json_schema json YES null VIRTUAL GENERATED
121 $ix_ft_r_9BDE81F857CBD7E27CAED548ED36F57CE4307F0B text NO MUL null STORED GENERATED
122 0 rows affected
123 ### Indexes of fulltext1
124 Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment Index_comment Visible Expression
125 fulltext1 0 PRIMARY 1 _id A 0 null null BTREE YES null
126 fulltext1 1 two 1 $ix_ft_r_9BDE81F857CBD7E27CAED548ED36F57CE4307F0B null 0 null null FULLTEXT YES null
127 0 rows affected
128 ############################
129
130 Create fulltext index on two memebers
131 =====================================
132
133 command ok
134 ### Columns of fulltext1
135 Field Type Null Key Default Extra
136 doc json YES null
137 _id varbinary(32) NO PRI null STORED GENERATED
138 _json_schema json YES null VIRTUAL GENERATED
139 $ix_ft_r_9BDE81F857CBD7E27CAED548ED36F57CE4307F0B text NO MUL null STORED GENERATED
140 $ix_ft_r_350BEBA0BA8F7BA4E147A3E652BE04A3B53B4479 text NO null STORED GENERATED
141 0 rows affected
142 ### Indexes of fulltext1
143 Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment Index_comment Visible Expression
144 fulltext1 0 PRIMARY 1 _id A 0 null null BTREE YES null
145 fulltext1 1 two 1 $ix_ft_r_9BDE81F857CBD7E27CAED548ED36F57CE4307F0B null 0 null null FULLTEXT YES null
146 fulltext1 1 three 1 $ix_ft_r_9BDE81F857CBD7E27CAED548ED36F57CE4307F0B null 0 null null FULLTEXT YES null
147 fulltext1 1 three 2 $ix_ft_r_350BEBA0BA8F7BA4E147A3E652BE04A3B53B4479 null 0 null null FULLTEXT YES null
148 0 rows affected
149 ############################
150
151 Create fulltext index on not requiered member
152 =============================================
153
154 command ok
155 ### Columns of fulltext1
156 Field Type Null Key Default Extra
157 doc json YES null
158 _id varbinary(32) NO PRI null STORED GENERATED
159 _json_schema json YES null VIRTUAL GENERATED
160 $ix_ft_r_9BDE81F857CBD7E27CAED548ED36F57CE4307F0B text NO MUL null STORED GENERATED
161 $ix_ft_r_350BEBA0BA8F7BA4E147A3E652BE04A3B53B4479 text NO null STORED GENERATED
162 $ix_ft_350BEBA0BA8F7BA4E147A3E652BE04A3B53B4479 text YES MUL null STORED GENERATED
163 0 rows affected
164 ### Indexes of fulltext1
165 Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment Index_comment Visible Expression
166 fulltext1 0 PRIMARY 1 _id A 0 null null BTREE YES null
167 fulltext1 1 two 1 $ix_ft_r_9BDE81F857CBD7E27CAED548ED36F57CE4307F0B null 0 null null FULLTEXT YES null
168 fulltext1 1 three 1 $ix_ft_r_9BDE81F857CBD7E27CAED548ED36F57CE4307F0B null 0 null null FULLTEXT YES null
169 fulltext1 1 three 2 $ix_ft_r_350BEBA0BA8F7BA4E147A3E652BE04A3B53B4479 null 0 null null FULLTEXT YES null
170 fulltext1 1 four 1 $ix_ft_350BEBA0BA8F7BA4E147A3E652BE04A3B53B4479 null 0 null null YES FULLTEXT YES null
171 0 rows affected
172 ############################
173
174 Create fulltext index with parser
175 =================================
176
177 command ok
178 ### Columns of fulltext1
179 Field Type Null Key Default Extra
180 doc json YES null
181 _id varbinary(32) NO PRI null STORED GENERATED
182 _json_schema json YES null VIRTUAL GENERATED
183 $ix_ft_r_9BDE81F857CBD7E27CAED548ED36F57CE4307F0B text NO MUL null STORED GENERATED
184 $ix_ft_r_350BEBA0BA8F7BA4E147A3E652BE04A3B53B4479 text NO null STORED GENERATED
185 $ix_ft_350BEBA0BA8F7BA4E147A3E652BE04A3B53B4479 text YES MUL null STORED GENERATED
186 $ix_ft_B5750A6F79D3B1F39FA4EF6A3C52CB94B2050EE8 text YES MUL null STORED GENERATED
187 0 rows affected
188 ### Indexes of fulltext1
189 Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment Index_comment Visible Expression
190 fulltext1 0 PRIMARY 1 _id A 0 null null BTREE YES null
191 fulltext1 1 two 1 $ix_ft_r_9BDE81F857CBD7E27CAED548ED36F57CE4307F0B null 0 null null FULLTEXT YES null
192 fulltext1 1 three 1 $ix_ft_r_9BDE81F857CBD7E27CAED548ED36F57CE4307F0B null 0 null null FULLTEXT YES null
193 fulltext1 1 three 2 $ix_ft_r_350BEBA0BA8F7BA4E147A3E652BE04A3B53B4479 null 0 null null FULLTEXT YES null
194 fulltext1 1 four 1 $ix_ft_350BEBA0BA8F7BA4E147A3E652BE04A3B53B4479 null 0 null null YES FULLTEXT YES null
195 fulltext1 1 five 1 $ix_ft_B5750A6F79D3B1F39FA4EF6A3C52CB94B2050EE8 null 0 null null YES FULLTEXT YES null
196 0 rows affected
197 ############################
198
199 Is collection with fulltext index still collection?
200 ===================================================
201 name type
202 fulltext1 COLLECTION
203 command ok
204
205 Drop collection fulltext1
206 =========================
207
208 command ok
209
210 Create collection fulltext1
211 ============================
212
213 command ok
214
215 Create fulltext index with FULLTEXT instead of fulltext
216 ========================================================
217
218 command ok
219
220 Verify "NOT NULL" for generated column
221 ======================================
222 ### Columns of fulltext1
223 Field Type Null Key Default Extra
224 doc json YES null
225 _id varbinary(32) NO PRI null STORED GENERATED
226 _json_schema json YES null VIRTUAL GENERATED
227 $ix_ft_r_350BEBA0BA8F7BA4E147A3E652BE04A3B53B4479 text NO MUL null STORED GENERATED
228 0 rows affected
229 ### Indexes of fulltext1
230 Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment Index_comment Visible Expression
231 fulltext1 0 PRIMARY 1 _id A 0 null null BTREE YES null
232 fulltext1 1 four 1 $ix_ft_r_350BEBA0BA8F7BA4E147A3E652BE04A3B53B4479 null 0 null null FULLTEXT YES null
233 0 rows affected
234 ############################
235
236 Check generated column can be dropped
237 =====================================
238
239 0 rows affected
240 Records: 0 Duplicates: 0 Warnings: 0
241
242 Create fulltext index with FULLTEXT nested doc
243 ==============================================
244
245 command ok
246
247 command ok
248
249 Drop collection fulltext1
250 =========================
251
252 command ok
253
254 Create collection fulltext2
255 ===========================
256
257 command ok
258
259 Try to create unique fulltext index
260 ===================================
261 Got expected error: Unique fulltext index is not supported (code 5017)
262
263 Insert not-text values to collection with fulltext index
264 ========================================================
265
266 command ok
267
268 1 rows affected
269 Got expected error (code 0)
270
271 1 rows affected
272 Got expected error (code 0)
273
274 1 rows affected
275 Got expected error (code 0)
276
277 1 rows affected
278 Got expected error (code 0)
279
280 Try to create fulltext index on missing member
281 ==============================================
282 Got expected error: Collection contains document missing required field (code 5117)
283
284 Try to create fulltext index with unknown parser
285 ================================================
286 Got expected error: Function 'blablabla' is not defined (code 1128)
287
288 Try to create 'regular' index with parser
289 =========================================
290 Got expected error: 'with_parser' argument is supported for fulltext index only (code 5017)
291 Mysqlx.Ok {
292 msg: "bye!"
293 }
294 ok