diff options
author | unknown <kent@mysql.com> | 2005-12-12 12:30:18 +0100 |
---|---|---|
committer | unknown <kent@mysql.com> | 2005-12-12 12:30:18 +0100 |
commit | 031ec5d2bdb28b66f0a28e5563d933b01f135858 (patch) | |
tree | 7caacde2fec98f8a5c4a9341c78c33c4142627fc /mysql-test/r/view.result | |
parent | 66583db0b0ca69460aab434cb64592c8234d109b (diff) | |
parent | e8edf40f43faa6d7011341280244f974651e87da (diff) | |
download | mariadb-git-031ec5d2bdb28b66f0a28e5563d933b01f135858.tar.gz |
Merge kboortz@bk-internal.mysql.com:/home/bk/mysql-5.1-new
into mysql.com:/Users/kent/mysql/bk/mysql-5.1-new
mysql-test/r/sp.result:
Auto merged
sql/sp_head.cc:
Auto merged
sql/sql_class.h:
Auto merged
Diffstat (limited to 'mysql-test/r/view.result')
-rw-r--r-- | mysql-test/r/view.result | 17 |
1 files changed, 11 insertions, 6 deletions
diff --git a/mysql-test/r/view.result b/mysql-test/r/view.result index 6eb5d895b11..f0305544eb3 100644 --- a/mysql-test/r/view.result +++ b/mysql-test/r/view.result @@ -2383,20 +2383,25 @@ CREATE TABLE t1(id INT); CREATE VIEW v1 AS SELECT id FROM t1; OPTIMIZE TABLE v1; Table Op Msg_type Msg_text -test.v1 optimize note Unknown table 'test.v1' +test.v1 optimize error 'test.v1' is not BASE TABLE +Warnings: +Error 1347 'test.v1' is not BASE TABLE ANALYZE TABLE v1; Table Op Msg_type Msg_text -test.v1 analyze note Unknown table 'test.v1' +test.v1 analyze error 'test.v1' is not BASE TABLE +Warnings: +Error 1347 'test.v1' is not BASE TABLE REPAIR TABLE v1; Table Op Msg_type Msg_text -test.v1 repair note Unknown table 'test.v1' +test.v1 repair error 'test.v1' is not BASE TABLE +Warnings: +Error 1347 'test.v1' is not BASE TABLE DROP TABLE t1; OPTIMIZE TABLE v1; Table Op Msg_type Msg_text -test.v1 optimize note Unknown table 'test.v1' +test.v1 optimize error 'test.v1' is not BASE TABLE Warnings: -Error 1146 Table 'test.t1' doesn't exist -Error 1356 View 'test.v1' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them +Error 1347 'test.v1' is not BASE TABLE DROP VIEW v1; create definer = current_user() sql security invoker view v1 as select 1; show create view v1; |