Archives of the TeradataForum
Message Posted: Wed, 18 Feb 2009 @ 20:57:29 GMT
| Subj: || || Re: Views and locking |
| From: || || Anomy Anom |
<-- Anonymously Posted: Wed, 18 Feb 2009 15:49 -->
Long ago, if you specified LOCK ROW ACCESS but a table-level lock was required, Teradata would use LOCK TABLE READ. That has been fixed; LOCK
ROW ACCESS results in table READ locks also being downgraded to ACCESS.
The problem Kiki referenced (which still exists) has to do with explicit LOCK modifiers in multi-statement requests. In particular, LOCK ROW is
honored only if it appears within the last statement in the request.