From 4fbba0982436aa871b57facc008a18527c10aacc Mon Sep 17 00:00:00 2001 From: =?UTF-8?q?Vicen=C8=9Biu=20Ciorbaru?= Date: Sat, 21 Mar 2015 19:54:06 +0200 Subject: MDEV-7813 analyze_stmt fails with --embedded flag set Moved the privilege checking code which does not apply for embedded to a separate test case. --- mysql-test/t/analyze_stmt.test | 47 ------------------------------------------ 1 file changed, 47 deletions(-) (limited to 'mysql-test/t/analyze_stmt.test') diff --git a/mysql-test/t/analyze_stmt.test b/mysql-test/t/analyze_stmt.test index 87b1616c816..0355b4e4e0f 100644 --- a/mysql-test/t/analyze_stmt.test +++ b/mysql-test/t/analyze_stmt.test @@ -258,50 +258,3 @@ insert into t2 values (0),(1); analyze select * from t1 straight_join t2 force index(a) where t2.a=t1.a; drop table t1,t2; - -# Analyze privilege checks testcase. ---echo # ---echo # MDEV-7025 and MDEV-7027 ANALYZE SELECT/INSERT/UPDATE/DELETE from a ---echo # view does not check access permissions on the underlying table ---echo # ---enable_connect_log -create database db; -use db; -create table t1 (i int, c varchar(8)); -insert into t1 values (1,'foo'),(2,'bar'),(3,'baz'),(4,'qux'); -create view v1 as select * from t1 where i > 1; -grant ALL on db.v1 to u1@localhost; - ---connect (con1,localhost,u1,,) - ---error ER_TABLEACCESS_DENIED_ERROR -select * from db.t1; ---error ER_TABLEACCESS_DENIED_ERROR -explain select * from db.t1; ---error ER_TABLEACCESS_DENIED_ERROR -analyze select * from db.t1; - -select * from db.v1; ---error ER_VIEW_NO_EXPLAIN -explain select * from db.v1; ---error ER_VIEW_NO_EXPLAIN -analyze select * from db.v1; - -UPDATE db.v1 SET i = 5; ---error ER_VIEW_NO_EXPLAIN -explain UPDATE db.v1 SET i = 5; ---error ER_VIEW_NO_EXPLAIN -analyze UPDATE db.v1 SET i = 5; - -DELETE FROM db.v1 WHERE i = 5; ---error ER_VIEW_NO_EXPLAIN -explain DELETE FROM db.v1 WHERE i = 5; ---error ER_VIEW_NO_EXPLAIN -analyze DELETE FROM db.v1 WHERE i = 5; - - ---disconnect con1 ---connection default - -drop user u1@localhost; -drop database db; -- cgit v1.2.1