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

CREATE TABLE src (c0 INT, cLB LONGBLOB,  cLT LONGTEXT)engine=columnstore default charset utf8mb4;
SELECT column_name, data_type, column_length FROM information_schema.columnstore_columns WHERE hex(table_schema)=hex('mcol_4758') and hex(table_name)=hex('src');
INSERT INTO src VALUES (1, "Pretty Bloby Thing", "This is some text");
select * from src where c0=1 and substr(cLT, 1, 4)="This";

# To be uncommented when MCOL-4480 is fixed
#ALTER TABLE src ADD COLUMN (cLT2 LONGTEXT);
#UPDATE src SET cLT2="My Friday Night" where c0=1;
#select * from src where c0=1 and substr(cLT, 1, 4)="This";

# cleanup
DROP DATABASE `mcol_4758`;