Jackie-Jiang commented on PR #14089: URL: https://github.com/apache/pinot/pull/14089#issuecomment-2377437825
Per the PG behavior: https://www.postgresql.org/docs/current/functions-math.html Should it return INT for operations between INT columns? Good catch on the division function behavior difference. In order to move towards standard SQL behavior without breaking backward compatibility, we can consider adding a query option to follow standard SQL. This way we can keep v1 behavior and also make v2 standard SQL compatible. V1 user can also migrate to standard SQL behavior. -- 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]
