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.
28 lines
922 B
Plaintext
28 lines
922 B
Plaintext
--source ../include/have_columnstore.inc
|
|
--disable_warnings
|
|
DROP DATABASE IF EXISTS `mcol_3879`;
|
|
--enable_warnings
|
|
CREATE DATABASE `mcol_3879`;
|
|
USE `mcol_3879`;
|
|
|
|
create table t1 (
|
|
id bigint(20) DEFAULT NULL,
|
|
v1 varchar(32) DEFAULT NULL,
|
|
v2 varchar(100) DEFAULT NULL,
|
|
json1 longtext DEFAULT NULL,
|
|
json2 longtext DEFAULT NULL,
|
|
json3 longtext DEFAULT NULL)
|
|
ENGINE = COLUMNSTORE
|
|
DEFAULT CHARSET utf8mb4;
|
|
|
|
insert into t1 (id, v1, v2) values (1, "DUP", "This is a test of a bug 1"),
|
|
(2, "REF", "This is a test of a bug 2"),
|
|
(1002, "REF", "This is a test of a bug 3"),
|
|
(1002, "DUP", "This is a test of a bug 4"),
|
|
(5, "dup", "This is a test of a bug 5");
|
|
|
|
select * from t1 where v1 = "DUP" and id <> 1002;
|
|
|
|
# cleanup
|
|
DROP DATABASE `mcol_3879`;
|