[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: |
|
||||||||
| Description |
|
Using server version 10.5.8-MariaDB-1:10.5.8+maria~stretch mariadb.org binary distribution CREATE TABLE t1(test varchar(2667)) ENGINE=Columnstore DEFAULT CHARSET=utf8; However, with later releases CREATE TABLE t1(test varchar(2667)) ENGINE=Columnstore DEFAULT CHARSET=utf8; Only lower length works: CREATE TABLE t1(test varchar(2666)) ENGINE=Columnstore DEFAULT CHARSET=utf8; 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; |
| Comments |
| Comment by Egor Kuts [ 2021-06-02 ] |
|
The same situation on the 10.5.10 version: |
| Comment by alexey vorovich (Inactive) [ 2022-06-16 ] |
|
toddstoffel pls prioritize this . Per Dave -2-4 weeks |