You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by Christian Lang <la...@us.ibm.com> on 2007/02/01 18:42:26 UTC
Derby fully sql-2003 compliant?
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
Re: Derby fully sql-2003 compliant?
Posted by "Jean T. Anderson" <jt...@bristowhill.com>.
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
>
Re: Derby fully sql-2003 compliant?
Posted by "Bernt M. Johnsen" <Be...@Sun.COM>.
>>>>>>>>>>>> Dyre.Tjeldvoll@Sun.COM wrote (2007-02-01 19:15:16):
> Christian Lang <la...@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.
It is in section 7.11 <window clause> in the 2003 standard
Tis is optional feature "T612 Advanced OLAP operations" which is not
implemented in Derby
--
Bernt Marius Johnsen, Database Technology Group,
Staff Engineer, Technical Lead Derby/Java DB
Sun Microsystems, Trondheim, Norway
Re: Derby fully sql-2003 compliant?
Posted by "Bernt M. Johnsen" <Be...@Sun.COM>.
>>>>>>>>>>>> Dyre.Tjeldvoll@Sun.COM wrote (2007-02-01 19:15:16):
> Christian Lang <la...@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.
It is in section 7.11 <window clause> in the 2003 standard
Tis is optional feature "T612 Advanced OLAP operations" which is not
implemented in Derby
--
Bernt Marius Johnsen, Database Technology Group,
Staff Engineer, Technical Lead Derby/Java DB
Sun Microsystems, Trondheim, Norway
Re: Derby fully sql-2003 compliant?
Posted by Dy...@Sun.COM.
Christian Lang <la...@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
Re: Derby fully sql-2003 compliant?
Posted by Dy...@Sun.COM.
Christian Lang <la...@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