Details
-
Bug
-
Status: Closed (View Workflow)
-
Blocker
-
Resolution: Fixed
-
1.2.0
-
None
-
None
-
2021-8, 2021-9
Description
Columnstore claims support for 2GB long LONGTEXT and LONGBLOB, to be in line with InnoDB.
However, internal implementation is insufficiently strong. On one hand, it allocates the buffer for the maximum row size, but then it is unable to handle the data because the buffer length in the code is integer, and cannot exceed 2GB.
It has been noted that our main competitors - RedShift and SnowFlake limit LONTEXT and LONGBLOB to just 16MB.
For 6.1.1 the resolution will be:
- reduce the limit to 16MB
- Change the documentation accordingly - jacob.moorman
After the change, the crash may still be present if the table would have over 100 LONGTEXT fields, an unrelaistic scenario.
The original ticket - MCOL-3879 will, in due time, protect from that as well.
Attachments
Issue Links
- split from
-
MCOL-3879 ExeMgr crash on select - SELECT TABLE FROM -- WHERE scan_code = 'DUP' and id_datasource <> 1002;
- Closed