diff options
| author | unknown <ram@gw.mysql.r18.ru> | 2004-05-17 12:47:16 +0500 |
|---|---|---|
| committer | unknown <ram@gw.mysql.r18.ru> | 2004-05-17 12:47:16 +0500 |
| commit | ff23273b7afe24ebc5927178895c18c97c01d3cf (patch) | |
| tree | ce06802f25684e53cefada0a5cc14b37ae682ec1 /mysql-test/t/func_str.test | |
| parent | 2d743fe227f469c0dbaba803e818b4e23a3e2a76 (diff) | |
| download | mariadb-git-ff23273b7afe24ebc5927178895c18c97c01d3cf.tar.gz | |
A fix (bug #3756: ISNULL(QUOTE()) returns 1 for every row after 1st NULL)
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 d6255e4d93c..1d33e459372 100644 --- a/mysql-test/t/func_str.test +++ b/mysql-test/t/func_str.test @@ -163,3 +163,12 @@ CREATE TABLE t1 (i int, j int); INSERT INTO t1 VALUES (1,1),(2,2); 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;
\ No newline at end of file |