diff options
| author | unknown <bar@mysql.com> | 2004-08-13 15:04:10 +0500 |
|---|---|---|
| committer | unknown <bar@mysql.com> | 2004-08-13 15:04:10 +0500 |
| commit | e2cfe7b60771610aff0d287ad243249099f4f629 (patch) | |
| tree | 3aa503a2465a0a4b7cfb2777273d09a137837d96 /mysql-test | |
| parent | da60f1973db490601ca9b96efe7cd8d1a1517260 (diff) | |
| download | mariadb-git-e2cfe7b60771610aff0d287ad243249099f4f629.tar.gz | |
ctype_utf8.result, ctype_utf8.test, item_strfunc.cc:
LEFT() didn't work well in some cases.
sql/item_strfunc.cc:
LEFT() didn't work well in some cases.
mysql-test/t/ctype_utf8.test:
LEFT() didn't work well in some cases.
mysql-test/r/ctype_utf8.result:
LEFT() didn't work well in some cases.
Diffstat (limited to 'mysql-test')
| -rw-r--r-- | mysql-test/r/ctype_utf8.result | 3 | ||||
| -rw-r--r-- | mysql-test/t/ctype_utf8.test | 6 |
2 files changed, 9 insertions, 0 deletions
diff --git a/mysql-test/r/ctype_utf8.result b/mysql-test/r/ctype_utf8.result index 8ad8be26b62..55b7f5f9035 100644 --- a/mysql-test/r/ctype_utf8.result +++ b/mysql-test/r/ctype_utf8.result @@ -93,6 +93,9 @@ this is a test select insert("aa",100,1,"b"),insert("aa",1,3,"b"); insert("aa",100,1,"b") insert("aa",1,3,"b") aa b +select char_length(left(@a:='тест',5)), length(@a), @a; +char_length(left(@a:='тест',5)) length(@a) @a +4 8 тест create table t1 select date_format("2004-01-19 10:10:10", "%Y-%m-%d"); show create table t1; Table Create Table diff --git a/mysql-test/t/ctype_utf8.test b/mysql-test/t/ctype_utf8.test index f25a1ecfd0c..82908fde75e 100644 --- a/mysql-test/t/ctype_utf8.test +++ b/mysql-test/t/ctype_utf8.test @@ -63,6 +63,12 @@ select insert('txs',2,1,'hi'),insert('is ',4,0,'a'),insert('txxxxt',2,4,'es'); select insert("aa",100,1,"b"),insert("aa",1,3,"b"); # +# LELF() didn't work well with utf8 in some cases too. +# +select char_length(left(@a:='тест',5)), length(@a), @a; + + +# # CREATE ... SELECT # create table t1 select date_format("2004-01-19 10:10:10", "%Y-%m-%d"); |