diff options
| author | Alexander Barkov <bar@mariadb.org> | 2016-08-12 15:32:10 +0400 |
|---|---|---|
| committer | Alexander Barkov <bar@mariadb.org> | 2017-04-05 15:02:42 +0400 |
| commit | 0040b0f38060724e95137aa5564feca3da11bc02 (patch) | |
| tree | 15c093a5edccc010dd4ac2eaa65761985b20a59e /sql/sp.cc | |
| parent | bd76d44564b6e23356ff7de59101cf02aee1e338 (diff) | |
| download | mariadb-git-0040b0f38060724e95137aa5564feca3da11bc02.tar.gz | |
MDEV-10411 Providing compatibility for basic PL/SQL constructs
Part 13: RETURN vs RETURNS in function definition:
CREATE FUNCTION f1(a INT) RETURN INT ...
Part 12: No parentheses if no arguments:
CREATE FUNCTION f1 RETURN INT ...
Diffstat (limited to 'sql/sp.cc')
| -rw-r--r-- | sql/sp.cc | 5 |
1 files changed, 4 insertions, 1 deletions
diff --git a/sql/sp.cc b/sql/sp.cc index 382b3abd3a3..0071c67ecea 100644 --- a/sql/sp.cc +++ b/sql/sp.cc @@ -2230,7 +2230,10 @@ show_create_sp(THD *thd, String *buf, buf->append(')'); if (type == TYPE_ENUM_FUNCTION) { - buf->append(STRING_WITH_LEN(" RETURNS ")); + if (sql_mode & MODE_ORACLE) + buf->append(STRING_WITH_LEN(" RETURN ")); + else + buf->append(STRING_WITH_LEN(" RETURNS ")); buf->append(returns, returnslen); } buf->append('\n'); |