> True. But the same exact analysis also applies to this definition,
> which contains no subquery:
>
> CREATE VIEW v1 AS SELECT t1.* FROM t1, t2 WHERE t1.i = t2.i;
That's not an updatable view, thus cannot be locked according to the
proposed implementation.
Anyway do you want to allow to lock all base tables in a view
definition if the view is updatable?
Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp