diff options
| author | unknown <gkodinov@dl145s.mysql.com> | 2006-09-15 11:52:49 +0200 |
|---|---|---|
| committer | unknown <gkodinov@dl145s.mysql.com> | 2006-09-15 11:52:49 +0200 |
| commit | e4b044060ca806c3c6a78bc7fc89acf3641f62ad (patch) | |
| tree | af058bb5d99db7c740c4e135bb2137cd924529ff /mysql-test/t/view.test | |
| parent | a1c85e65f0615c57f30d3c20fbdaeb60679ff9bb (diff) | |
| parent | 8fd0cf54983889377cdaaf5b5c7020687c9447a6 (diff) | |
| download | mariadb-git-e4b044060ca806c3c6a78bc7fc89acf3641f62ad.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
sql/item.cc:
Auto merged
sql/item_cmpfunc.cc:
Auto merged
sql/item_func.cc:
Auto merged
sql/item_func.h:
Auto merged
sql/mysql_priv.h:
Auto merged
sql/sql_parse.cc:
Auto merged
sql/sql_select.cc:
Auto merged
sql/sql_yacc.yy:
Auto merged
sql/item.h:
SCCS merged
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. |