diff options
| author | Alexander Barkov <bar@mariadb.org> | 2016-09-17 08:24:05 +0400 |
|---|---|---|
| committer | Alexander Barkov <bar@mariadb.org> | 2017-04-05 15:02:48 +0400 |
| commit | 30bec863cf710f9135439f410e1c31e4df873fd1 (patch) | |
| tree | 6f78961390733bfadec431053e9f909eeb88e2b5 /mysql-test | |
| parent | 7e7ba7cb948910e138922d6524cc125f9aa02848 (diff) | |
| download | mariadb-git-30bec863cf710f9135439f410e1c31e4df873fd1.tar.gz | |
MDEV-10342 Providing compatibility for basic SQL built-in functions
Adding functions NVL() and NVL2().
Diffstat (limited to 'mysql-test')
| -rw-r--r-- | mysql-test/suite/compat/oracle/r/func_case.result | 7 | ||||
| -rw-r--r-- | mysql-test/suite/compat/oracle/t/func_case.test | 9 |
2 files changed, 16 insertions, 0 deletions
diff --git a/mysql-test/suite/compat/oracle/r/func_case.result b/mysql-test/suite/compat/oracle/r/func_case.result new file mode 100644 index 00000000000..dfe2d165b88 --- /dev/null +++ b/mysql-test/suite/compat/oracle/r/func_case.result @@ -0,0 +1,7 @@ +SET sql_mode=ORACLE; +SELECT NVL(NULL, 'a'), NVL('a', 'b'); +NVL(NULL, 'a') NVL('a', 'b') +a a +SELECT NVL2(NULL, 'a', 'b'), NVL2('a', 'b', 'c'); +NVL2(NULL, 'a', 'b') NVL2('a', 'b', 'c') +b b diff --git a/mysql-test/suite/compat/oracle/t/func_case.test b/mysql-test/suite/compat/oracle/t/func_case.test new file mode 100644 index 00000000000..d5e0d650975 --- /dev/null +++ b/mysql-test/suite/compat/oracle/t/func_case.test @@ -0,0 +1,9 @@ +# +# Testing CASE and its abbreviations +# + +SET sql_mode=ORACLE; + +SELECT NVL(NULL, 'a'), NVL('a', 'b'); + +SELECT NVL2(NULL, 'a', 'b'), NVL2('a', 'b', 'c'); |