Debian Codegraph @

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

raw
1
2 ## 1.a. Verify that basic usage of `mysqlx_generate_document_id`
3 ## works correctly using classic protocol.
4 ## 1.b. Usage of `mysqlx_generate_document_id` with
5 ## invalid arguments using classic protocol.
6 ## 2.a. Handling of NULL values in DO (classic)
7 ## 2.b. Handling of NULL values in SELECT (classic)
8 ## 2.c. Handling of FUNCTION returning NULL values in DO (classic)
9 ## 2.d. Handling of FUNCTION returning NULL values in SELECT (classic)
10 ## 3.a. Verify that basic usage of `mysqlx_generate_document_id`
11 ## works correctly using x protocol.
12 ## 3.b. Usage of `mysqlx_generate_document_id` with
13 ## invalid arguments using X protocol.
14 ## 4.a. Handling of NULL values in DO (x)
15 ## 4.b. Handling of NULL values in SELECT (x)
16 ## 4.c. Handling of FUNCTION returning NULL values in DO (x)
17 ## 4.d. Handling of FUNCTION returning NULL values in SELECT (x)
18 CREATE SCHEMA xtest;
19 USE xtest;
20 CREATE TABLE util(f INT);
21 INSERT INTO util(f) VALUES(1),(2),(3),(4),(5);
22
23 #
24 ## Ad 1.a. Verify that basic usage of `mysqlx_generate_document_id`
25 ## works correctly using classic protocol.
26 SELECT mysqlx_generate_document_id() FROM util;
27 mysqlx_generate_document_id()
28 0000XXXXXXXX0000000000000001
29 0000XXXXXXXX0000000000000002
30 0000XXXXXXXX0000000000000003
31 0000XXXXXXXX0000000000000004
32 0000XXXXXXXX0000000000000005
33 SELECT mysqlx_generate_document_id(16) FROM util;
34 mysqlx_generate_document_id(16)
35 0000XXXXXXXX0000000000000006
36 0000XXXXXXXX0000000000000007
37 0000XXXXXXXX0000000000000008
38 0000XXXXXXXX0000000000000009
39 0000XXXXXXXX000000000000000a
40 SELECT mysqlx_generate_document_id(16, 8) FROM util;
41 mysqlx_generate_document_id(16, 8)
42 0000XXXXXXXX0000000000000010
43 0000XXXXXXXX0000000000000018
44 0000XXXXXXXX0000000000000020
45 0000XXXXXXXX0000000000000028
46 0000XXXXXXXX0000000000000030
47 SELECT mysqlx_generate_document_id(16, 8, 0) FROM util;
48 mysqlx_generate_document_id(16, 8, 0)
49 0000XXXXXXXX0000000000000038
50 0000XXXXXXXX0000000000000040
51 0000XXXXXXXX0000000000000048
52 0000XXXXXXXX0000000000000050
53 0000XXXXXXXX0000000000000058
54 SELECT mysqlx_generate_document_id(16, 8, 1) FROM util;
55 mysqlx_generate_document_id(16, 8, 1)
56 NULL
57 NULL
58 NULL
59 NULL
60 NULL
61 set auto_increment_offset = 16;
62 set auto_increment_increment = 8;
63 SELECT mysqlx_generate_document_id(@@auto_increment_offset, @@auto_increment_increment) FROM util;
64 mysqlx_generate_document_id(@@auto_increment_offset, @@auto_increment_increment)
65 0000XXXXXXXX0000000000000060
66 0000XXXXXXXX0000000000000068
67 0000XXXXXXXX0000000000000070
68 0000XXXXXXXX0000000000000078
69 0000XXXXXXXX0000000000000080
70 CREATE PROCEDURE my_procedure(IN offset INT, IN increment INT)
71 BEGIN
72 SELECT mysqlx_generate_document_id(offset, increment) AS document_id;
73 END ||
74 CALL my_procedure(16, 8);
75 document_id
76 0000XXXXXXXX0000000000000088
77
78 #
79 ## Ad 1.b. Usage of `mysqlx_generate_document_id` with
80 ## invalid arguments using classic protocol.
81 DO mysqlx_generate_document_id();
82 CALL mysqlx_generate_document_id();
83 ERROR 42000: PROCEDURE xtest.mysqlx_generate_document_id does not exist
84 DO mysqlx_generate_document_id('abc');
85 ERROR HY000: Can't initialize function 'mysqlx_generate_document_id'; Function expects integer argument
86 DO mysqlx_generate_document_id(NULL);
87 ERROR HY000: Can't initialize function 'mysqlx_generate_document_id'; Function expects integer argument
88 DO mysqlx_generate_document_id(123.45);
89 ERROR HY000: Can't initialize function 'mysqlx_generate_document_id'; Function expects integer argument
90 DO mysqlx_generate_document_id(1, 'abc');
91 ERROR HY000: Can't initialize function 'mysqlx_generate_document_id'; Function expects two integer arguments
92 DO mysqlx_generate_document_id(1, NULL);
93 ERROR HY000: Can't initialize function 'mysqlx_generate_document_id'; Function expects two integer arguments
94 DO mysqlx_generate_document_id(1, 123.45);
95 ERROR HY000: Can't initialize function 'mysqlx_generate_document_id'; Function expects two integer arguments
96 DO mysqlx_generate_document_id(1, 1, 'abc');
97 ERROR HY000: Can't initialize function 'mysqlx_generate_document_id'; Function expects three integer arguments
98 DO mysqlx_generate_document_id(1, 1, NULL);
99 ERROR HY000: Can't initialize function 'mysqlx_generate_document_id'; Function expects three integer arguments
100 DO mysqlx_generate_document_id(1, 1, 123.45);
101 ERROR HY000: Can't initialize function 'mysqlx_generate_document_id'; Function expects three integer arguments
102 DO mysqlx_generate_document_id(1, 1, 1, 1);
103 ERROR HY000: Can't initialize function 'mysqlx_generate_document_id'; Function expects up to three integer arguments
104 DO mysqlx_generate_document_id(1, 1, 1, 1, 1);
105 ERROR HY000: Can't initialize function 'mysqlx_generate_document_id'; Function expects up to three integer arguments
106
107 #
108 ## Ad 2.a. Handling of NULL values in DO
109 DO mysqlx_generate_document_id(NULL, 1, 1);
110 ERROR HY000: Can't initialize function 'mysqlx_generate_document_id'; Function expects three integer arguments
111 DO mysqlx_generate_document_id(1, NULL, 1);
112 ERROR HY000: Can't initialize function 'mysqlx_generate_document_id'; Function expects three integer arguments
113 DO mysqlx_generate_document_id(1, 1, NULL);
114 ERROR HY000: Can't initialize function 'mysqlx_generate_document_id'; Function expects three integer arguments
115
116 #
117 ## Ad 2.b. Handling of NULL values in SELECT
118 SELECT mysqlx_generate_document_id(NULL,1,1);
119 ERROR HY000: Can't initialize function 'mysqlx_generate_document_id'; Function expects three integer arguments
120 SELECT mysqlx_generate_document_id(1,NULL,1);
121 ERROR HY000: Can't initialize function 'mysqlx_generate_document_id'; Function expects three integer arguments
122 SELECT mysqlx_generate_document_id(1,1,NULL);
123 ERROR HY000: Can't initialize function 'mysqlx_generate_document_id'; Function expects three integer arguments
124
125 #
126 ## Ad 2.c. Handling of FUNCTION returning NULL values in DO
127 DO mysqlx_generate_document_id(IF(1=2,1,NULL), 1, 0);
128 DO mysqlx_generate_document_id(1, IF(1=2,1,NULL), 0);
129 DO mysqlx_generate_document_id(1, 1, IF(1=2,1,NULL));
130
131 #
132 ## Ad 2.d. Handling of FUNCTION returning NULL values in SELECT
133 SELECT mysqlx_generate_document_id(IF(1=2,1,NULL),1,0);
134 mysqlx_generate_document_id(IF(1=2,1,NULL),1,0)
135 0000XXXXXXXX000000000000008d
136 SELECT mysqlx_generate_document_id(1,IF(1=2,1,NULL),0);
137 mysqlx_generate_document_id(1,IF(1=2,1,NULL),0)
138 0000XXXXXXXX000000000000008e
139 SELECT mysqlx_generate_document_id(1,1,IF(1=2,1,NULL));
140 mysqlx_generate_document_id(1,1,IF(1=2,1,NULL))
141 0000XXXXXXXX000000000000008f
142
143 #
144 ## Ad 3.a. Verify that basic usage of `mysqlx_generate_document_id`
145 ## works correctly using x protocol.
146 RUN SELECT mysqlx_generate_document_id() FROM xtest.util
147 mysqlx_generate_document_id()
148 0000XXXXXXXX0000000000000090
149 0000XXXXXXXX0000000000000091
150 0000XXXXXXXX0000000000000092
151 0000XXXXXXXX0000000000000093
152 0000XXXXXXXX0000000000000094
153 0 rows affected
154 RUN SELECT mysqlx_generate_document_id(16) FROM xtest.util
155 mysqlx_generate_document_id(16)
156 0000XXXXXXXX0000000000000095
157 0000XXXXXXXX0000000000000096
158 0000XXXXXXXX0000000000000097
159 0000XXXXXXXX0000000000000098
160 0000XXXXXXXX0000000000000099
161 0 rows affected
162 RUN SELECT mysqlx_generate_document_id(16, 8) FROM xtest.util
163 mysqlx_generate_document_id(16, 8)
164 0000XXXXXXXX00000000000000a0
165 0000XXXXXXXX00000000000000a8
166 0000XXXXXXXX00000000000000b0
167 0000XXXXXXXX00000000000000b8
168 0000XXXXXXXX00000000000000c0
169 0 rows affected
170 RUN SELECT mysqlx_generate_document_id(16, 8, 0) FROM xtest.util
171 mysqlx_generate_document_id(16, 8, 0)
172 0000XXXXXXXX00000000000000c8
173 0000XXXXXXXX00000000000000d0
174 0000XXXXXXXX00000000000000d8
175 0000XXXXXXXX00000000000000e0
176 0000XXXXXXXX00000000000000e8
177 0 rows affected
178 RUN SELECT mysqlx_generate_document_id(16, 8, 1) FROM xtest.util
179 mysqlx_generate_document_id(16, 8, 1)
180 null
181 null
182 null
183 null
184 null
185 0 rows affected
186 RUN set auto_increment_offset = 16
187
188 0 rows affected
189 RUN set auto_increment_increment = 8
190
191 0 rows affected
192 RUN CALL xtest.my_procedure(16, 8)
193 document_id
194 0000XXXXXXXX00000000000000f0
195
196 0 rows affected
197 RUN SELECT mysqlx_generate_document_id(@@auto_increment_offset, @@auto_increment_increment) FROM xtest.util
198 mysqlx_generate_document_id(@@auto_increment_offset, @@auto_increment_increment)
199 0000XXXXXXXX00000000000000f8
200 0000XXXXXXXX0000000000000100
201 0000XXXXXXXX0000000000000108
202 0000XXXXXXXX0000000000000110
203 0000XXXXXXXX0000000000000118
204 0 rows affected
205 RUN DO mysqlx_generate_document_id()
206
207 0 rows affected
208
209 #
210 ## Ad 3.b. Usage of `mysqlx_generate_document_id` with
211 ## invalid arguments using X protocol.
212 RUN CALL mysqlx_generate_document_id();
213 Got expected error: No database selected (code 1046)
214 RUN use xtest
215
216 0 rows affected
217 RUN CALL mysqlx_generate_document_id();
218 Got expected error: PROCEDURE xtest.mysqlx_generate_document_id does not exist (code 1305)
219 RUN DO mysqlx_generate_document_id('abc');
220 Got expected error: Can't initialize function 'mysqlx_generate_document_id'; Function expects integer argument (code 1123)
221 RUN DO mysqlx_generate_document_id(NULL);
222 Got expected error: Can't initialize function 'mysqlx_generate_document_id'; Function expects integer argument (code 1123)
223 RUN DO mysqlx_generate_document_id(123.45);
224 Got expected error: Can't initialize function 'mysqlx_generate_document_id'; Function expects integer argument (code 1123)
225 RUN DO mysqlx_generate_document_id(1, 'abc');
226 Got expected error: Can't initialize function 'mysqlx_generate_document_id'; Function expects two integer arguments (code 1123)
227 RUN DO mysqlx_generate_document_id(1, NULL);
228 Got expected error: Can't initialize function 'mysqlx_generate_document_id'; Function expects two integer arguments (code 1123)
229 RUN DO mysqlx_generate_document_id(1, 123.45);
230 Got expected error: Can't initialize function 'mysqlx_generate_document_id'; Function expects two integer arguments (code 1123)
231 RUN DO mysqlx_generate_document_id(1, 1, 'abc');
232 Got expected error: Can't initialize function 'mysqlx_generate_document_id'; Function expects three integer arguments (code 1123)
233 RUN DO mysqlx_generate_document_id(1, 1, NULL);
234 Got expected error: Can't initialize function 'mysqlx_generate_document_id'; Function expects three integer arguments (code 1123)
235 RUN DO mysqlx_generate_document_id(1, 1, 123.45);
236 Got expected error: Can't initialize function 'mysqlx_generate_document_id'; Function expects three integer arguments (code 1123)
237 RUN DO mysqlx_generate_document_id(1, 1, 1, 1);
238 Got expected error: Can't initialize function 'mysqlx_generate_document_id'; Function expects up to three integer arguments (code 1123)
239 RUN DO mysqlx_generate_document_id(1, 1, 1, 1, 1);
240 Got expected error: Can't initialize function 'mysqlx_generate_document_id'; Function expects up to three integer arguments (code 1123)
241
242 #
243 ## Ad 4.a. Handling of NULL values in DO
244 RUN DO mysqlx_generate_document_id(NULL, 1, 1);
245 Got expected error: Can't initialize function 'mysqlx_generate_document_id'; Function expects three integer arguments (code 1123)
246 RUN DO mysqlx_generate_document_id(1, NULL, 1);
247 Got expected error: Can't initialize function 'mysqlx_generate_document_id'; Function expects three integer arguments (code 1123)
248 RUN DO mysqlx_generate_document_id(1, 1, NULL);
249 Got expected error: Can't initialize function 'mysqlx_generate_document_id'; Function expects three integer arguments (code 1123)
250
251 #
252 ## Ad 4.b. Handling of NULL values in SELECT
253 RUN SELECT mysqlx_generate_document_id(NULL,1,1);
254 Got expected error: Can't initialize function 'mysqlx_generate_document_id'; Function expects three integer arguments (code 1123)
255 RUN SELECT mysqlx_generate_document_id(1,NULL,1);
256 Got expected error: Can't initialize function 'mysqlx_generate_document_id'; Function expects three integer arguments (code 1123)
257 RUN SELECT mysqlx_generate_document_id(1,1,NULL);
258 Got expected error: Can't initialize function 'mysqlx_generate_document_id'; Function expects three integer arguments (code 1123)
259
260 #
261 ## Ad 4.c. Handling of FUNCTION returning NULL values in DO
262 RUN DO mysqlx_generate_document_id(IF(1=2,1,NULL), 1, 0);
263
264 0 rows affected
265 RUN DO mysqlx_generate_document_id(1, IF(1=2,1,NULL), 0);
266
267 0 rows affected
268 RUN DO mysqlx_generate_document_id(1, 1, IF(1=2,1,NULL));
269
270 0 rows affected
271
272 #
273 ## Ad 4.d. Handling of FUNCTION returning NULL values in SELECT
274 RUN SELECT mysqlx_generate_document_id(IF(1=2,1,NULL),1,0);
275 mysqlx_generate_document_id(IF(1=2,1,NULL),1,0)
276 0000XXXXXXXX000000000000011d
277 0 rows affected
278 RUN SELECT mysqlx_generate_document_id(1,IF(1=2,1,NULL),0);
279 mysqlx_generate_document_id(1,IF(1=2,1,NULL),0)
280 0000XXXXXXXX000000000000011e
281 0 rows affected
282 RUN SELECT mysqlx_generate_document_id(1,1,IF(1=2,1,NULL));
283 mysqlx_generate_document_id(1,1,IF(1=2,1,NULL))
284 0000XXXXXXXX000000000000011f
285 0 rows affected
286 Mysqlx.Ok {
287 msg: "bye!"
288 }
289 ok
290 SET @doc = '{"a":1}';
291 SELECT JSON_INSERT(@doc, '$.a', CONVERT(mysqlx_generate_document_id(1,1,JSON_CONTAINS_PATH(@doc, 'one', '$.a')) USING utf8mb4)) as doc;
292 doc
293 {"a": 1}
294 SELECT JSON_INSERT(@doc, '$.b', CONVERT(mysqlx_generate_document_id(1,1,JSON_CONTAINS_PATH(@doc, 'one', '$.b')) USING utf8mb4)) as doc;
295 doc
296 {"a": 1, "b": "0000XXXXXXXX0000000000000120"}
297 set auto_increment_increment = DEFAULT;
298 set auto_increment_offset = DEFAULT;