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

Wrong result for BETWEEN 0 AND 18446744073709551615

    XMLWordPrintable

Details

    Description

      CREATE OR REPLACE TABLE t1 (
      		 
        c1 bigint(20) unsigned NOT NULL
      		 
      );
      		 
      INSERT INTO t1 VALUES (0),(101),(255);
      		 
      SELECT * FROM t1 WHERE c1 BETWEEN 0 AND 18446744073709551615 ORDER BY c1;


      Empty set (0.00 sec)

      Looks wrong. The expected result is to return all 3 records.

      Attachments

        Issue Links

          causes

          Bug - A problem which impairs or prevents the functions of the product. MDEV-17747 engines/iuds.update_delete_number and engines/iuds.insert_number fail in buildbot with wrong result

          • Major - Major loss of function.
          • Closed
          duplicates

          Bug - A problem which impairs or prevents the functions of the product. MDEV-17698 MEMORY engine performance regression

          • Major - Major loss of function.
          • 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:

                Git Integration

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