Debian Codegraph @

mysql-test/suite/compat/oracle/t/sp-param.inc

raw
1 --eval CREATE FUNCTION f1(param $type) RETURN $type AS BEGIN RETURN param; END;
2 SHOW CREATE FUNCTION f1;
3
4 --eval SELECT LENGTH(f1(REPEAT('a',$length)));
5 --eval CREATE TABLE t1 AS SELECT f1(REPEAT('a',$length)) AS a;
6
7 SHOW CREATE TABLE t1;
8 DROP TABLE t1;
9 DROP FUNCTION f1;