Bug #9453 LOCK TABLE does not do proper checking of the existence of tables except 1st

• Submitted: 29 Mar 2005 13:48
• Modified: 29 Mar 2005 15:10
• Reporter: Guilhem Bichot
• Status: Not a Bug
• Category: MySQL Server
• Severity: S3 (Non-critical)
• Version: 4.1.11
• OS: Linux (linux)
• CPU Architecture: Any

[29 Mar 2005 13:48] Guilhem Bichot

Description:
LOCK TABLE does not do proper checking of the existence of tables except for first table:
Here "m" exists but the other one does not:
SLAVE> lock table m yeah_yeah_yeah_that_s_what_I_say read;
Query OK, 0 rows affected (0.00 sec)
SLAVE> lock table yeah_yeah_yeah_that_s_what_I_say m read;
ERROR 1146 (42S02): Table 'test.yeah_yeah_yeah_that_s_what_I_say' doesn't exist
Verified in 4.0. Not tested in 5.0.

How to repeat:
see description

[29 Mar 2005 15:10] Guilhem Bichot

sorry - didn't know about the "alias" feature of LOCK TABLES.