summaryrefslogtreecommitdiff
path: root/mysql-test/t/func_misc.test
diff options
context:
space:
mode:
authorunknown <msvensson@neptunus.(none)>2005-05-17 20:31:26 +0200
committerunknown <msvensson@neptunus.(none)>2005-05-17 20:31:26 +0200
commit804ce01a316d6f55f54e7580e7ef42384fb1d750 (patch)
tree42f8762f3c6f6963adfa9166c3069509a3a12c5c /mysql-test/t/func_misc.test
parentb3d194f2521cc1eb7d682af3329925b3a6cdf5e3 (diff)
downloadmariadb-git-804ce01a316d6f55f54e7580e7ef42384fb1d750.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' mysql-test/r/func_misc.result: Test results 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/t/func_misc.test')
-rw-r--r--mysql-test/t/func_misc.test8
1 files changed, 8 insertions, 0 deletions
diff --git a/mysql-test/t/func_misc.test b/mysql-test/t/func_misc.test
index 89aba7ee583..78ff0907b39 100644
--- a/mysql-test/t/func_misc.test
+++ b/mysql-test/t/func_misc.test
@@ -38,3 +38,11 @@ select a from t1 where mid(a+0,6,3) = ( mid(20040106123400,6,3) );
drop table t1;
+# Test for BUG#9535
+create table t1 as select uuid(), length(uuid());
+show create table t1;
+drop table t1;
+
+
+
+