Bug #8493 log-update logs create table selects twice
Submitted: 14 Feb 2005 4:54 Modified: 19 Feb 2005 13:42
Reporter: Lachlan Mulcahy Email Updates:
Status: Won't fix Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:4.1.9, 4.0.23 OS:Any (Any)
Assigned to: Guilhem Bichot CPU Architecture:Any

[14 Feb 2005 4:54] Lachlan Mulcahy 
Description:
The update log records create table selects twice.

How to repeat:
1. Add to my.cnf:

log-update=updates.log

2. Restart server.
3. 

mysql> use test;
mysql> create table a (a int);
mysql> create table b select * from a;
mysql> \q

4. shell> tail -f /path/to/datadir/updates.log

Suggested fix:
None.
[19 Feb 2005 13:42] Guilhem Bichot 
Hi Lachlan,
I'm marking it "won't fix" as the update log is already removed since MySQL 5.0.0.
If for customer reasons this really needs to be fixed (in 4.1 only, then), please feel free to re-open this bug report and then I'll fix it.