Simplify `LIKE '%'` predicates

[findepi]

information_schema and system.jdbc queries would benefit if we simplified table_name LIKE '%' (and table_name LIKE '%%' etc.) queries to table_name IS NOT NULL.

[findepi]

cc @huberty89 @kokosing @martint

[kokosing]

Is this only information_schema specific? It sounds like it could be a generic optimization. Does % match an empty string too?

[findepi]

yes, the optimization should be generic. i mentioned information_schema and system.jdbc to emphasize importance of such optimization. In these places, today we take different, less optimal code path when LIKE '%' predicate is present.

[chenjian2664]

I am interested in this part, Could you guide me on how to start on this part?

[kokosing]

I am under impression that this rewrite could be handled by io.trino.sql.planner.iterative.rule.SimplifyExpressions

[chenjian2664]

@kokosing Thank you