I just upgraded from 7.0.3 to 7.1.
I have a query like this:
SELECT l, (SELECT COUNT(*) FROM ms WHERE ms.p = 4 AND ms.s = 2),
COUNT(DISTINCT m.uid), COUNT(m.oid), AVG(m.msgs::int), SUM(m.msgs::int)
FROM m, a WHERE key = 4 AND m.p = 4 GROUP BY l;
The problem is suddenly in 7.1 the result of the subselect used to
return an Integer now returns a BigInteger and is causing
classCastExceptions in my code. What gives?
--
Joseph Shraibman
[EMAIL PROTECTED]
Increase signal to noise ratio. http://www.targabot.com
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
