summaryrefslogtreecommitdiff
path: root/mysql-test/r/view.result
diff options
context:
space:
mode:
authorunknown <kent@mysql.com>2005-12-12 12:30:18 +0100
committerunknown <kent@mysql.com>2005-12-12 12:30:18 +0100
commit031ec5d2bdb28b66f0a28e5563d933b01f135858 (patch)
tree7caacde2fec98f8a5c4a9341c78c33c4142627fc /mysql-test/r/view.result
parent66583db0b0ca69460aab434cb64592c8234d109b (diff)
parente8edf40f43faa6d7011341280244f974651e87da (diff)
downloadmariadb-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.result17
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;