parse_one(sql).sql("clickhouse") trans LIKE to wrong grammar

[CainYang]

my sql is
select if(like(ip, '%.%'), ip, IPv4NumToString(toIPv4(ip))) as ip_str from ip_traffic order by severity desc limit 10
and after parse_one(sql).sql("clickhouse"), it becomes
select case when '%.%' like ip then ip else IPv4NumToString(toIPv4(ip)) end as ip_str from ip_traffic order by severity desc limit 10
but the correct grammar is 'ip like '%.%'', not ''%.%' like ip'

[VaggelisD]

Hey @CainYang, just a heads up that the proper use of our API would be parse_one(sql, "clickhouse").sql("clickhouse") i.e you must select a dialect for both parsing and generation.

The problem still persists on Clickhouse, though, so I've submitted a PR to fix it.

[CainYang]

ok, i got it, thank you very much.