Details
-
Bug
-
Status: Resolved
-
Minor
-
Resolution: Fixed
-
5.4.0
-
None
-
None
-
None
-
HPCC 5.4.6-rc2
https://66.241.56.6:18010
Description
A WsSQL select query using aggregates (sum) is failing with the error "Could not verify field: totalboothprice". Per Rodrigo Pastrana: "I broke the query down and it appears to fail on type validation of the sum(column) entry in the select clause".
select sum(totalboothprice) from reed::in::salesrevenuebreakout where event = 'INT' and customerid = 1072602 and edition = 2014 group by totalboothprice
Filing on behalf of Ryan Jacovich at Reed Exhibitions (rjacovich@reedexpo.com). Original email describing issue is attached.