LOCK problem with SELECT table alias

2003-01-05 Thread ck
Description: A SELECT statement fails if you have table aliases and use table locking with the LOCK command How-To-Repeat: DROP TABLE IF EXISTS CK1; CREATE TABLE CK1 ( ID INT UNSIGNED NOT NULL, PRIMARY KEY(ID) ); LOCK TABLES CK1

Re: Re: LOCK problem with SELECT table alias

2003-01-05 Thread Paul DuBois
At 14:45 +0100 1/5/03, [EMAIL PROTECTED] wrote: Description: A SELECT statement fails if you have table aliases and use table locking with the LOCK command This is not a bug. It's documented in the manual that you must lock all the tables at once that you intend to use, *including* locking

Re: LOCK problem with SELECT table alias

2003-01-05 Thread Christian Kohlschuetter
Am Sonntag, 5. Januar 2003 19:29 schrieb Paul DuBois: At 14:45 +0100 1/5/03, [EMAIL PROTECTED] wrote: Description: A SELECT statement fails if you have table aliases and use table locking with the LOCK command This is not a bug. It's documented in the manual that you must