can't update temporary table when joined with table with triggers on read-only

## As root user with SUPER privilege run the following:

CREATE TABLE table1(

	`id` INT NOT NULL,

	`name` VARCHAR(10) NOT NULL

);

CREATE TABLE log1(

	info VARCHAR(10) NOT NULL

);

SET GLOBAL read_only=1;

## Insert some fake data

## Then as another user that has basic privileges but not the SUPER privilege run the following:

CREATE TEMPORARY TABLE TEMP_TABLE1 (

	`id` INT NOT NULL,

	`update_me` VARCHAR(10)

);

UPDATE TEMP_TABLE1 LEFT JOIN table1 ON TEMP_TABLE1.id = table1.id SET TEMP_TABLE1.update_me = 'hello';

## you should get an error complaining that it is running with the --read-only option