You've already forked mariadb-columnstore-engine
mirror of
https://github.com/mariadb-corporation/mariadb-columnstore-engine.git
synced 2025-07-30 19:23:07 +03:00
237cad347f
MCOL-4758 Limit LONGTEXT and LONGBLOB to 16MB Also add the original test case from MCOL-3879.
20 lines
791 B
Plaintext
20 lines
791 B
Plaintext
--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`;
|