[MCOL-165] CHAR(0)/VARCHAR(0) not supported Created: 2016-06-22 Updated: 2021-05-13 Resolved: 2021-05-13 |
|
| Status: | Closed |
| Project: | MariaDB ColumnStore |
| Component/s: | Documentation |
| Affects Version/s: | None |
| Fix Version/s: | 5.6.1 |
| Type: | Task | Priority: | Minor |
| Reporter: | Justin Swanhart (Inactive) | Assignee: | Geoff Montee (Inactive) |
| Resolution: | Done | Votes: | 0 |
| Labels: | None | ||
| Epic Link: | ColumnStore Compatibility Improvements |
| Description |
|
MariaDB supports CHAR(0) / VARCHAR(0) but columnstore does not. This limitation doesn't appear to be documented in the data type section of the KB. |
| Comments |
| Comment by David Thompson (Inactive) [ 2016-10-07 ] |
|
The KB does now reflect that 0 is not a valid length for char and varchar (minimum of 1). Until This article explains the reason and potential use cases for a 0 length string: |