diff options
| author | unknown <msvensson@neptunus.(none)> | 2005-12-07 15:45:31 +0100 |
|---|---|---|
| committer | unknown <msvensson@neptunus.(none)> | 2005-12-07 15:45:31 +0100 |
| commit | 6b6eb1aba4189df75367a4beb56368c4961880e3 (patch) | |
| tree | 776b6cfc2952db07d3fcd85e5fd5058eecef6ec2 /mysql-test/r/func_misc.result | |
| parent | 966ab524a336bb22088d4adbb7db7a090762551e (diff) | |
| download | mariadb-git-6b6eb1aba4189df75367a4beb56368c4961880e3.tar.gz | |
BUG#9535 Warning for "create table t as select uuid();"
- Set max_length of Item_func_uuid to max_length*system_charset_info->mbmaxlen
Note! Item_func_uuid should be set to use 'ascii' charset when hex(), format(), md5()
etc will use 'ascii'
- Comitting again, the old patch seems to have been lost.
mysql-test/r/func_misc.result:
Test results updated
mysql-test/t/func_misc.test:
Test case
sql/item_strfunc.h:
Multiply max_length of Item_func_uuid with system_charset_info->mbmaxlen
Diffstat (limited to 'mysql-test/r/func_misc.result')
| -rw-r--r-- | mysql-test/r/func_misc.result | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/mysql-test/r/func_misc.result b/mysql-test/r/func_misc.result index 2d464c891bf..181ecf7b65b 100644 --- a/mysql-test/r/func_misc.result +++ b/mysql-test/r/func_misc.result @@ -49,3 +49,11 @@ select a from t1 where mid(a+0,6,3) = ( mid(20040106123400,6,3) ); a 2004-01-06 12:34:00 drop table t1; +create table t1 as select uuid(), length(uuid()); +show create table t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `uuid()` char(36) character set utf8 NOT NULL default '', + `length(uuid())` int(10) NOT NULL default '0' +) ENGINE=MyISAM DEFAULT CHARSET=latin1 +drop table t1; |