--disable_warnings
DROP DATABASE IF EXISTS mcol5196;
--enable_warnings

CREATE DATABASE mcol5196;

USE mcol5196;

CREATE TABLE t1 (a VARCHAR(7) CHARACTER SET latin1 COLLATE latin1_bin) ENGINE=COLUMNSTORE;

INSERT INTO t1(a) VALUES ('aa');

SELECT REPLACE(a, 'pqrs', 'a') FROM t1;

DROP DATABASE mcol5196;