diff options
| author | unknown <jimw@mysql.com> | 2005-02-01 18:29:10 -0800 |
|---|---|---|
| committer | unknown <jimw@mysql.com> | 2005-02-01 18:29:10 -0800 |
| commit | 6d0d03dab9a74fb512f03ea0275d84d34657ce2a (patch) | |
| tree | 1a47b163b367a84db2059d5242ae787ed3350c89 /mysql-test/r/func_str.result | |
| parent | faca00b5d5a7214dc380bb5b0fd89ea2648d41d2 (diff) | |
| download | mariadb-git-6d0d03dab9a74fb512f03ea0275d84d34657ce2a.tar.gz | |
Fix QUOTE() to not reuse the input field for output, which resulted in
incorrect results when the input was a constant across a multi-row SELECT
statement. (Bug #8248)
sql/item_strfunc.h:
Add tmp_value member
sql/item_strfunc.cc:
Always allocate a new string for QUOTE(), in case the field is being reused
for multiple rows.
mysql-test/t/func_str.test:
Add regression test
mysql-test/r/func_str.result:
Add test results
Diffstat (limited to 'mysql-test/r/func_str.result')
| -rw-r--r-- | mysql-test/r/func_str.result | 7 |
1 files changed, 7 insertions, 0 deletions
diff --git a/mysql-test/r/func_str.result b/mysql-test/r/func_str.result index 278cd4dd935..9392f152bb4 100644 --- a/mysql-test/r/func_str.result +++ b/mysql-test/r/func_str.result @@ -297,3 +297,10 @@ quote(ltrim(concat(' ', 'a'))) select quote(trim(concat(' ', 'a'))); quote(trim(concat(' ', 'a'))) 'a' +CREATE TABLE t1 SELECT 1 UNION SELECT 2 UNION SELECT 3; +SELECT QUOTE('A') FROM t1; +QUOTE('A') +'A' +'A' +'A' +DROP TABLE t1; |