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

JSON is Unknown while replicating

Details

    Description

      While replicating JSON from MySQL to mariaDB, it says cannot convert the datatype.
      err:
      Column 0 of table 'test.json_test' cannot be converted from type '<unknown type>' to type 'longtext'

      While writing to relay log, JSON has to be remapped as long text (because we have JSON an alias for longtext) until we have full fledged JSON datatype.

      Thanks,
      ALI

      Attachments

        Activity

          elenst Elena Stepanova added a comment -

          The subject has now been explicitly clarified in MariaDB documentation:

          The JSON type in MySQL stores the JSON object in a compact form, not as LONGTEXT as in MariaDB. This means that row based replication will not work for JSON types from MySQL to MariaDB.

          There are a a few different ways to solve this:

          Use statement based replication.
          Change the JSON column to type TEXT in MySQL

          elenst Elena Stepanova added a comment - The subject has now been explicitly clarified in MariaDB documentation : The JSON type in MySQL stores the JSON object in a compact form, not as LONGTEXT as in MariaDB. This means that row based replication will not work for JSON types from MySQL to MariaDB. There are a a few different ways to solve this: Use statement based replication. Change the JSON column to type TEXT in MySQL

          People

            Unassigned Unassigned
            alimajaf Muhammedali KV
            Votes:
            0 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.