← Back to team overview

group.of.nepali.translators team mailing list archive

[Bug 1571605] Re: Backport the ->> operator to MySQL 5.7

 

5.7.13-0ubuntu3 is in 16.10.

** Changed in: mysql-5.7 (Ubuntu)
       Status: Triaged => Fix Released

-- 
You received this bug notification because you are a member of नेपाली
भाषा समायोजकहरुको समूह, which is subscribed to Xenial.
Matching subscriptions: Ubuntu 16.04 Bugs
https://bugs.launchpad.net/bugs/1571605

Title:
  Backport the ->> operator to MySQL 5.7

Status in mysql-5.7 package in Ubuntu:
  Fix Released
Status in mysql-5.7 source package in Xenial:
  Triaged

Bug description:
  As agreed with Robie Basak (racb), I'm filing this request for
  backporting a feature from 5.8 to the 5.7 stable branch so that it can
  be considered by the SRU Team and returned as input to
  upstream. Upstream is waiting for response from distros before
  deciding whether to backport or not.

  
  Background
  ==========

  MySQL 5.7 introduced a new JSON datatype, functions and operators to
  inspect and modify JSON documents. The JSON support has received a lot
  of attention and user feedback, and after requests from users, a new
  operator was introduced in MySQL 5.8 that makes the syntax more
  readable and easy to use.

  The new operator is only syntactic sugar, not new functionality.

  The new operator "->>" is a shorthand that allows the user to write

      json_field->>"$.a_key"

  instead of

      JSON_UNQUOTE(JSON_EXTRACT(json_field, "$.a_key"))

  Because of the immediate user requests on a new feature, upstream
  would like to backport this syntax to MySQL 5.7. If backported, it
  will be done after the release of Ubuntu 16.04, so it will affect an
  existing Ubuntu release.

  This does not fall under the existing microrelease exception for
  MySQL, and so must be considered separately. In consideration of the
  microrelease exception requirements, upstream is interested in a
  decision for acceptance in an Ubuntu SRU before making the change
  upstream, so that any change made, or not made, is consistent across
  upstream, Ubuntu and any other distribution that wish to follow suit.

  We would like a +1 or a -1 from the SRU team (or Technical Board if
  appropriate) on backporting it to 5.7.

  
  Impact
  ======

  If backported, the new syntax will be a built-in, non-optional part of
  the server. It is not suited for implementation in an optional plugin.

  MySQL 5.7 is not yet in Ubuntu, but will be when the new syntax can be
  backported.

  JSON functionality is new in 5.7, so the user base is limited. No
  packages in Ubuntu currently use this functionality.

  
  Regression potential
  ====================

  The potential for regression is considered low for the following
  reasons:

   - The new operator is pure syntactic sugar, no new functionality is
     added

   - The change is very small and localized

   - The change allows new syntax, no existing syntax is affected
   
   - No packages in Ubuntu currently use the JSON functionality of MySQL

To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/mysql-5.7/+bug/1571605/+subscriptions