IN/NOT IN Subquries don't accept aggregate values

[GoogleCodeExporter]

What steps will reproduce the problem?
1. Create a query that contains an IN/NOT IN subquery, where the subquery's
select statement is an aggregate, instead of a normal Select column.

What is the expected output? 
Expect the outer query to run successfully.

What do you see instead?
An error message like 'You must specify a column to return for the IN to be
valid. Use Select("column") to do this'

What version of the product are you using? 
Rev 479.

On what operating system?
XP

Please provide any additional information below.
The attached patch resolves this issue in SqlQuery\Contstraint.cs.

Original issue reported on code.google.com by dave.nee...@gmail.com on 29 Jul 2008 at 11:57

Attachments:

• Subsonic_aggregates_IN_subquery.patch

[GoogleCodeExporter]

Fixed with revision 500

Original comment by robcon...@gmail.com on 8 Apr 2009 at 7:19

[GoogleCodeExporter]

Original comment by robcon...@gmail.com on 8 Apr 2009 at 7:19

• Changed state: Fixed