summaryrefslogtreecommitdiff
path: root/mysql-test/t/func_str.test
diff options
context:
space:
mode:
authorunknown <Sinisa@sinisa.nasamreza.org>2004-12-24 23:07:10 +0200
committerunknown <Sinisa@sinisa.nasamreza.org>2004-12-24 23:07:10 +0200
commit6569fc7ddac44c64915876f215f9d40756cd38f0 (patch)
treea774e5685709b7497bf11430a09f7d7c1e250a27 /mysql-test/t/func_str.test
parent19ffa6a4ecdf30ca0d6071777a06b6d297a49529 (diff)
parent8feedada9d6968545a6ce3eec44f93be5e313575 (diff)
downloadmariadb-git-6569fc7ddac44c64915876f215f9d40756cd38f0.tar.gz
4.0 -> 4.1 merge
sql/item_strfunc.cc: Auto merged mysql-test/r/func_str.result: merged test results for QUOTE() buf fix mysql-test/t/func_str.test: merged test for QUOTE() buf fix
Diffstat (limited to 'mysql-test/t/func_str.test')
-rw-r--r--mysql-test/t/func_str.test6
1 files changed, 6 insertions, 0 deletions
diff --git a/mysql-test/t/func_str.test b/mysql-test/t/func_str.test
index 4404429cf7e..5477a0ccb30 100644
--- a/mysql-test/t/func_str.test
+++ b/mysql-test/t/func_str.test
@@ -429,3 +429,9 @@ create table t1 (a int not null primary key, b varchar(40), c datetime);
insert into t1 (a,b,c) values (1,'Tom','2004-12-10 12:13:14'),(2,'ball games','2004-12-10 12:13:14'), (3,'Basil','2004-12-10 12:13:14'), (4,'Dean','2004-12-10 12:13:14'),(5,'Ellis','2004-12-10 12:13:14'), (6,'Serg','2004-12-10 12:13:14'), (7,'Sergei','2004-12-10 12:13:14'),(8,'Georg','2004-12-10 12:13:14'),(9,'Salle','2004-12-10 12:13:14'),(10,'Sinisa','2004-12-10 12:13:14');
select count(*) as total, left(c,10) as reg from t1 group by reg order by reg desc limit 0,12;
drop table t1;
+# crashing bug with QUOTE() and LTRIM() or TRIM() fixed
+# Bug #7495
+#
+
+select quote(ltrim(concat(' ', 'a')));
+select quote(trim(concat(' ', 'a')));