DROP DATABASE IF EXISTS mcol_4622;
CREATE DATABASE mcol_4622;
USE mcol_4622;
DROP TABLE IF EXISTS t1;
CREATE TABLE t1 (a VARCHAR(32), d FLOAT) ENGINE=ColumnStore;
INSERT INTO t1 VALUES ('aaaa', 1.5);
SELECT LEFT(a, d) FROM t1;
LEFT(a, d)
aa
DROP TABLE IF EXISTS t1;
CREATE TABLE t1 (a VARCHAR(32), d DOUBLE) ENGINE=ColumnStore;
INSERT INTO t1 VALUES ('aaaa', 1.5);
SELECT LEFT(a, d) FROM t1;
LEFT(a, d)
aa
DROP TABLE IF EXISTS t1;
DROP DATABASE mcol_4622;