| 1 |
source include/federated.inc; |
| 2 |
source have_federatedx.inc; |
| 3 |
|
| 4 |
--echo # |
| 5 |
--echo # MDEV-32984 Update federated table and column privileges |
| 6 |
--echo # |
| 7 |
connection slave; |
| 8 |
create database db1; |
| 9 |
create user my@localhost identified by '1qaz2wsx'; |
| 10 |
create table db1.t1 ( |
| 11 |
f1 int auto_increment primary key, |
| 12 |
f2 varchar(50), |
| 13 |
f3 varchar(50), |
| 14 |
unique (f2) |
| 15 |
); |
| 16 |
grant insert, select (f1, f2, f3), update (f3) on db1.t1 to my@localhost; |
| 17 |
|
| 18 |
connection master; |
| 19 |
evalp create table tt1 engine=federated connection='mysql://my:1qaz2wsx@localhost:$SLAVE_MYPORT/db1/t1'; |
| 20 |
insert into tt1 (f2,f3) values ('test','123'); |
| 21 |
select * from tt1; |
| 22 |
update tt1 set f3='123456' where f2='test'; |
| 23 |
|
| 24 |
drop table tt1; |
| 25 |
|
| 26 |
connection slave; |
| 27 |
drop database db1; |
| 28 |
drop user my@localhost; |
| 29 |
|
| 30 |
source include/federated_cleanup.inc; |
| 31 |
|
| 32 |
|