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.
|