Uploaded image for project: 'WsSQL'
  1. WsSQL
  2. WSSQL-128

WsSQL - Type validation failure of the sum(column) entry in select clause

    XMLWordPrintable

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.

      Attachments

        Activity

          People

            rpastrana Rodrigo Pastrana
            marc.wetter@logianalytics.com Marc Wetter
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: