title: A suspended transaction release the "select for update" lock?
body: <pre><code>Transaction A(PROPAGATION_REQUIRED) {
  
     lock = "select * from lock_table while id = 1 for update"      
     Method son(){
         Transaction B(PROPAGATION_REQUIRES_NEW){}         
     }
  }
  </code></pre>
  
  <p>I know that PROPAGATION_REQUIRES_NEW will suspend the current transaction (if one exists) and start a new one, which means Transaction A will be suspended. 
  <p>
  <strong>But would Transaction A release the "select for update" lock when it is  suspended? Could other thread get the lock when Transaction A is suspended?</strong> </p>
  
  <p>Thank You!</p>