Re: Derby fully sql-2003 compliant?

2007-02-01 Thread Bernt M. Johnsen
[EMAIL PROTECTED] wrote (2007-02-01 19:15:16): > Christian Lang <[EMAIL PROTECTED]> 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: > > > >

Re: Derby fully sql-2003 compliant?

2007-02-01 Thread Dyre . Tjeldvoll
Christian Lang <[EMAIL PROTECTED]> 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-

Derby fully sql-2003 compliant?

2007-02-01 Thread Christian Lang
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