[MCOL-489] Remove row size limitation of 65535 Created: 2016-12-29 Updated: 2017-12-01 Resolved: 2017-11-14 |
|
| Status: | Closed |
| Project: | MariaDB ColumnStore |
| Component/s: | MDB Plugin |
| Affects Version/s: | None |
| Fix Version/s: | 1.1.0 |
| Type: | New Feature | Priority: | Minor |
| Reporter: | Zeng Chun | Assignee: | Andrew Hutchings (Inactive) |
| Resolution: | Fixed | Votes: | 1 |
| Labels: | None | ||
| Description |
|
Copied from the thread: I think my use case is very common. We have a 1500 columns table where each row stores all the data of a single transaction. In order to create the table in the columnstore engine, we kept getting the error: "Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535" The row size (and max number of columns of 4096) is a limit enforced by the mariadb server derived from the original mysql code base. Two options: I set this issue as major priority for it will impact on the marketing of MariaDB ColumnStore. Thanks for your great support. |
| Comments |
| Comment by David Thompson (Inactive) [ 2016-12-30 ] |
|
It is more likely that we'll support blob and text first and these will be tracked in the referenced tickets. The row size limitation is more of a fundamental limitation in mariadb server going all the way back to mysql. As such this is likely to be a fairly high effort. |
| Comment by Andrew Hutchings (Inactive) [ 2017-11-14 ] |
|
Closing this as fixed in 1.1.0 since we now support BLOB/TEXT columns in 1.1. |