Details

    • Task
    • Status: Closed (View Workflow)
    • Blocker
    • Resolution: Fixed
    • 10.2.3
    • OTHER
    • None
    • 10.2.0-9, 10.2.0-10, 10.2.0-11, 10.2.1-1, 10.2.1-3, 10.2.1-4, 10.2.1-5, 10.2.2-1, 10.2.2-1, 10.2.2-2, 10.2.2-3, 5.5.51 & 10.2.2, 10.2.2-1, 10.2.2-2, 10.2.2-3, 10.2.2-4, 10.2.3-1, 10.2.3-2, 10.0.28, 10.2.4-2

    Description

      JSON_xxx functions as in 5.7 and SQL standard (?)

      Attachments

        Issue Links

          Activity

            serg Sergei Golubchik created issue -
            serg Sergei Golubchik made changes -
            Field Original Value New Value
            serg Sergei Golubchik made changes -
            serg Sergei Golubchik made changes -
            Fix Version/s 10.2 [ 14601 ]
            serg Sergei Golubchik made changes -
            Assignee Alexey Botchkov [ holyfoot ]
            ratzpo Rasmus Johansson (Inactive) made changes -
            Sprint 10.2.0-9 [ 43 ]
            ratzpo Rasmus Johansson (Inactive) made changes -
            Rank Ranked higher
            holyfoot Alexey Botchkov made changes -
            Status Open [ 1 ] In Progress [ 3 ]
            ratzpo Rasmus Johansson (Inactive) made changes -
            Sprint 10.2.0-9 [ 43 ] 10.2.0-9, 10.2.0-10 [ 43, 46 ]
            ratzpo Rasmus Johansson (Inactive) made changes -
            Sprint 10.2.0-9, 10.2.0-10 [ 43, 46 ] 10.2.0-9, 10.2.0-10, 10.2.0-11 [ 43, 46, 47 ]
            ratzpo Rasmus Johansson (Inactive) made changes -
            Sprint 10.2.0-9, 10.2.0-10, 10.2.0-11 [ 43, 46, 47 ] 10.2.0-9, 10.2.0-10, 10.2.0-11, 10.2.1-1 [ 43, 46, 47, 56 ]
            ratzpo Rasmus Johansson (Inactive) made changes -
            Sprint 10.2.0-9, 10.2.0-10, 10.2.0-11, 10.2.1-1 [ 43, 46, 47, 56 ] 10.2.0-9, 10.2.0-10, 10.2.0-11, 10.2.1-1, 10.2.1-2 [ 43, 46, 47, 56, 63 ]
            ratzpo Rasmus Johansson (Inactive) made changes -
            Sprint 10.2.0-9, 10.2.0-10, 10.2.0-11, 10.2.1-1, 10.2.1-2 [ 43, 46, 47, 56, 63 ] 10.2.0-9, 10.2.0-10, 10.2.0-11, 10.2.1-1, 10.2.1-3 [ 43, 46, 47, 56, 65 ]
            ratzpo Rasmus Johansson (Inactive) made changes -
            Rank Ranked lower
            ratzpo Rasmus Johansson (Inactive) made changes -
            Sprint 10.2.0-9, 10.2.0-10, 10.2.0-11, 10.2.1-1, 10.2.1-3 [ 43, 46, 47, 56, 65 ] 10.2.0-9, 10.2.0-10, 10.2.0-11, 10.2.1-1, 10.2.1-3, 10.2.1-4 [ 43, 46, 47, 56, 65, 66 ]
            holyfoot Alexey Botchkov added a comment - First patch proposal: http://lists.askmonty.org/pipermail/commits/2016-May/009406.html
            holyfoot Alexey Botchkov made changes -
            Assignee Alexey Botchkov [ holyfoot ] Sergei Golubchik [ serg ]
            Status In Progress [ 3 ] In Review [ 10002 ]
            ratzpo Rasmus Johansson (Inactive) made changes -
            Sprint 10.2.0-9, 10.2.0-10, 10.2.0-11, 10.2.1-1, 10.2.1-3, 10.2.1-4 [ 43, 46, 47, 56, 65, 66 ] 10.2.0-9, 10.2.0-10, 10.2.0-11, 10.2.1-1, 10.2.1-3, 10.2.1-4, 10.2.1-5 [ 43, 46, 47, 56, 65, 66, 68 ]
            holyfoot Alexey Botchkov made changes -
            Assignee Sergei Golubchik [ serg ] Alexey Botchkov [ holyfoot ]
            ratzpo Rasmus Johansson (Inactive) made changes -
            Sprint 10.2.0-9, 10.2.0-10, 10.2.0-11, 10.2.1-1, 10.2.1-3, 10.2.1-4, 10.2.1-5 [ 43, 46, 47, 56, 65, 66, 68 ] 10.2.0-9, 10.2.0-10, 10.2.0-11, 10.2.1-1, 10.2.1-3, 10.2.1-4, 10.2.1-5, 10.2.2-1 [ 43, 46, 47, 56, 65, 66, 68, 77 ]
            ratzpo Rasmus Johansson (Inactive) made changes -
            Rank Ranked lower
            ratzpo Rasmus Johansson (Inactive) made changes -
            Sprint 10.2.0-9, 10.2.0-10, 10.2.0-11, 10.2.1-1, 10.2.1-3, 10.2.1-4, 10.2.1-5, 10.2.2-1 [ 43, 46, 47, 56, 65, 66, 68, 77 ] 10.2.0-9, 10.2.0-10, 10.2.0-11, 10.2.1-1, 10.2.1-3, 10.2.1-4, 10.2.1-5, 10.2.2-1, 10.2.2-1 [ 43, 46, 47, 56, 65, 66, 68, 77, 79 ]
            ratzpo Rasmus Johansson (Inactive) made changes -
            Rank Ranked higher
            ratzpo Rasmus Johansson (Inactive) made changes -
            Sprint 10.2.0-9, 10.2.0-10, 10.2.0-11, 10.2.1-1, 10.2.1-3, 10.2.1-4, 10.2.1-5, 10.2.2-1, 10.2.2-1 [ 43, 46, 47, 56, 65, 66, 68, 77, 79 ] 10.2.0-9, 10.2.0-10, 10.2.0-11, 10.2.1-1, 10.2.1-3, 10.2.1-4, 10.2.1-5, 10.2.2-1, 10.2.2-1, 10.2.2-2 [ 43, 46, 47, 56, 65, 66, 68, 77, 79, 82 ]
            holyfoot Alexey Botchkov added a comment - patch v2.0 http://lists.askmonty.org/pipermail/commits/2016-July/009555.html
            holyfoot Alexey Botchkov made changes -
            Assignee Alexey Botchkov [ holyfoot ] Sergei Golubchik [ serg ]
            ratzpo Rasmus Johansson (Inactive) made changes -
            Sprint 10.2.0-9, 10.2.0-10, 10.2.0-11, 10.2.1-1, 10.2.1-3, 10.2.1-4, 10.2.1-5, 10.2.2-1, 10.2.2-1, 10.2.2-2 [ 43, 46, 47, 56, 65, 66, 68, 77, 79, 82 ] 10.2.0-9, 10.2.0-10, 10.2.0-11, 10.2.1-1, 10.2.1-3, 10.2.1-4, 10.2.1-5, 10.2.2-1, 10.2.2-1, 10.2.2-2, 10.2.2-3 [ 43, 46, 47, 56, 65, 66, 68, 77, 79, 82, 83 ]
            serg Sergei Golubchik made changes -
            Assignee Sergei Golubchik [ serg ] Alexey Botchkov [ holyfoot ]
            Status In Review [ 10002 ] Stalled [ 10000 ]
            ratzpo Rasmus Johansson (Inactive) made changes -
            Sprint 10.2.0-9, 10.2.0-10, 10.2.0-11, 10.2.1-1, 10.2.1-3, 10.2.1-4, 10.2.1-5, 10.2.2-1, 10.2.2-1, 10.2.2-2, 10.2.2-3 [ 43, 46, 47, 56, 65, 66, 68, 77, 79, 82, 83 ] 10.2.0-9, 10.2.0-10, 10.2.0-11, 10.2.1-1, 10.2.1-3, 10.2.1-4, 10.2.1-5, 10.2.2-1, 10.2.2-1, 10.2.2-2, 10.2.2-3, 5.51 & 10.2 [ 43, 46, 47, 56, 65, 66, 68, 77, 79, 82, 83, 85 ]
            ratzpo Rasmus Johansson (Inactive) made changes -
            Rank Ranked higher
            ratzpo Rasmus Johansson (Inactive) made changes -
            Sprint 10.2.0-9, 10.2.0-10, 10.2.0-11, 10.2.1-1, 10.2.1-3, 10.2.1-4, 10.2.1-5, 10.2.2-1, 10.2.2-1, 10.2.2-2, 10.2.2-3, 5.5.51 & 10.2.2 [ 43, 46, 47, 56, 65, 66, 68, 77, 79, 82, 83, 85 ] 10.2.0-9, 10.2.0-10, 10.2.0-11, 10.2.1-1, 10.2.1-3, 10.2.1-4, 10.2.1-5, 10.2.2-1, 10.2.2-1, 10.2.2-2, 10.2.2-3, 5.5.51 & 10.2.2, 10.2.2-1 [ 43, 46, 47, 56, 65, 66, 68, 77, 79, 82, 83, 85, 89 ]
            ratzpo Rasmus Johansson (Inactive) made changes -
            Rank Ranked higher
            ratzpo Rasmus Johansson (Inactive) made changes -
            Sprint 10.2.0-9, 10.2.0-10, 10.2.0-11, 10.2.1-1, 10.2.1-3, 10.2.1-4, 10.2.1-5, 10.2.2-1, 10.2.2-1, 10.2.2-2, 10.2.2-3, 5.5.51 & 10.2.2, 10.2.2-1 [ 43, 46, 47, 56, 65, 66, 68, 77, 79, 82, 83, 85, 89 ] 10.2.0-9, 10.2.0-10, 10.2.0-11, 10.2.1-1, 10.2.1-3, 10.2.1-4, 10.2.1-5, 10.2.2-1, 10.2.2-1, 10.2.2-2, 10.2.2-3, 5.5.51 & 10.2.2, 10.2.2-1, 10.2.2-2 [ 43, 46, 47, 56, 65, 66, 68, 77, 79, 82, 83, 85, 89, 92 ]
            ratzpo Rasmus Johansson (Inactive) made changes -
            Rank Ranked lower
            holyfoot Alexey Botchkov made changes -
            Status Stalled [ 10000 ] In Progress [ 3 ]
            holyfoot Alexey Botchkov made changes -
            Assignee Alexey Botchkov [ holyfoot ] Sergei Golubchik [ serg ]
            Status In Progress [ 3 ] In Review [ 10002 ]
            ratzpo Rasmus Johansson (Inactive) made changes -
            Sprint 10.2.0-9, 10.2.0-10, 10.2.0-11, 10.2.1-1, 10.2.1-3, 10.2.1-4, 10.2.1-5, 10.2.2-1, 10.2.2-1, 10.2.2-2, 10.2.2-3, 5.5.51 & 10.2.2, 10.2.2-1, 10.2.2-2 [ 43, 46, 47, 56, 65, 66, 68, 77, 79, 82, 83, 85, 89, 92 ] 10.2.0-9, 10.2.0-10, 10.2.0-11, 10.2.1-1, 10.2.1-3, 10.2.1-4, 10.2.1-5, 10.2.2-1, 10.2.2-1, 10.2.2-2, 10.2.2-3, 5.5.51 & 10.2.2, 10.2.2-1, 10.2.2-2, 10.2.2-3 [ 43, 46, 47, 56, 65, 66, 68, 77, 79, 82, 83, 85, 89, 92, 94 ]
            serg Sergei Golubchik made changes -
            Assignee Sergei Golubchik [ serg ] Alexey Botchkov [ holyfoot ]
            Status In Review [ 10002 ] Stalled [ 10000 ]
            holyfoot Alexey Botchkov made changes -
            Status Stalled [ 10000 ] In Progress [ 3 ]
            holyfoot Alexey Botchkov added a comment - patch v3.0 http://lists.askmonty.org/pipermail/commits/2016-September/009854.html
            holyfoot Alexey Botchkov made changes -
            Assignee Alexey Botchkov [ holyfoot ] Sergei Golubchik [ serg ]
            Status In Progress [ 3 ] In Review [ 10002 ]
            ratzpo Rasmus Johansson (Inactive) made changes -
            Sprint 10.2.0-9, 10.2.0-10, 10.2.0-11, 10.2.1-1, 10.2.1-3, 10.2.1-4, 10.2.1-5, 10.2.2-1, 10.2.2-1, 10.2.2-2, 10.2.2-3, 5.5.51 & 10.2.2, 10.2.2-1, 10.2.2-2, 10.2.2-3 [ 43, 46, 47, 56, 65, 66, 68, 77, 79, 82, 83, 85, 89, 92, 94 ] 10.2.0-9, 10.2.0-10, 10.2.0-11, 10.2.1-1, 10.2.1-3, 10.2.1-4, 10.2.1-5, 10.2.2-1, 10.2.2-1, 10.2.2-2, 10.2.2-3, 5.5.51 & 10.2.2, 10.2.2-1, 10.2.2-2, 10.2.2-3, 10.2.2-4 [ 43, 46, 47, 56, 65, 66, 68, 77, 79, 82, 83, 85, 89, 92, 94, 96 ]
            serg Sergei Golubchik made changes -
            Assignee Sergei Golubchik [ serg ] Alexey Botchkov [ holyfoot ]
            Status In Review [ 10002 ] Stalled [ 10000 ]
            ratzpo Rasmus Johansson (Inactive) made changes -
            Sprint 10.2.0-9, 10.2.0-10, 10.2.0-11, 10.2.1-1, 10.2.1-3, 10.2.1-4, 10.2.1-5, 10.2.2-1, 10.2.2-1, 10.2.2-2, 10.2.2-3, 5.5.51 & 10.2.2, 10.2.2-1, 10.2.2-2, 10.2.2-3, 10.2.2-4 [ 43, 46, 47, 56, 65, 66, 68, 77, 79, 82, 83, 85, 89, 92, 94, 96 ] 10.2.0-9, 10.2.0-10, 10.2.0-11, 10.2.1-1, 10.2.1-3, 10.2.1-4, 10.2.1-5, 10.2.2-1, 10.2.2-1, 10.2.2-2, 10.2.2-3, 5.5.51 & 10.2.2, 10.2.2-1, 10.2.2-2, 10.2.2-3, 10.2.2-4, 10.2.3-1 [ 43, 46, 47, 56, 65, 66, 68, 77, 79, 82, 83, 85, 89, 92, 94, 96, 102 ]
            ratzpo Rasmus Johansson (Inactive) made changes -
            Rank Ranked lower
            holyfoot Alexey Botchkov made changes -
            Status Stalled [ 10000 ] In Progress [ 3 ]
            holyfoot Alexey Botchkov added a comment - unittest added. http://lists.askmonty.org/pipermail/commits/2016-October/009959.html

            See my reply to your review, and the new unittest commit.

            holyfoot Alexey Botchkov added a comment - See my reply to your review, and the new unittest commit.
            holyfoot Alexey Botchkov made changes -
            Assignee Alexey Botchkov [ holyfoot ] Sergei Golubchik [ serg ]
            Status In Progress [ 3 ] In Review [ 10002 ]
            serg Sergei Golubchik made changes -
            Assignee Sergei Golubchik [ serg ] Alexey Botchkov [ holyfoot ]
            Status In Review [ 10002 ] Stalled [ 10000 ]
            ratzpo Rasmus Johansson (Inactive) made changes -
            Sprint 10.2.0-9, 10.2.0-10, 10.2.0-11, 10.2.1-1, 10.2.1-3, 10.2.1-4, 10.2.1-5, 10.2.2-1, 10.2.2-1, 10.2.2-2, 10.2.2-3, 5.5.51 & 10.2.2, 10.2.2-1, 10.2.2-2, 10.2.2-3, 10.2.2-4, 10.2.3-1 [ 43, 46, 47, 56, 65, 66, 68, 77, 79, 82, 83, 85, 89, 92, 94, 96, 102 ] 10.2.0-9, 10.2.0-10, 10.2.0-11, 10.2.1-1, 10.2.1-3, 10.2.1-4, 10.2.1-5, 10.2.2-1, 10.2.2-1, 10.2.2-2, 10.2.2-3, 5.5.51 & 10.2.2, 10.2.2-1, 10.2.2-2, 10.2.2-3, 10.2.2-4, 10.2.3-1, 10.2.3-2 [ 43, 46, 47, 56, 65, 66, 68, 77, 79, 82, 83, 85, 89, 92, 94, 96, 102, 105 ]
            serg Sergei Golubchik made changes -
            Priority Major [ 3 ] Blocker [ 1 ]
            ratzpo Rasmus Johansson (Inactive) made changes -
            Sprint 10.2.0-9, 10.2.0-10, 10.2.0-11, 10.2.1-1, 10.2.1-3, 10.2.1-4, 10.2.1-5, 10.2.2-1, 10.2.2-1, 10.2.2-2, 10.2.2-3, 5.5.51 & 10.2.2, 10.2.2-1, 10.2.2-2, 10.2.2-3, 10.2.2-4, 10.2.3-1, 10.2.3-2 [ 43, 46, 47, 56, 65, 66, 68, 77, 79, 82, 83, 85, 89, 92, 94, 96, 102, 105 ] 10.2.0-9, 10.2.0-10, 10.2.0-11, 10.2.1-1, 10.2.1-3, 10.2.1-4, 10.2.1-5, 10.2.2-1, 10.2.2-1, 10.2.2-2, 10.2.2-3, 5.5.51 & 10.2.2, 10.2.2-1, 10.2.2-2, 10.2.2-3, 10.2.2-4, 10.2.3-1, 10.2.3-2, 10.0.28 [ 43, 46, 47, 56, 65, 66, 68, 77, 79, 82, 83, 85, 89, 92, 94, 96, 102, 105, 107 ]
            ratzpo Rasmus Johansson (Inactive) made changes -
            Rank Ranked higher
            ratzpo Rasmus Johansson (Inactive) made changes -
            Sprint 10.2.0-9, 10.2.0-10, 10.2.0-11, 10.2.1-1, 10.2.1-3, 10.2.1-4, 10.2.1-5, 10.2.2-1, 10.2.2-1, 10.2.2-2, 10.2.2-3, 5.5.51 & 10.2.2, 10.2.2-1, 10.2.2-2, 10.2.2-3, 10.2.2-4, 10.2.3-1, 10.2.3-2, 10.0.28 [ 43, 46, 47, 56, 65, 66, 68, 77, 79, 82, 83, 85, 89, 92, 94, 96, 102, 105, 107 ] 10.2.0-9, 10.2.0-10, 10.2.0-11, 10.2.1-1, 10.2.1-3, 10.2.1-4, 10.2.1-5, 10.2.2-1, 10.2.2-1, 10.2.2-2, 10.2.2-3, 5.5.51 & 10.2.2, 10.2.2-1, 10.2.2-2, 10.2.2-3, 10.2.2-4, 10.2.3-1, 10.2.3-2, 10.0.28, 10.2.4-1 [ 43, 46, 47, 56, 65, 66, 68, 77, 79, 82, 83, 85, 89, 92, 94, 96, 102, 105, 107, 110 ]
            ratzpo Rasmus Johansson (Inactive) made changes -
            Rank Ranked higher
            ratzpo Rasmus Johansson (Inactive) made changes -
            Sprint 10.2.0-9, 10.2.0-10, 10.2.0-11, 10.2.1-1, 10.2.1-3, 10.2.1-4, 10.2.1-5, 10.2.2-1, 10.2.2-1, 10.2.2-2, 10.2.2-3, 5.5.51 & 10.2.2, 10.2.2-1, 10.2.2-2, 10.2.2-3, 10.2.2-4, 10.2.3-1, 10.2.3-2, 10.0.28, 10.2.4-1 [ 43, 46, 47, 56, 65, 66, 68, 77, 79, 82, 83, 85, 89, 92, 94, 96, 102, 105, 107, 110 ] 10.2.0-9, 10.2.0-10, 10.2.0-11, 10.2.1-1, 10.2.1-3, 10.2.1-4, 10.2.1-5, 10.2.2-1, 10.2.2-1, 10.2.2-2, 10.2.2-3, 5.5.51 & 10.2.2, 10.2.2-1, 10.2.2-2, 10.2.2-3, 10.2.2-4, 10.2.3-1, 10.2.3-2, 10.0.28, 10.2.4-2 [ 43, 46, 47, 56, 65, 66, 68, 77, 79, 82, 83, 85, 89, 92, 94, 96, 102, 105, 107, 113 ]
            ratzpo Rasmus Johansson (Inactive) made changes -
            Rank Ranked lower
            holyfoot Alexey Botchkov added a comment - Implementing the rest of the functions. http://lists.askmonty.org/pipermail/commits/2016-November/010087.html
            holyfoot Alexey Botchkov made changes -
            issue.field.resolutiondate 2016-11-15 13:23:59.0 2016-11-15 13:23:59.256
            holyfoot Alexey Botchkov made changes -
            Component/s OTHER [ 10125 ]
            Fix Version/s 10.2.5 [ 22117 ]
            Fix Version/s 10.2 [ 14601 ]
            Resolution Fixed [ 1 ]
            Status Stalled [ 10000 ] Closed [ 6 ]
            elenst Elena Stepanova made changes -
            serg Sergei Golubchik made changes -
            Fix Version/s 10.2.3 [ 22115 ]
            Fix Version/s 10.2.5 [ 22117 ]
            elenst Elena Stepanova made changes -
            elenst Elena Stepanova made changes -
            elenst Elena Stepanova made changes -
            elenst Elena Stepanova made changes -
            elenst Elena Stepanova made changes -
            elenst Elena Stepanova made changes -
            elenst Elena Stepanova made changes -
            elenst Elena Stepanova made changes -
            elenst Elena Stepanova made changes -
            elenst Elena Stepanova made changes -
            elenst Elena Stepanova made changes -
            elenst Elena Stepanova made changes -
            elenst Elena Stepanova made changes -
            elenst Elena Stepanova made changes -
            elenst Elena Stepanova made changes -
            elenst Elena Stepanova made changes -
            elenst Elena Stepanova made changes -
            elenst Elena Stepanova made changes -
            elenst Elena Stepanova made changes -
            elenst Elena Stepanova made changes -
            elenst Elena Stepanova made changes -
            elenst Elena Stepanova made changes -
            elenst Elena Stepanova made changes -
            elenst Elena Stepanova made changes -
            elenst Elena Stepanova made changes -
            elenst Elena Stepanova made changes -
            elenst Elena Stepanova made changes -
            elenst Elena Stepanova made changes -
            elenst Elena Stepanova made changes -
            elenst Elena Stepanova made changes -
            elenst Elena Stepanova made changes -
            elenst Elena Stepanova made changes -
            elenst Elena Stepanova made changes -
            elenst Elena Stepanova made changes -
            elenst Elena Stepanova made changes -
            elenst Elena Stepanova made changes -
            elenst Elena Stepanova made changes -
            elenst Elena Stepanova made changes -
            elenst Elena Stepanova made changes -
            serg Sergei Golubchik made changes -
            StevenWdV Steven WdV added a comment -

            A have a question (sorry if this is the wrong place for it): why do the JSON functions not return compacted JSON?
            For example:

            SELECT JSON_ARRAY(1,2,3)

            returns [1, 2, 3] instead of [1,2,3] (without spaces). Of course we can compact it with JSON_COMPACT, but it would probably more efficiënt to not put spaces in in the first place, since you rarely want loose JSON to appear in a database.

            StevenWdV Steven WdV added a comment - A have a question (sorry if this is the wrong place for it): why do the JSON functions not return compacted JSON? For example: SELECT JSON_ARRAY(1,2,3) returns [1, 2, 3] instead of [1,2,3] (without spaces). Of course we can compact it with JSON_COMPACT , but it would probably more efficiënt to not put spaces in in the first place, since you rarely want loose JSON to appear in a database.
            serg Sergei Golubchik made changes -
            Workflow MariaDB v3 [ 72619 ] MariaDB v4 [ 132729 ]

            People

              holyfoot Alexey Botchkov
              serg Sergei Golubchik
              Votes:
              2 Vote for this issue
              Watchers:
              6 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.