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

INET6 representation doesn't seem to follow RFC 5952

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Open (View Workflow)
    • Priority: Minor
    • Resolution: Unresolved
    • Affects Version/s: 10.5.15, 10.5, 10.6, 10.7, 10.8
    • Fix Version/s: 10.5, 10.6, 10.7
    • Component/s: Data types
    • Labels:

      Description

      4.2.2. Handling One 16-Bit 0 Field

      The symbol "::" MUST NOT be used to shorten just one 16-bit 0 field.
      For example, the representation 2001:db8:0:1:1:1:1:1 is correct, but
      2001:db8::1:1:1:1:1 is not correct.
      https://datatracker.ietf.org/doc/html/rfc5952#section-4.2.2

      The single 0 is lost:

      MariaDB [test]> create table tin (addr inet6);
      Query OK, 0 rows affected (0.354 sec)
       
      MariaDB [test]> insert into tin (addr) values ('2a00:1a40:0:119:ed51:8d3:1821:7cd5');
      Query OK, 1 row affected (0.072 sec)
       
      MariaDB [test]> insert into tin (addr) values ('2a00:1a40:0:0:ed51:8d3:1821:7cd5');
      Query OK, 1 row affected (0.037 sec)
       
      MariaDB [test]> select * from tin;
      +-----------------------------------+
      | addr                              |
      +-----------------------------------+
      | 2a00:1a40::119:ed51:8d3:1821:7cd5 |
      | 2a00:1a40::ed51:8d3:1821:7cd5     |
      +-----------------------------------+
      2 rows in set (0.001 sec)
      

        Attachments

          Activity

            People

            Assignee:
            bar Alexander Barkov
            Reporter:
            Ale2019 Alessandro Vesely
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

              Dates

              Created:
              Updated:

                Git Integration

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