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

JSON DATA TYPE (MySql 5.7.8)

Details

    Description

      Dear colleagues, my name is Smail and I'm new to this community and I hope you go easy on me.

      I'm using MySql for 7 years now, even before MariaDb was a thing.

      We believed Monty and migrated immediately, but since then nothing happened.

      PostgreSql is way ahead of you these days, I would have migrated again, if our system was small.

      Recently I was excited about the upcoming features namely "Window Functions" and JSON, but then I was disappointed when I found out that you don't plan to support JSON DATA TYPE (MySql 5.7.8).

      Dynamic Column != JSON, they don't have anything in common.

      If I have to create columns, why would I use JSON, I can just create normal tables.

      engine=Connect -> I strongly recommend dropping that one, It's way too new and doesn't support transactions.

      We want JSON Data Type support in this version!

      Attachments

        Issue Links

          is duplicated by

          Task - A task that needs to be done. MDEV-9144 JSON data type

          • Major - Major loss of function.
          • Closed

          Activity

            serg Sergei Golubchik added a comment -

            10.2 has JSON functions, but not the JSON data type, because SQL standard specifies that JSON should be stored in normal VARCHARs, there should be no special JSON type.

            Nevertheless, we have a task for JSON type (MDEV-9144), but it's not planned for 10.2 or 10.3.

            serg Sergei Golubchik added a comment - 10.2 has JSON functions, but not the JSON data type, because SQL standard specifies that JSON should be stored in normal VARCHARs, there should be no special JSON type. Nevertheless, we have a task for JSON type ( MDEV-9144 ), but it's not planned for 10.2 or 10.3.

            People

              serg Sergei Golubchik
              Smail Smail Mustafa
              Votes:
              0 Vote for this issue
              Watchers:
              2 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.