1--eval CREATE FUNCTION f1(param $type) RETURN $type AS BEGIN RETURN param; END;
2SHOW 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
7SHOW CREATE TABLE t1;
8DROP TABLE t1;
9DROP FUNCTION f1;
10