[BUG] like function behaviour in V2 is not correct

[qianheng-aws]

What is the bug?
CalciteWhereCommandIT::testIsNotNullFunction running failed.

When expression like(firstname, 'Ambe_') evaluates on value Amber JOHnny, the v2 engine will return true while Calcite return false.

[LantaoJin]

@xinyual

[penghuo]

the v2 engine will return true while Calcite return false.

It is a bug in v2 engine. test in spark-sql

spark-sql (default)> select "Amber JOHnny" LIKE "Ambe_";
Amber JOHnny LIKE Ambe_
false


spark-sql (default)> select "Amber JOHnny" LIKE "Ambe_%";
Amber JOHnny LIKE Ambe_%
true

[LantaoJin]

Similar case as WHERE Like(TextBody, 'test*') should return false