Bug #33721 UPDATE of temp table, fails if log-bin is on
Submitted: 7 Jan 2008 14:10 Modified: 9 Apr 2008 17:06
Reporter: Magnus Blåudd Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Server: General Severity:S3 (Non-critical)
Version:5.1.23 OS:Any
Assigned to: CPU Architecture:Any

[7 Jan 2008 14:10] Magnus Blåudd 
Description:
When runnin mysqld with binlog turned off it will allow update of a temporary table. But then the binlog is used, the same update will fails with the message saying "1290: The MySQL server is running with the --read-only option so it cannot execute this statement"

How to repeat:
The current version of mysql-test-run.pl turns off log bin for any test case that does not use it, thus it's not possible to repeat without commenting one line in lib/mtr_cases.pl

msvensson@localhost:~/mysql/mysql-5.1-rpl/mysql-test$ bk diffs -u lib/*
===== lib/mtr_cases.pl 1.80 vs edited =====
--- 1.80/mysql-test/lib/mtr_cases.pl    2007-11-29 12:23:16 +01:00
+++ edited/lib/mtr_cases.pl     2008-01-07 15:08:25 +01:00
@@ -862,7 +862,7 @@ sub collect_one_test_case($$$$$$$$$) {
       {
        # Test does not need binlog, add --skip-binlog to
        # the options used when starting it
-       push(@{$tinfo->{'master_opt'}}, "--skip-log-bin");
+#      push(@{$tinfo->{'master_opt'}}, "--skip-log-bin");
       }
     }

Then run the failing 
./mtr read_only_bug --mysqld=--log-bin
and the working
./mtr read_only_bug
[7 Jan 2008 14:11] Magnus Blåudd 
Test case

Attachment: read_only_bug.test (application/octet-stream, text), 908 bytes.
[7 Jan 2008 14:12] Magnus Blåudd 
Result file

Attachment: read_only_bug.result (application/octet-stream, text), 511 bytes.
[7 Jan 2008 14:13] Magnus Blåudd 
The working way should be with log-bin turned off, like this:
./mtr read_only_bug --mysqld=--skip-log-bin
[23 Jan 2008 11:54] Sveta Smirnova 
Thank you for the report.

Verified as described.
[8 Apr 2008 13:52] Magnus Blåudd 
Not a test failure
[8 Apr 2008 14:44] Trudy Pelzer 
Please re-verify; this may have been fixed by
the patch for bug#35762. Thanks.
[9 Apr 2008 17:06] Sveta Smirnova 
Bug is not repeatable with current sources.