diff options
| author | unknown <evgen@moonbone.local> | 2005-10-12 00:12:54 +0400 |
|---|---|---|
| committer | unknown <evgen@moonbone.local> | 2005-10-12 00:12:54 +0400 |
| commit | 122b48fd4d4f45f4b24758b7be2d11c8cc162017 (patch) | |
| tree | b421f82083be5419738a2ec401a238c29bf53ebf /mysql-test/t/view.test | |
| parent | f6290f2cf980ac3540e4130834f9cab57675f2dc (diff) | |
| parent | 751e45ad2248f4cbdcb90d029b7031a9cfac13aa (diff) | |
| download | mariadb-git-122b48fd4d4f45f4b24758b7be2d11c8cc162017.tar.gz | |
Merge epotemkin@bk-internal.mysql.com:/home/bk/mysql-5.0
into moonbone.local:/work/13327-bug-5.0-mysql
Diffstat (limited to 'mysql-test/t/view.test')
| -rw-r--r-- | mysql-test/t/view.test | 20 |
1 files changed, 20 insertions, 0 deletions
diff --git a/mysql-test/t/view.test b/mysql-test/t/view.test index 15c8cccf69c..5f483401cff 100644 --- a/mysql-test/t/view.test +++ b/mysql-test/t/view.test @@ -2167,3 +2167,23 @@ SELECT v_1.a FROM v1 AS v_1 GROUP BY v_1.a HAVING v_1.a IN (1,2,3); DROP VIEW v1; DROP TABLE t1; + +# +# Bug #13327 view wasn't using index for const condition +# + +CREATE TABLE t1 (a INT, b INT, INDEX(a,b)); +CREATE TABLE t2 LIKE t1; +CREATE TABLE t3 (a INT); +INSERT INTO t1 VALUES (1,1),(2,2),(3,3); +INSERT INTO t2 VALUES (1,1),(2,2),(3,3); +INSERT INTO t3 VALUES (1),(2),(3); +CREATE VIEW v1 AS SELECT t1.* FROM t1,t2 WHERE t1.a=t2.a AND t1.b=t2.b; +CREATE VIEW v2 AS SELECT t3.* FROM t1,t3 WHERE t1.a=t3.a; +EXPLAIN SELECT t1.* FROM t1 JOIN t2 WHERE t1.a=t2.a AND t1.b=t2.b AND t1.a=1; +EXPLAIN SELECT * FROM v1 WHERE a=1; +EXPLAIN SELECT * FROM v2 WHERE a=1; +DROP VIEW v1,v2; +DROP TABLE t1,t2,t3; + + |