[MCOL-491] Change the data range of Varchar and Varbinary Created: 2016-12-29  Updated: 2023-07-25  Resolved: 2023-07-02

Status: Closed
Project: MariaDB ColumnStore
Component/s: N/A
Affects Version/s: None
Fix Version/s: N/A

Type: New Feature Priority: Major
Reporter: Zeng Chun Assignee: Todd Stoffel (Inactive)
Resolution: Won't Do Votes: 1
Labels: Compatibility

Issue Links:
Relates
relates to MCOL-2055 insert..select inserts shorter string... Closed
relates to MCOL-4698 Optimize long string handling during DML Open
relates to MCOL-1374 Support utf8mb4 Closed
Epic Link: ColumnStore Compatibility Improvements
Sprint: 2021-7

 Description   

Keep the same definition for character or binary types between MariaDB ColumnStore and MariaDB. Thanks for your great support.

MariaDB ColumnStore:

  • VARCHAR/VARBINARY: Max length = 8000 bytes
    Moreover, The characters are counted by bytes, such as 1 character size in UTF-8 may be 3 or more. It will impact on the capacity of the varchar type.

MariaDB:

  • VARCHAR/VARBINARY: Max length = 65535 bytes
    The character are counted by characters, such as 1 character size in UTF-8 is 1.


 Comments   
Comment by David Hall (Inactive) [ 2021-04-19 ]

The charset is correct. That is, varchar(2000) with charset utf8mb4, will reserve 2000 utf8mb4 chacracters, not bytes as it used to be. This was corrected by MCOL-2000

However, the 8000 byte limit is still in place. It may be a simple case of changing the edit for length code.

Comment by David Hall (Inactive) [ 2021-04-27 ]

When the maximum of 8000 is relaxed, inserted strings start showing the same symptoms reported in MCOL-2055 for TEXT columns. However, when I tried adding the oid flush as in MCOL-2055, it didn't help.

Comment by Todd Stoffel (Inactive) [ 2023-07-02 ]

The "create date" on this ticket is pre-convergence with MariaDB server. If the issue still exists in a modern version of the engine/plugin please submit a new ticket.

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