mariadb/storage/connect/mysql-test/connect/r/grant3.result
Sergei Golubchik 4995bcffad MDEV-9610 Trigger on normal table can't insert into CONNECT engine table - Access Denied
in case of prelocking, don't check table->grant.privilege
in handler::external_lock(), do it in
handler::start_stmt().
2016-04-26 21:03:40 +02:00

5 lines
237 B
Text

create table tcon (i int) engine=Connect table_type=DOS file_name='tcon.dos';
create table tin (i int);
create trigger tr after insert on tin for each row insert into tcon values (new.i);
insert into tin values (1);
drop table tin,tcon;