MDEV-7813 analyze_stmt fails with --embedded flag set10.1-MDEV-7813

Moved the privilege checking code which does not apply for embedded
to a separate test case.

1 files changed, 0 insertions, 47 deletions

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 <statement> 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;