diff options
| author | unknown <bar@mysql.com> | 2005-08-08 19:09:54 +0500 |
|---|---|---|
| committer | unknown <bar@mysql.com> | 2005-08-08 19:09:54 +0500 |
| commit | 8c163ce92db11ba0e8b85b448ce09a4656289843 (patch) | |
| tree | 9bdb449b91e6b7a6573d54fc11844c6e6a0115be /mysql-test/r | |
| parent | e329dedffb46031c74b7760c7633fba0c85c98df (diff) | |
| download | mariadb-git-8c163ce92db11ba0e8b85b448ce09a4656289843.tar.gz | |
func_system.result, func_system.test:
adding test case
item_strfunc.cc:
Bug#12351
CONCAT with USER()/DATEBASE() and
a column gets strange results.
Mark created Item_str as constant, so CONCAT
cannot reuse it for optimization purposes.
sql/item_strfunc.cc:
Bug#12351
CONCAT with USER()/DATEBASE() and
a column gets strange results
mysql-test/t/func_system.test:
adding test case
mysql-test/r/func_system.result:
adding test case
Diffstat (limited to 'mysql-test/r')
| -rw-r--r-- | mysql-test/r/func_system.result | 15 |
1 files changed, 15 insertions, 0 deletions
diff --git a/mysql-test/r/func_system.result b/mysql-test/r/func_system.result index 137c25a2db5..d49da90fa28 100644 --- a/mysql-test/r/func_system.result +++ b/mysql-test/r/func_system.result @@ -68,6 +68,21 @@ drop table t1; select TRUE,FALSE,NULL; TRUE FALSE NULL 1 0 NULL +create table t1 (c1 char(5)) character set=latin1; +insert into t1 values('row 1'); +insert into t1 values('row 2'); +insert into t1 values('row 3'); +select concat(user(), '--', c1) from t1; +concat(user(), '--', c1) +root@localhost--row 1 +root@localhost--row 2 +root@localhost--row 3 +select concat(database(), '--', c1) from t1; +concat(database(), '--', c1) +test--row 1 +test--row 2 +test--row 3 +drop table t1; create table t1 (a char(10)) character set latin1; select * from t1 where a=version(); a |