Cannot Reproduce
Details
Assignee
UnassignedUnassignedReporter
Paul BenedictPaul BenedictComponents
Affects versions
Priority
Trivial
Details
Details
Assignee
Unassigned
UnassignedReporter
Paul Benedict
Paul BenedictComponents
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
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