You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@jackrabbit.apache.org by "Benjamin Papez (JIRA)" <ji...@apache.org> on 2011/05/02 16:59:03 UTC
[jira] [Created] (JCR-2954) SQL-2 query returns more than the
requested column
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
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
[jira] [Updated] (JCR-2954) SQL-2 query returns more than the
requested column
Posted by "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:
--------------------------------
Status: Patch Available (was: Open)
> 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
[jira] [Updated] (JCR-2954) SQL-2 query returns more than the
requested column
Posted by "Jukka Zitting (Updated) (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/JCR-2954?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Jukka Zitting updated JCR-2954:
-------------------------------
Fix Version/s: 2.2.10
Merged to the 2.2 branch in revision 1202785.
> 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
> Assignee: Alex Parvulescu
> Priority: Minor
> Fix For: 2.2.10, 2.3
>
> 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.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Updated] (JCR-2954) SQL-2 query returns more than the
requested column
Posted by "Alex Parvulescu (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/JCR-2954?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Alex Parvulescu updated JCR-2954:
---------------------------------
Resolution: Fixed
Fix Version/s: 2.3.0
Assignee: Alex Parvulescu
Status: Resolved (was: Patch Available)
Fixed in revision 1126987.
> 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
> Assignee: Alex Parvulescu
> Priority: Minor
> Fix For: 2.3.0
>
> 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
[jira] [Updated] (JCR-2954) SQL-2 query returns more than the
requested column
Posted by "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
[jira] [Commented] (JCR-2954) SQL-2 query returns more than the
requested column
Posted by "Alex Parvulescu (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/JCR-2954?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13038514#comment-13038514 ]
Alex Parvulescu commented on JCR-2954:
--------------------------------------
hi Benjamin,
interesting find!
I've looked over this issue a little bit and the problem is better solved deeper, in the Parser class in jcr-commons. I've included a few tests, take a quick look and let me know what you think.
> 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