Thank Florent for you response. I have several questions to you.
1. Can you point me the place in SQL-92 spec where said that "the column and table names should be compared in a case-insensitive manner" 2. Properties with names "cmis:ObjectId" and "cmis:oBjectID" is the same and values should be stored in one place? Sergey Kabashnyuk ---------- Forwarded message ---------- From: Florent Guillaume <[email protected]> Date: Thu, Feb 25, 2010 at 8:12 PM Subject: Re: QueryPagingTest.testQueryPaging: wrong properties' names To: chemistry-dev <[email protected]> Cc: Andrey Parfonov <[email protected]> But note that the spec states that SQL-92 is followed unless otherwise specified, so the column and table names should be compared in a case-insensitive manner by your server. So both cmis:ObjectId and and cmis:objectId (and CmIS:oBjectID) should work. Florent 2010/2/25 Alexey Zavizionov <[email protected]>: > Thanks for the reply. > > On Thu, Feb 25, 2010 at 1:09 PM, David Caruana > <[email protected]>wrote: > >> That's a consequence of spec changes. They use to be that way. >> >> I'll update the query tests so they comply with the current spec. >> >> Dave >> >> On 25 Feb 2010, at 10:49, Alexey Zavizionov wrote: >> >> > Hello, list! >> > >> > I have a question related to QueryPagingTest.testQueryPaging >> > >> > String query = >> > "SELECT cmis:ObjectId, cmis:ObjectTypeId, cmis:Name FROM >> > cmis:document " + >> > "WHERE IN_FOLDER('" + >> > testFolderObject.getObjectId().getStringValue() + "')"; >> > >> > Why are properties' names start with Upper case char? >> > >> > Regards, >> > Alexey. >> >> > -- Florent Guillaume, Director of R&D, Nuxeo Open Source, Java EE based, Enterprise Content Management (ECM) http://www.nuxeo.com http://www.nuxeo.org +33 1 40 33 79 87
