It is not a bug. As soon as Computer1 releases the lock, Computer2 will have its query processed. Never write a program that keeps a lock for more than a few miliseconds.
Eric Cotting wrote: > MYSQL Server: 3.23.49a-log > MYSQL Client: 3.23.3 alpha > MYSQLGUI: 1.7.5 > Operating System: Windows NT, Windows 2000 > > When I place a table lock on a table with one computer and issue a > query on another while the lock is in affect, the computer that issues > the query halts execution of the query with no error message or > trace. I have tired this both in by VB6 application and using the > MYSQLGui. I have tried to test the data base for the presence of a > lock by issuing the SHOW TABLE STATUS command. This aslo halted my > MYSQLGUI. Is this a known bug or is there any way to determine if a > table has been locked without encountering the bug? > Computer 1 :LOCK TABLES Customer_IDs WRITE > > Computer 2: SELECT * FROM Customer_IDs > Halted Program > Computer 2: SHOW TABLE STATUS FROM Customer Halted > Program > > Eric Cotting > FGL Environmental > 805-659-0910 > > > > --------------------------------------------------------------------- > 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 > > --------------------------------------------------------------------- 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
