At 19:52 +0000 12/9/02, [EMAIL PROTECTED] wrote:
Hi All,I may be confused here but it would appear that when you issue a LOCK TABLES tbl_name { READ|WRITE }; You cannot read from another unlocked table in the same connection eg:
You're supposed to lock all the tables that you'll need until you issue the UNLOCK TABLES statement. Not just some of them.
mysql> LOCK TABLES users read; Query OK, 0 rows affected (0.00 sec) mysql> select * from Logger limit 1; ERROR 1100: Table 'Logger' was not locked with LOCK TABLES I've read section 6.7.2 of the Manual: http://www.mysql.com/documentation/mysql/bychapter/index.html#LOCK_TABLES This is on 3.23.43. I assume this is expected behaviour? Although at the moment it seems a little odd that this thread cannot read from another (unlocked) table whilst it has a lock. Does anyone have a solution that I may be missing? We are locking tables to do a "fake" transaction so that we can update a number of tables without interference from other threads. Thanks for any replies. Greg Cope JITC
--------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
