[FEA] Try to add some fallback tests for CharType and VarcharType

[firestarman]

This is a follow-up for #13151, suggested from the comment at #13151 (review).

We can try to address this after Spark adds CharType or VarcharType support to some SQL functions or operators.