Adding upstream version 1:10.11.6.upstream/1%10.11.6upstream

Signed-off-by: Daniel Baumann <daniel.baumann@progress-linux.org>

1 files changed, 51 insertions, 0 deletions

diff --git a/mysql-test/main/partition_grant.result b/mysql-test/main/partition_grant.result
new file mode 100644
index 00000000..c2698969
--- /dev/null
+++ b/mysql-test/main/partition_grant.result
@@ -0,0 +1,51 @@
+drop schema if exists mysqltest_1;
+create schema mysqltest_1;
+use mysqltest_1;
+create table t1 (a int) partition by list (a) (partition p1 values in (1), partition p2 values in (2), partition p3 values in (3));
+insert into t1 values (1),(2);
+create user mysqltest_1@localhost;
+grant usage on *.* to mysqltest_1@localhost;
+revoke all privileges on *.* from mysqltest_1@localhost;
+grant select,alter on mysqltest_1.* to mysqltest_1@localhost;
+connect  conn1,localhost,mysqltest_1,,mysqltest_1;
+show grants for current_user;
+Grants for mysqltest_1@localhost
+GRANT USAGE ON *.* TO `mysqltest_1`@`localhost`
+GRANT SELECT, ALTER ON `mysqltest_1`.* TO `mysqltest_1`@`localhost`
+alter table t1 add b int;
+alter table t1 drop partition p2;
+ERROR 42000: DROP command denied to user 'mysqltest_1'@'localhost' for table `mysqltest_1`.`t1`
+disconnect conn1;
+connection default;
+grant drop on mysqltest_1.* to mysqltest_1@localhost;
+connect  conn2,localhost,mysqltest_1,,mysqltest_1;
+alter table t1 drop partition p2;
+disconnect conn2;
+connection default;
+revoke alter on mysqltest_1.* from mysqltest_1@localhost;
+connect  conn3,localhost,mysqltest_1,,mysqltest_1;
+alter table t1 drop partition p3;
+ERROR 42000: ALTER command denied to user 'mysqltest_1'@'localhost' for table `mysqltest_1`.`t1`
+disconnect conn3;
+connection default;
+revoke select,alter,drop on mysqltest_1.* from mysqltest_1@localhost;
+drop table t1;
+create table t1 (s1 int);
+insert into t1 values (1);
+grant alter on mysqltest_1.* to mysqltest_1@localhost;
+connect  conn4,localhost,mysqltest_1,,mysqltest_1;
+connection conn4;
+alter table t1 partition by list (s1) (partition p1 values in (2));
+ERROR HY000: Table has no partition for some existing values
+connection default;
+grant select, alter on mysqltest_1.* to mysqltest_1@localhost;
+disconnect conn4;
+connect  conn5,localhost,mysqltest_1,,mysqltest_1;
+alter table t1 partition by list (s1) (partition p1 values in (2));
+ERROR HY000: Table has no partition for value 1
+disconnect conn5;
+connection default;
+drop table t1;
+drop user mysqltest_1@localhost;
+drop schema mysqltest_1;
+End of 5.1 tests