diff options
| author | unknown <gkodinov/kgeorge@macbook.local> | 2007-09-24 10:30:50 +0200 |
|---|---|---|
| committer | unknown <gkodinov/kgeorge@macbook.local> | 2007-09-24 10:30:50 +0200 |
| commit | ea1a4ae287f0ecb62fc45955d117b1e30bcbf38f (patch) | |
| tree | 05ff4af64a4fc7aea69b1d386b670bec494353c6 /mysql-test/t/view.test | |
| parent | bd8e7fee1f260b6f5b9b39c67bb6e701eace3cae (diff) | |
| parent | 053907318516bb8d25f5ae8cb0367d1ebd327158 (diff) | |
| download | mariadb-git-ea1a4ae287f0ecb62fc45955d117b1e30bcbf38f.tar.gz | |
merge of bug 28701 5.0-opt -> 5.1-opt
sql/sql_view.cc:
Auto merged
Diffstat (limited to 'mysql-test/t/view.test')
| -rw-r--r-- | mysql-test/t/view.test | 20 |
1 files changed, 19 insertions, 1 deletions
diff --git a/mysql-test/t/view.test b/mysql-test/t/view.test index 67354c14cff..341a17eb291 100644 --- a/mysql-test/t/view.test +++ b/mysql-test/t/view.test @@ -510,7 +510,7 @@ drop table t1; # create table t1 (a int, b int); create view v1 as select a, sum(b) from t1 group by a; --- error 1176 +--error ER_WRONG_USAGE select b from v1 use index (some_index) where b=1; drop view v1; drop table t1; @@ -3415,6 +3415,24 @@ select table_name, is_updatable from information_schema.views drop view v1; drop table t1; +# +# Bug #28701: SELECTs from VIEWs completely ignore USE/FORCE KEY, allowing +# invalid statements +# + +CREATE TABLE t1 (a INT); +INSERT INTO t1 VALUES (1),(2); +CREATE VIEW v1 AS SELECT * FROM t1; +--error ER_WRONG_USAGE +SELECT * FROM v1 USE KEY(non_existant); +--error ER_WRONG_USAGE +SELECT * FROM v1 FORCE KEY(non_existant); +--error ER_WRONG_USAGE +SELECT * FROM v1 IGNORE KEY(non_existant); + +DROP VIEW v1; +DROP TABLE t1; + --echo End of 5.0 tests. # |