Subquery example error

Description

14.13 gives this example:
select cat.id, (select max(kit.weight) from cat.kitten kit) from Cat as cat

I wrote something very similar but the parser rejected it. The alias needs to be outside the parentheses:
select cat.id, (select max(kit.weight) from cat.kitten) as kit from Cat as cat

Activity

Brett MeyerNovember 28, 2013 at 2:24 AM

I'm not able to find that query – that area has changed quite a bit.

Cannot Reproduce

Details

Assignee

Reporter

Components

Affects versions

Priority

Created March 24, 2010 at 8:19 AM
Updated November 28, 2013 at 2:24 AM
Resolved November 28, 2013 at 2:24 AM