[CALCITE-6290] Incorrect return type for BigQuery TRUNC

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.37.0
• Labels: pull-request-available
• Assignee: Tanner Clary
• Reporter: Tanner Clary
• Created: 04/Mar/24 17:50
• Updated: 06/May/24 22:19
• Resolved: 05/Mar/24 16:00

Description

The BigQuery docs state that when the TRUNC function is provided an integer argument, it should return a double. However, we currently have the return type set to ARG0_NULLABLE. We should probably adjust this to ARG0_EXCEPT_INTEGER_NULLABLE similar to CALCITE-5747

This change also adjusts the NULLABILITY for CEIL_BIG_QUERY and FLOOR_BIG_QUERY as I incorrectly set these with I implemented CALCITE-5747

Issue Links

• links to: GitHub Pull Request #3714