summaryrefslogtreecommitdiff
path: root/mysql-test/t/func_concat.test
diff options
context:
space:
mode:
authorevgen@moonbone.local <>2006-06-14 23:54:08 +0400
committerevgen@moonbone.local <>2006-06-14 23:54:08 +0400
commite35a0ca4b776c101667e447618f808ed0a51ca81 (patch)
tree9f2d34990366073803ede28b005fe7965ee7d736 /mysql-test/t/func_concat.test
parent36fae7be6337f4903ffef70fca50afd3be13a978 (diff)
parentc9077f07e708f55ec4241fdb62ebd271707cb824 (diff)
downloadmariadb-git-e35a0ca4b776c101667e447618f808ed0a51ca81.tar.gz
Manually merged
Diffstat (limited to 'mysql-test/t/func_concat.test')
-rw-r--r--mysql-test/t/func_concat.test7
1 files changed, 7 insertions, 0 deletions
diff --git a/mysql-test/t/func_concat.test b/mysql-test/t/func_concat.test
index 42201961222..5487ad9c56b 100644
--- a/mysql-test/t/func_concat.test
+++ b/mysql-test/t/func_concat.test
@@ -52,6 +52,13 @@ select 'a' union select concat('a', -0.0);
--replace_result a-0.0000 a0.0000
select 'a' union select concat('a', -0.0000);
+#
+# Bug#16716: subselect in concat() may lead to a wrong result
+#
+select concat((select x from (select 'a' as x) as t1 ),
+ (select y from (select 'b' as y) as t2 )) from (select 1 union select 2 )
+ as t3;
+
# End of 4.1 tests
#