diff options
| author | unknown <Sinisa@sinisa.nasamreza.org> | 2004-12-23 21:08:54 +0200 |
|---|---|---|
| committer | unknown <Sinisa@sinisa.nasamreza.org> | 2004-12-23 21:08:54 +0200 |
| commit | 8ccfad7636811347b57d9e14e20a3b52b8941664 (patch) | |
| tree | 486acf020b2189aeb3209550d5dfac42f70462dc /mysql-test/r/func_str.result | |
| parent | 74cc635a7cae3f2548ccbbdb2c6775758e554caa (diff) | |
| download | mariadb-git-8ccfad7636811347b57d9e14e20a3b52b8941664.tar.gz | |
Fix for a bug #7495
mysql-test/r/func_str.result:
result for test case for a bug in QUOTE() (Bug #7495)
mysql-test/t/func_str.test:
test case for a bug in QUOTE() (Bug #7495)
sql/item_strfunc.cc:
a better fix for a QUOTE() bug (Bug #7495)
Diffstat (limited to 'mysql-test/r/func_str.result')
| -rw-r--r-- | mysql-test/r/func_str.result | 18 |
1 files changed, 6 insertions, 12 deletions
diff --git a/mysql-test/r/func_str.result b/mysql-test/r/func_str.result index 2ca90653fec..278cd4dd935 100644 --- a/mysql-test/r/func_str.result +++ b/mysql-test/r/func_str.result @@ -291,15 +291,9 @@ trim(trailing 'foo' from 'foo') select trim(leading 'foo' from 'foo'); trim(leading 'foo' from 'foo') -create table t1 (a varchar(80), b varchar(80)); -insert into t1 values(NULL,"12345"); -insert into t1 values(NULL,"chm"); -select quote(ltrim(concat(' ',t1.b))) from t1; -quote(ltrim(concat(' ',t1.b))) -'12345' -'chm' -select quote(trim(concat(' ',t1.b))) from t1; -quote(trim(concat(' ',t1.b))) -'12345' -'chm' -drop table t1; +select quote(ltrim(concat(' ', 'a'))); +quote(ltrim(concat(' ', 'a'))) +'a' +select quote(trim(concat(' ', 'a'))); +quote(trim(concat(' ', 'a'))) +'a' |