[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]
Subject: [OASIS Issue Tracker] Created: (CMIS-515) ORDER BY should allowqualified column names
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 Assignee: Ethan Gur-esh Priority: Minor 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]