Re: query qualifiers

[Florent Guillaume <fg@nuxeo.com>]

And also that these are all legal:
  SELECT cmis:name FROM File
  SELECT File.cmis:name FROM File
  SELECT cmis:name FROM File f
  SELECT f.cmis:name FROM File f
  SELECT File.cmis:name FROM File f

Florent

On Fri, Apr 22, 2011 at 5:28 PM, Florent Guillaume <fg@nuxeo.com> wrote:
> Hi,
>
> I'm updating some of the OpenCMIS server-side query parsing code to
> properly validate qualifiers in IN_TREE, IN_FOLDER and CONTAINS.
>
> Could someone confirm my understanding that these are legal:
>  SELECT Title FROM BookType WHERE IN_TREE(BookType, 'foo')
>  SELECT Title FROM BookType B WHERE IN_TREE(B, 'foo')
>  SELECT Title FROM BookType B WHERE IN_TREE(BookType, 'foo')
>  SELECT B1.Title FROM BookType B1 JOIN BookType B2 ON ... WHERE
> IN_TREE(B1, 'foo') OR IN_TREE(B2, 'bar')
>  SELECT B.Title FROM BookType B JOIN MyDocType D ON ... WHERE
> IN_TREE(MyDocType, 'foo')
>
> And these are illegal due to ambiguous qualifier use:
>  SELECT B1.Title FROM BookType B1 JOIN BookType B2 ON ... WHERE
> IN_TREE(BookType, 'foo')
>  SELECT BookType.Title FROM BookType A JOIN BookType B ON ...
>
> Should this be legal?
>  SELECT BookType.Title FROM BookType A JOIN BookType ON ...
>
> Florent
>
> --
> 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
>



-- 
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