Debian Codegraph @

mysql-test/suite/federated/update.test

raw
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