Trigger on normal table can't insert into CONNECT engine table - Access Denied

Description

If you add an AFTER INSERT trigger on an Innodb table that simply tries to insert a record into a CONNECT table, adding a record to the Innodb table fails with:

1 Access denied for user 'root'@'localhost' (using password: YES)

Environment

CentOS7 on Google Cloud, unixODBC 2.3.1 all tested drivers

Status

Assignee

Sergei Golubchik

Reporter

Robert Dyas

Labels

External issue ID

None

External issue ID

None

Fix versions

Affects versions

10.0
10.1.11
10.1

Priority

Minor