[MDEV-8065] create temporary table ... select ... from ... fails on read-only slave - JIRA

Details

On a read only slave, given a table "existing_table"

CREATE TEMPORARY TABLE foobar AS SELECT 1 FROM existing_table;

Error in query (1290): The MariaDB server is running with the --read-only option so it cannot execute this statement

same as in mysql #73119 apparently fixed in mysql 5.6

duplicates

MDEV-6581 Writing to TEMPORARY TABLE not possible in read-only

is duplicated by

MDEV-8270 create temporary table ... select ... from innodb_table doesn't work on read-only instances

Hide

Permalink

Elena Stepanova added a comment - 2015-04-28 14:54

It appears to be a duplicate of MDEV-6581.

Show

Elena Stepanova added a comment - 2015-04-28 14:54 It appears to be a duplicate of MDEV-6581 .