summaryrefslogtreecommitdiff
path: root/mysql-test/t/derived.test
diff options
context:
space:
mode:
authorSergei Golubchik <sergii@pisem.net>2013-12-13 13:00:38 +0100
committerSergei Golubchik <sergii@pisem.net>2013-12-13 13:00:38 +0100
commite68bccc743ddd5ee9b0e47ff73b57d088f015f17 (patch)
treef524c15c650c94dd8bab87899b04ae767544b5a2 /mysql-test/t/derived.test
parentca083a764f14233dfd7f97436629020901bd23a6 (diff)
parent3ec4296ec413e866c3efabc8dfa94172ad5f7c04 (diff)
downloadmariadb-git-e68bccc743ddd5ee9b0e47ff73b57d088f015f17.tar.gz
5.3 merge
Diffstat (limited to 'mysql-test/t/derived.test')
-rw-r--r--mysql-test/t/derived.test10
1 files changed, 10 insertions, 0 deletions
diff --git a/mysql-test/t/derived.test b/mysql-test/t/derived.test
index a67a0e6c9d0..559a8b76280 100644
--- a/mysql-test/t/derived.test
+++ b/mysql-test/t/derived.test
@@ -383,7 +383,17 @@ set
drop table t1, t2;
+--echo #
+--echo # MDEV-5353: server crash on subselect if WHERE applied to some
+--echo # result field
+--echo #
+SELECT * FROM
+( SELECT 100 a, subsel.b FROM ( SELECT 200 b ) subsel ) tmp
+WHERE tmp.b;
+SELECT * FROM
+( SELECT 100 a, subsel.b FROM ( SELECT 200 b ) subsel ) tmp
+WHERE tmp.a;
--echo # End of 5.3 tests
--echo #