db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Bernt M. Johnsen" <be...@sun.com>
Subject Re: SQL-99 Core vs. Derby features
Date Wed, 13 Apr 2005 09:43:14 GMT
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

Mime
View raw message