Hi:
    I tried to get a S-lock using following SQL:
   1. start transaction;
      SELECT * FROM test.t1 where id=1;
    But I found this way does not work. I changed it as following:
    2. start transaction;
        SELECT * FROM test.t1 where id=1 lock in share mode;


I am wondering why the first way does not get a S lock?

Reply via email to