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

Wrong result of: WHERE inet6_column IN ('','::1')

    XMLWordPrintable

Details

    Description

      This script erroneously treats '' as a correct INET6 value of '::' and returns one row:

      CREATE OR REPLACE TABLE t1 (a INET6);
      		 
      INSERT INTO t1 VALUES ('::');
      		 
      SELECT * FROM t1 WHERE a IN ('','::1');


      +------+
      		 
      | a    |
      		 
      +------+
      		 
      | ::   |
      		 
      +------+
      		 
      1 row in set, 1 warning (0.000 sec)

      The comparison operator works as expected on the contrary:

      SELECT * FROM t1 WHERE a='';


      Empty set, 2 warnings (0.001 sec)

      Attachments

        Issue Links

          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-27207 Assertion `!m_null_value' failed in int FixedBinTypeBundle<FbtImpl>::cmp_item_fbt::compare or in cmp_item_inet6::compare

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Activity

            People

              bar Alexander Barkov
              bar Alexander Barkov
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0d
                  0d
                  Logged:
                  Time Spent - 0.5h
                  0.5h

                  Git Integration

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