Debian Codegraph @

mysql-test/suite/compat/oracle/r/sp-param.result

raw
1 ALTER DATABASE test CHARACTER SET latin1 COLLATE latin1_swedish_ci;
2 SET sql_mode=ORACLE;
3 #
4 # MDEV-10596 Allow VARCHAR and VARCHAR2 without length as a data type of routine parameters and in RETURN clause
5 #
6 CREATE FUNCTION f1(param CHAR) RETURN CHAR AS BEGIN RETURN param; END;;
7 SHOW CREATE FUNCTION f1;
8 Function sql_mode Create Function character_set_client collation_connection Database Collation
9 f1 PIPES_AS_CONCAT,ANSI_QUOTES,IGNORE_SPACE,ORACLE,NO_KEY_OPTIONS,NO_TABLE_OPTIONS,NO_FIELD_OPTIONS,NO_AUTO_CREATE_USER,SIMULTANEOUS_ASSIGNMENT CREATE DEFINER="root"@"localhost" FUNCTION "f1"(param CHAR) RETURN varchar(2000) CHARSET latin1 COLLATE latin1_swedish_ci
10 AS BEGIN RETURN param; END latin1 latin1_swedish_ci latin1_swedish_ci
11 SELECT LENGTH(f1(REPEAT('a',2000)));;
12 LENGTH(f1(REPEAT('a',2000)))
13 2000
14 CREATE TABLE t1 AS SELECT f1(REPEAT('a',2000)) AS a;;
15 SHOW CREATE TABLE t1;
16 Table Create Table
17 t1 CREATE TABLE "t1" (
18 "a" varchar(2000) DEFAULT NULL
19 )
20 DROP TABLE t1;
21 DROP FUNCTION f1;
22 CREATE FUNCTION f1(param NCHAR) RETURN NCHAR AS BEGIN RETURN param; END;;
23 SHOW CREATE FUNCTION f1;
24 Function sql_mode Create Function character_set_client collation_connection Database Collation
25 f1 PIPES_AS_CONCAT,ANSI_QUOTES,IGNORE_SPACE,ORACLE,NO_KEY_OPTIONS,NO_TABLE_OPTIONS,NO_FIELD_OPTIONS,NO_AUTO_CREATE_USER,SIMULTANEOUS_ASSIGNMENT CREATE DEFINER="root"@"localhost" FUNCTION "f1"(param NCHAR) RETURN varchar(2000) CHARSET utf8mb3 COLLATE utf8mb3_uca1400_ai_ci
26 AS BEGIN RETURN param; END latin1 latin1_swedish_ci latin1_swedish_ci
27 SELECT LENGTH(f1(REPEAT('a',2000)));;
28 LENGTH(f1(REPEAT('a',2000)))
29 2000
30 CREATE TABLE t1 AS SELECT f1(REPEAT('a',2000)) AS a;;
31 SHOW CREATE TABLE t1;
32 Table Create Table
33 t1 CREATE TABLE "t1" (
34 "a" varchar(2000) CHARACTER SET utf8mb3 COLLATE utf8mb3_uca1400_ai_ci DEFAULT NULL
35 )
36 DROP TABLE t1;
37 DROP FUNCTION f1;
38 CREATE FUNCTION f1(param BINARY) RETURN BINARY AS BEGIN RETURN param; END;;
39 SHOW CREATE FUNCTION f1;
40 Function sql_mode Create Function character_set_client collation_connection Database Collation
41 f1 PIPES_AS_CONCAT,ANSI_QUOTES,IGNORE_SPACE,ORACLE,NO_KEY_OPTIONS,NO_TABLE_OPTIONS,NO_FIELD_OPTIONS,NO_AUTO_CREATE_USER,SIMULTANEOUS_ASSIGNMENT CREATE DEFINER="root"@"localhost" FUNCTION "f1"(param BINARY) RETURN varbinary(2000)
42 AS BEGIN RETURN param; END latin1 latin1_swedish_ci latin1_swedish_ci
43 SELECT LENGTH(f1(REPEAT('a',2000)));;
44 LENGTH(f1(REPEAT('a',2000)))
45 2000
46 CREATE TABLE t1 AS SELECT f1(REPEAT('a',2000)) AS a;;
47 SHOW CREATE TABLE t1;
48 Table Create Table
49 t1 CREATE TABLE "t1" (
50 "a" varbinary(2000) DEFAULT NULL
51 )
52 DROP TABLE t1;
53 DROP FUNCTION f1;
54 CREATE FUNCTION f1(param VARCHAR) RETURN VARCHAR AS BEGIN RETURN param; END;;
55 SHOW CREATE FUNCTION f1;
56 Function sql_mode Create Function character_set_client collation_connection Database Collation
57 f1 PIPES_AS_CONCAT,ANSI_QUOTES,IGNORE_SPACE,ORACLE,NO_KEY_OPTIONS,NO_TABLE_OPTIONS,NO_FIELD_OPTIONS,NO_AUTO_CREATE_USER,SIMULTANEOUS_ASSIGNMENT CREATE DEFINER="root"@"localhost" FUNCTION "f1"(param VARCHAR) RETURN varchar(4000) CHARSET latin1 COLLATE latin1_swedish_ci
58 AS BEGIN RETURN param; END latin1 latin1_swedish_ci latin1_swedish_ci
59 SELECT LENGTH(f1(REPEAT('a',4000)));;
60 LENGTH(f1(REPEAT('a',4000)))
61 4000
62 CREATE TABLE t1 AS SELECT f1(REPEAT('a',4000)) AS a;;
63 SHOW CREATE TABLE t1;
64 Table Create Table
65 t1 CREATE TABLE "t1" (
66 "a" varchar(4000) DEFAULT NULL
67 )
68 DROP TABLE t1;
69 DROP FUNCTION f1;
70 CREATE FUNCTION f1(param VARCHAR2) RETURN VARCHAR2 AS BEGIN RETURN param; END;;
71 SHOW CREATE FUNCTION f1;
72 Function sql_mode Create Function character_set_client collation_connection Database Collation
73 f1 PIPES_AS_CONCAT,ANSI_QUOTES,IGNORE_SPACE,ORACLE,NO_KEY_OPTIONS,NO_TABLE_OPTIONS,NO_FIELD_OPTIONS,NO_AUTO_CREATE_USER,SIMULTANEOUS_ASSIGNMENT CREATE DEFINER="root"@"localhost" FUNCTION "f1"(param VARCHAR2) RETURN varchar(4000) CHARSET latin1 COLLATE latin1_swedish_ci
74 AS BEGIN RETURN param; END latin1 latin1_swedish_ci latin1_swedish_ci
75 SELECT LENGTH(f1(REPEAT('a',4000)));;
76 LENGTH(f1(REPEAT('a',4000)))
77 4000
78 CREATE TABLE t1 AS SELECT f1(REPEAT('a',4000)) AS a;;
79 SHOW CREATE TABLE t1;
80 Table Create Table
81 t1 CREATE TABLE "t1" (
82 "a" varchar(4000) DEFAULT NULL
83 )
84 DROP TABLE t1;
85 DROP FUNCTION f1;
86 CREATE FUNCTION f1(param NVARCHAR) RETURN NVARCHAR AS BEGIN RETURN param; END;;
87 SHOW CREATE FUNCTION f1;
88 Function sql_mode Create Function character_set_client collation_connection Database Collation
89 f1 PIPES_AS_CONCAT,ANSI_QUOTES,IGNORE_SPACE,ORACLE,NO_KEY_OPTIONS,NO_TABLE_OPTIONS,NO_FIELD_OPTIONS,NO_AUTO_CREATE_USER,SIMULTANEOUS_ASSIGNMENT CREATE DEFINER="root"@"localhost" FUNCTION "f1"(param NVARCHAR) RETURN varchar(4000) CHARSET utf8mb3 COLLATE utf8mb3_uca1400_ai_ci
90 AS BEGIN RETURN param; END latin1 latin1_swedish_ci latin1_swedish_ci
91 SELECT LENGTH(f1(REPEAT('a',4000)));;
92 LENGTH(f1(REPEAT('a',4000)))
93 4000
94 CREATE TABLE t1 AS SELECT f1(REPEAT('a',4000)) AS a;;
95 SHOW CREATE TABLE t1;
96 Table Create Table
97 t1 CREATE TABLE "t1" (
98 "a" varchar(4000) CHARACTER SET utf8mb3 COLLATE utf8mb3_uca1400_ai_ci DEFAULT NULL
99 )
100 DROP TABLE t1;
101 DROP FUNCTION f1;
102 CREATE FUNCTION f1(param VARBINARY) RETURN VARBINARY AS BEGIN RETURN param; END;;
103 SHOW CREATE FUNCTION f1;
104 Function sql_mode Create Function character_set_client collation_connection Database Collation
105 f1 PIPES_AS_CONCAT,ANSI_QUOTES,IGNORE_SPACE,ORACLE,NO_KEY_OPTIONS,NO_TABLE_OPTIONS,NO_FIELD_OPTIONS,NO_AUTO_CREATE_USER,SIMULTANEOUS_ASSIGNMENT CREATE DEFINER="root"@"localhost" FUNCTION "f1"(param VARBINARY) RETURN varbinary(4000)
106 AS BEGIN RETURN param; END latin1 latin1_swedish_ci latin1_swedish_ci
107 SELECT LENGTH(f1(REPEAT('a',4000)));;
108 LENGTH(f1(REPEAT('a',4000)))
109 4000
110 CREATE TABLE t1 AS SELECT f1(REPEAT('a',4000)) AS a;;
111 SHOW CREATE TABLE t1;
112 Table Create Table
113 t1 CREATE TABLE "t1" (
114 "a" varbinary(4000) DEFAULT NULL
115 )
116 DROP TABLE t1;
117 DROP FUNCTION f1;
118 CREATE FUNCTION f1(param RAW) RETURN RAW AS BEGIN RETURN param; END;;
119 SHOW CREATE FUNCTION f1;
120 Function sql_mode Create Function character_set_client collation_connection Database Collation
121 f1 PIPES_AS_CONCAT,ANSI_QUOTES,IGNORE_SPACE,ORACLE,NO_KEY_OPTIONS,NO_TABLE_OPTIONS,NO_FIELD_OPTIONS,NO_AUTO_CREATE_USER,SIMULTANEOUS_ASSIGNMENT CREATE DEFINER="root"@"localhost" FUNCTION "f1"(param RAW) RETURN varbinary(4000)
122 AS BEGIN RETURN param; END latin1 latin1_swedish_ci latin1_swedish_ci
123 SELECT LENGTH(f1(REPEAT('a',4000)));;
124 LENGTH(f1(REPEAT('a',4000)))
125 4000
126 CREATE TABLE t1 AS SELECT f1(REPEAT('a',4000)) AS a;;
127 SHOW CREATE TABLE t1;
128 Table Create Table
129 t1 CREATE TABLE "t1" (
130 "a" varbinary(4000) DEFAULT NULL
131 )
132 DROP TABLE t1;
133 DROP FUNCTION f1;
134
135 MDEV-13919 sql_mode=ORACLE: Derive length of VARCHAR SP parameters with no length from actual parameters
136
137 set sql_mode= 'oracle,strict_trans_tables';
138 CREATE OR REPLACE PROCEDURE p1(pinout INOUT varchar, pin IN varchar)
139 AS
140 BEGIN
141 pinout:=pin;
142 END;
143 /
144 call p1(@w,'0123456789')
145 /
146 declare w varchar(10);
147 begin
148 call p1(w,'0123456789');
149 end;
150 /
151 declare w varchar(5);
152 begin
153 call p1(w,'0123456789');
154 end;
155 /
156 ERROR 22001: Data too long for column 'pinout' at row 0
157 declare w varchar(20);
158 begin
159 w:='aaa';
160 call p1(w,'0123456789');
161 end;
162 /
163 declare w varchar(8);
164 begin
165 w:='aaa';
166 call p1(w,'0123456789');
167 end;
168 /
169 ERROR 22001: Data too long for column 'pinout' at row 0
170 declare str varchar(6000);
171 pout varchar(6000);
172 begin
173 str:=lpad('x',6000,'y');
174 call p1(pout,str);
175 select length(pout);
176 end;
177 /
178 length(pout)
179 6000
180 declare str varchar(6000);
181 pout varchar(4000);
182 begin
183 str:=lpad('x',6000,'y');
184 call p1(pout,str);
185 select length(pout);
186 end;
187 /
188 ERROR 22001: Data too long for column 'pinout' at row 0
189 declare str varchar(40000);
190 pout varchar(60000);
191 begin
192 str:=lpad('x',40000,'y');
193 call p1(pout,str);
194 select length(pout);
195 end;
196 /
197 length(pout)
198 40000
199 declare str text(80000);
200 pout text(80000);
201 begin
202 str:=lpad('x',80000,'y');
203 call p1(pout,str);
204 select length(pout);
205 end;
206 /
207 ERROR 22001: Data too long for column 'pin' at row 0
208 declare str text(80000);
209 pout text(80000);
210 begin
211 str:=lpad('x',60000,'y');
212 call p1(pout,str);
213 select length(pout);
214 end;
215 /
216 length(pout)
217 60000
218 drop procedure p1
219 /
220 SET sql_mode=ORACLE;
221 CREATE PROCEDURE p1(pinout INOUT varchar, pin IN varchar)
222 AS
223 BEGIN
224 pinout:=pin;
225 END;
226 /
227 CREATE PROCEDURE p2(len INT)
228 AS
229 pinout VARCHAR(10);
230 pin VARCHAR(30);
231 BEGIN
232 pin:= REPEAT('x', len);
233 p1(pinout, pin);
234 SELECT LENGTH(pinout);
235 END;
236 /
237 CALL p2(10);
238 LENGTH(pinout)
239 10
240 CALL p2(11);
241 LENGTH(pinout)
242 10
243 Warnings:
244 Warning 1265 Data truncated for column 'pinout' at row 0
245 DROP PROCEDURE p1;
246 DROP PROCEDURE p2;
247 SET sql_mode=ORACLE;
248 CREATE FUNCTION f1(pin VARCHAR, padlen INT) RETURN TEXT
249 AS
250 BEGIN
251 pin:=LPAD(pin, padlen);
252 RETURN pin;
253 END;
254 /
255 CREATE PROCEDURE p2(padlen INT) AS
256 str TEXT :='x';
257 BEGIN
258 SELECT LENGTH(f1(str,padlen));
259 END;
260 /
261 CALL p2(65535);
262 LENGTH(f1(str,padlen))
263 65532
264 Warnings:
265 Warning 1265 Data truncated for column 'pin' at row 0
266 CALL p2(65536);
267 LENGTH(f1(str,padlen))
268 65532
269 Warnings:
270 Warning 1265 Data truncated for column 'pin' at row 0
271 DROP PROCEDURE p2;
272 DROP FUNCTION f1;
273 SET sql_mode='ORACLE,STRICT_TRANS_TABLES';
274 CREATE PROCEDURE p1(pinout INOUT VARCHAR CHARACTER SET utf8,
275 pin IN VARCHAR CHARACTER SET utf8)
276 AS
277 BEGIN
278 pinout:=pin;
279 END;
280 /
281 CREATE PROCEDURE p2(padlen INT) AS
282 str VARCHAR(40000) CHARACTER SET latin1;
283 pout VARCHAR(60000) CHARACTER SET latin1;
284 BEGIN
285 str:=lpad('x',padlen,'y');
286 p1(pout,str);
287 SELECT length(pout);
288 END;
289 /
290 CALL p2(21844);
291 length(pout)
292 21844
293 CALL p2(21845);
294 ERROR 22001: Data too long for column 'pin' at row 0
295 CALL p2(21846);
296 ERROR 22001: Data too long for column 'pin' at row 0
297 DROP PROCEDURE p2;
298 DROP PROCEDURE p1;
299 SET sql_mode='ORACLE,STRICT_TRANS_TABLES';
300 CREATE PROCEDURE p1(pinout INOUT VARCHAR CHARACTER SET utf8,
301 pin IN VARCHAR CHARACTER SET utf8)
302 AS
303 BEGIN
304 pinout:=pin;
305 END;
306 /
307 CREATE PROCEDURE p2(padlen INT) AS
308 str TEXT CHARACTER SET utf8;
309 pout TEXT CHARACTER SET utf8;
310 BEGIN
311 str:=lpad('x',padlen,'y');
312 p1(pout,str);
313 SELECT length(pout);
314 END;
315 /
316 CALL p2(21844);
317 length(pout)
318 21844
319 CALL p2(21845);
320 ERROR 22001: Data too long for column 'pin' at row 0
321 CALL p2(21846);
322 ERROR 22001: Data too long for column 'pin' at row 0
323 DROP PROCEDURE p2;
324 DROP PROCEDURE p1;
325 SET sql_mode='ORACLE,STRICT_TRANS_TABLES';
326 CREATE FUNCTION f1(pin VARCHAR CHARACTER SET latin1, padlen INT) RETURN TEXT
327 AS
328 BEGIN
329 pin:=LPAD(pin, padlen);
330 RETURN pin;
331 END;
332 /
333 CREATE PROCEDURE p2(padlen INT) AS
334 str TEXT CHARACTER SET latin1 :='x';
335 BEGIN
336 SELECT LENGTH(f1(str,padlen));
337 END;
338 /
339 CALL p2(65532);
340 LENGTH(f1(str,padlen))
341 65532
342 CALL p2(65533);
343 ERROR 22001: Data too long for column 'pin' at row 0
344 CALL p2(65534);
345 ERROR 22001: Data too long for column 'pin' at row 0
346 CALL p2(65535);
347 ERROR 22001: Data too long for column 'pin' at row 0
348 CALL p2(65536);
349 ERROR 22001: Data too long for column 'pin' at row 0
350 DROP PROCEDURE p2;
351 DROP FUNCTION f1;
352 SET sql_mode='ORACLE,STRICT_TRANS_TABLES';
353 CREATE FUNCTION f1(pin VARCHAR CHARACTER SET utf8, padlen INT) RETURN TEXT
354 AS
355 BEGIN
356 pin:=LPAD(pin, padlen);
357 RETURN pin;
358 END;
359 /
360 CREATE PROCEDURE p2(padlen INT) AS
361 str TEXT CHARACTER SET utf8 := 'x';
362 BEGIN
363 SELECT LENGTH(f1(str,padlen));
364 END;
365 /
366 CALL p2(21844);
367 LENGTH(f1(str,padlen))
368 21844
369 CALL p2(21845);
370 ERROR 22001: Data too long for column 'pin' at row 0
371 CALL p2(21846);
372 ERROR 22001: Data too long for column 'pin' at row 0
373 DROP PROCEDURE p2;
374 DROP FUNCTION f1;
375 SET sql_mode='ORACLE,STRICT_TRANS_TABLES';
376 CREATE FUNCTION f1(pin VARCHAR CHARACTER SET utf8, padlen INT) RETURN TEXT
377 AS
378 BEGIN
379 pin:=LPAD(pin, padlen);
380 RETURN pin;
381 END;
382 /
383 CREATE PROCEDURE p2(padlen INT) AS
384 str TEXT CHARACTER SET latin1 := 'x';
385 BEGIN
386 SELECT LENGTH(f1(str,padlen));
387 END;
388 /
389 CALL p2(21844);
390 LENGTH(f1(str,padlen))
391 21844
392 CALL p2(21845);
393 ERROR 22001: Data too long for column 'pin' at row 0
394 CALL p2(21846);
395 ERROR 22001: Data too long for column 'pin' at row 0
396 DROP PROCEDURE p2;
397 DROP FUNCTION f1;
398 SET sql_mode='ORACLE,STRICT_TRANS_TABLES';
399 CREATE FUNCTION f1(pin VARCHAR CHARACTER SET latin1, padlen INT) RETURN TEXT
400 AS
401 BEGIN
402 pin:=LPAD(pin, padlen);
403 RETURN pin;
404 END;
405 /
406 CREATE PROCEDURE p2(padlen INT) AS
407 str TEXT CHARACTER SET utf8 := 'x';
408 BEGIN
409 SELECT LENGTH(f1(str,padlen));
410 END;
411 /
412 CALL p2(65532);
413 LENGTH(f1(str,padlen))
414 65532
415 CALL p2(65533);
416 ERROR 22001: Data too long for column 'pin' at row 0
417 CALL p2(65534);
418 ERROR 22001: Data too long for column 'pin' at row 0
419 CALL p2(65535);
420 ERROR 22001: Data too long for column 'pin' at row 0
421 CALL p2(65536);
422 ERROR 22001: Data too long for column 'pin' at row 0
423 DROP PROCEDURE p2;
424 DROP FUNCTION f1;
425 ALTER DATABASE test CHARACTER SET utf8mb4 COLLATE utf8mb4_uca1400_ai_ci;
426 #
427 # MDEV-34316 sql_mode=ORACLE: Ignore the NOCOPY keyword in stored routine parameters
428 #
429 SET sql_mode=ORACLE;
430 #
431 # sql_mode=ORACLE. Test with function
432 #
433 CREATE OR REPLACE FUNCTION example_func(
434 p_in1 IN VARCHAR(255),
435 p_in2 IN NOCOPY VARCHAR(255),
436 p_out1 OUT INT,
437 p_out2 OUT NOCOPY INT,
438 p_in_out1 IN OUT VARCHAR(255),
439 p_in_out2 IN OUT NOCOPY VARCHAR(255),
440 p_in_out3 INOUT NUMBER,
441 p_in_out4 INOUT NOCOPY NUMBER) RETURN NUMBER AS
442 BEGIN
443 RETURN 0;
444 END;
445 /
446 DROP FUNCTION example_func;
447 #
448 # sql_mode=ORACLE. Test with procedure
449 #
450 CREATE OR REPLACE PROCEDURE example_proc(
451 p_in1 IN VARCHAR(255),
452 p_in2 IN NOCOPY VARCHAR(255),
453 p_out1 OUT INT,
454 p_out2 OUT NOCOPY INT,
455 p_in_out1 IN OUT VARCHAR(255),
456 p_in_out2 IN OUT NOCOPY VARCHAR(255),
457 p_in_out3 INOUT NUMBER,
458 p_in_out4 INOUT NOCOPY NUMBER) AS
459 BEGIN
460 END;
461 /
462 DROP PROCEDURE example_proc;
463 SET sql_mode=DEFAULT;
464 #
465 # sql_mode=DEFAULT to perform the negative test case. Test with function, IN NOCOPY
466 #
467 CREATE OR REPLACE FUNCTION example_func(IN NOCOPY p_in INT) RETURNS INT
468 BEGIN
469 RETURN 0;
470 END;
471 $$
472 ERROR HY000: Unknown data type: 'p_in'
473 #
474 # sql_mode=DEFAULT to perform the negative test case. Test with function, OUT NOCOPY
475 #
476 CREATE OR REPLACE FUNCTION example_func(OUT NOCOPY p_out INT) RETURNS INT
477 BEGIN
478 RETURN 0;
479 END;
480 $$
481 ERROR HY000: Unknown data type: 'p_out'
482 #
483 # sql_mode=DEFAULT to perform the negative test case. Test with function, INOUT NOCOPY
484 #
485 CREATE OR REPLACE FUNCTION example_func(INOUT NOCOPY p_inout INT) RETURNS INT
486 BEGIN
487 RETURN 0;
488 END;
489 $$
490 ERROR HY000: Unknown data type: 'p_inout'
491 #
492 # sql_mode=DEFAULT to perform the negative test case. Test with procedure, IN NOCOPY
493 #
494 CREATE OR REPLACE PROCEDURE example_proc(IN NOCOPY p_in INT)
495 BEGIN
496 END;
497 $$
498 ERROR HY000: Unknown data type: 'p_in'
499 #
500 # sql_mode=DEFAULT to perform the negative test case. Test with procedure, OUT NOCOPY
501 #
502 CREATE OR REPLACE PROCEDURE example_proc(OUT NOCOPY p_out INT)
503 BEGIN
504 END;
505 $$
506 ERROR HY000: Unknown data type: 'p_out'
507 #
508 # sql_mode=DEFAULT to perform the negative test case. Test with procedure, INOUT NOCOPY
509 #
510 CREATE OR REPLACE PROCEDURE example_proc(INOUT NOCOPY p_inout INT)
511 BEGIN
512 END;
513 $$
514 ERROR HY000: Unknown data type: 'p_inout'
515 #
516 # MDEV-35229 NOCOPY has become reserved word bringing wide incompatibility
517 #
518 SET sql_mode=ORACLE;
519 CREATE TABLE nocopy (a INT);
520 DROP TABLE nocopy;
521 CREATE TABLE t1 (nocopy int);
522 SELECT nocopy AS nocopy FROM t1 AS nocopy;
523 nocopy
524 DROP TABLE t1;
525 CREATE TABLE nocopy (nocopy INT);
526 CREATE TRIGGER nocopy AFTER INSERT ON nocopy FOR EACH ROW BEGIN END;
527 DROP TRIGGER nocopy;
528 DROP TABLE nocopy;
529 PREPARE nocopy FROM 'select 1';
530 EXECUTE nocopy;
531 1
532 1
533 DEALLOCATE PREPARE nocopy;
534 CREATE FUNCTION nocopy (nocopy INT) RETURN INT AS
535 BEGIN
536 RETURN nocopy;
537 END;
538 $$
539 Warnings:
540 Note 1585 This function 'nocopy' has the same name as a native function
541 SELECT nocopy(1);
542 nocopy(1)
543 1
544 Warnings:
545 Note 1585 This function 'nocopy' has the same name as a native function
546 DROP FUNCTION nocopy;
547 CREATE FUNCTION nocopy (nocopy nocopy INT) RETURN INT AS
548 BEGIN
549 RETURN nocopy;
550 END;
551 $$
552 Warnings:
553 Note 1585 This function 'nocopy' has the same name as a native function
554 SELECT nocopy(1);
555 nocopy(1)
556 1
557 Warnings:
558 Note 1585 This function 'nocopy' has the same name as a native function
559 DROP FUNCTION nocopy;
560 CREATE PROCEDURE nocopy (nocopy INT) AS
561 BEGIN
562 SELECT nocopy;
563 END;
564 $$
565 CALL nocopy(1);
566 nocopy
567 1
568 DROP PROCEDURE nocopy;
569 CREATE PROCEDURE nocopy (nocopy nocopy INT) AS
570 BEGIN
571 SELECT nocopy;
572 END;
573 $$
574 CALL nocopy(1);
575 nocopy
576 1
577 DROP PROCEDURE nocopy;
578 DECLARE
579 nocopy INT := 1;
580 BEGIN
581 <<nocopy>>
582 WHILE 1
583 LOOP
584 SELECT nocopy;
585 LEAVE nocopy;
586 END LOOP;
587 END;
588 $$
589 nocopy
590 1
591 #
592 # End of 11.7 tests
593 #