dssysolyatin commented on PR #3142: URL: https://github.com/apache/calcite/pull/3142#issuecomment-1500817407
It turned out that it is not enough to just enable this function. PostgreSQL's LEAST, GREATEST functions behave differently with NULL values than ORACLE or BigQuery: From BigQuery documentation [1]: ``` They return NULL if any of the input parameters is NULL. ``` From PostgreSQL documentation [2]: ``` The result will be NULL only if all the expressions evaluate to NULL. ``` [1] https://cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions [2] https://www.postgresql.org/docs/15/functions-conditional.html#FUNCTIONS-GREATEST-LEAST -- 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]
