diff options
| author | gkodinov@dl145s.mysql.com <> | 2006-09-15 11:52:49 +0200 |
|---|---|---|
| committer | gkodinov@dl145s.mysql.com <> | 2006-09-15 11:52:49 +0200 |
| commit | b1e087a717ccf618910d549f4621248dbbb94355 (patch) | |
| tree | af058bb5d99db7c740c4e135bb2137cd924529ff /mysql-test/t/view.test | |
| parent | c8ebf3761e99e62bd665b9b8edc2bcd74b260a38 (diff) | |
| parent | 148cb4e98a6f711a8f7067def77c5036967fc95e (diff) | |
| download | mariadb-git-b1e087a717ccf618910d549f4621248dbbb94355.tar.gz | |
Merge dl145s.mysql.com:/data/bk/team_tree_merge/CLEAN/mysql-5.0
into dl145s.mysql.com:/data/bk/team_tree_merge/MERGE/mysql-5.0-opt
Diffstat (limited to 'mysql-test/t/view.test')
| -rw-r--r-- | mysql-test/t/view.test | 16 |
1 files changed, 16 insertions, 0 deletions
diff --git a/mysql-test/t/view.test b/mysql-test/t/view.test index edff38274c4..e299b86c4e6 100644 --- a/mysql-test/t/view.test +++ b/mysql-test/t/view.test @@ -2833,5 +2833,21 @@ DROP FUNCTION f2; DROP VIEW v1, v2; DROP TABLE t1; +# +# Bug #5500: wrong select_type in EXPLAIN output for queries over views +# + +CREATE TABLE t1 (s1 int); +CREATE VIEW v1 AS SELECT * FROM t1; + +EXPLAIN SELECT * FROM t1; +EXPLAIN SELECT * FROM v1; +INSERT INTO t1 VALUES (1), (3), (2); + +EXPLAIN SELECT * FROM t1 t WHERE t.s1+1 < (SELECT MAX(t1.s1) FROM t1); +EXPLAIN SELECT * FROM v1 t WHERE t.s1+1 < (SELECT MAX(t1.s1) FROM t1); + +DROP VIEW v1; +DROP TABLE t1; --echo End of 5.0 tests. |