Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
23.10.3
-
None
-
None
-
Red Hat Enterprise Linux release 9.4 (Plow)
10.6.20-16-MariaDB-enterprise
Columnstore_version | 23.10.3
Description
Dear Support Team,
We have observed that the JSON alias type defined for a LONGTEXT COLLATE utf8mb4_bin column does not appear to work correctly when using the Columnstore engine.
Notably, this same configuration functions as expected with the InnoDB engine.
Please find our detailed error description attached (EBI-1236_new_bug_exposal.zip).
The core problem is that storing large JSON documents in a LONGTEXT COLLATE utf8mb4_bin column fails specifically when the table uses the Columnstore engine.
However:
Storing small JSON documents works correctly under the exact same conditions (Columnstore engine, LONGTEXT column).
Using the InnoDB engine, both large and small JSON documents can be successfully stored in the LONGTEXT column without any issues.
This behavior seems to contradict the official documentation, which states that LONGTEXT should be capable of storing up to 4 GB of data. Apparently, this limit is not being respected for large JSON documents when the Columnstore engine is involved.
Best regards,
Andreas
EBI-2231