Return-Path: 
 <jdo-dev-return-2574-apmail-db-jdo-dev-archive=www.apache.org@db.apache.org>
Delivered-To: apmail-db-jdo-dev-archive@www.apache.org
Received: (qmail 34416 invoked from network); 19 Dec 2005 19:25:41 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199)
  by minotaur.apache.org with SMTP; 19 Dec 2005 19:25:41 -0000
Received: (qmail 6168 invoked by uid 500); 19 Dec 2005 19:25:40 -0000
Mailing-List: contact jdo-dev-help@db.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:jdo-dev-help@db.apache.org>
List-Unsubscribe: <mailto:jdo-dev-unsubscribe@db.apache.org>
List-Post: <mailto:jdo-dev@db.apache.org>
List-Id: <jdo-dev.db.apache.org>
Reply-To: jdo-dev@db.apache.org
Delivered-To: mailing list jdo-dev@db.apache.org
Received: (qmail 6157 invoked by uid 99); 19 Dec 2005 19:25:40 -0000
Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49)
    by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 19 Dec 2005 11:25:40 -0800
X-ASF-Spam-Status: No, hits=0.0 required=10.0
	tests=HTML_MESSAGE,UNPARSEABLE_RELAY
X-Spam-Check-By: apache.org
Received-SPF: pass (asf.osuosl.org: local policy)
Received: from [192.18.98.34] (HELO brmea-mail-3.sun.com) (192.18.98.34)
    by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 19 Dec 2005 11:25:38 -0800
Received: from fe-amer-04.sun.com ([192.18.108.178])
	by brmea-mail-3.sun.com (8.12.10/8.12.9) with ESMTP id jBJJPI3F026188
	for <jdo-dev@db.apache.org>; Mon, 19 Dec 2005 12:25:18 -0700 (MST)
Received: from conversion-daemon.mail-amer.sun.com by mail-amer.sun.com
 (Sun Java System Messaging Server 6.2-4.02 (built Sep  9 2005))
 id <0IRR00L01F2DQU00@mail-amer.sun.com>
 (original mail from Craig.Russell@Sun.COM) for jdo-dev@db.apache.org; Mon,
 19 Dec 2005 12:25:18 -0700 (MST)
Received: from [129.145.133.145] by mail-amer.sun.com
 (Sun Java System Messaging Server 6.2-4.02 (built Sep  9 2005))
 with ESMTPSA id <0IRR00NR0FA50720@mail-amer.sun.com> for
 jdo-dev@db.apache.org; Mon, 19 Dec 2005 12:25:18 -0700 (MST)
Date: Mon, 19 Dec 2005 11:25:14 -0800
From: Craig L Russell <Craig.Russell@Sun.COM>
Subject: Issue 149: Restrictions on Ordering expression used with Grouping
Sender: Craig.Russell@Sun.COM
To: JDO Expert Group <jdo-experts-ext@Sun.COM>,
        Apache JDO project <jdo-dev@db.apache.org>
Message-id: <21E103A9-F8B5-4979-9565-71F6DF3E9B91@Sun.COM>
MIME-version: 1.0
X-Mailer: Apple Mail (2.746.2)
Content-type: multipart/signed; protocol="application/pkcs7-signature";
 boundary=Apple-Mail-27--53190834; micalg=sha1
X-Virus-Checked: Checked by ClamAV on apache.org
X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N

--Apple-Mail-27--53190834
Content-Type: multipart/alternative;
	boundary=Apple-Mail-26--53191331


--Apple-Mail-26--53191331
Content-Transfer-Encoding: 7bit
Content-Type: text/plain;
	charset=US-ASCII;
	delsp=yes;
	format=flowed

Javadogs,

See JIRA issue JDO-243 http://issues.apache.org/jira/browse/JDO-243? 
page=all
Ordering should have the same restrictions as for the Select clause.  
That is, if grouping is used, only expressions in the Grouping clause  
and aggregate expressions can be in the Ordering clause.
The JDO implementation is not permitted to modify the Select clause,  
the Grouping clause, or the Ordering clause. These are user-visible  
and should not be changed by the implementation.
However, the JDO implementation is required to construct valid SQL if  
the query is being used with a relational datastore. This means that  
the SQL SELECT might need to have expressions added to the user's  
Select clause to include expressions in the Grouping and Ordering  
clauses.
Today in the specification there are restrictions on the expressions  
that can be used in the Select clause if there is a Grouping clause:
<spec 14.6.10>
Only expressions in the Grouping clause and aggregate expressions can  
be in the Select clause.
</spec 14.6.10>
A similar restriction is needed for the Ordering clause.
<proposed>
Only expressions in the Grouping clause and aggregate expressions can  
be in the Ordering clause.
</proposed>

Craig Russell
Architect, Sun Java Enterprise System http://java.sun.com/products/jdo
408 276-5638 mailto:Craig.Russell@sun.com
P.S. A good JDO? O, Gasp!


--Apple-Mail-26--53191331
Content-Transfer-Encoding: quoted-printable
Content-Type: text/html;
	charset=ISO-8859-1

<HTML><BODY style=3D"word-wrap: break-word; -khtml-nbsp-mode: space; =
-khtml-line-break: after-white-space; ">Javadogs,<DIV><BR =
class=3D"khtml-block-placeholder"></DIV><DIV style=3D"margin-top: 0px; =
margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><FONT =
class=3D"Apple-style-span" face=3D"Palatino">See JIRA issue JDO-243 =
</FONT><A =
href=3D"http://issues.apache.org/jira/browse/JDO-243?page=3Dall"><FONT =
class=3D"Apple-style-span" face=3D"Palatino"><FONT =
class=3D"Apple-style-span" =
color=3D"#000080">http://issues.apache.org/jira/browse/JDO-243?page=3Dall<=
/FONT></FONT></A></DIV><DIV style=3D"margin-top: 0px; margin-right: 0px; =
margin-bottom: 0px; margin-left: 0px; "><FONT class=3D"Apple-style-span" =
face=3D"Palatino">Ordering should have the same restrictions as for the =
Select clause. That is, if grouping is used, only expressions in the =
Grouping clause and aggregate expressions can be in the Ordering =
clause.</FONT></DIV><DIV style=3D"margin-top: 0px; margin-right: 0px; =
margin-bottom: 0px; margin-left: 0px; "><FONT class=3D"Apple-style-span" =
face=3D"Palatino">The JDO implementation is not permitted to modify the =
Select clause, the Grouping clause, or the Ordering clause. These are =
user-visible and should not be changed by the =
implementation.</FONT></DIV><DIV style=3D"margin-top: 0px; margin-right: =
0px; margin-bottom: 0px; margin-left: 0px; "><FONT =
class=3D"Apple-style-span" face=3D"Palatino">However, the JDO =
implementation is required to construct valid SQL if the query is being =
used with a relational datastore. This means that the SQL SELECT might =
need to have expressions added to the user's Select clause to include =
expressions in the Grouping and Ordering clauses.</FONT></DIV><DIV =
style=3D"margin-top: 0px; margin-right: 0px; margin-bottom: 0px; =
margin-left: 0px; "><FONT class=3D"Apple-style-span" =
face=3D"Palatino">Today in the specification there are restrictions on =
the expressions that can be used in the Select clause if there is a =
Grouping clause:</FONT></DIV><DIV style=3D"margin-top: 0px; =
margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><FONT =
class=3D"Apple-style-span" face=3D"Palatino">&lt;spec =
14.6.10&gt;<BR></FONT><FONT class=3D"Apple-style-span" face=3D"Palatino"> =
Only expressions in the Grouping clause and aggregate expressions can be =
in the Select clause. <BR></FONT><FONT class=3D"Apple-style-span" =
face=3D"Palatino"> &lt;/spec 14.6.10&gt;</FONT></DIV><DIV =
style=3D"margin-top: 0px; margin-right: 0px; margin-bottom: 0px; =
margin-left: 0px; "><FONT class=3D"Apple-style-span" face=3D"Palatino">A =
similar restriction is needed for the Ordering clause.</FONT><FONT =
class=3D"Apple-style-span" face=3D"Palatino">=A0</FONT></DIV><DIV =
style=3D"margin-top: 0px; margin-right: 0px; margin-bottom: 0px; =
margin-left: 0px; "><FONT class=3D"Apple-style-span" =
face=3D"Palatino">&lt;proposed&gt;<BR></FONT><FONT =
class=3D"Apple-style-span" face=3D"Palatino"> Only expressions in the =
Grouping clause and aggregate expressions can be in the Ordering =
clause.<BR></FONT><FONT class=3D"Apple-style-span" face=3D"Palatino"> =
&lt;/proposed&gt;</FONT></DIV><DIV><BR><DIV> <P style=3D"margin: 0.0px =
0.0px 0.0px 0.0px"><FONT face=3D"Helvetica" size=3D"3" style=3D"font: =
12.0px Helvetica">Craig Russell</FONT></P> <P style=3D"margin: 0.0px =
0.0px 0.0px 0.0px"><FONT face=3D"Helvetica" size=3D"3" style=3D"font: =
12.0px Helvetica">Architect, Sun Java Enterprise System <A =
href=3D"http://java.sun.com/products/jdo">http://java.sun.com/products/jdo=
</A></FONT></P> <P style=3D"margin: 0.0px 0.0px 0.0px 0.0px"><FONT =
face=3D"Helvetica" size=3D"3" style=3D"font: 12.0px Helvetica">408 =
276-5638 <A =
href=3D"mailto:Craig.Russell@sun.com">mailto:Craig.Russell@sun.com</A></FO=
NT></P> <P style=3D"margin: 0.0px 0.0px 0.0px 0.0px"><FONT =
face=3D"Helvetica" size=3D"3" style=3D"font: 12.0px Helvetica">P.S. A =
good JDO? O, Gasp!</FONT></P>  </DIV><BR></DIV></BODY></HTML>=

--Apple-Mail-26--53191331--

--Apple-Mail-27--53190834
Content-Transfer-Encoding: base64
Content-Type: application/pkcs7-signature;
	name=smime.p7s
Content-Disposition: attachment;
	filename=smime.p7s

MIAGCSqGSIb3DQEHAqCAMIACAQExCzAJBgUrDgMCGgUAMIAGCSqGSIb3DQEHAQAAoIIGHjCCAtcw
ggJAoAMCAQICAw3FWTANBgkqhkiG9w0BAQQFADBiMQswCQYDVQQGEwJaQTElMCMGA1UEChMcVGhh
d3RlIENvbnN1bHRpbmcgKFB0eSkgTHRkLjEsMCoGA1UEAxMjVGhhd3RlIFBlcnNvbmFsIEZyZWVt
YWlsIElzc3VpbmcgQ0EwHhcNMDUwMTEwMDA0MTA5WhcNMDYwMTEwMDA0MTA5WjBHMR8wHQYDVQQD
ExZUaGF3dGUgRnJlZW1haWwgTWVtYmVyMSQwIgYJKoZIhvcNAQkBFhVDcmFpZy5SdXNzZWxsQFN1
bi5DT00wggEiMA0GCSqGSIb3DQEBAQUAA4IBDwAwggEKAoIBAQDti7ZE4rO6oXKbLM02AG9WY55t
udmBVL53fb3V3X5S1kvcJOk1NEMIYT/T7Ww+/hE955zvHT29+mIoNe8AW/yj1WUH8uGG2HxhwCHI
UQTHmN/ioVJgjwUaYbtNMKbL/NRpnL0QWewdMJS+6IFzFyX7ADFW5cJ+UWNLvNeWAQtN0mtLildn
vdOgh50i8YPvACNkCHoomGjXx0azcXbe1X3c5AgRI6e2CZe5k2lRFQFUMqkjdoMtQPoNqJ1BxH9l
i4cnabl8mcTwHHl44hrvb8ThqwRf2pfJh2vVuwmgK6z4IWjOk4RQM+0ODsRdq67mBdimJYmPMK1p
RMBHzrUsfKxNAgMBAAGjMjAwMCAGA1UdEQQZMBeBFUNyYWlnLlJ1c3NlbGxAU3VuLkNPTTAMBgNV
HRMBAf8EAjAAMA0GCSqGSIb3DQEBBAUAA4GBAIj86LzxCHedStDLMEeqHLy+UFG7zIRHfChSIV42
+MvXicydXEBh8v0Ry1V2d/lY4jS78G5yW5R9fKt1U5nlRBCOVzdhomvSolnNRIT71wPVVDrAIVlA
YpXKxSmVBq7+4hV+3ZLHDeq3qZnNmiJR0sTEUD16xZX1RJs9dRYPCHoRMIIDPzCCAqigAwIBAgIB
DTANBgkqhkiG9w0BAQUFADCB0TELMAkGA1UEBhMCWkExFTATBgNVBAgTDFdlc3Rlcm4gQ2FwZTES
MBAGA1UEBxMJQ2FwZSBUb3duMRowGAYDVQQKExFUaGF3dGUgQ29uc3VsdGluZzEoMCYGA1UECxMf
Q2VydGlmaWNhdGlvbiBTZXJ2aWNlcyBEaXZpc2lvbjEkMCIGA1UEAxMbVGhhd3RlIFBlcnNvbmFs
IEZyZWVtYWlsIENBMSswKQYJKoZIhvcNAQkBFhxwZXJzb25hbC1mcmVlbWFpbEB0aGF3dGUuY29t
MB4XDTAzMDcxNzAwMDAwMFoXDTEzMDcxNjIzNTk1OVowYjELMAkGA1UEBhMCWkExJTAjBgNVBAoT
HFRoYXd0ZSBDb25zdWx0aW5nIChQdHkpIEx0ZC4xLDAqBgNVBAMTI1RoYXd0ZSBQZXJzb25hbCBG
cmVlbWFpbCBJc3N1aW5nIENBMIGfMA0GCSqGSIb3DQEBAQUAA4GNADCBiQKBgQDEpjxVc1X7TrnK
mVoeaMB1BHCd3+n/ox7svc31W/Iadr1/DDph8r9RzgHU5VAKMNcCY1osiRVwjt3J8CuFWqo/cVbL
rzwLB+fxH5E2JCoTzyvV84J3PQO+K/67GD4Hv0CAAmTXp6a7n2XRxSpUhQ9IBH+nttE8YQRAHmQZ
cmC3+wIDAQABo4GUMIGRMBIGA1UdEwEB/wQIMAYBAf8CAQAwQwYDVR0fBDwwOjA4oDagNIYyaHR0
cDovL2NybC50aGF3dGUuY29tL1RoYXd0ZVBlcnNvbmFsRnJlZW1haWxDQS5jcmwwCwYDVR0PBAQD
AgEGMCkGA1UdEQQiMCCkHjAcMRowGAYDVQQDExFQcml2YXRlTGFiZWwyLTEzODANBgkqhkiG9w0B
AQUFAAOBgQBIjNFQg+oLLswNo2asZw9/r6y+whehQ5aUnX9MIbj4Nh+qLZ82L8D0HFAgk3A8/a3h
YWLD2ToZfoSxmRsAxRoLgnSeJVCUYsfbJ3FXJY3dqZw5jowgT2Vfldr394fWxghOrvbqNOUQGls1
TXfjViF4gtwhGTXeJLHTHUb/XV9lTzGCAucwggLjAgEBMGkwYjELMAkGA1UEBhMCWkExJTAjBgNV
BAoTHFRoYXd0ZSBDb25zdWx0aW5nIChQdHkpIEx0ZC4xLDAqBgNVBAMTI1RoYXd0ZSBQZXJzb25h
bCBGcmVlbWFpbCBJc3N1aW5nIENBAgMNxVkwCQYFKw4DAhoFAKCCAVMwGAYJKoZIhvcNAQkDMQsG
CSqGSIb3DQEHATAcBgkqhkiG9w0BCQUxDxcNMDUxMjE5MTkyNTE1WjAjBgkqhkiG9w0BCQQxFgQU
3uz4tkjGFcl9pBXyN1dkldx81YYweAYJKwYBBAGCNxAEMWswaTBiMQswCQYDVQQGEwJaQTElMCMG
A1UEChMcVGhhd3RlIENvbnN1bHRpbmcgKFB0eSkgTHRkLjEsMCoGA1UEAxMjVGhhd3RlIFBlcnNv
bmFsIEZyZWVtYWlsIElzc3VpbmcgQ0ECAw3FWTB6BgsqhkiG9w0BCRACCzFroGkwYjELMAkGA1UE
BhMCWkExJTAjBgNVBAoTHFRoYXd0ZSBDb25zdWx0aW5nIChQdHkpIEx0ZC4xLDAqBgNVBAMTI1Ro
YXd0ZSBQZXJzb25hbCBGcmVlbWFpbCBJc3N1aW5nIENBAgMNxVkwDQYJKoZIhvcNAQEBBQAEggEA
iBVlaPPa/3REWy358o9NOAS6sJSlJsqdYtevy1O0RvMmf8FTqzoT/K7lBT1gGqFIGp/va4kyTX/F
ttE57Pu3Hpjthd01nNM6xhfOtftlEy+fo2nEWNhyopj9oyWwdUk7lUhpwkfIcKy098dYGJoueFFG
4WC9i1Uam0qwqfiYgdUwgRnbn0/CDa0ZVMOnviaNpTrFtjGHV8Ny44veWfHpZwtmz4vh11pTc76Y
mzeP0pSKN2thIe9PLQBM5CbTmxCHcbYDk7UjZhbMClRCifRcVc9eYPGtZWkSw/Yuk5TghWDk28tW
hdJERwYU3T36nmV8q0/gkMdm8kQQ/LTchwTVBgAAAAAAAA==

--Apple-Mail-27--53190834--