Regex Match fails on Dictionary and Utf8View

[blaginin]

Describe the bug

SELECT arrow_cast('abc', 'Utf8View') ~* arrow_cast('a.c', 'Dictionary(Int32, Utf8)'); fails on the latest build

To Reproduce

No response

Expected behavior

Regex Match should work the same way Like match does

Additional context

No response

[blaginin]

@goldmedal Do you think we should add tests for something like this in your sqllogictech string files? It feels like operators on everything × everything should catch it. For example, I could find this issue by doing:

[Omega359]

#11911

[goldmedal]

@goldmedal Do you think we should add tests for something like this in your sqllogictech string files? It feels like operators on everything × everything should catch it. For example, I could find this issue by doing:

Sure, I think it's good to have a test framework to test a string type with other string types. We only do this kind of thing at

datafusion/datafusion/sqllogictest/test_files/string/string_view.slt

Lines 106 to 110 in fce331a

	## StringView to Other Types column
	########
	# test StringViewArray with Utf8 columns
	query TTBBBB

If you want to add the test for StirngView specifically, I guess you can do it in this part. Or if you want to do it for all string types, you could create the testing data in https://github.com/apache/datafusion/blob/main/datafusion/sqllogictest/test_files/string/init_data.slt.part
and add the tests in
https://github.com/apache/datafusion/blob/main/datafusion/sqllogictest/test_files/string/string_query.slt.part

[blaginin]

Or if you want to do it for all string types…

Yes, this feels more robust! Let’s wait for the original issue to be solved than and then add tests for all cases

[blaginin]

closed as a duplicate of #11911