[DERBY-2238] Example of ScalarSubquery in Derby Reference Manual is not ScalarSubquery

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 10.2.2.0
• Fix Version/s: 10.12.1.1
• Component/s: Documentation
• Labels: derby_triage10_11
• Environment: http://db.apache.org/derby/docs/dev/ref/rrefscalarsubquery.html
• Urgency: Low
• Assignee: Myrna van Lunteren
• Reporter: Tomohito Nakayama
• Created: 13/Jan/07 09:01
• Updated: 09/Sep/16 09:51
• Resolved: 13/Jan/15 16:58

Description

In the page, I found next example.

– Introduce a way of "generating" new data values,
– using a query which selects from a VALUES clause (which is an
– alternate form of a fullselect).
– This query shows how a table can be derived called "X" having
– 2 columns "R1" and "R2" and 1 row of data.
SELECT R1,R2
FROM (VALUES('GROUP 1','GROUP 2')) AS X(R1,R2)

I think this is not ScalarSubquery because the result have two columns.