Return-Path: Delivered-To: apmail-db-derby-dev-archive@www.apache.org Received: (qmail 61143 invoked from network); 1 Feb 2007 18:46:03 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 1 Feb 2007 18:46:03 -0000 Received: (qmail 62437 invoked by uid 500); 1 Feb 2007 18:46:02 -0000 Delivered-To: apmail-db-derby-dev-archive@db.apache.org Received: (qmail 62406 invoked by uid 500); 1 Feb 2007 18:46:02 -0000 Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: Delivered-To: mailing list derby-dev@db.apache.org Received: (qmail 62387 invoked by uid 99); 1 Feb 2007 18:46:02 -0000 Received: from herse.apache.org (HELO herse.apache.org) (140.211.11.133) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 01 Feb 2007 10:46:02 -0800 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests=UNPARSEABLE_RELAY X-Spam-Check-By: apache.org Received-SPF: pass (herse.apache.org: local policy) Received: from [192.18.1.36] (HELO gmp-ea-fw-1.sun.com) (192.18.1.36) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 01 Feb 2007 10:45:52 -0800 Received: from d1-emea-09.sun.com ([192.18.2.119]) by gmp-ea-fw-1.sun.com (8.13.6+Sun/8.12.9) with ESMTP id l11IjTC6026408; Thu, 1 Feb 2007 18:45:30 GMT Received: from conversion-daemon.d1-emea-09.sun.com by d1-emea-09.sun.com (Sun Java System Messaging Server 6.2-6.01 (built Apr 3 2006)) id <0JCS00401S3H9600@d1-emea-09.sun.com> (original mail from Bernt.Johnsen@Sun.COM); Thu, 01 Feb 2007 18:45:29 +0000 (GMT) Received: from localhost (84.84-48-48.nextgentel.com [84.48.48.84]) by d1-emea-09.sun.com (Sun Java System Messaging Server 6.2-6.01 (built Apr 3 2006)) with ESMTPSA id <0JCS007NZS3SEB10@d1-emea-09.sun.com>; Thu, 01 Feb 2007 18:45:29 +0000 (GMT) Date: Thu, 01 Feb 2007 19:45:26 +0100 From: "Bernt M. Johnsen" Subject: Re: Derby fully sql-2003 compliant? In-reply-to: Sender: Bernt.Johnsen@Sun.COM To: derby-dev@db.apache.org Cc: Derby Discussion Message-id: <20070201184526.GA29223@localhost.localdomain> Organization: Sun Microsystems MIME-version: 1.0 Content-type: multipart/signed; boundary=IJpNTDwzlM2Ie8A6; protocol="application/pgp-signature"; micalg=pgp-sha1 Content-disposition: inline References: User-Agent: Mutt/1.5.9i X-Virus-Checked: Checked by ClamAV on apache.org --IJpNTDwzlM2Ie8A6 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable >>>>>>>>>>>> Dyre.Tjeldvoll@Sun.COM wrote (2007-02-01 19:15:16): > Christian Lang writes: >=20 > > Hi, > > > > I'm trying to understand which SQL language subset Derby is using. I=20 > > installed version 10.2.2.0 and tried to compile and execute the followi= ng=20 > > statement: > > > > SELECT MIN(A) OVER (PARTITION BY B) FROM C; > > > > (which seems a legal SQL-2003 statement). However, the Derby sql compil= er=20 > > complains about the '(' after the 'OVER' keyword. > > I looked into the sqlgrammar.jj file and could not find a "partition" o= r=20 > > "over" keyword at all. Is this not supported (yet)? > > Or am I doing something wrong? >=20 > I don't find anything about this on > http://wiki.apache.org/db-derby/SQLvsDerbyFeatures >=20 > so either it is completely over-looked, or it isn't required. It is in section 7.11 in the 2003 standard Tis is optional feature "T612 Advanced OLAP operations" which is not implemented in Derby --=20 Bernt Marius Johnsen, Database Technology Group,=20 Staff Engineer, Technical Lead Derby/Java DB Sun Microsystems, Trondheim, Norway --IJpNTDwzlM2Ie8A6 Content-Type: application/pgp-signature; name="signature.asc" Content-Description: Digital signature Content-Disposition: inline -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.1 (GNU/Linux) iD8DBQFFwjVGlFBD9TXBAPARAhwFAJ9lPFShbnLJHJP6hM4jcM5Yg53DEACgxOE3 sCIKPCHx0NTZcOGmnEmF0rY= =3GuP -----END PGP SIGNATURE----- --IJpNTDwzlM2Ie8A6--