ydb/yql/essentials/tests/sql/suites/like/like_rewrite.sql

PRAGMA AnsiLike;

SELECT
    'abc' like '%%%%%',
    'qqq' like '%q%',
    'qqq' like '%q%q%q%',
    'def' like '%f',
    'def' like '%%%f',
    'foo' like 'foo%foo',
    'foofoo' like 'foo%%foo',
    'abcxzfoo' like '%x_foo',