Re: BUG #1682: subselect generates multiple rows

On Fri, May 27, 2005 at 08:55:50AM +0100, D.J. Kniep wrote:
>
> id         content
> 1          John Doe
> 1          John Doe
> 2          Peter Gabriel

I couldn't reproduce these results with the test data and query you
provided, but my table and view definitions probably differed from
yours.  Could you post a complete example?  That is, all CREATE,
INSERT, and SELECT statements that somebody could execute in an
empty database to reproduce the results you get.

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/