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

Subquery using the ALL keyword on INET6 columns produces a wrong result

    XMLWordPrintable

    Details

      Description

      The problem reported in MDEV-27098 for TIME is repeatable with the INET6 data type.

      DROP TABLE IF EXISTS t1;
      		 
      CREATE TABLE t1 (d INET6);
      		 
      INSERT INTO t1 VALUES ('1::0'), ('12::0');
      		 
      SELECT * FROM t1 WHERE d >= ALL (SELECT * FROM t1);


      +------+
      		 
      | d    |
      		 
      +------+
      		 
      | 1::  |
      		 
      | 12:: |
      		 
      +------+

      The expected result should contain only one with with the maximum value '12::'.

        Attachments

          Issue Links

          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-27100 Subquery using the ALL keyword on UUID columns produces a wrong result

          • Major - Major loss of function.
          • Open

          Bug - A problem which impairs or prevents the functions of the product. MDEV-27101 Subquery using the ALL keyword on TIMESTAMP columns produces a wrong result

          • Major - Major loss of function.
          • Open

          Bug - A problem which impairs or prevents the functions of the product. MDEV-27098 Subquery using the ALL keyword on TIME columns produces a wrong result

          • Major - Major loss of function.
          • Closed

            Activity

              People

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