diff options
Diffstat (limited to 'mysql-test/t/view.test')
| -rw-r--r-- | mysql-test/t/view.test | 22 |
1 files changed, 0 insertions, 22 deletions
diff --git a/mysql-test/t/view.test b/mysql-test/t/view.test index 9eafae1729f..5b83c89e7bb 100644 --- a/mysql-test/t/view.test +++ b/mysql-test/t/view.test @@ -4193,28 +4193,6 @@ DROP VIEW v1; DROP TABLE t1,t2; --echo # ---echo # LP bug #804686: query over a derived table using a view ---echo # with a degenerated where condition ---echo # - -CREATE TABLE t1 (a int, b int); -INSERT INTO t1 VALUES (0,0), (1,0), (0,0), (1,1), (1,0); -CREATE VIEW v1 AS SELECT a,b FROM t1; -CREATE VIEW v2 AS SELECT a, MAX(b) AS b FROM t1 GROUP BY a; - -SELECT * FROM (SELECT b FROM v1 WHERE b = 0) t WHERE b<>0; -SELECT * FROM (SELECT b FROM v2 WHERE b = 0) t WHERE b<>0; -SELECT * FROM (SELECT b FROM v1 WHERE b = 0) t WHERE b; -SELECT * FROM (SELECT b FROM v2 WHERE b = 0) t WHERE b; -EXPLAIN EXTENDED -SELECT * FROM (SELECT b FROM v1 WHERE b = 0) t WHERE b; -EXPLAIN EXTENDED -SELECT * FROM (SELECT b FROM v2 WHERE b = 0) t WHERE b; - -DROP VIEW v1,v2; -DROP TABLE t1; - ---echo # --echo # LP bug #793386: unexpected 'Duplicate column name ''' error --echo # at the second execution of a PS using a view --echo # |