ankitsultana opened a new issue, #10415: URL: https://github.com/apache/pinot/issues/10415
Detected this in https://github.com/apache/pinot/pull/10409 There's a todo left in `FunctionOperand` as well related to this: https://github.com/apache/pinot/blob/master/pinot-query-runtime/src/main/java/org/apache/pinot/query/runtime/operator/operands/FunctionOperand.java#L53 Essentially after the PR linked above, for the query below a couple of project nodes are merged and the case/when starts returning a Double at runtime which is compared against `16.0` which is a float. ``` SELECT intCol, CASE WHEN (SELECT SUM(floatCol) FROM {tbl1}) > 16.0 THEN 'Large sum' ELSE 'Small sum' END AS aggVal, strCol FROM {tbl1} ``` cc: @walterddr -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
