summaryrefslogtreecommitdiff
path: root/mysql-test/t/func_concat.test
diff options
context:
space:
mode:
authorunknown <evgen@moonbone.local>2006-06-14 23:54:08 +0400
committerunknown <evgen@moonbone.local>2006-06-14 23:54:08 +0400
commit9936533be9359176ae7f196ef3291c5ee0df2e97 (patch)
tree9f2d34990366073803ede28b005fe7965ee7d736 /mysql-test/t/func_concat.test
parentb395f9c29e0c01e8e37d6c62f5fc54d9118da2a3 (diff)
parent15462dd90a3fe1129d795aa99eb8a8c6f15154e5 (diff)
downloadmariadb-git-9936533be9359176ae7f196ef3291c5ee0df2e97.tar.gz
Manually merged
mysql-test/r/cast.result: Auto merged mysql-test/t/func_time.test: Auto merged sql/item_cmpfunc.h: Auto merged sql/item_strfunc.cc: Auto merged sql/item_timefunc.cc: Auto merged sql/item_timefunc.h: Auto merged sql/opt_sum.cc: Auto merged sql/structs.h: Auto 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
#