DROP DATABASE IF EXISTS MCOL5599; CREATE DATABASE MCOL5599; USE MCOL5599; CREATE TABLE t (t TEXT) ENGINE = COLUMNSTORE; SELECT * FROM t WHERE t LIKE '%1%'; t DROP DATABASE MCOL5599;