[MCOL-4735] Length may not exceed 8000 for utf8 varchar(2667) column Created: 2021-05-27  Updated: 2023-11-17  Resolved: 2022-09-14

Status: Closed
Project: MariaDB ColumnStore
Component/s: ?
Affects Version/s: 5.5.1, 5.5.2
Fix Version/s: None

Type: Bug Priority: Major
Reporter: Sasha V Assignee: Unassigned
Resolution: Duplicate Votes: 2
Labels: None
Environment:

Docker Debian 9


Issue Links:
Duplicate
duplicates MCOL-643 support longer then 8m rows in order by Closed

 Description   

Using server version 10.5.8-MariaDB-1:10.5.8+maria~stretch mariadb.org binary distribution
with ColumnStore storage engine PLUGIN_AUTH_VERSION 5.4.1-Stable one can get

CREATE TABLE t1(test varchar(2667)) ENGINE=Columnstore DEFAULT CHARSET=utf8;
Query OK, 0 rows affected (0.328 sec)

However, with later releases
Server version: 10.5.9-MariaDB MariaDB Server
or
Server version: 10.5.10-MariaDB-1:10.5.10+maria~stretch mariadb.org binary distribution
the command above fails:

CREATE TABLE t1(test varchar(2667)) ENGINE=Columnstore DEFAULT CHARSET=utf8;
ERROR 1815 (HY000): Internal error: CAL0009: (3)Create table failed due to char, varchar and varbinary length may not exceed 8000

Only lower length works:

CREATE TABLE t1(test varchar(2666)) ENGINE=Columnstore DEFAULT CHARSET=utf8;
Query OK, 0 rows affected (0.299 sec)

Also the error message looks confusing, since attempt to use varbinary in 10.5.10-MariaDB

create table t1(name varbinary(800)) engine=Columnstore;

results in

ERROR 1178 (42000): The storage engine for the table doesn't support Varbinary is currently not supported by Columnstore.

and the char length can't exceed 255:

create table t1(name char(256)) engine=Columnstore;
ERROR 1074 (42000): Column length too big for column 'name' (max = 255); use BLOB or TEXT instead



 Comments   
Comment by Egor Kuts [ 2021-06-02 ]

The same situation on the 10.5.10 version:
CREATE TABLE `ext_events` (
`event_info` varchar(8000) DEFAULT NULL,
`x` int(11) DEFAULT NULL,
`y` int(11) DEFAULT NULL,
`z` int(11) DEFAULT NULL
) ENGINE=Columnstore DEFAULT CHARSET=utf8mb4;

Comment by alexey vorovich (Inactive) [ 2022-06-16 ]

toddstoffel pls prioritize this . Per Dave -2-4 weeks

Generated at Thu Feb 08 02:52:35 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.