CREATE TEMPORARY TABLE AS SELECT causes error 1290 with read_only and InnoDB

read_only = 1;

default_tmp_storage_engine = InnoDB;

-- Log in as user with all privileges, including SUPER

SET GLOBAL read_only = on;

CREATE DATABASE mydb;

CONNECT mydb;

CREATE TABLE mytable (id INTEGER);

INSERT INTO mytable (id) VALUES (1);

-- Create user without SUPER privilege

CREATE USER 'nosuper' IDENTIFIED BY 'nosuper';

GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, CREATE TEMPORARY TABLES, LOCK TABLES ON mydb.* TO 'nosuper'@'localhost';

FLUSH PRIVILEGES;

-- Now log into mydb as 'nosuper'

SET default_tmp_storage_engine = INNODB;

CREATE TEMPORARY TABLE t1 AS SELECT id FROM mytable;

-- Error 1290

--If you do this instead, it works

CREATE TEMPORARY TABLE t1 (id INTEGER);

INSERT INTO t1 SELECT id FROM mytable;

--And both methods work if default_tmp_storage_engine = MyISAM