Uploaded image for project: 'MariaDB ColumnStore'
  1. MariaDB ColumnStore
  2. MCOL-5985

Issue with JSON Alias on LONGTEXT (utf8mb4_bin) using Columnstore Engine

    XMLWordPrintable

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

      Attachments

        Activity

          People

            Unassigned Unassigned
            aeae81 andreas eschbacher
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.