Message from discussion Problem comparing two fields in HAVING clause

MIME-Version: 1.0
Received: by 10.100.45.9 with SMTP id s9mr308891ans.15.1246613734896; Fri, 03 
	Jul 2009 02:35:34 -0700 (PDT)
Date: Fri, 3 Jul 2009 02:35:34 -0700 (PDT)
X-IP: 87.217.178.53
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10.5; en-US; 
	rv:1.9.1.1pre) Gecko/20090702 Shiretoko/3.5.1pre,gzip(gfe),gzip(gfe)
Message-ID: <c10615c2-5d1e-4088-84b2-c3b944abf3ad@y9g2000yqg.googlegroups.com>
Subject: Problem comparing two fields in HAVING clause
From: Michi <mhauptm...@gmail.com>
To: doctrine-user <doctrine-user@googlegroups.com>
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

Hi everybody,

I'm trying to execute a query with a subquery and a HAVING clause. In
the HAVING clause I need to compare the result of the subquery to a
field in the SELECT clause like "paid < total_amount".

The problem is that Doctrine doesn't recognize the second field name
as such and I always get a SQLSTATE error complaining that the column
could not be found.

Is that a bug in Doctrine or am I doing something wrong?

Thanks for your help,