mysql-test/suite/compat/oracle/t/func_case.test


1
2
3
4
5
6
7
8
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');