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

Wrong result of MIN(inet6) with GROUP BY

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 10.5
    • 10.5.0
    • Data types
    • None

    Description

      CREATE OR REPLACE TABLE t1 (id INT, a INET6) ENGINE=MyISAM;
      		 
      INSERT INTO t1 VALUES (1, 'fff::'),(1, '8888::');
      		 
      SELECT MIN(a), MAX(a) FROM t1 GROUP BY id;


      +--------+--------+
      		 
      | MIN(a) | MAX(a) |
      		 
      +--------+--------+
      		 
      | 8888:: | fff::  |
      		 
      +--------+--------+

      Looks wrong. The INET6 value '8888::' is greater than 'fff::'.

      Attachments

        Issue Links

          relates to

          Task - A task that needs to be done. MDEV-274 The data type for IPv6/IPv4 addresses in MariaDB

          • Major - Major loss of function.
          • Closed

          Task - A task that needs to be done. MDEV-20784 Testing for MDEV-274 (INET6, data type for IPv6/IPv4 addresses)

          • Major - Major loss of function.
          • Closed

          Activity

            People

              bar Alexander Barkov
              bar Alexander Barkov
              Votes:
              0 Vote for this issue
              Watchers:
              1 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.