[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]
Subject: [OASIS Issue Tracker] Commented: (CMIS-515) ORDER BY should allowqualified column names
[ http://tools.oasis-open.org/issues/browse/CMIS-515?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17313#action_17313 ] Al Brown commented on CMIS-515: ------------------------------- JIRA Cleanup > ORDER BY should allow qualified column names > -------------------------------------------- > > Key: CMIS-515 > URL: http://tools.oasis-open.org/issues/browse/CMIS-515 > Project: OASIS Content Management Interoperability Services (CMIS) TC > Issue Type: Bug > Components: Domain Model > Affects Versions: Draft 0.62 > Reporter: Florent Guillaume > Priority: Minor > Fix For: Committee Draft 04 > > > The BNF for a query has: > <sort specification> ::= <column name> [ ASC | DESC ] > However if we want to allow queries with JOINs to order their results, like: > SELECT B.cmis:ObjectId, B.dc:title FROM cmis:Document A JOIN cmis:Document B ON A.cmis:ObjectId = B.my:field WHERE A.dc:description = 'foo' ORDER BY B.dc:title > Then we have to use a BNF like: > <sort specification> ::= <column reference> [ ASC | DESC ] > Note: In this BNF statement, SQL-92 has <column name>, but SQL 2008 actually has a very generic <value expression> instead. I think <column reference> is sufficient for CMIS. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://tools.oasis-open.org/issues/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira
[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]