[jira] [Updated] (JCR-2954) SQL-2 query returns more than the requested column

["Benjamin Papez (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/JCR-2954?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Benjamin Papez updated JCR-2954:
--------------------------------

    Attachment: QueryEngine.patch

Add check for the case that propertyName is specified in the column without using an alias. In this case still just the column should be returned and not all columns.

> SQL-2 query returns more than the requested column
> --------------------------------------------------
>
>                 Key: JCR-2954
>                 URL: https://issues.apache.org/jira/browse/JCR-2954
>             Project: Jackrabbit Content Repository
>          Issue Type: Bug
>          Components: query
>    Affects Versions: 2.2.5
>            Reporter: Benjamin Papez
>            Priority: Minor
>         Attachments: QueryEngine.patch
>
>
> If I do :
> SELECT alias.[jcr:title] FROM [jnt:mainContent] as alias
> and then iterate through the returned columns of the rows, I get the same result as for :
> SELECT * FROM [jnt:mainContent] 
> which is ALL the properties defined for jnt:mainContent.
> Only if I use
> SELECT alias.[jcr:title] as title FROM [jnt:mainContent] as alias
> the result is limited to the title column.

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira