diff options
| author | unknown <igor@igor-inspiron.creware.com> | 2005-06-13 11:38:16 -0700 |
|---|---|---|
| committer | unknown <igor@igor-inspiron.creware.com> | 2005-06-13 11:38:16 -0700 |
| commit | a4535bc827f38899270c4bca37c544198f6a9e2a (patch) | |
| tree | 0bf0e649d4d6040d753faa6b310bb2973b501565 | |
| parent | 89906482e0271824209d995a37a2265dee3bd4cf (diff) | |
| download | mariadb-git-a4535bc827f38899270c4bca37c544198f6a9e2a.tar.gz | |
func_if.result, func_if.test:
Correction for test case of bug #11142.
mysql-test/t/func_if.test:
Correction for test case of bug #11142.
mysql-test/r/func_if.result:
Correction for test case of bug #11142.
| -rw-r--r-- | mysql-test/r/func_if.result | 14 | ||||
| -rw-r--r-- | mysql-test/t/func_if.test | 15 |
2 files changed, 0 insertions, 29 deletions
diff --git a/mysql-test/r/func_if.result b/mysql-test/r/func_if.result index dd8f34d53d2..2c8f19f1754 100644 --- a/mysql-test/r/func_if.result +++ b/mysql-test/r/func_if.result @@ -86,20 +86,6 @@ 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; diff --git a/mysql-test/t/func_if.test b/mysql-test/t/func_if.test index ae820fae93b..4333defa412 100644 --- a/mysql-test/t/func_if.test +++ b/mysql-test/t/func_if.test @@ -60,21 +60,6 @@ drop table t1; # Bug #5595 NULLIF() IS NULL returns false if NULLIF() returns NULL # SELECT NULLIF(5,5) IS NULL, NULLIF(5,5) IS NOT NULL; -# -# Test to check evaluation of MULLIF when the first argument is NULL -# (motivated by the Bug 11142) -# - ---disable_warnings -DROP TABLE IF EXISTS t1; ---enable_warnings - -CREATE TABLE t1 (a CHAR(10)); -INSERT INTO t1 VALUES ('aaa'), (NULL), (''), ('bbb'); -SELECT a, NULLIF(a,'') FROM t1; -SELECT a, NULLIF(a,'') FROM t1 WHERE NULLIF(a,'') IS NULL; - -DROP TABLE t1; # # Test for bug #11142: evaluation of NULLIF when the first argument is NULL |