-- source ../include/have_columnstore.inc
--disable_warnings
DROP DATABASE IF EXISTS mcol_4622;
--enable_warnings
CREATE DATABASE mcol_4622;
USE mcol_4622;

--disable_warnings
DROP TABLE IF EXISTS t1;
--enable_warnings
CREATE TABLE t1 (a VARCHAR(32), d FLOAT) ENGINE=ColumnStore;
INSERT INTO t1 VALUES ('aaaa', 1.5);
SELECT LEFT(a, d) FROM t1;

--disable_warnings
DROP TABLE IF EXISTS t1;
--enable_warnings
CREATE TABLE t1 (a VARCHAR(32), d DOUBLE) ENGINE=ColumnStore;
INSERT INTO t1 VALUES ('aaaa', 1.5);
SELECT LEFT(a, d) FROM t1;

--disable_warnings
DROP TABLE IF EXISTS t1;
--enable_warnings

--disable_warnings
DROP DATABASE mcol_4622;
--enable_warnings