diff options
| author | Alexander Barkov <bar@mysql.com> | 2010-07-09 09:39:41 +0400 |
|---|---|---|
| committer | Alexander Barkov <bar@mysql.com> | 2010-07-09 09:39:41 +0400 |
| commit | 1d73bbd3a34750a3e1619b43605b865f4dceccd4 (patch) | |
| tree | deb9210a4406979a0ed87262242f37e2fe01f4a9 /mysql-test/include | |
| parent | 00e62a03112533adec6e8568c3097eca27823f46 (diff) | |
| download | mariadb-git-1d73bbd3a34750a3e1619b43605b865f4dceccd4.tar.gz | |
Bug#54668 User variable assignments get wrong type
Problem: Item_str_ascii_func::val_str() did not set
charset of the returned value properly.
mysql-test/include/ctype_numconv.inc
mysql-test/r/ctype_binary.result
mysql-test/r/ctype_cp1251.result
mysql-test/r/ctype_latin1.result
mysql-test/r/ctype_ucs.result
- Adding tests
sql/item_strfunc.cc
- Adding initialization of charset
Diffstat (limited to 'mysql-test/include')
| -rw-r--r-- | mysql-test/include/ctype_numconv.inc | 19 |
1 files changed, 19 insertions, 0 deletions
diff --git a/mysql-test/include/ctype_numconv.inc b/mysql-test/include/ctype_numconv.inc index d6bfa23017e..77913fc8c18 100644 --- a/mysql-test/include/ctype_numconv.inc +++ b/mysql-test/include/ctype_numconv.inc @@ -1607,6 +1607,25 @@ drop function f1; --echo # --echo # +--echo # Bug#54668 User variable assignments get wrong type +--echo # +SET @x=md5('a'); +SELECT charset(@x), collation(@x); +SET @x=old_password('a'); +SELECT charset(@x), collation(@x); +SET @x=password('a'); +SELECT charset(@x), collation(@x); +SET @x=sha('a'); +SELECT charset(@x), collation(@x); +SET @x=sha1('a'); +SELECT charset(@x), collation(@x); +SET @x=astext(point(1,2)); +SELECT charset(@x), collation(@x); +SET @x=aswkt(point(1,2)); +SELECT charset(@x), collation(@x); + + +--echo # --echo # Bug#52159 returning time type from function and empty left join causes debug assertion --echo # CREATE FUNCTION f1() RETURNS TIME RETURN 1; |