LIKE expressions with initial and ending % do not work on char columns about presto

[kaikalur]

I prefer adding the missing SPLIT function overload for char type - varchar vs char is too subtle for users.

So I suggest for now, removing the CharType as suggsted on the original PR and open a separate issue to add SPLIT for CHAR type so we can make it more robust.

We are definitely not reverting the optimization.

[kaikalur]

presto:di> select SPLIT(CAST('abc' AS CHAR(3)), 'a');
Query 20240229_013122_09457_ph8x5 failed: line 1:8: Unexpected parameters (char(3), varchar(1)) for function split. Expected: split(varchar(x), varchar(y), bigint) , split(varchar(x), varchar(y))
select SPLIT(CAST('abc' AS CHAR(3)), 'a')

[tdcmeehan]

I prefer adding the missing SPLIT function overload for char type - varchar vs char is too subtle for users.

So I suggest for now, removing the CharType as suggsted on the original PR and open a separate issue to add SPLIT for CHAR type so we can make it more robust.

We are definitely not reverting the optimization.

Agreed on this path forward. Would you like to raise a PR?