Hi Khaleel, Thanks a lot for reporting the problem, which looks like a bug. I will file a JIRA and keep you posted.
One question though, why would we use MAX(H."timestamp") instead of H."timestamp"? What difference would it make? Thanks, Maryann On Wed, Apr 22, 2015 at 9:45 AM, khaleel mershad <khellom...@gmail.com> wrote: > > Hello, > > I tried executing the following query in Phoenix: > select distinct W."rowId", W."md5_current", W."size_current" from "Wiki" > AS W where EXISTS( select MAX(H."timestamp") from "History" AS H where > (H."rowId" = W."rowId") AND (H."status" = 'approved') ); > > I got the following error: > ERROR 1018 (42Y27): Aggregate may not contain columns not in GROUP BY. > (state=42Y27,code=1018) > > If I replace W."rowId" (in the where clause) with a constant value (for > example: '3587'), the query works fine. Also, if I replace the aggregate > MAX(H."timestamp") with H."timestamp", the query also works fine. > > So it seems that Phoenix generates error when using a reference to an > outer query while using an aggregate within the inner query. > > Any solutions? > > > > Regards, > > Khaleel Mershad, Ph.D. > Research Associate > > American University of Beirut > Department of Electrical and Computer Engineering > Bliss Street, Beirut, Lebanon > email: kw...@aub.edu.lb >
