db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Mamta Satoor <msat...@gmail.com>
Subject Re: SQL-99 Core vs. Derby features
Date Wed, 13 Apr 2005 19:34:21 GMT
On 4/13/05, Bernt M. Johnsen <bernt@sun.com> wrote:
> 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
> 

Hi Brent, 

We do support select .... where...subquery....for update;

Some info on this can be found at
http://incubator.apache.org/derby/manuals/reference/sqlj35.html#HDRSII-SQLJ-31783

Mamta

Mime
View raw message