summaryrefslogtreecommitdiffstats
path: root/mysql-test/main/sp-row-vs-var.inc
blob: 54d323f7341f93407f9d1bcc52a92eb5b2285fa9 (plain)
1
2
3
4
5
6
--let $query= CREATE PROCEDURE p1() BEGIN DECLARE var $type; DECLARE rec ROW(var $type); CREATE TABLE t1 AS SELECT var,rec.var FROM DUAL;END
--eval $query
CALL p1();
SHOW CREATE TABLE t1;
DROP TABLE t1;
DROP PROCEDURE p1;