diff options
| author | Alexander Barkov <bar@mariadb.org> | 2016-08-11 15:47:17 +0400 |
|---|---|---|
| committer | Alexander Barkov <bar@mariadb.org> | 2017-04-05 15:02:41 +0400 |
| commit | 0c9c4b84b79a9fb26074fbd8b8cc47cede048d3b (patch) | |
| tree | 69dad1d3552cc3db90a7d9c9afdcc3c25aad6967 /mysql-test/suite/compat/oracle/t/sp.test | |
| parent | 8fdc1f0147cd77d3191139247a4c54d1f1cbe189 (diff) | |
| download | mariadb-git-0c9c4b84b79a9fb26074fbd8b8cc47cede048d3b.tar.gz | |
MDEV-10411 Providing compatibility for basic PL/SQL constructs
Part 10: Default variable value: x INT := 10;
Diffstat (limited to 'mysql-test/suite/compat/oracle/t/sp.test')
| -rw-r--r-- | mysql-test/suite/compat/oracle/t/sp.test | 16 |
1 files changed, 16 insertions, 0 deletions
diff --git a/mysql-test/suite/compat/oracle/t/sp.test b/mysql-test/suite/compat/oracle/t/sp.test index 1880f153f2a..9ac4dbc7aed 100644 --- a/mysql-test/suite/compat/oracle/t/sp.test +++ b/mysql-test/suite/compat/oracle/t/sp.test @@ -1,5 +1,21 @@ SET sql_mode=ORACLE; +--echo # Testing ":=" to set the default value of a variable +DELIMITER /; +CREATE FUNCTION f1 () RETURNS NUMBER(10) AS + a NUMBER(10) := 10; +BEGIN + DECLARE + b NUMBER(10) DEFAULT 3; + BEGIN + RETURN a+b; + END; +END; +/ +DELIMITER ;/ +SELECT f1(); +DROP FUNCTION f1; + --echo # Testing labels DELIMITER /; |