Debian Codegraph @

mysql-test/suite/compat/oracle/t/sp-row-vs-var.inc

raw
1 --let $query= CREATE PROCEDURE p1() AS var $type; rec ROW(var $type); BEGIN CREATE TABLE t1 AS SELECT var,rec.var FROM DUAL;END
2 --eval $query
3 CALL p1();
4 SHOW CREATE TABLE t1;
5 DROP TABLE t1;
6 DROP PROCEDURE p1;