Hi! See inline comment.
>>>>>>>>>>>> Jean T. Anderson wrote (2005-04-12 12:20:31): > This table looks like a really handy reference, so I started taking a > look at it. Regarding this item: > > >*E153* *Updatable queries with subqueries* No No > > Perhaps I'm missing the specific requirements for this item, but I think > Derby supports it. For example, the derby func tests at > https://svn.apache.org/viewcvs.cgi/*checkout*/incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/update.sql > > include these statements: > > update t1 set int_col = > (select t1.int_col > from t1, t2 > where t1.int_col = t2.int_col and t1.int_col = 1); > > update t1 set int_col = > (select > (select int_col > from t1 > where int_col = 2) > from t2 > where int_col = 1); > > Or does "Updateable queries with subqueries" mean something else? Yes, it does mean something else. It is constructs like E153 is related to expressions like select ..... where ...subquery... for update; -- Bernt Marius Johnsen, Database Technology Group, Sun Microsystems, Trondheim, Norway
