db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jean T. Anderson" <...@bristowhill.com>
Subject Re: Derby fully sql-2003 compliant?
Date Thu, 01 Feb 2007 18:00:51 GMT
Christian Lang wrote:
> Hi,
> 
> I'm trying to understand which SQL language subset Derby is using. I 
...

The Derby Wiki has a page that provides details about SQL support:

   http://wiki.apache.org/db-derby/SQLvsDerbyFeatures

There's also a page that provides JDBC details:

   http://wiki.apache.org/db-derby/JDBCSupport

regards,

 -jean


> 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?
> 
> Thanks for clarifying,
> Christian
> 


Mime
View raw message