[MCOL-4476] Add the word "bytes" to the message on Error 1815 Created: 2020-12-29  Updated: 2022-05-25  Resolved: 2022-04-21

Status: Closed
Project: MariaDB ColumnStore
Component/s: Columnstore Select Handler
Affects Version/s: None
Fix Version/s: 22.08.1

Type: New Feature Priority: Trivial
Reporter: Juan Assignee: Todd Stoffel (Inactive)
Resolution: Fixed Votes: 0
Labels: None
Environment:

CentOS 7
MariaDB-server 10.5.8_5-1



 Description   

When the 8000 byte varchar column limit is exceeded, the error message reads:

MariaDB [test]> alter table products add column testchar varchar(2001) character set utf8mb4;
 
ERROR 1815 (HY000): Internal error: CAL0001: Alter table Failed:  AlterTableProcessor::addColumn char, varchar and varbinary length may not exceed 8000

If this could just specify the units like this:

MariaDB [test]> alter table products add column testchar varchar(2001) character set utf8mb4;
 
ERROR 1815 (HY000): Internal error: CAL0001: Alter table Failed:  AlterTableProcessor::addColumn char, varchar and varbinary length may not exceed 8000 bytes

it would save a lot of confusion for users, as can be seen in the associated support case.
Generated at Thu Feb 08 02:50:38 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.