Is this only happening with Pro warehouse, if you test with Serverless for example does it work? I have tested using syntax 
SELECT * FROM table_name WHERE column_name LIKE 'string%' and it has worked as expected for me on Serverless.