[MDEV-8065] create temporary table ... select ... from ... fails on read-only slave Created: 2015-04-28  Updated: 2015-06-05  Resolved: 2015-04-28

Status: Closed
Project: MariaDB Server
Component/s: Data Definition - Temporary
Affects Version/s: 10.0.17-galera
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Mathieu Rochette Assignee: Unassigned
Resolution: Duplicate Votes: 0
Labels: None

Issue Links:
Duplicate
duplicates MDEV-6581 Writing to TEMPORARY TABLE not possib... Closed
is duplicated by MDEV-8270 create temporary table ... select ...... Closed

 Description   

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



 Comments   
Comment by Elena Stepanova [ 2015-04-28 ]

It appears to be a duplicate of MDEV-6581.

Generated at Thu Feb 08 07:24:22 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.