[Epic] A Collection of Additional UTF8View support tickets

[alamb]

Is your feature request related to a problem or challenge?

@Omega359 / @timsaucer have found that there are still some functions / workloads that don't work with Utf8View. This ticket is an attempt to organize them

Tasks

• Update REGEXP_MATCH scalar function to support Utf8View #11911
• String sqllogictest error when running the test with complete #12752
• feat: Support Utf8View for get_wider_type + binary_to_string_coercion functions #13370
• fix: Support Utf8View in numeric_string_coercion #13366
• Add support for Utf8View to crypto functions #13407
• Read string as Utf8View in sqllogictest #13408
• Support Utf8View for string function bit_length() #13221
• add support for utf8view type to NullIf function #13379
• Add support for string view to a few functions #13330
• Add support for Utf8View to string_to_array and array_to_string #13403
• Fix concat simplifier for Utf8View types #13346

[Omega359]

Related arrow-rs tickets:

• Support Temporal -> Utf8View casting arrow-rs#6734
• Support Numeric -> Utf8View casting arrow-rs#6714
• Support Utf8View <=> boolean casting arrow-rs#6713
• implement regexp_match, regexp_scalar_match and regexp_array_match for StringViewArray arrow-rs#6717
• Add support for Utf8View -> numeric in can_cast_types arrow-rs#6715

[alamb]

I will put those on my list to review shortly