Skip to content

like and ilike not supported for LargeUtf8 #5893

@SimonSchneider

Description

@SimonSchneider

Describe the bug

I'm trying to run an SQL query using ilike/like but it gives me the following error:

Data type LargeUtf8 not supported for scalar operation 'like' on string array. This was likely caused by a bug in DataFusion's code and we would welcome that you file an bug report in our issue tracker

The error seems to originate here

To Reproduce

given a table test with a column a of type LargeUtf8 the following SQL query will fail

SELECT a FROM test WHERE "a" like '%something%';

SELECT a FROM test WHERE "a" ilike '%something%';

Expected behavior

I'd expect to be able to do an ilike query on a LargeUtf8 column.

Additional context

No response

Metadata

Metadata

Assignees

Labels

bugSomething isn't working

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions