Silent correctness issue for PSQL and SQLServer for LIKE predicate pushdown

[vlad-lyutenko]

We have test for LIKE pushdown TestPostgreSqlConnectorTest.testLikePredicatePushdown()

Looks like it passing only because we have case sensitive columns in our test by default.
If we change collation for columns - it will fails.

I think we need to enable this pushdown only if column is case sensitive or we use enable_string_pushdown_with_collate.
The same problem with SQLServer.

So for example if table is case insensitive and we execute select, we could get different result with and without push down.

data : ABC, Abc, AbC, abc.

SELECT * WHERE column LIKE %abc% - with pushdown - ABC, Abc, AbC, abc.
                                    without pushdown - abc  

Here is attempt to apply this logic for MySql #18441