summaryrefslogtreecommitdiff
path: root/mysql-test/t/func_str.test
diff options
context:
space:
mode:
authorunknown <jimw@mysql.com>2005-07-22 12:35:15 -0700
committerunknown <jimw@mysql.com>2005-07-22 12:35:15 -0700
commit6fd718dfbbe6f9644e0ade69424517cfcff19d8c (patch)
treef92a75a856119748afdb36ea16fd51f742345470 /mysql-test/t/func_str.test
parentfb006284d8d4c0f38f28c4b2edcc2bf98b00c767 (diff)
parenta4217760b409a0ab05b32f748da70dce629e4697 (diff)
downloadmariadb-git-6fd718dfbbe6f9644e0ade69424517cfcff19d8c.tar.gz
Merge mysql.com:/home/jimw/my/mysql-4.1-clean
into mysql.com:/home/jimw/my/mysql-5.0-clean mysql-test/r/create.result: Auto merged mysql-test/r/func_str.result: Auto merged mysql-test/t/func_str.test: Auto merged sql/item_strfunc.cc: Auto merged sql/sql_table.cc: Auto merged mysql-test/t/create.test: Resolve conflict sql/mysql_priv.h: Resolve conflict sql/table.cc: Resolve conflict sql/unireg.cc: Resolve conflict
Diffstat (limited to 'mysql-test/t/func_str.test')
-rw-r--r--mysql-test/t/func_str.test11
1 files changed, 11 insertions, 0 deletions
diff --git a/mysql-test/t/func_str.test b/mysql-test/t/func_str.test
index efad2721ae5..b7cf9c8c4a0 100644
--- a/mysql-test/t/func_str.test
+++ b/mysql-test/t/func_str.test
@@ -613,3 +613,14 @@ drop table t1;
# Bug #9854 hex() and out of range handling
#
select hex(29223372036854775809), hex(-29223372036854775809);
+
+#
+# Bug #11311: Incorrect length returned from LPAD() and RPAD()
+#
+create table t1 (i int);
+insert into t1 values (1000000000),(1);
+--enable_metadata
+select lpad(i, 7, ' ') as t from t1;
+select rpad(i, 7, ' ') as t from t1;
+--disable_metadata
+drop table t1;