db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Christian Lang <la...@us.ibm.com>
Subject Derby fully sql-2003 compliant?
Date Thu, 01 Feb 2007 17:42:26 GMT
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?

Thanks for clarifying,
Christian

Mime
View raw message