GoogleCloudPlatform / bigquery-utils

Useful scripts, udfs, views, and other utilities for migration and data warehouse operations in BigQuery.
https://cloud.google.com/bigquery/
Apache License 2.0
1.11k stars 277 forks source link

Support arbitrary precision input in `cw_convert_base` for supported radix. #373

Closed paolomorandini closed 1 year ago

paolomorandini commented 1 year ago

This change introduces the use of BigInt (arbitrary precision integer numbers) in cw_convert_base. BigInt will be used for supported radix (2,8,10,16) else the function will default to parseInt which can safely represent integer numbers within approximately +/- 2^53.