Changes to browser_version_info UDF and Impact

[Winnie Chan]

Hello,

This email is to announce that we have made a fix to the mozfun.norm.browser_version_info udf on March 13th, 2023.

• Prior to the fix, the browser_version_info udf truncated the app_version when splitting the minor_version. (eg. app_version = 3.10 resulted in minor_version = 3.1) 
• This change has updated the browser_version_info udf to extract the minor_version instead.  (eg. app_version = 3.10.2 now results in minor_version = 10)

This proposal includes more details about the change and includes the list of impacted tables/views.

Please share this announcement with others who may need to know about this change. 

Thanks,

Winnie Chan

Senior Data Programmer