diff options
| author | Alexander Barkov <bar@mariadb.org> | 2016-09-19 09:43:00 +0400 |
|---|---|---|
| committer | Alexander Barkov <bar@mariadb.org> | 2017-04-05 15:02:49 +0400 |
| commit | 02a72cf87c51cf3e33627e1f358d18205f7bba3b (patch) | |
| tree | 71e47baf95b0b8573ae121e6f6769a21dcf13d31 /mysql-test/suite/compat/oracle/t/sp-param.test | |
| parent | ec527face333fc5d2fe058485dc670dd6db86e2d (diff) | |
| download | mariadb-git-02a72cf87c51cf3e33627e1f358d18205f7bba3b.tar.gz | |
MDEV-10596 Allow VARCHAR and VARCHAR2 without length as a data type of routine parameters and in RETURN clause
Diffstat (limited to 'mysql-test/suite/compat/oracle/t/sp-param.test')
| -rw-r--r-- | mysql-test/suite/compat/oracle/t/sp-param.test | 37 |
1 files changed, 37 insertions, 0 deletions
diff --git a/mysql-test/suite/compat/oracle/t/sp-param.test b/mysql-test/suite/compat/oracle/t/sp-param.test new file mode 100644 index 00000000000..23203317f50 --- /dev/null +++ b/mysql-test/suite/compat/oracle/t/sp-param.test @@ -0,0 +1,37 @@ +SET sql_mode=ORACLE; + +--echo # +--echo # MDEV-10596 Allow VARCHAR and VARCHAR2 without length as a data type of routine parameters and in RETURN clause +--echo # + +--let type = CHAR +--let length = 2000 +--source sp-param.inc + +--let type = NCHAR +--let length = 2000 +--source sp-param.inc + +--let type = BINARY +--let length = 2000 +--source sp-param.inc + +--let type = VARCHAR +--let length = 4000 +--source sp-param.inc + +--let type = VARCHAR2 +--let length = 4000 +--source sp-param.inc + +--let type = NVARCHAR +--let length = 4000 +--source sp-param.inc + +--let type = VARBINARY +--let length = 4000 +--source sp-param.inc + +--let type = RAW +--let length = 4000 +--source sp-param.inc |