summaryrefslogtreecommitdiff
path: root/mysql-test/t/join.test
diff options
context:
space:
mode:
authorSergey Glukhov <Sergey.Glukhov@sun.com>2010-03-24 14:45:09 +0400
committerSergey Glukhov <Sergey.Glukhov@sun.com>2010-03-24 14:45:09 +0400
commitfe25ec8f2425cfd0e59d9a20f0094d6fc6e0cd3a (patch)
tree79d297822c1d85981f562b66cc48a7dfcafb8d64 /mysql-test/t/join.test
parenta9a2ceae1f360c275ed4db5b093ab65be4f5fb7b (diff)
parentbccf219bfc61bb45d334b40d732651eb9bef5075 (diff)
downloadmariadb-git-fe25ec8f2425cfd0e59d9a20f0094d6fc6e0cd3a.tar.gz
5.0-bugteam->5.1-bugteam merge
Diffstat (limited to 'mysql-test/t/join.test')
-rw-r--r--mysql-test/t/join.test12
1 files changed, 12 insertions, 0 deletions
diff --git a/mysql-test/t/join.test b/mysql-test/t/join.test
index 761121313e5..c1b35b51563 100644
--- a/mysql-test/t/join.test
+++ b/mysql-test/t/join.test
@@ -784,6 +784,18 @@ FROM
DROP TABLE t1,t2,t3,t4,t5,t6;
+--echo #
+--echo # Bug#48483: crash in get_best_combination()
+--echo #
+
+CREATE TABLE t1(f1 INT);
+INSERT INTO t1 VALUES (1),(2);
+CREATE VIEW v1 AS SELECT 1 FROM t1 LEFT JOIN t1 AS t2 on 1=1;
+EXPLAIN EXTENDED
+SELECT 1 FROM v1 right join v1 AS v2 ON RAND();
+DROP VIEW v1;
+DROP TABLE t1;
+
--echo End of 5.0 tests.