[jira] [Updated] (JDO-721) Specifying NULL elements positioning in ordered columns
[ https://issues.apache.org/jira/browse/JDO-721?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Craig L Russell updated JDO-721: Fix Version/s: JDO 3 maintenance release 2 (3.2) Specifying NULL elements positioning in ordered columns --- Key: JDO-721 URL: https://issues.apache.org/jira/browse/JDO-721 Project: JDO Issue Type: Improvement Components: specification Affects Versions: JDO 3 update 1 (3.0.1) Reporter: Muhammad Gelbana Priority: Minor Labels: jdoql Fix For: JDO 3 maintenance release 2 (3.2) I don't know about other RDBMS but in MySQL ordering, it's possible to specify whether NULL column fields are placed in the beginning or at the end of the ordering, i.e.: ORDER BY `values_column` IS NULL DESC [values_column] NULL NULL value1 value2 value3 or the other way around (ORDER BY `values_column` IS NULL ASC): [values_column] value1 value2 value3 NULL NULL I checked JDO 3 specification and found that JDOQL's ordering specification doesn't support specifying NULL values handling: -- 26.7 Ordering Specification This section describes the syntax of the setOrdering argument. OrderingClause: OrderingSpecs ,opt OrderingSpecs: OrderingSpec OrderingSpecs , OrderingSpec OrderingSpec: Expression Ascending Expression Descending Ascending: one of asc ascending Descending: one of desc descending Please note, as a usability feature OrderingClause supports an optional trailing comma. -- Thank you for your time and efforts. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira
Minutes: JDO TCK Conference Call Friday August 2, 9 am Pacific Daylight Time
NOTE: Next week August 9 the meeting will be at 10:00 AM PDT. Attendees: Michelle Caisse, Michael Bouschen, Craig Russell Agenda: 1. News on JDO-678 Ability to set properties on PersistenceManager: Craig proposed Appendix K https://issues.apache.org/jira/browse/JDO-678 Appendix K shows up as Appendix A. Does it need some post-processing? No, it will show up as Appendix A until it's in the book. Multithreaded is an optional feature of an implementation but doesn't show up in Chapter 11 section 6. AI Craig update Chapter 11. 2. JDO release candidate https://issues.apache.org/jira/browse/JDO-723 When we release 3.1-rc1, trunk becomes 3.2-SNAPSHOT, the 3.1 branch becomes 3.1.1-SNAPSHOT. The proposal is to release 3.1-rc1 as the Apache release and then go to JCP with this release. Need to copy final changes of tck getProperties test. AI Craig The specification is only in trunk. Need to create 3.1 versions of dtd and xsd in branch. AI Michael 3. New comment on https://issues.apache.org/jira/browse/JDO-721 Null element ordering. Propose to address this in 3.2. 4. Other issues Action Items from weeks past: [May 10 2013] AI Everyone take a look Apache ISIS and maybe subscribe to ISIS mail lists. [Aug 24 2012] AI Craig update the JIRAs JDO-689 JDO-690 and JDO-692 about JDOHelper methods. In process. [Aug 17 2012] AI Craig comment on JIRA JDO-589 Autocommit or nontransactional action [Sep 23 2011] AI Michael document when changing dependencies (to DataNucleus) it's necessary to rebuild the exectck project before running tck. Craig L Russell Architect, Oracle http://db.apache.org/jdo 408 276-5638 mailto:craig.russ...@oracle.com P.S. A good JDO? O, Gasp!
Re: Minutes: JDO TCK Conference Call Friday August 2, 9 am Pacific Daylight Time
Hi, NOTE: Next week August 9 the meeting will be at 10:00 AM PDT. Attendees: Michelle Caisse, Michael Bouschen, Craig Russell Agenda: 1. News on JDO-678 Ability to set properties on PersistenceManager: Craig proposed Appendix K https://issues.apache.org/jira/browse/JDO-678 Appendix K shows up as Appendix A. Does it need some post-processing? No, it will show up as Appendix A until it's in the book. Multithreaded is an optional feature of an implementation but doesn't show up in Chapter 11 section 6. AI Craig update Chapter 11. I compared Appendix K with chapter 11.6 Optional Feature Support of the spec and found two missing entries in Appendix K: - javax.jdo.option.List - javax.jdo.query.JDOQL 2. JDO release candidate https://issues.apache.org/jira/browse/JDO-723 When we release 3.1-rc1, trunk becomes 3.2-SNAPSHOT, the 3.1 branch becomes 3.1.1-SNAPSHOT. The proposal is to release 3.1-rc1 as the Apache release and then go to JCP with this release. Need to copy final changes of tck getProperties test. AI Craig The specification is only in trunk. Need to create 3.1 versions of dtd and xsd in branch. AI Michael The 3.1 versions are checked into the branch. Regards Michael 3. New comment on https://issues.apache.org/jira/browse/JDO-721 Null element ordering. Propose to address this in 3.2. 4. Other issues Action Items from weeks past: [May 10 2013] AI Everyone take a look Apache ISIS and maybe subscribe to ISIS mail lists. [Aug 24 2012] AI Craig update the JIRAs JDO-689 JDO-690 and JDO-692 about JDOHelper methods. In process. [Aug 17 2012] AI Craig comment on JIRA JDO-589 Autocommit or nontransactional action [Sep 23 2011] AI Michael document when changing dependencies (to DataNucleus) it's necessary to rebuild the exectck project before running tck. Craig L Russell Architect, Oracle http://db.apache.org/jdo 408 276-5638 mailto:craig.russ...@oracle.com P.S. A good JDO? O, Gasp! -- *Michael Bouschen* *Prokurist* akquinet tech@spree GmbH Bülowstr. 66, D-10783 Berlin Fon: +49 30 235 520-33 Fax: +49 30 217 520-12 Email: michael.bousc...@akquinet.de Web: www.akquinet.de http://www.akquinet.de akquinet tech@spree GmbH, Berlin Geschäftsführung: Martin Weber, Dr. Torsten Fink Amtsgericht Berlin-Charlottenburg HRB 86780 B USt.-Id. Nr.: DE 225 964 680