diff options
| author | unknown <igor@igor-inspiron.creware.com> | 2005-06-13 11:45:29 -0700 |
|---|---|---|
| committer | unknown <igor@igor-inspiron.creware.com> | 2005-06-13 11:45:29 -0700 |
| commit | d039d345e69017d6e1937bc31f8e411336f83683 (patch) | |
| tree | 6589c3bbdc00cecba70b67ca4532f99328e8ada1 /mysql-test/r/func_if.result | |
| parent | 1a0bddb84d5c93af339e7c5ce1a45c7cbde59071 (diff) | |
| parent | a4535bc827f38899270c4bca37c544198f6a9e2a (diff) | |
| download | mariadb-git-d039d345e69017d6e1937bc31f8e411336f83683.tar.gz | |
Manual merge
sql/item_cmpfunc.cc:
Auto merged
mysql-test/r/func_if.result:
Manual merge.
Diffstat (limited to 'mysql-test/r/func_if.result')
| -rw-r--r-- | mysql-test/r/func_if.result | 13 |
1 files changed, 13 insertions, 0 deletions
diff --git a/mysql-test/r/func_if.result b/mysql-test/r/func_if.result index 3e72fb45a14..aee23b38ca5 100644 --- a/mysql-test/r/func_if.result +++ b/mysql-test/r/func_if.result @@ -108,3 +108,16 @@ id date_ord text 2 16-03-2005 Day 2 1 05-03-2005 Day 1 DROP TABLE t1; +CREATE TABLE t1 (a CHAR(10)); +INSERT INTO t1 VALUES ('aaa'), (NULL), (''), ('bbb'); +SELECT a, NULLIF(a,'') FROM t1; +a NULLIF(a,'') +aaa aaa +NULL NULL + NULL +bbb bbb +SELECT a, NULLIF(a,'') FROM t1 WHERE NULLIF(a,'') IS NULL; +a NULLIF(a,'') +NULL NULL + NULL +DROP TABLE t1; |