[JCR-2954] SQL-2 query returns more than the requested column

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 2.2.5
• Fix Version/s: 2.2.10, 2.3
• Component/s: query
• Assignee: Alex Deparvu
• Reporter: Benjamin Papez
• Created: 02/May/11 14:57
• Updated: 16/Nov/11 17:09
• Resolved: 24/May/11 11:58

Description

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.