db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Dyre.Tjeldv...@Sun.COM
Subject Re: Derby fully sql-2003 compliant?
Date Thu, 01 Feb 2007 18:15:16 GMT
Christian Lang <langc@us.ibm.com> writes:

> Hi,
>
> I'm trying to understand which SQL language subset Derby is using. I 
> installed version 10.2.2.0 and tried to compile and execute the following 
> statement:
>
>         SELECT MIN(A) OVER (PARTITION BY B) FROM C;
>
> (which seems a legal SQL-2003 statement). However, the Derby sql compiler 
> complains about the '(' after the 'OVER' keyword.
> I looked into the sqlgrammar.jj file and could not find a "partition" or 
> "over" keyword at all. Is this not supported (yet)?
> Or am I doing something wrong?

I don't find anything about this on
http://wiki.apache.org/db-derby/SQLvsDerbyFeatures

so either it is completely over-looked, or it isn't required.

-- 
dt


Mime
View raw message