Bug #9123 mysqldump database member_opinion
Submitted: 11 Mar 2005 10:33 Modified: 17 Mar 2005 17:33
Reporter: Bernhard Graf
Status: Closed
Category:Client Severity:S3 (Non-critical)
Version:4.1.10 OS:Linux (Linux (presumably all))
Assigned to: Lars Thalmann Target Version:

[11 Mar 2005 10:33] Bernhard Graf 
Description:
Seems mysqldump regards '_' (and '%') as wildcards - but not always, as we can see with
the "LOCK TABLES" error described in "How to repeat".

BTW: This error is not present in MySQL 3.23.52 and presumably in other older version.

How to repeat:
have two tables

	member_opinion
and
	member2opinion

try to dump the first one:

	mysqldump database member_opinion

says

	mysqldump: mysqldump: Couldn't execute 'show create table `member2opinion`': Table
'member2opinion' was not locked with LOCK TABLES (1100)

Suggested fix:
don't apply SQL wildcards on table names
[15 Mar 2005 16:23] Bugs System 
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/internals/23042
[16 Mar 2005 13:48] Bugs System 
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/internals/23086
[16 Mar 2005 14:16] Lars Thalmann 
Thank you for your bug report. This issue has been committed to our
source repository of that product and will be incorporated into the
next release.

If necessary, you can access the source repository and build the latest
available version, including the bugfix, yourself. More information 
about accessing the source trees is available at
    http://www.mysql.com/doc/en/Installing_source_tree.html

Additional info:

Will be part of 4.1.11 and 5.0.3 releases.
[16 Mar 2005 21:57] Bugs System 
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/internals/23112
[17 Mar 2005 14:00] Lars Thalmann 
Should be added to documentation too...
[17 Mar 2005 17:33] Paul DuBois 
Noted in 4.1.11, 5.0.3 changelogs.