diff options
| author | igor@igor-inspiron.creware.com <> | 2005-06-13 11:24:26 -0700 |
|---|---|---|
| committer | igor@igor-inspiron.creware.com <> | 2005-06-13 11:24:26 -0700 |
| commit | 42271e424013f70534da3e2e84ca55005ac4e92c (patch) | |
| tree | 7f90f7bc594a0ddf5ca1cc0008a1a291946590df /mysql-test/r/func_if.result | |
| parent | 36ff674468b4ec7d964f6d988f593fc517324dad (diff) | |
| download | mariadb-git-42271e424013f70534da3e2e84ca55005ac4e92c.tar.gz | |
func_if.result, func_if.test:
Added a test case for bug #11142.
item_cmpfunc.cc:
Fixed bug #11142.
Implementation of Item_func_nullif::is_null was corrected.
Diffstat (limited to 'mysql-test/r/func_if.result')
| -rw-r--r-- | mysql-test/r/func_if.result | 27 |
1 files changed, 27 insertions, 0 deletions
diff --git a/mysql-test/r/func_if.result b/mysql-test/r/func_if.result index 508a50caf02..dd8f34d53d2 100644 --- a/mysql-test/r/func_if.result +++ b/mysql-test/r/func_if.result @@ -86,3 +86,30 @@ drop table t1; SELECT NULLIF(5,5) IS NULL, NULLIF(5,5) IS NOT NULL; NULLIF(5,5) IS NULL NULLIF(5,5) IS NOT NULL 1 0 +DROP TABLE IF EXISTS 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; +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; |