diff options
author | monty@mysql.com <> | 2005-07-28 17:09:54 +0300 |
---|---|---|
committer | monty@mysql.com <> | 2005-07-28 17:09:54 +0300 |
commit | 15d48525afc66df10f8f4e68c0a33a4e3ef2ae8c (patch) | |
tree | efa95d21efbbc033b0cabce038118a09be44e9ac /mysql-test/t/bool.test | |
parent | b3cbd0048fe5fe36fe4fba9ce591b0d1b26e10a1 (diff) | |
parent | 3c12d0ae54eccaef7c265af4f782d95250308dc9 (diff) | |
download | mariadb-git-15d48525afc66df10f8f4e68c0a33a4e3ef2ae8c.tar.gz |
Merge mysql.com:/home/my/mysql-4.1
into mysql.com:/home/my/mysql-5.0
Diffstat (limited to 'mysql-test/t/bool.test')
-rw-r--r-- | mysql-test/t/bool.test | 2 |
1 files changed, 2 insertions, 0 deletions
diff --git a/mysql-test/t/bool.test b/mysql-test/t/bool.test index 53230dd5fa3..34c51c648d3 100644 --- a/mysql-test/t/bool.test +++ b/mysql-test/t/bool.test @@ -58,3 +58,5 @@ select ifnull(A, 'N') as A, ifnull(B, 'N') as B, ifnull(not A, 'N') as nA, ifnul select ifnull(A=1, 'N') as A, ifnull(B=1, 'N') as B, ifnull(not (A=1), 'N') as nA, ifnull(not (B=1), 'N') as nB, ifnull((A=1) and (B=1), 'N') as AB, ifnull(not ((A=1) and (B=1)), 'N') as `n(AB)`, ifnull((not (A=1) or not (B=1)), 'N') as nAonB, ifnull((A=1) or (B=1), 'N') as AoB, ifnull(not((A=1) or (B=1)), 'N') as `n(AoB)`, ifnull(not (A=1) and not (B=1), 'N') as nAnB from t1; drop table t1; + +# End of 4.1 tests |