MySQL Bugs: #10693: unable to create temp table on read-only slave

Bug #10693	unable to create temp table on read-only slave
Submitted:	17 May 2005 18:34	Modified:	20 May 2005 7:43
Reporter:	Lei Pan	Email Updates:
Status:	Duplicate	Impact on me:	None
Category:	MySQL Server: Replication	Severity:	S3 (Non-critical)
Version:	4.0.22-standard-log	OS:	Linux (Linux mysql3 2.4.20-8bigmem #1 S)
Assigned to:	Assigned Account	CPU Architecture:	Any

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
Unable to create temporary table on a replicating slave when the slave is set to read-only, even though the user has create temporary table privilege. Only 'super' user can create the temp tables.

How to repeat:
logged in to slave with an non-super user account, make sure the user has create temporary table permission on a particular database, and create temporary table in that database.  You will get a read-lock error.

Verified on 4.1.11 (not sure whether this is intended or not though)

Hi,
Thank you for your bug report!
Same as http://bugs.mysql.com/bug.php?id=4544.