Yves Goergen wrote:
> On 13.11.2007 14:01 CE(S)T, Baron Schwartz wrote:
>> It's more complicated than that. You can use them together, you just
>> have to do it like this:
>>
>> set autocommit = 0;
>> begin;
>> lock tables;
>> -- you are now in a transaction automatically begun by LOCK TABLES
>> .....
>
> I assume that at this point, any SELECT on the table I have locked
> should block. But guess what, it doesn't. So it doesn't really lock.
>
What kind of lock are you using?
-- cxn 1
set autocommit=0;
begin;
lock tables t1 write;
Query OK, 0 rows affected (6.29 sec)
-- cxn 2
set autocommit=0;
begin;
select * from t1;
-- hangs
