diff options
| author | monty@mysql.com <> | 2004-05-20 00:54:52 +0300 |
|---|---|---|
| committer | monty@mysql.com <> | 2004-05-20 00:54:52 +0300 |
| commit | a4b0ec1eded00350f41b26c475f45fe4919924c9 (patch) | |
| tree | 969ae655143f6308b50b399e6abcb73c20e39a81 /mysql-test/t/func_str.test | |
| parent | 332f124bc62d2a63cfb566b50e2784c357ef6b8e (diff) | |
| parent | 8e2ff7d13546e90eed7e3d05ad7f6a8d047ecdad (diff) | |
| download | mariadb-git-a4b0ec1eded00350f41b26c475f45fe4919924c9.tar.gz | |
Merge with 4.0, mainly to get changes to windows project files
Diffstat (limited to 'mysql-test/t/func_str.test')
| -rw-r--r-- | mysql-test/t/func_str.test | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/mysql-test/t/func_str.test b/mysql-test/t/func_str.test index c4413c3ef3f..c138b848491 100644 --- a/mysql-test/t/func_str.test +++ b/mysql-test/t/func_str.test @@ -173,6 +173,15 @@ SELECT DISTINCT i, ELT(j, '345', '34') FROM t1; DROP TABLE t1; # +# bug #3756: quote and NULL +# + +create table t1(a char(4)); +insert into t1 values ('one'),(NULL),('two'),('four'); +select a, quote(a), isnull(quote(a)), quote(a) is null, ifnull(quote(a), 'n') from t1; +drop table t1; + +# # Test collation and coercibility # |