Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-13313

JSON type alias is insufficiently compatible

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 10.2.7
    • 10.2.8
    • Data types, JSON
    • None

    Description

      Now it maps to TEXT. It'd be more compatible to map it to

        LONGTEXT CHARACTER SET utf8mb4 CHECK(JSON_VALID(col))
      

      But auto-adding a constraint is questionable. An unexpected constraint in the table definition, performance implications, strange errors if one manually specifies some constraint for this column.

      Attachments

        Issue Links

          Activity

            People

              serg Sergei Golubchik
              serg Sergei Golubchik
              Votes:
              1 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

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