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 y

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

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