| 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; |